$chkwourl = new Table;
$chkwourl->setSQLType($fms_db->getSQLType());
$chkwourl->setInstance($fms_db->getInstance());
$chkwourl->setView("v_workordermaster");
$chkwourl->setParam("WHERE url = '$sesid'");
$chkwourl->doQuery("query");
$num_chkurl = $chkwourl->getNumRows();
$row_chkurl = $chkwourl->getLists();
$wourl_status = $row_chkurl[0]['status'];
// CHECK WORK ORDER
$wo_dtl = new Table;
$wo_dtl->setSQLType($fms_db->getSQLType());
$wo_dtl->setInstance($fms_db->getInstance());
$wo_dtl->setView("v_workorderdetail");
$wo_dtl->setParam("WHERE woReferenceNo = '$worefno'");
$wo_dtl->doQuery("query");
$num_wo_dtl = $wo_dtl->getNumRows();
$row_wo_dtl = $wo_dtl->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
if($num_chkwo == 0 || $num_chkurl == 0 || $wo_status != 1 || $wourl_status != 1){
$url = BASE_URL;
$msg = "Invalid URL!";
$alert = new MessageAlert();
$alert->setURL($url);
$alert->setMessage($msg);
}
// -- END SAVE NEW EQUIPMENT --
// -- START DELETE EQUIPMENT --
if(isset($_GET['delete']) && !empty($_GET['delete']) && $_GET['delete'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET EQUIPMENT
$equipmentmst = new Table;
$equipmentmst->setSQLType($fms_db->getSQLType());
$equipmentmst->setInstance($fms_db->getInstance());
$equipmentmst->setView("v_equipmentmaster");
$equipmentmst->setParam("WHERE equipmentID = '$id'");
$equipmentmst->doQuery("query");
$row_equipmentmst = $equipmentmst->getLists();
// DELETE EQUIPMENT
$del_equipment = new Table;
$del_equipment->setSQLType($fms_db->getSQLType());
$del_equipment->setInstance($fms_db->getInstance());
$del_equipment->setTable("equipmentmaster");
$del_equipment->setParam("WHERE equipmentID = '$id'");
$del_equipment->doQuery("delete");
$res_equipment = $del_equipment->getError();
// CLOSING FMS DB
$fms_db->DBClose();
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET PURCHASE ORDER
$poreceivingmst = new Table;
$poreceivingmst->setSQLType($fms_db->getSQLType());
$poreceivingmst->setInstance($fms_db->getInstance());
$poreceivingmst->setView("v_poreceiving");
$poreceivingmst->setParam("WHERE status = '0' ORDER BY status ASC, poReferenceNo DESC, poTransactionDate DESC");
$poreceivingmst->doQuery("query");
$row_poreceivingmst = $poreceivingmst->getLists();
// SET WORK ORDER
$workordermst = new Table;
$workordermst->setSQLType($fms_db->getSQLType());
$workordermst->setInstance($fms_db->getInstance());
$workordermst->setView("v_workordermaster");
$workordermst->setParam("WHERE status NOT IN('5','6','7','8') ORDER BY status ASC, woReferenceNo DESC, woTransactionDate DESC");
$workordermst->doQuery("query");
$row_workordermst = $workordermst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
}
// -- END DELETE REMINDER --
// -- START EDIT REMINDER --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET REMINDER
$reminders = new Table;
$reminders->setSQLType($fms_db->getSQLType());
$reminders->setInstance($fms_db->getInstance());
$reminders->setView("v_remindermaster");
$reminders->setParam("WHERE reminderID = '$id'");
$reminders->doQuery("query");
$row_reminders = $reminders->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_reminders[0]['status'];
}
// -- END EDIT REMINDER --
// -- START UPDATE REMINDER --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$title = $_POST['txtTitle'];
}
// -- END DELETE CONTROL NO --
// -- START EDIT CONTROL NO --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET CONTROL NO
$ctrlno = new Table;
$ctrlno->setSQLType($fms_db->getSQLType());
$ctrlno->setInstance($fms_db->getInstance());
$ctrlno->setView("controlnomaster");
$ctrlno->setParam("WHERE id = '$id'");
$ctrlno->doQuery("query");
$row_ctrlno = $ctrlno->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_ctrlno[0]['status'];
}
// -- END EDIT CONTROL NO --
// -- START UPDATE CONTROL NO --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$desc = $_POST['txtDescription'];
$fms_db->setFleetDB();
// SET USER
$usermst = new Table;
$usermst->setSQLType($fms_db->getSQLType());
$usermst->setInstance($fms_db->getInstance());
$usermst->setView("v_usermaster");
$usermst->setParam("ORDER BY userID");
$usermst->doQuery("query");
$row_usermst = $usermst->getLists();
// GET USER
$getuser = new Table;
$getuser->setSQLType($fms_db->getSQLType());
$getuser->setInstance($fms_db->getInstance());
$getuser->setView("v_usermaster");
$getuser->setParam("WHERE userID = '$sys_UserID'");
$getuser->doQuery("query");
$row_getuser = $getuser->getLists();
$userPass = $row_getuser[0]['userPass'];
// CLOSING FMS DB
$fms_db->DBClose();
function generatePassword($password){
$salt = 'FleetManagementSystem';
$newpass = md5(sha1($salt.$password));
return $newpass;
}
?>
}
// -- END DELETE SERVICE TYPE --
// -- START EDIT SERVICE TYPE --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET SERVICE TYPE
$servicetype = new Table;
$servicetype->setSQLType($fms_db->getSQLType());
$servicetype->setInstance($fms_db->getInstance());
$servicetype->setView("v_servicetypemaster");
$servicetype->setParam("WHERE serviceTypeID = '$id'");
$servicetype->doQuery("query");
$row_servicetype = $servicetype->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_servicetype[0]['status'];
}
// -- END EDIT SERVICE TYPE --
// -- START UPDATE SERVICE TYPE --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$desc = $_POST['txtDescription'];
}
// -- END DELETE MAKE --
// -- START EDIT MAKE --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MAKE
$make = new Table;
$make->setSQLType($fms_db->getSQLType());
$make->setInstance($fms_db->getInstance());
$make->setView("v_makemaster");
$make->setParam("WHERE makeID = '$id'");
$make->doQuery("query");
$row_make = $make->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_make[0]['status'];
}
// -- END EDIT CATEGORY --
// -- START UPDATE MAKE --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$makeName = $_POST['txtMakeName'];
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MAKE
$invoicing = new Table;
$invoicing->setSQLType($fms_db->getSQLType());
$invoicing->setInstance($fms_db->getInstance());
$invoicing->setView("v_equipmentrepairedmaster");
$invoicing->setParam("WHERE noOfTransactions > 0 ORDER BY companyName ");
$invoicing->doQuery("query");
$row_invoicing = $invoicing->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET PARTS
$partsmst = new Table;
$partsmst->setSQLType($fms_db->getSQLType());
$partsmst->setInstance($fms_db->getInstance());
$partsmst->setView("v_partsmaster");
$partsmst->setParam("ORDER BY partsID");
$partsmst->doQuery("query");
$row_partsmst = $partsmst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
}
// -- END DELETE LOCATION --
// -- START EDIT LOCATION --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET LOCATION
$location = new Table;
$location->setSQLType($fms_db->getSQLType());
$location->setInstance($fms_db->getInstance());
$location->setView("v_locationmaster");
$location->setParam("WHERE locationID = '$id'");
$location->doQuery("query");
$row_location = $location->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_location[0]['status'];
}
// -- END EDIT LOCATION --
// -- START UPDATE LOCATION --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$locName = $_POST['txtLocationName'];
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET COMPANY
$companymst = new Table;
$companymst->setSQLType($fms_db->getSQLType());
$companymst->setInstance($fms_db->getInstance());
$companymst->setView("v_companymaster");
$companymst->setParam("ORDER BY companyID");
$companymst->doQuery("query");
$row_companymst = $companymst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MODEL
$modelmst = new Table;
$modelmst->setSQLType($fms_db->getSQLType());
$modelmst->setInstance($fms_db->getInstance());
$modelmst->setView("v_modelmaster");
$modelmst->setParam("ORDER BY modelID");
$modelmst->doQuery("query");
$row_modelmst = $modelmst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
}
// -- END DELETE SUPPLIER --
// -- START EDIT SUPPLIER --
if(isset($_GET['edit']) && !empty($_GET['edit']) && $_GET['edit'] == 1 && !empty($_GET['id'])){
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET SUPPLIER
$supplier = new Table;
$supplier->setSQLType($fms_db->getSQLType());
$supplier->setInstance($fms_db->getInstance());
$supplier->setView("v_suppliermaster");
$supplier->setParam("WHERE supplierID = '$id'");
$supplier->doQuery("query");
$row_supplier = $supplier->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
$status = $row_supplier[0]['status'];
}
// -- END EDIT SUPPLIER --
// -- START UPDATE SUPPLIER --
if(isset($_POST['update']) && !empty($_POST['update']) && $_POST['update'] == 1){
$id = $_GET['id'];
$suppName = $_POST['txtSupplierName'];
<?
$id = $_GET['id'];
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET USER ACCESS
$userassignee = new Table;
$userassignee->setSQLType($fms_db->getSQLType());
$userassignee->setInstance($fms_db->getInstance());
$userassignee->setView("v_userassigneemapper");
$userassignee->setParam("WHERE userID = '$id'");
$userassignee->doQuery("query");
$row_userassignee = $userassignee->getLists();
$num_userassignee = $userassignee->getNumRows();
// SET USER ACCESS
$assigneemst = new Table;
$assigneemst->setSQLType($fms_db->getSQLType());
$assigneemst->setInstance($fms_db->getInstance());
$assigneemst->setView("v_assigneemaster");
$assigneemst->setParam("WHERE assigneeID NOT IN(SELECT assigneeID FROM v_userassigneemapper)");
$assigneemst->doQuery("query");
$row_assigneemst = $assigneemst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET USER ACCESS
$usermenu = new Table;
$usermenu->setSQLType($fms_db->getSQLType());
$usermenu->setInstance($fms_db->getInstance());
$usermenu->setView("v_usermenu");
$usermenu->setParam("WHERE userID = '$sys_UserID'");
$usermenu->doQuery("query");
$row_usermenu = $usermenu->getLists();
// SET USER ACCESS
$menumst = new Table;
$menumst->setSQLType($fms_db->getSQLType());
$menumst->setInstance($fms_db->getInstance());
$menumst->setView("v_menumaster");
$menumst->setParam("WHERE menuID NOT IN(SELECT menuID FROM v_usermenu)");
$menumst->doQuery("query");
$row_menumst = $menumst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET CONTROL NO
$usermenu_access = new Table;
$usermenu_access->setSQLType($fms_db->getSQLType());
$usermenu_access->setInstance($fms_db->getInstance());
$usermenu_access->setView("v_usermenu");
$usermenu_access->setParam("WHERE userID = '$sys_UserID'");
$usermenu_access->doQuery("query");
$row_usermenu_access = $usermenu_access->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
if($row_user[0]['userPass'] == $password){
$_SESSION['SYS_USERID'] = $username;
$_SESSION['SYS_UNAME'] = $row_user[0]['userName'];
$_SESSION['SYS_AVATAR'] = USERPICS . $username . '/' . $row_user[0]['userPic'];
$_SESSION['SYS_USERTYPE'] = $row_user[0]['userType'];
$_SESSION['SYS_USERLVL'] = $row_user[0]['accessLevel'];
// SET FMS DB
$fms_db = new DBCOnfig;
$fms_db->setFleetDB();
// SET USER ACCESS
$userassignee = new Table;
$userassignee->setSQLType($fms_db->getSQLType());
$userassignee->setInstance($fms_db->getInstance());
$userassignee->setView("v_userassigneemapper");
$userassignee->setParam("WHERE userID = '$username'");
$userassignee->doQuery("query");
$row_userassignee = $userassignee->getLists();
$num_userassignee = $userassignee->getNumRows();
// GET ASSIGNEE ID
$assigneeID = $row_userassignee[0]['assigneeID'];
// SET ASSIGNEE TO SESSION
$_SESSION['SYS_ASSIGNEE'] = $assigneeID;
// CLOSING FMS DB
$fms_db->DBClose();
$alert = new MessageAlert;
$assigneemst->doQuery("query");
$row_assigneemst = $assigneemst->getLists();
break;
case "a":
$where = "assigneeID = '$id'";
// SET EQUIPMENT
$equipmentmst = new Table;
$equipmentmst->setSQLType($fms_db->getSQLType());
$equipmentmst->setInstance($fms_db->getInstance());
$equipmentmst->setView("v_equipmentmaster");
$equipmentmst->setParam("ORDER BY equipmentID");
$equipmentmst->doQuery("query");
$row_equipmentmst = $equipmentmst->getLists();
break;
default: break;
}
}
// SET ASSIGNEE
$assigneeequipment = new Table;
$assigneeequipment->setSQLType($fms_db->getSQLType());
$assigneeequipment->setInstance($fms_db->getInstance());
$assigneeequipment->setView("v_assigneeequipment");
$assigneeequipment->setParam("WHERE $where ORDER BY isCurrent DESC,assignedStart DESC");
$assigneeequipment->doQuery("query");
$row_assigneeequipment = $assigneeequipment->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
<?
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET CATEGORY
$categorymst = new Table;
$categorymst->setSQLType($fms_db->getSQLType());
$categorymst->setInstance($fms_db->getInstance());
$categorymst->setView("v_categorymaster");
$categorymst->setParam("ORDER BY categoryID");
$categorymst->doQuery("query");
$row_categorymst = $categorymst->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
?>
if($comp_exist == 0){
$alert = new MessageAlert();
$alert->setURL(BASE_URL . 'invoicing.php');
$alert->setMessage("Invalid URL!11");
$alert->Alert();
}
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET MAKE
$invoicingdtl = new Table;
$invoicingdtl->setSQLType($fms_db->getSQLType());
$invoicingdtl->setInstance($fms_db->getInstance());
$invoicingdtl->setView("v_equipmentrepaireddetail");
$invoicingdtl->setParam("WHERE companyID = '$id' ORDER BY woTransactionDate DESC");
$invoicingdtl->doQuery("query");
$row_invoicingdtl = $invoicingdtl->getLists();
// CLOSING FMS DB
$fms_db->DBClose();
}else{
$alert = new MessageAlert();
$alert->setURL(BASE_URL . 'invoicing.php');
$alert->setMessage("Invalid URL!");
$alert->Alert();
}
?>
