# DB INSERT INTO `qs_Application` (`class`, `role`, `title`, `sorter`) VALUES ('App_ECommerce_ShippingPrice_Admin_View', 'admin', 'Shipping Prices', 100), ('App_ECommerce_GiftCard_Admin_View', 'admin', 'Gift Cards', 110), ('App_ECommerce_Product_Category_Admin_View', 'admin', 'Product Categories', 120), ('App_ECommerce_Promo_Admin_View', 'admin', 'Promo Codes', 130), ('App_ECommerce_Product_Image_Admin_View', 'admin', 'Product Additional Images', 140), ('App_ECommerce_Product_Admin_View', 'admin', 'Products', 150), ('App_ECommerce_Order_Admin_View', 'admin', 'Orders', 170), ('App_ECommerce_Product_Category_View', 'user', 'Product Categories', 180), ('App_ECommerce_Product_View', 'user', 'Products', 190), ('App_ECommerce_Cart_View', 'user', 'Shopping Cart', 210), ('App_ECommerce_Checkout_View', 'user', 'Order Checkout', 220), ('App_ECommerce_Order_View', 'user', 'Order History', 290) ; INSERT INTO `qs_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'ECommerce_Product_Category_', 'Product Categories List', 170), (NULL, 'ECommerce_Product_', 'Products List', 230), (NULL, 'ECommerce_Cart_', 'Shopping Cart', 240), (NULL, 'ECommerce_Checkout_', 'Chekout', 250), (NULL, 'ECommerce_Checkout_LoginBlock_', 'Checkout Login Block', 260), (NULL, 'ECommerce_Order_', 'User Order History', 270); CREATE TABLE IF NOT EXISTS `qs_Cart` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userId` int(11) NOT NULL, `transactionId` int(11) DEFAULT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `transactionId` (`transactionId`), KEY `userId` (`userId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_CartItem` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cartId` int(11) NOT NULL, `cartItemType` enum('ECommerce_Product_') NOT NULL, `productId` int(11) NOT NULL, `productCategoryId` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `applyTax` enum('y','n') NOT NULL, `tax` decimal(10,4) NOT NULL, `image` varchar(255) DEFAULT NULL, `quantity` int(11) NOT NULL, `price` decimal(10,4) NOT NULL, `weight` decimal(10,4) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), KEY `cartId` (`cartId`), KEY `productId` (`productId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_CartItemGiftCard` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cartId` int(11) NOT NULL, `giftCardId` int(11) NOT NULL, `cardCode` varchar(255) NOT NULL, `cardValue` decimal(10,2) NOT NULL, `userId` int(11) NOT NULL, `added` datetime NOT NULL, PRIMARY KEY (`id`), KEY `cartId` (`cartId`), KEY `giftCardId` (`giftCardId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_CartItemPromo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `promoId` int(11) NOT NULL, `cartId` int(11) NOT NULL, `productId` int(11) DEFAULT NULL, `code` varchar(255) NOT NULL, `value` decimal(10,2) NOT NULL, `type` enum('dollar','percent') NOT NULL, `minOrderValue` decimal(10,2) NOT NULL, `added` datetime NOT NULL, PRIMARY KEY (`id`), KEY `cartId` (`cartId`,`productId`), KEY `promoId` (`promoId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_DGiftCardStatus` ( `id` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `sorter` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `qs_DGiftCardStatus` (`id`, `title`, `sorter`) VALUES ('new', 'New', 0), ('send', 'Send', 10), ('redeemed', 'Redeemed', 20); CREATE TABLE IF NOT EXISTS `qs_DPromoType` ( `id` varchar(15) NOT NULL, `title` varchar(150) NOT NULL, `sorter` int(11) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `qs_DPromoType` (`id`, `title`, `sorter`, `added`, `changed`) VALUES ('dollar', '$', 1, '2012-07-10 00:00:00', '2012-07-10 00:00:00'), ('percent', '%', 2, '2012-07-10 00:00:00', '2012-07-10 00:00:00'); CREATE TABLE IF NOT EXISTS `qs_GiftCard` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cardCode` varchar(255) NOT NULL, `cardValue` float NOT NULL, `expirationDate` date NOT NULL, `userId` int(11) NOT NULL, `statusId` enum('new','send','redeemed') NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), KEY `userId` (`userId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_Promo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(255) NOT NULL, `value` float NOT NULL, `type` varchar(15) NOT NULL, `isRelated` enum('y','n') NOT NULL DEFAULT 'n', `productId` int(11) DEFAULT NULL, `minOrderValue` float NOT NULL, `startDate` date NOT NULL, `endDate` date DEFAULT NULL, `hasNoExpirationDate` enum('y','n') NOT NULL, `usageCount` int(11) NOT NULL, `sorter` int(11) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), KEY `sorter` (`sorter`), KEY `code` (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_Product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `alias` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `metaKeywords` text NOT NULL, `metaDescription` text NOT NULL, `soldOut` enum('n','y') NOT NULL, `applyTax` enum('n','y') NOT NULL, `price` decimal(10,2) NOT NULL, `weight` decimal(10,2) NOT NULL, `image` varchar(255) DEFAULT NULL, `description` text NOT NULL, `show` enum('y','n') NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_Product2Category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `productId` int(11) NOT NULL, `categoryId` int(11) NOT NULL, `added` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_ProductCategory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parentId` int(11) NOT NULL, `alias` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `metaKeywords` text NOT NULL, `metaDescription` text NOT NULL, `image` varchar(255) DEFAULT NULL, `sorter` int(11) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), KEY `parentId` (`parentId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_ProductImage` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `productId` int(11) unsigned NOT NULL, `title` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `show` enum('y','n') NOT NULL DEFAULT 'y', `sorter` int(11) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), KEY `idProduct` (`productId`,`show`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; CREATE TABLE IF NOT EXISTS `qs_Transaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `transactionId` varchar(255) NOT NULL, `billingFirstName` varchar(255) NOT NULL, `billingLastName` varchar(255) NOT NULL, `billingAddress` varchar(255) NOT NULL, `billingCity` varchar(255) NOT NULL, `billingState` varchar(255) NOT NULL, `billingZip` varchar(255) NOT NULL, `billingPhone` varchar(255) NOT NULL, `billingEmail` varchar(255) NOT NULL, `shippingAsBilling` enum('y','n') NOT NULL, `shippingFirstName` varchar(255) NOT NULL, `shippingLastName` varchar(255) NOT NULL, `shippingAddress` varchar(255) NOT NULL, `shippingCity` varchar(255) NOT NULL, `shippingState` varchar(255) NOT NULL, `shippingZip` varchar(255) NOT NULL, `shippingAddressType` enum('residential','commercial') NOT NULL DEFAULT 'residential', `shippingName` varchar(255) NOT NULL, `shippingNameTitle` varchar(255) DEFAULT NULL, `shippingServiceCode` varchar(255) NOT NULL, `shippingServiceCodeTitle` varchar(255) NOT NULL, `shippingHandling` decimal(10,2) NOT NULL, `shippingHandlingTax` decimal(10,2) NOT NULL, `shippingRate` decimal(10,2) NOT NULL, `shippingTax` decimal(10,2) NOT NULL, `paymentType` varchar(255) DEFAULT NULL, `paymentTypeTitle` varchar(255) NOT NULL, `paid` enum('y','n') NOT NULL DEFAULT 'n', `status` enum('new','packed','sent','closed') NOT NULL DEFAULT 'new', `promo` decimal(10,2) NOT NULL, `giftCard` decimal(10,2) NOT NULL, `subtotal` decimal(10,2) NOT NULL, `tax` decimal(10,2) NOT NULL, `total` decimal(10,2) NOT NULL, `oldTotal` decimal(10,2) NOT NULL, `paymentCardNumber` varchar(255) NOT NULL, `paymentExpirationDate` date DEFAULT NULL, `paymentPoNumber` varchar(255) DEFAULT NULL, `trackingCode` varchar(255) NOT NULL, `adminAdditionalNote` text NOT NULL, `userAdditionalNote` text NOT NULL, `enabled` enum('y','n') NOT NULL DEFAULT 'y', `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`), KEY `deliveryType` (`shippingName`), KEY `shippingMethod` (`shippingAsBilling`), KEY `status` (`status`), KEY `paymentType` (`paymentType`), KEY `shippingAddressType` (`shippingAddressType`), KEY `paid` (`paid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; ------------------------------------------------------------------------------------------------------------------------ # sitemap.xml ... ... <__products handler="popup"> ... ... <__e-commerce-remove-garbage handler="speedy"> ... ------------------------------------------------------------------------------------------------------------------------ # Files trunk/site/App/ECommerce/ | install.txt +---Checkout | | View.php | | Obj.php | | config.php | +---LoginBlock | | View.php | +---Abstract | | View.php | | Obj.php | +---Form | | | Process.php | | | Config.php | | | New.php | | \---Service | | | Payment.php | | | Abstract.php | | | Shipping.php | | \---Type | | | Abstract.php | | +---Shipping | | | Ups.php | | | FedEx.php | | | Usps.php | | | Manual.php | | \---Payment | | PayPalStandard.php | | PayPalExpressCheckout.php | | Po.php | | AuthorizeNet.php | \---Adapter | \---Payment | PoResponse.php | PayPalStandard.php | Abstract.php | PayPalExpressCheckout.php | Po.php | AuthorizeNet.php +---Cart | | List.php | | View.php | | Obj.php | | config.php | +---Abstract | | List.php | | View.php | | Obj.php | \---Form | Config.php | AddItem.php +---Product | | List.php | | View.php | | Obj.php | | config.php | +---Category | | | List.php | | | View.php | | | Obj.php | | | config.php | | +---Admin | | | | List.php | | | | View.php | | | | Obj.php | | | \---Form | | | Abstract.php | | | Reorder.php | | | Edit.php | | | New.php | | +---Abstract | | | Obj.php | | \---Form | | Config.php | +---Admin | | | List.php | | | View.php | | | Obj.php | | \---Form | | Filter.php | | Abstract.php | | Edit.php | | New.php | +---Abstract | | View.php | | Form.php | | Obj.php | +---Form | | | Config.php | | +---Element | | | CategoriesSelector.php | | \---Decorator | | CategoriesSelector.php | +---View | | \---Helper | | CategoriesSelector.php | \---Image | | config.php | +---Admin | | | List.php | | | View.php | | | Obj.php | | \---Form | | Filter.php | | Abstract.php | | Reorder.php | | Edit.php | | New.php | \---Abstract | List.php | Obj.php +---GiftCard | | config.php | +---Admin | | | List.php | | | View.php | | | Obj.php | | \---Form | | Filter.php | | Abstract.php | | Edit.php | | New.php | \---Abstract | Obj.php +---Order | | Interface.php | | List.php | | View.php | | Obj.php | | config.php | | MailAdapter.php | +---Garbage | | View.php | | Obj.php | +---Admin | | | List.php | | | View.php | | | Obj.php | | | Tab.php | | +---Summary | | | | View.php | | | | Obj.php | | | \---Form | | | Control.php | | | New.php | | +---Customer | | | | View.php | | | | Obj.php | | | \---Form | | | New.php | | +---Abstract | | | View.php | | +---Form | | | Filter.php | | | View.php | | | Tool.php | | | ControlAbstract.php | | | Abstract.php | | +---Product | | | | List.php | | | | View.php | | | | Obj.php | | | +---Popup | | | | | List.php | | | | | View.php | | | | | Obj.php | | | | \---Form | | | | Filter.php | | | \---Form | | | Control.php | | \---Payment | | | View.php | | | Obj.php | | \---Form | | New.php | +---Abstract | | | List.php | | | View.php | | | Obj.php | | \---Form | | Filter.php | \---Form | Filter.php | View.php +---ShippingPrice | | config.php | +---Admin | | | List.php | | | View.php | | | Obj.php | | \---Form | | Abstract.php | | Edit.php | | New.php | \---Abstract | Obj.php \---Promo | config.php +---Admin | | List.php | | View.php | | Obj.php | \---Form | Filter.php | Abstract.php | Edit.php | New.php \---Abstract Obj.php trunk/site/App/Service/ | Payment.php | Shipping.php +---Shipping | | Ups.php | | FedEx.php | | Usps.php | | Abstract.php | | Manual.php | | Config.php | | ResponseAbstract.php | | REQUIREMENTS.txt | +---Ups | | Response.php | | Exception.php | | config.php | +---Manual | | Response.php | | Exception.php | | config.php | +---Usps | | Response.php | | Exception.php | | config.php | \---FedEx | | Response.php | | SoapClient.php | | Exception.php | | config.php | \---wsdl | RateService_v13.wsdl \---Payment | PayPalStandard.php | Abstract.php | PayPalExpressCheckout.php | ResponseAbstract.php | AuthorizeNet.php +---PayPalExpressCheckout | Response.php | View.php | config.php +---AuthorizeNet | Response.php | config.php +---PayPalIpn | View.php \---PayPalStandard config.php trunk/site/tpl/ECommerce/ +---Checkout | | confirmation.tpl | \---LoginBlock | form.tpl +---Cart | | row-empty-list.tpl | | list.tpl | | helper-cc.tpl | | small-list.tpl | \---cells | quantity.tpl | account-options.tpl | total.tpl | link_advanced.tpl | item.tpl | account-item.tpl | image.tpl +---Product | | list.tpl | | view.tpl | +---Category | | | tree-list.tpl | | | list.tpl | | | tree-list-item.tpl | | \---Admin | | list.tpl | | list-links.tpl | | list_item.tpl | | list-legend.tpl | \---Admin | \---cells | categories.tpl | options.tpl | image.tpl +---GiftCard | \---Admin | \---cells | customer.tpl +---Order | | billing-information.tpl | | cart-information.tpl | | view.tpl | | view-header.tpl | | order-information.tpl | | cart-information-render.tpl | | payment-information.tpl | | shipping-information.tpl | +---Admin | | | list.tpl | | | view.tpl | | | tabs.tpl | | | order-information.tpl | | | list-actionToolbar.tpl | | +---Summary | | | total.tpl | | +---cells | | | paid.tpl | | | order-status.tpl | | | submitted.tpl | | | checkbox.tpl | | | options.tpl | | \---Product | | | row-empty-list.tpl | | | list.tpl | | +---cells | | | quantity.tpl | | \---Popup | | | list.tpl | | \---cells | | quantity.tpl | | image.tpl | \---cells | paid.tpl | order-status.tpl | submitted.tpl \---ShippingPrice \---Admin \---cells options.tpl trunk/site/tpl/Service/ \---Payment \---PayPalExpressCheckout failView.tpl successView.tpl cancelView.tpl trunk/site/lib/AuthorizeNet/ | AuthorizeNetCIM.php | AuthorizeNetDPM.php | AuthorizeNetAIM.php | AuthorizeNetSIM.php | AuthorizeNetTD.php | AuthorizeNetCP.php | AuthorizeNetARB.php | AuthorizeNetSOAP.php +---ssl | cert.pem \---shared AuthorizeNetException.php AuthorizeNetRequest.php AuthorizeNetResponse.php AuthorizeNetTypes.php AuthorizeNetXMLResponse.php trunk/www/images/ecommerce/ | ups.png | q.png | 1.png | usps.png | 3.png | fedex.png | payment_cc_paypal.png | 2.png | 4.png | cc-helper.png | manual.png | payment_cc.png \---ssl scaner-seal-by-godaddy.png verified-and-secured-by-godaddy.png authorize-secure-checkout.png cards-paypal.png Verified-Merchant.png paypal-seal.png paypal.png lock-icon.png cards.png trunk/www/js/app/ECommerce/ | small-cart.js | checkout.js | cart.js +---order | admin.js | admin-action-form-toolbar.js +---product | tree.js | form-element-categoriesSelector.js | view.js +---giftCard | form.js \---promo \---admin form.js