public function findActionAfterDate(
        $action,
        $date,
        $doerId = null,
        $resourceId = null,
        $workspaceId = null,
        $receiverId = null,
        $roleId = null,
        $groupId = null,
        $toolName = null,
        $userType = null
    ) {
        $queryBuilder = $this
            ->createQueryBuilder('log')
            ->orderBy('log.dateLog', 'DESC')

            ->andWhere('log.action = :action')
            ->setParameter('action', $action)

            ->andWhere('log.dateLog >= :date')
            ->setParameter('date', $date);

        if (null !== $doerId) {
            $queryBuilder
                ->leftJoin('log.doer', 'doer')
                ->andWhere('doer.id = :doerId')
                ->setParameter('doerId', $doerId);
        }

        if (null !== $resourceId) {
            $queryBuilder
                ->leftJoin('log.resource', 'resource')
                ->andWhere('resource.id = :resourceId')
                ->setParameter('resourceId', $resourceId);
        }

        if (null !== $workspaceId) {
            $queryBuilder
                ->leftJoin('log.workspace', 'workspace')
                ->andWhere('workspace.id = :workspaceId')
                ->setParameter('workspaceId', $workspaceId);
        }

        if (null !== $receiverId) {
            $queryBuilder
                ->leftJoin('log.receiver', 'receiver')
                ->andWhere('receiver.id = :receiverId')
                ->setParameter('receiverId', $receiverId);
        }

        if (null !== $roleId) {
            $queryBuilder
                ->leftJoin('log.role', 'role')
                ->andWhere('role.id = :roleId')
                ->setParameter('roleId', $roleId);
        }

        if (null !== $groupId) {
            $queryBuilder
                ->leftJoin('log.receiverGroup', 'receiverGroup')
                ->andWhere('receiverGroup.id = :groupId')
                ->setParameter('groupId', $groupId);
        }

        if (null !== $toolName) {
            $queryBuilder
                ->andWhere('log.toolName = :toolName')
                ->setParameter('toolName', $toolName);
        }

        $q = $queryBuilder->getQuery();
        $logs = $q->getResult();

        return $logs;
    }
public function findActionAfterDate(
        $action,
        $date,
        $doerId = null,
        $resourceId = null,
        $workspaceId = null,
        $receiverId = null,
        $roleId = null,
        $groupId = null,
        $toolName = null,
        $userType = null
    ) {
        $queryBuilder = $this
            ->createQueryBuilder('log')
            ->orderBy('log.dateLog', 'DESC')

            ->andWhere('log.action = :action')
            ->setParameter('action', $action)

            ->andWhere('log.dateLog >= :date')
            ->setParameter('date', $date);

        if (null !== $doerId) {
            $queryBuilder
                ->leftJoin('log.doer', 'doer')
                ->andWhere('doer.id = :doerId')
                ->setParameter('doerId', $doerId);
        }

        if (null !== $resourceId) {
            $queryBuilder
                ->leftJoin('log.resource', 'resource')
                ->andWhere('resource.id = :resourceId')
                ->setParameter('resourceId', $resourceId);
        }

        if (null !== $workspaceId) {
            $queryBuilder
                ->leftJoin('log.workspace', 'workspace')
                ->andWhere('workspace.id = :workspaceId')
                ->setParameter('workspaceId', $workspaceId);
        }

        if (null !== $receiverId) {
            $queryBuilder
                ->leftJoin('log.receiver', 'receiver')
                ->andWhere('receiver.id = :receiverId')
                ->setParameter('receiverId', $receiverId);
        }

        if (null !== $roleId) {
            $queryBuilder
                ->leftJoin('log.role', 'role')
                ->andWhere('role.id = :roleId')
                ->setParameter('roleId', $roleId);
        }

        if (null !== $groupId) {
            $queryBuilder
                ->leftJoin('log.receiverGroup', 'receiverGroup')
                ->andWhere('receiverGroup.id = :groupId')
                ->setParameter('groupId', $groupId);
        }

        if (null !== $toolName) {
            $queryBuilder
                ->andWhere('log.toolName = :toolName')
                ->setParameter('toolName', $toolName);
        }

        $q = $queryBuilder->getQuery();
        $logs = $q->getResult();

        return $logs;
    }
public function findActionAfterDate ( $ action , $ date , $ doerId = null , $ resourceId = null , $ workspaceId = null , $ receiverId = null , $ roleId = null , $ groupId = null , $ toolName = null , $ userType = null ) { $ queryBuilder = $ this -> createQueryBuilder ( 'log' ) -> orderBy ( 'log.dateLog' , 'DESC' ) -> andWhere ( 'log.action = :action' ) -> setParameter ( 'action' , $ action ) -> andWhere ( 'log.dateLog >= :date' ) -> setParameter ( 'date' , $ date ) ; if ( null !== $ doerId ) { $ queryBuilder -> leftJoin ( 'log.doer' , 'doer' ) -> andWhere ( 'doer.id = :doerId' ) -> setParameter ( 'doerId' , $ doerId ) ; } if ( null !== $ resourceId ) { $ queryBuilder -> leftJoin ( 'log.resource' , 'resource' ) -> andWhere ( 'resource.id = :resourceId' ) -> setParameter ( 'resourceId' , $ resourceId ) ; } if ( null !== $ workspaceId ) { $ queryBuilder -> leftJoin ( 'log.workspace' , 'workspace' ) -> andWhere ( 'workspace.id = :workspaceId' ) -> setParameter ( 'workspaceId' , $ workspaceId ) ; } if ( null !== $ receiverId ) { $ queryBuilder -> leftJoin ( 'log.receiver' , 'receiver' ) -> andWhere ( 'receiver.id = :receiverId' ) -> setParameter ( 'receiverId' , $ receiverId ) ; } if ( null !== $ roleId ) { $ queryBuilder -> leftJoin ( 'log.role' , 'role' ) -> andWhere ( 'role.id = :roleId' ) -> setParameter ( 'roleId' , $ roleId ) ; } if ( null !== $ groupId ) { $ queryBuilder -> leftJoin ( 'log.receiverGroup' , 'receiverGroup' ) -> andWhere ( 'receiverGroup.id = :groupId' ) -> setParameter ( 'groupId' , $ groupId ) ; } if ( null !== $ toolName ) { $ queryBuilder -> andWhere ( 'log.toolName = :toolName' ) -> setParameter ( 'toolName' , $ toolName ) ; } $ q = $ queryBuilder -> getQuery ( ) ; $ logs = $ q -> getResult ( ) ; return $ logs ; }
this method is never used and not up to date.
this method is never used and not up to date .