[TYPO3-project-seminars] Sorting of places in BE
Joachim Bachmann
joachim.bachmann at triebstahl.de
Mon Oct 26 15:36:08 CET 2009
Oliver Klee schrieb:
> Rolf Thiele schrieb:
Hi Rolf an Oliver,
I have a familiar problem with the Sorting of Speakers ...
seminars ver 0.8.1
>> as I have some hundred places, I'd like to sort the list of places in
>> the Backend (the list where I pick a place when editing an event) by
>> name.
> That's Configuration/TCA/tca.php:
>
> 'place' => array(
> 'exclude' => 0,
> 'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.place',
> 'config' => array(
> 'type' => $selectType,
> 'internal_type' => 'db',
> 'allowed' => 'tx_seminars_sites',
> 'foreign_table' => 'tx_seminars_sites',
> 'foreign_table_where' => tx_seminars_tableRelations(
> 'tx_seminars_sites'
> ),
> 'size' => 10,
> 'minitems' => 0,
> 'maxitems' => 999,
> 'MM' => 'tx_seminars_seminars_place_mm',
> 'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_sites'),
> ),
> ),
>
>
> You'll need to add an ORDER BY title to the foreign_table_where.
> (I think most of the other selectors in the seminars TCEforms would
> benefit from the sorting, too.
I've added simply ".'ORDER BY title'" to the following lines:
categories
requirements
dependencies
event_types
place
speakers
partners
tutors
leaders
organizers
organizing_partners
target_groups
I'll post / attatch the Code on the end of this message.
Now the speakers ... are sorted by name when editing events.
Don't know if it would be good to order them by name in the BE. Nice
would be a order funktion like in the FE listview.
Almost all of our speakers habe academic titles, so the ordering by name
just does half the job.
It would be necessary to split the field "title" into title (academic),
forename and surname.
After that you could order all speakers by surname.
But i don't know exactly how to handle the existing speakers, after this
patch without editing every existing speaker.
> If you'd like to test this, create a patch for this and put it in the
> bug tracker, that would be terrific. :-)
Where can I find the bugtracker?
Regards
Joachim
[CODE]
$TCA['tx_seminars_seminars'] = array(
'ctrl' => $TCA['tx_seminars_seminars']['ctrl'],
'interface' => array(
'showRecordFieldList' =>
'title,subtitle,categories,teaser,description,accreditation_number,credit_points,begin_date,end_date,timeslots,begin_date_registration,deadline_registration,deadline_unregistration,expiry,details_page,place,room,speakers,price_regular,price_special,payment_methods,organizers,organizing_partners,event_takes_place_reminder_sent,cancelation_deadline_reminder_sent,needs_registration,allows_multiple_registrations,attendees_min,attendees_max,queue_size,target_groups,skip_collision_check,cancelled,notes,attached_files,hidden,starttime,endtime,owner_feuser,vips'
),
'columns' => array(
'object_type' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.object_type',
'config' => array(
'type' => 'radio',
'default' => '0',
'items' => array(
array('LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.object_type.I.0',
'0'),
array('LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.object_type.I.1',
'1'),
array('LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.object_type.I.2',
'2'),
),
),
),
'title' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.title',
'config' => array(
'type' => 'input',
'size' => '30',
'eval' => 'required,trim',
),
),
'topic' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.topic',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_seminars',
'foreign_table' => 'tx_seminars_seminars',
// only allow for topic records and complete event records, but not
for date records
'foreign_table_where' => 'AND (tx_seminars_seminars.object_type=0 '
.'OR tx_seminars_seminars.object_type=1)'.$selectWhereForTopics
.' ORDER BY title',
'size' => 1,
'minitems' => 1,
'maxitems' => 1,
),
),
'subtitle' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.subtitle',
'config' => array(
'type' => 'input',
'size' => '30',
'eval' => 'trim',
),
),
'categories' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.categories',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_categories',
'foreign_table' => 'tx_seminars_categories',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_categories')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_categories_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_categories'),
),
),
'requirements' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.requirements',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_seminars',
'foreign_table' => 'tx_seminars_seminars',
'foreign_table_where' => 'AND
tx_seminars_seminars.uid!=###THIS_UID###' .
' AND object_type=1'.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_requirements_mm',
),
),
'dependencies' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.dependencies',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'foreign_table' => 'tx_seminars_seminars',
'foreign_table_where' => 'AND
tx_seminars_seminars.uid!=###THIS_UID###' .
' AND object_type=1'.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_requirements_mm',
'MM_opposite_field' => 'requirements',
),
),
'teaser' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.teaser',
'config' => array(
'type' => 'text',
'cols' => '30',
'rows' => '5',
),
),
'description' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.description',
'config' => array(
'type' => 'text',
'cols' => '30',
'rows' => '5',
),
),
'event_type' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.event_type',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_event_types',
'foreign_table' => 'tx_seminars_event_types',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_event_types')
.' ORDER BY title',
'size' => 1,
'minitems' => 0,
'maxitems' => 1,
'items' => array(
'' => '',
),
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_event_types'),
),
),
'accreditation_number' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.accreditation_number',
'config' => array(
'type' => 'input',
'size' => '20',
'eval' => 'trim',
),
),
'credit_points' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.credit_points',
'config' => array(
'type' => 'input',
'size' => '3',
'max' => '3',
'eval' => 'int',
'checkbox' => '0',
'range' => array(
'upper' => '999',
'lower' => '0',
),
'default' => 0,
),
),
'begin_date' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.begin_date',
'config' => array(
'type' => 'input',
'size' => '12',
'max' => '20',
'eval' => 'datetime',
'checkbox' => '0',
'default' => '0',
),
),
'end_date' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.end_date',
'config' => array(
'type' => 'input',
'size' => '12',
'max' => '20',
'eval' => 'datetime',
'checkbox' => '0',
'default' => '0',
),
),
'timeslots' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.timeslots',
'config' => array(
'type' => 'inline',
'foreign_table' => 'tx_seminars_timeslots',
'foreign_field' => 'seminar',
'foreign_default_sortby' => 'tx_seminars_timeslots.begin_date',
'maxitems' => 999,
'appearance' => array(
'newRecordLinkPosition' => 'bottom',
'expandSingle' => 1,
),
),
),
'begin_date_registration' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.begin_date_registration',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '12',
'max' => '20',
'eval' => 'datetime',
'checkbox' => '0',
'default' => '0',
),
),
'deadline_registration' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.deadline_registration',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '12',
'max' => '20',
'eval' => 'datetime',
'checkbox' => '0',
'default' => '0',
),
),
'deadline_early_bird' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.deadline_early_bird',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '12',
'max' => '20',
'eval' => 'datetime',
'checkbox' => '0',
'default' => '0',
),
),
'deadline_unregistration' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.deadline_unregistration',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '12',
'max' => '20',
'eval' => 'datetime',
'checkbox' => '0',
'default' => '0',
),
),
'expiry' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.expiry',
'config' => array(
'type' => 'input',
'size' => '10',
'max' => '10',
'eval' => 'date',
'checkbox' => '0',
'default' => '0',
),
),
'details_page' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.details_page',
'config' => array(
'type' => 'input',
'size' => '15',
'max' => '255',
'checkbox' => '',
'eval' => 'trim',
'wizards' => array(
'_PADDING' => 2,
'link' => array(
'type' => 'popup',
'title' => 'Link',
'icon' => 'link_popup.gif',
'script' => 'browse_links.php?mode=wizard',
'JSopenParams' =>
'height=300,width=500,status=0,menubar=0,scrollbars=1',
),
),
),
),
'place' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.place',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_sites',
'foreign_table' => 'tx_seminars_sites',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_sites')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_place_mm',
'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_sites'),
),
),
'room' => array(
'exclude' => 1,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.room',
'config' => array(
'type' => 'text',
'cols' => '30',
'rows' => '5',
),
),
'lodgings' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.lodgings',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_lodgings',
'foreign_table' => 'tx_seminars_lodgings',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_lodgings'
) . ' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_lodgings_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_lodgings'),
),
),
'foods' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.foods',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_foods',
'foreign_table' => 'tx_seminars_foods',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_foods'
) . ' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_foods_mm',
'wizards' => tx_seminars_tableReplace($tempWizard, 'tx_seminars_foods'),
),
),
'speakers' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.speakers',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_speakers',
'foreign_table' => 'tx_seminars_speakers',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_speakers')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_speakers_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_speakers'),
),
),
'partners' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.partners',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_speakers',
'foreign_table' => 'tx_seminars_speakers',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_speakers')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_speakers_mm_partners',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_speakers'),
),
),
'tutors' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.tutors',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_speakers',
'foreign_table' => 'tx_seminars_speakers',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_speakers')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_speakers_mm_tutors',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_speakers'),
),
),
'leaders' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.leaders',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_speakers',
'foreign_table' => 'tx_seminars_speakers',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_speakers')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_speakers_mm_leaders',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_speakers'),
),
),
'language' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.language',
'config' => array(
'type' => 'select',
'items' => array(
array('', ''),
),
'itemsProcFunc' => 'tx_staticinfotables_div->selectItemsTCA',
'itemsProcFunc_config' => array(
'table' => 'static_languages',
'where' => '',
'indexField' => 'lg_iso_2',
),
'size' => 1,
'minitems' => 0,
'maxitems' => 1,
),
),
'price_regular' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_regular',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0.00',
),
'default' => '0.00',
),
),
'price_regular_early' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_regular_early',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0.00',
),
'default' => '0.00',
),
),
'price_regular_board' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_regular_board',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0',
),
'default' => '0.00',
),
),
'price_special' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_special',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0.00',
),
'default' => '0.00',
),
),
'price_special_early' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_special_early',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0.00',
),
'default' => '0.00',
),
),
'price_special_board' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_special_board',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0.00',
),
'default' => '0.00',
),
),
'additional_information' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.additional_information',
'config' => array(
'type' => 'text',
'cols' => '30',
'rows' => '5',
),
),
'checkboxes' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.checkboxes',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_checkboxes',
'foreign_table' => 'tx_seminars_checkboxes',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_checkboxes'
) . ' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_checkboxes_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_checkboxes'),
),
),
'uses_terms_2' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.uses_terms_2',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'check',
'default' => 0,
)
),
'payment_methods' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.payment_methods',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_payment_methods',
'foreign_table' => 'tx_seminars_payment_methods',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_payment_methods'
) . ' ORDER BY title',
'size' => 5,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_payment_methods_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_payment_methods'),
),
),
'organizers' => array(
'exclude' => 0,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.organizers',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_organizers',
'foreign_table' => 'tx_seminars_organizers',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_organizers')
.' ORDER BY title',
'size' => 5,
'minitems' => 1,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_organizers_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_organizers'),
),
),
'organizing_partners' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.organizing_partners',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_organizers',
'foreign_table' => 'tx_seminars_organizers',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_organizers')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_organizing_partners_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_organizers'),
),
),
'event_takes_place_reminder_sent' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.event_takes_place_reminder_sent',
'config' => array(
'type' => 'check',
'readOnly' => 1,
),
),
'cancelation_deadline_reminder_sent' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.cancelation_deadline_reminder_sent',
'config' => array(
'type' => 'check',
'readOnly' => 1,
),
),
'needs_registration' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.needs_registration',
'config' => array(
'type' => 'check',
'default' => 1,
),
),
'allows_multiple_registrations' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.allows_multiple_registrations',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'check',
'default' => 0,
),
),
'attendees_min' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.attendees_min',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '4',
'max' => '4',
'eval' => 'int',
'checkbox' => '0',
'range' => array(
'upper' => '9999',
'lower' => '0',
),
'default' => 0,
),
),
'attendees_max' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.attendees_max',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'input',
'size' => '4',
'max' => '4',
'eval' => 'int',
'checkbox' => '0',
'range' => array(
'upper' => '9999',
'lower' => '0',
),
'default' => 0,
),
),
'queue_size' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.queue_size',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'check',
'default' => 0,
),
),
'target_groups' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.target_groups',
'config' => array(
'type' => $selectType,
'internal_type' => 'db',
'allowed' => 'tx_seminars_target_groups',
'foreign_table' => 'tx_seminars_target_groups',
'foreign_table_where' => tx_seminars_tableRelations(
'tx_seminars_target_groups')
.' ORDER BY title',
'size' => 10,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_target_groups_mm',
'wizards' => tx_seminars_tableReplace($tempWizard,
'tx_seminars_target_groups'),
),
),
'skip_collision_check' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.skip_collision_check',
'displayCond' => 'FIELD:needs_registration:REQ:true',
'config' => array(
'type' => 'check',
'default' => 0,
),
),
'cancelled' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.cancelled',
'config' => array(
'type' => 'select',
'default' => '0',
'items' => array(
array('LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.cancelled_planned',
'0'),
array('LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.cancelled_canceled',
'1'),
array('LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.cancelled_confirmed',
'2'),
),
),
),
'notes' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.notes',
'config' => array(
'type' => 'text',
'cols' => '30',
'rows' => '5',
),
),
'attached_files' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.attached_files',
'config' => array(
'type' => 'group',
'internal_type' => 'file',
'allowed' => 'jpg,jpeg,png,bmp,gif,tiff,tif,' . 'txt,pdf,ps,' .
'svg,' . 'doc,docx,sxw,odt,' . 'xls,xlsx,sxc,ods,' .
'ppt,pptx,sxi,odp,' . 'html,htm,css,js,xml,xsd,' .
'zip,rar,gz,tgz,tar,bz2,tbz,tbz2',
'max_size' => $GLOBALS['TYPO3_CONF_VARS']['BE']['maxFileSize'],
'uploadfolder' => 'uploads/tx_seminars/',
'size' => '5',
'maxitems' => '200',
'minitems' => '0',
'autoSizeMax' => 40,
),
),
'hidden' => array(
'exclude' => 1,
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.hidden',
'config' => array(
'type' => 'check',
'default' => '0',
),
),
'starttime' => array(
'exclude' => 1,
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.starttime',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0',
),
),
'endtime' => array(
'exclude' => 1,
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.endtime',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'checkbox' => '0',
'default' => '0',
'range' => array(
'upper' => mktime(0,0,0,12,31,2020),
'lower' => mktime(0,0,0,date('m')-1,date('d'),date('Y')),
),
),
),
'owner_feuser' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.owner_feuser',
'config' => array(
'type' => 'group',
'internal_type' => 'db',
'allowed' => 'fe_users',
'size' => 1,
'minitems' => 0,
'maxitems' => 1,
),
),
'vips' => array(
'exclude' => 1,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.vips',
'config' => array(
'type' => 'group',
'internal_type' => 'db',
'allowed' => 'fe_users',
'size' => 5,
'minitems' => 0,
'maxitems' => 999,
'MM' => 'tx_seminars_seminars_feusers_mm',
),
),
'image' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.image',
'config' => array(
'type' => 'group',
'internal_type' => 'file',
'allowed' => 'gif,png,jpeg,jpg',
'max_size' => 256,
'uploadfolder' => 'uploads/tx_seminars',
'show_thumbs' => 1,
'size' => 1,
'minitems' => 0,
'maxitems' => 1,
),
),
),
'types' => array(
// Single event
'0' => array('showitem' => '' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelGeneral,
object_type, title;;;;2-2-2, subtitle;;;;3-3-3, image, categories,
teaser,
description;;;richtext[paste|bold|italic|formatblock|class|left|center|right|orderedlist|unorderedlist|outdent|indent|link|image]:rte_transform[mode=ts_css],
event_type, language, accreditation_number, credit_points, details_page,
additional_information;;;richtext[paste|bold|italic|formatblock|class|left|center|right|orderedlist|unorderedlist|outdent|indent|link|image]:rte_transform[mode=ts_css],
checkboxes, uses_terms_2, cancelled, notes, attached_files, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelPlaceTime,
begin_date, end_date, timeslots, begin_date_registration,
deadline_registration, deadline_early_bird, deadline_unregistration,
place, room, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelSpeakers,
speakers, partners, tutors, leaders, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelOrganizers,
organizers, organizing_partners, event_takes_place_reminder_sent,
cancelation_deadline_reminder_sent, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelAttendees,
needs_registration, allows_multiple_registrations, attendees_min,
attendees_max, queue_size, target_groups, skip_collision_check, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelLodging,
lodgings, foods, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelPayment,
price_regular, price_regular_early, price_regular_board, price_special,
price_special_early, price_special_board, payment_methods, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelAccess,
hidden;;1;;1-1-1, owner_feuser, vips',
),
// Multiple event topic
'1' => array('showitem' =>
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelGeneral,
object_type, title;;;;2-2-2, subtitle;;;;3-3-3, image, categories,
requirements, dependencies, teaser,
description;;;richtext[paste|bold|italic|formatblock|class|left|center|right|orderedlist|unorderedlist|outdent|indent|link|image]:rte_transform[mode=ts_css],
event_type, credit_points,
additional_information;;;richtext[paste|bold|italic|formatblock|class|left|center|right|orderedlist|unorderedlist|outdent|indent|link|image]:rte_transform[mode=ts_css],
checkboxes, uses_terms_2, notes, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelAttendees,
allows_multiple_registrations, target_groups, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelPayment,
price_regular, price_regular_early, price_regular_board, price_special,
price_special_early, price_special_board, payment_methods, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelAccess,
hidden;;1;;1-1-1, ',
),
// Multiple event date
'2' => array('showitem' =>
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelGeneral,
object_type, title;;;;2-2-2, topic, language, accreditation_number,
details_page, cancelled, notes, attached_files, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelPlaceTime,
begin_date, end_date, timeslots, begin_date_registration,
deadline_registration, deadline_early_bird, deadline_unregistration,
expiry, place, room, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelSpeakers,
speakers, partners, tutors, leaders, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelOrganizers,
organizers, organizing_partners, event_takes_place_reminder_sent,
cancelation_deadline_reminder_sent, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelAttendees,
needs_registration, attendees_min, attendees_max, queue_size,
skip_collision_check, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelLodging,
lodgings, foods, ' .
'--div--;LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.divLabelAccess,
hidden;;1;;1-1-1, vips',
),
),
'palettes' => array(
'1' => array('showitem' => 'starttime, endtime'),
),
);
[/CODE]
More information about the TYPO3-project-seminars
mailing list