WorkOrderController.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536
  1. <?php
  2. namespace App\Http\Controllers\App;
  3. use App\Filters\WorkOrderFilter;
  4. use App\Http\Resources\App\WorkOrderResource;
  5. use App\Http\Resources\WarningLogResource;
  6. use App\Jobs\VerifyChargeWorkOrderJob;
  7. use App\Jobs\VerifyWatchWorkOrderJob;
  8. use App\Models\AdminUser;
  9. use App\Models\Bike;
  10. use App\Models\LocationsLog;
  11. use App\Models\WarningLog;
  12. use App\Models\WorkOrder;
  13. use App\Utils\Admin;
  14. use App\Utils\GaodeMaps;
  15. use App\Utils\RedisKeys;
  16. use Carbon\Carbon;
  17. use Illuminate\Http\Request;
  18. use App\Http\Controllers\Controller;
  19. use Illuminate\Support\Facades\DB;
  20. use Illuminate\Support\Facades\Log;
  21. use Illuminate\Support\Facades\Redis;
  22. class WorkOrderController extends AppBaseController
  23. {
  24. /**
  25. * workOrderList 工单列表
  26. *
  27. * @param WorkOrderFilter $workOrderFilter
  28. * @return \Illuminate\Http\JsonResponse
  29. * @author Fx
  30. *
  31. */
  32. public function workOrderList(WorkOrderFilter $workOrderFilter)
  33. {
  34. $area_ids = self::$areaIds;
  35. $workOrderList = WorkOrder::query()
  36. ->whereIn('area_id', $area_ids)
  37. ->filter($workOrderFilter)
  38. ->orderBy('planned')
  39. ->orderByDesc('id')
  40. ->paginate();
  41. return $this->ok(WorkOrderResource::collection($workOrderList));
  42. }
  43. /**
  44. * myWorkOrder 我的工单列表
  45. *
  46. * @param WorkOrderFilter $workOrderFilter
  47. * @return \Illuminate\Http\JsonResponse
  48. * @author Fx
  49. *
  50. */
  51. public function myWorkOrder(WorkOrderFilter $workOrderFilter)
  52. {
  53. $admin_id = Admin::user()->id;
  54. $area_ids = self::$areaIds;
  55. $workOrderList = WorkOrder::query()
  56. ->whereIn('area_id', $area_ids)
  57. ->filter($workOrderFilter)
  58. ->where('worker_id', $admin_id)
  59. ->orderByDesc('id')
  60. ->paginate();
  61. return $this->ok(WorkOrderResource::collection($workOrderList));
  62. }
  63. /**
  64. * workOrderDetail 工单详情
  65. *
  66. * @param Request $request
  67. * @return \Illuminate\Http\JsonResponse
  68. * @author Fx
  69. *
  70. */
  71. public function workOrderDetail(Request $request)
  72. {
  73. $work_order_id = $request->get('work_order_id') ?? '';
  74. if (empty($work_order_id)) return $this->error('参数错误');
  75. $worker_order = WorkOrder::query()->find($work_order_id);
  76. if (empty($worker_order)) return $this->error('找不到该工单信息,请联系管理员');
  77. // 创建者
  78. $created_at = $worker_order->created_at;
  79. $created_man = WorkOrder::$sourceMaps[$worker_order->source];
  80. // 进度
  81. $planneds = WorkOrder::$plannedMaps[$worker_order->planned];
  82. $planned = $worker_order->planned;
  83. // 接单着
  84. $received_name = $worker_order->worker->name ?? '';
  85. $received_at = $worker_order->fix_start_time ?? '';
  86. $position = LocationsLog::getNewestLocationByBikeNo($worker_order->bike_no);
  87. $reason = $worker_order->reason ?? '';
  88. $type = $worker_order->type;
  89. // if($type === WorkOrder::TYPE_TROUBLE){
  90. $str = '';
  91. if (is_serialized($reason)) {
  92. $reasonArr = unserialize($reason);
  93. foreach ($reasonArr as $k => $v) {
  94. if ($v == 1) {
  95. $str .= WorkOrder::$warningMaps[$k] . "、";
  96. }
  97. }
  98. $str = rtrim($str, '、');
  99. $reason = $str;
  100. }
  101. // }
  102. $data = [
  103. 'reason' => empty($reason) ? $worker_order->type_name : $reason,
  104. 'planned' => $planned,
  105. 'planneds' => $planneds,
  106. 'bike_no' => $worker_order->bike_no,
  107. 'location' => GaodeMaps::getAddress([$position['lng'], $position['lat']]),
  108. 'created_at' => Carbon::parse($created_at)->format('Y-m-d H:i:s'),
  109. 'times' => $worker_order->times,
  110. 'created_man' => $created_man
  111. ];
  112. switch ($planned) {
  113. case WorkOrder::PLANNED_STATUS_MEET:
  114. $data += [
  115. 'received_name' => '',
  116. 'received_at' => '',
  117. 'work_over_time' => '',
  118. 'work_over_name' => '',
  119. ];
  120. break;
  121. case WorkOrder::PLANNED_STATUS_WORK:
  122. $data += [
  123. 'received_name' => $received_name,
  124. 'received_at' => Carbon::parse($received_at)->format('Y-m-d H:i:s'),
  125. 'work_over_time' => '',
  126. 'work_over_name' => '',
  127. ];
  128. break;
  129. case WorkOrder::PLANNED_STATUS_WORKED:
  130. $data += [
  131. 'received_name' => $received_name,
  132. 'received_at' => Carbon::parse($received_at)->format('Y-m-d H:i:s'),
  133. 'work_over_time' => Carbon::parse($worker_order->fix_end_time)->format('Y-m-d H:i:s'),
  134. 'work_over_name' => $worker_order->workerOver->name ?? '系统',
  135. ];
  136. break;
  137. case WorkOrder::PLANNED_STATUS_OVER:
  138. $data += [
  139. 'received_name' => $received_name,
  140. 'received_at' => Carbon::parse($received_at)->format('Y-m-d H:i:s'),
  141. 'work_over_time' => Carbon::parse($worker_order->fix_end_time)->format('Y-m-d H:i:s'),
  142. 'work_over_name' => $worker_order->workerOver->name ?? '系统',
  143. ];
  144. break;
  145. default :
  146. $data += [
  147. 'received_name' => '',
  148. 'received_at' => '',
  149. 'work_over_time' => '',
  150. 'work_over_name' => '',
  151. ];
  152. }
  153. return $this->ok($data);
  154. }
  155. /**
  156. * workOrderStatistics 工单统计
  157. *
  158. * @param WorkOrderFilter $filter
  159. * @return \Illuminate\Http\JsonResponse
  160. * @author Fx
  161. *
  162. */
  163. public function workOrderStatistics(WorkOrderFilter $filter)
  164. {
  165. $area_ids = self::$areaIds;
  166. $type_num = WorkOrder::query()
  167. ->whereIn('area_id', $area_ids)
  168. ->where('status', WorkOrder::STATUS_NO)
  169. ->filter($filter)
  170. ->groupBy(['type'])
  171. ->select('type', DB::raw('COUNT(id) as type_num'))
  172. ->get()
  173. ->toArray();
  174. $data = [
  175. 'charge_num' => 0,
  176. 'watch_num' => 0,
  177. 'power_failure_num' => 0,
  178. 'alert_num' => 0,
  179. 'steal_num' => 0,
  180. 'headman_num' => 0,
  181. 'trouble_num' => 0,
  182. 'help_num' => 0,
  183. 'other_num' => 0,
  184. 'offline_num' => 0,
  185. 'planned_meet_num' => 0, // 未认领
  186. 'planned_work_num' => 0, // 处理中
  187. 'planned_worked_num' => 0, // 已处理
  188. 'planned_over_num' => 0,// 完结
  189. ];
  190. foreach ($type_num as $v) {
  191. switch ($v['type']) {
  192. case WorkOrder::TYPE_CHARGE:
  193. $data['charge_num'] = $v['type_num'];
  194. break;
  195. case WorkOrder::TYPE_WATCH:
  196. $data['watch_num'] = $v['type_num'];
  197. break;
  198. case WorkOrder::TYPE_POWER_FAILURE:
  199. $data['power_failure_num'] = $v['type_num'];
  200. break;
  201. case WorkOrder::TYPE_ALERT:
  202. $data['alert_num'] = $v['type_num'];
  203. break;
  204. case WorkOrder::TYPE_STEAL:
  205. $data['steal_num'] = $v['type_num'];
  206. break;
  207. case WorkOrder::TYPE_HEADMAN:
  208. $data['headman_num'] = $v['type_num'];
  209. break;
  210. case WorkOrder::TYPE_TROUBLE:
  211. $data['trouble_num'] = $v['type_num'];
  212. break;
  213. case WorkOrder::TYPE_HELP:
  214. $data['help_num'] = $v['type_num'];
  215. break;
  216. case WorkOrder::TYPE_OFFLINE:
  217. $data['offline_num'] = $v['type_num'];
  218. break;
  219. case WorkOrder::TYPE_OTHER:
  220. $data['other_num'] = $v['type_num'];
  221. break;
  222. default;
  223. }
  224. }
  225. $planned_num = WorkOrder::query()
  226. ->filter($filter)
  227. ->groupBy('planned')
  228. ->select('planned', DB::raw('COUNT(id) as planned_num'))
  229. ->get()
  230. ->toArray();
  231. foreach ($planned_num as $v) {
  232. switch ($v['planned']) {
  233. case WorkOrder::PLANNED_STATUS_MEET:
  234. $data['planned_meet_num'] = $v['planned_num'];
  235. break;
  236. case WorkOrder::PLANNED_STATUS_WORK:
  237. $data['planned_work_num'] = $v['planned_num'];
  238. break;
  239. case WorkOrder::PLANNED_STATUS_WORKED:
  240. $data['planned_worked_num'] = $v['planned_num'];
  241. break;
  242. case WorkOrder::PLANNED_STATUS_OVER:
  243. $data['planned_over_num'] = $v['planned_num'];
  244. break;
  245. default;
  246. }
  247. }
  248. return $this->ok($data);
  249. }
  250. /**
  251. * workOrderType 筛选项工单类型
  252. *
  253. * @return \Illuminate\Http\JsonResponse
  254. * @author Fx
  255. *
  256. */
  257. public function workOrderType()
  258. {
  259. $types = WorkOrder::$typeMaps;
  260. $data = [];
  261. foreach ($types as $k => $v) {
  262. $dataItem['key'] = $k;
  263. $dataItem['value'] = $v;
  264. $data[] = $dataItem;
  265. }
  266. return $this->ok($types);
  267. }
  268. /**
  269. * receiveWorkOrder 接单
  270. *
  271. * @param Request $request
  272. * @return \Illuminate\Http\JsonResponse
  273. * @author Fx
  274. *
  275. */
  276. public function receiveWorkOrder(Request $request)
  277. {
  278. $work_order_id = $request->get('work_order_id') ?? '';
  279. if (empty($work_order_id)) return $this->error('参数错误');
  280. $worker_order = WorkOrder::query()->find($work_order_id);
  281. if (empty($worker_order)) return $this->error('找不到该工单信息,请联系管理员');
  282. // 加锁防止重复
  283. $lock = $this->makeReceiveWorkLock($work_order_id);
  284. if (!$lock) return $this->error('该工单已被认领');
  285. if ($worker_order->planned > WorkOrder::PLANNED_STATUS_MEET) return $this->error('该工单已被认领');
  286. $worker_id = Admin::user()->id;
  287. $worker_order->planned = WorkOrder::PLANNED_STATUS_WORK;
  288. $worker_order->fix_start_time = Carbon::now();
  289. $worker_order->worker_id = $worker_id;
  290. $bool = $worker_order->save();
  291. if ($bool) {
  292. return $this->ok('接单成功');
  293. } else {
  294. return $this->error('出现错误,请联系管理员');
  295. }
  296. }
  297. /**
  298. * makeReceiveWorkLock 接单锁 防止重复接单
  299. *
  300. * @param $work_order_id
  301. * @return bool
  302. * @author Fx
  303. *
  304. */
  305. public function makeReceiveWorkLock($work_order_id)
  306. {
  307. $key = sprintf(RedisKeys::LOCK_RECEIVE_WORK, $work_order_id);
  308. $res = app()->redis->incr($key);
  309. app()->redis->Expire($key, RedisKeys::LOCK_EXPIRE_RECEIVE_WORK);
  310. return $res > 1 ? false : true;
  311. }
  312. /**
  313. * updateWorkOrderStatus 更新工单状态已处理
  314. *
  315. * @param Request $request
  316. * @return \Illuminate\Http\JsonResponse
  317. * @author Fx
  318. *
  319. */
  320. public function updateWorkOrderStatus(Request $request)
  321. {
  322. $work_order_id = $request->get('work_order_id') ?? '';
  323. if (empty($work_order_id)) return $this->error('参数错误');
  324. //验证工单存在
  325. $work_order = WorkOrder::query()->find($work_order_id);
  326. if (empty($work_order)) return $this->error('找不到该工单信息,请联系管理员');
  327. $work_order_type = $work_order->type;
  328. $worker_id = $work_order->worker_id;
  329. // 验证是否有权限操作此工单
  330. $worker_type = Admin::user()->type;
  331. $admin_id = Admin::user()->id;
  332. if ($worker_type != AdminUser::TYPE_ADMIN) {
  333. if ($admin_id != $worker_id) {
  334. return $this->error('无权限操作此工单');
  335. }
  336. }
  337. if ($work_order->planned == WorkOrder::PLANNED_STATUS_MEET) return $this->error('该工单暂未认领');
  338. if ($work_order->planned == WorkOrder::PLANNED_STATUS_WORKED) return $this->error('该工单为已处理状态不可重复提交');
  339. if ($work_order->planned == WorkOrder::PLANNED_STATUS_OVER) return $this->error('该工单为已完成状态不可重复提交');
  340. // 判断工单类型 进行验证是否真正完成
  341. switch ($work_order_type) {
  342. case WorkOrder::TYPE_WATCH: // 查看类型工单
  343. $res = $this->updateWorkOrder($work_order);
  344. if ($res) {
  345. // 延时队列 验证是否完成工单
  346. VerifyWatchWorkOrderJob::dispatch($work_order->work_no)->delay(Carbon::now()->addMinutes(config('queue.delay.verifyWatchWorkOrder')));
  347. return $this->ok('操作成功');
  348. } else {
  349. return $this->error('更新失败,请重新尝试');
  350. }
  351. break;
  352. case WorkOrder::TYPE_CHARGE: // 充电类型工单
  353. $res = $this->updateWorkOrder($work_order);
  354. if ($res) {
  355. // 延时队列 验证是否完成工单
  356. VerifyChargeWorkOrderJob::dispatch($work_order->work_no)->delay(Carbon::now()->addMinutes(config('queue.delay.verifyChargeWorkOrder')));
  357. return $this->ok('操作成功');
  358. } else {
  359. return $this->error('更新失败,请重新尝试');
  360. }
  361. break;
  362. case WorkOrder::TYPE_TROUBLE: // 故障工单
  363. // 需要修改车辆故障表 以及更新车辆状态
  364. $bike_id = $work_order->bike_id;
  365. $bike = Bike::find($bike_id);
  366. if(!empty($bike)){
  367. $bike->is_trouble = Bike::TROUBLE_NO;
  368. $bike->save();
  369. }else{
  370. return $this->error('找不到车辆相关信息');
  371. }
  372. $res = $this->updateWorkOrderOver($work_order);
  373. if ($res) {
  374. return $this->ok('操作成功');
  375. } else {
  376. return $this->error('更新失败,请重新尝试');
  377. }
  378. break;
  379. default: // 其他工单了类型暂时不验证 直接赋值成功
  380. $res = $this->updateWorkOrderOver($work_order);
  381. if ($res) {
  382. return $this->ok('操作成功');
  383. } else {
  384. return $this->error('更新失败,请重新尝试');
  385. }
  386. }
  387. }
  388. /**
  389. * updateWorkOrder 更新工单状态为已处理
  390. *
  391. * @param $work_order
  392. * @return mixed
  393. * @author Fx
  394. *
  395. */
  396. private function updateWorkOrder($work_order)
  397. {
  398. $work_order->planned = WorkOrder::PLANNED_STATUS_WORKED;
  399. $work_order->work_over_id = Admin::user()->id;
  400. $bool = $work_order->save();
  401. return $bool;
  402. }
  403. /**
  404. * updateWorkOrderOver 更新工单状态为已完成
  405. *
  406. * @param $work_order
  407. * @return mixed
  408. * @author Fx
  409. *
  410. */
  411. private function updateWorkOrderOver($work_order)
  412. {
  413. $work_order->planned = WorkOrder::PLANNED_STATUS_OVER;
  414. $work_order->status = WorkOrder::STATUS_OK;
  415. $work_order->work_over_id = Admin::user()->id;
  416. $work_order->fix_end_time = Carbon::now();
  417. $bool = $work_order->save();
  418. $bike_id = $work_order->bike_id;
  419. $bike = Bike::find($bike_id);
  420. if(!empty($bike)){
  421. $bike->is_trouble = Bike::TROUBLE_NO;
  422. $bike->save();
  423. }
  424. return $bool;
  425. }
  426. /**
  427. * upgradeGroupWorkOrder 升级为组长工单
  428. *
  429. * @param Request $request
  430. * @return \Illuminate\Http\JsonResponse
  431. * @author Fx
  432. *
  433. */
  434. public function upgradeGroupWorkOrder(Request $request)
  435. {
  436. $work_order_id = $request->get('work_order_id') ?? '';
  437. $remark = $request->get('remark') ?? '';
  438. if (empty($work_order_id) || empty($remark)) return $this->error('参数错误');
  439. //验证工单存在
  440. $work_order = WorkOrder::query()->find($work_order_id);
  441. if (empty($work_order)) return $this->error('找不到该工单信息,请联系管理员');
  442. $admin_id = Admin::user()->id;
  443. $worker_id = $work_order->worker_id;
  444. if ($work_order->planned == WorkOrder::PLANNED_STATUS_MEET) return $this->error('该工单暂未认领不能升级');
  445. if ($admin_id != $worker_id) {
  446. return $this->error('无权限操作此工单');
  447. }
  448. try {
  449. $work_order->type = WorkOrder::TYPE_HEADMAN;
  450. $work_order->type_name = WorkOrder::$typeMaps[WorkOrder::TYPE_HEADMAN];
  451. $work_order->remark = $remark; // 备注信息
  452. $work_order->save();
  453. return $this->ok('更改成功');
  454. } catch (\Exception $exception) {
  455. Log::error($exception->getMessage());
  456. return $this->error('更改失败,请联系管理员');
  457. }
  458. }
  459. /**
  460. * getWarningByWorkOrderId 根据工单id获取警告日志
  461. *
  462. * @param Request $request
  463. * @return \Illuminate\Http\JsonResponse
  464. * @author Fx
  465. *
  466. */
  467. public function getWarningByWorkOrderId(Request $request)
  468. {
  469. $workOrderId = $request->get('id');
  470. $is_limit_type = $request->get('is_limit_type', 1);
  471. $workOrder = WorkOrder::find($workOrderId);
  472. if (empty($workOrder)) return $this->error('找不到工单');
  473. $warning = WarningLog::query()
  474. ->where('bike_no', $workOrder->bike_no);
  475. if ((bool)$is_limit_type) {
  476. // Log::info($is_limit_type);
  477. $warning = $warning
  478. ->where('type', $workOrder->warning_type);
  479. }
  480. $warning = $warning
  481. ->where('created_at', '>', Carbon::parse($workOrder->created_at)->subMinutes(5))
  482. ->orderByDesc('id')
  483. ->limit(300)
  484. ->get();
  485. return $this->ok(WarningLogResource::collection($warning));
  486. }
  487. }