X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=includes%2Fui%2Fui_lists.inc;h=178a48dbdbfb5800e0280babadd695e1dd112722;hb=0262a2246f9426d154327826cc9bd02c0af3a274;hp=8d7a6c9959da977ac2278e06eb7325ba2d2bb507;hpb=a9ece4be9018bdabd012ac3dc9089d6767c08448;p=fa-stable.git
diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc
index 8d7a6c99..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}%')";
}