loadSalesGroup.php000064400000013317150252101010010171 0ustar00 0){ $errorMSG="Record already exist."; }else{ $branchID = getUserData($employeeSearchID)[0]; //store data $sql = "INSERT INTO pms_sales_team ( `id`, `company_id`, `employee_id`, `group_id`, `dealer_id`, `date_added`, `modified_by`) VALUES ( '', '$selUnitID', '$employeeSearchID', '$selRole', '$branchID', '$myTimeStamp', '$userID')"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been saved."; } else { $errorMSG="Error saving record. SQL Error detected at line: 49 loadCompanyApprover @ swtich #2"; } } break; case 3: //DELETE aprID $userID = sanitize($_POST['userID']); $salesPersonID = sanitize($_POST['salesPersonID']); $selUnitID = sanitize($_POST['selUnitID']); $sql = "UPDATE pms_sales_team SET deleted = 1,date_modified='$myTimeStamp',modified_by='$userID' WHERE `id`='$salesPersonID'"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been updated."; } else { $errorMSG="Error saving record. SQL Error detected at line: 63 loadCompanyApprover @ swtich #3"; } break; } $count=0; if($selectedGroupID!=''){ $getEmpInfo = "SELECT * FROM `pms_sales_team` WHERE `deleted`=0 AND `company_id`='$selUnitID' AND `group_id`='$selectedGroupID' ORDER BY `id` ASC"; }else{ $getEmpInfo = "SELECT * FROM `pms_sales_team` WHERE `deleted`=0 AND `company_id`='$selUnitID' ORDER BY `id` ASC"; } $getEmp = mysqli_query($conn,$getEmpInfo); $statRow = mysqli_num_rows($getEmp); $actDealID=0; $grpID=0; $actEmpID=0; while($eow = mysqli_fetch_array($getEmp)){ $count = $count + 1; $actEmpID=$eow['employee_id']; $actDealID =$eow['dealer_id']; $grpID=$eow['group_id']; ?>".$eow['id'].""; echo ""; echo getSalesGroup($grpID)[0]; echo ""; echo ""; echo getEmployeeEmpInformationB($actEmpID)[2] . " ". getEmployeeEmpInformationB($actEmpID)[3]; echo ""; echo ""; echo getDealerNameSub($actDealID)[0]; echo ""; echo " "; echo ""; } if($count>1){$flr='s';}else{$flr='';} $errorMSG = $count ." record" .$flr." found"; echo "".$errorMSG.""; $conn->close(); } ?> salesGroupSetup.php000064400000066776150252101010010433 0ustar00PMS Name id " . $_SESSION['userID']; $uID = $_SESSION['userID']; } include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['grp'])){ //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($uID); $moduleID = 43; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo ""; echo ""; echo ""; echo ""; echo ""; if($add == 1){$addButton = '';}else{$addButton='Disabled';} if($edit == 1){$editButton = '';}else{$editButton='Disabled';} if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';} if($print == 1){$printButton = '';}else{$printButton='Disabled';} if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';} if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){ echo "
"; echo "

Access Denied

"; echo "

Sorry, you are not authorized to access this page.
Please contact your system support for assistance.

Thank you!

"; exit(); } //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== ?>

Sales Group Setup

NAVIGATION:

  • SELECT COMPANY
      0){ echo ""; while($row = mysqli_fetch_array($getC)){ ?>".$row['comp_id'].""; echo ""; echo ""; } echo "
      ".$row['comp_name']."
      "; } ?>
  • SELECT SALES GROUP
      0){ echo ""; while($row = mysqli_fetch_array($getC)){ ?>".$row['id'].""; echo ""; echo ""; } echo "
      ".$row['group_name']."
      "; echo ""; echo ""; echo ""; echo ""; echo "
      "; } ?>

ACTIVE SALES GROUP / SALES PERSON:

REC.ID GROUP FIRSTNAME DEALER

.htaccess000064400000000030150252101010006316 0ustar00DirectoryIndex index.phpsaveNewSalesGroup.php000064400000002222150252101010010653 0ustar00query($sql) === TRUE) { } else { } $getComp = "SELECT * FROM `pms_sales_group` WHERE `deleted`=0 ORDER BY `group_code` ASC"; $getC = mysqli_query($conn,$getComp); $statRow = mysqli_num_rows($getC); while($row = mysqli_fetch_array($getC)){ ?>".$row['id'].""; echo "".$row['group_name'].""; echo ""; } } $conn->close(); ?> index.php000064400000000113150252101010006342 0ustar00error_log000064400000000770150252101010006450 0ustar00[02-Oct-2023 14:47:56 Asia/Singapore] PHP Fatal error: Call to undefined function getUserData() in /home/autoph/public_html/pms_v1/sales/loadSalesGroup.php on line 32 [02-Oct-2023 14:48:12 Asia/Singapore] PHP Fatal error: Call to undefined function getUserData() in /home/autoph/public_html/pms_v1/sales/loadSalesGroup.php on line 32 [02-Oct-2023 14:48:58 Asia/Singapore] PHP Fatal error: Call to undefined function getUserData() in /home/autoph/public_html/pms_v1/sales/loadSalesGroup.php on line 32