projekt kivitendo

use SL::DB::ShopImage;

  shop_images                    => 'shop_image',

# 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::ShopImage;

use strict;

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

use SL::DB::Helper::Sorted;

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

__PACKAGE__->make_manager_methods;

1;

  doc_storage_for_shopimages                => { type => 'text', default => 'Filesystem' },

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

# by rose_auto_create_model.pl automatically.

package SL::DB::ShopImage;

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

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

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

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

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

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

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

  thumbnail_content      => { type => 'bytea' },

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

);

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

__PACKAGE__->meta->allow_inline_column_values(1);

__PACKAGE__->meta->foreign_keys(

  file => {

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

    key_columns => { file_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::ShopImage;

use strict;

use SL::DB::MetaSetup::ShopImage;

use SL::DB::Manager::ShopImage;

use SL::DB::Helper::ActsAsList;

__PACKAGE__->meta->initialize;

__PACKAGE__->configure_acts_as_list(group_by => [qw(object_id)]);

1;

-- @tag:shopimages

-- @description: Tabelle für Shopbilder und zusätzliche Konfiguration und valid_type für Filemanagement

-- @charset: UTF-8

-- @depends: release_3_5_0 files shop_parts

-- @ignore: 0

CREATE TABLE shop_images(

  id                      SERIAL PRIMARY KEY,

  file_id                 INTEGER REFERENCES files(id) ON DELETE CASCADE,

  position                INTEGER,

  thumbnail_content       BYTEA,

  thumbnail_width         INTEGER,

  thumbnail_height        INTEGER,

  thumbnail_content_type  TEXT,

  itime                   TIMESTAMP DEFAULT now(),

  mtime                   TIMESTAMP

);

CREATE TRIGGER mtime_shop_images BEFORE UPDATE ON shop_images FOR EACH ROW EXECUTE PROCEDURE set_mtime();

ALTER TABLE defaults ADD COLUMN doc_storage_for_shopimages      text default 'Filesystem';

ALTER TABLE files

  DROP CONSTRAINT valid_type;

ALTER TABLE files

  ADD  CONSTRAINT valid_type CHECK (

             (object_type = 'credit_note'     ) OR (object_type = 'invoice'                 ) OR (object_type = 'sales_order'       )

          OR (object_type = 'sales_quotation' ) OR (object_type = 'sales_delivery_order'    ) OR (object_type = 'request_quotation' )

          OR (object_type = 'purchase_order'  ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice'  )

          OR (object_type = 'vendor'          ) OR (object_type = 'customer'                ) OR (object_type = 'part'              )

          OR (object_type = 'gl_transaction'  ) OR (object_type = 'dunning'                 ) OR (object_type = 'dunning1'          )

          OR (object_type = 'dunning2'        ) OR (object_type = 'dunning3'                ) OR (object_type = 'draft'             )

          OR (object_type = 'statement'       ) OR (object_type = 'shop_image'              )

  );

-- @tag:shopimages_2

-- @description: Umbennung der Spalten für Weite und Breite in die Weite und Breite des orginal Bildes

-- @charset: UTF-8

-- @depends: release-3.5.0 files shop_parts shopimages

-- @ignore: 0

ALTER TABLE shop_images RENAME thumbnail_width TO org_file_width;

ALTER TABLE shop_images RENAME thumbnail_height TO org_file_height;

-- @tag:shopimages_3

-- @description: Neue Spalte object_id um eine group_by Klausel zu haben für act_as_list

-- @charset: UTF-8

-- @depends: release_3_5_0 files shop_parts shopimages

-- @ignore: 0

ALTER TABLE shop_images ADD COLUMN object_id text NOT NULL;

  <tr>

    <td align="right">[% LxERP.t8('Storage Type for shopimages') %]</td>

    <td>[% L.select_tag('defaults.doc_storage_for_shopimages',

         [ [ 'None', LxERP.t8('None') ], [ 'Filesystem', LxERP.t8('Files') ],[ 'Webdav', LxERP.t8('WebDAV') ],[ 'ExtDMS', LxERP.t8('ext.DMS') ],[ 'DB', LxERP.t8('Database') ]  ],

                               default = SELF.defaults.doc_storage_for_shopimages,

                               onchange="return checkavailable_filebackend(this);") %]</td>

    <td>[% LxERP.t8('Use this storage backend for uploaded images') %]</td>

  </tr>