<?php

// CORPORATE CONTACT PERSONS REPORT ///////////////////////////////////////////////////////////////
$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"],
];

// DATABASE FORCED COLUMNS ////////////////////////////////////////////////////////////////////////
$CFG['reportsManagement']['adminReport']['addForcedColumns']['corporateContactPersons'] = [
	'contact_id'
];

// DATABASE COLUMNS DEPENDENCIES //////////////////////////////////////////////////////////////////
$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'],
];

// TABLE PRIMARY KEY (can be more columns, separated by comma) ////////////////////////////////////
$CFG['reportsManagement']['adminReport']['tablePrimaryKey']['corporateContactPersons'] = '`contact_id`';