1
|
|
|
<?php |
2
|
|
|
// |
3
|
|
|
// ------------------------------------------------------------------------ // |
4
|
|
|
// This program is free software; you can redistribute it and/or modify // |
5
|
|
|
// it under the terms of the GNU General Public License as published by // |
6
|
|
|
// the Free Software Foundation; either version 2 of the License, or // |
7
|
|
|
// (at your option) any later version. // |
8
|
|
|
// // |
9
|
|
|
// You may not change or alter any portion of this comment or credits // |
10
|
|
|
// of supporting developers from this source code or any supporting // |
11
|
|
|
// source code which is considered copyrighted (c) material of the // |
12
|
|
|
// original comment or credit authors. // |
13
|
|
|
// // |
14
|
|
|
// This program is distributed in the hope that it will be useful, // |
15
|
|
|
// but WITHOUT ANY WARRANTY; without even the implied warranty of // |
16
|
|
|
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // |
17
|
|
|
// GNU General Public License for more details. // |
18
|
|
|
// // |
19
|
|
|
// You should have received a copy of the GNU General Public License // |
20
|
|
|
// along with this program; if not, write to the Free Software // |
21
|
|
|
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // |
22
|
|
|
// ------------------------------------------------------------------------ // |
23
|
|
|
// Author: phppp (D.J., [email protected]) // |
24
|
|
|
// URL: https://xoops.org // |
25
|
|
|
// Project: Article Project // |
26
|
|
|
// ------------------------------------------------------------------------ // |
27
|
|
|
|
28
|
|
|
// defined('XOOPS_ROOT_PATH') || die('Restricted access'); |
29
|
|
|
require_once __DIR__ . '/../include/vars.php'; |
30
|
|
|
//mod_loadFunctions('', $GLOBALS['moddirname']); |
31
|
|
|
|
32
|
|
|
if (!class_exists('Brate')): |
33
|
|
|
/** |
34
|
|
|
* Class Brate |
35
|
|
|
*/ |
36
|
|
|
class Brate extends XoopsObject |
37
|
|
|
{ |
38
|
|
|
/** |
39
|
|
|
* Brate constructor. |
40
|
|
|
* @param null $id |
41
|
|
|
*/ |
42
|
|
|
public function __construct($id = null) |
43
|
|
|
{ |
44
|
|
|
// $this->ArtObject(); |
45
|
|
|
$this->table = planet_DB_prefix('rate'); |
46
|
|
|
$this->initVar('rate_id', XOBJ_DTYPE_INT, null, false); |
47
|
|
|
$this->initVar('art_id', XOBJ_DTYPE_INT, 0, true); |
48
|
|
|
$this->initVar('rate_uid', XOBJ_DTYPE_INT, 0); |
49
|
|
|
$this->initVar('rate_ip', XOBJ_DTYPE_INT, 0); |
50
|
|
|
$this->initVar('rate_rating', XOBJ_DTYPE_INT, 0, true); |
51
|
|
|
$this->initVar('rate_time', XOBJ_DTYPE_INT, 0, true); |
52
|
|
|
} |
53
|
|
|
} |
54
|
|
|
endif; |
55
|
|
|
|
56
|
|
|
PlanetUtility::planetParseClass(' |
57
|
|
|
class [CLASS_PREFIX]RateHandler extends XoopsPersistableObjectHandler |
58
|
|
|
{ |
59
|
|
|
/** |
60
|
|
|
* Constructor |
61
|
|
|
* |
62
|
|
|
* @param object $db reference to the {@link XoopsDatabase} object |
63
|
|
|
**/ |
64
|
|
|
public function __construct(\XoopsDatabase $db) { |
65
|
|
|
parent::__construct($db, planet_DB_prefix("rate", true), "Brate", "rate_id"); |
66
|
|
|
} |
67
|
|
|
|
68
|
|
|
public function &getByArticle($art_id, $criteria = null) |
69
|
|
|
{ |
70
|
|
|
if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) { |
71
|
|
|
$criteria->add(new \Criteria("art_id", (int)($art_id)), "AND"); |
72
|
|
|
} else { |
73
|
|
|
$criteria = new \CriteriaCompo(new \Criteria("art_id", (int)($art_id))); |
74
|
|
|
} |
75
|
|
|
$ret = $this->getAll($criteria); |
76
|
|
|
|
77
|
|
|
return $ret; |
78
|
|
|
} |
79
|
|
|
|
80
|
|
|
public function &getRatingByArticle($art_id, $criteria = null) |
81
|
|
|
{ |
82
|
|
|
if (isset($criteria) && is_subclass_of($criteria, "criteriaelement")) { |
83
|
|
|
$criteria->add(new \Criteria("art_id", (int)($art_id)), "AND"); |
84
|
|
|
} else { |
85
|
|
|
$criteria = new \CriteriaCompo(new \Criteria("art_id", (int)($art_id))); |
86
|
|
|
} |
87
|
|
|
$sql = "SELECT COUNT(*) AS rates, SUM(rate_rating) AS rating FROM " . planet_DB_prefix("rate"); |
88
|
|
|
$sql .= " ".$criteria->renderWhere(); |
89
|
|
|
if ($criteria->getSort() != "") { |
90
|
|
|
$sql .= " ORDER BY ".$criteria->getSort()." ".$criteria->getOrder(); |
91
|
|
|
} |
92
|
|
|
$limit = $criteria->getLimit(); |
93
|
|
|
$start = $criteria->getStart(); |
94
|
|
|
$result = $this->db->query($sql, $limit, $start); |
95
|
|
|
$myrow = $this->db->fetchArray($result); |
96
|
|
|
$ret = array("rates"=>$myrow["rates"], "rating"=>$myrow["rating"]); |
97
|
|
|
|
98
|
|
|
return $ret; |
99
|
|
|
} |
100
|
|
|
} |
101
|
|
|
'); |
102
|
|
|
|