$path_to_root = "../..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/ui.inc");
+include_once($path_to_root . "/sales/includes/db/branches_db.inc");
$js = get_js_select_combo_item();
-if (isset($SysPrefs->max_rows_in_search))
- $limit = $SysPrefs->max_rows_in_search;
-else
- $limit = 10;
-
page(_($help_context = "Customer Branches"), true, false, "", $js);
-// Activate Ajax on form submit
if(get_post("search")) {
$Ajax->activate("customer_branch_tbl");
}
-// BEGIN: Filter form. Use query string so the client_id will not disappear
-// after ajax form post.
start_form(false, false, $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING']);
start_table(TABLESTYLE_NOBORDER);
end_table();
end_form();
-// END: Filter form
-
-// BEGIN: Link to add new customer branch
-// hyperlink_params($path_to_root . "/sales/manage/customer_branches.php", _("Add new"), "debtor_no=" . strip_tags($_GET["SelectedBranch"]) . "&popup=1");
-// END: Link to add new customer branch
-// BEGIN: Customer branches list
div_start("customer_branch_tbl");
-
start_table(TABLESTYLE);
$th = array("", _("Ref"), _("Branch"), _("Contact"), _("Phone"));
table_header($th);
-// Query based on function get_sql_for_customer_branches in includes/db/branches_db.inc.
-$sql = "SELECT
- b.branch_code,
- b.branch_ref,
- b.br_name,
- p.name as contact_name,
- p.phone
- 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
- WHERE b.debtor_no = ".db_escape($_GET["customer_id"])."
- AND b.br_name LIKE " . db_escape("%" . get_post("branch"). "%") . "
- ORDER BY b.br_name LIMIT 0, $limit"; // We only display 10 items.
-
-$result = db_query($sql, "Failed in retreiving branches list.");
-
-$k = 0; //row colour counter
+$k = 0;
$name = $_GET["client_id"];
+$result = get_branches_search($_GET["customer_id"], get_post("branch"));
while ($myrow = db_fetch_assoc($result))
{
alt_table_row_color($k);
end_table(1);
div_end();
-// END: Customer list
-
end_page(true);