X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fvoid_transaction.php;h=68413f9aa3ea54fad6ca76a23c2bc3e2071224dd;hb=a7e711f2718d867380952b884f6cbb839d818a78;hp=f490cb237fe8b195e6073e39e3b927bdd0ab19a1;hpb=8143beb0b9260509cfd1e73acd3d29c965760763;p=fa-stable.git diff --git a/admin/void_transaction.php b/admin/void_transaction.php index f490cb23..68413f9a 100644 --- a/admin/void_transaction.php +++ b/admin/void_transaction.php @@ -73,7 +73,7 @@ function exist_transaction($type, $type_no) return false; case ST_SUPPRECEIVE : // it's a GRN - if (exists_grn($type_no)) + if (!exists_grn($type_no)) return false; break; @@ -142,6 +142,12 @@ function ref_view($row) return $row['ref']; } +function is_selected($row) // Function added by faisal +{ + global $selected_id; + return $row['trans_no'] == $selected_id ? true : false; +} + function voiding_controls() { global $selected_id; @@ -177,14 +183,16 @@ function voiding_controls() return; $cols = array( - _("#") => array('insert'=>true, 'fun'=>'view_link'), - _("Reference") => array('fun'=>'ref_view'), + _("#") => array('insert'=>true, 'fun'=>'view_link'), + _("Reference") => array('fun'=>'ref_view'), _("Date") => array('type'=>'date', 'fun'=>'date_view'), _("GL") => array('insert'=>true, 'fun'=>'gl_view'), - _("Select") => array('insert'=>true, 'fun'=>'select_link') + _("Select") => array('insert'=>true, 'fun'=>'select_link') ); $table =& new_db_pager('transactions', $sql, $cols); + $table->set_marker('is_selected', _("Marked transactions will be voided.")); //Added by Faisal + $table->width = "40%"; display_db_pager($table); @@ -222,7 +230,24 @@ function voiding_controls() } else { - display_warning(_("Are you sure you want to void this transaction ? This action cannot be undone."), 0, 1); + if ($_POST['filterType'] == ST_SUPPRECEIVE) { + $result = get_grn_items($_POST['trans_no']); + if (db_num_rows($result) > 0) { + while ($myrow = db_fetch($result)) { + if (is_inventory_item($myrow["item_code"])) { + if (check_negative_stock($myrow["item_code"], -$myrow["qty_recd"], null, $_POST['date_'])) { + $stock = get_item($myrow["item_code"]); + display_error(_("The void cannot be processed because there is an insufficient quantity for item:") . + " " . $stock['stock_id'] . " - " . $stock['description'] . " - " . + _("Quantity On Hand") . " = " . number_format2(get_qoh_on_date($stock['stock_id'], null, + $_POST['date_']), get_qty_dec($stock['stock_id']))); + return false; + } + } + } + } + } + display_warning(_("Are you sure you want to void this transaction ? This action cannot be undone."), 0, 1); br(); submit_center_first('ConfirmVoiding', _("Proceed"), '', true); submit_center_last('CancelVoiding', _("Cancel"), '', 'cancel'); @@ -290,7 +315,6 @@ function handle_void_transaction() display_notification_centered(_("Selected transaction has been voided.")); unset($_POST['trans_no']); unset($_POST['memo_']); - unset($_POST['date_']); } else { display_error($msg); @@ -319,6 +343,7 @@ if (isset($_POST['ProcessVoiding'])) if (isset($_POST['ConfirmVoiding'])) { handle_void_transaction(); + $selected_id = ''; $Ajax->activate('_page_body'); }