X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=178a48dbdbfb5800e0280babadd695e1dd112722;hb=0262a2246f9426d154327826cc9bd02c0af3a274;hp=687c035eedccf87261123b83182df277975f90f9;hpb=ccc6ec0bcb632b559ee068effa0b61f5b1b6276f;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 687c035e..178a48db 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -3,7 +3,7 @@ include_once($path_to_root . "/includes/banking.inc"); define("DEFVAL", "--"); -$search_button = " "; +$search_button = " "; //$search_button = " "; $all_items = reserved_words::get_all(); @@ -15,10 +15,13 @@ function supplier_list($name, $selected_id, $all_option=false, $submit_on_change { global $all_items; + default_focus($name); if ($selected_id == null) $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]); - $no_supplier_list = get_company_pref('no_supplier_list'); - if ($no_supplier_list) + + + $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"; @@ -28,34 +31,25 @@ function supplier_list($name, $selected_id, $all_option=false, $submit_on_change if (isset($_POST[$edit_button])) { $selected_id = $_POST[$name] = ""; + set_focus($name); } if ($selected_id != "") { $val = DEFVAL; - $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers WHERE supplier_id=$selected_id"; - $supplier_result = db_query($supplier_sql); + $supplier_sql .= "WHERE supplier_id=$selected_id"; } - else + elseif ($val != "" && $val != DEFVAL) { - if ($val != "" && $val != DEFVAL) - { - $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers WHERE supp_name LIKE '%{$val}%' ORDER BY supp_name"; - $supplier_result = db_query($supplier_sql); - } - else - $supplier_result = false; + $supplier_sql .= "WHERE supp_name LIKE '%{$val}%'"; } echo " "; echo sprintf($search_button, $edit_button); } - else - { - $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers ORDER BY supp_name"; - $supplier_result = db_query($supplier_sql); - } + + $supplier_result = db_query($supplier_sql." ORDER BY supp_name"); if ($submit_on_change==true) echo " "; echo sprintf($search_button, $edit_button); } - else - { - $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master ORDER BY name"; - $customer_result = db_query($customer_sql); - } + + + $customer_result = db_query($customer_sql." ORDER BY name"); + if ($submit_on_change==true) echo ""; else @@ -316,6 +304,7 @@ function locations_list($name, $selected_id, $all_option=false, $submit_on_chang { global $all_items; + default_focus($name); if ($submit_on_change == true) echo ""; else @@ -443,6 +433,7 @@ function currencies_list_row($label, $name, $selected_id) function fiscalyears_list($name, &$selected_id, $submit_on_change=false) { + default_focus($name); if ($submit_on_change == true) echo ""; else @@ -567,6 +559,7 @@ function simple_codeandname_list($sql, $name, &$selected_id, 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) { @@ -608,10 +601,15 @@ function stock_items_list($name, $selected_id, $all_option=false, $submit_on_cha { global $all_items; + default_focus($name); if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - $no_item_list = get_company_pref('no_item_list'); - if ($no_item_list) + + + $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"; @@ -622,41 +620,26 @@ function stock_items_list($name, $selected_id, $all_option=false, $submit_on_cha if (isset($_POST[$edit_button])) { $selected_id = $_POST[$name] = ""; + set_focus($name); } - if ($selected_id != "") { $val = DEFVAL; - $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description - FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id - AND stock_id='$selected_id'"; - $result = db_query($sql); + $sql .= " AND stock_id='$selected_id'"; } - else + elseif ($val != "" && $val != DEFVAL) { - if ($val != "" && $val != DEFVAL) - { - $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description - FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE " - .TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND + $sql .= " AND (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR " .TB_PREF."stock_master.description LIKE '%{$val}%')"; - $result = db_query($sql); - } - else - $result = false; } echo " "; echo sprintf($search_button, $edit_button); } - else - { - $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description - FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id"; - $result = db_query($sql); - } + $result = db_query($sql); + if ($submit_on_change==true) echo ""; else @@ -801,6 +785,7 @@ function base_stock_items_list($sql, $name, &$selected_id, { global $all_items; + default_focus($name); if ($submit_on_change==true) echo " "; echo " "; } - else - { - $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description - FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=" - .TB_PREF."stock_category.category_id AND mb_flag !='M'"; - $result = db_query($sql); - } + + $result = db_query($sql); if ($submit_on_change==true) echo ""; @@ -1058,17 +1035,20 @@ function stock_units_list_row($label, $name, $value, $enabled=true) if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); - foreach ($stock_units as $unit) + + while($unit = db_fetch($result)) { - if ($value == "") - $_POST[$name] = $value = $unit; - if ($value==$unit) + if ($value == "") { + $_POST[$name] = $unit['abbr']; + } + $descr = $unit['name']; + if ($value==$unit['abbr']) { - echo "\n"; + echo "\n"; } else { - echo "\n"; + echo "\n"; } } echo "\n"; @@ -1079,7 +1059,7 @@ function stock_units_list_row($label, $name, $value, $enabled=true) function tax_types_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_types", + 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); } @@ -1191,10 +1171,10 @@ function sales_persons_list_cells($label, $name, $selected_id) echo "\n"; } -function sales_persons_list_row($label, $name, $selected_id) +function sales_persons_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; - sales_persons_list_cells($label, $name, $selected_id); + sales_persons_list_cells($label, $name, $selected_id, $submit_on_change=false); echo "\n"; } @@ -1296,25 +1276,25 @@ function credit_status_list_row($label, $name, $selected_id) //----------------------------------------------------------------------------------------------- -function sales_types_list($name, $selected_id) +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); + $name, $selected_id, false, null, false, $submit_on_change); } -function sales_types_list_cells($label, $name, $selected_id) +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); + sales_types_list($name, $selected_id, $submit_on_change); echo "\n"; } -function sales_types_list_row($label, $name, $selected_id) +function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false) { echo "\n"; - sales_types_list_cells($label, $name, $selected_id); + sales_types_list_cells($label, $name, $selected_id, $submit_on_change); echo "\n"; } @@ -1371,6 +1351,8 @@ function bank_trans_types_list_row($label, $name, $selected_id) function workcenter_list($name, $selected_id, $all_option=false) { global $all_items; + + default_focus($name); echo ""; else @@ -1486,6 +1470,7 @@ function bank_accounts_list_row($label, $name, $selected_id, $submit_on_change=f function class_list($name, $selected_id, $submit_on_change=false) { + default_focus($name); if ($submit_on_change==true) echo ""; if ($skip_bank_accounts) @@ -1640,26 +1626,27 @@ function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false, } function gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts=false, - $show_group=false, $onchange="") + $show_group=false, $params="") { if ($label != null) echo "$label\n"; echo ""; - gl_all_accounts_list($name, $selected_id, $skip_bank_accounts, $show_group, $onchange); + 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, $onchange="") + $show_group=false, $params="") { echo "\n"; gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts, - $show_group, $onchange); + $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 ""; if ($selected_id == null) @@ -1752,6 +1740,7 @@ function bank_account_types_list($name, &$selected_id) { $bank_account_types = bank_account_types::get_all(); + default_focus($name); echo ""; if ($selected_id == null) @@ -1857,6 +1848,7 @@ function dateformats_list_row($label, $name, $value) { global $dateformats; + default_focus($name); echo "$label\n"; echo ""; @@ -1909,6 +1902,7 @@ function thoseps_list_row($label, $name, $value) { global $thoseps; + default_focus($name); echo "$label\n"; echo ""; @@ -1959,8 +1954,18 @@ function decseps_list_row($label, $name, $value) function themes_list_row($label, $name, $value) { - global $themes; + 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 ""; @@ -2009,6 +2015,7 @@ function security_headings_list_row($label, $name, $value) { global $security_headings; + default_focus($name); echo "$label\n"; echo "