<?php 
include_once('../../../php/sessionStart.php');
include_once('../../../php/db/dbExec.php');

$empCod = $_SESSION['empCod'];
$empNom = $_SESSION['empNom'];
$empNit = $_SESSION['empNit'];

# QUERYS
$sDeptosi = "SELECT *, TRIM(dep_cod) AS dep_codc FROM deptosi";
$sSubdeptosi = "SELECT *, TRIM(sdep_cod) AS sdep_codc FROM subdeptosi";
$sBodegas = "SELECT * FROM bodegas where bod_emp='$empCod' ORDER BY bod_cod";
# EJECUCION DE QUERYS
$db = new dbExec();
$select["deptosi"] = $db->query($sDeptosi);
$select["subdeptosi"] = $db->query($sSubdeptosi);
$select["bodegas"] = $db->query($sBodegas);
?>
<?php include_once('../includes/htmlOpen.php'); ?>
    <main class="main" style="">
      <?php 
        $li[0] = '<i class="fas fa-file-excel"></i>';
        $li[1] = $_GET["opcNom"];
        include_once('../../../php/includes/ol.php');

        $modalImp = "modalImp";
        include_once('../../../php/includes/modalImp.php');
      ?>
      <div class="container-as">
        <div class="row">
          <div class="col">
            <ul class="nav nav-pills mb-1" id="pills-tab" role="tablist">
              <li class="nav-item">
                <a class="nav-link active" id="pills-0-tab" data-toggle="pill" href="#pills-0" role="tab" aria-controls="pills-0" aria-selected="true">Reporte Costeado</a>
              </li>
            </ul>
            <div class="tab-content bg-transparent border-0" id="pills-tabContent">
              <div class="tab-pane fade show active" id="pills-0" role="tabpanel" aria-labelledby="pills-0-tab">
                <form action="" name="thisform" autocomplete="off" enctype="multipart/form-data">
                  <div class="form-group">
                    <div class="form-row">
                      <div class="col-sm-6 col-md-3">
                        <label class="font-size-md" for="selDepto">Familia</label>
                        <select class="form-control form-control-md form-control-as" name="selDepto" id="selDepto">
                          <option value="0000">Todas las Familias</option>
                          <?php
                            while ($rec = $db->fetchAssoc($select['deptosi'])) {
                              echo  '<option value="'.$rec['dep_cod'].'" data-codc="'.$rec['dep_codc'].'">'.utf8_encode($rec['dep_nom']).'</option>';

                              //echo  "<option value={$rec['dep_cod']}>".utf8_encode($rec['dep_nom']).'</option>';
                            }
                          ?>
                        </select>
                      </div>
                      <div class="col-sm-6 col-md-3">
                        <label class="font-size-md" for="selSubDepto">Sub-Familia</label>
                        <select class="form-control form-control-md form-control-as" name="selSubDepto" id="selSubDepto">
                          <option value="0000">Todos las Sub-Familias</option>
                          <?php
                            while ($rec = $db->fetchAssoc($select['subdeptosi'])) {
                              echo  '<option value="'.$rec['sdep_cod'].'" data-scodc="'.$rec['sdep_codc'].'">'.utf8_encode($rec['sdep_nom']).'</option>';
                            //  echo  "<option data-dep={$rec['sdep_dep']} value={$rec['sdep_cod']}>".utf8_encode($rec['sdep_nom']).'</option>';
                            }
                          ?>
                        </select>
                      </div>
                    </div>
                    <div class="form-row">
                      <div class="col-6">
                        <label class="font-size-sm" for="selBodega">De que Bodega</label>
                        <select class="form-control form-control-sm form-control-as" name="selBodega" id="selBodega">
                          <option value="0000">Todas las Bodegas</option>
                          <?php
                            while ($rec = $db->fetchAssoc($select['bodegas'])) {
                              echo  '<option value="'.$rec['bod_cod'].'">'.utf8_encode($rec['bod_nom']).'</option>';
                            }
                          ?>
                        </select>
                      </div>
                    </div>
                    <div class="form-row">
                      <div class="col-2">
                        <label for="txtGrupo" class="font-size-md">Grupo Codigo</label>
                        <input type="text" class="form-control form-control-sm form-control-as font-size-md" id="txtGrupo" placeholder="" maxlength="20">
                      </div>
                      <div class="col-1">
                        <label > </label>
                      </div>
                      <div class="col-3">
                        <label for="dtFec" class="font-size-md">A que Fecha</label>
                        <input type="date" class="form-control form-control-sm form-control-as font-size-md" id="dtFec" placeholder="">
                      </div>
                    </div>
                    <div class="form-row">
                      <div class="col-3">
                        <label class="pr-1"></label><br>
                        <div class="custom-control custom-radio custom-control-inline">
                          <input type="radio" id="crTse1" name="crTse" class="custom-control-input" value="T">
                          <label class="custom-control-label" for="crTse1">Todos los Articulos</label>
                        </div>
                        <div class="custom-control custom-radio custom-control-inline">
                          <input type="radio" id="crTse2" name="crTse" class="custom-control-input" value="E">
                          <label class="custom-control-label" for="crTse2">Solo con Existencia</label>
                        </div>
                      </div>

                    </div>
                  </div>

                  <h3 class="text-light"></h3>

                  <div class="form-group">
                    <div class="form-row">
                      <div class="col-md-3">
                        <button class="btn btn-primary btn-lg btn-block" id="btnImprimir" type="button">Imprimir</button>
                      </div>
                      <div class="col-md-3">
                        <button class="btn btn-success btn-lg btn-block" id="btnExcel" type="button">Excel</button>
                      </div>
                    </div>
                  </div>
                </form>

              </div>
            </div>
          </div>
        </div>
      </div>
    </main>
