X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=5ca6a49d4c84da915ff56dcc4c3e8b85b173fcd8;hb=2f3375b4493c1b1e0b17c2801298275f22f8d76e;hp=8e4da29d0f467e6e59cf4874cc9b8a532661fd91;hpb=d32bf132413c22c5a19966160fcd574346f63b24;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 8e4da29d..5ca6a49d 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -150,7 +150,7 @@ $opts = array( // default options foreach($opts['search'] as $i=> $s) $opts['search'][$i] = $s . " LIKE " .db_escape(($class=='combo3' ? '' : '%').$txt.'%'); - $opts['where'][] = '('. implode($opts['search'], ' OR ') . ')'; + $opts['where'][] = '('. implode(' OR ', $opts['search']) . ')'; } } } @@ -158,7 +158,7 @@ $opts = array( // default options // sql completion if (count($opts['where'])) { $where = strpos($sql, 'WHERE')==false ? ' WHERE ':' AND '; - $where .= '('. implode($opts['where'], ' AND ') . ')'; + $where .= '('. implode(' AND ', $opts['where']) . ')'; $group_pos = strpos($sql, 'GROUP BY'); if ($group_pos) { $group = substr($sql, $group_pos); @@ -365,7 +365,7 @@ $opts = array( // default options $selector .= ' '.$opts['editlink']; if ($search_box && $opts['cells']) - $str = ($edit_entry!='' ? "$edit_entry" : '')."$selector$img"; + $str = ($edit_entry!='' ? "$edit_entry" : '')."$selector$img"; else $str = $edit_entry.$selector.$img; return $str; @@ -944,7 +944,7 @@ function sales_items_list_cells($label, $name, $selected_id=null, $all_option=fa if ($label != null) echo "$label\n"; echo sales_items_list($name, $selected_id, $all_option, $submit_on_change, - '', array('cells'=>true)); + '', array('cells'=>true, 'max'=>50)); // maximum is set to 50 and not default 255. } function sales_kits_list($name, $selected_id=null, $all_option=false, $submit_on_change=false) @@ -2691,7 +2691,7 @@ function accounts_type_list_row($label, $name, $selected_id=null) function users_list_cells($label, $name, $selected_id=null, $submit_on_change=false, $spec_opt=true) { $where = false; - $sql = " SELECT user_id, IF(real_name = ' ', user_id, real_name) FROM ".TB_PREF."users"; + $sql = " SELECT user_id, IF(real_name = '', user_id, real_name) FROM ".TB_PREF."users"; if ($label != null) echo "$label\n";