$fms_db->setFleetDB(); // SAVE NEW MAKE $ins_make = new Table; $ins_make->setSQLType($fms_db->getSQLType()); $ins_make->setInstance($fms_db->getInstance()); $ins_make->setTable("makemaster"); $ins_make->setField("makeID,makeName,createdBy,createdDate"); $ins_make->setValues("'$newNum','$makeName','$sys_UserID','$today'"); $ins_make->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO MAKE UpdateCtrlNo("make"); $url = BASE_URL . V_MAKE; $msg = "New Make successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW MAKE -- // -- START DELETE MAKE -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
// SAVE NEW SUPPLIER $ins_category = new Table; $ins_category->setSQLType($fms_db->getSQLType()); $ins_category->setInstance($fms_db->getInstance()); $ins_category->setTable("suppliermaster"); $ins_category->setField("supplierID,supplierName,supplierAddress,supplierEmailAddress,supplierContactNo,contactPerson ,TIN,createdBy,createdDate"); $ins_category->setValues("'$newNum','$suppName','$suppAddress','$suppEmailAddress','$suppContactNo','$suppContactPerson' ,'$suppTIN','$sys_UserID','$today'"); $ins_category->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO SUPPLIER UpdateCtrlNo("supplier"); $url = BASE_URL . V_SUPPLIER; $msg = "New Supplier successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW SUPPLIER -- // -- START DELETE SUPPLIER -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
$fms_db->setFleetDB(); // SAVE NEW USER MENU $ins_assigneecompany = new Table; $ins_assigneecompany->setSQLType($fms_db->getSQLType()); $ins_assigneecompany->setInstance($fms_db->getInstance()); $ins_assigneecompany->setTable("assigneemapper"); $ins_assigneecompany->setField("id,companyID,assigneeID,type,createdBy,createdDate"); $ins_assigneecompany->setValues("'$newNum','$companyid','$assigneeid','assignee_company','$sys_UserID','$today'"); $ins_assigneecompany->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO UpdateCtrlNo("assignee_company"); $url = BASE_URL . V_ASSIGNEECOMPANY . "?id=" . $assigneeid; $msg = "Company was successfully tagged to Assignee."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } if(isset($_GET['assignee_company_remove']) && !empty($_GET['assignee_company_remove']) && $_GET['assignee_company_remove'] == '1'){ $assigneeid = $_GET['id']; $companyid = $_GET['companyid']; // SET FMS DB $fms_db = new DBConfig;
$ins_wodtl->setInstance($fms_db->getInstance()); $ins_wodtl->setTable("workorderdetail"); $ins_wodtl->setField("woReferenceNo,partsID,partsPrice,qty"); $ins_wodtl->setValues("'$newNum','$pItem[0]','$pItem[3]','$pItem[4]'"); $ins_wodtl->doQuery("save"); // $sql .= "INSERT INTO workorderdetail(woReferenceNo,partsID,partsPrice,qty) // VALUES('$newNum','$pItem[0]','$pItem[3]','$pItem[4]'); "; } } // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO WORK ORDER UpdateCtrlNo("work_order"); $url = BASE_URL . V_WORKORDER; $msg = "New Work Order successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW WORK ORDER -- // -- START DELETE WORK ORDER -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
// UPDATE ASSIGNEE EQUIPMENT $upd_ass_equip = new Table; $upd_ass_equip->setSQLType($fms_db->getSQLType()); $upd_ass_equip->setInstance($fms_db->getInstance()); $upd_ass_equip->setTable("assigneeequipment"); $upd_ass_equip->setValues("assignedEnd = '$today', isCurrent = '0'"); $upd_ass_equip->setParam("WHERE assigneeID = '$curAssignee' AND equipmentID = '$id'"); $upd_ass_equip->doQuery("update"); } // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO UpdateCtrlNo("assignee_equipment"); if($_FILES['txtEquipmentPhoto']['size'] > 0){ if (!is_dir($dir)) { mkdir($dir, 0777, true); } if(file_exists($dir . "/" . $oldPhoto)){ unlink($dir . "/" . $oldPhoto); } move_uploaded_file($_FILES['txtEquipmentPhoto']['tmp_name'], $dir . '/' . $equipmentPhoto); } $url = BASE_URL . V_EQUIPMENT; $msg = "Equipment successfully updated."; $alert = new MessageAlert();
$fms_db->setFleetDB(); // SAVE NEW CATEGORY $ins_category = new Table; $ins_category->setSQLType($fms_db->getSQLType()); $ins_category->setInstance($fms_db->getInstance()); $ins_category->setTable("categorymaster"); $ins_category->setField("categoryID,categoryName,createdBy,createdDate"); $ins_category->setValues("'$newNum','$catName','$sys_UserID','$today'"); $ins_category->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO CATEGORY UpdateCtrlNo("category"); $url = BASE_URL . V_CATEGORY; $msg = "New Category successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW CATEGORY -- // -- START DELETE CATEGORY -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
// SAVE NEW REMINDER $ins_reminder = new Table; $ins_reminder->setSQLType($fms_db->getSQLType()); $ins_reminder->setInstance($fms_db->getInstance()); $ins_reminder->setTable("remindermaster"); $ins_reminder->setField("reminderID,title,description,location,category,startDate,dueDate ,createdBy,createdDate"); $ins_reminder->setValues("'$newNum','$title','$desc','$location','$category','$startDate','$dueDate' ,'$sys_UserID','$today'"); $ins_reminder->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO REMINDER UpdateCtrlNo("reminder"); $url = BASE_URL . V_REMINDERS; $msg = "New Reminder successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW REMINDER -- // -- START DELETE REMINDER -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
$fms_db->setFleetDB(); // SAVE NEW SERVICE TYPE $ins_servicetype = new Table; $ins_servicetype->setSQLType($fms_db->getSQLType()); $ins_servicetype->setInstance($fms_db->getInstance()); $ins_servicetype->setTable("servicetypemaster"); $ins_servicetype->setField("serviceTypeID,description,createdBy,createdDate"); $ins_servicetype->setValues("'$newNum','$desc','$sys_UserID','$today'"); $ins_servicetype->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO SERVICE TYPE UpdateCtrlNo("service_type"); $url = BASE_URL . V_SERVICETYPE; $msg = "New Service Type successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW SERVICE TYPE -- // -- START DELETE SERVICE TYPE -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
$fms_db->setFleetDB(); // SAVE NEW USER MENU $ins_userassignee = new Table; $ins_userassignee->setSQLType($fms_db->getSQLType()); $ins_userassignee->setInstance($fms_db->getInstance()); $ins_userassignee->setTable("assigneemapper"); $ins_userassignee->setField("id,userID,assigneeID,type,createdBy,createdDate"); $ins_userassignee->setValues("'$newNum','$userid','$assigneeid','user_assignee',$sys_UserID','$today'"); $ins_userassignee->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO USER ASSIGNEE UpdateCtrlNo("user_assignee"); $url = BASE_URL . V_USERASSIGNEE . "?id=" . $userid; $msg = "User Assignee was successfully tagged."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } if(isset($_GET['user_assignee_remove']) && !empty($_GET['user_assignee_remove']) && $_GET['user_assignee_remove'] == '1'){ $assigneeid = $_GET['assigneeid']; $userid = $_GET['userid']; // SET FMS DB $fms_db = new DBConfig;
$fms_db->setFleetDB(); // SAVE NEW LOCATION $ins_location = new Table; $ins_location->setSQLType($fms_db->getSQLType()); $ins_location->setInstance($fms_db->getInstance()); $ins_location->setTable("locationmaster"); $ins_location->setField("locationID,locationName,createdBy,createdDate"); $ins_location->setValues("'$newNum','$locName','$sys_UserID','$today'"); $ins_location->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO LOCATION UpdateCtrlNo("location"); $url = BASE_URL . V_LOCATION; $msg = "New Location successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW LOCATION -- // -- START DELETE LOCATION -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
$fms_db->setFleetDB(); // SAVE NEW MODEL $ins_make = new Table; $ins_make->setSQLType($fms_db->getSQLType()); $ins_make->setInstance($fms_db->getInstance()); $ins_make->setTable("modelmaster"); $ins_make->setField("modelID,description,variant,variantDescription,createdBy,createdDate"); $ins_make->setValues("'$newNum','$desc','$variant','$variantDesc','$sys_UserID','$today'"); $ins_make->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO MODEL UpdateCtrlNo("model"); $url = BASE_URL . V_MODEL; $msg = "New Model successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW MODEL -- // -- START DELETE MODEL -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];
$ins_assignee->setInstance($fms_db->getInstance()); $ins_assignee->setTable("assigneemaster"); $ins_assignee->setField("assigneeID,companyID,locationID,firstname,lastname,gender,age,contactNo1,contactNo2,address ,costCenter,immediateHead,emailAddress,attachment,licenseNo,expirationDate,licenseAddress ,createdBy,createdDate"); $ins_assignee->setValues("'$newNum','$company','$location','$fName','$lName','$gender','$age','$contactNo1','$contactNo2' ,'$address','$costCenter','$immediateHead','$immediateEmailAddress','$attachment','$licenseNo' ,'$licenseExpirationDate','$licenseAddress' ,'$sys_UserID','$today'"); $ins_assignee->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO ASSIGNEE UpdateCtrlNo("assignee"); if($_FILES['txtAttachment']['size'] > 0){ if (!file_exists($dir . "/" . $attachment)) { mkdir($dir, 0777, true); } move_uploaded_file($_FILES['txtAttachment']['tmp_name'], $dir . '/' . $attachment); } $url = BASE_URL . V_ASSIGNEE; $msg = "New Assignee successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert();
$ins_po->setTable("poreceiving"); $ins_po->setField("poReferenceNo,woReferenceNo,poTransactionDate ,labor,miscellaneous,parts,discount,tax,Amount $attachmentfld ,createdBy,createdDate"); $ins_po->setValues("'$newNum','$wo','$today' ,'$labor','$misc','$parts','$disc','$tax','$totalCost' $attachmentval ,'$sys_UserID','$today'"); $ins_po->doQuery("save"); // CLOSING PURCHSE DB $fms_db->DBClose(); // UPDATE CONTROL NO PURCHSE ORDER UpdateCtrlNo("po_receiving"); if($_FILES['txtAttachment']['size'] > 0){ if (!file_exists($dirPOAttachment . "/" . $attachment)) { mkdir($dirPOAttachment, 0777, true); } move_uploaded_file($_FILES['txtAttachment']['tmp_name'], $dirPOAttachment . '/' . $attachment); } $url = BASE_URL . V_PORECEIVING; $msg = "New Purchase Order successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert();
// SAVE NEW PARTS $ins_parts = new Table; $ins_parts->setSQLType($fms_db->getSQLType()); $ins_parts->setInstance($fms_db->getInstance()); $ins_parts->setTable("partsmaster"); $ins_parts->setField("partsID,stockCode,brand,model,description,stockOnHand,lowStockQty,price,retailPrice ,createdBy,createdDate"); $ins_parts->setValues("'$newNum','$stockCode','$brand','$model','$desc','$stockOnHand','$lowStockQty','$price','$retailPrice' ,'$sys_UserID','$today'"); $ins_parts->doQuery("save"); // CLOSING FMS DB $fms_db->DBClose(); // UPDATE CONTROL NO PARTS UpdateCtrlNo("parts"); $url = BASE_URL . V_PARTS; $msg = "New Parts successfully saved."; $alert = new MessageAlert(); $alert->setURL($url); $alert->setMessage($msg); $alert->Alert(); } // -- END SAVE NEW PARTS -- // -- START DELETE PARTS -- if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){ $id = $_GET['id'];