File manager

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

Back
<?php $user = $user_data['u_name']; $comCode = $user_data['company_assignment']; $checkAccess = $user_data['cancel_payment']; $or = $_GET['ORNumber']; $empFname = $_GET['empFname']; $empLname = $_GET['empLname']; $empID = $_GET['empID']; if($checkAccess == '0'){ secalert(); }else{ if(isset($_GET['xpay'])){ $payID=$_GET['xID']; $OR = $_GET['ORNumber']; $itm = $_GET['itm']; $qty = $_GET['qty']; mysql_query("UPDATE `payments` SET `cancel`='yes', `cancelled_by`='$user', `cancelled_date`='$toDate', `cancelled_time`='$currentTime' WHERE `payment_id`='$payID'"); mysql_query("UPDATE `sales_journal` SET `cancel`='yes' WHERE `trans_id`='$OR' AND `item_id`='$itm'"); if($itm!='0'){ $onHand = mysql_result(mysql_query("SELECT `item_qty` FROM `inventory` WHERE `item_id`='$itm'"),0); $newQTY = $onHand + $qty; mysql_query("UPDATE `inventory` SET `item_qty`='$newQTY' WHERE `item`='$itm'"); $sql="INSERT INTO `stockcard` (`stk_id`, `ref_number`, `trans_type`,`item_id`,`beg_qty`,`trans_qty`,`end_qty`,`date`,`time`,`branch_code`,`by`,`posted`,`transType`) VALUES('','$OR','Cancelled Transaction','$itm','$onHand','$qty','$newQTY','$toDate','$currentTime','$comCode','$user','No','na')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } } echo "<div style='position:relative;width:550px;height:300px;left:20px;top:20px;border:3px solid red;border-radius:5px;background:#EFFBFB;'>"; echo "<h3> CANCEL PAYMENTS </h3>"; echo "<center> <input type='hidden' name='view' value='payment'> <table style='width:90%;background:white;border-collapse:collapse'>"; echo " <form action='' method='GET'> <input type='hidden' name='view' value='cancelpay'>"; echo "<tr>"; echo "<td align='left' style='width:150px;height:25px;border:1px solid white;background:#EFFBFB;font-size:16px;font-weight:bold'> <br>OR NUMBER: <br><input type='text' id='ornumber' value='".$or."' name='ORNumber' style='text-align:center;font-size:16px;font-weight:bold;color:#0B0B61;width:150px;height:30px;border:1px solid lightgray;border-radius:3px;background:#FFFFC8' placeholder='O.R Number' required> <input type='submit' name='searchor' value='...' style='width:60px;height:30px;border:1px solid #00BFFF;border-radius:3px;background:#A9E2F3;text-align:center;font-size:16px;font-weight:bold'> </td>"; echo "<td align='left' style='width:100px;height:25px;border:1px solid white;background:#EFFBFB;font-size:16px;font-weight:bold'> </td>"; echo "</tr> </form> "; if(isset($_GET['ORNumber'])){ echo "<tr>"; echo "<td colspan='2' align='right' style='width:100px;height:25px;border:1px solid white;background:#fff;font-size:16px;font-weight:bold'>"; echo "<form action='' method='POST'>"; echo "<input type='text' name='xNotes' style='text-align:center;background:#fff;width:400px;height:30px;border-radius:3px;border:1px solid red;font-size:16px;font-weight:bold' required>"; echo "<input type='submit' class='Gradient' name='xCancel' value='Cancel' style='width:90px;height:30px;border-radius:1px;border:1px solid red;font-size:16px;font-weight:bold'>"; echo "</form>"; echo "</td>"; echo "</tr> "; } //Item Summary below echo "</table> </center><br>"; echo "<table style='width:100%;border-collapse:collapse'>"; echo "<tr>"; echo "<td cols='5'>"; $qq=mysql_query("SELECT * FROM `payments` WHERE `payment_or`='$or' AND `branch_code`='$comCode' AND `cancel`='no' ORDER by `payment_id` 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:30px;background:lightgray;border:1px solid gray;font-size:12px;height:20px'>No.</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:12px'>Item ID</th> <th class='Gradient' align='center' style='width:400px;background:lightgray;border:1px solid gray;font-size:12px'>Item Description</th> <th class='Gradient' align='center' style='width:30px;background:lightgray;border:1px solid gray;font-size:12px'>Qty</th> <th class='Gradient' align='center' style='width:50px;background:lightgray;border:1px solid gray;font-size:12px'>Total Amount</th> <th class='Gradient' align='center' style='width:20px;background:lightgray;border:1px solid gray;font-size:12px'>-</th> </tr>"; //$TreatmentUsage = mysql_result(mysql_query("SELECT COUNT('session_id') FROM `treatment_session` WHERE `session_patient_id`='$patientID' AND `session_header_id`='$transactionID'"),0); while($row = mysql_fetch_array($qq)){ $totalORAmount = $row['payment_amount'] +$totalORAmount; $count = $count +1; echo "<tr>"; echo "<td align='center'>".$count."</td>"; echo "<td align='center'>".$row['item_id']."</td>"; echo "<td>"; $itmID = $row['item_id']; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itmID'"),0); if($itmID==='0'){ echo "Non-medical Supply"; }else { echo $itemDesc; } echo "</td>"; echo "<td align='center'>".$row['quantity']."</td>"; echo "<td align='right'>".$row['payment_amount']."</td>"; echo "<td align='center' style='background:#81F781'><a href='mainindex.php?view=cancelpay&ORNumber=".$row['payment_or']."&xpay=true&xID=".$row['payment_id']."&qty=".$row['quantity']."&itm=".$row['item_id']."'><b style='font-size:14px;font-weight:bold;color:red'>x</b></a></td>"; echo "</tr>"; } echo "<tr>"; echo "<th colspan='6' align='right'> <b style='font-size:14px;'>TOTAL </b>    "; echo number_format($totalORAmount,2,'.',','); echo "</th></tr>"; echo "</td>"; echo "</tr>"; echo "</table>"; echo "</div>"; //Saving Records // } ?>

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