$salle = new CSalle(); $where["bloc_id"] = "= '{$bloc_id}'"; $salles = $salle->loadListWithPerms(PERM_READ, $where); // Récupération des opérations $ljoin = array(); $ljoin["plagesop"] = "operations.plageop_id = plagesop.plageop_id"; $where = array(); $in_salles = CSQLDataSource::prepareIn(array_keys($salles)); $where[] = "plagesop.salle_id {$in_salles} OR operations.salle_id {$in_salles}"; $where["materiel"] = "!= ''"; $where[] = " operations.date BETWEEN '{$date_min}' AND '{$date_max}'"; if ($praticien_id) { $where["operations.chir_id"] = " = '{$praticien_id}'"; } elseif ($function_id) { $mediuser = new CMediusers(); $users = $mediuser->loadProfessionnelDeSante(PERM_READ, $function_id); $where["operations.chir_id"] = CSQLDataSource::prepareIn(array_keys($users)); } $order = "operations.date, rank"; $operation = new COperation(); $ops = $operation->loadList($where, $order, null, "operation_id", $ljoin); $operations = array(); $commande = new CCommandeMaterielOp(); foreach ($commande->_specs["etat"]->_list as $spec) { $operations[$spec] = array(); } foreach ($ops as $_op) { /** @var COperation $_op */ $_op->loadRefPatient(); $_op->loadRefChir()->loadRefFunction(); $_op->loadRefPlageOp();
* @version $Revision: 7320 $ * @author SARL OpenXtrem * @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html */ //CCanDo::checkRead(); $choix = CValue::get("choix", "mois"); $filter = new CPlageAstreinte(); $filter->user_id = CValue::get("user_id", CAppUI::$user->_id); $filter->start = CValue::get("date_debut", CMbDT::date()); // Tableau des jours fériés sur 2 ans, car // en mode semaine : 31 décembre - 1 janvier $bank_holidays = array_merge(CMbDate::getHolidays($filter->start), CMbDate::getHolidays(CMbDT::transform("+1 YEAR", $filter->start, "%Y-%m-%d"))); $mediuser = new CMediusers(); switch ($filter->user_id) { case '-1': $mediusers = $mediuser->loadProfessionnelDeSante(); $filter->user_id = ""; break; case '-2': $mediusers = $mediuser->loadNonProfessionnelDeSante(); $filter->user_id = ""; break; default: $mediusers = $mediuser->loadListFromType(); break; } if (!$filter->start) { $filter->start = Date("Y-m-d"); } // Si la date rentrée par l'utilisateur est un lundi, // on calcule le dimanche d'avant et on rajoute un jour.