NAME
Handel::Schema::Order - Schema class for order table
SYNOPSIS
use Handel::Order::Schema;
use strict;
use warnings;
my $schema = Handel::Order::Schema->connect;
my $cart = $schema->resultset("Orders")->find('12345678-9098-7654-3212-345678909876');DESCRIPTION
Handel::Schema::Order is loaded by Handel::Order::Schema 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 => {
data_type => 'varchar',
size => 36,
is_nullable => 0,
},shopper
Contains the keys used to tie each order to a specific shopper. By default, this is a uuid string.
shopper => {
data_type => 'varchar',
size => 36,
is_nullable => 0,
},type
Contains the type for this order. The current values are ORDER_TYPE_TEMP and ORDER_TYPE_SAVED from Handel::Constants.
type => {
data_type => 'tinyint',
size => 3,
is_nullable => 0,
default_value => 0
},number
The order number for this order.
number => {
data_type => 'varchar',
size => 20,
is_nullable => 1,
default_value => undef
},created
The date this order record was created.
created => {
data_type => 'datetime',
size => 19,
is_nullable => 1,
default_value => undef
},updated
The date this order record was last updated.
updated => {
data_type => 'datetime',
size => 19,
is_nullable => 1,
default_value => undef
},comments
Any user comments for this order.
comments => {
data_type => 'varchar',
size => 100,
is_nullable => 1,
default_value => undef
},shipmethod
The shipping method for this order.
shipmethod => {
data_type => 'varchar',
size => 20,
is_nullable => 1,
default_value => undef
},shipping
The shipping cost for this order.
shipping => {
data_type => 'decimal',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},handling
The handling charge for this order.
handling => {
data_type => 'decimal',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},tax
The tax amount for this order.
tax => {
data_type => 'decimal',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},subtotal
The subtotal of all the items on this order.
subtotal => {
data_type => 'decimal',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},total
The total cost of the current order.
total => {
data_type => 'decimal',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},billtofirstname
The first name for the billing address for this order.
billtofirstname => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},billtolastname
The last name for the billing address for this order.
billtolastname => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},billtoaddress1
The billing address line 1 for this order.
billtoaddress1 => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},billtoaddress2
The billing address line 2 for this order.
billtoaddress2 => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},billtoaddress3
The billing address line 3 for this order.
billtoaddress3 => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},billtocity
The billing address city for this order.
billtocity => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},billtostate
The billing address state/province for this order.
billtostate => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},billtozip
The billing address zip/postal code for this order.
billtozip => {
data_type => 'varchar',
size => 10,
is_nullable => 1,
default_value => undef
},billtocountry
The billing address country for this order.
billtocountry => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},billtodayphone
The billing address daytime phone number for this order.
billtodayphone => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},billtonightphone
The billing address night time phone number for this order.
billtonightphone => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},billtofax
The billing address fax number for this order.
billtofax => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},billtoemail
The billing address email address for this order.
billtoemail => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},shiptosameasbillto
When set to true, the shipping address is the same as the billing address.
shiptosameasbillto => {
data_type => 'tinyint',
size => 3,
is_nullable => 0,
default_value => 1
},shiptofirstname
The first name for the shipping address for this order.
shiptofirstname => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},shiptolastname
The last name for the shipping address for this order.
shiptolastname => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},shiptoaddress1
The shipping address line 1 for this order.
shiptoaddress1 => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},shiptoaddress2
The shipping address line 2 for this order.
shiptoaddress2 => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},shiptoaddress3
The shipping address line 3 for this order.
shiptoaddress3 => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},shiptocity
The shipping address city for this order.
shiptocity => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},shiptostate
The shipping address state/province for this order.
shiptostate => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
},shiptozip
The shipping address zip/postal code for this order.
shiptozip => {
data_type => 'varchar',
size => 10,
is_nullable => 1,
default_value => undef
},shiptocountry
The shipping address country for this order.
shiptocountry => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},shiptodayphone
The shipping address daytime phone number for this order.
shiptodayphone => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},shiptonightphone
The shipping address night time phone number for this order.
shiptonightphone => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},shiptofax
The shipping address fax number for this order.
shiptofax => {
data_type => 'varchar',
size => 25,
is_nullable => 1,
default_value => undef
},shiptoemail
The shipping address email address for this order.
shiptoemail => {
data_type => 'varchar',
size => 50,
is_nullable => 1,
default_value => undef
}SEE ALSO
Handel::Schema::Order::Item, DBIx::Class::Schema
AUTHOR
Christopher H. Laco
CPAN ID: CLACO
claco@chrislaco.com
http://today.icantfocus.com/blog/