One Hat Cyber Team

View File Name : getit

#!/usr/bin/php

<?
$m = mysqli_connect('localhost','umzh1','7qqRQQ555','umzh1');
mysqli_query($m, "set character_set_results='utf8'");
mysqli_query($m, "SET NAMES 'utf8'");
mysqli_query($m, "SET CHARACTER SET utf8");
mysqli_query($m, "SET SESSION collation_connection = 'utf8_unicode_ci'");

$paperType = "P"; // N - new, R - in review  P - accepted <-----------------------------------------------

$sql = "select * from articles where";
$sql = $sql .  " article_status='$paperType'";
// . " and article_print='N' and (`article_item`='15' or `article_year`='1900')";
$sql = $sql . " and article_id in (" 
// . "11135,11132,11131,11116,11092,11075,11066,11060,11059,11052,11002,10994,10992,10966,10963,10959,"
// . "10954,10952,10944,10940,10939,10934,10928,10927,10909,10904,10892,10851,10847,10844,10829,10824,10823,10811,10809,10774,10773,10767,10763,10751,10739,10725,"
// . "10723,10715,10705,10700,10693,10690,10687,10682,10671,10668,10666,10665,10643,10639,10585,10581,10578,10570,10565,10561,10559,10554,"
// . "10553,10546,10532,10530,10523,10519,10518,10515,10492,10477,10474,10455,10444,10443,10436,10435,10431,10430,10427,10426,10421,10420,10416,10415,10414,10408,10407,10404,"
// . "10382,10371,10361,10360,10355,10350,10344,10343,10319,10315,10299,10242,10234,10232,10228,10227,10226,10203,10147,10146,10143,10139,10138,10137,10115,10107,"
// . "10103,10101,10076,10040,10039,10038,10009,10008,9984,9983,9980,9942,9894,9884,9849,9808,9805,9803,9800,9799,9798,9797,9794,9787,9783,9782,9771,9769,9768,9767,9760,9751,9748,9747,"
// . "9743,9742,9741,9739,9736,9730,9708,9701,9686,9684,9679,9673,9650,9649,9647,9644,9638,9603,9589,9587,9585,9565,9505,9501,9481,9470,9469,9460,"
// . "9458,9457,9456,9452,9301,9278,9269,9262,9256,9247,9217,9215,9205,9204,9203,9194,9189,9185,9184,9182,9174,9154,9148,9137,9115,9111,9098,9091,9087,9086,9083,9061,"
// . "10672,10560,10428,10406,10375,10368," //2020-3
// . "11131,10427," //2020-4
// . "11224,11177,11139,11100,11010,10998,10987,10982,10935,10929,10901,10889,10835,10833,10820,10805,10679,10675,10667,10656,10647,10587,10577,10568,10567,10558,10533,10525,10462,10378,10108,9705,9485,9482,9473,9258,9207,9120," // remaining after AA checks
. "0)"; 
// > 10958 and article_id < 11233"; //<------------------------------------------------

// echo $sql;

$res = mysqli_query($m, $sql);

$out = new DOMDocument;
$out->formatOutput = true;


