X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=7835f33905bbef4d64bd11b4bb774cae71af5e1f;hb=cc36638b65572da4867b7622723d6ed0135525b8;hp=08e73f0225032bb8f71a2bc4df297dcc740a1744;hpb=818719f38b8327cdca616d58b13913dbd174d96a;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 08e73f02..7835f339 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -1,16 +1,15 @@ . + See the License here . ***********************************************************************/ include_once($path_to_root . "/includes/banking.inc"); -include_once($path_to_root . "/includes/reserved.inc"); include_once($path_to_root . "/includes/types.inc"); include_once($path_to_root . "/includes/current_user.inc"); @@ -20,7 +19,7 @@ $_search_button = " "; -$all_items = reserved_words::get_all(); +$all_items = ALL_TEXT; //---------------------------------------------------------------------------- // Universal sql combo generator @@ -41,7 +40,6 @@ $opts = array( // default options // submit on select parameters 'default' => '', // default value when $_POST is not set 'select_submit' => false, //submit on select: true/false - 'edit_submit' => false, // call editor on F4 'async' => true, // select update via ajax (true) vs _page_body reload // search box parameters 'sel_hint' => null, @@ -54,12 +52,14 @@ $opts = array( // default options 'search_submit' => true, //search submit button: true/false 'size' => 8, // size and max of box tag 'max' => 50, + 'height' => false, // number of lines in select box 'cells' => false, // combo displayed as 2 cells 'search' => array(), // sql field names to search 'format' => null, // format functions for regular options 'disabled' => false, 'box_hint' => null, // box/selectors hints; null = std see below - 'category' => false // category column name or false + 'category' => false, // category column name or false + 'show_inactive' => false // show inactive records. ); // ------ merge options with defaults ---------- if($options != null) @@ -68,7 +68,7 @@ $opts = array( // default options $search_box = $opts['search_box']===true ? '_'.$name.'_edit' : $opts['search_box']; $search_submit = $opts['search_submit']===true ? '_'.$name.'_button' : $opts['search_submit']; - $select_submit = $opts['select_submit']===true ? '_'.$name.'_update' : $opts['select_submit']; + $select_submit = $opts['select_submit']; $spec_id = $opts['spec_id']; $spec_option = $opts['spec_option']; $by_id = ($opts['type'] == 0); @@ -94,7 +94,7 @@ $opts = array( // default options $rel = ''; $limit = ''; - if (isset($_POST[$select_submit])) { + if (isset($_POST['_'.$name.'_update'])) { if ($by_id) $txt = $_POST[$name]; if (!$opts['async']) @@ -167,6 +167,12 @@ $opts = array( // default options $sel = 'selected'; $found = $value; } + // show selected option even if inactive + if (!$opts['show_inactive'] && @$contact_row['inactive'] && $sel==='') { + continue; + } else + $optclass = @$contact_row['inactive'] ? "class='inactive'" : ''; + if ($first_id === false) { $first_id = $value; $first_opt = $descr; @@ -176,7 +182,7 @@ $opts = array( // default options $selector .= "\n"; $lastcat = $cat; } - $selector .= "\n"; + $selector .= "\n"; } db_free_result($result); } @@ -185,8 +191,11 @@ $opts = array( // default options if ($spec_option !== false) { // if special option used - add it $first_id = $spec_id; $first_opt = $spec_option; +// } +// if($first_id !== false) { $sel = $found===false ? 'selected' : ''; - $selector = "\n" + $optclass = @$contact_row['inactive'] ? "class='inactive'" : ''; + $selector = "\n" . $selector; } @@ -199,9 +208,10 @@ $opts = array( // default options $txt = $found; $Ajax->addUpdate($name, $search_box, $txt ? $txt : ''); } - $aspect = $opts['edit_submit'] ? " aspect='editable'" : ''; - $selector = "\n"; + $selector = "\n"; $Ajax->addUpdate($name, "_{$name}_sel", $selector); @@ -214,7 +224,7 @@ $opts = array( // default options // button class selects form reload/ajax selector update $selector .= sprintf($_select_button, $disabled, user_theme(), (fallback_mode() ? '' : 'display:none;'), - $select_submit)."\n"; + '_'.$name.'_update')."\n"; } // ------ make combo ---------- @@ -233,7 +243,7 @@ $opts = array( // default options $search_submit)."\n"; } } - default_focus($name); + default_focus(($search_box && $by_id) ? $search_box : $name); $str = $selector; if ($search_box && $opts['cells']) echo ($edit_entry!='' ? "$edit_entry" : '')."$selector"; @@ -264,17 +274,17 @@ $opts = array( // default options 'spec_option'=>false, // option text or false 'spec_id' => 0, // option id 'select_submit' => false, //submit on select: true/false - 'edit_submit' => false, // call editor on F4 'async' => true, // select update via ajax (true) vs _page_body reload 'default' => '', // default value when $_POST is not set // search box parameters + 'height' => false, // number of lines in select box 'sel_hint' => null, 'disabled' => false ); // ------ merge options with defaults ---------- if($options != null) $opts = array_merge($opts, $options); - $select_submit = $opts['select_submit']===true ? '_'.$name.'_update' : $opts['select_submit']; + $select_submit = $opts['select_submit']; $spec_id = $opts['spec_id']; $spec_option = $opts['spec_option']; $disabled = $opts['disabled'] ? "disabled" : ''; @@ -283,7 +293,7 @@ $opts = array( // default options $selected_id = get_post($name, $opts['default']); } - if (isset($_POST[$select_submit])) { + if (isset($_POST[ '_'.$name.'_update'])) { if (!$opts['async']) $Ajax->activate('_page_body'); else @@ -297,7 +307,7 @@ $opts = array( // default options //if($name=='SelectStockFromList') display_error($sql); foreach($items as $value=>$descr) { $sel = ''; - if ($selected_id == $value) { + if ((string)$selected_id === (string)$value) { $sel = 'selected'; $found = $value; } @@ -318,12 +328,14 @@ $opts = array( // default options } if ($found === false) { - $_POST[$name] = $first_id; + $selected_id = $first_id; } + $_POST[$name] = $selected_id; - $aspect = $opts['edit_submit'] ? " aspect='editable'" : ''; - $selector = "\n"; + $selector = "\n"; $Ajax->addUpdate($name, "_{$name}_sel", $selector); @@ -333,7 +345,7 @@ $opts = array( // default options global $_select_button; $selector .= sprintf($_select_button, $disabled, user_theme(), (fallback_mode() ? '' : 'display:none;'), - $select_submit)."\n"; + '_'.$name.'_update')."\n"; } default_focus($name); echo $selector; @@ -354,85 +366,103 @@ function _format_add_curr($row) '' : (" - " . $row[2])); } -function supplier_list($name, $selected_id=null, $spec_option=false, $submit_on_change=false) +function supplier_list($name, $selected_id=null, $spec_option=false, $submit_on_change=false, + $all=false, $editkey = false) { global $all_items; - $sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers "; + $sql = "SELECT supplier_id, supp_ref, curr_code, inactive FROM ".TB_PREF."suppliers "; $mode = get_company_pref('no_supplier_list'); + if ($editkey) + set_editor('supplier', $name, $editkey); + return combo_input($name, $selected_id, $sql, 'supplier_id', 'supp_name', array( 'format' => '_format_add_curr', + 'order' => array('supp_ref'), 'search_box' => $mode!=0, - 'edit_submit' => true, 'type' => 1, 'spec_option' => $spec_option === true ? _("All Suppliers") : $spec_option, 'spec_id' => $all_items, 'select_submit'=> $submit_on_change, 'async' => false, 'sel_hint' => $mode ? _('Press Space tab to filter by name fragment') : - _('Select supplier') + _('Select supplier'), + 'show_inactive'=>$all )); } -function supplier_list_cells($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) +function supplier_list_cells($label, $name, $selected_id=null, $all_option=false, + $submit_on_change=false, $all=false, $editkey = false) { if ($label != null) echo "$label\n"; - $str = supplier_list($name, $selected_id, $all_option, $submit_on_change); + $str = supplier_list($name, $selected_id, $all_option, $submit_on_change, + $all, $editkey); echo "\n"; return $str; } -function supplier_list_row($label, $name, $selected_id=null, $all_option = false, $submit_on_change=false) +function supplier_list_row($label, $name, $selected_id=null, $all_option = false, + $submit_on_change=false, $all=false, $editkey = false) { echo "$label"; - $str = supplier_list($name, $selected_id, $all_option, $submit_on_change ); + $str = supplier_list($name, $selected_id, $all_option, $submit_on_change, + $all, $editkey); echo "\n"; return $str; } //---------------------------------------------------------------------------------------------- -function customer_list($name, $selected_id=null, $spec_option=false, $submit_on_change=false) +function customer_list($name, $selected_id=null, $spec_option=false, $submit_on_change=false, + $show_inactive=false, $editkey = false) { global $all_items; - $sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master "; + $sql = "SELECT debtor_no, debtor_ref, curr_code, inactive FROM ".TB_PREF."debtors_master "; $mode = get_company_pref('no_customer_list'); + if ($editkey) + set_editor('customer', $name, $editkey); + return combo_input($name, $selected_id, $sql, 'debtor_no', 'name', array( 'format' => '_format_add_curr', + 'order' => array('debtor_ref'), 'search_box' => $mode!=0, 'type' => 1, 'size' => 20, 'spec_option' => $spec_option === true ? _("All Customers") : $spec_option, 'spec_id' => $all_items, 'select_submit'=> $submit_on_change, - 'edit_submit' => true, // call editor on F4 'async' => false, - 'sel_hint' => $mode ? _('Press Space tab to filter by name fragment; F4 - entry new customer') : - _('Select customer') + 'sel_hint' => $mode ? _('Press Space tab to filter by name fragment; F2 - entry new customer') : + _('Select customer'), + 'show_inactive' => $show_inactive ) ); } -function customer_list_cells($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) +function customer_list_cells($label, $name, $selected_id=null, $all_option=false, + $submit_on_change=false, $show_inactive=false, $editkey = false) { if ($label != null) echo "$label\n"; echo ""; - $str = customer_list($name, $selected_id, $all_option, $submit_on_change); + $str = customer_list($name, $selected_id, $all_option, $submit_on_change, + $show_inactive, $editkey); echo "\n"; return $str; } -function customer_list_row($label, $name, $selected_id=null, $all_option = false, $submit_on_change=false) +function customer_list_row($label, $name, $selected_id=null, $all_option = false, + $submit_on_change=false, $show_inactive=false, $editkey = false) { echo "$label"; - $str = customer_list($name, $selected_id, $all_option, $submit_on_change); + $str = customer_list($name, $selected_id, $all_option, $submit_on_change, + $show_inactive, $editkey); echo "\n\n"; return $str; } @@ -440,17 +470,21 @@ function customer_list_row($label, $name, $selected_id=null, $all_option = false //------------------------------------------------------------------------------------------------ function customer_branches_list($customer_id, $name, $selected_id=null, - $spec_option = true, $enabled=true, $submit_on_change=false) + $spec_option = true, $enabled=true, $submit_on_change=false, $editkey = false) { global $all_items; - $sql = "SELECT branch_code, br_name FROM ".TB_PREF."cust_branch + $sql = "SELECT branch_code, branch_ref FROM ".TB_PREF."cust_branch WHERE debtor_no='" . $customer_id . "' "; + if ($editkey) + set_editor('branch', $name, $editkey); + $where = $enabled ? array("disable_trans = 0") : array(); return combo_input($name, $selected_id, $sql, 'branch_code', 'br_name', array( 'where' => $where, + 'order' => array('branch_ref'), 'spec_option' => $spec_option === true ? _('All branches') : $spec_option, 'spec_id' => $all_items, 'select_submit'=> $submit_on_change, @@ -459,20 +493,24 @@ return combo_input($name, $selected_id, $sql, 'branch_code', 'br_name', } //------------------------------------------------------------------------------------------------ -function customer_branches_list_cells($label,$customer_id, $name, $selected_id=null, $all_option = true, $enabled=true, $submit_on_change=false) +function customer_branches_list_cells($label,$customer_id, $name, $selected_id=null, + $all_option = true, $enabled=true, $submit_on_change=false, $editkey = false) { if ($label != null) echo "$label\n"; echo ""; - $ret = customer_branches_list($customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change); + $ret = customer_branches_list($customer_id, $name, $selected_id, $all_option, $enabled, + $submit_on_change, $editkey); echo "\n"; return $ret; } -function customer_branches_list_row($label,$customer_id, $name, $selected_id=null, $all_option = true, $enabled=true, $submit_on_change=false) +function customer_branches_list_row($label, $customer_id, $name, $selected_id=null, + $all_option = true, $enabled=true, $submit_on_change=false, $editkey = false) { echo ""; - $ret = customer_branches_list_cells($label, $customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change); + $ret = customer_branches_list_cells($label, $customer_id, $name, $selected_id, + $all_option, $enabled, $submit_on_change, $editkey); echo ""; return $ret; } @@ -483,7 +521,7 @@ function locations_list($name, $selected_id=null, $all_option=false, $submit_on_ { global $all_items; - $sql = "SELECT loc_code, location_name FROM ".TB_PREF."locations"; + $sql = "SELECT loc_code, location_name, inactive FROM ".TB_PREF."locations"; return combo_input($name, $selected_id, $sql, 'loc_code', 'location_name', array( @@ -515,7 +553,7 @@ function locations_list_row($label, $name, $selected_id=null, $all_option=false, function currencies_list($name, $selected_id=null, $submit_on_change=false) { - $sql = "SELECT curr_abrev, currency FROM ".TB_PREF."currencies"; + $sql = "SELECT curr_abrev, currency, inactive FROM ".TB_PREF."currencies"; // default to the company currency @@ -602,7 +640,7 @@ $options = array( 'async' => false, ); - if ($showclosed) + if (!$showclosed) $options['where'][] = "closed=0"; if($showtype) $options['where'][] = "type_=$showtype"; @@ -633,13 +671,17 @@ function dimensions_list_row($label, $name, $selected_id=null, $no_option=false, //--------------------------------------------------------------------------------------------------- -function stock_items_list($name, $selected_id=null, $all_option=false, $submit_on_change=false, $opts=array()) +function stock_items_list($name, $selected_id=null, $all_option=false, + $submit_on_change=false, $opts=array(), $editkey = false) { global $all_items; - $sql = "SELECT stock_id, s.description, c.description + $sql = "SELECT stock_id, s.description, c.description, s.inactive FROM ".TB_PREF."stock_master s,".TB_PREF."stock_category c WHERE s.category_id=c.category_id"; + if ($editkey) + set_editor('item', $name, $editkey); + return combo_input($name, $selected_id, $sql, 'stock_id', 's.description', array_merge( array( @@ -661,12 +703,13 @@ function _format_stock_items($row) return (user_show_codes() ? ($row[0] . " - ") : "") . $row[1]; } -function stock_items_list_cells($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) +function stock_items_list_cells($label, $name, $selected_id=null, $all_option=false, + $submit_on_change=false, $all=false, $editkey = false) { if ($label != null) echo "$label\n"; $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, - array('cells'=>true)); + array('cells'=>true, 'show_inactive'=>$all), $editkey); return $str; } /* @@ -687,19 +730,23 @@ function sales_items_list($name, $selected_id=null, $all_option=false, { global $all_items; // all sales codes - $sql = "SELECT i.item_code, i.description, c.description, count(*)>1 as kit + $sql = "SELECT i.item_code, i.description, c.description, count(*)>1 as kit, + i.inactive FROM + ".TB_PREF."stock_master s, ".TB_PREF."item_codes i LEFT JOIN ".TB_PREF."stock_category c - ON i.category_id=c.category_id"; + ON i.category_id=c.category_id + WHERE i.stock_id=s.stock_id"; + if ($type == 'local') { // exclude foreign codes - $sql .= " WHERE !i.is_foreign"; + $sql .= " AND !i.is_foreign"; } elseif ($type == 'kits') { // sales kits - $sql .= " WHERE !i.is_foreign AND i.item_code!=i.stock_id"; + $sql .= " AND !i.is_foreign AND i.item_code!=i.stock_id"; } - + $sql .= " AND !i.inactive AND !s.inactive AND !s.no_sale"; $sql .= " GROUP BY i.item_code"; return combo_input($name, $selected_id, $sql, 'i.item_code', 'c.description', @@ -709,7 +756,7 @@ function sales_items_list($name, $selected_id=null, $all_option=false, 'spec_option' => $all_option===true ? _("All Items") : $all_option, 'spec_id' => $all_items, 'search_box' => true, - 'search' => array("i.item_code", "c.description"), + 'search' => array("i.item_code", "i.description"), 'search_submit' => get_company_pref('no_item_list')!=0, 'size'=>15, 'select_submit'=> $submit_on_change, @@ -747,58 +794,12 @@ function sales_local_items_list_row($label, $name, $selected_id=null, $all_optio } //------------------------------------------------------------------------------------ -function base_stock_items_list($where, $name, $selected_id=null, - $all_option=false, $submit_on_change=false) -{ - global $all_items; - - $sql = "SELECT stock_id, s.description, c.description - FROM ".TB_PREF."stock_master s,".TB_PREF."stock_category c WHERE - s.category_id=c.category_id"; - - return combo_input($name, $selected_id, $sql, 'stock_id', 's.description', - array( - 'format' => '_format_stock_items', - 'spec_option' => $all_option==true ? _("All Items") : $all_option, - 'spec_id' => $all_items, - 'select_submit'=> $submit_on_change, - 'where' => $where, - 'category' => 2 ) ); -} -//------------------------------------------------------------------------------------ - -function stock_bom_items_list($name, $selected_id=null, $all_option=false, $submit_on_change=false) -{ - - return base_stock_items_list("(s.mb_flag='M' OR s.mb_flag='K')", - $name, $selected_id, $all_option, $submit_on_change); -} -/* -function stock_bom_items_list_cells($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) -{ - if ($label != null) - echo "$label\n"; - echo ""; - $str = stock_bom_items_list($name, $selected_id, $all_option, $submit_on_change); - echo "\n"; - return $str; -} - -function stock_bom_items_list_row($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) -{ - echo "\n"; - $str = stock_bom_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); - echo "\n"; - return $str; -} -*/ -//------------------------------------------------------------------------------------ - function stock_manufactured_items_list($name, $selected_id=null, $all_option=false, $submit_on_change=false) { - return base_stock_items_list("s.mb_flag='M'", - $name, $selected_id, $all_option, $submit_on_change); + $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, + array('where'=>array("mb_flag= 'M'"))); + return $str; } function stock_manufactured_items_list_cells($label, $name, $selected_id=null, @@ -807,8 +808,7 @@ function stock_manufactured_items_list_cells($label, $name, $selected_id=null, if ($label != null) echo "$label\n"; echo ""; - $str = stock_manufactured_items_list($name, $selected_id, $all_option, - $submit_on_change); + $str = stock_manufactured_items_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; return $str; } @@ -817,28 +817,28 @@ function stock_manufactured_items_list_row($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) { echo "\n"; - $str = stock_manufactured_items_list_cells($label, $name, $selected_id, - $all_option, $submit_on_change); + $str = stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change); echo "\n"; return $str; } //------------------------------------------------------------------------------------ function stock_component_items_list($name, $parent_stock_id, $selected_id=null, - $all_option=false, $submit_on_change=false) + $all_option=false, $submit_on_change=false, $editkey = false) { $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, - array('where'=>array("stock_id != '$parent_stock_id'"))); + array('where'=>array("stock_id != '$parent_stock_id'")), $editkey); return $str; } function stock_component_items_list_cells($label, $name, $parent_stock_id, - $selected_id=null, $all_option=false, $submit_on_change=false) + $selected_id=null, $all_option=false, $submit_on_change=false, $editkey = false) { if ($label != null) echo "$label\n"; $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, - array('where'=>array("stock_id != '$parent_stock_id'"), 'cells'=>true)); + array('where'=>array("stock_id != '$parent_stock_id'"), 'cells'=>true), + $editkey); return $str; } //------------------------------------------------------------------------------------ @@ -863,32 +863,31 @@ function stock_costable_items_list_cells($label, $name, $selected_id=null, //------------------------------------------------------------------------------------ function stock_purchasable_items_list($name, $selected_id=null, - $all_option=false, $submit_on_change=false) + $all_option=false, $submit_on_change=false, $all=false, $editkey=false) { $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, array('where'=>array("mb_flag!= 'M'"), - 'edit_submit' => true)); + 'show_inactive'=>$all), $editkey); return $str; } function stock_purchasable_items_list_cells($label, $name, $selected_id=null, - $all_option=false, $submit_on_change=false) + $all_option=false, $submit_on_change=false, $editkey=false) { if ($label != null) echo "$label\n"; $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, array('where'=>array("mb_flag!= 'M'"), - 'edit_submit' => true, - 'cells'=>true)); + 'cells'=>true), $editkey); return $str; } function stock_purchasable_items_list_row($label, $name, $selected_id=null, - $all_option=false, $submit_on_change=false) + $all_option=false, $submit_on_change=false, $editkey=false) { echo "\n"; $ret = stock_purchasable_items_list_cells($label, $name, $selected_id=null, - $all_option, $submit_on_change); + $all_option, $submit_on_change, $editkey); echo "\n"; return $ret; } @@ -897,18 +896,14 @@ function stock_purchasable_items_list_row($label, $name, $selected_id=null, function stock_item_types_list_row($label, $name, $selected_id=null, $enabled=true) { - $types = array( - 'M' => _("Manufactured"), - 'B' => _("Purchased"), - 'D' => _("Service") - ); + global $stock_types; echo ""; if ($label != null) echo "$label\n"; echo ""; - array_selector($name, $selected_id, $types, + array_selector($name, $selected_id, $stock_types, array( 'select_submit'=> true, 'disabled' => !$enabled) ); @@ -926,10 +921,7 @@ function stock_units_list_row($label, $name, $value=null, $enabled=true) while($unit = db_fetch($result)) $units[$unit['abbr']] = $unit['name']; - array_selector($name, $value, $units, - array( - 'select_submit'=> true, - 'disabled' => !$enabled) ); + array_selector($name, $value, $units, array( 'disabled' => !$enabled) ); echo "\n"; } @@ -943,7 +935,7 @@ function tax_types_list($name, $selected_id=null, $none_option=false, $submit_on return combo_input($name, $selected_id, $sql, 'id', 'name', array( 'spec_option' => $none_option, - 'spec_id' => reserved_words::get_all_numeric(), + 'spec_id' => ALL_NUMERIC, 'select_submit'=> $submit_on_change, 'async' => false, ) ); @@ -980,7 +972,7 @@ function tax_groups_list($name, $selected_id=null, array( 'order' => 'id', 'spec_option' => $none_option, - 'spec_id' => reserved_words::get_all_numeric(), + 'spec_id' => ALL_NUMERIC, 'select_submit'=> $submit_on_change, 'async' => false, ) ); @@ -1032,8 +1024,9 @@ function item_tax_types_list_row($label, $name, $selected_id=null) function shippers_list($name, $selected_id=null) { - $sql = "SELECT shipper_id, shipper_name FROM ".TB_PREF."shippers"; - combo_input($name, $selected_id, $sql, 'shipper_id', 'shipper_name', array()); + $sql = "SELECT shipper_id, shipper_name, inactive FROM ".TB_PREF."shippers"; + combo_input($name, $selected_id, $sql, 'shipper_id', 'shipper_name', + array('order'=>array('shipper_name'))); } function shippers_list_cells($label, $name, $selected_id=null) @@ -1056,8 +1049,9 @@ function shippers_list_row($label, $name, $selected_id=null) function sales_persons_list($name, $selected_id=null) { - $sql = "SELECT salesman_code, salesman_name FROM ".TB_PREF."salesman"; - combo_input($name, $selected_id, $sql, 'salesman_code', 'salesman_name', array()); + $sql = "SELECT salesman_code, salesman_name, inactive FROM ".TB_PREF."salesman"; + combo_input($name, $selected_id, $sql, 'salesman_code', 'salesman_name', + array('order'=>array('salesman_name'))); } function sales_persons_list_cells($label, $name, $selected_id=null) @@ -1080,7 +1074,7 @@ function sales_persons_list_row($label, $name, $selected_id=null, $submit_on_cha function sales_areas_list($name, $selected_id=null) { - $sql = "SELECT area_code, description FROM ".TB_PREF."areas"; + $sql = "SELECT area_code, description, inactive FROM ".TB_PREF."areas"; combo_input($name, $selected_id, $sql, 'area_code', 'description', array()); } @@ -1104,7 +1098,7 @@ function sales_areas_list_row($label, $name, $selected_id=null) function sales_groups_list($name, $selected_id=null, $special_option=false) { - $sql = "SELECT id, description FROM ".TB_PREF."groups"; + $sql = "SELECT id, description, inactive FROM ".TB_PREF."groups"; combo_input($name, $selected_id, $sql, 'id', 'description', array( 'spec_option' => $special_option===true ? ' ' : $special_option, 'order' => 'description', 'spec_id' => 0, @@ -1190,7 +1184,7 @@ function workorders_list_row($label, $name, $selected_id=null) function payment_terms_list($name, $selected_id=null) { - $sql = "SELECT terms_indicator, terms FROM ".TB_PREF."payment_terms"; + $sql = "SELECT terms_indicator, terms, inactive FROM ".TB_PREF."payment_terms"; combo_input($name, $selected_id, $sql, 'terms_indicator', 'terms', array()); } @@ -1214,7 +1208,7 @@ function payment_terms_list_row($label, $name, $selected_id=null) function credit_status_list($name, $selected_id=null) { - $sql ="SELECT id, reason_description FROM ".TB_PREF."credit_status"; + $sql ="SELECT id, reason_description, inactive FROM ".TB_PREF."credit_status"; combo_input($name, $selected_id, $sql, 'id', 'reason_description', array()); } @@ -1238,7 +1232,7 @@ function credit_status_list_row($label, $name, $selected_id=null) function sales_types_list($name, $selected_id=null, $submit_on_change=false, $special_option=false) { - $sql = "SELECT id, sales_type FROM ".TB_PREF."sales_types"; + $sql = "SELECT id, sales_type, inactive FROM ".TB_PREF."sales_types"; return combo_input($name, $selected_id, $sql, 'id', 'sales_type', array( @@ -1333,7 +1327,7 @@ function workcenter_list($name, $selected_id=null, $all_option=false) { global $all_items; - $sql = "SELECT id, name FROM ".TB_PREF."workcentres"; + $sql = "SELECT id, name, inactive FROM ".TB_PREF."workcentres"; return combo_input($name, $selected_id, $sql, 'id', 'name', array( @@ -1363,7 +1357,7 @@ function workcenter_list_row($label, $name, $selected_id=null, $all_option=false function bank_accounts_list($name, $selected_id=null, $submit_on_change=false) { - $sql = "SELECT ".TB_PREF."bank_accounts.id, bank_account_name, bank_curr_code + $sql = "SELECT ".TB_PREF."bank_accounts.id, bank_account_name, bank_curr_code, inactive FROM ".TB_PREF."bank_accounts"; // , ".TB_PREF."chart_master // WHERE ".TB_PREF."bank_accounts.account_code=".TB_PREF."chart_master.account_code"; @@ -1397,7 +1391,7 @@ function bank_accounts_list_row($label, $name, $selected_id=null, $submit_on_cha function cash_accounts_list_row($label, $name, $selected_id=null, $submit_on_change=false) { - $sql = "SELECT ".TB_PREF."bank_accounts.id, bank_account_name, bank_curr_code + $sql = "SELECT ".TB_PREF."bank_accounts.id, bank_account_name, bank_curr_code, inactive FROM ".TB_PREF."bank_accounts WHERE ".TB_PREF."bank_accounts.account_type=3"; @@ -1417,7 +1411,7 @@ function cash_accounts_list_row($label, $name, $selected_id=null, $submit_on_cha function pos_list_row($label, $name, $selected_id=null, $spec_option=false, $submit_on_change=false) { - $sql = "SELECT id, pos_name FROM ".TB_PREF."sales_pos"; + $sql = "SELECT id, pos_name, inactive FROM ".TB_PREF."sales_pos"; default_focus($name); echo ''; @@ -1431,6 +1425,7 @@ function pos_list_row($label, $name, $selected_id=null, $spec_option=false, $sub 'async' => true, 'spec_option' =>$spec_option, 'spec_id' => -1, + 'order'=> array('pos_name') ) ); echo "\n"; @@ -1481,26 +1476,29 @@ function class_list_row($label, $name, $selected_id=null, $submit_on_change=fals //----------------------------------------------------------------------------------------------- -function stock_categories_list($name, $selected_id=null) +function stock_categories_list($name, $selected_id=null, $submit_on_change=false) { - $sql = "SELECT category_id, description FROM ".TB_PREF."stock_category"; + $sql = "SELECT category_id, description, inactive FROM ".TB_PREF."stock_category"; combo_input($name, $selected_id, $sql, 'category_id', 'description', - array('order'=>'category_id')); + array('order'=>'category_id', + 'select_submit'=> $submit_on_change, + 'async' => true + )); } -function stock_categories_list_cells($label, $name, $selected_id=null) +function stock_categories_list_cells($label, $name, $selected_id=null, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; - stock_categories_list($name, $selected_id); + stock_categories_list($name, $selected_id, $submit_on_change); echo "\n"; } -function stock_categories_list_row($label, $name, $selected_id=null) +function stock_categories_list_row($label, $name, $selected_id=null, $submit_on_change=false) { echo "\n"; - stock_categories_list_cells($label, $name, $selected_id); + stock_categories_list_cells($label, $name, $selected_id, $submit_on_change); echo "\n"; } @@ -1541,17 +1539,17 @@ function gl_account_types_list_row($label, $name, $selected_id=null, $all_option //----------------------------------------------------------------------------------------------- function gl_all_accounts_list($name, $selected_id=null, $skip_bank_accounts=false, - $cells=false, $all_option=false, $submit_on_change=false) + $cells=false, $all_option=false, $submit_on_change=false, $all=false) { if ($skip_bank_accounts) - $sql = "SELECT chart.account_code, chart.account_name, type.name + $sql = "SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id FROM (".TB_PREF."chart_master chart,".TB_PREF."chart_types type) " ."LEFT JOIN ".TB_PREF."bank_accounts acc " ."ON chart.account_code=acc.account_code WHERE acc.account_code IS NULL AND chart.account_type=type.id"; else - $sql = "SELECT chart.account_code, chart.account_name, type.name + $sql = "SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id FROM ".TB_PREF."chart_master chart,".TB_PREF."chart_types type WHERE chart.account_type=type.id"; @@ -1560,7 +1558,7 @@ function gl_all_accounts_list($name, $selected_id=null, $skip_bank_accounts=fals 'format' => '_format_account', 'spec_option' => $all_option===true ? _("Use Item Sales Accounts") : $all_option, 'spec_id' => '', - 'order' => array('name','account_code'), + 'order' => array('type.id','account_code'), 'search_box' => $cells, 'search_submit' => false, 'size' => 12, @@ -1568,7 +1566,8 @@ function gl_all_accounts_list($name, $selected_id=null, $skip_bank_accounts=fals 'cells' => true, 'select_submit'=> $submit_on_change, 'async' => false, - 'category' => 2 + 'category' => 2, + 'show_inactive' => $all ) ); } @@ -1579,13 +1578,14 @@ function _format_account($row) } function gl_all_accounts_list_cells($label, $name, $selected_id=null, - $skip_bank_accounts=false, $cells=false, $all_option=false) + $skip_bank_accounts=false, $cells=false, $all_option=false, + $submit_on_change=false, $all=false) { if ($label != null) echo "$label\n"; echo ""; gl_all_accounts_list($name, $selected_id, - $skip_bank_accounts, $cells, $all_option); + $skip_bank_accounts, $cells, $all_option, $submit_on_change, $all); echo "\n"; } @@ -1601,8 +1601,8 @@ function gl_all_accounts_list_row($label, $name, $selected_id=null, function yesno_list($name, $selected_id=null, $name_yes="", $name_no="", $submit_on_change=false) { $items = array(); - $items['1'] = strlen($name_yes) ? $name_yes : _("Yes"); $items['0'] = strlen($name_no) ? $name_no : _("No"); + $items['1'] = strlen($name_yes) ? $name_yes : _("Yes"); return array_selector($name, $selected_id, $items, array( @@ -1661,15 +1661,9 @@ function languages_list_row($label, $name, $selected_id=null) function bank_account_types_list($name, $selected_id=null) { - $types = bank_account_types::get_all(); + global $bank_account_types; - $items = array(); - foreach ($types as $type) - { - $items[$type['id']] = $type['name']; - } - - return array_selector($name, $selected_id, $items ); + return array_selector($name, $selected_id, $bank_account_types); } function bank_account_types_list_cells($label, $name, $selected_id=null) @@ -1691,17 +1685,14 @@ function bank_account_types_list_row($label, $name, $selected_id=null) //------------------------------------------------------------------------------------------------ function payment_person_types_list($name, $selected_id=null, $submit_on_change=false) { - $types = payment_person_types::get_all(); + global $payment_person_types; $items = array(); - foreach ($types as $type) + foreach ($payment_person_types as $key=>$type) { - if (payment_person_types::has_items($type['id'])) - { - $items[$type['id']] = $type['name']; - } - } - + if ($key != PT_WORKORDER) + $items[$key] = $type; + } return array_selector($name, $selected_id, $items, array( 'select_submit'=> $submit_on_change ) ); } @@ -1728,13 +1719,9 @@ function payment_person_types_list_row($label, $name, $selected_id=null, $relate function wo_types_list($name, $selected_id=null) { - $types = wo_types::get_all(); - - $items = array(); - foreach ($types as $type) - $items[$type['id']] = $type['name']; + global $wo_types_array; - return array_selector($name, $selected_id, $items, + return array_selector($name, $selected_id, $wo_types_array, array( 'select_submit'=> true, 'async' => true ) ); } @@ -1818,16 +1805,25 @@ function pagesizes_list_row($label, $name, $value=null) echo "\n"; } -function security_headings_list_row($label, $name, $value=null) +function systypes_list_cells($label, $name, $value=null, $submit_on_change=false) { - global $security_headings; + global $systypes_array; - echo "$label\n"; - array_selector( $name, $value, $security_headings ); - echo "\n"; + if ($label != null) + echo "$label\n"; + echo ""; + + $str = array_selector($name, $value, $systypes_array, + array( + 'select_submit'=> $submit_on_change, + 'async' => false + ) + ); + echo "\n"; + return $str; } -function systypes_list_cells($label, $name, $value=null, $submit_on_change=false) +function journal_types_list_cells($label, $name, $value=null, $submit_on_change=false) { global $systypes_array; @@ -1835,12 +1831,17 @@ function systypes_list_cells($label, $name, $value=null, $submit_on_change=false echo "$label\n"; echo ""; - $items = array(); - foreach ($systypes_array as $key=>$type) - $items[$key] = $type['name']; + $items = $systypes_array; + + // exclude quotes, orders and dimensions + foreach (array(ST_PURCHORDER, ST_WORKORDER, ST_SALESORDER, ST_DIMENSION, + ST_SALESQUOTE) as $excl) + unset($items[$excl]); $str = array_selector($name, $value, $items, array( + 'spec_option'=> _("All"), + 'spec_id' => -1, 'select_submit'=> $submit_on_change, 'async' => false ) @@ -1943,7 +1944,7 @@ function number_list($name, $selected, $from, $to, $no_option=false) return array_selector($name, $selected, $items, array( 'spec_option' => $no_option, - 'spec_id' => reserved_words::get_all_numeric()) ); + 'spec_id' => ALL_NUMERIC) ); } function number_list_cells($label, $name, $selected, $from, $to, $no_option=false) @@ -2064,5 +2065,90 @@ function quick_entry_types_list_row($label, $name, $selected_id=null, $submit_on echo "\n"; } +function record_status_list_row($label, $name) { + return yesno_list_row($label, $name, null, _('Inactive'), _('Active')); +} + +function class_types_list_row($label, $name, $selected_id=null, $submit_on_change=false) +{ + global $class_types; + + echo "$label"; + array_selector($name, $selected_id, $class_types, + array( + 'select_submit'=> $submit_on_change + ) ); + echo "\n"; +} + +//------------------------------------------------------------------------------------------------ + +function security_roles_list($name, $selected_id=null, $new_item=false, $submit_on_change=false, + $show_inactive = false) +{ + global $all_items; + + $sql = "SELECT id, role, inactive FROM ".TB_PREF."security_roles"; + +return combo_input($name, $selected_id, $sql, 'id', 'description', + array( + 'spec_option'=>$new_item ? _("New role") : false, + 'spec_id' => '', + 'select_submit'=> $submit_on_change, + 'show_inactive' => $show_inactive + ) ); +} + +function security_roles_list_cells($label, $name, $selected_id=null, $new_item=false, $submit_on_change=false, + $show_inactive = false) +{ + if ($label != null) + echo "$label\n"; + echo ""; + $str = security_roles_list($name, $selected_id, $new_item, $submit_on_change, $show_inactive); + echo "\n"; + return $str; +} + +function security_roles_list_row($label, $name, $selected_id=null, $new_item=false, $submit_on_change=false, + $show_inactive = false) +{ + echo ""; + $str = security_roles_list_cells($label, $name, $selected_id, $new_item, $submit_on_change, $show_inactive); + echo "\n"; + return $str; +} + +function tab_list_row($label, $name, $selected_id=null) +{ + global $tabs; + echo "\n"; + echo "$label\n"; + + $items = array(); + + array_selector($name, $selected_id, $tabs); + + echo "\n"; +} + +//--------------------------------------------------------------------------------------------- +// List of sets of active extensions +// +function extset_list($name, $value=null, $submit_on_change=false) +{ + global $db_connections; + + $items = array(); + foreach ($db_connections as $comp) + $items[] = sprintf(_("Activated for '%s'"), $comp['name']); + array_selector( $name, $value, $items, + array( + 'spec_option'=> _("Installed on system"), + 'spec_id' => -1, + 'select_submit'=> $submit_on_change, + 'async' => true + )); +} ?> \ No newline at end of file