Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
.htaccess	237 B	-r-xr-xr-x	2026-08-17 03:12
CCEStudentRepository.php	2.4 KB	-rwxrwxr-x	2026-05-26 09:32
UserBankDetailRepository.php	256 B	-rwxrwxr-x	2026-04-02 12:06
UserContactRepository.php	1.26 KB	-rwxrwxr-x	2026-04-02 12:06
UserFieldRepository.php	2.7 KB	-rwxrwxr-x	2026-04-02 12:06
UserFieldUserRepository.php	254 B	-rwxrwxr-x	2026-04-02 12:06
UserGroupRepository.php	3.57 KB	-rwxrwxr-x	2026-04-02 12:06
UserLevelRepository.php	1.44 KB	-rwxrwxr-x	2026-04-02 12:06
UserListRepository.php	13.17 KB	-rwxrwxr-x	2026-04-02 12:06
UserLoginRepository.php	442 B	-rwxrwxr-x	2026-05-20 09:05
UserNetworkRepository.php	250 B	-rwxrwxr-x	2026-04-02 12:06
UserOldRepository.php	1.57 KB	-rwxrwxr-x	2026-05-18 12:51
UserTypesRepository.php	267 B	-rwxrwxr-x	2026-04-02 12:06
php_errors.log	3.6 KB	-rwxrwxr-x	2026-04-02 12:06

Rename

<?php

namespace App\UserBundle\Repository;

use App\UserBundle\Entity\UserList;

/**
 * UserFieldRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class UserFieldRepository extends \Doctrine\ORM\EntityRepository {

/**
     * Get the user field list query
     *
     * @param array $conf
     * @return Object
     */
    public function getSiteListQuery($conf = array()) {

$qb = $this->createQueryBuilder('ug')
                ->where('1 = 1');

if (isset($conf['user_list']) && is_object($conf['user_list'])) {
            $conf['company_id'] = $conf['user_list']->getCompanyId();
        }

if (!isset($conf['user_type_id'])) {
            $conf['user_type_id'] = '';
        }

if (isset($conf['company_id']) && strlen($conf['company_id']) > 0) {

$users = $this->getEntityManager()->getRepository(UserList::class)->findBySearchCompany('', $conf['company_id'], array('user_type_id' => $conf['user_type_id']));
            $userIDArray = array();

foreach ($users as $user) {
//                echo $user->getId() . '<br />';
                $userIDArray[] = $user->getId();
            }

$qb = $qb->andWhere('ug.created_by IN (:userIDs)')->setParameter('userIDs', $userIDArray);
        }

if ((isset($conf['mobile']) && $conf['mobile']) || (isset($conf['e_mail']) && $conf['e_mail'])) {
            $qb->join('ug.user_list', 'ul');
        }

if (isset($conf['mobile']) && $conf['mobile']) {
            $qb->join('ul.user_tel_no_mobile', 'ulm')
                    ->andWhere('ulm.tel_fax_number <> :telNum')->setParameter('telNum', '');
        } elseif (isset($conf['e_mail']) && $conf['e_mail']) {
            $qb->join('ul.user_e_mail_address', 'uem')
                    ->andWhere('uem.e_mail_address <> :eMail')->setParameter('eMail', '');
        }

if (isset($conf['include_ids']) && is_array($conf['include_ids']) && count($conf['include_ids']) > 0) {
            $qb->orWhere('ug.id IN (:includeIds)')->setParameter('includeIds', $conf['include_ids']);
        }

if (isset($conf['search_text']) && strlen($conf['search_text']) > 0) {
            $qb = $qb->andWhere('ug.field_name LIKE :searchText')->setParameter('searchText', '%' . $conf['search_text'] . '%');
        }

$qb->orderBy('ug.field_name', 'ASC');

if (isset($conf['return_qb']) && $conf['return_qb']) {
            return $qb;
        }

return $qb->getQuery();
    }

/**
     * Get the user fields
     *
     * @param array $conf
     * @return array
     */
    public function findForSelect($conf = array()) {
        return $this->getSiteListQuery($conf)->execute();
    }

}