$order[] = "sortie";
$order[] = "entree";
$step = 30;
$limit = "{$page},{$step}";
/** @var CSejour[] $listSejours */
$count = $sejour->countList($where);
$listSejours = $sejour->loadList($where, $order, $limit);
$patients = CSejour::massLoadFwdRef($listSejours, "patient_id");
$ipps = CPatient::massLoadIPP($patients);
$ndas = CSejour::massLoadNDA($listSejours);
$praticiens = CSejour::massLoadFwdRef($listSejours, "praticien_id");
CMediusers::massLoadFwdRef($praticiens, "function_id");
CSejour::massLoadFwdRef($listSejours, "group_id");
CSejour::massLoadFwdRef($listSejours, "etablissement_sortie_id");
CSejour::massLoadFwdRef($listSejours, "service_sortie_id");
CSejour::massLoadFwdRef($listSejours, "service_sortie_id");
foreach ($listSejours as $_sejour) {
    $_sejour->_ref_patient = $patients[$_sejour->patient_id];
    $_sejour->loadRefPraticien();
    $_sejour->loadExtCodesCCAM();
    $_sejour->loadRefsFactureEtablissement();
    $_sejour->countActes();
    $_sejour->loadRefTraitementDossier();
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("date", $date);
$smarty->assign("listSejours", $listSejours);
$smarty->assign("page", $page);
$smarty->assign("count", $count);
$smarty->assign("step", $step);
$where = array();
$ljoin["sejour"] = "sejour.sejour_id = operations.sejour_id";
$where["operations.date"] = "= '{$date}'";
$where["operations.plageop_id"] = "IS NULL";
$where["operations.annulee"] = "= '0'";
$where["sejour.group_id"] = "= '" . CGroups::loadCurrent()->_id . "'";
$order = "operations.chir_id";
$step = 30;
$limit = "{$page},{$step}";
/** @var COperation[] $horsplages */
$count = $operation->countList($where, null, $ljoin);
$horsplages = $operation->loadList($where, $order, $limit, null, $ljoin);
/** @var CSejour[] $sejours */
$sejours = COperation::massLoadFwdRef($horsplages, "sejour_id");
/** @var CPatient[] $patients */
$patients = CSejour::massLoadFwdRef($sejours, "patient_id");
CSejour::massLoadNDA($sejours);
CPatient::massLoadIPP($patients);
CSejour::massCountDocItems($sejours);
COperation::massCountDocItems($horsplages);
$chirurgiens = COperation::massLoadFwdRef($horsplages, "chir_id");
CMediusers::massLoadFwdRef($chirurgiens, "function_id");
foreach ($horsplages as $_operation) {
    $_operation->loadRefChir()->loadRefFunction();
    $_operation->loadExtCodesCCAM();
    $_operation->loadRefsDocItems();
    $_operation->_ref_sejour = $sejours[$_operation->sejour_id];
    $_operation->_ref_sejour->_ref_patient = $patients[$_operation->_ref_sejour->patient_id];
    $_operation->_ref_sejour->loadRefsDocItems();
}
// Création du template