Nur dann Auftragsdaten aus Datenbank holen, wenn Rechnung aus Auftrag angelegt wird.
[kivitendo-erp.git] / bin / mozilla / is.pl
index 5708ac4..4a37b7e 100644 (file)
@@ -34,6 +34,7 @@
 use SL::FU;
 use SL::IS;
 use SL::PE;
+use SL::OE;
 use Data::Dumper;
 use List::Util qw(max sum);
 
@@ -45,7 +46,6 @@ require "bin/mozilla/drafts.pl";
 use strict;
 
 my $edit;
-my $payment;
 my $print_post;
 
 1;
@@ -156,6 +156,14 @@ sub invoice_links {
     $ref->{name} = $form->quote($ref->{name});
   }
 
+  # Load data for a specific order and update form fields
+  my $order_data = OE->get_order_data_by_ordnumber(%$form) if $form->{ordnumber};
+
+  # Copy the fields we need to %form
+  for my $key (qw(payment_id salesman_id orddate taxzone_id quonumber)) {
+    $form->{$key} = $order_data->{$key};
+  }
+
   $form->restore_vars(qw(id));
 
   IS->retrieve_invoice(\%myconfig, \%$form);
@@ -163,24 +171,22 @@ sub invoice_links {
   $form->restore_vars(qw(taxincluded)) if $form->{id};
   $form->restore_vars(qw(salesman_id)) if $main::editing;
 
+
   # build vendor/customer drop down comatibility... don't ask
   if (@{ $form->{"all_customer"} }) {
     $form->{"selectcustomer"} = 1;
     $form->{customer}         = qq|$form->{customer}--$form->{"customer_id"}|;
   }
 
-  $form->{oldcustomer} = "$form->{customer}--$form->{customer_id}";
-  $form->{selectcustomer} = 1;
+  $form->{"oldcustomer"}  = $form->{customer};
+
+  if ($form->{"oldcustomer"} !~ m/--\d+$/ && $form->{"customer_id"}) {
+    $form->{"oldcustomer"} .= qq|--$form->{"customer_id"}|
+  }
 
-  # departments
-#  if ($form->{all_departments}) {
-#    $form->{selectdepartment} = "<option>\n";
-#    $form->{department}       = "$form->{department}--$form->{department_id}";
-#
-#    map {
-#      $form->{selectdepartment} .= "<option>$_->{description}--$_->{id}</option>\n"
-#    } @{ $form->{all_departments} };
-#  }
+
+#  $form->{oldcustomer} = "$form->{customer}--$form->{customer_id}";
+#  $form->{selectcustomer} = 1;
 
   $form->{employee} = "$form->{employee}--$form->{employee_id}";
 
@@ -289,15 +295,6 @@ sub form_header {
   $form->{defaultcurrency} = $form->get_default_currency(\%myconfig);
   $form->{radier}          = ($form->current_date(\%myconfig) eq $form->{gldate}) ? 1 : 0;
 
-  $payment = qq|<option value=""></option>|;
-  foreach my $item (@{ $form->{payment_terms} }) {
-    if ($form->{payment_id} eq $item->{id}) {
-      $payment .= qq|<option value="$item->{id}" selected>$item->{description}</option>|;
-    } else {
-      $payment .= qq|<option value="$item->{id}">$item->{description}</option>|;
-    }
-  }
-
   my $set_duedate_url = "$form->{script}?action=set_duedate";
 
   push @ { $form->{AJAX} }, new CGI::Ajax( 'set_duedate' => $set_duedate_url );
@@ -385,17 +382,19 @@ sub form_footer {
   my $form     = $main::form;
   my %myconfig = %main::myconfig;
   my $locale   = $main::locale;
-  my $cgi      = $main::cgi;
 
   $main::auth->assert('invoice_edit');
 
-  $form->{invtotal} = $form->{invsubtotal};
+  $form->{invtotal}    = $form->{invsubtotal};
+  $form->{oldinvtotal} = $form->{invtotal};
+
+  # note rows
+  $form->{rows} = max 2,
+    $form->numtextrows($form->{notes},    26, 8),
+    $form->numtextrows($form->{intnotes}, 35, 8);
 
-  my ($rows, $introws);
-  if (($rows    = $form->numtextrows($form->{notes}, 26, 8)) < 2)    { $rows    = 2; }
-  if (($introws = $form->numtextrows($form->{intnotes}, 35, 8)) < 2) { $introws = 2; }
-  $form->{rows} = ($rows > $introws) ? $rows : $introws;
 
+  # tax, total and subtotal calculations
   my ($tax, $subtotal);
   $form->{taxaccounts_array} = [ split / /, $form->{taxaccounts} ];
 
@@ -412,327 +411,33 @@ sub form_footer {
     }
   }
 
-  $form->{oldinvtotal} = $form->{invtotal};
-
-  # unfortunately locales doesn't support extended syntax
+  # follow ups
   if ($form->{id}) {
-    my $follow_ups = FU->follow_ups('trans_id' => $form->{id});
-    if (@{ $follow_ups} ) {
-      $form->{follow_up_text} = $locale->text("There are #1 unfinished follow-ups of which #2 are due.",
-                                               scalar(@{ $follow_ups }),
-                                               sum map { $_->{due} * 1 } @{ $follow_ups });
-    }
+    $form->{follow_ups}            = FU->follow_ups('trans_id' => $form->{id}) || [];
+    $form->{follow_ups_unfinished} = ( sum map { $_->{due} * 1 } @{ $form->{follow_ups} } ) || 0;
   }
 
-
-# payments
+  # payments
   my $totalpaid = 0;
-
   $form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"});
   $form->{paid_indices} = [ 1 .. $form->{paidaccounts} ];
 
   for my $i (1 .. $form->{paidaccounts}) {
     $form->{"selectAR_paid_$i"} = $form->{selectAR_paid};
     $form->{"selectAR_paid_$i"} =~ s/option>\Q$form->{"AR_paid_$i"}\E/option selected>$form->{"AR_paid_$i"}/;
-
-    # format amounts
     $totalpaid += $form->{"paid_$i"};
   }
 
-  $form->{print_options} = print_options(inline => 1);
-
-  print $form->parse_html_template('is/form_footer');
-# print $form->parse_html_template('is/_payments'); # parser
-
-
-
-#  print qq|
-#  <tr>
-#    <td>
-#      <table width="100%">
-#      <tr valign="bottom">
-#        <td>
-#          <table>
-#            <tr>
-#              <th align="left">| . $locale->text('Notes') . qq|</th>
-#              <th align="left">| . $locale->text('Internal Notes') . qq|</th>
-#                <th align="right">| . $locale->text('Payment Terms') . qq|</th>
-#            </tr>
-#            <tr valign="top">
-#              <td>$notes</td>
-#              <td>$intnotes</td>
-#                <td><select name="payment_id" onChange="if (this.value) set_duedate(['payment_id__' + this.value, 'invdate__' + invdate.value],['duedate'])">$payment
-#                </select></td>
-#            </tr>
-#        $follow_ups_block
-#          </table>
-#        </td>
-#          <td>
-#            <table>
-#            <tr>
-#              <th  align=left>| . $locale->text('Ertrag') . qq|</th>
-#              <td>| .  $form->format_amount(\%myconfig, $form->{marge_total}, 2, 0) . qq|</td>
-#            </tr>
-#            <tr>
-#              <th  align=left>| . $locale->text('Ertrag prozentual') . qq|</th>
-#              <td>| .  $form->format_amount(\%myconfig, $form->{marge_percent}, 2, 0) . qq| %</td>
-#            </tr>
-#            <input type=hidden name="marge_total" value="$form->{"marge_total"}">
-#            <input type=hidden name="marge_percent" value="$form->{"marge_percent"}">
-#            </table>
-#          </td>
-#        <td align="right">
-#          $taxincluded
-#          <table>
-#            $subtotal
-#            $tax
-#            <tr>
-#              <th align="right">| . $locale->text('Total') . qq|</th>
-#              <td align="right">$form->{invtotal}</td>
-#            </tr>
-#          </table>
-#        </td>
-#      </tr>
-#      </table>
-#    </td>
-#  </tr>
-#|;
-#  my $webdav_list;
-#  if ($main::webdav) {
-#    $webdav_list = qq|
-#  <tr>
-#    <td><hr size="3" noshade></td>
-#  </tr>
-#  <tr>
-#    <th class="listtop" align="left">Dokumente im Webdav-Repository</th>
-#  </tr>
-#    <table width="100%">
-#      <td align="left" width="30%"><b>Dateiname</b></td>
-#      <td align="left" width="70%"><b>Webdavlink</b></td>
-#|;
-#    foreach my $file (@{ $form->{WEBDAV} }) {
-#      $webdav_list .= qq|
-#      <tr>
-#        <td align="left">$file->{name}</td>
-#        <td align="left"><a href="$file->{link}">$file->{type}</a></td>
-#      </tr>
-#|;
-#    }
-#    $webdav_list .= qq|
-#    </table>
-#  </tr>
-#|;
-#
-#    print $webdav_list;
-#  }
-#if ($form->{type} eq "credit_note") {
-#  print qq|
-#  <tr>
-#    <td>
-#      <table width="100%">
-#      <tr class="listheading">
-#        <th colspan="6" class="listheading">|
-#    . $locale->text('Payments') . qq|</th>
-#      </tr>
-#|;
-#} else {
-#  print qq|
-#  <tr>
-#    <td>
-#      <table width="100%">
-#      <tr class="listheading">
-#        <th colspan="6" class="listheading">|
-#    . $locale->text('Incoming Payments') . qq|</th>
-#      </tr>
-#|;
-#}
-#
-#  my @column_index;
-#  if ($form->{currency} eq $form->{defaultcurrency}) {
-#    @column_index = qw(datepaid source memo paid AR_paid);
-#  } else {
-#    @column_index = qw(datepaid source memo paid exchangerate AR_paid);
-#  }
-#
-#  my %column_data;
-#  $column_data{datepaid}     = "<th>" . $locale->text('Date') . "</th>";
-#  $column_data{paid}         = "<th>" . $locale->text('Amount') . "</th>";
-#  $column_data{exchangerate} = "<th>" . $locale->text('Exch') . "</th>";
-#  $column_data{AR_paid}      = "<th>" . $locale->text('Account') . "</th>";
-#  $column_data{source}       = "<th>" . $locale->text('Source') . "</th>";
-#  $column_data{memo}         = "<th>" . $locale->text('Memo') . "</th>";
-#
-#  print "
-#      <tr>
-#";
-#  map { print "$column_data{$_}\n" } @column_index;
-#  print "
-#        </tr>
-#";
-#
-#  my @triggers  = ();
-#  my $totalpaid = 0;
-#
-#  $form->{paidaccounts}++ if ($form->{"paid_$form->{paidaccounts}"});
-#  for my $i (1 .. $form->{paidaccounts}) {
-#
-#    print "
-#        <tr>\n";
-#
-#    $form->{"selectAR_paid_$i"} = $form->{selectAR_paid};
-#    $form->{"selectAR_paid_$i"} =~
-#      s/option>\Q$form->{"AR_paid_$i"}\E/option selected>$form->{"AR_paid_$i"}/;
-#
-#    # format amounts
-#    $totalpaid += $form->{"paid_$i"};
-#    if ($form->{"paid_$i"}) {
-#      $form->{"paid_$i"} = $form->format_amount(\%myconfig, $form->{"paid_$i"}, 2);
-#    }
-#    $form->{"exchangerate_$i"} = $form->format_amount(\%myconfig, $form->{"exchangerate_$i"});
-#
-#    if ($form->{"exchangerate_$i"} == 0) {
-#      $form->{"exchangerate_$i"} = "";
-#    }
-#    my $exchangerate = qq|&nbsp;|;
-#    if ($form->{currency} ne $form->{defaultcurrency}) {
-#      if ($form->{"forex_$i"}) {
-#        $exchangerate = qq|<input type="hidden" name="exchangerate_$i" value="$form->{"exchangerate_$i"}">$form->{"exchangerate_$i"}|;
-#      } else {
-#        $exchangerate = qq|<input name="exchangerate_$i" size="10" value="$form->{"exchangerate_$i"}">|;
-#      }
-#    }
-#
-#    $exchangerate .= qq|<input type="hidden" name="forex_$i" value="$form->{"forex_$i"}">|;
-#
-#    $column_data{"paid_$i"} =
-#      qq|<td align="center"><input name="paid_$i" size="11" value="$form->{"paid_$i"}" onBlur=\"check_right_number_format(this)\"></td>|;
-#    $column_data{"exchangerate_$i"} = qq|<td align="center">$exchangerate</td>|;
-#    $column_data{"AR_paid_$i"}      =
-#      qq|<td align="center"><select name="AR_paid_$i">$form->{"selectAR_paid_$i"}</select></td>|;
-#    $column_data{"datepaid_$i"} =
-#      qq|<td align="center"><input id="datepaid_$i" name="datepaid_$i"  size="11" title="$myconfig{dateformat}" value="$form->{"datepaid_$i"}" onBlur=\"check_right_date_format(this)\">
-#         <input type="button" name="datepaid_$i" id="trigger_datepaid_$i" value="?"></td>|;
-#    $column_data{"source_$i"} =
-#      qq|<td align=center><input name="source_$i" size="11" value="$form->{"source_$i"}"></td>|;
-#    $column_data{"memo_$i"} =
-#      qq|<td align="center"><input name="memo_$i" size="11" value="$form->{"memo_$i"}"></td>|;
-#
-#    map { print qq|$column_data{"${_}_$i"}\n| } @column_index;
-#    print "
-#        </tr>\n";
-#    push(@triggers, "datepaid_$i", "BL", "trigger_datepaid_$i");
-#  }
-#
-#  my $paid_missing = $form->{oldinvtotal} - $totalpaid;
-#
-#  print qq|
-#    <tr>
-#      <td></td>
-#      <td></td>
-#      <td align="center">| . $locale->text('Total') . qq|</td>
-#      <td align="center">| . H($form->format_amount(\%myconfig, $totalpaid, 2)) . qq|</td>
-#    </tr>
-#    <tr>
-#      <td></td>
-#      <td></td>
-#      <td align="center">| . $locale->text('Missing amount') . qq|</td>
-#      <td align="center">| . H($form->format_amount(\%myconfig, $paid_missing, 2)) . qq|</td>
-#    </tr>
-#|;
-#
-#  map({ print($cgi->hidden("-name" => $_, "-value" => $form->{$_})); } qw(paidaccounts selectAR_paid oldinvtotal));
-#  print qq|<input type="hidden" name="oldtotalpaid" value="$totalpaid">
-#    </table>
-#    </td>
-#  </tr>
-#  <tr>
-#    <td><hr size="3" noshade></td>
-#  </tr>
-#  <tr>
-#    <td>
-#|;
-#
-#  print_options();
-#
-#  print qq|
-#    </td>
-#  </tr>
-#</table>
-#|;
-#
-#  my $invdate  = $form->datetonum($form->{invdate},  \%myconfig);
-#  my $closedto = $form->datetonum($form->{closedto}, \%myconfig);
-#
-#  if ($form->{id}) {
-#    my $show_storno = !$form->{storno} && !IS->has_storno(\%myconfig, $form, "ar") && (($totalpaid == 0) || ($totalpaid eq ""));
-#
-#    print qq|
-#    <input class="submit" type="submit" accesskey="u" name="action" id="update_button" value="| . $locale->text('Update') . qq|">
-#    <input class="submit" type="submit" name="action" value="| . $locale->text('Ship to') . qq|">
-#    <input class="submit" type="submit" name="action" value="| . $locale->text('Print') . qq|">
-#    <input class="submit" type="submit" name="action" value="| . $locale->text('E-mail') . qq|"> |;
-#    print qq|<input class="submit" type="submit" name="action" value="| . $locale->text('Storno') . qq|"> | if ($show_storno);
-#    print qq|<input class="submit" type="submit" name="action" value="| . $locale->text('Post Payment') . qq|"> |;
-#    print qq|<input class="submit" type="submit" name="action" value="| . $locale->text('Use As Template') . qq|"> |;
-#    if ($form->{id} && !($form->{type} eq "credit_note")) {
-#      print qq| <input class="submit" type="submit" name="action" value="| . $locale->text('Credit Note') . qq|"> |;
-#    }
-#    if ($form->{radier}) {
-#      print qq| <input class="submit" type="submit" name="action" value="| . $locale->text('Delete') . qq|"> |;
-#    }
-#
-#
-#    if ($invdate > $closedto) {
-#      print qq| <input class="submit" type="submit" name="action" value="| . $locale->text('Order') . qq|"> |;
-#    }
-#
-#    print qq| <input type="button" class="submit" onclick="follow_up_window()" value="| . $locale->text('Follow-Up') . qq|">|;
-#
-#  } else {
-#    if ($invdate > $closedto) {
-#      print qq|
-#      <input class="submit" type="submit" name="action" id="update_button" value="| . $locale->text('Update') . qq|">
-#      <input class="submit" type="submit" name="action" value="| . $locale->text('Ship to') . qq|">
-#      <input class="submit" type="submit" name="action" value="| . $locale->text('Preview') . qq|">
-#      <input class="submit" type="submit" name="action" value="| . $locale->text('E-mail') . qq|">
-#      <input class="submit" type="submit" name="action" value="| . $locale->text('Print and Post') . qq|">
-#      <input class="submit" type="submit" name="action" value="| . $locale->text('Post') . qq|"> | .
-#        NTI($cgi->submit('-name' => 'action', '-value' => $locale->text('Save draft'), '-class' => 'submit'));
-#    }
-#  }
-#
-#  # button for saving history
-#  if($form->{id} ne "") {
-#    print qq|
-#        <input type="button" class="submit" onclick="set_history_window(|
-#        . Q($form->{id})
-#        . qq|);" name="history" id="history" value="|
-#        . $locale->text('history')
-#        . qq|"> |;
-#  }
-#  # /button for saving history
-#
-#  # mark_as_paid button
-#  if($form->{id} ne "") {
-#    print qq|<input type="submit" class="submit" name="action" value="| . $locale->text('mark as paid') . qq|">|;
-#  }
-#  # /mark_as_paid button
-#  print $form->write_trigger(\%myconfig, scalar(@triggers) / 3, @triggers) .
-#    qq|
-#
-#<input type="hidden" name="rowcount" value="$form->{rowcount}">
-#| .
-#$cgi->hidden("-name" => "callback", "-value" => $form->{callback})
-#. $cgi->hidden('-name' => 'draft_id', '-default' => [$form->{draft_id}])
-#. $cgi->hidden('-name' => 'draft_description', '-default' => [$form->{draft_description}])
-#. $cgi->hidden('-name' => 'customer_discount', '-value' => [$form->{customer_discount}])
-#. qq|
-#</form>
-#
-#</body>
-#
-# </html>
-#|;
+  print $form->parse_html_template('is/form_footer', {
+    is_type_credit_note => ($form->{type} eq "credit_note"),
+    totalpaid           => $totalpaid,
+    paid_missing        => $form->{invtotal} - $totalpaid,
+    print_options       => print_options(inline => 1),
+    show_storno         => $form->{id} && !$form->{storno} && !IS->has_storno(\%myconfig, $form, "ar") && !$totalpaid,
+    show_delete         => ($form->current_date(\%myconfig) eq $form->{gldate}),
+  });
+##print $form->parse_html_template('is/_payments'); # parser
+##print $form->parse_html_template('webdav/_list'); # parser
 
   $main::lxdebug->leave_sub();
 }
@@ -760,7 +465,7 @@ sub update {
 
   my ($recursive_call) = shift;
 
-  map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining) unless $recursive_call;
+#  map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining) unless $recursive_call;
 
   $form->{print_and_post} = 0         if $form->{second_run};
   my $taxincluded            = "checked" if $form->{taxincluded};
@@ -1181,8 +886,8 @@ sub credit_note {
 
   map { $form->{"select$_"} = "" } ($form->{vc}, 'currency');
 
-  map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) }
-    qw(creditlimit creditremaining);
+#  map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) }
+#    qw(creditlimit creditremaining);
 
   my $currency = $form->{currency};
   &invoice_links;