lib.personnes = COA
lib.personnes {

    10 = FLUIDTEMPLATE
    10 {
        file = EXT:wseils/Resources/Private/Templates/ContentElements/Annuaire.html

        dataProcessing {
            10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
            10 {
                # the table name from which the data is fetched from
                # + stdWrap
                table = tt_address

                andWhere.cObject = COA
                andWhere.cObject {
                    10 = TEXT
                    10 {
                        field = tx_mask_personnes
                        wrap = uid IN(|)
                        if.isTrue.field = tx_mask_personnes
                    }
                    #20 = TEXT
                    #20 {
                    #field = tx_mask_personnes
                    #	wrap = uid IN(52)
                    #	if.isFalse.field = tx_mask_personnes
                    #}

                    20 = COA
                    20 {
                        if.isFalse.field = tx_mask_personnes
                        stdWrap.wrap = uid IN (|)
                        stdWrap.substring = 0,-1
                        10 = CONTENT
                        10 {
                            table = tt_address
                            select {
                                pidInList = {$annuairePID}
                                join = sys_category_record_mm ON sys_category_record_mm.uid_foreign=tt_address.uid
                                where.cObject = COA
                                where.cObject {
                                    10 = TEXT
                                    10 {
                                        if.isTrue.field = tx_mask_service
                                        dataWrap = sys_category_record_mm.tablenames = "tt_address" AND fieldname = "categories" AND sys_category_record_mm.uid_local = {field:tx_mask_service}
                                    }
                                    20 = TEXT
                                    20 {
                                        if.isFalse.field = tx_mask_service
                                        dataWrap = sys_category_record_mm.tablenames = "tt_address" AND fieldname = "categories"
                                    }
                                }
                                orderBy = sys_category_record_mm.sorting_foreign
                                languageField = 0 # disable translation handling of sys_category
                            }
                            renderObj = COA
                            renderObj {
                                10 = TEXT
                                10.field = uid
                                10.wrap = |,
                            }
                        }
                    }
                }
                # All properties from .select can be used directly
                # + stdWrap
                colPos = 1
                pidInList = {$annuairePID}

                # The target variable to be handed to the ContentObject again, can be used
                # in Fluid e.g. to iterate over the objects. defaults to "records" when not defined
                # + stdWrap
                as = personnes

                # The fetched records can also be processed by DataProcessors.
                # All configured processors are applied to every row of the result.
                dataProcessing {
                    10 = TYPO3\CMS\Frontend\DataProcessing\FilesProcessor
                    10 {
                        references.fieldName = image
                    }
                }
            }
        }
        variables {
            displayfilter = TEXT
            displayfilter.field = tx_mask_displayfilter

            header = TEXT
            header.field = header

            service = TEXT
            service.field = tx_mask_service
        }
    }
}