anyv / xkeasy · 文件

转到一个项目

审查视图

app/admin/controller/GoodsController.php 8.9 KB
原文件 普通视图 历史 永久链接
首次提交
d5556cd5
 
anyv authored
1 2 3 4 5 6 7 8 9 10 11 12 13 
<?php
namespace app\admin\controller;

use app\admin\model\RouteModel;
use cmf\controller\AdminBaseController;
use think\Db;

class GoodsController extends AdminBaseController{

    /**
     * 平台商品列表
     */
    public function goods_list(){
后台列表筛选优化
8dc348e0
 
刘朕 authored
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 
        $param = $this->request->param();
        $where = [
            'type' => ['=', 1],
        ];
        if(!empty($param['start_time']) && !empty($param['end_time'])){
            $start_time = strtotime($param['start_time']);
            $end_time = strtotime($param['end_time']);
            $where['create_time'] = [['>=',$start_time],['<=',$end_time]];
        }
        if(!empty($param['keyword'])){
            $keyword = $param['keyword'];
            $where['book_name'] = ['like',"%$keyword%"];
        }
        if(!empty($param['classify_id'])){
            if($param['classify_id'] == 0){
                $where['classify_id'] = 0;
            }elseif ($param['classify_id'] == 100){
首次提交
d5556cd5
 
anyv authored
31
后台列表筛选优化
8dc348e0
 
刘朕 authored
32 33 
            }else{
                $where['classify_id'] = $param['classify_id'];
首次提交
d5556cd5
 
anyv authored
34 35 
            }
        }
后台列表筛选优化
8dc348e0
 
刘朕 authored
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 
        $classif_data = Db::name('classification') -> select();
        $this -> assign('classif_data',$classif_data);
        $data = Db::name('goods') -> where($where)->order('create_time','DESC')->paginate(12);
        $data1 = $data -> toArray();
        foreach ($data1['data'] as $key => $val){
            $class_data = Db::name('classification') -> where('id',$val['classify_id']) -> find();
            $data1['data'][$key]['classify_name'] = $class_data['name'];
        }
        $this->assign('start_time',!empty($param['start_time']) ? $param['start_time'] : '');
        $this->assign('end_time',!empty($param['end_time']) ? $param['end_time'] : '');
        $this->assign('keyword',!empty($param['keyword']) ? $param['keyword'] : '');
        $this->assign('classify_id',!empty($param['classify_id']) ? $param['classify_id'] : '');
        $this -> assign('data',$data1['data']);
        $this -> assign('res',$data);
        return $this -> fetch();
首次提交
d5556cd5
 
anyv authored
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 

    }

    /**
     * 平台商品添加
     */
    public function goods_add(){

        if($this -> request -> isPost()){
            if(!empty($_POST['det_img'])){
                $_POST['det_img'] = json_encode($_POST['det_img']);
                $_POST['det_name'] = json_encode($_POST['det_name']);
            }
            $_POST['type'] = 1;
            $_POST['create_time'] = time();
商品编辑
4685b751
 
anyv authored
66 
            if(!empty($_POST['label_id'])){
商品添加
6bc9c9f1
 
anyv authored
67 68 
                $label_id = $_POST['label_id'];
            }
商品添加
2df3ef27
 
anyv authored
69 
            unset($_POST['label_id']);
商品标签修改
15e5d366
 
anyv authored
70 
            $data = Db::name('goods') -> insertGetId($_POST);
商品添加
5405f17f
 
anyv authored
71 72 73 74 
            if(!empty($label_id)){
                foreach($label_id as $key => $val){
                    Db::name('goods_label') -> insert(['goods_id'=>$data,'label_id'=>$val]);
                }
商品标签修改
15e5d366
 
anyv authored
75 
            }
首次提交
d5556cd5
 
anyv authored
76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 
            if($data){
                $this -> success('添加成功',url('Goods/goods_add'));
            }else{
                $this -> error('添加失败');
            }
        }else{
            $classif_data = Db::name('classification') -> select();
            $this -> assign('classif_data',$classif_data);
            $label_data = Db::name('label') -> select();
            $this -> assign('label_data',$label_data);
            return $this -> fetch();
        }

    }

