Gift.class.php
3.84 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
<?php
class Gift {
/**GIFT:1.根据ID查询活动礼品分类**/
public function getOne($id) {
global $_W;
$condition = '`uniacid`=:uniacid AND `id`=:id';
$pars = array();
$pars[':uniacid'] = $_W['uniacid'];
$pars[':id'] = $id;
$sql = 'SELECT * FROM ' . tablename('wwx_fxxt_red_gifts') . " WHERE {$condition}";
$entity = pdo_fetch($sql, $pars);
if(!empty($entity)) {
$entity['tag'] = @unserialize($entity['tag']);
}
return $entity;
}
/**GIFT:2.查询所有活动礼品分类**/
public function getAll($filters, $pindex = 0, $psize = 20, &$total = 0) {
global $_W;
$condition = '`uniacid`=:uniacid';
$pars = array();
$pars[':uniacid'] = $_W['uniacid'];
if(!empty($filters['type'])) {
$condition .= ' AND `type`=:type';
$pars[':type'] = $filters['type'];
}
if(!empty($filters['title'])) {
$condition .= ' AND `title` LIKE :title';
$pars[':title'] = "%{$filters['title']}%";
}
$sql = 'SELECT * FROM ' . tablename('wwx_fxxt_red_gifts') . " WHERE {$condition} ORDER BY `id` DESC";
if($pindex > 0) {
$sql = "SELECT COUNT(*) FROM " . tablename('wwx_fxxt_red_gifts') . " WHERE {$condition}";
$total = pdo_fetchcolumn($sql, $pars);
$start = ($pindex - 1) * $psize;
$sql = "SELECT * FROM " . tablename('wwx_fxxt_red_gifts') . " WHERE {$condition} ORDER BY `id` DESC LIMIT {$start},{$psize}";
}
$ds = pdo_fetchall($sql, $pars);
return $ds;
}
/**GIFT:3.添加活动礼品分类**/
public function create($entity) {
global $_W;
$rec = array_elements(array('title', 'type', 'remark', 'tag'), $entity);
$rec['uniacid'] = $_W['uniacid'];
$condition = '`uniacid`=:uniacid AND `title`=:title';
$pars = array();
$pars[':uniacid'] = $rec['uniacid'];
$pars[':title'] = $rec['title'];
$sql = 'SELECT * FROM ' . tablename('wwx_fxxt_red_gifts') . " WHERE {$condition}";
$exists = pdo_fetch($sql, $pars);
if(!empty($exists)) {
return error(-1, '这个礼品名称已经使用, 请更换');
}
$ret = pdo_insert('wwx_fxxt_red_gifts', $rec);
if(!empty($ret)) {
$id = pdo_insertid();
return $id;
}
return false;
}
/**GIFT:4.根据ID编辑活动礼品分类**/
public function modify($id, $entity) {
global $_W;
$id = intval($id);
$rec = array_elements(array('title', 'type', 'remark', 'tag'), $entity);
$rec['uniacid'] = $_W['uniacid'];
$condition = '`uniacid`=:uniacid AND `title`=:title AND `id`!=:id';
$pars = array();
$pars[':uniacid'] = $rec['uniacid'];
$pars[':title'] = $rec['title'];
$pars[':id'] = $id;
$sql = 'SELECT * FROM ' . tablename('wwx_fxxt_red_gifts') . " WHERE {$condition}";
$exists = pdo_fetch($sql, $pars);
if(!empty($exists)) {
return error(-1, '这个礼品名称已经使用, 请更换');
}
$ret = pdo_update('wwx_fxxt_red_gifts', $rec, array('id'=>$id));
return $ret !== false;
}
/**GIFT:5.根据ID删除活动礼品分类**/
public function remove($id) {
global $_W;
$pars = array();
$pars[':uniacid'] = $_W['uniacid'];
$sql = 'DELETE FROM ' . tablename('wwx_fxxt_red_activity_gifts') . ' WHERE `gift`=:id';
pdo_query($sql, $pars);
$pars[':id'] = $id;
$sql = 'DELETE FROM ' . tablename('wwx_fxxt_red_gifts') . ' WHERE `uniacid`=:uniacid AND `id`=:id';
pdo_query($sql, $pars);
$sql = 'DELETE FROM ' . tablename('wwx_fxxt_red_records') . ' WHERE `uniacid`=:uniacid AND `gift`=:id';
pdo_query($sql, $pars);
return true;
}
}