/** * Delete this object from the database, 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; } $oDB = oxDb::getDb(); $oDB->execute('delete from oxobject2discount where oxobject2discount.oxdiscountid = ' . $oDB->quote($sOXID)); return parent::delete($sOXID); }
/** * Delete this object from the database, 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; } $oDb = oxDb::getDb(); $sOxIdQuoted = $oDb->quote($sOxId); $oDb->execute('delete from oxobject2payment where oxobjectid = ' . $sOxIdQuoted); $oDb->execute('delete from oxobject2delivery where oxdeliveryid = ' . $sOxIdQuoted); $oDb->execute('delete from oxdel2delset where oxdelsetid = ' . $sOxIdQuoted); return parent::delete($sOxId); }
/** * Removes attributes from articles, returns true on success. * * @param string $sOXID Object ID * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } // remove attributes from articles also $oDb = oxDb::getDb(); $sOxidQuoted = $oDb->quote($sOXID); $sDelete = "delete from oxobject2attribute where oxattrid = " . $sOxidQuoted; $rs = $oDb->execute($sDelete); // #657 ADDITIONAL removes attribute connection to category $sDelete = "delete from oxcategory2attribute where oxattrid = " . $sOxidQuoted; $rs = $oDb->execute($sDelete); return parent::delete($sOXID); }
/** * Deletes user group from database. Returns true/false, according to deleting status. * * @param string $sOXID Object ID (default null) * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } parent::delete($sOXID); $oDb = oxDb::getDb(); // deleting related data records $sDelete = 'delete from oxobject2group where oxobject2group.oxgroupsid = ' . $oDb->quote($sOXID); $rs = $oDb->execute($sDelete); $sDelete = 'delete from oxobject2delivery where oxobject2delivery.oxobjectid = ' . $oDb->quote($sOXID); $rs = $oDb->execute($sDelete); $sDelete = 'delete from oxobject2discount where oxobject2discount.oxobjectid = ' . $oDb->quote($sOXID); $rs = $oDb->execute($sDelete); $sDelete = 'delete from oxobject2payment where oxobject2payment.oxobjectid = ' . $oDb->quote($sOXID); $rs = $oDb->execute($sDelete); return $rs->EOF; }
/** * Delete this object from the database, 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; } $oDb = oxDb::getDb(); $sQ = "delete from `oxobject2delivery` where `oxobject2delivery`.`oxdeliveryid` = " . $oDb->quote($sOxId); $oDb->execute($sQ); return parent::delete($sOxId); }
/** * Delete this object from the database, returns true on success. * * @param string $sOxId Object ID(default null) * * @return bool */ public function delete($sOxId = null) { if (parent::delete($sOxId)) { $sOxId = $sOxId ? $sOxId : $this->getId(); $oDb = oxDb::getDb(); // deleting payment related data $rs = $oDb->execute("delete from oxobject2payment where oxpaymentid = " . $oDb->quote($sOxId)); return $rs->EOF; } return false; }
/** * Removes article action, returns true on success. For * performance - you can not load action object - just pass * action ID. * * @param string $sOxId Object ID * * @return bool */ public function delete($sOxId = null) { if (!$sOxId) { $sOxId = $this->getId(); } if (!$sOxId) { return false; } // remove actionss from articles also $oDb = oxDb::getDb(true); $sDelete = "delete from oxactions2article where oxactionid = " . $oDb->quote($sOxId) . " and oxshopid = '" . $this->getShopId() . "'"; $oDb->execute($sDelete); 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; } if ($blDelete = parent::delete($sOxid)) { $oDb = oxDb::getDb(); $oDb->execute("delete from oxobject2group where oxobject2group.oxobjectid = " . $oDb->quote($sOxid)); } 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) { if (parent::delete($sOXID)) { oxSeoEncoderVendor::getInstance()->onDeleteVendor($this); return true; } return false; }
/** * Delete this object from the database, returns true on success. * * @param string $sOXID Object ID(default null) * * @return bool */ public function delete($sOXID = null) { if (parent::delete($sOXID)) { oxRegistry::get("oxSeoEncoderVendor")->onDeleteVendor($this); return true; } return false; }
/** * Deletes record and unlinks the file * * @param string $sOXID Object ID(default null) * * @return bool */ public function delete($sOXID = null) { $sFilePath = $this->getConfig()->getConfigParam('sShopDir') . "/out/media/" . $this->oxmediaurls__oxurl->value; if ($this->oxmediaurls__oxisuploaded->value && file_exists($sFilePath)) { unlink($sFilePath); } return parent::delete($sOXID); }
/** * Removes selectlists from articles. * * @param string $sOXID object ID (default null) * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } // remove selectlists from articles also if ($blRemove = parent::delete($sOXID)) { $oDb = oxDb::getDb(); $oDb->execute("delete from oxobject2selectlist where oxselnid = " . $oDb->quote($sOXID) . " "); } return $blRemove; }
/** * Deletes record and other information related to this article such as images from DB, * also removes variants. Returns true on success. * * @param string $sOXID Article id * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } // #2339 delete first variants before deleting parent product $this->_deleteVariantRecords($sOXID); $this->load($sOXID); $this->_deletePics(); $this->_onChangeResetCounts($sOXID, $this->oxarticles__oxvendorid->value, $this->oxarticles__oxmanufacturerid->value); // delete self parent::delete($sOXID); $rs = $this->_deleteRecords($sOXID); oxRegistry::get("oxSeoEncoderArticle")->onDeleteArticle($this); $this->onChange(ACTION_DELETE, $sOXID, $this->oxarticles__oxparentid->value); return $rs->EOF; }
/** * Delete this object from the database, returns true on success. * * @param string $sOXID Object ID(default null) * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (parent::delete($sOXID)) { oxRegistry::get("oxSeoEncoderContent")->onDeleteContent($sOXID); return true; } return false; }
/** * Deletes record and other information related to this article such as images from DB, * also removes variants. Returns true if entry was deleted. * * @param string $sOXID Article id * * @throws \Exception * * @return bool */ public function delete($sOXID = null) { if (!$sOXID) { $sOXID = $this->getId(); } if (!$sOXID) { return false; } $database = oxDb::getDb(); $database->startTransaction(); try { // #2339 delete first variants before deleting parent product $this->_deleteVariantRecords($sOXID); $this->load($sOXID); $this->_deletePics(); $this->_onChangeResetCounts($sOXID, $this->oxarticles__oxvendorid->value, $this->oxarticles__oxmanufacturerid->value); // delete self $deleted = parent::delete($sOXID); $this->_deleteRecords($sOXID); Registry::get("oxSeoEncoderArticle")->onDeleteArticle($this); $this->onChange(ACTION_DELETE, $sOXID, $this->oxarticles__oxparentid->value); $database->commitTransaction(); } catch (Exception $exception) { $database->rollbackTransaction(); throw $exception; } return $deleted; }
/** * Delete empty categories, returns true on success. * * @param string $sOXID Object ID * * @return bool */ public function delete($sOXID = null) { if (!$this->getId()) { $this->load($sOXID); } $sOXID = isset($sOXID) ? $sOXID : $this->getId(); $myConfig = $this->getConfig(); $oDb = oxDb::getDb(); $blRet = false; if ($this->oxcategories__oxright->value == $this->oxcategories__oxleft->value + 1) { $myUtilsPic = oxRegistry::get("oxUtilsPic"); $sDir = $myConfig->getPictureDir(false); // only delete empty categories // #1173M - not all pic are deleted, after article is removed $myUtilsPic->safePictureDelete($this->oxcategories__oxthumb->value, $sDir . oxRegistry::get("oxUtilsFile")->getImageDirByType('TC'), 'oxcategories', 'oxthumb'); $myUtilsPic->safePictureDelete($this->oxcategories__oxicon->value, $sDir . oxRegistry::get("oxUtilsFile")->getImageDirByType('CICO'), 'oxcategories', 'oxicon'); $myUtilsPic->safePictureDelete($this->oxcategories__oxpromoicon->value, $sDir . oxRegistry::get("oxUtilsFile")->getImageDirByType('PICO'), 'oxcategories', 'oxpromoicon'); $sAdd = " and oxshopid = '" . $this->getShopId() . "' "; $oDb->execute("UPDATE oxcategories SET OXLEFT = OXLEFT - 2\n WHERE OXROOTID = " . $oDb->quote($this->oxcategories__oxrootid->value) . "\n AND OXLEFT > " . (int) $this->oxcategories__oxleft->value . $sAdd); $oDb->execute("UPDATE oxcategories SET OXRIGHT = OXRIGHT - 2\n WHERE OXROOTID = " . $oDb->quote($this->oxcategories__oxrootid->value) . "\n AND OXRIGHT > " . (int) $this->oxcategories__oxright->value . $sAdd); // delete entry $blRet = parent::delete($sOXID); $sOxidQuoted = $oDb->quote($sOXID); // delete links to articles $oDb->execute("delete from oxobject2category where oxobject2category.oxcatnid={$sOxidQuoted} "); // #657 ADDITIONAL delete links to attributes $oDb->execute("delete from oxcategory2attribute where oxcategory2attribute.oxobjectid={$sOxidQuoted} "); // A. removing assigned: // - deliveries $oDb->execute("delete from oxobject2delivery where oxobject2delivery.oxobjectid={$sOxidQuoted} "); // - discounts $oDb->execute("delete from oxobject2discount where oxobject2discount.oxobjectid={$sOxidQuoted} "); oxRegistry::get("oxSeoEncoderCategory")->onDeleteCategory($this); } return $blRet; }
/** * Delete this object from the database, 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; } $oDb = oxDb::getDb(); $sQ = "delete from oxobject2delivery where oxobject2delivery.oxdeliveryid = " . $oDb->quote($sOXID); $oDb->execute($sQ); return parent::delete($sOXID); }