for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace Application\Repository;
use Application\Handler\ExportTransactionLinesHandler;
use Application\Model\User;
use Doctrine\ORM\Query;
use Ecodev\Felix\Repository\LimitedAccessSubQuery;
class TransactionLineRepository extends AbstractRepository implements ExportExcelInterface, LimitedAccessSubQuery
{
/**
* Returns pure SQL to get ID of all objects that are accessible to given user.
*
* @param null|User $user
*/
public function getAccessibleSubQuery(?\Ecodev\Felix\Model\User $user): string
if (!$user) {
return '-1';
}
if (in_array($user->getRole(), [User::ROLE_RESPONSIBLE, User::ROLE_ADMINISTRATOR], true)) {
return $this->getAllIdsQuery();
if ($user->getOwner()) {
$id = $user->getOwner()->getId();
} else {
$id = $user->getId();
return 'SELECT transaction_line.id FROM transaction_line
JOIN account ON transaction_line.debit_id = account.id OR transaction_line.credit_id = account.id
WHERE account.owner_id = ' . $id;
* Generates an Excel spreadsheet with the query result
* @return string name of the temporary file
public function exportExcel(Query $query): string
global $container;
return ($container->get(ExportTransactionLinesHandler::class))->generate($query);
public function importedIdExists(string $importedId): bool
$connection = $this->getEntityManager()->getConnection();
$count = $connection->fetchOne('SELECT COUNT(*) > 0 FROM transaction_line WHERE imported_id = :importedId', ['importedId' => $importedId]);
return (bool) $count;
Ecodev /
my-ichtus
