isAjax()){
$param = input('param.');
$limit = $param['pageSize'];
$offset = ($param['pageNumber'] - 1) * $limit;
$where = [];
if (empty($param['searchText']) === false) {
$where['account_name'] = $param['searchText'];
}
$start = '';$end = '';
if (empty($param['start']) === false && empty($param['end']) === false && $param['start'] <= $param['end']) {
$start = strtotime($param['start']);
$end = strtotime($param['end'] . ' 23:59:59');
}
// $join = [
// 'accounts b' => 'a.account_id = b.id',
// ];
$leftjoin = [
'users c' => 'a.user_id = c.id',
];
$result = model('Accountsmessage')->selectJoin($leftjoin,$where, $start,$end,$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['total'] = count($result); //总数据
$return['rows'] = $result;
return json($return);
}
return $this->fetch();
}
// 留言详情
public function detail()
{
if(request()->isAjax()) {
//设置留言公开/不公开
$param = input('post.');
$id = $param['id'];
$if_public = $param['if_public'];
try{
db('accountsmessage')->where('message_id', $id)->update(['if_public' => $if_public]);
}catch(\Exception $e){
return json(['code' => -1, 'data' => '', 'msg' => $e->getMessage()]);
}
return json(['code' => 1, 'data' => url('messages/index'), 'msg' => '设置成功']);
}
$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;
}
}