File manager

File manager - Edit - /home/autoph/public_html/ahglegal/includes/recon_new.php

Back
<?php $myDate = explode("/",$toDate); $myDay = $myDate[1]; $myMonth = $myDate[0]; $myYear = $myDate[2]; $uPassword2 = $user_data['u_password2']; $user = $user_data['u_name']; $compCode = $user_data['company_assignment']; $selDate = $_GET['date']; if(empty($selDate)){ $selDate = $toDate; } //http://localhost/nephro/main_new.php?view=707&sview=707&sid=recon&tab=5#id-5 //http://localhost/nephro/main_new.php?view=303&sview=303&sid=BD1&tab=0%23-2&date=01%2F04%2F2018&filter=Filter+Date#id-5 ?> <script type="text/javascript"> function addDateSeparator(e, control, format){ this.Format = format; var keycode = (e.which) ? e.which : event.keyCode if (keycode > 31 && (keycode < 48 \|\| keycode > 57)){ return false; }else{ var DateFormatPattern = /^dd\/mm\/yyyy$\|^mm\/dd\/yyyy$\|^mm\/dd\/yyyy$\|^yyyy\/mm\/dd$/; if ( DateFormatPattern.test(this.Format) ){ var SplitFormat = this.Format.split("/"); if ( control.value.length >= this.Format.length ){ if ( keycode !=8){ return false; } } if ( control.value.length == SplitFormat[0].length ){ if ( keycode !=8){ control.value += '/'; } } if ( control.value.length == (SplitFormat[1].length + SplitFormat[0].length +1) ){ if ( keycode !=8){ control.value += '/'; } } }else{ alert("Supplied date format parameter is incorrect."); } } }</script> <table style="border-collapse:collapse;background:#fff:border:none;height:100%;width:100%"> <tr> <td class="lightGradient" style="border:1px solid lightgray;height:32px;font-size:14px;font-weight:normal;color:gray"> <img src="images/bullet.gif" width="10px" height="10px"> </img> <b style="font-size:14px;color:red">DAILY CASH FLOW REPORT</b> <i>(From start Shift to end shift cash flow report)</i> </td> </tr> <tr> <td colspan="2" valign="TOP" style="border:1px solid gray;font-size:14px;weight:bold;color:gray;height:100%;background:white"> <form action="" method="GET"> <input type='hidden' name='view' value='707'> <input type='hidden' name='sview' value='707'> <input type='hidden' name='sid' value='recon'> <input type='hidden' name='tab' value='0#-2'> <input id='datepickerPOS' type="text" maxlength="10" name="date" value="<?php echo $_GET['date'];?>" style="font-size:14px;font-weight:normal;color:blue;width:130px;height:30px;border:1px solid gray;text-align:center;background:white" onkeyup="addDateSeparator(event,this,'dd/mm/yyyy')" placeholder="mm/dd/yyyy" required> <input type='submit' name='filter' value='Filter Date' style="width:80px;height:30px;border:1px solid lightgray;border-radius:3px;font-size:14px;background:#aae400;text-align:center"> </form> <table style='width:100%;border-collapse:collapse;background:white'> <tr> <td style='font-size:12px;font-weight:bold;text-align:left;width:220px;height:30px;border:1px solid lightgray'> Cash Transaction Summary </td> <td style='font-size:12px;font-weight:bold;text-align:center;width:100px;height:30px;border:1px solid lightgray'> Amount </td> </tr> <tr> <td style='font-size:12px;font-weight:normal;text-align:left;width:200px;height:30px;border:1px solid lightgray'> Treatment </td> <td style='font-size:12px;font-weight:normal;text-align:right;width:100px;height:30px;border:1px solid lightgray'> <?php $txCash = mysql_query("SELECT * FROM `payments` WHERE `payment_type`='Treatment' AND `payment_method`='Cash' AND `branch_code`='$compCode' AND `payment_date`='$selDate' AND `cancel`='no'\|\| `payment_type`='Treatment' AND `payment_method`='Advance' AND `branch_code`='$compCode' AND `payment_date`='$selDate' AND `cancel`='no'"); while($row = mysql_fetch_array($txCash)){ $txAmount = $txAmount + $row['payment_amount']; } echo number_format($txAmount, 2,'.',','); $TotalCash = $TotalCash + $txAmount; //echo $txAmount; ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:normal;text-align:left;width:200px;height:30px;border:1px solid lightgray'> Medicines and Supplies </td> <td style='font-size:12px;font-weight:normal;text-align:right;width:100px;height:30px;border:1px solid lightgray'> <?php $txCash = mysql_query("SELECT * FROM `payments` WHERE `payment_type`!='Treatment' AND `payment_type`!='Laboratory' AND `payment_type`!='Others' AND `payment_method`='Cash' AND `branch_code`='$compCode' AND `payment_date`='$selDate' AND `cancel`='no' \|\| `payment_type`!='Treatment' AND `payment_type`!='Laboratory' AND `payment_type`!='Others' AND `payment_method`='Advance' AND `branch_code`='$compCode' AND `payment_date`='$selDate' AND `cancel`='no'"); while($row = mysql_fetch_array($txCash)){ $mtxAmount = $mtxAmount + $row['payment_amount']; } echo number_format($mtxAmount, 2,'.',','); $TotalCash = $TotalCash + $mtxAmount; ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:normal;text-align:left;width:200px;height:30px;border:1px solid lightgray'> Laboratory </td> <td style='font-size:12px;font-weight:normal;text-align:right;width:100px;height:30px;border:1px solid lightgray'> <?php $txCash = mysql_query("SELECT * FROM `payments` WHERE `payment_type`='Laboratory' AND `payment_method`='Cash' AND `branch_code`='$compCode' AND `payment_date`='$selDate' AND `cancel`='no' \|\| `payment_type`='Laboratory' AND `payment_method`='Advance' AND `branch_code`='$compCode' AND `payment_date`='$selDate' AND `cancel`='no'"); while($row = mysql_fetch_array($txCash)){ $labAmount = $labAmount + $row['payment_amount']; } echo number_format($labAmount, 2,'.',','); $TotalCash = $TotalCash + $labAmount; ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:normal;text-align:left;width:200px;height:30px;border:1px solid lightgray'> Others / Miscellaneous </td> <td style='font-size:12px;font-weight:normal;text-align:right;width:100px;height:30px;border:1px solid lightgray'> <?php $txCash = mysql_query("SELECT * FROM `payments` WHERE `payment_type`='Others' AND `payment_method`='Cash' AND `branch_code`='$compCode' AND `payment_date`='$selDate' \|\| `payment_type`='Others' AND `payment_method`='Advance' AND `branch_code`='$compCode' AND `payment_date`='$selDate'"); while($row = mysql_fetch_array($txCash)){ $othAmount = $othAmount + $row['payment_amount']; } echo number_format($othAmount, 2,'.',','); $TotalCash = $TotalCash + $othAmount; ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:bold;text-align:right;width:200px;height:30px;border:1px solid lightgray;background:#f5f5f5'> Total Cash Registered </td> <td style='font-size:12px;font-weight:bold;text-align:right;width:100px;height:30px;border:1px solid lightgray;background:#f5f5f5'> <?php echo number_format($TotalCash, 2,'.',','); ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:bold;text-align:right;width:200px;height:30px;border:1px solid lightgray;background:#f5f5f5'> Cashier's Change Fund: </td> <td style='font-size:12px;font-weight:bold;text-align:right;width:100px;height:30px;border:1px solid lightgray;background:#f5f5f5'> <?php $checkCashierFund = mysql_result(mysql_query("SELECT `amount` FROM `cashier_cash_on_hand` WHERE `date_applied`='$selDate' AND `branch_code`='$compCode'"),0); echo number_format($checkCashierFund, 2,'.',','); ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:bold;text-align:right;width:200px;height:30px;border:1px solid lightgray;background:#f5f5f5'> Bank Deposit </td> <td style='font-size:12px;font-weight:bold;text-align:right;width:100px;height:30px;border:1px solid lightgray;background:#f5f5f5'> <?php $selBnk = mysql_query("SELECT * FROM `bank_deposit` WHERE `date_deposit`='$selDate'"); while($crow = mysql_fetch_array($selBnk)){ $bankDeposit = $bankDeposit + $crow['amount']; } echo number_format($bankDeposit, 2,'.',','); $onHand = $TotalCash - $bankDeposit;// + $checkCashierFund; ?> </td> </tr> <tr> <td style='font-size:12px;font-weight:bold;text-align:right;width:200px;height:30px;border:1px solid lightgray;background:#f5f5f5'> Total Cash On-Hand </td> <td style='font-size:12px;font-weight:bold;text-align:right;width:100px;height:30px;border:1px solid lightgray;background:#f5f5f5'> <?php echo number_format($onHand, 2,'.',','); ?> </td> </tr> </table> </td> </tr> </table> <?php if(isset($_POST['update'])){ $pass1 = $_POST['newpassword1']; $pass1 = $_POST['newpassword2']; $NewPass1 = md5($pass1); $NewPass2 = md5($pass1); mysql_query("UPDATE `c_users` SET `u_password`='$NewPass1',`u_password2`='$NewPass2' WHERE `u_name`='$user'"); echo " <center> <div style='position:absolute;width:400px;height:170px;left:250px;top:200px;border:2px solid lightgray;border-radius:5px;background:white'> <h3>Notification</h3> <table> <tr> <td align='center' style='font-size:12px;font-weight:normal;color:red;width:350px;height:140px;background:white;border:1px solid white'> Change password complete. Please login using the your new assigned password to continue...<br><br>Thank you!</font> <br> <br> <a href='logout.php'><br> <input style='background-color:#E5E4E2;border:1px black solid;border-radius:5px;width:100px;height:25px;color:black;font-size:14px;font-weight:bold;'type ='button' name ='edit' value = 'Close'> </a> <br><br> </td> </tr> </table> </div> </center>"; } ?>

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