<?php
  $page_title = 'CONFIGURACION';
  require_once('../../includes/load.php');
?>
<?php
// Checkin What level user has permission to view this page
 page_require_level(1);

//Consulta de la base de datos para obterner el ultimo registro del as
 $consulta = $db->query("SELECT * FROM tb_configuracion_as ORDER BY id DESC LIMIT 1");
 $as = $db->fetch_array($consulta);
?>
<?php
  if(isset($_POST['accesorios'])){
   if(empty($errors)){
      $botiquin   = remove_junk($db->escape($_POST['botiquin']));
      $extintor   = remove_junk($db->escape($_POST['extintor']));
      $gata   = remove_junk($db->escape($_POST['gata']));
      $triangulo = remove_junk($db->escape($_POST['triangulo']));
      $cono = remove_junk($db->escape($_POST['cono']));
      $cable_corriente = remove_junk($db->escape($_POST['corriente']));
      $cable_remolque = remove_junk($db->escape($_POST['remolque']));
      $anio = remove_junk($db->escape($_POST['anio']));
      $mes = remove_junk($db->escape($_POST['mes']));
      $total = $botiquin/12 + $extintor/12 + $gata/60 + $triangulo/60 + $cono/60 + $cable_corriente/60 + $cable_remolque/60;
      $created_at=date("Y-m-d H:i:s");

      
      $query = "INSERT INTO tb_configuracion_as (";
      $query .="botiquin, extintor, gata, triangulo, cono, cable_corriente, cable_remolque, total, anio, mes, created_at";
      $query .=") VALUES (";
      $query .=" '{$botiquin}', '{$extintor}', '{$gata}', '{$triangulo}', '{$cono}', '{$cable_corriente}', '{$cable_remolque}', '{$total}', '{$anio}', '{$mes}', '{$created_at}'";
      $query .=")";
      if($db->query($query)){
        //sucess
        $session->msg('s'," La Configuración de ACCESORIOS ha sido Actualizada");
        redirect('accesorios.php', false);
      } else {
        //failed
        $session->msg('d',' No se pudo Actualizar Configuración de ACCESORIOS');
        redirect('accesorios.php', false);
      }
   }else {
   $session->msg("d", $errors);
    redirect('accesorios.php',false);
 }
}
?>
<?php include_once('../../layouts/header.php'); ?>
<div class="col-md-12">
   <?php echo display_msg($msg); ?>
</div>
<form method="post" action="accesorios.php">
    <div class="col-12 px-4 pt-3">
          <div class="row d-flex justify-content-center">
            <div class="col-6">
              <div class="card">
                <div class="card-header">
                  <h5 class="card-title mb-0">CONFIGURACIÓN ACCESORIOS DE SEGURIDAD</h5>
                </div>
                <div class="card-body">
                  <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="anio" class="col-sm-6 col-form-label text-primary">AÑO</label>
                        <div class="col-sm-6">
                          <select class="custom-select-confi is-requerido" id="anio" name="anio">
                            <option value="" disabled>Seleccione...</option>      
                            <?php
                                $year = date("Y");
                                for ($i=2022; $i<=$year; $i++) {
                                    $selected = ($as['anio'] == $i) ? 'selected' : ''; // Verifica si este mes debe ser seleccionado
                                    echo '<option ' . $selected . ' value="' . $i . '">'.$i.'</option>';
                                }
                            ?>            
                        </select>
                        </div>
                      </div>
                    </div>
                   </div>
                   <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="mes" class="col-sm-6 col-form-label text-primary">MES</label>
                        <div class="col-sm-6">
                          <select class="custom-select-confi is-requerido" id="mes" name="mes">
                          <option value="" disabled>Seleccione...</option>      
                          <?php
                            for ($i = 1; $i <= 12; $i++) {
                                $value = ($i < 10) ? '0' . $i : $i;
                                switch ($value) {
                                   case '1': $mes = 'Enero';break;
                                   case '2': $mes = 'Febrero';break;
                                   case '3': $mes = 'Marzo';break;
                                   case '4': $mes = 'Abril';break;
                                   case '5': $mes = 'Mayo';break;
                                   case '6': $mes = 'Junio';break;
                                   case '7': $mes = 'Julio';break;
                                   case '8': $mes = 'Agosto';break;
                                   case '9': $mes = 'Septiembre';break;
                                   case '10': $mes = 'Octubre';break;
                                   case '11': $mes = 'Noviembre';break;
                                   case '12': $mes = 'Diciembre';break;
                                   default: $mes = 'Non'; break;
                                }
                                $selected = ($as['mes'] == $i) ? 'selected' : ''; // Verifica si este mes debe ser seleccionado
                                echo '<option ' . $selected . ' value="' . $i . '">' . $mes . '</option>';
                            }
                            ?>                    
                        </select>
                        </div>
                      </div>
                    </div>
                   </div>
                  <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="botiquin" class="col-sm-6 col-form-label text-primary">BOTIQUIN</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="botiquin" name="botiquin" placeholder="number" step="any" value="<?php echo  (double)$as['botiquin'];?>">
                        </div>
                      </div>
                    </div>
                   </div>
                   <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="extintor" class="col-sm-6 col-form-label text-primary">EXTINTOR</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="extintor" name="extintor" placeholder="number" step="any" value="<?php echo  (double)$as['extintor'];?>">
                        </div>
                      </div>
                    </div>
                   </div>
                   <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="gata" class="col-sm-6 col-form-label text-primary">GATA</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="gata" name="gata" placeholder="number" step="any" value="<?php echo  (double)$as['gata'];?>">
                        </div>
                      </div>
                    </div>
                   </div>
                   <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="triangulo" class="col-sm-6 col-form-label text-primary">TRIANGULO</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="triangulo" name="triangulo" placeholder="number" step="any" value="<?php echo  (double)$as['triangulo'];?>">
                        </div>
                      </div>
                    </div>
                   </div>
                   <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="cono" class="col-sm-6 col-form-label text-primary">CONO</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="cono" name="cono" placeholder="number" step="any" value="<?php echo  (double)$as['cono'];?>">
                        </div>
                      </div>
                    </div>
                   </div>
                
                <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="corriente" class="col-sm-6 col-form-label text-primary">CABLE CORRIENTE 400A </label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="corriente" name="corriente" placeholder="number" step="any" value="<?php echo  (double)$as['cable_corriente'];?>">
                        </div>
                      </div>
                    </div>
                   </div>
                
                <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="remolque" class="col-sm-6 col-form-label text-primary">CABLE REMOLQUE</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="remolque" name="remolque" placeholder="number" step="any" value="<?php echo  (double)$as['cable_remolque'];?>">
                        </div>
                      </div>
                    </div>
                   
                </div>
                <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        <label for="total" class="col-sm-6 col-form-label text-primary">TOTAL</label>
                        <div class="col-sm-6">
                          <input type="number" class="form-control" id="total" name="total" placeholder="number" step="any" value="<?php echo  (double)$as['total'];?>" disabled>
                        </div>
                      </div>
                    </div>
                   
                </div>
                <div class="row mb-3"> 
                    <div class="col-12 col-lg-12">
                      <div class="form-group row">
                        
                        <div class="col-sm-12">
                            <button type="submit" class="btn btn-block btn-success" name="accesorios" id="accesorios">Actualizar</button>
                        </div>
                      </div>
                    </div>
                   
                </div>         
            </div>
        </div>
      </div>
     </div>
    </div>
  </form>
<?php include_once('../../layouts/footer.php'); ?>
<script type="text/javascript" src="js/configuracion_as.js"></script>