Goods.php 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183
  1. <?php
  2. namespace app\admin\controller;
  3. use app\common\controller\Backend;
  4. use app\common\model\GoodsSku;
  5. use think\Db;
  6. /**
  7. * 商品列管理
  8. *
  9. * @icon fa fa-circle-o
  10. */
  11. class Goods extends Backend
  12. {
  13. /**
  14. * Goods模型对象
  15. * @var \app\admin\model\Goods
  16. */
  17. protected $model = null;
  18. public function _initialize()
  19. {
  20. parent::_initialize();
  21. $this->model = new \app\admin\model\Goods;
  22. $this->assign('status',\app\admin\model\Goods::getStatus());
  23. $this->assign('category',\app\common\model\Category::mall());
  24. }
  25. public function import()
  26. {
  27. parent::import();
  28. }
  29. /**
  30. * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
  31. * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
  32. * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
  33. */
  34. /**
  35. * 查看
  36. */
  37. public function index()
  38. {
  39. //当前是否为关联查询
  40. $this->relationSearch = true;
  41. //设置过滤方法
  42. $this->request->filter(['strip_tags', 'trim']);
  43. if ($this->request->isAjax()) {
  44. //如果发送的来源是Selectpage,则转发到Selectpage
  45. if ($this->request->request('keyField')) {
  46. return $this->selectpage();
  47. }
  48. list($where, $sort, $order, $offset, $limit) = $this->buildparams();
  49. $list = $this->model
  50. ->with(['category'])
  51. ->where($where)
  52. ->order($sort, $order)
  53. ->paginate($limit);
  54. foreach ($list as $row) {
  55. }
  56. $result = array("total" => $list->total(), "rows" => $list->items());
  57. return json($result);
  58. }
  59. return $this->view->fetch();
  60. }
  61. public function add()
  62. {
  63. if($this->request->isGet()){
  64. return $this->fetch();
  65. }else{
  66. $this->makeAdd();
  67. }
  68. }
  69. public function edit($ids = null)
  70. {
  71. if($this->request->isGet()){
  72. $row=$this->model->with(['sku'=>function($q){}])->findOrFail($ids);
  73. $this->assign('row',$row);
  74. return $this->fetch('add');
  75. }else{
  76. $this->makeAdd();
  77. }
  78. }
  79. protected function makeVal(){
  80. $data=input('row/a');
  81. $data['logo']=array_filter(explode(',',$data['logo']??''));
  82. if(empty($data['is_kill'])||$data['is_kill']==0){
  83. unset($data['amount_kill']);
  84. }
  85. $this->validate($data,[
  86. 'name|商品名称'=>['require'],
  87. 'category_id|商品分类'=>['require'],
  88. 'brand|品牌'=>['require'],
  89. 'amount|售价'=>['require','float','gt:0'],
  90. 'is_kill'=>['require'],
  91. 'amount_kill|秒杀价'=>['float','gt:0','requireIf:is_kill,1'],
  92. 'logo|LOGO'=>['require','array','min:1','max:6'],
  93. ]);
  94. foreach ($data['sku'] as $item){
  95. $this->validate($item,[
  96. 'name|规格名'=>['require'],
  97. 'num_stock|规格库存'=>['require','gt:0'],
  98. ]);
  99. }
  100. foreach ($data['detail'] as $item){
  101. $this->validate($item,[
  102. 'name|规格参数名'=>['require'],
  103. 'value|规格参数值'=>['require','gt:0'],
  104. ]);
  105. }
  106. foreach ($data['service'] as $item){
  107. $this->validate($item,[
  108. 'name|售后服务参数名'=>['require'],
  109. 'value|售后服务参数值'=>['require','gt:0'],
  110. ]);
  111. }
  112. return $data;
  113. }
  114. protected function makeAdd(){
  115. $data=$this->makeVal();
  116. if(!empty($data['id'])){
  117. $goods=$this->model->findOrFail($data['id']);
  118. }else{
  119. $goods=new $this->model;
  120. }
  121. Db::startTrans();
  122. foreach ($data as $key=>$value){
  123. if(!in_array($key,$goods::$read)){
  124. $goods[$key]=$value;
  125. }
  126. }
  127. $goods->allowField(true)->save();
  128. $ids=[];
  129. foreach ($data['sku'] as $sku){
  130. if(!empty($sku['id'])){
  131. $SKU=$goods->sku()->find($sku['id']);
  132. $SKU->save($sku);
  133. }else{
  134. $SKU=$goods->sku()->save($sku);
  135. }
  136. $ids[]=$SKU['id'];
  137. }
  138. $goods->sku()->whereNotIn('id',$ids)->update(['is_del'=>1]);
  139. $ids=[];
  140. foreach ($data['detail'] as $temp){
  141. if(!empty($temp['id'])){
  142. $model=$goods->detail()->find($temp['id']);
  143. $model->save($temp);
  144. }else{
  145. $model=$goods->detail()->save($temp);
  146. }
  147. $ids[]=$model['id'];
  148. }
  149. $goods->detail()->whereNotIn('id',$ids)->delete();
  150. $ids=[];
  151. foreach ($data['service'] as $temp){
  152. if(!empty($temp['id'])){
  153. $model=$goods->service()->find($temp['id']);
  154. $model->save($temp);
  155. }else{
  156. $model=$goods->service()->save($temp);
  157. }
  158. $ids[]=$model['id'];
  159. }
  160. $goods->service()->whereNotIn('id',$ids)->delete();
  161. Db::commit();
  162. $this->success();
  163. }
  164. }