query($dropT) === TRUE) { } else { } //create temp. table if not exist $sql = "CREATE TABLE IF NOT EXISTS `tempapprovalview` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mar_header_id` int(11) NOT NULL, `emp_id` int(11) NOT NULL, `pcp_id` int(11) NOT NULL, `employee_name` varchar(50) NOT NULL, `mar_month` varchar(2) NOT NULL, `mar_group` varchar(4) NOT NULL, `mar_year` varchar(4) NOT NULL, `mar_date` varchar(15) NOT NULL, `mar_desc` varchar(100) NOT NULL, `owner_id` int(11) NOT NULL, PRIMARY KEY (`id`))"; if ($conn->query($sql) === TRUE) { $sqlMessage = "Table has been created:
"; } else { $sqlMessage = "Error: " . $sql . "
" . $conn->error; } ?> 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; case 'SECT': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `unit_id`='$activeUnitID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $getMAR= "SELECT * FROM `mar_emp_header` WHERE `emp_id`='$empRecID' AND `mar_posted`=1 AND `mar_approved_by`=0 AND `deleted`=0 || `emp_id`='$userID' AND `mar_posted`=1 AND `mar_approved_by`=1 AND `deleted`=0 AND `ratee_agreement`=0 AND `date_confirmed`=''"; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; $marHeadID = $row['id']; $pcpID = $row['pcp_id']; $marSem = $row['mar_group']; $empName = getEmployeeEmpInformationB($empID)[2]. ", ".getEmployeeEmpInformationB($empID)[3]; $marMonth = $row['mar_month']; $marYear = $row['mar_year']; $marDesc = $row['mar_status']; $posDate= $row['mar_posted_date']; $checkIFrecordExist = "SELECT * FROM tempapprovalview WHERE emp_id='$empID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; case 'DEPT': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `department_id`='$activeUnitID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $getMAR= "SELECT * FROM `mar_emp_header` WHERE `emp_id`='$empRecID' AND `mar_posted`=1 AND `mar_approved_by`=0 AND `deleted`=0 || `emp_id`='$userID' AND `mar_posted`=1 AND `mar_approved_by`=1 AND `deleted`=0 AND `ratee_agreement`=0 AND `date_confirmed`=''"; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; $marHeadID = $row['id']; $pcpID = $row['pcp_id']; $marSem = $row['mar_group']; $empName = getEmployeeEmpInformationB($empID)[2]. ", ".getEmployeeEmpInformationB($empID)[3]; $marMonth = $row['mar_month']; $marYear = $row['mar_year']; $marDesc = $row['mar_status']; $posDate= $row['mar_posted_date']; $checkIFrecordExist = "SELECT * FROM tempapprovalview WHERE emp_id='$empID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; case 'DIVM': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `division_id`='$activeUnitID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $getMAR= "SELECT * FROM `mar_emp_header` WHERE `emp_id`='$empRecID' AND `mar_posted`=1 AND `mar_approved_by`=0 AND `deleted`=0 || `emp_id`='$userID' AND `mar_posted`=1 AND `mar_approved_by`=1 AND `deleted`=0 AND `ratee_agreement`=0 AND `date_confirmed`=''"; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; $marHeadID = $row['id']; $pcpID = $row['pcp_id']; $marSem = $row['mar_group']; $empName = getEmployeeEmpInformationB($empID)[2]. ", ".getEmployeeEmpInformationB($empID)[3]; $marMonth = $row['mar_month']; $marYear = $row['mar_year']; $marDesc = $row['mar_status']; $posDate= $row['mar_posted_date']; $checkIFrecordExist = "SELECT * FROM tempapprovalview WHERE emp_id='$empID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; case 'SUBG': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `sub_group_id`='$activeUnitID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $getMAR= "SELECT * FROM `mar_emp_header` WHERE `emp_id`='$empRecID' AND `mar_posted`=1 AND `mar_approved_by`=0 AND `deleted`=0 || `emp_id`='$userID' AND `mar_posted`=1 AND `mar_approved_by`=1 AND `deleted`=0 AND `ratee_agreement`=0 AND `date_confirmed`=''"; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; $marHeadID = $row['id']; $pcpID = $row['pcp_id']; $marSem = $row['mar_group']; $empName = getEmployeeEmpInformationB($empID)[2]. ", ".getEmployeeEmpInformationB($empID)[3]; $marMonth = $row['mar_month']; $marYear = $row['mar_year']; $marDesc = $row['mar_status']; $posDate= $row['mar_posted_date']; $checkIFrecordExist = "SELECT * FROM tempapprovalview WHERE emp_id='$empID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; case 'DEAL': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `branch_id`='$activeUnitID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $getMAR= "SELECT * FROM `mar_emp_header` WHERE `emp_id`='$empRecID' AND `mar_posted`=1 AND `mar_approved_by`=0 AND `deleted`=0 || `emp_id`='$userID' AND `mar_posted`=1 AND `mar_approved_by`=1 AND `deleted`=0 AND `ratee_agreement`=0 AND `date_confirmed`=''"; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; $marHeadID = $row['id']; $pcpID = $row['pcp_id']; $marSem = $row['mar_group']; $empName = getEmployeeEmpInformationB($empID)[2]. ", ".getEmployeeEmpInformationB($empID)[3]; $marMonth = $row['mar_month']; $marYear = $row['mar_year']; $marDesc = $row['mar_status']; $posDate= $row['mar_posted_date']; $checkIFrecordExist = "SELECT * FROM tempapprovalview WHERE emp_id='$empID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; case 'COMP': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `comp_id`='$activeUnitID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $getMAR= "SELECT * FROM `mar_emp_header` WHERE `emp_id`='$empRecID' AND `mar_posted`=1 AND `mar_approved_by`=0 AND `deleted`=0 || `emp_id`='$userID' AND `mar_posted`=1 AND `mar_approved_by`=1 AND `deleted`=0 AND `ratee_agreement`=0 AND `date_confirmed`=''"; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; $marHeadID = $row['id']; $pcpID = $row['pcp_id']; $marSem = $row['mar_group']; $empName = getEmployeeEmpInformationB($empID)[2]. ", ".getEmployeeEmpInformationB($empID)[3]; $marMonth = $row['mar_month']; $marYear = $row['mar_year']; $marDesc = $row['mar_status']; $posDate= $row['mar_posted_date']; $checkIFrecordExist = "SELECT * FROM tempapprovalview WHERE emp_id='$empID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempapprovalview (`id`, `mar_header_id`, `emp_id`,`employee_name`,`mar_month`,`mar_year`,`mar_date`,`mar_desc`,`owner_id`,`pcp_id`,`mar_group`) VALUES ('', '$marHeadID', '$empID','$empName','$marMonth','$marYear','$posDate','$marDesc','$userID','$pcpID','$marSem')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "
" . $conn->error; } } } } break; } } ?> ".$row['mar_header_id'].""; // mar_emp_header ID echo ""; // emp ID echo ""; // emp ID echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
REC# EMP ID PCP ID EMPLOYEE NAME MON SEM YEAR DATE MAR STATUS
".$empID."".$row['pcp_id']."".$row['employee_name']."".$row['mar_month']."".$row['mar_group']."".$row['mar_year'].""; echo $row['mar_date']; echo "".$row['mar_desc']."
close(); } ?>