Update from usntable branch.
[fa-stable.git] / sales / includes / db / sales_credit_db.inc
index 0cea7655c5a2ddce7b6e6f44eb761de5587eca88..a71d686acc77e876fbda050ce5464a1ca2102fcc 100644 (file)
@@ -15,6 +15,8 @@
 //
 function write_credit_note($credit_note, $write_off_acc)
 {
+       global $Refs;
+
        $credit_invoice =       is_array($credit_note->src_docs) ?
                 reset(array_keys($credit_note->src_docs)) : $credit_note->src_docs;
 
@@ -65,7 +67,7 @@ function write_credit_note($credit_note, $write_off_acc)
 
        /*Now insert the Credit Note into the debtor_trans table with the allocations as calculated above*/
        // all amounts in debtor's currency
-       $credit_no = write_customer_trans(11, $trans_no, $credit_note->customer_id,
+       $credit_no = write_customer_trans(ST_CUSTCREDIT, $trans_no, $credit_note->customer_id,
                $credit_note->Branch, $credit_date, $credit_note->reference,
                $credit_note_total, 0, $items_added_tax,
                $credit_note->freight_cost, $freight_added_tax,
@@ -78,15 +80,15 @@ function write_credit_note($credit_note, $write_off_acc)
                $credit_note->trans_no = array($credit_no=>0);
                set_document_parent($credit_note);
        } else {
-               delete_comments(11, $credit_no);
-               void_cust_allocations(11, $credit_no, $credit_date);
-               void_gl_trans(11, $credit_no, true);
-               void_stock_move(11, $credit_no);
-               void_trans_tax_details(11, $credit_no);
+               delete_comments(ST_CUSTCREDIT, $credit_no);
+               void_cust_allocations(ST_CUSTCREDIT, $credit_no, $credit_date);
+               void_gl_trans(ST_CUSTCREDIT, $credit_no, true);
+               void_stock_move(ST_CUSTCREDIT, $credit_no);
+               void_trans_tax_details(ST_CUSTCREDIT, $credit_no);
        }
        if ($credit_invoice) {
-               $invoice_alloc_balance = get_DebtorTrans_allocation_balance(10, $credit_invoice);
-               update_customer_trans_version(get_parent_type(11), $credit_note->src_docs );
+               $invoice_alloc_balance = get_DebtorTrans_allocation_balance(ST_SALESINVOICE, $credit_invoice);
+               update_customer_trans_version(get_parent_type(ST_CUSTCREDIT), $credit_note->src_docs );
                if ($invoice_alloc_balance > 0) {       //the invoice is not already fully allocated 
                        $total = $credit_note_total + $credit_note->freight_cost +
                            $items_added_tax + $freight_added_tax;
@@ -94,13 +96,13 @@ function write_credit_note($credit_note, $write_off_acc)
                        $allocate_amount = ($invoice_alloc_balance > $total) ? $total : $invoice_alloc_balance;
                        /*Now insert the allocation record if > 0 */
                        if ($allocate_amount != 0) {
-                               update_debtor_trans_allocation(10, $credit_invoice, $allocate_amount);
-                               update_debtor_trans_allocation(11, $credit_no, $allocate_amount); // ***
-                               add_cust_allocation($allocate_amount, 11, $credit_no, 10, $credit_invoice);
+                               update_debtor_trans_allocation(ST_SALESINVOICE, $credit_invoice, $allocate_amount);
+                               update_debtor_trans_allocation(ST_CUSTCREDIT, $credit_no, $allocate_amount); // ***
+                               add_cust_allocation($allocate_amount, ST_CUSTCREDIT, $credit_no, ST_SALESINVOICE, $credit_invoice);
                                // Exchange Variations Joe Hunt 2008-09-20 ////////////////////////////////////////
 
-                               exchange_variation(11, $credit_no, 10, $credit_invoice, $credit_date,
-                                       $allocate_amount, payment_person_types::customer());
+                               exchange_variation(ST_CUSTCREDIT, $credit_no, ST_SALESINVOICE, $credit_invoice, $credit_date,
+                                       $allocate_amount, PT_CUSTOMER);
 
                                ///////////////////////////////////////////////////////////////////////////
 
@@ -122,7 +124,7 @@ function write_credit_note($credit_note, $write_off_acc)
                $line_tax = get_full_price_for_item($credit_line->stock_id, $credit_line->price,
                  0, $credit_note->tax_included, $credit_note->tax_group_array) - $line_taxfree_price;
 
-               write_customer_trans_detail_item(11, $credit_no, $credit_line->stock_id,
+               write_customer_trans_detail_item(ST_CUSTCREDIT, $credit_no, $credit_line->stock_id,
                        $credit_line->item_description, $credit_line->qty_dispatched,
                        $credit_line->line_price(), $line_tax, $credit_line->discount_percent,
                        $credit_line->standard_cost, $trans_no==0 ? 0:  $credit_line->id);
@@ -139,14 +141,14 @@ function write_credit_note($credit_note, $write_off_acc)
 
        if (($credit_note_total + $credit_note->freight_cost) != 0) {
 
-               $total += add_gl_trans_customer(11, $credit_no, $credit_date, $branch_data["receivables_account"], 0, 0,
+               $total += add_gl_trans_customer(ST_CUSTCREDIT, $credit_no, $credit_date, $branch_data["receivables_account"], 0, 0,
                        -($credit_note_total + $credit_note->freight_cost + $items_added_tax + $freight_added_tax),
                        $credit_note->customer_id,
                        "The total debtor GL posting for the credit note could not be inserted");
        }
 
-       if ($credit_note->freight_cost !=0) {
-               $total += add_gl_trans_customer(11, $credit_no, $credit_date, $company_data["freight_act"], 0, 0,
+       if ($credit_note->freight_cost != 0) {
+               $total += add_gl_trans_customer(ST_CUSTCREDIT, $credit_no, $credit_date, $company_data["freight_act"], 0, 0,
                        $credit_note->get_tax_free_shipping(), $credit_note->customer_id,
                        "The freight GL posting for this credit note could not be inserted");
        }
@@ -155,23 +157,23 @@ function write_credit_note($credit_note, $write_off_acc)
                if ($taxitem['Net'] != 0) {
 
                        $ex_rate = get_exchange_rate_from_home_currency(get_customer_currency($credit_note->customer_id), $credit_note->document_date);
-                       add_trans_tax_details(11, $credit_no, $taxitem['tax_type_id'],
+                       add_trans_tax_details(ST_CUSTCREDIT, $credit_no, $taxitem['tax_type_id'],
                                $taxitem['rate'], $credit_note->tax_included, $taxitem['Value'],
                                $taxitem['Net'], $ex_rate,
                                $credit_note->document_date, $credit_note->reference);
 
-                       $total += add_gl_trans_customer(11, $credit_no, $credit_date, $taxitem['sales_gl_code'], 0, 0,
+                       $total += add_gl_trans_customer(ST_CUSTCREDIT, $credit_no, $credit_date, $taxitem['sales_gl_code'], 0, 0,
                                $taxitem['Value'], $credit_note->customer_id,
                                "A tax GL posting for this credit note could not be inserted");
                }
        }
        /*Post a balance post if $total != 0 */
-       add_gl_balance(11, $credit_no, $credit_date, -$total, payment_person_types::customer(), $credit_note->customer_id);     
+       add_gl_balance(ST_CUSTCREDIT, $credit_no, $credit_date, -$total, PT_CUSTOMER, $credit_note->customer_id);       
 
-       add_comments(11, $credit_no, $credit_date, $credit_note->Comments);
+       add_comments(ST_CUSTCREDIT, $credit_no, $credit_date, $credit_note->Comments);
 
        if ($trans_no == 0) {
-               references::save_last($credit_note->reference, 11);
+               $Refs->save(ST_CUSTCREDIT, $credit_no, $credit_note->reference);
        }
 
        commit_transaction();
@@ -200,14 +202,14 @@ function add_credit_movements_item(&$credit_note, &$credit_line,
                if ($credited_invoice)
                        $reference .= "Ex Inv: " . $credited_invoice;
 
-       add_stock_move_customer(11,  $credit_line->stock_id,
+       add_stock_move_customer(ST_CUSTCREDIT,  $credit_line->stock_id,
                key($credit_note->trans_no), $credit_note->Location,
                $credit_note->document_date, $reference, -$credit_line->qty_dispatched,
                $credit_line->standard_cost,  0, $price,
                $credit_line->discount_percent);
 
                }
-       add_stock_move_customer(11,  $credit_line->stock_id,
+       add_stock_move_customer(ST_CUSTCREDIT,  $credit_line->stock_id,
                key($credit_note->trans_no), $credit_note->Location,
                $credit_note->document_date, $reference, $credit_line->qty_dispatched,
                $credit_line->standard_cost,  0, $price,
@@ -235,9 +237,9 @@ function add_gl_trans_credit_costs($order, $order_line, $credit_no, $date_,
        if ($standard_cost != 0) {
                /*first the cost of sales entry*/
 
-               $total += add_gl_trans_std_cost(11, $credit_no, $date_, $stock_gl_codes["cogs_account"],
+               $total += add_gl_trans_std_cost(ST_CUSTCREDIT, $credit_no, $date_, $stock_gl_codes["cogs_account"],
                        $dim, $dim2, "", -($standard_cost * $order_line->qty_dispatched),
-                       payment_person_types::customer(), $order->customer_id,
+                       PT_CUSTOMER, $order->customer_id,
                        "The cost of sales GL posting could not be inserted");
 
                /*now the stock entry*/
@@ -248,9 +250,9 @@ function add_gl_trans_credit_costs($order, $order_line, $credit_no, $date_,
                        $stock_entry_account = $stock_gl_code["inventory_account"];
                }
 
-               $total += add_gl_trans_std_cost(11, $credit_no, $date_, $stock_entry_account, 0, 0,
+               $total += add_gl_trans_std_cost(ST_CUSTCREDIT, $credit_no, $date_, $stock_entry_account, 0, 0,
                        "", ($standard_cost * $order_line->qty_dispatched),
-                       payment_person_types::customer(), $order->customer_id,
+                       PT_CUSTOMER, $order->customer_id,
                        "The stock side (or write off) of the cost of sales GL posting could not be inserted");
 
        } /* end of if GL and stock integrated and standard cost !=0 */
@@ -273,13 +275,13 @@ function add_gl_trans_credit_costs($order, $order_line, $credit_no, $date_,
                        $sales_account = $branch_data['sales_account'];
                else
                        $sales_account = $stock_gl_codes['sales_account'];
-               $total += add_gl_trans_customer(11, $credit_no, $date_, $sales_account, $dim, $dim2,
+               $total += add_gl_trans_customer(ST_CUSTCREDIT, $credit_no, $date_, $sales_account, $dim, $dim2,
                        ($line_taxfree_price * $order_line->qty_dispatched), $order->customer_id,
                        "The credit note GL posting could not be inserted");
 
                if ($order_line->discount_percent != 0) {
 
-                       $total += add_gl_trans_customer(11, $credit_no, $date_, $branch_data["sales_discount_account"],
+                       $total += add_gl_trans_customer(ST_CUSTCREDIT, $credit_no, $date_, $branch_data["sales_discount_account"],
                                $dim, $dim2, -($line_taxfree_price * $order_line->qty_dispatched * $order_line->discount_percent),
                                $order->customer_id,
                                "The credit note discount GL posting could not be inserted");