一、控制器部分
<?php namespace app\user\controller; use app\index\controller\Common;
use app\user\model\HelpCenterFeedback as HelpCenterFeedbackModel;
use org\Response;
use app\index\logic\Upload;
use think\Request;
use org\Ucenter;
use think\Db; /**
* 帮助中心意见反馈控制器
* Class Feedback
* @package app\user\controller
*/
class Feedback extends Common
{
/**
* 反馈列表数据
* @return array
*/
public function index(Request $request)
{
$page = $request->get('page', 1);//页数
$row = $request->get('row', 2);//每页数据
$keywords = $request->get('keywords', '');//搜索关键词
$source = $request->get('source', '0');//版本 0-用户端 1-企业端
//查询模型取数据
$feedback = new HelpCenterFeedbackModel();
$feedback->getList($page, $row, $keywords, $source);
//提取模型查询的数据
$total = $feedback->total;
$pages = $feedback->pages;
$list = $feedback->list;
$data = [
'total' => $total,//数据总量
'page' => $page,//当前页
'pages' => $pages,//总页数
'trainlist' => $list,//数据详情
];
return Response::response(0, $data);
} public function create()
{
//
} public function edit(Request $request,$id)
{
//
} /**
* 反馈列表状态修改
* @param $id
* @return array
*/
public function update(Request $request,$id)
{
$status = $request->put('status','');
if (empty($status) && $status != '0') {
return Response::response(1005, [], '操作状态错误');
}
$res= Db::table('qj_help_center_feedback')->where('id',$id)->update(['status'=>$status]);
if ($res === false) Response::response(1, '修改失败');
return Response::response(0, '修改成功');
} }
二、模型
<?php namespace app\user\model; use Helper\JobHelper;
use Helper\ResumeHelper;
use think\Model;
use think\Request;
use traits\model\SoftDelete;
use think\Db; /**
* 帮助中心模型
* Class Feedback
* @package app\user\model
*/
class HelpCenterFeedback extends Model
{
/**
* @param $page 页数
* @param $row 每页数据
* @param $keywords 搜索关键词
* @param $source 版本 0-用户端 1-企业端
*/
public function getList($page, $row, $keywords, $source)
{
$offset = ($page - 1) * $row;
$where = [];
if ($keywords) {
$where['a.user_account'] = [ 'like', $keywords . '%'];
}
//0用户端，1企业端
$where['source'] = $source?$source:0;
//统计总数
$total = Db::table('qj_help_center_feedback')->alias('a')
->join('qj_feedback_type t','a.type=t.id','left')
->where($where)
->order('a.id asc')
->count();
//查询列表信息
$list = Db::table('qj_help_center_feedback')->alias('a')->field('a.*,t.type')
->join('qj_feedback_type t','a.type=t.id','left')
->where($where)
->order('a.id asc')
->limit($offset, $row)
->select();
//处理状态和图片路径处理
foreach ($list as $key => &$val) {
//处理状态转换
if ($val['status'] == 0) {
$val['status'] = '待处理';
} elseif ($val['status'] == 1) {
$val['status'] = '已回访';
} else {
$val['status'] = '忽略';
}
//图片path路径转oss路径
$img_arrs = [];
if ($val['img'] !='') {
$img_arr = explode(',',$val['img']);
foreach($img_arr as $k=>$v){
$img_arrs[$k]=get_image_url($v);
}
$list[$key]['img']=$img_arrs;
}
}
$this->pages = ceil($total / $row);
$this->list = $list;
$this->total = $total;
}
}
路由定义参考如下(这里定义的是资源路由)
return [
'__pattern__' => [
'name' => '\w+',
],
'/error' => 'index/error/index',//错误页面
'__rest__' => [
'user/feedback'=>'user/feedback',//帮助中心-意见反馈-用户端 ]
];
请求数据
数据如下
Status: 200 OK Time: 683 ms
{
"code": 0,
"message": "success",
-"data": {
"total": 25,
"page": "1",
"pages": 13,
-"trainlist": [
-{
"id": 51,
"user_account": "17076611177",
"version": "PC_3.0.0",
"type": "优化建议",
"content": "这些健议优化一下",
"addtime": "2018-05-11 09:22:43",
"status": "忽略",
"source": 0,
-"img": [
"http://zcplant1.oss-cn-shenzhen.aliyuncs.com/user/20180511/ddb5254c9dc2d65ec60cb377039c5a06.jpg",
"http://zcplant1.oss-cn-shenzhen.aliyuncs.com/user/20180511/ddb5254c9dc2d65ec60cb377039c5a06.jpg",
"http://zcplant1.oss-cn-shenzhen.aliyuncs.com/user/20180511/ddb5254c9dc2d65ec60cb377039c5a06.jpg"
]
},
-{
"id": 52,
"user_account": "17076611177",
"version": "PC_3.0.0",
"type": "优化建议",
"content": "123",
"addtime": "2018-05-11 14:49:17",
"status": "待处理",
"source": 0,
-"img": [
"http://zcplant1.oss-cn-shenzhen.aliyuncs.com/user/20180511/ddb5254c9dc2d65ec60cb377039c5a06.jpg"
]
}
]
}
}