6 use List::MoreUtils qw(any);
9 use SL::DB::MetaSetup::Part;
10 use SL::DB::Manager::Part;
12 use SL::DB::Helper::TransNumberGenerator;
14 __PACKAGE__->meta->add_relationships(
17 class => 'SL::DB::Unit',
18 column_map => { unit => 'name' },
21 type => 'one to many',
22 class => 'SL::DB::Assembly',
23 column_map => { id => 'id' },
27 class => 'SL::DB::PartsGroup',
28 column_map => { partsgroup_id => 'id' },
32 class => 'SL::DB::PriceFactor',
33 column_map => { price_factor_id => 'id' },
36 type => 'one to many',
37 class => 'SL::DB::Price',
38 column_map => { id => 'parts_id' },
42 __PACKAGE__->meta->initialize;
44 __PACKAGE__->before_save('_before_save_set_partnumber');
46 sub _before_save_set_partnumber {
49 $self->create_trans_number if $self->partnumber eq '';
55 my $type = lc(shift || '');
56 die 'invalid type' unless $type =~ /^(?:part|service|assembly)$/;
58 return $self->type eq $type ? 1 : 0;
61 sub is_part { $_[0]->is_type('part') }
62 sub is_assembly { $_[0]->is_type('assembly') }
63 sub is_service { $_[0]->is_type('service') }
66 my ($self, $type) = @_;
68 die 'invalid type' unless $type =~ /^(?:part|service|assembly)$/;
69 $self->assembly( $type eq 'assembly' ? 1 : 0);
70 $self->inventory_accno_id($type ne 'service' ? 1 : undef);
73 return 'assembly' if $self->assembly;
74 return 'part' if $self->inventory_accno_id;
79 my ($class, %params) = @_;
80 $class->new(%params, type => 'part');
84 my ($class, %params) = @_;
85 $class->new(%params, type => 'assembly');
89 my ($class, %params) = @_;
90 $class->new(%params, type => 'service');
95 die 'not an accessor' if @_ > 1;
104 for my $class (@relations) {
105 eval "require $class";
106 return 0 if $class->_get_manager_class->get_all_count(query => [ parts_id => $self->id ]);
111 sub get_sellprice_info {
115 confess "Missing part id" unless $self->id;
117 my $object = $self->load;
119 return { sellprice => $object->sellprice,
120 price_factor_id => $object->price_factor_id };
123 sub get_ordered_qty {
125 my %result = SL::DB::Manager::Part->get_ordered_qty($self->id);
127 return $result{ $self->id };
130 sub available_units {
131 shift->unit_obj->convertible_units;
134 # autogenerated accessor is slightly off...
136 shift->buchungsgruppen(@_);
140 my ($self, %params) = @_;
142 my $date = $params{date} || DateTime->today_local;
143 my $is_sales = !!$params{is_sales};
144 my $taxzone = $params{ defined($params{taxzone}) ? 'taxzone' : 'taxzone_id' } * 1;
146 $self->{__partpriv_taxkey_information} ||= { };
147 my $tk_info = $self->{__partpriv_taxkey_information};
149 $tk_info->{$taxzone} ||= { };
150 $tk_info->{$taxzone}->{$is_sales} ||= { };
152 if (!exists $tk_info->{$taxzone}->{$is_sales}->{$date}) {
153 $tk_info->{$taxzone}->{$is_sales}->{$date} =
154 $self->get_chart(type => $is_sales ? 'income' : 'expense', taxzone => $taxzone)
156 ->get_active_taxkey($date);
159 return $tk_info->{$taxzone}->{$is_sales}->{$date};
163 my ($self, %params) = @_;
165 my $type = (any { $_ eq $params{type} } qw(income expense inventory)) ? $params{type} : croak("Invalid 'type' parameter '$params{type}'");
166 my $taxzone = $params{ defined($params{taxzone}) ? 'taxzone' : 'taxzone_id' } * 1;
168 $self->{__partpriv_get_chart_id} ||= { };
169 my $charts = $self->{__partpriv_get_chart_id};
171 $charts->{$taxzone} ||= { };
173 if (!exists $charts->{$taxzone}->{$type}) {
174 my $bugru = $self->buchungsgruppe;
175 my $chart_id = ($type eq 'inventory') ? ($self->inventory_accno_id ? $bugru->inventory_accno_id : undef)
176 : $bugru->call_sub("${type}_accno_id_${taxzone}");
178 $charts->{$taxzone}->{$type} = $chart_id ? SL::DB::Chart->new(id => $chart_id)->load : undef;
181 return $charts->{$taxzone}->{$type};
194 SL::DB::Part: Model for the 'parts' table
198 This is a standard Rose::DB::Object based model and can be used as one.
202 Although the base class is called C<Part> we usually talk about C<Articles> if
203 we mean instances of this class. This is because articles come in three
208 =item Part - a single part
210 =item Service - a part without onhand, and without inventory accounting
212 =item Assembly - a collection of both parts and services
216 These types are sadly represented by data inside the class and cannot be
217 migrated into a flag. To work around this, each C<Part> object knows what type
218 it currently is. Since the type ist data driven, there ist no explicit setting
219 method for it, but you can construct them explicitly with C<new_part>,
220 C<new_service>, and C<new_assembly>. A Buchungsgruppe should be supplied in this
221 case, but it will use the default Buchungsgruppe if you don't.
223 Matching these there are assorted helper methods dealing with types,
224 e.g. L</new_part>, L</new_service>, L</new_assembly>, L</type>,
225 L</is_type> and others.
231 =item C<new_part %PARAMS>
233 =item C<new_service %PARAMS>
235 =item C<new_assembly %PARAMS>
237 Will set the appropriate data fields so that the resulting instance will be of
238 tthe requested type. Since part of the distinction are accounting targets,
239 providing a C<Buchungsgruppe> is recommended. If none is given the constructor
240 will load a default one and set the accounting targets from it.
244 Returns the type as a string. Can be one of C<part>, C<service>, C<assembly>.
246 =item C<is_type $TYPE>
248 Tests if the current object is a part, a service or an
249 assembly. C<$type> must be one of the words 'part', 'service' or
250 'assembly' (their plurals are ok, too).
252 Returns 1 if the requested type matches, 0 if it doesn't and
253 C<confess>es if an unknown C<$type> parameter is encountered.
261 Shorthand for C<is_type('part')> etc.
263 =item C<get_sellprice_info %params>
265 Retrieves the C<sellprice> and C<price_factor_id> for a part under
266 different conditions and returns a hash reference with those two keys.
268 If C<%params> contains a key C<project_id> then a project price list
269 will be consulted if one exists for that project. In this case the
270 parameter C<country_id> is evaluated as well: if a price list entry
271 has been created for this country then it will be used. Otherwise an
272 entry without a country set will be used.
274 If none of the above conditions is met then the information from
277 =item C<get_ordered_qty %params>
279 Retrieves the quantity that has been ordered from a vendor but that
280 has not been delivered yet. Only open purchase orders are considered.
282 =item C<get_taxkey %params>
284 Retrieves and returns a taxkey object valid for the given date
285 C<$params{date}> and tax zone C<$params{taxzone}>
286 (C<$params{taxzone_id}> is also recognized). The date defaults to the
287 current date if undefined.
289 This function looks up the income (for trueish values of
290 C<$params{is_sales}>) or expense (for falsish values of
291 C<$params{is_sales}>) account for the current part. It uses the part's
292 associated buchungsgruppe and uses the fields belonging to the tax
293 zone given by C<$params{taxzone}> (range 0..3).
295 The information retrieved by the function is cached.
297 =item C<get_chart %params>
299 Retrieves and returns a chart object valid for the given type
300 C<$params{type}> and tax zone C<$params{taxzone}>
301 (C<$params{taxzone_id}> is also recognized). The type must be one of
302 the three key words C<income>, C<expense> and C<inventory>.
304 This function uses the part's associated buchungsgruppe and uses the
305 fields belonging to the tax zone given by C<$params{taxzone}> (range
308 The information retrieved by the function is cached.
312 Checks if this articke is used in orders, invoices, delivery orders or
315 =item C<buchungsgruppe BUCHUNGSGRUPPE>
317 Used to set the accounting informations from a L<SL:DB::Buchungsgruppe> object.
318 Please note, that this is a write only accessor, the original Buchungsgruppe can
319 not be retrieved from an article once set.
325 Moritz Bunkus E<lt>m.bunkus@linet-services.deE<gt>,
326 Sven Schöling E<lt>s.schoeling@linet-services.deE<gt>