EntryRepository
extends AbstractRepository
in package
FinalYes
Table of Contents
Methods
- __construct() : mixed
- EntryRepository constructor.
- countByClientIdAndStartDate() : int
- countNotPaidReturnsByClientId() : int
- countQualityControlNotDoneInPeriodByClientIdAndPeriod() : mixed
- delete() : void
- deleteList() : void
- fetchAllAsAssocArray() : mixed
- findAll() : array<string|int, Entry>|null
- findAll_ClientIds_With_NonEmpty_Summaries_ForPeriodAndReportTypeId() : array<string|int, mixed>
- findAll_NonEmpty_Summaries_ForClientAndPeriodAndReportTypeId() : array<string|int, mixed>
- findAllByClientIdAndCountryIdAndAndStartDateAndEndDateAndPeriods() : array<string|int, Entry>
- findAllClientIdsByEntryIds() : array<string|int, int>
- findAllFilesForClientAndPeriod() : array<string|int, mixed>
- findAllOssEntriesByUserId() : array<string|int, Entry>|null
- findByClientIdAndSubmitDateAndReportTypeIdList() : array<string|int, mixed>|null
- findByEntryFilter() : array<string|int, Entry>|null
- findById() : Entry|null
- findByIdListWithLimitAndOffset() : array<string|int, Entry>|null
- findByUserId() : array<string|int, Entry>|null
- findCountByEntryFilter() : int
- findEcReportsByStartDate() : array<string|int, mixed>|null
- findEntriesByReportFilter() : array<string|int, mixed>|null
- findEntriesIdListWithTechnicalErrorsByEndDate() : mixed
- findEntriesIdsByFilingAlertsFilters() : array<string|int, mixed>
- findEntriesWithoutDeadlineByPeriodAndLabel() : array<string|int, mixed>
- findEntryHasMovementCredits() : bool
- findEntryHasMovementProducts() : bool
- findEntryIdListByEntryFilter() : array<string|int, int>|null
- findEntryReportIdListByEntryFilter() : array<string|int, int>|null
- findEntryReportVersionListByEntryIdList() : array<string|int, mixed>|int|string
- findIdListByEntryIdListAndHasEntryReport() : array<string|int, int>|null
- findIdListByEntryIdListAndHasEntryReportAndHasReportAndIsOnHold() : array<string|int, int>|null
- findReportGroupMessagesByReportFilter() : array<string|int, mixed>|null
- flush() : void
- getOrThrow() : mixed
- getQualityControlNotDoneInPeriodByClientIdAndPeriod() : array<string|int, mixed>|null
- insert() : void
- insertList() : void
- markSubmittedByEntryIds() : void
- merge() : object
- persist() : void
- remove() : void
- update() : void
- updateList() : void
- updateOnHoldDateByIdListAndDate() : int
- getNativeSqlWithParameters() : mixed
- code mostly copied from doctrine private methods
- addFiltersForReportAlerts() : mixed
- joinUQCHelper() : mixed
- queryBuilderAmazonCancelledReports() : mixed
- queryBuilderByEntryFilter() : QueryBuilder
Methods
__construct()
EntryRepository constructor.
public
__construct(EntityManager $entityManager) : mixed
Parameters
- $entityManager : EntityManager
countByClientIdAndStartDate()
public
countByClientIdAndStartDate(int $clientId, int $year) : int
Parameters
- $clientId : int
- $year : int
Tags
Return values
intcountNotPaidReturnsByClientId()
public
countNotPaidReturnsByClientId(int $clientId) : int
Parameters
- $clientId : int
Return values
intcountQualityControlNotDoneInPeriodByClientIdAndPeriod()
public
countQualityControlNotDoneInPeriodByClientIdAndPeriod(int $clientId, DateTime $periodStart, DateTime $periodEnd) : mixed
Parameters
- $clientId : int
- $periodStart : DateTime
- $periodEnd : DateTime
Tags
delete()
public
delete(object $entity) : void
Parameters
- $entity : object
Tags
deleteList()
public
deleteList(array<string|int, object> $entities) : void
Parameters
- $entities : array<string|int, object>
Tags
fetchAllAsAssocArray()
public
fetchAllAsAssocArray(mixed $key) : mixed
Parameters
- $key : mixed
findAll()
public
findAll() : array<string|int, Entry>|null
Return values
array<string|int, Entry>|nullfindAll_ClientIds_With_NonEmpty_Summaries_ForPeriodAndReportTypeId()
public
findAll_ClientIds_With_NonEmpty_Summaries_ForPeriodAndReportTypeId(DateTime $startDate, DateTime $endDate, int $reportTypeId[, bool|null $subscribed = null ]) : array<string|int, mixed>
Parameters
- $startDate : DateTime
- $endDate : DateTime
- $reportTypeId : int
- $subscribed : bool|null = null
Return values
array<string|int, mixed>findAll_NonEmpty_Summaries_ForClientAndPeriodAndReportTypeId()
public
findAll_NonEmpty_Summaries_ForClientAndPeriodAndReportTypeId(int $clientId, DateTime $startDate, DateTime $endDate, int $reportTypeId[, bool|null $subscribed = null ]) : array<string|int, mixed>
Parameters
- $clientId : int
- $startDate : DateTime
- $endDate : DateTime
- $reportTypeId : int
- $subscribed : bool|null = null
Return values
array<string|int, mixed>findAllByClientIdAndCountryIdAndAndStartDateAndEndDateAndPeriods()
public
findAllByClientIdAndCountryIdAndAndStartDateAndEndDateAndPeriods(int $clientId, int $countryId, DateTime $startDate, DateTime $endDate, mixed $periodIds) : array<string|int, Entry>
Parameters
- $clientId : int
- $countryId : int
- $startDate : DateTime
- $endDate : DateTime
- $periodIds : mixed
Return values
array<string|int, Entry>findAllClientIdsByEntryIds()
public
findAllClientIdsByEntryIds(array<string|int, int> $entryIds) : array<string|int, int>
Parameters
- $entryIds : array<string|int, int>
Return values
array<string|int, int>findAllFilesForClientAndPeriod()
public
findAllFilesForClientAndPeriod(int $clientId, DateTime $startDate, DateTime $endDate[, bool|null $subscribed = null ]) : array<string|int, mixed>
Parameters
- $clientId : int
- $startDate : DateTime
- $endDate : DateTime
- $subscribed : bool|null = null
Return values
array<string|int, mixed>findAllOssEntriesByUserId()
public
findAllOssEntriesByUserId(int $userId) : array<string|int, Entry>|null
Parameters
- $userId : int
Return values
array<string|int, Entry>|nullfindByClientIdAndSubmitDateAndReportTypeIdList()
public
findByClientIdAndSubmitDateAndReportTypeIdList(int $clientId, DateTime $yesterday, array<string|int, mixed> $reportTypeIdList) : array<string|int, mixed>|null
Parameters
- $clientId : int
- $yesterday : DateTime
- $reportTypeIdList : array<string|int, mixed>
Return values
array<string|int, mixed>|nullfindByEntryFilter()
public
findByEntryFilter(EntryFilter $entryFilter) : array<string|int, Entry>|null
Parameters
- $entryFilter : EntryFilter
Tags
Return values
array<string|int, Entry>|nullfindById()
public
findById(int $id) : Entry|null
Parameters
- $id : int
Tags
Return values
Entry|nullfindByIdListWithLimitAndOffset()
public
findByIdListWithLimitAndOffset(array<string|int, int> $idList[, int|null $limit = null ][, int|null $offset = null ]) : array<string|int, Entry>|null
Parameters
- $idList : array<string|int, int>
- $limit : int|null = null
- $offset : int|null = null
Return values
array<string|int, Entry>|nullfindByUserId()
public
findByUserId(int $clientId) : array<string|int, Entry>|null
Parameters
- $clientId : int
Return values
array<string|int, Entry>|nullfindCountByEntryFilter()
public
findCountByEntryFilter(EntryFilter $entryFilter) : int
Parameters
- $entryFilter : EntryFilter
Tags
Return values
intfindEcReportsByStartDate()
public
findEcReportsByStartDate(DateTime $startDate) : array<string|int, mixed>|null
Parameters
- $startDate : DateTime
Tags
Return values
array<string|int, mixed>|nullfindEntriesByReportFilter()
public
findEntriesByReportFilter(ReportFilterEntity $filter[, array<string|int, mixed> $ossEntriesWithActiveSubscriptionBetweenPeriod = [] ]) : array<string|int, mixed>|null
Parameters
- $filter : ReportFilterEntity
- $ossEntriesWithActiveSubscriptionBetweenPeriod : array<string|int, mixed> = []
Return values
array<string|int, mixed>|nullfindEntriesIdListWithTechnicalErrorsByEndDate()
public
findEntriesIdListWithTechnicalErrorsByEndDate(mixed $endDate) : mixed
Parameters
- $endDate : mixed
findEntriesIdsByFilingAlertsFilters()
public
findEntriesIdsByFilingAlertsFilters(array<string|int, mixed> $filters) : array<string|int, mixed>
Parameters
- $filters : array<string|int, mixed>
Return values
array<string|int, mixed>findEntriesWithoutDeadlineByPeriodAndLabel()
public
findEntriesWithoutDeadlineByPeriodAndLabel(int $periodId, array<string|int, mixed> $labelsList) : array<string|int, mixed>
Parameters
- $periodId : int
- $labelsList : array<string|int, mixed>
Tags
Return values
array<string|int, mixed>findEntryHasMovementCredits()
public
findEntryHasMovementCredits(int $entryId) : bool
Parameters
- $entryId : int
Return values
boolfindEntryHasMovementProducts()
public
findEntryHasMovementProducts(int $entryId) : bool
Parameters
- $entryId : int
Return values
boolfindEntryIdListByEntryFilter()
public
findEntryIdListByEntryFilter(EntryFilter $entryFilter) : array<string|int, int>|null
Parameters
- $entryFilter : EntryFilter
Tags
Return values
array<string|int, int>|nullfindEntryReportIdListByEntryFilter()
public
findEntryReportIdListByEntryFilter(EntryFilter $entryFilter) : array<string|int, int>|null
Parameters
- $entryFilter : EntryFilter
Tags
Return values
array<string|int, int>|nullfindEntryReportVersionListByEntryIdList()
public
findEntryReportVersionListByEntryIdList(array<string|int, mixed> $entryIdList) : array<string|int, mixed>|int|string
Parameters
- $entryIdList : array<string|int, mixed>
Return values
array<string|int, mixed>|int|stringfindIdListByEntryIdListAndHasEntryReport()
public
findIdListByEntryIdListAndHasEntryReport(array<string|int, mixed> $entryIdList, bool $hasEntryReport) : array<string|int, int>|null
Parameters
- $entryIdList : array<string|int, mixed>
- $hasEntryReport : bool
Return values
array<string|int, int>|nullfindIdListByEntryIdListAndHasEntryReportAndHasReportAndIsOnHold()
public
findIdListByEntryIdListAndHasEntryReportAndHasReportAndIsOnHold(array<string|int, mixed> $entryIdList, bool $hasEntryReport, bool $hasReport, bool $isOnHold) : array<string|int, int>|null
Parameters
- $entryIdList : array<string|int, mixed>
- $hasEntryReport : bool
- $hasReport : bool
- $isOnHold : bool
Return values
array<string|int, int>|nullfindReportGroupMessagesByReportFilter()
public
findReportGroupMessagesByReportFilter(ReportFilterEntity $filter[, array<string|int, mixed> $ossEntriesWithActiveSubscriptionBetweenPeriod = [] ]) : array<string|int, mixed>|null
Parameters
- $filter : ReportFilterEntity
- $ossEntriesWithActiveSubscriptionBetweenPeriod : array<string|int, mixed> = []
Return values
array<string|int, mixed>|nullflush()
public
flush() : void
Tags
getOrThrow()
public
getOrThrow(mixed $id[, mixed $lockMode = null ][, mixed $lockVersion = null ][, Exception $exception = null ]) : mixed
Parameters
- $id : mixed
- $lockMode : mixed = null
- $lockVersion : mixed = null
- $exception : Exception = null
getQualityControlNotDoneInPeriodByClientIdAndPeriod()
public
getQualityControlNotDoneInPeriodByClientIdAndPeriod(int $clientId, DateTime $periodStart, DateTime $periodEnd) : array<string|int, mixed>|null
Parameters
- $clientId : int
- $periodStart : DateTime
- $periodEnd : DateTime
Return values
array<string|int, mixed>|nullinsert()
public
insert(object $entity) : void
Parameters
- $entity : object
Tags
insertList()
public
insertList(array<string|int, object> $entities) : void
Parameters
- $entities : array<string|int, object>
Tags
markSubmittedByEntryIds()
public
markSubmittedByEntryIds(array<string|int, int> $entryIds, DateTimeInterface $date) : void
Parameters
- $entryIds : array<string|int, int>
- $date : DateTimeInterface
merge()
public
merge(object $entity) : object
Parameters
- $entity : object
Tags
Return values
objectpersist()
public
persist(object $entity) : void
Parameters
- $entity : object
Tags
remove()
public
remove(object $entity) : void
Parameters
- $entity : object
Tags
update()
public
update(object $entity) : void
Parameters
- $entity : object
Tags
updateList()
public
updateList(array<string|int, object> $entities) : void
Parameters
- $entities : array<string|int, object>
Tags
updateOnHoldDateByIdListAndDate()
public
updateOnHoldDateByIdListAndDate(array<string|int, int> $entryIdList, DateTime|null $onHoldDate) : int
Parameters
- $entryIdList : array<string|int, int>
- $onHoldDate : DateTime|null
Return values
intgetNativeSqlWithParameters()
code mostly copied from doctrine private methods
protected
getNativeSqlWithParameters(Query $query) : mixed
Parameters
- $query : Query
addFiltersForReportAlerts()
private
addFiltersForReportAlerts(QueryBuilder $builder, ReportFilterEntity $filter) : mixed
Parameters
- $builder : QueryBuilder
- $filter : ReportFilterEntity
joinUQCHelper()
private
joinUQCHelper(mixed $builder, bool &$joinedFlag[, mixed $entryAlias = 'entry' ][, mixed $helperAlias = 'viewUQCHelper' ]) : mixed
Parameters
- $builder : mixed
- $joinedFlag : bool
- $entryAlias : mixed = 'entry'
- $helperAlias : mixed = 'viewUQCHelper'
queryBuilderAmazonCancelledReports()
private
queryBuilderAmazonCancelledReports() : mixed
queryBuilderByEntryFilter()
private
queryBuilderByEntryFilter(EntryFilter $entryFilter) : QueryBuilder
Parameters
- $entryFilter : EntryFilter