<?
	include('include/common.inc.php');
	include('nb_specific/common.inc.php');
	include('nb_specific/security.inc.php');
	include('modules/list/list.class.php');
	include('modules/article/article.class.php');
	include('include/filters/newlinefilter.class.php');
	include('include/library/edatabase.inc.php');
	
	global $lang;
	$lang = GetLanguage();
	$type = $_GET['mag'];
	CheckOnlyEnglishText($type);
	
	$year = CheckNumericGetParameter('year');
		
	if ($type == 'phil' || $type == 'PHILHARMONICA' )
	{
	}
	else
	{
		//CheckLanguage($lang, $type, -1, -1, -1, "cross_ref_".$year.".html");		
	}

	$electronic = isset($_GET['el'])? $_GET['el'] : 0;
	
	
//print_r($_GET);

	$pos = strrpos($type,"eng");


		
	/*if ($electronic == 0)
	{
		if ($lang == 2 && $pos === false)
		{
			$type = 'eng'.$type;		
			$type = substr($type , 0 , strlen($type)-2);
		}
		else if ($lang == 1)
		{
			CheckLanguage($lang, $type, -1, -1, -1, "cross_ref_".$year.".html");		
		}
		
		DBConnect();
		$mag_info = GetRecordSet('nb_mag_names', array('*'), "istype='".$type."'");
		
		//print($type);
		$mag_info = @$mag_info[0];
		$id_mag = GetSQLValue('nb_mag_names', 'id_secondary', 'istype="'.$type.'"');
		$mag_info['url_google_scholar'] = GetSQLValue('enotabene.emag_mags','url_google_scholar','id_mag='.$id_mag);
		$mag_info['cross_ref'] = GetSQLValue('enotabene.emag_mags','cross_ref','id_mag='.$id_mag);
		
		$mag_info_e = GetRecordSet('enotabene.emag_mags', array('*'), 'id_mag='.$id_mag);
		$mag_info_e = $mag_info_e[0];	
		DBDisconnect();
			ShowTopPart();
		$side_menu_html = RenderSideMenu($type, -5, 0, 0, $mag_info, $lang, false, 0);
	}
	else*/
	{
		DBConnect();
		$mag_info = GetRecordSet('enotabene.emag_mags', array('*'), "str_id='$type'");
		$mag_info = $mag_info[0];
		$mag_info_e = $mag_info;
		$id_mag = $mag_info['id_mag'];
		DBDisconnect();		
			ShowTopPart();
		$side_menu_html = RenderSideMenu($type, -5, 0, 0, $mag_info, $lang, true, 0);
	}

	$title = $lang == 1 ? "Самые цитируемые статьи в CrossRef": "Most cited articles in CrossRef";
	

	
	DBConnect();
	$years = GetRecordSet('enotabene.emag_issues', array('year'), 'id_mag='.$id_mag.' GROUP BY year ORDER BY year DESC');

	$where = "";
	
	if ($year != 0)
	{
		$where = " AND a.year =".$year;
	}
	
	$articles = new CList('enotabene.emag_articles a LEFT JOIN (SELECT count(*) as cnt, id_article FROM enotabene.emag_crossref GROUP BY id_article) b ON a.id_article = b.id_article', "a.status=7 ANd a.id_mag=".$id_mag." AND b.cnt > 0 ".$where." ORDER BY b.cnt DESC", array('a.id_article','a.id_mag','a.year','a.month','a.title','a.title_eng', 'a.title_cn','a.annotation','a.annotation_eng', 'a.annotation_cn', 'a.authors','a.authors_eng','a.page_start','a.page_end','a.lang_text','a.doi','a.id_rubric','a.is_eng_text_published','a.edn', "b.cnt"), "mag_cross_ref/");
	$articles->SetRecordCountInPage(200);
	$articles->AddConst("side_menu", $side_menu_html);
	$articles->AddConst("title", $title);	
	$articles->AddConst("mag_info", $mag_info_e);
	$articles->AddConst("years", $years);
	$articles->AddConst("current_year", $year);	
	$articles->Show();

	ShowBottomPart(); 	
	
?>