OrderController.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518
  1. <?php
  2. namespace App\Http\Controllers\Api\mini;
  3. use App\Models\Device;
  4. use App\Models\DeviceName;
  5. use App\Models\InnerDevice;
  6. use App\Models\Notification;
  7. use App\Models\Option;
  8. use App\Models\Order;
  9. use App\Models\OrderDevice;
  10. use App\Models\OrderOverviewModel;
  11. use App\Models\Project;
  12. use App\Models\ProjectRole;
  13. use App\Models\ProjectUser;
  14. use App\Models\RentType;
  15. use App\Models\Spec;
  16. use App\Models\WorkPoint;
  17. use Carbon\Carbon;
  18. use Illuminate\Http\Request;
  19. use Illuminate\Support\Facades\Auth;
  20. use Illuminate\Support\Facades\Log;
  21. class OrderController extends BaseController
  22. {
  23. protected $model;
  24. public function __construct()
  25. {
  26. $this->model = new Order();
  27. }
  28. public function create(Request $request)
  29. {
  30. $project = Project::find($request->input('project_id'));
  31. if(!$project) return $this->error(['msg' => '找不到项目']);
  32. $user = Auth::guard('mini')->user();
  33. $project_role = ProjectRole::getCreateRole('rent', $request->input('is_draft'));
  34. $option = Option::get('orders', 'status', 'checking');
  35. $order = Order::create([
  36. 'work_point_id' => $request->input('work_point_id'),
  37. 'remark' => $request->input('remark'),
  38. 'is_draft' => $request->input('is_draft'),
  39. 'status' => $option,
  40. 'order_number' => $this->model->createOrderNumber(),
  41. 'project_id' => $project->id,
  42. 'user_id' => $user->id,
  43. 'project_role_id' => $project_role ? $project_role['id'] : '',
  44. 'level' => $project_role ? $project_role['level'] : '',
  45. 'type' => 1
  46. ]);
  47. if(!$order) return $this->error(['msg' => '订单创建失败']);
  48. Notification::send($order->id);
  49. $order->updateOrderDevices($request->input('devices'));
  50. return $this->success();
  51. }
  52. public function getNameSpecRent($data)
  53. {
  54. $device = Device::find($data['type_id']);
  55. $rent_type = RentType::firstOrCreate([
  56. 'name' => $data['rent']
  57. ]);
  58. if(!$device) return [
  59. 'device_id' => '',
  60. 'device_name_id' => '',
  61. 'spec_id' => '',
  62. 'rent_type_id' => $rent_type->id
  63. ];
  64. $device_name = DeviceName::firstOrCreate([
  65. 'device_id' => $device->id,
  66. 'name' => $data['name']
  67. ]);
  68. $spec = Spec::firstOrCreate([
  69. 'device_id' => $device->id,
  70. 'device_name_id' => $device_name->id,
  71. 'name' => $data['spec']
  72. ]);
  73. return [
  74. 'device_id' => $device->id,
  75. 'device_name_id' => $device_name->id,
  76. 'spec_id' => $spec->id,
  77. 'rent_type_id' => $rent_type->id
  78. ];
  79. }
  80. public function createInner(Request $request)
  81. {
  82. $project = Project::find($request->input('project_id'));
  83. if(!$project) return $this->error(['msg' => '找不到项目']);
  84. $devices = $request->input('devices');
  85. $using_id = Option::get('inner_devices', 'status', 'using');
  86. $free_id = Option::get('inner_devices', 'status', 'free');
  87. // 续租时不检查设备使用状态
  88. if(!$request->input('type') || $request->input('type') != 're-rent') {
  89. foreach($devices as $device) {
  90. $device = InnerDevice::find($device['id']);
  91. if($device->status != $free_id) {
  92. $status = Option::find($device->status);
  93. $msg = $device['name'] . ($status ? $status['name'] : '使用中') . ',不能使用';
  94. return $this->error(['msg' => $msg]);
  95. }
  96. }
  97. }
  98. $user = Auth::guard('mini')->user();
  99. $project_role = ProjectRole::getCreateRole('apply', $request->input('is_draft'));
  100. $option = Option::get('orders', 'status', 'checking');
  101. $order = Order::create([
  102. 'remark' => $request->input('remark'),
  103. 'is_draft' => $request->input('is_draft'),
  104. 'status' => $option,
  105. 'order_number' => $this->model->createOrderNumber(),
  106. 'project_id' => $project->id,
  107. 'user_id' => $user->id,
  108. 'project_role_id' => $project_role ? $project_role['id'] : '',
  109. 'level' => $project_role ? $project_role['level'] : '',
  110. 'type' => 2,
  111. 'is_change' => 2
  112. ]);
  113. if(!$order) return $this->error(['msg' => '订单创建失败']);
  114. foreach($devices as $device) {
  115. OrderDevice::create([
  116. 'name' => $device['name'],
  117. 'order_id' => $order->id,
  118. 'project_id' => $order->project_id,
  119. 'user_id' => $order->user_id,
  120. 'inner_device_id' => $device['id'],
  121. 'start_date' => $device['start_date'],
  122. 'end_date' => $device['end_date']
  123. ]);
  124. if($device['id']) {
  125. InnerDevice::find($device['id'])->update([
  126. 'project_id' => $order['project_id'],
  127. 'status' => $using_id,
  128. 'start_date' => $device['start_date'],
  129. 'end_date' => $device['end_date'],
  130. ]);
  131. }
  132. }
  133. Notification::send($order->id);
  134. return $this->success();
  135. }
  136. public function getYears()
  137. {
  138. $date_arr = OrderOverviewModel::pluck('date')->toArray();
  139. $result = array_unique($date_arr);
  140. $years = [];
  141. foreach ($result as $value)
  142. {
  143. $year = date('Y',strtotime($value));
  144. array_push($years,$year);
  145. }
  146. $years = array_unique($years);
  147. return $this->success(['msg' => '获取年份成功', 'data' => $years]);
  148. }
  149. public function getOrderview(Request $request)
  150. {
  151. if ($request->input('year'))
  152. {
  153. $year = $request->input('year');
  154. }else
  155. {
  156. $year = 2021;
  157. }
  158. if ($request->input('status'))
  159. {
  160. $status = $request->input('status');
  161. }else{
  162. $status = 2;
  163. }
  164. if ($request->input('project_id'))
  165. {
  166. $project_id = $request->input('project_id');
  167. } else
  168. {
  169. $project_id = 38;
  170. }
  171. //获取当前项目的当前年的所有月份的数据总览
  172. if ($status == 2)
  173. {
  174. $items = OrderOverviewModel::whereYear('date',$year)->where('project_id',$project_id)->get()->toArray();
  175. foreach ($items as &$item)
  176. {
  177. $item['date'] = date('Y年m月',strtotime($item['date']));
  178. $item['total_price'] = $item['total_price']/100;
  179. $item['status'] = $item['status'] ? '已确认':'未确认';
  180. $item['confirmation_user_id'] = User::where('id',$item['confirmation_user_id'])->value('name');
  181. $item['project_id'] = Project::where('id',$item['project_id'])->value('name');
  182. $item['confirmation_time'] = $item['confirmation_time'] ?$item['confirmation_time']: '暂无';
  183. }
  184. }else
  185. {
  186. $items = OrderOverviewModel::whereYear('date',$year)->where('project_id',$project_id)->where('status',$status)->get()->toArray();
  187. foreach ($items as &$item)
  188. {
  189. $item['date'] = date('Y年m月',strtotime($item['date']));
  190. $item['total_price'] = $item['total_price']/100;
  191. $item['status'] = $item['status'] ? '已确认':'未确认';
  192. $item['confirmation_user_id'] = User::where('id',$item['confirmation_user_id'])->value('name');
  193. $item['project_id'] = Project::where('id',$item['project_id'])->value('name');
  194. $item['confirmation_time'] = $item['confirmation_time'] ?$item['confirmation_time']: '暂无';
  195. }
  196. }
  197. return $this->success(['msg' => '获取年份成功', 'data' => $items]);
  198. }
  199. public function update(Request $request)
  200. {
  201. $order = $this->model->find($request->input('id'));
  202. if(!$order) return $this->error(['msg' => '找不到订单']);
  203. $user = Auth::guard('mini')->user();
  204. $project_role = ProjectRole::getCreateRole('rent', $request->input('is_draft'));
  205. $option = Option::get('orders', 'status', 'checking');
  206. $res = $order->update([
  207. 'work_point_id' => $request->input('work_point_id'),
  208. 'remark' => $request->input('remark'),
  209. 'is_draft' => $request->input('is_draft'),
  210. 'status' => $option,
  211. 'order_number' => $this->model->createOrderNumber(),
  212. 'user_id' => $user->id,
  213. 'project_role_id' => $project_role ? $project_role['id'] : '',
  214. 'level' => $project_role ? $project_role['level'] : ''
  215. ]);
  216. if(!$res) return $this->error(['msg' => '订单修改失败']);
  217. $order->updateOrderDevices($request->input('devices'));
  218. return $this->success();
  219. }
  220. public function updateInner(Request $request)
  221. {
  222. $order = $this->model->find($request->input('id'));
  223. if(!$order) return $this->error(['msg' => '找不到订单']);
  224. $user = Auth::guard('mini')->user();
  225. $project_role = ProjectRole::getCreateRole('apply', $request->input('is_draft'));
  226. $type = $request->input('type');
  227. $option = Option::get('orders', 'status', 'checking');
  228. if($type == 'back') {
  229. $option = Option::get('orders', 'status', 'back');
  230. }
  231. $res = $order->update([
  232. 'work_point_id' => $request->input('work_point_id'),
  233. 'remark' => $request->input('remark'),
  234. 'is_draft' => $request->input('is_draft'),
  235. 'status' => $option,
  236. 'user_id' => $user->id,
  237. 'project_role_id' => $project_role ? $project_role['id'] : '',
  238. 'level' => $project_role ? $project_role['level'] : '',
  239. ]);
  240. if(!$res) return $this->error(['msg' => '订单修改失败']);
  241. $devices = $request->input('devices');
  242. if($type == 'back') {
  243. foreach($devices as $device) {
  244. if($device['id']) {
  245. InnerDevice::find($device['id'])->update([
  246. 'project_id' => '',
  247. 'start_date' => '',
  248. 'end_date' => '',
  249. 'work_point_id' => '',
  250. 'status' => Option::get('inner_devices', 'status', 'free')
  251. ]);
  252. }
  253. }
  254. } else {
  255. $order->updateOrderDevices($devices);
  256. }
  257. return $this->success();
  258. }
  259. //订单列表
  260. public function get(Request $request)
  261. {
  262. $user = Auth::guard('mini')->user();
  263. $project_role = $user->getTopRole();
  264. if($project_role) {
  265. $project_role->rights = $project_role->getRights();
  266. }
  267. //判断是否有租赁查看权限
  268. if($project_role->rights['rentView'] == true){
  269. $items = $this->model->join('users', 'orders.user_id', '=', 'users.id')->where('status','!=',4)->select('orders.*', 'users.id as user_id', 'users.name');
  270. } else {
  271. $items = $this->model->join('users', 'orders.user_id', '=', 'users.id')->select('orders.*', 'users.id as user_id', 'users.name');
  272. }
  273. //取对应项目的工点
  274. $level = $user->getLevel($request->input('project_id'));
  275. $search_items = [
  276. ['project_id', $request->input('project_id')],
  277. ['level', '>=', $level]
  278. ];
  279. $is_draft = $request->input('is_draft');
  280. $project_user = ProjectUser::where([
  281. ['user_id', $user->id],
  282. ['project_id', $request->input('project_id')]
  283. ])->first();
  284. if($project_user) {
  285. $project_role = ProjectRole::find($project_user->project_role_id);
  286. if($project_role) {
  287. $rights = $project_role->getRights();
  288. if(isset($rights) && $rights['rentView']) {
  289. unset($search_items[1]);
  290. }
  291. }
  292. }
  293. if($is_draft) {
  294. $search_items['is_draft'] = $is_draft;
  295. if($is_draft == 1) {
  296. $search_items['user_id'] = $user->id;
  297. }
  298. }
  299. $statu = $request->input('status');
  300. if($request->input('status')) {
  301. // if($statu == 'reject'){
  302. // unset($search_items[1]);
  303. // $search_items[] = ['last_project_role_id',$level];
  304. // }
  305. $status = Option::get('orders', 'status', $request->input('status'));
  306. if($status) {
  307. array_push($search_items, ['status', '=', $status]);
  308. };
  309. }
  310. $equal_items = ['work_point_id', 'type'];
  311. foreach ($equal_items as $item) {
  312. if($request->input($item)) {
  313. array_push($search_items, [$item, '=', $request->input($item)]);
  314. }
  315. }
  316. $items = $items->where($search_items);
  317. if($request->input('keyword')) {
  318. $keyword = '%' . $request->input('keyword') . '%';
  319. $items = $items->where(function ($query) use($keyword) {
  320. $query->where('order_number', 'like', $keyword)->orWhere('users.name', 'like', $keyword);
  321. });
  322. }
  323. $items = $items->orderBy('updated_at', 'desc');
  324. $items = $items->paginate();
  325. foreach($items as $item) {
  326. $item->formatOrder($item);
  327. }
  328. return $this->success(['data' => $items->items()]);
  329. }
  330. public function formatOrder($item)
  331. {
  332. $option = Option::find($item->status);
  333. $item->status = $item->getStatusName();
  334. $item->status_key = $option ? $option['key'] : '';
  335. $item->color = $option ? $option['color'] : '';
  336. $item->date_time = substr($item->created_at, 0, 16);
  337. }
  338. public function detail(Request $request)
  339. {
  340. $order = $this->model->with('project', 'workPoint', 'user', 'innerDevices', 'order_devices')->find($request->input('id'));
  341. if(!$order) return $this->error(['msg' => '找不到订单']);
  342. $this->formatOrder($order);
  343. foreach($order['innerDevices'] as $device) {
  344. $device->device = Device::find($device->device_id);
  345. $device->device_name = DeviceName::find($device->device_name_id);
  346. $device->status = Option::find($device->status);
  347. $device->spec = Spec::find($device->spec);
  348. $device->work_point = $order['workPoint'];
  349. $device->init_start_date = $device->start_date;
  350. $device->init_end_date = $device->end_date;
  351. }
  352. foreach($order['order_devices'] as $order_device) {
  353. $order_device->device_type = Device::find($order_device->device_id);
  354. $order_device->device_name = DeviceName::find($order_device->device_name_id);
  355. $order_device->spec = Spec::find($order_device->spec_id);
  356. $order_device->rent_type = RentType::find($order_device->rent_type_id);
  357. }
  358. return $this->success(['data' => $order]);
  359. }
  360. public function getRole(Request $request)
  361. {
  362. $user = Auth::guard('mini')->user();
  363. $project_user = ProjectUser::where([
  364. ['project_id', '=', $request->input('id')],
  365. ['user_id', '=', $user->id]
  366. ])->first();
  367. $project_role = null;
  368. if($project_user) {
  369. $project_role = ProjectRole::find($project_user->project_role_id);
  370. if($project_role) {
  371. $project_role->rights = $project_role->getRights();
  372. }
  373. }
  374. return $this->success(['data' => $project_role]);
  375. }
  376. public function check(Request $request)
  377. {
  378. $user = Auth::guard('mini')->user();
  379. $order = $this->model->find($request->input('id'));
  380. if(!$order) return $this->error(['msg' => '找不到订单']);
  381. $project_user = ProjectUser::where([
  382. ['project_id', '=', $order->project_id],
  383. ['user_id', '=', $user->id]
  384. ])->first();
  385. if(!$project_user) return $this->error(['msg' => '找不到用户']);
  386. $project_role = ProjectRole::find($project_user->project_role_id);
  387. if(!$project_role) return $this->error(['msg' => '找不到角色']);
  388. $status = Option::get('orders', 'status', $request->input('type'));
  389. $next_project_role = null;
  390. $is_inner = $order->type == 2;
  391. $new_order = null;
  392. // 工区负责人确认通过
  393. if($request->input('type') == 'pass') {
  394. $status = Option::get('orders', 'status', 'pass');
  395. $next_project_role = $project_role;
  396. } else if($request->input('type') == 're-submit') {
  397. $status = Option::get('orders', 'status', 'checking');
  398. $next_project_role = $project_role->getNext(null, $is_inner);
  399. $order->updateOrderDevices($request->input('devices'));
  400. } else if($request->input('type') == 'reject') {
  401. $next_project_role = ProjectRole::getFirstRole($order);
  402. $next_project_role['level'] =$project_role->level;
  403. } else if($request->input('type') == 'back') {
  404. $new_order = $order->backInnerDevices($request->input('devices'));
  405. // 没有返回新订单,是全部归还
  406. if(!$new_order) {
  407. $status = Option::get('orders', 'status', 'pass');
  408. // 全部归还,下一角色改为最高角色
  409. $next_project_role = ProjectRole::getLastRole($order);
  410. OrderDevice::where('order_id', $order->id)->update(['end_date' => Carbon::now()->toDateString()]);
  411. } else {
  412. // 部分归还,状态保持,下一角色保持,上一角色保持
  413. $status = $order->status;
  414. $next_project_role = ProjectRole::find($order->project_role_id);
  415. $project_role = ProjectRole::find($order->last_project_role_id);
  416. }
  417. } else {
  418. // 审核
  419. $next_project_role = $project_role->getNext(null, $is_inner);
  420. }
  421. $is_change = $request->input('is_change');
  422. $level = $next_project_role ? $next_project_role['level'] : '';
  423. if($request->input('type') == 'pass') {
  424. $last_role = ProjectRole::getLastRole($order);
  425. $level = $last_role ? $last_role['level'] : '';
  426. }
  427. $res = $order->update([
  428. 'status' => $status,
  429. 'last_project_role_id' => $project_role->id,
  430. 'project_role_id' => $next_project_role ? $next_project_role['id'] : '',
  431. 'level' => $level,
  432. 'is_change' => $is_change,
  433. 'remark' => $request->input('remark')
  434. ]);
  435. if($request->input('type') == 'back') {
  436. if($new_order) {
  437. // 部分归还
  438. Notification::send($new_order->id);
  439. } else {
  440. // 全部归还
  441. Notification::send($order->id);
  442. }
  443. } else {
  444. Notification::send($order->id);
  445. }
  446. if($res) return $this->success();
  447. return $this->error(['msg' => '操作失败']);
  448. }
  449. public function change(Request $request)
  450. {
  451. $order_device = OrderDevice::find($request->input('id'));
  452. if(!$order_device) return $this->error(['msg' => '找不到设备']);
  453. $order_device->update([
  454. 'quantity' => $request->input('quantity')
  455. ]);
  456. $order = $this->model->find($order_device['order_id']);
  457. if(!$order) return $this->error(['msg' => '找不到订单']);
  458. $order->updateMoney();
  459. return $this->success();
  460. }
  461. public function delete(Request $request)
  462. {
  463. if($request->input('id')) {
  464. $id = $request->input('id');
  465. $this->model->where('id', $id)->delete();
  466. $inner_device_ids = OrderDevice::where('order_id', $id)->pluck('inner_device_id');
  467. if($inner_device_ids) {
  468. $free_id = Option::get('inner_devices', 'status', 'free');
  469. InnerDevice::where('id', $inner_device_ids)->update([
  470. 'status' => $free_id,
  471. 'start_date' => null,
  472. 'end_date' => null,
  473. 'work_point_id' => ''
  474. ]);
  475. }
  476. Notification::where('order_id', $id)->delete();
  477. OrderDevice::where('order_id', $id)->delete();
  478. }
  479. return $this->success();
  480. }
  481. }