Models\Products.php

Products.php

    private function queryBuilder($params)
    {
        $queryBuilder = $this->conn->createQueryBuilder();

        $queryBuilder
            ->select(
                'p.id', 'p.nombre name', 'precio_ref referencePrice',
                'p.categoria_id categoryId', 'precio_venta sellPrice',
                'img_catalogo image', 'descripcion description',
                'publicado published', 'alt imageAlt',
                'short_description shortDescription')
            ->from('productos', 'p')
            ->innerJoin('p', 'categorias', 'c', 'c.id=p.categoria_id')
            ->orderBy('p.orden');

        $translations = array(
            'categoryId' => 'p.categoria_id',
            'campaignId' => 'c.venta_id',
            'published'  => 'p.publicado'
        );

        foreach ($params as $key => $value) {
            if (isset($translations[$key])) {
                if (is_array($value)) {
                    $queryBuilder
                        ->andWhere(sprintf('%s IN (:%s)', $translations[$key], $key))
                        ->setParameter($key, $value, \Doctrine\DBAL\Connection::PARAM_STR_ARRAY);
                } else {
                    $queryBuilder
                        ->andWhere(sprintf('%s=:%s', $translations[$key], $key))
                        ->setParameter($key, $value);
                }
            }
        }

        return $queryBuilder;
    }