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)
19 if ($selected_id == null)
20 $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]);
23 $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers ";
24 if (get_company_pref('no_supplier_list'))
26 global $search_button;
27 $edit_name = $name."_edit";
28 $edit_button = $name."_button";
30 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
31 if (isset($_POST[$edit_button]))
33 $selected_id = $_POST[$name] = "";
37 if ($selected_id != "")
40 $supplier_sql .= "WHERE supplier_id=$selected_id";
42 elseif ($val != "" && $val != DEFVAL)
44 $supplier_sql .= "WHERE supp_name LIKE '%{$val}%'";
47 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
49 echo sprintf($search_button, $edit_button);
52 $supplier_result = db_query($supplier_sql." ORDER BY supp_name");
54 if ($submit_on_change==true)
55 echo "<select name='$name' onchange='this.form.submit();'>";
57 echo "<select name='$name'>";
59 $company_currency = get_company_currency();
61 if ($all_option == true)
63 if ($selected_id == $all_items)
65 echo "<option selected value='$all_items'>" . _("All Suppliers") . "</option>\n";
69 echo "<option value='$all_items'>" . _("All Suppliers") . "</option>\n";
71 if ($selected_id == "")
73 $selected_id = $all_items;
77 while ($supplier_row = db_fetch_row($supplier_result))
79 if ($selected_id==$supplier_row[0])
81 echo "<option selected value='" . $supplier_row[0] . "'>";
85 echo "<option value='" . $supplier_row[0] . "'>";
87 echo $supplier_row[1];
89 if ($supplier_row[2] != $company_currency)
90 echo " - " . $supplier_row[2];
92 if ($selected_id == "")
94 $selected_id = $supplier_row[0];
95 $_POST[$name] = $selected_id;
101 db_free_result($supplier_result);
104 function supplier_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
107 echo "<td>$label</td>\n";
109 supplier_list($name, $selected_id, $all_option, $submit_on_change);
113 function supplier_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
116 supplier_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
120 //----------------------------------------------------------------------------------------------
122 function customer_list($name, $selected_id, $all_option=false, $submit_on_change=false)
126 default_focus($name);
127 if ($selected_id == null)
128 $selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]);
130 $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master ";
131 if (get_company_pref('no_customer_list'))
133 global $search_button;
134 $edit_name = $name."_edit";
135 $edit_button = $name."_button";
137 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
138 if (isset($_POST[$edit_button]))
140 $selected_id = $_POST[$name] = "";
141 $_POST['branch_id'] = "";
144 if ($selected_id != "")
147 $customer_sql .= "WHERE debtor_no=$selected_id";
149 elseif ($val != "" && $val != DEFVAL)
151 $customer_sql .= "WHERE name LIKE '%{$val}%'";
153 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
155 echo sprintf($search_button, $edit_button);
159 $customer_result = db_query($customer_sql." ORDER BY name");
161 if ($submit_on_change==true)
162 echo "<select name='$name' onchange='this.form.submit();'>";
164 echo "<select name='$name'>";
166 $company_currency = get_company_currency();
168 if (($all_option == true))
170 if ($selected_id == $all_items)
172 echo "<option selected value='$all_items'>" . _("All Customers") . "</option>\n";
176 echo "<option value='$all_items'>" . _("All Customers") . "</option>\n";
178 if ($selected_id == "")
180 $selected_id = $all_items;
183 while ($customer_row = db_fetch_row($customer_result))
185 if ($selected_id == $customer_row[0])
187 echo "<option selected value='" . $customer_row[0] . "'>";
191 echo "<option value='" . $customer_row[0] . "'>";
194 echo $customer_row[1];
195 if ($customer_row[2] != $company_currency)
196 echo " - " . $customer_row[2];
199 // if no initial selection - set the first item
200 // do we want to do this for all lists ???? probably
201 if ($selected_id == "")
203 $selected_id = $customer_row[0];
204 $_POST[$name] = $selected_id;
209 db_free_result($customer_result);
212 function customer_list_cells($label, $name, $selected_id, $all_option = false, $submit_on_change=false)
215 echo "<td>$label</td>\n";
217 customer_list($name, $selected_id, $all_option, $submit_on_change);
221 function customer_list_row($label, $name, $selected_id, $all_option = false, $submit_on_change=false)
224 customer_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
228 //------------------------------------------------------------------------------------------------
230 function customer_branches_list($customer_id, $name, $selected_id,
231 $all_option = true, $enabled=true, $submit_on_change=false)
235 default_focus($name);
236 if ($submit_on_change==true)
237 echo "<select name='$name' onchange='this.form.submit();'>";
239 echo "<select name='$name'>";
241 $sql = "SELECT branch_code, br_name FROM ".TB_PREF."cust_branch
242 WHERE debtor_no='" . $customer_id . "'";
244 $sql .= " AND disable_trans = 0";
245 $result = db_query($sql);
247 if ($selected_id == null)
248 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
249 if ($all_option == true)
252 if ($selected_id == $all_items)
254 echo "value='$all_items'>" . _("All Branches") . "</option>\n";
256 if ($selected_id == "")
258 $selected_id = $all_items;
262 while ($row = db_fetch_row($result))
264 if ($selected_id == $row[0])
266 echo "<option selected value='" . $row[0] . "'>";
270 echo "<option value='" . $row[0] . "'>";
272 echo $row[1] . "</option>\n";
274 if ($selected_id == "")
276 $selected_id = $row[0];
277 $_POST[$name] = $selected_id;
282 db_free_result($result);
285 function customer_branches_list_cells($label,$customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false)
288 echo "<td>$label</td>\n";
290 customer_branches_list($customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change);
294 function customer_branches_list_row($label,$customer_id, $name, $selected_id, $all_option = true, $enabled=true, $submit_on_change=false)
297 customer_branches_list_cells($label, $customer_id, $name, $selected_id, $all_option, $enabled, $submit_on_change);
301 //------------------------------------------------------------------------------------------------
303 function locations_list($name, $selected_id, $all_option=false, $submit_on_change=false)
307 default_focus($name);
308 if ($submit_on_change == true)
309 echo "<select name='$name' onchange='this.form.submit();'>";
311 echo "<select name='$name'>";
313 // if ($selected_id =="" AND isset($_SESSION['UserStockLocation']) AND $_SESSION['UserStockLocation'] !="") {
314 // $selected_id = $_SESSION['UserStockLocation'];
317 $sql = "SELECT loc_code, location_name FROM ".TB_PREF."locations";
318 $result = db_query($sql);
320 if ($selected_id == null)
321 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
322 if ($all_option == true)
325 if ($selected_id == $all_items)
327 echo " value='$all_items'>" . _("All Locations") . "</option>\n";
329 if ($selected_id == "")
331 $selected_id = $all_items;
335 while ($row = db_fetch_row($result))
337 if ($selected_id == $row[0])
339 echo "<option selected value='" . $row[0] . "'>";
343 echo "<option value='" . $row[0] . "'>";
345 echo $row[1] . "</option>\n";
347 if ($selected_id == "")
349 $selected_id = $row[0];
350 $_POST[$name] = $selected_id;
356 db_free_result($result);
359 function locations_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
362 echo "<td>$label</td>\n";
364 locations_list($name, $selected_id, $all_option, $submit_on_change);
368 function locations_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
371 locations_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
375 //-----------------------------------------------------------------------------------------------
377 function currencies_list($name, &$selected_id, $submit_on_change=false)
379 default_focus($name);
380 if ($submit_on_change==true)
381 echo "<select name='$name' onchange='this.form.submit();'>";
383 echo "<select name='$name'>";
385 $company_currency = get_company_currency();
387 $sql = "SELECT curr_abrev, currency FROM ".TB_PREF."currencies";
388 $result = db_query($sql);
390 if ($selected_id == null)
391 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
392 while ($row = db_fetch_row($result))
394 // default to the company currency
395 if ($selected_id == "" && ($row[0] == $company_currency))
397 $selected_id = $row[0];
398 $_POST[$name] = $selected_id;
401 if ($selected_id == $row[0])
403 echo "<option selected value='" . $row[0] . "'>";
407 echo "<option value='" . $row[0] . "'>";
409 echo $row[0] . " - " . $row[1] . "</option>\n";
413 db_free_result($result);
416 function currencies_list_cells($label, $name, $selected_id)
419 echo "<td>$label</td>\n";
421 currencies_list($name, $selected_id);
425 function currencies_list_row($label, $name, $selected_id)
428 currencies_list_cells($label, $name, $selected_id);
432 //---------------------------------------------------------------------------------------------------
434 function fiscalyears_list($name, &$selected_id, $submit_on_change=false)
436 default_focus($name);
437 if ($submit_on_change == true)
438 echo "<select name='$name' onchange='this.form.submit();'>";
440 echo "<select name='$name'>";
442 $company_year = get_company_pref('f_year');
444 $sql = "SELECT * FROM ".TB_PREF."fiscal_year ORDER BY begin";
445 $result = db_query($sql);
447 if ($selected_id == null)
448 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
449 while ($row = db_fetch_row($result))
451 // default to the company current fiscal year
452 if ($selected_id == "" && ($row[0] == $company_year))
454 $selected_id = $row[0];
455 $_POST[$name] = $selected_id;
458 if ($selected_id == $row[0])
460 echo "<option selected value='" . $row[0] . "'>";
464 echo "<option value='" . $row[0] . "'>";
470 $row[1] = sql2date($row[1]);
471 $row[2] = sql2date($row[2]);
472 echo $row[1] . " - " . $row[2] . " " . $how . "</option>\n";
476 db_free_result($result);
479 function fiscalyears_list_cells($label, $name, $selected_id)
482 echo "<td>$label</td>\n";
484 fiscalyears_list($name, $selected_id);
488 function fiscalyears_list_row($label, $name, $selected_id)
491 fiscalyears_list_cells($label, $name, $selected_id);
495 //---------------------------------------------------------------------------------------------------
497 function simple_codeandname_list($sql, $name, &$selected_id,
498 $all_option=false, $all_option_name=null, $all_option_numeric=false,
499 $submit_on_change=false, $returnzero=false)
503 default_focus($name);
504 if ($submit_on_change == true)
505 echo "<select name='$name' onchange='this.form.submit();'>";
507 echo "<select name='$name'>";
509 if ($selected_id == null)
510 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
511 if ($all_option == true)
515 elseif ($all_option_numeric)
516 $reserved_word = reserved_words::get_all_numeric();
518 $reserved_word = $all_items;
520 if ($selected_id == $reserved_word)
522 echo "<option selected value='$reserved_word'>$all_option_name</option>\n";
526 echo "<option value='$reserved_word'>$all_option_name</option>\n";
528 if ($selected_id == "")
530 $selected_id = $reserved_word;
534 $result = db_query($sql);
536 while ($row = db_fetch_row($result))
538 if ($selected_id == $row[0])
540 echo "<option selected value='" . $row[0] . "'>";
542 echo "<option value='" . $row[0] . "'>";
544 echo $row[1] . "</option>\n";
546 if (!$returnzero && $selected_id == "")
548 $selected_id = $row[0];
549 $_POST[$name] = $selected_id;
554 db_free_result($result);
557 //------------------------------------------------------------------------------------
559 function dimensions_list($name, &$selected_id, $no_option=false, $showname=null,
560 $submit_on_change=false, $showclosed=false, $showtype=1)
562 default_focus($name);
563 $sql = "SELECT id, CONCAT(reference,' ',name) FROM ".TB_PREF."dimensions";
564 if ($showclosed || $showtype)
569 if ($showclosed && $showtype)
570 $sql .= " AND type_=$showtype";
572 $sql .= " type_=$showtype";
574 $sql .= " ORDER BY reference";
575 simple_codeandname_list($sql, $name, $selected_id, $no_option, $showname,
576 true, $submit_on_change, true);
579 function dimensions_list_cells($label, $name, $selected_id, $no_option=false, $showname=null,
580 $showclosed=false, $showtype=0)
583 echo "<td>$label</td>\n";
585 dimensions_list($name, $selected_id, $no_option, $showname, false, $showclosed, $showtype);
589 function dimensions_list_row($label, $name, $selected_id, $no_option=false, $showname=null,
590 $showclosed=false, $showtype=0)
593 dimensions_list_cells($label, $name, $selected_id, $no_option, $showname,
594 $showclosed, $showtype);
598 //---------------------------------------------------------------------------------------------------
600 function stock_items_list($name, $selected_id, $all_option=false, $submit_on_change=false, $extra="")
604 default_focus($name);
605 if ($selected_id == null)
606 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
609 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
610 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
612 if (get_company_pref('no_item_list'))
614 global $search_button;
615 $edit_name = $name."_edit";
616 $edit_button = $name."_button";
618 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
620 if (isset($_POST[$edit_button]))
622 $selected_id = $_POST[$name] = "";
625 if ($selected_id != "")
628 $sql .= " AND stock_id='$selected_id'";
630 elseif ($val != "" && $val != DEFVAL)
633 (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
634 .TB_PREF."stock_master.description LIKE '%{$val}%')";
637 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
639 echo sprintf($search_button, $edit_button);
641 $result = db_query($sql);
644 if ($submit_on_change==true)
645 echo "<select name='$name' onchange='this.form.submit();'>";
646 else if ($extra != "")
647 echo "<select name='$name' $extra>";
649 echo "<select name='$name'>";
651 if (($all_option == true))
653 if ($selected_id == $all_items)
655 echo "<option selected value='$all_items'>" . _("All Items") . "</option>\n";
659 echo "<option value='$all_items'>" . _("All Items") . "</option>\n";
661 if ($selected_id == "")
663 $selected_id = $all_items;
667 while ($row = db_fetch_row($result))
669 if ($selected_id == $row[0])
671 echo "<option selected value='" . $row[0] . "'>";
675 echo "<option value='" . $row[0] . "'>";
677 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
679 // if no initial selection - set the first item
680 // do we want to do this for all lists ???? probably
681 if ($selected_id == "")
683 $selected_id = $row[0];
684 $_POST[$name] = $selected_id;
688 db_free_result($result);
691 function stock_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false, $extra="")
694 echo "<td>$label</td>\n";
696 stock_items_list($name, $selected_id, $all_option, $submit_on_change, $extra);
700 function stock_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
703 stock_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
707 //------------------------------------------------------------------------------------
709 function stock_bom_items_list($name, $selected_id, $all_option=false, $submit_on_change=false)
713 default_focus($name);
714 if ($submit_on_change==true)
715 echo "<select name='$name' onchange='this.form.submit();'>";
717 echo "<select name='$name'>";
719 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
720 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
721 AND (".TB_PREF."stock_master.mb_flag='M' OR ".TB_PREF."stock_master.mb_flag='K')";
722 $result = db_query($sql);
724 if ($selected_id == null)
725 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
726 if (($all_option == true))
728 if ($selected_id == $all_items)
730 echo "<option selected value='$all_items'>" . _("All Items") . "</option>\n";
734 echo "<option value='$all_items'>" . _("All Items") . "</option>\n";
736 if ($selected_id == "")
738 $selected_id = $all_items;
742 while ($row = db_fetch_row($result))
744 if ($selected_id==$row[0])
746 echo "<option selected value='" . $row[0] . "'>";
750 echo "<option value='" . $row[0] . "'>";
752 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
754 if ($selected_id == "")
756 $selected_id = $row[0];
757 $_POST[$name] = $selected_id;
762 db_free_result($result);
765 function stock_bom_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
768 echo "<td>$label</td>\n";
770 stock_bom_items_list($name, $selected_id, $all_option, $submit_on_change);
774 function stock_bom_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
777 stock_bom_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
781 //------------------------------------------------------------------------------------
783 function base_stock_items_list($sql, $name, &$selected_id,
784 $all_option=false, $all_option_name="", $submit_on_change=false, $extra="")
788 default_focus($name);
789 if ($submit_on_change==true)
790 echo "<select name='$name' onchange='this.form.submit();'>";
791 else if ($extra != "")
792 echo "<select name='$name' $extra>";
794 echo "<select name='$name'>";
796 $result = db_query($sql);
798 if ($selected_id == null)
799 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
800 if ($all_option == true)
802 if ($selected_id == $all_items)
804 echo "<option selected value='$all_items'>$all_option_name</option>\n";
808 echo "<option value='$all_items'>$all_option_name</option>\n";
810 if ($selected_id == "")
812 $selected_id = $all_items;
816 while ($row = db_fetch_row($result))
818 if ($selected_id == $row[0])
820 echo "<option selected value='" . $row[0] . "'>";
824 echo "<option value='" . $row[0] . "'>";
826 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
828 if ($selected_id == "")
830 $selected_id = $row[0];
831 $_POST[$name] = $selected_id;
836 db_free_result($result);
839 //------------------------------------------------------------------------------------
841 function stock_manufactured_items_list($name, &$selected_id,
842 $all_option=false, $submit_on_change=false)
844 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
845 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
846 AND (".TB_PREF."stock_master.mb_flag='M')";
848 base_stock_items_list($sql, $name, $selected_id, $all_option, _("All Items"),
852 function stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
855 echo "<td>$label</td>\n";
857 stock_manufactured_items_list($name, $selected_id, $all_option, $submit_on_change);
861 function stock_manufactured_items_list_row($label, $name, $selected_id, $all_option=false, $submit_on_change=false)
864 stock_manufactured_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
868 //------------------------------------------------------------------------------------
870 function stock_component_items_list($name, $parent_stock_id, &$selected_id,
871 $all_option=false, $submit_on_change=false)
873 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
874 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE
875 ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
876 AND stock_id != '$parent_stock_id'";
878 base_stock_items_list($sql, $name, $selected_id,
879 $all_option, _("All Items"), $submit_on_change);
882 //------------------------------------------------------------------------------------
884 function stock_purchasable_items_list($name, &$selected_id, $all_option=false, $submit_on_change=false, $extra="")
888 default_focus($name);
889 if ($selected_id == null)
890 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
892 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
893 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
895 if (get_company_pref('no_item_list'))
897 $edit_name = $name."_edit";
898 $edit_button = $name."_button";
900 $val = (isset($_POST[$edit_name]) && $_POST[$edit_name] != "" ? $_POST[$edit_name] : "");
901 if (isset($_POST[$edit_button]))
903 $selected_id = $_POST[$name] = "";
907 if ($selected_id != "")
910 $sql .= "AND stock_id='$selected_id'";
912 elseif ($val != "" && $val != DEFVAL)
915 (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
916 .TB_PREF."stock_master.description LIKE '%{$val}%')";
919 echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' > ";
921 echo "<input type='submit' class='inputsubmit' name='$edit_button' value='?'> ";
924 $result = db_query($sql);
926 if ($submit_on_change==true)
927 echo "<select name='$name' onchange='this.form.submit();'>";
928 else if ($extra != "")
929 echo "<select name='$name' $extra>";
931 echo "<select name='$name'>";
933 if ($all_option == true)
935 if ($selected_id == $all_items)
937 echo "<option selected value='$all_items'>"._("All Items")."</option>\n";
941 echo "<option value='$all_items'>"._("All Items")."</option>\n";
943 if ($selected_id == "")
945 $selected_id = $all_items;
949 while ($row = db_fetch_row($result))
951 if ($selected_id == $row[0])
953 echo "<option selected value='" . $row[0] . "'>";
957 echo "<option value='" . $row[0] . "'>";
959 echo (user_show_codes()?$row[0] . " - ":"") . $row[2] . " - " . $row[1] . "</option>\n";
961 if ($selected_id == "")
963 $selected_id = $row[0];
964 $_POST[$name] = $selected_id;
969 db_free_result($result);
972 function stock_purchasable_items_list_cells($label, $name, &$selected_id, $all_option=false, $submit_on_change=false, $extra = "")
975 echo "<td>$label</td>\n";
977 stock_purchasable_items_list($name, $selected_id, $all_option, $submit_on_change, $extra);
981 function stock_purchasable_items_list_row($label, $name, &$selected_id, $all_option=false, $submit_on_change=false)
984 stock_purchasable_items_list_cells($label, $name, $selected_id, $all_option, $submit_on_change);
988 //------------------------------------------------------------------------------------
990 function stock_costable_items_list($name, &$selected_id,
991 $all_option=false, $submit_on_change=false)
993 $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
994 FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
997 base_stock_items_list($sql, $name, $selected_id,
998 $all_option, _("All Items"), $submit_on_change);
1001 //------------------------------------------------------------------------------------
1003 function stock_item_types_list_row($label, $name, $selected_id, $enabled=true)
1005 default_focus($name);
1008 echo "<td>$label</td>\n";
1011 echo "<select name='$name' onchange='this.form.submit();'>\n";
1013 echo "<select disabled name='$name'>\n";
1014 if ($selected_id == null)
1015 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1016 if ($selected_id == "")
1017 $_POST[$name] = $selected_id = "B";
1018 echo "<option " . ($selected_id == 'M'?" selected ":"") . " value='M'>" . _("Manufactured"). "</option>\n";
1019 echo "<option " . ($selected_id == 'B'?" selected ":"") . " value='B'>" . _("Purchased"). "</option>\n";
1020 echo "<option " . ($selected_id == 'D'?" selected ":"") . " value='D'>" . _("Service"). "</option>\n";
1021 echo "</select></td></tr>\n";
1024 function stock_units_list_row($label, $name, $value, $enabled=true)
1026 global $stock_units;
1028 default_focus($name);
1029 $result = get_all_item_units();
1030 echo "<tr><td>$label</td>\n";
1032 echo "<td><select name='$name'>";
1034 echo "<td><select disabled name='$name'>";
1037 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1039 while($unit = db_fetch($result))
1042 $_POST[$name] = $unit['abbr'];
1044 $descr = $unit['name'];
1045 if ($value==$unit['abbr'])
1047 echo "<option selected value='".$unit['abbr']."'>$descr</option>\n";
1051 echo "<option value='".$unit['abbr']."'>$descr</option>\n";
1054 echo "</select></td></tr>\n";
1057 //------------------------------------------------------------------------------------
1059 function tax_types_list($name, $selected_id,
1060 $none_option=false, $none_option_name=null, $submit_on_change=false)
1062 simple_codeandname_list("SELECT id, CONCAT(name, ' (',rate,'%)') as name FROM ".TB_PREF."tax_types",
1063 $name, $selected_id, $none_option, $none_option_name, true, $submit_on_change);
1066 function tax_types_list_cells($label, $name, $selected_id, $none_option=false,
1067 $none_option_name=null, $submit_on_change=false)
1070 echo "<td>$label</td>\n";
1072 tax_types_list($name, $selected_id, $none_option, $none_option_name, $submit_on_change);
1076 function tax_types_list_row($label, $name, $selected_id, $none_option=false,
1077 $none_option_name=null, $submit_on_change=false)
1080 tax_types_list_cells($label, $name, $selected_id, $none_option, $none_option_name, $submit_on_change);
1084 //------------------------------------------------------------------------------------
1086 function tax_groups_list($name, $selected_id,
1087 $none_option=false, $none_option_name=null, $submit_on_change=false)
1089 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."tax_groups ORDER BY id",
1090 $name, $selected_id, $none_option, $none_option_name, true, $submit_on_change);
1093 function tax_groups_list_cells($label, $name, $selected_id, $submit_on_change=false)
1096 echo "<td>$label</td>\n";
1098 tax_groups_list($name, $selected_id, false, null, $submit_on_change);
1102 function tax_groups_list_row($label, $name, $selected_id, $submit_on_change=false)
1105 tax_groups_list_cells($label, $name, $selected_id, false, null, $submit_on_change);
1109 //------------------------------------------------------------------------------------
1111 function item_tax_types_list($name, $selected_id)
1113 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."item_tax_types ORDER BY id",
1114 $name, $selected_id);
1117 function item_tax_types_list_cells($label, $name, $selected_id)
1120 echo "<td>$label</td>\n";
1122 item_tax_types_list($name, $selected_id);
1126 function item_tax_types_list_row($label, $name, $selected_id)
1129 item_tax_types_list_cells($label, $name, $selected_id);
1133 //------------------------------------------------------------------------------------
1135 function shippers_list($name, $selected_id)
1137 simple_codeandname_list("SELECT shipper_id, shipper_name FROM ".TB_PREF."shippers",
1138 $name, $selected_id);
1141 function shippers_list_cells($label, $name, $selected_id)
1144 echo "<td>$label</td>\n";
1146 shippers_list($name, $selected_id);
1150 function shippers_list_row($label, $name, $selected_id)
1153 shippers_list_cells($label, $name, $selected_id);
1157 //-------------------------------------------------------------------------------------
1159 function sales_persons_list($name, $selected_id)
1161 simple_codeandname_list("SELECT salesman_code, salesman_name FROM ".TB_PREF."salesman",
1162 $name, $selected_id);
1165 function sales_persons_list_cells($label, $name, $selected_id)
1168 echo "<td>$label</td>\n";
1170 sales_persons_list($name, $selected_id);
1174 function sales_persons_list_row($label, $name, $selected_id, $submit_on_change=false)
1177 sales_persons_list_cells($label, $name, $selected_id, $submit_on_change=false);
1181 //------------------------------------------------------------------------------------
1183 function sales_areas_list($name, $selected_id)
1185 simple_codeandname_list("SELECT area_code, description FROM ".TB_PREF."areas",
1186 $name, $selected_id);
1189 function sales_areas_list_cells($label, $name, $selected_id)
1192 echo "<td>$label</td>\n";
1194 sales_areas_list($name, $selected_id);
1198 function sales_areas_list_row($label, $name, $selected_id)
1201 sales_areas_list_cells($label, $name, $selected_id);
1205 //------------------------------------------------------------------------------------
1207 function workorders_list($name, $selected_id)
1209 simple_codeandname_list("SELECT id, wo_ref FROM ".TB_PREF."workorders WHERE closed=0",
1210 $name, $selected_id);
1213 function workorders_list_cells($label, $name, $selected_id)
1216 echo "<td>$label</td>\n";
1218 workorders_list($name, $selected_id);
1222 function workorders_list_row($label, $name, $selected_id)
1225 workorders_list_cells($label, $name, $selected_id);
1229 //------------------------------------------------------------------------------------
1231 function payment_terms_list($name, $selected_id)
1233 simple_codeandname_list("SELECT terms_indicator, terms FROM ".TB_PREF."payment_terms",
1234 $name, $selected_id);
1237 function payment_terms_list_cells($label, $name, $selected_id)
1240 echo "<td>$label</td>\n";
1242 payment_terms_list($name, $selected_id);
1246 function payment_terms_list_row($label, $name, $selected_id)
1249 payment_terms_list_cells($label, $name, $selected_id);
1253 //------------------------------------------------------------------------------------
1255 function credit_status_list($name, $selected_id)
1257 simple_codeandname_list("SELECT id, reason_description FROM ".TB_PREF."credit_status",
1258 $name, $selected_id);
1261 function credit_status_list_cells($label, $name, $selected_id)
1264 echo "<td>$label</td>\n";
1266 credit_status_list($name, $selected_id);
1270 function credit_status_list_row($label, $name, $selected_id)
1273 credit_status_list_cells($label, $name, $selected_id);
1277 //-----------------------------------------------------------------------------------------------
1279 function sales_types_list($name, $selected_id, $submit_on_change=false)
1281 simple_codeandname_list("SELECT id, sales_type FROM ".TB_PREF."sales_types",
1282 $name, $selected_id, false, null, false, $submit_on_change);
1285 function sales_types_list_cells($label, $name, $selected_id, $submit_on_change=false)
1288 echo "<td>$label</td>\n";
1290 sales_types_list($name, $selected_id, $submit_on_change);
1294 function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false)
1297 sales_types_list_cells($label, $name, $selected_id, $submit_on_change);
1301 //-----------------------------------------------------------------------------------------------
1303 function movement_types_list($name, $selected_id)
1305 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."movement_types",
1306 $name, $selected_id);
1309 function movement_types_list_cells($label, $name, $selected_id)
1312 echo "<td>$label</td>\n";
1314 movement_types_list($name, $selected_id);
1318 function movement_types_list_row($label, $name, $selected_id)
1321 movement_types_list_cells($label, $name, $selected_id);
1325 //-----------------------------------------------------------------------------------------------
1327 function bank_trans_types_list($name, $selected_id)
1329 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."bank_trans_types",
1330 $name, $selected_id);
1333 function bank_trans_types_list_cells($label, $name, $selected_id)
1336 echo "<td>$label</td>\n";
1338 bank_trans_types_list($name, $selected_id);
1342 function bank_trans_types_list_row($label, $name, $selected_id)
1345 bank_trans_types_list_cells($label, $name, $selected_id);
1349 //-----------------------------------------------------------------------------------------------
1351 function workcenter_list($name, $selected_id, $all_option=false)
1355 default_focus($name);
1356 echo "<select name='$name'>";
1358 $sql = "SELECT id, name FROM ".TB_PREF."workcentres";
1359 $result = db_query($sql);
1361 if ($selected_id == null)
1362 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1363 if ($all_option == true)
1365 if ($selected_id == $all_items)
1367 echo "<option selected value='$all_items'>" . _("All Work Centres") . "</option>\n";
1371 echo "<option value='$all_items'>" . _("All Work Centres") . "</option>\n";
1375 while ($row = db_fetch_row($result))
1377 if ($selected_id == $row[0])
1379 echo "<option selected value='" . $row[0] . "'>";
1383 echo "<option value='" . $row[0] . "'>";
1385 echo $row[1] . "</option>\n";
1389 db_free_result($result);
1392 function workcenter_list_cells($label, $name, $selected_id, $all_option=false)
1394 default_focus($name);
1396 echo "<td>$label</td>\n";
1398 workcenter_list($name, $selected_id, $all_option);
1402 function workcenter_list_row($label, $name, $selected_id, $all_option=false)
1405 workcenter_list_cells($label, $name, $selected_id, $all_option);
1409 //-----------------------------------------------------------------------------------------------
1411 function bank_accounts_list($name, $selected_id, $submit_on_change=false)
1413 default_focus($name);
1414 if ($submit_on_change==true)
1415 echo "<select name='$name' onchange='this.form.submit();'>";
1417 echo "<select name='$name'>";
1419 $company_currency = get_company_currency();
1421 $sql = "SELECT ".TB_PREF."bank_accounts.account_code, bank_account_name, bank_curr_code
1422 FROM ".TB_PREF."bank_accounts, ".TB_PREF."chart_master
1423 WHERE ".TB_PREF."bank_accounts.account_code=".TB_PREF."chart_master.account_code";
1424 $result = db_query($sql);
1426 if ($selected_id == null)
1427 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1428 while ($row = db_fetch_row($result))
1430 if ($selected_id == $row[0])
1432 echo "<option selected value='" . $row[0] . "'>";
1436 echo "<option value='" . $row[0] . "'>";
1439 if ($company_currency != $row[2])
1440 echo " - " . $row[2];
1442 if ($selected_id == "")
1444 $selected_id = $row[0];
1445 $_POST[$name] = $selected_id;
1450 db_free_result($result);
1453 function bank_accounts_list_cells($label, $name, $selected_id, $submit_on_change=false)
1456 echo "<td>$label</td>\n";
1458 bank_accounts_list($name, $selected_id, $submit_on_change);
1462 function bank_accounts_list_row($label, $name, $selected_id, $submit_on_change=false)
1465 bank_accounts_list_cells($label, $name, $selected_id, $submit_on_change);
1469 //-----------------------------------------------------------------------------------------------
1471 function class_list($name, $selected_id, $submit_on_change=false)
1473 default_focus($name);
1474 if ($submit_on_change==true)
1475 echo "<select name='$name' onchange='this.form.submit();'>";
1477 echo "<select name='$name'>";
1479 $sql = "SELECT cid, class_name FROM ".TB_PREF."chart_class";
1480 $result = db_query($sql);
1482 if ($selected_id == null)
1483 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1484 while ($row = db_fetch_row($result))
1486 if ($selected_id == $row[0])
1488 echo "<option selected value='" . $row[0] . "'>";
1492 echo "<option value='" . $row[0] . "'>";
1494 echo $row[1] . "</option>\n";
1495 if ($selected_id == "")
1497 $selected_id = $row[0];
1498 $_POST[$name] = $selected_id;
1503 db_free_result($result);
1506 function class_list_cells($label, $name, $selected_id, $submit_on_change=false)
1509 echo "<td>$label</td>\n";
1511 class_list($name, $selected_id, $submit_on_change);
1515 function class_list_row($label, $name, $selected_id, $submit_on_change=false)
1518 class_list_cells($label, $name, $selected_id, $submit_on_change);
1522 //-----------------------------------------------------------------------------------------------
1524 function stock_categories_list($name, $selected_id)
1526 simple_codeandname_list("SELECT category_id, description FROM ".TB_PREF."stock_category
1527 ORDER BY category_id", $name, $selected_id);
1530 function stock_categories_list_cells($label, $name, $selected_id)
1533 echo "<td>$label</td>\n";
1535 stock_categories_list($name, $selected_id);
1539 function stock_categories_list_row($label, $name, $selected_id)
1542 stock_categories_list_cells($label, $name, $selected_id);
1546 //-----------------------------------------------------------------------------------------------
1548 function gl_account_types_list($name, $selected_id, $all_option, $all_option_name,
1549 $all_option_numeric)
1551 simple_codeandname_list("SELECT id, name FROM ".TB_PREF."chart_types ORDER BY id",
1552 $name, $selected_id, $all_option, $all_option_name, $all_option_numeric);
1555 function gl_account_types_list_cells($label, $name, $selected_id, $all_option=false, $all_option_name=null,
1556 $all_option_numeric=false)
1559 echo "<td>$label</td>\n";
1561 gl_account_types_list($name, $selected_id, $all_option, $all_option_name, $all_option_numeric);
1565 function gl_account_types_list_row($label, $name, $selected_id, $all_option=false, $all_option_name=null,
1566 $all_option_numeric=false)
1569 gl_account_types_list_cells($label, $name, $selected_id, $all_option,
1570 $all_option_name, $all_option_numeric);
1574 //-----------------------------------------------------------------------------------------------
1576 function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false,
1577 $show_group=false, $onchange="")
1579 default_focus($name);
1580 echo "<select name='$name'";
1581 if ($onchange != "")
1582 echo " onchange='$onchange'";
1585 if ($skip_bank_accounts)
1586 $sql = "SELECT ".TB_PREF."chart_master.account_code, ".TB_PREF."chart_master.account_name, ".TB_PREF."chart_types.name
1587 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
1588 WHERE ".TB_PREF."bank_accounts.account_code IS NULL
1589 AND ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id
1590 ORDER BY account_code;";
1592 $sql = "SELECT account_code, account_name,".TB_PREF."chart_types.name
1593 FROM ".TB_PREF."chart_master, ".TB_PREF."chart_types
1594 WHERE ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id
1595 ORDER BY account_code";
1597 if ($selected_id == null)
1598 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1599 $result = db_query($sql, "query chart master");
1601 while ($row = db_fetch_row($result))
1603 if ($selected_id == $row[0])
1605 echo "<option selected value='" . $row[0] . "'>";
1609 echo "<option value='" . $row[0] . "'>";
1611 //echo str_pad($row[0],6,'0', STR_PAD_LEFT) . " " . $row[2] . " " . $row[1];
1613 echo $row[0] . " " . $row[2] . " " . $row[1] . "</option>\n";
1615 echo $row[0] . " " . $row[1] . "</option>\n";
1617 if ($selected_id == "")
1619 $selected_id = $row[0];
1620 $_POST[$name] = $selected_id;
1625 db_free_result($result);
1628 function gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts=false,
1629 $show_group=false, $onchange="")
1632 echo "<td>$label</td>\n";
1634 gl_all_accounts_list($name, $selected_id, $skip_bank_accounts, $show_group, $onchange);
1638 function gl_all_accounts_list_row($label, $name, $selected_id, $skip_bank_accounts=false,
1639 $show_group=false, $onchange="")
1642 gl_all_accounts_list_cells($label, $name, $selected_id, $skip_bank_accounts,
1643 $show_group, $onchange);
1647 function yesno_list($name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
1649 default_focus($name);
1650 if ($submit_on_change == true)
1651 echo "<select name='$name' onchange='this.form.submit();'>";
1653 echo "<select name='$name'>";
1655 if (strlen($name_yes) == 0)
1659 if (strlen($name_no) == 0)
1664 if ($selected_id == null)
1665 $selected_id = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1666 if ($selected_id == 0)
1667 echo "<option value=1>";
1669 echo "<option selected value=1>";
1670 if (!isset($name_yes))
1671 echo _("Yes") . "</option>\n";
1673 echo $name_yes . "</option>\n";
1674 if ($selected_id == 0)
1675 echo "<option selected value=0>";
1677 echo "<option value=0>";
1678 if (!isset($name_no))
1679 echo _("No") . "</option>\n";
1681 echo $name_no . "</option>\n";
1685 function yesno_list_cells($label, $name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
1688 echo "<td>$label</td>\n";
1690 yesno_list($name, $selected_id, $name_yes, $name_no, $submit_on_change);
1694 function yesno_list_row($label, $name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
1697 yesno_list_cells($label, $name, $selected_id, $name_yes, $name_no, $submit_on_change);
1701 //------------------------------------------------------------------------------------------------
1703 function languages_list($name, &$selected_id)
1705 global $installed_languages;
1707 default_focus($name);
1708 echo "<select name='$name'>";
1710 if ($selected_id == null)
1711 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1712 foreach ($installed_languages as $lang)
1715 if ($selected_id == $lang['code'])
1717 echo "value='" . $lang['code'] . "'>" . $lang['name'] . "</option>\n";
1721 function languages_list_cells($label, $name, $selected_id)
1724 echo "<td>$label</td>\n";
1726 languages_list($name, $selected_id);
1730 function languages_list_row($label, $name, $selected_id)
1733 languages_list_cells($label, $name, $selected_id);
1737 //------------------------------------------------------------------------------------------------
1739 function bank_account_types_list($name, &$selected_id)
1741 $bank_account_types = bank_account_types::get_all();
1743 default_focus($name);
1744 echo "<select name='$name'>";
1746 if ($selected_id == null)
1747 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1748 foreach ($bank_account_types as $type)
1751 if ($selected_id == "" || $selected_id == $type['id'])
1753 echo "value='" . $type['id'] . "'>" . $type['name'] . "</option>\n";
1757 function bank_account_types_list_cells($label, $name, $selected_id)
1760 echo "<td>$label</td>\n";
1762 bank_account_types_list($name, $selected_id);
1766 function bank_account_types_list_row($label, $name, $selected_id)
1769 bank_account_types_list_cells($label, $name, $selected_id);
1773 //------------------------------------------------------------------------------------------------
1775 function payment_person_types_list($name, $selected_id, $related=null)
1777 $types = payment_person_types::get_all();
1779 default_focus($name);
1780 echo "<select name='$name'";
1782 echo " onchange='this.form.$related.value=\"\"; this.form.submit();' ";
1785 if ($selected_id == null)
1786 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1787 foreach ($types as $type)
1789 if (payment_person_types::has_items($type['id']))
1791 if ($selected_id == "")
1792 $_POST[$name] = $selected_id = $type['id'];
1794 if ($selected_id == $type['id'])
1796 echo "value='" . $type['id'] . "'>" . $type['name'] . "</option>\n";
1801 function payment_person_types_list_cells($label, $name, $selected_id, $related=null)
1804 echo "<td>$label</td>\n";
1806 payment_person_types_list($name, $selected_id, $related);
1810 function payment_person_types_list_row($label, $name, $selected_id, $related=null)
1813 payment_person_types_list_cells($label, $name, $selected_id, $related);
1817 //------------------------------------------------------------------------------------------------
1819 function wo_types_list($name, &$selected_id)
1821 $types = wo_types::get_all();
1823 default_focus($name);
1824 echo "<select name='$name' onchange='this.form.submit();'>";
1826 if ($selected_id == null)
1827 $selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1828 foreach ($types as $type)
1831 if ($selected_id == $type['id'])
1833 echo "value='" . $type['id'] . "'>" . $type['name'] . "</option>\n";
1838 function wo_types_list_row($label, $name, &$selected_id)
1840 echo "<tr><td>$label</td><td>\n";
1841 wo_types_list($name, $selected_id);
1842 echo "</td></tr>\n";
1845 //------------------------------------------------------------------------------------------------
1847 function dateformats_list_row($label, $name, $value)
1849 global $dateformats;
1851 default_focus($name);
1852 echo "<tr><td>$label</td>\n";
1853 echo "<td><select name='$name'>";
1856 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1858 foreach ($dateformats as $df)
1861 if ($value==$counter)
1863 echo "<option selected value='$counter'>$df</option>\n";
1867 echo "<option value='$counter'>$df</option>\n";
1871 echo "</select></td></tr>\n";
1874 function dateseps_list_row($label, $name, $value)
1878 default_focus($name);
1879 echo "<tr><td>$label</td>\n";
1880 echo "<td><select name='$name'>";
1883 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1885 foreach ($dateseps as $ds)
1888 if ($value==$counter)
1890 echo "<option selected value='$counter'>$ds</option>\n";
1894 echo "<option value='$counter'>$ds</option>\n";
1898 echo "</select></td></tr>\n";
1901 function thoseps_list_row($label, $name, $value)
1905 default_focus($name);
1906 echo "<tr><td>$label</td>\n";
1907 echo "<td><select name='$name'>";
1910 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1912 foreach ($thoseps as $ts)
1915 if ($value==$counter)
1917 echo "<option selected value='$counter'>$ts</option>\n";
1921 echo "<option value='$counter'>$ts</option>\n";
1925 echo "</select></td></tr>\n";
1928 function decseps_list_row($label, $name, $value)
1932 default_focus($name);
1933 echo "<tr><td>$label</td>\n";
1934 echo "<td><select name='$name'>";
1937 $value = (!isset($_POST[$name]) ? 0 : $_POST[$name]);
1939 foreach ($decseps as $ds)
1942 if ($value==$counter)
1944 echo "<option selected value='$counter'>$ds</option>\n";
1948 echo "<option value='$counter'>$ds</option>\n";
1952 echo "</select></td></tr>\n";
1955 function themes_list_row($label, $name, $value)
1957 global $path_to_root;
1959 default_focus($name);
1960 $path = $path_to_root.'/themes/';
1962 $themedir = opendir($path);
1963 while(false !== ($fname = readdir($themedir))) {
1964 if($fname!='.' && $fname!='..' && $fname!='CVS' && is_dir($path.$fname)) {
1969 echo "<tr><td>$label</td>\n";
1970 echo "<td><select name='$name'>";
1973 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1974 foreach ($themes as $th)
1979 echo "<option selected value='$th'>$th</option>\n";
1983 echo "<option value='$th'>$th</option>\n";
1986 echo "</select></td></tr>\n";
1989 function pagesizes_list_row($label, $name, $value)
1993 default_focus($name);
1994 echo "<tr><td>$label</td>\n";
1995 echo "<td><select name='$name'>";
1998 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
1999 foreach ($pagesizes as $pz)
2004 echo "<option selected value='$pz'>$pz</option>\n";
2008 echo "<option value='$pz'>$pz</option>\n";
2011 echo "</select></td></tr>\n";
2014 function security_headings_list_row($label, $name, $value)
2016 global $security_headings;
2018 default_focus($name);
2019 echo "<tr><td>$label</td>\n";
2020 echo "<td><select name='$name'>";
2023 $value = (!isset($_POST[$name]) ? 0 : (int)$_POST[$name]);
2025 foreach ($security_headings as $sh)
2028 if ($value==$counter)
2030 echo "<option selected value='$counter'>$sh</option>\n";
2034 echo "<option value='$counter'>$sh</option>\n";
2038 echo "</select></td></tr>\n";
2041 function systypes_list_cells($label, $name, $value, $submit_on_change=false)
2043 global $systypes_array;
2045 default_focus($name);
2047 echo "<td>$label</td>\n";
2048 echo "<td><select name='$name'";
2049 if ($submit_on_change)
2050 echo " onchange='this.form.submit();'>";
2054 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2055 foreach ($systypes_array as $key=>$type)
2060 echo "<option selected value='$key'>".$type['name']."</option>\n";
2064 echo "<option value='$key'>".$type['name']."</option>\n";
2067 echo "</select></td>\n";
2070 function systypes_list_row($label, $name, $value, $submit_on_change=false)
2073 systypes_list_cells($label, $name, $value, $submit_on_change);
2077 function cust_allocations_list_cells($label, $name, $selected)
2080 default_focus($name);
2083 if ($selected == null)
2084 $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2085 echo "<td><select name='$name'>";
2086 echo "<option " . ($selected == $all_items ? " selected " : "") . " value='$all_items'>" . _("All Types"). "</option>\n";
2087 echo "<option " . ($selected == '1'?" selected ":"") . " value='1'>" . _("Sales Invoices"). "</option>\n";
2088 echo "<option " . ($selected == '2'?" selected ":"") . " value='2'>" . _("Overdue Invoices"). "</option>\n";
2089 echo "<option " . ($selected == '3'?" selected ":"") . " value='3'>" . _("Payments"). "</option>\n";
2090 echo "<option " . ($selected == '4'?" selected ":"") . " value='4'>" . _("Credit Notes"). "</option>\n";
2091 echo "<option " . ($selected == '5'?" selected ":"") . " value='5'>" . _("Delivery Notes"). "</option>\n";
2092 echo "</select></td>\n";
2095 function supp_allocations_list_cells($name, $selected)
2099 default_focus($name);
2100 if ($selected == null)
2101 $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2102 echo "<td><select name='$name'>";
2103 echo "<option " . ($selected == $all_items ? " selected " : "") . " value='$all_items'>" . _("All Types"). "</option>\n";
2104 echo "<option " . ($selected == '1'?" selected ":"") . " value='1'>" . _("Invoices"). "</option>\n";
2105 echo "<option " . ($selected == '2'?" selected ":"") . " value='2'>" . _("Overdue Invoices"). "</option>\n";
2106 echo "<option " . ($selected == '3'?" selected ":"") . " value='3'>" . _("Payments"). "</option>\n";
2107 echo "<option " . ($selected == '4'?" selected ":"") . " value='4'>" . _("Credit Notes"). "</option>\n";
2108 echo "<option " . ($selected == '5'?" selected ":"") . " value='5'>" . _("Overdue Credit Notes"). "</option>\n";
2109 echo "</select></td>\n";
2112 function policy_list_cells($label, $name, $selected)
2114 default_focus($name);
2115 if ($selected == null)
2117 $selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
2118 if ($selected == "")
2119 $_POST[$name] = $selected;
2123 echo "<td><select name='$name'>";
2124 echo "<option " . ($selected == ''?" selected ":"") . " value=''>" . _("Automatically put balance on back order"). "</option>\n";
2125 echo "<option " . ($selected == 'CAN'?" selected ":"") . " value='CAN'>" . _("Cancel any quantites not delivered"). "</option>\n";
2126 echo "</select></td>\n";
2129 function policy_list_row($label, $name, $selected)
2132 policy_list_cells($label, $name, $selected);
2136 function credit_type_list_cells($label, $name, $selected, $submit_on_change=false)
2138 default_focus($name);
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 default_focus($name);
2167 if ($selected == null)
2169 $selected = (!isset($_POST[$name]) ? $from : $_POST[$name]);
2170 if ($selected == $from)
2171 $_POST[$name] = $selected;
2173 echo "<select name='$name'>";
2174 for ($i = $from; $i <= $to; $i++)
2176 if ($i == 0 && $firstlabel != "")
2177 $label = $firstlabel;
2180 if ($selected == $i)
2182 echo "<option selected value='$i'>$label</option>\n";
2186 echo "<option value='$i'>$label</option>\n";
2192 function number_list_cells($label, $name, $selected, $from, $to)
2197 number_list($name, $selected, $from, $to);
2201 function number_list_row($label, $name, $selected, $from, $to)
2204 number_list_cells($label, $name, $selected, $from, $to);