Nip\MailModule\Console\Commands\EmailsCleanupRecords

Complexity

Total Complexity

8

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Test Coverage

Coverage

95.24%

Importance

Changes	1
Bugs	0	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
A	deleteByType()	0	8	3
A	handle()	0	10	2
A	deleteByTypeQuery()	0	14	3

<?php

namespace Nip\MailModule\Console\Commands;

use Nip\Database\Query\Delete;
use Nip\Database\Result;
use Nip\MailModule\Tests\Fixtures\Models\Emails\Emails;
use Nip\Records\AbstractModels\RecordManager;

/**
 * Class EmailsCleanupRecords
 * @package Nip\MailModule\Console\Commands
 */
class EmailsCleanupRecords extends EmailsAbstract
{
    /**
     * @return bool|int
     */
    public function handle()
    {
        $emailsManager = $this->emailsManager();

        $types = $emailsManager::reduceEmailsByType();
        $records = 0;
        foreach ($types as $type => $days) {
            $records += $this->deleteByType($emailsManager, $type, $days);
        }
        return $records;
    }

    /**
     * @param RecordManager $emailsManager
     * @param string $type
     * @param int $days
     * @return bool|int
     */
    protected function deleteByType(RecordManager $emailsManager, string $type, $days)
    {
        $query = $this->deleteByTypeQuery($emailsManager, $type, $days);
        $result = $query->execute();
        if ($result instanceof Result && $result->isValid()) {
            return $result->numRows();
        }
        return 0;
    }

    /**
     * @param RecordManager $emailsManager
     * @param string $type
     * @param int $days
     * @return Delete
     */
    protected function deleteByTypeQuery($emailsManager, $type, $days)
    {
        /** @var Emails $emailsManager */
        $query = $emailsManager->newDeleteQuery();
        if (is_string($type) && strlen($type) > 1) {
            $query->where('`type` = ?', $type);

$type of type string is incompatible with the type array expected by parameter $values of Nip\Database\Query\AbstractQuery::where().

        }
        $query->where(
            '`' . $emailsManager::getSentDateField() . '` <= DATE_SUB(CURRENT_DATE(), INTERVAL ' . $days . ' DAY)'
        );

        $query->limit(500);

        return $query;
    }
}