ShopController.php 7.6 KB

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