use SL::DBUtils;
use SL::FU;
use SL::Notes;
+use SL::TransNumber;
+
+use strict;
sub get_tuple {
$main::lxdebug->enter_sub();
qq|ORDER BY cp.cp_id LIMIT 1|;
my $sth = prepare_execute_query($form, $dbh, $query, $form->{id});
- my $ref = $sth->fetchrow_hashref(NAME_lc);
+ my $ref = $sth->fetchrow_hashref("NAME_lc");
map { $form->{$_} = $ref->{$_} } keys %$ref;
if ($ref) {
foreach my $key (keys %{ $ref }) {
my $new_key = $key;
- $new_key =~ s/^([^_]+)/\U\1\E/;
+ $new_key =~ s/^([^_]+)/\U$1\E/;
$form->{$new_key} = $ref->{$key};
}
}
$main::lxdebug->enter_sub();
my ($self, $myconfig, $form, $provided_dbh) = @_;
+ my $query;
my $dbh = $provided_dbh ? $provided_dbh : $form->dbconnect($myconfig);
$main::lxdebug->enter_sub();
my ( $self, $myconfig, $form ) = @_;
- my ( %tmp, $ref );
+ my ( %tmp, $ref, $query );
my $dbh = $form->dbconnect($myconfig);
qq|FROM vendor | .
qq|WHERE greeting ~ '[a-zA-Z]' | .
qq|ORDER BY greeting|;
- my %tmp;
+
map({ $tmp{$_} = 1; } selectall_array_query($form, $dbh, $query));
$form->{COMPANY_GREETINGS} = [ sort(keys(%tmp)) ];
$form->{klass} = 0 unless ($form->{klass});
# connect to database
- my $dbh = $form->dbconnect_noauto($myconfig);
+ my $dbh = $form->get_standard_dbh;
map( {
$form->{"cp_${_}"} = $form->{"selected_cp_${_}"}
}
} else {
- if (!$form->{customernumber} && $form->{business}) {
- $form->{customernumber} =
- $form->update_business($myconfig, $form->{business}, $dbh);
- }
- if (!$form->{customernumber}) {
- $form->{customernumber} =
- $form->update_defaults($myconfig, "customernumber", $dbh);
- }
-
- $query = qq|SELECT c.id FROM customer c WHERE c.customernumber = ?|;
- ($f_id) = selectrow_query($form, $dbh, $query, $form->{customernumber});
- if ($f_id ne "") {
- $main::lxdebug->leave_sub();
- return 3;
- }
+ my $customernumber = SL::TransNumber->new(type => 'customer',
+ dbh => $dbh,
+ number => $form->{customernumber},
+ business_id => $form->{business},
+ save => 1);
+ $form->{customernumber} = $customernumber->create_unique unless $customernumber->is_unique;
$query = qq|SELECT nextval('id')|;
($form->{id}) = selectrow_query($form, $dbh, $query);
CVar->save_custom_variables('dbh' => $dbh,
'module' => 'CT',
'trans_id' => $form->{id},
- 'variables' => $form);
+ 'variables' => $form,
+ 'always_valid' => 1);
- $rc = $dbh->commit();
- $dbh->disconnect();
+ my $rc = $dbh->commit();
$main::lxdebug->leave_sub();
return $rc;
$form->{taxzone_id} *= 1;
# connect to database
- my $dbh = $form->dbconnect_noauto($myconfig);
+ my $dbh = $form->get_standard_dbh;
map( {
$form->{"cp_${_}"} = $form->{"selected_cp_${_}"}
$query = qq|INSERT INTO vendor (id, name) VALUES (?, '')|;
do_query($form, $dbh, $query, $form->{id});
- if ( !$form->{vendornumber} ) {
- $form->{vendornumber} = $form->update_defaults( $myconfig, "vendornumber", $dbh );
- }
+ my $vendornumber = SL::TransNumber->new(type => 'vendor',
+ dbh => $dbh,
+ number => $form->{vendornumber},
+ save => 1);
+ $form->{vendornumber} = $vendornumber->create_unique unless $vendornumber->is_unique;
}
$query =
qq| user_password = ?, | .
qq| v_customer_id = ? | .
qq|WHERE id = ?|;
- @values = (
+ my @values = (
$form->{vendornumber},
$form->{name},
$form->{greeting},
qq|cp_project = ?, | .
qq|cp_privatphone = ?, | .
qq|cp_privatemail = ?, | .
- qq|cp_birthday = ? | .
+ qq|cp_birthday = ?, | .
qq|cp_gender = ? | .
qq|WHERE cp_id = ?|;
@values = (
CVar->save_custom_variables('dbh' => $dbh,
'module' => 'CT',
'trans_id' => $form->{id},
- 'variables' => $form);
+ 'variables' => $form,
+ 'always_valid' => 1);
- $rc = $dbh->commit();
- $dbh->disconnect();
+ my $rc = $dbh->commit();
$main::lxdebug->leave_sub();
return $rc;
my @values;
my %allowed_sort_columns =
- map({ $_, 1 } qw(id customernumber vendornumber name contact phone fax email
- taxnumber business invnumber ordnumber quonumber));
- $sortorder = $form->{sort} && $allowed_sort_columns{$form->{sort}} ? $form->{sort} : "name";
+ map { $_, 1 } qw(
+ id customernumber vendornumber name contact phone fax email street
+ taxnumber business invnumber ordnumber quonumber zipcode city
+ );
+ my $sortorder = $form->{sort} && $allowed_sort_columns{$form->{sort}} ? $form->{sort} : "name";
$form->{sort} = $sortorder;
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
- if ($sortorder ne 'id' && 1 >= scalar grep { $form->{$_} } qw(l_ordnumber l_quonumber l_invnumber)) {
+ if ($sortorder !~ /(business|id)/ && 1 >= scalar grep { $form->{$_} } qw(l_ordnumber l_quonumber l_invnumber )) {
$sortorder = "lower($sortorder) ${sortdir}";
} else {
$sortorder .= " ${sortdir}";
qq|SELECT * FROM contacts c | .
qq|WHERE cp_id = ? ORDER BY cp_id limit 1|;
my $sth = prepare_execute_query($form, $dbh, $query, $form->{cp_id});
- my $ref = $sth->fetchrow_hashref(NAME_lc);
+ my $ref = $sth->fetchrow_hashref("NAME_lc");
map { $form->{$_} = $ref->{$_} } keys %$ref;
my $query = qq|SELECT * FROM shipto WHERE shipto_id = ?|;
my $sth = prepare_execute_query($form, $dbh, $query, $form->{shipto_id});
- my $ref = $sth->fetchrow_hashref(NAME_lc);
+ my $ref = $sth->fetchrow_hashref("NAME_lc");
map { $form->{$_} = $ref->{$_} } keys %$ref;
qq|SELECT s.shiptoname, i.qty $qty_sign, | .
qq| ${arap}.id, ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | .
qq| i.description, i.unit, i.sellprice, | .
- qq| oe.id AS oe_id | .
+ qq| oe.id AS oe_id, invoice | .
qq|FROM $arap | .
qq|LEFT JOIN shipto s ON | .
($arap eq "ar"
$main::lxdebug->leave_sub();
}
-sub delete_shipto {
+sub delete_contact {
$main::lxdebug->enter_sub();
my $self = shift;
- my $shipto_id = shift;
+ my $cp_id = shift;
my $form = $main::form;
my %myconfig = %main::myconfig;
my $dbh = $form->get_standard_dbh(\%myconfig);
- do_query($form, $dbh, qq|UPDATE contacts SET cp_cv_id = NULL WHERE cp_id = ?|, $shipto_id);
+ do_query($form, $dbh, qq|UPDATE contacts SET cp_cv_id = NULL WHERE cp_id = ?|, $cp_id);
$dbh->commit();
my $table = $params{vc} eq 'customer' ? 'customer' : 'vendor';
my @ids = ref $params{id} eq 'ARRAY' ? @{ $params{id} } : ($params{id});
- my $placeholders = ('?') x scalar @ids;
+ my $placeholders = join ", ", ('?') x scalar @ids;
my $query = qq|SELECT id, name, account_number, bank, bank_code, iban, bic
FROM ${table}
WHERE id IN (${placeholders})|;
return $result;
}
+sub parse_excel_file {
+ $main::lxdebug->enter_sub();
+
+ my ($self, $myconfig, $form) = @_;
+ my $locale = $main::locale;
+
+ $form->{formname} = 'sales_quotation';
+ $form->{type} = 'sales_quotation';
+ $form->{format} = 'excel';
+ $form->{media} = 'screen';
+ $form->{quonumber} = 1;
+
+
+ # $form->{"notes"} will be overridden by the customer's/vendor's "notes" field. So save it here.
+ $form->{ $form->{"formname"} . "notes" } = $form->{"notes"};
+
+ my $inv = "quo";
+ my $due = "req";
+ $form->{"${inv}date"} = $form->{transdate};
+ $form->{label} = $locale->text('Quotation');
+ my $numberfld = "sqnumber";
+ my $order = 1;
+
+ # assign number
+ $form->{what_done} = $form->{formname};
+
+ map({ delete($form->{$_}); } grep(/^cp_/, keys(%{ $form })));
+
+ my $output_dateformat = $myconfig->{"dateformat"};
+ my $output_numberformat = $myconfig->{"numberformat"};
+ my $output_longdates = 1;
+
+ # map login user variables
+ map { $form->{"login_$_"} = $myconfig->{$_} } ("name", "email", "fax", "tel", "company");
+
+ # format item dates
+ for my $field (qw(transdate_oe deliverydate_oe)) {
+ map {
+ $form->{$field}[$_] = $locale->date($myconfig, $form->{$field}[$_], 1);
+ } 0 .. $#{ $form->{$field} };
+ }
+
+ if ($form->{shipto_id}) {
+ $form->get_shipto($myconfig);
+ }
+
+ $form->{notes} =~ s/^\s+//g;
+
+ $form->{templates} = $myconfig->{templates};
+
+ delete $form->{printer_command};
+
+ $form->get_employee_info($myconfig);
+
+ my ($cvar_date_fields, $cvar_number_fields) = CVar->get_field_format_list('module' => 'CT', 'prefix' => 'vc_');
+
+ if (scalar @{ $cvar_date_fields }) {
+ format_dates($output_dateformat, $output_longdates, @{ $cvar_date_fields });
+ }
+
+ while (my ($precision, $field_list) = each %{ $cvar_number_fields }) {
+ reformat_numbers($output_numberformat, $precision, @{ $field_list });
+ }
+
+ $form->{excel} = 1;
+ my $extension = 'xls';
+
+ $form->{IN} = "$form->{formname}.${extension}";
+
+ delete $form->{OUT};
+
+ $form->parse_template($myconfig);
+
+ $main::lxdebug->leave_sub();
+}
+
1;