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;
}
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;
}
