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