MyriadDataStore\Console\Commands\SetIssuesDatesForPackages::handle()

Complexity

Conditions	1
Paths	1

Size

Total Lines	26
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function handle(): int
    {
        $tableOrderPackages = config('myriad-data-store.tables.order_packages');
        $tableIssues        = config('myriad-data-store.tables.issues');
        DB::statement("
            UPDATE {$tableOrderPackages}
            LEFT JOIN {$tableIssues} ON
                        {$tableOrderPackages}.title_id = {$tableIssues}.title_id
                         AND {$tableOrderPackages}.start_issue = {$tableIssues}.name
            SET {$tableOrderPackages}.start_issue_dn = {$tableIssues}.publication_date
            WHERE true;
        ");

        DB::statement("
            UPDATE {$tableOrderPackages}
            LEFT JOIN {$tableIssues} ON
                        {$tableOrderPackages}.title_id = {$tableIssues}.title_id
                         AND {$tableOrderPackages}.end_issue = {$tableIssues}.name
            LEFT JOIN {$tableIssues} as mi ON
                        {$tableOrderPackages}.title_id = mi.title_id
                         AND {$tableOrderPackages}.start_issue = mi.name
            SET {$tableOrderPackages}.end_issue_dn = IF({$tableIssues}.publication_date IS NULL, mi.publication_date, {$tableIssues}.publication_date)
            WHERE true;
        ");

        return 0;
    }