    /**
     * 平台商品编辑
     */
    public function goods_edit(){

        if($this -> request -> isPost()){
            if(!empty($_POST['det_img'])){
                $_POST['det_img'] = json_encode($_POST['det_img']);
                $_POST['det_name'] = json_encode($_POST['det_name']);
            }
商品编辑
26cd875b
 
anyv authored
101 102 103 
            if(!empty($_POST['label_id'])){
                $label_id = $_POST['label_id'];
            }
商品标签编辑
b98751fa
 
anyv authored
104 
            unset($_POST['label_id']);
商品编辑
313a5cb9
 
anyv authored
105 
            $goods_label_del = Db::name('goods_label') -> where('goods_id',$_POST['id']) -> delete();
商品编辑
de8f051e
 
anyv authored
106 
            if(!empty($label_id)){
商品编辑
26cd875b
 
anyv authored
107 108 109 
                foreach ($label_id as $key => $val){
                    $goods_label_data = Db::name('goods_label') -> insert(['goods_id'=>$_POST['id'],'label_id'=>$val]);
                }
商品标签编辑
b98751fa
 
anyv authored
110 
            }
首次提交
d5556cd5
 
anyv authored
111 
            $data = Db::name('goods') -> update($_POST);
商品编辑
54453d77
 
anyv authored
112 
            $this -> success('保存成功',url('Goods/goods_edit',array('id'=>$_POST['id'])));
首次提交
d5556cd5
 
anyv authored
113 114 115 116 117 118 119 120 121 122 123 
        }else{
            $id = $this -> request -> param();
            $data = Db::name('Goods') -> where('id',$id['id']) -> find();
            if(!empty($data['det_img'])){
                $data['det_img'] = json_decode($data['det_img'],true);
                $data['det_name'] = json_decode($data['det_name'],true);
                foreach ($data['det_img'] as $key => $val){
                    $data['more'][$key]['url'] = $data['det_img'][$key];
                    $data['more'][$key]['name'] = $data['det_name'][$key];
                }
            }
商品编辑
4fc4cd7e
 
anyv authored
124 125 
            $data_gradeall = Db::name('gradeall ') -> select();
            $this -> assign('data_gradeall',$data_gradeall);
首次提交
d5556cd5
 
anyv authored
126 127 128 129 130 131 132 
            $this -> assign('data',$data);
        }

        $classif_data = Db::name('classification') -> select();
        $this -> assign('classif_data',$classif_data);
        $label_data = Db::name('label') -> select();
        $this -> assign('label_data',$label_data);
商品编辑
33ff684f
 
anyv authored
133 
        $goods_label_data = Db::name('goods_label') -> where('goods_id',$id['id']) -> column('label_id');
商品标签编辑
ba14d534
 
anyv authored
134 
        $this -> assign('goods_label_data',$goods_label_data);
首次提交
d5556cd5
 
anyv authored
135 136 137 138 139 140 141 142 143 144 145 146 147 
        return $this -> fetch();

    }

    /**
     * 平台商品下架
     */
    public function sold_out(){

        $id = $_POST['id'];
        $data['id'] = $id;
        $data['is_out'] = 0;
        $res = Db::name('Goods') -> update($data);
44
385f4324
 
anyv authored
148 149 
        Db::name('collect') -> where('goods_id',$id) -> delete();
        Db::name('browsing_history') -> where('goods_id',$id) -> delete();
66
a8cb92b0
 
anyv authored
150 
        Db::name('shopping_cart') -> where('goods_id',$id) -> delete();
首次提交
d5556cd5
 
anyv authored
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 
        if($res){
            return true;
        }else{
            return false;
        }

    }

    /**
     * 平台商品上架
     */
    public function putaway(){

        $id = $_POST['id'];
        $data['id'] = $id;
        $data['is_out'] = 1;
        $res = Db::name('Goods') -> update($data);
        if($res){
            return true;
        }else{
            return false;
        }

    }

    /**
     * 平台商品删除
     */
    public function goods_del(){

        $id = $_POST['id'];
        $data = Db::name('goods') -> delete($id);
删除商品
0e4f5fb4
 
anyv authored
183 
        Db::name('goods_label') -> where('goods_id',$id) -> delete();
74
e160e665
 
anyv authored
184 
        Db::name('collect') -> where("goods_id = ".$id) -> delete();
44
385f4324
 
anyv authored
185 
        Db::name('browsing_history') -> where("goods_id = ".$id) -> delete();
66
a8cb92b0
 
anyv authored
186 
        Db::name('shopping_cart') -> where('goods_id',$id) -> delete();
首次提交
d5556cd5
 
anyv authored
187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 
        if($data){
            return true;
        }else{
            return false;
        }

    }

    /**
     * 推荐新品
     */
    public function goods_new(){

        if($this -> request -> isPost()){
            $ids = $_POST['ids'];
            $arr_id = explode(',',$ids);
            $data = Db::name('goods') -> where('recommend_new',1) -> select();
            if(!empty($data)){
                foreach ($data as $key => $val){
                    Db::name("goods") -> where('id',$val['id']) -> update(["recommend_new"=>0]);
                }
            }
            foreach ($arr_id as $key => $val){
                Db::name("goods") -> where('id',$arr_id[$key]) -> update(["recommend_new"=>1]);
            }
            return true;
        }else{
推荐
5c24aacb
 
anyv authored
214 
            $data = Db::name('goods') -> where('is_out =1 and type =1') -> select() -> toArray();
首次提交
d5556cd5
 
anyv authored
215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 
            foreach ($data as $key => $val){
                $class_data = Db::name('classification') -> where('id',$val['classify_id']) -> find();
                $data[$key]['classify_name'] = $class_data['name'];
            }
            $this -> assign('data',$data);
            return $this -> fetch();
        }

    }

    /**
     * 推荐热门
     */
    public function goods_hot(){

        if($this -> request -> isPost()){
            $ids = $_POST['ids'];
            $arr_id = explode(',',$ids);
            $data = Db::name('Goods') -> where('recommend_hot',1) -> select();
            if(!empty($data)){
                foreach ($data as $key => $val){
                    Db::name("Goods") -> where('id',$val['id']) -> update(["recommend_hot"=>0]);
                }
            }
            foreach ($arr_id as $key => $val){
                Db::name("Goods") -> where('id',$arr_id[$key]) -> update(["recommend_hot"=>1]);
            }
            return true;
        }else{
推荐
5c24aacb
 
anyv authored
244 
            $data = Db::name('Goods') -> where('is_out =1 and type =1') -> select() -> toArray();
首次提交
d5556cd5
 
anyv authored
245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 
            foreach ($data as $key => $val){
                $class_data = Db::name('classification') -> where('id',$val['classify_id']) -> find();
                $data[$key]['classify_name'] = $class_data['name'];
            }
            $this -> assign('data',$data);
            return $this -> fetch();
        }

    }
























}