/** * Override delete function so we can delete user group and article or category relations first. * * @param string $sOxId object ID (default null) * * @return null */ public function delete($sOxId = null) { if (!$sOxId) { $sOxId = $this->getId(); } $this->unsetDiscountRelations(); $this->unsetUserGroups(); $this->deleteVoucherList(); return parent::delete($sOxId); }
/** * Deletes object information from DB, returns true on success. * * @param string $sOxId object ID (default null) * * @return bool */ public function delete($sOxId = null) { if (!$sOxId) { $sOxId = $this->getId(); } if (!$sOxId) { return false; } $blDeleted = parent::delete($sOxId); if ($blDeleted) { $oDb = oxDb::getDb(); $sDelete = "delete from oxobject2group where oxobject2group.oxshopid = '" . $this->getShopId() . "' and oxobject2group.oxobjectid = " . $oDb->quote($sOxId); $oDb->execute($sDelete); } return $blDeleted; }
/** * Deletes oxFile record from DB, removes orphan files. * * @param string $sOxId default null * * @return bool */ public function delete($sOxId = null) { $sOxId = $sOxId ? $sOxId : $this->getId(); $this->load($sOxId); // if record cannot be delete, abort deletion if ($blDeleted = parent::delete($sOxId)) { $this->_deleteFile(); } return $blDeleted; }
/** * Deletes order article object. If deletion succeded - updates * article stock information. Returns deletion status * * @param string $sOXID Article id * * @return bool */ public function delete($sOXID = null) { if ($blDelete = parent::delete($sOXID)) { $myConfig = $this->getConfig(); if ($this->oxorderarticles__oxstorno->value != 1) { $this->updateArticleStock($this->oxorderarticles__oxamount->value, $myConfig->getConfigParam('blAllowNegativeStock')); } } return $blDelete; }
/** * Removes articles from the recommlist and deletes list * * @param string $sOXID Object ID(default null) * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } if ($blDelete = parent::delete($sOXID)) { $oDb = oxDb::getDb(); // cleaning up related data $oDb->execute("delete from oxobject2list where oxlistid = " . $oDb->quote($sOXID)); } return $blDelete; }
/** * Deletes current basket history * * @param string $sOXID Object ID(default null) * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } $blDelete = false; if ($sOXID && ($blDelete = parent::delete($sOXID))) { // cleaning up related data $oDb = oxDb::getDb(); $sQ = "delete from oxuserbasketitems where oxbasketid = " . $oDb->quote($sOXID); $oDb->execute($sQ); } return $blDelete; }
/** * Delete this object from the database, returns true on success. * * @param string $sOXID Object ID(default null) * * @return bool */ public function delete($sOXID = null) { $blDeleted = parent::delete($sOXID); if ($blDeleted) { $oDB = oxDb::getDb(); $sOXID = $oDB->quote($sOXID); //delete the record foreach ($this->_getLanguageSetTables() as $sSetTbl) { $oDB->execute("delete from {$sSetTbl} where oxid = {$sOXID}"); } } return $blDeleted; }
/** * Removes user data stored in some DB tables (such as oxuserpayments, oxaddress * oxobject2group, oxremark, etc). Return true on success. * * @param string $sOXID object ID (default null) * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } $blDeleted = parent::delete($sOXID); if ($blDeleted) { $oDb = oxDb::getDb(); $sOXIDQuoted = $oDb->quote($sOXID); // deleting stored payment, address, group dependencies, remarks info $oDb->execute("delete from oxaddress where oxaddress.oxuserid = {$sOXIDQuoted}"); $oDb->execute("delete from oxobject2group where oxobject2group.oxobjectid = {$sOXIDQuoted}"); // deleting notice/wish lists $oDb->execute("delete oxuserbasketitems.* from oxuserbasketitems, oxuserbaskets where oxuserbasketitems.oxbasketid = oxuserbaskets.oxid and oxuserid = {$sOXIDQuoted}"); $oDb->execute("delete from oxuserbaskets where oxuserid = {$sOXIDQuoted}"); // deleting newsletter subscription $oDb->execute("delete from oxnewssubscribed where oxuserid = {$sOXIDQuoted}"); // delivery and delivery sets $oDb->execute("delete from oxobject2delivery where oxobjectid = {$sOXIDQuoted}"); // discounts $oDb->execute("delete from oxobject2discount where oxobjectid = {$sOXIDQuoted}"); $this->deleteAdditionally($sOXIDQuoted); // and leaving all order related information $rs = $oDb->execute("delete from oxremark where oxparentid = {$sOXIDQuoted} and oxtype !='o'"); $blDeleted = $rs->EOF; } return $blDeleted; }
/** * Updates stock information, deletes current ordering details from DB, * returns true on success. * * @param string $sOxId Ordering ID (default null) * * @return bool */ public function delete($sOxId = null) { if ($sOxId) { if (!$this->load($sOxId)) { // such order does not exist return false; } } elseif (!$sOxId) { $sOxId = $this->getId(); } // no order id is passed if (!$sOxId) { return false; } // delete order articles $oOrderArticles = $this->getOrderArticles(false); foreach ($oOrderArticles as $oOrderArticle) { $oOrderArticle->delete(); } // #440 - deleting user payment info if ($oPaymentType = $this->getPaymentType()) { $oPaymentType->delete(); } return parent::delete($sOxId); }
/** * Delete this object from the database, returns true on success. * * @param string $oxid Object ID(default null) * * @return bool */ public function delete($oxid = null) { $deleted = parent::delete($oxid); if ($deleted) { $db = oxDb::getDb(); $oxid = $db->quote($oxid); //delete the record foreach ($this->_getLanguageSetTables() as $setTbl) { $db->execute("delete from {$setTbl} where oxid = {$oxid}"); } } return $deleted; }