MySQL to Excel

    public function actionStep1()
    {
        $current_city = "Ульяновск";
        $categories = Category::model()->findAll();

        foreach($categories as $category)
        {
            mkdir("./upload/" . iconv("utf-8", "windows-1251", $current_city) . "/" . iconv("utf-8", "windows-1251", str_replace(" /", ",", $category->name) . "/"));
        }

        $this->render('index');
    }

    public function actionStep2()
    {
        $data = array();
        $firms = FirmToSubcategory::model()->findAll();

        foreach($firms as $item)
        {
            if (!isset($data[$item->firm_id]))
                $data[$item->firm_id] = $item->subcategory_id;
            else
            {
                $item->delete();
            }
        }

        $this->render('index');
    }

    public function actionStep3()
    {
        $current_city = "Ульяновск";
        $categories = array();
        $categories_list = Category::model()->findAll();

        foreach($categories_list as $item)
            $categories[$item->id] = $item->name;

        $sub = Subcategory::model()->findAll();

        foreach($sub as $item)
        {
            $current_category = str_replace(" /", ",", $categories[$item->category_id]);
            $current_subcategory = str_replace(" /", ",", $item->name);
            $objPHPExcel = new PHPExcel();

            $objPHPExcel->getProperties()
                ->setCreator("Андрей Клипиков");

            $objPHPExcel->setActiveSheetIndex(0)
                ->setCellValue('A1', 'ID')
                ->setCellValue('B1', 'Название')
                ->setCellValue('C1', 'Адрес')
                ->setCellValue('D1', 'Телефоны')
                ->setCellValue('E1', 'E-mail')
                ->setCellValue('F1', 'WWW')
                ->setCellValue('G1', 'Факс')
                ->setCellValue('H1', 'Звонок')
                ->setCellValue('I1', 'Решение');

            $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
            $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50);
            $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
            $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
            $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
            $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
            $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(30);

            $ids = array();
            $firms_id = FirmToSubcategory::model()->findAll(array('condition'=>'subcategory_id=' . $item->id));

            foreach($firms_id as $tmp)
                $ids[] = $tmp->firm_id;

            $criteria = new CDbCriteria();
            $criteria->addInCondition("id", $ids);
            $firms = Firm::model()->findAll($criteria);
            $firm_number = 2;

            foreach($firms as $firm)
            {
                $phones = array();
                $emails = array();
                $www = array();
                $fax = array();
                $contacts = Contacts::model()->findAll(array('condition'=>'firm_id=' . $firm->id));

                foreach($contacts as $contact)
                {
                    if ($contact->type == "mobile" || $contact->type == "phone")
                        $phones[] = $contact->rawdata;

                    if ($contact->type == "email")
                        $emails[] = $contact->rawdata;

                    if ($contact->type == "website" || $contact->type == "twitter" || $contact->type == "vkontakte" || $contact->type == "facebook" || $contact->type == "instagram")
                        $www[] = $contact->rawdata;

                    if ($contact->type == "fax")
                        $fax[] = $contact->rawdata;
                }

                $objPHPExcel->setActiveSheetIndex(0)
                    ->setCellValue('A' . $firm_number, $firm->id)
                    ->setCellValue('B' . $firm_number, $firm->name)
                    ->setCellValue('C' . $firm_number, $firm->geometry_name . ' ' . $firm->office)
                    ->setCellValue('D' . $firm_number, implode(", ", $phones))
                    ->setCellValue('E' . $firm_number, implode(", ", $emails))
                    ->setCellValue('F' . $firm_number, implode(", ", $www))
                    ->setCellValue('G' . $firm_number, implode(", ", $fax))
                    ->setCellValue('H' . $firm_number, '')
                    ->setCellValue('I' . $firm_number, '');
                $firm_number++;
            }

            $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
            $objWriter->save("./upload/" . iconv("utf-8", "windows-1251", $current_city) . "/" . iconv("utf-8", "windows-1251", $current_category) . "/" . iconv("utf-8", "windows-1251", $current_subcategory) . ".xls");
        }

        $this->render('index');
    }