|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* @copyright Bluz PHP Team |
|
5
|
|
|
* @link https://github.com/bluzphp/skeleton |
|
6
|
|
|
*/ |
|
7
|
|
|
|
|
8
|
|
|
namespace Application\Transactions; |
|
9
|
|
|
|
|
10
|
|
|
use Bluz\Grid\Source\SelectSource; |
|
|
|
|
|
|
11
|
|
|
|
|
12
|
|
|
/** |
|
13
|
|
|
* Grid based on Table |
|
14
|
|
|
* |
|
15
|
|
|
* @package Application\Transactions |
|
16
|
|
|
* |
|
17
|
|
|
* @author Anton Shevchuk |
|
18
|
|
|
* @created 2017-10-19 15:29:44 |
|
19
|
|
|
*/ |
|
20
|
|
|
class Grid extends \Bluz\Grid\Grid |
|
|
|
|
|
|
21
|
|
|
{ |
|
22
|
|
|
/** |
|
23
|
|
|
* @var string |
|
24
|
|
|
*/ |
|
25
|
|
|
protected $uid = 'transactions'; |
|
26
|
|
|
|
|
27
|
|
|
/** |
|
28
|
|
|
* @return void |
|
29
|
|
|
* @throws \Bluz\Grid\GridException |
|
30
|
|
|
*/ |
|
31
|
|
|
public function init(): void |
|
32
|
|
|
{ |
|
33
|
|
|
// Build select |
|
34
|
|
|
$select = Table::select() |
|
35
|
|
|
->addSelect('users.login AS login') |
|
36
|
|
|
->addSelect('usersChain.login AS chainLogin') |
|
37
|
|
|
->leftJoin('transactions', 'users', 'users', 'users.id = transactions.userId') |
|
38
|
|
|
->leftJoin('transactions', 'users', 'usersChain', 'usersChain.id = transactions.chainUserId') |
|
39
|
|
|
; |
|
40
|
|
|
|
|
41
|
|
|
// Current table as source of grid |
|
42
|
|
|
$adapter = new SelectSource(); |
|
43
|
|
|
$adapter->setSource($select); |
|
44
|
|
|
|
|
45
|
|
|
$this->addAlias('users.id', 'user'); |
|
46
|
|
|
$this->addAlias('users.login', 'login'); |
|
47
|
|
|
|
|
48
|
|
|
$this->setAdapter($adapter); |
|
49
|
|
|
$this->setDefaultLimit(25); |
|
50
|
|
|
$this->setAllowFilters(['users.id', 'type']); |
|
51
|
|
|
$this->setAllowOrders(['type', 'amount', 'created', 'users.login']); |
|
52
|
|
|
} |
|
53
|
|
|
} |
|
54
|
|
|
|
The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g.
excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths