TestController.php
3.8 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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<?php
// +----------------------------------------------------------------------
// | bronet [ 以客户为中心 以奋斗者为本 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2017 http://www.bronet.cn All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
namespace app\portal\controller;
use cmf\controller\WeChatBaseController;
use cmf\controller\HomeBaseController;
use EasyWeChat\Foundation\Application;
use think\db;
use Yunpian\Sdk\YunpianClient;
class TestController extends WeChatBaseController
{
// public function _initialize()
// {
// $this->checkWeChatUserLogin();
//
// }
//模拟进行渲染
public function index()
{
$this->checkWeChatUserLogin();
//获取搜索参数
$param=$this->request->param();
$where=[];
$name = empty($param['name']) ? "" : empty($param['name']);
$search_address = empty($param['address']) ? "" : empty($param['address']);
if (!empty($name)){
$where['name']=['like',"%$name%"];
}
if (!empty($search_address)){
$where['address']=['like',"%$search_address%"];
}
$data=Db::name('temple')->select()->each(function ($item) {
$item['count'] = Db::name('light_order')
->alias('lo')
->join('light l','lo.light_id=l.id')
->join('temple t','l.temple_id=t.id')
->where(['lo.status'=>1,'t.id'=>$item['id']/*,'lo.end_time'=>['<',time()]*/])
->count();
return $item;
});
$address=Db::name('temple')->distinct(true)->field('address')->select();
$this->assign('address',$address);
$this->assign('list',$data);
$this->assign('name',$name);
$this->assign('search_address',$search_address);
return $this->fetch();
}
//寺庙下区域
public function templeArea(){
$param=$this->request->param();
$data=Db::name('temple_area')->where('temple_id',$param['id'])->select()->each(function ($item) {
$not_empty=Db::name('light_order')->where(['status'=>1,'end_time'=>['<',time()]])->column('light_id');
$item['empty'] = Db::name('light')
->alias('l')
->join('temple_area ta','l.area_id=ta.id')
->where(['l.id'=>['not in',$not_empty]])
->count();
return $item;
});
$this->assign('list',$data);
return$this->fetch();
}
//区域下财神灯位置
public function light(){
$param=$this->request->param();
$param['id']=1;
$row= $data=Db::name('light')
->alias('l')
->join('temple_area ta','l.area_id=ta.id')
->where(['l.area_id'=>$param['id']])
->distinct(true)
->field('l.row')
->order('l.row','dec')
->column('l.row');
foreach ($row as $k=>$v){
$arr[$v]=Db::name('light')->alias('l')->join('light_order lo','lo.light_id=l.id')->where('l.row',$v)->select()->toArray();
}
$this->assign('empty',$param['empty']);
$this->assign('list',$arr);
return $this->fetch();
}
//财神详情
public function details(){
}
public function sendMessage(){
$clnt = YunpianClient::create('ae02d6c1c41748b663c3f31ba5a03da8');
$param = [YunpianClient::MOBILE => '17694933850',YunpianClient::TEXT => '【云片网】接口测试'];
$r = $clnt->sms()->single_send($param);
var_dump($r);
if($r->isSucc()){
$r->data();
}
}
}