MichaelMcDonald
Posts: 640
|
| Posted: 09/16/2010, 6:10 AM |
|
A whole heap of code that appears in one of my forms after insert event. Using PHP 5.
$db = new clsDBFM();
$SQL = "SELECT LAST_INSERT_ID() FROM workorder";
$db->query($SQL);
if ($db->next_record()) {
$last_insert_id = $db->f(0);
CCSetSession("workorderid_1", $last_insert_id);
}
$SQL = "Update workorder SET issuedate= NOW()" . " WHERE idworkorder= "
. $db->ToSQL(CCGetSession("workorderid_1"),ccsInteger);
$db->query($SQL);
$SQL = "SELECT accrual, assetid, contact, domainid, description, duedate, issuedate, levelid, phone,
priorityid, quotenumber, roomid, siteid, supplierid, userid,
updatenotes FROM workorder WHERE idworkorder=" . $db->ToSQL(CCGetSession("workorderid_1"),ccsInteger);
$db->query($SQL);
$Result = $db->next_record();
{
CCSetSession("accrual_1", $db->f("accrual"),ccsFloat);
CCSetSession("assetid_1", $db->f("assetid"),ccsInteger);
CCSetSession("contact_1", $db->f("contact"),ccsText);
CCSetSession("domainid_1", $db->f("domainid"),ccsInteger);
CCSetSession("description_1", $db->f("description"),ccsText);
CCSetSession("duedate_1", $db->f("duedate"),ccsDate);
CCSetSession("issuedate_1", $db->f("issuedate"),ccsDate);
CCSetSession("levelid_1", $db->f("levelid"),ccsInteger);
CCSetSession("phone_1", $db->f("phone"),ccsText);
CCSetSession("priorityid_1", $db->f("priorityid"),ccsInteger);
CCSetSession("quotenumber_1", $db->f("quotenumber"),ccsText);
CCSetSession("supplierid_1", $db->f("supplierid"),ccsInteger);
CCSetSession("roomid_1", $db->f("roomid"),ccsInteger);
CCSetSession("siteid_1", $db->f("siteid"),ccsInteger);
CCSetSession("userid_1", $db->f("userid"),ccsInteger);
CCSetSession("updatenotes_1", $db->f("updatenotes"),ccsText);
}
$SQL = "INSERT INTO workorderlog (assetid, contact, description, duedate, levelid,
phone, priorityid, quotenumber, roomid, supplierid, updatenotes, userid, workorderid)"
." VALUES(" .$db->ToSQL(CCGetSession("assetid_1"),ccsText)."," .$db->ToSQL(CCGetSession("contact_1"),ccsText).","
.$db->ToSQL(CCGetSession("description_1"),ccsText).","
.$db->ToSQL(CCGetSession("duedate_1"),ccsDate).","
.$db->ToSQL(CCGetSession("levelid_1"),ccsInteger).","
.$db->ToSQL(CCGetSession("phone_1"),ccsText).","
.$db->ToSQL(CCGetSession("priorityid_1"),ccsInteger).","
.$db->ToSQL(CCGetSession("quotenumber_1"),ccsText).","
.$db->ToSQL(CCGetSession("roomid_1"),ccsInteger).","
.$db->ToSQL(CCGetSession("supplierid_1"),ccsInteger).","
.$db->ToSQL(CCGetSession("updatenotes_1"),ccsText).","
.$db->ToSQL(CCGetSession("userid_1"),ccsInteger).","
.$db->ToSQL(CCGetSession("workorderid_1"),ccsInteger).")";
$db->query($SQL);
$SQL = "INSERT INTO accruals (workorderid)"." VALUES(" .$db->ToSQL(CCGetSession("workorderid_1"),ccsInteger).")";
$db->query($SQL);
$SQL = "UPDATE accruals SET accrual= " .$db->ToSQL(CCGetSession("accrual_1"),ccsFloat).","
."domainid= " .$db->ToSQL(CCGetSession("domainid_1"),ccsInteger).","
."issuedate= ".$db->ToSQL(CCGetSession("issuedate_1"),ccsDate).","
."quotenumber= ".$db->ToSQL(CCGetSession("quotenumber_1"),ccsText).","
."supplierid= ".$db->ToSQL(CCGetSession("supplierid_1"),ccsInteger).","
."siteid= ".$db->ToSQL(CCGetSession("siteid_1"),ccsInteger)."."
."WHERE workorderid= ". $db->ToSQL(CCGetSession("workorderid_1"),ccsInteger);
$db->query($SQL);
$SQL = "INSERT INTO accrualinvoices (workorderid)"." VALUES(" .$db->ToSQL(CCGetSession("workorderid_1"),ccsInteger).")";
$db->query($SQL);
$SQL = "UPDATE accrualinvoices SET domainid= " .$db->ToSQL(CCGetSession("domainid_1"),ccsInteger).","
."issuedate= ".$db->ToSQL(CCGetSession("issuedate_1"),ccsDate).","
."quotenumber= ".$db->ToSQL(CCGetSession("quotenumber_1"),ccsText).","
."supplierid= ".$db->ToSQL(CCGetSession("supplierid_1"),ccsInteger).","
."siteid= ".$db->ToSQL(CCGetSession("siteid_1"),ccsInteger)."."
."WHERE workorderid= ". $db->ToSQL(CCGetSession("workorderid_1"),ccsInteger);
$db->query($SQL);
$SQL= "SELECT calloutfee FROM sitesupplier WHERE siteid= ". $db->ToSQL(CCGetSession("siteid_1"),ccsInteger).
"." ."AND supplierid=". $db->ToSQL(CCGetSession("supplierid_1"),ccsInteger);
$db->query($SQL);
$Result = $db->next_record();
{
CCSetSession("calloutfee_1", $db->f("calloutfee"),ccsFloat);
}
$SQL = "Update accruals SET accrual=".$db->ToSQL(CCGetSession("calloutfee_1"),ccsFloat)."."
."WHERE workorderid= ". $db->ToSQL(CCGetSession("workorderid_1"),ccsInteger);
$db->query($SQL);
$db->close();
CCSetSession("accrual_1", "");
CCSetSession("assetid_1", "");
CCSetSession("calloutfee_1","");
CCSetSession("contact_1", "");
CCSetSession("domainid_1", "");
CCSetSession("description_1", "");
CCSetSession("duedate_1", "");
CCSetSession("levelid_1", "");
CCSetSession("phone_1", "");
CCSetSession("priorityid_1", "");
CCSetSession("quotenumber_1", "");
CCSetSession("roomid_1", "");
CCSetSession("siteid_1", "");
CCSetSession("updatenotes_1", "");
CCSetSession("supplierid_1", "");
CCSetSession("userid_1", "");
CCSetSession("workorder_1", "");
_________________
Central Coast, NSW, Australia.
|
