/**
* Overloaded delete() to delete a list of tsmart_userinfo_id's based on the user id
* @var mixed id
* @return boolean True on success
* @author Oscar van Eijk
*/
function delete($id = null, $where = 0)
{
// TODO If $id is not numeric, assume it's a tsmart_userinfo_id. Validate if this is safe enough
if (!is_numeric($id)) {
return parent::delete($id);
}
// Implicit else
$this->_db->setQuery('DELETE from `#__tsmart_userinfos` WHERE `tsmart_user_id` = ' . $id);
if ($this->_db->execute() === false) {
vmError($this->_db->getError());
return false;
}
return true;
}
/**
* Overloaded delete() to delete records from order_userinfo and order payment as well,
* and write a record to the order history (TODO Or should the hist table be cleaned as well?)
*
* @var integer Order id
* @return boolean True on success
* @auhtor Max Milbers
* @author Kohl Patrick
*/
function delete($id = null, $where = 0)
{
$k = $this->_tbl_key;
if ($id === null) {
$id = $this->{$k};
}
$this->_db->setQuery('DELETE from `#__tsmart_order_userinfos` WHERE `tsmart_order_id` = ' . (int) $id);
if ($this->_db->execute() === false) {
vmError($this->_db->getError());
return false;
}
/*vm_order_payment NOT EXIST have to find the table name*/
$this->_db->setQuery('SELECT `payment_element` FROM `#__tsmart_paymentmethods` , `#__tsmart_orders`
WHERE `#__tsmart_paymentmethods`.`tsmart_paymentmethod_id` = `#__tsmart_orders`.`tsmart_paymentmethod_id` AND `tsmart_order_id` = ' . $id);
$payment_element = $this->_db->loadResult();
if (!empty($payment_element)) {
$paymentTable = '#__tsmart_payment_plg_' . $payment_element;
$this->_db->setQuery('DELETE from `' . $paymentTable . '` WHERE `tsmart_order_id` = ' . $id);
if ($this->_db->execute() === false) {
vmError($this->_db->getError());
return false;
}
}
/*vm_order_shipment NOT EXIST have to find the table name*/
$this->_db->setQuery('SELECT `shipment_element` FROM `#__tsmart_shipmentmethods` , `#__tsmart_orders`
WHERE `#__tsmart_shipmentmethods`.`tsmart_shipmentmethod_id` = `#__tsmart_orders`.`tsmart_shipmentmethod_id` AND `tsmart_order_id` = ' . $id);
$shipmentName = $this->_db->loadResult();
if (!empty($shipmentName)) {
$shipmentTable = '#__tsmart_shipment_plg_' . $shipmentName;
$this->_db->setQuery('DELETE from `' . $shipmentTable . '` WHERE `tsmart_order_id` = ' . $id);
if ($this->_db->execute() === false) {
vmError('TableOrders delete Order shipmentTable = ' . $shipmentTable . ' `tsmart_order_id` = ' . $id . ' dbErrorMsg ' . $this->_db->getError());
return false;
}
}
$_q = 'INSERT INTO `#__tsmart_order_histories` (' . ' tsmart_order_history_id' . ',tsmart_order_id' . ',order_status_code' . ',created_on' . ',customer_notified' . ',comments' . ') VALUES (' . ' NULL' . ',' . $id . ",'-'" . ',NOW()' . ',0' . ",'Order deleted'" . ')';
$this->_db->setQuery($_q);
$this->_db->execute();
// Ignore error here
return parent::delete($id);
}
