Symfony Profiler

<?php
namespace App\Repository;
use App\Entity\Articulos;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
use App\Utils\CustomPaginator;
/**
* @method Articulos|null find($id, $lockMode = null, $lockVersion = null)
* @method Articulos|null findOneBy(array $criteria, array $orderBy = null)
* @method Articulos[] findAll()
* @method Articulos[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
*/
class ArticulosRepository extends ServiceEntityRepository
{
public function __construct(ManagerRegistry $registry)
{
parent::__construct($registry, Articulos::class);
}
// /**
// * @return Articulos[] Returns an array of Articulos objects
// */
/*
public function findByExampleField($value)
{
return $this->createQueryBuilder('m')
->andWhere('m.exampleField = :val')
->setParameter('val', $value)
->orderBy('m.id', 'ASC')
->setMaxResults(10)
->getQuery()
->getResult()
;
}
*/
/*
public function findOneBySomeField($value): ?Articulos
{
return $this->createQueryBuilder('m')
->andWhere('m.exampleField = :val')
->setParameter('val', $value)
->getQuery()
->getOneOrNullResult()
;
}
*/
public function getAllArticulos($data, $currentPage = 1, $limit = 12, $sort, $order)
{
$parameters = array();
$query = $this->createQueryBuilder('Articulos')
->leftJoin('Articulos.MatProveedor', 'Proveedor');
if (isset($data['value']) && $data['value'] != "") {
$query->andWhere('(
Articulos.MatEstado like :where1 or
Articulos.MatObservaciones like :where1 or
Articulos.MatCodigo like :where1 or
Articulos.MatNombre like :where1
)');
$parameters[':where1'] = "%" . $data['value'] . "%";
}
if (isset($data['nombre']) && '' != $data['nombre']) {
$query->andWhere('(
Articulos.MatNombre like :nombre
)');
$parameters[':nombre'] = '%' . $data['nombre'] . '%';
}
if (isset($data['codigo']) && '' != $data['codigo']) {
$query->andWhere('(
Articulos.MatCodigo like :codigo
)');
$parameters[':codigo'] = '%' . $data['codigo'] . '%';
}
if (isset($data['observaciones']) && '' != $data['observaciones']) {
$query->andWhere('(
Articulos.MatObservaciones like :observaciones
)');
$parameters[':observaciones'] = '%' . $data['observaciones'] . '%';
}
if (isset($data['proveedor']) && '' != $data['proveedor']) {
$query->andWhere('(
Proveedor.ProvNombreFiscal like :proveedor
)');
$parameters[':proveedor'] = '%' . $data['proveedor'] . '%';
}
if (isset($data['precio_compra']) && $data['precio_compra'] > 0) {
$query->andWhere('(
Articulos.MatPrecioCompra = :precio_compra
)');
$parameters[':precio_compra'] = $data['precio_compra'];
}
if (isset($data['precio_venta']) && $data['precio_venta'] > 0) {
$query->andWhere('(
Articulos.MatPrecioVenta = :precio_venta
)');
$parameters[':precio_venta'] = $data['precio_venta'];
}
if (!empty($parameters)) {
$query->setParameters($parameters);
}
$query->addOrderBy($sort, $order);
$query->getQuery();
//dd($query->getQuery()->getResult());
$paginator = new CustomPaginator($query);
$result = $paginator->paginate($currentPage, $limit);
if ($result['count'] > 0 && $result['maxPages'] < $result['thisPage']) {
$result = $paginator->paginate(1, $limit);
}
return $result;
}
public function getAllArticulos_Select($data, $currentPage = 1, $limit = 12, $sort, $order = "DESC")
{
$parameters = array();
$query = $this->createQueryBuilder('Articulos');
if (isset($data['texto']) && $data['texto'] != "") {
$query->andWhere('(
Articulos.MatEstado like :where1 or
Articulos.MatObservaciones like :where1 or
Articulos.MatCodigo like :where1 or
Articulos.MatNombre like :where1
)');
$parameters[':where1'] = "%" . $data['texto'] . "%";
}
$query->andWhere('(
Articulos.MatEstado = 1
)');
if (!empty($parameters)) {
$query->setParameters($parameters);
}
$query->addOrderBy($sort, $order);
$query->getQuery();
//dd($query->getQuery()->getResult());
$paginator = new CustomPaginator($query);
$result = $paginator->paginate($currentPage, $limit);
if ($result['count'] > 0 && $result['maxPages'] < $result['thisPage']) {
$result = $paginator->paginate(1, $limit);
}
return $result;
}
public function getAllArticulosNoArray()
{
$parameters = array();
$query = $this->createQueryBuilder('Articulos');
if (isset($data['value']) && $data['value'] != "") {
$query->andWhere('(
Articulos.MatEstado like :where1 or
Articulos.MatObservaciones like :where1 or
Articulos.MatCodigo like :where1 or
Articulos.MatNombre like :where1
)');
$parameters[':where1'] = "'%" . $data['value'] . "%'";
}
if (!empty($parameters)) {
$query->setParameters($parameters);
}
return $query;
}
public function getAllArticulosByProveedor($data, $currentPage = 1, $limit = 12, $sort, $order, $idProveedor)
{
$parameters = array();
$query = $this->createQueryBuilder('Articulos')
->leftJoin('Articulos.MatProveedor', "proveedor");
if (isset($data['value']) && $data['value'] != "") {
$query->andWhere('(
Articulos.MatEstado like :where1 or
Articulos.MatObservaciones like :where1 or
Articulos.MatCodigo like :where1 or
Articulos.MatNombre like :where1
)');
$parameters[':where1'] = "'%" . $data['value'] . "%'";
}
if (isset($idProveedor) && $idProveedor != "") {
$query->andWhere('(
proveedor.id = :proveedor
)');
$parameters[':proveedor'] = $idProveedor;
}
if (!empty($parameters)) {
$query->setParameters($parameters);
}
$query->addOrderBy($sort, $order);
$query->getQuery();
//dd($query->getQuery()->getResult());
$paginator = new CustomPaginator($query);
$result = $paginator->paginate($currentPage, $limit);
if ($result['count'] > 0 && $result['maxPages'] < $result['thisPage']) {
$result = $paginator->paginate(1, $limit);
}
return $result;
}
public function getAllArticulosByProceso($data, $currentPage = 1, $limit = 12, $sort, $order, $idProceso)
{
$parameters = array();
$query = $this->createQueryBuilder('Articulos')
->leftJoin('Articulos.ProcesoArticulos', "ProcesoArticulos");
if (isset($data['value']) && $data['value'] != "") {
$query->andWhere('(
Articulos.MatEstado like :where1 or
Articulos.MatObservaciones like :where1 or
Articulos.MatCodigo like :where1 or
Articulos.MatNombre like :where1
)');
$parameters[':where1'] = "'%" . $data['value'] . "%'";
}
if (isset($idProceso) && $idProceso != "") {
$query->andWhere('(
ProcesoArticulos.proceso = :proceso
)');
$parameters[':proceso'] = $idProceso;
}
if (!empty($parameters)) {
$query->setParameters($parameters);
}
$query->addOrderBy($sort, $order);
$query->getQuery();
//dd($query->getQuery()->getResult());
$paginator = new CustomPaginator($query);
$result = $paginator->paginate($currentPage, $limit);
if ($result['count'] > 0 && $result['maxPages'] < $result['thisPage']) {
$result = $paginator->paginate(1, $limit);
}
return $result;
}
public function getLast()
{
$query = $this->createQueryBuilder('Articulos');
$query->addOrderBy('Articulos.id', 'DESC');
$query->setMaxResults(1);
return $query->getQuery()->getOneOrNullResult();
}
}

src/Repository/ArticulosRepository.php line 180