2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
13 // Sets local POST value and adds Value to ajax posting if needed
15 /*function set_post($name, $value, $ajax_trigger=true) {
18 $_POST[$name] = $value;
19 if ($ajax_trigger) $Ajax->activate($name);
22 //------------------------------------------------------------------------------
23 // Seek for _POST variable with $prefix.
24 // If var is found returns variable name with prefix stripped,
25 // and null or -1 otherwise.
27 function find_submit($prefix, $numeric=true)
30 foreach($_POST as $postkey=>$postval )
32 if (strpos($postkey, $prefix) === 0)
34 $id = substr($postkey, strlen($prefix));
35 return $numeric ? (int)$id : $id;
38 return $numeric ? -1 : null;
40 //------------------------------------------------------------------------------
42 // Helper function for simple db table editor pages
44 function simple_page_mode($numeric_id = true)
46 global $Ajax, $Mode, $selected_id;
48 $default = $numeric_id ? -1 : '';
49 $selected_id = get_post('selected_id', $default);
50 foreach (array('ADD_ITEM', 'UPDATE_ITEM', 'RESET', 'CLONE') as $m) {
51 if (isset($_POST[$m])) {
52 $Ajax->activate('_page_body');
53 if ($m == 'RESET' || $m == 'CLONE')
54 $selected_id = $default;
55 unset($_POST['_focus']);
59 foreach (array('Edit', 'Delete') as $m) {
60 foreach ($_POST as $p => $pvar) {
61 if (strpos($p, $m) === 0) {
62 // $selected_id = strtr(substr($p, strlen($m)), array('%2E'=>'.'));
63 unset($_POST['_focus']); // focus on first form entry
64 $selected_id = quoted_printable_decode(substr($p, strlen($m)));
65 $Ajax->activate('_page_body');
74 //------------------------------------------------------------------------------
76 // Read numeric value from user formatted input
78 function input_num($postname=null, $dflt=0)
80 if (!isset($_POST[$postname]) || $_POST[$postname] == "")
83 return user_numeric($_POST[$postname]);
86 //---------------------------------------------------------------------------------
88 function hidden($name, $value=null, $echo=true)
93 $value = get_post($name);
95 $ret = "<input type=\"hidden\" name=\"$name\" value=\"$value\">";
96 $Ajax->addUpdate($name, $name, $value);
103 Universal submit form button.
104 $atype - type of submit:
106 false - normal button; optional icon
107 null - button visible only in fallback mode; optional icon
109 true - standard button; optional icon
111 'default' - default form submit on Ctrl-Enter press; dflt ICON_OK icon
112 'selector' - ditto with closing current popup editor window
113 'cancel' - cancel form entry on Escape press; dflt ICON_CANCEL
114 'process' - displays progress bar during call; optional icon
116 $atype can contain also multiply type selectors separated by space,
117 however make sense only combination of 'process' and one of defualt/selector/cancel
119 function submit($name, $value, $echo=true, $title=false, $atype=false, $icon=false)
121 global $path_to_root;
124 if ($atype === null) {
125 $aspect = fallback_mode() ? " aspect='fallback'" : " style='display:none;'";
127 } elseif (!is_bool($atype)) { // necessary: switch uses '=='
129 $aspect = "aspect='$atype' ";
130 $types = explode(' ', $atype);
132 foreach ($types as $type) {
135 $aspect = " aspect='selector' rel = '$value'";
136 $value = _("Select");
137 if ($icon===false) $icon=ICON_SUBMIT; break;
140 if ($icon===false) $icon=ICON_SUBMIT; break;
143 if ($icon===false) $icon=ICON_ESCAPE; break;
147 $submit_str = "<button class=\""
148 .($atype ? 'ajaxsubmit' : 'inputsubmit')
149 ."\" type=\"submit\""
151 ." name=\"$name\" id=\"$name\" value=\"$value\""
152 .($title ? " title='$title'" : '')
154 .($icon ? "<img src='$path_to_root/themes/".user_theme()."/images/$icon' height='12'>" : '')
155 ."<span>$value</span>"
163 function submit_center($name, $value, $echo=true, $title=false, $async=false, $icon=false)
165 if ($echo) echo "<center>";
166 submit($name, $value, $echo, $title, $async, $icon);
167 if ($echo) echo "</center>";
170 function submit_center_first($name, $value, $title=false, $async=false, $icon=false)
173 submit($name, $value, true, $title, $async, $icon);
177 function submit_center_last($name, $value, $title=false, $async=false, $icon=false)
180 submit($name, $value, true, $title, $async, $icon);
184 For following controls:
185 'both' - use both Ctrl-Enter and Escape hotkeys
186 'cancel' - apply to 'RESET' button
188 function submit_add_or_update($add=true, $title=false, $async=false, $clone=false)
192 if ($async === 'both') {
193 $async = 'default'; $cancel = 'cancel';
195 else if ($async === 'default')
197 else if ($async === 'cancel')
201 submit('ADD_ITEM', _("Add new"), true, $title, $async);
203 submit('UPDATE_ITEM', _("Update"), true, _('Submit changes'), $async);
204 if ($clone) submit('CLONE', _("Clone"), true,
205 _('Edit new record with current data'), $async);
206 submit('RESET', _("Cancel"), true, _('Cancel edition'), $cancel);
210 function submit_add_or_update_center($add=true, $title=false, $async=false, $clone=false)
213 submit_add_or_update($add, $title, $async, $clone);
217 function submit_add_or_update_row($add=true, $right=true, $extra="", $title=false, $async=false, $clone = false)
221 echo "<td> </td>\n";
223 submit_add_or_update($add, $title, $async, $clone);
227 function submit_cells($name, $value, $extra="", $title=false, $async=false)
230 submit($name, $value, true, $title, $async);
234 function submit_row($name, $value, $right=true, $extra="", $title=false, $async=false)
238 echo "<td> </td>\n";
239 submit_cells($name, $value, $extra, $title, $async);
243 function submit_return($name, $value, $title=false)
245 if (@$_REQUEST['popup']) {
246 submit($name, $value, true, $title, 'selector');
250 function submit_js_confirm($name, $msg) {
252 "_validate.$name=function(){ return confirm('"
253 . strtr($msg, array("\n"=>'\\n')) . "');};");
255 //-----------------------------------------------------------------------------------
257 function set_icon($icon, $title=false)
259 global $path_to_root;
260 return "<img src='$path_to_root/themes/".user_theme()."/images/$icon' width='12' height='12' border='0'".($title ? " title='$title'" : "")." />\n";
263 function button($name, $value, $title=false, $icon=false, $aspect='')
265 // php silently changes dots,spaces,'[' and characters 128-159
266 // to underscore in POST names, to maintain compatibility with register_globals
268 if ($aspect == 'selector') {
269 $rel = " rel='$value'";
270 $value = _("Select");
272 if (user_graphic_links() && $icon)
274 if ($value == _("Delete")) // Helper during implementation
276 return "<button type='submit' class='editbutton' name='"
277 .htmlentities(strtr($name, array('.'=>'=2E', '='=>'=3D',// ' '=>'=20','['=>'=5B'
279 ."' value='1'" . ($title ? " title='$title'":" title='$value'")
280 . ($aspect ? " aspect='$aspect'" : '')
282 ." />".set_icon($icon)."</button>\n";
285 return "<input type='submit' class='editbutton' name='"
286 .htmlentities(strtr($name, array('.'=>'=2E', '='=>'=3D',// ' '=>'=20','['=>'=5B'
289 .($title ? " title='$title'":'')
290 . ($aspect ? " aspect='$aspect'" : '')
295 function button_cell($name, $value, $title=false, $icon=false, $aspect='')
297 echo "<td align='center'>";
298 echo button($name, $value, $title, $icon, $aspect);
302 function delete_button_cell($name, $value, $title=false)
304 button_cell($name, $value, $title, ICON_DELETE);
307 function edit_button_cell($name, $value, $title=false)
309 button_cell($name, $value, $title, ICON_EDIT);
312 function select_button_cell($name, $value, $title=false)
314 button_cell($name, $value, $title, ICON_ADD, 'selector');
316 //-----------------------------------------------------------------------------------
318 function check_value($name)
320 if (!isset($_POST[$name]))
325 function checkbox($label, $name, $value=null, $submit_on_change=false, $title=false)
332 $str .= $label . " ";
333 if ($submit_on_change !== false) {
334 if ($submit_on_change === true)
336 "JsHttpRequest.request(\"_{$name}_update\", this.form);";
339 $value = get_post($name,0);
342 .($value == 1 ? ' checked':'')
343 ." type='checkbox' name='$name' value='1'"
344 .($submit_on_change ? " onclick='$submit_on_change'" : '')
345 .($title ? " title='$title'" : '')
348 $Ajax->addUpdate($name, $name, $value);
352 function check($label, $name, $value=null, $submit_on_change=false, $title=false)
354 echo checkbox($label, $name, $value, $submit_on_change, $title);
357 function check_cells($label, $name, $value=null, $submit_on_change=false, $title=false,
361 echo "<td>$label</td>\n";
363 echo check(null, $name, $value, $submit_on_change, $title);
367 function check_row($label, $name, $value=null, $submit_on_change=false, $title=false)
369 echo "<tr><td class='label'>$label</td>";
370 echo check_cells(NULL, $name, $value, $submit_on_change, $title);
374 //-----------------------------------------------------------------------------------
375 function radio($label, $name, $value, $selected, $submit_on_change=false) {
377 if ($submit_on_change === true)
379 "JsHttpRequest.request(\"_{$name}_update\", this.form);";
381 return "<input type='radio' name=$name value='$value' ".($selected ? "checked":'')
382 .($submit_on_change ? " onclick='$submit_on_change'" : '')
383 .">".($label ? $label : '');
386 //-----------------------------------------------------------------------------------
387 function labelheader_cell($label, $params="")
389 echo "<td class='tableheader' $params>$label</td>\n";
392 function label_cell($label, $params="", $id=null)
398 $params .= " id='$id'";
399 $Ajax->addUpdate($id, $id, $label);
401 echo "<td $params>$label</td>\n";
406 function email_cell($label, $params="", $id=null)
408 label_cell("<a href='mailto:$label'>$label</a>", $params, $id);
411 function amount_decimal_cell($label, $params="", $id=null)
414 label_cell(price_decimal_format($label, $dec), "nowrap align=right ".$params, $id);
417 function amount_cell($label, $bold=false, $params="", $id=null)
420 label_cell("<b>".price_format($label)."</b>", "nowrap align=right ".$params, $id);
422 label_cell(price_format($label), "nowrap align=right ".$params, $id);
425 //JAM Allow entered unit prices to be fractional
426 function unit_amount_cell($label, $bold=false, $params="", $id=null)
429 label_cell("<b>".unit_price_format($label)."</b>", "nowrap align=right ".$params, $id);
431 label_cell(unit_price_format($label), "nowrap align=right ".$params, $id);
435 function percent_cell($label, $bold=false, $id=null)
438 label_cell("<b>".percent_format($label)."</b>", "nowrap align=right", $id);
440 label_cell(percent_format($label), "nowrap align=right", $id);
442 // 2008-06-15. Changed
443 function qty_cell($label, $bold=false, $dec=null, $id=null)
446 $dec = get_qty_dec();
448 label_cell("<b>".number_format2($label, $dec)."</b>", "nowrap align=right", $id);
450 label_cell(number_format2($label, $dec), "nowrap align=right", $id);
453 function label_cells($label, $value, $params="", $params2="", $id='')
456 echo "<td $params>$label</td>\n";
457 label_cell($value, $params2, $id);
460 function label_row($label, $value, $params="", $params2="", $leftfill=0, $id='')
465 echo "<td class='label'>$label</td>";
468 label_cells($label, $value, $params, $params2, $id);
470 echo "<td colspan=$leftfill></td>";
474 //-----------------------------------------------------------------------------------
476 function text_cells($label, $name, $value=null, $size="", $max="", $title=false,
477 $labparams="", $post_label="", $inparams="")
481 default_focus($name);
483 label_cell($label, $labparams);
487 $value = get_post($name);
488 echo "<input $inparams type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" value=\"$value\""
489 .($title ? " title='$title'" : '')
492 if ($post_label != "")
493 echo " " . $post_label;
496 $Ajax->addUpdate($name, $name, $value);
499 function text_cells_ex($label, $name, $size, $max=null, $init=null, $title=null,
500 $labparams=null, $post_label=null, $submit_on_change=false)
504 default_focus($name);
505 if (!isset($_POST[$name]) || $_POST[$name] == "")
508 $_POST[$name] = $init;
513 label_cell($label, $labparams);
519 $class = $submit_on_change ? 'class="searchbox"' : '';
520 echo "<input $class type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" value=\"" . $_POST[$name]. "\""
521 .($title ? " title='$title'": '')." >";
524 echo " " . $post_label;
527 $Ajax->addUpdate($name, $name, $_POST[$name]);
530 function text_row($label, $name, $value, $size, $max, $title=null, $params="", $post_label="")
532 echo "<tr><td class='label'>$label</td>";
533 text_cells(null, $name, $value, $size, $max, $title, $params, $post_label);
538 //-----------------------------------------------------------------------------------
540 function text_row_ex($label, $name, $size, $max=null, $title=null, $value=null, $params=null, $post_label=null)
542 echo "<tr><td class='label'>$label</td>";
543 text_cells_ex(null, $name, $size, $max, $value, $title, $params, $post_label);
548 //-----------------------------------------------------------------------------------
549 function email_row($label, $name, $value, $size, $max, $title=null, $params="", $post_label="")
552 $label = "<a href='Mailto:".$_POST[$name]."'>$label</a>";
553 text_row($label, $name, $value, $size, $max, $title, $params, $post_label);
556 function email_row_ex($label, $name, $size, $max=null, $title=null, $value=null, $params=null, $post_label=null)
559 $label = "<a href='Mailto:".$_POST[$name]."'>$label</a>";
560 text_row_ex($label, $name, $size, $max, $title, $value, $params, $post_label);
563 function link_row($label, $name, $value, $size, $max, $title=null, $params="", $post_label="")
565 $val = get_post($name);
567 if (strpos($val,'http://')===false)
568 $val = 'http://'.$val;
569 $label = "<a href='$val' target='_blank'>$label</a>";
571 text_row($label, $name, $value, $size, $max, $title, $params, $post_label);
574 function link_row_ex($label, $name, $size, $max=null, $title=null, $value=null, $params=null, $post_label=null)
576 $val = get_post($name);
578 if (strpos($val,'http://')===false)
579 $val = 'http://'.$val;
580 $label = "<a href='$val' target='_blank'>$label</a>";
582 text_row_ex($label, $name, $size, $max, $title, $value, $params, $post_label);
585 //-----------------------------------------------------------------------------------
587 // Since FA 2.2 $init parameter is superseded by $check.
588 // When $check!=null current date is displayed in red when set to other
589 // than current date.
591 function date_cells($label, $name, $title = null, $check=null, $inc_days=0,
592 $inc_months=0, $inc_years=0, $params=null, $submit_on_change=false)
594 global $use_date_picker, $path_to_root, $Ajax;
596 if (!isset($_POST[$name]) || $_POST[$name] == "")
598 if ($inc_years == 1001)
599 $_POST[$name] = null;
604 $dd = add_days($dd, $inc_days);
605 if ($inc_months != 0)
606 $dd = add_months($dd, $inc_months);
608 $dd = add_years($dd, $inc_years);
612 if ($use_date_picker)
613 $post_label = "<a tabindex='-1' href=\"javascript:date_picker(document.getElementsByName('$name')[0]);\">"
614 . " <img src='$path_to_root/themes/default/images/cal.gif' width='16' height='16' border='0' alt='"._('Click Here to Pick up the date')."'></a>\n";
619 label_cell($label, $params);
623 $class = $submit_on_change ? 'class="searchbox"' : '';
625 $aspect = $check ? 'aspect="cdate"' : '';
626 if ($check && (get_post($name) != Today()))
627 $aspect .= ' style="color:#FF0000"';
629 default_focus($name);
631 echo "<input type=\"text\" name=\"$name\" $class $aspect size=\"9\" maxlength=\"12\" value=\""
632 . $_POST[$name]. "\""
633 .($title ? " title='$title'": '')." > $post_label";
635 $Ajax->addUpdate($name, $name, $_POST[$name]);
638 function date_row($label, $name, $title=null, $check=null, $inc_days=0, $inc_months=0,
639 $inc_years=0, $params=null, $submit_on_change=false)
641 echo "<tr><td class='label'>$label</td>";
642 date_cells(null, $name, $title, $check, $inc_days, $inc_months,
643 $inc_years, $params, $submit_on_change);
647 //-----------------------------------------------------------------------------------
648 function password_row($label, $name, $value)
650 echo "<tr><td class='label'>$label</td>";
651 label_cell("<input type='password' name='$name' size=20 maxlength=20 value='$value' />");
655 //-----------------------------------------------------------------------------------
656 function file_cells($label, $name, $id="")
660 label_cells($label, "<input type='file' name='$name' $id />");
662 function file_row($label, $name, $id = "")
664 echo "<tr><td class='label'>$label</td>";
665 file_cells(null, $name, $id);
669 //-----------------------------------------------------------------------------------
671 function ref_cells($label, $name, $title=null, $init=null, $params=null, $submit_on_change=false)
673 text_cells_ex($label, $name, 16, 18, $init, $title, $params, null, $submit_on_change);
676 //-----------------------------------------------------------------------------------
678 function ref_row($label, $name, $title=null, $init=null, $submit_on_change=false)
680 echo "<tr><td class='label'>$label</td>";
681 ref_cells(null, $name, $title, $init, null, $submit_on_change);
685 //-----------------------------------------------------------------------------------
687 function percent_row($label, $name, $init=null)
690 if (!isset($_POST[$name]) || $_POST[$name]=="")
692 $_POST[$name] = $init == null ? '' : $init;
695 small_amount_row($label, $name, $_POST[$name], null, "%", user_percent_dec());
698 function amount_cells_ex($label, $name, $size, $max=null, $init=null, $params=null, $post_label=null, $dec=null)
703 $dec = user_price_dec();
704 if (!isset($_POST[$name]) || $_POST[$name] == "")
707 $_POST[$name] = $init;
714 $params = "class='label'";
715 label_cell($label, $params);
723 echo "<td align='right'>";
725 echo "<input class='amount' type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" dec=\"$dec\" value=\"" . $_POST[$name]. "\">";
728 echo "<span id='_{$name}_label'> $post_label</span>";
729 $Ajax->addUpdate($name, '_'.$name.'_label', $post_label);
732 $Ajax->addUpdate($name, $name, $_POST[$name]);
733 $Ajax->addAssign($name, $name, 'dec', $dec);
737 //-----------------------------------------------------------------------------------
739 function amount_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
741 amount_cells_ex($label, $name, 15, 15, $init, $params, $post_label, $dec);
744 //JAM Allow entered unit prices to be fractional
745 function unit_amount_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
748 $dec = user_price_dec()+2;
750 amount_cells_ex($label, $name, 15, 15, $init, $params, $post_label, $dec+2);
753 function amount_row($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
756 amount_cells($label, $name, $init, $params, $post_label, $dec);
760 function small_amount_row($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
763 small_amount_cells($label, $name, $init, $params, $post_label, $dec);
767 //-----------------------------------------------------------------------------------
769 function qty_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
772 $dec = user_qty_dec();
774 amount_cells_ex($label, $name, 15, 15, $init, $params, $post_label, $dec);
777 function qty_row($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
780 $dec = user_qty_dec();
783 amount_cells($label, $name, $init, $params, $post_label, $dec);
787 function small_qty_row($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
790 $dec = user_qty_dec();
793 small_amount_cells($label, $name, $init, $params, $post_label, $dec);
797 //-----------------------------------------------------------------------------------
799 function small_amount_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
801 amount_cells_ex($label, $name, 7, 12, $init, $params, $post_label, $dec);
804 //-----------------------------------------------------------------------------------
806 function small_qty_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
809 $dec = user_qty_dec();
810 amount_cells_ex($label, $name, 7, 12, $init, $params, $post_label, $dec);
813 //-----------------------------------------------------------------------------------
815 function textarea_cells($label, $name, $value, $cols, $rows, $title = null, $params="")
819 default_focus($name);
821 echo "<td $params>$label</td>\n";
823 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
824 echo "<td><textarea name='$name' cols='$cols' rows='$rows'"
825 .($title ? " title='$title'" : '')
826 .">$value</textarea></td>\n";
827 $Ajax->addUpdate($name, $name, $value);
830 function textarea_row($label, $name, $value, $cols, $rows, $title=null, $params="")
832 echo "<tr><td class='label'>$label</td>";
833 textarea_cells(null, $name, $value, $cols, $rows, $title, $params);
837 //-----------------------------------------------------------------------------------
839 function text_row_with_submit($label, $name, $value, $size, $max, $input_name, $input_value)
843 default_focus($name);
844 echo "<tr><td>$label</td>\n";
848 $value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
849 echo "<input type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" value=\"$value\"> ";
851 submit($input_name, $input_value);
854 $Ajax->addUpdate($name, $name, $value);
857 //-----------------------------------------------------------------------------------
859 // When show_inactive page option is set
860 // displays value of inactive field as checkbox cell.
861 // Also updates database record after status change.
863 function inactive_control_cell($id, $value, $table, $key)
867 $name = "Inactive". $id;
868 $value = $value ? 1:0;
870 if (check_value('show_inactive')) {
871 if (isset($_POST['LInact'][$id]) && (get_post('_Inactive'.$id.'_update') ||
872 get_post('Update')) && (check_value('Inactive'.$id) != $value)) {
873 update_record_status($id, !$value, $table, $key);
875 echo '<td align="center">'. checkbox(null, $name, $value, true, '', "align='center'")
876 . hidden("LInact[$id]", $value, false) . '</td>';
880 // Displays controls for optional display of inactive records
882 function inactive_control_row($th) {
883 echo "<tr><td colspan=".(count($th)).">"
884 ."<div style='float:left;'>"
885 . checkbox(null, 'show_inactive', null, true). _("Show also Inactive")
886 ."</div><div style='float:right;'>"
887 . submit('Update', _('Update'), false, '', null)
891 // Inserts additional column header when display of inactive records is on.
893 function inactive_control_column(&$th) {
896 if (check_value('show_inactive'))
897 array_insert($th, count($th)-2 , _("Inactive"));
898 if (get_post('_show_inactive_update')) {
899 $Ajax->activate('_page_body');
903 function customer_credit_row($customer, $credit, $parms='')
905 global $path_to_root;
907 label_row( _("Current Credit:"),
908 "<a target='_blank' " . ($credit<0 ? 'class="redfg"' : '')
909 ."href='$path_to_root/sales/inquiry/customer_inquiry.php?customer_id=".$customer."'"
910 ." onclick=\"javascript:openWindow(this.href,this.target); return false;\" >"
911 . price_format($credit)
915 function supplier_credit_row($supplier, $credit, $parms='')
917 global $path_to_root;
919 label_row( _("Current Credit:"),
920 "<a target='_blank' " . ($credit<0 ? 'class="redfg"' : '')
921 ."href='$path_to_root/purchasing/inquiry/supplier_inquiry.php?supplier_id=".$supplier."'"
922 ." onclick=\"javascript:openWindow(this.href,this.target); return false;\" >"
923 . price_format($credit)