8230471191

Committed 11 Mar 2024 09:25AM UTC coverage: 34.102%. First build

Build # 8230471191

Build Type

Pull #1060

github

Committed by

radimvaculik

Commit Message

Fix phpstan

Pull Request Pull Request #1060: [7.x] Next

Run Details

117 of 435 new or added lines in 54 files covered. (26.9%)

1124 of 3296 relevant lines covered (34.1%)

0.34 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/src/DataSource/DibiFluentMssqlDataSource.php

<?php declare(strict_types = 1);

namespace Contributte\Datagrid\DataSource;

use Contributte\Datagrid\Exception\DatagridDateTimeHelperException;
use Contributte\Datagrid\Filter\FilterDate;
use Contributte\Datagrid\Filter\FilterDateRange;
use Contributte\Datagrid\Filter\FilterText;
use Contributte\Datagrid\Utils\DateTimeHelper;
use dibi;
use Dibi\Fluent;
use Dibi\Helpers;
use Dibi\Result;
use UnexpectedValueException;

class DibiFluentMssqlDataSource extends DibiFluentDataSource
{

        protected array $data = [];

        public function __construct(Fluent $dataSource, string $primaryKey)
        {
                parent::__construct($dataSource, $primaryKey);
        }

        public function getCount(): int
        {
                $clone = clone $this->dataSource;
                $clone->removeClause('ORDER BY');

                return $clone->count();
        }

        /**
         * {@inheritDoc}
         */
        public function filterOne(array $condition): IDataSource
        {
                $this->dataSource->where($condition);

                return $this;
        }

        public function limit(int $offset, int $limit): IDataSource
        {
                $sql = (string) $this->dataSource;

                $result = $this->dataSource->getConnection()
                        ->query('%sql OFFSET ? ROWS FETCH NEXT ? ROWS ONLY', $sql, $offset, $limit);

                if (!$result instanceof Result) {
                        throw new UnexpectedValueException();
                }

                $this->data = $result->fetchAll();

                return $this;
        }

        protected function applyFilterDate(FilterDate $filter): void
        {
                $conditions = $filter->getCondition();

                try {
                        $date = DateTimeHelper::tryConvertToDateTime(
                                $conditions[$filter->getColumn()],
                                [$filter->getPhpFormat()]
                        );

                        $this->dataSource->where(
                                'CONVERT(varchar(10), %n, 112) = ?',
                                $filter->getColumn(),
                                $date->format('Ymd')
                        );
                } catch (DatagridDateTimeHelperException) {
                        // ignore the invalid filter value
                }
        }

        protected function applyFilterDateRange(FilterDateRange $filter): void
        {
                $conditions = $filter->getCondition();

                $valueFrom = $conditions[$filter->getColumn()]['from'];
                $valueTo = $conditions[$filter->getColumn()]['to'];

                if ($valueFrom) {
                        $this->dataSource->where(
                                'CONVERT(varchar(10), %n, 112) >= ?',
                                $filter->getColumn(),
                                $valueFrom
                        );
                }

                if ($valueTo) {
                        $this->dataSource->where(
                                'CONVERT(varchar(10), %n, 112) <= ?',
                                $filter->getColumn(),
                                $valueTo
                        );
                }
        }

        protected function applyFilterText(FilterText $filter): void
        {
                $condition = $filter->getCondition();
                $driver = $this->dataSource->getConnection()->getDriver();
                $or = [];

                foreach ($condition as $column => $value) {
                        $column = Helpers::escape($driver, $column, dibi::IDENTIFIER);

                        if ($filter->isExactSearch()) {
                                $this->dataSource->where(sprintf('%s = %%s', $column), $value);

                                continue;
                        }

                        $or[] = sprintf('%s LIKE "%%%s%%"', $column, $value);
                }

                if (count($or) > 1) {
                        $this->dataSource->where('(%or)', $or);
                } else {
                        $this->dataSource->where($or);
                }
        }

}

