X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fui%2Fui_lists.inc;h=b75d66c8af1c313aae9d6e0175d1bc857990b381;hb=4def49c9e0be02ccdf814188c2a72ebd969a7a98;hp=56290071171182c25d7711149f091a514f937a5e;hpb=9993129b78ef90e59ce81a68413535d808aee380;p=fa-stable.git diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 56290071..b75d66c8 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -2,6 +2,10 @@ include_once($path_to_root . "/includes/banking.inc"); +define("DEFVAL", "--"); +$search_button = " "; +//$search_button = " "; + $all_items = reserved_words::get_all(); // TDB for all list functions : if there is no data, display a link to the releveant @@ -9,6 +13,50 @@ $all_items = reserved_words::get_all(); function supplier_list($name, $selected_id, $all_option=false, $submit_on_change=false) { + global $no_supplier_list, $all_items; + + if ($selected_id == null) + $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]); + + if ($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] = ""; + } + + 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); + } + else + { + 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; + } + + 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); + } + 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); + } if ($submit_on_change==true) echo ""; - $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master ORDER BY name"; - $customer_result = db_query($customer_sql); - $company_currency = get_company_currency(); - if ($selected_id == null) - $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if (($all_option == true)) { - if (reserved_words::get_all() == $selected_id) + if ($selected_id == $all_items) { - echo "\n"; - } - else + echo "\n"; + } + else { - echo "\n"; + echo "\n"; } - if ($selected_id == "") + if ($selected_id == "") { - $selected_id = reserved_words::get_all(); + $selected_id = $all_items; } } - - while ($customer_row = db_fetch_row($customer_result)) + while ($customer_row = db_fetch_row($customer_result)) { - if ($selected_id == $customer_row[0]) + if ($selected_id == $customer_row[0]) { echo "\n"; // if no initial selection - set the first item // do we want to do this for all lists ???? probably - if ($selected_id == "") + if ($selected_id == "") { $selected_id = $customer_row[0]; $_POST[$name] = $selected_id; @@ -138,7 +219,6 @@ function customer_list($name, $selected_id, $all_option=false, $submit_on_change } echo ""; - db_free_result($customer_result); } @@ -146,7 +226,7 @@ function customer_list_cells($label, $name, $selected_id, $all_option = false, $ { if ($label != null) echo "$label\n"; - echo ""; + echo ""; customer_list($name, $selected_id, $all_option, $submit_on_change); echo "\n"; } @@ -181,29 +261,29 @@ function customer_branches_list($customer_id, $name, $selected_id, if ($all_option == true) { echo "\n"; + echo "value='$all_items'>" . _("All Branches") . "\n"; - if ($selected_id == "") + if ($selected_id == "") { - $selected_id = reserved_words::get_all(); + $selected_id = $all_items; } } - while ($row = db_fetch_row($result)) + while ($row = db_fetch_row($result)) { - if ($selected_id == $row[0]) + if ($selected_id == $row[0]) { echo "\n"; - if ($selected_id == "") + if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; @@ -232,8 +312,10 @@ function customer_branches_list_row($label,$customer_id, $name, $selected_id, $a //------------------------------------------------------------------------------------------------ -function locations_list($name, $selected_id, $all_option=false, $submit_on_change=false, $all_option_name="") +function locations_list($name, $selected_id, $all_option=false, $submit_on_change=false) { + global $all_items; + if ($submit_on_change == true) echo ""; else @@ -438,17 +523,17 @@ function simple_codeandname_list($sql, $name, &$selected_id, elseif ($all_option_numeric) $reserved_word = reserved_words::get_all_numeric(); else - $reserved_word = reserved_words::get_all(); + $reserved_word = $all_items; - if ($reserved_word == $selected_id) + if ($selected_id == $reserved_word) { - echo "\n"; - } - else + echo "\n"; + } + else { - echo "\n"; + echo "\n"; } - if ($selected_id == "") + if ($selected_id == "") { $selected_id = $reserved_word; } @@ -456,9 +541,9 @@ function simple_codeandname_list($sql, $name, &$selected_id, $result = db_query($sql); - while ($row = db_fetch_row($result)) + while ($row = db_fetch_row($result)) { - if ($selected_id == $row[0]) + if ($selected_id == $row[0]) { echo "\n"; - if (!$returnzero && $selected_id == "") + if (!$returnzero && $selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; @@ -492,13 +577,13 @@ function dimensions_list($name, &$selected_id, $no_option=false, $showname=null, $sql .= " AND type_=$showtype"; else if ($showtype) $sql .= " type_=$showtype"; - } - $sql .= " ORDER BY reference"; - simple_codeandname_list($sql, $name, &$selected_id, $no_option, $showname, + } + $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, +function dimensions_list_cells($label, $name, $selected_id, $no_option=false, $showname=null, $showclosed=false, $showtype=0) { if ($label != null) @@ -508,11 +593,11 @@ function dimensions_list_cells($label, $name, $selected_id, $no_option=false, $s echo "\n"; } -function dimensions_list_row($label, $name, $selected_id, $no_option=false, $showname=null, +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, + dimensions_list_cells($label, $name, $selected_id, $no_option, $showname, $showclosed, $showtype); echo "\n"; } @@ -521,43 +606,88 @@ function dimensions_list_row($label, $name, $selected_id, $no_option=false, $sho function stock_items_list($name, $selected_id, $all_option=false, $submit_on_change=false, $extra="") { - global $all_items; + global $all_items, $no_item_list; + + if ($selected_id == null) + $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); + + if ($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] = ""; + } + + 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); + } + else + { + 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 + (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); + } + if ($submit_on_change==true) echo ""; else 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) + if ($label != null) echo "$label\n"; - echo ""; + echo ""; stock_items_list($name, $selected_id, $all_option, $submit_on_change, $extra); echo "\n"; } @@ -612,33 +741,33 @@ function stock_bom_items_list($name, $selected_id, $all_option=false, $submit_on $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); if (($all_option == true)) { - if ($all_items == $selected_id) + if ($selected_id == $all_items) { echo "\n"; - } - else + } + else { echo "\n"; } - if ($selected_id == "") + if ($selected_id == "") { $selected_id = $all_items; } } - while ($row = db_fetch_row($result)) + while ($row = db_fetch_row($result)) { - if ($selected_id==$row[0]) + if ($selected_id==$row[0]) { echo "\n"; - if ($selected_id == "") + if ($selected_id == "") { $selected_id = $row[0]; $_POST[$name] = $selected_id; @@ -670,9 +799,11 @@ function stock_bom_items_list_row($label, $name, $selected_id, $all_option=false function base_stock_items_list($sql, $name, &$selected_id, $all_option=false, $all_option_name="", $submit_on_change=false, $extra="") { + global $all_items; + if ($submit_on_change==true) echo ""; else echo " "; - base_stock_items_list($sql, $name, &$selected_id, - $all_option, _("All Items"), $submit_on_change, $extra); + 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); + } + + if ($submit_on_change==true) + echo ""; + else + echo ""; + db_free_result($result); } function stock_purchasable_items_list_cells($label, $name, &$selected_id, $all_option=false, $submit_on_change=false, $extra = "") @@ -801,7 +1020,7 @@ function stock_costable_items_list($name, &$selected_id, 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, + base_stock_items_list($sql, $name, $selected_id, $all_option, _("All Items"), $submit_on_change); } @@ -812,7 +1031,7 @@ function stock_item_types_list_row($label, $name, $selected_id, $enabled=true) echo ""; if ($label != NULL) echo "$label\n"; - echo ""; + echo ""; if ($enabled) echo ""; else echo ""; @@ -1277,13 +1496,13 @@ function class_list($name, $selected_id, $submit_on_change=false) if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - while ($row = db_fetch_row($result)) + while ($row = db_fetch_row($result)) { - if ($selected_id == $row[0]) + if ($selected_id == $row[0]) { echo "\n"; } @@ -1537,10 +1756,10 @@ function bank_account_types_list($name, &$selected_id) if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - foreach ($bank_account_types as $type) + foreach ($bank_account_types as $type) { echo "\n"; } @@ -1575,14 +1794,14 @@ function payment_person_types_list($name, $selected_id, $related=null) if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - foreach ($types as $type) + foreach ($types as $type) { - if (payment_person_types::has_items($type['id'])) + if (payment_person_types::has_items($type['id'])) { if ($selected_id == "") $_POST[$name] = $selected_id = $type['id']; echo "\n"; } @@ -1615,10 +1834,10 @@ function wo_types_list($name, &$selected_id) if ($selected_id == null) $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]); - foreach ($types as $type) + foreach ($types as $type) { echo "\n"; } @@ -1644,14 +1863,14 @@ function dateformats_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; - foreach ($dateformats as $df) + foreach ($dateformats as $df) { if ($value==$counter) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1670,14 +1889,14 @@ function dateseps_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; - foreach ($dateseps as $ds) + foreach ($dateseps as $ds) { if ($value==$counter) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1696,14 +1915,14 @@ function thoseps_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; - foreach ($thoseps as $ts) + foreach ($thoseps as $ts) { if ($value==$counter) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1722,14 +1941,14 @@ function decseps_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]); $counter = 0; - foreach ($decseps as $ds) + foreach ($decseps as $ds) { if ($value==$counter) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1747,14 +1966,14 @@ function themes_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); - foreach ($themes as $th) + foreach ($themes as $th) { if ($value==$th) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1771,14 +1990,14 @@ function pagesizes_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? "" : $_POST[$name]); - foreach ($pagesizes as $pz) + foreach ($pagesizes as $pz) { if ($value==$pz) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1796,14 +2015,14 @@ function security_headings_list_row($label, $name, $value) if ($value == null) $value = (!isset($_POST[$name]) ? 0 : (int)$_POST[$name]); $counter=0; - foreach ($security_headings as $sh) + foreach ($security_headings as $sh) { if ($value==$counter) { echo "\n"; - } - else + } + else { echo "\n"; } @@ -1819,7 +2038,7 @@ function systypes_list_cells($label, $name, $value, $submit_on_change=false) if ($label != null) echo "$label\n"; echo ""; - echo "\n"; + echo "\n"; echo "\n"; echo "\n"; echo "\n"; @@ -1864,10 +2084,11 @@ function cust_allocations_list_cells($label, $name, $selected) function supp_allocations_list_cells($name, $selected) { + global $all_items; if ($selected == null) $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]); echo ""; @@ -1904,9 +2125,9 @@ function credit_type_list_cells($label, $name, $selected, $submit_on_change=fals if ($selected == null) { $selected = (!isset($_POST[$name]) ? "Return" : $_POST[$name]); - if ($selected == "Return") + if ($selected == "Return") $_POST[$name] = $selected; - } + } if ($label != null) label_cell($label); echo "