SqlServerExpression::getValue() - Code Metrics - ARCANEDEV/LaravelMetrics - Measure and Improve Code Quality continuously with Scrutinizer

SqlServerExpression::getValue() B
last analyzed 2020-10-19 12:59 UTC

↳ Parent: SqlServerExpression

Complexity

Conditions	6
Paths	6

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	9
CRAP Score	6

Importance

Changes

Metric	Value
dl	0
loc	24
ccs	9
cts	9
cp	1
rs	8.9137
c	0
b	0
f	0
cc	6
nc	6
nop	0
crap	6

<?php

declare(strict_types=1);

namespace Arcanedev\LaravelMetrics\Expressions\TrendDateFormat;

use Arcanedev\LaravelMetrics\Exceptions\InvalidTrendUnitException;
use Arcanedev\LaravelMetrics\Metrics\Trend;

/**
 * Class     SqlServerExpression
 *
 * @author   ARCANEDEV <[email protected]>
 */
class SqlServerExpression extends Expression
{
    /* -----------------------------------------------------------------
     |  Main Methods
     | -----------------------------------------------------------------
     */

    /**
     * Get the value of the expression.
     *
     * @return mixed
     */
    public function getValue(): string
    {
        $date = "DATEADD(hour, {$this->interval()}, {$this->wrap($this->value)})";

        switch ($this->unit) {
            case Trend::BY_MONTHS:
                return "FORMAT({$date}, 'yyyy-MM')";

            case Trend::BY_WEEKS:
                return "concat(YEAR({$date}), '-', datepart(ISO_WEEK, {$date}))";

            case Trend::BY_DAYS:
                return "FORMAT({$date}, 'yyyy-MM-dd')";

            case Trend::BY_HOURS:
                return "FORMAT({$date}, 'yyyy-MM-dd HH:00')";

            case Trend::BY_MINUTES:
                return "FORMAT({$date}, 'yyyy-MM-dd HH:mm:00')";

            default:
                throw InvalidTrendUnitException::make($this->unit);
        }
    }

    /**
     * Get the interval.
     *
     * @return string
     */
    private function interval(): string
    {
        $offset = $this->offset();

        if ($offset >= 0) {
            return (string) $offset;
        }

        return '-'.($offset * -1);
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Arcanedev\LaravelMetrics\Expressions\TrendDateFormat;
6
7		use Arcanedev\LaravelMetrics\Exceptions\InvalidTrendUnitException;
8		use Arcanedev\LaravelMetrics\Metrics\Trend;
9
10		/**
11		* Class SqlServerExpression
12		*
13		* @author ARCANEDEV <[email protected]>
14		*/
15		class SqlServerExpression extends Expression
16		{
17		/* -----------------------------------------------------------------
18		\| Main Methods
19		\| -----------------------------------------------------------------
20		*/
21
22		/**
23		* Get the value of the expression.
24		*
25		* @return mixed
26		*/
27	44	public function getValue(): string
28		{
29	44	$date = "DATEADD(hour, {$this->interval()}, {$this->wrap($this->value)})";
30
31	44	switch ($this->unit) {
32		case Trend::BY_MONTHS:
33	8	return "FORMAT({$date}, 'yyyy-MM')";
34
35		case Trend::BY_WEEKS:
36	8	return "concat(YEAR({$date}), '-', datepart(ISO_WEEK, {$date}))";
37
38		case Trend::BY_DAYS:
39	8	return "FORMAT({$date}, 'yyyy-MM-dd')";
40
41		case Trend::BY_HOURS:
42	8	return "FORMAT({$date}, 'yyyy-MM-dd HH:00')";
43
44		case Trend::BY_MINUTES:
45	8	return "FORMAT({$date}, 'yyyy-MM-dd HH:mm:00')";
46
47		default:
48	4	throw InvalidTrendUnitException::make($this->unit);
49		}
50		}
51
52		/**
53		* Get the interval.
54		*
55		* @return string
56		*/
57	44	private function interval(): string
58		{
59	44	$offset = $this->offset();
60
61	44	if ($offset >= 0) {
62	44	return (string) $offset;
63		}
64
65	20	return '-'.($offset * -1);
66		}
67		}
68

ARCANEDEV / LaravelMetrics

SqlServerExpression::getValue() B last analyzed 2020-10-19 12:59 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

SqlServerExpression::getValue() B
last analyzed 2020-10-19 12:59 UTC