Symfony: doctrine custom sql order

    $this->data = Doctrine_Query::create()
            ->from('Category c')
            ->innerJoin('c.Product p')
            ->whereIn('c.slug', array('cpu', 'mainboards', 'ram', 'hdd', 'videocards', 'cases'))
            ->addWhere('p.is_published = ?', true)
            ->addOrderBy('FIELD(c.slug, "cpu", "mainboards", "ram", "hdd", "videocards", "cases")')
            ->execute()
    ;

Symfony: upload file, save original name

public function generatePicFilename($file = null)
{
  if (null === $file) {
    return null;
  }

 return $file->getOriginalName();
}

Symfony: Doctrine IndexBy field

    $posts = Doctrine_Query::create()
           ->from('Post p INDEXBY id')
           ->fetchArray()
    ;

на выходе получаем массив индексированный по реальным значениям id,
а не [0 => array(), 1 => array() ... ]

p.s. спасибо develop7 за наводку

Symfony: doctrine raw sql, get alphabet from i18n model

Задача: получить алфавит из i18n модели, для разных языков.
Показать только те буквы на которые начинаются имена.

in actions.class.php

    $lang = $request->getParameter('lang', 'ru');

    $query = "
      SELECT substring(`name`,1,1) as firstletter
      FROM `xxx_translation` 
      WHERE `lang` = '".$lang."' AND
        substring(`name`,1,1) <> ''
      GROUP BY substring(`name`,1,1)
    ";

    $pdo = Doctrine_Manager::getInstance()->getCurrentConnection()->getDbh();
    $stmt = $pdo->prepare($query);
    $stmt->execute();

    $this->abc = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);

in template

 <?php if ($abc): ?>
   <ul id="abcList">
     <?php foreach ($abc as $letter): ?>
       <li><?php echo link_to($letter, '@user_list?search='.$letter.'&pos=start')?> </li>
     <?php endforeach; ?>
   </ul>
   <br clear="all" />
 <?php endif; ?>

Css

ul#abcList li {
  float: left;
  display: inline;
  list-style: none;
  padding: 4px;
}