File manager

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

Back
<?php include 'core/init.php'; $user = $user_data['u_name']; protected_page(); $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); $myDate = explode("/",$toDate); $myDay = $myDate[1]; $myMonth = $myDate[0]; $myYear = $myDate[2]; $or=$_GET['or']; $pID=$_GET['pid']; $fName = mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `patient_id`='$pID'"),0); $lName = mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `patient_id`='$pID'"),0); ?> <table style="border-collapse:collapse;background:#fff:border:none;height:100%;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="200px" height="50px"> </img> <br><?php echo "<b style='font-size:14px'>".$branchName."</b>";?> <br><?php echo "<i style='font-size:12px'>" . $branchAddress ."</i>";?> <br><br><b style="font-size:18px;color:black;font-family:Calibri"><center>ADVANCE PAYMENT UTILIZATION REPORT</center> <br>Name of Patient: <?php echo $lName . ", ". $fName;?><i style='font-size:14px'></i></b> </td> </tr> <tr> <td valign="TOP" style="border:1px solid white;font-size:14px;weight:bold;color:gray;height:100%;background:white"> <?php $q=mysql_query("SELECT * FROM `advance_payment_usage` WHERE `or_number`='$or' AND `pid`='$pID'"); $row=mysql_fetch_array($q); $total=mysql_num_rows($q); $dis=20; $total_page=ceil($total/$dis); $page_cur=(isset($_GET['page']))?$_GET['page']:1; $k=($page_cur-1)$dis; $page_cur = mysql_real_escape_string($page_cur); $qq=mysql_query("SELECT FROM `advance_payment_usage` WHERE `or_number`='$or' AND `pid`='$pID' ORDER by `date` ASC"); echo "<table style='width:100%; height:95% border:1px solid white; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:80px;background:lightgray;border:1px solid gray;font-size:13px;height:20px'>Date Paid</th> <th class='Gradient' align='center' style='width:100px;background:lightgray;border:1px solid gray;font-size:13px'>Payment. No.</th> <th class='Gradient' align='center' style='width:200px;background:lightgray;border:1px solid gray;font-size:13px'>Name of Patient</th> <th class='Gradient' align='center' style='width:300px;background:lightgray;border:1px solid gray;font-size:13px'>Item Description</th> <th class='Gradient' align='center' style='width:30px;background:lightgray;border:1px solid gray;font-size:13px'>QTY</th> <th class='Gradient' align='center' style='width:80px;background:lightgray;border:1px solid gray;font-size:13px'>Paid Amount</th> <th class='Gradient' align='center' style='width:100px;background:lightgray;border:1px solid gray;font-size:13px'>Date Used</th </tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; $itemID =$row['item_id']; echo "<td style='font-size:12px'>"; $getDate = mysql_result(mysql_query("SELECT `date` FROM `advance_payment` WHERE `OR_number`='$or'"),0); echo $getDate; echo "</td>"; echo "<td style='font-size:12px'>"; $getOR = mysql_result(mysql_query("SELECT `OR_number` FROM `advance_payment` WHERE `OR_number`='$or'"),0); echo $getOR; echo "</td>"; echo "<td style='font-size:12px'>"; echo $lName.", ".$fName; echo "</td>"; echo "<td style='font-size:12px'>"; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); echo $itemDesc; echo "</td>"; echo "<td align = 'center' style='font-size:12px'>"; echo $row['qty']; echo "</td>"; echo "<td align = 'right' style='font-size:12px'>"; echo number_format($row['used_amount'],2,'.',','); $totalAmount = $totalAmount + $row['used_amount']; echo "</td>"; echo "<td align = 'center' style='font-size:12px'>"; echo $row['date']; echo "</td>"; } echo "</tr>"; echo "<tr> <th colspan='6' style='text-align:right;width:80px;background:#fff;border:1px solid white;border-top:1px solid gray;font-size:14px;height:20px'>".number_format($totalAmount,2,'.',',')."</th> <th style='text-align:right;width:80px;background:#fff;border:1px solid white;border-top:1px solid gray;font-size:13px;height:20px'> </th> </tr>"; echo "</table>"; ?> </td> </tr> <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"> <br><br><?php echo "Date Printed: ".$toDate;?> <br><?php echo "Prepared by: " .$user;?> </td> </tr> </table>

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