class PricedownProductsController
{
    public function index(Application $app)
    {
        $qb = $app['orm.em']->createQueryBuilder('p')
            ->where('p.Status = 1')
            ->innerJoin('p.ProductTag', 'pt')
            ->innerJoin('pt.Tag', 't')
            ->andWhere('t.name = :TagName')
            ->setParameter('TagName', '値下げ商品');

        $pricedownProducts = array();
        try {
            $pricedownProducts = $qb->getQuery()->getResult();
        } catch (NoResultException $e) {
            return array();
        }

        return $app->render('Block/pricedown.twig', array(
            'pricedownProducts' => $pricedownProducts,
        ));
    }
}