inventory/inquiry/stock_list.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 /**********************************************************************
  13   Page for searching item list and select it to item selection
  14   in pages that have the item dropdown lists.
  15   Author: bogeyman2007 from Discussion Forum. Modified by Joe Hunt
  16 ***********************************************************************/
  17 $page_security = "SA_ITEM";
  18 $path_to_root = "../..";
  19 include_once($path_to_root . "/includes/session.inc");
  20 include_once($path_to_root . "/includes/ui.inc");
  21 include_once($path_to_root . "/inventory/includes/db/items_db.inc");
  22
  23 $mode = get_company_pref('no_item_list');
  24 if ($mode != 0)
  25         $js = get_js_set_combo_item();
  26 else
  27         $js = get_js_select_combo_item();
  28
  29 page(_($help_context = "Items"), true, false, "", $js);
  30
  31 if(get_post("search")) {
  32   $Ajax->activate("item_tbl");
  33 }
  34
  35 start_form(false, false, $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING']);
  36
  37 start_table(TABLESTYLE_NOBORDER);
  38
  39 start_row();
  40
  41 text_cells(_("Description"), "description");
  42 submit_cells("search", _("Search"), "", _("Search items"), "default");
  43
  44 end_row();
  45
  46 end_table();
  47
  48 end_form();
  49
  50 div_start("item_tbl");
  51 start_table(TABLESTYLE);
  52
  53 $th = array("", _("Item Code"), _("Description"), _("Category"));
  54 table_header($th);
  55
  56 $k = 0;
  57 $name = $_GET["client_id"];
  58 $result = get_items_search(get_post("description"), @$_GET['type']);
  59
  60 while ($myrow = db_fetch_assoc($result))
  61 {
  62         alt_table_row_color($k);
  63         $value = $myrow['item_code'];
  64         if ($mode != 0) {
  65                 $text = $myrow['description'];
  66                 ahref_cell(_("Select"), 'javascript:void(0)', '', 'setComboItem(window.opener.document, "'.$name.'",  "'.$value.'", "'.$text.'")');
  67         }
  68         else {
  69                 ahref_cell(_("Select"), 'javascript:void(0)', '', 'selectComboItem(window.opener.document, "'.$name.'", "'.$value.'")');
  70         }
  71         label_cell($myrow["item_code"]);
  72         label_cell($myrow["description"]);
  73         label_cell($myrow["category"]);
  74         end_row();
  75 }
  76
  77 end_table(1);
  78
  79 div_end();
  80 end_page(true);