File manager

File manager - Edit - /home/autoph/public_html/portal/cashdepositsummaryreport.php

Back
<?php include 'core/init.php'; $user = $user_data['u_name']; $fuser = $user_data['u_fname']; $luser = $user_data['u_lname']; $compCode = $user_data['company_assignment']; $branchName = mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`='$compCode'"),0); $branchAddress = mysql_result(mysql_query("SELECT `company_address` FROM `company` WHERE `company_id`='$compCode'"),0); $rangeFrom=$_GET['bdate']; $rangeTo=$_GET['edate']; $comp = $_GET['cat']; $myComp = explode("---",$comp); $selCompID = $myComp[1]; $selCompName = $myComp[0]; ?> <script type="text/javascript"> function printpage() { //Get the print button and put it into a variable var printButton = document.getElementById("printpagebutton"); //var postButton = document.getElementById("postbutton"); //Set the print button visibility to 'hidden' removeButton printButton.style.visibility = 'hidden'; //postButton.style.visibility = 'hidden'; //Print the page content window.print() //Set the print button to 'visible' again //[Delete this line if you want it to stay hidden after printing] printButton.style.visibility = 'visible'; //postButton.style.visibility = 'visible'; } </script> <table style="border-collapse:collapse;background:#fff:border:none;width:100%"> <tr> <td valign="top" class="lightGradient" style="width:400px;border:1px solid white;border-bottom:1px solid lightgray;height:32px;font-size:14px;font-weight:normal;color:gray"> <img src="images/logo.png" width="250px" height="70px"> </img> <br><b style="font-size:20px;color:black;font-family:Calibri">DEPOSIT SLIP SUMMARY REPORT</b> <br><?php echo "<b style='font-size:14px'>".$branchName."</b>";?> <br><?php echo "<i style='font-size:12px'>" . $branchAddress ."</i>";?> <br><br><center><b style='font-size:14px;'><?php echo $iType;?></center></b><br><?php echo "Date Printed: ". $toDate;?> <br><?php echo "Prepared by: ".$fuser. " " .$luser;?> </td> <td valign="top" class="lightGradient" style="border:1px solid white;border-bottom:1px solid lightgray;height:32px;font-size:14px;font-weight:normal;color:gray"> </td> </tr> <center> <tr> <td colspan="2" valign="top" style="border:1px solid white;font-size:14px;weight:bold;color:gray;background:white;width:200px"> <table style='width:100%;border-collapse:collapse;border:none'> <?php echo "<tr> <th class='Gradient' style='height:25px;text-align:center;width:30px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>No.</th> <th class='Gradient' align='center' style='width:70px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>TRANSACTION DATE</th> <th class='Gradient' align='center' style='width:70px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>DATE DEPOSIT</th> <th class='Gradient' align='center' style='width:250px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>COMPANY</th> <th class='Gradient' align='center' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>REF. NUMBER</th> <th class='Gradient' align='center' style='width:150px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>BANK NAME</th> <th class='Gradient' align='center' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>AMOUNT</th> <th class='Gradient' align='center' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:10px;color:black'>BY</th> </tr>"; IF($comp==='All Centers'){ $checkdeposit=mysql_query("SELECT * FROM `bank_deposit` WHERE `date_deposit` BETWEEN '$rangeFrom' AND '$rangeTo' ORDER by `date_deposit` ASC"); }else { $checkdeposit=mysql_query("SELECT * FROM `bank_deposit` WHERE `date_deposit` BETWEEN '$rangeFrom' AND '$rangeTo' AND `branch_code`='$selCompID' ORDER by `date_deposit` ASC"); } while($row = mysql_fetch_array($checkdeposit)){ $companyID = $row['branch_code']; $compName = mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`='$companyID'"),0); $iCount = $iCount + 1; echo "<tr>"; echo "<td style='text-align:center;border:1px solid lightgray;font-size:12px'>".$iCount."</td>"; echo "<td style='text-align:center;border:1px solid lightgray;font-size:12px'>".$row['date_deposit']."</td>"; echo "<td style='text-align:left;border:1px solid lightgray;font-size:12px'>".$row['date_encoded']."</td>"; echo "<td style='text-align:left;border:1px solid lightgray;font-size:12px'>".$compName."</td>"; echo "<td style='text-align:center;border:1px solid lightgray;font-size:12px'>".$row['ref_number']."</td>"; echo "<td style='text-align:center;border:1px solid lightgray;font-size:12px'>".$row['bank_name']."</td>"; echo "<td style='text-align:right;border:1px solid lightgray;font-size:12px'>".number_format($row['amount'],2,'.',',')."</td>"; echo "<td style='text-align:center;border:1px solid lightgray;font-size:12px'>".$row['deposit_by']."</td>"; echo "</tr>"; $totalAmount = $totalAmount + $row['amount']; } echo "<tr>"; echo "<td colspan='6' style='text-align:right;border:1px solid lightgray;font-size:12px'>TOTAL</td>"; echo "<td style='text-align:right;border:1px solid lightgray;font-size:12px'>".number_format($totalAmount,2,'.',',')."</td>"; echo "<td style='text-align:right;border:1px solid lightgray;font-size:12px'></td>"; echo "</tr>"; ?> </table> </td> </tr> <tr> <td colspan='2' valign="top" style="width:100%;border:1px solid white;font-size:12px;weight:bold;color:gray;background:white"> <br><br><?php echo "Date Printed: ". $toDate;?> <br><?php echo "Prepared by: ".$user_data['u_fname']." ".$user_data['u_lname'];?> </td> </tr> </table> <center><input id="printpagebutton" type="button" value="Print..." onclick="printpage()"/>

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