File manager

File manager - Edit - /home/autoph/public_html/pms_v1/mar/loadPendingApproval.php

Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['code'])){ $userID = $_POST['userID']; $accessLevel =""; //DROP EXISTIN TABLE AND CREATE EMPTY TEMP. TABLE $dropT = "DROP TABLE IF EXISTS `tempapprovalview`"; if ($conn->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: <br>"; } else { $sqlMessage = "Error: " . $sql . "<br>" . $conn->error; } ?> <?php $myKingdom = "SELECT * FROM `approver_setup` WHERE `approver_id`='$userID' ORDER BY `id` ASC"; $qKing = mysqli_query($conn,$myKingdom); while($km = mysqli_fetch_array($qKing)){ $myLevel = $km['level']; $activeUnitID = $km['unit_id']; switch($myLevel){ case 'EMPL': $getEmp = "SELECT * FROM `pms_employee_data` WHERE `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 . "<br>" . $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 . "<br>" . $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 . "<br>" . $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 . "<br>" . $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 . "<br>" . $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 . "<br>" . $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 . "<br>" . $conn->error; } } } } break; } } ?> <table data-toggle="modal" data-target="#viewMARData" data-dismiss="modal" style="width:100%;border-collapse:collapse;min-width:400px"> <thead> <th class='text-left text-dark'>REC#</th> <th class='text-left text-dark'>EMP ID</th> <th class='text-left text-dark'>PCP ID</th> <th class='col-lg-4 text-left text-dark'>EMPLOYEE NAME</th> <th class='text-left text-dark'>MON</th> <th class='text-left text-dark'>SEM</th> <th class='text-left text-dark'>YEAR</th> <th class='col-lg-1 text-left text-dark'>DATE </th> <th class='col-lg-4 text-left text-dark'>MAR STATUS</th> </thead> <?php $getMAR= "SELECT * FROM `tempapprovalview` WHERE `owner_id` = '$userID' ORDER BY employee_name ASC "; $qMar = mysqli_query($conn,$getMAR); while($row = mysqli_fetch_array($qMar)){ $empID = $row['emp_id']; ?><tr onclick="javascript:getApprovalInfo(this);"><?php echo "<td class='text-left'>".$row['mar_header_id']."</td>"; // mar_emp_header ID echo "<td class='text-left'>".$empID."</td>"; // emp ID echo "<td class='text-left'>".$row['pcp_id']."</td>"; // emp ID echo "<td class='text-left'>".$row['employee_name']."</td>"; echo "<td class='text-left'>".$row['mar_month']."</td>"; echo "<td class='text-left'>".$row['mar_group']."</td>"; echo "<td class='text-left'>".$row['mar_year']."</td>"; echo "<td class='text-left'>"; echo $row['mar_date']; echo "</td>"; echo "<td class='col-lg-3 text-left'>".$row['mar_desc']."</td>"; echo "</tr>"; } ?> </table> <?php $conn->close(); } ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.01 | proxy | phpinfo | Settings