Christopher H. Laco > Handel-Storage-RDBO-1.00003 > Handel::Schema::RDBO::Order

Download:
Handel-Storage-RDBO-1.00003.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

NAME ^

Handel::Schema::RDBO::Order - RDBO schema class for order table

SYNOPSIS ^

    use Handel::Schema::RDBO::Order;
    use strict;
    use warnings;

    my $order = Handel::Schema::RDBO::Order->new(id => '12345678-9098-7654-3212-345678909876');
    $order->load;

DESCRIPTION ^

Handel::Schema::RDBO::Order is loaded by Handel::Storage::RDBO::Order to read/write data to the order table.

COLUMNS ^

id

Contains the primary key for each order record. By default, this is a uuid string.

    id => {type => 'varchar', primary_key => 1, length => 36, not_null => 1},

shopper

Contains the keys used to tie each order to a specific shopper. By default, this is a uuid string.

    shopper => {type => 'varchar', length => 36, not_null => 1},

type

Contains the type for this order. The current values are ORDER_TYPE_TEMP and ORDER_TYPE_SAVED from Handel::Constants.

    type => {type => 'boolean', default => 0, not_null => 1},

number

The order number for this order.

    number => {type => 'varchar', length => 20, not_null => 0},

created

The date this order record was created.

    created => {type => 'datetime', not_null => 0},

updated

The date this order record was last updated.

    updated => {type => 'datetime', not_null => 0},

comments

Any user comments for this order.

    comments => {type => 'varchar', length => 100, not_null => 0},

shipmethod

The shipping method for this order.

    shipmethod => {type => 'varchar', length => 20, not_null => 0},

shipping

The shipping cost for this order.

    shipping => {type => 'decimal', precision => 9, scale => 2, default => 0, not_null => 1},

handling

The handling charge for this order.

    handling => {type => 'decimal', precision => 9, scale => 2, default => 0, not_null => 1},

tax

The tax amount for this order.

    tax => {type => 'decimal', precision => 9, scale => 2, default => 0, not_null => 1},

subtotal

The subtotal of all the items on this order.

    subtotal => {type => 'decimal', precision => 9, scale => 2, default => 0, not_null => 1},

total

The total cost of the current order.

    total => {type => 'decimal', precision => 9, scale => 2, default => 0, not_null => 1},

billtofirstname

The first name for the billing address for this order.

    billtofirstname => {type => 'varchar', length => 25, not_null => 0},

billtolastname

The last name for the billing address for this order.

    billtolastname => {type => 'varchar', length => 25, not_null => 0},

billtoaddress1

The billing address line 1 for this order.

    billtoaddress1 => {type => 'varchar', length => 50, not_null => 0},

billtoaddress2

The billing address line 2 for this order.

    billtoaddress2 => {type => 'varchar', length => 50, not_null => 0},

billtoaddress3

The billing address line 3 for this order.

    billtoaddress3 => {type => 'varchar', length => 50, not_null => 0},

billtocity

The billing address city for this order.

    billtocity => {type => 'varchar', length => 50, not_null => 0},

billtostate

The billing address state/province for this order.

    billtostate => {type => 'varchar', length => 50, not_null => 0},

billtozip

The billing address zip/postal code for this order.

    billtozip => {type => 'varchar', length => 10, not_null => 0},

billtocountry

The billing address country for this order.

    billtocountry => {type => 'varchar', length => 25, not_null => 0},

billtodayphone

The billing address daytime phone number for this order.

    billtodayphone => {type => 'varchar', length => 25, not_null => 0},

billtonightphone

The billing address night time phone number for this order.

    billtonightphone => {type => 'varchar', length => 25, not_null => 0},

billtofax

The billing address fax number for this order.

    billtofax => {type => 'varchar', length => 25, not_null => 0},

billtoemail

The billing address email address for this order.

    billtoemail => {type => 'varchar', length => 50, not_null => 0},

shiptosameasbillto

When set to true, the shipping address is the same as the billing address.

    shiptosameasbillto => {type => 'boolean', default => 0, not_null => 1},

shiptofirstname

The first name for the shipping address for this order.

    shiptofirstname => {type => 'varchar', length => 25, not_null => 0},

shiptolastname

The last name for the shipping address for this order.

    shiptolastname => {type => 'varchar', length => 25, not_null => 0},

shiptoaddress1

The shipping address line 1 for this order.

    shiptoaddress1 => {type => 'varchar', length => 50, not_null => 0},

shiptoaddress2

The shipping address line 2 for this order.

    shiptoaddress2 => {type => 'varchar', length => 50, not_null => 0},

shiptoaddress3

The shipping address line 3 for this order.

    shiptoaddress3 => {type => 'varchar', length => 50, not_null => 0},

shiptocity

The shipping address city for this order.

    shiptocity => {type => 'varchar', length => 50, not_null => 0},

shiptostate

The shipping address state/province for this order.

    shiptostate => {type => 'varchar', length => 50, not_null => 0},

shiptozip

The shipping address zip/postal code for this order.

    shiptozip => {type => 'varchar', length => 10, not_null => 0},

shiptocountry

The shipping address country for this order.

    shiptocountry => {type => 'varchar', length => 25, not_null => 0},

shiptodayphone

The shipping address daytime phone number for this order.

    shiptodayphone => {type => 'varchar', length => 25, not_null => 0},

shiptonightphone

The shipping address night time phone number for this order.

    shiptonightphone => {type => 'varchar', length => 25, not_null => 0},

shiptofax

The shipping address fax number for this order.

    shiptofax => {type => 'varchar', length => 25, not_null => 0},

shiptoemail

The shipping address email address for this order.

    shiptoemail => {type => 'varchar', length => 50, not_null => 0}

SEE ALSO ^

Handel::Schema::RDBO::Order::Item, Rose::DB::Object

AUTHOR ^

    Christopher H. Laco
    CPAN ID: CLACO
    claco@chrislaco.com
    http://today.icantfocus.com/blog/
syntax highlighting: