1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| if ($_GET["act"]='delPlanif') {
$planDate = substr($_GET["addsupDate"],0,4) . "-" . substr($_GET["addsupDate"],4,2) . "-" . substr($_GET["addsupDate"],6,2);
$link = pg_connect($conn_string)
or die("Connexion Impossible! ");
$req = "SELECT id FROM T_p ";
$req .= "WHERE plan_seq =" . $_GET["addsupPlanSeq"] . " AND id_org = '" . $_GET["addsupIdOrg"] . "' ";
$result = pg_query($link,$req);
$line = pg_fetch_array($result);
$id_trait_org = $line[0];
$sql = "UPDATE T_p ";
$sql .= "SET plan_status = 5, plan_histo = '' ";
$sql .= "WHERE id_trait_org=" . $id_trait_org .";";
$res = pg_query($link,$sql);
$sql2 = "SELECT trait_nom, plan_ord_day, trait_lib, freq_type ";
$sql2 .= "FROM T_traitements, T_trait_org, T_planif ";
$sql2 .= "WHERE T_traitements.id_trait = T_trait_org.id_trait ";
$sql2 .= "AND T_planif.id_trait_org = T_trait_org.id_trait_org ";
$sql2 .= "AND T_planif.plan_seq = " . $_GET["addsupPlanSeq"] . "; ";
$nomPos = pg_fetch_array(pg_query($link,$sql2));
$sql3 = "UPDATE T_planif ";
$sql3 .= "SET plan_ord_day = plan_ord_day - 1 ";
$sql3 .= "WHERE id_trait_org=" . $id_trait_org . " ";
$sql3 .= "AND plan_ord_day > '" . $nomPos['plan_ord_day'] . "'; ";
$res3 = pg_query($link,$sql3);
echo $nomPos["trait_nom"] . "|" . $nomPos["trait_lib"] . "|" . $nomPos["freq_type"];
pg_close();
} |
Partager