Dao.php
3.14 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
<?php
/**
* Created by JetBrains PhpStorm.
* User: elkan
* Date: 14-8-18
* Time: 下午6:04
* To change this template use File | Settings | File Templates.
*/
use YHMSupport\SqlMap\Choicegoods;
class YHMSupport_Models_Choicegoods_Dao extends YHMSupport_Dao {
private $_tag = 'support_choice_goods';
public function __construct() {
$this->router = 'choice_goods.yhm_support';
}
/**
* 精选商品列表
* @return type
*/
function getList($offset, $num) {
return $this->dao()->tag($this->_tag)->key('getList' . $offset . '_' . $num)->fetchAll(Choicegoods\Choicegoods::SELECT_CHOICE_LIST, array('offset' => $offset, 'num' => $num));
}
/**
* 添加精选商品关联
* @param number $product_skc
* @param number $order_by
* @param number $create_uid
*/
function setChoice($product_skc, $order_by = 1, $create_uid = 0) {
$params = array(
'product_skc' => $product_skc,
'order_by' => $order_by,
'create_uid' => $create_uid
);
return $this->dao()->tag($this->_tag)->insert(Choicegoods\Choicegoods::SET_CHOICE, $params)->status();
}
function delChoice($product_skc) {
return $this->dao()->tag($this->_tag)->delete(Choicegoods\Choicegoods::DELETE_CHOICE, array('product_skc' => $product_skc))->status();
}
/**
* 获取所有精选
* @return type
*/
function getCount() {
return $this->dao()->cache(false)->fetchOne(Choicegoods\Choicegoods::SELECT_COUNT_CHOICE);
}
function setSortBySkc($skc, $sort) {
return $this->dao()->cache(false)->update(Choicegoods\Choicegoods::UPDATE_SORT_BY_SKC, array('product_skc' => $skc, 'order_by' => $sort));
}
/**
* 根据类型获取所有精选
* @return type
*/
function getCountByType($type, $keyword) {
$sqlArr = array();
$param = array();
if ($type == 1 && !empty($keyword)) {
$sqlArr[] = "id = '$keyword'";
}
$sql = '1=1';
if (!empty($sqlArr)) {
$sql = implode(' and ', $sqlArr);
}
return $this->dao()->cache(false)->fetchOne(Choicegoods\Choicegoods::SELECT_COUNT_CHOICE_BY_TYPE, $param, array('sql' => $sql));
}
/**
* 根据类型获精选商品列表
* @return type
*/
function getListByType($type, $keyword, $offset, $num) {
$sqlArr = array();
$params = array(
'offset' => $offset,
'num' => $num
);
if ($type == 1 && !empty($keyword)) {
$sqlArr[] = "id = '$keyword'";
}
$sql = '1=1';
if (!empty($sqlArr)) {
$sql = implode(' and ', $sqlArr);
}
return $this->dao()->cache(false)->fetchAll(Choicegoods\Choicegoods::SELECT_CHOICE_LIST_BY_TYPE, $params, array('sql' => $sql));
}
/**
* 精选商品列表
* @return type
*/
function getGoodsList($offset, $num) {
return $this->dao()->tag($this->_tag)->key('getGoodsList' . $offset . '_' . $num)->fetchAll(Choicegoods\Choicegoods::SELECT_CHOICE_GOODS_LIST, array('offset' => $offset, 'num' => $num));
}
}