File manager

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

Back
<?php include_once 'core/init.php'; $prfDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_GET['selYearSN'])){ $compID=$_GET['selectCompanyN']; $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'>PRF SUMMARY LIST</p> <p style='margin:1px;padding:1px;padding-top:2px;margin-top:2px;font-weight:normal;font-size:16px'>Coverage: <?php echo $_GET['selYearSN'] ."-".$_GET['selYearEN'];?></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';//$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: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'>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'>DATE</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:left'>CATEGORY</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:left'>REQUESTED BY</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:left'>STATUS</td> <td style='width:30%;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'>REASON</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['selYearSN']; $endDate = $_GET['selYearEN']; echo "<table style='width:100%;border-collapse:collapse;border:0px'>"; $getPRF = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `deleted`=0 AND `date_created` BETWEEN '$startDate' AND '$endDate' ORDER BY `date_created` ASC"); while($row=mysql_fetch_array($getPRF)){ $countPRF = $countPRF + 1; $reqByID=$row['request_by']; $catID=$row['category_id']; $prtStatus=$row['current_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); $reqByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqByID'"),0); $reqByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqByID'"),0); 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:10%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px;text-align:center'>".$row['reference_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:15%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px'>".$catName."</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'>".$reqByLName.", ".$reqByFName."</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'>".$prfStatDesc."</td>"; echo "<td style='width:30%;padding:1px;font-family:Yu Gothic Light;font-size:12px; color:black;border:1px solid lightgray;border-left:0px'>".$row['purpose_of_request']."</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