<?

require_once('../functions.php');
$pdo = new PDO( 
    'mysql:host=localhost;dbname=journal', 
    'journal', 
    'journal', 
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") 
);

function zamiana($tekst)
{
   $tabela = Array(
   //WIN
        "\xb9" => "a", "\xa5" => "A", "\xe6" => "c", "\xc6" => "C",
        "\xea" => "e", "\xca" => "E", "\xb3" => "l", "\xa3" => "L",
        "\xf3" => "o", "\xd3" => "O", "\x9c" => "s", "\x8c" => "S",
        "\x9f" => "z", "\xaf" => "Z", "\xbf" => "z", "\xac" => "Z",
        "\xf1" => "n", "\xd1" => "N",
   //UTF
        "\xc4\x85" => "a", "\xc4\x84" => "A", "\xc4\x87" => "c", "\xc4\x86" => "C",
        "\xc4\x99" => "e", "\xc4\x98" => "E", "\xc5\x82" => "l", "\xc5\x81" => "L",
        "\xc3\xb3" => "o", "\xc3\x93" => "O", "\xc5\x9b" => "s", "\xc5\x9a" => "S",
        "\xc5\xbc" => "z", "\xc5\xbb" => "Z", "\xc5\xba" => "z", "\xc5\xb9" => "Z",
        "\xc5\x84" => "n", "\xc5\x83" => "N",
   //ISO
        "\xb1" => "a", "\xa1" => "A", "\xe6" => "c", "\xc6" => "C",
        "\xea" => "e", "\xca" => "E", "\xb3" => "l", "\xa3" => "L",
        "\xf3" => "o", "\xd3" => "O", "\xb6" => "s", "\xa6" => "S",
        "\xbc" => "z", "\xac" => "Z", "\xbf" => "z", "\xaf" => "Z",
        "\xf1" => "n", "\xd1" => "N");

   return strtr($tekst,$tabela);
}

$id_artykuly = 403;
$id_artykuly = $_GET['id_artykuly'];

$query = 'SELECT * FROM artykuly JOIN rozdzialy USING(id_rozdzialy) JOIN zeszyty USING(id_zeszyty) WHERE id_artykuly='.$id_artykuly;
$result = $pdo->query($query);
$row = $result->fetch();


$query = 'SELECT * FROM art_aut JOIN autorzy USING(id_autorzy) WHERE id_artykuly='.$row['id_artykuly'].' ORDER BY kolejnosc_autorzy ASC';
$result2 = $pdo->query($query);
$autorzy = array();
$autorzy2 = array();
$i=0;
foreach ($result2 as $row2) {
	$autorzy[] = trim($row2['nazwisko'].', '.$row2['imie']);
	$autorzy2[] = trim($row2['nazwisko']);
	if ($i==0) {
		$autor = trim($row2['nazwisko'].' '.$row2['inic'].' '.$row['rok']);
		$id_autorzy1 = $row2['id_autorzy'];
	}
	$i++;
}
$autorzys = zamiana(implode(' and ',$autorzy));
$autorzy2s = zamiana(implode('_',$autorzy2));
$autorzy2s = $autorzy2s.'_'.$row['rok'];

$query = 'SELECT * FROM art_klucz JOIN kluczowe USING(id_kluczowe) WHERE id_artykuly='.$id_artykuly;
$result3 = $pdo->query($query);
$keywords = array();
foreach ($result3 as $row3) {
	$keywords[] = trim($row3['slowo']);
}
$keywordss = implode(', ',$keywords);


//dodanie numerku na końcu bibtex'a
$query = 'SELECT * FROM art_aut JOIN artykuly USING(id_artykuly) JOIN rozdzialy USING(id_rozdzialy) JOIN zeszyty USING(id_zeszyty) WHERE rok='.$row['rok'].' AND id_autorzy='.$id_autorzy1;
$result4 = $pdo->query($query);
$row_count = $result4->rowCount();
if ($row_count>1) {
	$ir4 = 1;
	foreach ($result4 as $row4) {
		if ($row4['id_artykuly']==$row['id_artykuly']) {
			$autorzy2s .= '_'.$ir4;
		}
		$ir4++;
	}
}


//$skrot = (str_replace(' ','_',(substr($row['title'],0,strpos($row['title']," ",30))))).'_'.$nazw.','.$row['id_zeszyty'].','.$row['id_artykuly'].'.html';
//$html = 'http://www.transnav.eu/Article_'.$skrot;
$html = artykul_link($pdo,$id_artykuly);
$html = zamiana($html);

//header('Content-Type: text/plain',true);
header('Content-Disposition: attachment; filename="'.$autor.'.bib"');

echo "@article{".$autorzy2s.",\r\n";
echo "\tauthor = {".$autorzys."},\r\n";
echo "\ttitle = {".$row['title']."},\r\n";
echo "\tjournal = {TransNav, the International Journal on Marine Navigation and Safety of Sea Transportation},\r\n";
echo "\tvolume = {".$row['vol']."},\r\n";
echo "\tnumber = {".$row['number']."},\r\n";
echo "\tpages = {".$row['page_start']."-".$row['page_stop']."},\r\n";
echo "\tyear = {".$row['rok']."},\r\n";
echo "\turl = {".$html."},\r\n";
echo "\tabstract = {".(zamiana($row['abstract']))."},\r\n";
if (!is_null($row['doi'])) echo "\tdoi = {".($row['doi'])."},\r\n";
echo "\tissn = {2083-6473},\r\n";
echo "\tpublisher = {Gdynia Maritime University, Faculty of Navigation},\r\n";
echo "\tkeywords = {".(zamiana($keywordss))."}\r\n";
echo "}";
?>