File manager

File manager - Edit - /home/autoph/public_html/pms_v1/functions/myKingdom.php

Back
<?php function loadMyKingdom($userID){ include '../../../cfg/conn.php'; //DROP EXISTIN TABLE AND CREATE EMPTY TEMP. TABLE $dropT = "DROP TABLE IF EXISTS `tempmarviews`"; if ($conn->query($dropT) === TRUE) { } else { } //create temp. table if not exist $sql = "CREATE TABLE IF NOT EXISTS `tempmarviews` ( `id` int(11) NOT NULL AUTO_INCREMENT, `emp_rec_id` int(11) NOT NULL, `emp_id` int(11) NOT NULL, `comp_code` varchar(15) NOT NULL, `branch_code` varchar(15) NOT NULL, `first_name` varchar(30) NOT NULL, `last_name` varchar(30) NOT NULL, `position` varchar(30) NOT NULL, `owner_id` varchar(30) NOT NULL, PRIMARY KEY (`id`))"; if ($conn->query($sql) === TRUE) { $sqlMessage = "Table has been created: <br>"; } else { $sqlMessage = "Error: " . $sql . "<br>" . $conn->error; } $myKingdom = "SELECT * FROM `approver_setup` WHERE `approver_id`='$userID' AND `deleted`=0 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $empEmpNo = $sec['emp_id']; $compID = $sec['comp_id']; $branchID = $sec['branch_id']; $empFName = $sec['first_name']; $empLName = $sec['last_name']; $empPosition = $sec['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($sec = mysqli_fetch_array($qEmp)){ $empRecID = $sec['id']; $empEmpNo = $sec['emp_id']; $compID = $sec['comp_id']; $branchID = $sec['branch_id']; $empFName = $sec['first_name']; $empLName = $sec['last_name']; $empPosition = $sec['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($dep = mysqli_fetch_array($qEmp)){ $empRecID = $dep['id']; $empEmpNo = $dep['emp_id']; $compID = $dep['comp_id']; $branchID = $dep['branch_id']; $empFName = $dep['first_name']; $empLName = $dep['last_name']; $empPosition = $dep['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($dep = mysqli_fetch_array($qEmp)){ $empRecID = $dep['id']; $empEmpNo = $dep['emp_id']; $compID = $dep['comp_id']; $branchID = $dep['branch_id']; $empFName = $dep['first_name']; $empLName = $dep['last_name']; $empPosition = $dep['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($dep = mysqli_fetch_array($qEmp)){ $empRecID = $dep['id']; $empEmpNo = $dep['emp_id']; $compID = $dep['comp_id']; $branchID = $dep['branch_id']; $empFName = $dep['first_name']; $empLName = $dep['last_name']; $empPosition = $dep['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($dep = mysqli_fetch_array($qEmp)){ $empRecID = $dep['id']; $empEmpNo = $dep['emp_id']; $compID = $dep['comp_id']; $branchID = $dep['branch_id']; $empFName = $dep['first_name']; $empLName = $dep['last_name']; $empPosition = $dep['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; 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 \|\| `id`='$userID' AND deleted=0 "; $qEmp = mysqli_query($conn,$getEmp); while($dep = mysqli_fetch_array($qEmp)){ $empRecID = $dep['id']; $empEmpNo = $dep['emp_id']; $compID = $dep['comp_id']; $branchID = $dep['branch_id']; $empFName = $dep['first_name']; $empLName = $dep['last_name']; $empPosition = $dep['position']; //insert record to temp. table for later viewing $checkIFrecordExist = "SELECT * FROM tempmarviews WHERE emp_rec_id='$empRecID'"; $qcheckIFrecordExist = mysqli_query($conn,$checkIFrecordExist); $existCount = mysqli_num_rows($qcheckIFrecordExist); if($existCount > 0){ }else{ $sql = "INSERT INTO tempmarviews (`id`, `emp_rec_id`, `emp_id`,`comp_code`,`branch_code`,`first_name`,`last_name`,`position`,`owner_id`) VALUES ('', '$empRecID', '$empEmpNo','$compID','$branchID','$empFName','$empLName','$empPosition','$userID')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } } break; } } $conn->close(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings