zk

<?
include 'db.php';

//SELECT d.title AS title_ZK, d.town AS town, b.floors, b.sections, b.corp, b.endingYear, b.endingQuarter, t.title AS townarea, s.title AS street, bt.title AS TypeHouse, GROUP_CONCAT(m.title SEPARATOR ', ') AS metro, nm.timeOnFoot, nm.timeOnCar FROM `buildings` AS b LEFT JOIN `districts` AS d ON b.district = d.id /* Название ЖК -> title , Город -> town, этажи -> floors, секции -> sections, корпус -> corp, срок сдачи -> endingYear, квартал сдачи -> endingQuarter */ LEFT JOIN `townareas` AS t ON d.townarea = t.id /* Район -> title*/ LEFT JOIN `streets` AS s ON b.street = s.id /* улица -> title*/ LEFT JOIN `buildingTypes` AS bt ON b.buildingType = bt.id /* Тип дома -> title */ LEFT JOIN `nearMetros` AS nm ON d.id = nm.district_id /* получаем id метро для ЖК */ LEFT JOIN `metros` AS m ON nm.metro_id = m.id /* метро -> title */ group by title_ZK, corp */

$temp = mysql_query("SELECT d.title AS title_ZK, d.town AS town, b.floors, b.sections, b.corp, b.endingYear, b.endingQuarter, t.title AS townarea, s.title AS street, bt.title AS TypeHouse, GROUP_CONCAT(m.title SEPARATOR ', ') AS metro, nm.timeOnFoot, nm.timeOnCar FROM `buildings` AS b LEFT JOIN `districts` AS d ON b.district = d.id LEFT JOIN `townareas` AS t ON d.townarea = t.id LEFT JOIN `streets` AS s ON b.street = s.id LEFT JOIN `buildingTypes` AS bt ON b.buildingType = bt.id LEFT JOIN `nearMetros` AS nm ON d.id = nm.district_id LEFT JOIN `metros` AS m ON nm.metro_id = m.id group by title_ZK, corp");

$fileopen=fopen("parse-to-bitrix-zk.csv", "w+");
fwrite($fileopen,"IE_XML_ID;IE_NAME;IE_ID;IE_ACTIVE;IE_ACTIVE_FROM;IE_ACTIVE_TO;IE_PREVIEW_PICTURE;IE_PREVIEW_TEXT;IE_PREVIEW_TEXT_TYPE;IE_DETAIL_PICTURE;IE_DETAIL_TEXT;IE_DETAIL_TEXT_TYPE;IE_CODE;IE_SORT;IE_TAGS;IP_PROP397;IP_PROP396;IP_PROP398;IP_PROP389;IP_PROP390;IP_PROP393;IP_PROP392;IP_PROP391;IP_PROP395;IC_GROUP0;IC_GROUP1;IC_GROUP2\n");

for ($i=0; $i<mysql_num_rows($temp); $i++){
	$row = mysql_fetch_object($temp);
	fwrite($fileopen,"{$i};Объект №{$i};{$i};Y;;;;;text;;;text;;500;;{$row->sections};{$row->floors};{$row->metro};{$row->title_ZK};{$row->corp};{$row->town};{$row->townarea};{$row->endingQuarter} кв. {$row->endingYear};{$row->TypeHouse};;;\n");
}
fclose($fileopen);
?>