projekt kivitendo

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

use strict;

use SL::DB::MetaSetup::Cleared;

use SL::DB::Manager::Cleared;

__PACKAGE__->meta->initialize;

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::ClearedGroup;

use strict;

use SL::DB::MetaSetup::ClearedGroup;

use SL::DB::Manager::ClearedGroup;

__PACKAGE__->meta->initialize;

1;

use SL::DB::Cleared;

use SL::DB::ClearedGroup;

  cleared                        => 'cleared',

  cleared_group                  => 'ClearedGroup',

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

use strict;

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

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

__PACKAGE__->make_manager_methods;

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::Manager::ClearedGroup;

use strict;

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

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

__PACKAGE__->make_manager_methods;

1;

  clearing       => { type => 'boolean', default => 'false', not_null => 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::Cleared;

use strict;

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

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

__PACKAGE__->meta->columns(

  acc_trans_id     => { type => 'bigint', not_null => 1 },

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

);

__PACKAGE__->meta->primary_key_columns([ 'cleared_group_id', 'acc_trans_id' ]);

__PACKAGE__->meta->unique_keys(

  [ 'acc_trans_id' ],

  [ 'acc_trans_id', 'cleared_group_id' ],

);

__PACKAGE__->meta->foreign_keys(

  acc_transaction => {

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

    key_columns => { acc_trans_id => 'acc_trans_id' },

    rel_type    => 'one to one',

  },

  cleared_group => {

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

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

  },

);

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::ClearedGroup;

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

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

);

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

__PACKAGE__->meta->allow_inline_column_values(1);

__PACKAGE__->meta->foreign_keys(

  employee => {

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

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

  },

);

1;

;

-- @tag: charts_cleared

-- @description: Ausziffern für Konten ermöglichen

-- @depends: release_3_8_0

-- @ignore: 0

CREATE TABLE cleared_group (

  id SERIAL PRIMARY KEY,

  employee_id INTEGER NOT NULL REFERENCES employee(id),

  itime timestamp DEFAULT now()

);

-- deleting an acc_trans record shouldn't be possible unless all cleared entries have been deleted

-- deleting the cleared_group should remove all cleared entries

CREATE TABLE cleared (

  acc_trans_id      bigint UNIQUE NOT NULL REFERENCES acc_trans(acc_trans_id),

  cleared_group_id  int    NOT NULL REFERENCES cleared_group(id) ON DELETE CASCADE,

  primary key (cleared_group_id, acc_trans_id)

);

-- which charts should be activated for clearing

ALTER TABLE chart ADD COLUMN clearing BOOLEAN DEFAULT false NOT NULL;