Mini File Manager

File Manager

Current Directory: /home/lartcid/public_html/journal.lartc.id

[Back]

.. [Open]

.htaccess [Edit]

.well-known [Open]

README.md [Edit]

api [Open]

cache [Open]

cgi-bin [Open]

classes [Open]

config.TEMPLATE.inc.php [Edit]

config.inc.php [Edit]

controllers [Open]

cypress.json [Edit]

dbscripts [Open]

docs [Open]

error_log [Edit]

favicon.ico [Edit]

index.php [Edit]

js [Open]

lib [Open]

locale [Open]

mini.php [Edit]

pages [Open]

php.ini [Edit]

plugins [Open]

public [Open]

registry [Open]

scheduledTaskLogs [Open]

schemas [Open]

styles [Open]

templates [Open]

tools [Open]

Edit File

<?php

/**
 * @file tools/cleanReviewerInterests.php
 *
 * Copyright (c) 2014-2021 Simon Fraser University
 * Copyright (c) 2003-2021 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class ReviewerInterestsDeletionTool
 *
 * @ingroup tools
 *
 * @brief CLI tool to remove user interests that are not referenced by any user accounts.
 */

require(dirname(__FILE__) . '/bootstrap.php');

use PKP\cliTool\CommandLineTool;
use PKP\controlledVocab\ControlledVocabDAO;
use PKP\controlledVocab\ControlledVocabEntryDAO;
use PKP\db\DAORegistry;
use PKP\user\InterestDAO;

class ReviewerInterestsDeletionTool extends CommandLineTool
{
    public array $parameters;

/**
     * Constructor.
     *
     * @param array $argv command-line arguments
     */
    public function __construct($argv = [])
    {
        parent::__construct($argv);

if (!sizeof($this->argv)) {
            $this->usage();
            exit(1);
        }

$this->parameters = $this->argv;
    }

/**
     * Print command usage information.
     */
    public function usage()
    {
        echo "Permanently removes user interests that are not referenced by any user accounts.  USE WITH CARE.\n"
            . "Usage:\n"
            . "\t{$this->scriptName} --show : Display user interests not referenced\n"
            . "\t{$this->scriptName} --remove  : Permanently delete user interests not referenced\n";
    }

/**
     * Remove user interests that are not referenced by any user account
     */
    public function execute()
    {
        $orphans = $this->_getOrphanVocabInterests();
        if (!count($orphans)) {
            echo "No user interests to remove.\n";
            exit(0);
        }

$command = $this->parameters[0];
        switch ($command) {
            case '--show':
                $interests = array_map(function ($entry) {
                    return $entry->getData(InterestDAO::CONTROLLED_VOCAB_INTEREST);
                }, $orphans);
                echo "Below are the user interests that are not referenced by any user account.\n";
                echo "\t" . join("\n\t", $interests) . "\n";
                break;

case '--remove':
                /** @var ControlledVocabEntryDAO */
                $vocabEntryDao = DAORegistry::getDAO('ControlledVocabEntryDAO');
                foreach ($orphans as $orphanVocab) {
                    $vocabEntryDao->deleteObject($orphanVocab);
                }
                echo count($orphans) . " entries deleted\n";
                break;

default:
                echo "Invalid command.\n";
                $this->usage();
                exit(2);
        }
    }

/**
     * Returns user interests that are not referenced
     *
     * @return array array of ControlledVocabEntry object
     */
    protected function _getOrphanVocabInterests()
    {
        /** @var InterestDAO */
        $interestDao = DAORegistry::getDAO('InterestDAO');
        /** @var ControlledVocabDAO */
        $vocabDao = DAORegistry::getDAO('ControlledVocabDAO');
        /** @var ControlledVocabEntryDAO */
        $vocabEntryDao = DAORegistry::getDAO('ControlledVocabEntryDAO');

$interestVocab = $vocabDao->getBySymbolic(InterestDAO::CONTROLLED_VOCAB_INTEREST);
        $vocabEntryIterator = $vocabEntryDao->getByControlledVocabId($interestVocab->getId());
        $vocabEntryList = $vocabEntryIterator->toArray();

// list of vocab interests in db
        $allInterestVocabIds = array_map(
            function ($entry) {
                return $entry->getId();
            },
            $vocabEntryList
        );

// list of vocabs associated to users
        $interests = $interestDao->getAllInterests();
        $userInterestVocabIds = array_map(
            function ($interest) {
                return $interest->getId();
            },
            $interests->toArray()
        );

// get the difference
        $diff = array_diff($allInterestVocabIds, $userInterestVocabIds);

$orphans = array_filter(
            $vocabEntryList,
            function ($entry) use ($diff) {
                return in_array($entry->getId(), $diff);
            }
        );

return $orphans;
    }
}

$tool = new ReviewerInterestsDeletionTool($argv ?? []);
$tool->execute();