OrderController.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505
  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 getOrderview(Request $request)
  137. {
  138. if ($request->input('year'))
  139. {
  140. $year = $request->input('year');
  141. }else
  142. {
  143. $year = 2021;
  144. }
  145. if ($request->input('status'))
  146. {
  147. $status = $request->input('status');
  148. }else{
  149. $status = 2;
  150. }
  151. if ($request->input('project_id'))
  152. {
  153. $project_id = $request->input('project_id');
  154. } else
  155. {
  156. $project_id = 38;
  157. }
  158. //获取当前项目的当前年的所有月份的数据总览
  159. if ($status == 2)
  160. {
  161. $items = OrderOverviewModel::whereYear('date',$year)->where('project_id',$project_id)->get()->toArray();
  162. foreach ($items as &$item)
  163. {
  164. $item['date'] = date('Y年m月',strtotime($item['date']));
  165. $item['total_price'] = $item['total_price']/100;
  166. $item['status'] = $item['status'] ? '已确认':'未确认';
  167. $item['confirmation_user_id'] = User::where('id',$item['confirmation_user_id'])->value('name');
  168. $item['project_id'] = Project::where('id',$item['project_id'])->value('name');
  169. $item['confirmation_time'] = $item['confirmation_time'] ?$item['confirmation_time']: '暂无';
  170. }
  171. }else
  172. {
  173. $items = OrderOverviewModel::whereYear('date',$year)->where('project_id',$project_id)->where('status',$status)->get()->toArray();
  174. foreach ($items as &$item)
  175. {
  176. $item['date'] = date('Y年m月',strtotime($item['date']));
  177. $item['total_price'] = $item['total_price']/100;
  178. $item['status'] = $item['status'] ? '已确认':'未确认';
  179. $item['confirmation_user_id'] = User::where('id',$item['confirmation_user_id'])->value('name');
  180. $item['project_id'] = Project::where('id',$item['project_id'])->value('name');
  181. $item['confirmation_time'] = $item['confirmation_time'] ?$item['confirmation_time']: '暂无';
  182. }
  183. }
  184. return $this->success();
  185. }
  186. public function update(Request $request)
  187. {
  188. $order = $this->model->find($request->input('id'));
  189. if(!$order) return $this->error(['msg' => '找不到订单']);
  190. $user = Auth::guard('mini')->user();
  191. $project_role = ProjectRole::getCreateRole('rent', $request->input('is_draft'));
  192. $option = Option::get('orders', 'status', 'checking');
  193. $res = $order->update([
  194. 'work_point_id' => $request->input('work_point_id'),
  195. 'remark' => $request->input('remark'),
  196. 'is_draft' => $request->input('is_draft'),
  197. 'status' => $option,
  198. 'order_number' => $this->model->createOrderNumber(),
  199. 'user_id' => $user->id,
  200. 'project_role_id' => $project_role ? $project_role['id'] : '',
  201. 'level' => $project_role ? $project_role['level'] : ''
  202. ]);
  203. if(!$res) return $this->error(['msg' => '订单修改失败']);
  204. $order->updateOrderDevices($request->input('devices'));
  205. return $this->success();
  206. }
  207. public function updateInner(Request $request)
  208. {
  209. $order = $this->model->find($request->input('id'));
  210. if(!$order) return $this->error(['msg' => '找不到订单']);
  211. $user = Auth::guard('mini')->user();
  212. $project_role = ProjectRole::getCreateRole('apply', $request->input('is_draft'));
  213. $type = $request->input('type');
  214. $option = Option::get('orders', 'status', 'checking');
  215. if($type == 'back') {
  216. $option = Option::get('orders', 'status', 'back');
  217. }
  218. $res = $order->update([
  219. 'work_point_id' => $request->input('work_point_id'),
  220. 'remark' => $request->input('remark'),
  221. 'is_draft' => $request->input('is_draft'),
  222. 'status' => $option,
  223. 'user_id' => $user->id,
  224. 'project_role_id' => $project_role ? $project_role['id'] : '',
  225. 'level' => $project_role ? $project_role['level'] : '',
  226. ]);
  227. if(!$res) return $this->error(['msg' => '订单修改失败']);
  228. $devices = $request->input('devices');
  229. if($type == 'back') {
  230. foreach($devices as $device) {
  231. if($device['id']) {
  232. InnerDevice::find($device['id'])->update([
  233. 'project_id' => '',
  234. 'start_date' => '',
  235. 'end_date' => '',
  236. 'work_point_id' => '',
  237. 'status' => Option::get('inner_devices', 'status', 'free')
  238. ]);
  239. }
  240. }
  241. } else {
  242. $order->updateOrderDevices($devices);
  243. }
  244. return $this->success();
  245. }
  246. //订单列表
  247. public function get(Request $request)
  248. {
  249. $user = Auth::guard('mini')->user();
  250. $project_role = $user->getTopRole();
  251. if($project_role) {
  252. $project_role->rights = $project_role->getRights();
  253. }
  254. //判断是否有租赁查看权限
  255. if($project_role->rights['rentView'] == true){
  256. $items = $this->model->join('users', 'orders.user_id', '=', 'users.id')->where('status','!=',4)->select('orders.*', 'users.id as user_id', 'users.name');
  257. } else {
  258. $items = $this->model->join('users', 'orders.user_id', '=', 'users.id')->select('orders.*', 'users.id as user_id', 'users.name');
  259. }
  260. //取对应项目的工点
  261. $level = $user->getLevel($request->input('project_id'));
  262. $search_items = [
  263. ['project_id', $request->input('project_id')],
  264. ['level', '>=', $level]
  265. ];
  266. $is_draft = $request->input('is_draft');
  267. $project_user = ProjectUser::where([
  268. ['user_id', $user->id],
  269. ['project_id', $request->input('project_id')]
  270. ])->first();
  271. if($project_user) {
  272. $project_role = ProjectRole::find($project_user->project_role_id);
  273. if($project_role) {
  274. $rights = $project_role->getRights();
  275. if(isset($rights) && $rights['rentView']) {
  276. unset($search_items[1]);
  277. }
  278. }
  279. }
  280. if($is_draft) {
  281. $search_items['is_draft'] = $is_draft;
  282. if($is_draft == 1) {
  283. $search_items['user_id'] = $user->id;
  284. }
  285. }
  286. $statu = $request->input('status');
  287. if($request->input('status')) {
  288. // if($statu == 'reject'){
  289. // unset($search_items[1]);
  290. // $search_items[] = ['last_project_role_id',$level];
  291. // }
  292. $status = Option::get('orders', 'status', $request->input('status'));
  293. if($status) {
  294. array_push($search_items, ['status', '=', $status]);
  295. };
  296. }
  297. $equal_items = ['work_point_id', 'type'];
  298. foreach ($equal_items as $item) {
  299. if($request->input($item)) {
  300. array_push($search_items, [$item, '=', $request->input($item)]);
  301. }
  302. }
  303. $items = $items->where($search_items);
  304. if($request->input('keyword')) {
  305. $keyword = '%' . $request->input('keyword') . '%';
  306. $items = $items->where(function ($query) use($keyword) {
  307. $query->where('order_number', 'like', $keyword)->orWhere('users.name', 'like', $keyword);
  308. });
  309. }
  310. $items = $items->orderBy('updated_at', 'desc');
  311. $items = $items->paginate();
  312. foreach($items as $item) {
  313. $item->formatOrder($item);
  314. }
  315. return $this->success(['data' => $items->items()]);
  316. }
  317. public function formatOrder($item)
  318. {
  319. $option = Option::find($item->status);
  320. $item->status = $item->getStatusName();
  321. $item->status_key = $option ? $option['key'] : '';
  322. $item->color = $option ? $option['color'] : '';
  323. $item->date_time = substr($item->created_at, 0, 16);
  324. }
  325. public function detail(Request $request)
  326. {
  327. $order = $this->model->with('project', 'workPoint', 'user', 'innerDevices', 'order_devices')->find($request->input('id'));
  328. if(!$order) return $this->error(['msg' => '找不到订单']);
  329. $this->formatOrder($order);
  330. foreach($order['innerDevices'] as $device) {
  331. $device->device = Device::find($device->device_id);
  332. $device->device_name = DeviceName::find($device->device_name_id);
  333. $device->status = Option::find($device->status);
  334. $device->spec = Spec::find($device->spec);
  335. $device->work_point = $order['workPoint'];
  336. $device->init_start_date = $device->start_date;
  337. $device->init_end_date = $device->end_date;
  338. }
  339. foreach($order['order_devices'] as $order_device) {
  340. $order_device->device_type = Device::find($order_device->device_id);
  341. $order_device->device_name = DeviceName::find($order_device->device_name_id);
  342. $order_device->spec = Spec::find($order_device->spec_id);
  343. $order_device->rent_type = RentType::find($order_device->rent_type_id);
  344. }
  345. return $this->success(['data' => $order]);
  346. }
  347. public function getRole(Request $request)
  348. {
  349. $user = Auth::guard('mini')->user();
  350. $project_user = ProjectUser::where([
  351. ['project_id', '=', $request->input('id')],
  352. ['user_id', '=', $user->id]
  353. ])->first();
  354. $project_role = null;
  355. if($project_user) {
  356. $project_role = ProjectRole::find($project_user->project_role_id);
  357. if($project_role) {
  358. $project_role->rights = $project_role->getRights();
  359. }
  360. }
  361. return $this->success(['data' => $project_role]);
  362. }
  363. public function check(Request $request)
  364. {
  365. $user = Auth::guard('mini')->user();
  366. $order = $this->model->find($request->input('id'));
  367. if(!$order) return $this->error(['msg' => '找不到订单']);
  368. $project_user = ProjectUser::where([
  369. ['project_id', '=', $order->project_id],
  370. ['user_id', '=', $user->id]
  371. ])->first();
  372. if(!$project_user) return $this->error(['msg' => '找不到用户']);
  373. $project_role = ProjectRole::find($project_user->project_role_id);
  374. if(!$project_role) return $this->error(['msg' => '找不到角色']);
  375. $status = Option::get('orders', 'status', $request->input('type'));
  376. $next_project_role = null;
  377. $is_inner = $order->type == 2;
  378. $new_order = null;
  379. // 工区负责人确认通过
  380. if($request->input('type') == 'pass') {
  381. $status = Option::get('orders', 'status', 'pass');
  382. $next_project_role = $project_role;
  383. } else if($request->input('type') == 're-submit') {
  384. $status = Option::get('orders', 'status', 'checking');
  385. $next_project_role = $project_role->getNext(null, $is_inner);
  386. $order->updateOrderDevices($request->input('devices'));
  387. } else if($request->input('type') == 'reject') {
  388. $next_project_role = ProjectRole::getFirstRole($order);
  389. $next_project_role['level'] =$project_role->level;
  390. } else if($request->input('type') == 'back') {
  391. $new_order = $order->backInnerDevices($request->input('devices'));
  392. // 没有返回新订单,是全部归还
  393. if(!$new_order) {
  394. $status = Option::get('orders', 'status', 'pass');
  395. // 全部归还,下一角色改为最高角色
  396. $next_project_role = ProjectRole::getLastRole($order);
  397. OrderDevice::where('order_id', $order->id)->update(['end_date' => Carbon::now()->toDateString()]);
  398. } else {
  399. // 部分归还,状态保持,下一角色保持,上一角色保持
  400. $status = $order->status;
  401. $next_project_role = ProjectRole::find($order->project_role_id);
  402. $project_role = ProjectRole::find($order->last_project_role_id);
  403. }
  404. } else {
  405. // 审核
  406. $next_project_role = $project_role->getNext(null, $is_inner);
  407. }
  408. $is_change = $request->input('is_change');
  409. $level = $next_project_role ? $next_project_role['level'] : '';
  410. if($request->input('type') == 'pass') {
  411. $last_role = ProjectRole::getLastRole($order);
  412. $level = $last_role ? $last_role['level'] : '';
  413. }
  414. $res = $order->update([
  415. 'status' => $status,
  416. 'last_project_role_id' => $project_role->id,
  417. 'project_role_id' => $next_project_role ? $next_project_role['id'] : '',
  418. 'level' => $level,
  419. 'is_change' => $is_change,
  420. 'remark' => $request->input('remark')
  421. ]);
  422. if($request->input('type') == 'back') {
  423. if($new_order) {
  424. // 部分归还
  425. Notification::send($new_order->id);
  426. } else {
  427. // 全部归还
  428. Notification::send($order->id);
  429. }
  430. } else {
  431. Notification::send($order->id);
  432. }
  433. if($res) return $this->success();
  434. return $this->error(['msg' => '操作失败']);
  435. }
  436. public function change(Request $request)
  437. {
  438. $order_device = OrderDevice::find($request->input('id'));
  439. if(!$order_device) return $this->error(['msg' => '找不到设备']);
  440. $order_device->update([
  441. 'quantity' => $request->input('quantity')
  442. ]);
  443. $order = $this->model->find($order_device['order_id']);
  444. if(!$order) return $this->error(['msg' => '找不到订单']);
  445. $order->updateMoney();
  446. return $this->success();
  447. }
  448. public function delete(Request $request)
  449. {
  450. if($request->input('id')) {
  451. $id = $request->input('id');
  452. $this->model->where('id', $id)->delete();
  453. $inner_device_ids = OrderDevice::where('order_id', $id)->pluck('inner_device_id');
  454. if($inner_device_ids) {
  455. $free_id = Option::get('inner_devices', 'status', 'free');
  456. InnerDevice::where('id', $inner_device_ids)->update([
  457. 'status' => $free_id,
  458. 'start_date' => null,
  459. 'end_date' => null,
  460. 'work_point_id' => ''
  461. ]);
  462. }
  463. Notification::where('order_id', $id)->delete();
  464. OrderDevice::where('order_id', $id)->delete();
  465. }
  466. return $this->success();
  467. }
  468. }