File Manager

Editing File: /home/cienp/public_html/portal/sql_almx_solc.php

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

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

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

$s_id_solc = protecao($_POST[id_solc],'inteiro');
            $s_id_prdt = protecao($_POST[id_prdt],'inteiro');
            $s_nu_qtde = protecao($_POST[nu_qtde],'decimal');
            settype($s_id_solc, 'integer');

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

if ($s_id_solc == 0) {
                $sqls  = "INSERT INTO ".$pref_tabl."almx_solc ";
                $sqls .= "(dt_cads, id_cads) ";
                $sqls .= "VALUES ('$dt_atua', $linhau[id_user]) ";
                #echo $sqls;
                $ress  = mysqli_query($conn, $sqls);

$sqlj  = "SELECT MAX(id_solc) as id_solc ";
                $sqlj .= "FROM ".$pref_tabl."almx_solc ";
                $sqlj .= "LIMIT 1";
                #echo $sqlj."<br>";
                $resj  = mysqli_query($conn, $sqlj);
                if (mysqli_num_rows($resj) > 0) {
                    $linhaj = mysqli_fetch_array($resj);

$s_id_solc = $linhaj[id_solc];
                }
            }

if ($s_id_solc > 0) {

$sqlfo  = "SELECT id_item ";
                $sqlfo .= "FROM ".$pref_tabl."almx_item ";
                $sqlfo .= "WHERE id_solc = '$s_id_solc' ";
                $sqlfo .= "AND id_prdt = '$s_id_prdt' ";
                $sqlfo .= "LIMIT 1 ";
                $resfo  = mysqli_query($conn, $sqlfo);
                if (mysqli_num_rows($resfo) == 0) {

$sql  = "INSERT INTO ".$pref_tabl."almx_item ";
                    $sql .= "(id_prdt, id_solc, nu_qtde, dt_cads, id_cads) ";
                    $sql .= "VALUES ('$s_id_prdt', '$s_id_solc', ";
                    $sql .= "'$s_nu_qtde', '$dt_atua', $linhau[id_user]) ";
                    #echo $sql;
                    $res  = mysqli_query($conn, $sql);
                    
                    if ($res) {
                        $onde = "index1.php?pg=ins_almx_solc&certo=S";
                    } else {
                        $onde = "index1.php?pg=ins_almx_solc&certo=N";
                    }
                } else {
                    $onde = "index1.php?pg=ins_almx_solc&certo=J";
                }
            } else {
                $onde = "index1.php?pg=ins_almx_solc&certo=N";
            }
            break;

case "exc":

require "$this->include_dir/conecta.php";
    
            $s_id_solc = protecao($_POST[id_solc],'inteiro');
            $s_id_item = protecao($_POST[id_item],'inteiro');
            
            if ($s_id_item > 0) {

$sql  = "DELETE FROM ".$pref_tabl."almx_item ";
                $sql .= "WHERE id_item = '$s_id_item' ";
                $sql .= "LIMIT 1";
                $res  = mysqli_query($conn, $sql);
                if ($res) {
                    $onde = "index1.php?pg=ins_almx_solc&certo=X";
                } else {
                    $onde = "index1.php?pg=ins_almx_solc&certo=N";
                } 
            } else {
                $onde = "index1.php?pg=ins_almx_solc&certo=N";
            }
            break;

case "conc":

require "$this->include_dir/conecta.php";
    
            $s_id_solc = protecao($_POST[id_solc],'inteiro');
            
            if ($s_id_solc > 0) {

$sql  = "UPDATE ".$pref_tabl."almx_solc ";
                $sql .= "SET fl_sitc = 'A' ";
                $sql .= "WHERE id_solc = '$s_id_solc' ";
                $sql .= "LIMIT 1";
                $res  = mysqli_query($conn, $sql);
                if ($res) {
                    $onde = "index1.php?pg=ins_almx_solc&certo=A";
                    $s_id_solc = '';
                } else {
                    $onde = "index1.php?pg=ins_almx_solc&certo=N";
                } 
            } else {
                $onde = "index1.php?pg=ins_almx_solc&certo=N";
            }
            break;

case "entg_solc":

