Re: [Galette-discussion] Problème avec l'Ajout de colonnes triées dans le listing membre

[Contact CID Auditeur <contact@xxxxxxxxxxxxxxxx>]

Voilà la fraction de log correspondant au bug :

185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Db] Database connection was successfull!
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_database`.`version` AS `version` FROM `oitar_database` LIMIT 1
185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-events is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-maps is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Db] Database connection was successfull!
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Db] Database connection was successfull!
185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-events is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-maps is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT DISTINCT `oitar_statuts`.`id_statut` AS `id_statut`, `oitar_statuts`.`libelle_statut` AS `libelle_statut`, `oitar_statuts`.`priorite_statut` AS `priorite_statut` FROM `oitar_statuts` ORDER BY `priorite_statut` ASC
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'A' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'C' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'M' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'MI' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'Non renseigné' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Galette\Filters\MembersList|Pagination] Setting property `orderby`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `email_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `email_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `filter_str`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `membership_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `account_status_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `group_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `group_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `group_filter`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `orderby`
185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Galette\Filters\MembersList|Pagination] Getting property `orderby`
185.2.4.98 - 2018-07-10 14:51:05 - 7 - [Db] Database connection was successfull!
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_database`.`version` AS `version` FROM `oitar_database` LIMIT 1
185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-events is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-maps is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:05 - 7 - [Db] Database connection was successfull!
185.2.4.98 - 2018-07-10 14:51:05 - 7 - [Db] Database connection was successfull!
185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-events is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-maps is explicitely disabled
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT DISTINCT `oitar_statuts`.`id_statut` AS `id_statut`, `oitar_statuts`.`libelle_statut` AS `libelle_statut`, `oitar_statuts`.`priorite_statut` AS `priorite_statut` FROM `oitar_statuts` ORDER BY `priorite_statut` ASC
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'A' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'C' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'M' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'MI' AND `text_locale` = 'fr_FR.utf8' LIMIT 1
185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'Non renseigné' AND `text_locale` = 'fr_FR.utf8' LIMIT 1

Cordialement,

Georges Beyna

Johan a écrit :

Le 10 juillet 2018 11:43:15 GMT+02:00, Contact CID Auditeur <contact@xxxxxxxxxxxxxxxx> a écrit :

Bonjour à tous,

J'ai ajouté des colonnes dans gestion_adherents.tpl, jusque là pas de 
problème, ça marche, Certaines doivent avoir une option de tri et là ça

se dégrade ...

Exemple dans */templates/default/gestion_adherents.tpl*

/<th class="left">//
//                        <a href=""members" 
data="" => {_T string='order' domain="routes"}, "value" => 
"Galette\Repository\Members::ORDERBY_BIRTHDATE"|constant]}">//
//                            {_T string="Birth date"}//
//                            {if $filters->orderby eq 
constant('Galette\Repository\Members::ORDERBY_BIRTHDATE')}//
//                                {if $filters->ordered eq 
constant('Galette\Filters\MembersList::ORDER_ASC')}//
//                                    <img 
src="" width="10"
height="6" 
alt=""/>//
//                                {else}//
//                                    <img 
src="" width="10" height="6" 
alt=""/>//
//                                {/if}//
//                            {/if}//
//                        </a>//
//                    </th>/

+

/<td class="{$rclass}">{$member->birthdate}</td>/


dans *lib/Galette/Repository/Members.php*

/const ORDERBY_BIRTHDATE = 6;/

+

/case self::ORDERBY_BIRTHDATE://
//                if ( $this->canOrderBy('ddn_adh', $fields) ) {//
//                    $order[] = 'ddn_adh ' . 
$this->_filters->getDirection();//
//                }//
//            break;/

En faisant attention à la position du CASE


Au clic sur l'entête de col, j'ai une erreur : *Erreur de
l’application*


J'ai du oublier quelque chose mais QUOI ??? Une autre modif ??? Dans un

autre fichier ??? Merci d'avance pour votre aide

Salut,

Pas trop d'idée sans creuser davantage, il faudrait voir ce que disent les logs dans un premier temps.

++
Johan