isAjax()){
$param = input('param.');
$limit = $param['pageSize'];
$offset = (($param['pageNumber'] - 1) * $limit);
$where = [];
if (empty($param['searchText']) === false) {
$where['user_name'] = $param['searchText'];
}
$join = [
'accounts b' => 'a.account_id = b.id',
];
$leftjoin = [
'users c' => 'a.user_id = c.id',
];
$result = model('Accountsmessage')->selectJoin($join,$leftjoin,$where, $offset, $limit);
foreach($result as $key=>$vo){
// 优化显示附件
$result[$key]['image'] = '
';
// 优化时间
if(null != $vo['add_time']){
$result[$key]['add_time'] = date('Y-m-d H:m:s',$result[$key]['add_time']);
}
if(null != $vo['dealWith_time']){
$result[$key]['dealWith_time'] = date('Y-m-d H:m:s',$result[$key]['dealWith_time']);
}
// 优化显示状态
if(1 == $vo['message_status']){
$result[$key]['status'] = '已处理';
}else{
$result[$key]['status'] = '未处理';
}
// 生成操作按钮
$result[$key]['operate'] = $this->makeBtn($vo['message_id']);
}
$return['total'] = db('Accountsmessage')->count(); //总数据
$return['rows'] = $result;
return json($return);
}
return $this->fetch();
}
// 留言详情
public function detail()
{
$id = input('param.id/d');
$info = db('Accountsmessage')->where('message_id', $id)->find();
$account = db('Accounts')->where('id', $info['account_id'])->find();
$user = db('Users')->where('id', $info['user_id'])->find();
$info['account_name'] = $account['account_name'];
$info['account_email'] = $account['account_email'];
$info['user_name'] = $user['user_name'];
// 优化时间
if(null != $info['add_time']){
$info['add_time'] = date('Y-m-d H:m:s',$info['add_time']);
}
if(null != $info['dealWith_time']){
$info['dealWith_time'] = date('Y-m-d H:m:s',$info['dealWith_time']);
}
// 优化显示状态
if(1 == $info['message_status']){
$info['message_status'] = '已处理';
}else{
$info['message_status'] = '未处理';
}
$this->assign([
'info' => $info,
'status' => config('kf_status'),
// 'groups' => db('groups')->select()
]);
return $this->fetch();
}
// 上传客服头像
public function upAvatar()
{
if(request()->isAjax()) {
$file = request()->file('file');
if (!empty($file)) {
// 移动到框架应用根目录/public/uploads/ 目录下
$info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
if ($info) {
$src = '/uploads' . '/' . date('Ymd') . '/' . $info->getFilename();
return json(['code' => 0, 'data' => ['src' => $src], 'msg' => 'ok']);
} else {
// 上传失败获取错误信息
return json(['code' => -1, 'data' => '', 'msg' => $file->getError()]);
}
}
}
}
// 生成按钮
private function makeBtn($id)
{
$operate = '';
// $operate .= ' ';
//
// $operate .= ' ';
//$operate .= '';
$operate .= '';
return $operate;
}
}