<?php include_once('../../../php/includes/htmlClose.php'); ?>

<script>
  const selDepto = document.thisform.selDepto;
  const selsubDepto = document.thisform.selsubDepto;
  const selBodega = document.thisform.selBodega;
  const dtFec = document.thisform.dtFec;
  const crTse = document.thisform.crTse;
  const txtGrupo = document.thisform.txtGrupo;

  $(document).ready(function() {
    $(this).find('select:visible:first').focus();
    dtFec.value = dateToday();
    selBodega.value="0020";
    crTse.value="E";
    txtGrupo.value="";
    // SUBMIT FORM
    $('form').submit(function() {
      return false;
    });

    // VALID SUBDEPARTAMENTOS CUANDO ABANDONA DEPARTAMENTO
    $("#selDepto")
    .blur(function() {
      var subDepcur = $("#selSubDepto");
      // Limpiamos el select
      subDepcur.find('option').remove();
      const parametros = new FormData();
      parametros.append("action", "consultarSubdep");
      parametros.append("selDepto", $('#selDepto').find('option:selected').data('codc'));

      $.ajax({
        data:  parametros,
        url:   window.location.origin+window.location.pathname+"actions.php",
        type:  "post",
        contentType: false,
        processData: false,
        success: function (jsonPhp) {
          //console.log(jsonPhp);
          const jsonJS = JSON.parse(jsonPhp);

          if(jsonJS.error == true){
            alError(jsonJS);
          } else {
            $cod="0000";
            $scod="0000";
            $nom="Todos las Sub-Familias";
            subDepcur.append('<option value="'+$cod+'"data-scodc="'+$cod+'">'+$nom+'</option>');

            jsonJS.subdeptosi.forEach(function(i){
                $cod=i.sdep_cod;
                $scod=i.sdep_cod;
                $nom=i.sdep_nom;
                subDepcur.append('<option value="'+$cod+'"data-scodc="'+$cod+'">'+$nom+'</option>');
            });
//            if (selDepto.value=='0000'){
//            }
          }
        }
      });
    });

    // CLICK IMPRIMIR
    $("#btnImprimir").click(function (){
      const getselDepto = "?selDepto="+selDepto.value;
      const getselsubDepto = "&selSubDepto="+selSubDepto.value;
      const getselBodega = "&selBodega="+selBodega.value;
      const getBodegaNom = "&BodegaNom="+$("#selBodega option:selected").text();
      const getdtFec = "&dtFec="+dtFec.value;
      const getcrTse = "&crTse="+crTse.value;
      const getGrupo = "&txtGrupo="+txtGrupo.value;
      console.log(selDepto.value," ",selSubDepto.value," ",selBodega.value," ",dtFec);
      var url = window.location.origin+window.location.pathname+"print.php"+getselDepto+getselsubDepto+getselBodega+getBodegaNom+getdtFec+getcrTse+getGrupo;
      window.open(url, '_blank');
      txtGrupo.value="";
    });

    // CLICK EXCEL
    $("#btnExcel").click(function (){
      const getselDepto = "?selDepto="+selDepto.value;
      const getselsubDepto = "&selSubDepto="+selSubDepto.value;
      const getselBodega = "&selBodega="+selBodega.value;
      const getBodegaNom = "&BodegaNom="+$("#selBodega option:selected").text();
      const getdtFec = "&dtFec="+dtFec.value;
      const getcrTse = "&crTse="+crTse.value;
      const getGrupo = "&txtGrupo="+txtGrupo.value;
      var url = window.location.origin+window.location.pathname+"excel.php"+getselDepto+getselsubDepto+getselBodega+getBodegaNom+getdtFec+getcrTse+getGrupo;
      window.location.href = url;
      txtGrupo.value="";
    });
  });

  // FOCUS PILL
  $('a[data-toggle="pill"]').on('shown.bs.tab', function (e) {
    if (!isMobile()) {
      const target = e.target.attributes.href.value;
      if ($(target+' select:visible:first').length) {
        $(target+' select:visible:first').focus();
      } else {
        $(target+' select:visible:first').focus();
      }
    }
  });

</script>