GoodsService.php 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | Laravel框架 [ Laravel ]
  4. // +----------------------------------------------------------------------
  5. // | 版权所有 2017~2021 南京Laravel研发中心
  6. // +----------------------------------------------------------------------
  7. // | 官方网站: http://www.laravel.cn
  8. // +----------------------------------------------------------------------
  9. // | Author: wesmiler <12345678@qq.com>
  10. // +----------------------------------------------------------------------
  11. namespace App\Services;
  12. use App\Models\GoodsModel;
  13. /**
  14. * 商品管理-服务类
  15. * @author wesmiler
  16. * @since 2020/11/11
  17. * Class GoodsService
  18. * @package App\Services
  19. */
  20. class GoodsService extends BaseService
  21. {
  22. /**
  23. * 构造函数
  24. * @author wesmiler
  25. * @since 2020/11/11
  26. * GoodsService constructor.
  27. */
  28. public function __construct()
  29. {
  30. $this->model = new GoodsModel();
  31. }
  32. /**
  33. * 获取友链列表
  34. * @return array
  35. * @since 2020/11/11
  36. * @author wesmiler
  37. */
  38. public function getList()
  39. {
  40. $params = request()->all();
  41. $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE;
  42. $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE;
  43. $dataList = $this->model::from('goods as g')
  44. ->leftJoin('goods_cates as c', 'g.cate_id', '=', 'c.id')
  45. ->where(function ($query) use ($params) {
  46. $title = isset($params['title']) ? trim($params['title']) : '';
  47. if (!empty($title)) {
  48. $query->where('g.title', 'like', "%{$title}%");
  49. }
  50. $cateId = isset($params['cate_id']) ? intval($params['cate_id']) : 0;
  51. if ($cateId > 0) {
  52. $query->where('g.cate_id', $cateId);
  53. } else if ($cateId == -1) {
  54. $query->where('g.is_recommand', 1);
  55. }
  56. $status = isset($params['status']) ? $params['status'] : 0;
  57. if ($status > 0) {
  58. $query->where('g.status', $status);
  59. } else {
  60. $query->whereIn('g.status', [1, 2]);
  61. }
  62. })
  63. ->select(['g.id', 'g.cate_id', 'c.name as cate_name', 'g.title', 'g.stock', 'g.price', 'g.specs', 'g.thumb', 'g.status', 'g.create_time', 'g.update_time', 'g.description', 'g.sort', 'g.view_num','g.albums','g.content','g.is_recommand'])
  64. ->orderBy('g.update_time', 'desc')
  65. ->paginate($pageSize);
  66. $dataList = $dataList ? $dataList->toArray() : [];
  67. if ($dataList) {
  68. foreach ($dataList['data'] as &$item) {
  69. $item['thumb'] = $item['thumb'] ? get_image_url($item['thumb']) : '';
  70. $item['albums'] = isset($item['albums']) && $item['albums'] ? json_decode($item['albums'], true) : [];
  71. if($item['albums']){
  72. foreach ($item['albums'] as &$v){
  73. $v['url'] = isset($v['url']) && $v['url']? get_image_url($v['url']) : '';
  74. }
  75. }
  76. }
  77. unset($item);
  78. }
  79. return [
  80. 'code' => 0,
  81. 'success'=> true,
  82. 'msg' => '操作成功',
  83. 'count' => isset($dataList['total']) ? $dataList['total'] : 0,
  84. 'data' => isset($dataList['data']) ? $dataList['data'] : 0,
  85. ];
  86. }
  87. /**
  88. * 添加或编辑
  89. * @return array
  90. * @since 2020/11/11
  91. * @author wesmiler
  92. */
  93. public function edit()
  94. {
  95. $data = request()->all();
  96. // 图片处理
  97. $image = trim($data['thumb']);
  98. $id = isset($data['id']) ? $data['id'] : 0;
  99. if (!$id && !$image) {
  100. return message('请上传商品图片', false);
  101. }
  102. if (strpos($image, "temp")) {
  103. $data['thumb'] = save_image($image, 'item');
  104. } else {
  105. $data['thumb'] = str_replace(IMG_URL, "", $data['thumb']);
  106. }
  107. // 图册上传处理
  108. if(isset($data['albums'])){
  109. if($data['albums']){
  110. foreach ($data['albums'] as &$v){
  111. $v['url'] = isset($v['url']) && $v['url']? str_replace(IMG_URL, "", $v['url']) : '';
  112. }
  113. }
  114. $data['albums'] = $data['albums']? json_encode($data['albums'], 256) : '';
  115. }
  116. $data['update_time'] = time();
  117. return parent::edit($data); // TODO: Change the autogenerated stub
  118. }
  119. }