X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fvoiding_db.inc;h=00b3eb4d1e9fa24f8119f621d49290016013304a;hb=76ca9fef9bb510236a6a7740fa0f60eb7db384c9;hp=e81dd1b0dfc848376edd0fd44b27269cf05fb4f4;hpb=f12dbe7523bb1abc6cd69b009ef8f0be838f5348;p=fa-stable.git diff --git a/admin/db/voiding_db.inc b/admin/db/voiding_db.inc index e81dd1b0..00b3eb4d 100644 --- a/admin/db/voiding_db.inc +++ b/admin/db/voiding_db.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ include_once($path_to_root . "/sales/includes/sales_db.inc"); include_once($path_to_root . "/purchasing/includes/purchasing_db.inc"); include_once($path_to_root . "/inventory/includes/inventory_db.inc"); @@ -7,97 +16,98 @@ include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc"); function void_transaction($type, $type_no, $date_, $memo_) { + global $Refs; $void_entry = get_voided_entry($type, $type_no); if ($void_entry != null) return false; switch ($type) { - case 0 : // it's a journal entry + case ST_JOURNAL : // it's a journal entry if (!exists_gl_trans($type, $type_no)) return false; - void_gl_trans($type, $type_no); - if (exists_bank_trans($type, $type_no)) - void_bank_trans($type, $type_no); + void_journal_trans($type, $type_no); break; - case 1 : // it's a payment - case 2 : // it's a deposit - case 4 : // it's a transfer + case ST_BANKPAYMENT : // it's a payment + case ST_BANKDEPOSIT : // it's a deposit + case ST_BANKTRANSFER : // it's a transfer if (!exists_bank_trans($type, $type_no)) return false; void_bank_trans($type, $type_no); break; - case 10 : // it's a customer invoice - case 11 : // it's a customer credit note - case 12 : // it's a customer payment - case 13 : // it's a customer dispatch + case ST_SALESINVOICE : // it's a customer invoice + case ST_CUSTCREDIT : // it's a customer credit note + case ST_CUSTPAYMENT : // it's a customer payment + case ST_CUSTDELIVERY : // it's a customer dispatch if (!exists_customer_trans($type, $type_no)) return false; - if ($type == 13) // added 04 Oct 2008 by Joe Hunt. If delivery note has a not voided invoice, then NO. + if ($type == ST_CUSTDELIVERY) // added 04 Oct 2008 by Joe Hunt. If delivery note has a not voided invoice, then NO. { - $delivery = get_customer_trans($type_no, $type); - if ($delivery['trans_link'] != 0) - { - $inv = get_customer_trans($delivery['trans_link'], 10); - if ($inv['ov_amount'] != 0 || $inv['ov_discount'] != 0 || $inv['ov_gst'] != 0 || - $inv['ov_freight'] != 0 || $inv['ov_freight_tax'] != 0 || $inv['alloc'] != 0) + $childs = get_sales_child_lines($type, $type_no, false); + + if ($childs && db_num_rows($childs)) return false; - } - } + } post_void_customer_trans($type, $type_no); break; - case systypes::location_transfer() : // it's a stock transfer + case ST_LOCTRANSFER : // it's a stock transfer if (get_stock_transfer_items($type_no) == null) return false; void_stock_transfer($type_no); break; - case systypes::inventory_adjustment() : // it's a stock adjustment + case ST_INVADJUST : // it's a stock adjustment if (get_stock_adjustment_items($type_no) == null) return false; void_stock_adjustment($type_no); break; - case 25 : // it's a GRN + case ST_PURCHORDER : // it's a PO + case ST_SUPPRECEIVE : // it's a GRN return false; - case 20 : // it's a suppler invoice - case 21 : // it's a supplier credit note - case 22 : // it's a supplier payment + case ST_SUPPINVOICE : // it's a suppler invoice + case ST_SUPPCREDIT : // it's a supplier credit note + case ST_SUPPAYMENT : // it's a supplier payment if (!exists_supp_trans($type, $type_no)) return false; if (!post_void_supp_trans($type, $type_no)) return false; break; - case systypes::work_order() : // it's a work order + case ST_WORKORDER : // it's a work order if (!get_work_order($type_no, true)) return false; void_work_order($type_no); break; - case 28 : // it's a work order issue + case ST_MANUISSUE : // it's a work order issue if (!exists_work_order_issue($type_no)) return false; void_work_order_issue($type_no); break; - case 29 : // it's a work order production + case ST_MANURECEIVE : // it's a work order production if (!exists_work_order_produce($type_no)) return false; void_work_order_produce($type_no); break; - case systypes::cost_update() : // it's a stock cost update + case ST_SALESORDER: // it's a sales order + case ST_SALESQUOTE: // it's a sales quotation + return false; + + case ST_COSTUPDATE : // it's a stock cost update return false; break; } // only add an entry if it's actually been voided + add_audit_trail($type, $type_no, $date_, _("Voided.")."\n".$memo_); add_voided_entry($type, $type_no, $date_, $memo_); - + $Refs->restore_last($type, $type_no); return true; } @@ -105,7 +115,8 @@ function void_transaction($type, $type_no, $date_, $memo_) function get_voided_entry($type, $type_no) { - $sql = "SELECT * FROM ".TB_PREF."voided WHERE type=$type AND id=$type_no"; + $sql = "SELECT * FROM ".TB_PREF."voided WHERE type=".db_escape($type) + ." AND id=".db_escape($type_no); $result = db_query($sql, "could not query voided transaction table"); @@ -118,7 +129,8 @@ function add_voided_entry($type, $type_no, $date_, $memo_) { $date = date2sql($date_); $sql = "INSERT INTO ".TB_PREF."voided (type, id, date_, memo_) - VALUES ($type, $type_no, ".db_escape($date).", ".db_escape($memo_).")"; + VALUES (".db_escape($type).", ".db_escape($type_no).", " + .db_escape($date).", ".db_escape($memo_).")"; db_query($sql, "could not add voided transaction entry"); }