- $del_date = date2sql($order->delivery_date);
-
- $sql = "INSERT INTO ".TB_PREF."sales_orders (debtor_no, branch_code, customer_ref, Comments, ord_date,
- order_type, ship_via, deliver_to, delivery_address, contact_phone,
- contact_email, freight_cost, from_stk_loc, delivery_date)
- VALUES ('" . $order->customer_id . "', '" . $order->Branch . "', '".
- $order->cust_ref ."','". db_escape($order->Comments) ."','" .
- date2sql($order->orig_order_date) . "', '" .
- $order->default_sales_type . "', " .
- $_POST['ship_via'] .",'" . $order->deliver_to . "', '" .
- $order->delivery_address . "', '" .
- $order->phone . "', '" . $order->email . "', " .
- $order->freight_cost .", '" . $order->Location ."', '" .
- $del_date . "')";
+ begin_transaction();
+ hook_db_prewrite($order, $order->trans_type);
+ $order_no = get_next_trans_no($order->trans_type);
+ $del_date = date2sql($order->due_date);
+ $order_type = 0; // this is default on new order
+ $total = $order->get_trans_total();
+ $sql = "INSERT INTO ".TB_PREF."sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
+ order_type, ship_via, deliver_to, delivery_address, contact_phone,
+ freight_cost, from_stk_loc, delivery_date, payment_terms, total, prep_amount)
+ VALUES (" .db_escape($order_no) . "," .db_escape($order_type) . "," . db_escape($order->customer_id) .
+ ", " .db_escape($order->trans_type) . "," .db_escape($order->Branch) . ", ".
+ db_escape($order->cust_ref) .",".
+ db_escape($order->reference) .",".
+ db_escape($order->Comments) .",'" .
+ date2sql($order->document_date) . "', " .
+ db_escape($order->sales_type) . ", " .
+ db_escape($order->ship_via)."," .
+ db_escape($order->deliver_to) . "," .
+ db_escape($order->delivery_address) . ", " .
+ db_escape($order->phone) . ", " .
+ db_escape($order->freight_cost) .", " .
+ db_escape($order->Location) .", " .
+ db_escape($del_date) . "," .
+ db_escape($order->payment) . "," .
+ db_escape($total) . "," .
+ db_escape($order->prep_amount).")";