1. class
  2. Alligator
  3. \
  4. Business
  5. \
  6. Database
  7. \
  8. User
  9. \
  10. UserRepository

UserRepository

class UserRepository extends EntityRepository implements UserProviderInterface, UserLoaderInterface

Class UserRepository is injected as alligator.user_repository service. UserRepository is used for crud operation for managed entity.

Use this class to work with database.

Traits

JQGridTrait
Trait JQGridTrait

Constants

ALIAS

Alias for entity
ADDRESS_ALIAS

Alias for address entity
ORDER_ALIAS

Alias for order entity
GROUP_ALIAS

Alias for group entity
PRODUCT_ALIAS

Alias for product entity
WISHLIST_ALIAS

Alias for wishlist entity
COMPANY_ALIAS

Alias for company entity
JOIN_WITH_ADDRESS

JOIN_WITH_COMPANY

JOIN_WITH_ORDERS

JOIN_WITH_GROUP

ROLE_ADMIN

Methods

jQGridJoinFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

All joins used in select.

from JQGridTrait
jQGridGroupByFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

Should contain group by which jqgrid uses.

from JQGridTrait
array
findAllForJQGRID(int $page, int $offset, array $sortParams, array $additionalParams, JQGridWrapper $jqGridWrapper)

JQGrid function

from JQGridTrait
array
searchForJQGRID(array $searchParams, array $sortParams, bool $isCountSearch = false, array $additionalParams = array(), JQGridWrapper $jqGridWrapper = null)

JQGrid function

from JQGridTrait
findOneBy(array $criteria, array $orderBy = null)

Utility override to be used by the UserManager

User
edit(User $entity)

Update existing user

User
getUserById(int $userId)

Find user by id

loadUserByUsername($username)

{@inheritDoc}

refreshUser(UserInterface $user)

{@inheritDoc}

supportsClass($class)

{@inheritDoc}

User|null|object
getUserByToken(string $token)

Find user by token

array
getAllUsers()

Finds all users in the database.

array
getUsersIdsAndCustomFiled(string $filed)

Find id and provided field for all users

array
findAllUsersWithSelect()

Find all users as array

int|User
saveUser(User $user)

Persist new user

EntityManagerInterface
getEm()

No description

bool|string
saveMultiple(array $users, int $flushNumber = 30)

Persist multiple users

array
getMailFromDb(int $id)

Find email for user that match provided id

Address
editUserAddress(Address $address, int $id)

Edit address for user

User
editUser(User $user)

No description

User
editUserByAdmin(User $user)

Update existing user

User
getUserByPK(int $id)

No description

User|bool
addToWishList(User $user, Product $product)

Add new product to user's wishlist

User|bool
removeFromWishList(User $user, Product $product)

Remove product from user's wishlist

mixed
getCountForJQGRIDCustom(array|null $searchParams, array|null $sortParams, true $isCountSearch, array|null $additionalParams, JQGridWrapper|null $jqGridWrapper)

This is custom count query because we need to count number of orders and self::ALIAS.id(more then 1 aggregate function) This is only used here, every other query should just count self::ALIAS.id

array
findAllForWishlistUserJQGRID(mixed $page, mixed $offset, array $sortParams = array(), array $additionalParams = array())

JQGrid function

array
searchForWishlistUserJQGRID(mixed $searchParams, bool $isCountSearch = false, array $sortParams = array(), array $additionalParams = array())

JQGrid function

array
getUsersByGroup(string $groupName = 'ADMIN')

Find all users by group

array
getAllEmails(mixed $param, mixed $page, mixed $offset, mixed $arrayOfUsers = null, bool $admin = false, bool $locked = true)

Find all users that match provided criteria

array
getAllUsersWithAdditionalInfo(mixed $param, mixed $page, mixed $offset, mixed $arrayOfUsers = null, bool $admin = false)

Find all users that match provided criteria

array
getAllAdminsEmails()

Get all admin users

array
getUsersForDashboard(int $number)

Find provided number of users for dashboard

array
getSocialNetworksLinks(int $userId)

Find social network links for provided user

array
getAllUsersInArray(array $arrayOfUsers)

Find all users that match provided ids

array
getLoggedUserAddress(int $userId)

Find user by id

array
getUsersWithProductInWishList(int $productId)

Find all users that have provided product in wishlist

User|Proxy|object|null
getUserReference(int $id)

No description

array
getAllUsersShippingAddresses()

Find all user's shipping address

User|Proxy|null|object
getReference(string $className, int $id)

No description

array
getUsersArray(array $userIds)

Find all users that match provided ids

array
findUserForEdit(User $user)

Get user from db for user edit

array
getUsersByStringParam(int $page = 1, int $offset = 10, array $param = null)

Find all users with pagination

array
findUsersByMails(array $mails)

Find users by mails

