$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'];
