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 listAction()
{
$this->setLeftNav('list');
$req = $this->request;
$page = intval($req->getQuery('page', null, 1));
$page = $page > 0 ? $page : 1;
$limit = $this->pageNavLimit;
$offset = $limit * ($page - 1);
if ($req->getQuery('title') != '') {
$wherearr[] = "title like '%" . $req->getQuery('title') . "%'";
$this->view->setVar("title", $req->getQuery("title"));
}
$timeSlotarr = explode("至", $req->getQuery('timeSlot'));
if ($req->getQuery('timeSlot')) {
$wherearr[] = "settime > '" . $timeSlotarr[0] . "'";
$wherearr[] = "settime < '" . $timeSlotarr[1] . "'";
$this->view->setVar("timeSlot", $req->getQuery("timeSlot"));
}
$wherearr[] = "state <> 3";
$where = implode(" and ", $wherearr);
$query = CosBeautyCanon::query();
$total = CosBeautyCanon::count(['conditions' => $where]);
$list = $query->where($where)->orderBy('settime DESC')->limit($limit, $offset)->execute()->toArray();
foreach ($list as $k => $v) {
$list[$k]['img_url'] = PicUrl::BeautyParlorPic($list[$k]['img_url'], $this->getDi());
}
$this->view->setVar("total", $total);
$this->view->setVar("limit", $limit);
$this->view->setVar("page", $page);
$this->view->setVar("list", $list);
}
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);
}
/**
* 美粒宝典列表
* @date: 2016年1月4日
* @author: chenxiaolin
*/
public function listAction()
{
$this->setLeftNav('list');
$req = $this->request;
$page = intval($req->getQuery('page', null, 1));
$page = $page > 0 ? $page : 1;
$limit = $this->pageNavLimit;
$offset = $limit * ($page - 1);
$title = $req->getQuery('title');
$filterCity = intval($req->getQuery('filterCity', null, -10000));
if ($title != '') {
$wherearr[] = "title like '%" . $title . "%'";
$this->view->setVar("title", $title);
}
if ($filterCity > -10000) {
$wherearr[] = "Apps\\Common\\Models\\CosBeautyCanon.city_id = {$filterCity}";
}
$state = $req->getQuery('state');
$this->view->setVar("state", $state);
//$wherearr[]="state <> 3";
$wherearr[] = "state = {$state}";
$where = implode(" and ", $wherearr);
$query = CosBeautyCanon::query();
$total = CosBeautyCanon::count(['conditions' => $where]);
$list = $query->columns(['Apps\\Common\\Models\\CosBeautyCanon.id', 'Apps\\Common\\Models\\CosBeautyCanon.title', 'Apps\\Common\\Models\\CosBeautyCanon.img_url', 'soc.city_name', 'Apps\\Common\\Models\\CosBeautyCanon.fit', 'Apps\\Common\\Models\\CosBeautyCanon.assist', 'Apps\\Common\\Models\\CosBeautyCanon.state', 'Apps\\Common\\Models\\CosBeautyCanon.settime', 'Apps\\Common\\Models\\CosBeautyCanon.city_id'])->leftJoin('Apps\\Common\\Models\\SysOpenCity', 'soc.city_id=Apps\\Common\\Models\\CosBeautyCanon.city_id', 'soc')->where($where)->orderBy('Apps\\Common\\Models\\CosBeautyCanon.settime DESC')->limit($limit, $offset)->execute()->toArray();
//封面图片地址处理
foreach ($list as $k => $v) {
$list[$k]['img_url'] = PicUrl::BeautyParlorPic($list[$k]['img_url'], $this->getDi());
}
$this->view->setVar("total", $total);
$this->view->setVar("limit", $limit);
$this->view->setVar("page", $page);
$this->view->setVar("list", $list);
$this->view->setVar("filterCity", $filterCity);
$this->view->setVar('openCity', SysOpenCity::find('city_state = 1'));
}
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);
}
/**
* 美粒宝典预览
* @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);
}
