File odules/profile/class/visibility.php

Namespaces

None
Xmf
- Database
- Module
  - Helper
- Template
Xoops
- Auth
- Core
  - Cache
  - Database
    - Logging
    - Schema
  - Exception
  - Handler
    - Scheme
  - Kernel
    - Dtype
    - Handlers
    - Model
  - Lists
  - Locale
    - Punic
  - Service
    - Contract
  - Session
  - Text
    - Sanitizer
      - Extensions
  - Theme
    - Plugins
- Form
- Html
- Locale
- Module
  - Helper
  - Plugin

Classes

Interfaces

Exceptions

Functions

 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\XoopsObject;
14: use Xoops\Core\Kernel\XoopsPersistableObjectHandler;
15: 
16: /**
17:  * Extended User Profile
18:  *
19:  * @copyright       XOOPS Project (http://xoops.org)
20:  * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
21:  * @package         profile
22:  * @since           2.3.0
23:  * @author          Jan Pedersen
24:  * @author          Taiwen Jiang <phppp@users.sourceforge.net>
25:  * @version         $Id$
26:  */
27: 
28: class ProfileVisibility extends XoopsObject
29: {
30:     /**
31:      * Constructor
32:      */
33:     public function __construct()
34:     {
35:         $this->initVar('field_id', XOBJ_DTYPE_INT);
36:         $this->initVar('user_group', XOBJ_DTYPE_INT);
37:         $this->initVar('profile_group', XOBJ_DTYPE_INT);
38:     }
39: }
40: 
41: class ProfileVisibilityHandler extends XoopsPersistableObjectHandler
42: {
43:     /**
44:      * @param null|Connection $db database
45:      */
46:     public function __construct(Connection $db = null)
47:     {
48:         parent::__construct($db, 'profile_visibility', 'profilevisibility', 'field_id');
49:     }
50: 
51:     /**
52:      * Get fields visible to the $user_groups on a $profile_groups profile
53:      *
54:      * @param array $profile_groups groups of the user to be accessed
55:      * @param array $user_groups    groups of the visitor, default as $xoops->user
56:      *
57:      * @return array
58:      */
59:     public function getVisibleFields($profile_groups, $user_groups = null)
60:     {
61:         $profile_groups[] = 0;
62:         array_walk($profile_groups, 'intval');
63:         $user_groups[] = 0;
64:         array_walk($user_groups, 'intval');
65: 
66:         $qb = $this->db2->createXoopsQueryBuilder();
67:         $eb = $qb->expr();
68:         $sql = $qb->select('t1.field_id')
69:             ->from($this->table, 't1')
70:             ->where($eb->in('t1.profile_group', $profile_groups))
71:             ->andWhere($eb->in('t1.user_group', $user_groups));
72: 
73:         $result = $sql->execute();
74:         $field_ids = array();
75:         while (list($field_id) = $result->fetch(PDO::FETCH_NUM)) {
76:             $field_ids[] = $field_ids;
77:         }
78: 
79:         return $field_ids;
80:     }
81: }
82: