public function delete()
{
if (!count(JeproshopOrderModelOrder::getCustomerOrders((int) $this->customer_id))) {
$addresses = $this->getAddresses((int) JeproshopSettingModelSetting::getValue('default_lang'));
foreach ($addresses as $address) {
$obj = new JeproshopAddressModelAddress((int) $address->address_id);
$obj->delete();
}
}
$db = JFactory::getDBO();
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_customer_group') . " WHERE " . $db->quoteName('customer_id') . " = " . (int) $this->customer_id;
$db->setQuery($query);
$db->query();
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_message') . " WHERE " . $db->quoteName('customer_id') . " = " . (int) $this->customer_id;
$db->setQuery($query);
$db->query();
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_specific_price') . " WHERE " . $db->quoteName('customer_id') . " = " . (int) $this->customer_id;
$db->setQuery($query);
$db->query();
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_compare') . " WHERE " . $db->quoteName('customer_id') . " = " . (int) $this->customer_id;
$db->setQuery($query);
$db->query();
$query = "SELECT " . $db->quoteName('cart_id') . " FROM " . $db->quoteName('#__jeproshop_cart') . " WHERE " . $db->quoteName('customer_id') . " = " . (int) $this->customer_id;
$db->setQuery($query);
$carts = $db->loadObjectList();
if ($carts) {
foreach ($carts as $cart) {
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_cart') . " WHERE " . $db->quoteName('cart_id') . " = " . (int) $cart->cart_id;
$db->setQuery($query);
$db->query();
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_cart_product') . " WHERE " . $db->quoteName('cart_id') . " = " . (int) $cart->cart_id;
$db->setQuery($query);
$db->query();
}
}
$query = "SELECT " . $db->quoteName('customer_thread_id') . " FROM " . $db->quoteName('#__jeproshop_customer_thread') . " WHERE " . $this->quoteName('customer_id') . " = " . (int) $this->customer_id;
$db->setQuery($query);
$customer_threads = $db->loadObjectList();
if ($customer_threads) {
foreach ($customer_threads as $customer_thread) {
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_customer_thread') . " WHERE " . $db->quoteName('customer_thread_id') . " = " . (int) $customer_thread->customer_thread_id;
$db->setQuery($query);
$db->query();
$query = "DELETE FROM " . $db->quoteName('#__jeproshop_customer_message') . " WHERE " . $db->quoteName('customer_thread_id') . " = " . (int) $customer_thread->customer_thread_id;
$db->setQuery($query);
$db->query();
}
}
JeproshopCartRuleModelCartRule::deleteByCustomerId((int) $this->customer_id);
return parent::delete();
}
