projekt kivitendo

use SL::DB::ShopPart;

  shop_parts                     => 'shop_part',

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::Manager::ShopPart;

use strict;

use SL::DB::Helper::Manager;

use base qw(SL::DB::Helper::Manager);

sub object_class { 'SL::DB::ShopPart' }

__PACKAGE__->make_manager_methods;

1;

# This file has been auto-generated. Do not modify it; it will be overwritten

# by rose_auto_create_model.pl automatically.

package SL::DB::ShopPart;

use strict;

use base qw(SL::DB::Object);

__PACKAGE__->meta->table('shop_parts');

__PACKAGE__->meta->columns(

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

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

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

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

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

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

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

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

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

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

  show_date        => { type => 'date' },

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

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

__PACKAGE__->meta->unique_keys([ 'shop_id', 'part_id' ]);

__PACKAGE__->meta->allow_inline_column_values(1);

__PACKAGE__->meta->foreign_keys(

  part => {

    class       => 'SL::DB::Part',

    key_columns => { part_id => 'id' },

  },

  shop => {

    class       => 'SL::DB::Shop',

    key_columns => { shop_id => 'id' },

  },

);

1;

;

# This file has been auto-generated only because it didn't exist.

# Feel free to modify it at will; it will not be overwritten automatically.

package SL::DB::ShopPart;

use strict;

use SL::DB::MetaSetup::ShopPart;

use SL::DB::Manager::ShopPart;

__PACKAGE__->meta->initialize;

1;

  # if ( $form->{shop} ) { # && $previous_values->{"shop_part_id"} ) {

  #   my $part = SL::DB::Manager::Part->find_by( id  => $form->{"id"} );

  #   die "no part" unless $part;

  #   my %shophash = map { ( $_ =~ m/^shop_(.*)/ ) => $form->{$_} }  grep { $_ =~ /^shop_/ } keys %$::form;

  #   delete $shophash{show_date} unless $shophash{show_date};

  #   delete $shophash{sortorder} unless $shophash{sortorder};

  #

  #   my $shop_part;

  #   if ( $part->shop_part ) {

  #     # update existing shop_port

  #     $shop_part = $part->shop_part;

  #     foreach ( keys %shophash ) {

  #       $shop_part->$_( $shophash{$_} );

  #     };

  #   } else {

  #     # shop_part didn't exist yet

  #     $shop_part = SL::DB::ShopPart->new( %shophash )->save;

  #     $part->shop_part_id( $shop_part->id );

  #     $part->save;

  #   };

  #   # TODO: make part of request

  #   $shop_part->save;

  # };

-- @tag: shop_parts

-- @description: Add tables for part information for shop

-- @charset: UTF-8

-- @depends: release_3_3_0 shops

-- @ignore: 0

CREATE TABLE shop_parts (

  id               SERIAL PRIMARY KEY,

  shop_id          INTEGER REFERENCES shops(id),

  part_id          INTEGER REFERENCES parts(id),

  shop_description TEXT,

  itime            TIMESTAMP DEFAULT now(),

  mtime            TIMESTAMP,

  last_update      TIMESTAMP,

  show_date        DATE,   -- the starting date for displaying part in shop

  sortorder        INTEGER,

  front_page       BOOLEAN NOT NULL DEFAULT false,

  active           BOOLEAN NOT NULL DEFAULT false,  -- rather than obsolete

  shop_category    TEXT,

  UNIQUE (part_id, shop_id)  -- make sure a shop_part appears only once per shop and part

);

CREATE TRIGGER mtime_shop_parts BEFORE UPDATE ON shop_parts

    FOR EACH ROW EXECUTE PROCEDURE set_mtime();

-- CREATE TABLE shop_meta_tags (

-- id integer NOT NULL DEFAULT nextval('shop_parts_id'),

 --  description

-- );

-- CREATE TABLE shop_categories (

-- );

[%- IF shop %]

 [% PROCESS 'ic/tabs/_shop.html' %]

[%- END %]

    [%- IF shop %]

    <li><a href="#shop_variables">[% 'Shop variables' | $T8 %]</a></li>

    [%- END %]

[%- USE HTML %][%- USE L -%][%- USE P -%][%- USE LxERP -%]

<div id="shop_variables">

 <table>

  <tr>

   <td>[% LxERP.t8("Description") %]</td>

   <td>[% L.textarea_tag("shop_shop_description", shop_part.shop_description) %]</td>

  </tr>

  <tr>

   <td>[% LxERP.t8("Sort order") %]</td>

   <td>[% L.input_tag("shop_sortorder", shop_part.sortorder, size=2) %]</td>

  </tr>

  <tr>

   <td>[% LxERP.t8("Date") %]</td>

   <td>[% L.date_tag("shop_show_date", shop_part.show_date) %]</td>

  </tr>

  <tr>

   <td>[% LxERP.t8("Front page") %]</td>

   <td>[% L.yes_no_tag('shop_front_page', shop_part.front_page) %]</td>

  </tr>

  </tr>

</table>

[% # L.dump(shop_part) %]

</div>