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