本文整理汇总了PHP中Discount::deleteByIdGroup方法的典型用法代码示例。如果您正苦于以下问题：PHP Discount::deleteByIdGroup方法的具体用法？PHP Discount::deleteByIdGroup怎么用？PHP Discount::deleteByIdGroup使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Discount的用法示例。
在下文中一共展示了Discount::deleteByIdGroup方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: delete
public function delete()
{
if ($this->id == _PS_DEFAULT_CUSTOMER_GROUP_) {
return false;
}
if (parent::delete()) {
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'customer_group` WHERE `id_group` = ' . (int) $this->id);
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'category_group` WHERE `id_group` = ' . (int) $this->id);
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'group_reduction` WHERE `id_group` = ' . (int) $this->id);
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'product_group_reduction_cache` WHERE `id_group` = ' . (int) $this->id);
// Add default group (id 1) to customers without groups
Db::getInstance()->Execute('INSERT INTO `' . _DB_PREFIX_ . 'customer_group` (
SELECT c.id_customer, 1 FROM `' . _DB_PREFIX_ . 'customer` c
LEFT JOIN `' . _DB_PREFIX_ . 'customer_group` cg
ON cg.id_customer = c.id_customer
WHERE cg.id_customer IS NULL)');
// Set to the customer the default group
// Select the minimal id from customer_group
Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'customer` cg
SET id_default_group =
IFNULL((
SELECT min(id_group) FROM `' . _DB_PREFIX_ . 'customer_group`
WHERE id_customer = cg.id_customer),
1)
WHERE `id_default_group` = ' . (int) $this->id);
Discount::deleteByIdGroup((int) $this->id);
return true;
}
return false;
}示例2: delete
public function delete()
{
if ($this->id == _PS_DEFAULT_CUSTOMER_GROUP_) {
return false;
}
if (parent::delete()) {
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'customer_group` WHERE `id_group` = ' . (int) $this->id);
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'category_group` WHERE `id_group` = ' . (int) $this->id);
Discount::deleteByIdGroup((int) $this->id);
return true;
}
return false;
}