public function beforeDelete() { if ($this->video_file) { $pathVideo = Yii::getPathOfAlias($this->path) . DIRECTORY_SEPARATOR . $this->apartment_id . DIRECTORY_SEPARATOR; deleteFile($pathVideo, $this->video_file); } return parent::beforeDelete(); }
public function beforeDelete() { if (issetModule('seo') && param('genFirendlyUrl')) { $sql = 'DELETE FROM {{seo_friendly_url}} WHERE model_id="' . $this->id . '" AND model_name = "Article"'; Yii::app()->db->createCommand($sql)->execute(); } $sql = 'DELETE FROM {{comments}} WHERE model_id=:id AND model_name="Article"'; Yii::app()->db->createCommand($sql)->execute(array(':id' => $this->id)); return parent::beforeDelete(); }
public function beforeDelete() { $sql = 'DELETE FROM {{apartment_reference_values}} WHERE reference_category_id="' . $this->id . '";'; Yii::app()->db->createCommand($sql)->execute(); $sql = 'DELETE FROM {{apartment_reference}} WHERE reference_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); $formDesignerModel = FormDesigner::model()->findByAttributes(array('reference_id' => $this->id)); if ($formDesignerModel) { $formDesignerModel->delete(); } return parent::beforeDelete(); }
public function beforeDelete() { // удалять тарифы пользователей. деактивировать объявления. $sql = 'SELECT user_id FROM {{users_tariff_plans}} WHERE tariff_id = ' . $this->id; $res = Yii::app()->db->createCommand($sql)->queryColumn(); if ($res) { $usersIds = array(); if (count($res) > 0) { foreach ($res as $userId) { $usersIds[$userId] = $userId; } } if (count($usersIds) > 0) { TariffPlans::deactivateUserAdsByTariffPlan($usersIds); } } $sql = 'UPDATE {{users_tariff_plans}} SET status = ' . UsersTariffPlans::STATUS_NO_ACTIVE . ' WHERE tariff_id = ' . $this->id; Yii::app()->db->createCommand($sql)->execute(); return parent::beforeDelete(); }
public function beforeDelete() { if ($this->name_iso == self::getDefaultLang() || $this->name_iso == self::getAdminMailLang() || $this->model()->count() <= 1) { return false; } $this->deleteLang($this->name_iso); return parent::beforeDelete(); }
public function beforeDelete() { @unlink(Yii::getPathOfAlias($this->path) . DIRECTORY_SEPARATOR . $this->name); $fileName = 'thumb_' . self::FULL_THUMB_WIDTH . 'x' . self::FULL_THUMB_HEIGHT . "_" . $this->name; @unlink(Yii::getPathOfAlias($this->path) . DIRECTORY_SEPARATOR . $fileName); return parent::beforeDelete(); }
public function beforeDelete() { $sql = 'SELECT id, file_path FROM {{messages_files}} WHERE id_message="' . $this->id . '"'; $items = Yii::app()->db->createCommand($sql)->queryAll(); $message = new Messages(); if ($items) { foreach ($items as $item) { if (file_exists($message->uploadPath . '/' . $item['file_path'])) { unlink($message->uploadPath . '/' . $item['file_path']); MessagesFiles::model()->deleteByPk($item['id']); } } } return parent::beforeDelete(); }
public function beforeDelete() { if (issetModule('seo') && param('genFirendlyUrl')) { $sql = 'DELETE FROM {{seo_friendly_url}} WHERE model_id="' . $this->id . '" AND model_name = "InfoPages"'; Yii::app()->db->createCommand($sql)->execute(); } return parent::beforeDelete(); }
public function beforeDelete() { return parent::beforeDelete(); }
public function beforeDelete() { if (issetModule('seo')) { $sql = 'DELETE FROM {{seo_friendly_url}} WHERE model_id="' . $this->id . '" AND ( model_name = "Apartment" OR model_name = "UserAds" )'; Yii::app()->db->createCommand($sql)->execute(); } $sql = 'DELETE FROM {{apartment_reference}} WHERE apartment_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); $sql = 'DELETE FROM {{comments}} WHERE model_id="' . $this->id . '" AND model_name="Apartment"'; Yii::app()->db->createCommand($sql)->execute(); $sql = 'DELETE FROM {{apartment_statistics}} WHERE apartment_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); $sql = 'DELETE FROM {{apartment_complain}} WHERE apartment_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); //Images::deleteByObjectId($this); Images::deleteDbByObjectId($this->id); $dir = Yii::getPathOfAlias('webroot.uploads.objects') . '/' . $this->id; rrmdir($dir); if (issetModule('metrostations')) { $sql = 'DELETE FROM {{apartment_metro}} WHERE id_apartment="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); } //delete QR-code $qr_codes = glob(Yii::getPathOfAlias('webroot.uploads.qrcodes') . '/listing_' . $this->id . '-*.png'); if (is_array($qr_codes) && count($qr_codes)) { array_map("unlink", $qr_codes); } // delete video $sql = 'DELETE FROM {{apartment_video}} WHERE apartment_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); $pathVideo = Yii::getPathOfAlias('webroot.uploads.video') . DIRECTORY_SEPARATOR . $this->id; rmrf($pathVideo); if (issetModule('bookingcalendar')) { $sql = 'DELETE FROM {{booking_calendar}} WHERE apartment_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); } if (issetModule('comparisonList')) { $sql = 'DELETE FROM {{comparison_list}} WHERE apartment_id="' . $this->id . '"'; Yii::app()->db->createCommand($sql)->execute(); } Yii::app()->cache->flush(); return parent::beforeDelete(); }
public function beforeDelete() { $fieldName = $this->field; $sql = "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME='{{apartment}}' AND COLUMN_NAME='{$fieldName}' AND table_schema = DATABASE()"; $fieldExist = Yii::app()->db->createCommand($sql)->queryScalar(); if ($fieldExist) { Yii::app()->db->createCommand("ALTER TABLE {{apartment}} DROP `{$fieldName}`")->execute(); } Yii::app()->db->createCommand("DELETE FROM {{search_form}} WHERE field=:field")->execute(array(':field' => $fieldName)); Yii::app()->cache->flush(); return parent::beforeDelete(); }
protected function beforeDelete() { $sql = 'SELECT img FROM {{slider}} WHERE id="' . $this->id . '"'; $item = Yii::app()->db->createCommand($sql)->queryRow(); if (isset($item['img'])) { if (file_exists($this->path . '/' . $item['img'])) { @unlink($this->path . '/' . $item['img']); } } return parent::beforeDelete(); }
public function beforeDelete() { if ($this->model()->count() <= 1) { return false; } $sql = "UPDATE {{apartment}} SET city_id=0, active=0 WHERE city_id=" . $this->id; Yii::app()->db->createCommand($sql)->execute(); return parent::beforeDelete(); }
public function beforeDelete() { if ($this->model()->count() <= 1) { echo 1; return false; } if ($this->icon_file) { $iconPath = Yii::getPathOfAlias('webroot') . '/' . $this->model()->iconsMapPath . '/' . $this->icon_file; if (file_exists($iconPath)) { @unlink($iconPath); } } $db = Yii::app()->db; $sql = "SELECT id FROM " . $this->tableName() . " WHERE id != " . $this->id . " ORDER BY sorter ASC"; $type_id = (int) $db->createCommand($sql)->queryScalar(); $sql = "UPDATE {{apartment}} SET obj_type_id={$type_id}, active=0 WHERE obj_type_id=" . $this->id; $db->createCommand($sql)->execute(); if (issetModule('formdesigner')) { $sql = "DELETE FROM {{formdesigner_obj_type}} WHERE obj_type_id=" . $this->id; $db->createCommand($sql)->execute(); } $sql = "DELETE FROM {{search_form}} WHERE obj_type_id=" . $this->id; $db->createCommand($sql)->execute(); return parent::beforeDelete(); }