3 include_once($path_to_root . "/includes/banking.inc");
5 define("DEFVAL", "--");
6 $search_button = "<input type='submit' class='inputsubmit' style='border:0;background:url($path_to_root/themes/default/images/locate.png) no-repeat;' name='%s' value='?' title='"._("Search")."'> ";
7 //$search_button = "<input type='submit' class='inputsubmit' name='%s' value='?'> ";
9 $all_items = reserved_words::get_all();
11 // TDB for all list functions : if there is no data, display a link to the releveant
12 // page to add an item, eg. for locations, if no locations, link to Add Location
14 function supplier_list($name, $selected_id, $all_option=false, $submit_on_change=false)
18 if ($selected_id == null)
19 $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]);
20 $no_supplier_list = get_company_pref('no_supplier_list');
21 if ($no_supplier_list)
23 global $search_button;
24 $edit_name = $name."_edit";
25 $edit_button = $name."_button";
27 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
28 if (isset($_POST[$edit_button]))
30 $selected_id = $_POST[$name] = "";
33 if ($selected_id != "")
36 $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers WHERE supplier_id=$selected_id";
37 $supplier_result = db_query($supplier_sql);
41 if ($val != "" && $val != DEFVAL)
43 $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers WHERE supp_name LIKE '%{$val}%' ORDER BY supp_name";
44 $supplier_result = db_query($supplier_sql);
47 $supplier_result = false;
50 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
52 echo sprintf($search_button, $edit_button);
56 $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers ORDER BY supp_name";
57 $supplier_result = db_query($supplier_sql);
60 if ($submit_on_change==true)
61 echo "<select name='$name' onchange='this.form.submit();'>";
63 echo "<select name='$name'>";
65 $company_currency = get_company_currency();
67 if ($all_option == true)
69 if ($selected_id == $all_items)
71 echo "<option selected value='$all_items'>" . _("All Suppliers") . "</option>\n";
75 echo "<option value='$all_items'>" . _("All Suppliers") . "</option>\n";
77 if ($selected_id == "")
79 $selected_id = $all_items;
83 while ($supplier_row = db_fetch_row($supplier_result))
85 if ($selected_id==$supplier_row[0])
87 echo "<option selected value='" . $supplier_row[0] . "'>";
91 echo "<option value='" . $supplier_row[0] . "'>";
93 echo $supplier_row[1];
95 if ($supplier_row[2] != $company_currency)
96 echo " - " . $supplier_row[2];
98 if ($selected_id == "")
100 $selected_id = $supplier_row[0];
101 $_POST[$name] = $selected_id;
107 db_free_result($supplier_result);
110 function supplier_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
113 echo "<td>$label</td>\n";
115 supplier_list($name, $selected_id, $all_option, $submit_on_change);
119 function supplier_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
122 supplier_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
126 //----------------------------------------------------------------------------------------------
128 function customer_list($name, $selected_id, $all_option=false, $submit_on_change=false)
132 if ($selected_id == null)
133 $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]);
134 $no_customer_list = get_company_pref('no_customer_list');
135 if ($no_customer_list)
137 global $search_button;
138 $edit_name = $name."_edit";
139 $edit_button = $name."_button";
141 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
142 if (isset($_POST[$edit_button]))
144 $selected_id = $_POST[$name] = "";
145 $_POST['branch_id'] = "";
148 if ($selected_id != "")
151 $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no=$selected_id";
152 $customer_result = db_query($customer_sql);
156 if ($val != "" && $val != DEFVAL)
158 $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master WHERE name LIKE '%{$val}%' ORDER BY name";
159 $customer_result = db_query($customer_sql);
162 $customer_result = false;
165 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
167 echo sprintf($search_button, $edit_button);
171 $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master ORDER BY name";
172 $customer_result = db_query($customer_sql);
174 if ($submit_on_change==true)
175 echo "<select name='$name' onchange='this.form.submit();'>";
177 echo "<select name='$name'>";
179 $company_currency = get_company_currency();
181 if (($all_option == true))
183 if ($selected_id == $all_items)
185 echo "<option selected value='$all_items'>" . _("All Customers") . "</option>\n";
189 echo "<option value='$all_items'>" . _("All Customers") . "</option>\n";
191 if ($selected_id == "")
193 $selected_id = $all_items;
196 while ($customer_row = db_fetch_row($customer_result))
198 if ($selected_id == $customer_row[0])
200 echo "<option selected value='" . $customer_row[0] . "'>";
204 echo "<option value='" . $customer_row[0] . "'>";
207 echo $customer_row[1];
208 if ($customer_row[2] != $company_currency)
209 echo " - " . $customer_row[2];
212 // if no initial selection - set the first item
213 // do we want to do this for all lists ???? probably
214 if ($selected_id == "")
216 $selected_id = $customer_row[0];
217 $_POST[$name] = $selected_id;
222 db_free_result($customer_result);
225 function customer_list_cells($label, $name, $selected_id, $all_option = false, $submit_on_change=false)
228 echo "<td>$label</td>\n";
230 customer_list($name, $selected_id, $all_option, $submit_on_change);
234 function customer_list_row($label, $name, $selected_id, $all_option = false, $submit_on_change=false)
237 customer_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
241 //------------------------------------------------------------------------------------------------
243 function customer_branches_list($customer_id, $name, $selected_id,
244 $all_option = true, $enabled=true, $submit_on_change=false)
248 if ($submit_on_change==true)
249 echo "<select name='$name' onchange='this.form.submit();'>";
251 echo "<select name='$name'>";
253 $sql = "SELECT branch_code, br_name FROM ".TB_PREF."cust_branch
254 WHERE debtor_no='" . $customer_id . "'";
256 $sql .= " AND disable_trans = 0";
257 $result = db_query($sql);
259 if ($selected_id == null)
260 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
261 if ($all_option == true)
264 if ($selected_id == $all_items)
266 echo "value='$all_items'>" . _("All Branches") . "</option>\n";
268 if ($selected_id == "")
270 $selected_id = $all_items;
274 while ($row = db_fetch_row($result))
276 if ($selected_id == $row[0])
278 echo "<option selected value='" . $row[0] . "'>";
282 echo "<option value='" . $row[0] . "'>";
284 echo $row[1] . "</option>\n";
286 if ($selected_id == "")
288 $selected_id = $row[0];
289 $_POST[$name] = $selected_id;
294 db_free_result($result);
297 function customer_branches_list_cells($label,$customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false)
300 echo "<td>$label</td>\n";
302 customer_branches_list($customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change);
306 function customer_branches_list_row($label,$customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false)
309 customer_branches_list_cells($label, $customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change);
313 //------------------------------------------------------------------------------------------------
315 function locations_list($name, $selected_id, $all_option=false, $submit_on_change=false)
319 if ($submit_on_change == true)
320 echo "<select name='$name' onchange='this.form.submit();'>";
322 echo "<select name='$name'>";
324 // if ($selected_id =="" AND isset($_SESSION['UserStockLocation']) AND $_SESSION['UserStockLocation'] !="") {
325 // $selected_id = $_SESSION['UserStockLocation'];
328 $sql = "SELECT loc_code, location_name FROM ".TB_PREF."locations";
329 $result = db_query($sql);
331 if ($selected_id == null)
332 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
333 if ($all_option == true)
336 if ($selected_id == $all_items)
338 echo " value='$all_items'>" . _("All Locations") . "</option>\n";
340 if ($selected_id == "")
342 $selected_id = $all_items;
346 while ($row = db_fetch_row($result))
348 if ($selected_id == $row[0])
350 echo "<option selected value='" . $row[0] . "'>";
354 echo "<option value='" . $row[0] . "'>";
356 echo $row[1] . "</option>\n";
358 if ($selected_id == "")
360 $selected_id = $row[0];
361 $_POST[$name] = $selected_id;
367 db_free_result($result);
370 function locations_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
373 echo "<td>$label</td>\n";
375 locations_list($name, $selected_id, $all_option, $submit_on_change);
379 function locations_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
382 locations_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
386 //-----------------------------------------------------------------------------------------------
388 function currencies_list($name, &$selected_id, $submit_on_change=false)
390 if ($submit_on_change==true)
391 echo "<select name='$name' onchange='this.form.submit();'>";
393 echo "<select name='$name'>";
395 $company_currency = get_company_currency();
397 $sql = "SELECT curr_abrev, currency FROM ".TB_PREF."currencies";
398 $result = db_query($sql);
400 if ($selected_id == null)
401 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
402 while ($row = db_fetch_row($result))
404 // default to the company currency
405 if ($selected_id == "" && ($row[0] == $company_currency))
407 $selected_id = $row[0];
408 $_POST[$name] = $selected_id;
411 if ($selected_id == $row[0])
413 echo "<option selected value='" . $row[0] . "'>";
417 echo "<option value='" . $row[0] . "'>";
419 echo $row[0] . " - " . $row[1] . "</option>\n";
423 db_free_result($result);
426 function currencies_list_cells($label, $name, $selected_id)
429 echo "<td>$label</td>\n";
431 currencies_list($name, $selected_id);
435 function currencies_list_row($label, $name, $selected_id)
438 currencies_list_cells($label, $name, $selected_id);
442 //---------------------------------------------------------------------------------------------------
444 function fiscalyears_list($name, &$selected_id, $submit_on_change=false)
446 if ($submit_on_change == true)
447 echo "<select name='$name' onchange='this.form.submit();'>";
449 echo "<select name='$name'>";
451 $company_year = get_company_pref('f_year');
453 $sql = "SELECT * FROM ".TB_PREF."fiscal_year ORDER BY begin";
454 $result = db_query($sql);
456 if ($selected_id == null)
457 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
458 while ($row = db_fetch_row($result))
460 // default to the company current fiscal year
461 if ($selected_id == "" && ($row[0] == $company_year))
463 $selected_id = $row[0];
464 $_POST[$name] = $selected_id;
467 if ($selected_id == $row[0])
469 echo "<option selected value='" . $row[0] . "'>";
473 echo "<option value='" . $row[0] . "'>";
479 $row[1] = sql2date($row[1]);
480 $row[2] = sql2date($row[2]);
481 echo $row[1] . " - " . $row[2] . " " . $how . "</option>\n";
485 db_free_result($result);
488 function fiscalyears_list_cells($label, $name, $selected_id)
491 echo "<td>$label</td>\n";
493 fiscalyears_list($name, $selected_id);
497 function fiscalyears_list_row($label, $name, $selected_id)
500 fiscalyears_list_cells($label, $name, $selected_id);
504 //---------------------------------------------------------------------------------------------------
506 function simple_codeandname_list($sql, $name, &$selected_id,
507 $all_option=false, $all_option_name=null, $all_option_numeric=false,
508 $submit_on_change=false, $returnzero=false)
512 if ($submit_on_change == true)
513 echo "<select name='$name' onchange='this.form.submit();'>";
515 echo "<select name='$name'>";
517 if ($selected_id == null)
518 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
519 if ($all_option == true)
523 elseif ($all_option_numeric)
524 $reserved_word = reserved_words::get_all_numeric();
526 $reserved_word = $all_items;
528 if ($selected_id == $reserved_word)
530 echo "<option selected value='$reserved_word'>$all_option_name</option>\n";
534 echo "<option value='$reserved_word'>$all_option_name</option>\n";
536 if ($selected_id == "")
538 $selected_id = $reserved_word;
542 $result = db_query($sql);
544 while ($row = db_fetch_row($result))
546 if ($selected_id == $row[0])
548 echo "<option selected value='" . $row[0] . "'>";
550 echo "<option value='" . $row[0] . "'>";
552 echo $row[1] . "</option>\n";
554 if (!$returnzero && $selected_id == "")
556 $selected_id = $row[0];
557 $_POST[$name] = $selected_id;
562 db_free_result($result);
565 //------------------------------------------------------------------------------------
567 function dimensions_list($name, &$selected_id, $no_option=false, $showname=null,
568 $submit_on_change=false, $showclosed=false, $showtype=1)
570 $sql = "SELECT id, CONCAT(reference,' ',name) FROM ".TB_PREF."dimensions";
571 if ($showclosed || $showtype)
576 if ($showclosed && $showtype)
577 $sql .= " AND type_=$showtype";
579 $sql .= " type_=$showtype";
581 $sql .= " ORDER BY reference";
582 simple_codeandname_list($sql, $name, $selected_id, $no_option, $showname,
583 true, $submit_on_change, true);
586 function dimensions_list_cells($label, $name, $selected_id, $no_option=false, $showname=null,
587 $showclosed=false, $showtype=0)
590 echo "<td>$label</td>\n";
592 dimensions_list($name, $selected_id, $no_option, $showname, false, $showclosed, $showtype);
596 function dimensions_list_row($label, $name, $selected_id, $no_option=false, $showname=null,
597 $showclosed=false, $showtype=0)
600 dimensions_list_cells($label, $name, $selected_id, $no_option, $showname,
601 $showclosed, $showtype);
605 //---------------------------------------------------------------------------------------------------
607 function stock_items_list($name, $selected_id, $all_option=false, $submit_on_change=false, $extra="")
611 if ($selected_id == null)
612 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
613 $no_item_list = get_company_pref('no_item_list');
616 global $search_button;
617 $edit_name = $name."_edit";
618 $edit_button = $name."_button";
620 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
622 if (isset($_POST[$edit_button]))
624 $selected_id = $_POST[$name] = "";
627 if ($selected_id != "")
630 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
631 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
632 AND stock_id='$selected_id'";
633 $result = db_query($sql);
637 if ($val != "" && $val != DEFVAL)
639 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
640 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE "
641 .TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND
642 (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
643 .TB_PREF."stock_master.description LIKE '%{$val}%')";
644 $result = db_query($sql);
650 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
652 echo sprintf($search_button, $edit_button);
656 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
657 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
658 $result = db_query($sql);
661 if ($submit_on_change==true)
662 echo "<select name='$name' onchange='this.form.submit();'>";
663 else if ($extra != "")
664 echo "<select name='$name' $extra>";
666 echo "<select name='$name'>";
668 if (($all_option == true))
670 if ($selected_id == $all_items)
672 echo "<option selected value='$all_items'>" . _("All Items") . "</option>\n";
676 echo "<option value='$all_items'>" . _("All Items") . "</option>\n";
678 if ($selected_id == "")
680 $selected_id = $all_items;
684 while ($row = db_fetch_row($result))
686 if ($selected_id == $row[0])
688 echo "<option selected value='" . $row[0] . "'>";
692 echo "<option value='" . $row[0] . "'>";
694 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
696 // if no initial selection - set the first item
697 // do we want to do this for all lists ???? probably
698 if ($selected_id == "")
700 $selected_id = $row[0];
701 $_POST[$name] = $selected_id;
705 db_free_result($result);
708 function stock_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false, $extra="")
711 echo "<td>$label</td>\n";
713 stock_items_list($name, $selected_id, $all_option, $submit_on_change, $extra);
717 function stock_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
720 stock_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
724 //------------------------------------------------------------------------------------
726 function stock_bom_items_list($name, $selected_id, $all_option=false, $submit_on_change=false)
730 if ($submit_on_change==true)
731 echo "<select name='$name' onchange='this.form.submit();'>";
733 echo "<select name='$name'>";
735 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
736 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
737 AND (".TB_PREF."stock_master.mb_flag='M' OR ".TB_PREF."stock_master.mb_flag='K')";
738 $result = db_query($sql);
740 if ($selected_id == null)
741 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
742 if (($all_option == true))
744 if ($selected_id == $all_items)
746 echo "<option selected value='$all_items'>" . _("All Items") . "</option>\n";
750 echo "<option value='$all_items'>" . _("All Items") . "</option>\n";
752 if ($selected_id == "")
754 $selected_id = $all_items;
758 while ($row = db_fetch_row($result))
760 if ($selected_id==$row[0])
762 echo "<option selected value='" . $row[0] . "'>";
766 echo "<option value='" . $row[0] . "'>";
768 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
770 if ($selected_id == "")
772 $selected_id = $row[0];
773 $_POST[$name] = $selected_id;
778 db_free_result($result);
781 function stock_bom_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
784 echo "<td>$label</td>\n";
786 stock_bom_items_list($name, $selected_id, $all_option, $submit_on_change);
790 function stock_bom_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
793 stock_bom_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
797 //------------------------------------------------------------------------------------
799 function base_stock_items_list($sql, $name, &$selected_id,
800 $all_option=false, $all_option_name="", $submit_on_change=false, $extra="")
804 if ($submit_on_change==true)
805 echo "<select name='$name' onchange='this.form.submit();'>";
806 else if ($extra != "")
807 echo "<select name='$name' $extra>";
809 echo "<select name='$name'>";
811 $result = db_query($sql);
813 if ($selected_id == null)
814 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
815 if ($all_option == true)
817 if ($selected_id == $all_items)
819 echo "<option selected value='$all_items'>$all_option_name</option>\n";
823 echo "<option value='$all_items'>$all_option_name</option>\n";
825 if ($selected_id == "")
827 $selected_id = $all_items;
831 while ($row = db_fetch_row($result))
833 if ($selected_id == $row[0])
835 echo "<option selected value='" . $row[0] . "'>";
839 echo "<option value='" . $row[0] . "'>";
841 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
843 if ($selected_id == "")
845 $selected_id = $row[0];
846 $_POST[$name] = $selected_id;
851 db_free_result($result);
854 //------------------------------------------------------------------------------------
856 function stock_manufactured_items_list($name, &$selected_id,
857 $all_option=false, $submit_on_change=false)
859 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
860 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
861 AND (".TB_PREF."stock_master.mb_flag='M')";
863 base_stock_items_list($sql, $name, $selected_id, $all_option, _("All Items"),
867 function stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
870 echo "<td>$label</td>\n";
872 stock_manufactured_items_list($name, $selected_id, $all_option, $submit_on_change);
876 function stock_manufactured_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
879 stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
883 //------------------------------------------------------------------------------------
885 function stock_component_items_list($name, $parent_stock_id, &$selected_id,
886 $all_option=false, $submit_on_change=false)
888 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
889 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE
890 ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
891 AND stock_id != '$parent_stock_id'";
893 base_stock_items_list($sql, $name, $selected_id,
894 $all_option, _("All Items"), $submit_on_change);
897 //------------------------------------------------------------------------------------
899 function stock_purchasable_items_list($name, &$selected_id, $all_option=false, $submit_on_change=false, $extra="")
903 if ($selected_id == null)
904 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
905 $no_item_list = get_company_pref('no_item_list');
908 $edit_name = $name."_edit";
909 $edit_button = $name."_button";
911 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
912 if (isset($_POST[$edit_button]))
914 $selected_id = $_POST[$name] = "";
917 if ($selected_id != "")
920 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
921 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
922 AND mb_flag !='M' AND stock_id='$selected_id'";
923 $result = db_query($sql);
927 if ($val != "" && $val != DEFVAL)
929 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
930 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE "
931 .TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND mb_flag !='M' AND
932 (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
933 .TB_PREF."stock_master.description LIKE '%{$val}%')";
934 $result = db_query($sql);
940 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' > ";
942 echo "<input type='submit' class='inputsubmit' name='$edit_button' value='?'> ";
946 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
947 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id="
948 .TB_PREF."stock_category.category_id AND mb_flag !='M'";
949 $result = db_query($sql);
952 if ($submit_on_change==true)
953 echo "<select name='$name' onchange='this.form.submit();'>";
954 else if ($extra != "")
955 echo "<select name='$name' $extra>";
957 echo "<select name='$name'>";
959 if ($all_option == true)
961 if ($selected_id == $all_items)
963 echo "<option selected value='$all_items'>"._("All Items")."</option>\n";
967 echo "<option value='$all_items'>"._("All Items")."</option>\n";
969 if ($selected_id == "")
971 $selected_id = $all_items;
975 while ($row = db_fetch_row($result))
977 if ($selected_id == $row[0])
979 echo "<option selected value='" . $row[0] . "'>";
983 echo "<option value='" . $row[0] . "'>";
985 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
987 if ($selected_id == "")
989 $selected_id = $row[0];
990 $_POST[$name] = $selected_id;
995 db_free_result($result);
998 function stock_purchasable_items_list_cells($label, $name, &$selected_id, $all_option=false, $submit_on_change=false, $extra = "")
1001 echo "<td>$label</td>\n";
1003 stock_purchasable_items_list($name, $selected_id, $all_option, $submit_on_change, $extra);
1007 function stock_purchasable_items_list_row($label, $name, &$selected_id, $all_option=false, $submit_on_change=false)
1010 stock_purchasable_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
1014 //------------------------------------------------------------------------------------
1016 function stock_costable_items_list($name, &$selected_id,
1017 $all_option=false, $submit_on_change=false)
1019 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
1020 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
1023 base_stock_items_list($sql, $name, $selected_id,
1024 $all_option, _("All Items"), $submit_on_change);
1027 //------------------------------------------------------------------------------------
1029 function stock_item_types_list_row($label, $name, $selected_id, $enabled=true)
1033 echo "<td>$label</td>\n";
1036 echo "<select name='$name' onchange='this.form.submit();'>\n";
1038 echo "<select disabled name='$name'>\n";
1039 if ($selected_id == null)
1040 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1041 if ($selected_id == "")
1042 $_POST[$name] = $selected_id = "B";
1043 echo "<option " . ($selected_id == 'M'?" selected ":"") . " value='M'>" . _("Manufactured"). "</option>\n";
1044 echo "<option " . ($selected_id == 'B'?" selected ":"") . " value='B'>" . _("Purchased"). "</option>\n";
1045 echo "<option " . ($selected_id == 'D'?" selected ":"") . " value='D'>" . _("Service"). "</option>\n";
1046 echo "</select></td></tr>\n";
1049 function stock_units_list_row($label, $name, $value, $enabled=true)
1051 global $stock_units;
1053 $result = get_all_item_units();
1054 echo "<tr><td>$label</td>\n";
1056 echo "<td><select name='$name'>";
1058 echo "<td><select disabled name='$name'>";
1061 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1063 while($unit = db_fetch($result))
1066 $_POST[$name] = $unit['abbr'];
1068 $descr = $unit['name'];
1069 if ($value==$unit['abbr'])
1071 echo "<option selected value='".$unit['abbr']."'>$descr</option>\n";
1075 echo "<option value='".$unit['abbr']."'>$descr</option>\n";
1078 echo "</select></td></tr>\n";
1081 //------------------------------------------------------------------------------------
1083 function tax_types_list($name, $selected_id,
1084 $none_option=false, $none_option_name=null, $submit_on_change=false)
1086 simple_codeandname_list("SELECT id, CONCAT(name, ' (',rate,'%)') as name FROM ".TB_PREF."tax_types",
1087 $name, $selected_id, $none_option, $none_option_name, true, $submit_on_change);
1090 function tax_types_list_cells($label, $name, $selected_id, $none_option=false,
1091 $none_option_name=null, $submit_on_change=false)
1094 echo "<td>$label</td>\n";
1096 tax_types_list($name, $selected_id, $none_option, $none_option_name, $submit_on_change);
1100 function tax_types_list_row($label, $name, $selected_id, $none_option=false,
1101 $none_option_name=null, $submit_on_change=false)
1104 tax_types_list_cells($label, $name, $selected_id, $none_option, $none_option_name, $submit_on_change);
1108 //------------------------------------------------------------------------------------
1110 function tax_groups_list($name, $selected_id,
1111 $none_option=false, $none_option_name=null, $submit_on_change=false)
1113 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."tax_groups ORDER BY id",
1114 $name, $selected_id, $none_option, $none_option_name, true, $submit_on_change);
1117 function tax_groups_list_cells($label, $name, $selected_id, $submit_on_change=false)
1120 echo "<td>$label</td>\n";
1122 tax_groups_list($name, $selected_id, false, null, $submit_on_change);
1126 function tax_groups_list_row($label, $name, $selected_id, $submit_on_change=false)
1129 tax_groups_list_cells($label, $name, $selected_id, false, null, $submit_on_change);
1133 //------------------------------------------------------------------------------------
1135 function item_tax_types_list($name, $selected_id)
1137 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."item_tax_types ORDER BY id",
1138 $name, $selected_id);
1141 function item_tax_types_list_cells($label, $name, $selected_id)
1144 echo "<td>$label</td>\n";
1146 item_tax_types_list($name, $selected_id);
1150 function item_tax_types_list_row($label, $name, $selected_id)
1153 item_tax_types_list_cells($label, $name, $selected_id);
1157 //------------------------------------------------------------------------------------
1159 function shippers_list($name, $selected_id)
1161 simple_codeandname_list("SELECT shipper_id, shipper_name FROM ".TB_PREF."shippers",
1162 $name, $selected_id);
1165 function shippers_list_cells($label, $name, $selected_id)
1168 echo "<td>$label</td>\n";
1170 shippers_list($name, $selected_id);
1174 function shippers_list_row($label, $name, $selected_id)
1177 shippers_list_cells($label, $name, $selected_id);
1181 //-------------------------------------------------------------------------------------
1183 function sales_persons_list($name, $selected_id)
1185 simple_codeandname_list("SELECT salesman_code, salesman_name FROM ".TB_PREF."salesman",
1186 $name, $selected_id);
1189 function sales_persons_list_cells($label, $name, $selected_id)
1192 echo "<td>$label</td>\n";
1194 sales_persons_list($name, $selected_id);
1198 function sales_persons_list_row($label, $name, $selected_id, $submit_on_change=false)
1201 sales_persons_list_cells($label, $name, $selected_id, $submit_on_change=false);
1205 //------------------------------------------------------------------------------------
1207 function sales_areas_list($name, $selected_id)
1209 simple_codeandname_list("SELECT area_code, description FROM ".TB_PREF."areas",
1210 $name, $selected_id);
1213 function sales_areas_list_cells($label, $name, $selected_id)
1216 echo "<td>$label</td>\n";
1218 sales_areas_list($name, $selected_id);
1222 function sales_areas_list_row($label, $name, $selected_id)
1225 sales_areas_list_cells($label, $name, $selected_id);
1229 //------------------------------------------------------------------------------------
1231 function workorders_list($name, $selected_id)
1233 simple_codeandname_list("SELECT id, wo_ref FROM ".TB_PREF."workorders WHERE closed=0",
1234 $name, $selected_id);
1237 function workorders_list_cells($label, $name, $selected_id)
1240 echo "<td>$label</td>\n";
1242 workorders_list($name, $selected_id);
1246 function workorders_list_row($label, $name, $selected_id)
1249 workorders_list_cells($label, $name, $selected_id);
1253 //------------------------------------------------------------------------------------
1255 function payment_terms_list($name, $selected_id)
1257 simple_codeandname_list("SELECT terms_indicator, terms FROM ".TB_PREF."payment_terms",
1258 $name, $selected_id);
1261 function payment_terms_list_cells($label, $name, $selected_id)
1264 echo "<td>$label</td>\n";
1266 payment_terms_list($name, $selected_id);
1270 function payment_terms_list_row($label, $name, $selected_id)
1273 payment_terms_list_cells($label, $name, $selected_id);
1277 //------------------------------------------------------------------------------------
1279 function credit_status_list($name, $selected_id)
1281 simple_codeandname_list("SELECT id, reason_description FROM ".TB_PREF."credit_status",
1282 $name, $selected_id);
1285 function credit_status_list_cells($label, $name, $selected_id)
1288 echo "<td>$label</td>\n";
1290 credit_status_list($name, $selected_id);
1294 function credit_status_list_row($label, $name, $selected_id)
1297 credit_status_list_cells($label, $name, $selected_id);
1301 //-----------------------------------------------------------------------------------------------
1303 function sales_types_list($name, $selected_id, $submit_on_change=false)
1305 simple_codeandname_list("SELECT id, sales_type FROM ".TB_PREF."sales_types",
1306 $name, $selected_id, false, null, false, $submit_on_change);
1309 function sales_types_list_cells($label, $name, $selected_id, $submit_on_change=false)
1312 echo "<td>$label</td>\n";
1314 sales_types_list($name, $selected_id, $submit_on_change);
1318 function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false)
1321 sales_types_list_cells($label, $name, $selected_id, $submit_on_change);
1325 //-----------------------------------------------------------------------------------------------
1327 function movement_types_list($name, $selected_id)
1329 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."movement_types",
1330 $name, $selected_id);
1333 function movement_types_list_cells($label, $name, $selected_id)
1336 echo "<td>$label</td>\n";
1338 movement_types_list($name, $selected_id);
1342 function movement_types_list_row($label, $name, $selected_id)
1345 movement_types_list_cells($label, $name, $selected_id);
1349 //-----------------------------------------------------------------------------------------------
1351 function bank_trans_types_list($name, $selected_id)
1353 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."bank_trans_types",
1354 $name, $selected_id);
1357 function bank_trans_types_list_cells($label, $name, $selected_id)
1360 echo "<td>$label</td>\n";
1362 bank_trans_types_list($name, $selected_id);
1366 function bank_trans_types_list_row($label, $name, $selected_id)
1369 bank_trans_types_list_cells($label, $name, $selected_id);
1373 //-----------------------------------------------------------------------------------------------
1375 function workcenter_list($name, $selected_id, $all_option=false)
1378 echo "<select name='$name'>";
1380 $sql = "SELECT id, name FROM ".TB_PREF."workcentres";
1381 $result = db_query($sql);
1383 if ($selected_id == null)
1384 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1385 if ($all_option == true)
1387 if ($selected_id == $all_items)
1389 echo "<option selected value='$all_items'>" . _("All Work Centres") . "</option>\n";
1393 echo "<option value='$all_items'>" . _("All Work Centres") . "</option>\n";
1397 while ($row = db_fetch_row($result))
1399 if ($selected_id == $row[0])
1401 echo "<option selected value='" . $row[0] . "'>";
1405 echo "<option value='" . $row[0] . "'>";
1407 echo $row[1] . "</option>\n";
1411 db_free_result($result);
1414 function workcenter_list_cells($label, $name, $selected_id, $all_option=false)
1417 echo "<td>$label</td>\n";
1419 workcenter_list($name, $selected_id, $all_option);
1423 function workcenter_list_row($label, $name, $selected_id, $all_option=false)
1426 workcenter_list_cells($label, $name, $selected_id, $all_option);
1430 //-----------------------------------------------------------------------------------------------
1432 function bank_accounts_list($name, $selected_id, $submit_on_change=false)
1434 if ($submit_on_change==true)
1435 echo "<select name='$name' onchange='this.form.submit();'>";
1437 echo "<select name='$name'>";
1439 $company_currency = get_company_currency();
1441 $sql = "SELECT ".TB_PREF."bank_accounts.account_code, bank_account_name, bank_curr_code
1442 FROM ".TB_PREF."bank_accounts, ".TB_PREF."chart_master
1443 WHERE ".TB_PREF."bank_accounts.account_code=".TB_PREF."chart_master.account_code";
1444 $result = db_query($sql);
1446 if ($selected_id == null)
1447 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1448 while ($row = db_fetch_row($result))
1450 if ($selected_id == $row[0])
1452 echo "<option selected value='" . $row[0] . "'>";
1456 echo "<option value='" . $row[0] . "'>";
1459 if ($company_currency != $row[2])
1460 echo " - " . $row[2];
1462 if ($selected_id == "")
1464 $selected_id = $row[0];
1465 $_POST[$name] = $selected_id;
1470 db_free_result($result);
1473 function bank_accounts_list_cells($label, $name, $selected_id, $submit_on_change=false)
1476 echo "<td>$label</td>\n";
1478 bank_accounts_list($name, $selected_id, $submit_on_change);
1482 function bank_accounts_list_row($label, $name, $selected_id, $submit_on_change=false)
1485 bank_accounts_list_cells($label, $name, $selected_id, $submit_on_change);
1489 //-----------------------------------------------------------------------------------------------
1491 function class_list($name, $selected_id, $submit_on_change=false)
1493 if ($submit_on_change==true)
1494 echo "<select name='$name' onchange='this.form.submit();'>";
1496 echo "<select name='$name'>";
1498 $sql = "SELECT cid, class_name FROM ".TB_PREF."chart_class";
1499 $result = db_query($sql);
1501 if ($selected_id == null)
1502 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1503 while ($row = db_fetch_row($result))
1505 if ($selected_id == $row[0])
1507 echo "<option selected value='" . $row[0] . "'>";
1511 echo "<option value='" . $row[0] . "'>";
1513 echo $row[1] . "</option>\n";
1514 if ($selected_id == "")
1516 $selected_id = $row[0];
1517 $_POST[$name] = $selected_id;
1522 db_free_result($result);
1525 function class_list_cells($label, $name, $selected_id, $submit_on_change=false)
1528 echo "<td>$label</td>\n";
1530 class_list($name, $selected_id, $submit_on_change);
1534 function class_list_row($label, $name, $selected_id, $submit_on_change=false)
1537 class_list_cells($label, $name, $selected_id, $submit_on_change);
1541 //-----------------------------------------------------------------------------------------------
1543 function stock_categories_list($name, $selected_id)
1545 simple_codeandname_list("SELECT category_id, description FROM ".TB_PREF."stock_category
1546 ORDER BY category_id", $name, $selected_id);
1549 function stock_categories_list_cells($label, $name, $selected_id)
1552 echo "<td>$label</td>\n";
1554 stock_categories_list($name, $selected_id);
1558 function stock_categories_list_row($label, $name, $selected_id)
1561 stock_categories_list_cells($label, $name, $selected_id);
1565 //-----------------------------------------------------------------------------------------------
1567 function gl_account_types_list($name, $selected_id, $all_option, $all_option_name,
1568 $all_option_numeric)
1570 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."chart_types ORDER BY id",
1571 $name, $selected_id, $all_option, $all_option_name, $all_option_numeric);
1574 function gl_account_types_list_cells($label, $name, $selected_id, $all_option=false, $all_option_name=null,
1575 $all_option_numeric=false)
1578 echo "<td>$label</td>\n";
1580 gl_account_types_list($name, $selected_id, $all_option, $all_option_name, $all_option_numeric);
1584 function gl_account_types_list_row($label, $name, $selected_id, $all_option=false, $all_option_name=null,
1585 $all_option_numeric=false)
1588 gl_account_types_list_cells($label, $name, $selected_id, $all_option,
1589 $all_option_name, $all_option_numeric);
1593 //-----------------------------------------------------------------------------------------------
1595 function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false,
1596 $show_group=false, $onchange="")
1598 echo "<select name='$name'";
1599 if ($onchange != "")
1600 echo " onchange='$onchange'";
1603 if ($skip_bank_accounts)
1604 $sql = "SELECT ".TB_PREF."chart_master.account_code, ".TB_PREF."chart_master.account_name, ".TB_PREF."chart_types.name
1605 FROM (".TB_PREF."chart_master,".TB_PREF."chart_types) LEFT JOIN ".TB_PREF."bank_accounts ON ".TB_PREF."chart_master.account_code=".TB_PREF."bank_accounts.account_code
1606 WHERE ".TB_PREF."bank_accounts.account_code IS NULL
1607 AND ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id
1608 ORDER BY account_code;";
1610 $sql = "SELECT account_code, account_name,".TB_PREF."chart_types.name
1611 FROM ".TB_PREF."chart_master, ".TB_PREF."chart_types
1612 WHERE ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id
1613 ORDER BY account_code";
1615 if ($selected_id == null)
1616 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1617 $result = db_query($sql, "query chart master");
1619 while ($row = db_fetch_row($result))
1621 if ($selected_id == $row[0])
1623 echo "<option selected value='" . $row[0] . "'>";
1627 echo "<option value='" . $row[0] . "'>";
1629 //echo str_pad($row[0],6,'0', STR_PAD_LEFT) . " " . $row[2] . " " . $row[1];
1631 echo $row[0] . " " . $row[2] . " " . $row[1] . "</option>\n";
1633 echo $row[0] . " " . $row[1] . "</option>\n";
1635 if ($selected_id == "")
1637 $selected_id = $row[0];
1638 $_POST[$name] = $selected_id;
1643 db_free_result($result);
1646 function gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts=false,
1647 $show_group=false, $onchange="")
1650 echo "<td>$label</td>\n";
1652 gl_all_accounts_list($name, $selected_id, $skip_bank_accounts, $show_group, $onchange);
1656 function gl_all_accounts_list_row($label, $name, $selected_id, $skip_bank_accounts=false,
1657 $show_group=false, $onchange="")
1660 gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts,
1661 $show_group, $onchange);
1665 function yesno_list($name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
1667 if ($submit_on_change == true)
1668 echo "<select name='$name' onchange='this.form.submit();'>";
1670 echo "<select name='$name'>";
1672 if (strlen($name_yes) == 0)
1676 if (strlen($name_no) == 0)
1681 if ($selected_id == null)
1682 $selected_id = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1683 if ($selected_id == 0)
1684 echo "<option value=1>";
1686 echo "<option selected value=1>";
1687 if (!isset($name_yes))
1688 echo _("Yes") . "</option>\n";
1690 echo $name_yes . "</option>\n";
1691 if ($selected_id == 0)
1692 echo "<option selected value=0>";
1694 echo "<option value=0>";
1695 if (!isset($name_no))
1696 echo _("No") . "</option>\n";
1698 echo $name_no . "</option>\n";
1702 function yesno_list_cells($label, $name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
1705 echo "<td>$label</td>\n";
1707 yesno_list($name, $selected_id, $name_yes, $name_no, $submit_on_change);
1711 function yesno_list_row($label, $name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
1714 yesno_list_cells($label, $name, $selected_id, $name_yes, $name_no, $submit_on_change);
1718 //------------------------------------------------------------------------------------------------
1720 function languages_list($name, &$selected_id)
1722 global $installed_languages;
1724 echo "<select name='$name'>";
1726 if ($selected_id == null)
1727 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1728 foreach ($installed_languages as $lang)
1731 if ($selected_id == $lang['code'])
1733 echo "value='" . $lang['code'] . "'>" . $lang['name'] . "</option>\n";
1737 function languages_list_cells($label, $name, $selected_id)
1740 echo "<td>$label</td>\n";
1742 languages_list($name, $selected_id);
1746 function languages_list_row($label, $name, $selected_id)
1749 languages_list_cells($label, $name, $selected_id);
1753 //------------------------------------------------------------------------------------------------
1755 function bank_account_types_list($name, &$selected_id)
1757 $bank_account_types = bank_account_types::get_all();
1759 echo "<select name='$name'>";
1761 if ($selected_id == null)
1762 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1763 foreach ($bank_account_types as $type)
1766 if ($selected_id == "" || $selected_id == $type['id'])
1768 echo "value='" . $type['id'] . "'>" . $type['name'] . "</option>\n";
1772 function bank_account_types_list_cells($label, $name, $selected_id)
1775 echo "<td>$label</td>\n";
1777 bank_account_types_list($name, $selected_id);
1781 function bank_account_types_list_row($label, $name, $selected_id)
1784 bank_account_types_list_cells($label, $name, $selected_id);
1788 //------------------------------------------------------------------------------------------------
1790 function payment_person_types_list($name, $selected_id, $related=null)
1792 $types = payment_person_types::get_all();
1794 echo "<select name='$name'";
1796 echo " onchange='this.form.$related.value=\"\"; this.form.submit();' ";
1799 if ($selected_id == null)
1800 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1801 foreach ($types as $type)
1803 if (payment_person_types::has_items($type['id']))
1805 if ($selected_id == "")
1806 $_POST[$name] = $selected_id = $type['id'];
1808 if ($selected_id == $type['id'])
1810 echo "value='" . $type['id'] . "'>" . $type['name'] . "</option>\n";
1815 function payment_person_types_list_cells($label, $name, $selected_id, $related=null)
1818 echo "<td>$label</td>\n";
1820 payment_person_types_list($name, $selected_id, $related);
1824 function payment_person_types_list_row($label, $name, $selected_id, $related=null)
1827 payment_person_types_list_cells($label, $name, $selected_id, $related);
1831 //------------------------------------------------------------------------------------------------
1833 function wo_types_list($name, &$selected_id)
1835 $types = wo_types::get_all();
1837 echo "<select name='$name' onchange='this.form.submit();'>";
1839 if ($selected_id == null)
1840 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1841 foreach ($types as $type)
1844 if ($selected_id == $type['id'])
1846 echo "value='" . $type['id'] . "'>" . $type['name'] . "</option>\n";
1851 function wo_types_list_row($label, $name, &$selected_id)
1853 echo "<tr><td>$label</td><td>\n";
1854 wo_types_list($name, $selected_id);
1855 echo "</td></tr>\n";
1858 //------------------------------------------------------------------------------------------------
1860 function dateformats_list_row($label, $name, $value)
1862 global $dateformats;
1864 echo "<tr><td>$label</td>\n";
1865 echo "<td><select name='$name'>";
1868 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1870 foreach ($dateformats as $df)
1873 if ($value==$counter)
1875 echo "<option selected value='$counter'>$df</option>\n";
1879 echo "<option value='$counter'>$df</option>\n";
1883 echo "</select></td></tr>\n";
1886 function dateseps_list_row($label, $name, $value)
1890 echo "<tr><td>$label</td>\n";
1891 echo "<td><select name='$name'>";
1894 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1896 foreach ($dateseps as $ds)
1899 if ($value==$counter)
1901 echo "<option selected value='$counter'>$ds</option>\n";
1905 echo "<option value='$counter'>$ds</option>\n";
1909 echo "</select></td></tr>\n";
1912 function thoseps_list_row($label, $name, $value)
1916 echo "<tr><td>$label</td>\n";
1917 echo "<td><select name='$name'>";
1920 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1922 foreach ($thoseps as $ts)
1925 if ($value==$counter)
1927 echo "<option selected value='$counter'>$ts</option>\n";
1931 echo "<option value='$counter'>$ts</option>\n";
1935 echo "</select></td></tr>\n";
1938 function decseps_list_row($label, $name, $value)
1942 echo "<tr><td>$label</td>\n";
1943 echo "<td><select name='$name'>";
1946 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1948 foreach ($decseps as $ds)
1951 if ($value==$counter)
1953 echo "<option selected value='$counter'>$ds</option>\n";
1957 echo "<option value='$counter'>$ds</option>\n";
1961 echo "</select></td></tr>\n";
1964 function themes_list_row($label, $name, $value)
1966 global $path_to_root;
1968 $path = $path_to_root.'/themes/';
1970 $themedir = opendir($path);
1971 while(false !== ($fname = readdir($themedir))) {
1972 if($fname!='.' && $fname!='..' && $fname!='CVS' && is_dir($path.$fname)) {
1977 echo "<tr><td>$label</td>\n";
1978 echo "<td><select name='$name'>";
1981 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1982 foreach ($themes as $th)
1987 echo "<option selected value='$th'>$th</option>\n";
1991 echo "<option value='$th'>$th</option>\n";
1994 echo "</select></td></tr>\n";
1997 function pagesizes_list_row($label, $name, $value)
2001 echo "<tr><td>$label</td>\n";
2002 echo "<td><select name='$name'>";
2005 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2006 foreach ($pagesizes as $pz)
2011 echo "<option selected value='$pz'>$pz</option>\n";
2015 echo "<option value='$pz'>$pz</option>\n";
2018 echo "</select></td></tr>\n";
2021 function security_headings_list_row($label, $name, $value)
2023 global $security_headings;
2025 echo "<tr><td>$label</td>\n";
2026 echo "<td><select name='$name'>";
2029 $value = (!isset($_POST[$name]) ? 0 : (int)$_POST[$name]);
2031 foreach ($security_headings as $sh)
2034 if ($value==$counter)
2036 echo "<option selected value='$counter'>$sh</option>\n";
2040 echo "<option value='$counter'>$sh</option>\n";
2044 echo "</select></td></tr>\n";
2047 function systypes_list_cells($label, $name, $value, $submit_on_change=false)
2049 global $systypes_array;
2052 echo "<td>$label</td>\n";
2053 echo "<td><select name='$name'";
2054 if ($submit_on_change)
2055 echo " onchange='this.form.submit();'>";
2059 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2060 foreach ($systypes_array as $key=>$type)
2065 echo "<option selected value='$key'>".$type['name']."</option>\n";
2069 echo "<option value='$key'>".$type['name']."</option>\n";
2072 echo "</select></td>\n";
2075 function systypes_list_row($label, $name, $value, $submit_on_change=false)
2078 systypes_list_cells($label, $name, $value, $submit_on_change);
2082 function cust_allocations_list_cells($label, $name, $selected)
2087 if ($selected == null)
2088 $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2089 echo "<td><select name='$name'>";
2090 echo "<option " . ($selected == $all_items ? " selected " : "") . " value='$all_items'>" . _("All Types"). "</option>\n";
2091 echo "<option " . ($selected == '1'?" selected ":"") . " value='1'>" . _("Sales Invoices"). "</option>\n";
2092 echo "<option " . ($selected == '2'?" selected ":"") . " value='2'>" . _("Overdue Invoices"). "</option>\n";
2093 echo "<option " . ($selected == '3'?" selected ":"") . " value='3'>" . _("Payments"). "</option>\n";
2094 echo "<option " . ($selected == '4'?" selected ":"") . " value='4'>" . _("Credit Notes"). "</option>\n";
2095 echo "<option " . ($selected == '5'?" selected ":"") . " value='5'>" . _("Delivery Notes"). "</option>\n";
2096 echo "</select></td>\n";
2099 function supp_allocations_list_cells($name, $selected)
2102 if ($selected == null)
2103 $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2104 echo "<td><select name='$name'>";
2105 echo "<option " . ($selected == $all_items ? " selected " : "") . " value='$all_items'>" . _("All Types"). "</option>\n";
2106 echo "<option " . ($selected == '1'?" selected ":"") . " value='1'>" . _("Invoices"). "</option>\n";
2107 echo "<option " . ($selected == '2'?" selected ":"") . " value='2'>" . _("Overdue Invoices"). "</option>\n";
2108 echo "<option " . ($selected == '3'?" selected ":"") . " value='3'>" . _("Payments"). "</option>\n";
2109 echo "<option " . ($selected == '4'?" selected ":"") . " value='4'>" . _("Credit Notes"). "</option>\n";
2110 echo "<option " . ($selected == '5'?" selected ":"") . " value='5'>" . _("Overdue Credit Notes"). "</option>\n";
2111 echo "</select></td>\n";
2114 function policy_list_cells($label, $name, $selected)
2116 if ($selected == null)
2118 $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2119 if ($selected == "")
2120 $_POST[$name] = $selected;
2124 echo "<td><select name='$name'>";
2125 echo "<option " . ($selected == ''?" selected ":"") . " value=''>" . _("Automatically put balance on back order"). "</option>\n";
2126 echo "<option " . ($selected == 'CAN'?" selected ":"") . " value='CAN'>" . _("Cancel any quantites not delivered"). "</option>\n";
2127 echo "</select></td>\n";
2130 function policy_list_row($label, $name, $selected)
2133 policy_list_cells($label, $name, $selected);
2137 function credit_type_list_cells($label, $name, $selected, $submit_on_change=false)
2139 if ($selected == null)
2141 $selected = (!isset($_POST[$name]) ? "Return" : $_POST[$name]);
2142 if ($selected == "Return")
2143 $_POST[$name] = $selected;
2147 echo "<td><select name='$name'";
2148 if ($submit_on_change)
2149 echo " onchange='this.form.submit();'>";
2152 echo "<option " . ($selected == 'Return'?" selected ":"") . " value='Return'>" . _("Items Returned to Inventory Location"). "</option>\n";
2153 echo "<option " . ($selected == 'WriteOff'?" selected ":"") . " value='WriteOff'>" . _("Items Written Off"). "</option>\n";
2154 echo "</select></td>\n";
2157 function credit_type_list_row($label, $name, $selected, $submit_on_change=false)
2160 credit_type_list_cells($label, $name, $selected, $submit_on_change);
2164 function number_list($name, $selected, $from, $to, $firstlabel="")
2166 if ($selected == null)
2168 $selected = (!isset($_POST[$name]) ? $from : $_POST[$name]);
2169 if ($selected == $from)
2170 $_POST[$name] = $selected;
2172 echo "<select name='$name'>";
2173 for ($i = $from; $i <= $to; $i++)
2175 if ($i == 0 && $firstlabel != "")
2176 $label = $firstlabel;
2179 if ($selected == $i)
2181 echo "<option selected value='$i'>$label</option>\n";
2185 echo "<option value='$i'>$label</option>\n";
2191 function number_list_cells($label, $name, $selected, $from, $to)
2196 number_list($name, $selected, $from, $to);
2200 function number_list_row($label, $name, $selected, $from, $to)
2203 number_list_cells($label, $name, $selected, $from, $to);