$path_to_root = "../..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/ui.inc");
+include_once($path_to_root . "/purchasing/includes/db/suppliers_db.inc");
$mode = get_company_pref('no_supplier_list');
if ($mode != 0)
page(_($help_context = "Suppliers"), true, false, "", $js);
-if (isset($SysPrefs->max_rows_in_search))
- $limit = $SysPrefs->max_rows_in_search;
-else
- $limit = 10;
-
-// Activate Ajax on form submit
if(get_post("search")) {
$Ajax->activate("supplier_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 supplier
-// hyperlink_params($path_to_root . "/purchasing/manage/suppliers.php", _("Add new"), "popup=1");
-// END: Link to add new supplier
-
-// BEGIN: Supplier list
div_start("supplier_tbl");
start_table(TABLESTYLE);
table_header($th);
-// Query based on function supplier_list in includes/ui/ui_lists.inc.
-$sql = "SELECT supplier_id, supp_name, supp_ref, address, gst_no FROM ".TB_PREF."suppliers
- WHERE (supp_name LIKE " . db_escape("%" . get_post("supplier"). "%") . " OR
- supp_ref LIKE " . db_escape("%" . get_post("supplier"). "%") . " OR
- address LIKE " . db_escape("%" . get_post("supplier"). "%") . " OR
- gst_no LIKE " . db_escape("%" . get_post("supplier"). "%") . ")
- ORDER BY supp_name LIMIT 0, $limit"; // We only display 10 items.
-$result = db_query($sql, "Failed in retreiving supplier list.");
-
-$k = 0; //row colour counter
+$k = 0;
$name = $_GET["client_id"];
+$result = get_suppliers_search(get_post("supplier"));
while ($myrow = db_fetch_assoc($result)) {
alt_table_row_color($k);
$value = $myrow['supplier_id'];
}
end_table(1);
-
div_end();
-// END: Supplier list
-
end_page(true);