/**
* 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);
}
