<?php require ("./Connections/medoo.php");?>
<?php 
/* sistema de padron inspectores index.php */
$querytxt="SELECT * FROM dependencias";
$datas = $database->query($querytxt)->fetchAll();
//print_r($datas);
$cuantos = sizeof($datas);

?>
<?php 
$querytxtmpios="  SELECT fid_municipio,NOM_MUN, COUNT(*) FROM inspectores

full JOIN municipios32 ON (id_mpio=fid_municipio)
WHERE CVE_ENT=16 AND vnotas=3 AND CVE_MUN<=113
GROUP BY fid_municipio,NOM_MUN ";
$datas_mpios = $database->query($querytxtmpios)->fetchAll();
$cuantos_mpios = sizeof($datas_mpios);
//----------------------------
$querytxtedos="   SELECT fid_dependencias,dependencias.nombre AS ndependencia, COUNT(*)
FROM inspectores
full JOIN municipios32 ON (id_mpio=fid_municipio)
LEFT JOIN dependencias ON (id_dependencia=fid_dependencias)
WHERE CVE_ENT=16 AND CVE_MUN=114
GROUP BY fid_dependencias,dependencias.nombre
ORDER BY ndependencia";
//echo $querytxtedos;
$datas_edo = $database->query($querytxtedos)->fetchAll();
$cuantos_edo = sizeof($datas_edo);
?>
<!doctype html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="megakit,business,company,agency,multipurpose,modern,bootstrap4">

    <meta name="author" content="themefisher.com">

    <title>Padron</title>

    <!-- bootstrap.min css -->
    <link rel="stylesheet" href="./tema/plugins/bootstrap/css/bootstrap.min.css">
    <!-- Icon Font Css -->
    <link rel="stylesheet" href="./tema/plugins/themify/css/themify-icons.css">
    <link rel="stylesheet" href="./tema/plugins/fontawesome/css/all.css">
    <link rel="stylesheet" href="./tema/plugins/magnific-popup/dist/magnific-popup.css">
    <!-- Owl Carousel CSS -->

    <!-- Main Stylesheet -->
    <link href="css/galano.css" rel="stylesheet" />
    <link rel="stylesheet" href="./tema/css/style.css">

</head>

