File manager - Edit - /home/webivo6/rado.webivox.com/invupdate.php
Back
<?php require_once('config.php'); require_once(DIR_SYSTEM.'class/class.inc.php'); $res=$db->select("*","sales_invoices","","21400,1000",""); while($row=$db->fetch($res)) { ////////////// $invoice_total=0; $invoice_total_cost=0; $res_tmp_inv_itm=$db->select("*","sales_invoice_items","invoice_id='".$row['id']."'","","id ASC"); while($row_tmp_inv_itm=$db->fetch($res_tmp_inv_itm)) { if($row_tmp_inv_itm['discount']!=='0.0000') { $thisprice=$row_tmp_inv_itm['unit_price']-($row_tmp_inv_itm['unit_price']*$row_tmp_inv_itm['discount']/100); $invoice_total+=$thisprice*$row_tmp_inv_itm['qty']; } else { $invoice_total+=$row_tmp_inv_itm['unit_price']*$row_tmp_inv_itm['qty']; } $invoice_total_cost+=$row_tmp_inv_itm['cost']*$row_tmp_inv_itm['qty']; } $res_tmp_inv=$db->select("id,gsd","sales_invoices","id='".$row['id']."'","",""); $row_tmp_inv=$db->fetch($res_tmp_inv); if($row_tmp_inv['gsd']!=='0.0000') { $inv_amount=$invoice_total-($invoice_total*$row_tmp_inv['gsd']/100); } else { $inv_amount=$invoice_total; } $cash=0; $cheque=0; $card=0; $credit=0; $return=0; $respayf=$db->select("*","sales_invoice_payments","invoice_id='".$row['id']."'","","id ASC"); while($rowpayf=$db->fetch($respayf)) { if($rowpayf['type']=='Cash') { $cash+=$rowpayf['amount']; } if($rowpayf['type']=='Cheque') { $cheque+=$rowpayf['amount']; } if($rowpayf['type']=='Card') { $card+=$rowpayf['amount']; } if($rowpayf['type']=='Credit') { $credit+=$rowpayf['amount']; } if($rowpayf['type']=='Return') { $return+=$rowpayf['amount']; } } $db->update("sales_invoices","`total_sale`='".$inv_amount."', `total_sale_cost`='".$invoice_total_cost."', `cash`='".$cash."', `cheque`='".$cheque."', `card`='".$card."', `credit`='".$credit."', `return`='".$return."'","id='".$row['id']."'"); } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.2.34 | Generation time: 0 |
proxy
|
phpinfo
|
Settings