Zadanie

V BE module Pages (Stránka) potrebujeme vidieť záznamy z nami vytvoreného extensionu tx_rtgper, ktorý vytvára v BE tabuľku tx_rtgper_references.

DB tabuľka tx_rtgper_references

CREATE TABLE tx_rtgper_references (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	title varchar(40) DEFAULT '' NOT NULL,
	image text,
	realised_for varchar(80) DEFAULT '' NOT NULL,
	date int(11) DEFAULT '0' NOT NULL
);

Riešenie

Úprava ext_localconf.php

V zozname budú viditeľné stĺpce tabuľky vymenované v položke flist.

$TYPO3_CONF_VARS['EXTCONF']['cms']['db_layout']['addTables']['tx_rtgper_references'][0] = array(
	'fList' => 'uid,title,realised_for,date,image',
	'icon' => TRUE
);

Úprava ext_tables.php

Pridaný riadok je vyznačený tučným písmom.

$TCA['tx_rtgper_references'] = array (
	'ctrl' => array (
		'title'     => 'LLL:EXT:rtgper/locallang_db.xml:tx_rtgper_references',		
		'label'     => 'title',	
		'tstamp'    => 'tstamp',
		'crdate'    => 'crdate',
		'cruser_id' => 'cruser_id',
		'languageField'            => 'sys_language_uid',    
		'transOrigPointerField'    => 'l10n_parent',    
		'transOrigDiffSourceField' => 'l10n_diffsource',    
		'default_sortby' => 'ORDER BY title',	
		'delete' => 'deleted',	
		'enablecolumns' => array (		
			'disabled' => 'hidden',
		),
		'dynamicConfigFile' => t3lib_extMgm::extPath($_EXTKEY).'tca.php',
		'thumbnail'			=> 'image',
		'iconfile'          => t3lib_extMgm::extRelPath($_EXTKEY).'icon_tx_rtgper_references.gif',
	),
);