GridPromptRepository
extends BaseRepository
Table of Contents
Constants
-
FLAG_IS_ACTIVE
= 1
-
FLAG_IS_DELETED
= 1
-
FLAG_IS_NOT_ACTIVE
= 0
-
FLAG_IS_NOT_DELETED
= 0
-
FLAG_IS_NOT_SYSTEM
= 'N'
-
SYSTEM_USER_ID
= 0
Methods
-
__construct()
: mixed
-
getAvailablePromptsForGrid()
: array<int, array{ID: string}>
-
getAvailablePromptsForGridWithUserInShare()
: array<string|int, mixed>
-
getPromptsForGrid()
: array<int, array{ID: string, CODE: string, TITLE: string, TYPE: string, IS_ACTIVE: string, AUTHOR_NAME: string, AUTHOR_LAST_NAME: string, AUTHOR_SECOND_NAME: string, AUTHOR_EMAIL: string, AUTHOR_ID: string, AUTHOR_LOGIN: string, AUTHOR_PHOTO_ID: string, AUTHOR_GENDER: string, EDITOR_NAME: string, EDITOR_LAST_NAME: string, EDITOR_SECOND_NAME: string, EDITOR_EMAIL: string, EDITOR_ID: string, EDITOR_LOGIN: string, EDITOR_PHOTO_ID: string, EDITOR_GENDER: string, DATE_CREATE: string, DATE_MODIFY: string, CATEGORIES: string, SHARE_CODES: string, IS_FAVORITE: string, IS_DELETED: string}>
FLAG_IS_ACTIVE
public
mixed
FLAG_IS_ACTIVE
= 1
FLAG_IS_DELETED
public
mixed
FLAG_IS_DELETED
= 1
FLAG_IS_NOT_ACTIVE
public
mixed
FLAG_IS_NOT_ACTIVE
= 0
FLAG_IS_NOT_DELETED
public
mixed
FLAG_IS_NOT_DELETED
= 0
FLAG_IS_NOT_SYSTEM
public
mixed
FLAG_IS_NOT_SYSTEM
= 'N'
SYSTEM_USER_ID
public
mixed
SYSTEM_USER_ID
= 0
__construct()
public
__construct(UserAccessRepository $userAccessRepository) : mixed
Parameters
-
$userAccessRepository
: UserAccessRepository
-
getAvailablePromptsForGrid()
public
getAvailablePromptsForGrid(int $userId, GridParamsDto $params) : array<int, array{ID: string}>
Parameters
-
$userId
: int
-
-
$params
: GridParamsDto
-
Return values
array<int, array{ID: string}>
getAvailablePromptsForGridWithUserInShare()
public
getAvailablePromptsForGridWithUserInShare(array<string|int, mixed> $userList, array<string|int, mixed> $availablePromptList) : array<string|int, mixed>
Parameters
-
$userList
: array<string|int, mixed>
-
-
$availablePromptList
: array<string|int, mixed>
-
Return values
array<string|int, mixed>
getPromptsForGrid()
public
getPromptsForGrid(int $userId, GridParamsDto $params) : array<int, array{ID: string, CODE: string, TITLE: string, TYPE: string, IS_ACTIVE: string, AUTHOR_NAME: string, AUTHOR_LAST_NAME: string, AUTHOR_SECOND_NAME: string, AUTHOR_EMAIL: string, AUTHOR_ID: string, AUTHOR_LOGIN: string, AUTHOR_PHOTO_ID: string, AUTHOR_GENDER: string, EDITOR_NAME: string, EDITOR_LAST_NAME: string, EDITOR_SECOND_NAME: string, EDITOR_EMAIL: string, EDITOR_ID: string, EDITOR_LOGIN: string, EDITOR_PHOTO_ID: string, EDITOR_GENDER: string, DATE_CREATE: string, DATE_MODIFY: string, CATEGORIES: string, SHARE_CODES: string, IS_FAVORITE: string, IS_DELETED: string}>
Parameters
-
$userId
: int
-
-
$params
: GridParamsDto
-
-
throws
-
SqlQueryException
Return values
array<int, array{ID: string, CODE: string, TITLE: string, TYPE: string, IS_ACTIVE: string, AUTHOR_NAME: string, AUTHOR_LAST_NAME: string, AUTHOR_SECOND_NAME: string, AUTHOR_EMAIL: string, AUTHOR_ID: string, AUTHOR_LOGIN: string, AUTHOR_PHOTO_ID: string, AUTHOR_GENDER: string, EDITOR_NAME: string, EDITOR_LAST_NAME: string, EDITOR_SECOND_NAME: string, EDITOR_EMAIL: string, EDITOR_ID: string, EDITOR_LOGIN: string, EDITOR_PHOTO_ID: string, EDITOR_GENDER: string, DATE_CREATE: string, DATE_MODIFY: string, CATEGORIES: string, SHARE_CODES: string, IS_FAVORITE: string, IS_DELETED: string}>