+ global $all_items, $no_item_list;
+
+ if ($selected_id == null)
+ $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
+
+ if ($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] = "";
+ }
+
+ if ($selected_id != "")
+ {
+ $val = DEFVAL;
+ $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 stock_id='$selected_id'";
+ $result = db_query($sql);
+ }
+ else
+ {
+ if ($val != "" && $val != DEFVAL)
+ {
+ $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
+ (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
+ .TB_PREF."stock_master.description LIKE '%{$val}%')";
+ $result = db_query($sql);
+ }
+ else
+ $result = false;
+ }
+
+ 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);
+ }
+ else
+ {
+ $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";
+ $result = db_query($sql);
+ }
+