PlanController.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Http\Requests\Admin\PlanSave;
  4. use App\Http\Requests\Admin\PlanSort;
  5. use App\Http\Requests\Admin\PlanUpdate;
  6. use Illuminate\Http\Request;
  7. use App\Http\Controllers\Controller;
  8. use App\Models\Plan;
  9. use App\Models\Order;
  10. use App\Models\User;
  11. use Illuminate\Support\Facades\DB;
  12. class PlanController extends Controller
  13. {
  14. public function fetch(Request $request)
  15. {
  16. return response([
  17. 'data' => Plan::orderBy('sort', 'ASC')->get()
  18. ]);
  19. }
  20. public function save(PlanSave $request)
  21. {
  22. $params = $request->only(array_keys(PlanSave::RULES));
  23. if ($request->input('id')) {
  24. $plan = Plan::find($request->input('id'));
  25. if (!$plan) {
  26. abort(500, '该订阅不存在');
  27. }
  28. DB::beginTransaction();
  29. // update user group id and transfer
  30. try {
  31. User::where('plan_id', $plan->id)->update([
  32. 'group_id' => $plan->group_id,
  33. 'transfer_enable' => $plan->transfer_enable * 1073741824
  34. ]);
  35. $plan->update($params);
  36. } catch (\Exception $e) {
  37. DB::rollBack();
  38. abort(500, '保存失败');
  39. }
  40. DB::commit();
  41. return response([
  42. 'data' => true
  43. ]);
  44. }
  45. if (!Plan::create($params)) {
  46. abort(500, '创建失败');
  47. }
  48. return response([
  49. 'data' => true
  50. ]);
  51. }
  52. public function drop(Request $request)
  53. {
  54. if (Order::where('plan_id', $request->input('id'))->first()) {
  55. abort(500, '该订阅下存在订单无法删除');
  56. }
  57. if (User::where('plan_id', $request->input('id'))->first()) {
  58. abort(500, '该订阅下存在用户无法删除');
  59. }
  60. if ($request->input('id')) {
  61. $plan = Plan::find($request->input('id'));
  62. if (!$plan) {
  63. abort(500, '该订阅ID不存在');
  64. }
  65. }
  66. return response([
  67. 'data' => $plan->delete()
  68. ]);
  69. }
  70. public function update(PlanUpdate $request)
  71. {
  72. $updateData = $request->only([
  73. 'show',
  74. 'renew'
  75. ]);
  76. $plan = Plan::find($request->input('id'));
  77. if (!$plan) {
  78. abort(500, '该订阅不存在');
  79. }
  80. try {
  81. $plan->update($updateData);
  82. } catch (\Exception $e) {
  83. abort(500, '保存失败');
  84. }
  85. return response([
  86. 'data' => true
  87. ]);
  88. }
  89. public function sort(PlanSort $request)
  90. {
  91. DB::beginTransaction();
  92. foreach ($request->input('plan_ids') as $k => $v) {
  93. if (!Plan::find($v)->update(['sort' => $k + 1])) {
  94. DB::rollBack();
  95. abort(500, '保存失败');
  96. }
  97. }
  98. DB::commit();
  99. return response([
  100. 'data' => true
  101. ]);
  102. }
  103. }