ManufacturerController

gistfile1.txt

protected function getPartners() {
    $partnersRaw = Yii::app()->db->createCommand()->selectDistinct
                   ('ct.name as category_name,
                     mt.name as manufacturer_name,
                     c.url as category_url,
                     m.url, m.id,
                     p.url as product_url,
                     p.id as product_id')
                   ->from('StoreCategoryTranslate ct')
                   ->join('StoreCategory c', 'c.id=ct.object_id')
                   ->join('StoreProductCategoryRef pcr', 'pcr.category=ct.object_id')
                   ->join('StoreProduct p', 'p.id=pcr.product')
                   ->join('StoreManufacturer m', 'm.id=p.manufacturer_id')
                   ->join('StoreManufacturerTranslate mt', 'mt.object_id=m.id')
                   ->where('ct.language_id=1 and pcr.is_main=1 and p.is_active=:is_active and mt.language_id=1', array(':is_active'=>1))
                   ->order('mt.name')
                   ->queryAll();

    $partners = array();

    foreach($partnersRaw as $partnerRaw) {
        if($partnerRaw['category_name'] != 'root') { //shitcode!
            $partners[$partnerRaw['category_name']] = array();
        }
    }

    foreach($partners as $key => $value) {
        foreach($partnersRaw as $partnerRaw) {
            if($key == $partnerRaw['category_name']) {
                $letterKey = mb_substr($partnerRaw['manufacturer_name'], 0, 1);
                $partners[$key][$letterKey] = array();
                array_push($partners[$key][$letterKey], $partnerRaw);
            }
        }
    }

    return $partners;
}