/** * Deletes a particular model. * If deletion is successful, the browser will be redirected to the 'admin' page. * @param integer $id the ID of the model to be deleted */ public function actionDelete_user_news($id, $type) { $tinKhachHang = $this->loadModel($id); if ($tinKhachHang->ma_loai_tin == Tinraovat::CODE_RV) { Tinraovat::model()->deleteAll('ma_tin =' . $tinKhachHang->ma_tin); } else { Tinghepxe::model()->deleteAll('ma_tin =' . $tinKhachHang->ma_tin); } $tinKhachHang->delete(); $this->redirect(array('admin')); }
/** * Sửa tin rao vặt * @param integer $maTin */ private function __suaTinRaoVat($maTin) { $form = new CForm('application.views.user.khach_hang._formRV'); $form['tinkhachhang']->model = $tinKH = Tinkhachhang::model()->findByPk($maTin); $form['tinraovat']->model = $tinRV = Tinraovat::model()->find("ma_tin = {$maTin}"); $anh = $tinRV['anh']; if ($form->submitted('dangtin') && $form->validate()) { $tinkhachhang = $form['tinkhachhang']->model; $tinraovat = $form['tinraovat']->model; if ($tinkhachhang->save(false)) { $image = CUploadedFile::getInstance($tinraovat, 'anh'); if ($image) { //Nếu tồn tại ảnh trong CSDL thì sẽ xóa ảnh cũ trong thư mục ảnh if ($anh) { unlink(Yii::app()->basePath . "/../" . Tinraovat::IMAGE_DIR_RV . $anh); } $newName = md5(microtime(true) . 'xechieuve') . $image->name; $tinraovat->anh = $newName; $image->saveAs(Tinraovat::IMAGE_DIR_RV . $newName); } Tinraovat::updateTinRV($tinraovat->ma_loai_tin_rv, $tinraovat->gia_rao_vat, $tinraovat->anh != null ? $tinraovat->anh : $anh, $tinraovat->ma_tin); } } //render view $this->render('sua_tin', ['form' => $form]); }
public static function updateTinRV($maLoaiTinRV, $giaRaoVat, $anh = 'null', $maTin) { $sql = "UPDATE " . Tinraovat::model()->tableName() . " SET ma_loai_tin_rv = {$maLoaiTinRV},gia_rao_vat= '{$giaRaoVat}', anh = '{$anh}'" . " WHERE ma_tin ={$maTin}"; Yii::app()->db->createCommand($sql)->execute(); }
/** * Delete tin đăng của khách hàng * @param type $maTin */ public function deleteTin($maTin, $maLoaiTin) { if ($maLoaiTin == Tinraovat::CODE_RV) { //Kiểm tra nếu có tồn tại ảnh thì xóa luôn cùng $tinRV = Tinraovat::model()->find("ma_tin = {$maTin}"); if ($anh = $tinRV['anh']) { unlink(Yii::app()->basePath . "/../" . Tinraovat::IMAGE_DIR_RV . $anh); } $sql = "DELETE FROM tinraovat "; Yii::app()->db->createCommand($sql)->where('ma_tin = :id', array(':id' => $maTin))->andWhere('ma_khach_hang = :mkh', array(':mkh' => Yii::app()->user->userId)); } else { $sql = "DELETE FROM tinghepxe "; Yii::app()->db->createCommand($sql)->where('ma_tin = :id', array(':id' => $maTin))->andWhere('ma_khach_hang = :mkh', array(':mkh' => Yii::app()->user->userId)); } //xóa tin ở bảng cha(bảng tin khách hàng) $this->deleteByPk($maTin); }