$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