* Copyright (C) 2004-2010 Laurent Destailleur * Copyright (C) 2005-2009 Regis Houssin * Copyright (C) 2015-2024 Frédéric France * Copyright (C) 2024 MDW * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . */ /** * \file htdocs/core/boxes/box_birthdays_members.php * \ingroup member * \brief Box for members birthdays */ include_once DOL_DOCUMENT_ROOT.'/core/boxes/modules_boxes.php'; /** * Class to manage the box to show members birthdays */ class box_birthdays_members extends ModeleBoxes { public $boxcode = "birthdays_members"; public $boximg = "object_user"; public $boxlabel = "BoxTitleMemberNextBirthdays"; public $depends = array("adherent"); public $enabled = 1; /** * Constructor * * @param DoliDB $db Database handler * @param string $param More parameters */ public function __construct($db, $param = '') { global $user; $this->db = $db; $this->hidden = !($user->hasRight("adherent", "lire") && empty($user->socid)); } /** * Load data for box to show them later * * @param int $max Maximum number of records to load * @return void */ public function loadBox($max = 20) { global $conf, $user, $langs; include_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php'; include_once DOL_DOCUMENT_ROOT.'/adherents/class/adherent.class.php'; $memberstatic = new Adherent($this->db); $langs->load("boxes"); $this->max = $max; $this->info_box_head = array('text' => $langs->trans("BoxTitleMemberNextBirthdays")); if ($user->hasRight('adherent', 'lire')) { $data = array(); $tmparray = dol_getdate(dol_now(), true); $sql = "SELECT u.rowid, u.firstname, u.lastname, u.societe, u.birth, date_format(u.birth, '%d') as daya, u.email, u.statut as status, u.datefin"; $sql .= " FROM ".MAIN_DB_PREFIX."adherent as u"; $sql .= " WHERE u.entity IN (".getEntity('adherent').")"; $sql .= " AND u.statut = ".Adherent::STATUS_VALIDATED; $sql .= dolSqlDateFilter('u.birth', 0, $tmparray['mon'], 0); $sql .= " ORDER BY daya ASC"; // We want to have date of the month sorted by the day without taking into consideration the year $sql .= $this->db->plimit($max, 0); dol_syslog(get_class($this)."::loadBox", LOG_DEBUG); $resql = $this->db->query($sql); if ($resql) { $num = $this->db->num_rows($resql); $line = 0; while ($line < $num) { $data[$line] = $this->db->fetch_object($resql); $line++; } $this->db->free($resql); } if (!empty($data)) { $j = 0; while ($j < count($data)) { $memberstatic->id = $data[$j]->rowid; $memberstatic->firstname = $data[$j]->firstname; $memberstatic->lastname = $data[$j]->lastname; $memberstatic->company = $data[$j]->societe; $memberstatic->email = $data[$j]->email; $memberstatic->status = $data[$j]->status; $memberstatic->statut = $data[$j]->status; $memberstatic->datefin = $this->db->jdate($data[$j]->datefin); $dateb = $this->db->jdate($data[$j]->birth); $age = idate('Y', dol_now()) - idate('Y', $dateb); $typea = ''; $this->info_box_contents[$j][0] = array( 'td' => '', 'text' => $memberstatic->getNomUrl(1), 'asis' => 1, ); $this->info_box_contents[$j][1] = array( 'td' => 'class="center nowraponall"', 'text' => dol_print_date($dateb, "day", 'tzserver').' - '.$age.' '.$langs->trans('DurationYears') ); $this->info_box_contents[$j][2] = array( 'td' => 'class="right nowraponall"', 'text' => $typea, 'asis' => 1 ); /*$this->info_box_contents[$j][3] = array( 'td' => 'class="right" width="18"', 'text' => $memberstatic->LibStatut($objp->status, 3) );*/ $j++; } } if (is_array($data) && count($data) == 0) { $this->info_box_contents[0][0] = array( 'td' => 'class="center"', 'text' => ''.$langs->trans("None").'', ); } } else { $this->info_box_contents[0][0] = array( 'td' => 'class="nohover left"', 'text' => ''.$langs->trans("ReadPermissionNotAllowed").'' ); } } /** * Method to show box. Called when the box needs to be displayed. * * @param ?array,target?:string}> $head Array with properties of box title * @param ?array}> $contents Array with properties of box lines * @param int<0,1> $nooutput No print, only return string * @return string */ public function showBox($head = null, $contents = null, $nooutput = 0) { return parent::showBox($this->info_box_head, $this->info_box_contents, $nooutput); } }