require "$this->include_dir/conecta.php";
    
            $s_id_solc = protecao($_POST[id_solc],'inteiro');
            
            if ($s_id_solc > 0) {

$sqlit  = "SELECT i.* ";
                $sqlit .= "FROM ".$pref_tabl."almx_item i ";
                $sqlit .= "WHERE i.id_solc = '$s_id_solc' ";
                $sqlit .= "ORDER BY i.id_item ";
                #echo $sqlit.'<br>';
                $resit  = mysqli_query($conn, $sqlit);
                if (mysqli_num_rows($resit) > 0) {
                    while ($linhait = mysqli_fetch_array($resit)) {
                        $sqles  = "SELECT nu_estq ";
                        $sqles .= "FROM ".$pref_tabl."almx_prdt p ";
                        $sqles .= "WHERE p.id_prdt = '$linhait[id_prdt]' ";
                        $sqles .= "LIMIT 1 ";
                        #echo $sqles.'<br>';
                        $reses  = mysqli_query($conn, $sqles);
                        if (mysqli_num_rows($reses) > 0) {
                            $linhaes = mysqli_fetch_array($reses);

if ($linhaes[nu_estq] >= $linhait[nu_qtde]) {
                                $nu_entg = $linhait[nu_qtde];
                            } else {
                                $nu_entg = $linhaes[nu_estq];
                            }

if ($nu_entg > 0) {

$sql  = "INSERT INTO ".$pref_tabl."almx_said ";
                                $sql .= "(id_prdt, id_entg, nu_qtde, id_resp, dt_solc, dt_entg, dt_cads, id_cads) ";
                                $sql .= "VALUES ('$linhait[id_prdt]', '1', '$nu_entg', '1', '$linhait[dt_cads]', '$dt_atua', '$dt_atua', $linhau[id_user]) ";
                                #echo $sql;
                                $res  = mysqli_query($conn, $sql);
                                
                                if ($res) {
            
                                    $nu_estq = $linhaes[nu_estq] - $nu_entg;
            
                                    // faz o update no estoque
                                    $sqlee  = "UPDATE ".$pref_tabl."almx_prdt ";
                                    $sqlee .= "SET nu_estq = '$nu_estq' ";
                                    $sqlee .= "WHERE id_prdt = '$linhait[id_prdt]' ";
                                    $sqlee .= "LIMIT 1";
                                    $resee  = mysqli_query($conn, $sqlee);
                                    if (!$resee) {
                                        $onde = "index1.php?pg=alt_almx_solc&certo=A";
                                    }

// faz o update no item
                                    $sqlii  = "UPDATE ".$pref_tabl."almx_item ";
                                    $sqlii .= "SET nu_entg = '$nu_entg' ";
                                    $sqlii .= "WHERE id_item = '$linhait[id_item]' ";
                                    $sqlii .= "LIMIT 1";
                                    $resii  = mysqli_query($conn, $sqlii);
                                    if (!$resii) {
                                        $onde = "index1.php?pg=alt_almx_solc&certo=A";
                                    }
                                }
                            } else {
                                // faz o update no item zerado
                                $sqlii  = "UPDATE ".$pref_tabl."almx_item ";
                                $sqlii .= "SET nu_entg = '0' ";
                                $sqlii .= "WHERE id_item = '$linhait[id_item]' ";
                                $sqlii .= "LIMIT 1";
                                $resii  = mysqli_query($conn, $sqlii);
                                if (!$resii) {
                                    $onde = "index1.php?pg=alt_almx_solc&certo=A";
                                }
                            }

}

}
                    $sql  = "UPDATE ".$pref_tabl."almx_solc ";
                    $sql .= "SET fl_sitc = 'E', ";
                    $sql .= "id_entg = '$linhau[id_user]', ";
                    $sql .= "dt_entg = '$dt_atua' ";
                    $sql .= "WHERE id_solc = '$s_id_solc' ";
                    $sql .= "LIMIT 1";
                    $res  = mysqli_query($conn, $sql);
                    if ($res) {
                        $onde = "index1.php?pg=alt_almx_solc&certo=E";
                    } else {
                        $onde = "index1.php?pg=alt_almx_solc&certo=N";
                    } 
                }

} else {
                $onde = "index1.php?pg=alt_almx_solc&certo=N";
            }
            break;
            
        
    }
?>
<form name="retorna" method="post" action="">
    <input type="hidden" name="id_solc" id="id_solc" value="<?=$s_id_solc?>">
    <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>";
?>

Back to Directory File Manager