public function run() { //上传用户id $user_id = intval($this->getDataItem('user_id', 0)); $page = intval($this->getDataItem('page', 1)); $limit = $this->getConfig()->limit; $offset = ($page - 1) * $limit; $this->beautyCanons = CosBeautyCanon::query()->columns(['id', 'title', 'img_url', 'settime', 'fit', 'summary', 'assist'])->where("state != 3")->orderBy('settime DESC')->limit($limit, $offset)->execute()->toArray(); $this->beautyCanons = $this->beautyCanons ? $this->beautyCanons : []; for ($i = 0; $i < count($this->beautyCanons); $i++) { if ($user_id > 0) { //判断是否已经点过赞 $bc_assist = CosBeautyCanonAssist::count(["conditions" => "user_id = :sign: AND beauty_canon_id = :bc_id: ", "bind" => ['sign' => $user_id, 'bc_id' => $this->beautyCanons[$i]['id']]]); } else { $bc_assist = 0; } if ($bc_assist > 0) { $this->beautyCanons[$i]['is_assist'] = true; } else { $this->beautyCanons[$i]['is_assist'] = false; } if ($this->beautyCanons[$i]['summary'] == null) { $this->beautyCanons[$i]['summary'] = ''; } $this->beautyCanons[$i]['img_url'] = "http://img.meelier.com/" . $this->beautyCanons[$i]['img_url']; if (empty($this->beautyCanons[$i]['fit'])) { $this->beautyCanons[$i]['fit'] = 0; } if (empty($this->beautyCanons[$i]['assist'])) { $this->beautyCanons[$i]['assist'] = 0; } } $this->setResult($this->beautyCanons); }
public function run() { $id = intval($this->getDataItem('id', 0)); if (0 < $id) { $this->bcanonInfo = CosBeautyCanon::query()->columns(['content', 'fit'])->where('state != 3 and id = ' . $id)->execute()->getFirst(); } else { return $this->errorLog(ResultStatus::POST_BODY_PARAM_ERROR, '参数异常'); } if ($this->bcanonInfo) { if ($this->bcanonInfo->fit == null) { $this->bcanonInfo->fit = 0; } //浏览量加1 $query = new CosBeautyCanon(); $model = $query->findFirst(' id = ' . $id); $model->fit = $this->bcanonInfo->fit + 1; $model->save(); //循环处理内容中的图片 $this->bcanonInfo->content = str_replace('src="/ueditor/php/upload/image/', 'src="http://meelier.com/ueditor/php/upload/image/', $this->bcanonInfo->content); } else { $this->bcanonInfo = null; } $this->setResult($this->bcanonInfo); }
public function run() { $page = intval($this->getDataItem('page', 1)); $limit = $this->getConfig()->limit; $offset = ($page - 1) * $limit; $this->beautyCanons = CosBeautyCanon::query()->columns(['id', 'title', 'img_url', 'settime', 'fit', 'assist'])->where("state != 3")->orderBy('settime DESC')->limit($limit, $offset)->execute()->toArray(); $this->beautyCanons = $this->beautyCanons ? $this->beautyCanons : []; for ($i = 0; $i < count($this->beautyCanons); $i++) { $this->beautyCanons[$i]['img_url'] = "http://img.meelier.com/" . $this->beautyCanons[$i]['img_url']; if (empty($this->beautyCanons[$i]['fit'])) { $this->beautyCanons[$i]['fit'] = 0; } if (empty($this->beautyCanons[$i]['assist'])) { $this->beautyCanons[$i]['assist'] = 0; } } $this->setResult($this->beautyCanons); }
/** * 首页推荐美粒宝典取消推荐1.0版本 * * @return $this|ResponseResult */ public function undoAction() { $req = $this->request; $id = $req->getQuery("id"); $status = CosPointCanon::find("canon_id = {$id}")->delete(); $cosbeautycanon = CosBeautyCanon::findFirst("id = {$id}"); $cosbeautycanon->state = 1; $flg = $cosbeautycanon->save(); if ($flg == true && $status == true) { $arr = array("status" => 10000); echo json_encode($arr); exit; } else { $arr = array("status" => 0, "errmsg" => "error"); echo json_encode($arr); exit; } }
public static function updateAssist($id) { $sql = 'UPDATE beauty_canon SET assist = assist+1 WHERE id = :bc_id'; $model = new CosBeautyCanon(); return $model->getWriteConnection()->execute($sql, ['bc_id' => $id]); }
/** * 美粒宝典预览 * @date: 2016年1月4日 * @author: chenxiaolin */ public function beautyCanonAction() { $id = $this->request->getQuery('id'); if (empty($id)) { echo '美粒宝典不存在!'; $this->view->disable(); return; } $canon = CosBeautyCanon::query()->columns(['title', 'content'])->where('id=:id:')->bind(['id' => $id])->execute()->getFirst(); if (!$canon) { echo '美粒宝典不存在!'; $this->view->disable(); return; } $this->view->setVar('canon', $canon); //$this->tag->setTitle($data['beauty_parlor']->name); }
public static function updateAssist($id) { $sql = 'UPDATE cos_beauty_canon SET assist = (SELECT COUNT(*) FROM cos_beauty_canon_assist WHERE beauty_canon_id=cos_beauty_canon.id) WHERE id = :bc_id'; $model = new CosBeautyCanon(); return $model->getWriteConnection()->execute($sql, ['bc_id' => $id]); }