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();
}
