$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
$smarty = new CSmartyDP();
$smarty->assign("date", $date);
$smarty->assign("urgences", $horsplages);
$smarty->assign("pageUrg", $page);
/** @var CPlageOp[] $plages */
$plages = $plage->loadList($where, $order);
$operation = new COperation();
$where = array();
$where["plageop_id"] = CSQLDataSource::prepareIn(array_keys($plages));
$where["annulee"] = "= '0'";
$count = $operation->countList($where);
$operations = $operation->loadList($where, null, $limit);
/** @var CSejour[] $sejours */
$sejours = COperation::massLoadFwdRef($operations, "sejour_id");
/** @var CPatient[] $patients */
$patients = CSejour::massLoadFwdRef($sejours, "patient_id");
CSejour::massLoadNDA($sejours);
CPatient::massLoadIPP($patients);
CSejour::massCountDocItems($sejours);
COperation::massCountDocItems($operations);
$chirurgiens = COperation::massLoadFwdRef($operations, "chir_id");
CMediusers::massLoadFwdRef($chirurgiens, "function_id");
/** @var COperation[] $operations */
foreach ($operations as $_operation) {
    // Détails de l'opérations
    $_operation->loadRefChir()->loadRefFunction();
    $_operation->loadExtCodesCCAM();
    $_operation->loadRefsDocItems();
    // Détails du séjour
    $_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
$smarty = new CSmartyDP();