X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sales%2Fincludes%2Fdb%2Fbranches_db.inc;h=bc9543b41f0a8b77b1064806b636f7081cf7a195;hb=a52174853a7922acd6626ac61032ec7674bce9cd;hp=ae63737302d9ec91722c8fed962c8bd82abb23ca;hpb=818719f38b8327cdca616d58b13913dbd174d96a;p=fa-stable.git diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc index ae637373..bc9543b4 100644 --- a/sales/includes/db/branches_db.inc +++ b/sales/includes/db/branches_db.inc @@ -1,52 +1,210 @@ . + See the License here . ***********************************************************************/ +function add_branch($customer_id, $br_name, $br_ref, $br_address, $salesman, $area, + $tax_group_id, $sales_account, $sales_discount_account, $receivables_account, + $payment_discount_account, $default_location, $br_post_address, $disable_trans, $group_no, + $default_ship_via, $notes) +{ + $sql = "INSERT INTO ".TB_PREF."cust_branch (debtor_no, br_name, branch_ref, br_address, + salesman, area, tax_group_id, sales_account, receivables_account, payment_discount_account, + sales_discount_account, default_location, + br_post_address, disable_trans, group_no, default_ship_via, notes) + VALUES (".db_escape($customer_id). ",".db_escape($br_name) . ", " + .db_escape($br_ref) . ", " + .db_escape($br_address) . ", ".db_escape($salesman) . ", " + .db_escape($area) . "," + .db_escape($tax_group_id) . ", " + .db_escape($sales_account) . ", " + .db_escape($receivables_account) . ", " + .db_escape($payment_discount_account) . ", " + .db_escape($sales_discount_account) . ", " + .db_escape($default_location) . ", " + .db_escape($br_post_address) . "," + .db_escape($disable_trans) . ", " + .db_escape($group_no) . ", " + .db_escape($default_ship_via). ", " + .db_escape($notes).")"; + db_query($sql,"The branch record could not be added"); +} + +function update_branch($customer_id, $branch_code, $br_name, $br_ref, $br_address, + $salesman, $area, $tax_group_id, $sales_account, $sales_discount_account, $receivables_account, + $payment_discount_account, $default_location, $br_post_address, $disable_trans, $group_no, + $default_ship_via, $notes) +{ + $sql = "UPDATE ".TB_PREF."cust_branch SET br_name = " . db_escape($br_name) . ", + branch_ref = " . db_escape($br_ref) . ", + br_address = ".db_escape($br_address). ", + salesman= ".db_escape($salesman) . ", + area=".db_escape($area) . ", + tax_group_id=".db_escape($tax_group_id). ", + sales_account=".db_escape($sales_account) . ", + sales_discount_account=".db_escape($sales_discount_account) . ", + receivables_account=".db_escape($receivables_account) . ", + payment_discount_account=".db_escape($payment_discount_account) . ", + default_location=".db_escape($default_location) . ", + br_post_address =".db_escape($br_post_address) . ", + disable_trans=".db_escape($disable_trans) . ", + group_no=".db_escape($group_no) . ", + default_ship_via=".db_escape($default_ship_via) . ", + notes=".db_escape($notes) . " + WHERE branch_code =".db_escape($branch_code) . " + AND debtor_no=".db_escape($customer_id); + db_query($sql,"The branch record could not be updated"); +} + +function delete_branch($customer_id, $branch_code) +{ + delete_entity_contacts('cust_branch', $branch_code); + + $sql="DELETE FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_code)." AND debtor_no=".db_escape($customer_id); + db_query($sql,"could not delete branch"); +} + +function branch_in_foreign_table($customer_id, $branch_code, $table) +{ + $sql= "SELECT COUNT(*) FROM ".TB_PREF."$table WHERE branch_code=".db_escape($branch_code) + ." AND debtor_no = ".db_escape($customer_id); + $result = db_query($sql,"could not query $table"); + $myrow = db_fetch_row($result); + return ($myrow[0] > 0); +} + function get_branch($branch_id) { $sql = "SELECT ".TB_PREF."cust_branch.*,".TB_PREF."salesman.salesman_name FROM ".TB_PREF."cust_branch, ".TB_PREF."salesman WHERE ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code - AND branch_code=$branch_id"; + AND branch_code=".db_escape($branch_id); $result = db_query($sql, "Cannot retreive a customer branch"); - return db_fetch($result); + return db_fetch($result); +} + +function get_cust_branch($customer_id, $branch_code) +{ + $sql = "SELECT * FROM ".TB_PREF."cust_branch + WHERE branch_code=".db_escape($branch_code)." + AND debtor_no=".db_escape($customer_id); + $result = db_query($sql,"check failed"); + return db_fetch($result); } function get_branch_accounts($branch_id) { $sql = "SELECT receivables_account,sales_account, sales_discount_account, payment_discount_account - FROM ".TB_PREF."cust_branch WHERE branch_code=$branch_id"; + FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_id); $result = db_query($sql, "Cannot retreive a customer branch"); - return db_fetch($result); + return db_fetch($result); } function get_branch_name($branch_id) { $sql = "SELECT br_name FROM ".TB_PREF."cust_branch - WHERE branch_code = '$branch_id'"; + WHERE branch_code = ".db_escape($branch_id); $result = db_query($sql,"could not retreive name for branch" . $branch_id); - $myrow = db_fetch_row($result); + $myrow = db_fetch_row($result); return $myrow[0]; } function get_cust_branches_from_group($group_no) { $sql = "SELECT branch_code, debtor_no FROM ".TB_PREF."cust_branch - WHERE group_no = '$group_no'"; + WHERE group_no = ".db_escape($group_no); return db_query($sql,"could not retreive branches for group " . $group_no); } + +function get_default_info_for_branch($customer_id) +{ + $sql = "SELECT name, address, debtor_ref + FROM ".TB_PREF."debtors_master WHERE debtor_no = ".db_escape($customer_id); + $result = db_query($sql,"check failed"); + return db_fetch($result); +} + +function get_sql_for_customer_branches() +{ + $sql = "SELECT " + ."b.branch_code, " + ."b.branch_ref, " + ."b.br_name, " + ."p.name as contact_name, " + ."s.salesman_name, " + ."a.description, " + ."p.phone, " + ."p.fax, " + ."p.email, " + ."t.name AS tax_group_name, " + ."b.inactive + FROM ".TB_PREF."cust_branch b " + . "LEFT JOIN ".TB_PREF."crm_contacts c + ON c.entity_id=b.branch_code AND c.type='cust_branch' AND c.action='general' + LEFT JOIN ".TB_PREF."crm_persons p on c.person_id=p.id," + .TB_PREF."areas a, " + .TB_PREF."salesman s, " + .TB_PREF."tax_groups t + WHERE b.tax_group_id=t.id + AND b.area=a.area_code + AND b.salesman=s.salesman_code + AND b.debtor_no = ".db_escape($_POST['customer_id']); + + if (!get_post('show_inactive')) $sql .= " AND !b.inactive"; + $sql .= " ORDER BY branch_ref"; + + return $sql; +} + +function get_branch_contacts($branch_code, $action=null, $customer_id=null) +{ +/* + $ret = get_crm_persons('cust_branch', $action, $branch_code); + if ($customer_id && !db_num_rows($ret)) { + $ret = get_crm_persons('customer', $action, $customer_id); + } + return $ret; +*/ + $sql = "SELECT p.*, r.action, r.type FROM ".TB_PREF."crm_persons p," + .TB_PREF."crm_contacts r WHERE r.person_id=p.id AND r.type='cust_branch' + AND r.entity_id=".db_escape($branch_code); + + if ($action) + $sql .= ' AND r.action='.db_escape($action); + + $sql .= " GROUP BY person_id"; + + if($customer_id) { + $sql = "($sql) UNION (SELECT p.*, r.action, r.type FROM ".TB_PREF."crm_persons p," + .TB_PREF."crm_contacts r WHERE r.person_id=p.id AND r.type='customer' + AND r.entity_id=".db_escape($customer_id); + if ($action) + $sql .= ' AND r.action='.db_escape($action); + $sql .= " GROUP BY person_id)"; + } + + $res = db_query($sql, "can't retrieve branch contacts"); + $results = array(); + $type = ''; + while($contact = db_fetch($res)) { + if ($type && $type != $contact['type']) break; + $results[] = $contact; + $type = $contact['type']; + } + return $results; +} + ?> \ No newline at end of file