1 #=====================================================================
4 # Based on SQL-Ledger Version 2.1.9
5 # Web http://www.lx-office.org
7 #=====================================================================
8 # SQL-Ledger Accounting
9 # Copyright (c) 1998-2002
11 # Author: Dieter Simader
12 # Email: dsimader@sql-ledger.org
13 # Web: http://www.sql-ledger.org
16 # This program is free software; you can redistribute it and/or modify
17 # it under the terms of the GNU General Public License as published by
18 # the Free Software Foundation; either version 2 of the License, or
19 # (at your option) any later version.
21 # This program is distributed in the hope that it will be useful,
22 # but WITHOUT ANY WARRANTY; without even the implied warranty of
23 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 # GNU General Public License for more details.
25 # You should have received a copy of the GNU General Public License
26 # along with this program; if not, write to the Free Software
27 # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
28 #======================================================================
30 # project administration
31 # partsgroup administration
33 #======================================================================
37 require "bin/mozilla/common.pl";
44 $lxdebug->enter_sub();
46 $form->{title} = "Add";
50 "$form->{script}?action=add&type=$form->{type}&path=$form->{path}&login=$form->{login}&password=$form->{password}"
51 unless $form->{callback};
53 &{"form_$form->{type}_header"};
54 &{"form_$form->{type}_footer"};
56 $lxdebug->leave_sub();
60 $lxdebug->enter_sub();
62 $form->{javascript} = qq|<script type="text/javascript" src="js/show_history.js"></script>|;
63 #/show hhistory button
64 $form->{title} = "Edit";
66 if ($form->{type} eq 'project') {
67 PE->get_project(\%myconfig, \%$form);
69 if ($form->{type} eq 'partsgroup') {
70 PE->get_partsgroup(\%myconfig, \%$form);
72 if ($form->{type} eq 'pricegroup') {
73 PE->get_pricegroup(\%myconfig, \%$form);
75 &{"form_$form->{type}_header"};
76 &{"form_$form->{type}_footer"};
78 $lxdebug->leave_sub();
82 $lxdebug->enter_sub();
84 if ($form->{type} eq 'project') {
85 $report = "project_report";
86 $sort = 'projectnumber';
87 $form->{title} = $locale->text('Projects');
91 <th align=right width=1%>| . $locale->text('Number') . qq|</th>
92 <td>| . $cgi->textfield('-name' => 'projectnumber', '-size' => 20) . qq|</td>
95 <th align=right>| . $locale->text('Description') . qq|</th>
96 <td>| . $cgi->textfield('-name' => 'description', '-size' => 60) . qq|</td>
101 $cgi->radio_group('-name' => 'active', '-default' => 'active',
102 '-values' => ['active', 'inactive', 'both'],
103 '-labels' => { 'active' => ' ' . $locale->text("Active"),
104 'inactive' => ' ' . $locale->text("Inactive"),
105 'both' => ' ' . $locale->text("Both") })
111 if ($form->{type} eq 'partsgroup') {
112 $report = "partsgroup_report";
113 $sort = 'partsgroup';
114 $form->{title} = $locale->text('Groups');
118 <th align=right width=1%>| . $locale->text('Group') . qq|</th>
119 <td><input name=partsgroup size=20></td>
126 if ($form->{type} eq 'pricegroup') {
127 $report = "pricegroup_report";
128 $sort = 'pricegroup';
129 $form->{title} = $locale->text('Pricegroup');
133 <th align=right width=1%>| . $locale->text('Pricegroup') . qq|</th>
134 <td><input name=pricegroup size=20></td>
145 <form method=post action=$form->{script}>
147 <input type=hidden name=sort value=$sort>
148 <input type=hidden name=type value=$form->{type}>
152 <th class=listtop>$form->{title}</th>
161 <td><input name=status class=radio type=radio value=all checked> |
162 . $locale->text('All') . qq|
163 <input name=status class=radio type=radio value=orphaned> |
164 . $locale->text('Orphaned') . qq|</td>
170 <td><hr size=3 noshade></td>
174 <input type=hidden name=nextsub value=$report>
176 <input type=hidden name=path value=$form->{path}>
177 <input type=hidden name=login value=$form->{login}>
178 <input type=hidden name=password value=$form->{password}>
181 <input class=submit type=submit name=action value="|
182 . $locale->text('Continue') . qq|">
189 $lxdebug->leave_sub();
193 $lxdebug->enter_sub();
195 map { $form->{$_} = $form->unescape($form->{$_}) }
196 (projectnumber, description);
197 PE->projects(\%myconfig, \%$form);
200 "$form->{script}?action=project_report&type=$form->{type}&path=$form->{path}&login=$form->{login}&password=$form->{password}&status=$form->{status}&active=" .
204 if ($form->{status} eq 'all') {
205 $option = $locale->text('All');
207 if ($form->{status} eq 'orphaned') {
208 $option .= $locale->text('Orphaned');
210 if ($form->{projectnumber}) {
211 $href .= "&projectnumber=" . $form->escape($form->{projectnumber});
212 $callback .= "&projectnumber=$form->{projectnumber}";
214 "\n<br>" . $locale->text('Project') . " : $form->{projectnumber}";
216 if ($form->{description}) {
217 $href .= "&description=" . $form->escape($form->{description});
218 $callback .= "&description=$form->{description}";
220 "\n<br>" . $locale->text('Description') . " : $form->{description}";
223 @column_index = qw(projectnumber description);
225 push(@column_index, "active") if ("both" eq $form->{active});
227 $column_header{projectnumber} =
228 qq|<th><a class=listheading href=$href&sort=projectnumber>|
229 . $locale->text('Number')
231 $column_header{description} =
232 qq|<th><a class=listheading href=$href&sort=description>|
233 . $locale->text('Description')
235 $column_header{active} =
236 qq|<th class="listheading">| . $locale->text('Active') . qq|</th>|;
238 $form->{title} = $locale->text('Projects');
247 <th class=listtop>$form->{title}</th>
256 <tr class=listheading>
259 map { print "$column_header{$_}\n" } @column_index;
266 $form->{callback} = $callback .= "&sort=$form->{sort}";
268 # escape callback for href
269 $callback = $form->escape($callback);
271 foreach $ref (@{ $form->{project_list} }) {
277 <tr valign=top class=listrow$i>
280 $column_data{projectnumber} =
281 qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{projectnumber}</td>|;
282 $column_data{description} = qq|<td>$ref->{description} </td>|;
283 $column_data{active} =
285 ($ref->{active} ? $locale->text("Yes") : $locale->text("No")) .
288 map { print "$column_data{$_}\n" } @column_index;
300 <td><hr size=3 noshade></td>
305 <form method=post action=$form->{script}>
307 <input name=callback type=hidden value="$form->{callback}">
309 <input type=hidden name=type value=$form->{type}>
311 <input type=hidden name=path value=$form->{path}>
312 <input type=hidden name=login value=$form->{login}>
313 <input type=hidden name=password value=$form->{password}>
315 <input class=submit type=submit name=action value="|
316 . $locale->text('Add') . qq|">
324 $lxdebug->leave_sub();
327 sub form_project_header {
328 $lxdebug->enter_sub();
330 $form->{title} = $locale->text("$form->{title} Project");
332 # $locale->text('Add Project')
333 # $locale->text('Edit Project')
335 $form->{description} =~ s/\"/"/g;
338 $cgi->textfield('-name' => 'projectnumber', '-size' => 20,
339 '-default' => $form->{projectnumber});
342 if (($rows = $form->numtextrows($form->{description}, 60)) > 1) {
344 $cgi->textarea('-name' => 'description', '-rows' => $rows, '-cols' => 60,
345 '-style' => 'width: 100%', '-wrap' => 'soft',
346 '-default' => $form->{description});
349 $cgi->textfield('-name' => 'description', '-size' => 60,
350 '-default' => $form->{description});
360 $cgi->radio_group('-name' => 'active',
362 '-default' => $form->{active} * 1,
363 '-labels' => { 1 => $locale->text("Active"),
364 0 => $locale->text("Inactive") })
375 <form method=post action=$form->{script}>
377 <input type=hidden name=id value=$form->{id}>
378 <input type=hidden name=type value=project>
382 <th class=listtop>$form->{title}</th>
389 <th align=right>| . $locale->text('Number') . qq|</th>
390 <td>$projectnumber</td>
393 <th align=right>| . $locale->text('Description') . qq|</th>
394 <td>$description</td>
401 <td colspan=2><hr size=3 noshade></td>
406 $lxdebug->leave_sub();
409 sub form_project_footer {
410 $lxdebug->enter_sub();
414 <input name=callback type=hidden value="$form->{callback}">
416 <input type=hidden name=path value=$form->{path}>
417 <input type=hidden name=login value=$form->{login}>
418 <input type=hidden name=password value=$form->{password}>
420 <br><input type=submit class=submit name=action value="|
421 . $locale->text('Save') . qq|">
424 if ($form->{id} && $form->{orphaned}) {
426 <input type=submit class=submit name=action value="|
427 . $locale->text('Delete') . qq|">|;
431 if ($form->{menubar}) {
432 require "$form->{path}/menu.pl";
435 # button for saving history
437 <input type=button onclick=set_history_window(|
439 . qq|); name=history id=history value=|
440 . $locale->text('history')
442 # /button for saving history
452 $lxdebug->leave_sub();
456 $lxdebug->enter_sub();
458 if ($form->{type} eq 'project') {
459 $form->isblank("projectnumber", $locale->text('Project Number missing!'));
460 PE->save_project(\%myconfig, \%$form);
461 $form->redirect($locale->text('Project saved!'));
463 if ($form->{type} eq 'partsgroup') {
464 $form->isblank("partsgroup", $locale->text('Group missing!'));
465 PE->save_partsgroup(\%myconfig, \%$form);
466 $form->redirect($locale->text('Group saved!'));
469 # choice pricegroup and save
470 if ($form->{type} eq 'pricegroup') {
471 $form->isblank("pricegroup", $locale->text('Pricegroup missing!'));
472 PE->save_pricegroup(\%myconfig, \%$form);
473 $form->redirect($locale->text('Pricegroup saved!'));
476 if(!exists $form->{addition} && $form->{id} ne "") {
477 $form->{addition} = "SAVED";
478 $form->save_history($form->dbconnect(\%myconfig));
480 # /saving the history
482 $lxdebug->leave_sub();
486 $lxdebug->enter_sub();
488 PE->delete_tuple(\%myconfig, \%$form);
490 if ($form->{type} eq 'project') {
491 $form->redirect($locale->text('Project deleted!'));
493 if ($form->{type} eq 'partsgroup') {
494 $form->redirect($locale->text('Group deleted!'));
496 if ($form->{type} eq 'pricegroup') {
497 $form->redirect($locale->text('Pricegroup deleted!'));
500 if(!exists $form->{addition}) {
501 $form->{addition} = "DELETED";
502 $form->save_history($form->dbconnect(\%myconfig));
504 # /saving the history
505 $lxdebug->leave_sub();
508 sub continue { &{ $form->{nextsub} } }
510 sub partsgroup_report {
511 $lxdebug->enter_sub();
513 map { $form->{$_} = $form->unescape($form->{$_}) } (partsgroup);
514 PE->partsgroups(\%myconfig, \%$form);
517 "$form->{script}?action=partsgroup_report&type=$form->{type}&path=$form->{path}&login=$form->{login}&password=$form->{password}&status=$form->{status}";
519 if ($form->{status} eq 'all') {
520 $option = $locale->text('All');
522 if ($form->{status} eq 'orphaned') {
523 $option .= $locale->text('Orphaned');
525 if ($form->{partsgroup}) {
526 $callback .= "&partsgroup=$form->{partsgroup}";
527 $option .= "\n<br>" . $locale->text('Group') . " : $form->{partsgroup}";
530 @column_index = $form->sort_columns(qw(partsgroup));
532 $column_header{partsgroup} =
533 qq|<th class=listheading width=90%>| . $locale->text('Group') . qq|</th>|;
535 $form->{title} = $locale->text('Groups');
544 <th class=listtop>$form->{title}</th>
553 <tr class=listheading>
556 map { print "$column_header{$_}\n" } @column_index;
563 $form->{callback} = $callback;
565 # escape callback for href
566 $callback = $form->escape($callback);
568 foreach $ref (@{ $form->{item_list} }) {
574 <tr valign=top class=listrow$i>
577 $column_data{partsgroup} =
578 qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{partsgroup}</td>|;
579 map { print "$column_data{$_}\n" } @column_index;
591 <td><hr size=3 noshade></td>
596 <form method=post action=$form->{script}>
598 <input name=callback type=hidden value="$form->{callback}">
600 <input type=hidden name=type value=$form->{type}>
602 <input type=hidden name=path value=$form->{path}>
603 <input type=hidden name=login value=$form->{login}>
604 <input type=hidden name=password value=$form->{password}>
606 <input class=submit type=submit name=action value="|
607 . $locale->text('Add') . qq|">
615 $lxdebug->leave_sub();
618 sub form_partsgroup_header {
619 $lxdebug->enter_sub();
621 $form->{title} = $locale->text("$form->{title} Group");
623 # $locale->text('Add Group')
624 # $locale->text('Edit Group')
626 $form->{partsgroup} =~ s/\"/"/g;
633 <form method=post action=$form->{script}>
635 <input type=hidden name=id value=$form->{id}>
636 <input type=hidden name=type value=$form->{type}>
640 <th class=listtop>$form->{title}</th>
647 <th align=right>| . $locale->text('Group') . qq|</th>
649 <td><input name=partsgroup size=30 value="$form->{partsgroup}"></td>
655 <td colspan=2><hr size=3 noshade></td>
660 $lxdebug->leave_sub();
663 sub form_partsgroup_footer {
664 $lxdebug->enter_sub();
668 <input name=callback type=hidden value="$form->{callback}">
670 <input type=hidden name=path value=$form->{path}>
671 <input type=hidden name=login value=$form->{login}>
672 <input type=hidden name=password value=$form->{password}>
674 <br><input type=submit class=submit name=action value="|
675 . $locale->text('Save') . qq|">
678 if ($form->{id} && $form->{orphaned}) {
680 <input type=submit class=submit name=action value="|
681 . $locale->text('Delete') . qq|">|;
685 if ($form->{menubar}) {
686 require "$form->{path}/menu.pl";
689 # button for saving history
691 <input type=button onclick=set_history_window(|
693 . qq|); name=history id=history value=|
694 . $locale->text('history')
696 # /button for saving history
706 $lxdebug->leave_sub();
709 #################################
710 # get pricesgroups and build up html-code
712 sub pricegroup_report {
713 $lxdebug->enter_sub();
715 map { $form->{$_} = $form->unescape($form->{$_}) } (pricegroup);
716 PE->pricegroups(\%myconfig, \%$form);
719 "$form->{script}?action=pricegroup_report&type=$form->{type}&path=$form->{path}&login=$form->{login}&password=$form->{password}&status=$form->{status}";
721 if ($form->{status} eq 'all') {
722 $option = $locale->text('All');
724 if ($form->{status} eq 'orphaned') {
725 $option .= $locale->text('Orphaned');
727 if ($form->{pricegroup}) {
728 $callback .= "&pricegroup=$form->{pricegroup}";
730 "\n<br>" . $locale->text('Pricegroup') . " : $form->{pricegroup}";
733 @column_index = $form->sort_columns(qw(pricegroup));
735 $column_header{pricegroup} =
736 qq|<th class=listheading width=90%>|
737 . $locale->text('Pricegroup')
740 $form->{title} = $locale->text('Pricegroup');
749 <th class=listtop>$form->{title}</th>
758 <tr class=listheading>
761 map { print "$column_header{$_}\n" } @column_index;
768 $form->{callback} = $callback;
770 # escape callback for href
771 $callback = $form->escape($callback);
773 foreach $ref (@{ $form->{item_list} }) {
779 <tr valign=top class=listrow$i>
781 $column_data{pricegroup} =
782 qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{pricegroup}</td>|;
784 map { print "$column_data{$_}\n" } @column_index;
796 <td><hr size=3 noshade></td>
801 <form method=post action=$form->{script}>
803 <input name=callback type=hidden value="$form->{callback}">
805 <input type=hidden name=type value=$form->{type}>
807 <input type=hidden name=path value=$form->{path}>
808 <input type=hidden name=login value=$form->{login}>
809 <input type=hidden name=password value=$form->{password}>
811 <input class=submit type=submit name=action value="|
812 . $locale->text('Add') . qq|">
820 $lxdebug->leave_sub();
823 #######################
824 #build up pricegroup_header
826 sub form_pricegroup_header {
827 $lxdebug->enter_sub();
829 # $locale->text('Add Pricegroup')
830 # $locale->text('Edit Pricegroup')
832 $form->{title} = $locale->text("$form->{title} Pricegroup");
834 $form->{pricegroup} =~ s/\"/"/g;
841 <form method=post action=$form->{script}>
843 <input type=hidden name=id value=$form->{id}>
844 <input type=hidden name=type value=$form->{type}>
848 <th class=listtop>$form->{title}</th>
855 <th align=right>| . $locale->text('Preisgruppe') . qq|</th>
856 <td><input name=pricegroup size=30 value="$form->{pricegroup}"></td>
862 <td colspan=2><hr size=3 noshade></td>
867 $lxdebug->leave_sub();
869 ######################
870 #build up pricegroup_footer
872 sub form_pricegroup_footer {
873 $lxdebug->enter_sub();
877 <input name=callback type=hidden value="$form->{callback}">
879 <input type=hidden name=path value=$form->{path}>
880 <input type=hidden name=login value=$form->{login}>
881 <input type=hidden name=password value=$form->{password}>
883 <br><input type=submit class=submit name=action value="|
884 . $locale->text('Save') . qq|">
887 if ($form->{id} && $form->{orphaned}) {
889 <input type=submit class=submit name=action value="|
890 . $locale->text('Delete') . qq|">|;
894 if ($form->{menubar}) {
895 require "$form->{path}/menu.pl";
898 # button for saving history
900 <input type=button onclick=set_history_window(|
902 . qq|); name=history id=history value=|
903 . $locale->text('history')
905 # /button for saving history
915 $lxdebug->leave_sub();