File manager

File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_ReportB.php

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearC'])){ $compID=$_GET['activeCompany']; $companyID = mysql_result(mysql_query("SELECT `comp_id` FROM `vts_company` WHERE `comp_id`='$compID'"),0); $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyAddress = mysql_result(mysql_query("SELECT `comp_address` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyTIN = mysql_result(mysql_query("SELECT `comp_tin` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyFax = mysql_result(mysql_query("SELECT `comp_fax` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyTel = mysql_result(mysql_query("SELECT `comp_tel` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $companyEmail = mysql_result(mysql_query("SELECT `comp_email` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $uFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$myUID'"),0); $uLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$myUID'"),0); $uFullName = $uFname.' '.$uLname; ?><center> <div style='padding:10px;margin:0%;width:60%;min-width:750px;border:0px solid gray;min-height:auto;background:white'> <div style='float:left;width:100%;height:auto;background:white;border:0px solid gray;margin-bottom:2px'> <div style='width:40%;min-width:200px;height:100px;float:left;border:0px solid gray;padding:10px;text-align;left'> <img src='images/autohub_logo_2016.png' width="auto" height="auto" style='float:left' /> <p style='float:left;width:100%; text-align:left;margin-top:5px;font-family:Yu Gothic Light;font-size:10px'>Website: https://www.autohubgroup.com</p> </div> <div style='width:55%;min-width:400px;height:100px;float:right;border:0px solid gray;padding:0px;text-align;right'> <div style='background:white;width:50%;height:100px;float:right;border:0px solid gray;padding:10px;text-align;left'> <?php //echo "<b style='font-family:Yu Gothic Light;font-size:14px;font-weight:bold;float:left;text-align:left'>".$companyName."</b>"; //echo "<b style='font-family:Yu Gothic Light;font-size:12px;font-weight:normal;float:left;text-align:left'>".$companyAddress."</b>"; //echo "<b style='font-family:Yu Gothic Light;font-size:12px;font-weight:normal;float:left;text-align:left'>Tel. No.".$companyTel." Fax." .$companyFax."</b>"; //echo "<b style='font-family:Yu Gothic Light;font-size:12px;font-weight:normal;float:left;text-align:left'>E-mail: ".$companyEmail."</b>"; ?> <div style='width:100%;padding:0px;font-family:Yu Gothic Bold;font-size:18px;font-weight:normal;color:black;border:0px solid gray;text-align:right;padding-top:40px'> <p style='margin:1px;padding:1px;padding-bottom:2px;margin-bottom:2px;font-weight:bold;font-size:18px'>TOTAL PRF WITH P.O</p> <p style='margin:1px;padding:1px;padding-top:2px;margin-top:2px;font-weight:normal;font-size:16px'>Report Coverage: Year <?php echo $_GET['selYearB'];?></p> <p style='margin:1px;padding:1px;padding-top:2px;margin-top:2px;font-weight:normal;font-size:12px'>Prepared Date: <?php echo Date('m/d/Y h:m');?></p> </div> </div> </div> </div> <div style='float:left;width:100%;height:50px;background:white;border:1px solid white;margin-bottom:5px;font-family:Yu Gothic Bold;font-size:18px;font-weight:normal;color:black;border:0px solid gray'> <?php echo 'AUTOHUB WIDE';?> <!--<div style='width:100%;padding:0px;font-family:Yu Gothic Bold;font-size:18px;font-weight:normal;color:black;border:0px solid gray'> <p style='margin:15px;padding:15px;padding-bottom:2px;margin-bottom:2px'>TOTAL PRF RECEIVED</p> <p style='margin:15px;padding:15px;padding-top:2px;margin-top:2px;font-weight:normal;font-size:14px'>Coverage: <?php echo $_GET['selYearB'];?></p> </div> --> </div> <div style='float:left;width:100%;height:485px;background:white;border:0px solid gray;margin-bottom:2px'> <div style='width:100%;padding:0px;font-family:Yu Gothic Bold;font-size:0.8vw;font-weight:bold;color:black;border:0px solid gray;height:25px;background:lightgray'> <table style='width:100%;border-collapse:collapse'> <tr> <td style='width:18%;border:1px solid gray;border-bottom:0px solid white;padding:2px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>COMPANY</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>JAN.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>FEB.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>MAR.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>APR</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>MAY</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>JUN.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>JUL.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>AUG.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>SEP.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>OCT.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>NOV.</td> <td style='width:6%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>DEC.</td> <td style='width:10%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:center'>TOTAL</td> </tr> </table> </div> <div style='float:left;width:99.8%;margin-bottom:2px;padding:0px;border:1px solid gray;height:auto;float:left;'> <?php //CurrentYear $JanYearStart = $_GET['selYearB'] ."-01-01"; $JanYearEnd = $_GET['selYearB'] ."-01-31"; $FebYearStart = $_GET['selYearB'] ."-02-01"; $FebYearEnd = $_GET['selYearB'] ."-02-28"; $MarYearStart = $_GET['selYearB'] ."-03-01"; $MarYearEnd = $_GET['selYearB'] ."-03-31"; $AprYearStart = $_GET['selYearB'] ."-04-01"; $AprYearEnd = $_GET['selYearB'] ."-04-30"; $MayYearStart = $_GET['selYearB'] ."-05-01"; $MayYearEnd = $_GET['selYearB'] ."-05-31"; $JunYearStart = $_GET['selYearB'] ."-06-01"; $JunYearEnd = $_GET['selYearB'] ."-06-30"; $JulYearStart = $_GET['selYearB'] ."-07-01"; $JulYearEnd = $_GET['selYearB'] ."-07-31"; $AugYearStart = $_GET['selYearB'] ."-08-01"; $AugYearEnd = $_GET['selYearB'] ."-08-31"; $SepYearStart = $_GET['selYearB'] ."-09-01"; $SepYearEnd = $_GET['selYearB'] ."-08-30"; $OctYearStart = $_GET['selYearB'] ."-10-01"; $OctYearEnd = $_GET['selYearB'] ."-10-31"; $NovYearStart = $_GET['selYearB'] ."-11-01"; $NovYearEnd = $_GET['selYearB'] ."-11-30"; $DecYearStart = $_GET['selYearB'] ."-12-01"; $DecYearEnd = $_GET['selYearB'] ."-12-31"; echo "<table style='width:100%;border-collapse:collapse;border:0px'>"; $getCompany = mysql_query("SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_code` ASC"); while($row=mysql_fetch_array($getCompany)){ $checkPO=0; $refCode=0; echo "<tr>"; echo "<td style='width:18%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px'>".$row['comp_code']."</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getJan = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$JanYearStart' AND '$JanYearEnd' AND `deleted`=0"); while($janRow=mysql_fetch_array($getJan)){ $refCode = $janRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getJanCount = $getJanCount + 1; } echo $getJanCount; } $getJanTotal = $getJanTotal + $getJanCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getFeb = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$FebYearStart' AND '$FebYearEnd' AND `deleted`=0"); while($febRow=mysql_fetch_array($getFeb)){ $refCode = $febRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getFebCount = $getFebCount + 1; } echo $getFebCount; } $getFebTotal = $getFebTotal + $getFebCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getMar = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$MarYearStart' AND '$MarYearEnd' AND `deleted`=0"); while($marRow=mysql_fetch_array($getMar)){ $refCode = $marRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getMarCount = $getMarCount + 1; } echo $getMarCount; } $getMarTotal = $getMarTotal + $getMarCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getApr = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$AprYearStart' AND '$AprYearEnd' AND `deleted`=0"); while($aprRow=mysql_fetch_array($getApr)){ $refCode = $aprRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getAprCount = $getAprCount + 1; } echo $getAprCount; } $getAprTotal = $getAprTotal + $getAprCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getMay = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$MayYearStart' AND '$MayYearEnd' AND `deleted`=0"); while($mayRow=mysql_fetch_array($getMay)){ $refCode = $mayRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getMayCount = $getMayCount + 1; } echo $getMayCount; } $getMayTotal = $getMayTotal + $getMayCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getJun = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$JunYearStart' AND '$JunYearEnd' AND `deleted`=0"); while($junRow=mysql_fetch_array($getJun)){ $refCode = $junRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getJunCount = $getJunCount + 1; } echo $getJunCount; } $getJunTotal = $getJunTotal + $getJunCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getJul = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$JulYearStart' AND '$JulYearEnd' AND `deleted`=0"); while($julRow=mysql_fetch_array($getJul)){ $refCode = $julRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getJulCount = $getJulCount + 1; } echo $getJulCount; } $getJulTotal = $getJulTotal + $getJulCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getAug = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$AugYearStart' AND '$AugYearEnd' AND `deleted`=0"); while($augRow=mysql_fetch_array($getAug)){ $refCode = $augRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getAugCount = $getAugCount + 1; } echo $getAugCount; } $getAugTotal = $getAugTotal + $getAugCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getSep = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$SepYearStart' AND '$SepYearEnd' AND `deleted`=0"); while($sepRow=mysql_fetch_array($getSep)){ $refCode = $sepRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getSepCount = $getSepCount + 1; } echo $getSepCount; } $getSepTotal = $getSepTotal + $getSepCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getOct = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$OctYearStart' AND '$OctYearEnd' AND `deleted`=0"); while($octRow=mysql_fetch_array($getOct)){ $refCode = $octRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getOctCount = $getOctCount + 1; } echo $getOctCount; } $getOctTotal = $getOctTotal + $getOctCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getNov = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$NovYearStart' AND '$NovYearEnd' AND `deleted`=0"); while($novRow=mysql_fetch_array($getNov)){ $refCode = $novRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getNovCount = $getNovCount + 1; } echo $getNovCount; } $getNovTotal = $getNovTotal + $getNovCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $decNov = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `comp_id`='".$row['comp_id']."' AND `date_created` BETWEEN '$DecYearStart' AND '$DecYearEnd' AND `deleted`=0"); while($decRow=mysql_fetch_array($decNov)){ $refCode = $decRow['reference_code']; $checkPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `header_ref_code`='$refCode' AND `po_code`!=''"),0); if($checkPO > 0){ $getDecCount = $getDecCount + 1; } echo $getDecCount; } $getDecTotal = $getDecTotal + $getDecCount; echo "</td>"; echo "<td style='width:6%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;text-align:center'>"; $getMonthlyTotal = $getJanCount + $getFebCount + $getMarCount + $getAprCount + $getMayCount + $getJunCount + $getJulCount + $getAugCount + $getSepCount + $getOctCount + $getNovCount + $getDecCount; echo $getMonthlyTotal; echo "</td>"; echo "</tr>"; $getGranTotal = $getGranTotal+$getMonthlyTotal; $getJanCount=0; $getFebCount=0; $getMarCount=0; $getAprCount=0; $getMayCount=0; $getJunCount=0; $getJulCount=0; $getAugCount=0; $getSepCount=0; $getOctCount=0; $getNovCount=0; $getDecCount=0; } echo "<tr>"; echo "<td style='background:lightgray;width:18%;padding:2px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold; color:black;border-right:1px solid gray;text-align:center'>TOTAL</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getJanTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getFebTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getMarTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getAprTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getMayTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getJunTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getJulTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getAugTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getSepTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getOctTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getNovTotal."</td>"; echo "<td style='background:lightgray;width:6%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:1px solid gray;text-align:center'>". $getDecTotal."</td>"; echo "<td style='background:lightgray;width:10%;padding:2px;font-family:Yu Gothic Light;font-size:12px; font-weight:bold;color:black;border-right:0px solid gray;text-align:center'>". $getGranTotal."</td>"; echo "</tr>"; echo "</table>"; ?> </div> <div style='float:left;width:100%;height:100px;background:white;border:0px solid gray;margin-bottom:2px;float:left;'> <div style='float:left;width:27%;height:90px;background:white;border:0px solid gray;margin:5px;margin-right:15px;float:left;padding-top:50px'> <div style='font-family:Yu Gothic Light;font-size:12px;text-align:left;float:left;width:95%;height:10px;background:white;border:0px solid gray;margin:1px;margin-bottom:0px;margin-top:15px'> Prepared By: </div> <div style='font-family:Yu Gothic Light;font-size:13px;text-align:center;float:left;width:95%;height:30px;background:white;border:0px solid gray;margin:1px;margin-top:0px;border-bottom:1px solid gray;;margin-top:10px '> <?php echo $uFullName . " \| ".$prfDate;?> </div> </div> </div> <!--<p style='width:100%;font-family:Yu Gothic Light;font-size:10px;margin-top:100px'>* This is a System Generated Report, physical signature might not be required * =--> </div> </div> </center> <?php } ?>

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