ZjGoodsController.php
3.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
/**
* Created by PhpStorm.
* User: wz
* Date: 2018/9/26
* Time: 14:29
*/
namespace app\admin\controller;
use cmf\controller\AdminBaseController;
use think\Db;
class ZjGoodsController extends AdminBaseController
{
/**
* 商品列表
*/
public function index(){
$where['g.delete_time']=0;
$param=[];
if ($this->request->param()){
$param=input('param.');
if (!empty($param['cate'])){
$where['ca.id']=$param['cate'];
}
}
$all=Db::name('zj_goods')->alias('g')->join('zj_category c','g.cid=c.id')->join('zj_category ca','c.cid=ca.id')
->where($where)->field('g.*,c.name as cname,ca.name as caname')->order('create_time','desc')->paginate(15);
$all->appends($param);
$this->assign('all',$all->items());
$this->assign('page',$all->render());
return $this->fetch();
}
/**
* 商品分类列表
*/
public function category(){
$all=Db::name('zj_category')->alias('c')->join('zj_category ca','c.cid=ca.id','left')
->field('c.*,ca.name as cname')->where('c.delete_time','0')->select();
$this->assign('all',$all);
return $this->fetch();
}
/**
* 添加商品分类
*/
public function addCate(){
$all=Db::name('zj_category')->where('grade','1')->select();
$this->assign('all',$all);
return $this->fetch();
}
/**
* 添加商品分类提交
*/
public function addCatePost(){
if ($this->request->param()){
$param=input('param.');
$param['create_time']=time();
$add=Db::name('zj_category')->insert($param);
if (empty($add)){
$this->error('添加分类失败');
}else{
$this->success('添加分类成功');
}
}
}
/**
* 编辑分类
*/
public function editCate(){
if ($this->request->param()){
$param=input('param.id');
$one=Db::name('zj_category')->where('id',$param)->find();
$all=Db::name('zj_category')->where('grade','1')->select();
$this->assign('all',$all);
$this->assign('one',$one);
return $this->fetch();
}
}
/**
* 编辑分类提交
*/
public function editCatePost(){
if ($this->request->param()){
$param=input('param.');
$edit=Db::name('zj_category')->update($param);
if (empty($edit)){
$this->error('保存失败');
}else{
$this->success('保存成功');
}
}
}
/**
* 删除分类
*/
public function delCate(){
if ($this->request->isAjax()){
$param=input('param.id');
$edit=Db::name('zj_category')->where(['id'=>$param,'grade'=>'2'])->update(['delete_time'=>time()]);
if (empty($edit)){
$this->error('删除失败');
}else{
$this->success('删除成功');
}
}
}
}