scene('list')->validate(); // 查询条件 $map = []; $limit = request('limit', config('page_num', 10)); $status = request('status', ''); $start_time = request('start_time', ''); $end_time = request('end_time', ''); $company_name = request('company_name', ''); // 时间条件 if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)]; if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)]; // 其他条件 if (is_numeric($status)) $map[] = ['status', '=', $status]; if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"]; // 查询数据 $result = $CompanyModel->query() ->where($map) ->orderByDesc('id') ->paginate($limit)->toarray(); // 分配数据 if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]); // 加载模板 return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]); } /** * 全部 * @author 唐远望 * @version 1.0 * @date 2026-02-03 * */ public function all(Request $request, CompanyModel $CompanyModel) { $request->scene('all')->validate(); // 查询条件 $map = []; $start_time = request('start_time', ''); $end_time = request('end_time', ''); $company_name = request('company_name', ''); // 时间条件 if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)]; if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)]; // 其他条件 $map[] = ['status', '=', 0]; if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"]; // 查询数据 $result = $CompanyModel->query() ->where($map) ->orderByDesc('id') ->get(); // 分配数据 if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]); // 加载模板 return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]); } /** * 详情 * @author 唐远望 * @version 1.0 * @date 2026-02-03 */ public function detail(Request $request, CompanyModel $CompanyModel) { $request->scene('detail')->validate(); // 接收参数 $id = request('id', 0); $map = ['id' => $id]; // 权限判断 $data = $CompanyModel->where($map)->first(); if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']); // 加载模板 return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]); } /** * 添加 * @author 唐远望 * @version 1.0 * @date 2026-02-03 * */ public function add(Request $request, CompanyModel $CompanyModel) { $request->scene('add')->validate(); $all_data = request()->all(); //查询是否存在 $map = ['social_credit_code' => $all_data['social_credit_code']]; $data = $CompanyModel->where($map)->first(); if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']); // 写入数据表 $result = $CompanyModel->addCompany($all_data); // 如果操作失败 if (!$result) return json_send(['code' => 'error', 'msg' => '新增失败']); // 记录行为 $admin_id = request('access_token.uid', 0); //用户ID $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否 $table_name = $CompanyModel->getTable(); $notes_type = 1; //操作类型,1添加,2修改,3=删除 $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, [], $all_data, '新增了公司' . $all_data['company_name'] . '信息'); // 告知结果 return json_send(['code' => 'success', 'msg' => '新增成功']); } /** * 修改 * @author 唐远望 * @version 1.0 * @date 2026-02-03 * */ public function edit(Request $request, CompanyModel $CompanyModel) { $request->scene('edit')->validate(); // 接收参数 $id = request('id', 0); // 接收数据 $all_data = request()->all(); //查询是否存在 $map = ['social_credit_code' => $all_data['social_credit_code']]; $data = $CompanyModel->where($map)->where('id', '!=', $id)->first(); if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']); // 更新数据表 $where = ['id' => $id]; $Company = $CompanyModel->where($where)->first(); if (!$Company) return json_send(['code' => 'error', 'msg' => '记录不存在']); $oldData = $Company->toarray(); $result = $CompanyModel->editCompany_content($Company, $all_data); // 如果操作失败 if (!$result) return json_send(['code' => 'error', 'msg' => '修改失败']); // 记录行为 $admin_id = request('access_token.uid', 0); //用户ID $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否 $table_name = $CompanyModel->getTable(); $notes_type = 2; //操作类型,1添加,2修改,3=删除 $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, $oldData, $all_data, '修改了公司' . $oldData['company_name'] . '信息'); // 告知结果 return json_send(['code' => 'success', 'msg' => '修改成功']); } /** * 修改状态 * @author 唐远望 * @version 1.0 * @date 2026-02-03 * */ public function set_status(Request $request, CompanyModel $CompanyModel) { // 验证参数 $request->scene('set_status')->validate(); $is_admin = request('access_token.is_admin', '0'); // 接收数据 $id = request('id', 0); $status = request('status', 0); $where = ['id' => $id]; $Company = $CompanyModel->where($where)->first(); if (!$Company) return json_send(['code' => 'error', 'msg' => '记录不存在']); // 执行修改 $result = $CompanyModel->changeStatus($Company, $status); // 提示新增失败 if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']); // 记录行为 $admin_id = request('access_token.uid', 0); //用户ID $table_name = $CompanyModel->getTable(); $notes_type = 2; //操作类型,1添加,2修改,3=删除 $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, [], ['status' => $status], '修改了公司' . $Company->company_name . '状态'); // 告知结果 return json_send(['code' => 'success', 'msg' => '设置成功']); } /** * 删除 * @author 唐远望 * @version 1.0 * @date 2026-02-03 * */ public function delete(Request $request, CompanyModel $CompanyModel) { // 验证参数 $request->scene('delete')->validate(); // 接收数据 $id = request('id', 0); // 查询用户 $where = ['id' => $id]; // 执行删除 $Company = $CompanyModel->where($where)->first(); if (!$Company) { return json_send(['code' => 'error', 'msg' => '删除失败,记录不存在']); } DB::beginTransaction(); try { $Company->delete(); // 记录行为 $admin_id = request('access_token.uid', 0); //用户ID $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否 $table_name = $CompanyModel->getTable(); $notes_type = 3; //操作类型,1添加,2修改,3=删除 $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, $Company->toarray(), [], '删除了公司' . $Company->company_name . '信息'); // 告知结果 DB::commit(); return json_send(['code' => 'success', 'msg' => '删除成功']); // 成功处理... } catch (\Exception $e) { DB::rollBack(); // 错误处理... return json_send(['code' => 'error', 'msg' => '删除失败']); } } }