SurveyRepository
class SurveyRepository extends TranslatableRepository implements AbstractBlockElementRepositoryInterface
Class SurveyRepository is injected as alligator.survey_repository service. SurveyRepository is used for crud operation for managed entity.
Use this class to work with database.
Traits
Constants
| TRANSLATION_WALKER_HINT |
|
| ALIAS |
Survey alias |
| CATEGORY_ALIAS |
Survey alias |
| QUESTION_ALIAS |
Question alias |
| AGGREGATION_ALIAS |
Aggregation alias |
Properties
| protected string | $defaultLocale | from TranslatableRepository |
Methods
Returns translated one (or null if not found) result for given locale
Returns translated results for given locale
Returns translated array results for given locale
Returns translated single result for given locale
Returns translated scalar result for given locale
Returns translated single scalar result for given locale
Remove entities provided as array
Find all locales for custom ids of entities
Returns translated Doctrine query instance
No description
Should contain group by which jqgrid uses.
JQGrid function
JQGrid function
Find survey by id for edit
Find featured surveys by locale and optional slug
Delete all cached results
Get all surveys for delete
Get all surveys by object array
Delete surveys
Get all surveys by locale
Get all surveys by ids
Find one for edit by id and locale
Get entities from database by ids Tis method is used to for block elements extension Make sure you order data by ids - ids is array of elements and it is sorted by priority - so add this to select -> ' FIELD('.self::ALIAS.'.id'.', '.implode(', ', $ids).') AS sort_col'); - and order by this field Also make sure you cache this data -> qb->useQueryCache(true)->useResultCache(true, 3600)
Get id and name (field must be name so change it in select) of entity Used in event for block element edit Make sure you order data by ids - ids is array of elements and it is sorted by priority - so add this to select -> ' FIELD('.self::ALIAS.'.id'.', '.implode(', ', $ids).') AS sort_col'); - and order by this field
Details
in TranslatableRepository at line 41
setDefaultLocale(string $locale)
Sets default locale
in TranslatableRepository at line 57
QueryBuilder
getOneOrNullResult(QueryBuilder $qb, string $locale = null, string $hydrationMode = null)
Returns translated one (or null if not found) result for given locale
in TranslatableRepository at line 72
mixed
getResult(QueryBuilder $qb, string $locale = null, int $hydrationMode = AbstractQuery::HYDRATE_OBJECT)
Returns translated results for given locale
in TranslatableRepository at line 85
array
getArrayResult(QueryBuilder $qb, string $locale = null)
Returns translated array results for given locale
in TranslatableRepository at line 102
QueryBuilder
getSingleResult(QueryBuilder $qb, string $locale = null, string $hydrationMode = null)
Returns translated single result for given locale
in TranslatableRepository at line 115
array
getScalarResult(QueryBuilder $qb, string $locale = null)
Returns translated scalar result for given locale
in TranslatableRepository at line 130
QueryBuilder
getSingleScalarResult(QueryBuilder $qb, string $locale = null)
Returns translated single scalar result for given locale
in TranslatableRepository at line 142
PrimaryKeyInterface
save(PrimaryKeyInterface $entity)
in TranslatableRepository at line 172
remove(mixed $entity)
Remove entity
in TranslatableRepository at line 200
bool
removeArray(array $arrayOfEntities)
Remove entities provided as array
in TranslatableRepository at line 228
PrimaryKeyInterface
edit(PrimaryKeyInterface $entity)
Sets default locale to entity and merge
in TranslatableRepository at line 253
mixed
getAll()
Find all entities depending on locale
in TranslatableRepository at line 270
mixed
getByPrimaryKey(PrimaryKeyInterface $entity)
Find entity by primary key
in TranslatableRepository at line 291
QueryBuilder
getById(int $id)
Find entity by id
in TranslatableRepository at line 307
QueryBuilder|array
getGroupFromDB(array $array)
Find group od entities
in TranslatableRepository at line 332
EntityManager
getManager()
Singleton
in TranslatableRepository at line 352
mixed
saveCollection(array $array)
Persist collection
in TranslatableRepository at line 379
array
getLanguagesForIds(array $ids)
Find all locales for custom ids of entities
in TranslatableRepository at line 396
protected Query
getTranslatedQuery(QueryBuilder $qb, string $locale = null)
Returns translated Doctrine query instance
in TranslatableRepository at line 404
protected
startTransaction()
Begins transaction over database
in TranslatableRepository at line 412
protected
commitTransaction()
Commit transaction over database
in TranslatableRepository at line 420
protected
rollbackTransaction()
Rollback transaction over database
at line 52
string
getAlias()
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
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
in JQGridTrait at line 61
array
findAllForJQGRID(int $page, int $offset, array $sortParams, array $additionalParams, JQGridWrapper $jqGridWrapper)
JQGrid function
in JQGridTrait at line 94
array
searchForJQGRID(array $searchParams, array $sortParams, bool $isCountSearch = false, array $additionalParams = array(), JQGridWrapper $jqGridWrapper = null)
JQGrid function
at line 88
array
findOneByIdForEdit(int $id)
Find survey by id for edit
at line 118
array
findFeaturedSurveys(string $locale, null $slug = null)
Find featured surveys by locale and optional slug
at line 156
deleteResultCaches()
Delete all cached results
at line 168
array
getAllSurveysForDelete(array $surveyId)
Get all surveys for delete
at line 190
array
getAllSurveysByObjectArray(array $surveysAggregation)
Get all surveys by object array
at line 211
Survey
deleteSurveys(array $surveys)
Delete surveys
at line 229
array
getAllSurveys(string $locale = null)
Get all surveys by locale
at line 247
array
getAllSurveysIds()
Get all surveys by ids
at line 265
array
findOneForEdit(int|string $id, string $locale)
Find one for edit by id and locale
at line 288
array
getEntitiesForBlockElementsExtension(array $ids)
Get entities from database by ids Tis method is used to for block elements extension Make sure you order data by ids - ids is array of elements and it is sorted by priority - so add this to select -> ' FIELD('.self::ALIAS.'.id'.', '.implode(', ', $ids).') AS sort_col'); - and order by this field Also make sure you cache this data -> qb->useQueryCache(true)->useResultCache(true, 3600)
at line 307
array
getEntityNamesForIds(array $ids)
Get id and name (field must be name so change it in select) of entity Used in event for block element edit Make sure you order data by ids - ids is array of elements and it is sorted by priority - so add this to select -> ' FIELD('.self::ALIAS.'.id'.', '.implode(', ', $ids).') AS sort_col'); - and order by this field