X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=178a48dbdbfb5800e0280babadd695e1dd112722;hb=0262a2246f9426d154327826cc9bd02c0af3a274;hp=7c31bd692e85b2b804979a41f8723ab17bb103a0;hpb=7792e42d75607b7e2dbaf73c318b8b7d9367dd17;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 7c31bd69..178a48db 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -3,7 +3,7 @@ include_once($path_to_root . "/includes/banking.inc"); define("DEFVAL", "--"); -$search_button = " "; +$search_button = " "; //$search_button = " "; $all_items = reserved_words::get_all(); @@ -18,7 +18,7 @@ function supplier_list($name, $selected_id, $all_option=false, $submit_on_change default_focus($name); if ($selected_id == null) $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]); - + $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers "; if (get_company_pref('no_supplier_list')) @@ -604,7 +604,7 @@ function stock_items_list($name, $selected_id, $all_option=false, $submit_on_cha default_focus($name); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - + $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id"; @@ -888,7 +888,7 @@ function stock_purchasable_items_list($name, &$selected_id, $all_option=false, $ default_focus($name); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - + $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND mb_flag !='M' "; @@ -911,7 +911,7 @@ function stock_purchasable_items_list($name, &$selected_id, $all_option=false, $ } elseif ($val != "" && $val != DEFVAL) { - $sql = "AND + $sql .= "AND (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR " .TB_PREF."stock_master.description LIKE '%{$val}%')"; } @@ -1574,12 +1574,12 @@ function gl_account_types_list_row($label, $name, $selected_id, $all_option=fals //----------------------------------------------------------------------------------------------- function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false, - $show_group=false, $onchange="") + $show_group=false, $params="") { default_focus($name); echo "