array
getUserInfoForOrder(int $id)

Find user by id

User|null
getNumberOfOrdersForUser(int $userId, string $orderState)

Get number of orders for user

array
getAllEmailsForArrayOfIds(array $ids = null)

Get all emails for array of ids

array
getUserIdErpCodes()

Find id and erp code of all users

array
getUserIdErpCodeAddresses()

Find id, erp code, and id of all user address

bool|string
updateAccountBalance(array $data)

Update account balance

array
getBaseUserDataInArray()

Find all users as array

bool
checkUserSecondaryCode(string $code)

Check if user for provided code exist

bool|string
reCacheUserPricelistItemsArray()

Re-caching user specific pricelist

bool|string
reCacheUserGroupDiscountsArray(array $ids = [])

Re-caching user group discounts

Details

in JQGridTrait at line 27
jQGridJoinFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

All joins used in select.

Override in the repository class if needed. Should do nothing otherwise

Parameters

QueryBuilder $qb
JQGridWrapper $jqGridWrapper

in JQGridTrait at line 42
jQGridGroupByFields(QueryBuilder $qb, JQGridWrapper $jqGridWrapper)

Should contain group by which jqgrid uses.

Override in the repository class if needed. Should do nothing otherwise

Parameters

QueryBuilder $qb
JQGridWrapper $jqGridWrapper

in JQGridTrait at line 61
array findAllForJQGRID(int $page, int $offset, array $sortParams, array $additionalParams, JQGridWrapper $jqGridWrapper)

JQGrid function

Parameters

int $page
int $offset
array $sortParams
array $additionalParams
JQGridWrapper $jqGridWrapper

Return Value

array

in JQGridTrait at line 94
array searchForJQGRID(array $searchParams, array $sortParams, bool $isCountSearch = false, array $additionalParams = array(), JQGridWrapper $jqGridWrapper = null)

JQGrid function

Parameters

array $searchParams
array $sortParams
bool $isCountSearch
array $additionalParams
JQGridWrapper $jqGridWrapper

Return Value

array

at line 88
findOneBy(array $criteria, array $orderBy = null)

Utility override to be used by the UserManager

{@inheritDoc}

Parameters

array $criteria
array $orderBy

at line 113
User edit(User $entity)

Update existing user

Parameters

User $entity

Return Value

User

at line 134
User getUserById(int $userId)

Find user by id

Parameters

int $userId

Return Value

User

Exceptions

NoResultException
NonUniqueResultException

at line 150
loadUserByUsername($username)

{@inheritDoc}

Parameters

$username

Exceptions

NonUniqueResultException

at line 174
refreshUser(UserInterface $user)

{@inheritDoc}

Parameters

UserInterface $user

at line 198
supportsClass($class)

{@inheritDoc}

Parameters

$class

at line 209
User|null|object getUserByToken(string $token)

Find user by token

Parameters

string $token

Return Value

User|null|object

at line 219
array getAllUsers()

Finds all users in the database.

Return Value

array

at line 230
array getUsersIdsAndCustomFiled(string $filed)

Find id and provided field for all users

Parameters

string $filed

Return Value

array

at line 243
array findAllUsersWithSelect()

Find all users as array

Return Value

array

at line 260
int|User saveUser(User $user)

Persist new user

Parameters

User $user

Return Value

int|User If DBALException is thrown than returns 0, but if PDOException is thrown than 1 returned. Otherwise, the user instance is returned

Exceptions

ORMException
OptimisticLockException

at line 277
EntityManagerInterface getEm()

Return Value

EntityManagerInterface

at line 289
bool|string saveMultiple(array $users, int $flushNumber = 30)

Persist multiple users

Parameters

array $users
int $flushNumber

Return Value

bool|string

at line 318
array getMailFromDb(int $id)

Find email for user that match provided id

Parameters

int $id

Return Value

array

at line 339
Address editUserAddress(Address $address, int $id)

Edit address for user

Parameters

Address $address
int $id

Return Value

Address

Exceptions

ORMException
OptimisticLockException

at line 361
User editUser(User $user)

Parameters

User $user

Return Value

User

Exceptions

ORMException
OptimisticLockException

at line 380
User editUserByAdmin(User $user)

Update existing user

Parameters

User $user

Return Value

User

at line 399
User getUserByPK(int $id)

Parameters

int $id

Return Value

User

at line 415
User|bool addToWishList(User $user, Product $product)

Add new product to user's wishlist

Parameters

User $user
Product $product

Return Value

User|bool

Exceptions

ORMException
OptimisticLockException

at line 440
User|bool removeFromWishList(User $user, Product $product)

Remove product from user's wishlist

Parameters

User $user
Product $product

Return Value

User|bool

Exceptions

ORMException
OptimisticLockException

