X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=bde06e22ade0f6352d9fcb66af3954920e30d8d3;hb=6d27f64388100dbbfad58ccb52c1ed334dd74e16;hp=4d15b0095a4f291e1db4deface6e06b9ab973ce8;hpb=c2dd0246dfc1625b90f4212767fbac3706796a08;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 4d15b009..bde06e22 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -1,15 +1,24 @@ . +***********************************************************************/ 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"); $_search_button = " "; + ."%s/images/locate.png) no-repeat;%s' aspect='fallback' name='%s' value=' ' title='"._("Set filter")."'> "; $_select_button = " "; + ."%s/images/button_ok.png) no-repeat;%s' aspect='fallback' name='%s' value=' ' title='"._("Select")."'> "; $all_items = reserved_words::get_all(); @@ -30,7 +39,9 @@ $opts = array( // default options 'spec_option'=>false, // option text or false 'spec_id' => 0, // option id // 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, @@ -47,10 +58,13 @@ $opts = array( // default options '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 + 'box_hint' => null, // box/selectors hints; null = std see below + 'category' => false, // category column name or false + 'show_inactive' => false // show inactive records. ); // ------ merge options with defaults ---------- - $opts = array_merge($opts, $options); + if($options != null) + $opts = array_merge($opts, $options); if (!is_array($opts['where'])) $opts['where'] = array($opts['where']); $search_box = $opts['search_box']===true ? '_'.$name.'_edit' : $opts['search_box']; @@ -65,24 +79,23 @@ $opts = array( // default options if(!count($opts['search'])) { $opts['search'] = array($by_id ? $valfield : $namefield); } - if ($opts['sel_hint'] === null) + if ($opts['sel_hint'] === null) $opts['sel_hint'] = $by_id || $search_box==false ? - '' : _('Press Space tab for search pattern entry'); + '' : _('Press Space tab for search pattern entry'); if ($opts['box_hint'] === null) - $opts['box_hint'] = $search_box ? + $opts['box_hint'] = $search_box && $search_submit != false ? ($by_id ? _('Enter code fragment to search or * for all') : _('Enter description fragment to search or * for all')) :''; if ($selected_id == null) { - $selected_id = get_post($name, null); + $selected_id = get_post($name, $opts['default']); } $txt = get_post($search_box); $rel = ''; $limit = ''; if (isset($_POST[$select_submit])) { - if ($by_id) $txt = $_POST[$name]; if (!$opts['async']) @@ -96,6 +109,7 @@ $opts = array( // default options $rel = "rel='$search_box'"; // set relation to list if ($opts['search_submit']) { if (isset($_POST[$search_submit])) { + $selected_id = ''; // ignore selected_id while search if (!$opts['async']) $Ajax->activate('_page_body'); else @@ -118,11 +132,20 @@ $opts = array( // default options } // sql completion if (count($opts['where'])) { - $sql .= strpos($sql, 'WHERE')==false ? ' WHERE ':' AND '; - $sql .= '('. implode($opts['where'], ' AND ') . ')'; + $where = strpos($sql, 'WHERE')==false ? ' WHERE ':' AND '; + $where .= '('. implode($opts['where'], ' AND ') . ')'; + $group_pos = strpos($sql, 'GROUP BY'); + if ($group_pos) { + $group = substr($sql, $group_pos); + $sql = substr($sql, 0, $group_pos) . $where.' '.$group; + } else { + $sql .= $where; + } } if ($opts['order'] != false) { - $sql .= ' ORDER BY '.$opts['order']; + if (!is_array($opts['order'])) + $opts['order'] = array($opts['order']); + $sql .= ' ORDER BY '.implode(',',$opts['order']); } $sql .= $limit; @@ -130,22 +153,37 @@ $opts = array( // default options $selector = $first_opt = ''; $first_id = false; $found = false; -//if($name=='SelectStockFromList') display_error($sql); + $lastcat = null; +//if($name=='stock_id') display_error($sql); if($result = db_query($sql)) { while ($contact_row = db_fetch($result)) { $value = $contact_row[0]; $descr = $opts['format']==null ? $contact_row[1] : call_user_func($opts['format'], $contact_row); $sel = ''; - if ((string)($selected_id) === $value) { + if (get_post($search_submit) && ($txt === $value)) { + $selected_id = $value; + } + if ((string)($selected_id) === $value) { $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; } - $selector .= "\n"; + $cat = $contact_row[$opts['category']]; + if ($opts['category'] !== false && $cat != $lastcat){ + $selector .= "\n"; + $lastcat = $cat; + } + $selector .= "\n"; } db_free_result($result); } @@ -154,23 +192,26 @@ $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; } if ($found === false) { - $_POST[$name] = $first_id; + $selected_id = $first_id; } + $_POST[$name] = $selected_id; - if ($by_id) { - $txt = $_POST[$name]; - if ($search_box) - $Ajax->addUpdate($name, $search_box, $txt); + if ($by_id && $search_box != false) { + $txt = $found; + $Ajax->addUpdate($name, $search_box, $txt ? $txt : ''); } - + $aspect = $opts['edit_submit'] ? " aspect='editable'" : ''; $selector = "\n"; + . $opts['sel_hint']."'$aspect $rel>".$selector."\n"; $Ajax->addUpdate($name, "_{$name}_sel", $selector); @@ -182,7 +223,7 @@ $opts = array( // default options global $_select_button; // button class selects form reload/ajax selector update $selector .= sprintf($_select_button, $disabled, user_theme(), - (in_ajax() ? 'display:none;':''), + (fallback_mode() ? '' : 'display:none;'), $select_submit)."\n"; } // ------ make combo ---------- @@ -193,16 +234,16 @@ $opts = array( // default options $opts['size']."' maxlength='".$opts['max']. "' value='$txt' class='$class' rel='$name' autocomplete='off' title='" .$opts['box_hint']."'" - .(in_ajax() && !$by_id ? " style=display:none;":'') + .(!fallback_mode() && !$by_id ? " style=display:none;":'') .">\n"; if ($search_submit != false) { global $_search_button; $edit_entry .= sprintf($_search_button, $disabled, user_theme(), - (in_ajax() ? 'display:none;':''), + (fallback_mode() ? '' : 'display:none;'), $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"; @@ -211,6 +252,15 @@ $opts = array( // default options return $str; } + +/* + Helper function. + Returns true if selector $name is subject to update. +*/ +function list_updated($name) +{ + return isset($_POST['_'.$name.'_update']) || isset($_POST['_'.$name.'_button']); +} //---------------------------------------------------------------------------------------------- // Universal array combo generator // $items is array of options 'value' => 'description' @@ -224,20 +274,23 @@ $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 'sel_hint' => null, 'disabled' => false ); // ------ merge options with defaults ---------- - $opts = array_merge($opts, $options); + if($options != null) + $opts = array_merge($opts, $options); $select_submit = $opts['select_submit']===true ? '_'.$name.'_update' : $opts['select_submit']; $spec_id = $opts['spec_id']; $spec_option = $opts['spec_option']; $disabled = $opts['disabled'] ? "disabled" : ''; if ($selected_id == null) { - $selected_id = get_post($name, null); + $selected_id = get_post($name, $opts['default']); } if (isset($_POST[$select_submit])) { @@ -278,8 +331,9 @@ $opts = array( // default options $_POST[$name] = $first_id; } + $aspect = $opts['edit_submit'] ? " aspect='editable'" : ''; $selector = "\n"; + . $opts['sel_hint']."'$aspect >".$selector."\n"; $Ajax->addUpdate($name, "_{$name}_sel", $selector); @@ -288,7 +342,7 @@ $opts = array( // default options if ($select_submit != false) { // if submit on change is used - add select button global $_select_button; $selector .= sprintf($_select_button, $disabled, user_theme(), - (in_ajax() ? 'display:none;':''), + (fallback_mode() ? '' : 'display:none;'), $select_submit)."\n"; } default_focus($name); @@ -310,11 +364,12 @@ 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) { global $all_items; - $sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers "; + $sql = "SELECT supplier_id, supp_name, curr_code, inactive FROM ".TB_PREF."suppliers "; $mode = get_company_pref('no_supplier_list'); @@ -322,21 +377,24 @@ function supplier_list($name, $selected_id=null, $spec_option=false, $submit_on_ array( 'format' => '_format_add_curr', '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) { 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); echo "\n"; return $str; } @@ -350,11 +408,11 @@ 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) { global $all_items; - $sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master "; + $sql = "SELECT debtor_no, name, curr_code, inactive FROM ".TB_PREF."debtors_master "; $mode = get_company_pref('no_customer_list'); @@ -367,26 +425,32 @@ return combo_input($name, $selected_id, $sql, 'debtor_no', 'name', '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') : - _('Select customer') + 'sel_hint' => $mode ? _('Press Space tab to filter by name fragment; F4 - 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) { 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); 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) { 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); echo "\n\n"; return $str; } @@ -437,7 +501,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( @@ -469,36 +533,32 @@ 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 - if ($selected_id == "") - { - $selected_id = get_company_currency(); - $_POST[$name] = $selected_id; - } return combo_input($name, $selected_id, $sql, 'curr_abrev', 'currency', array( 'select_submit'=> $submit_on_change, - 'async' => false + 'default' => get_company_currency(), + 'async' => false ) ); } -function currencies_list_cells($label, $name, $selected_id=null) +function currencies_list_cells($label, $name, $selected_id=null, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; - $str = currencies_list($name, $selected_id); + $str = currencies_list($name, $selected_id, $submit_on_change); echo "\n"; return $str; } -function currencies_list_row($label, $name, $selected_id=null) +function currencies_list_row($label, $name, $selected_id=null, $submit_on_change=false) { echo "\n"; - $str = currencies_list_cells($label, $name, $selected_id); + $str = currencies_list_cells($label, $name, $selected_id, $submit_on_change); echo "\n"; return $str; } @@ -511,15 +571,11 @@ function fiscalyears_list($name, $selected_id=null, $submit_on_change=false) $sql = "SELECT * FROM ".TB_PREF."fiscal_year"; // default to the company current fiscal year - if ($selected_id == "") - { - $selected_id = get_company_pref('f_year'); - $_POST[$name] = $selected_id; - } return combo_input($name, $selected_id, $sql, 'id', '', array( 'order' => 'begin', + 'default' => get_company_pref('f_year'), 'format' => '_format_fiscalyears', 'select_submit'=> $submit_on_change, 'async' => false @@ -565,41 +621,42 @@ $options = array( ); if ($showclosed) - $options['where'][] = "closed=0"; + $options['where'][] = "closed=0"; if($showtype) - $options['where'][] = "type_=$showtype"; + $options['where'][] = "type_=$showtype"; return combo_input($name, $selected_id, $sql, 'id', 'ref', $options); } function dimensions_list_cells($label, $name, $selected_id=null, $no_option=false, $showname=null, - $showclosed=false, $showtype=0) + $showclosed=false, $showtype=0, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; - $str = dimensions_list($name, $selected_id, $no_option, $showname, false, $showclosed, $showtype); + $str = dimensions_list($name, $selected_id, $no_option, $showname, $submit_on_change, $showclosed, $showtype); echo "\n"; return $str; } function dimensions_list_row($label, $name, $selected_id=null, $no_option=false, $showname=null, - $showclosed=false, $showtype=0) + $showclosed=false, $showtype=0, $submit_on_change=false) { echo "\n"; $str = dimensions_list_cells($label, $name, $selected_id, $no_option, $showname, - $showclosed, $showtype); + $showclosed, $showtype, $submit_on_change); echo "\n"; return $str; } //--------------------------------------------------------------------------------------------------- -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()) { 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"; return combo_input($name, $selected_id, $sql, 'stock_id', 's.description', @@ -612,22 +669,24 @@ function stock_items_list($name, $selected_id=null, $all_option=false, $submit_o 'search' => array("stock_id", "c.description","s.description"), 'search_submit' => get_company_pref('no_item_list')!=0, 'size'=>10, - 'select_submit'=> $submit_on_change + 'select_submit'=> $submit_on_change, + 'category' => 2, + 'order' => array('c.description','stock_id') ), $opts) ); } function _format_stock_items($row) { - return (user_show_codes() ? ($row[0] . " - ") : "") - . $row[2] . " - " . $row[1]; + 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) { 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)); return $str; } /* @@ -639,6 +698,77 @@ function stock_items_list_row($label, $name, $selected_id=null, $all_option=fals return $str; } */ +//--------------------------------------------------------------------------------------------------- +// +// Select item via foreign code. +// +function sales_items_list($name, $selected_id=null, $all_option=false, + $submit_on_change=false, $type='', $opts=array()) +{ + global $all_items; + // all sales codes + $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 + WHERE i.stock_id=s.stock_id"; + + + if ($type == 'local') { // exclude foreign codes + $sql .= " AND !i.is_foreign"; + } elseif ($type == 'kits') { // sales kits + $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', + array_merge( + array( + 'format' => '_format_stock_items', + 'spec_option' => $all_option===true ? _("All Items") : $all_option, + 'spec_id' => $all_items, + 'search_box' => true, + 'search' => array("i.item_code", "i.description"), + 'search_submit' => get_company_pref('no_item_list')!=0, + 'size'=>15, + 'select_submit'=> $submit_on_change, + 'category' => 2, + 'order' => array('c.description','i.item_code') + ), $opts) ); +} + +function sales_items_list_cells($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) +{ + if ($label != null) + echo "$label\n"; + $str = sales_items_list($name, $selected_id, $all_option, $submit_on_change, + '', array('cells'=>true)); + return $str; +} + +function sales_kits_list($name, $selected_id=null, $all_option=false, $submit_on_change=false) +{ + $str = sales_items_list($name, $selected_id, $all_option, $submit_on_change, + 'kits', array('cells'=>false)); + return $str; +} + +function sales_local_items_list_row($label, $name, $selected_id=null, $all_option=false, $submit_on_change=false) +{ + echo ""; + if ($label != null) + echo "$label\n"; + echo ""; + $str = sales_items_list($name, $selected_id, $all_option, $submit_on_change, + 'local', array('cells'=>false)); + echo ""; + return $str; +} //------------------------------------------------------------------------------------ function base_stock_items_list($where, $name, $selected_id=null, @@ -646,7 +776,7 @@ function base_stock_items_list($where, $name, $selected_id=null, { 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"; @@ -656,8 +786,8 @@ function base_stock_items_list($where, $name, $selected_id=null, 'spec_option' => $all_option==true ? _("All Items") : $all_option, 'spec_id' => $all_items, 'select_submit'=> $submit_on_change, - 'where' => $where - ) ); + 'where' => $where, + 'category' => 2 ) ); } //------------------------------------------------------------------------------------ @@ -757,20 +887,24 @@ 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) { $str = stock_items_list($name, $selected_id, $all_option, $submit_on_change, - array('where'=>array("mb_flag!= 'M'"))); + array('where'=>array("mb_flag!= 'M'"), + 'edit_submit' => true, + 'show_inactive'=>$all)); 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, $all=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'"), 'cells'=>true)); + array('where'=>array("mb_flag!= 'M'"), + 'edit_submit' => true, + 'cells'=>true)); return $str; } @@ -788,18 +922,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) ); @@ -871,26 +1001,26 @@ function tax_groups_list($name, $selected_id=null, array( 'order' => 'id', 'spec_option' => $none_option, - 'spec_id' => 0, + 'spec_id' => reserved_words::get_all_numeric(), 'select_submit'=> $submit_on_change, 'async' => false, ) ); } -function tax_groups_list_cells($label, $name, $selected_id=null, $submit_on_change=false) +function tax_groups_list_cells($label, $name, $selected_id=null, $none_option=false, $submit_on_change=false) { if ($label != null) echo "$label\n"; echo ""; - $str = tax_groups_list($name, $selected_id, false, $submit_on_change); + $str = tax_groups_list($name, $selected_id, $none_option, $submit_on_change); echo "\n"; return $str; } -function tax_groups_list_row($label, $name, $selected_id=null, $submit_on_change=false) +function tax_groups_list_row($label, $name, $selected_id=null, $none_option=false, $submit_on_change=false) { echo "\n"; - $str = tax_groups_list_cells($label, $name, $selected_id, false, $submit_on_change); + $str = tax_groups_list_cells($label, $name, $selected_id, $none_option, $submit_on_change); echo "\n"; return $str; } @@ -923,7 +1053,7 @@ 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"; + $sql = "SELECT shipper_id, shipper_name, inactive FROM ".TB_PREF."shippers"; combo_input($name, $selected_id, $sql, 'shipper_id', 'shipper_name', array()); } @@ -947,7 +1077,7 @@ 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"; + $sql = "SELECT salesman_code, salesman_name, inactive FROM ".TB_PREF."salesman"; combo_input($name, $selected_id, $sql, 'salesman_code', 'salesman_name', array()); } @@ -971,7 +1101,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()); } @@ -993,6 +1123,68 @@ 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, 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, + )); +} + +function sales_groups_list_cells($label, $name, $selected_id=null, $special_option=false) +{ + if ($label != null) + echo "$label\n"; + echo ""; + sales_groups_list($name, $selected_id, $special_option); + echo "\n"; +} + +function sales_groups_list_row($label, $name, $selected_id=null, $special_option=false) +{ + echo "\n"; + sales_groups_list_cells($label, $name, $selected_id, $special_option); + echo "\n"; +} + +//------------------------------------------------------------------------------------ + +function _format_template_items($row) +{ + return ($row[0] . " -  " . _("Amount") . " ".$row[1]); +} + +function templates_list($name, $selected_id=null, $special_option=false) +{ + $sql = "SELECT sorder.order_no, Sum(line.unit_price*line.quantity*(1-line.discount_percent)) AS OrderValue + FROM ".TB_PREF."sales_orders as sorder, ".TB_PREF."sales_order_details as line + WHERE sorder.order_no = line.order_no AND sorder.type = 1 GROUP BY line.order_no"; + combo_input($name, $selected_id, $sql, 'order_no', 'OrderValue', array( + 'format' => '_format_template_items', + 'spec_option' => $special_option===true ? ' ' : $special_option, + 'order' => 'order_no', 'spec_id' => 0, + )); +} + +function templates_list_cells($label, $name, $selected_id=null, $special_option=false) +{ + if ($label != null) + echo "$label\n"; + echo ""; + templates_list($name, $selected_id, $special_option); + echo "\n"; +} + +function templates_list_row($label, $name, $selected_id=null, $special_option=false) +{ + echo "\n"; + templates_list_cells($label, $name, $selected_id, $special_option); + echo "\n"; +} + +//------------------------------------------------------------------------------------ + function workorders_list($name, $selected_id=null) { $sql = "SELECT id, wo_ref FROM ".TB_PREF."workorders WHERE closed=0"; @@ -1019,7 +1211,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()); } @@ -1043,7 +1235,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()); } @@ -1067,7 +1259,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( @@ -1121,36 +1313,48 @@ function movement_types_list_row($label, $name, $selected_id=null) } //----------------------------------------------------------------------------------------------- +function _format_date($row) +{ + return sql2date($row['reconciled']); +} -function bank_trans_types_list($name, $selected_id=null) +function bank_reconciliation_list($account, $name, $selected_id=null, $submit_on_change=false, $special_option=false) { - $sql = "SELECT id, name FROM ".TB_PREF."bank_trans_types"; - combo_input($name, $selected_id, $sql, 'id', 'name', array()); + $sql = "SELECT reconciled, reconciled FROM ".TB_PREF."bank_trans + WHERE bank_act=".db_escape($account)." AND reconciled IS NOT NULL + GROUP BY reconciled"; + combo_input($name, $selected_id, $sql, 'id', 'reconciled', + array( + 'spec_option' => $special_option, + 'format' => '_format_date', + 'spec_id' => '', + 'select_submit'=> $submit_on_change + ) ); } -function bank_trans_types_list_cells($label, $name, $selected_id=null) +function bank_reconciliation_list_cells($label,$account, $name, $selected_id=null, $submit_on_change=false, $special_option=false) { if ($label != null) echo "$label\n"; echo ""; - bank_trans_types_list($name, $selected_id); + bank_reconciliation_list($account, $name, $selected_id, $submit_on_change, $special_option); echo "\n"; } - -function bank_trans_types_list_row($label, $name, $selected_id=null) +/* +function bank_reconciliation_list_row($label, $account, $name, $selected_id=null, $submit_on_change=false, $special_option=false) { echo "\n"; - bank_trans_types_list_cells($label, $name, $selected_id); + bank_reconciliation_list_cells($label, $account, $name, $selected_id, $submit_on_change, $special_option); echo "\n"; } - +*/ //----------------------------------------------------------------------------------------------- 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( @@ -1180,11 +1384,12 @@ 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.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"; + $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"; - return combo_input($name, $selected_id, $sql, 'account_code', 'bank_account_name', + return combo_input($name, $selected_id, $sql, 'id', 'bank_account_name', array( 'format' => '_format_add_curr', 'select_submit'=> $submit_on_change, @@ -1209,7 +1414,60 @@ function bank_accounts_list_row($label, $name, $selected_id=null, $submit_on_cha echo "\n"; return $str; } +//----------------------------------------------------------------------------------------------- + +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, inactive + FROM ".TB_PREF."bank_accounts + WHERE ".TB_PREF."bank_accounts.account_type=3"; + + if ($label != null) + echo "$label\n"; + echo ""; + $str = combo_input($name, $selected_id, $sql, 'id', 'bank_account_name', + array( + 'format' => '_format_add_curr', + 'select_submit'=> $submit_on_change, + 'async' => true + ) ); + echo "\n"; + return $str; +} +//----------------------------------------------------------------------------------------------- + +function pos_list_row($label, $name, $selected_id=null, $spec_option=false, $submit_on_change=false) +{ + $sql = "SELECT id, pos_name, inactive FROM ".TB_PREF."sales_pos"; + default_focus($name); + echo ''; + if ($label != null) + echo "$label\n"; + echo ""; + + $str = combo_input($name, $selected_id, $sql, 'id', 'pos_name', + array( + 'select_submit'=> $submit_on_change, + 'async' => true, + 'spec_option' =>$spec_option, + 'spec_id' => -1, + ) ); + echo "\n"; + + return $str; +} +//----------------------------------------------------------------------------------------------- + +function sale_payment_list_cells($label, $name, $selected_id=null, $submit_on_change=false) +{ + if ($label != null) + echo "$label\n"; + echo ""; + $str = yesno_list($name, $selected_id, _('Cash'), _('Delayed'), $submit_on_change); + echo "\n"; + return $str; +} //----------------------------------------------------------------------------------------------- function class_list($name, $selected_id=null, $submit_on_change=false) @@ -1244,26 +1502,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"; } @@ -1304,31 +1565,35 @@ 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, - $show_group=false, $cells=false, $all_option=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 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 + 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 FROM ".TB_PREF."chart_master chart,".TB_PREF."chart_types type WHERE chart.account_type=type.id"; combo_input($name, $selected_id, $sql, 'chart.account_code', 'chart.account_name', array( - 'format' => '_format_account' . ($show_group ? '2' : ''), + 'format' => '_format_account', 'spec_option' => $all_option===true ? _("Use Item Sales Accounts") : $all_option, 'spec_id' => '', - 'order' => 'account_code', + 'order' => array('name','account_code'), 'search_box' => $cells, 'search_submit' => false, 'size' => 12, 'max' => 10, - 'cells' => true + 'cells' => true, + 'select_submit'=> $submit_on_change, + 'async' => false, + 'category' => 2, + 'show_inactive' => $all ) ); } @@ -1338,27 +1603,24 @@ function _format_account($row) return $row[0] . "    " . $row[1]; } -function _format_account2($row) -{ - return $row[0] . "    " . $row[2] . "      " . $row[1]; -} - -function gl_all_accounts_list_cells($label, $name, $selected_id=null, $skip_bank_accounts=false, - $show_group=false, $cells=false, $all_option=false) +function gl_all_accounts_list_cells($label, $name, $selected_id=null, + $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, $show_group, $cells, $all_option); + gl_all_accounts_list($name, $selected_id, + $skip_bank_accounts, $cells, $all_option, $submit_on_change, $all); echo "\n"; } -function gl_all_accounts_list_row($label, $name, $selected_id=null, $skip_bank_accounts=false, - $show_group=false, $cells=false, $all_option=false) +function gl_all_accounts_list_row($label, $name, $selected_id=null, + $skip_bank_accounts=false, $cells=false, $all_option=false) { echo "\n"; - gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts, - $show_group, $cells, $all_option); + gl_all_accounts_list_cells($label, $name, $selected_id, + $skip_bank_accounts, $cells, $all_option); echo "\n"; } @@ -1370,7 +1632,7 @@ function yesno_list($name, $selected_id=null, $name_yes="", $name_no="", $submit return array_selector($name, $selected_id, $items, array( - 'select_submit'=> true, + 'select_submit'=> $submit_on_change, 'async' => false ) ); // FIX? } @@ -1430,10 +1692,7 @@ function bank_account_types_list($name, $selected_id=null) $items = array(); foreach ($types as $type) { - if (payment_person_types::has_items($type['id'])) - { $items[$type['id']] = $type['name']; - } } return array_selector($name, $selected_id, $items ); @@ -1616,6 +1875,32 @@ function systypes_list_cells($label, $name, $value=null, $submit_on_change=false return $str; } +function journal_types_list_cells($label, $name, $value=null, $submit_on_change=false) +{ + global $systypes_array; + + if ($label != null) + echo "$label\n"; + echo ""; + + $items = array(); + foreach ($systypes_array as $key=>$type) + // exclude orders and dimensions + if (!in_array($key, array(18,26,30,40))) + $items[$key] = $type['name']; + + $str = array_selector($name, $value, $items, + array( + 'spec_option'=> _("All"), + 'spec_id' => -1, + 'select_submit'=> $submit_on_change, + 'async' => false + ) + ); + echo "\n"; + return $str; +} + function systypes_list_row($label, $name, $value=null, $submit_on_change=false) { echo "\n"; @@ -1729,4 +2014,110 @@ function number_list_row($label, $name, $selected, $from, $to, $no_option=false) echo "\n"; } +function print_profiles_list_row($label, $name, $selected_id=null, $spec_opt=false, + $submit_on_change=true) +{ + $sql = "SELECT profile FROM ".TB_PREF."print_profiles" + ." GROUP BY profile"; + $result = db_query($sql, 'cannot get all profile names'); + $profiles = array(); + while($myrow=db_fetch($result)) { + $profiles[$myrow['profile']] = $myrow['profile']; + } + + echo ""; + if ($label != null) + echo "$label\n"; + echo ""; + + array_selector($name, $selected_id, $profiles, + array( 'select_submit'=> $submit_on_change, + 'spec_option'=>$spec_opt, + 'spec_id' => '' + )); + + echo "\n"; +} + +function printers_list($name, $selected_id=null, $spec_opt=false, $submit_on_change=false) +{ + static $printers; // query only once for page display + + if (!$printers) { + $sql = "SELECT id, name, description FROM ".TB_PREF."printers"; + $result = db_query($sql, 'cannot get all printers'); + $printers = array(); + while($myrow=db_fetch($result)) { + $printers[$myrow['id']] = $myrow['name'].' - '.$myrow['description']; + } + } + array_selector($name, $selected_id, $printers, + array( 'select_submit'=> $submit_on_change, + 'spec_option'=>$spec_opt, + 'spec_id' => '' + )); +} + +//------------------------------------------------------------------------------------------------ + +function quick_entries_list($name, $selected_id=null, $type=null, $submit_on_change=false) +{ + $where = false; + $sql = "SELECT id, description FROM ".TB_PREF."quick_entries"; + if ($type != null) + $sql .= " WHERE type=$type"; + + combo_input($name, $selected_id, $sql, 'id', 'description', + array( + 'spec_id' => '', + 'order' => 'description', + 'select_submit'=> $submit_on_change, + 'async' => false + ) ); + +} + +function quick_entries_list_cells($label, $name, $selected_id=null, $type, $submit_on_change=false) +{ + echo "$label\n"; + quick_entries_list($name, $selected_id, $type, $submit_on_change); + echo ""; +} + +function quick_entries_list_row($label, $name, $selected_id=null, $type, $submit_on_change=false) +{ + echo "\n"; + quick_entries_list_cells($label, $name, $selected_id, $type, $submit_on_change); + echo "\n"; +} + + +function quick_actions_list_row($label, $name, $selected_id=null, $submit_on_change=false) +{ + global $quick_actions; + + echo "$label"; + array_selector($name, $selected_id, $quick_actions, + array( + 'select_submit'=> $submit_on_change + ) ); + echo "\n"; +} + +function quick_entry_types_list_row($label, $name, $selected_id=null, $submit_on_change=false) +{ + global $quick_entry_types; + + echo "$label"; + array_selector($name, $selected_id, $quick_entry_types, + array( + 'select_submit'=> $submit_on_change + ) ); + echo "\n"; +} + +function record_status_list_row($label, $name) { + return yesno_list_row($label, $name, null, _('Inactive'), _('Active')); +} + ?> \ No newline at end of file