- default_focus($name);
- $sql = "SELECT id, CONCAT(reference,' ',name) FROM ".TB_PREF."dimensions";
- if ($showclosed || $showtype)
- {
- $sql .= " WHERE";
- if ($showclosed)
- $sql .= " closed=0";
- if ($showclosed && $showtype)
- $sql .= " AND type_=$showtype";
- else if ($showtype)
- $sql .= " type_=$showtype";
- }
- $sql .= " ORDER BY reference";
- simple_codeandname_list($sql, $name, $selected_id, $no_option, $showname,
- true, $submit_on_change, true);
-}
-
-function dimensions_list_cells($label, $name, $selected_id, $no_option=false, $showname=null,
- $showclosed=false, $showtype=0)
-{
- if ($label != null)
- echo "<td>$label</td>\n";
- echo "<td>";
- dimensions_list($name, $selected_id, $no_option, $showname, false, $showclosed, $showtype);
- echo "</td>\n";
-}
-
-function dimensions_list_row($label, $name, $selected_id, $no_option=false, $showname=null,
- $showclosed=false, $showtype=0)
-{
- echo "<tr>\n";
- dimensions_list_cells($label, $name, $selected_id, $no_option, $showname,
- $showclosed, $showtype);
- echo "</tr>\n";
-}
-
-//---------------------------------------------------------------------------------------------------
-
-function stock_items_list($name, $selected_id, $all_option=false, $submit_on_change=false, $extra="")
-{
- global $all_items;
-
- 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";
-
- if (get_company_pref('no_item_list'))
- {
- global $search_button;
- $edit_name = $name."_edit";
- $edit_button = $name."_button";
-
- $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
-
- if (isset($_POST[$edit_button]))
- {
- $selected_id = $_POST[$name] = "";
- set_focus($name);
- }
- if ($selected_id != "")
- {
- $val = DEFVAL;
- $sql .= " AND stock_id='$selected_id'";
- }
- elseif ($val != "" && $val != DEFVAL)
- {
- $sql .= " AND
- (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
- .TB_PREF."stock_master.description LIKE '%{$val}%')";
- }
- else
- $sql .= " LIMIT 1";
- echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
-
- echo sprintf($search_button, $edit_button);
- }
- $result = db_query($sql);