File manager

File manager - Edit - /home/autoph/public_html/connect/home/report_load_RPTa.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','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); error_reporting(1); //if submit/ save to databasevar ` if(isset($_POST['done'])){ $addDate = mysql_escape_string($_POST['addDate']); $addTime = mysql_escape_string($_POST['addTime']); $addBy = mysql_escape_string($_POST['addBy']); //$carPlate = mysql_escape_string($_POST['carPlate']); //$vPlateA = str_replace(' ', '', $carPlate); //$textPlate = str_replace('-', '', $vPlateA); $MyDealID = mysql_escape_string($_POST['MyDealID']); $MyCompID = mysql_escape_string($_POST['MyCompID']); $apptDate = mysql_escape_string($_POST['apptDate']); $newApptDate = date_format(date_create_from_format('Y-m-d', $apptDate), 'Y/m/d'); $newApptDate = date_format(date_create_from_format('m/d/Y', $apptDate), 'Y/m/d'); exit(); } //display from database ?> <center><button onclick="printDiv('PrintaBle')" style="margin:10px;">Print Report</button> <br><br></center> <br><br><br> <script> function printDiv(divName){ var printContents = document.getElementById(divName).innerHTML; var originalContents = document.body.innerHTML; document.body.innerHTML = printContents; window.print(); document.body.innerHTML = originalContents; } </script> <?php //display from database if(isset($_POST['display'])){ $eDate = $_POST['eDate']; $sDate = $_POST['sDate']; $svUserID = mysql_escape_string($_POST['svUserID']); $sCompID = mysql_escape_string($_POST['sCompID']); $sDealID = mysql_escape_string($_POST['sDealID']); $StartApptDate =str_replace('-', '/', $sDate); $EndApptDate = str_replace('-', '/', $eDate); $uLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$svUserID'"),0); $uFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$svUserID'"),0); $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$sDealID'"),0); $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$sCompID'"),0); $begin = new DateTime($StartApptDate); $end = new DateTime($EndApptDate); $interval = DateInterval::createFromDateString('1 day'); $period = new DatePeriod($begin, $interval, $end); echo "<div id='PrintaBle' style='height:100%;width:100%'>"; echo "<img src='images/autohub_logo_2016.png' width='100px' border='0px solid white'></img><br> <b style='font-family:Verdana;font-size:18px;color:black'>".$companyName."</b><br> <b style='font-family:Verdana;font-size:12px;color:black;font-weight:normal'>".$dealName."</b> <center><p style='font-family:Verdana;font-size:16px;color:black'>Service Appointment Summary Report <br><i style='font-size:12px;'>From Period: ".$StartApptDate." - ".$EndApptDate."</i></p></center>"; echo "<div id='' style='width:100%;height:100%;background:white;border:0px solid black;border-left:0px;border-right:0px'> "; echo "<table style='width:100%;'>"; echo "<thead>"; echo "<td style='width:20%;text-align:left'>Date</td>"; echo "<td style='width:8%;text-align:left'>Confirmed</td>"; echo "<td style='width:8%;text-align:left'>Arrived</td>"; echo "<td style='width:8%;text-align:left'>No Show</td>"; echo "<td style='width:8%;text-align:left'>Q.S</td>"; echo "<td style='width:8%;text-align:left'>G.J</td>"; echo "<td style='width:8%;text-align:left'>B.P</td>"; echo "<td style='width:8%;text-align:left'>Closed RO</td>"; echo "<td style='width:8%;text-align:left'>Open RO</td>"; echo "<td style='width:10%;text-align:left'>Cancelled Appt</td>"; echo "</thead>"; foreach ($period as $dt) { $curDate = $dt->format("Y-m-d"); $curDateNew=str_replace('-', '/', $curDate); $dayName = $dt->format("l"); $booked = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew'"),0); $noShow = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`=''"),0); $arrived = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!=''"),0); $qss = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_appt_type`='QS' AND `s_arrived_date`!=''"),0); $gj = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_appt_type`='GJ' AND `s_arrived_date`!=''"),0); $bp = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_appt_type`='BP' AND `s_arrived_date`!=''"),0); $arrived = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!=''"),0); $closed = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!='' AND `service_status`='1'"),0); $open = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!='' AND `service_status`='0'"),0); $cancelled = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `service_status`='3'"),0); echo "<tr>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$curDateNew." - ". $dayName."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$booked."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$arrived."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$noShow."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$qss."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$gj."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$bp."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$closed."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$open."</td>"; echo "<td style='background:white;border:0px solid white; border-bottom:1px solid lightgray;text-align:left;padding-left:10px'>".$cancelled."</td>"; echo "<tr>"; } echo "</table>"; echo "</div>"; echo "<br><br><p style='font-family:Verdana;font-size:12px;color:black'>___________________________________________ <br><b style='font-size:12px;font-weight:normal'>Prepared By: ".$uFname." ".$uLname."<br><i style='font-size:10px'>Date: ". date_create() ->format("m/d/Y")."</i></b></p><br><br>"; echo "</div>"; echo "</div>"; exit(); } ?>

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