File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF_DASHBOARD_001.php

Back
<html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script src="https://canvasjs.com/assets/script/jquery.canvasjs.min.js"></script> <script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script> <?php include 'core/database/connect.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); error_reporting(0); $compID= $_GET['secondPassComID']; $dateTime = $myDate . " ".$toTime; $myEmpID = $user_data['u_id']; $toDate = date_create() ->format("Y-m-d"); $daDate = explode('-',$toDate); $dasYear = $daDate[0]; //One $janS = $dasYear."-01-01"; $janE = $dasYear."-01-31"; $febS = $dasYear."-01-01"; $febE = $dasYear."-02-28"; $marS = $dasYear."-03-01"; $marE = $dasYear."-03-31"; $aprS = $dasYear."-04-01"; $aprE = $dasYear."-04-30"; $mayS = $dasYear."-05-01"; $mayE = $dasYear."-05-31"; $junS = $dasYear."-06-01"; $junE = $dasYear."-06-30"; $julS = $dasYear."-07-01"; $julE = $dasYear."-07-31"; $augS = $dasYear."-08-01"; $augE = $dasYear."-08-31"; $sepS = $dasYear."-09-01"; $sepE = $dasYear."-09-30"; $octS = $dasYear."-10-01"; $octE = $dasYear."-10-31"; $novS = $dasYear."-11-01"; $novE = $dasYear."-11-30"; $decS = $dasYear."-12-01"; $decE = $dasYear."-12-31"; if(isset($_POST['done'])){ //GROUP WIDE //$getData = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `item_status` > 3"); $getData = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `item_status`!='0' AND `date_created` BETWEEN '$janS' AND '$decE'"); while($row=mysql_fetch_array($getData)){ $olddate = $row['date_created']; $endDate = $toDate; if($endDate != ""){ $myEndDate = strtotime($endDate); }else{ $myEndDate = time(); } $slaStart = strtotime($olddate); $datediff = $myEndDate - $slaStart; $totalCount = round($datediff / (60 * 60 * 24)); //$totalCount= round($datediff / (60 * 60 * 24)); echo $totalCount."xxx<br>"; if($totalCount < 32){ $green = $green + 1; } if ($totalCount > 31 && $totalCount < 61){ $orange = $orange + 1; } if ($totalCount > 60 && $totalCount < 91){ $red = $red + 1; } if ($totalCount > 90){ $fullred = $fullred + 1; } $total = $green + $orange + $red + $fullred; } $EarlyCount = number_format(($green / $total * 100),2,'.',','); $MidCount = number_format(($orange / $total * 100),2,'.',','); $LateCount = number_format(($red / $total * 100),2,'.',','); $SuperLateCount = number_format(($fullred / $total * 100),2,'.',','); $forCanvass = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='4' AND `deleted` = 0"),0); $forApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='8' AND `deleted` = 0 "),0); //PO APPROVAL $userApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval`=1 AND `user_approval_ts`=''"),0); $execomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='6' AND `deleted` = 0"),0); $forDelivery = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='9' AND `deleted` = 0"),0); $newIncoming = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`<4 AND `deleted` = 0"),0); }else{ //GROUP WIDE $getData = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `item_status`!=0"); while($row=mysql_fetch_array($getData)){ $olddate = $row['date_created']; $endDate = $toDate; if($endDate != ""){ $myEndDate = strtotime($endDate); }else{ $myEndDate = time(); } $slaStart = strtotime($olddate); $datediff = $myEndDate - $slaStart; $totalCount = round($datediff / (60 * 60 * 24)); //$totalCount= round($datediff / (60 * 60 * 24)); //echo $totalCount."<br>"; if($totalCount < 30){ $green = $green + 1; } if ($totalCount > 30 && $totalCount < 61){ $orange = $orange + 1; } if ($totalCount > 60 && $totalCount < 91){ $red = $red + 1; } if ($totalCount > 90){ $fullred = $fullred + 1; } $total = $green + $orange + $red + $fullred; } //$EarlyCount = number_format(($green),0,'.',''); //$MidCount = number_format(($orange),0,'.',''); //$LateCount = number_format(($red),0,'.',''); //$SuperLateCount = number_format(($fullred),2,'.',','); $EarlyCount = number_format(($green / $total * 100),2,'.',','); $MidCount = number_format(($orange / $total * 100),2,'.',','); $LateCount = number_format(($red / $total * 100),2,'.',','); $SuperLateCount = number_format(($fullred / $total * 100),2,'.',','); $forCanvass = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`=4 AND `deleted` = 0"),0); $forApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`=8 AND `deleted` = 0"),0); $userApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval`=1 AND `user_approval_ts`=''"),0); $execomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`='6' AND `deleted` = 0"),0); $forDelivery = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`=9 AND `deleted` = 0"),0); $newIncoming = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status`<4 AND `deleted` = 0"),0); } //echo $green. " \| " .$orange. " \| " .$red. " \| " .$fullred; ?> <script> //window.onload = function (){ //alert('test'); //LoadGraph(); //StopLoadGraph(); //} var idVar = setInterval(() => { LoadGraph(); }, 400); function StopLoadGraph() { clearInterval(idVar); } function LoadGraph() { CanvasJS.addColorSet("greenShades", [//colorSet Array "#05c80b", //green "#ef990b", //orange "#f19197", // red "#5fe4bc", // purple "#f37f05", // purple "#f30f92", // purple "#f1b2db", // purple "#ef220b", //orange "#ef9c5b", //orange "#55c05b", //green "#e84b8e", // red "#f5d823", // yellow "#f3d284", // yellow "#f9b5db", // purple "#f9c5ba", // purple "#93b0f9", //lightblue "#33b4f1" //lightblue ]); CanvasJS.addColorSet("greenShadesB", [//colorSet Array "#05c80b", //green "#ef990b", //orange "#f19197", // red "#5fe4bc", // purple "#f37f05", // purple "#f30f92", // purple "#f1b2db", // purple "#ef220b", //orange "#ef9c5b", //orange "#55c05b", //green "#e84b8e", // red "#f5d823", // yellow "#f3d284", // yellow "#f9b5db", // purple "#f9c5ba", // purple "#93b0f9", //lightblue "#33b4f1" //lightblue ]); var options = { colorSet: "greenShadesB", title: { text: "ACTIVE REQUEST", fontFamily: "Yu Gothic", fontSize:18, fontWeight: "bold" }, subtitles: [{ fontFamily: "Yu Gothic Light", fontSize:12, text:"By Status" }], animationEnabled: false, animationDuration: 100, data: [{ type: "doughnut", startAngle: 40, toolTipContent: "<b>{label}</b>: {y}", showInLegend: "true", legendText: "{label}", indexLabelFontSize: 12, indexLabel: "{label} - {y}", dataPoints: [ { y: <?php echo $forCanvass;?>, label: "For Canvass"}, { y: <?php echo $userApproval;?>, label: "User ApprovalX"}, { y: <?php echo $execomApproval;?>, label: "EXECOM Approval"}, { y: <?php echo $forApproval;?>, label: "PO Approval"}, { y: <?php echo $forDelivery;?>, label: "For Delivery"}, { y: <?php echo $newIncoming;?>, label: "New (Incoming)"}, ] }] }; $("#activeSLA").CanvasJSChart(options); //================================= //================================= var options = { colorSet: "greenShades", title: { text: "COMPLIANCE RATE", fontFamily: "Yu Gothic", fontSize:16, fontWeight: "bold" }, subtitles: [{ fontFamily: "Yu Gothic Light", fontSize:12, text:"Turn-Around-Time" }], animationEnabled: false, animationDuration: 1500, backgroundColor: "#fff", data: [{ type: "stackedBar", startAngle: 40, toolTipContent: "<b>{label}</b>", showInLegend: "true", legendText: "AUTOHUB WIDE", indexLabelFontSize: 12, indexLabel: "{y}", dataPoints: [ { y: <?php echo $EarlyCount;?>, label: "1-30 Days $%$"}, { y: <?php echo $MidCount;?>, label: "31-60 Days $%$" }, { y: <?php echo $LateCount;?>, label: "61-90 Above $%$" }, { y: <?php echo $SuperLateCount;?>, label: "91 Above $%$" }, ] }] }; $("#slaAnalysis").CanvasJSChart(options); //STOCK INVENTORY ANALYSIS BY MODEL var options = { colorSet: "greenShades", animationEnabled: false, animationDuration: 2000, backgroundColor: "#fff", title: { text: "REQUEST SUMMARY", fontFamily: "Yu Gothic", fontSize:16, fontWeight: "bold" }, subtitles: [{ fontFamily: "Yu Gothic Light", fontSize:13, text:"By Company" }], data: [ { // Change type to "doughnut", "line", "splineArea", etc. area, stepLine,scatter, bubble , stackedColumn, stackedBar, stackedArea,stackedColumn100,doughnut type: "column", toolTipContent: "{label}", showInLegend: "true", legendText: "COMPANY", indexLabelFontSize: 10, indexLabel: "{y}", dataPoints: [ <?php if(isset($_POST['done'])){ $SearchTextEnd = mysql_escape_string($_POST['SearchTextEnd']); $SearchTextStart = mysql_escape_string($_POST['SearchTextStart']); $getDataA = mysql_query("SELECT * FROM `vts_company` WHERE 1 ORDER BY `comp_code` ASC"); $totalCountItem = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status` < 11 AND `item_status` != 0 AND `deleted`=0"),0); while($row=mysql_fetch_array($getDataA)){ $clCompID = $row['comp_id']; $countBrand = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `comp_id`='$clCompID' AND `item_status` != '0' AND `deleted`=0"),0); $countBrandx = number_format((($countBrand /$totalCountItem) 100),2,'.',','); echo "{ label: \"".$row['comp_code']."\", y: ".$countBrand."},"; } }else{ $getDataA = mysql_query("SELECT FROM `vts_company` WHERE 1 ORDER BY `comp_code` ASC"); $totalCountItem = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status` < 10 AND `item_status` != '0' AND `deleted`='0'"),0); while($row=mysql_fetch_array($getDataA)){ $clCompID = $row['comp_id']; $countBrand = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `comp_id`='$clCompID' AND `item_status` != '0' AND `deleted`=0"),0); $countBrandx = number_format((($countBrand /$totalCountItem) 100),2,'.',','); echo "{ label: \"".$row['comp_code']."\", y: ".$countBrand."},"; } } ?> //<?php echo "{ label: \"apple\", y: 10 },";?> //{ label: "orange", y: 15 }, //{ label: "banana", y: 25 }, //{ label: "mango", y: 30 }, //{ label: "grape", y: 28 } ] } ] }; //================================= $("#slaCount").CanvasJSChart(options); //============================================================= var chart = new CanvasJS.Chart("expenseData", { animationEnabled: true, theme: "light2", title:{ fontFamily: "Yu Gothic Light", fontSize:18, text: "EXPENSE SUMMARY" }, subtitles: [{ fontFamily: "Yu Gothic Light", fontSize:16, text:"<?php echo 'Year '.$dasYear;?>" }], data: [{ type: "column", indexLabelFontSize: 14, dataPoints: [ <?php $getCom=mysql_query("SELECT FROM `vts_company` WHERE `comp_status`= 1"); while($eRow=mysql_fetch_array($getCom)){ $comCount=0; $comCount = mysql_result(mysql_query("SELECT SUM(invoice_amount) FROM `prf_request_detl` WHERE `deleted`='0' AND `po_code`!='' AND `comp_id`='".$eRow['comp_id']."'"),0); if($comCount ==''){$comCount=0;} echo "{ label: \"".$eRow['comp_code']."\", y: ".$comCount."},"; } ?> //{ y: 450 }, //{ y: 414}, //{ y: 520, indexLabel: "\u2191 highest",markerColor: "red", markerType: "triangle" }, //{ y: 460 }, //{ y: 450 }, //{ y: 500 }, //{ y: 480 }, //{ y: 480 }, //{ y: 410 , indexLabel: "\u2193 lowest",markerColor: "DarkSlateGrey", markerType: "cross" }, //{ y: 500 }, //{ y: 480 }, //{ y: 510 } ] }] }); chart.render(); //============================================================= StopLoadGraph(); }; function showFormTitle(){ $("#formTitle").fadeIn(500); }; function hideFormTitle(){ $("#formTitle").fadeOut(500); }; </script> </head> <body> <div class='DashboardTileA'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $unVerifyRequest = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `current_status` < 4 AND `deleted`='0'"),0); //mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `current_status` < 4 AND `deleted`=0"),0); echo $unVerifyRequest; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> INCOMING </div> <div id='forIncomingXXX' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileB'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $forCanvassItem = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval` = 0 AND `item_status`=4"),0); echo $forCanvassItem; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> FOR CANVASS </div> <div id='forCanvassDB' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileBa'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $userApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status` = 5 AND `deleted`='0'"),0); echo $userApproval; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> USER APPROVAL </div> <div id='xxxx' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileBb'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $execomApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status` = 6 AND `deleted`='0'"),0); echo $execomApproval; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> EXECOM APPROVAL </div> <div id='execomxxx' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileEa'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $forPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`=''"),0); echo $forPO; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> PO Creation </div> <div id='poCreation' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileC'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; //$forPOItem = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `item_status` = 8 AND `deleted`=0"),0); $forPOApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status` BETWEEN 1 AND 2"),0); echo $forPOApproval; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> PO APPROVAL </div> <div id='poApproval' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileD'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $forPOItem = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status` = 4"),0); echo $forPOItem; ?> </div> <div class='DashboardTileCountAA'> <div class='DashboardTileCountAb'> FOR DELIVERY </div> <div id='forDelivery' class='DashboardTileCountAbb'><BR> View Details </div> </div> </div> <div class='DashboardTileE'> <div class='DashboardTileCountA'> <?php include_once 'core/init.php'; protected_page(); $OBLADM = $user_data['OBL_ADM']; $userID=$user_data['u_id']; $comID=$user_data['company']; $forPaymentPO = mysql_result(mysql_query("SELECT COUNT(1) FROM (SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number`) t1 "),0); echo $forPaymentPO; ?> </div> <div class='DashboardTileCountAA'> <div id='forPayment' class='DashboardTileCountAb'> FOR PAYMENT </div> <div id='paymentView' class='DashboardTileCountAbb'><br> View Details </div> </div> </div> <!--#######################################################################################################################################--> <BR> <div style='border:0px solid red;width:100%;height:815px;min-height:600px;float:left;margin:5px;background:white'> <div style='vertical-align:top;height:55px;margin:0px;width:100%;border-bottom:1px solid gray;padding:5px;font-family:Yu Gothic;font-weight:normal;color:gray;font-size:30px;text-align:center'> <?php echo "PURCHASE REQUEST";?><br><br> </div> <div id="activeSLA" style="height: 370px; width: 40%;margin:5px;border:0px solid gray;float:left;border-bottom:1px solid gray"></div> <div id="slaAnalysis" style="height: 370px; width: 40%;margin:5px;border:0px solid gray;float:right;border-bottom:1px solid gray"></div> <div id="slaCount" style="background:#ffffff;height: 400px; width:100%;margin:5px;margin-top:50px;margin-bottom:50px;border:0px solid gray;float:left;border-bottom:1px solid gray"></div> <div id="expenseData" style="background:#ffffff;height:400px; width:100%;margin:5px;margin-top:50px;margin-bottom:50px;border:0px solid gray;float:left;border-bottom:1px solid gray"></div> </div> </body> </html> <!--- LOCALIZED COPY OF JAVASCRIPT <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-3.6.0.js"></script> <script type="text/javascript"> $(document).ready(function(){ //======================================================================================================================================= $("#poCreation").click(function(){ ShowUploadBar(); $.ajax({ url: "PRF_ReadyForPO.php", type: "POST", async: false, data: { }, success: function(d){ ShowUploadBar(); //invShowAssignMsg(); $("#cleranceTemplateView").html(d); //invHideAssignMsg(); //$('#searchText').val(''); } }) }); //====================================================================================================== $("#paymentView").click(function(){ //var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); //alert('alert'); //exit; ShowUploadBar(); $.ajax({ url: "PRF_FORPAYMENT.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ ShowUploadBar(); $("#cleranceTemplateView").html(d); } }) }); //====================================================================================================== $("#poApproval").click(function(){ //var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); //alert('alert'); //exit; ShowUploadBar(); $.ajax({ url: "PRF_POFORAPPROVAL.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ ShowUploadBar(); $("#cleranceTemplateView").html(d); } }) }); //====================================================================================================== $("#forDelivery").click(function(){ //var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); //alert('alert'); //exit; ShowUploadBar(); $.ajax({ url: "PRF_ACTIVESUPPLIERSPO.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ ShowUploadBar(); $("#cleranceTemplateView").html(d); } }) }); //====================================================================================================== $("#forCanvassDB").click(function(){ //var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); //alert('alert'); //exit; ShowUploadBar(); $.ajax({ url: "PRF_FORCanvass.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ ShowUploadBar(); $("#cleranceTemplateView").html(d); } }) }); //====================================================================================================== $("#forIncoming").click(function(){ //var selectedPRFHeaderID = $("#selectedPRFHeaderID").val(); //alert('alert'); //exit; ShowUploadBar(); $.ajax({ url: "PRF_procIncomingInfo.php", type: "POST", async: false, data: { "done": 1 }, success: function(d){ ShowUploadBar(); $("#cleranceTemplateView").html(d); } }) }); //====================================================================================================== });

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