<?
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, m.title 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 */

$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, m.title 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");

// $fileopen=fopen("parse-to-bitrix.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");
/*
44976;тест1;44976;Y;;;;;text;;;text;;500;;3;8;Проспект Ветеранов;Английская миля;35;СПБ;Красносельский;2017;Монолит;;;

44976;тест1;44976;Y;;;;;text;;;text;;500;;кол-во секций;кол-во этажей;метро;название ЖК;название корпуса;населенный пункт/город;район;квартал и год сдачи;тип дома;;;
*/
for ($i=0; $i<mysql_num_rows($temp); $i++){
	$row = mysql_fetch_object($temp);
	// fwrite($fileopen,
	echo ("{$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);
?>