ScoutController.php
2.5 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
<?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 ScoutController extends HomeBaseController
{
private $index_limit = 16;//首页分页
public function index(){
//旅游路线
$position['category_id'] = CityCategoryModel::lylx;
$field = 'id,thumbnail,post_title';
$res_lylx = $this->getChildArticle($position,$field,1);
$this->assign('res_lylx',$res_lylx);
//地道风物
$position['category_id'] = CityCategoryModel::ddfw;
$field = 'id,thumbnail,post_title,price';
$res_ddfw = $this->getChildArticle($position,$field);
$this->assign('res_ddfw',$res_ddfw);
//创意设计
$position['category_id'] = CityCategoryModel::cysj;
$field = 'id,thumbnail,post_title,price';
$res_cysj = $this->getChildArticle($position,$field);
$this->assign('res_cysj',$res_cysj);
//悦己悦人
$position['category_id'] = CityCategoryModel::yjyr;
$field = 'id,thumbnail,post_title,price';
$res_yjyr = $this->getChildArticle($position,$field);
$this->assign('res_yjyr',$res_yjyr);
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('delete_time', 0)
->field($field)
->limit($limit)
->order('weigh desc')
->select()
->toArray();
return $res;
}
}