1	<?php declare(strict_types = 1);
2
3	namespace Contributte\Datagrid\DataSource;
4
5	use Contributte\Datagrid\Exception\DatagridDateTimeHelperException;
6	use Contributte\Datagrid\Filter\FilterDate;
7	use Contributte\Datagrid\Filter\FilterDateRange;
8	use Contributte\Datagrid\Filter\FilterText;
9	use Contributte\Datagrid\Utils\DateTimeHelper;
10	use dibi;
11	use Dibi\Fluent;
12	use Dibi\Helpers;
13	use Dibi\Result;
14	use UnexpectedValueException;
15
16	class DibiFluentMssqlDataSource extends DibiFluentDataSource
17	{
18
19	protected array $data = [];
20
21	public function __construct(Fluent $dataSource, string $primaryKey)
22	{
23	parent::__construct($dataSource, $primaryKey);	×
24	}
25
26	public function getCount(): int
27	{
28	$clone = clone $this->dataSource;	×
29	$clone->removeClause('ORDER BY');	×
30
31	return $clone->count();	×
32	}
33
34	/**
35	* {@inheritDoc}
36	*/
37	public function filterOne(array $condition): IDataSource
38	{
39	$this->dataSource->where($condition);	×
40
41	return $this;	×
42	}
43
44	public function limit(int $offset, int $limit): IDataSource
45	{
46	$sql = (string) $this->dataSource;	×
47
48	$result = $this->dataSource->getConnection()	×
49	->query('%sql OFFSET ? ROWS FETCH NEXT ? ROWS ONLY', $sql, $offset, $limit);	×
50
51	if (!$result instanceof Result) {	×
52	throw new UnexpectedValueException();	×
53	}
54
55	$this->data = $result->fetchAll();	×
56
57	return $this;	×
58	}
59
60	protected function applyFilterDate(FilterDate $filter): void
61	{
62	$conditions = $filter->getCondition();	×
63
64	try {
65	$date = DateTimeHelper::tryConvertToDateTime(	×
66	$conditions[$filter->getColumn()],	×
67	[$filter->getPhpFormat()]	×
68	);
69
70	$this->dataSource->where(	×
71	'CONVERT(varchar(10), %n, 112) = ?',	×
72	$filter->getColumn(),	×
73	$date->format('Ymd')	×
74	);
NEW 75	} catch (DatagridDateTimeHelperException) {	×
76	// ignore the invalid filter value
77	}
78	}
79
80	protected function applyFilterDateRange(FilterDateRange $filter): void
81	{
82	$conditions = $filter->getCondition();	×
83
84	$valueFrom = $conditions[$filter->getColumn()]['from'];	×
85	$valueTo = $conditions[$filter->getColumn()]['to'];	×
86
87	if ($valueFrom) {	×
88	$this->dataSource->where(	×
89	'CONVERT(varchar(10), %n, 112) >= ?',	×
90	$filter->getColumn(),	×
91	$valueFrom
92	);
93	}
94
95	if ($valueTo) {	×
96	$this->dataSource->where(	×
97	'CONVERT(varchar(10), %n, 112) <= ?',	×
98	$filter->getColumn(),	×
99	$valueTo
100	);
101	}
102	}
103
104	protected function applyFilterText(FilterText $filter): void
105	{
106	$condition = $filter->getCondition();	×
107	$driver = $this->dataSource->getConnection()->getDriver();	×
108	$or = [];	×
109
110	foreach ($condition as $column => $value) {	×
NEW 111	$column = Helpers::escape($driver, $column, dibi::IDENTIFIER);	×
112
113	if ($filter->isExactSearch()) {	×
NEW 114	$this->dataSource->where(sprintf('%s = %%s', $column), $value);	×
115
116	continue;	×
117	}
118
NEW 119	$or[] = sprintf('%s LIKE "%%%s%%"', $column, $value);	×
120	}
121
NEW 122	if (count($or) > 1) {	×
123	$this->dataSource->where('(%or)', $or);	×
124	} else {
125	$this->dataSource->where($or);	×
126	}
127	}
128
129	}

contributte / datagrid / 8230471191

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous