| Re: [Galette-discussion] Problème avec l'Ajout de colonnes triées dans le listing membre |
[ Thread Index |
Date Index
| More lists.galette.eu/users Archives
]
- To: users@xxxxxxxxxxxxxxxx
- Subject: Re: [Galette-discussion] Problème avec l'Ajout de colonnes triées dans le listing membre
- From: Johan <johan@xxxxxxxx>
- Date: Tue, 10 Jul 2018 19:02:32 +0200
Le 10 juillet 2018 16:54:14 GMT+02:00, Contact CID Auditeur <contact@xxxxxxxxxxxxxxxx> a écrit :
>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="{path_for name="members"
>>> data=["option" => {_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="{base_url}/{$template_subdir}images/down.png" width="10"
>>> height="6"
>>> alt=""/>//
>>> // {else}//
>>> // <img
>>> src="{base_url}/{$template_subdir}images/up.png" 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
>>
À vue de nez, l'erreur n'y est pas.
Le plus simple serait de passer en mode DEV
++
Johan
--
Galette users discussions
http://galette.eu - http://galette.eu/documentation
http://bugs.galette.eu/projects/galette/
List documentation: https://listengine.tuxfamily.org/lists.galette.eu/users/