Category Archives: symfony

Symfony admin generator link with filters

Posted on by
Reply

Let's assume you have module A in which you'd like to place a link to module B, and you also want this link to set filters in module B.
To do this, you'll have to use following code:

 
$filters = array('query_string' => 'filter',
  'filters' => array('a_id' => $A->getId()));
 
echo link_to('Go and apply filter',
  'b/index?'.http_build_query($filters));
 

Following this link, user will visit module B with 'a_id' filter field set to $A->getId()
No csrf_token is needed - it's a simple solution to crosslink your symfony admin modules.

Propel 1.5 nested joins

Posted on by
2

Я, это, люблю Propel15:

 
$langs = LanguageQuery::create()
      ->useCountryLanguageQuery()
        ->useCountryQuery()
          ->useCountryDomainQuery()
            ->filterByDomain($_SERVER['HTTP_HOST'])
          ->endUse()
        ->endUse()
      ->endUse()
      ->orderByCode()
      ->find();
 

Создает SQL:

 
SELECT LANGUAGE.ID, LANGUAGE.CODE, LANGUAGE.SHORT_TITLE
  FROM `language`
  INNER JOIN country_language
    ON (LANGUAGE.ID=country_language.LANGUAGE_ID)
  INNER JOIN country
    ON (country_language.COUNTRY_ID=country.ID)
  LEFT JOIN country_domain
   ON (country.ID=country_domain.COUNTRY_ID)
  WHERE country_domain.DOMAIN='localhost'