protected function execute(InputInterface $input, OutputInterface $output)
{
parent::execute($input, $output);
$um = $this->getContainer()->get('fos_user.user_manager');
$locale = $this->getContainer()->getParameter('locale');
$tokenGenrator = $this->getContainer()->get('fos_user.util.token_generator');
$ui = new UserImporter($this->connection, $this->em, $this->logger, $output, $um, $tokenGenrator, $locale);
$ii = new IssueImporter($this->connection, $this->em, $this->logger, $output);
$ai = new ArticleImporter($this->connection, $this->em, $this->logger, $output, $ui);
$oldIssueId = $input->getArgument('id');
$journalId = $input->getArgument('journal');
if (is_numeric($journalId)) {
$journal = $this->em->find('OjsJournalBundle:Journal', $journalId);
} else {
$journal = $this->em->getRepository(Journal::class)->findOneBy(['slug' => $journalId]);
}
if (!$journal) {
$output->writeln('<error>Journal does not exist.</error>');
return;
}
$sectionRepo = $this->em->getRepository(Section::class);
$currentSectionIds = array_column($sectionRepo->getIdsByJournal($journal), 'id');
$ii->importIssues([['issue_id' => $oldIssueId]], $journal->getId(), $currentSectionIds);
$mapRepo = $this->em->getRepository(ImportMap::class);
if (!$input->getOption('without-articles')) {
$sql = "SELECT article_id FROM published_articles WHERE issue_id = ?";
$articleIds = $this->connection->executeQuery($sql, [$oldIssueId])->fetchAll();
$oldSectionIds = $mapRepo->getSectionIds($journal);
if (empty($oldSectionIds) && !empty($currentSectionIds)) {
$oldSectionIds = $currentSectionIds[0];
}
$ai->importArticles($articleIds, $journal->getId(), $oldSectionIds, $mapRepo->getIssueIds($journal));
}
}
/**
* @param OutputInterface $output
* @return array
* @throws \Doctrine\DBAL\DBALException
* @throws \Doctrine\ORM\ORMException
*/
protected function syncIssues(OutputInterface $output)
{
$ii = new IssueImporter($this->connection, $this->em, $this->logger, $output, $this->ui);
$importRepo = $this->em->getRepository(ImportMap::class);
$journalMaps = $importRepo->findBy(['type' => Journal::class]);
$createdIssueIds = [];
/** @var ImportMap $journalMap */
foreach ($journalMaps as $journalMap) {
$output->writeln('Synchronizing #' . $journalMap->getNewId());
$journalRef = $this->em->getReference(Journal::class, $journalMap->getNewId());
$importedIssueIds = null;
$importedIssues = array_values($this->em->createQueryBuilder()->select('map.oldId')->from(ImportMap::class, 'map')->join(Issue::class, 'issue', 'WITH', 'map.newId = issue.id')->where('map.type = :type')->andWhere('issue.journal = :journal')->setParameter('type', Issue::class)->setParameter('journal', $journalRef)->getQuery()->getScalarResult());
foreach ($importedIssues as $key => $importedIssue) {
$importedIssueIds[] = $importedIssue['oldId'];
}
$issuesSql = 'SELECT issue_id FROM issues WHERE issue_id NOT IN (?) AND journal_id = ?';
$issuesStatement = $this->connection->executeQuery($issuesSql, [$importedIssueIds, [$journalMap->getOldId()]], [Connection::PARAM_INT_ARRAY, Connection::PARAM_INT_ARRAY]);
$nonImportedIssues = $issuesStatement->fetchAll();
$importedSectionIds = $this->getSectionIds($journalRef);
$createdIssueIds = $ii->importIssues($nonImportedIssues, $journalMap->getNewId(), $importedSectionIds);
}
return $createdIssueIds;
}
