8780667983

Committed 13 Mar 2024 12:24PM UTC coverage: 34.102%. Remained the same

Build # 8780667983

Build Type

push

github

Committed by

web-flow

Commit Message

[7.x] Next (#1060)

* PHP 8.0

* Translator: switch from ITranslator to Translator (#973)

* [7.x] Bootstrap 5 + PHP 8 + vanilla javascript (#1021)

* Bootstrap 5

* Bootstrap 5 (docs)

* Bootstrap 5

* form-control -> form-select

* Bump bootstrap-select for Bootstrap 5 support

* Removed `input-sm` from Bootstrap 3

See https://getbootstrap.com/docs/4.0/migration/#forms-1

* Bootstrap 5: When selectpicker, replace form-select classes with form-control and refresh it

* Hide `underline` also for `dropdown-item`. And merged into one CSS rule.

* Update the filterMultiSelect initialization

* Text-align: left -> start

Co-authored-by: Radim Vaculík <radim.vaculik@gmail.com>
Co-authored-by: Jaroslav Líbal <jaroslav.libal@neatous.cz>

* [7.x] phpstan-deprecation-rules (#1061)

* Fix sort

* Add method for setting custom Action href, v6.x (#853)

* [7.x] Nextras ORM 4 support, closes #984

* Fix ElasticsearchDataSource.php data source (#1041)

* Error: Typed property Ublaboo\DataGrid\InlineEdit\InlineEdit::$itemID must not be accessed before initialization

* composer: allow-plugins: php-http/discovery

* ItemDetailForm: $httpPost: Typed property must not be accessed...

* phpstan: revert  --memory-limit=4G

* NetteDatabaseSelectionHelper: Context -> Explorer, getSupplementalDriver -> getDriver

* Update README.md

* Templates: fix variables

* data-bs-toggle attribute for multiaction button (#1072)

* dependabot.yml (#1078)

* Allow nette/utils:4.0 (#1077)

* Add onColumnShow and onColumnHide event methods (#1076)

* Add onColumnShow and onColumnHide event methods

* Add native type array

* Removed duplicity

* Return value of BackedEnum when reading Doctrine entity property. (#1081)

* Return value of BackedEnum when reading array value (#1083)

* Added method to check if filter is on default values; Closes #1082 (#1084)

* ublaboo -> contributte (#1067) (#1075)

* Delete depe... (continued)

Run Details

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

1455 existing lines in 67 files now uncovered.

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/NetteDatabaseTableMssqlDataSource.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\Utils\DateTimeHelper;

class NetteDatabaseTableMssqlDataSource extends NetteDatabaseTableDataSource implements IDataSource
{

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

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

                        $this->dataSource->where(
                                sprintf('CONVERT(varchar(10), %s, 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) {
                        try {
                                $dateFrom = DateTimeHelper::tryConvertToDateTime($valueFrom, [$filter->getPhpFormat()]);
                                $dateFrom->setTime(0, 0, 0);

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

                if ($valueTo) {
                        try {
                                $dateTo = DateTimeHelper::tryConvertToDateTime($valueTo, [$filter->getPhpFormat()]);
                                $dateTo->setTime(23, 59, 59);

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

}

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\Utils\DateTimeHelper;
9
10	class NetteDatabaseTableMssqlDataSource extends NetteDatabaseTableDataSource implements IDataSource
11	{
12
13	protected function applyFilterDate(FilterDate $filter): void
14	{
UNCOV 15	$conditions = $filter->getCondition();	×
16
17	try {
18	$date = DateTimeHelper::tryConvertToDateTime($conditions[$filter->getColumn()], [$filter->getPhpFormat()]);	×
19
20	$this->dataSource->where(	×
NEW 21	sprintf('CONVERT(varchar(10), %s, 112) = ?', $filter->getColumn()),	×
22	$date->format('Ymd')	×
23	);
NEW 24	} catch (DatagridDateTimeHelperException) {	×
25	// ignore the invalid filter value
26	}
27	}
28
29	protected function applyFilterDateRange(FilterDateRange $filter): void
30	{
31	$conditions = $filter->getCondition();	×
32
33	$valueFrom = $conditions[$filter->getColumn()]['from'];	×
UNCOV 34	$valueTo = $conditions[$filter->getColumn()]['to'];	×
35
36	if ($valueFrom) {	×
37	try {
38	$dateFrom = DateTimeHelper::tryConvertToDateTime($valueFrom, [$filter->getPhpFormat()]);	×
39	$dateFrom->setTime(0, 0, 0);	×
40
UNCOV 41	$this->dataSource->where(	×
NEW 42	sprintf('CONVERT(varchar(10), %s, 112) >= ?', $filter->getColumn()),	×
UNCOV 43	$dateFrom->format('Ymd')	×
44	);
NEW 45	} catch (DatagridDateTimeHelperException) {	×
46	// ignore the invalid filter value
47	}
48	}
49
50	if ($valueTo) {	×
51	try {
52	$dateTo = DateTimeHelper::tryConvertToDateTime($valueTo, [$filter->getPhpFormat()]);	×
53	$dateTo->setTime(23, 59, 59);	×
54
UNCOV 55	$this->dataSource->where(	×
NEW 56	sprintf('CONVERT(varchar(10), %s, 112) <= ?', $filter->getColumn()),	×
UNCOV 57	$dateTo->format('Ymd')	×
58	);
NEW 59	} catch (DatagridDateTimeHelperException) {	×
60	// ignore the invalid filter value
61	}
62	}
63	}
64
65	}

contributte / datagrid / 8780667983

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