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: use Xoops\Core\Database\Connection;
 13: use Xoops\Core\Kernel\Criteria;
 14: use Xoops\Core\Kernel\CriteriaCompo;
 15: use Xoops\Core\Kernel\CriteriaElement;
 16: use Xoops\Core\Kernel\XoopsObject;
 17: use Xoops\Core\Kernel\XoopsPersistableObjectHandler;
 18: 
 19: /**
 20:  * @copyright       XOOPS Project (http://xoops.org)
 21:  * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
 22:  * @package         Avatars
 23:  * @author          Kazumi Ono (AKA onokazu) http://www.myweb.ne.jp/, http://jp.xoops.org/
 24:  * @version         $Id$
 25:  */
 26: 
 27: /**
 28:  * A Avatar
 29:  *
 30:  * @author Kazumi Ono <onokazu@xoops.org>
 31:  * @copyright copyright (c) 2000 XOOPS.org
 32:  *
 33:  * @package kernel
 34:  */
 35: class AvatarsAvatar extends XoopsObject
 36: {
 37:     /**
 38:      * @var int
 39:      */
 40:     private $userCount;
 41: 
 42:     /**
 43:      * Constructor
 44:      */
 45:     public function __construct()
 46:     {
 47:         $this->initVar('avatar_id', XOBJ_DTYPE_INT, null, false);
 48:         $this->initVar('avatar_file', XOBJ_DTYPE_OTHER, null, false, 30);
 49:         $this->initVar('avatar_name', XOBJ_DTYPE_TXTBOX, null, true, 100);
 50:         $this->initVar('avatar_mimetype', XOBJ_DTYPE_OTHER, null, false);
 51:         $this->initVar('avatar_created', XOBJ_DTYPE_INT, null, false);
 52:         $this->initVar('avatar_display', XOBJ_DTYPE_INT, 1, false);
 53:         $this->initVar('avatar_weight', XOBJ_DTYPE_INT, 0, false);
 54:         $this->initVar('avatar_type', XOBJ_DTYPE_OTHER, 0, false);
 55:     }
 56: 
 57:     /**
 58:      * get avatar_id
 59:      *
 60:      * @param string $format return format code
 61:      *
 62:      * @return mixed
 63:      */
 64:     public function id($format = 'n')
 65:     {
 66:         return $this->getVar('avatar_id', $format);
 67:     }
 68: 
 69:     /**
 70:      * get avatar_id
 71:      *
 72:      * @param string $format return format code
 73:      *
 74:      * @return mixed
 75:      */
 76:     public function avatar_id($format = '')
 77:     {
 78:         return $this->getVar('avatar_id', $format);
 79:     }
 80: 
 81:     /**
 82:      * get avatar_file
 83:      *
 84:      * @param string $format return format code
 85:      *
 86:      * @return mixed
 87:      */
 88:     public function avatar_file($format = '')
 89:     {
 90:         return $this->getVar('avatar_file', $format);
 91:     }
 92: 
 93:     /**
 94:      * get avatar_name
 95:      *
 96:      * @param string $format return format code
 97:      *
 98:      * @return mixed
 99:      */
100:     public function avatar_name($format = '')
101:     {
102:         return $this->getVar('avatar_name', $format);
103:     }
104: 
105:     /**
106:      * get avatar_mimetype
107:      *
108:      * @param string $format return format code
109:      *
110:      * @return mixed
111:      */
112:     public function avatar_mimetype($format = '')
113:     {
114:         return $this->getVar('avatar_mimetype', $format);
115:     }
116: 
117:     /**
118:      * get avatar_created
119:      *
120:      * @param string $format return format code
121:      *
122:      * @return mixed
123:      */
124:     public function avatar_created($format = '')
125:     {
126:         return $this->getVar('avatar_created', $format);
127:     }
128: 
129:     /**
130:      * get avatar_display
131:      *
132:      * @param string $format return format code
133:      *
134:      * @return mixed
135:      */
136:     public function avatar_display($format = '')
137:     {
138:         return $this->getVar('avatar_display', $format);
139:     }
140: 
141:     /**
142:      * get avatar_weight
143:      *
144:      * @param string $format return format code
145:      *
146:      * @return mixed
147:      */
148:     public function avatar_weight($format = '')
149:     {
150:         return $this->getVar('avatar_weight', $format);
151:     }
152: 
153:     /**
154:      * get avatar_type
155:      *
156:      * @param string $format return format code
157:      *
158:      * @return mixed
159:      */
160:     public function avatar_type($format = '')
161:     {
162:         return $this->getVar('avatar_type', $format);
163:     }
164: 
165:     /**
166:      * Set User Count
167:      *
168:      * @param int $value user count
169:      *
170:      * @return void
171:      */
172:     public function setUserCount($value)
173:     {
174:         $this->userCount = (int)($value);
175:     }
176: 
177:     /**
178:      * Get User Count
179:      *
180:      * @return int
181:      */
182:     public function getUserCount()
183:     {
184:         return $this->userCount;
185:     }
186: }
187: 
188: /**
189:  * @author  Kazumi Ono <onokazu@xoops.org>
190:  * @copyright copyright (c) 2000 XOOPS.org
191:  * @package kernel
192:  */
193: class AvatarsAvatarHandler extends XoopsPersistableObjectHandler
194: {
195:     /**
196:      * Constructor
197:      *
198:      * @param Connection|null $db {@link Connection}
199:      */
200:     public function __construct(Connection $db = null)
201:     {
202:         parent::__construct($db, 'avatars_avatar', 'AvatarsAvatar', 'avatar_id', 'avatar_name');
203:     }
204: 
205:     /**
206:      * Fetch a row of objects from the database
207:      *
208:      * @param null|CriteriaElement $criteria  criteria object
209:      * @param bool                 $id_as_key if true, use avatar_id as array key
210:      *
211:      * @return array
212:      */
213:     public function getObjectsWithCount(CriteriaElement $criteria = null, $id_as_key = false)
214:     {
215:         $ret = array();
216:         if ($criteria === null) {
217:             $criteria = new Criteria('');
218:         }
219:         $criteria->setGroupby('a.avatar_id');
220:         $criteria->setSort('avatar_weight, avatar_id');
221:         $qb = $this->db2->createXoopsQueryBuilder();
222:         $qb ->select('a.*', 'COUNT(u.user_id) AS count')
223:             ->fromPrefix('avatars_avatar', 'a')
224:             ->leftJoinPrefix('l', 'avatars_user_link', 'u', 'u.avatar_id=a.avatar_id');
225:         $criteria->renderQb($qb);
226:         $result = $qb->execute();
227:         if (!$result) {
228:             return $ret;
229:         }
230:         while ($myrow = $result->fetch(\PDO::FETCH_ASSOC)) {
231:             $avatar = new AvatarsAvatar();
232:             $avatar->assignVars($myrow);
233:             $avatar->setUserCount($myrow['count']);
234:             if (!$id_as_key) {
235:                 $ret[] = $avatar;
236:             } else {
237:                 $ret[$myrow['avatar_id']] = $avatar;
238:             }
239:             unset($avatar);
240:         }
241:         return $ret;
242:     }
243: 
244:     /**
245:      * Add user to avatars_user_link
246:      *
247:      * @param int $avatar_id avatar id
248:      * @param int $user_id   user id
249:      *
250:      * @return bool
251:      */
252:     public function addUser($avatar_id, $user_id)
253:     {
254:         $avatar_id = (int)($avatar_id);
255:         $user_id = (int)($user_id);
256:         if ($avatar_id < 1 || $user_id < 1) {
257:             return false;
258:         }
259: 
260:         $qb = $this->db2->createXoopsQueryBuilder();
261:         $qb ->deletePrefix('avatars_user_link', 'l')
262:             ->where('l.user_id = :uid')
263:             ->setParameter(':uid', $user_id, \PDO::PARAM_INT);
264:         $result = $qb->execute();
265:         if ($result) {
266:             return false;
267:         }
268: 
269:         $qb = $this->db2->createXoopsQueryBuilder();
270:         $qb ->insertPrefix('avatars_user_link')
271:             ->values(
272:                 array(
273:                     'avatar_id' => ':aid',
274:                     'user_id' => ':uid'
275:                 )
276:             )
277:             ->setParameter(':aid', $avatar_id, \PDO::PARAM_INT)
278:             ->setParameter(':uid', $user_id, \PDO::PARAM_INT);
279:         $result = $qb->execute();
280:         if ($result) {
281:             return false;
282:         }
283: 
284:         return true;
285:     }
286: 
287:     /**
288:      * getUser - get avatars_user_link for an avatar
289:      *
290:      * @param AvatarsAvatar $avatar avatar object
291:      *
292:      * @return array
293:      */
294:     public function getUser(AvatarsAvatar $avatar)
295:     {
296:         $ret = array();
297:         $qb = $this->db2->createXoopsQueryBuilder();
298:         $qb ->select('user_id')
299:             ->fromPrefix('avatars_user_link', 'l')
300:             ->where('l.avatar_id = :bid')
301:             ->setParameter(':bid', $avatar->getVar('avatar_id'), \PDO::PARAM_INT);
302:         $result = $qb->execute();
303:         if (!$result) {
304:             return $ret;
305:         }
306:         while ($myrow = $result->fetch(\PDO::FETCH_ASSOC)) {
307:             $ret[] = $myrow['user_id'];
308:         }
309:         return $ret;
310:     }
311: 
312:     /**
313:      * Get a list of Avatars
314:      *
315:      * @param string $avatar_type    'C' for custom, 'S' for system
316:      * @param bool   $avatar_display display avatar
317:      *
318:      * @return array
319:      */
320:     public function getListByType($avatar_type = null, $avatar_display = null)
321:     {
322:         $criteria = new CriteriaCompo();
323:         if (isset($avatar_type)) {
324:             $avatar_type = ($avatar_type === 'C') ? 'C' : 'S';
325:             $criteria->add(new Criteria('avatar_type', $avatar_type));
326:         }
327:         if (isset($avatar_display)) {
328:             $criteria->add(new Criteria('avatar_display', (int)($avatar_display)));
329:         }
330:         $avatars = $this->getObjects($criteria, true);
331:         $ret = array(
332:             'avatars/blank.gif' => XoopsLocale::NONE
333:         );
334:         foreach (array_keys($avatars) as $i) {
335:             $ret[$avatars[$i]->getVar('avatar_file')] = $avatars[$i]->getVar('avatar_name');
336:         }
337:         return $ret;
338:     }
339: }
340: