Viewing File: /home/cienp/public_html/portal/sql_patr_mant.php

<?
    $dt_atua = date("Y-m-d");
    echo ".";

    switch ($_POST[opc]){
        case "ins":

            require "$this->include_dir/conecta.php";

            $s_id_patr = protecao($_POST[id_patr],'inteiro');
            $s_dt_mant = protecao($_POST[dt_mant],'data');
            $s_dt_recb = protecao($_POST[dt_recb],'data');
            $s_nu_os   = protecao($_POST[nu_os]);
            $s_de_pres = protecao($_POST[de_pres]);
            $s_de_mant = protecao($_POST[de_mant]);

            if ($s_dt_mant != '') {
                $d1 = explode('/', $s_dt_mant);
                $dt_mant = $d1[2]."-".$d1[1]."-".$d1[0];
            }

            if ($s_dt_recb != '') {
                $d2 = explode('/', $s_dt_recb);
                $dt_recb = $d2[2]."-".$d2[1]."-".$d2[0];
            }

            if ($pass == 0) {
                $sql  = "INSERT INTO ".$pref_tabl."patr_mant ";
                $sql .= "(id_patr, dt_mant, dt_recb, nu_os, de_pres, de_mant, dt_cads, id_cads) ";
                $sql .= "VALUES ('$s_id_patr', '$dt_mant', '$dt_recb', '$s_nu_os', '$s_de_pres', '$s_de_mant', '$dt_atua', $linhau[id_user])";
                #echo $sql;
                $res  = mysqli_query($conn, $sql);
                
                if ($res) {
                    $onde = "index1.php?pg=ins_patr_mant&certo=S";
                } else {
                    $onde = "index1.php?pg=ins_patr_mant&certo=N";
                }
            } else {
                $onde = "index1.php?pg=ins_patr_mant&certo=J";
            }
            break;

        case "alt":

            require "$this->include_dir/conecta.php";


            $s_id_patr = protecao($_POST[id_patr],'inteiro');
            $s_id_forn = protecao($_POST[id_forn],'inteiro');
            $s_dt_mant = protecao($_POST[dt_mant],'data');
            $s_dt_recb = protecao($_POST[dt_recb],'data');
            $s_nu_os   = protecao($_POST[nu_os]);
            $s_de_mant = protecao($_POST[de_mant]);
            $s_id_mant = protecao($_POST[id_mant],'inteiro');

            if ($s_dt_mant != '') {
                $d1 = explode('/', $s_dt_mant);
                $dt_mant = $d1[2]."-".$d1[1]."-".$d1[0];
            }

            if ($s_dt_recb != '') {
                $d2 = explode('/', $s_dt_recb);
                $dt_recb = $d2[2]."-".$d2[1]."-".$d2[0];
            }

            if ($pass == 0) {

                $sql  = "UPDATE ".$pref_tabl."patr_mant ";
                $sql .= "SET id_patr = '$s_id_patr', ";
                $sql .= "id_forn = '$s_id_forn', ";
                $sql .= "dt_mant = '$dt_mant', ";
                $sql .= "dt_recb = '$dt_recb', ";
                $sql .= "nu_os   = '$s_nu_os', ";
                $sql .= "de_mant = '$s_de_mant', ";
                $sql .= "id_altr = '$linhau[id_user]', ";
                $sql .= "dt_altr = '$dt_atua' ";
                $sql .= "WHERE id_mant = '$s_id_mant' ";
                $sql .= "LIMIT 1";
                $res  = mysqli_query($conn, $sql);

                if ($res) {
                    $onde = "index1.php?pg=alt_patr_mant&certo=S";
                } else {
                    $onde = "index1.php?pg=alt_patr_mant&certo=N";
                } 
            } else {
                $onde = "index1.php?pg=alt_patr_mant&certo=J";
            }
            break;

        case "exc_mant":

            $erros = 0;

            require "$this->include_dir/conecta.php";

            $s_id_patr = protecao($_POST[id_patr],'inteiro');
            $s_id_mant = protecao($_POST[id_mant],'inteiro');

            $sqlv  = "DELETE FROM ".$pref_tabl."patr_mant ";
            $sqlv .= "WHERE id_mant = '$s_id_mant' ";
            $sqlv .= "AND id_patr = '$s_id_patr' ";
            $sqlv .= "LIMIT 1";
            $resv  = mysqli_query($conn, $sqlv);
            if ($resv) {
                $onde = "index1.php?pg=alt_patr&certo=XM";
            } else {
                $onde = "index1.php?pg=alt_patr&certo=N";
            }
            break;
    
    }
?>
<form name="retorna" method="post" action="">
    <input type="hidden" name="id_mant" id="id_mant" value="<?=$s_id_mant?>">
    <input type="hidden" name="id_patr" id="id_patr" value="<?=$s_id_patr?>">
    <input type="hidden" name="v_id_patr" id="v_id_patr" value="<?=$_POST[v_id_patr]?>">
    <input type="hidden" name="v_id_marc" id="v_id_marc" value="<?=$_POST[v_id_marc]?>">
    <input type="hidden" name="v_id_forn" id="v_id_forn" value="<?=$_POST[v_id_forn]?>">
    <input type="hidden" name="v_de_equp" id="v_de_equp" value="<?=$_POST[v_de_equp]?>">
    <input type="hidden" name="v_fl_atvo" id="v_fl_atvo" value="<?=$_POST[v_fl_atvo]?>">
    <input name="passa" type="hidden" id="passa" value="yes">
</form>
<?
echo "<SCRIPT LANGUAGE=javascript> \n";
echo "document.retorna.action = '$onde'; \n";
echo "document.retorna.submit(); \n";
echo "</script>";
?>