Viewing 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