AdminPostController.php
4.0 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
108
109
<?php
// +----------------------------------------------------------------------
// | bronet [ 以客户为中心 以奋斗者为本 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013-2017 http://www.bronet.cn All rights reserved.
// +----------------------------------------------------------------------
// | Licensed ( http://www.apache.org/licenses/LICENSE-2.0 )
// +----------------------------------------------------------------------
// | Author: 老猫 <bronet@126.com>
// +----------------------------------------------------------------------
namespace app\portal\controller;
use cmf\controller\AdminBaseController;
use function GuzzleHttp\Psr7\parse_header;
use think\Db;
class AdminPostController extends AdminBaseController
{
public function index(){
$param=$this->request->param();
$keywordComplex = [];
if (!empty($param['keyword'])) {
$keywordComplex['p.mobile|u.user_nickname']= ['like', "%".$param['keyword']."%"];
}
$data=Db::name('post')
->alias('p')
->join('user u','p.user_id=u.id')
->whereOr($keywordComplex)
->order('p.create_time','desc')
->field('p.*,u.user_nickname')
->paginate(10);
$data->appends($param);
$this->assign('keyword', isset($param['keyword']) ? $param['keyword'] : '');
$this->assign('page',$data->render());
$this->assign('list',$data);
return $this->fetch('index');
}
public function check(){
$param=$this->request->param();
$data=Db::name('post')
->alias('p')
->join('user u','p.user_id=u.id')
->where('p.id',$param['id'])
->field('p.*,u.user_nickname')
->find();
$data['skill_id']=explode(',',$data['skill_id']);
$data['skill']=Db::name('skill')->alias('s')->join('category c','s.category_id=c.id')->where('s.id','in',$data['skill_id'])->field('c.name,s.price')->select();
if ($data['sex']==1){
$data['sex']='男';
}elseif ($data['sex']==2){
$data['sex']='女';
}
if ($data['is_mobile']==1){
$data['is_mobile']='可以';
}elseif ($data['is_mobile']==0){
$data['is_mobile']='不可以';
}
if ($data['is_contact']==1){
$data['is_contact']='可以';
}elseif ($data['is_contact']==0){
$data['is_contact']='不可以';
}
$this->assign('list',$data);
return $this->fetch('check');
}
public function checkPost(){
$param=$this->request->param();
Db::name('post')->where('id',$param['id'])->update(['status'=>$param['status'],'remark'=>$param['remark']]);
return $this->success('审核成功',url('AdminPost/index'));
}
public function detail(){
$param=$this->request->param();
$data=Db::name('post')
->alias('p')
->join('user u','p.user_id=u.id')
->where('p.id',$param['id'])
->field('p.*,u.user_nickname')
->find();
$data['skill_id']=explode(',',$data['skill_id']);
$data['skill']=Db::name('skill')->alias('s')->join('category c','s.category_id=c.id')->where('s.id','in',$data['skill_id'])->field('c.name,s.price')->select();
if ($data['sex']==1){
$data['sex']='男';
}elseif ($data['sex']==2){
$data['sex']='女';
}
if ($data['is_mobile']==1){
$data['is_mobile']='可以';
}elseif ($data['is_mobile']==0){
$data['is_mobile']='不可以';
}
if ($data['is_contact']==1){
$data['is_contact']='可以';
}elseif ($data['is_contact']==0){
$data['is_contact']='不可以';
}
$this->assign('list',$data);
return $this->fetch('detail');
}
public function delete(){
$param=$this->request->param();
Db::name('post')->where('id',$param['id'])->delete();
return $this->success('删除成功');
}
}