sub _get_customers {
$main::lxdebug->enter_sub();
- my ($self, $dbh, $key, $limit) = @_;
-
- $key = "all_customers" unless ($key);
- my $limit_clause = "LIMIT $limit" if $limit;
+ my ($self, $dbh, $key) = @_;
- my $query = qq|SELECT * FROM customer WHERE NOT obsolete ORDER BY name $limit_clause|;
+ my $options = ref $key eq 'HASH' ? $key : { key => $key };
+ $options->{key} ||= "all_customers";
+ my $limit_clause = "LIMIT $options->{limit}" if $options->{limit};
+ my $where = $options->{business_is_salesman} ? qq| AND business_id IN (SELECT id FROM business WHERE salesman)| : '';
- $self->{$key} = selectall_hashref_query($self, $dbh, $query);
+ my $query = qq|SELECT * FROM customer WHERE NOT obsolete $where ORDER BY name $limit_clause|;
+ $self->{ $options->{key} } = selectall_hashref_query($self, $dbh, $query);
$main::lxdebug->leave_sub();
}
}
if($params{"customers"}) {
- if (ref $params{"customers"} eq 'HASH') {
- $self->_get_customers($dbh, $params{"customers"}{key}, $params{"customers"}{limit});
- } else {
- $self->_get_customers($dbh, $params{"customers"});
- }
+ $self->_get_customers($dbh, $params{"customers"});
}
if($params{"vendors"}) {
my %myconfig = %main::myconfig;
my $locale = $main::locale;
- $form->get_lists(employees => "ALL_EMPLOYEES",
- taxzones => "ALL_TAXZONES",
- business_types => { key => 'ALL_SALESMAN_BUSINESSES', salesman => 1 });
+ $form->get_lists(employees => "ALL_EMPLOYEES",
+ taxzones => "ALL_TAXZONES");
$form->get_pricegroup(\%myconfig, { all => 1 });
+ $form->get_lists(customers => { key => "ALL_SALESMAN_CUSTOMERS", business_is_salesman => 1 }) if $::vertreter;
+
$form->{ALL_SALESMEN} = $form->{ALL_EMPLOYEES};
$form->{taxincluded} = ($form->{taxincluded}) ? "checked" : "";
$form->{is_admin} = $myconfig{role} eq 'admin';
'WHJournal' => 'Lagerbuchungen',
'Warehouse' => 'Lager',
'Warehouse From' => 'Quelllager',
- 'Warehouse MIgration' => 'Lagermigration',
+ 'Warehouse Migration' => 'Lagermigration',
'Warehouse To' => 'Ziellager',
'Warehouse content' => 'Lagerbestand',
'Warehouse deleted.' => 'Lager gelöscht.',
<th align="right">Vertreter</th>
<td>
[%- INCLUDE generic/multibox.html
- name = 'salesman_id',
- DATA = ALL_SALESMAN_BUSINESSES,
- show_empty = 1,
- id_key = 'id',
- label_key = 'description',
+ name = 'salesman_id',
+ DATA = ALL_SALESMAN_CUSTOMERS,
+ id_key = 'id',
+ label_key = 'name',
-%]
</td>
</tr>
label_key = 'description',
-%]
</td>
- [%- IF is_customer && !use_vertreter %]
+ [%- IF is_customer && !conf_vertreter %]
<th align="right">Verkäufer/in</th>
<td>
[%- INCLUDE generic/multibox.html
<th align="right"><translate>Representative</translate></th>
<td>
[%- INCLUDE generic/multibox.html
- name = 'salesman_id',
- DATA = ALL_SALESMAN_BUSINESSES,
- show_empty = 1,
- id_key = 'id',
- label_key = 'description',
+ name = 'salesman_id',
+ DATA = ALL_SALESMAN_CUSTOMERS,
+ id_key = 'id',
+ label_key = 'name',
-%]
</td>
</tr>
label_key = 'description',
-%]
</td>
- [%- IF is_customer && !use_vertreter %]
+ [%- IF is_customer && !conf_vertreter %]
<th align="right"><translate>Salesman</translate></th>
<td>
[%- INCLUDE generic/multibox.html
-[% USE HTML %]<div class="listtop">Lagermigration</div>
+[% USE HTML %]
+<div class="listtop">Lagermigration</div>
<form action="[% script %]" method="POST">
+ <p>
+ Lx-Office enthält jetzt auch echte Lagerverwaultung anstatt reiner Mengenzählung.
+ Dieses update ändert die Art und Weise wie Lagermengen gezält werden.
+ Als Konsequenz können die gespeicherten Mengen entweder in ein Lager überführt werden, oder für eine frische Lagerverwaltung resettet werden.
+ </p>
-<p>Lx-Office enthält jetzt auch echte Lagerverwaultung anstatt reiner Mengenzählung.
-Dieses update ändert die Art und Weise wie Lagermengen gezält werden.
-Als Konsequenz können die gespeicherten Mengen entweder in ein Lager überführt werden, oder für eine frische Lagerverwaltung resettet werden.</p>
+ <p>Möchten Sie die vorhandenen Mengendaten in ein Lager übertragen?</p>
-<p>Möchten Sie die vorhandenen Mengendaten in ein Lager übertragen?</p>
-<input id=do_migrate_Y name=do_migrate type=radio value=Y> <label for=do_migrate_Y>Ja</label>
-<input id=do_migrate_N name=do_migrate type=radio value=N checked> <label for=do_migrate_N>Nein</label>
+ <input id="do_migrate_Y" name="do_migrate" type="radio" value="Y"> <label for="do_migrate_Y">Ja</label>
+ <input id="do_migrate_N" name="do_migrate" type="radio" value="N" checked> <label for="do_migrate_N">Nein</label>
-<p>Bitte geben Sie den Namen des Ziellagers für die übernommenen Daten ein.</p>
-<input name=import_warehouse size=50>
+ <p>Bitte geben Sie den Namen des Ziellagers für die übernommenen Daten ein.</p>
+ <input name="import_warehouse" size="50">
-<p>Da Lagerplätze kein Pflichtfeld sind, geben Sie bitte einen Lagerplatz an, in dem Waren ohne spezifizierten Lagerplatz eingelagert werden sollen.<p>
-<input name=bin_default size=50>
+ <p>Da Lagerplätze kein Pflichtfeld sind, geben Sie bitte einen Lagerplatz an, in dem Waren ohne spezifizierten Lagerplatz eingelagert werden sollen.<p>
-<p><input type=submit value="Weiter"></p>
+ <input name="bin_default" size="50">
+
+ <p><input type="submit" value="Weiter"></p>
+</form>
-[% USE HTML %]<div class="listtop"><translate>Warehouse MIgration</translate></div>
+[% USE HTML %]
+<div class="listtop"><translate>Warehouse Migration</translate></div>
<form action="[% script %]" method="POST">
+ <p>
+ <translate>Lx-Office is now able to manage warehouses instead of just tracking the amount of goods in your system.</translate>
+ <translate>This update will change the nature the onhand of goods is tracked.</translate>
+ <translate>As a result, the saved onhand values of the present goods can be stored into a warehouse designated by you, or will be reset for a proper warehouse tracking</translate>
+ </p>
-<p><translate>Lx-Office is now able to manage warehouses instead of just tracking the amount of goods in your system.</translate>
-<translate>This update will change the nature the onhand of goods is tracked.</translate>
-<translate>As a result, the saved onhand values of the present goods can be stored into a warehouse designated by you, or will be reset for a proper warehouse tracking</translate></p>
+ <p><translate>Do you want to store the existing onhand values into a new warehouse?</translate></p>
-<p><translate>Do you want to store the existing onhand values into a new warehouse?</translate></p>
-<input id=do_migrate_Y name=do_migrate type=radio value=Y> <label for=do_migrate_Y><translate>Yes</translate></label>
-<input id=do_migrate_N name=do_migrate type=radio value=N checked> <label for=do_migrate_N><translate>No</translate></label>
+ <input id="do_migrate_Y" name="do_migrate" type="radio" value="Y"> <label for="do_migrate_Y"><translate>Yes</translate></label>
+ <input id="do_migrate_N" name="do_migrate" type="radio" value="N" checked> <label for="do_migrate_N"><translate>No</translate></label>
-<p><translate>Please specify a description for the warehouse designated for these goods.</translate></p>
-<input name=import_warehouse size=50>
+ <p><translate>Please specify a description for the warehouse designated for these goods.</translate></p>
+ <input name="import_warehouse" size="50">
-<p><translate>Since bin is not enforced in the parts data, please specify a bin where goods without a specified bin will be put.</translate><p>
-<input name=bin_default size=50>
+ <p><translate>Since bin is not enforced in the parts data, please specify a bin where goods without a specified bin will be put.</translate><p>
-<p><input type=submit value="<translate>Continue</translate>"></p>
+ <input name="bin_default" size="50">
+
+ <p><input type="submit" value="<translate>Continue</translate>"></p>
+</form>