projekt kivitendo

  my ($self, %params) = @_;

  $self->part( SL::DB::Part->new_parent_variant );

  $self->add;

}

  $self->action_add_service        if $::form->{part_type} eq 'service';

  $self->action_add_assembly       if $::form->{part_type} eq 'assembly';

  $self->action_add_assortment     if $::form->{part_type} eq 'assortment';

};

sub action_save {

      for @variant_property_values_lists;

    1;

  }) or do {

  };

  $self->redirect_to(

                     assembly       => t8('Edit Assembly'),

                     service        => t8('Edit Service'),

                     assortment     => t8('Edit Assortment'),

                   );

  $self->part->prices([])       unless $self->part->prices;

  $self->part->translations([]) unless $self->part->translations;

  $self->render(

    'part/form',

    %assortment_vars,

    %assembly_vars,

    %parent_variant_vars,

                     assembly       => t8('Add Assembly'),

                     service        => t8('Add Service'),

                     assortment     => t8('Add Assortment'),

                   );

  $self->render(

    'part/form',

  );

}

}

sub check_has_valid_part_type {

}

              service                     => { number_column => 'partnumber',     number_range_column => 'servicenumber',                              },

              assembly                    => { number_column => 'partnumber',     number_range_column => 'assemblynumber',                             },

              assortment                  => { number_column => 'partnumber',     number_range_column => 'assortmentnumber',                           },

            );

sub get_next_trans_number {

  order_warn_no_cusordnumber                => { type => 'boolean', default => 'false' },

  order_warn_no_deliverydate                => { type => 'boolean', default => 'true' },

  p_reclamation_record_number               => { type => 'text', default => '0', not_null => 1 },

  parts_image_css                           => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' },

  parts_listing_image                       => { type => 'boolean', default => 'true' },

  parts_show_image                          => { type => 'boolean', default => 'true' },

  transit_items_chart_id                    => { type => 'integer' },

  transport_cost_reminder_article_number_id => { type => 'integer' },

  undo_transfer_interval                    => { type => 'integer', default => 7 },

  vc_greetings_use_textfield                => { type => 'boolean' },

  vendor_ustid_taxnummer_unique             => { type => 'boolean', default => 'false' },

  vendornumber                              => { type => 'text' },

  obsolete           => { type => 'boolean', default => 'false', not_null => 1 },

  onhand             => { type => 'numeric', default => '0', precision => 25, scale => 5 },

  order_qty          => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 },

  partnumber         => { type => 'text', not_null => 1 },

  partsgroup_id      => { type => 'integer' },

  payment_id         => { type => 'integer' },

  stockable          => { type => 'boolean', default => 'false' },

  tariff_code        => { type => 'text' },

  unit               => { type => 'varchar', length => 20, not_null => 1 },

  ve                 => { type => 'integer' },

  warehouse_id       => { type => 'integer' },

  weight             => { type => 'float', precision => 4, scale => 4 },

  id                  => { type => 'serial', not_null => 1 },

  itime               => { type => 'timestamp', default => 'now()' },

  mtime               => { type => 'timestamp' },

  value               => { type => 'text', not_null => 1 },

  variant_property_id => { type => 'integer', not_null => 1 },

);

use Carp;

use List::MoreUtils qw(any uniq);

use Rose::DB::Object::Helpers qw(as_tree);

use SL::Locale::String qw(t8);

sub is_assembly       { $_[0]->part_type eq 'assembly'   }

sub is_service        { $_[0]->part_type eq 'service'    }

sub is_assortment     { $_[0]->part_type eq 'assortment' }

sub type { return $_[0]->part_type; }

sub new_parent_variant {

  my ($class, %params) = @_;

}

sub last_modification {

    die "Given variant_property_values dosn't match the variant_properties of parent_variant part";

  }

  my $new_variant = $self->clone_and_reset;

  return $new_variant;

}

