Revision 2f5363d2
Von Moritz Bunkus vor etwa 2 Jahren hinzugefügt
SL/Controller/Order.pm | ||
---|---|---|
sort_by => 'name');
|
||
$self->{all_payment_terms} = SL::DB::Manager::PaymentTerm->get_all_sorted(where => [ or => [ id => $self->order->payment_id,
|
||
obsolete => 0 ] ]);
|
||
$self->{all_delivery_terms} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
|
||
$self->{all_delivery_terms} = SL::DB::Manager::DeliveryTerm->get_valid($self->order->delivery_term_id);
|
||
$self->{all_statuses} = SL::DB::Manager::OrderStatus->get_all_sorted(where => [ or => [ id => $self->order->order_status_id,
|
||
obsolete => 0, ] ] );
|
||
$self->{current_employee_id} = SL::DB::Manager::Employee->current->id;
|
SL/DB/Manager/DeliveryTerm.pm | ||
---|---|---|
});
|
||
}
|
||
|
||
sub get_valid {
|
||
my ($class, $with_this_id) = @_;
|
||
|
||
my @conditions = (obsolete => 0);
|
||
|
||
if ($with_this_id) {
|
||
@conditions = (
|
||
or => [
|
||
id => $with_this_id,
|
||
@conditions,
|
||
]);
|
||
}
|
||
|
||
return $class->get_all_sorted(query => \@conditions);
|
||
}
|
||
|
||
1;
|
SL/DB/MetaSetup/DeliveryTerm.pm | ||
---|---|---|
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
||
itime => { type => 'timestamp', default => 'now()' },
|
||
mtime => { type => 'timestamp' },
|
||
obsolete => { type => 'boolean', default => 'false', not_null => 1 },
|
||
sortkey => { type => 'integer', not_null => 1 },
|
||
);
|
||
|
bin/mozilla/do.pl | ||
---|---|---|
]);
|
||
|
||
$::form->{ALL_PROJECTS} = SL::DB::Manager::Project->get_all_sorted(query => \@conditions);
|
||
$::form->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
|
||
$::form->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_valid($::form->{delivery_term_id});
|
||
$::form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{employee_id}, deleted => 0 ] ]);
|
||
$::form->{ALL_SALESMEN} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{salesman_id}, deleted => 0 ] ]);
|
||
$::form->{ALL_SHIPTO} = SL::DB::Manager::Shipto->get_all_sorted(query => [
|
bin/mozilla/ir.pl | ||
---|---|---|
"price_factors" => "ALL_PRICE_FACTORS");
|
||
|
||
$TMPL_VAR->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all_sorted;
|
||
$TMPL_VAR->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
|
||
$TMPL_VAR->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_valid($::form->{delivery_term_id});
|
||
$TMPL_VAR->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ or => [ id => $::form->{employee_id}, deleted => 0 ] ]);
|
||
$TMPL_VAR->{ALL_CONTACTS} = SL::DB::Manager::Contact->get_all_sorted(query => [
|
||
or => [
|
bin/mozilla/is.pl | ||
---|---|---|
|
||
$form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all_sorted;
|
||
$form->{ALL_LANGUAGES} = SL::DB::Manager::Language->get_all_sorted;
|
||
$form->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
|
||
$form->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_valid($form->{delivery_term_id});
|
||
|
||
# Projects
|
||
my @old_project_ids = uniq grep { $_ } map { $_ * 1 } ($form->{"globalproject_id"}, map { $form->{"project_id_$_"} } 1..$form->{"rowcount"});
|
bin/mozilla/oe.pl | ||
---|---|---|
]);
|
||
|
||
$TMPL_VAR->{ALL_PROJECTS} = SL::DB::Manager::Project->get_all_sorted(query => \@conditions);
|
||
$TMPL_VAR->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_all_sorted();
|
||
$TMPL_VAR->{ALL_DELIVERY_TERMS} = SL::DB::Manager::DeliveryTerm->get_valid($form->{delivery_term_id});
|
||
$form->{ALL_PROJECTS} = $TMPL_VAR->{ALL_PROJECTS}; # make projects available for second row drop-down in io.pl
|
||
|
||
# label subs
|
sql/Pg-upgrade2/delivery_terms_markable_as_obsolete.sql | ||
---|---|---|
-- @tag: delivery_terms_markable_as_obsolete
|
||
-- @description: Lieferbedingungenals ungültig markierbar
|
||
-- @depends: release_3_7_0
|
||
ALTER TABLE delivery_terms
|
||
ADD COLUMN obsolete BOOLEAN NOT NULL DEFAULT FALSE;
|
templates/webpages/delivery_term/form.html | ||
---|---|---|
</td>
|
||
</tr>
|
||
[%- END %]
|
||
|
||
<tr>
|
||
<td>[% 'Obsolete' | $T8 %]</td>
|
||
<td>[% L.checkbox_tag('delivery_term.obsolete', checked=SELF.delivery_term.obsolete, for_submit=1) %]</td>
|
||
</tr>
|
||
</table>
|
||
|
||
[% P.hidden_tag("id", SELF.delivery_term.id) %]
|
templates/webpages/delivery_term/list.html | ||
---|---|---|
<th align="center"><img src="image/updown.png" alt="[%- LxERP.t8('reorder item') %]"></th>
|
||
<th>[%- 'Description' | $T8 %]</th>
|
||
<th>[%- 'Long Description' | $T8 %]</th>
|
||
<th>[%- 'Obsolete' | $T8 %]</th>
|
||
</tr>
|
||
</thead>
|
||
|
||
... | ... | |
</a>
|
||
</td>
|
||
<td>[%- HTML.escape(delivery_term.description_long) %]</td>
|
||
<td>[% IF delivery_term.obsolete %][% LxERP.t8("yes") %][% ELSE %][% LxERP.t8("no") %][% END %]</td>
|
||
</tr>
|
||
[%- END %]
|
||
</tbody>
|
Auch abrufbar als: Unified diff
Lieferbedingungen ungültig markieren können