<body>


    <!-- Header Start -->

    <header class="navigation">

        <nav class="navbar navbar-expand-lg  py-4 fixed-top" id="navbar">
            <div class="container">
                <a class="navbar-brand" href="#">
                    <!-- <img src="./tablas/imagenes/baner_fondo_negro.svg" alt="Logo" width="600" height="55">-->
                    <img src="../mich-veda.png" class="img-fluid" alt="Logo" width="143" height="35">
                </a>

                <button class="navbar-toggler collapsed" type="button" data-toggle="collapse"
                    data-target="#navbarsExample09" aria-controls="navbarsExample09" aria-expanded="false"
                    aria-label="Toggle navigation">
                    <span class="fa fa-bars"></span>
                </button>

                <div class="collapse navbar-collapse text-center" id="navbarsExample09">
                    <ul class="navbar-nav ml-auto">
                        <li class="nav-item active">
                            <a class="nav-link" href="#">Inicio <span class="sr-only">(current)</span></a>
                        </li>
                        <li class="nav-item dropdown">
                            <a class="nav-link dropdown-toggle" href="#" id="dropdown03" data-toggle="dropdown"
                                aria-haspopup="true" aria-expanded="false">Sitios de interés</a>
                            <ul class="dropdown-menu" aria-labelledby="dropdown03">
                                <li><a class="dropdown-item" href="http://mejoraregulatoria.michoacan.gob.mx">Mejora
                                        Regulatoria</a></li>
                                <li><a class="dropdown-item" href="http://sedeco.michoacan.gob.mx/">SEDECO</a></li>
                                <li><a class="dropdown-item" href="https://tramites.michoacan.gob.mx/">Tramites</a></li>
                            </ul>
                        </li>

                       
                    </ul>

                    <form class="form-lg-inline my-2 my-md-0 ml-lg-4 text-center">
                        <a href="./seg/ingreso.php" class="btn btn-solid-border btn-round-full">Iniciar
                            Sesión</a>
                    </form>
                </div>
            </div>
        </nav>
    </header>

    <!-- Header Close -->
    <!-- Section Cta Start -->
    <section class="section cta">
        <div class="container">
            <div class="row">
                <div class="col-lg-4">
                    <div class="cta-item  bg-white p-5 rounded">
                        <span class="h6 text-color">Mejora Regulatoria</span>
                        <h2 class="mt-2 mb-4">Padrón de Inspectores, Verificadores y Visitadores Domiciliarios</h2>
                        <p class="lead mb-4">El Padrón contendrá la lista de los servidores públicos autorizados para
                            realizar inspecciones, verificaciones y visitas domiciliarias en el ámbito administrativo.
                            .</p>
                        <h3><i class="ti-mobile mr-3 text-color"></i>070</h3>
                    </div>
                </div>



                <div class="col-lg-7">

				<div class="row justify-content-center">
                    <div class="col-lg-7 text-center">
                        <div class="section-title">
                            <span class="h2 text-color">Consultar</span>

                        </div>
                    </div>
                </div>

                    <div class="cta-item  bg-white p-5 rounded">
					<div class="col-lg-4 col-md-6 col-sm-6">
                        <div class="service-item mb-5">
                            <i class="ti-desktop"></i>
                            <h4 class="mb-3">Estatales</h4>
                            <p>
                            <form action="./tablas/Linspectores.php" method="post">

                                <div style="width:250px;">
                                    <select name="dependencia" id="dependencia" class="form-control" style="font-size:14px;">
                                        <option value="0" selected="selected">Selecciona una dependencia</option>
                                        <?php
  						foreach($datas_edo as $row_edo){
 							 echo '<option value="'.$row_edo[0].'">'.$row_edo[1].'('.$row_edo[2].')</option>';
  						}
  
 						 ?>
                                    </select>
                                </div>
                                <input type="hidden" name="lista" value="edo">
                                <input class="btn btn-primary btn-xl js-scroll-trigger" type="submit"
                                    value="Seleccionar">
                            </form>



                            </p>
                        </div>
                    </div>
                    <!--	</div>
			<div class="row justify-content-center"> -->
                    <div class="col-lg-4 col-md-6 col-sm-6">
                        <div class="service-item mb-5">
                            <i class="ti-layers"></i>
                            <h4 class="mb-3">Municipales</h4>
                            <p>
                            <form action="./tablas/Linspectores.php" method="post">

                                <div style="width:250px">
                                    <select name="dependencia" id="dependencia" class="form-control">
                                        <option value="0" "selected=selected">Selecciona un municipio</option>
                                        <?php
               			 foreach($datas_mpios as $row_mpios){
               			  echo '<option value="'.$row_mpios[0].'">'.$row_mpios[1].'('.$row_mpios[2].')</option>';
                		 }
  
  						?>
                                    </select>

                                </div>
                                <input type="hidden" name="lista" value="mpio">
                                <input class="btn btn-primary" type="submit" value="Seleccionar">
                            </form>
                            </p>
                        </div>
                    </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--  Section Cta End-->




    <div class="main-wrapper ">



        <!--  Section Services Start -->

        <!--  Section Services End -->

        <!-- Slider Start 
        <section class="slider">
            <div class="container">
                <div class="row">
                    <div class="col-lg-9 col-md-10">
                        <div class="block">
                            <span class="d-block mb-3 text-white text-capitalize">Preparándonos para el futuro</span>
                            <h1 class="animated fadeInUp mb-5">Mejora regulatoria, <br>oportunidad para encarar crisis
                                económica por COVID-19.</h1>
                            
                        </div>
                    </div>
                </div>
            </div>
        </section>

        -->


    </div>

    <!-- 
    Essential Scripts
    =====================================-->


    <!-- Main jQuery -->
    <script src="./tema/plugins/jquery/jquery.js"></script>
    <script src="./tema/js/contact.js"></script>
    <!-- Bootstrap 4.3.1 -->
    <script src="./tema/plugins/bootstrap/js/popper.js"></script>
    <script src="./tema/plugins/bootstrap/js/bootstrap.min.js"></script>
    <!--  Magnific Popup-->
    <script src="./tema/plugins/magnific-popup/dist/jquery.magnific-popup.min.js"></script>
    <!-- Slick Slider -->
    <script src="./tema/plugins/slick-carousel/slick/slick.min.js"></script>
    <!-- Counterup -->
    <script src="./tema/plugins/counterup/jquery.waypoints.min.js"></script>
    <script src="./tema/plugins/counterup/jquery.counterup.min.js"></script>

    <!-- Google Map -->


    <script src="./tema/js/script.js"></script>

</body>

</html>