"; //$search_button = " "; $all_items = reserved_words::get_all(); // TDB for all list functions : if there is no data, display a link to the releveant // page to add an item, eg. for locations, if no locations, link to Add Location function supplier_list($name, $selected_id, $all_option=false, $submit_on_change=false) { global $all_items; 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')) { 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; $supplier_sql .= "WHERE supplier_id=$selected_id"; } elseif ($val != "" && $val != DEFVAL) { $supplier_sql .= "WHERE supp_name LIKE '%{$val}%'"; } echo " "; echo sprintf($search_button, $edit_button); } $supplier_result = db_query($supplier_sql." ORDER BY supp_name"); if ($submit_on_change==true) echo ""; else echo ""; $company_currency = get_company_currency(); if ($all_option == true) { if ($selected_id == $all_items) { echo "" . _("All Suppliers") . "\n"; } else { echo "" . _("All Suppliers") . "\n"; } if ($selected_id == "") { $selected_id = $all_items; } } while ($supplier_row = db_fetch_row($supplier_result)) { if ($selected_id==$supplier_row[0]) { echo ""; } else { echo ""; } echo $supplier_row[1]; if ($supplier_row[2] != $company_currency) echo " - " . $supplier_row[2]; echo "\n"; if ($selected_id == "") { $selected_id = $supplier_row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($supplier_result); } function supplier_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; supplier_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; } function supplier_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { echo "\n"; supplier_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //---------------------------------------------------------------------------------------------- function customer_list($name, $selected_id, $all_option=false, $submit_on_change=false) { global $all_items; default_focus($name); if ($selected_id == null) $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]); $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master "; if (get_company_pref('no_customer_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] = ""; $_POST['branch_id'] = ""; set_focus($name); } if ($selected_id != "") { $val = DEFVAL; $customer_sql .= "WHERE debtor_no=$selected_id"; } elseif ($val != "" && $val != DEFVAL) { $customer_sql .= "WHERE name LIKE '%{$val}%'"; } echo " "; echo sprintf($search_button, $edit_button); } $customer_result = db_query($customer_sql." ORDER BY name"); if ($submit_on_change==true) echo ""; else echo ""; $company_currency = get_company_currency(); if (($all_option == true)) { if ($selected_id == $all_items) { echo "" . _("All Customers") . "\n"; } else { echo "" . _("All Customers") . "\n"; } if ($selected_id == "") { $selected_id = $all_items; } } while ($customer_row = db_fetch_row($customer_result)) { if ($selected_id == $customer_row[0]) { echo ""; } else { echo ""; } echo $customer_row[1]; if ($customer_row[2] != $company_currency) echo " - " . $customer_row[2]; echo "\n"; // if no initial selection - set the first item // do we want to do this for all lists ???? probably if ($selected_id == "") { $selected_id = $customer_row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($customer_result); } function customer_list_cells($label, $name, $selected_id, $all_option = false, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; customer_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; } function customer_list_row($label, $name, $selected_id, $all_option = false, $submit_on_change=false) { echo "\n"; customer_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------------------ function customer_branches_list($customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false) { global $all_items; default_focus($name); if ($submit_on_change==true) echo ""; else echo ""; $sql = "SELECT branch_code, br_name FROM ".TB_PREF."cust_branch WHERE debtor_no='" . $customer_id . "'"; if ($enabled) $sql .= " AND disable_trans = 0"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($all_option == true) { echo "" . _("All Branches") . "\n"; if ($selected_id == "") { $selected_id = $all_items; } } while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function customer_branches_list_cells($label,$customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; customer_branches_list($customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change); echo "\n"; } function customer_branches_list_row($label,$customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false) { echo ""; customer_branches_list_cells($label, $customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change); echo ""; } //------------------------------------------------------------------------------------------------ function locations_list($name, $selected_id, $all_option=false, $submit_on_change=false) { global $all_items; default_focus($name); if ($submit_on_change == true) echo ""; else echo ""; // if ($selected_id =="" AND isset($_SESSION['UserStockLocation']) AND $_SESSION['UserStockLocation'] !="") { // $selected_id = $_SESSION['UserStockLocation']; // } $sql = "SELECT loc_code, location_name FROM ".TB_PREF."locations"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($all_option == true) { echo "" . _("All Locations") . "\n"; if ($selected_id == "") { $selected_id = $all_items; } } while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function locations_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; locations_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; } function locations_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { echo ""; locations_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //----------------------------------------------------------------------------------------------- function currencies_list($name, &$selected_id, $submit_on_change=false) { default_focus($name); if ($submit_on_change==true) echo ""; else echo ""; $company_currency = get_company_currency(); $sql = "SELECT curr_abrev, currency FROM ".TB_PREF."currencies"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); while ($row = db_fetch_row($result)) { // default to the company currency if ($selected_id == "" && ($row[0] == $company_currency)) { $selected_id = $row[0]; $_POST[$name] = $selected_id; } if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[0] . " - " . $row[1] . "\n"; } echo ""; db_free_result($result); } function currencies_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; currencies_list($name, $selected_id); echo "\n"; } function currencies_list_row($label, $name, $selected_id) { echo "\n"; currencies_list_cells($label, $name, $selected_id); echo "\n"; } //--------------------------------------------------------------------------------------------------- function fiscalyears_list($name, &$selected_id, $submit_on_change=false) { default_focus($name); if ($submit_on_change == true) echo ""; else echo ""; $company_year = get_company_pref('f_year'); $sql = "SELECT * FROM ".TB_PREF."fiscal_year ORDER BY begin"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); while ($row = db_fetch_row($result)) { // default to the company current fiscal year if ($selected_id == "" && ($row[0] == $company_year)) { $selected_id = $row[0]; $_POST[$name] = $selected_id; } if ($selected_id == $row[0]) { echo ""; } else { echo ""; } if ($row[3] == 0) $how = _('Active'); else $how = _('Closed'); $row[1] = sql2date($row[1]); $row[2] = sql2date($row[2]); echo $row[1] . " - " . $row[2] . " " . $how . "\n"; } echo ""; db_free_result($result); } function fiscalyears_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; fiscalyears_list($name, $selected_id); echo "\n"; } function fiscalyears_list_row($label, $name, $selected_id) { echo "\n"; fiscalyears_list_cells($label, $name, $selected_id); echo "\n"; } //--------------------------------------------------------------------------------------------------- function simple_codeandname_list($sql, $name, &$selected_id, $all_option=false, $all_option_name=null, $all_option_numeric=false, $submit_on_change=false, $returnzero=false) { global $all_items; default_focus($name); if ($submit_on_change == true) echo ""; else echo ""; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($all_option == true) { if ($returnzero) $reserved_word = 0; elseif ($all_option_numeric) $reserved_word = reserved_words::get_all_numeric(); else $reserved_word = $all_items; if ($selected_id == $reserved_word) { echo "$all_option_name\n"; } else { echo "$all_option_name\n"; } if ($selected_id == "") { $selected_id = $reserved_word; } } $result = db_query($sql); while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[1] . "\n"; if (!$returnzero && $selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } //------------------------------------------------------------------------------------ function dimensions_list($name, &$selected_id, $no_option=false, $showname=null, $submit_on_change=false, $showclosed=false, $showtype=1) { 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 "$label\n"; echo ""; dimensions_list($name, $selected_id, $no_option, $showname, false, $showclosed, $showtype); echo "\n"; } function dimensions_list_row($label, $name, $selected_id, $no_option=false, $showname=null, $showclosed=false, $showtype=0) { echo "\n"; dimensions_list_cells($label, $name, $selected_id, $no_option, $showname, $showclosed, $showtype); echo "\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}%')"; } echo " "; echo sprintf($search_button, $edit_button); } $result = db_query($sql); echo ""; if (($all_option == true)) { if ($selected_id == $all_items) { echo "" . _("All Items") . "\n"; } else { echo "" . _("All Items") . "\n"; } if ($selected_id == "") { $selected_id = $all_items; } } while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "\n"; // if no initial selection - set the first item // do we want to do this for all lists ???? probably if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function stock_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false, $extra="") { if ($label != null) echo "$label\n"; echo ""; stock_items_list($name, $selected_id, $all_option, $submit_on_change, $extra); echo "\n"; } function stock_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { echo "\n"; stock_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------ function stock_bom_items_list($name, $selected_id, $all_option=false, $submit_on_change=false) { global $all_items; default_focus($name); if ($submit_on_change==true) echo ""; else echo ""; $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 (".TB_PREF."stock_master.mb_flag='M' OR ".TB_PREF."stock_master.mb_flag='K')"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if (($all_option == true)) { if ($selected_id == $all_items) { echo "" . _("All Items") . "\n"; } else { echo "" . _("All Items") . "\n"; } if ($selected_id == "") { $selected_id = $all_items; } } while ($row = db_fetch_row($result)) { if ($selected_id==$row[0]) { echo ""; } else { echo ""; } echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function stock_bom_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; stock_bom_items_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; } function stock_bom_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { echo "\n"; stock_bom_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------ function base_stock_items_list($sql, $name, &$selected_id, $all_option=false, $all_option_name="", $submit_on_change=false, $extra="") { global $all_items; default_focus($name); if ($submit_on_change==true) echo ""; else if ($extra != "") echo ""; else echo ""; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($all_option == true) { if ($selected_id == $all_items) { echo "$all_option_name\n"; } else { echo "$all_option_name\n"; } if ($selected_id == "") { $selected_id = $all_items; } } while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } //------------------------------------------------------------------------------------ function stock_manufactured_items_list($name, &$selected_id, $all_option=false, $submit_on_change=false) { $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 (".TB_PREF."stock_master.mb_flag='M')"; base_stock_items_list($sql, $name, $selected_id, $all_option, _("All Items"), $submit_on_change); } function stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; stock_manufactured_items_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; } function stock_manufactured_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false) { echo "\n"; stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------ function stock_component_items_list($name, $parent_stock_id, &$selected_id, $all_option=false, $submit_on_change=false) { $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 != '$parent_stock_id'"; base_stock_items_list($sql, $name, $selected_id, $all_option, _("All Items"), $submit_on_change); } //------------------------------------------------------------------------------------ function stock_purchasable_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 AND mb_flag !='M' "; if (get_company_pref('no_item_list')) { $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}%')"; } echo " "; echo " "; } $result = db_query($sql); if ($submit_on_change==true) echo ""; else if ($extra != "") echo ""; else echo ""; if ($all_option == true) { if ($selected_id == $all_items) { echo ""._("All Items")."\n"; } else { echo ""._("All Items")."\n"; } if ($selected_id == "") { $selected_id = $all_items; } } while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function stock_purchasable_items_list_cells($label, $name, &$selected_id, $all_option=false, $submit_on_change=false, $extra = "") { if ($label != null) echo "$label\n"; echo ""; stock_purchasable_items_list($name, $selected_id, $all_option, $submit_on_change, $extra); echo "\n"; } function stock_purchasable_items_list_row($label, $name, &$selected_id, $all_option=false, $submit_on_change=false) { echo "\n"; stock_purchasable_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------ function stock_costable_items_list($name, &$selected_id, $all_option=false, $submit_on_change=false) { $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 !='D'"; base_stock_items_list($sql, $name, $selected_id, $all_option, _("All Items"), $submit_on_change); } //------------------------------------------------------------------------------------ function stock_item_types_list_row($label, $name, $selected_id, $enabled=true) { default_focus($name); echo ""; if ($label != NULL) echo "$label\n"; echo ""; if ($enabled) echo "\n"; else echo "\n"; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($selected_id == "") $_POST[$name] = $selected_id = "B"; echo "" . _("Manufactured"). "\n"; echo "" . _("Purchased"). "\n"; echo "" . _("Service"). "\n"; echo "\n"; } function stock_units_list_row($label, $name, $value, $enabled=true) { global $stock_units; default_focus($name); $result = get_all_item_units(); echo "$label\n"; if ($enabled) echo ""; else echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); while($unit = db_fetch($result)) { if ($value == "") { $_POST[$name] = $unit['abbr']; } $descr = $unit['name']; if ($value==$unit['abbr']) { echo "$descr\n"; } else { echo "$descr\n"; } } echo "\n"; } //------------------------------------------------------------------------------------ function tax_types_list($name, $selected_id, $none_option=false, $none_option_name=null, $submit_on_change=false) { simple_codeandname_list("SELECT id, CONCAT(name, ' (',rate,'%)') as name FROM ".TB_PREF."tax_types", $name, $selected_id, $none_option, $none_option_name, true, $submit_on_change); } function tax_types_list_cells($label, $name, $selected_id, $none_option=false, $none_option_name=null, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; tax_types_list($name, $selected_id, $none_option, $none_option_name, $submit_on_change); echo "\n"; } function tax_types_list_row($label, $name, $selected_id, $none_option=false, $none_option_name=null, $submit_on_change=false) { echo "\n"; tax_types_list_cells($label, $name, $selected_id, $none_option, $none_option_name, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------ function tax_groups_list($name, $selected_id, $none_option=false, $none_option_name=null, $submit_on_change=false) { simple_codeandname_list("SELECT id, name FROM ".TB_PREF."tax_groups ORDER BY id", $name, $selected_id, $none_option, $none_option_name, true, $submit_on_change); } function tax_groups_list_cells($label, $name, $selected_id, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; tax_groups_list($name, $selected_id, false, null, $submit_on_change); echo "\n"; } function tax_groups_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; tax_groups_list_cells($label, $name, $selected_id, false, null, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------ function item_tax_types_list($name, $selected_id) { simple_codeandname_list("SELECT id, name FROM ".TB_PREF."item_tax_types ORDER BY id", $name, $selected_id); } function item_tax_types_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; item_tax_types_list($name, $selected_id); echo "\n"; } function item_tax_types_list_row($label, $name, $selected_id) { echo "\n"; item_tax_types_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------ function shippers_list($name, $selected_id) { simple_codeandname_list("SELECT shipper_id, shipper_name FROM ".TB_PREF."shippers", $name, $selected_id); } function shippers_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; shippers_list($name, $selected_id); echo "\n"; } function shippers_list_row($label, $name, $selected_id) { echo "\n"; shippers_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------- function sales_persons_list($name, $selected_id) { simple_codeandname_list("SELECT salesman_code, salesman_name FROM ".TB_PREF."salesman", $name, $selected_id); } function sales_persons_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo "\n"; sales_persons_list($name, $selected_id); echo "\n"; } function sales_persons_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; sales_persons_list_cells($label, $name, $selected_id, $submit_on_change=false); echo "\n"; } //------------------------------------------------------------------------------------ function sales_areas_list($name, $selected_id) { simple_codeandname_list("SELECT area_code, description FROM ".TB_PREF."areas", $name, $selected_id); } function sales_areas_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; sales_areas_list($name, $selected_id); echo "\n"; } function sales_areas_list_row($label, $name, $selected_id) { echo "\n"; sales_areas_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------ function workorders_list($name, $selected_id) { simple_codeandname_list("SELECT id, wo_ref FROM ".TB_PREF."workorders WHERE closed=0", $name, $selected_id); } function workorders_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; workorders_list($name, $selected_id); echo "\n"; } function workorders_list_row($label, $name, $selected_id) { echo "\n"; workorders_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------ function payment_terms_list($name, $selected_id) { simple_codeandname_list("SELECT terms_indicator, terms FROM ".TB_PREF."payment_terms", $name, $selected_id); } function payment_terms_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; payment_terms_list($name, $selected_id); echo "\n"; } function payment_terms_list_row($label, $name, $selected_id) { echo "\n"; payment_terms_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------ function credit_status_list($name, $selected_id) { simple_codeandname_list("SELECT id, reason_description FROM ".TB_PREF."credit_status", $name, $selected_id); } function credit_status_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; credit_status_list($name, $selected_id); echo "\n"; } function credit_status_list_row($label, $name, $selected_id) { echo "\n"; credit_status_list_cells($label, $name, $selected_id); echo "\n"; } //----------------------------------------------------------------------------------------------- function sales_types_list($name, $selected_id, $submit_on_change=false) { simple_codeandname_list("SELECT id, sales_type FROM ".TB_PREF."sales_types", $name, $selected_id, false, null, false, $submit_on_change); } function sales_types_list_cells($label, $name, $selected_id, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; sales_types_list($name, $selected_id, $submit_on_change); echo "\n"; } function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; sales_types_list_cells($label, $name, $selected_id, $submit_on_change); echo "\n"; } //----------------------------------------------------------------------------------------------- function movement_types_list($name, $selected_id) { simple_codeandname_list("SELECT id, name FROM ".TB_PREF."movement_types", $name, $selected_id); } function movement_types_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; movement_types_list($name, $selected_id); echo "\n"; } function movement_types_list_row($label, $name, $selected_id) { echo "\n"; movement_types_list_cells($label, $name, $selected_id); echo "\n"; } //----------------------------------------------------------------------------------------------- function bank_trans_types_list($name, $selected_id) { simple_codeandname_list("SELECT id, name FROM ".TB_PREF."bank_trans_types", $name, $selected_id); } function bank_trans_types_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; bank_trans_types_list($name, $selected_id); echo "\n"; } function bank_trans_types_list_row($label, $name, $selected_id) { echo "\n"; bank_trans_types_list_cells($label, $name, $selected_id); echo "\n"; } //----------------------------------------------------------------------------------------------- function workcenter_list($name, $selected_id, $all_option=false) { global $all_items; default_focus($name); echo ""; $sql = "SELECT id, name FROM ".TB_PREF."workcentres"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($all_option == true) { if ($selected_id == $all_items) { echo "" . _("All Work Centres") . "\n"; } else { echo "" . _("All Work Centres") . "\n"; } } while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[1] . "\n"; } echo ""; db_free_result($result); } function workcenter_list_cells($label, $name, $selected_id, $all_option=false) { default_focus($name); if ($label != null) echo "$label\n"; echo ""; workcenter_list($name, $selected_id, $all_option); echo "\n"; } function workcenter_list_row($label, $name, $selected_id, $all_option=false) { echo "\n"; workcenter_list_cells($label, $name, $selected_id, $all_option); echo "\n"; } //----------------------------------------------------------------------------------------------- function bank_accounts_list($name, $selected_id, $submit_on_change=false) { default_focus($name); if ($submit_on_change==true) echo ""; else echo ""; $company_currency = get_company_currency(); $sql = "SELECT ".TB_PREF."bank_accounts.account_code, bank_account_name, bank_curr_code FROM ".TB_PREF."bank_accounts, ".TB_PREF."chart_master WHERE ".TB_PREF."bank_accounts.account_code=".TB_PREF."chart_master.account_code"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[1]; if ($company_currency != $row[2]) echo " - " . $row[2]; echo "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function bank_accounts_list_cells($label, $name, $selected_id, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; bank_accounts_list($name, $selected_id, $submit_on_change); echo "\n"; } function bank_accounts_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; bank_accounts_list_cells($label, $name, $selected_id, $submit_on_change); echo "\n"; } //----------------------------------------------------------------------------------------------- function class_list($name, $selected_id, $submit_on_change=false) { default_focus($name); if ($submit_on_change==true) echo ""; else echo ""; $sql = "SELECT cid, class_name FROM ".TB_PREF."chart_class"; $result = db_query($sql); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } echo $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function class_list_cells($label, $name, $selected_id, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; class_list($name, $selected_id, $submit_on_change); echo "\n"; } function class_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; class_list_cells($label, $name, $selected_id, $submit_on_change); echo "\n"; } //----------------------------------------------------------------------------------------------- function stock_categories_list($name, $selected_id) { simple_codeandname_list("SELECT category_id, description FROM ".TB_PREF."stock_category ORDER BY category_id", $name, $selected_id); } function stock_categories_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; stock_categories_list($name, $selected_id); echo "\n"; } function stock_categories_list_row($label, $name, $selected_id) { echo "\n"; stock_categories_list_cells($label, $name, $selected_id); echo "\n"; } //----------------------------------------------------------------------------------------------- function gl_account_types_list($name, $selected_id, $all_option, $all_option_name, $all_option_numeric) { simple_codeandname_list("SELECT id, name FROM ".TB_PREF."chart_types ORDER BY id", $name, $selected_id, $all_option, $all_option_name, $all_option_numeric); } function gl_account_types_list_cells($label, $name, $selected_id, $all_option=false, $all_option_name=null, $all_option_numeric=false) { if ($label != null) echo "$label\n"; echo ""; gl_account_types_list($name, $selected_id, $all_option, $all_option_name, $all_option_numeric); echo "\n"; } function gl_account_types_list_row($label, $name, $selected_id, $all_option=false, $all_option_name=null, $all_option_numeric=false) { echo "\n"; gl_account_types_list_cells($label, $name, $selected_id, $all_option, $all_option_name, $all_option_numeric); echo "\n"; } //----------------------------------------------------------------------------------------------- function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false, $show_group=false, $params="") { default_focus($name); echo ""; if ($skip_bank_accounts) $sql = "SELECT ".TB_PREF."chart_master.account_code, ".TB_PREF."chart_master.account_name, ".TB_PREF."chart_types.name FROM (".TB_PREF."chart_master,".TB_PREF."chart_types) LEFT JOIN ".TB_PREF."bank_accounts ON ".TB_PREF."chart_master.account_code=".TB_PREF."bank_accounts.account_code WHERE ".TB_PREF."bank_accounts.account_code IS NULL AND ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id ORDER BY account_code;"; else $sql = "SELECT account_code, account_name,".TB_PREF."chart_types.name FROM ".TB_PREF."chart_master, ".TB_PREF."chart_types WHERE ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id ORDER BY account_code"; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); $result = db_query($sql, "query chart master"); while ($row = db_fetch_row($result)) { if ($selected_id == $row[0]) { echo ""; } else { echo ""; } //echo str_pad($row[0],6,'0', STR_PAD_LEFT) . " " . $row[2] . " " . $row[1]; if ($show_group) echo $row[0] . " " . $row[2] . " " . $row[1] . "\n"; else echo $row[0] . " " . $row[1] . "\n"; if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; } } echo ""; db_free_result($result); } function gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts=false, $show_group=false, $params="") { if ($label != null) echo "$label\n"; echo ""; gl_all_accounts_list($name, $selected_id, $skip_bank_accounts, $show_group, $params); echo "\n"; } function gl_all_accounts_list_row($label, $name, $selected_id, $skip_bank_accounts=false, $show_group=false, $params="") { echo "\n"; gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts, $show_group, $params); echo "\n"; } function yesno_list($name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false) { default_focus($name); if ($submit_on_change == true) echo ""; else echo ""; if (strlen($name_yes) == 0) { unset($name_yes); } if (strlen($name_no) == 0) { unset($name_no); } if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? 0 : $_POST[$name]); if ($selected_id == 0) echo ""; else echo ""; if (!isset($name_yes)) echo _("Yes") . "\n"; else echo $name_yes . "\n"; if ($selected_id == 0) echo ""; else echo ""; if (!isset($name_no)) echo _("No") . "\n"; else echo $name_no . "\n"; echo ""; } function yesno_list_cells($label, $name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; yesno_list($name, $selected_id, $name_yes, $name_no, $submit_on_change); echo "\n"; } function yesno_list_row($label, $name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false) { echo "\n"; yesno_list_cells($label, $name, $selected_id, $name_yes, $name_no, $submit_on_change); echo "\n"; } //------------------------------------------------------------------------------------------------ function languages_list($name, &$selected_id) { global $installed_languages; default_focus($name); echo ""; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($installed_languages as $lang) { echo "" . $lang['name'] . "\n"; } } function languages_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; languages_list($name, $selected_id); echo "\n"; } function languages_list_row($label, $name, $selected_id) { echo "\n"; languages_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------------------ function bank_account_types_list($name, &$selected_id) { $bank_account_types = bank_account_types::get_all(); default_focus($name); echo ""; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($bank_account_types as $type) { echo "" . $type['name'] . "\n"; } } function bank_account_types_list_cells($label, $name, $selected_id) { if ($label != null) echo "$label\n"; echo ""; bank_account_types_list($name, $selected_id); echo "\n"; } function bank_account_types_list_row($label, $name, $selected_id) { echo "\n"; bank_account_types_list_cells($label, $name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------------------ function payment_person_types_list($name, $selected_id, $related=null) { $types = payment_person_types::get_all(); default_focus($name); echo ""; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($types as $type) { if (payment_person_types::has_items($type['id'])) { if ($selected_id == "") $_POST[$name] = $selected_id = $type['id']; echo "" . $type['name'] . "\n"; } } } function payment_person_types_list_cells($label, $name, $selected_id, $related=null) { if ($label != null) echo "$label\n"; echo ""; payment_person_types_list($name, $selected_id, $related); echo "\n"; } function payment_person_types_list_row($label, $name, $selected_id, $related=null) { echo "\n"; payment_person_types_list_cells($label, $name, $selected_id, $related); echo "\n"; } //------------------------------------------------------------------------------------------------ function wo_types_list($name, &$selected_id) { $types = wo_types::get_all(); default_focus($name); echo ""; if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($types as $type) { echo "" . $type['name'] . "\n"; } echo ""; } function wo_types_list_row($label, $name, &$selected_id) { echo "$label\n"; wo_types_list($name, $selected_id); echo "\n"; } //------------------------------------------------------------------------------------------------ function dateformats_list_row($label, $name, $value) { global $dateformats; default_focus($name); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; foreach ($dateformats as $df) { if ($value==$counter) { echo "$df\n"; } else { echo "$df\n"; } $counter++; } echo "\n"; } function dateseps_list_row($label, $name, $value) { global $dateseps; default_focus($name); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; foreach ($dateseps as $ds) { if ($value==$counter) { echo "$ds\n"; } else { echo "$ds\n"; } $counter++; } echo "\n"; } function thoseps_list_row($label, $name, $value) { global $thoseps; default_focus($name); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; foreach ($thoseps as $ts) { if ($value==$counter) { echo "$ts\n"; } else { echo "$ts\n"; } $counter++; } echo "\n"; } function decseps_list_row($label, $name, $value) { global $decseps; default_focus($name); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; foreach ($decseps as $ds) { if ($value==$counter) { echo "$ds\n"; } else { echo "$ds\n"; } $counter++; } echo "\n"; } function themes_list_row($label, $name, $value) { global $path_to_root; default_focus($name); $path = $path_to_root.'/themes/'; $themes = array(); $themedir = opendir($path); while(false !== ($fname = readdir($themedir))) { if($fname!='.' && $fname!='..' && $fname!='CVS' && is_dir($path.$fname)) { $themes[] = $fname; } } sort($themes); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($themes as $th) { if ($value==$th) { echo "$th\n"; } else { echo "$th\n"; } } echo "\n"; } function pagesizes_list_row($label, $name, $value) { global $pagesizes; default_focus($name); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($pagesizes as $pz) { if ($value==$pz) { echo "$pz\n"; } else { echo "$pz\n"; } } echo "\n"; } function security_headings_list_row($label, $name, $value) { global $security_headings; default_focus($name); echo "$label\n"; echo ""; if ($value == null) $value = (!isset($_POST[$name]) ? 0 : (int)$_POST[$name]); $counter=0; foreach ($security_headings as $sh) { if ($value==$counter) { echo "$sh\n"; } else { echo "$sh\n"; } $counter++; } echo "\n"; } function systypes_list_cells($label, $name, $value, $submit_on_change=false) { global $systypes_array; default_focus($name); if ($label != null) echo "$label\n"; echo ""; else echo ">"; if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); foreach ($systypes_array as $key=>$type) { if ($value==$key) { echo "".$type['name']."\n"; } else { echo "".$type['name']."\n"; } } echo "\n"; } function systypes_list_row($label, $name, $value, $submit_on_change=false) { echo "\n"; systypes_list_cells($label, $name, $value, $submit_on_change); echo "\n"; } function cust_allocations_list_cells($label, $name, $selected) { global $all_items; default_focus($name); if ($label != null) label_cell($label); if ($selected == null) $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]); echo ""; echo "" . _("All Types"). "\n"; echo "" . _("Sales Invoices"). "\n"; echo "" . _("Overdue Invoices"). "\n"; echo "" . _("Payments"). "\n"; echo "" . _("Credit Notes"). "\n"; echo "" . _("Delivery Notes"). "\n"; echo "\n"; } function supp_allocations_list_cells($name, $selected) { global $all_items; default_focus($name); if ($selected == null) $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]); echo ""; echo "" . _("All Types"). "\n"; echo "" . _("Invoices"). "\n"; echo "" . _("Overdue Invoices"). "\n"; echo "" . _("Payments"). "\n"; echo "" . _("Credit Notes"). "\n"; echo "" . _("Overdue Credit Notes"). "\n"; echo "\n"; } function policy_list_cells($label, $name, $selected) { default_focus($name); if ($selected == null) { $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]); if ($selected == "") $_POST[$name] = $selected; } if ($label != null) label_cell($label); echo ""; echo "" . _("Automatically put balance on back order"). "\n"; echo "" . _("Cancel any quantites not delivered"). "\n"; echo "\n"; } function policy_list_row($label, $name, $selected) { echo "\n"; policy_list_cells($label, $name, $selected); echo "\n"; } function credit_type_list_cells($label, $name, $selected, $submit_on_change=false) { default_focus($name); if ($selected == null) { $selected = (!isset($_POST[$name]) ? "Return" : $_POST[$name]); if ($selected == "Return") $_POST[$name] = $selected; } if ($label != null) label_cell($label); echo ""; else echo ">"; echo "" . _("Items Returned to Inventory Location"). "\n"; echo "" . _("Items Written Off"). "\n"; echo "\n"; } function credit_type_list_row($label, $name, $selected, $submit_on_change=false) { echo "\n"; credit_type_list_cells($label, $name, $selected, $submit_on_change); echo "\n"; } function number_list($name, $selected, $from, $to, $firstlabel="") { default_focus($name); if ($selected == null) { $selected = (!isset($_POST[$name]) ? $from : $_POST[$name]); if ($selected == $from) $_POST[$name] = $selected; } echo ""; for ($i = $from; $i <= $to; $i++) { if ($i == 0 && $firstlabel != "") $label = $firstlabel; else $label = $i; if ($selected == $i) { echo "$label\n"; } else { echo "$label\n"; } } echo "\n"; } function number_list_cells($label, $name, $selected, $from, $to) { if ($label != null) label_cell($label); echo "\n"; number_list($name, $selected, $from, $to); echo "\n"; } function number_list_row($label, $name, $selected, $from, $to) { echo "\n"; number_list_cells($label, $name, $selected, $from, $to); echo "\n"; } ?>