【www.bbyears.com--magento】
一:针对退货sql安装表数据,需要的字段
$installer = $this;
$installer->startSetup();
$installer->run("
DROP TABLE IF EXISTS `return_order`;
CREATE TABLE `return_order` (
`return_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT "退货申请Id",
`customer_id` int(10) unsigned NOT NULL COMMENT "申请人Id",
`order_id` int(10) unsigned NOT NULL COMMENT "订单Id",
`return_total_xyz` int(10) unsigned NOT NULL COMMENT "退还的总心意值",
`return_shipping_number` varchar(60) DEFAULT NULL COMMENT "退货物流编号",
`auditor_id` int(10) unsigned NOT NULL COMMENT "审核人Id",
`confirm_user_id` int(10) unsigned NOT NULL COMMENT "确认收货人Id",
`return_shipping_name` text COMMENT "物流名称",
`return_status` enum("RETURN_AGREEMENT","RETURN_REFUSE","RETURN_CONFIRM") DEFAULT NULL COMMENT "RETURN_AGREEMENT:同意退货; RETURN_REFUSE:拒绝退货; RETURN_CONFIRM:确认收货",
`return_create_time` datetime DEFAULT NULL COMMENT "申请时间",
`product_recieve_time` datetime DEFAULT NULL COMMENT "收货时间",
`return_deal_time` datetime DEFAULT NULL COMMENT "处理申请时间",
`return_memo` text COMMENT "退货说明",
PRIMARY KEY (`return_id`),
KEY `customer_id` (`customer_id`),
KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Table structure for table `return_order_item` */
DROP TABLE IF EXISTS `return_order_item`;
CREATE TABLE `return_order_item` (
`return_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`return_order_id` int(10) unsigned NOT NULL COMMENT "退货单Id",
`customer_id` int(10) unsigned NOT NULL COMMENT "退货人Id",
`sales_order_id` int(10) unsigned NOT NULL COMMENT "订单Id, sales_flat_order表的Id",
`order_item_id` int(10) unsigned NOT NULL COMMENT "sales_flat_order_item表的Id",
`product_id` int(10) unsigned NOT NULL COMMENT "产品Id",
`return_qty` int(10) unsigned NOT NULL COMMENT "退货商品的数量",
`return_item_xyz` int(10) unsigned NOT NULL COMMENT "退还的心意值",
PRIMARY KEY (`return_item_id`),
KEY `return_order_item_ibfk_2` (`return_order_id`),
CONSTRAINT `return_order_item_ibfk_2` FOREIGN KEY (`return_order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");
$installer->endSetup();
二:针对换货
$installer = $this;
$installer->startSetup();
$installer->run("
DROP TABLE IF EXISTS `barter_items`;
CREATE TABLE `barter_items` (
`barter_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`barter_id` int(10) unsigned NOT NULL COMMENT "换货单Id",
`sales_item_id` int(10) unsigned NOT NULL COMMENT "sales_flat_order_item表的Id",
`customer_id` int(10) unsigned NOT NULL COMMENT "换货人Id",
`product_id` int(10) unsigned NOT NULL COMMENT "产品Id",
`barter_qty` int(10) unsigned NOT NULL COMMENT "换货数量",
PRIMARY KEY (`barter_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Table structure for table `barter_order` */
DROP TABLE IF EXISTS `barter_order`;
CREATE TABLE `barter_order` (
`barter_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT "换货单Id",
`customer_id` int(10) unsigned NOT NULL COMMENT "申请人Id",
`order_id` int(10) unsigned NOT NULL COMMENT "销售订单Id",
`barter_apply_time` datetime COMMENT "换货申请时间",
`barter_check_time` datetime COMMENT "换货申请审核时间",
`customer_delivery_time` datetime COMMENT "客户发货时间",
`customer_express_name` varchar(100) NOT NULL COMMENT "客户发货物流名称",
`customer_express_num` varchar(100) NOT NULL COMMENT "客户发货物流单号",
`warehouse_receive_time` datetime COMMENT "仓库收货时间",
`warehouse_delivery_time` datetime COMMENT "仓库发货时间",
`warehouse_express_name` varchar(100) NOT NULL COMMENT "仓库发货物流名称",
`warehouse_express_num` varchar(100) NOT NULL COMMENT "仓库发货物流单号",
`customer_receive_time` datetime COMMENT "客户确认收货时间",
`barter_status` enum("BARTER_AGREENMENT","BARTER_REFUSE","WAREHOUSE_RECIEVED","WAREHOUSE_DELIVERY","CUSTOMER_RECIEVED")
DEFAULT NULL COMMENT "BARTER_AGREENMENT:同意换货,BARTER_REFUSE:拒接换货,WAREHOUSE_RECIEVED:仓库确认收货,WAREHOUSE_DELIVERY:仓库已发,CUSTOMER_RECIEVED:客户确认收货",
`barter_memo` text COMMENT "退货说明",
PRIMARY KEY (`barter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");
$installer->endSetup();