Evénements prioritaires aux anniversaires [Réglé]
Module calendar
Support Général
MickaelFR Membre non connecté
Booster Fusée
- Booster Fusée
- Voir le profil du membre MickaelFR
- Inscrit le : 20/01/2014
- Site internet
- Groupes :
Comment faire SVP pour mettre en priorité les événements plutôt que les anniversaires en affichage sur le calendrier (couleurs)?
Merci encore.
j1.seth Membre non connecté
- Administrateur
- Voir le profil du membre j1.seth
- Inscrit le : 01/09/2008
- Site internet
- Groupes :
- Chef de Projet
- Equipe Développement
Je n'ai pas essayé, mais il faudrait remplacer la requête entre les lignes 247 et 264 du fichier /calendar/services/CalendarService.class.php par :
Code PHP :
return self::$db_querier->select("(SELECT start_date, end_date, title, 'EVENT' AS type, id_category, repeat_type, repeat_number FROM " . CalendarSetup::$calendar_events_table . " event LEFT JOIN " . CalendarSetup::$calendar_events_content_table . " event_content ON event_content.id = event.content_id WHERE approved = 1 AND ((start_date BETWEEN :first_month_day AND :last_month_day) OR (end_date BETWEEN :first_month_day AND :last_month_day) OR (:first_month_day BETWEEN start_date AND end_date)) AND id_category IN :authorized_categories) ORDER BY start_date ASC" . (CalendarConfig::load()->is_members_birthday_enabled() ? " UNION (SELECT member_extended_fields.user_born AS start_date, member_extended_fields.user_born AS end_date, display_name AS title, 'BIRTHDAY' AS type, 0 AS id_category, '" . CalendarEventContent::YEARLY . "' AS repeat_type, 100 AS repeat_number FROM " . DB_TABLE_MEMBER . " member LEFT JOIN " . DB_TABLE_MEMBER_EXTENDED_FIELDS . " member_extended_fields ON member_extended_fields.user_id = member.user_id WHERE member_extended_fields.user_born <> '' AND MONTH(FROM_UNIXTIME(member_extended_fields.user_born)) = :month AND :year > YEAR(FROM_UNIXTIME(member_extended_fields.user_born))) " : ""), array( 'month' => $month, 'year' => $year, 'first_month_day' => mktime(0, 0, 0, $month, 1, $year), 'last_month_day' => mktime(23, 59, 59, $month, $month_days, $year), 'authorized_categories' => $authorized_categories ));
Si ça fonctionne, je modifierai pour la version 5.0.9 de PHPBoost qui devrait sortir demain, sinon en effet on ne voit pas les événements le jour des anniversaires.
MickaelFR Membre non connecté
Booster Fusée
- Booster Fusée
- Voir le profil du membre MickaelFR
- Inscrit le : 20/01/2014
- Site internet
- Groupes :
J'ai une erreur :
Code TEXT :
Sorry, we encountered a problem and we cannot complete your request...
Merci
j1.seth Membre non connecté
- Administrateur
- Voir le profil du membre j1.seth
- Inscrit le : 01/09/2008
- Site internet
- Groupes :
- Chef de Projet
- Equipe Développement
MickaelFR Membre non connecté
Booster Fusée
- Booster Fusée
- Voir le profil du membre MickaelFR
- Inscrit le : 20/01/2014
- Site internet
- Groupes :
Code SQL :
Fatale : invalid query. (ERRNO 1064) You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MariaDB server version FOR the RIGHT syntax TO USE near 'UNION (SELECT member_extended_fields.user_born AS start_date, member_ext' at line 7query: (SELECT start_date, end_date, title, 'EVENT' AS TYPE, id_category, repeat_type, repeat_number FROM phpboost_calendar_events event LEFT JOIN phpboost_calendar_events_content event_content ON event_content.id = event.content_id WHERE approved = 1 AND ((start_date BETWEEN 1470002400 AND 1472680799) OR (end_date BETWEEN 1470002400 AND 1472680799) OR (1470002400 BETWEEN start_date AND end_date)) AND id_category IN ('0')) ORDER BY start_date ASC UNION (SELECT member_extended_fields.user_born AS start_date, member_extended_fields.user_born AS end_date, display_name AS title, 'BIRTHDAY' AS TYPE, 0 AS id_category, 'yearly' AS repeat_type, 100 AS repeat_number FROM phpboost_member member LEFT JOIN phpboost_member_extended_fields member_extended_fields ON member_extended_fields.user_id = member.user_id WHERE member_extended_fields.user_born '' AND MONTH(FROM_UNIXTIME(member_extended_fields.user_born)) = '8' AND '2016' > YEAR(FROM_UNIXTIME(member_extended_fields.user_born))) [0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->EXECUTE(string, array) [1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->SELECT(string, array, INT) [2] /calendar/services/CalendarService.class.php:264 - DBQuerier->SELECT(string, array) [3] /calendar/phpboost/CalendarCurrentMonthEventsCache.class.php:43 - CalendarService::get_all_current_month_events(string, string, INT) [4] /kernel/framework/io/DATA/cache/CacheManager.class.php:97 - CalendarCurrentMonthEventsCache->synchronize() [5] /calendar/phpboost/CalendarCurrentMonthEventsCache.class.php:61 - CacheManager::LOAD(string, string, string) [6] /calendar/controllers/ajax/CalendarAjaxCalendarController.class.php:103 - CalendarCurrentMonthEventsCache::LOAD() [7] /calendar/controllers/ajax/CalendarAjaxCalendarController.class.php:301 - CalendarAjaxCalendarController->build_view(HTTPRequestCustom) [8] /calendar/phpboost/CalendarModuleMiniMenu.class.php:55 - CalendarAjaxCalendarController::get_view(BOOLEAN) [9] /kernel/framework/phpboost/menu/module_mini/ModuleMiniMenu.class.php:110 - CalendarModuleMiniMenu->get_menu_content() [10] /kernel/framework/phpboost/environment/SiteDisplayGraphicalEnvironment.class.php:188 - ModuleMiniMenu->display() [11] /kernel/framework/phpboost/environment/SiteDisplayGraphicalEnvironment.class.php:85 - SiteDisplayGraphicalEnvironment->display_menus(FileTemplate) [12] /kernel/framework/mvc/response/AbstractResponse.class.php:60 - SiteDisplayGraphicalEnvironment->display(string) [13] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:88 - AbstractResponse->send() [14] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:59 - UrlControllerMapper->do_call() [15] /kernel/framework/mvc/dispatcher/Dispatcher.class.php:67 - UrlControllerMapper->CALL() [16] /kernel/framework/mvc/dispatcher/DispatchManager.class.php:43 - Dispatcher->dispatch() [17] /INDEX.php:35 - DispatchManager::dispatch(array) [URL] /site/
j1.seth Membre non connecté
- Administrateur
- Voir le profil du membre j1.seth
- Inscrit le : 01/09/2008
- Site internet
- Groupes :
- Chef de Projet
- Equipe Développement
Code PHP :
return self::$db_querier->select((CalendarConfig::load()->is_members_birthday_enabled() ? " (SELECT member_extended_fields.user_born AS start_date, member_extended_fields.user_born AS end_date, display_name AS title, 'BIRTHDAY' AS type, 0 AS id_category, '" . CalendarEventContent::YEARLY . "' AS repeat_type, 100 AS repeat_number FROM " . DB_TABLE_MEMBER . " member LEFT JOIN " . DB_TABLE_MEMBER_EXTENDED_FIELDS . " member_extended_fields ON member_extended_fields.user_id = member.user_id WHERE member_extended_fields.user_born <> '' AND MONTH(FROM_UNIXTIME(member_extended_fields.user_born)) = :month AND :year > YEAR(FROM_UNIXTIME(member_extended_fields.user_born))) UNION " : "") . "(SELECT start_date, end_date, title, 'EVENT' AS type, id_category, repeat_type, repeat_number FROM " . CalendarSetup::$calendar_events_table . " event LEFT JOIN " . CalendarSetup::$calendar_events_content_table . " event_content ON event_content.id = event.content_id WHERE approved = 1 AND ((start_date BETWEEN :first_month_day AND :last_month_day) OR (end_date BETWEEN :first_month_day AND :last_month_day) OR (:first_month_day BETWEEN start_date AND end_date)) AND id_category IN :authorized_categories) ORDER BY type ASC, start_date ASC", array( 'month' => $month, 'year' => $year, 'first_month_day' => mktime(0, 0, 0, $month, 1, $year), 'last_month_day' => mktime(23, 59, 59, $month, $month_days, $year), 'authorized_categories' => $authorized_categories ));
MickaelFR Membre non connecté
Booster Fusée
- Booster Fusée
- Voir le profil du membre MickaelFR
- Inscrit le : 20/01/2014
- Site internet
- Groupes :
Je confirme
Merci à toi Julien.
Répondre
Vous n'êtes pas autorisé à écrire dans cette catégorie