File manager

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

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearGS'])){ $compID=$_GET['selectCompanyG']; $companyName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$compID'"),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:60%;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'>REQUEST ITEMS WITHOUT P.O</p> <p style='margin:1px;padding:1px;padding-top:2px;margin-top:2px;font-weight:normal;font-size:16px'>Coverage: Year <?php echo $_GET['selYearGS'] ."-".$_GET['selYearEG'];?></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 strtoupper($companyName);//$companyName;?> <!--<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['selYearC'];?></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:5%;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'>NO</td> <td style='width:15%;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'>PRF NUMBER</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'>REQ. DATE</td> <td style='width:20%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:left'>DEALERSHIP</td> <td style='width:33%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:left'>ITEM DESCRIPTION</td> <td style='width:8%;border:1px solid gray;border-bottom:0px solid white; padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:left'>QUANTITY</td> <td style='width:9%;border:1px solid gray;border-bottom:0px solid white;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold;text-align:left'>AMOUNT</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 $startDate = $_GET['selYearGS']; $endDate = $_GET['selYearEG']; echo "<table style='width:100%;border-collapse:collapse;border:0px'>"; $getPRF = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `date_created` BETWEEN '$startDate' AND '$endDate' AND `comp_id`='16' AND `po_code`='' ORDER BY `date_created` ASC"); while($row=mysql_fetch_array($getPRF)){ $countPRF = $countPRF + 1; //$reqByID=$row['request_by']; $catID=$row['category_id']; $prtStatus=$row['item_status']; $prfStatDesc = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `id`='$prtStatus'"),0); $catName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$catID'"),0); $dealerName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['dealer_id']."'"),0); $totalCost = $totalCost + $row['approved_amount']; $totalQTY = $totalQTY + $row['quantity']; echo "<tr>"; echo "<td style='width:5%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:center'>".$countPRF."</td>"; echo "<td style='width:15%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:center'>".$row['header_ref_code']."</td>"; echo "<td style='width:10%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:center'>".$row['date_created']."</td>"; echo "<td style='width:20%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px'>".$dealerName."</td>"; echo "<td style='width:33%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px'>".$row['item_description']."</td>"; echo "<td style='width:8%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:center'>".number_format($row['quantity'],2,'.',',')."</td>"; echo "<td style='width:9%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:right'>".number_format($row['approved_amount'],2,'.',',')."</td>"; echo "</tr>"; } echo "<tr>"; echo "<td colspan='5' style='width:5%;padding:1px;font-family:Yu Gothic Light;font-weight:bold;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:right'>TOTAL</td>"; echo "<td style='width:8%;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold; color:black;border:1px solid lightgray;border-left:0px;text-align:center'>".number_format($totalQTY,2,'.',',')."</td>"; echo "<td style='width:9%;padding:1px;font-family:Yu Gothic Light;font-size:12px;font-weight:bold; color:black;border:1px solid lightgray;border-left:0px;text-align:right'>".number_format($totalCost,2,'.',',')."</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