| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242 |
- <?php
- namespace App\Http\Controllers\Manager\External;
- use App\Http\Controllers\Controller;
- use App\Http\Requests\Manager\External\Company as Request;
- use App\Models\Manager\External\Company as CompanyModel;
- use Illuminate\Support\Facades\DB;
- use Illuminate\Support\Carbon;
- /**
- * 外部-公司管理
- * @author 唐远望
- * @version 1.0
- * @date 2026-02-03
- */
- class Company extends Controller
- {
- /**
- * 列表
- * @author 唐远望
- * @version 1.0
- * @date 2026-02-03
- *
- */
- public function list(Request $request, CompanyModel $CompanyModel)
- {
- $request->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' => '删除失败']);
- }
- }
- }
|