Projekt

Allgemein

Profil

Herunterladen (13,6 KB) Statistiken
| Zweig: | Markierung: | Revision:
d319704a Moritz Bunkus
#=====================================================================
# LX-Office ERP
# Copyright (C) 2004
# Based on SQL-Ledger Version 2.1.9
# Web http://www.lx-office.org
#
#=====================================================================
# SQL-Ledger Accounting
# Copyright (c) 1998-2002
#
# Author: Dieter Simader
# Email: dsimader@sql-ledger.org
# Web: http://www.sql-ledger.org
#
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#======================================================================
#
08844064 Moritz Bunkus
# partsgroup, pricegroup administration
d319704a Moritz Bunkus
#
#======================================================================

use SL::PE;

59f8f1fa Moritz Bunkus
require "bin/mozilla/common.pl";

8fd85060 Sven Schöling
use strict;

d319704a Moritz Bunkus
1;

# end of main

sub add {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
d319704a Moritz Bunkus
8fd85060 Sven Schöling
my $form = $main::form;
8c7e4493 Moritz Bunkus
d319704a Moritz Bunkus
$form->{title} = "Add";

# construct callback
$form->{callback} =
5b22b6b5 Moritz Bunkus
"$form->{script}?action=add&type=$form->{type}"
d319704a Moritz Bunkus
unless $form->{callback};

40782548 Moritz Bunkus
call_sub("form_$form->{type}_header");
call_sub("form_$form->{type}_footer");
d319704a Moritz Bunkus
8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

sub edit {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();
8c7e4493 Moritz Bunkus
8fd85060 Sven Schöling
$main::auth->assert('config');

my $form = $main::form;
my %myconfig = %main::myconfig;
8c7e4493 Moritz Bunkus
2b89ec97 Thomas Kasulke
# show history button
$form->{javascript} = qq|<script type="text/javascript" src="js/show_history.js"></script>|;
#/show hhistory button
d319704a Moritz Bunkus
$form->{title} = "Edit";

if ($form->{type} eq 'partsgroup') {
PE->get_partsgroup(\%myconfig, \%$form);
}
195883fd Stephan Köhler
if ($form->{type} eq 'pricegroup') {
PE->get_pricegroup(\%myconfig, \%$form);
}
40782548 Moritz Bunkus
call_sub("form_$form->{type}_header");
call_sub("form_$form->{type}_footer");
d319704a Moritz Bunkus
8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

sub search {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
d319704a Moritz Bunkus
8fd85060 Sven Schöling
my $form = $main::form;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
8fd85060 Sven Schöling
my ($report, $sort, $number);
d319704a Moritz Bunkus
if ($form->{type} eq 'partsgroup') {
$report = "partsgroup_report";
$sort = 'partsgroup';
$form->{title} = $locale->text('Groups');

$number = qq|
b65a230d Sven Schöling
<tr>
<th align=right width=1%>| . $locale->text('Group') . qq|</th>
<td><input name=partsgroup size=20></td>
</tr>
d319704a Moritz Bunkus
|;

}

195883fd Stephan Köhler
# for pricesgroups
if ($form->{type} eq 'pricegroup') {
$report = "pricegroup_report";
$sort = 'pricegroup';
$form->{title} = $locale->text('Pricegroup');

$number = qq|
b65a230d Sven Schöling
<tr>
<th align=right width=1%>| . $locale->text('Pricegroup') . qq|</th>
<td><input name=pricegroup size=20></td>
</tr>
195883fd Stephan Köhler
|;

}

d319704a Moritz Bunkus
$form->header;

print qq|
<body>

<form method=post action=$form->{script}>

<input type=hidden name=sort value=$sort>
<input type=hidden name=type value=$form->{type}>

<table width=100%>
<tr>
<th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
<td>
<table width=100%>
$number
b65a230d Sven Schöling
<tr>
<td></td>
<td><input name=status class=radio type=radio value=all checked>&nbsp;| . $locale->text('All') . qq|
<input name=status class=radio type=radio value=orphaned>&nbsp;| . $locale->text('Orphaned') . qq|</td>
</tr>
d319704a Moritz Bunkus
</table>
</td>
</tr>
<tr>
<td><hr size=3 noshade></td>
</tr>
</table>

<input type=hidden name=nextsub value=$report>

<br>
<input class=submit type=submit name=action value="|
. $locale->text('Continue') . qq|">
</form>

</body>
</html>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

sub save {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();
d319704a Moritz Bunkus
8fd85060 Sven Schöling
$main::auth->assert('config');

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
d319704a Moritz Bunkus
if ($form->{type} eq 'partsgroup') {
$form->isblank("partsgroup", $locale->text('Group missing!'));
PE->save_partsgroup(\%myconfig, \%$form);
$form->redirect($locale->text('Group saved!'));
}

195883fd Stephan Köhler
# choice pricegroup and save
if ($form->{type} eq 'pricegroup') {
$form->isblank("pricegroup", $locale->text('Pricegroup missing!'));
PE->save_pricegroup(\%myconfig, \%$form);
$form->redirect($locale->text('Pricegroup saved!'));
}
2b89ec97 Thomas Kasulke
# saving the history
if(!exists $form->{addition} && $form->{id} ne "") {
8cef58b2 Thomas Kasulke
$form->{snumbers} = qq|projectnumber_| . $form->{projectnumber};
b65a230d Sven Schöling
$form->{addition} = "SAVED";
a590a651 Sven Schöling
$form->save_history;
2b89ec97 Thomas Kasulke
}
8fd85060 Sven Schöling
# /saving the history
195883fd Stephan Köhler
8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

sub delete {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();
d319704a Moritz Bunkus
8fd85060 Sven Schöling
$main::auth->assert('config');

my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
d319704a Moritz Bunkus
PE->delete_tuple(\%myconfig, \%$form);

if ($form->{type} eq 'partsgroup') {
$form->redirect($locale->text('Group deleted!'));
}
195883fd Stephan Köhler
if ($form->{type} eq 'pricegroup') {
$form->redirect($locale->text('Pricegroup deleted!'));
}
2b89ec97 Thomas Kasulke
# saving the history
if(!exists $form->{addition}) {
8cef58b2 Thomas Kasulke
$form->{snumbers} = qq|projectnumber_| . $form->{projectnumber};
b65a230d Sven Schöling
$form->{addition} = "DELETED";
a590a651 Sven Schöling
$form->save_history;
2b89ec97 Thomas Kasulke
}
# /saving the history
8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

8fd85060 Sven Schöling
sub continue { call_sub($main::form->{"nextsub"}); }
d319704a Moritz Bunkus
sub partsgroup_report {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
d319704a Moritz Bunkus
8fd85060 Sven Schöling
my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
8fd85060 Sven Schöling
map { $form->{$_} = $form->unescape($form->{$_}) } qw(partsgroup);
d319704a Moritz Bunkus
PE->partsgroups(\%myconfig, \%$form);

8fd85060 Sven Schöling
my $callback =
5b22b6b5 Moritz Bunkus
"$form->{script}?action=partsgroup_report&type=$form->{type}&status=$form->{status}";
d319704a Moritz Bunkus
8fd85060 Sven Schöling
my ($option);
d319704a Moritz Bunkus
if ($form->{status} eq 'all') {
$option = $locale->text('All');
}
if ($form->{status} eq 'orphaned') {
$option .= $locale->text('Orphaned');
}
if ($form->{partsgroup}) {
$callback .= "&partsgroup=$form->{partsgroup}";
$option .= "\n<br>" . $locale->text('Group') . " : $form->{partsgroup}";
}

8fd85060 Sven Schöling
my @column_index = $form->sort_columns(qw(partsgroup));
my %column_header;
d319704a Moritz Bunkus
$column_header{partsgroup} =
qq|<th class=listheading width=90%>| . $locale->text('Group') . qq|</th>|;

$form->{title} = $locale->text('Groups');

$form->header;

print qq|
<body>

<table width=100%>
<tr>
<th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
<td>$option</td>
</tr>
<tr>
<td>
<table width=100%>
b65a230d Sven Schöling
<tr class=listheading>
d319704a Moritz Bunkus
|;

map { print "$column_header{$_}\n" } @column_index;

print qq|
</tr>
|;

# escape callback
$form->{callback} = $callback;

# escape callback for href
$callback = $form->escape($callback);

8fd85060 Sven Schöling
my ($i, %column_data);
foreach my $ref (@{ $form->{item_list} }) {
d319704a Moritz Bunkus
$i++;
$i %= 2;

print qq|
<tr valign=top class=listrow$i>
|;

$column_data{partsgroup} =
5b22b6b5 Moritz Bunkus
qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&callback=$callback>$ref->{partsgroup}</td>|;
d319704a Moritz Bunkus
map { print "$column_data{$_}\n" } @column_index;

print "
</tr>
";
}

print qq|
</table>
</td>
</tr>
<tr>
<td><hr size=3 noshade></td>
</tr>
</table>

<br>
<form method=post action=$form->{script}>

<input name=callback type=hidden value="$form->{callback}">

<input type=hidden name=type value=$form->{type}>

<input class=submit type=submit name=action value="|
8ec0d29a Moritz Bunkus
. $locale->text('Add') . qq|">
d319704a Moritz Bunkus
</form>

</body>
</html>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

sub form_partsgroup_header {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
d319704a Moritz Bunkus
8fd85060 Sven Schöling
my $form = $main::form;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
45d0d9de Stephan Köhler
$form->{title} = $locale->text("$form->{title} Group");
d319704a Moritz Bunkus
# $locale->text('Add Group')
# $locale->text('Edit Group')

$form->{partsgroup} =~ s/\"/&quot;/g;

$form->header;

print qq|
<body>

<form method=post action=$form->{script}>

<input type=hidden name=id value=$form->{id}>
<input type=hidden name=type value=$form->{type}>

<table width=100%>
<tr>
<th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
<td>
<table width=100%>
b65a230d Sven Schöling
<tr>
<th align=right>| . $locale->text('Group') . qq|</th>
d319704a Moritz Bunkus
<td><input name=partsgroup size=30 value="$form->{partsgroup}"></td>
b65a230d Sven Schöling
</tr>
d319704a Moritz Bunkus
</table>
</td>
</tr>
<tr>
<td colspan=2><hr size=3 noshade></td>
</tr>
</table>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}

sub form_partsgroup_footer {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();
d319704a Moritz Bunkus
8fd85060 Sven Schöling
$main::auth->assert('config');

my $form = $main::form;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
d319704a Moritz Bunkus
print qq|

<input name=callback type=hidden value="$form->{callback}">

<br><input type=submit class=submit name=action value="|
. $locale->text('Save') . qq|">
|;

if ($form->{id} && $form->{orphaned}) {
print qq|
<input type=submit class=submit name=action value="|
. $locale->text('Delete') . qq|">|;
}

2b89ec97 Thomas Kasulke
# button for saving history
print qq|
b65a230d Sven Schöling
<input type=button onclick=set_history_window(|
. $form->{id}
. qq|); name=history id=history value=|
. $locale->text('history')
. qq|>|;
2b89ec97 Thomas Kasulke
# /button for saving history
d319704a Moritz Bunkus
print qq|
</form>

</body>
</html>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
d319704a Moritz Bunkus
}
195883fd Stephan Köhler
#################################
# get pricesgroups and build up html-code
#
sub pricegroup_report {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
195883fd Stephan Köhler
8fd85060 Sven Schöling
my $form = $main::form;
my %myconfig = %main::myconfig;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
8fd85060 Sven Schöling
map { $form->{$_} = $form->unescape($form->{$_}) } qw(pricegroup);
195883fd Stephan Köhler
PE->pricegroups(\%myconfig, \%$form);

8fd85060 Sven Schöling
my $callback =
5b22b6b5 Moritz Bunkus
"$form->{script}?action=pricegroup_report&type=$form->{type}&status=$form->{status}";
195883fd Stephan Köhler
8fd85060 Sven Schöling
my $option;
195883fd Stephan Köhler
if ($form->{status} eq 'all') {
$option = $locale->text('All');
}
if ($form->{status} eq 'orphaned') {
$option .= $locale->text('Orphaned');
}
if ($form->{pricegroup}) {
$callback .= "&pricegroup=$form->{pricegroup}";
$option .=
"\n<br>" . $locale->text('Pricegroup') . " : $form->{pricegroup}";
}

8fd85060 Sven Schöling
my @column_index = $form->sort_columns(qw(pricegroup));
my %column_header;
195883fd Stephan Köhler
$column_header{pricegroup} =
qq|<th class=listheading width=90%>|
. $locale->text('Pricegroup')
. qq|</th>|;

$form->{title} = $locale->text('Pricegroup');

$form->header;

print qq|
<body>

<table width=100%>
<tr>
<th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
<td>$option</td>
</tr>
<tr>
<td>
<table width=100%>
b65a230d Sven Schöling
<tr class=listheading>
195883fd Stephan Köhler
|;

map { print "$column_header{$_}\n" } @column_index;

print qq|
</tr>
|;

# escape callback
$form->{callback} = $callback;

# escape callback for href
$callback = $form->escape($callback);

8fd85060 Sven Schöling
my ($i, %column_data);
foreach my $ref (@{ $form->{item_list} }) {
195883fd Stephan Köhler
$i++;
$i %= 2;

print qq|
<tr valign=top class=listrow$i>
|;
$column_data{pricegroup} =
5b22b6b5 Moritz Bunkus
qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&callback=$callback>$ref->{pricegroup}</td>|;
195883fd Stephan Köhler
map { print "$column_data{$_}\n" } @column_index;

print "
</tr>
";
}

print qq|
</table>
</td>
</tr>
<tr>
<td><hr size=3 noshade></td>
</tr>
</table>

<br>
<form method=post action=$form->{script}>

<input name=callback type=hidden value="$form->{callback}">

<input type=hidden name=type value=$form->{type}>

<input class=submit type=submit name=action value="|
8ec0d29a Moritz Bunkus
. $locale->text('Add') . qq|">
195883fd Stephan Köhler
</form>

</body>
</html>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
195883fd Stephan Köhler
}

#######################
#build up pricegroup_header
#
sub form_pricegroup_header {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
195883fd Stephan Köhler
8fd85060 Sven Schöling
my $form = $main::form;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
45d0d9de Stephan Köhler
# $locale->text('Add Pricegroup')
# $locale->text('Edit Pricegroup')

$form->{title} = $locale->text("$form->{title} Pricegroup");
195883fd Stephan Köhler
$form->{pricegroup} =~ s/\"/&quot;/g;

$form->header;

print qq|
<body>

<form method=post action=$form->{script}>

<input type=hidden name=id value=$form->{id}>
<input type=hidden name=type value=$form->{type}>

<table width=100%>
<tr>
<th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
<td>
<table width=100%>
b65a230d Sven Schöling
<tr>
<th align=right>| . $locale->text('Preisgruppe') . qq|</th>
195883fd Stephan Köhler
<td><input name=pricegroup size=30 value="$form->{pricegroup}"></td>
b65a230d Sven Schöling
</tr>
195883fd Stephan Köhler
</table>
</td>
</tr>
<tr>
<td colspan=2><hr size=3 noshade></td>
</tr>
</table>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
195883fd Stephan Köhler
}
######################
#build up pricegroup_footer
#
sub form_pricegroup_footer {
8fd85060 Sven Schöling
$main::lxdebug->enter_sub();

$main::auth->assert('config');
195883fd Stephan Köhler
8fd85060 Sven Schöling
my $form = $main::form;
my $locale = $main::locale;
8c7e4493 Moritz Bunkus
195883fd Stephan Köhler
print qq|

<input name=callback type=hidden value="$form->{callback}">

<br><input type=submit class=submit name=action value="|
. $locale->text('Save') . qq|">
|;

if ($form->{id} && $form->{orphaned}) {
print qq|
<input type=submit class=submit name=action value="|
. $locale->text('Delete') . qq|">|;
}

2b89ec97 Thomas Kasulke
# button for saving history
print qq|
b65a230d Sven Schöling
<input type=button onclick=set_history_window(|
. $form->{id}
. qq|); name=history id=history value=|
. $locale->text('history')
. qq|>|;
2b89ec97 Thomas Kasulke
# /button for saving history
195883fd Stephan Köhler
print qq|
</form>

</body>
</html>
|;

8fd85060 Sven Schöling
$main::lxdebug->leave_sub();
195883fd Stephan Köhler
}