model = Db::name('company_comment'); } /** * 列表 * @return void */ public function getList() { try { $companyId = $this->request->param('company_id',0); $companyId = !empty($companyId) ? $companyId : $this->auth->company_id; $cc = 'company_comment'; $u = 'user'; $field = $cc.'.id,'.$cc.'.user_id,info,images,'.$cc.'.createtime,'.$u.'.avatar,'.$u.'.nickname'; $where[$cc.'.company_id'] = $companyId; $result = $this->model->alias($cc)->field($field) ->join($u,$u.'.id = '.$cc.'.user_id','LEFT') ->where($where)->order($cc.'.createtime desc')->autopage()->select(); if (!empty($result)) { foreach ($result as $key => &$value) { empty($value['info']) && $value['info'] = '此用户没有填写评价。'; $value['createtime'] = !empty($value['createtime']) ? date('m月d日',$value['createtime']) : ''; unset($value['user_id']); } $result = list_domain_image($result,['images','avatar']); } $this->success('获取成功',$result); } catch (Exception $e) { $this->error($e->getMessage()); } } /** * 保存 * @return void */ public function save() { try { //用于上架审核提示 $commentSwitch = config('site.comment_switch');echo '
';var_dump($commentSwitch);exit;
if ($commentSwitch == 1) {
$this->success('提交成功,请等待审核。');
}
//验证参数
$id = $this->request->param('id',0);
$companyId = $this->request->param('company_id',0);
$companyId = !empty($companyId) ? $companyId : $this->auth->company_id;
$info = $this->request->param('info','');
$images = $this->request->param('images','');
if (empty($info) && $images) {
throw new Exception('参数有误');
}
$userId = $this->auth->id;
$scene = !empty($id) ? 'edit' : 'add';
$validate = validate('CompanyComment');
if(!$validate->check($this->request->param(),[],$scene)){
throw new Exception($validate->getError());
}
$time = time();
$data = [
'info' => $info,
'images' => $images,
];
$limitCreatetime = $time - 60;
$commentWhere['user_id'] = $userId;
$commentWhere['company_id'] = $companyId;
$commentWhere['createtime'] = ['gt',$limitCreatetime];
$commentData = $this->model->where($commentWhere)->find();
if (!empty($commentData) && empty($id)) {
throw new Exception('请不要频繁操作');
}
if (empty($id)) {
$data['company_id'] = $companyId;
$data['user_id'] = $userId;
$data['createtime'] = $time;
$res = $this->model->insertGetId($data);
} else {
$where['id'] = $id;
$where['user_id'] = $userId;
$res = $this->model->where($where)->update($data);
}
if (!$res) {
throw new Exception('操作失败');
}
$this->success('操作成功');
} catch (Exception $e) {
$this->error($e->getMessage());
}
}
}