Nip\MailModule\Console\Commands\EmailsCleanupRecords

Complexity

Total Complexity

6

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	handle()	0	10	2
A	deleteByType()	0	5	1
A	deleteByTypeQuery()	0	12	3

<?php

namespace Nip\MailModule\Console\Commands;

use Nip\Database\Query\Delete;
use Nip\MailModule\Models\EmailsTable\EmailsTrait;
use Nip\Records\Locator\ModelLocator;
use Nip\Records\RecordManager;

/**
 * Class EmailsCleanupRecords
 * @package Nip\MailModule\Console\Commands
 */
class EmailsCleanupRecords
{


    public function handle()
    {
        /** @var EmailsTrait $emailsManager */
        $emailsManager = ModelLocator::get('emails');

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

    /**
     * @param EmailsTrait|RecordManager $emailsManager
     * @param $type
     * @param $days
     */
    protected function deleteByType(RecordManager $emailsManager, string $type, $days)
    {
        $query = $this->deleteByTypeQuery($emailsManager, $type, $days);
        $query->execute();
    }

    /**
     * @param EmailsTrait|RecordManager $emailsManager
     * @param $type
     * @param $days
     * @return Delete
     */
    protected function deleteByTypeQuery($emailsManager, $type, $days)
    {
        $query = $emailsManager->newDeleteQuery();

The method newDeleteQuery does only exist in Nip\Records\RecordManager, but not in Nip\MailModule\Models\EmailsTable\EmailsTrait.

        if (is_string($type) && strlen($type) > 1) {
            $query->where('`type` = ?', $type);
        }
        $query->where(
            '`' . $emailsManager::getSentDateField() . '` <= DATE_SUB(CURRENT_DATE(), INTERVAL ' . $days . ' DAY)'
        );

        return $query;
    }
}