[Symfony][Symfony2] czy mogę w klasie Entity reprezentującej tabele wykonać zapytanie? Opcje

[wiewiorek]

Mam klasę KategorieEntity i ZdjeciaEntity. W widoku w pętli wyświetlam wszystkie kategorie, jednak chciałbym wywołać moją metodę pobierzNazweMiniaturyKategorii() z KategorieEntity na obiekcie reprezentującym pojedynczą kategorię, tzn. w widoku mam:

[PHP] pobierz, plaintext 
<?php foreach ($kategorie as $kategoria): ?>
  <?php echo $kategoria->getNazwa() ?>
  <img src="<?php echo $view['assets']->getUrl('uploads/'.$kategoria->pobierzNazweMiniaturyKategorii($kategoria->getId())) ?>" />
<?php endforeach; ?>
[PHP] pobierz, plaintext 

W klasie KategorieEntity:

[PHP] pobierz, plaintext 
class KategorieEntity
{
    protected $id;    
 
    protected $nazwa;
 
         //moja metoda:
         public function pobierzNazweMiniaturyKategorii($idKategorii)
  	{  		
		$zdjecie = $this->getEntityManager()
			->createQuery('SELECT z FROM AcmeStronaBundle:ZdjeciaEntity z 
            	        JOIN z.kategoria k
            	        WHERE k.id = :idKategorii AND z.glowneKategorii = true')
                ->setParameter('idKategorii', $idKategorii)
                ->getSingleResult();
 
               return $zdjecie->getNazwaMiniatury();
  	}  
 
 
................
}
[PHP] pobierz, plaintext 

Niestety wykonanie zapytania w klasie Entity i wywołanie metody z tej klasy w widoku chyba nie jest mozliwe, bo to nie działa (nie jest też wyświetlany komunikat błedu), więc jak to zrobić?

Ten post edytował wiewiorek 21.03.2012, 14:23:21

[wiewiorek]

No nic istotnego własnie nie mówią:

[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\RouterListener::onEarlyKernelRequest". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest". [] []
[2012-03-21 14:53:44] security.DEBUG: Read SecurityContext from the session [] []
[2012-03-21 14:53:44] security.DEBUG: Reloading user from user provider. [] []
[2012-03-21 14:53:44] doctrine.DEBUG: SET NAMES UTF8 ([]) [] []
[2012-03-21 14:53:44] doctrine.DEBUG: SELECT t0.user_id AS user_id1, t0.username AS username2, t0.email AS email3, t0.password AS password4, t0.salt AS salt5 FROM user t0 WHERE t0.user_id = ? ([1]) [] []
[2012-03-21 14:53:44] security.DEBUG: Username "admin" was reloaded from user provider. [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\RouterListener::onKernelRequest". [] []
[2012-03-21 14:53:44] request.INFO: Matched route "kategorie_zarzadzanie" (parameters: "_controller": "Acme\StronaBundle\Controller\KategorieController::indexAction", "_route": "kategorie_zarzadzanie") [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RequestDataCollector::onKernelController". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.controller" to listener "Acme\DemoBundle\ControllerListener::onKernelController". [] []
[2012-03-21 14:53:44] event.DEBUG: Notified event "kernel.controller" to listener "JMS\SecurityExtraBundle\Controller\ControllerListener::onCoreController". [] []
[2012-03-21 14:53:44] doctrine.DEBUG: SELECT k0_.id AS id0, k0_.nazwa AS nazwa1, k0_.opis AS opis2, k0_.data_dodania AS data_dodania3, k0_.data_modyfikacji AS data_modyfikacji4 FROM kategorie k0_ ORDER BY k0_.data_dodania DESC ([]) [] []