public function delete()
{
if ($this->OrderExists()) {
//NOT delete a cart which is associated with an order
return false;
}
$uploaded_files = Db::getInstance()->executeS('
SELECT cd.`value`
FROM `' . _DB_PREFIX_ . 'customized_data` cd
INNER JOIN `' . _DB_PREFIX_ . 'customization` c ON (cd.`id_customization`= c.`id_customization`)
WHERE cd.`type`= 0 AND c.`id_cart`=' . (int) $this->id);
foreach ($uploaded_files as $must_unlink) {
unlink(_PS_UPLOAD_DIR_ . $must_unlink['value'] . '_small');
unlink(_PS_UPLOAD_DIR_ . $must_unlink['value']);
}
Db::getInstance()->execute('
DELETE FROM `' . _DB_PREFIX_ . 'customized_data`
WHERE `id_customization` IN (
SELECT `id_customization`
FROM `' . _DB_PREFIX_ . 'customization`
WHERE `id_cart`=' . (int) $this->id . '
)');
Db::getInstance()->execute('
DELETE FROM `' . _DB_PREFIX_ . 'customization`
WHERE `id_cart` = ' . (int) $this->id);
if (!Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'cart_cart_rule` WHERE `id_cart` = ' . (int) $this->id) || !Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'cart_product` WHERE `id_cart` = ' . (int) $this->id)) {
return false;
}
return parent::delete();
}
