public static function getImageById($id) { $criteria = new CDbCriteria(); $criteria->select = 'i.image_path,i.image_title,i.image_ext'; $criteria->alias = 'i'; $criteria->condition = "id=:id"; $criteria->params = array(':id' => (int) $id); $rs = WImages::model()->find($criteria); /*$connection = Yii::app()->db; if(isset($id)){ $sql = "SELECT image_path, image_title, image_ext FROM {{images}} WHERE id = ".$id; $command = $connection->createCommand($sql); $rs = $command->queryRow(); } */ if ($rs) { return "<img width='200px' src='" . Yii::app()->params->upload_path . $rs['image_path'] . $rs['image_title'] . "_110." . $rs['image_ext'] . "'/>"; } else { return "<img width='200px' src='" . Yii::app()->params->upload_path . "noimage.jpg'/>"; } }
public function actionDeleteImage() { $id = isset($_POST['id']) ? $_POST['id'] : 0; $file_name = isset($_POST['file_name']) ? $_POST['file_name'] : ''; $ext = isset($_POST['ext']) ? $_POST['ext'] : ''; //$resource_id = isset($_POST['resource_id']) ? $_POST['resource_id'] : 0; $model = WImages::model()->find("id = :id", array(':id' => $id)); if ($resource_id != 0) { $resourceModel = WCampaignResource::model()->findByPk($resource_id); $arrFileID = explode(',', $resourceModel->ad_file_id); $arrNewFile = array(); if (is_array($arrFileID)) { foreach ($arrFileID as $key => $value) { if ($value != $id) { $arrNewFile[] = $value; } } } $resourceModel->ad_file_id = implode(",", $arrNewFile); $resourceModel->save(); } $files = realpath(Yii::app()->getBasePath() . '/../uploads/') . "/" . $file_name; if ($model) { if ($model->delete() && @unlink($files . '.' . $ext)) { $arrReturn = array("status" => true, "msg" => Yii::t('web/campaign', 'delete_image_ok')); } else { $arrReturn = array("status" => false, "msg" => Yii::t('web/campaign', 'delete_image_fail')); } } else { $arrReturn = array("status" => false, "msg" => Yii::t('web/campaign', 'delete_image_fail')); } echo json_encode($arrReturn); exit; }