EnjoyController.php
3.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
// +----------------------------------------------------------------------
// | ThinkCMF [ WE CAN DO IT MORE SIMPLE ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2019 http://www.thinkcmf.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Author: 老猫 <thinkcmf@126.com>
// +----------------------------------------------------------------------
namespace app\portal\controller;
use cmf\controller\HomeBaseController;
use app\portal\model\CityCategoryModel;
use think\Db;
//星享体验
class EnjoyController extends HomeBaseController
{
private $index_limit = 16;//首页分页
private $more_limit = 8;//更多列表分页
public function index(){
//按照城市查询
$city_id = $this->request->param('city_id');
$position['city_id'] = $city_id;
//亲临现场
$position['category_id'] = CityCategoryModel::qlxc;
$field = 'id,thumbnail,post_title,post_excerpt';
$res_qlxc = $this->getChildArticle($position,$field);
$this->assign('res_qlxc',$res_qlxc);
//市井漫游
$position['category_id'] = CityCategoryModel::yyzx;
$field = 'id,thumbnail,post_title,more';
$res_yyzx = $this->getChildArticle($position,$field);
foreach($res_yyzx as &$value){
$more = json_decode($value['more'],true);
if(isset($more['photos']) && !empty($more['photos'])){
$value['photos'] = $more['photos'][0]['url'];
}else{
$value['photos'] = '';
}
}
$this->assign('res_yyzx',$res_yyzx);
//视听盛宴
$position['category_id'] = CityCategoryModel::stsy;
$field = 'id,thumbnail,post_title,post_excerpt';
$res_stsy = $this->getChildArticle($position,$field);
$this->assign('res_stsy',$res_stsy);
//户外天堂
$position['category_id'] = CityCategoryModel::hwtt;
$field = 'id,thumbnail,post_title,post_excerpt';
$res_hwtt = $this->getChildArticle($position,$field);
$this->assign('res_hwtt',$res_hwtt);
return $this->fetch();
}
//根据子类获取文章
public function getChildArticle($position,$field,$limit=''){
$pre = CityCategoryModel::pre;
$limit = empty($limit)?0:$limit;
$post_id = Db::table($pre.'portal_category_post')
->whereIn('category_id',$position['category_id'])
->field('post_id')
->select()
->toArray();
$post_id = array_column($post_id,'post_id');
//查询文章
$res = Db::table($pre.'portal_post')
->whereIn('id',$post_id)
->where('city_id',$position['city_id'])
->where('delete_time', 0)
->field($field)
->limit($limit)
->order('weigh desc')
->select()
->toArray();
return $res;
}
}