<?php
namespace App\Repository\Raport;
use App\Entity\Raport\OpeningLine;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
use App\Pagination\Paginator;
use Proxies\__CG__\App\Entity\Raport\Opening;
/**
* @extends ServiceEntityRepository<OpeningLine>
*
* @method OpeningLine|null find($id, $lockMode = null, $lockVersion = null)
* @method OpeningLine|null findOneBy(array $criteria, array $orderBy = null)
* @method OpeningLine[] findAll()
* @method OpeningLine[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
*/
class OpeningLineRepository extends ServiceEntityRepository
{
public function __construct(ManagerRegistry $registry)
{
parent::__construct($registry, OpeningLine::class);
}
public function add(OpeningLine $entity, bool $flush = false): void
{
$this->getEntityManager()->persist($entity);
if ($flush) {
$this->getEntityManager()->flush();
}
}
public function remove(OpeningLine $entity, bool $flush = false): void
{
$this->getEntityManager()->remove($entity);
if ($flush) {
$this->getEntityManager()->flush();
}
}
public function findOpeningLines(int $page = 1, array $sort, array $querys, $doc, $last): Paginator
{
if (isset($sort['request']) && $sort['request'] != null) {
$qb = $this->createQueryBuilder('p')->orderBy('p.' . $sort['request'], $sort[$sort['request']]);
} else {
$qb = $this->createQueryBuilder('p')->orderBy('p.id', 'DESC');
}
if ($last) {
$key = "opening";
$qb_id = $this->createQueryBuilder('i')->orderBy('i.id', 'DESC')->setMaxResults(1);
$qb_id ->leftJoin(Opening::class, 'e', 'WITH', 'e.id = i.opening');
if ('checked' == $doc['doc_close'] && '' == $doc['doc_open']) {
$doc_key = 'status_document';
$query = 'Close';
$qb_id->andwhere('e.'.$doc_key.' LIKE :'.$doc_key)->setParameter($doc_key, '%'.$query.'%');
}
if ('' == $doc['doc_close'] && 'checked' == $doc['doc_open']) {
$doc_key = 'status_document';
$query = 'Open';
$qb_id->andwhere('e.'.$doc_key.' LIKE :'.$doc_key)->setParameter($doc_key, '%'.$query.'%');
}
$result= $qb_id->getQuery()->getResult() ;
$query = $result[0]->getOpening()->getId();
// dump($query);
$qb->andwhere('LOWER(CAST(p.'.$key.' AS STRING)) LIKE LOWER(:'.$key.')')->setParameter($key, '%'.$query.'%');
$qb->leftJoin(Opening::class, 'd', 'WITH', 'd.id = p.opening');
} else {
$qb->leftJoin(Opening::class, 'd', 'WITH', 'd.id = p.opening');
}
if (count($querys) > 0) {
foreach ($querys as $key => $query) {
$qb->andwhere('LOWER(CAST(p.'.$key.' AS STRING)) LIKE LOWER(:'.$key.')')->setParameter($key, '%'.$query.'%');
}
}
//$qb->andwhere('d.status_document=:close');
//$qb->setParameter('close', 'Open');
/*
* Support for checkboxes at the repository level, we signed inputs differently above the columns
*
*/
if ('checked' == $doc['doc_close'] && '' == $doc['doc_open']) {
$doc_key = 'status_document';
$query = 'Close';
$qb->andwhere('d.'.$doc_key.' LIKE :'.$doc_key)->setParameter($doc_key, '%'.$query.'%');
}
if ('' == $doc['doc_close'] && 'checked' == $doc['doc_open']) {
$doc_key = 'status_document';
$query = 'Open';
$qb->andwhere('d.'.$doc_key.' LIKE :'.$doc_key)->setParameter($doc_key, '%'.$query.'%');
}
if ('' == $doc['doc_close'] && '' == $doc['doc_open']) {
$doc_key = 'status_document';
$query = 'Blank';
$qb->andwhere('d.'.$doc_key.' LIKE :'.$doc_key)->setParameter($doc_key, '%'.$query.'%');
}
return (new Paginator($qb))->paginate($page);
}
// /**
// * @return OpeningLine[] Returns an array of OpeningLine objects
// */
// public function findByExampleField($value): array
// {
// return $this->createQueryBuilder('o')
// ->andWhere('o.exampleField = :val')
// ->setParameter('val', $value)
// ->orderBy('o.id', 'ASC')
// ->setMaxResults(10)
// ->getQuery()
// ->getResult()
// ;
// }
// public function findOneBySomeField($value): ?OpeningLine
// {
// return $this->createQueryBuilder('o')
// ->andWhere('o.exampleField = :val')
// ->setParameter('val', $value)
// ->getQuery()
// ->getOneOrNullResult()
// ;
// }
}