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/
To install Handel::Storage::RDBO, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Handel::Storage::RDBO
CPAN shell
perl -MCPAN -e shell install Handel::Storage::RDBO
For more information on module installation, please visit the detailed CPAN module installation guide.