sub variant_value {

  my ($self, $variant_property) = @_;

  my %property_id_to_values =

    map {$_->variant_property_id => $_}

    $form->{l_assembly}       = 1 if $form->{searchitems} eq 'assembly'       || $form->{searchitems} eq '';

    $form->{l_part}           = 1 if $form->{searchitems} eq 'part'           || $form->{searchitems} eq '';

    $form->{l_assortment}     = 1 if $form->{searchitems} eq 'assortment'     || $form->{searchitems} eq '';

    push @where_tokens, "p.partnumber ILIKE ? OR p.description ILIKE ?";

    push @bind_vars,    (like($form->{all})) x 2;

  }

  # Oder Bedingungen fuer Ware Dienstleistung Erzeugnis:

  if (   $form->{l_part}           || $form->{l_assembly}

      || $form->{l_service}        || $form->{l_assortment}

    ) {

    my @or_tokens = ();

    push @or_tokens, "p.part_type = 'service'"        if $form->{l_service};

    push @or_tokens, "p.part_type = 'assembly'"       if $form->{l_assembly};

    push @or_tokens, "p.part_type = 'part'"           if $form->{l_part};

    push @or_tokens, "p.part_type = 'assortment'"     if $form->{l_assortment};

    push @where_tokens, join ' OR ', map { "($_)" } @or_tokens;

  }

  else {

    assembly       => t8('Assembly (typeabbreviation)'),

    assortment     => t8('Assortment (typeabbreviation)'),

    service        => t8('Service (typeabbreviation)'),

    parent_variant => t8('Parent Variant (typeabbreviation)'),

    variant        => t8('Variant (typeabbreviation)'),

  );

}

#

    $filters{table}         = "oe";

    $filters{where}         = 'COALESCE(quotation, FALSE) AND (vendor_id IS NOT NULL)';

    $filters{trans_number}  = "partnumber";

    my %numberfield_hash = ( service        => 'servicenumber',

                             assembly       => 'assemblynumber',

                             assortment     => 'assortmentnumber',

                             part           => 'articlenumber'

                           );

    $filters{numberfield}   = $numberfield_hash{$type};

  name: Add Parent Variant

  order: 575

  access: part_service_assembly_edit

  params:

    action: Part/add_parent_variant

- parent: master_data

  id: master_data_add_project

  name: Add Project

-- @depends: release_3_8_0

-- @ignore: 0

CREATE TABLE parts_parent_variant_id_parts_variant_id (

  parent_variant_id INTEGER NOT NULL        REFERENCES parts(id),

  name         TEXT       NOT NULL,

  unique_name  TEXT       NOT NULL UNIQUE,

  abbreviation VARCHAR(4) NOT NULL,

  itime        TIMESTAMP DEFAULT now(),

  mtime        TIMESTAMP

);

  variant_property_id INTEGER NOT NULL REFERENCES variant_properties(id),

  value               TEXT    NOT NULL,

  abbreviation        VARCHAR(4) NOT NULL,

  itime               TIMESTAMP DEFAULT now(),

  mtime               TIMESTAMP

);

      <td>[% L.input_tag("defaults.assortmentnumber", SELF.defaults.assortmentnumber, size="15", class="wi-normal") %]</td>

      [% END %]

    </tr>

  </tbody>

</table>

            <input name="l_assortment" id="l_assortment" type="checkbox" value="Y" checked>

            <label for="l_assortment"> [% 'Assortment' | $T8 %] </label>

          [% END %]

        </td>

      </tr>

      <tr>

[% INCLUDE 'common/flash.html' %]

[% L.hidden_tag('part.id'          , SELF.part.id) %]

[% L.hidden_tag('last_modification', SELF.part.last_modification) %]

[% L.hidden_tag('callback'         , FORM.callback) %]

  <tr>

   <td align="right" nowrap>[% LxERP.t8('Last Purchase Delivery Order Number') %]</td>

   <td>[% L.input_tag("defaults.pdonumber", SELF.defaults.pdonumber, size="15") %]</td>

  </tr>

  <tr>

   <td align="right" nowrap>[% LxERP.t8('Last Supplier Delivery Order Number') %]</td>

   <td>[% L.input_tag("defaults.sudonumber", SELF.defaults.sudonumber, size="15") %]</td>

  </tr>

  <tr>

 <form method="post" id="ic" name="ic" action="controller.pl">

  [% L.hidden_tag('part.id'          , SELF.part.id) %]

  [% L.hidden_tag('last_modification', SELF.part.last_modification) %]

  [% L.hidden_tag('callback'         , FORM.callback) %]