Symfony - how to use an array as an parameter by using a querybuilder?

Question

I'm about to output a list that includes several documents(called waiver). However not every user should be allowed to see all documents and therefore I've implemented an filter to check if the user has the same "airline" and "market" assigned. So every user should only see the documents that are assigned to his "airline" and "market". This is f.e. the getter for the airline of the user entity:

 /**
 * Get airlines
 *
 * @return array 
 */
public function getAirlines()
{
    if($this->airlines != null)
    {
        $airlines = explode(",", $this->airlines);
        return $airlines; 
    }

    return Array();        
}

This is the controller logic:

        //Get User:
        $user = $this->container->get('security.context')->getToken()->getUser();

        // Gets an Array of User markets
        $user_markets = $user->getMarkets();

        // Gets an Array of User carriers
        $user_airlines = $user->getAirlines();


        if(!$this->ROLE_IS(Array( 'ROLE_XY'))){
            $query = $em->createQuery(
                'SELECT w
                FROM WaiverBundle:Waiver w
                WHERE w.carrier = :carrier 
                AND w.market = :market
                ORDER BY w.id DESC'
            )
               ->setFirstResult($page*10-10)
               ->setMaxResults(10)
               // I wan't to get the whole array and not just one position here:
               ->setParameters(array(':carrier'=>$user_airlines[0],
                ':market'=>$user_markets[0],
            ));  
        }else{
            $query = $em->createQuery(
                'SELECT u
                FROM WaiverBundle:Waiver u
                ORDER BY u.id DESC'
            )
               ->setFirstResult($page*10-10)
               ->setMaxResults(10);
        }

Question: How do I manage to compare the DQL attributes with an array and not just a string as a parameter?

Daniel · Accepted Answer · 2016-01-25 19:53:03Z

4

I think you want to use "IN" syntax, not "=" syntax:

'SELECT w
    FROM WaiverBundle:Waiver w
    WHERE w.carrier IN (:carrier)
    AND w.market = :market
    ORDER BY w.id DESC'

answered Jan 25, 2016 at 19:53

Daniel

4,58716 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mayak Over a year ago

Thanks, I didn't know that there existed a special parameter ("IN") for this problem. This seems to solve my issue.

Daniel Over a year ago

Awesome, then please upvote and accept my answer ;-)

HoangND · Accepted Answer · 2016-01-26 05:59:17Z

3

Your query is not complicated. I think you should consider QueryBuilder instead of DQL in this case. Something like this would do the trick:

    $qb = $em->createQueryBuilder();
    $qb->select('w')
        ->from('WaiverBundle:Waiver', 'w')
        ->where($qb->expr()->in('w.carrier', ':carrier'))
        ->andWhere($qb->expr()->eq('w.market', ':market'))
        ->orderBy('w.id', 'DESC')
        ->setParameters(
            array(
                'carrier'=>$user_airlines[0],
                'market'=>$user_markets[0)
        );

answered Jan 26, 2016 at 5:59

HoangND

4083 silver badges12 bronze badges

Collectives™ on Stack Overflow

Symfony - how to use an array as an parameter by using a querybuilder?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related