1: <?php
  2: /*
  3:  You may not change or alter any portion of this comment or credits
  4:  of supporting developers from this source code or any supporting source code
  5:  which is considered copyrighted (c) material of the original comment or credit authors.
  6: 
  7:  This program is distributed in the hope that it will be useful,
  8:  but WITHOUT ANY WARRANTY; without even the implied warranty of
  9:  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 10: */
 11: 
 12: /**
 13:  * @copyright       XOOPS Project (http://xoops.org)
 14:  * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
 15:  * @package         Comments
 16:  * @author          trabis <lusopoemas@gmail.com>
 17:  * @author          Kazumi Ono (AKA onokazu) http://www.myweb.ne.jp/, http://jp.xoops.org/
 18:  * @version         $Id$
 19:  */
 20: 
 21: use Xoops\Core\Database\Connection;
 22: use Xoops\Core\Kernel\XoopsObject;
 23: use Xoops\Core\Kernel\XoopsPersistableObjectHandler;
 24: 
 25: /**
 26:  * A Comment
 27:  *
 28:  * @author        Kazumi Ono    <onokazu@xoops.org>
 29:  * @copyright    copyright (c) 2000-2003 XOOPS.org
 30:  */
 31: class CommentsComment extends XoopsObject
 32: {
 33: 
 34:     /**
 35:      * Constructor
 36:      **/
 37:     public function __construct()
 38:     {
 39:         $this->initVar('id', XOBJ_DTYPE_INT, 0, false);
 40:         $this->initVar('pid', XOBJ_DTYPE_INT, 0, false);
 41:         $this->initVar('modid', XOBJ_DTYPE_INT, null, false);
 42:         $this->initVar('icon', XOBJ_DTYPE_OTHER, '', false);
 43:         $this->initVar('title', XOBJ_DTYPE_TXTBOX, null, true, 255, true);
 44:         $this->initVar('text', XOBJ_DTYPE_TXTAREA, '', true, null, true);
 45:         $this->initVar('created', XOBJ_DTYPE_INT, 0, false);
 46:         $this->initVar('modified', XOBJ_DTYPE_INT, 0, false);
 47:         $this->initVar('uid', XOBJ_DTYPE_INT, 0, true);
 48:         $this->initVar('ip', XOBJ_DTYPE_OTHER, null, false);
 49:         $this->initVar('sig', XOBJ_DTYPE_INT, 0, false);
 50:         $this->initVar('itemid', XOBJ_DTYPE_INT, 0, false);
 51:         $this->initVar('rootid', XOBJ_DTYPE_INT, 0, false);
 52:         $this->initVar('status', XOBJ_DTYPE_INT, 0, false);
 53:         $this->initVar('exparams', XOBJ_DTYPE_OTHER, null, false, 255);
 54:         $this->initVar('dohtml', XOBJ_DTYPE_INT, 0, false);
 55:         $this->initVar('dosmiley', XOBJ_DTYPE_INT, 1, false);
 56:         $this->initVar('doxcode', XOBJ_DTYPE_INT, 1, false);
 57:         $this->initVar('doimage', XOBJ_DTYPE_INT, 1, false);
 58:         $this->initVar('dobr', XOBJ_DTYPE_INT, 1, false);
 59:     }
 60: 
 61:     /**
 62:      * @return bool
 63:      */
 64:     public function isRoot()
 65:     {
 66:         return ($this->getVar('id') == $this->getVar('rootid'));
 67:     }
 68: }
 69: 
 70: /**
 71:  * Comment handler class.
 72:  *
 73:  * @author        Kazumi Ono    <onokazu@xoops.org>
 74:  * @copyright    copyright (c) 2000-2003 XOOPS.org
 75:  */
 76: class CommentsCommentHandler extends XoopsPersistableObjectHandler
 77: {
 78:     /**
 79:      * Constructor
 80:      *
 81:      * @param Connection|null $db {@link Connection}
 82:      */
 83:     public function __construct(Connection $db = null)
 84:     {
 85:         parent::__construct($db, 'comments', 'CommentsComment', 'id', 'title');
 86:     }
 87: 
 88:     /**
 89:      * Retrieves comments for an item
 90:      *
 91:      * @param   int     $module_id  Module ID
 92:      * @param   int     $item_id    Item ID
 93:      * @param   string  $order      Sort order
 94:      * @param   int     $status     Status of the comment
 95:      * @param   int     $limit      Max num of comments to retrieve
 96:      * @param   int     $start      Start offset
 97:      *
 98:      * @return  array   Array of {@link CommentsComment} objects
 99:      **/
100:     public function getByItemId($module_id, $item_id, $order = null, $status = null, $limit = null, $start = 0)
101:     {
102:         $criteria = new CriteriaCompo(new Criteria('modid', (int)($module_id)));
103:         $criteria->add(new Criteria('itemid', (int)($item_id)));
104:         if (isset($status)) {
105:             $criteria->add(new Criteria('status', (int)($status)));
106:         }
107:         if (isset($order)) {
108:             $criteria->setOrder($order);
109:         }
110:         if (isset($limit)) {
111:             $criteria->setLimit($limit);
112:             $criteria->setStart($start);
113:         }
114:         return $this->getObjects($criteria);
115:     }
116: 
117:     /**
118:      * Gets total number of comments for an item
119:      *
120:      * @param   int     $module_id  Module ID
121:      * @param   int     $item_id    Item ID
122:      * @param   int     $status     Status of the comment
123:      *
124:      * @return  integer   Array of {@link CommentsComment} objects
125:      **/
126:     public function getCountByItemId($module_id, $item_id, $status = null)
127:     {
128:         $criteria = new CriteriaCompo(new Criteria('modid', (int)($module_id)));
129:         $criteria->add(new Criteria('itemid', (int)($item_id)));
130:         if (isset($status)) {
131:             $criteria->add(new Criteria('status', (int)($status)));
132:         }
133:         return $this->getCount($criteria);
134:     }
135: 
136:     /**
137:      * @param int $module_id
138:      * @param int|null $item_id
139:      * @return int
140:      */
141:     public function getCountByModuleId($module_id, $item_id = null)
142:     {
143:         $criteria = new CriteriaCompo(new Criteria('modid', (int)($module_id)));
144:         if (isset($item_id)) {
145:             $criteria->add(new Criteria('itemid', (int)($item_id)));
146:         }
147:         return $this->getCount($criteria);
148:     }
149: 
150:     /**
151:      * Get the top {@link CommentsComment}s
152:      *
153:      * @param   int     $module_id
154:      * @param   int     $item_id
155:      * @param   string  $order
156:      * @param   int     $status
157:      *
158:      * @return  array   Array of {@link CommentsComment} objects
159:      **/
160:     public function getTopComments($module_id, $item_id, $order, $status = null)
161:     {
162:         $criteria = new CriteriaCompo(new Criteria('modid', (int)($module_id)));
163:         $criteria->add(new Criteria('itemid', (int)($item_id)));
164:         $criteria->add(new Criteria('pid', 0));
165:         if (isset($status)) {
166:             $criteria->add(new Criteria('status', (int)($status)));
167:         }
168:         $criteria->setOrder($order);
169:         return $this->getObjects($criteria);
170:     }
171: 
172:     /**
173:      * Retrieve a whole thread
174:      *
175:      * @param   int     $comment_rootid
176:      * @param   int     $comment_id
177:      * @param   int     $status
178:      *
179:      * @return  array   Array of {@link CommentsComment} objects
180:      **/
181:     public function getThread($comment_rootid, $comment_id, $status = null)
182:     {
183:         $criteria = new CriteriaCompo(new Criteria('rootid', (int)($comment_rootid)));
184:         $criteria->add(new Criteria('id', (int)($comment_id), '>='));
185:         if (isset($status)) {
186:             $criteria->add(new Criteria('status', (int)($status)));
187:         }
188:         return $this->getObjects($criteria);
189:     }
190: 
191:     /**
192:      * Update
193:      *
194:      * @param   CommentsComment  $comment       {@link CommentsComment} object
195:      * @param   string  $field_name     Name of the field
196:      * @param   mixed   $field_value    Value to write
197:      *
198:      * @return  bool
199:      **/
200:     public function updateByField(CommentsComment $comment, $field_name, $field_value)
201:     {
202:         $comment->unsetNew();
203:         $comment->setVar($field_name, $field_value);
204:         return $this->insert($comment);
205:     }
206: 
207:     /**
208:      * Delete all comments for one whole module
209:      *
210:      * @param   int $module_id  ID of the module
211:      * @return  bool
212:      **/
213:     public function deleteByModule($module_id)
214:     {
215:         return $this->deleteAll(new Criteria('modid', (int)($module_id)));
216:     }
217: 
218:     /**
219:      * @param int $module_id
220:      * @param int $item_id
221:      * @return bool
222:      */
223:     function deleteByItemId($module_id, $item_id)
224:     {
225:         $module_id = (int)($module_id);
226:         $item_id = (int)($item_id);
227:         if ($module_id > 0 && $item_id > 0) {
228:             $comments = $this->getByItemId($module_id, $item_id);
229:             if (is_array($comments)) {
230:                 $count = count($comments);
231:                 $deleted_num = array();
232:                 for ($i = 0; $i < $count; ++$i) {
233:                     if (false != $this->delete($comments[$i])) {
234:                         // store poster ID and deleted post number into array for later use
235:                         $poster_id = $comments[$i]->getVar('uid');
236:                         if ($poster_id != 0) {
237:                             $deleted_num[$poster_id] = !isset($deleted_num[$poster_id]) ? 1
238:                                 : ($deleted_num[$poster_id] + 1);
239:                         }
240:                     }
241:                 }
242: 
243:                 $member_handler = Xoops::getInstance()->getHandlerMember();
244:                 foreach ($deleted_num as $user_id => $post_num) {
245:                     // update user posts
246:                     /* @var $member_handler XoopsMemberHandler */
247:                     $poster = $member_handler->getUser($user_id);
248:                     if (is_object($poster)) {
249:                         $member_handler->updateUserByField($poster, 'posts', $poster->getVar('posts') - $post_num);
250:                     }
251:                 }
252:                 return true;
253:             }
254:         }
255:         return false;
256:     }
257: }
258: