<?php
 $CFG['reportsManagement']['adminReport']['columnsList']['corporateContactPersons'] = [ 'contact_id' => [ 'type' => 'numeric', 'dbCol' => "INT(10) UNSIGNED NOT NULL", 'cat' => "general"], 'contact_titleCode' => [ 'type' => 'string', 'dbCol' => "CHAR(1) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_titleName' => ['type' => 'string', 'dbCol' => "VARCHAR(10) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_firstName' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_lastName' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_department' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_job' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_role' => [ 'type' => 'string', 'dbCol' => "VARCHAR(30) NOT NULL DEFAULT ''", 'cat' => "general"], 'contact_comments' => [ 'type' => 'string', 'dbCol' => "TEXT NOT NULL", 'cat' => "general"], 'contact_remarks' => [ 'type' => 'string', 'dbCol' => "TEXT NOT NULL", 'cat' => "general"], 'contact_processedRemarks' => [ 'type' => 'string', 'dbCol' => "TEXT NOT NULL", 'cat' => "general", 'disabled' => true, 'content' => 'remarks'], 'contact_birthday' => [ 'type' => 'date', 'dbCol' => "DATE NULL DEFAULT NULL", 'cat' => "personal"], 'contact_email' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "personal"], 'contact_telephone' => [ 'type' => 'string', 'dbCol' => "VARCHAR(50) NOT NULL DEFAULT ''", 'cat' => "personal"], 'contact_telephoneMobile' => [ 'type' => 'string', 'dbCol' => "VARCHAR(50) NOT NULL DEFAULT ''", 'cat' => "personal"], 'contact_fax' => [ 'type' => 'string', 'dbCol' => "VARCHAR(50) NOT NULL DEFAULT ''", 'cat' => "personal"], 'contact_addTime' => [ 'type' => 'datetime', 'dbCol' => "DATETIME NULL", 'cat' => "admin"], 'contact_idAddUser' => [ 'type' => 'numeric', 'dbCol' => "SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "admin"], 'contact_addUserName' => [ 'type' => 'string', 'dbCol' => "VARCHAR(101) NOT NULL DEFAULT ''", 'cat' => "admin"], 'contact_addOfficeId' => [ 'type' => 'numeric', 'dbCol' => "SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "admin"], 'contact_addOfficeName' => [ 'type' => 'string', 'dbCol' => "VARCHAR(150) NOT NULL DEFAULT ''", 'cat' => "admin"], 'contact_lastUpdateTime' => [ 'type' => 'datetime', 'dbCol' => "DATETIME NULL DEFAULT NULL", 'cat' => "admin"], 'contact_idUpdateUser' => [ 'type' => 'numeric', 'dbCol' => "SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "admin"], 'contact_updateUserName' => [ 'type' => 'string', 'dbCol' => "VARCHAR(101) NOT NULL DEFAULT ''", 'cat' => "admin"], 'contact_updatesCount' => [ 'type' => 'numeric', 'dbCol' => "SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "admin"], 'corp_id' => [ 'type' => 'numeric', 'dbCol' => "INT(10) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "corporate"], 'corp_alias' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "corporate"], 'corp_companyNameStd' => [ 'type' => 'string', 'dbCol' => "VARCHAR(170) NOT NULL DEFAULT ''", 'cat' => "corporate"], 'corp_companyPrefixStd' => [ 'type' => 'string', 'dbCol' => "VARCHAR(20) NOT NULL DEFAULT ''", 'cat' => "corporate"], 'corp_companySuffixStd' => [ 'type' => 'string', 'dbCol' => "VARCHAR(20) NOT NULL DEFAULT ''", 'cat' => "corporate"], 'corp_companyFullStd' => [ 'type' => 'string', 'dbCol' => "VARCHAR(212) NOT NULL DEFAULT ''", 'cat' => "corporate"], 'corp_idOffice' => [ 'type' => 'numeric', 'dbCol' => "INT(10) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "corporate"], 'corp_officeName' => [ 'type' => 'string', 'dbCol' => "VARCHAR(100) NOT NULL DEFAULT ''", 'cat' => "corporate"], 'corp_duplicated' => [ 'type' => 'boolean', 'dbCol' => "TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'", 'cat' => "corporate"], 'corp_idOriginal' => [ 'type' => 'numeric', 'dbCol' => "INT(10) UNSIGNED NOT NULL DEFAULT '0'", 'cat'=>"corporate"], ]; $CFG['reportsManagement']['adminReport']['addForcedColumns']['corporateContactPersons'] = [ 'contact_id' ]; $CFG['reportsManagement']['adminReport']['columnsDependencies']['corporateContactPersons'] = [ 'contact_titleName' => ['contact_titleCode'], 'contact_addOfficeName' => ['contact_addOfficeId'], 'contact_updateUserName' => ['contact_idUpdateUser'], 'corp_alias' => ['corp_id'], 'corp_companyNameStd' => ['corp_id'], 'corp_companyPrefixStd' => ['corp_id'], 'corp_companySuffixStd' => ['corp_id'], 'corp_companyFullStd' => ['corp_id'], 'corp_idOffice' => ['corp_id'], 'corp_officeName' => ['corp_idOffice'], ]; $CFG['reportsManagement']['adminReport']['tablePrimaryKey']['corporateContactPersons'] = '`contact_id`';