X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sales%2Fincludes%2Fsales_db.inc;h=1eb5e9060371c40d786d7897e9e09acab4e8c173;hb=5363021b0a477a1332cc19598c245edd2f8afd91;hp=e3b3e5a34752fa304d8bef0e191487b6ded1b598;hpb=0c1bcd8ce3c089d7ddb3722a097f8fc8417f41e6;p=fa-stable.git diff --git a/sales/includes/sales_db.inc b/sales/includes/sales_db.inc index e3b3e5a3..1eb5e906 100644 --- a/sales/includes/sales_db.inc +++ b/sales/includes/sales_db.inc @@ -1,11 +1,22 @@ . +***********************************************************************/ include_once($path_to_root . "/includes/banking.inc"); include_once($path_to_root . "/includes/db/inventory_db.inc"); include_once($path_to_root . "/sales/includes/db/sales_order_db.inc"); include_once($path_to_root . "/sales/includes/db/sales_credit_db.inc"); include_once($path_to_root . "/sales/includes/db/sales_invoice_db.inc"); include_once($path_to_root . "/sales/includes/db/sales_delivery_db.inc"); +include_once($path_to_root . "/sales/includes/db/sales_types_db.inc"); +include_once($path_to_root . "/sales/includes/db/sales_points_db.inc"); include_once($path_to_root . "/sales/includes/db/custalloc_db.inc"); include_once($path_to_root . "/sales/includes/db/cust_trans_db.inc"); include_once($path_to_root . "/sales/includes/db/cust_trans_details_db.inc"); @@ -34,40 +45,121 @@ function add_stock_move_customer($type, $stock_id, $trans_id, $location, $date_, // $amount is in CUSTOMER'S currency function add_gl_trans_customer($type, $type_no, $date_, $account, $dimension, $dimension2, - $amount, $customer_id, $err_msg="") + $amount, $customer_id, $err_msg="", $rate=0) { if ($err_msg == "") $err_msg = "The customer GL transaction could not be inserted"; return add_gl_trans($type, $type_no, $date_, $account, $dimension, $dimension2, "", $amount, get_customer_currency($customer_id), - payment_person_types::customer(), $customer_id, $err_msg); + payment_person_types::customer(), $customer_id, $err_msg, $rate); } //---------------------------------------------------------------------------------------- -function get_price ($stock_id, $debtor_no) +function get_price ($stock_id, $currency, $sales_type_id, $factor=null, $date=null) { - $sql = "SELECT ".TB_PREF."prices.price - FROM ".TB_PREF."prices, ".TB_PREF."debtors_master - WHERE ".TB_PREF."debtors_master.sales_type=".TB_PREF."prices.sales_type_id - AND ".TB_PREF."debtors_master.debtor_no='" . $debtor_no . "' - AND ".TB_PREF."prices.stock_id = '" . $stock_id . "' - AND ".TB_PREF."prices.curr_abrev = ".TB_PREF."debtors_master.curr_code"; + if ($date == null) + $date = new_doc_date(); + + if ($factor === null) + { + $myrow = get_sales_type($sales_type_id); + $factor = $myrow['factor']; + } + + $sql = "SELECT price + FROM ".TB_PREF."prices + WHERE stock_id = '" . $stock_id . "' " + ." AND sales_type_id = " . $sales_type_id + ." AND curr_abrev = '$currency'"; - $result = db_query($sql, "There was a problem retrieving the pricing information for the part $stock_id for customer"); + $msg = "There was a problem retrieving the pricing information for the part $stock_id for customer"; + $result = db_query($sql, $msg); - if (db_num_rows($result) != 0) + if (db_num_rows($result) != 0) { - /*There is a price from one of the above so return that */ $myrow = db_fetch_row($result); return $myrow[0]; } - else + if ($factor == 0) return false; // auto price calculations off + + $base_id = get_base_sales_type(); + if ($base_id <= 0) return 0; // auto price calculations off + + $home_curr = get_company_currency(); + + // get all prices which we can use to guess the price. + // alternative is make up to 2 additional sql queries + $sql = "SELECT price, curr_abrev, sales_type_id + FROM ".TB_PREF."prices + WHERE stock_id = '" . $stock_id . "' " + ." AND (sales_type_id = " . $sales_type_id + ." OR sales_type_id = " . $base_id.")" + ." AND (curr_abrev = '$currency'" + ." OR curr_abrev = '$home_curr')"; + + $result = db_query($sql, $msg); + + $prices = array(); + while($myrow = db_fetch($result)) { - return 0; + $prices[$myrow['sales_type_id']][$myrow['curr_abrev']] = $myrow['price']; + } + + $rate = round(get_exchange_rate_from_home_currency($currency, $date), + user_exrate_dec()); + $price = false; + + if (isset($prices[$sales_type_id][$home_curr])) + { + $price = $prices[$sales_type_id][$home_curr] / $rate; + } + elseif (isset($prices[$base_id][$currency])) + { + $price = $prices[$base_id][$currency] * $factor; + } + elseif (isset($prices[$base_id][$home_curr])) + { + $price = $prices[$base_id][$home_curr] * $factor / $rate; } + + return $price === false ? false : round($price, user_price_dec()); +} +//---------------------------------------------------------------------------------------- +// +// Get price for given item or kit. +// When $std==true price is calculated as a sum of all included stock items, +// otherwise all prices set for kits and items are accepted. +// +function get_kit_price($item_code, $currency, $sales_type_id, $factor=null, + $date=null, $std = false) +{ + $kit_price = 0.00; + if (!$std) { + $kit_price = get_price( $item_code, $currency, $sales_type_id, + $factor, $date); + if ($kit_price !== false) { + return $kit_price; + } + } + // no price for kit found, get total value of all items + $kit = get_item_kit($item_code); + + while($item = db_fetch($kit)) { + if ($item['item_code'] != $item['stock_id']) { + // foreign/kit code + $kit_price += $item['quantity'] * get_kit_price( $item['stock_id'], + $currency, $sales_type_id, $factor, $date, $std); + + } else { + // stock item + $kit_price += $item['quantity'] * get_price( $item['stock_id'], + $currency, $sales_type_id, $factor, $date); + } + } + return $kit_price; } //----------------------------------------------------------------------------- @@ -79,7 +171,7 @@ function set_document_parent($cart) if (count($cart->src_docs) == 1) { // if this child document has only one parent - update child link - $del_no = key($cart->src_docs); + $del_no = reset(array_keys($cart->src_docs)); $sql = 'UPDATE '.TB_PREF.'debtor_trans SET trans_link = ' . $del_no . ' WHERE type='.$cart->trans_type.' AND trans_no='. $inv_no ; @@ -123,7 +215,7 @@ function update_parent_line($doc_type, $line_id, $qty_dispatched) { $doc_type = get_parent_type($doc_type); - //echo "update line: $line_id, $doc_type, $qty_dispatch"; +// echo "update line: $line_id, $doc_type, $qty_dispatched"; if ($doc_type==0) return false; else { @@ -180,7 +272,7 @@ function read_sales_trans($doc_type, $trans_no, &$cart) else $cart->trans_no = array($trans_no[0]=>$myrow["version"]); - $cart->set_sales_type($myrow["tpe"], $myrow["sales_type"], $myrow["tax_included"]); + $cart->set_sales_type($myrow["tpe"], $myrow["sales_type"], $myrow["tax_included"],0); $cart->set_customer($myrow["debtor_no"], $myrow["DebtorName"], $myrow["curr_code"], $myrow["discount"]); @@ -193,18 +285,11 @@ function read_sales_trans($doc_type, $trans_no, &$cart) $cart->trans_link = $myrow["trans_link"]; $cart->due_date = sql2date($myrow["due_date"]); $cart->document_date = sql2date($myrow["tran_date"]); - + $cart->dimension_id = $myrow['dimension_id']; // added 2.1 Joe Hunt 2008-11-12 + $cart->dimension2_id = $myrow['dimension2_id']; $cart->Comments = ''; foreach ( $trans_no as $trans ) { - $coms = get_comments($doc_type,$trans); - while($row=db_fetch($coms)) { - $text = $row['memo_']; - if ($text!='') { - if ($cart->Comments!='') - $cart->Comments .= "\n"; - $cart->Comments .= $text; - } - } + $cart->Comments .= get_comments_string($doc_type,$trans); } // FIX this should be calculated sum() for multiply parents @@ -222,7 +307,8 @@ function read_sales_trans($doc_type, $trans_no, &$cart) $result = get_customer_trans_details($doc_type,$trans_no); if (db_num_rows($result) > 0) { for($line_no=0; $myrow = db_fetch($result); $line_no++) { - $cart->add_to_cart($line_no,$myrow["stock_id"],$myrow["quantity"], + $cart->line_items[$line_no] = new line_details( + $myrow["stock_id"],$myrow["quantity"], $myrow["unit_price"], $myrow["discount_percent"], $myrow["qty_done"], $myrow["standard_cost"], $myrow["StockDescription"],$myrow["id"], $myrow["debtor_trans_no"]);