Waca\API\Actions\StatusAction::executeApiAction()

Complexity

Conditions	4
Paths	8

Size

Total Lines	93
Code Lines	65

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	20

Importance

Changes	2
Bugs	0	Features	0

<?php
    public function executeApiAction(DOMElement $apiDocument)
    {
        $statusElement = $this->document->createElement("status");
        $apiDocument->appendChild($statusElement);

        $query = $this->getDatabase()->prepare(<<<SQL
            SELECT /* Api/StatusAction */ COUNT(*) AS count
            FROM request
            WHERE
                status = :pstatus
                AND queue = :queue
                AND emailconfirm = 'Confirmed';
SQL
        );

        $allQueues = RequestQueue::getAllQueues($this->getDatabase());

        foreach ($allQueues as $value) {
            $query->bindValue(":pstatus", RequestStatus::OPEN);
            $query->bindValue(":queue", $value->getId());
            $query->execute();
            $sus = $query->fetchColumn();
            $statusElement->setAttribute($value->getApiName(), $sus);
            $query->closeCursor();
        }

        // hospital queue
        $search = RequestSearchHelper::get($this->getDatabase())->isHospitalised();

        if ($this->getSiteConfiguration()->getEmailConfirmationEnabled()) {
            $search->withConfirmedEmail();
        }
        $search->getRecordCount($hospitalCount);
        $statusElement->setAttribute('x-hospital', $hospitalCount);

        // job queue
        $search = RequestSearchHelper::get($this->getDatabase())
            ->byStatus(RequestStatus::JOBQUEUE);

        if ($this->getSiteConfiguration()->getEmailConfirmationEnabled()) {
            $search->withConfirmedEmail();
        }

        $search->getRecordCount($jobQueueRequestCount);
        $statusElement->setAttribute('x-jobqueue', $jobQueueRequestCount);

        // bans
        $query = $this->getDatabase()->prepare(<<<SQL
            SELECT /* Api/StatusAction */ COUNT(*) AS count
            FROM ban
            WHERE
                (duration > UNIX_TIMESTAMP() OR duration is null)
                AND active = 1;
SQL
        );

        $query->execute();
        $sus = $query->fetchColumn();
        $statusElement->setAttribute("bans", $sus);
        $query->closeCursor();

        $query = $this->getDatabase()->prepare(<<<SQL
SELECT /* Api/StatusAction */ COUNT(*) AS count
FROM user WHERE status = :ulevel;
SQL
        );

        $query->bindValue(":ulevel", "New");
        $query->execute();
        $sus = $query->fetchColumn();
        $statusElement->setAttribute("usernew", $sus);
        $query->closeCursor();

        $query = $this->getDatabase()->prepare(<<<SQL
select /* Api/StatusAction */ COUNT(*) from user u
inner join userrole ur on u.id = ur.user
where u.status = 'Active' and ur.role = :ulevel
SQL
        );

        $query->bindValue(":ulevel", "admin");
        $query->execute();
        $sus = $query->fetchColumn();
        $statusElement->setAttribute("useradmin", $sus);
        $query->closeCursor();

        $query->bindValue(":ulevel", "user");
        $query->execute();
        $sus = $query->fetchColumn();
        $statusElement->setAttribute("user", $sus);
        $query->closeCursor();

        return $apiDocument;
    }