<?php
    if(isset($_POST['submit_form'])) {
        $publicidad = Statics::SafeInput($con, $_POST['1']);
        $reacondicionado = Statics::SafeInput($con, $_POST['2']);
        $comercializacion = Statics::SafeInput($con, $_POST['3']);
        $saneamiento = Statics::SafeInput($con, $_POST['4']);
        $depreciacion = Statics::SafeInput($con, $_POST['5']);

        $Schema->executeQuery('UPDATE VEHICULOS_LITERALES SET EXTRA2 = ? WHERE TIPO = ? AND CODIGO = ?', 'dsi', [$publicidad, 'VEH_GAS', 1]);
        $Schema->executeQuery('UPDATE VEHICULOS_LITERALES SET EXTRA2 = ? WHERE TIPO = ? AND CODIGO = ?', 'dsi', [$reacondicionado, 'VEH_GAS', 2]);
        $Schema->executeQuery('UPDATE VEHICULOS_LITERALES SET EXTRA2 = ? WHERE TIPO = ? AND CODIGO = ?', 'dsi', [$comercializacion, 'VEH_GAS', 3]);
        $Schema->executeQuery('UPDATE VEHICULOS_LITERALES SET EXTRA2 = ? WHERE TIPO = ? AND CODIGO = ?', 'dsi', [$saneamiento, 'VEH_GAS', 4]);
        $Schema->executeQuery('UPDATE VEHICULOS_LITERALES SET EXTRA2 = ? WHERE TIPO = ? AND CODIGO = ?', 'dsi', [$depreciacion, 'VEH_GAS', 5]);

        $is_valid = 'is-valid';
    } else {
        $is_valid = FALSE;
    }
    if($Permisos->permisosACC(29, $_SESSION['GRUPO'])) {
?>

<form method="post" action="" class="mt-3 pb-5">
    
    <?php
        $html = '<div class="row">';
        $res = $Schema->executeQuery("SELECT CODIGO, DESCRIPCION_$lg AS DESCRIPCION, EXTRA2  FROM VEHICULOS_LITERALES WHERE TIPO = ?", 's', ['VEH_GAS']);
        if($res->num_rows) {
            while($row = $res->fetch_array()) {
                $html .= '<div class="col-12 col-sm-6 col-md-4 mb-3">';
                    $html .= '<label for="' . $row['CODIGO'] . '">' . ucfirst(mb_strtolower($row['DESCRIPCION'], 'UTF-8')) . '</label>';
                    $html .= '<input type="number" name="' . $row['CODIGO'] . '" value="' . $row['EXTRA2'] . '" step="any" class="form-control ' . $is_valid . '" placeholder="' . ucfirst(mb_strtolower($row['DESCRIPCION'], 'UTF-8')) . '">';
                $html .= '</div>';
            }
        } 
        $html .= '</div>';

        $html .= '<button class="btn btn-primary" name="submit_form" type="submit">' . $actualizar_lg . '</button>';

        echo $html;
    
    ?>
        
    
</form>

<?php
    } else {
        echo '<h4 class="text-center mt-4"><i class="fas fa-lock mr-2 ml-n5"></i>' . $sin_permisos_lg . '</h4>';
    }