at line 466
mixed getCountForJQGRIDCustom(array|null $searchParams, array|null $sortParams, true $isCountSearch, array|null $additionalParams, JQGridWrapper|null $jqGridWrapper)

This is custom count query because we need to count number of orders and self::ALIAS.id(more then 1 aggregate function) This is only used here, every other query should just count self::ALIAS.id

Parameters

array|null $searchParams
array|null $sortParams
true $isCountSearch
array|null $additionalParams
JQGridWrapper|null $jqGridWrapper

Return Value

mixed

at line 536
array findAllForWishlistUserJQGRID(mixed $page, mixed $offset, array $sortParams = array(), array $additionalParams = array())

JQGrid function

Parameters

mixed $page
mixed $offset
array $sortParams
array $additionalParams

Return Value

array

at line 571
array searchForWishlistUserJQGRID(mixed $searchParams, bool $isCountSearch = false, array $sortParams = array(), array $additionalParams = array())

JQGrid function

Parameters

mixed $searchParams
bool $isCountSearch
array $sortParams
array $additionalParams

Return Value

array

at line 633
array getUsersByGroup(string $groupName = 'ADMIN')

Find all users by group

Parameters

string $groupName

Return Value

array

at line 655
array getAllEmails(mixed $param, mixed $page, mixed $offset, mixed $arrayOfUsers = null, bool $admin = false, bool $locked = true)

Find all users that match provided criteria

Parameters

mixed $param
mixed $page
mixed $offset
mixed $arrayOfUsers
bool $admin
bool $locked

Return Value

array

at line 707
array getAllUsersWithAdditionalInfo(mixed $param, mixed $page, mixed $offset, mixed $arrayOfUsers = null, bool $admin = false)

Find all users that match provided criteria

Parameters

mixed $param
mixed $page
mixed $offset
mixed $arrayOfUsers
bool $admin

Return Value

array

at line 760
array getAllAdminsEmails()

Get all admin users

Return Value

array

at line 778
array getUsersForDashboard(int $number)

Find provided number of users for dashboard

Parameters

int $number

Return Value

array

Find social network links for provided user

Parameters

int $userId

Return Value

array

Exceptions

NoResultException
NonUniqueResultException

at line 832
array getAllUsersInArray(array $arrayOfUsers)

Find all users that match provided ids

Parameters

array $arrayOfUsers

Return Value

array

at line 852
array getLoggedUserAddress(int $userId)

Find user by id

Parameters

int $userId

Return Value

array

Exceptions

NonUniqueResultException

at line 871
array getUsersWithProductInWishList(int $productId)

Find all users that have provided product in wishlist

Parameters

int $productId

Return Value

array

at line 887
User|Proxy|object|null getUserReference(int $id)

Parameters

int $id

Return Value

User|Proxy|object|null

at line 897
array getAllUsersShippingAddresses()

Find all user's shipping address

Return Value

array

at line 914
User|Proxy|null|object getReference(string $className, int $id)

Parameters

string $className
int $id

Return Value

User|Proxy|null|object

Exceptions

ORMException

at line 925
array getUsersArray(array $userIds)

Find all users that match provided ids

Parameters

array $userIds

Return Value

array

at line 942
array findUserForEdit(User $user)

Get user from db for user edit

Parameters

User $user

Return Value

array

at line 960
array getUsersByStringParam(int $page = 1, int $offset = 10, array $param = null)

Find all users with pagination

Parameters

int $page
int $offset
array $param

Return Value

array

at line 984
array findUsersByMails(array $mails)

Find users by mails

Parameters

array $mails

Return Value

array

at line 1007
array getUserInfoForOrder(int $id)

Find user by id

Parameters

int $id

Return Value

array

at line 1024
User|null getNumberOfOrdersForUser(int $userId, string $orderState)

Get number of orders for user

Parameters

int $userId
string $orderState

Return Value

User|null

Exceptions

NonUniqueResultException

at line 1043
array getAllEmailsForArrayOfIds(array $ids = null)

Get all emails for array of ids

Parameters

array $ids

Return Value

array

at line 1058
array getUserIdErpCodes()

Find id and erp code of all users

Return Value

array

at line 1071
array getUserIdErpCodeAddresses()

Find id, erp code, and id of all user address

Return Value

array

at line 1089
bool|string updateAccountBalance(array $data)

Update account balance

Parameters

array $data

Return Value

bool|string

at line 1127
array getBaseUserDataInArray()

Find all users as array

Return Value

array

at line 1142
bool checkUserSecondaryCode(string $code)

Check if user for provided code exist

Parameters

string $code

Return Value

bool

at line 1158
bool|string reCacheUserPricelistItemsArray()

Re-caching user specific pricelist

Return Value

bool|string

at line 1190
bool|string reCacheUserGroupDiscountsArray(array $ids = [])

Re-caching user group discounts

Parameters

array $ids

Return Value

bool|string