/** * load the sejours managed by user_id which has been broken by other * * @param null $user_id * @param array $object_classes * @param null $date_start * @param null $date_end * * @return CBrisDeGlace[] */ static function loadBrisForOwnObject($user_id = null, $object_classes = array(), $date_start = null, $date_end = null) { $date_start = $date_start ? $date_start : CMbDT::date(); $date_end = $date_end ? $date_end : $date_start; $user_id = $user_id ? $user_id : CMediusers::get()->_id; $bris = new CBrisDeGlace(); $ljoin = array("sejour" => "sejour.sejour_id = bris_de_glace.object_id"); $where = array("bris_de_glace.object_class" => " = 'CSejour' ", "sejour.praticien_id" => " = '{$user_id}' ", "bris_de_glace.user_id" => " != '{$user_id}' ", "bris_de_glace.date" => " BETWEEN '{$date_start} 00:00:00' AND '{$date_end} 23:59:59' "); /** @var CBrisDeGlace[] $briss */ $briss = $bris->loadList($where, "date DESC", null, null, $ljoin); return $briss; }