where('t1.audit_status', $where['audit_status']); } if (!empty($where['mer_id'])) { $model = $model->where('t1.mer_id', $where['mer_id']); } if (!empty($where['apply_user_name'])) { $model = $model->where('t1.apply_user_name', 'like', '%' . $where['apply_user_name'] . '%'); } $list = $model->field('t1.*,t2.job_name,t3.name as companyName')->alias('t1')->leftJoin('job t2', 't1.apply_job_id=t2.id')->join('enterprise_user t3', 't1.mer_id=t3.id')->page($where['page'], $where['limit'])->order('t1.add_time desc')->select()->toArray(); $count = count($list); // 通过行业Id获取行业名 foreach ($list as &$v) { $v['add_time'] = date('Y-m-d H:i:s', $v['add_time']); } return JsonService::successlayui(['count' => $count, 'data' => $list]); } public function audit($data) { $find = self::get($data['id']); if (empty($find)) { return JsonService::fail('找不到记录'); } if ($find['audit_status'] !== 0) { return JsonService::fail('已经审核过'); } $user = User::get($find['apply_user_id']); if (empty($user)) { return JsonService::fail('找不到申请用户'); } if (!empty($user['mer_id'])) { return JsonService::fail('用户已经加入过企业'); } $id = $data['id']; unset($data['id']); $data['audit_admin_id'] = $this->adminInfo['id']; $data['audit_time'] = time(); $data['audit_status'] = intval($data['audit_status']); if ($data['audit_status'] == 1) { $data['pass_text'] = $data['text']; } else if ($data['audit_status'] == 2) { $data['fail_text'] = $data['text']; } else { return JsonService::fail('非法操作'); } if (!self::edit($data, $id)) { return JsonService::fail('审核失败'); } //更新用户 if ($data['audit_status'] == 1) { $updateUser = []; $updateUser['mer_id'] = $find['mer_id']; if (!User::edit($updateUser, $find['apply_user_id'])) { return JsonService::fail('关联用户失败'); } } return JsonService::successful('审核成功'); } /** * 用户是否有正在审核的记录 * @param $userId 用户 * @return bool true-有,false-无 */ public function hasApllying($userId) { $query = []; $query['apply_user_id'] = $userId; $query['is_delete'] = '0'; $query['audit_status'] = 0; return self::be($query); } public function getEmployeeList($where) { $model = self::where('t1.is_delete', '0'); if ($where['audit_status'] != -1) { $model = $model->where('t1.audit_status', $where['audit_status']); } if (!empty($where['mer_id'])) { $model = $model->where('t4.mer_id', $where['mer_id']); } if (!empty($where['apply_user_name'])) { $model = $model->where('t1.apply_user_name', 'like', '%' . $where['apply_user_name'] . '%'); } $list = $model->field('t1.*,t2.job_name,t3.name as companyName')->alias('t1')->leftJoin('job t2', 't1.apply_job_id=t2.id')->join('enterprise_user t3', 't1.mer_id=t3.id')->join('user t4', 't1.apply_user_id=t4.uid')->page($where['page'], $where['limit'])->order('t1.add_time desc')->select()->toArray(); $count = count($list); // 通过行业Id获取行业名 foreach ($list as &$v) { $v['add_time'] = date('Y-m-d H:i:s', $v['add_time']); } return JsonService::successlayui(['count' => $count, 'data' => $list]); } }