File manager

File manager - Edit - /home/autoph/public_html/connect/home/REPORTS/CL_REPORTL.php

Back
<?php date_default_timezone_set('Asia/Singapore'); $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee10244') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); mysql_connect('localhost','autoph_arnel','Hke@2001') or die ($connect_error); mysql_select_db('autoph_connect') or die($connect_error); $prfDate = date_create() ->format("Y-m-d"); error_reporting(0); $comID = $_GET['cID']; $userID = $_GET['uID']; $sDate = $_GET['ksDate']; $eDate = $_GET['keDate']; $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$comID'"),0); $FName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$userID'"),0); $LName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$userID'"),0); $totalCount = mysql_result(mysql_query("SELECT COUNT(1) FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"),0); $totalClosed = mysql_result(mysql_query("SELECT COUNT(1) FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='CLOSED' AND `cl_lastpay_released_date` BETWEEN '$sDate' AND '$eDate'"),0); $totalOpen = $totalCount - $totalClosed;//mysql_result(mysql_query("SELECT COUNT(1) FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_h_hr_approval`!='CLOSED' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"),0); mysql_query("DROP TABLE IF EXISTS `CL_TAT_Summary`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Summary` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); //$getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVEd' AND `cl_h_hr_approval`='CLOSED' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate' AND `cl_sla_start` < `cl_lastpay_released_date`"); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_h_hr_approval`='CLOSED' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate' AND `cl_sla_start`!='' AND `cl_sla_end`!=''"); while($rowA=mysql_fetch_array($getClearanceHead)){ $coStartDateTSH = $rowA['cl_sla_start']; if($rowA['cl_completion_date'] == ''){ $coEndDateH = strtotime($prfDate); }else{ $coEndDateH = strtotime($rowA['cl_completion_date']); } $your_dateH = strtotime($coStartDateTSH); $datediffH = $coEndDateH - $your_dateH; $mandaysH = round($datediffH / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Summary (id,days) VALUES('','$mandaysH')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $totalFast = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Summary` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); $totalAverageSUM = mysql_result(mysql_query("SELECT SUM(`days`) FROM `CL_TAT_Summary` WHERE `days`!=''"),0); $totalAverageCOUNT = mysql_result(mysql_query("SELECT COUNT(id) FROM `CL_TAT_Summary` WHERE `days`!=''"),0); $totalAverage = $totalAverageSUM / $totalAverageCOUNT; $totalSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Summary` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); $totalSlowS = number_format($totalSlow,1,'.',''). " Days"; $totalFastS = number_format($totalFast,1,'.',''). " Days"; $totalAverageS = number_format($totalAverage,1,'.','')." Days"; if($_GET['AutohubWide']==='No'){ $title = $compName; }else{ $title = "AUTOHUB WIDE"; } ?> <html> <head> <style> .tBalls{ font-familyly:Arial; font-size:12px; font-weight:bold; padding:5px border:0px solid gray; background:lightgray; } </style> </head> <script type="text/javascript"> function ShowUploadBar() { var div = document.getElementById("loadBaraData"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } </script> <!--#########################################################################--> <div id="loadBaraData" style="display:none;position:fixed;top:40%;left:45%;width:50px;padding:5px;padding-left:2px;padding-right:2px;height:50px;background:transparent;z-index:9999;border:0px solid gray;z-index:999999999999999999"> <div id="uploadBar" style="padding-bottom:5px;font-family:Yu Gothic Light;font-size:14px;color: #d109b0;font-weight:normal ;text-align:center;margin-top:0px;background:#ffffff ;display:block;width:100px;height:95px;border-radius:10px;position:relative;left:5px;padding:8px;z-index:999999999999999999;border:1px solid gray "> <img src='../images/ajaxLoader2.gif' width="auto" height="auto" style='margin:10px;margin-bottom:5px'/><center>Please wait<center></div> </div> <!--#########################################################################--> <script type="text/javascript"> ShowUploadBar(); </script> <?php echo "<center>"; echo "<div style='width:850px;height:120px;border-bottom:0px solid gray;background:white;text-align:left'>"; echo "<div style='float:left;width:50%;height:130px;border-bottom:0px solid gray;background:white;text-align:left'>"; echo "<img src='../images/autohub_logo_2016.png' border='0px solid blue' style='margin:5%'></img>"; echo "</div>"; echo "<div style='float:left;width:50%;height:130px;border:0px solid gray;background:white;text-align:right;'>"; echo "<p style='font-familyly:Arial;font-size:20px;font-weight:bold;padding:5%;padding-bottom:0px;border:0px solid red;margin-bottom:5px;'>CLEARANCE SUMMARY</p> <b style='font-familyly:Arial;font-size:16px;font-weight:normal;padding:5%;padding-top:0px;padding-bottom:0px;margin-top:0px;border:0px solid red'>".$title."</b>"; echo " <b style='font-familyly:Arial;font-size:14px;font-weight:normal;padding-right:5%;padding-top:0px;padding-bottom:0px;margin-top:10px;border:0px solid red'> <br>Date: ".date("m/d/Y")."</b>"; echo "</div>"; echo "</div>"; //############################################################################################### start date cl_hr_approval_timestamp End Date cl_completion_ echo "<div style='height:80px;width:850px;border:0px solid gray;padding:0px'>"; echo "<b style='font-family:Calibri;font-size:24px;color:black'>PERFORMANCE ANALYSIS</b>"; echo "<p style='padding:0px;margin:0px;margin-bottom:40px;font-family:Calibri;font-size:14px;'>Period Covered: ".$sDate." - ".$eDate."</p>"; echo "</div>"; echo "<div style='width:850px;border:0px solid red;padding:0px'>"; //########################################################################################## echo "<div style='float:left;width:94.5%;padding:1px;border:0px solid gray;text-align:left;background:transparent;margin-top:15px;font-family:Yu GOthic Light'>"; echo "<b style='padding:1px;font-family:Yu GOthic Light'>Clearance Inventory:</b>"; echo "</div>"; echo "<div style='float:left;width:29%;padding:15px;border:1px solid gray;text-align:left'>"; echo "<b style='background:white;padding:5px;font-weight:normal;font-family:Yu GOthic Light'>Clearance Created:</b>"; echo "<b style='background:yellow;padding:5px;padding-left:20px;padding-right:20px'>".$totalCount."</b>"; echo "</div>"; echo "<div style='float:left;width:29%;padding:15px;border:1px solid gray;border-left:0px;border-right:0px;text-align:left'>"; echo "<b style='background:white;padding:5px;font-weight:normal;font-family:Yu GOthic Light'>Closed/Completed:</b>"; echo "<b style='background:yellow;padding:5px;padding-left:20px;padding-right:20px'>".$totalClosed."</b>"; echo "</div>"; echo "<div style='float:left;width:29%;padding:15px;border:1px solid gray;text-align:left'>"; echo "<b style='background:white;padding:5px;font-weight:normal;font-family:Yu GOthic Light'>Pending/On-Going:</b>"; echo "<b style='background:yellow;padding:5px;padding-left:20px;padding-right:20px'>".$totalOpen."</b>"; echo "</div>"; //########################################################################################## echo "<div style='float:left;width:94.5%;padding:1px;border:0px solid gray;text-align:left;background:transparent;margin-top:15px;font-family:Yu GOthic Light'>"; echo "<b style='padding:1px;font-family:Yu GOthic Light'>Turn-Around Time Analysis:</b>"; echo "</div>"; echo "<div style='float:left;width:32.2%;padding:1px;border:1px solid gray;text-align:left;background:#e6f7cb;margin-top:5px;font-family:Yu GOthic Light'>"; echo "<div style='font-family:Yu Gothic Light;font-size:14px;padding:10px;padding-top:3px;float:left;width:100%;'>SHORTEST:</div>"; echo "<div style='width:100%;font-family:Yu Gothic Light;font-size:24px;padding:10px;padding-top:3px;text-align:center;font-weight:bold'>".$totalFastS."</div>"; echo "</div>"; echo "<div style='float:left;width:32.2%;padding:1px;border:1px solid gray;text-align:left;background:#fee2b2;margin-top:5px;font-family:Yu GOthic Light;border-left:0px;border-right:0px'>"; echo "<div style='font-family:Yu Gothic Light;font-size:14px;padding:10px;padding-top:3px;float:left;width:100%;'>AVERAGE:</div>"; echo "<div style='width:100%;font-family:Yu Gothic Light;font-size:24px;padding:10px;padding-top:3px;text-align:center;font-weight:bold'>".$totalAverageS."</div>"; echo "</div>"; echo "<div style='float:left;width:32.2%;padding:1px;border:1px solid gray;text-align:left;background:#fb9363;margin-top:5px;font-family:Yu GOthic Light'>"; echo "<div style='font-family:Yu Gothic Light;font-size:14px;padding:10px;padding-top:3px;float:left;width:100%;'>LONGEST:</div>"; echo "<div style='width:100%;font-family:Yu Gothic Light;font-size:24px;padding:10px;padding-top:3px;text-align:center;font-weight:bold'>".$totalSlowS."</div>"; echo "</div>"; //########################################################################################## echo "<div style='float:left;width:94.5%;padding:1px;border:0px solid gray;text-align:left;background:transparent;margin-top:25px;font-family:Yu GOthic Light'>"; echo "<b style='padding:1px;font-family:Yu GOthic Light'>TRANSACTION TURN-AROUND TIME ANALYSIS:</b>"; echo "</div>"; //########################################################################################## echo "<div style='float:left;padding-top:0px;width:830px;border:0px solid red'>"; echo "<table style='border-collapse:collapse;width:100%;'>"; echo "<thead>"; echo "<th style='border-right:1px solid gray;text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:10px;width:40%'>CLEARANCE PROCESS</th>"; echo "<th style='border-right:1px solid gray;text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:10px;width:20%'>SHORTEST</th>"; echo "<th style='border-right:1px solid gray;text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:10px;width:20%'>AVERAGE</th>"; echo "<th style='text-align:left;font-family:Calibri;font-size:12px;color:white;background:black;padding:10px;width:20%'>LONGEST</th>"; echo "</thead>"; echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>CLEARING OFFICER</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`='CLOSED' AND `cl_h_hr_approval`='CLOSED' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate' AND `cl_sla_start`!='' AND `cl_sla_end`!=''"); while($rowA=mysql_fetch_array($getClearanceHead)){ $coStartDateTS = strtotime($rowA['cl_sla_start']); //$coStartDateEx =explode(" ",$coStartDateTS); //$coStartDate=$coStartDate[0]; //if($rowA['signatory_completion_date'] == ''){ // $coEndDate = strtotime($prfDate); //}else{ $coEndDate = strtotime($rowA['signatory_completion_date']); //} //$your_date = strtotime($coStartDateTS); $datediff = $coEndDate - $coStartDateTS; $mandays = round($datediff / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } //$coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); $coFast = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFast > 1){$pluralText ='Days';}else{$pluralText ='Day';} $coAverageCount = mysql_result(mysql_query("SELECT COUNT(`1`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); //$coAverage = number_format(($coAverageSUM / $coAverageCount),1,'.',','); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','')." ".$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>RECOMMENDING OFFICERS</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `signatory_completion_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate' AND `cl_recommender_a_timestamp` !='' \|\| `cl_h_hr_approval`!='DISAPPROVED' AND `signatory_completion_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate' AND `cl_recommender_b_timestamp` !=''"); while($rowB=mysql_fetch_array($getClearanceHead)){ $rcStartDateTS = $rowB['signatory_completion_date']; $recoA = $rowB['cl_recommender_a_timestamp']; $recoB = $rowB['cl_recommender_b_timestamp']; if($recoB==''){ $endDate = $recoA; }else{ $endDate = $recoB; } $recoAeX=explode(" ",$endDate); $myEndDate = strtotime($recoAeX[0]); $clearanceCompletionDate = strtotime($rcStartDateTS); $datediff = $myEndDate - $clearanceCompletionDate; $mandays = round($datediff / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverageCount = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFastA,1,'.',',').$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverageCount,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>APPROVING OFFICERS</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `signatory_completion_date`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_recommender_b_timestamp`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ //GetLastRecommending officer date $startDateA =$rowB['cl_recommender_a_timestamp']; $startDateB =$rowB['cl_recommender_b_timestamp']; $exStartA=explode(" ",$startDateA); $myStartDateA = $exStartA[0]; $exStartB=explode(" ",$startDateB); $myStartDateB = $exStartB[0]; if($myStartDateA > $myStartDateB){ $myTrueStartDate = $myStartDateA; }else{ $myTrueStartDate = $myStartDateB; } //echo $myTrueStartDate."<br>"; //Get LastApproving officer date $startAprDateAdum =$rowB['cl_approver_id_timestamp']; if($startAprDateAdum==''){ $startAprDateA=$prfDate; } else{ $startAprDateA=$rowB['cl_approver_id_timestamp']; } $startAprDateBdum =$rowB['cl_approver_id_b_timestamp']; if($startAprDateBdum==''){ $startAprDateB=$prfDate; } else{ $startAprDateB=$rowB['cl_approver_id_b_timestamp']; } $exStartAprA=explode(" ",$startAprDateA); $myStartAprDateA = $exStartAprA[0]; $exStartAprB=explode(" ",$startAprDateB); $myStartAprDateB = $exStartAprB[0]; if($myStartAprDateA > $myStartAprDateB){ $myTrueAprStartDate = $myStartAprDateA; }else{ $myTrueAprStartDate = $myStartAprDateB; } //echo $myTrueAprStartDate."<br>"; $approvalDate = strtotime($myTrueAprStartDate); $recommendedDate = strtotime($myTrueStartDate); $datediff = $approvalDate - $recommendedDate; $mandays = round($datediff / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverageCount = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); //echo $coEndDate . "-".$your_date;; echo number_format($coFastA,1,'.','').$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverageCount,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>LASTPAY COMPUTATION</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `signatory_completion_date`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_recommender_b_timestamp`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ //Get LastApproving officer date $startAprDateAdum =$rowB['cl_approver_id_timestamp']; if($startAprDateAdum==''){ $startAprDateA=$prfDate; }else{ $startAprDateA=$rowB['cl_approver_id_timestamp']; } $startAprDateBdum =$rowB['cl_approver_id_b_timestamp']; if($startAprDateBdum==''){ $startAprDateB=$prfDate; } else{ $startAprDateB=$rowB['cl_approver_id_b_timestamp']; } $exStartAprA=explode(" ",$startAprDateA); $myStartAprDateA = $exStartAprA[0]; $exStartAprB=explode(" ",$startAprDateB); $myStartAprDateB = $exStartAprB[0]; if($myStartAprDateA > $myStartAprDateB){ $myTrueAprStartDate = $myStartAprDateA; }else{ $myTrueAprStartDate = $myStartAprDateB; } $coEndDateSX = $rowB['cl_computation_date']; if($coEndDateSX==''){ $coEndDateS=$prfDate; }else{ $coEndDateS=$rowB['cl_computation_date']; } $your_date = strtotime($myTrueAprStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast ==0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','').$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>EMPLOYEE APPROVAL</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_computation_date`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_recommender_b_timestamp`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ $getRawStartDate =$rowB['cl_computation_date']; $getRawEndDate =$rowB['cl_lastpay_approved_date']; if($getRawEndDate==''){ $coEndDateS=$prfDate; } else{ $coEndDateS=$rowB['cl_lastpay_approved_date']; } // echo $getRawEndDate. "-".$getRawStartDate; $your_date = strtotime($getRawStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast ==0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','').$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>CHECK REQUEST PREPARATION</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_computation_date`!='' AND `cl_lastpay_approved_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ $getRawStartDate =$rowB['cl_lastpay_approved_date']; $getRawEndDate =$rowB['cl_lastpay_check_request_date']; if($getRawEndDate==''){ $coEndDateS=$prfDate; } else{ $coEndDateS=$rowB['cl_lastpay_check_request_date']; } // echo $getRawEndDate. "-".$getRawStartDate; $your_date = strtotime($getRawStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast ==0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.',',')." ".$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>CHECK RELEASING</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_lastpay_check_request_date`!='' AND `cl_lastpay_check_created_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ $getRawStartDate =$rowB['cl_lastpay_check_request_date']; $getRawEndDate =$rowB['cl_lastpay_check_created_date']; if($getRawEndDate==''){ $coEndDateS=$prfDate; } else{ $coEndDateS=$rowB['cl_lastpay_check_created_date']; } $your_date = strtotime($getRawStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); //echo $getRawStartDate. "-".$coEndDateS." - ".$mandays."<br>"; $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast ==0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','')." ".$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>HR DOCUMENTATION AND RECORDING</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_lastpay_check_created_date`!='' AND `cl_lastpay_documented_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ $getRawStartDate =$rowB['cl_lastpay_check_created_date']; $getRawEndDate =$rowB['cl_lastpay_documented_date']; if($getRawEndDate==''){ $coEndDateS=$prfDate; } else{ $coEndDateS=$rowB['cl_lastpay_documented_date']; } $your_date = strtotime($getRawStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); //echo $getRawStartDate. "-".$coEndDateS." - ".$mandays."<br>"; $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } //$coFast = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast ==0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','')." ".$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>SCHEDULED OF RELEASE TO EMPLOYEE</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_lastpay_documented_date`!='' AND `cl_lastpay_schedule_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ $getRawStartDate =$rowB['cl_lastpay_documented_date']; $getRawEndDate =$rowB['cl_lastpay_schedule_date']; if($getRawEndDate==''){ $coEndDateS=$prfDate; } else{ $coEndDateS=$rowB['cl_lastpay_schedule_date']; } $your_date = strtotime($getRawStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); //echo $getRawStartDate. "-".$coEndDateS." - ".$mandays."<br>"; $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast == 0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days` > 0"),0); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','')." ".$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; //########################################################################################## echo "<tr>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>DATE CLAIMED BY EMPLOYEE</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>"; mysql_query("DROP TABLE IF EXISTS `CL_TAT_Analysis`"); $sql = "CREATE TABLE IF NOT EXISTS `CL_TAT_Analysis` (`id` int(11) NOT NULL AUTO_INCREMENT, `days` int(4) NOT NULL,PRIMARY KEY (`id`))"; $sqlResponse = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $getClearanceHead = mysql_query("SELECT * FROM`cl_clearance_header` WHERE `cl_h_hr_approval`!='DISAPPROVED' AND `cl_lastpay_schedule_date`!='' AND `cl_lastpay_schedule_date`!='' AND `cl_sla_start` BETWEEN '$sDate' AND '$eDate'"); while($rowB=mysql_fetch_array($getClearanceHead)){ $getRawStartDate =$rowB['cl_lastpay_schedule_date']; $getRawEndDate =$rowB['cl_date_of_release']; if($getRawEndDate==''){ $coEndDateS=$prfDate; } else{ $coEndDateS=$rowB['cl_date_of_release']; } $your_date = strtotime($getRawStartDate); $coEndDate = strtotime($coEndDateS); $datediff = $coEndDate - $your_date; $mandays = round($datediff / (60 * 60 * 24)); //echo $getRawStartDate. "-".$coEndDateS." - ".$mandays."<br>"; $sql = "INSERT INTO CL_TAT_Analysis (id,days) VALUES('','$mandays')"; $sqlQuery = mysql_query($sql) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } $coFastA = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` ASC LIMIT 1"),0); if($coFastA < 0){ $coFast ==0; }else{ $coFast = $coFastA; } if($coFast > 1){$pluralText =' Days';}else{$pluralText =' Day';} //$coAverageCount = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); $coAverage = mysql_result(mysql_query("SELECT AVG(`days`) FROM `CL_TAT_Analysis` WHERE `days`!='' AND `days`> 0"),0); //$coAverage = number_format(($coAverageSUM / $coAverageCount),1,'.',','); $coSlow = mysql_result(mysql_query("SELECT `days` FROM `CL_TAT_Analysis` WHERE `days`!='' ORDER BY `days` DESC LIMIT 1"),0); echo number_format($coFast,1,'.','')." ".$pluralText; echo"</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coAverage,1,'.','')." Days</td>"; echo "<td style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray'>". number_format($coSlow,1,'.','')." Days </td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='4' style='font-family:Calibri;font-size:12px;color:black;padding:10px;border:1px solid gray;height:50px'></td>"; echo "</tr>"; echo "</div>"; echo "</div>"; echo "</center>"; ?> <script type="text/javascript"> ShowUploadBar(); </script>

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