File manager

File manager - Edit - /home/autoph/public_html/portal/print-dr-items.php

Back
<?php include 'core/init.php'; $compCode =$user_data['company_assignment']; $user = $user_data['u_name']; $myCompany = mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`='$compCode'"),0); $fromID = $_GET['venID']; $toID = $_GET['compID']; $inv = $_GET['inv']; $dr = $_GET['dr']; $vendorName = mysql_result(mysql_query("SELECT `vendor_name` FROM `suppliers` WHERE `vendor_id`='$fromID'"),0); $companyName = mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`='$toID'"),0); $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); $checkAccess = $user_data['add_new_hmo']; if($checkAccess == '0'){ secalert(); }else{ ?> <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="200px" height="50px"> </img> <br><?php echo "<b style='font-size:14px'>".$companyName."</b>";?> <br><?php echo "<i style='font-size:12px'>" . $branchAddress ."</i>";?> <br><br><b style="font-size:18px;color:black;font-family:Calibri">DELIVERY RECEIVING REPORT <br> <i style='font-size:14px'>Delivery Date <?php echo $_GET['date'];?></i></b> <br><br><?php echo "Date Printed: ".$toDate;?> <br><?php echo "Prepared by: ".$fuser. " " .$user;?> </td> </tr> <tr> <td class="lightGradient" valign="top" style="border:1px solid lightgray;height:15%;font-size:14px;font-weight:normal;color:gray;background:white"> <table style='border:1px solid lightgray;width:100%'> <tr> <td style='width:120px;background:#f5f5f5;color:gray'> D.R Number:</td> <td style='width:100px;background:#f5f5f5;font-size:14px;font-weight:bold;color:gray'><?php echo $_GET['dr'];?></td> <td style='width:120px;background:#f5f5f5;color:gray'> Invoice Number:</td> <td style='width:100px;background:#f5f5f5;font-size:14px;font-weight:bold;color:gray'><?php echo $_GET['inv'];?></td> <td style='width:120px;background:#f5f5f5;color:gray'> D.R Date:</td> <td style='width:100px;background:#f5f5f5;font-size:14px;font-weight:bold;color:gray'><?php echo $_GET['date'];?></td> </tr> <tr> <td style='width:120px;background:#f5f5f5;font-size:14px;font-weight:normal;color:gray'> Received From:</td> <td colspan="2" style='height:25px;width:100px;font-size:14px;font-weight:bold;background:#f5f5f5;color:gray'><?php echo $vendorName;?></td> <td style='width:120px;background:#f5f5f5;color:gray'> Delivered To:</td> <td colspan="2" style='height:25px;width:100px;;background:#f5f5f5;font-size:14px;font-weight:bold;color:gray'><?php echo $companyName;?></td> </tr> </table> </td> </tr> <tr> <td class="lightGradient" valign="top" style="border:1px solid gray;background:white;font-size:14px;font-weight:normal;color:white"> <?php $qq=mysql_query("SELECT * FROM `deliver_details` WHERE `detl_status`='posted' AND `detl_hdr_invoice`='$inv' AND `detl_hdr_dr`='$dr'"); 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:#f5f5f5;border:1px solid gray;font-size:13px;height:25px'>Record No</th> <th class='Gradient' align='center' style='width:80px;background:#f5f5f5;border:1px solid gray;font-size:13px'>D.R Date</th> <th class='Gradient' align='center' style='width:80px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Item ID</th> <th class='Gradient' align='center' style='width:300px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Item Description</th> <th class='Gradient' align='center' style='width:40px;background:#f5f5f5;border:1px solid gray;font-size:13px'>UoM</th> <th class='Gradient' align='center' style='width:50px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Quantity</th> <th class='Gradient' align='center' style='width:80px;background:#f5f5f5;border:1px solid gray;font-size:13px'>Status</th> </tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; $itemID = $row['item_id']; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); $uom = mysql_result(mysql_query("SELECT `UoM` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:25px'>" . $row['detl_id'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:25px'>" . $row['detl_date'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:25px'>" . $row['item_id'] . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;height:25px'>" . $itemDesc. "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:25px'>" . $uom. "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:25px'>" . number_format($row['detl_qty'],2,'.',',') . "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:25px'>" . $row['detl_status'] . "</td>"; echo "</tr>"; } echo "</tr> </table>"; ?> </td> </tr> </table> <?php }?>

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