<?php
 namespace App\Reports\Sources\UsersVisits; class ColumnsManager extends \App\Reports\Sources\ColumnsManagerAbstract { protected array $columnsCfg = [ 'id' => [ 'type' => 'numeric', 'dbDef' => "INT UNSIGNED NOT NULL AUTO_INCREMENT", 'cat'=> 'visit', 'disabled'=>true ], 'module' => [ 'type' => 'string', 'dbDef' => "VARCHAR(250) NOT NULL DEFAULT ''", 'cat'=> 'visit' ], 'action' => [ 'type' => 'string', 'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat'=> 'visit' ], 'entityType' => [ 'type' => 'string', 'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''", 'cat'=> 'visit' ], 'entityOperation' => [ 'type' => 'string', 'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''", 'cat'=> 'visit' ], 'idEntity' => [ 'type' => 'string', 'dbDef' => "VARCHAR(50) NOT NULL DEFAULT ''", 'cat'=> 'visit' ], 'extraData' => [ 'type' => 'string', 'dbDef' => "TEXT NOT NULL DEFAULT ''", 'cat'=> 'visit', 'disabled'=>true, 'content'=>'assocArray'], 'extraDataList' => [ 'type' => 'string', 'dbDef' => "TEXT NOT NULL DEFAULT ''", 'cat'=> 'visit' ], 'datetime' => [ 'type' => 'datetime', 'dbDef' => "DATETIME NOT NULL", 'cat'=> 'visit' ], 'timestamp' => [ 'type' => 'numeric', 'dbDef' => "DECIMAL(16,6) UNSIGNED", 'cat'=> 'visit' ], 'idUser' => [ 'type' => 'numeric', 'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0", 'cat' => 'user' ], 'userName' => [ 'type' => 'string', 'dbDef' => "VARCHAR(101) NOT NULL DEFAULT ''", 'cat' => 'user' ], 'userOfficeId' => [ 'type' => 'numeric', 'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0", 'cat' => 'user' ], 'userOfficeName' => [ 'type' => 'string', 'dbDef' => "VARCHAR(150) NOT NULL DEFAULT ''", 'cat' => 'user' ], 'userDepartmentId' => [ 'type' => 'numeric', 'dbDef' => "SMALLINT UNSIGNED NOT NULL DEFAULT 0", 'cat' => 'user' ], 'userDepartmentName' => [ 'type' => 'string', 'dbDef' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => 'user' ], 'activeUser' => [ 'type' => 'boolean', 'dbDef' => "TINYINT UNSIGNED NOT NULL DEFAULT 0", 'cat' => 'user' ], ]; protected string $primaryKeyColumn = 'id'; protected array $forcedColumns = [ 'id', 'idUser', 'timestamp', 'userOfficeId' ]; protected array $columnsDependencies = [ 'userDepartmentName' => ['userDepartmentId' ], ]; } 