[模組] 商品出貨方式 & 付款方式（根據客戶群組批次修改）- 客製化開發募資活動

Code: Select all

CREATE TABLE `oc_product_method_ci` (
  `product_method_id` int(11) NOT NULL,
  `customer_group_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_shipping_method` varchar(2550) NOT NULL,
  `product_payment_method` varchar(2550) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Code: Select all

INSERT INTO `oc_product_method_ci` (`product_method_id`, `customer_group_id`, `product_id`, `product_shipping_method`, `product_payment_method`) VALUES
(1, 1, 1, 'flat,category_product_based', 'bank_transfer,pp_standard'),
(2, 2, 1, 'item,category_product_based', 'pp_standard'),
(3, 3, 1, 'category_product_based', 'bank_transfer'),

Code: Select all

ALTER TABLE `oc_product` ADD `no_self_pickup` TINYINT(1) NOT NULL DEFAULT 0;

Code: Select all

UPDATE `oc_product` p
JOIN `oc_product_to_category` pc ON p.product_id = pc.product_id
SET p.no_self_pickup = 1
WHERE pc.category_id = 10;

Code: Select all

INSERT INTO `oc_product_method_ci` (`product_method_id`, `customer_group_id`, `product_id`, `product_shipping_method`, `product_payment_method`) VALUES
(1, 1, 1, 'flat,category_product_based', 'bank_transfer,pp_standard'),
(2, 2, 1, 'item,category_product_based', 'pp_standard'),
(3, 3, 1, 'category_product_based', 'bank_transfer'),

Code: Select all

$status = in_array($this->customer->getGroupId(), array(1)) ? true : false;