public function listAction()
{
$this->setLeftNav('comment_list');
$req = $this->request;
$id = intval($req->getQuery('id', null, 0));
if ($id <= 0) {
$this->view->disable();
echo '美容院不存在！';
return;
}
$page = intval($req->getQuery('page', null, 1));
$page = $page > 0 ? $page : 1;
$limit = $this->pageNavLimit;
$offset = $limit * ($page - 1);
$list = BeautyParlorComment::query()->columns(['comment_id', 'ub.user_id', 'ub.user_nickname', 'ub.user_cover', 'ub.user_gender', 'comment_info', 'comment_photos', 'comment_state', 'comment_addtime', 'comment_reply', 'comment_reply_addtime'])->leftJoin('Apps\\Common\\Models\\UserBase', 'ub.user_id = Apps\\Common\\Models\\BeautyParlorComment.user_id', 'ub')->where('beauty_parlor_id = :id:', ['id' => $id])->limit($limit, $offset)->orderBy('comment_id DESC')->execute()->toArray();
foreach ($list as $k => $v) {
if (unserialize(base64_decode($v['comment_info']))) {
$list[$k]['comment_info'] = unserialize(base64_decode($v['comment_info']));
}
}
$total = BeautyParlorComment::count('beauty_parlor_id = ' . $id);
$this->view->setVar('commentList', $list);
$this->view->setVar('total', $total);
$this->view->setVar('page', $page);
$this->view->setVar('limit', $limit);
$this->view->setVar('id', $id);
}
/**
* 美容院评论列表
* @date: 2016年1月19日
* @author: chenxiaolin
*/
public function listAction()
{
$this->setLeftNav('comment_list');
$req = $this->request;
$id = intval($req->getQuery('id', null, 0));
if ($id <= 0) {
$this->view->disable();
echo '美容院不存在！';
return;
}
$page = intval($req->getQuery('page', null, 1));
$page = $page > 0 ? $page : 1;
$limit = $this->pageNavLimit;
$offset = $limit * ($page - 1);
$user_name = $req->getQuery('user_name');
$comment_addtime = $req->getQuery('comment_addtime');
$timeSlotarr = explode("至", $comment_addtime);
$where = [];
if ($user_name != '') {
$user = UserBase::query()->columns(['user_id'])->where("user_nickname like '%" . $user_name . "%'")->execute();
foreach ($user as $k => $v) {
$user_id .= $v['user_id'] . ',';
}
$user_id = rtrim($user_id, ",");
if (!empty($user_id)) {
$where[] = "Apps\\Common\\Models\\BeautyParlorComment.user_id in ( {$user_id} )";
} else {
$where[] = "Apps\\Common\\Models\\BeautyParlorComment.user_id in ( 0 )";
}
$this->view->setVar("user_name", $user_name);
}
if ($comment_addtime != '') {
$where[] = "comment_addtime > '" . $timeSlotarr[0] . "'";
$where[] = "comment_addtime < '" . $timeSlotarr[1] . "'";
$this->view->setVar("comment_addtime", $comment_addtime);
}
$where[] = "beauty_parlor_id = {$id}";
$whereStr = implode(' AND ', $where);
$list = BeautyParlorComment::query()->columns(['comment_id', 'ub.user_id', 'ub.user_nickname', 'ub.user_cover', 'ub.user_gender', 'comment_info', 'comment_photos', 'comment_state', 'comment_addtime', 'comment_reply', 'comment_reply_addtime'])->leftJoin('Apps\\Common\\Models\\UserBase', 'ub.user_id = Apps\\Common\\Models\\BeautyParlorComment.user_id', 'ub')->where($whereStr)->limit($limit, $offset)->orderBy('comment_id DESC')->execute()->toArray();
foreach ($list as $k => $v) {
if (unserialize(base64_decode($v['comment_info']))) {
$list[$k]['comment_info'] = unserialize(base64_decode($v['comment_info']));
}
}
//$total = BeautyParlorComment::count('beauty_parlor_id = ' . $id);
$total = BeautyParlorComment::count($whereStr);
$this->view->setVar('commentList', $list);
$this->view->setVar('total', $total);
$this->view->setVar('page', $page);
$this->view->setVar('limit', $limit);
$this->view->setVar('id', $id);
}
public function run()
{
$bp_id = intval($this->getDataItem('id', 0));
$page = intval($this->getDataItem('page', 1));
$limit = $this->getConfig()->limit;
$offset = ($page - 1) * $limit;
if (0 < $bp_id) {
$this->comments = BeautyParlorComment::query()->columns(['u.user_id', 'u.user_nickname', 'u.user_cover', 'u.user_expert', 'Apps\\Common\\Models\\BeautyParlorComment.comment_id as comment_id', 'Apps\\Common\\Models\\BeautyParlorComment.comment_info as comment_info', 'Apps\\Common\\Models\\BeautyParlorComment.comment_photos as comment_photos', 'Apps\\Common\\Models\\BeautyParlorComment.comment_floor as comment_floor', 'Apps\\Common\\Models\\BeautyParlorComment.comment_addtime as addtime'])->leftJoin('Apps\\Common\\Models\\UserBase', 'Apps\\Common\\Models\\BeautyParlorComment.user_id=u.user_id', 'u')->where('Apps\\Common\\Models\\BeautyParlorComment.beauty_parlor_id=' . $bp_id . ' and Apps\\Common\\Models\\BeautyParlorComment.comment_state = 1')->orderBy('Apps\\Common\\Models\\BeautyParlorComment.comment_id desc')->limit($limit, $offset)->execute()->toArray();
}
$this->comments = $this->comments ? $this->comments : [];
$data = [];
foreach ($this->comments as $arr) {
$arr['user_cover'] = PicUrl::UserCover($arr['user_cover'], $this->getDi());
$arr['comment_photos'] = PicUrl::BeautyParlorComment(json_decode($arr['comment_photos']), $this->getDi());
if (unserialize(base64_decode($arr['comment_info']))) {
$arr['comment_info'] = unserialize(base64_decode($arr['comment_info']));
}
$data[] = $arr;
}
$this->setResult($data);
}
public function run()
{
$id = intval($this->getDataItem('id', 0));
$user_id = intval($this->getDataItem('user_id', 0));
if (0 < $id) {
/**
* 查询基础信息
*/
$info = BeautyParlorModel::query()->columns(['bp_id as id', 'bp_name as name', 'bp_cover as cover', 'bp_address as address', 'bp_tel as tel', 'bp_medal as medal', 'bp_intro as intro', 'X(bp_coordinate) latitude', 'Y(bp_coordinate) longitude', 'bpa.open_time', 'bpa.close_time', 'bpa.low_price', 'bpa.open_year', 'bpa.shop_area', 'bpa.service_num', 'bpa.facilities'])->leftJoin('Apps\\Common\\Models\\BeautyParlorAttr', 'Apps\\Common\\Models\\BeautyParlor.bp_id = bpa.beauty_parlor_id', 'bpa')->where('Apps\\Common\\Models\\BeautyParlor.bp_state>0 and Apps\\Common\\Models\\BeautyParlor.bp_id=:id:')->bind(['id' => $id])->execute()->getFirst();
} else {
return $this->errorLog(ResultStatus::URL_PARAM_CANNOT_EMPTY, '参数异常');
}
if ($info) {
$this->parlor['id'] = $info->id;
$this->parlor['name'] = $info->name;
$this->parlor['cover'] = PicUrl::BeautyParlorCover($info->cover, $this->getDi());
$this->parlor['address'] = $info->address;
$this->parlor['tel'] = $info->tel;
$this->parlor['intro'] = $info->intro;
$this->parlor['latitude'] = $info->latitude;
$this->parlor['longitude'] = $info->longitude;
$this->parlor['medal_refund'] = \Apps\Common\Libs\BeautyParlor::getMedalRefund($info->medal);
$this->parlor['medal_verify'] = \Apps\Common\Libs\BeautyParlor::getMedalVerify($info->medal);
$this->parlor['open_time'] = $info->open_time == null ? '' : $info->open_time;
$this->parlor['close_time'] = $info->close_time == null ? '' : $info->close_time;
$this->parlor['low_price'] = $info->low_price == null ? '' : $info->low_price;
$this->parlor['open_year'] = $info->open_year == null ? '' : $info->open_year;
$this->parlor['shop_area'] = $info->shop_area == null ? '' : $info->shop_area;
$this->parlor['facilities'] = $info->facilities == null ? [] : (json_decode($info->facilities) ?: []);
$this->parlor['pics'] = [];
$this->parlor['services'] = [];
/**
* 增加图片列表 如果深度验店
*/
if ($this->parlor['medal_verify']) {
$pics = BeautyParlorPhotos::query()->columns(['photo_url url'])->where('photo_state>0 and beauty_parlor_id=:bid:')->bind(['bid' => $id])->execute()->toArray();
foreach ($pics as $pic) {
$this->parlor['pics'][] = PicUrl::BeautyParlorPic($pic['url'], $this->getDi());
}
/**
* 增加服务范围列表
*/
$service = BeautyParlorService::query()->columns(['service_id id', 'service_cover cover', 'service_name name', 'service_price price', 'service_unit unit', 'service_description description'])->where('service_state>0 and service_is_sell = 1 and beauty_parlor_id=:bid:')->bind(['bid' => $id])->limit(3, 0)->execute()->toArray();
foreach ($service as $d) {
$d['cover'] = PicUrl::BeautyParlorCover($d['cover'], $this->getDi());
$unit = $d['unit'];
unset($d['unit']);
$d['price_show'] = '';
if ($d['price'] > 0) {
$d['price_show'] = $d['price'] . '元' . ($unit ? '/' . $unit : '');
}
$this->parlor['services'][] = $d;
}
}
/**
* 增加tag列表
*/
$tag = BeautyParlorTag::query()->columns(['i.tag_title'])->leftJoin('Apps\\Common\\Models\\BeautyParlorTagInfo', 'Apps\\Common\\Models\\BeautyParlorTag.tag_id = i.tag_id', 'i')->where('i.tag_state=1 and bp_id=:bid:')->bind(['bid' => $id])->orderBy('sort desc,bp_tag_addtime asc')->execute()->toArray();
$this->parlor['tags'] = $tag;
// 评论总数
$this->parlor['comment_num'] = BeautyParlorComment::count(['conditions' => 'beauty_parlor_id = :bid: and comment_state = 1', 'bind' => ['bid' => $id]]);
//获取3条评论
$comments = BeautyParlorComment::query()->columns(['u.user_id', 'u.user_nickname', 'u.user_cover', 'u.user_gender', 'u.user_expert', 'Apps\\Common\\Models\\BeautyParlorComment.comment_id as comment_id', 'Apps\\Common\\Models\\BeautyParlorComment.comment_info as comment_info', 'Apps\\Common\\Models\\BeautyParlorComment.comment_photos as comment_photos', 'Apps\\Common\\Models\\BeautyParlorComment.comment_floor as comment_floor', 'Apps\\Common\\Models\\BeautyParlorComment.comment_addtime as addtime'])->leftJoin('Apps\\Common\\Models\\UserBase', 'Apps\\Common\\Models\\BeautyParlorComment.user_id=u.user_id', 'u')->where('Apps\\Common\\Models\\BeautyParlorComment.beauty_parlor_id=' . $id . ' and Apps\\Common\\Models\\BeautyParlorComment.comment_state = 1')->orderBy('Apps\\Common\\Models\\BeautyParlorComment.comment_addtime desc')->limit(3, 0)->execute()->toArray();
foreach ($comments as $arr) {
$arr['user_cover'] = PicUrl::UserCover($arr['user_cover'], $this->getDi());
$arr['comment_photos'] = PicUrl::BeautyParlorComment(json_decode($arr['comment_photos']), $this->getDi());
if (unserialize(base64_decode($arr['comment_info']))) {
$arr['comment_info'] = unserialize(base64_decode($arr['comment_info']));
}
$data[] = $arr;
}
$this->parlor['comments'] = $data;
} else {
return $this->errorLog(ResultStatus::QUERY_DATA_NOT_EXIST, 'ID不存在');
}
$this->parlor['favorite_num'] = BpFavorites::count(['conditions' => "bp_id = " . $this->parlor['id']]);
if ($user_id != '') {
$is_favorite = BpFavorites::findFirst("user_id = {$user_id} and bp_id =" . $this->parlor['id']);
/* var_dump($is_favorite);
exit; */
if ($is_favorite) {
$this->parlor['is_favorite'] = 1;
//已关注
} else {
$this->parlor['is_favorite'] = 0;
//未关注
}
} else {
$this->parlor['is_favorite'] = 0;
}
$this->setResult($this->parlor);
}
/**
* 预览美容院
* @date: 2016年1月28日
* @author: chenxiaolin
*/
public function beautyParlorPreviewAction()
{
$id = $this->request->getQuery('id');
if (empty($id)) {
echo '美容院不存在！';
$this->view->disable();
return;
}
//美容院
$parlor = BeautyParlor::query()->columns(['Apps\\Common\\Models\\BeautyParlor.bp_id', 'Apps\\Common\\Models\\BeautyParlor.bp_name as name', 'Apps\\Common\\Models\\BeautyParlor.bp_address', 'Apps\\Common\\Models\\BeautyParlor.bp_medal', 'Apps\\Common\\Models\\BeautyParlor.bp_intro', 'bpAttr.low_price', 'bpAttr.open_time', 'bpAttr.close_time', 'bpAttr.open_year', 'bpAttr.shop_area', 'bpAttr.service_num', 'bpAttr.facilities'])->leftJoin('Apps\\Common\\Models\\BeautyParlorAttr', 'Apps\\Common\\Models\\BeautyParlor.bp_id = bpAttr.beauty_parlor_id', 'bpAttr')->where("Apps\\Common\\Models\\BeautyParlor.bp_id = {$id}")->execute()->getFirst();
if ($parlor) {
$parlor->bp_medal = \Apps\Common\Libs\BeautyParlor::getMedalVerify($parlor->bp_medal);
$parlor->facilities = json_decode($parlor->facilities, true);
} else {
echo '美容院不存在！';
$this->view->disable();
return;
}
//标签
$tag = BeautyParlorTagInfo::query()->columns(['tag_title'])->leftJoin('Apps\\Common\\Models\\BeautyParlorTag', 'bpTag.tag_id = Apps\\Common\\Models\\BeautyParlorTagInfo.tag_id', 'bpTag')->where("bpTag.bp_id = {$id} and Apps\\Common\\Models\\BeautyParlorTagInfo.tag_state = 1")->execute()->toArray();
//轮播图片
$photos = BeautyParlorPhotos::query()->columns(['photo_url'])->where("beauty_parlor_id = {$id} and photo_state = 1")->execute()->toArray();
foreach ($photos as $k => $v) {
$photos[$k]['photo_url'] = PicUrl::BeautyParlorPic($photos[$k]['photo_url'], $this->getDI());
}
//服务项目
$service = BeautyParlorService::query()->columns(['service_name', 'service_price', 'service_cover'])->where("beauty_parlor_id = {$id}")->execute()->toArray();
foreach ($service as $k => $v) {
$service[$k]['service_cover'] = PicUrl::BeautyParlorCover($service[$k]['service_cover'], $this->getDI());
}
//用户评论
$comment = BeautyParlorComment::query()->columns(['u.user_id', 'u.user_nickname', 'u.user_cover', 'comment_addtime', 'comment_info', 'comment_photos'])->leftJoin('Apps\\Common\\Models\\UserBase', 'Apps\\Common\\Models\\BeautyParlorComment.user_id=u.user_id', 'u')->where("Apps\\Common\\Models\\BeautyParlorComment.beauty_parlor_id = {$id} and Apps\\Common\\Models\\BeautyParlorComment.comment_state = 1")->execute()->toArray();
foreach ($comment as $k => $v) {
$comment[$k]['user_cover'] = PicUrl::UserCover($comment[$k]['user_cover'], $this->getDI());
$comment[$k]['comment_photos'] = PicUrl::BeautyParlorComment(json_decode($comment[$k]['comment_photos'], true), $this->getDI());
if (unserialize(base64_decode($comment[$k]['comment_info']))) {
$comment[$k]['comment_info'] = unserialize(base64_decode($comment[$k]['comment_info']));
}
}
$this->view->setVar('parlor', $parlor);
$this->view->setVar('photos', $photos);
$this->view->setVar('service', $service);
$this->view->setVar('tag', $tag);
$this->view->setVar('comment', $comment);
$this->tag->setTitle($parlor['name']);
$this->assets->collection('footer')->addJs('/libs/zepto/zepto-1.1.6.min.js', false)->addJs('/libs/iscroll/iscroll.js', false)->addJs('/assets/frontend/js/share/bp-view.js', false);
}