Documentation

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
throws
NonUniqueResultException
Return values
int

countNotPaidReturnsByClientId()

public countNotPaidReturnsByClientId(int $clientId) : int
Parameters
$clientId : int
Return values
int

countQualityControlNotDoneInPeriodByClientIdAndPeriod()

public countQualityControlNotDoneInPeriodByClientIdAndPeriod(int $clientId, DateTime $periodStart, DateTime $periodEnd) : mixed
Parameters
$clientId : int
$periodStart : DateTime
$periodEnd : DateTime
Tags
throws
NonUniqueResultException

delete()

public delete(object $entity) : void
Parameters
$entity : object
Tags
throws
OptimisticLockException
throws
DataException
throws
ORMException

deleteList()

public deleteList(array<string|int, object> $entities) : void
Parameters
$entities : array<string|int, object>
Tags
throws
DataException
throws
ORMException
throws
OptimisticLockException

fetchAllAsAssocArray()

public fetchAllAsAssocArray(mixed $key) : mixed
Parameters
$key : mixed

findAll_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>|null

findByClientIdAndSubmitDateAndReportTypeIdList()

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>|null

findById()

public findById(int $id) : Entry|null
Parameters
$id : int
Tags
throws
NonUniqueResultException
Return values
Entry|null

findByIdListWithLimitAndOffset()

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>|null

findByUserId()

public findByUserId(int $clientId) : array<string|int, Entry>|null
Parameters
$clientId : int
Return values
array<string|int, Entry>|null

findCountByEntryFilter()

public findCountByEntryFilter(EntryFilter $entryFilter) : int
Parameters
$entryFilter : EntryFilter
Tags
throws
NonUniqueResultException
throws
Exception
Return values
int

findEcReportsByStartDate()

public findEcReportsByStartDate(DateTime $startDate) : array<string|int, mixed>|null
Parameters
$startDate : DateTime
Tags
throws
Exception
Return values
array<string|int, mixed>|null

findEntriesByReportFilter()

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>|null

findEntriesIdListWithTechnicalErrorsByEndDate()

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

Entry[]|[]

throws
Exception
Return values
array<string|int, mixed>

findEntryHasMovementCredits()

public findEntryHasMovementCredits(int $entryId) : bool
Parameters
$entryId : int
Return values
bool

findEntryHasMovementProducts()

public findEntryHasMovementProducts(int $entryId) : bool
Parameters
$entryId : int
Return values
bool

findEntryIdListByEntryFilter()

public findEntryIdListByEntryFilter(EntryFilter $entryFilter) : array<string|int, int>|null
Parameters
$entryFilter : EntryFilter
Tags
throws
Exception
Return values
array<string|int, int>|null

findEntryReportIdListByEntryFilter()

public findEntryReportIdListByEntryFilter(EntryFilter $entryFilter) : array<string|int, int>|null
Parameters
$entryFilter : EntryFilter
Tags
throws
Exception
Return values
array<string|int, int>|null

findEntryReportVersionListByEntryIdList()

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|string

findIdListByEntryIdListAndHasEntryReport()

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>|null

findIdListByEntryIdListAndHasEntryReportAndHasReportAndIsOnHold()

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>|null

findReportGroupMessagesByReportFilter()

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>|null

flush()

public flush() : void
Tags
throws
ORMException
throws
OptimisticLockException

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>|null

insert()

public insert(object $entity) : void
Parameters
$entity : object
Tags
throws
OptimisticLockException
throws
DataException
throws
ORMException

insertList()

public insertList(array<string|int, object> $entities) : void
Parameters
$entities : array<string|int, object>
Tags
throws
DataException
throws
ORMException
throws
OptimisticLockException

markSubmittedByEntryIds()

public markSubmittedByEntryIds(array<string|int, int> $entryIds, DateTimeInterface $date) : void
Parameters
$entryIds : array<string|int, int>
$date : DateTimeInterface

update()

public update(object $entity) : void
Parameters
$entity : object
Tags
throws
OptimisticLockException
throws
DataException
throws
ORMException

updateList()

public updateList(array<string|int, object> $entities) : void
Parameters
$entities : array<string|int, object>
Tags
throws
DataException
throws
ORMException
throws
OptimisticLockException

updateOnHoldDateByIdListAndDate()

public updateOnHoldDateByIdListAndDate(array<string|int, int> $entryIdList, DateTime|null $onHoldDate) : int
Parameters
$entryIdList : array<string|int, int>
$onHoldDate : DateTime|null
Return values
int

getNativeSqlWithParameters()

code mostly copied from doctrine private methods

protected getNativeSqlWithParameters(Query $query) : mixed
Parameters
$query : Query

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
Tags
throws
Exception
Return values
QueryBuilder

        
On this page

Search results