File manager

File manager - Edit - /home/autoph/tmp/public_html/pms_v1/ajaxCall/generateEmpKRA.php

Back
<?php include_once("../../../cfg/conn.php"); if(isset($_POST['genKRA'])){ $empRecordID = $_POST['SelectedRecordID']; $userID = $_POST['userID']; //GET POSITION ID $pSQL = "SELECT `position` FROM `pms_employee_data` WHERE `id`='$empRecordID'"; $myPos = mysqli_query($conn,$pSQL); while($pRow = mysqli_fetch_array($myPos)){ $myPositionID=$pRow['position']; } //Delete old KRA before recrating new $dSql = "UPDATE `kra_employee_tbl` SET `deleted` = '1', `date_modified`='$myTimeStamp' WHERE `emp_id` = '$empRecordID' AND `deleted`=0"; if($conn->query($dSql) === TRUE){ //echo "New record created successfully" ; }else{ echo "Error: " . $sql . "<br>" . $conn->error; } //Delete old KPI before recrating new $kSql = "UPDATE `kpi_employee` SET `deleted` = '1', `date_modified`='$myTimeStamp' WHERE `emp_id` = '$empRecordID' AND `deleted`=0"; if($conn->query($kSql) === TRUE){ //echo "New record created successfully"; }else{ //echo "Error: " . $sql . "<br>" . $conn->error; } //LOOP TO POSITION AND READ ALL KRA AND INSERT TO EMPLOYEE KRA TABLE $sqlExist = "SELECT * FROM `kra_position_tbl` WHERE `deleted` = 0 AND `position_id` ='$myPositionID' ORDER BY `kra_code` ASC"; $resultExist = mysqli_query($conn,$sqlExist) or die("Bad query"); $countRowOld = mysqli_num_rows($resultExist); while($kRow=mysqli_fetch_array($resultExist)){ //ADD EMPLOYEE KRA based on ACTIVE POSITION $unitKRAID = $kRow['unit_kra_id']; $positionKRAID = $kRow['id']; $kraWeight = $kRow['weight']; $kraCode = $kRow['kra_code']; $kraName = $kRow['kra_name']; $kraDesc = $kRow['kra_description']; $kraTAG = $kRow['tag']; $kraID=$kRow['id']; $chkQCount=0; //GET DEPTKRA KRA ID $dSQL = "SELECT `department_kra_id` FROM `kra_unit_tbl` WHERE `id`='$unitKRAID'"; $myDept = mysqli_query($conn,$dSQL); while($dRow = mysqli_fetch_array($myDept)){ $departmentKRAID=$dRow['department_kra_id']; } //GET CHILD DIVISION KRA ID $sdSQL = "SELECT `division_kra_id` FROM `kra_department_tbl` WHERE `id`='$departmentKRAID'"; $myDiv = mysqli_query($conn,$sdSQL); while($sdRow = mysqli_fetch_array($myDiv)){ $ChildDivisionKRAID=$sdRow['division_kra_id']; } //GET GROUP DIVISION KRA ID $mdSQL = "SELECT `main_division_kra_id` FROM `kra_division_child_tbl` WHERE `id`='$ChildDivisionKRAID'"; $myMDiv = mysqli_query($conn,$mdSQL); while($mdRow = mysqli_fetch_array($myMDiv)){ $MainDivisionKRAID=$mdRow['main_division_kra_id']; } //GET BRANCH KRA ID $bdSQL = "SELECT `branch_kra_id` FROM `kra_division_tbl` WHERE `id`='$MainDivisionKRAID'"; $byMDiv = mysqli_query($conn,$bdSQL); while($bdRow = mysqli_fetch_array($byMDiv)){ $branchKRAid=$bdRow['branch_kra_id']; } //GET COMPANY KRA ID $companyKRAid=0; $bcdSQL = "SELECT `comp_kra_id` FROM `kra_branch_tbl` WHERE `id`='$branchKRAid'"; $cyMDiv = mysqli_query($conn,$bcdSQL); while($cdRow = mysqli_fetch_array($cyMDiv)){ $companyKRAid = $cdRow['comp_kra_id']; } //GET BRAND KRA $bSQL = "SELECT `brand_kra_id` FROM `kra_comp_detl` WHERE `id`='$companyKRAid'"; $myBrand = mysqli_query($conn,$bSQL); while($dRow = mysqli_fetch_array($myBrand)){ $brandKRAID=$dRow['brand_kra_id']; } //GET AREA KRA $aSQL = "SELECT `group_kra_id` FROM `kra_area_tbl` WHERE `id`='$brandKRAID'"; $myArea = mysqli_query($conn,$aSQL); while($dRow = mysqli_fetch_array($myArea)){ $areaKRAID=$dRow['group_kra_id']; } //GET AUTOHUB KRA $aSQL = "SELECT `id` FROM `kra_group_tbl` WHERE `id`='$areaKRAID'"; $myArea = mysqli_query($conn,$aSQL); while($dRow = mysqli_fetch_array($myArea)){ $ahgKRAID=$dRow['id']; } //CHECK IF KRA ID EXIST IN TABLE. IF SO, SKIP. IF NOT INSERT $chk ="SELECT * FROM `kra_employee_tbl` WHERE `position_kra_id`='$positionKRAID' AND `emp_id`='$empRecordID' AND `deleted`=0"; $chkQ = mysqli_query($conn,$chk); while($kC = mysqli_fetch_array($chkQ)){ $chkQCount=$chkQCount + 1; } if($chkQCount == 0){ //INSERT NEW RECORD $sql = "INSERT INTO kra_employee_tbl ( `id`, `ahg_kra_id`, `brand_kra_id`, `area_kra_id`, `tag`, `emp_id`, `comp_kra_id`, `branch_kra_id`, `main_division_kra_id`, `sub_division_kra_id`, `department_kra_id`, `unit_kra_id`, `position_kra_id`, `weight`, `kra_code`, `kra_name`, `kra_description`, `created_by`) VALUES ( '', '$ahgKRAID', '$brandKRAID', '$areaKRAID', '$kraTAG', '$empRecordID', '$companyKRAid', '$branchKRAid', '$MainDivisionKRAID', '$ChildDivisionKRAID', '$departmentKRAID', '$unitKRAID', '$positionKRAID', '$kraWeight', '$kraCode', '$kraName', '$kraDesc', '$userID')"; if ($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } //SCAN KPI PER KRA TO ADD ENTRY TO EMPLOYEE KPI TABLE } $sqlEmpKRA = "SELECT * FROM `kra_employee_tbl` WHERE `deleted` = 0 AND `emp_id` ='$empRecordID' ORDER BY `id` ASC"; $qKra = mysqli_query($conn,$sqlEmpKRA); while($kr = mysqli_fetch_array($qKra)){ $empKRAid = $kr['id']; //1 2 3 $posKRAid=$kr['position_kra_id']; //1 2 3 $ckpCount=0; $sqlKpi = "SELECT * FROM `kpi_position` WHERE `deleted` = 0 AND `kra_id` ='$posKRAid' ORDER BY `kra_id` ASC"; $kpiExist = mysqli_query($conn,$sqlKpi); while($kpi=mysqli_fetch_array($kpiExist)){ $topKPIID=$kpi['id']; //1 //INSERT NEW KPI RECORD $posKraID = $kpi['kra_id']; $myKPIWeight=$kpi['kpi_weight']; $myKPITarget=$kpi['kpi_target']; $myKPIName=$kpi['kpi_name']; $myKPIDescription=$kpi['kpi_description']; $sqlKPI = "INSERT INTO kpi_employee ( `id`, `emp_id`, `position_kra_id`, `top_kpi_id`, `kra_id`, `kpi_weight`, `kpi_target`, `kpi_name`, `kpi_description`, `created_by`, `date_created`) VALUES ( '', '$empRecordID', '$posKraID', '$topKPIID', '$empKRAid', '$myKPIWeight', '$myKPITarget', '$myKPIName', '$myKPIDescription', '$userID', '$myTimeStamp')"; if ($conn->query($sqlKPI) === TRUE) { //echo "New record created successfully";top_kpi_id } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } } //RELOAD EMPLOYEE KRA LIST $activeRecordID = $_POST['SelectedRecordID']; $getKRAList = "SELECT * FROM `kra_employee_tbl` WHERE `deleted`=0 AND `emp_id` ='$activeRecordID' ORDER BY `kra_code` ASC"; //$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'"; $getKRA = mysqli_query($conn,$getKRAList); $statRow = mysqli_num_rows($getKRA); if($statRow > 0){ while($row = mysqli_fetch_array($getKRA)){ ?><tr onclick="javascript:getKRAinfo(this);" ><?php echo "<td style='width:5%;min-width:20px;padding-left:15px;font-weight:normal;color:$textColor'>".$row['position_kra_id']."</td>"; echo "<td style='width:10%;min-width:30px;padding-left:15px;font-weight:normal;color:$textColor'>".$row['weight']."</td>"; echo "<td style='width:10%;min-width:30px;padding-left:15px;font-weight:normal;color:$textColor'>".$row['kra_code']."</td>"; echo "<td style='width:10%;min-width:30px;padding-left:15px;font-weight:normal;color:$textColor'>".$stat."</td>"; echo "<td style='width:56%;min-width:200px;padding-left:15px;font-weight:normal;color:$textColor'>".$row['kra_name']."</td>"; echo "<td style='width:2%'>";?> <!--<abbr title='View KRA'><i class='fa fa-plus-circle' aria-hidden='true' style='cursor:pointer;color:green;float:right;font-size:18px'></i> </abbr>--> <i data-toggle="modal" data-target="#kpiModal" class="fa fa-list-ol" style='cursor:pointer;color:green;float:right;font-size:18px'></i> <?php echo "</td>"; echo "<tr>"; } } $conn->close(); } ?>

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