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

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

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

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

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},

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},

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},

The order number for this order.

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

The date this order record was created.

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

The date this order record was last updated.

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

Any user comments for this order.

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

The shipping method for this order.

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

The shipping cost for this order.

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

The handling charge for this order.

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

The tax amount for this order.

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

The subtotal of all the items on this order.

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

The total cost of the current order.

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

The first name for the billing address for this order.

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

The last name for the billing address for this order.

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

The billing address line 1 for this order.

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

The billing address line 2 for this order.

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

The billing address line 3 for this order.

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

The billing address city for this order.

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

The billing address state/province for this order.

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

The billing address zip/postal code for this order.

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

The billing address country for this order.

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

The billing address daytime phone number for this order.

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

The billing address night time phone number for this order.

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

The billing address fax number for this order.

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

The billing address email address for this order.

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

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

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

The first name for the shipping address for this order.

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

The last name for the shipping address for this order.

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

The shipping address line 1 for this order.

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

The shipping address line 2 for this order.

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

The shipping address line 3 for this order.

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

The shipping address city for this order.

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

The shipping address state/province for this order.

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

The shipping address zip/postal code for this order.

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

The shipping address country for this order.

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

The shipping address daytime phone number for this order.

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

The shipping address night time phone number for this order.

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

The shipping address fax number for this order.

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

The shipping address email address for this order.

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

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

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