/**
* Imports the given article file
* @param int $pkpArticleFile ID of the old article file
* @param int $oldArticleId ID of the old article
* @param Article $article Newly imported Article entity
* @param string $slug Journal's slug
*/
public function importArticleFile($pkpArticleFile, $oldArticleId, $article, $slug)
{
$this->consoleOutput->writeln("Reading article file #" . $pkpArticleFile['file_id'] . "... ", true);
$galleysSql = "SELECT galley_id, article_id, locale, label FROM article_galleys " . "WHERE article_id = :article_id AND file_id = :id";
$galleysStatement = $this->dbalConnection->prepare($galleysSql);
$galleysStatement->bindValue('article_id', $oldArticleId);
$galleysStatement->bindValue('id', $pkpArticleFile['file_id']);
$galleysStatement->execute();
$pkpGalleys = $galleysStatement->fetchAll();
foreach ($pkpGalleys as $galley) {
$locale = !empty($galley['locale']) ? mb_substr($galley['locale'], 0, 2, 'UTF-8') : 'en';
$label = !empty($galley['label']) ? $galley['label'] : '-';
$version = !empty($pkpArticleFile['revision']) ? $pkpArticleFile['revision'] : 0;
$filename = sprintf('imported/%s/%s.%s', $galley['article_id'], $galley['galley_id'], FileHelper::$mimeToExtMap[$pkpArticleFile['file_type']]);
$articleFile = new ArticleFile();
$articleFile->setFile($filename);
$articleFile->setArticle($article);
$articleFile->setVersion($version);
$articleFile->setTitle($label);
$articleFile->setLangCode($locale);
$articleFile->setDescription('-');
$articleFile->setType(ArticleFileParams::FULL_TEXT);
$history = $this->em->getRepository(FileHistory::class)->findOneBy(['fileName' => $filename]);
if (!$history) {
$history = new FileHistory();
$history->setFileName($filename);
$history->setOriginalName($pkpArticleFile['original_file_name']);
$history->setType('articlefiles');
$this->em->persist($history);
}
$source = sprintf('%s/article/download/%s/%s', $slug, $galley['article_id'], $galley['galley_id']);
$target = sprintf('/../web/uploads/articlefiles/imported/%s/%s.%s', $galley['article_id'], $galley['galley_id'], FileHelper::$mimeToExtMap[$pkpArticleFile['file_type']]);
$pendingDownload = new PendingDownload();
$pendingDownload->setSource($source);
$pendingDownload->setTarget($target);
$this->em->persist($pendingDownload);
$this->em->persist($articleFile);
}
}
/**
* @param Article $article New article entity
* @param array $row Supp file row from the source database
* @param integer $oldArticleId Old ID of the article
* @param string $oldJournalSlug Slug of the article's journal
*/
public function importSupFile(Article $article, $row, $oldArticleId, $oldJournalSlug)
{
$settings = $this->getSettings($row["supp_id"]);
if (empty($settings)) {
return;
}
$accessor = PropertyAccess::createPropertyAccessor();
$code = $article->getJournal()->getMandatoryLang()->getCode();
$settings = empty($settings[$code]) ? current($settings) : $settings[$code];
$fileFormat = "imported/supplementary/%s/%s.%s";
$extension = !empty($row["file_type"]) ? $accessor->getValue(FileHelper::$mimeToExtMap, "[" . $row["file_type"] . "]") : "";
$filename = sprintf($fileFormat, $oldArticleId, $row["file_id"], $extension);
$keywords = mb_substr($accessor->getValue($settings, "[subject]"), 0, 255);
$file = new ArticleFile();
$file->setVersion(0);
$file->setLangCode($code);
$file->setFile($filename);
$file->setArticle($article);
$file->setKeywords($keywords);
$file->setType(ArticleFileParams::SUPPLEMENTARY_FILE);
$file->setTitle($accessor->getValue($settings, "[title]"));
$file->setDescription($accessor->getValue($settings, "[description]"));
$history = $this->em->getRepository(FileHistory::class)->findOneBy(["fileName" => $filename]);
if (!$history) {
$history = new FileHistory();
$history->setFileName($filename);
$history->setType("articlefiles");
$history->setOriginalName($row["original_file_name"]);
$this->em->persist($history);
}
$source = sprintf("%s/article/downloadSuppFile/%s/%s", $oldJournalSlug, $oldArticleId, $row["supp_id"]);
$target = sprintf("/../web/uploads/articlefiles/%s", $filename);
$download = new PendingDownload();
$download->setSource($source);
$download->setTarget($target);
$this->em->persist($file);
$this->em->persist($download);
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$output->writeln('Creating sample data...');
$em = $this->getContainer()->get('doctrine')->getManager();
$manipulator = $this->getContainer()->get('fos_user.util.user_manipulator');
$manipulator->create('sample_author', 'author', '*****@*****.**', false, false);
$user = $em->getRepository('OjsUserBundle:User')->findOneBy(['username' => 'sample_author']);
$announcement = new AdminAnnouncement();
$announcement->setTitle('We are online!');
$announcement->setContent('We are now online and accepting submissions!');
$em->persist($announcement);
$em->flush();
$post = new AdminPost();
$post->setCurrentLocale('en');
$post->setTitle('Welcome to OJS!');
$post->setSlug('Welcome to OJS!');
$post->setContent('Hello! We are now online and waiting for your submissions. ' . 'Our readers will be able to follow you and read your work ' . 'right after it gets published!');
$em->persist($post);
$em->flush();
$publisherTypes = ['University', 'Government', 'Association', 'Foundation', 'Hospital', 'Chamber', 'Private'];
foreach ($publisherTypes as $typeName) {
$publisherType = new PublisherTypes();
$publisherType->setCurrentLocale('en');
$publisherType->setName($typeName);
$em->persist($publisherType);
}
$em->flush();
$slug = $this->getContainer()->getParameter('defaultPublisherSlug');
$publisherType = $em->getRepository('OjsJournalBundle:PublisherTypes')->find(1);
$publisher = new Publisher();
$publisher->setCurrentLocale('en');
$publisher->setName('OJS');
$publisher->setSlug($slug);
$publisher->setEmail('*****@*****.**');
$publisher->setAddress('First Avenue, Exampletown');
$publisher->setPhone('+908501234567');
$publisher->setVerified(1);
$publisher->setStatus(PublisherStatuses::STATUS_COMPLETE);
$publisher->setPublisherType($publisherType);
$em->persist($publisher);
$em->flush();
$subject1 = new Subject();
$subject1->setCurrentLocale('en');
$subject1->setSubject('Computer Science');
$subject1->setTags('computer, science');
$subject2 = new Subject();
$subject2->setCurrentLocale('en');
$subject2->setSubject('Journalism');
$subject2->setTags('journalism');
$em->persist($subject1);
$em->persist($subject2);
$em->flush();
$language1 = new Lang();
$language1->setCurrentLocale('en');
$language1->setName('English');
$language1->setCode('en');
$language1->setRtl(false);
$language2 = new Lang();
$language2->setCurrentLocale('tr');
$language2->setName('Türkçe');
$language2->setCode('tr');
$language2->setRtl(false);
$em->persist($language1);
$em->persist($language2);
$em->flush();
$articleTypes = [['Case Report', 'Olgu Sunumu'], ['Research papers', 'Araştırma Makalesi'], ['Translation', 'Çeviri'], ['Note', 'Not'], ['Letter', 'Editöre Mektup'], ['Review Articles', 'Derleme'], ['Book review', 'Kitap İncelemesi'], ['Correction', 'Düzeltme'], ['Editorial', 'Editoryal'], ['Short Communication', 'Kısa Bildiri'], ['Meeting abstract', 'Toplantı Özetleri'], ['Conference Paper', 'Konferans Bildirisi'], ['Biography', 'Biyografi'], ['Bibliography', 'Bibliyografi'], ['News', 'Haber'], ['Report', 'Rapor'], ['Legislation Review', 'Yasa İncelemesi'], ['Decision Review', 'Karar İncelemesi'], ['Art and Literature', 'Sanat ve Edebiyat'], ['Other', 'Diğer']];
foreach ($articleTypes as $typeNames) {
$type = new ArticleTypes();
$type->setCurrentLocale('en');
$type->setName($typeNames[0]);
$type->setCurrentLocale('tr');
$type->setName($typeNames[1]);
$em->persist($type);
}
$em->flush();
$contactTypes = ['Journal Contact', 'Primary Contact', 'Technical Contact', 'Author Support', 'Subscription Support', 'Publisher Support', 'Submission Support', 'Advertising', 'Media', 'Editor', 'Co-Editor'];
foreach ($contactTypes as $typeName) {
$type = new ContactTypes();
$type->setCurrentLocale('en');
$type->setName($typeName);
$em->persist($type);
}
$em->flush();
$journal = new Journal();
$journal->setCurrentLocale('en');
$journal->setPublisher($publisher);
$journal->setTitle('Introduction to OJS');
$journal->setSubtitle('How to use OJS');
$journal->setDescription('A journal about OJS');
$journal->setTitleAbbr('INTROJS');
$journal->setUrl('http://ojs.io');
$journal->setSlug('intro');
$journal->addSubject($subject1);
$journal->addSubject($subject2);
$journal->addLanguage($language1);
$journal->addLanguage($language2);
$journal->setMandatoryLang($language2);
$journal->setFounded(new \DateTime('now'));
$journal->setIssn('1234-5679');
$journal->setEissn('1234-5679');
$journal->setStatus(JournalStatuses::STATUS_PUBLISHED);
$journal->setPublished(1);
$em->persist($journal);
$em->flush();
$this->createDemoFiles();
$issueFile = new IssueFile();
$issueFile->setCurrentLocale('en');
$issueFile->setTitle('Demo File');
$issueFile->setDescription('A file');
$issueFile->setFile('issue.txt');
$issueFile->setLangCode('en');
$issueFile->setType(0);
$issueFile->setVersion(0);
$issueFile->setUpdatedBy($user->getUsername());
$issueFileHistory = new FileHistory();
$issueFileHistory->setFileName('issue.txt');
$issueFileHistory->setOriginalName('issue.txt');
$issueFileHistory->setType('issuefiles');
$em->persist($issueFile);
$em->persist($issueFileHistory);
$em->flush();
$issue = new Issue();
$issue->setCurrentLocale('en');
$issue->setJournal($journal);
$issue->setTitle('First Issue: Hello OJS!');
$issue->setDescription('First issue of the journal');
$issue->setNumber(1);
$issue->setVolume(1);
$issue->setYear(2015);
$issue->setSpecial(1);
$issue->setDatePublished(new \DateTime('now'));
$issue->setTags('first, guide, tutorial');
$issue->setDatePublished(new \DateTime('now'));
$issue->addIssueFile($issueFile);
$em->persist($issue);
$em->flush();
$section = new Section();
$section->setCurrentLocale('en');
$section->setJournal($journal);
$section->setTitle('Tutorials');
$section->setHideTitle(0);
$section->setAllowIndex(1);
$em->persist($section);
$em->flush();
$citation1 = new Citation();
$citation1->setCurrentLocale('en');
$citation1->setRaw('The Matrix [Motion picture]. (2001). Warner Bros. Pictures.');
$citation1->setOrderNum(0);
$em->persist($citation1);
$em->flush();
$articleFile = new ArticleFile();
$articleFile->setCurrentLocale('en');
$articleFile->setTitle('Demo File');
$articleFile->setDescription('A file');
$articleFile->setFile('article.txt');
$articleFile->setLangCode('en');
$articleFile->setType(0);
$articleFile->setVersion(0);
$articleFile->setUpdatedBy($user->getUsername());
$articleFileHistory = new FileHistory();
$articleFileHistory->setFileName('article.txt');
$articleFileHistory->setOriginalName('article.txt');
$articleFileHistory->setType('articlefiles');
$em->persist($articleFile);
$em->persist($articleFileHistory);
$em->flush();
$author = new Author();
$author->setCurrentLocale('en');
$author->setTitle('Dr.');
$author->setFirstName('John');
$author->setLastName('Doe');
$author->setEmail('*****@*****.**');
$em->persist($author);
$em->flush();
$article1 = new Article();
$article1->setCurrentLocale('en');
$article1->setJournal($journal);
$article1->setSection($section);
$article1->setIssue($issue);
$article1->setTitle('Getting Started with OJS');
$article1->setAbstract('A tutorial about using OJS');
$article1->setSubjects('OJS');
$article1->setKeywords('ojs, intro, starting');
$article1->setDoi('10.5281/zenodo.14791');
$article1->setSubmissionDate(new \DateTime('now'));
$article1->setPubdate(new \DateTime('now'));
$article1->setAnonymous(0);
$article1->setFirstPage(1);
$article1->setLastPage(5);
$article1->setStatus(ArticleStatuses::STATUS_PUBLISHED);
$article1->addCitation($citation1);
$article1->addArticleFile($articleFile);
$em->persist($article1);
$em->flush();
$articleAuthor = new ArticleAuthor();
$articleAuthor->setAuthor($author);
$articleAuthor->setArticle($article1);
$articleAuthor->setAuthorOrder(0);
$em->persist($articleAuthor);
$em->flush();
$checklistItems = [['The title page should include necessary information.', "<ul>\n <li>The name(s) of the author(s)</li>\n <li>A concise and informative title</li>\n <li>The affiliation(s) of the author(s)</li>\n <li>The e-mail address, telephone number of the corresponding author </li>\n </ul>"], ['Manuscript must be approved.', 'All authors must have read and approved the most recent version of the manuscript.'], ['Manuscript must be <i>spell checked</i>.', 'The most recent version of the manuscript must be spell checked.']];
foreach ($checklistItems as $checklistItem) {
$label = $checklistItem[0];
$detail = $checklistItem[1];
$item = new SubmissionChecklist();
$item->setLabel($label);
$item->setDetail($detail);
$item->setLocale('en');
$item->setJournal($journal);
$em->persist($item);
}
$em->flush();
$periods = ['Monthly', 'Bimonthly', 'Quarterly', 'Triquarterly', 'Biannually', 'Annually', 'Spring', 'Summer', 'Fall', 'Winter'];
foreach ($periods as $period) {
$journalPeriod = new Period();
$journalPeriod->setCurrentLocale('en');
$journalPeriod->setPeriod($period);
$em->persist($journalPeriod);
}
$em->flush();
}
/**
* Edits an existing Article entity.
*
* @param Request $request
* @param int $id
* @return RedirectResponse|Response
*/
public function updateAction(Request $request, $id)
{
$journal = $this->get('ojs.journal_service')->getSelectedJournal();
/** @var Article $entity */
$em = $this->getDoctrine()->getManager();
$entity = $em->getRepository('OjsJournalBundle:Article')->findOneBy(array('journal' => $journal, 'id' => $id));
$this->throw404IfNotFound($entity);
if (!$this->isGranted('EDIT', $entity->getJournal(), 'articles')) {
throw new AccessDeniedException("You not authorized for this page!");
}
$editForm = $this->createEditForm($entity, $journal);
$editForm->handleRequest($request);
if ($editForm->isValid()) {
$header = $request->request->get('header');
if ($header) {
$entity->setHeaderOptions(json_encode($header));
}
$files = $request->request->get('articlefiles', []);
$fileHelper = new FileHelper();
foreach ($files as $file) {
$file_entity = new File();
$file_entity->setName($file);
$imagepath = $this->get('kernel')->getRootDir() . '/../web/uploads/articlefiles/' . $fileHelper->generatePath($file, false);
$file_entity->setSize(filesize($imagepath . $file));
$file_entity->setMimeType(mime_content_type($imagepath . $file));
$file_entity->setPath('/uploads/articlefiles/' . $fileHelper->generatePath($file, false));
$em->persist($file_entity);
$articleFile = new ArticleFile();
$articleFile->setArticle($entity);
$articleFile->setFile($file_entity);
$articleFile->setType(0);
// TODO: See ArticleFileParams::$FILE_TYPES
$articleFile->setVersion(1);
$articleFile->setLangCode('tr');
// TODO: Don't use hardcoded locale
$em->persist($articleFile);
$entity->addArticleFile($articleFile);
}
$em->flush();
$this->successFlashBag('successful.update');
return $this->redirect($this->generateUrl('ojs_journal_article_edit', array('id' => $id, 'journalId' => $journal->getId())));
}
return $this->render('OjsJournalBundle:Article:edit.html.twig', ['entity' => $entity, 'edit_form' => $editForm->createView()]);
}