<?
	include('include/common.inc.php');
	include('nb_specific/common.inc.php');
	include('include/library/common.inc.php');
	include('nb_specific/security.inc.php');
	include('modules/article/article.class.php');
	include('include/filters/issuesrus.class.php');
	include('include/filters/issueseng.class.php');
	include('include/filters/transliterate.class.php');
	include('include/filters/transliterateifneeded.class.php');
	include('include/filters/newlinefilter.class.php');
	include('include/filters/doifilter.class.php');
	
	$id = GetNumericIDOrDie();
	
	DBConnect();
	
	$id_user = 0;
	$id_coauthor = 0;
	$user_name = "";
	
	if (isset($_GET['id_user']))
	{
		//$id_user = $_GET['id_user'];
		$id_user = CheckNumericGetParameter('id_user');
		$articles = GetRecordSet('enotabene.emag_articles', array('id_article'), 'id_user='.$id_user.' AND id_article != '.$id.' AND status = 7');
		
		$user = GetRecordSet('enotabene.emag_users', array('*'), 'id_user='.$id_user);

		if (count($user))
		{
			$user = $user[0];
			if (GetLanguage() == 1)
				$user_name 	= $user['surname']." ".$user['name']." ".$user['middlename'];
			else
				$user_name 	= $user['surname_eng']." ".$user['name_eng']." ".$user['middlename_eng'];
		}
				
	}
	else if (isset($_GET['id_coauthor']))
	{
		//$id_coauthor = $_GET['id_coauthor'];
		$id_coauthor = CheckNumericGetParameter('id_coauthor');
		$other_articles = GetRecordSet('enotabene.emag_coauthors_by_article', array('*'), 'id_coauthor='.$id_coauthor.' AND id_article !='.$id);

		for($j = 0; $j < count($other_articles); $j++)
		{
			$status = GetSQLValue('enotabene.emag_articles', 'status', 'id_article='.$other_articles[$j]['id_article']);
				
			if ($status == 7)
			{
				$article = GetRecordSet('enotabene.emag_articles', array('id_article'), 'id_article = '.$other_articles[$j]['id_article']);
				
				if (count($article)>0)
					$articles[] = $article[0];
			}
		}

		$user = GetRecordSet('enotabene.emag_coauthors', array('*'), 'id_coauthor='.$id_coauthor);

		if (count($user))
		{
			$user = $user[0];
			if (GetLanguage() == 1)
				$user_name 	= $user['surname']." ".$user['name']." ".$user['middlename'];
			else
				$user_name 	= $user['surname_eng']." ".$user['name_eng']." ".$user['middlename_eng'];
		}		
	}	
	
	if (count($articles) == 0)
		die();
	
	$articles_ids_str = "";
	
	for($i=0; $i< count($articles); $i++)
	{
		if ($articles_ids_str != "")
			$articles_ids_str .=",";
		
		$articles_ids_str .= $articles[$i]['id_article'];
	}
	
	$id_mag = GetSQLValue('enotabene.emag_articles', 'id_mag', 'id_article='.$id);
	$year = GetSQLValue('enotabene.emag_articles', 'year', 'id_article='.$id);
	$month = GetSQLValue('enotabene.emag_articles', 'month', 'id_article='.$id);
	$mag = GetSQLValue('enotabene.emag_mags', 'str_id', 'id_mag='.$id_mag);
	
	
	//print_r($articles_ids_str);
	
	ShowTopPart();
	
	$articles = new CList('enotabene.emag_articles a', 'a.id_article IN ('.$articles_ids_str.') ORDER BY a.year DESC,a.month DESC', 
		array("a.id_article","a.year","a.month","a.doi", "a.title", "a.authors", "a.annotation", "a.title_eng", "a.annotation_eng", "a.page_start", "a.lang_text", 
			"a.page_end", "a.printed", "a.free", "a.uploaded", "a.id_mag", "a.authors_eng","a.id_secondary"), 'author_other_publication/');
			
	$articles->AddHelperQuery('SELECT title as mag_title FROM enotabene.emag_mags WHERE id_mag = {id_mag}');
	$articles->AddHelperQuery('SELECT eprinted FROM enotabene.emag_mags WHERE id_mag = {id_mag}');	

	$articles->AddHelperQuery('SELECT title_eng as mag_title_eng FROM enotabene.emag_mags WHERE id_mag = {id_mag}');
	$articles->AddHelperQuery('SELECT str_id as mag_str_id FROM enotabene.emag_mags WHERE id_mag = {id_mag}');
	$articles->AddHelperQuery('SELECT issn as mag_issn FROM enotabene.emag_mags WHERE id_mag = {id_mag}');

	//$articles->AddHelperQuery('SELECT id_order as id_order_payed_subscribe FROM emag_orders WHERE id_article={id_article} AND order_type=22 AND id_user='.$_SESSION['id_user'].' AND is_payed=1');
	$articles->AddConst('mag', $mag);
	$articles->AddConst('user_name', $user_name);
	
	//$articles->AddFieldFilter('annotation', new CAnnotationFilter());
	//$articles->AddFieldFilter('annotation_eng', new CAnnotationFilter());
	if (GetLanguage() == 2)
	{
		$articles->AddFieldFilter("authors", new CTransliterateIfNeededFilter());
	}
	$articles->AddFieldFilter("authors_eng", new CTransliterateIfNeededFilter());
	$articles->AddFieldFilter('doi', new CDoiFilter());
	$articles->SetRecordCountInPage(240);
	$articles->Show();
	
	ShowBottomPart();
?>