$current_group = $etab->_id; $res_current_etab = array(); $where = array(); $ljoin = array(); // - Nombre de séjours $tag_NDA = CSejour::getTagNDA($current_group); $where["tag"] = " = '{$tag_NDA}'"; $where["object_class"] = " = 'CSejour'"; $idex = new CIdSante400(); $res_current_etab["CSejour-_NDA"] = $idex->countList($where); // - Patients IPP $tag_ipp = CPatient::getTagIPP($current_group); $where["tag"] = " = '{$tag_ipp}'"; $where["object_class"] = " = 'CPatient'"; $idex = new CIdSante400(); $res_current_etab["CPatient-_IPP"] = $idex->countList($where); // - Nombre de consultations $where = array(); $consultation = new CConsultation(); $ljoin["plageconsult"] = "consultation.plageconsult_id = plageconsult.plageconsult_id"; $ljoin["users_mediboard"] = "plageconsult.chir_id = users_mediboard.user_id"; $ljoin["functions_mediboard"] = "users_mediboard.function_id = functions_mediboard.function_id"; $where["functions_mediboard.group_id"] = " = '{$current_group}'"; $res_current_etab["CConsultation"] = $consultation->countList($where, null, $ljoin); // - Lits $ljoin = array(); $where = array(); $lit = new C**t(); $ljoin["chambre"] = "lit.chambre_id = chambre.chambre_id"; $ljoin["service"] = "chambre.service_id = service.service_id"; $where["service.group_id"] = " = '{$current_group}'";