table_forum_trade.php
3.96 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
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: table_forum_trade.php 27769 2012-02-14 06:29:36Z liulanbo $
*/
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
class table_forum_trade extends discuz_table
{
public function __construct() {
$this->_table = 'forum_trade';
$this->_pk = '';
parent::__construct();
}
public function fetch_all_thread_goods($tid, $pid = 0) {
$pidsql = $pid ? ' AND '.DB::field('pid', $pid) : '';
return DB::fetch_all("SELECT * FROM %t WHERE tid=%d $pidsql ORDER BY displayorder", array($this->_table, $tid));
}
public function fetch_counter_thread_goods($tid) {
return DB::result_first('SELECT COUNT(*) FROM %t WHERE tid=%d', array($this->_table, $tid));
}
public function fetch_all_for_seller($sellerid, $limit = 10, $tid = 0) {
$tidsql = $tid ? ' AND '.DB::field('tid', $tid) : '';
return DB::fetch_all("SELECT * FROM %t WHERE sellerid=%d $tidsql ORDER BY displayorder DESC LIMIT %d", array($this->_table, $sellerid, $limit));
}
public function fetch_first_goods($tid) {
return DB::fetch_first('SELECT * FROM %t WHERE tid=%d ORDER BY displayorder DESC LIMIT 1', array($this->_table, $tid));
}
public function fetch_goods($tid, $pid, $orderby = '', $ascdesc = 'asc', $start = 0, $limit = 0) {
if(empty($pid)) {
return array();
}
if($tid) {
$tidsql = DB::field('tid', $tid).' AND ';
}
if($orderby) {
$ordersql = " ORDER BY ".DB::order($orderby, $ascdesc);
}
return DB::fetch_first("SELECT * FROM %t WHERE $tidsql ".DB::field('pid', $pid).$ordersql.DB::limit($start, $limit), array($this->_table));
}
public function fetch_all_statvars($fieldname, $limit = 10) {
if(empty($fieldname)) {
return array();
}
return DB::fetch_all("SELECT subject, tid, pid, seller, sellerid, SUM(%s) as %s
FROM ".DB::table('forum_trade')."
WHERE %s>0
GROUP BY sellerid
ORDER BY %s DESC ".DB::limit($limit), array($fieldname, $fieldname, $fieldname));
}
public function update_closed($expiration) {
DB::query("UPDATE %t SET closed='1' WHERE expiration>0 AND expiration<%d", array($this->_table, $expiration));
}
public function check_goods($pid) {
return DB::result_first('SELECT count(*) FROM %t WHERE pid=%d', array($this->_table, $pid));
}
public function update($tid, $pid, $data) {
if(empty($data) || !is_array($data)) {
return false;
}
DB::update('forum_trade', $data, array('tid' => $tid, 'pid' => $pid));
}
public function update_counter($tid, $pid, $items, $price, $credit, $amount = 0) {
DB::query('UPDATE %t SET totalitems=totalitems+\'%d\', tradesum=tradesum+\'%d\', credittradesum=credittradesum+\'%d\', amount=amount+\'%d\' WHERE tid=%d AND pid=%d', array($this->_table, $items, $price, $credit, $amount, $tid, $pid));
}
public function delete_by_id_idtype($ids, $idtype) {
if(empty($ids) || empty($idtype)) {
return false;
}
DB::delete($this->_table, DB::field($idtype, $ids));
}
public function fetch_all_for_search($digestltd, $fids, $topltd, $sqlsrch, $start = 0, $limit = 0) {
return DB::fetch_all("SELECT tr.tid, tr.pid, t.closed FROM ".DB::table('forum_trade')." tr INNER JOIN ".DB::table('forum_thread')." t ON tr.tid=t.tid AND $digestltd t.".DB::field('fid', $fids)." $topltd WHERE$sqlsrch ORDER BY tr.pid DESC".DB::limit($start, $limit));
}
public function fetch_all_for_space($wheresql, $ordersql, $count = 0, $start = 0, $limit = 0) {
if(empty($wheresql)) {
return array();
}
if($count) {
return DB::result_first("SELECT COUNT(*) FROM ".DB::table('forum_trade')." t WHERE $wheresql");
}
if($ordersql && is_string($ordersql)) {
$ordersql = ' ORDER BY '.$ordersql;
}
return DB::fetch_all("SELECT t.* FROM ".DB::table('forum_trade')." t
INNER JOIN ".DB::table('forum_thread')." th ON t.tid=th.tid AND th.displayorder>='0'
WHERE $wheresql $ordersql ".DB::limit($start, $limit));
}
}
?>