<?php

namespace Netapsys\Bundle\BibleBundle\Entity;

use Doctrine\ORM\EntityRepository;

class KjvRepository extends EntityRepository
{
    public function verseRange($name, $chapter, $vmin, $vmax)
    {
        return $this->getEntityManager()
                    ->createQuery(
                        'SELECT v
                         FROM  NetapsysBibleBundle:Kjv v
                         WHERE v.bname = :name
                             AND v.cnum = :chapter
                             AND (v.vnum <= :vmax AND v.vnum >= :vmin) ')
                    ->setParameters(array('name'    => $name,
                                          'chapter' => $chapter,
                                          'vmax'    => $vmax,
                                          'vmin'    => $vmin))
                    ->getResult();
    }
}