OrderController.php 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Models\Option;
  4. use App\Models\Order;
  5. use App\Models\OrderDevice;
  6. use App\Models\Project;
  7. use Illuminate\Http\Request;
  8. class OrderController extends BaseController
  9. {
  10. protected $model;
  11. protected $project;
  12. protected $model_name = '订单';
  13. protected $pre_uri = '/admin/Order/';
  14. protected $view_path = 'admin.orders.';
  15. protected $redirect_index = '/admin/Order/index';
  16. public function __construct()
  17. {
  18. parent::__construct();
  19. $this->model = new Order();
  20. $this->project = new Project();
  21. }
  22. public function index()
  23. {
  24. $project_options = $this->project->getOptions();
  25. $status_options = Option::get('orders', 'status');
  26. $type_options = [['name' => '外部租赁', 'id' => 1], ['name' => '内部调用', 'id' => 2]];
  27. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  28. return view($this->view_path . 'index', compact('model', 'model_name','pre_uri', 'project_options', 'status_options', 'type_options'));
  29. }
  30. public function get(Request $request)
  31. {
  32. $items = $this->model->where('id', '>', 0)->with('project', 'user');
  33. $tmp_items = collect(['order_number']);
  34. foreach($tmp_items as $tmp_item) {
  35. if($request->has($tmp_item) && !empty($request->input($tmp_item))) {
  36. $items = $items->where($tmp_item, 'like', '%' . $request->input($tmp_item) . '%');
  37. }
  38. }
  39. $select_items = collect(['status', 'type', 'project_id']);
  40. foreach($select_items as $select_item) {
  41. if($request->has($select_item) && !empty($request->input($select_item))) {
  42. $items = $items->where($select_item, '=', $request->input($select_item));
  43. }
  44. }
  45. $items = $items->paginate();
  46. foreach($items as $item) {
  47. $item->order_id = $item->id ? $item->id : '';
  48. $item->project_name = $item->project ? $item->project->name : '';
  49. $item->work_point = $item->work_point_id ? $item->workpoints?($item->workpoints->name ? $item->workpoints->name : '') :'': '';
  50. // dd($item->workpoints);
  51. //方法区
  52. $order = OrderDevice::where('order_id',$item->order_id)->get()->toArray();
  53. $order_num = count($order);
  54. $total_price = 0;
  55. if ($item->type == 1)
  56. {
  57. foreach ($order as $value)
  58. {
  59. $one_price = ($value['quantity']*$value['price'])/100;
  60. $total_price += $one_price;
  61. }
  62. }
  63. $item->order_num = $item->id ? $order_num : '';
  64. $item->total_price = $item->id ? $total_price : '';
  65. $item->remark = $item->remark ? $item->remark : '';
  66. $item->user_name = $item->user ? $item->user->name : '';
  67. $item->status_name = $item->getStatusName();
  68. $item->option = Option::find($item->status);
  69. $color = $item->option ? $item->option->color : '';
  70. $item->status_name = '<span style="color: ' . $color . '">' . $item->status_name . '</span>';
  71. $item->type_name = $item->type == 1 ? '<span class="layui-badge layui-bg-green">外部租赁</span>' : '<span class="layui-badge layui-bg-blue">内部调用</span>';
  72. }
  73. return response()->json(['code' => 0, 'message' => '', 'count' => $items->total(), 'data' => $items->items()]);
  74. }
  75. public function create()
  76. {
  77. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  78. return view($this->view_path . 'create', compact('model', 'model_name','pre_uri'));
  79. }
  80. public function store(Request $request)
  81. {
  82. if(empty($request->input('data')) || !is_array($request->input('data'))) return back()->withErrors(['sg_error_info' => '数据错误']);
  83. $validator = $this->model->getValidator($request, 'store');
  84. if($validator->fails()) {
  85. return back()->withErrors($validator)->withInput();
  86. }
  87. $data = $request->input('data');
  88. $res = $this->model->create($data);
  89. if(empty($res)) return back()->withErrors(['sg_error_info' => '保存失败']);
  90. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '创建成功']);
  91. }
  92. public function edit(Request $request)
  93. {
  94. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return back()->withErrors(['sg_error_info' => '找不到要编辑的数据']);
  95. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  96. return view($this->view_path . 'edit', compact('model', 'model_name', 'pre_uri', 'item'));
  97. }
  98. public function update(Request $request)
  99. {
  100. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return back()->withErrors(['sg_error_info' => '找不到要编辑的数据']);
  101. if(empty($request->input('data')) || !is_array($request->input('data'))) return back()->withErrors(['sg_error_info' => '数据错误']);
  102. $validator = $this->model->getValidator($request, 'update');
  103. if($validator->fails()) {
  104. return back()->withErrors($validator)->withInput();
  105. }
  106. $data = $request->input('data');
  107. $res = $this->model->where('id', $request->input('id'))->update($data);
  108. if(!$res) return back()->withErrors(['sg_error_info' => '数据库保存失败!']);
  109. return back()->with(['sg_success_info' => '编辑成功']);
  110. }
  111. public function delete(Request $request)
  112. {
  113. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return response()->json(['status' => 'fail', 'info' => '找不到要删除的数据']);
  114. $res = $item->delete();
  115. if (!$res) return response()->json(['status' => 'fail', 'info' => '删除失败']);
  116. return response()->json(['status' => 'success', 'info' => '操作成功']);
  117. }
  118. }