while ($row = mysqli_fetch_assoc($res)) {
//	print_r($row);

	// Create article
	$article = $out->createElement('article');
	$article->setAttribute("locale", "en_US");
	$article->setAttribute("section_ref", "1");
	$article->setAttribute("stage", "submission");
	$out->appendChild($article);
	
	// Title is the same for all locales
	$title_ua = $out->createElement('title');
	$title_ua->setAttribute('locale','uk_UA');
	$title_ua->nodeValue = $row['article_name_ua'];
	$article->appendChild($title_ua);

	$title_en = $out->createElement('title');
	$title_en->setAttribute('locale','en_US');
	$title_en->nodeValue = $row['article_name_ua'];
	$article->appendChild($title_en);

	// Add empty but not null abstract
	$abstract_ua = $out->createElement('abstract');
	$abstract_ua->setAttribute('locale','uk_UA');
	$abstract_ua->nodeValue = '';
	$article->appendChild($abstract_ua);

	$abstract_en = $out->createElement('abstract');
	$abstract_en->setAttribute('locale','en_US');
	$abstract_en->nodeValue = '';
	$article->appendChild($abstract_en);

	// Authors
	$authors = $out->createElement('authors');
	
	// First author is primary
	$author = $out->createElement('author');

	$author->setAttribute('primary_contact','true');
	$firstname = $out->createElement('firstname');
	$firstname->setAttribute('locale','uk_UA');
	$firstname->nodeValue = ''; //<-----------------------------------------
	$author->appendChild($firstname);
	$firstname = $out->createElement('firstname');
	$firstname->setAttribute('locale','en_US');
	$firstname->nodeValue = ''; //<-----------------------------------------
	$author->appendChild($firstname);

	$lastname = $out->createElement('lastname');
	$lastname->setAttribute('locale','uk_UA');
	$lastname->nodeValue = $row['article_main_author']; //<-----------------------------------------
	$author->appendChild($lastname);
	$lastname = $out->createElement('lastname');
	$lastname->setAttribute('locale','en_US');
	$lastname->nodeValue = $row['article_main_author']; //<-----------------------------------------
	$author->appendChild($lastname);
	$authors->appendChild($author);

	$email = $out->createElement('email');
	$email->nodeValue = $row['article_main_author_email'];
	$author->appendChild($email);

	// Second author contains all names

//	$author = $out->createElement('author');
//	$author->setAttribute('primary_contact','false');
//	$firstname = $out->createElement('firstname');
//	$firstname->setAttribute('locale','uk_UA');
//	$firstname->nodeValue = ''; //<-----------------------------------------
//	$author->appendChild($firstname);
//	$firstname = $out->createElement('firstname');
//	$firstname->setAttribute('locale','en_US');
//	$firstname->nodeValue = ''; //<-----------------------------------------
//	$author->appendChild($firstname);
//
//	$lastname = $out->createElement('lastname');
//	$lastname->setAttribute('locale','uk_UA');
//	$lastname->nodeValue = $row['article_author_ua']; //<-----------------------------------------
//	$author->appendChild($lastname);
//	$lastname = $out->createElement('lastname');
//	$lastname->setAttribute('locale','en_US');
//	$lastname->nodeValue = $row['article_author_ua']; //<-----------------------------------------
//	$author->appendChild($lastname);
//	$authors->appendChild($author);
//
//	$email = $out->createElement('email');
//	$email->nodeValue = 'nobody@nowhere.net';
//	$author->appendChild($email);
//	$authors->appendChild($author);

	$article->appendChild($authors);

	// Article id
	$id = $out->createElement('id');
	$id->nodeValue = $row['article_id'];
	$article->appendChild($id);
	
	
	// Date
	
	$date = $row['article_date'];
	list($year, $month, $day) = explode('-', $date);
	
	// File contents
	
	$basepath = '/var/www/vhost/umj/admin-editor/submit-pdf/';
	$dirpath = $basepath . $year . '/' . $month . '/';
	$files = glob($dirpath . 'aticle' . $row['article_id'] .'*.pdf');
	$revision = 1;
	foreach($files as $path){
		$filename = basename($path);
		$size = filesize($path);
		$contents = file_get_contents($path);
	
		$submission = $out->createElement('submission_file');
		$submission->setAttribute('filename', $filename);
		$submission->setAttribute('date_uploaded', $date);
		$submission->setAttribute('filesize', $size);
		$submission->setAttribute('revision', $revision);

		$name = $out->createElement('name');
		$name->setAttribute('locale', 'uk_UA');
		$name->nodeValue = 'Імпортовано: ' . $filename;
		$submission->appendChild($name);
	
		$name = $out->createElement('name');
		$name->setAttribute('locale', 'en_US');
		$name->nodeValue = 'Imported: ' . $filename;
		$submission->appendChild($name);
	
		$embed = $out->createElement('embed');
		$embed->setAttribute('encoding', 'base64');
		$embed->nodeValue = base64_encode($contents);
		$submission->appendChild($embed);

		$article->appendChild($submission);
		$revision++;
	}

	// Assigned editor
	$editor = $out->createElement('editor');
	$editor->nodeValue = $row['article_managing_editor'];
	if($row['article_managing_editor']){
		$article->appendChild($editor);
	}
	

	// Various notes
	// Id
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Реєстраційний №');
	$paperId = $row['article_id'];
	$link = '<a href="http://umj-old.imath.kiev.ua/admin-editor/articles/index.php?type=1';
	$link .= '&item=' . $paperType . '&id=' . $paperId . '">';
	$link .= $date . '-' . $paperId;
	$link .= '</a>';
//echo $link; die;
	$note->nodeValue = urlencode($link);
	$article->appendChild($note);
	
	// Selected by author
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Вибраний автором редактор');
	$note->nodeValue = $row['article_editor_selected'];
	if($row['article_editor_selected']){
		$article->appendChild($note);
	}

	// Author comments
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Коментарі автора');
	$note->nodeValue = htmlspecialchars($row['article_comments']);
	if($row['article_comments']){
		$article->appendChild($note);
	}
	
	// Forward to editor
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Порадити іншого редактора');
	$note->nodeValue = $row['article_other_editor'];
	if($row['article_other_editor']){
		$article->appendChild($note);
	}
	
	// Editor comments
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Коментарі відповідального редактора');
	$note->nodeValue = $row['article_managing_editor_comments'];
	if($row['article_managing_editor_comments']){
		$article->appendChild($note);
	}
	
	// Assign reviewer
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Рекомендовано рецензента');
	$note->nodeValue = $row['article_recommend_reviewer'];
	if($row['article_recommend_reviewer']){
		$article->appendChild($note);
	}
	
	// Editor comments
	$note = $out->createElement('note');
	$note->setAttribute('title', 'Коментарі редакції');
	$note->nodeValue = $row['article_referee_comments'];
	if($row['article_referee_comments']){
		$article->appendChild($note);
	}
	

}

echo $out->saveXML();

?>