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();
}
?>