Company.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  1. <?php
  2. namespace App\Http\Controllers\Manager\External;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\Manager\External\Company as Request;
  5. use App\Models\Manager\External\Company as CompanyModel;
  6. use Illuminate\Support\Facades\DB;
  7. use Illuminate\Support\Carbon;
  8. /**
  9. * 外部-公司管理
  10. * @author 唐远望
  11. * @version 1.0
  12. * @date 2026-02-03
  13. */
  14. class Company extends Controller
  15. {
  16. /**
  17. * 列表
  18. * @author 唐远望
  19. * @version 1.0
  20. * @date 2026-02-03
  21. *
  22. */
  23. public function list(Request $request, CompanyModel $CompanyModel)
  24. {
  25. $request->scene('list')->validate();
  26. // 查询条件
  27. $map = [];
  28. $limit = request('limit', config('page_num', 10));
  29. $status = request('status', '');
  30. $start_time = request('start_time', '');
  31. $end_time = request('end_time', '');
  32. $company_name = request('company_name', '');
  33. // 时间条件
  34. if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)];
  35. if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)];
  36. // 其他条件
  37. if (is_numeric($status)) $map[] = ['status', '=', $status];
  38. if ($company_name) $map[] = ['company_name', 'like', "%$company_name%"];
  39. // 查询数据
  40. $result = $CompanyModel->query()
  41. ->where($map)
  42. ->orderByDesc('id')
  43. ->paginate($limit)->toarray();
  44. // 分配数据
  45. if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]);
  46. // 加载模板
  47. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]);
  48. }
  49. /**
  50. * 详情
  51. * @author 唐远望
  52. * @version 1.0
  53. * @date 2026-02-03
  54. */
  55. public function detail(Request $request, CompanyModel $CompanyModel)
  56. {
  57. $request->scene('detail')->validate();
  58. // 接收参数
  59. $id = request('id', 0);
  60. $map = ['id' => $id];
  61. // 权限判断
  62. $data = $CompanyModel->where($map)->first();
  63. if (!$data) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  64. $data->platform = isset($data->platform) ? explode(',', $data->platform) : '';
  65. // 加载模板
  66. return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $data]);
  67. }
  68. /**
  69. * 添加
  70. * @author 唐远望
  71. * @version 1.0
  72. * @date 2026-02-03
  73. *
  74. */
  75. public function add(Request $request, CompanyModel $CompanyModel)
  76. {
  77. $request->scene('add')->validate();
  78. $all_data = request()->all();
  79. //采集信息配置
  80. $minimum_order_quantity = request('minimum_order_quantity', 1);
  81. $sampling_cycle = request('sampling_cycle', '0');
  82. $sampling_start_time = request('sampling_start_time', '');
  83. $sampling_end_time = request('sampling_end_time', '');
  84. $all_data['sampling_cycle'] = $sampling_cycle;
  85. $all_data['sampling_start_time'] = $sampling_start_time ? strtotime($sampling_start_time . '00:00:00') : '0';
  86. $all_data['sampling_end_time'] = $sampling_end_time ? strtotime($sampling_end_time . '23:59:59') : '0';
  87. $all_data['minimum_order_quantity'] = $minimum_order_quantity;
  88. $allow_sampling_time = Carbon::tomorrow()->startOfDay()->getTimestamp(); // 明天的开始时间(允许开始采集时间校验)
  89. if ($all_data['sampling_start_time'] && $all_data['sampling_start_time'] < $allow_sampling_time) return json_send(['code' => 'error', 'msg' => '采集最早开始时间为明天']);
  90. //查询是否存在
  91. $map = ['company_name' => $all_data['company_name'], 'product_specs' => $all_data['product_specs'], 'platform' => $all_data['platform']];
  92. $data = $CompanyModel->where($map)->first();
  93. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  94. // 写入数据表
  95. $result = $CompanyModel->addCompany($all_data);
  96. // 如果操作失败
  97. if (!$result) return json_send(['code' => 'error', 'msg' => '新增失败']);
  98. // 记录行为
  99. $admin_id = request('access_token.uid', 0); //用户ID
  100. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  101. $table_name = $CompanyModel->getTable();
  102. $notes_type = 1; //操作类型,1添加,2修改,3=删除
  103. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, [], $all_data, '新增了公司' . $all_data['company_name'] . '信息');
  104. // 告知结果
  105. return json_send(['code' => 'success', 'msg' => '新增成功']);
  106. }
  107. /**
  108. * 修改
  109. * @author 唐远望
  110. * @version 1.0
  111. * @date 2026-02-03
  112. *
  113. */
  114. public function edit(Request $request, CompanyModel $CompanyModel)
  115. {
  116. $request->scene('edit')->validate();
  117. // 接收参数
  118. $id = request('id', 0);
  119. // 接收数据
  120. $all_data = request()->all();
  121. //采集信息配置
  122. $minimum_order_quantity = request('minimum_order_quantity', 1);
  123. $sampling_cycle = request('sampling_cycle', '0');
  124. $sampling_start_time = request('sampling_start_time', '');
  125. $sampling_end_time = request('sampling_end_time', '');
  126. $all_data['sampling_cycle'] = $sampling_cycle;
  127. $all_data['sampling_start_time'] = $sampling_start_time ? strtotime($sampling_start_time . '00:00:00') : '0';
  128. $all_data['sampling_end_time'] = $sampling_end_time ? strtotime($sampling_end_time . '23:59:59') : '0';
  129. $all_data['minimum_order_quantity'] = $minimum_order_quantity;
  130. //查询是否存在
  131. $map = ['company_name' => $all_data['company_name'], 'product_specs' => $all_data['product_specs'], 'platform' => $all_data['platform']];
  132. $data = $CompanyModel->where($map)->where('id', '!=', $id)->first();
  133. if ($data) return json_send(['code' => 'error', 'msg' => '记录已存在']);
  134. // 更新数据表
  135. $where = ['id' => $id];
  136. $Company = $CompanyModel->where($where)->first();
  137. if (!$Company) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  138. $oldData = $Company->toarray();
  139. $allow_sampling_time = Carbon::tomorrow()->startOfDay()->getTimestamp(); // 明天的开始时间(允许开始采集时间校验)
  140. if ($all_data['sampling_start_time'] && $all_data['sampling_start_time'] < $allow_sampling_time) return json_send(['code' => 'error', 'msg' => '采集最早开始时间为明天']);
  141. $result = $CompanyModel->editCompany_content($Company, $all_data);
  142. // 如果操作失败
  143. if (!$result) return json_send(['code' => 'error', 'msg' => '修改失败']);
  144. // 记录行为
  145. $admin_id = request('access_token.uid', 0); //用户ID
  146. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  147. $table_name = $CompanyModel->getTable();
  148. $notes_type = 2; //操作类型,1添加,2修改,3=删除
  149. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, $oldData, $all_data, '修改了公司' . $oldData['company_name'] . '信息');
  150. // 告知结果
  151. return json_send(['code' => 'success', 'msg' => '修改成功']);
  152. }
  153. /**
  154. * 修改状态
  155. * @author 唐远望
  156. * @version 1.0
  157. * @date 2026-02-03
  158. *
  159. */
  160. public function set_status(Request $request, CompanyModel $CompanyModel)
  161. {
  162. // 验证参数
  163. $request->scene('set_status')->validate();
  164. $is_admin = request('access_token.is_admin', '0');
  165. // 接收数据
  166. $id = request('id', 0);
  167. $status = request('status', 0);
  168. $where = ['id' => $id];
  169. $Company = $CompanyModel->where($where)->first();
  170. if (!$Company) return json_send(['code' => 'error', 'msg' => '记录不存在']);
  171. // 执行修改
  172. $result = $CompanyModel->changeStatus($Company, $status);
  173. // 提示新增失败
  174. if (!$result) return json_send(['code' => 'error', 'msg' => '设置失败']);
  175. // 记录行为
  176. $admin_id = request('access_token.uid', 0); //用户ID
  177. $table_name = $CompanyModel->getTable();
  178. $notes_type = 2; //操作类型,1添加,2修改,3=删除
  179. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, [], ['status' => $status], '修改了公司' . $Company->company_name . '状态');
  180. // 告知结果
  181. return json_send(['code' => 'success', 'msg' => '设置成功']);
  182. }
  183. /**
  184. * 删除
  185. * @author 唐远望
  186. * @version 1.0
  187. * @date 2026-02-03
  188. *
  189. */
  190. public function delete(Request $request, CompanyModel $CompanyModel)
  191. {
  192. // 验证参数
  193. $request->scene('delete')->validate();
  194. // 接收数据
  195. $id = request('id', 0);
  196. // 查询用户
  197. $where = ['id' => $id];
  198. // 执行删除
  199. $Company = $CompanyModel->where($where)->first();
  200. if (!$Company) {
  201. return json_send(['code' => 'error', 'msg' => '删除失败,记录不存在']);
  202. }
  203. DB::beginTransaction();
  204. try {
  205. $Company->delete();
  206. // 记录行为
  207. $admin_id = request('access_token.uid', 0); //用户ID
  208. $is_admin = request('access_token.is_admin'); //是否管理员操作 0=是1=否
  209. $table_name = $CompanyModel->getTable();
  210. $notes_type = 3; //操作类型,1添加,2修改,3=删除
  211. $this->addAdminHistory('外部-公司管理', 0, $admin_id, $is_admin, $table_name, $notes_type, $Company->toarray(), [], '删除了公司' . $Company->company_name . '信息');
  212. // 告知结果
  213. DB::commit();
  214. return json_send(['code' => 'success', 'msg' => '删除成功']);
  215. // 成功处理...
  216. } catch (\Exception $e) {
  217. DB::rollBack();
  218. // 错误处理...
  219. return json_send(['code' => 'error', 'msg' => '删除失败']);
  220. }
  221. }
  222. }