$_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;
$alert->setURL(BASE_URL);
$alert->setMessage("Access Granted.");
$alert->Alert();
}else{
$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);
$alert->Alert();
}
}
$search .= "AND category LIKE '%$category%' ";
}
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
// SET REMINDER
$searchrem = new Table;
$searchrem->setSQLType($fms_db->getSQLType());
$searchrem->setInstance($fms_db->getInstance());
$searchrem->setView("v_remindermaster");
$searchrem->setParam("WHERE status > 0 $search ORDER BY createdDate DESC");
$searchrem->doQuery("query");
$row_searchrem = $searchrem->getLists();
$num_searchrem = $searchrem->getNumRows();
// CLOSING FMS DB
$fms_db->DBClose();
}
// -- START SAVE NEW REMINDER --
if(isset($_POST['save']) && !empty($_POST['save']) && $_POST['save'] == 1){
$title = $_POST['txtTitle'];
$location = $_POST['txtLocation'];
$category = $_POST['txtCategory'];
$desc = $_POST['txtDescription'];
$startDate = $_POST['txtStartDate'] . ' ' . date("h:i:s");
$dueDate = $_POST['txtDueDate'] . ' ' . date("h:i:s");
$newNum = getNewCtrlNo("reminder");
$wo = $_GET['wo'];
$exist = 0;
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
if(!empty($wo)){
// SET WORK ORDER
$workordermst = new Table;
$workordermst->setSQLType($fms_db->getSQLType());
$workordermst->setInstance($fms_db->getInstance());
$workordermst->setView("v_workordermaster");
$workordermst->setParam("WHERE woReferenceNo = '$wo' AND status NOT IN('5','6','7','8') ");
$workordermst->doQuery("query");
$num_workordermst = $workordermst->getNumRows();
if($num_workordermst == 0){
$placeholder = "Work Order Reference # not existed!";
$wo = null;
}
}else{
$placeholder = "Enter Work Order here...";
}
// CLOSING FMS DB
$fms_db->DBClose();
?>
<span id="divTxtWorkOrder">
<input type="text" name="txtWorkOrderNo" id="txtWorkOrderNo" value="<?php
echo $wo;
$servicetypemst->setSQLType($fms_db->getSQLType());
$servicetypemst->setInstance($fms_db->getInstance());
$servicetypemst->setView("v_servicetypemaster");
$servicetypemst->setParam("WHERE status = '1'");
$servicetypemst->doQuery("query");
$row_servicetypemst = $servicetypemst->getLists();
// SET EQUIPMENT
$equipmentmst = new Table;
$equipmentmst->setSQLType($fms_db->getSQLType());
$equipmentmst->setInstance($fms_db->getInstance());
$equipmentmst->setView("v_equipmentmaster");
$equipmentmst->setParam("WHERE status = '1'");
$equipmentmst->doQuery("query");
$row_equipmentmst = $equipmentmst->getLists();
$num_equipmentmst = $equipmentmst->getNumRows();
if($num_equipmentmst == 1){
$assignee = $row_equipmentmst[0]['assigneeName'];
}
// SET EQUIPMENT
$assigneemst = new Table;
$assigneemst->setSQLType($fms_db->getSQLType());
$assigneemst->setInstance($fms_db->getInstance());
$assigneemst->setView("v_assigneemaster");
$assigneemst->setParam("WHERE status = '1'");
$assigneemst->doQuery("query");
$row_assigneemst = $assigneemst->getLists();
// SET PARTS
$fileName = $_FILES['txtUserPic']['name'];
$password = generatePassword(strtoupper($userID));
$dir = USERPICS . strtoupper($userID);
// SET FMS DB
$fms_db = new DBConfig;
$fms_db->setFleetDB();
$chk_user = new Table;
$chk_user->setSQLType($fms_db->getSQLType());
$chk_user->setInstance($fms_db->getInstance());
$chk_user->setView("v_usermaster");
$chk_user->setParam("WHERE userID = '$userID'");
$chk_user->doQuery("query");
$num_chkuser = $chk_user->getNumRows();
if($num_chkuser == 0){
// SAVE NEW USER
$ins_user = new Table;
$ins_user->setSQLType($fms_db->getSQLType());
$ins_user->setInstance($fms_db->getInstance());
$ins_user->setTable("usermaster");
$ins_user->setField("userID,userPass,firstname,lastname,userType,accessLevel,userPic,createdBy,createdDate");
$ins_user->setValues("'$userID','$password','$fName','$lName','$userType','$accessLvl','$fileName','$sys_UserID','$today'");
$ins_user->doQuery("save");
if($_FILES['txtUserPic']['size'] > 0){
if (!file_exists($dir . "/" . $fileName)) {
mkdir($dir, 0777, true);
}
