Mango::Schema::Order - DBIC schema class for orders
use Mango::Schema; my $schema = Mango::Schema->connect; my $orders = $schema->resultset('Orders')->search;
Mango::Schema::Order is loaded by Mango::Schema to read/write order data.
Contains the primary key for each order record.
id => { data_type => 'INT', is_auto_increment => 1, is_nullable => 0, extras => {unsigned => 1} },
Contains the foreign key to the user this order belongs to.
user_id => { data_type => 'INT', is_nullable => 1, is_foreign_key => 1, default_value => undef, extras => {unsigned => 1} },
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 },
The order number for this order.
number => { data_type => 'varchar', size => 20, is_nullable => 1, default_value => undef },
The date this order record was created.
created => { data_type => 'datetime', is_nullable => 1, default_value => undef },
The date this order record was last updated.
updated => { data_type => 'datetime', is_nullable => 1, default_value => undef },
Any user comments for this order.
comments => { data_type => 'varchar', size => 100, is_nullable => 1, default_value => undef },
The shipping method for this order.
shipmethod => { data_type => 'varchar', size => 20, is_nullable => 1, default_value => undef },
The shipping cost for this order.
shipping => { data_type => 'decimal', size => [9,2], is_nullable => 0, default_value => '0.00' },
The handling charge for this order.
handling => { data_type => 'decimal', size => [9,2], is_nullable => 0, default_value => '0.00' },
The tax amount for this order.
tax => { data_type => 'decimal', size => [9,2], is_nullable => 0, default_value => '0.00' },
The subtotal of all the items on this order.
subtotal => { data_type => 'decimal', size => [9,2], is_nullable => 0, default_value => '0.00' },
The total cost of the current order.
total => { data_type => 'decimal', size => [9,2], is_nullable => 0, default_value => '0.00' },
The first name for the billing address for this order.
billtofirstname => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The last name for the billing address for this order.
billtolastname => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The billing address line 1 for this order.
billtoaddress1 => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The billing address line 2 for this order.
billtoaddress2 => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The billing address line 3 for this order.
billtoaddress3 => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The billing address city for this order.
billtocity => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The billing address state/province for this order.
billtostate => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The billing address zip/postal code for this order.
billtozip => { data_type => 'varchar', size => 10, is_nullable => 1, default_value => undef },
The billing address country for this order.
billtocountry => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The billing address daytime phone number for this order.
billtodayphone => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The billing address night time phone number for this order.
billtonightphone => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The billing address fax number for this order.
billtofax => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The billing address email address for this order.
billtoemail => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
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 },
The first name for the shipping address for this order.
shiptofirstname => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The last name for the shipping address for this order.
shiptolastname => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The shipping address line 1 for this order.
shiptoaddress1 => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The shipping address line 2 for this order.
shiptoaddress2 => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The shipping address line 3 for this order.
shiptoaddress3 => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The shipping address city for this order.
shiptocity => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The shipping address state/province for this order.
shiptostate => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef },
The shipping address zip/postal code for this order.
shiptozip => { data_type => 'varchar', size => 10, is_nullable => 1, default_value => undef },
The shipping address country for this order.
shiptocountry => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The shipping address daytime phone number for this order.
shiptodayphone => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The shipping address night time phone number for this order.
shiptonightphone => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The shipping address fax number for this order.
shiptofax => { data_type => 'varchar', size => 25, is_nullable => 1, default_value => undef },
The shipping address email address for this order.
shiptoemail => { data_type => 'varchar', size => 50, is_nullable => 1, default_value => undef }
Christopher H. Laco CPAN ID: CLACO claco@chrislaco.com http://today.icantfocus.com/blog/
To install Mango, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Mango
CPAN shell
perl -MCPAN -e shell install Mango
For more information on module installation, please visit the detailed CPAN module installation guide.