Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 3a7d0b6b

Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt

  • ID 3a7d0b6be7c5b679e8b2a00d326998a39c6e0529
  • Vorgänger 0550e83a
  • Nachfolger f3889750

Reste der Tabellen "rma" und "rmaitems" entfernt

Behebt #2204.

Unterschiede anzeigen:

SL/DB/Helper/ALL.pm
65 65
use SL::DB::Printer;
66 66
use SL::DB::Project;
67 67
use SL::DB::PurchaseInvoice;
68
use SL::DB::RMA;
69
use SL::DB::RMAItem;
70 68
use SL::DB::RecordLink;
71 69
use SL::DB::SchemaInfo;
72 70
use SL::DB::SepaExport;
SL/DB/Helper/Mappings.pm
92 92
  pricegroup                     => 'pricegroup',
93 93
  printers                       => 'Printer',
94 94
  record_links                   => 'record_link',
95
  rma                            => 'RMA',
96
  rmaitems                       => 'RMA_item',
97 95
  sepa_export                    => 'sepa_export',
98 96
  sepa_export_items              => 'sepa_export_item',
99 97
  schema_info                    => 'schema_info',
SL/DB/Manager/Project.pm
18 18
  delivery_orders => 'global',
19 19
);
20 20

  
21
our @tables_with_project_id_cols = qw(acc_trans ap ar delivery_order_items delivery_orders invoice oe orderitems rmaitems);
21
our @tables_with_project_id_cols = qw(acc_trans ap ar delivery_order_items delivery_orders invoice oe orderitems);
22 22

  
23 23
sub _sort_spec {
24 24
  return (
SL/DB/MetaSetup/RMA.pm
1
# This file has been auto-generated. Do not modify it; it will be overwritten
2
# by rose_auto_create_model.pl automatically.
3
package SL::DB::RMA;
4

  
5
use strict;
6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'rma',
11

  
12
  columns => [
13
    id                   => { type => 'integer', not_null => 1, sequence => 'id' },
14
    rmanumber            => { type => 'text', not_null => 1 },
15
    transdate            => { type => 'date', default => 'now' },
16
    vendor_id            => { type => 'integer' },
17
    customer_id          => { type => 'integer' },
18
    amount               => { type => 'numeric', precision => 5, scale => 15 },
19
    netamount            => { type => 'numeric', precision => 5, scale => 15 },
20
    reqdate              => { type => 'date' },
21
    taxincluded          => { type => 'boolean' },
22
    shippingpoint        => { type => 'text' },
23
    notes                => { type => 'text' },
24
    curr                 => { type => 'text' },
25
    employee_id          => { type => 'integer' },
26
    closed               => { type => 'boolean', default => 'false' },
27
    quotation            => { type => 'boolean', default => 'false' },
28
    quonumber            => { type => 'text' },
29
    cusrmanumber         => { type => 'text' },
30
    intnotes             => { type => 'text' },
31
    delivery_customer_id => { type => 'integer' },
32
    delivery_vendor_id   => { type => 'integer' },
33
    language_id          => { type => 'integer' },
34
    payment_id           => { type => 'integer' },
35
    department_id        => { type => 'integer', default => '0' },
36
    itime                => { type => 'timestamp', default => 'now()' },
37
    mtime                => { type => 'timestamp' },
38
    shipvia              => { type => 'text' },
39
    cp_id                => { type => 'integer' },
40
  ],
41

  
42
  primary_key_columns => [ 'id' ],
43

  
44
  allow_inline_column_values => 1,
45
);
46

  
47
1;
48
;
SL/DB/MetaSetup/RMAItem.pm
1
# This file has been auto-generated. Do not modify it; it will be overwritten
2
# by rose_auto_create_model.pl automatically.
3
package SL::DB::RMAItem;
4

  
5
use strict;
6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'rmaitems',
11

  
12
  columns => [
13
    trans_id      => { type => 'integer' },
14
    parts_id      => { type => 'integer' },
15
    description   => { type => 'text' },
16
    qty           => { type => 'float', precision => 4 },
17
    base_qty      => { type => 'float', precision => 4 },
18
    sellprice     => { type => 'numeric', precision => 5, scale => 15 },
19
    discount      => { type => 'float', precision => 4 },
20
    project_id    => { type => 'integer' },
21
    reqdate       => { type => 'date' },
22
    ship          => { type => 'float', precision => 4 },
23
    serialnumber  => { type => 'text' },
24
    id            => { type => 'integer', not_null => 1, sequence => 'orderitemsid' },
25
    itime         => { type => 'timestamp', default => 'now()' },
26
    mtime         => { type => 'timestamp' },
27
    pricegroup_id => { type => 'integer' },
28
    rmanumber     => { type => 'text' },
29
    transdate     => { type => 'text' },
30
    cusrmanumber  => { type => 'text' },
31
    unit          => { type => 'varchar', length => 20 },
32
  ],
33

  
34
  primary_key_columns => [ 'id' ],
35

  
36
  allow_inline_column_values => 1,
37

  
38
  foreign_keys => [
39
    parts => {
40
      class       => 'SL::DB::Part',
41
      key_columns => { parts_id => 'id' },
42
    },
43
  ],
44
);
45

  
46
1;
47
;
SL/DB/Part.pm
97 97
    SL::DB::InvoiceItem
98 98
    SL::DB::OrderItem
99 99
    SL::DB::Inventory
100
    SL::DB::RMAItem
101 100
  );
102 101

  
103 102
  for my $class (@relations) {
SL/DB/RMA.pm
1
# This file has been auto-generated only because it didn't exist.
2
# Feel free to modify it at will; it will not be overwritten automatically.
3

  
4
package SL::DB::RMA;
5

  
6
use strict;
7

  
8
use SL::DB::MetaSetup::RMA;
9

  
10
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
11
__PACKAGE__->meta->make_manager_class;
12

  
13
1;
SL/DB/RMAItem.pm
1
# This file has been auto-generated only because it didn't exist.
2
# Feel free to modify it at will; it will not be overwritten automatically.
3

  
4
package SL::DB::RMAItem;
5

  
6
use strict;
7

  
8
use SL::DB::MetaSetup::RMAItem;
9

  
10
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
11
__PACKAGE__->meta->make_manager_class;
12

  
13
1;

Auch abrufbar als: Unified diff