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

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

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

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

            $s_id_resp = protecao($_POST[id_resp],'inteiro');
            $s_dt_regs = protecao($_POST[dt_regs],'data');
            $s_vl_debt = protecao($_POST[vl_debt]);
            $s_vl_sald = protecao($_POST[vl_sald]);
            $s_de_finl = protecao($_POST[de_finl]);
            $s_nu_pipt = protecao($_POST[nu_pipt]);
            $s_nu_pip2 = protecao($_POST[nu_pip2]);
            $s_nu_balc = protecao($_POST[nu_balc]);
            
            $s_vl_debt = str_replace('.','',$s_vl_debt);
            $s_vl_debt = str_replace(',','.',$s_vl_debt);

            $s_vl_sald = str_replace('.','',$s_vl_sald);
            $s_vl_sald = str_replace(',','.',$s_vl_sald);

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

            $sql  = "INSERT INTO ".$pref_tabl."almx_regs ";
            $sql .= "(id_resp, dt_regs, vl_debt, vl_sald, de_finl, nu_pipt, nu_pip2, nu_balc, dt_cads, id_cads) ";
            $sql .= "VALUES ('$s_id_resp', '$dt_regs', '$s_vl_debt', '$s_vl_sald', '$s_de_finl', '$s_nu_pipt', '$s_nu_pip2', '$s_nu_balc', '$dt_atua', $linhau[id_user]) ";
            #echo $sql;
            $res  = mysqli_query($conn, $sql);
            
            if ($res) {
                $onde = "index1.php?pg=ins_almx_regs&certo=S";
            } else
                $onde = "index1.php?pg=ins_almx_regs&certo=N";

        break;

        case "alt":

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

            $s_id_resp = protecao($_POST[id_resp],'inteiro');
            $s_dt_regs = protecao($_POST[dt_regs],'data');
            $s_vl_debt = protecao($_POST[vl_debt]);
            $s_vl_sald = protecao($_POST[vl_sald]);
            $s_de_finl = protecao($_POST[de_finl]);
            $s_nu_pipt = protecao($_POST[nu_pipt]);
            $s_nu_pip2 = protecao($_POST[nu_pip2]);
            $s_nu_balc = protecao($_POST[nu_balc]);
            $s_id_regs = protecao($_POST[id_regs],'inteiro');
            
            $s_vl_debt = str_replace('.','',$s_vl_debt);
            $s_vl_debt = str_replace(',','.',$s_vl_debt);

            $s_vl_sald = str_replace('.','',$s_vl_sald);
            $s_vl_sald = str_replace(',','.',$s_vl_sald);

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

            $sql  = "UPDATE ".$pref_tabl."almx_regs ";
            $sql .= "SET id_resp = '$s_id_resp', ";
            $sql .= "dt_regs = '$dt_regs', ";
            $sql .= "vl_debt = '$s_vl_debt', ";
            $sql .= "vl_sald = '$s_vl_sald', ";
            $sql .= "de_finl = '$s_de_finl', ";
            $sql .= "nu_pipt = '$s_nu_pipt', ";
            $sql .= "nu_pip2 = '$s_nu_pip2', ";
            $sql .= "nu_balc = '$s_nu_balc', ";
            $sql .= "id_altr = '$linhau[id_user]', ";
            $sql .= "dt_altr = '$dt_atua' ";
            $sql .= "WHERE id_regs = $s_id_regs ";
            $sql .= "LIMIT 1";
            #echo $sql.'<br>';
            $res  = mysqli_query($conn, $sql);

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

        break;

    }
?>
<form name="retorna" method="post" action="">
    <input type="hidden" name="id_regs" id="id_regs" value="<?=$_POST[id_regs]?>">
    <input type="hidden" name="v_id_resp" id="v_id_resp" value="<?=$_POST[v_id_resp]?>">
    <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>";
?>