table_forum_tradecomment.php
2.2 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
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: table_forum_tradecomment.php 27737 2012-02-13 09:46:21Z monkey $
*/
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
class table_forum_tradecomment extends discuz_table
{
public function __construct() {
$this->_table = 'forum_tradecomment';
$this->_pk = 'id';
parent::__construct();
}
function fetch_all_by_rateeid($rateeid, $type, $dateline = 0) {
$dateline = $dateline ? 'AND dateline>='.intval($dateline) : '';
return DB::fetch_all("SELECT * FROM %t WHERE rateeid=%d AND type=%d %i", array($this->_table, $rateeid, $type, $dateline));
}
function fetch_all_list($from, $uid, $dateline, $score, $start) {
$sql = $from == 'myself' ? "tc.raterid='".intval($uid)."'" : "tc.rateeid='".intval($uid)."'";
$sql .= $from == 'buyer' ? ' AND tc.type=0' : ($from == 'seller' ? ' AND tc.type=1' : '');
$dateline = $dateline !== false ? ' AND tc.dateline>='.intval($dateline) : '';
$score = $score !== false ? ' AND tc.score='.intval($score) : '';
return DB::fetch_all("SELECT tc.*, tl.subject, tl.price, tl.credit FROM %t tc LEFT JOIN %t tl USING(orderid) WHERE %i %i %i ORDER BY tc.dateline DESC LIMIT %d, 10",
array($this->_table, 'forum_tradelog', $sql, $dateline, $score, $start));
}
function count_list($from, $uid, $dateline, $score) {
$sql = $from == 'myself' ? "tc.raterid='".intval($uid)."'" : "tc.rateeid='".intval($uid)."'";
$sql .= $from == 'buyer' ? ' AND tc.type=0' : ($from == 'seller' ? ' AND tc.type=1' : '');
$dateline = $dateline !== false ? ' AND tc.dateline>='.intval($dateline) : '';
$score = $score !== false ? ' AND tc.score='.intval($score) : '';
return DB::result_first("SELECT COUNT(*) FROM %t tc WHERE %i %i %i", array($this->_table, $sql, $dateline, $score));
}
function get_month_score($uid, $type, $rateeid) {
$monthfirstday = mktime(0, 0, 0, date('m', TIMESTAMP), 1, date('Y', TIMESTAMP));
return DB::result_first("SELECT COUNT(score) FROM %t WHERE raterid=%d AND type=%d AND dateline>=%d AND rateeid=%d", array($this->_table, $uid, $type, $monthfirstday, $rateeid));
}
}
?>