|
#=====================================================================
|
|
# LX-Office ERP
|
|
# Copyright (C) 2004
|
|
# Based on SQL-Ledger Version 2.1.9
|
|
# Web http://www.lx-office.org
|
|
#############################################################################
|
|
# Veraendert 2005-01-05 - Marco Welter <mawe@linux-studio.de> - Neue Optik #
|
|
#############################################################################
|
|
# 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.
|
|
#
|
|
#######################################################################
|
|
#
|
|
# common routines used in is, ir but not in oe
|
|
#
|
|
#######################################################################
|
|
|
|
use CGI;
|
|
use CGI::Ajax;
|
|
use List::Util qw(max);
|
|
|
|
use SL::Common;
|
|
use SL::CT;
|
|
use SL::IC;
|
|
|
|
require "bin/mozilla/common.pl";
|
|
|
|
use strict;
|
|
|
|
# any custom scripts for this one
|
|
if (-f "bin/mozilla/custom_invoice_io.pl") {
|
|
eval { require "bin/mozilla/custom_ivvoice_io.pl"; };
|
|
}
|
|
if (-f "bin/mozilla/$main::form->{login}_invoice_io.pl") {
|
|
eval { require "bin/mozilla/$main::form->{login}_invoice_io.pl"; };
|
|
}
|
|
|
|
1;
|
|
|
|
# end of main
|
|
|
|
# this is for our long dates
|
|
# $locale->text('January')
|
|
# $locale->text('February')
|
|
# $locale->text('March')
|
|
# $locale->text('April')
|
|
# $locale->text('May ')
|
|
# $locale->text('June')
|
|
# $locale->text('July')
|
|
# $locale->text('August')
|
|
# $locale->text('September')
|
|
# $locale->text('October')
|
|
# $locale->text('November')
|
|
# $locale->text('December')
|
|
|
|
# this is for our short month
|
|
# $locale->text('Jan')
|
|
# $locale->text('Feb')
|
|
# $locale->text('Mar')
|
|
# $locale->text('Apr')
|
|
# $locale->text('May')
|
|
# $locale->text('Jun')
|
|
# $locale->text('Jul')
|
|
# $locale->text('Aug')
|
|
# $locale->text('Sep')
|
|
# $locale->text('Oct')
|
|
# $locale->text('Nov')
|
|
# $locale->text('Dec')
|
|
use SL::IS;
|
|
use SL::PE;
|
|
use SL::AM;
|
|
use Data::Dumper;
|
|
########################################
|
|
# Eintrag fuer Version 2.2.0 geaendert #
|
|
# neue Optik im Rechnungsformular #
|
|
########################################
|
|
#sub display_row {
|
|
# $main::lxdebug->enter_sub();
|
|
# my $numrows = shift;
|
|
#
|
|
# my $is_sales =
|
|
# (substr($form->{type}, 0, 6) eq "sales_")
|
|
# || (($form->{type} eq "invoice") && ($form->{script} eq "is.pl"))
|
|
# || ($form->{type} eq 'credit_note');
|
|
#
|
|
# if ($lizenzen && $form->{vc} eq "customer") {
|
|
# if ($form->{type} =~ /sales_order/) {
|
|
# @column_index = (runningnumber, partnumber, description, ship, qty);
|
|
# } elsif ($form->{type} =~ /sales_quotation/) {
|
|
# @column_index = (runningnumber, partnumber, description, qty);
|
|
# } else {
|
|
# @column_index = (runningnumber, partnumber, description, qty);
|
|
# }
|
|
# } else {
|
|
# if ( ($form->{type} =~ /purchase_order/)
|
|
# || ($form->{type} =~ /sales_order/)) {
|
|
# @column_index = (runningnumber, partnumber, description, ship, qty);
|
|
# } else {
|
|
# @column_index = (runningnumber, partnumber, description, qty);
|
|
# }
|
|
# }
|
|
############### ENDE Neueintrag ##################
|
|
#
|
|
# my $all_units = AM->retrieve_units(\%myconfig, $form);
|
|
# my $dimension_units = $all_units;
|
|
# my $service_units = $all_units;
|
|
#
|
|
# my %price_factors = map { $_->{id} => $_->{factor} } @{ $form->{ALL_PRICE_FACTORS} };
|
|
#
|
|
# push @column_index, qw(unit);
|
|
#
|
|
# #for pricegroups column
|
|
# if ( $form->{type} =~ (/sales_quotation/)
|
|
# or (($form->{level} =~ /Sales/) and ($form->{type} =~ /invoice/))
|
|
# or (($form->{level} eq undef) and ($form->{type} =~ /invoice/))
|
|
# or ($form->{type} =~ /sales_order/)) {
|
|
# push @column_index, qw(sellprice_pg);
|
|
# }
|
|
#
|
|
# push @column_index, qw(sellprice);
|
|
#
|
|
# if ($form->{vc} eq 'customer') {
|
|
# push @column_index, qw(discount);
|
|
# }
|
|
#
|
|
# push @column_index, "linetotal";
|
|
#
|
|
# my $colspan = $#column_index + 1;
|
|
#
|
|
# $form->{invsubtotal} = 0;
|
|
# map { $form->{"${_}_base"} = 0 } (split(/ /, $form->{taxaccounts}));
|
|
#
|
|
#########################################
|
|
# # Eintrag fuer Version 2.2.0 geaendert #
|
|
# # neue Optik im Rechnungsformular #
|
|
#########################################
|
|
# $column_data{runningnumber} = qq|<th align="left" nowrap width="5%" class="listheading">| . $locale->text('No.') . qq|</th>|;
|
|
# $column_data{partnumber} = qq|<th align="left" nowrap width="12%" class="listheading">| . $locale->text('Number') . qq|</th>|;
|
|
# $column_data{description} = qq|<th align="left" nowrap width="30%" class="listheading">| . $locale->text('Part Description') . qq|</th>|;
|
|
# if ($form->{"type"} eq "purchase_order") {
|
|
# $column_data{ship} = qq|<th align="left" nowrap width="5%" class="listheading">| . $locale->text('Ship rcvd') . qq|</th>|;
|
|
# } else {
|
|
# $column_data{ship} = qq|<th align="left" nowrap width="5%" class="listheading">| . $locale->text('Ship') . qq|</th>|;
|
|
# }
|
|
# $column_data{qty} = qq|<th align="left" nowrap width="5%" class="listheading">| . $locale->text('Qty') . qq|</th>|;
|
|
# $column_data{unit} = qq|<th align="left" nowrap width="20%" class="listheading">| . $locale->text('Unit') . qq|</th>|;
|
|
# $column_data{license} = qq|<th align="left" nowrap width="10%" class="listheading">| . $locale->text('License') . qq|</th>|;
|
|
# $column_data{serialnr} = qq|<th align="left" nowrap width="10%" class="listheading">| . $locale->text('Serial No.') . qq|</th>|;
|
|
# $column_data{projectnr} = qq|<th align="left" nowrap width="10%" class="listheading">| . $locale->text('Project') . qq|</th>|;
|
|
# $column_data{sellprice} = qq|<th align="left" nowrap width="15%" class="listheading">| . $locale->text('Price') . qq|</th>|;
|
|
# $column_data{sellprice_pg} = qq|<th align="left" nowrap width="15%" class="listheading">| . $locale->text('Pricegroup') . qq|</th>|;
|
|
# $column_data{discount} = qq|<th align="left" nowrap width="5%" class="listheading">| . $locale->text('Discount') . qq|</th>|;
|
|
# $column_data{linetotal} = qq|<th align="left" nowrap width="10%" class="listheading">| . $locale->text('Extended') . qq|</th>|;
|
|
# $column_data{bin} = qq|<th align="left" nowrap width="10%" class="listheading">| . $locale->text('Bin') . qq|</th>|;
|
|
############### ENDE Neueintrag ##################
|
|
#
|
|
# $myconfig{"show_form_details"} = 1
|
|
# unless (defined($myconfig{"show_form_details"}));
|
|
# $form->{"show_details"} = $myconfig{"show_form_details"}
|
|
# unless (defined($form->{"show_details"}));
|
|
# $form->{"show_details"} = $form->{"show_details"} ? 1 : 0;
|
|
# my $show_details_new = 1 - $form->{"show_details"};
|
|
# my $show_details_checked = $form->{"show_details"} ? "checked" : "";
|
|
#
|
|
# print qq|
|
|
# <tr>
|
|
# <td>| . $cgi->hidden("-name" => "show_details", "-value" => $form->{show_details}) . qq|
|
|
# <input type="checkbox" id="cb_show_details" onclick="show_form_details($show_details_new);" $show_details_checked>
|
|
# <label for="cb_show_details">| . $locale->text("Show details") . qq|</label><br>
|
|
# <table width="100%">
|
|
# <tr class="listheading">|;
|
|
#
|
|
# map { print "\n$column_data{$_}" } @column_index;
|
|
#
|
|
# print qq|
|
|
# </tr>
|
|
#|;
|
|
#
|
|
# $runningnumber = $locale->text('No.');
|
|
# $deliverydate = $locale->text('Delivery Date');
|
|
# $serialnumber = $locale->text('Serial No.');
|
|
# $projectnumber = $locale->text('Project');
|
|
# $partsgroup = $locale->text('Group');
|
|
# $reqdate = $locale->text('Reqdate');
|
|
#
|
|
# $delvar = 'deliverydate';
|
|
#
|
|
# if ($form->{type} =~ /_order$/ || $form->{type} =~ /_quotation$/) {
|
|
# $deliverydate = $locale->text('Required by');
|
|
# $delvar = 'reqdate';
|
|
# }
|
|
#
|
|
# $form->{marge_total} = 0;
|
|
# $form->{sellprice_total} = 0;
|
|
# $form->{lastcost_total} = 0;
|
|
# my %projectnumber_labels = ();
|
|
# my @projectnumber_values = ("");
|
|
# foreach my $item (@{ $form->{"ALL_PROJECTS"} }) {
|
|
# push(@projectnumber_values, $item->{"id"});
|
|
# $projectnumber_labels{$item->{"id"}} = $item->{"projectnumber"};
|
|
# }
|
|
#
|
|
# for $i (1 .. $numrows) {
|
|
#
|
|
# # undo formatting
|
|
# map {
|
|
# $form->{"${_}_$i"} =
|
|
# $form->parse_amount(\%myconfig, $form->{"${_}_$i"})
|
|
# } qw(qty ship discount sellprice price_new price_old) unless ($form->{simple_save});
|
|
#
|
|
# if (!$form->{"unit_old_$i"}) {
|
|
# # Neue Ware aus der Datenbank. In diesem Fall ist unit_$i die
|
|
# # Einheit, wie sie in den Stammdaten hinterlegt wurde.
|
|
# # Es sollte also angenommen werden, dass diese ausgewaehlt war.
|
|
# $form->{"unit_old_$i"} = $form->{"unit_$i"};
|
|
# }
|
|
#
|
|
# # Die zuletzt ausgewaehlte mit der aktuell ausgewaehlten Einheit
|
|
# # vergleichen und bei Unterschied den Preis entsprechend umrechnen.
|
|
# $form->{"selected_unit_$i"} = $form->{"unit_$i"} unless ($form->{"selected_unit_$i"});
|
|
#
|
|
# my $check_units = $form->{"inventory_accno_$i"} ? $dimension_units : $service_units;
|
|
# if (!$check_units->{$form->{"selected_unit_$i"}} ||
|
|
# ($check_units->{$form->{"selected_unit_$i"}}->{"base_unit"} ne
|
|
# $all_units->{$form->{"unit_old_$i"}}->{"base_unit"})) {
|
|
# # Die ausgewaehlte Einheit ist fuer diesen Artikel nicht gueltig
|
|
# # (z.B. Dimensionseinheit war ausgewaehlt, es handelt sich aber
|
|
# # um eine Dienstleistung). Dann keinerlei Umrechnung vornehmen.
|
|
# $form->{"unit_old_$i"} = $form->{"selected_unit_$i"} = $form->{"unit_$i"};
|
|
# }
|
|
# if ((!$form->{"prices_$i"}) || ($form->{"new_pricegroup_$i"} == $form->{"old_pricegroup_$i"})) {
|
|
# if ($form->{"unit_old_$i"} ne $form->{"selected_unit_$i"}) {
|
|
# my $basefactor = 1;
|
|
# if (defined($all_units->{$form->{"unit_old_$i"}}->{"factor"}) &&
|
|
# $all_units->{$form->{"unit_old_$i"}}->{"factor"}) {
|
|
# $basefactor = $all_units->{$form->{"selected_unit_$i"}}->{"factor"} /
|
|
# $all_units->{$form->{"unit_old_$i"}}->{"factor"};
|
|
# }
|
|
# $form->{"sellprice_$i"} *= $basefactor;
|
|
# $form->{"unit_old_$i"} = $form->{"selected_unit_$i"};
|
|
# }
|
|
# }
|
|
#
|
|
# ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/);
|
|
# $decimalplaces = max length($dec), 2;
|
|
#
|
|
# $price_factor = $price_factors{$form->{"price_factor_id_$i"}} || 1;
|
|
# $discount = (100 - $form->{"discount_$i"} * 1) / 100;
|
|
#
|
|
# $linetotal = $form->round_amount($form->{"sellprice_$i"} * $form->{"qty_$i"} * $discount / $price_factor, $decimalplaces);
|
|
#
|
|
# my $real_sellprice = $form->{"sellprice_$i"} * $discount / $price_factor;
|
|
#
|
|
# # marge calculations
|
|
# my ($marge_font_start, $marge_font_end);
|
|
#
|
|
# $form->{"lastcost_$i"} *= 1;
|
|
#
|
|
# $marge_price_factor = $form->{"marge_price_factor_$i"} * 1 || 1;
|
|
#
|
|
# if ($real_sellprice && ($form->{"qty_$i"} * 1)) {
|
|
# $form->{"marge_percent_$i"} = ($real_sellprice - $form->{"lastcost_$i"} / $marge_price_factor) * 100 / $real_sellprice;
|
|
# $myconfig{"marge_percent_warn"} = 15 unless (defined($myconfig{"marge_percent_warn"}));
|
|
#
|
|
# if ($form->{"id_$i"} &&
|
|
# ($form->{"marge_percent_$i"} < (1 * $myconfig{"marge_percent_warn"}))) {
|
|
# $marge_font_start = "<font color=\"#ff0000\">";
|
|
# $marge_font_end = "</font>";
|
|
# }
|
|
#
|
|
# } else {
|
|
# $form->{"marge_percent_$i"} = 0;
|
|
# }
|
|
#
|
|
# my $marge_adjust_credit_note = $form->{type} eq 'credit_note' ? -1 : 1;
|
|
# $form->{"marge_total_$i"} = ($real_sellprice - $form->{"lastcost_$i"} / $marge_price_factor) * $form->{"qty_$i"} * $marge_adjust_credit_note;
|
|
# $form->{"marge_total"} += $form->{"marge_total_$i"};
|
|
# $form->{"lastcost_total"} += $form->{"lastcost_$i"} * $form->{"qty_$i"} / $marge_price_factor;
|
|
# $form->{"sellprice_total"} += $real_sellprice * $form->{"qty_$i"};
|
|
#
|
|
# map { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2) } qw(marge_total marge_percent);
|
|
#
|
|
# # convert " to "
|
|
# map { $form->{"${_}_$i"} =~ s/\"/"/g }
|
|
# qw(partnumber description unit unit_old);
|
|
#
|
|
#########################################
|
|
# # Eintrag fuer Version 2.2.0 geaendert #
|
|
# # neue Optik im Rechnungsformular #
|
|
#########################################
|
|
# $column_data{runningnumber} =
|
|
# qq|<td><input name="runningnumber_$i" size="5" value="$i"></td>|; # HuT
|
|
############### ENDE Neueintrag ##################
|
|
#
|
|
# $column_data{partnumber} =
|
|
# qq|<td><input name="partnumber_$i" size=12 value="$form->{"partnumber_$i"}"></td>|;
|
|
#
|
|
# if (($rows = $form->numtextrows($form->{"description_$i"}, 30, 6)) > 1) {
|
|
# $column_data{description} =
|
|
# qq|<td><textarea name="description_$i" rows="$rows" cols="30" wrap="soft">| . H($form->{"description_$i"}) . qq|</textarea><button type="button" onclick="set_longdescription_window('longdescription_$i')">| . $locale->text('L') . qq|</button></td>|;
|
|
# } else {
|
|
# $column_data{description} =
|
|
# qq|<td><input name="description_$i" size="30" value="| . $form->quote($form->{"description_$i"}) . qq|"><button type="button" onclick="set_longdescription_window('longdescription_$i')">| . $locale->text('L') . qq|</button></td>|;
|
|
# }
|
|
#
|
|
# (my $qty_dec) = ($form->{"qty_$i"} =~ /\.(\d+)/);
|
|
# $qty_dec = length $qty_dec;
|
|
#
|
|
# $column_data{qty} =
|
|
# qq|<td align="right" nowrap><input name="qty_$i" size="5" value="|
|
|
# . $form->format_amount(\%myconfig, $form->{"qty_$i"}, $qty_dec) .qq|">|;
|
|
# if ($form->{"formel_$i"}) {
|
|
# $column_data{qty} .= qq|<button type="button" onclick="calculate_qty_selection_window('qty_$i','alu_$i', 'formel_$i', $i)">| . $locale->text('*/') . qq|</button>|
|
|
# . $cgi->hidden("-name" => "formel_$i", "-value" => $form->{"formel_$i"}) . $cgi->hidden("-name" => "alu_$i", "-value" => $form->{"alu_$i"});
|
|
# }
|
|
# $column_data{qty} .= qq|</td>|;
|
|
# $column_data{ship} =
|
|
# qq|<td align="right"><input name="ship_$i" size=5 value="|
|
|
# . $form->format_amount(\%myconfig, $form->{"ship_$i"})
|
|
# . qq|"></td>|;
|
|
#
|
|
# my $is_part = $form->{"inventory_accno_$i"};
|
|
# my $is_assembly = $form->{"assembly_$i"};
|
|
# my $is_assigned = $form->{"id_$i"};
|
|
# my $this_unit = $form->{"unit_$i"};
|
|
# if ($form->{"selected_unit_$i"} && $this_unit &&
|
|
# $all_units->{$form->{"selected_unit_$i"}} && $all_units->{$this_unit} &&
|
|
# ($all_units->{$form->{"selected_unit_$i"}}->{"base_unit"} eq $all_units->{$this_unit}->{"base_unit"})) {
|
|
# $this_unit = $form->{"selected_unit_$i"};
|
|
# } elsif (!$is_assigned ||
|
|
# ($is_part && !$this_unit && ($all_units->{$this_unit} && ($all_units->{$this_unit}->{"base_unit"} eq $all_units->{"kg"}->{"base_unit"})))) {
|
|
# $this_unit = "kg";
|
|
# }
|
|
#
|
|
# my $price_factor_select;
|
|
# if (0 < scalar @{ $form->{ALL_PRICE_FACTORS} }) {
|
|
# my @values = ('', map { $_->{id} } @{ $form->{ALL_PRICE_FACTORS} });
|
|
# my %labels = map { $_->{id} => $_->{description} } @{ $form->{ALL_PRICE_FACTORS} };
|
|
#
|
|
# $price_factor_select =
|
|
# NTI($cgi->popup_menu('-name' => "price_factor_id_$i",
|
|
# '-default' => $form->{"price_factor_id_$i"},
|
|
# '-values' => \@values,
|
|
# '-labels' => \%labels,
|
|
# '-style' => 'width:90px'))
|
|
# . ' ';
|
|
# }
|
|
#
|
|
# $column_data{"unit"} = "<td>" .
|
|
# $price_factor_select .
|
|
# AM->unit_select_html($is_part || $is_assembly ? $dimension_units :
|
|
# $is_assigned ? $service_units : $all_units,
|
|
# "unit_$i", $this_unit,
|
|
# $is_assigned ? $form->{"unit_$i"} : undef)
|
|
# . "</td>";
|
|
#
|
|
# # build in drop down list for pricesgroups
|
|
# if ($form->{"prices_$i"}) {
|
|
# if ($form->{"new_pricegroup_$i"} != $form->{"old_pricegroup_$i"}) {
|
|
# $price_tmp = $form->format_amount(\%myconfig, $form->{"price_new_$i"}, $decimalplaces);
|
|
# } else {
|
|
# $price_tmp = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces);
|
|
# }
|
|
#
|
|
# $column_data{sellprice_pg} =
|
|
# qq|<td align="right"><select name="sellprice_pg_$i">$form->{"prices_$i"}</select></td>|;
|
|
# $column_data{sellprice} =
|
|
# qq|<td><input name="sellprice_$i" size="10" value="$price_tmp" onBlur=\"check_right_number_format(this)\"></td>|;
|
|
# } else {
|
|
#
|
|
# # for last row and report
|
|
# # set pricegroup drop down list from report menu
|
|
# if ($form->{"sellprice_$i"} != 0) {
|
|
# $prices =
|
|
# qq|<option value="$form->{"sellprice_$i"}--$form->{"pricegroup_id_$i"}" selected>$form->{"pricegroup_$i"}</option>\n|;
|
|
#
|
|
# $form->{"pricegroup_old_$i"} = $form->{"pricegroup_id_$i"};
|
|
#
|
|
# $column_data{sellprice_pg} =
|
|
# qq|<td align="right"><select name="sellprice_pg_$i">$prices</select></td>|;
|
|
#
|
|
# } else {
|
|
#
|
|
# # for last row
|
|
# $column_data{sellprice_pg} = qq|<td align="right"> </td>|;
|
|
# }
|
|
#
|
|
# $column_data{sellprice} =
|
|
# qq|<td><input name="sellprice_$i" size="10" onBlur=\"check_right_number_format(this)\" value="|
|
|
# . $form->format_amount(\%myconfig, $form->{"sellprice_$i"},
|
|
# $decimalplaces)
|
|
# . qq|"></td>|;
|
|
# }
|
|
# $column_data{discount} =
|
|
# qq|<td align="right"><input name="discount_$i" size=3 value="|
|
|
# . $form->format_amount(\%myconfig, $form->{"discount_$i"})
|
|
# . qq|"></td>|;
|
|
# $column_data{linetotal} =
|
|
# qq|<td align="right">|
|
|
# . $form->format_amount(\%myconfig, $linetotal, 2)
|
|
# . qq|</td>|;
|
|
# $column_data{bin} = qq|<td>$form->{"bin_$i"}</td>|;
|
|
#
|
|
#########################################
|
|
# # Eintrag fuer Version 2.2.0 geaendert #
|
|
# # neue Optik im Rechnungsformular #
|
|
#########################################
|
|
# # if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") {
|
|
# # $column_data{license} = qq|<td><select name="licensenumber_$i">$form->{"lizenzen_$i"}></select></td>|;
|
|
# # }
|
|
# #
|
|
# # if ($form->{type} !~ /_quotation/) {
|
|
# # $column_data{serialnr} = qq|<td><input name="serialnumber_$i" size=10 value="$form->{"serialnumber_$i"}"></td>|;
|
|
# # }
|
|
# #
|
|
# # $column_data{projectnr} = qq|<td><input name="projectnumber_$i" size=10 value="$form->{"projectnumber_$i"}"></td>|;
|
|
############### ENDE Neueintrag ##################
|
|
# my $j = $i % 2;
|
|
# print qq|
|
|
#
|
|
# <tr valign="top" class="listrow$j">|;
|
|
#
|
|
# map { print "\n$column_data{$_}" } @column_index;
|
|
#
|
|
# print("</tr>\n" .
|
|
# $cgi->hidden("-name" => "unit_old_$i",
|
|
# "-value" => $form->{"selected_unit_$i"})
|
|
# . "\n" .
|
|
# $cgi->hidden("-name" => "price_new_$i",
|
|
# "-value" => $form->format_amount(\%myconfig, $form->{"price_new_$i"}))
|
|
# . "\n");
|
|
# map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_}) . "\n"); }
|
|
# ("orderitems_id_$i", "bo_$i", "pricegroup_old_$i", "price_old_$i",
|
|
# "id_$i", "inventory_accno_$i", "bin_$i", "partsgroup_$i", "partnotes_$i",
|
|
# "income_accno_$i", "expense_accno_$i", "listprice_$i", "assembly_$i",
|
|
# "taxaccounts_$i", "ordnumber_$i", "transdate_$i", "cusordnumber_$i",
|
|
# "longdescription_$i", "basefactor_$i", "marge_total_$i", "marge_percent_$i", "lastcost_$i",
|
|
# "marge_price_factor_$i"));
|
|
#
|
|
#########################################
|
|
# # Eintrag fuer Version 2.2.0 geaendert #
|
|
# # neue Optik im Rechnungsformular #
|
|
#########################################
|
|
#
|
|
# my $row_style_attr =
|
|
# 'style="display:none;"' if (!$form->{"show_details"});
|
|
#
|
|
# # print second row
|
|
# print qq|
|
|
# <tr class="listrow$j" $row_style_attr>
|
|
# <td colspan="$colspan">
|
|
#|;
|
|
# if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") {
|
|
# my $selected = $form->{"licensenumber_$i"};
|
|
# my $lizenzen_quoted;
|
|
# $form->{"lizenzen_$i"} =~ s/ selected//g;
|
|
# $form->{"lizenzen_$i"} =~
|
|
# s/value="${selected}"\>/value="${selected}" selected\>/;
|
|
# $lizenzen_quoted = $form->{"lizenzen_$i"};
|
|
# $lizenzen_quoted =~ s/\"/"/g;
|
|
# print qq|
|
|
# <b>Lizenz\#</b> <select name="licensenumber_$i" size="1">
|
|
# $form->{"lizenzen_$i"}
|
|
# </select>
|
|
# <input type="hidden" name="lizenzen_$i" value="${lizenzen_quoted}">
|
|
#|;
|
|
# }
|
|
# if ($form->{type} !~ /_quotation/) {
|
|
# print qq|
|
|
# <b>$serialnumber</b> <input name="serialnumber_$i" size="15" value="$form->{"serialnumber_$i"}">|;
|
|
# }
|
|
#
|
|
# print qq|<b>$projectnumber</b> | .
|
|
# NTI($cgi->popup_menu('-name' => "project_id_$i",
|
|
# '-values' => \@projectnumber_values,
|
|
# '-labels' => \%projectnumber_labels,
|
|
# '-default' => $form->{"project_id_$i"}));
|
|
#
|
|
# if ($form->{type} eq 'invoice' or $form->{type} =~ /order/) {
|
|
# my $reqdate_term =
|
|
# ($form->{type} eq 'invoice')
|
|
# ? 'deliverydate'
|
|
# : 'reqdate'; # invoice uses a different term for the same thing.
|
|
# print qq|
|
|
# <b>${$reqdate_term}</b> <input name="${reqdate_term}_$i" size="11" onBlur="check_right_date_format(this)" value="$form->{"${reqdate_term}_$i"}">
|
|
#|;
|
|
# }
|
|
# my $subtotalchecked = ($form->{"subtotal_$i"}) ? "checked" : "";
|
|
# print qq|
|
|
# <b>|.$locale->text('Subtotal').qq|</b> <input type="checkbox" name="subtotal_$i" value="1" $subtotalchecked>
|
|
#|;
|
|
#
|
|
# if ($form->{"id_$i"} && $is_sales) {
|
|
# my $marge_price_factor;
|
|
#
|
|
# $form->{"marge_price_factor_$i"} *= 1;
|
|
#
|
|
# if ($form->{"marge_price_factor_$i"} && (1 != $form->{"marge_price_factor_$i"})) {
|
|
# $marge_price_factor = '/' . $form->format_amount(\%myconfig, $form->{"marge_price_factor_$i"});
|
|
# }
|
|
#
|
|
# print qq|
|
|
# ${marge_font_start}<b>| . $locale->text('Ertrag') . qq|</b> $form->{"marge_total_$i"} $form->{"marge_percent_$i"} % ${marge_font_end}|;
|
|
# }
|
|
# print qq|
|
|
# <b>| . $locale->text('LP') . qq|</b> | . $form->format_amount(\%myconfig, $form->{"listprice_$i"}, 2) . qq|
|
|
# <b>| . $locale->text('EK') . qq|</b> | . $form->format_amount(\%myconfig, $form->{"lastcost_$i"}, 2) . $marge_price_factor;
|
|
#
|
|
#
|
|
# print qq|
|
|
# </td>
|
|
# </tr>
|
|
#|;
|
|
#
|
|
############### ENDE Neueintrag ##################
|
|
#
|
|
# map { $form->{"${_}_base"} += $linetotal }
|
|
# (split(/ /, $form->{"taxaccounts_$i"}));
|
|
#
|
|
# $form->{invsubtotal} += $linetotal;
|
|
# }
|
|
#
|
|
# print qq|
|
|
# </table>
|
|
# </td>
|
|
# </tr>
|
|
#|;
|
|
#
|
|
# if (0 != ($form->{sellprice_total} * 1)) {
|
|
# $form->{marge_percent} = ($form->{sellprice_total} - $form->{lastcost_total}) / $form->{sellprice_total} * 100;
|
|
# }
|
|
#
|
|
# $main::lxdebug->leave_sub();
|
|
#}
|
|
|
|
sub set_pricegroup {
|
|
$main::lxdebug->enter_sub();
|
|
|
|
my $form = $main::form;
|
|
my %myconfig = %main::myconfig;
|
|
my $locale = $main::locale;
|
|
|
|
my $rowcount = shift;
|
|
for my $j (1 .. $rowcount) {
|
|
my $pricegroup_old = $form->{"pricegroup_old_$j"};
|
|
if ($form->{PRICES}{$j}) {
|
|
my $len = 0;
|
|
my $prices = '<option value="--">' . $locale->text("none (pricegroup)") . '</option>';
|
|
my $price = 0;
|
|
foreach my $item (@{ $form->{PRICES}{$j} }) {
|
|
|
|
#$price = $form->round_amount($myconfig, $item->{price}, 5);
|
|
#$price = $form->format_amount($myconfig, $item->{price}, 2);
|
|
my $price = $item->{price};
|
|
my $pricegroup_id = $item->{pricegroup_id};
|
|
my $pricegroup = $item->{pricegroup};
|
|
|
|
# build drop down list for pricegroups
|
|
$prices .=
|
|
qq|<option value="$price--$pricegroup_id"$item->{selected}>$pricegroup</option>\n|;
|
|
|
|
$len += 1;
|
|
|
|
# map {
|
|
# $form->{"${_}_$j"} =
|
|
# $form->format_amount(\%myconfig, $form->{"${_}_$j"})
|
|
# } qw(sellprice price_new price_old);
|
|
|
|
# set new selectedpricegroup_id and prices for "Preis"
|
|
if ($item->{selected} && ($pricegroup_id != 0)) {
|
|
$form->{"pricegroup_old_$j"} = $pricegroup_id;
|
|
$form->{"price_new_$j"} = $price;
|
|
$form->{"sellprice_$j"} = $price;
|
|
}
|
|
if ($pricegroup_id == 0) {
|
|
$form->{"price_new_$j"} = $form->{"sellprice_$j"};
|
|
}
|
|
}
|
|
$form->{"prices_$j"} = $prices;
|
|
}
|
|
}
|
|
$main::lxdebug->leave_sub();
|
|
}
|
|
|
|
sub display_form {
|
|
$main::lxdebug->enter_sub();
|
|
|
|
my $form = $main::form;
|
|
my %myconfig = %main::myconfig;
|
|
|
|
$main::auth->assert('part_service_assembly_edit | vendor_invoice_edit | sales_order_edit | invoice_edit |' .
|
|
'request_quotation_edit | sales_quotation_edit | purchase_order_edit | '.
|
|
'purchase_delivery_order_edit | sales_delivery_order_edit');
|
|
|
|
relink_accounts();
|
|
retrieve_partunits() if ($form->{type} =~ /_delivery_order$/);
|
|
|
|
my $new_rowcount = $form->{"rowcount"} * 1 + 1;
|
|
$form->{"project_id_${new_rowcount}"} = $form->{"globalproject_id"};
|
|
|
|
$form->language_payment(\%myconfig);
|
|
|
|
# if we have a display_form
|
|
if ($form->{display_form}) {
|
|
call_sub($form->{"display_form"});
|
|
exit;
|
|
}
|
|
|
|
Common::webdav_folder($form) if ($main::webdav);
|
|
|
|
# if ( $form->{print_and_post}
|
|
# && $form->{second_run}
|
|
# && ($form->{action} eq "display_form")) {
|
|
# for (keys %$form) { $old_form->{$_} = $form->{$_} }
|
|
# $old_form->{rowcount}++;
|
|
#
|
|
# #$form->{rowcount}--;
|
|
# #$form->{rowcount}--;
|
|
#
|
|
# $form->{print_and_post} = 0;
|
|
#
|
|
# &print_form($old_form);
|
|
# exit;
|
|
# }
|
|
#
|
|
# $form->{action} = "";
|
|
# $form->{resubmit} = 0;
|
|
#
|
|
# if ($form->{print_and_post} && !$form->{second_run}) {
|
|
# $form->{second_run} = 1;
|
|
# $form->{action} = "display_form";
|
|
# $form->{rowcount}--;
|
|
# my $rowcount = $form->{rowcount};
|
|
#
|
|
# # get pricegroups for parts
|
|
# IS->get_pricegroups_for_parts(\%myconfig, \%$form);
|
|
#
|
|
# # build up html code for prices_$i
|
|
# set_pricegroup($rowcount);
|
|
#
|
|
# $form->{resubmit} = 1;
|
|
#
|
|
# }
|
|
&form_header;
|
|
|
|
{
|
|
no strict 'refs';
|
|
|
|
my $numrows = ++$form->{rowcount};
|
|
my $subroutine = "display_row";
|
|
|
|
if ($form->{item} eq 'part') {
|
|
|
|
#set preisgruppenanzahl
|
|
$numrows = $form->{price_rows};
|
|
$subroutine = "price_row";
|
|
|
|
&{$subroutine}($numrows);
|
|
|
|
$numrows = ++$form->{makemodel_rows};
|
|
$subroutine = "makemodel_row";
|
|
}
|
|
if ($form->{item} eq 'assembly') {
|
|
$numrows = $form->{price_rows};
|
|
$subroutine = "price_row";
|
|
|
|
&{$subroutine}($numrows);
|
|
|
|
$numrows = ++$form->{makemodel_rows};
|
|
$subroutine = "makemodel_row";
|
|
|
|
# create makemodel rows
|
|
&{$subroutine}($numrows);
|
|
|
|
$numrows = ++$form->{assembly_rows};
|
|
$subroutine = "assembly_row";
|
|
}
|
|
if ($form->{item} eq 'service') {
|
|
$numrows = $form->{price_rows};
|
|
$subroutine = "price_row";
|
|
|
|
&{$subroutine}($numrows);
|
|
|
|
$numrows = 0;
|
|
}
|
|
|
|
# create rows
|
|
&{$subroutine}($numrows) if $numrows;
|
|
}
|
|
|
|
&form_footer;
|
|
|
|
$main::lxdebug->leave_sub();
|
|
}
|