projekt kivitendo

use SL::DB::ShopOrder;

use SL::DB::ShopOrderItem;

  shop_orders                    => 'shop_order',

  shop_order_items               => 'shop_order_item',

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

use strict;

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

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

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

__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::ShopOrderItem;

use strict;

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

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

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

__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::ShopOrder;

use strict;

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

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

__PACKAGE__->meta->columns(

  amount                 => { type => 'numeric', precision => 15, scale => 5 },

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  netamount              => { type => 'numeric', precision => 15, scale => 5 },

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

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

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

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

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

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

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

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

  shipping_costs         => { type => 'numeric', precision => 15, scale => 5 },

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

  shipping_costs_net     => { type => 'numeric', precision => 15, scale => 5 },

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

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

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

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

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

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

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

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

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

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

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

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

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

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

);

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

__PACKAGE__->meta->allow_inline_column_values(1);

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

use strict;

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

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

__PACKAGE__->meta->columns(

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

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

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

  price         => { type => 'numeric', precision => 15, scale => 5 },

  quantity      => { type => 'numeric', precision => 25, scale => 5 },

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

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

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

  tax_rate      => { type => 'numeric', precision => 15, scale => 2 },

);

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

__PACKAGE__->meta->foreign_keys(

  shop_order => {

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

    key_columns => { shop_order_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::ShopOrder;

use strict;

use SL::DB::MetaSetup::ShopOrder;

use SL::DB::Manager::ShopOrder;

__PACKAGE__->meta->add_relationships(

  shop_order_items => {

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

    column_map => { id => 'shop_order_id' },

    type       => 'one to many',

  },

);

__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::ShopOrderItem;

use strict;

use SL::DB::MetaSetup::ShopOrderItem;

use SL::DB::Manager::ShopOrderItem;

__PACKAGE__->meta->initialize;

1;

use SL::ShopConnector::ALL;

-- @tag: shop_orders

-- @description: Erstellen der Tabellen shop_orders und shop_order_items

-- @depends: release_3_3_0

CREATE TABLE shop_orders (

  id SERIAL PRIMARY KEY,

  shop_trans_id integer NOT NULL, --id vom shop

  shop_ordernumber TEXT, --Bestellnummer vom Shop

  shop_data text,        -- store whole order as json

  shop_customer_comment text, --Bestellkommentar des Kunden

  amount numeric(15,5),  --Bruttogesamtbetrag

  netamount numeric(15,5),--Nettogesamtbetrag

  order_date timestamp, --Bestelldatum und Zeit

  shipping_costs numeric(15,5),

  shipping_costs_net numeric(15,5),

  shipping_costs_id integer,

  tax_included boolean,

  payment_id integer, --Bezahlart

  payment_description TEXT,  --Bezahlart

  shop_id integer,               --welcher shop bei mehreren

  host TEXT,             --Hostname vom Shop

  remote_ip text,        --IP Besteller

  transferred boolean DEFAULT FALSE,    -- übernommen 

  transfer_date date, -- Zeit wann übernommen

  kivi_customer_id integer,  -- Kundenid von Tbl customer wenn übernommen

  oe_transid integer,  -- id to 

-- Bestell-, Rechnungs- und Lieferadresse. !!Manche Shops bieten sowas!!

-- In der Regel ist aber die Rechnungsadresse die Kundenadresse

  -- Bestelldaten des Kunden

  shop_customer_id integer,

  shop_customer_number TEXT,

  customer_lastname TEXT,

  customer_firstname TEXT,

  customer_company TEXT,

  customer_street TEXT,

  customer_zipcode TEXT,

  customer_city TEXT,

  customer_country TEXT,

  customer_greeting TEXT,

  customer_department TEXT,

  customer_vat TEXT,

  customer_phone TEXT,

  customer_fax TEXT,

  customer_email TEXT,

  customer_newsletter boolean,

  -- Rechnungsadresse

  shop_c_billing_id integer,

  shop_c_billing_number TEXT,

  billing_lastname TEXT,

  billing_firstname TEXT,

  billing_company TEXT,

  billing_street TEXT,

  billing_zipcode TEXT,

  billing_city TEXT,

  billing_country TEXT,

  billing_greeting TEXT,

  billing_department TEXT,

  billing_vat TEXT,

  billing_phone TEXT,

  billing_fax TEXT,

  billing_email TEXT,

  -- SEPA

  sepa_account_holder TEXT,

  sepa_iban TEXT,

  sepa_bic TEXT,

  -- Lieferadresse

  shop_c_delivery_id integer,

  shop_c_delivery_number TEXT,

  delivery_lastname TEXT,

  delivery_firstname TEXT,

  delivery_company TEXT,

  delivery_street TEXT,

  delivery_zipcode TEXT,

  delivery_city TEXT,

  delivery_country TEXT,

  delivery_greeting TEXT,

  delivery_department TEXT,

  delivery_vat TEXT,

  delivery_phone TEXT,

  delivery_fax TEXT,

  delivery_email TEXT,

  itime timestamp DEFAULT now(),

  mtime timestamp

);

CREATE TABLE shop_order_items (

  id            SERIAL PRIMARY KEY,

  shop_trans_id INTEGER NOT NULL, --id vom shop in shop-db? -> could use $order_item->shop_order->shop_trans_id instead

  shop_order_id INTEGER REFERENCES shop_orders (id) ON DELETE CASCADE,

  description   TEXT,  -- Artikelbezeichnung

  partnumber    TEXT,

  shop_id       INTEGER,  --kann als Sortorder benutzt werden

  tax_rate      NUMERIC(15,2),

  quantity      NUMERIC(25,5),   -- qty in invoice and orderitems is real, doi is numeric(25,5)

  price         NUMERIC(15,5)

);