<?
ini_set('post_max_size', '64M');
ini_set('upload_max_filesize', '64M');
set_time_limit(0);

require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_before.php");

$APPLICATION->SetTitle($_SESSION["LANG"] == CGeoCountryTable::LANG_RU ? "Скачать файл" : "Download PDF");

$id_str = isset($_GET['ID']) ? trim($_GET['ID']) : false;
$title = isset($_GET['title']) ? trim($_GET['title']) : 'Проекты';
$pstfx = CGeoHelper::GetModelFieldKey();

if($id_str) {
    $ids = explode(',', $id_str);

	$filterWhere[] = 't.ACTIVE = 1';
	$filterWhere[] = '(badge.ACTIVE = 1 OR b.BADGE_ID IS NULL)';
	$idsSql = "SELECT COUNT(b.ID) as BCNT, t.ID FROM ctc_project as t " .
        "LEFT JOIN ctc_project_territory as tr ON tr.PROJECT_ID = t.ID " .
        "LEFT JOIN ctc_project_badge as b ON b.PROJECT_ID = t.ID " .
        "LEFT JOIN ctc_badge as badge ON badge.ID = b.BADGE_ID " .
        "LEFT JOIN ctc_project_format as f ON f.PROJECT_ID = t.ID " .
        "LEFT JOIN ctc_project_genre as g ON g.PROJECT_ID = t.ID " .
        "LEFT JOIN ctc_project_category as c ON c.PROJECT_ID = t.ID " .
        "LEFT JOIN ctc_project_channel as ch ON ch.PROJECT_ID = t.ID " .
        "LEFT JOIN ctc_project_year as y ON y.PROJECT_ID = t.ID " .
        ($filterWhere ? ("WHERE ".implode(" AND ", $filterWhere)) : "").
        " GROUP BY t.ID ORDER BY BCNT DESC, t.NAME".$loc." ASC";
	$rs = $DB->Query($idsSql);
	$allIDs = array();
	while($ar = $rs->Fetch()) $allIDs[] = $ar["ID"];

	$diff = array_diff($allIDs, $ids);
	if($diff) {
		$pdf = new CPDFHelper('', 'A4-L');
		$pdf->AddMeta();
		$pdf->makeHeader();
		$pdf->addProjects($ids, $pstfx);
		$pdf->makeFooter();
		$pdf->Output($title . '.pdf', 'D');
	} else {
		$locales = array('' => 'Все_проекты', '_EN' => 'All_projects');
		LocalRedirect('/pdf/'.$locales[$pstfx].'.pdf');
	}
} else {
    LocalRedirect("/project/");
}
?>