ShopController.php 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Http\Models\Goods;
  4. use App\Http\Models\GoodsLabel;
  5. use App\Http\Models\Label;
  6. use Illuminate\Http\Request;
  7. use Response;
  8. use Redirect;
  9. use Session;
  10. use DB;
  11. /**
  12. * 商店控制器
  13. * Class LoginController
  14. *
  15. * @package App\Http\Controllers
  16. */
  17. class ShopController extends Controller
  18. {
  19. // 商品列表
  20. public function goodsList(Request $request)
  21. {
  22. $goodsList = Goods::query()->where('is_del', 0)->orderBy('id', 'desc')->paginate(10);
  23. foreach ($goodsList as $goods) {
  24. $goods->traffic = flowAutoShow($goods->traffic * 1048576);
  25. }
  26. $view['goodsList'] = $goodsList;
  27. return Response::view('shop/goodsList', $view);
  28. }
  29. // 添加商品
  30. public function addGoods(Request $request)
  31. {
  32. if ($request->method() == 'POST') {
  33. $name = $request->get('name');
  34. $desc = $request->get('desc', '');
  35. $traffic = $request->get('traffic');
  36. $price = $request->get('price', 0);
  37. $score = $request->get('score', 0);
  38. $type = $request->get('type', 1);
  39. $days = $request->get('days', 90);
  40. $labels = $request->get('labels');
  41. $status = $request->get('status');
  42. if (empty($name) || empty($traffic)) {
  43. Session::flash('errorMsg', '请填写完整');
  44. return Redirect::back()->withInput();
  45. }
  46. // 套餐必须有价格
  47. if ($type == 2 && $price <= 0) {
  48. Session::flash('errorMsg', '套餐价格必须大于0');
  49. return Redirect::back()->withInput();
  50. }
  51. // 套餐有效天数必须大于90天
  52. if ($type == 2 && $days < 90) {
  53. Session::flash('errorMsg', '套餐有效天数必须不能少于90天');
  54. return Redirect::back()->withInput();
  55. }
  56. // 流量不能超过1PB
  57. if ($traffic > 1073741824) {
  58. Session::flash('errorMsg', '内含流量不能超过1PB');
  59. return Redirect::back()->withInput();
  60. }
  61. // 商品LOGO
  62. $logo = '';
  63. if ($request->hasFile('logo')) {
  64. $file = $request->file('logo');
  65. $fileType = $file->getClientOriginalExtension();
  66. $logoName = date('YmdHis') . mt_rand(1000, 2000) . '.' . $fileType;
  67. $move = $file->move(base_path() . '/public/upload/image/goods/', $logoName);
  68. $logo = $move ? '/upload/image/goods/' . $logoName : '';
  69. }
  70. DB::beginTransaction();
  71. try {
  72. $goods = new Goods();
  73. $goods->name = $name;
  74. $goods->desc = $desc;
  75. $goods->logo = $logo;
  76. $goods->traffic = $traffic;
  77. $goods->price = $price;
  78. $goods->score = $score;
  79. $goods->type = $type;
  80. $goods->days = $days;
  81. $goods->is_del = 0;
  82. $goods->status = $status;
  83. $goods->save();
  84. // 生成SKU
  85. $goods->sku = 'S0000' . $goods->id;
  86. $goods->save();
  87. // 生成商品标签
  88. if (!empty($labels)) {
  89. foreach ($labels as $label) {
  90. $goodsLabel = new GoodsLabel();
  91. $goodsLabel->goods_id = $goods->id;
  92. $goodsLabel->label_id = $label;
  93. $goodsLabel->save();
  94. }
  95. }
  96. Session::flash('successMsg', '添加成功');
  97. DB::commit();
  98. } catch (\Exception $e) {
  99. Session::flash('errorMsg', '添加失败');
  100. DB::rollBack();
  101. }
  102. return Redirect::to('shop/addGoods');
  103. } else {
  104. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  105. return Response::view('shop/addGoods', $view);
  106. }
  107. }
  108. // 编辑商品
  109. public function editGoods(Request $request)
  110. {
  111. $id = $request->get('id');
  112. if ($request->method() == 'POST') {
  113. $name = $request->get('name');
  114. $desc = $request->get('desc');
  115. $price = $request->get('price', 0);
  116. $labels = $request->get('labels');
  117. $status = $request->get('status');
  118. $goods = Goods::query()->where('id', $id)->first();
  119. if (!$goods) {
  120. Session::flash('errorMsg', '商品不存在');
  121. return Redirect::back();
  122. }
  123. if (empty($name)) {
  124. Session::flash('errorMsg', '请填写完整');
  125. return Redirect::back()->withInput();
  126. }
  127. // 套餐必须有价格
  128. if ($goods->type == 2 && $price <= 0) {
  129. Session::flash('errorMsg', '套餐价格必须大于0');
  130. return Redirect::back()->withInput();
  131. }
  132. // 商品LOGO
  133. $logo = '';
  134. if ($request->hasFile('logo')) {
  135. $file = $request->file('logo');
  136. $fileType = $file->getClientOriginalExtension();
  137. $logoName = date('YmdHis') . mt_rand(1000, 2000) . '.' . $fileType;
  138. $move = $file->move(base_path() . '/public/upload/image/goods/', $logoName);
  139. $logo = $move ? '/upload/image/goods/' . $logoName : '';
  140. }
  141. DB::beginTransaction();
  142. try {
  143. $data = [
  144. 'name' => $name,
  145. 'desc' => $desc,
  146. 'logo' => $logo,
  147. 'price' => $price * 100,
  148. 'status' => $status
  149. ];
  150. Goods::query()->where('id', $id)->update($data);
  151. // 先删除该商品所有的标签
  152. GoodsLabel::query()->where('goods_id', $id)->delete();
  153. // 生成商品标签
  154. if (!empty($labels)) {
  155. foreach ($labels as $label) {
  156. $goodsLabel = new GoodsLabel();
  157. $goodsLabel->goods_id = $id;
  158. $goodsLabel->label_id = $label;
  159. $goodsLabel->save();
  160. }
  161. }
  162. Session::flash('successMsg', '编辑成功');
  163. DB::commit();
  164. } catch (\Exception $e) {
  165. Session::flash('errorMsg', '编辑失败');
  166. DB::rollBack();
  167. }
  168. return Redirect::to('shop/editGoods?id=' . $id);
  169. } else {
  170. $goods = Goods::query()->with(['label'])->where('id', $id)->first();
  171. if ($goods) {
  172. $label = [];
  173. foreach ($goods->label as $vo) {
  174. $label[] = $vo->label_id;
  175. }
  176. $goods->labels = $label;
  177. }
  178. $view['goods'] = $goods;
  179. $view['label_list'] = Label::query()->orderBy('sort', 'desc')->orderBy('id', 'asc')->get();
  180. return Response::view('shop/editGoods', $view);
  181. }
  182. }
  183. // 删除商品
  184. public function delGoods(Request $request)
  185. {
  186. $id = $request->get('id');
  187. Goods::query()->where('id', $id)->update(['is_del' => 1]);
  188. return Response::json(['status' => 'success', 'data' => '', 'message' => '删除成功']);
  189. }
  190. }