} if ($medecin_type) { $where["type"] = "= '{$medecin_type}'"; } $order = "nom, prenom"; if ($order_col == "cp") { $order = "cp {$order_way}, nom, prenom"; } else { if ($order_col == "ville") { $order = "ville {$order_way}, nom, prenom"; } } $medecin = new CMedecin(); $count_medecins = $medecin->countList($where); /** @var CMedecin[] $medecins */ $medecins = $medecin->loadList($where, $order, "{$start_med}, {$step_med}"); foreach ($medecins as $_medecin) { $_medecin->loadRefFunction(); } $list_types = $medecin->_specs['type']->_locales; // Création du template $smarty = new CSmartyDP(); $smarty->assign("is_admin", $is_admin); $smarty->assign("dialog", $dialog); $smarty->assign("annuaire", $annuaire); $smarty->assign("nom", $medecin_nom); $smarty->assign("prenom", $medecin_prenom); $smarty->assign("cp", $medecin_cp); $smarty->assign("type", $medecin_type); $smarty->assign("medecins", $medecins); $smarty->assign("medecin", $medecin);
$list_corresp = $ds->loadHashList($query_corresp); $list_traitant = $ds->loadHashList($query_traitant); foreach ($list_traitant as $_medecin_id => $_count) { if (array_key_exists($_medecin_id, $list_corresp)) { $list_corresp[$_medecin_id] += $_count; } else { $list_corresp[$_medecin_id] = $_count; } } arsort($list_corresp); $list = $list_corresp; } $where = array("medecin_id" => $ds->prepareIn(array_keys($list))); $medecin = new CMedecin(); /** @var CMedecin[] $medecins */ $medecins = $medecin->loadList($where); if ($csv) { $csvfile = new CCSVFile(); $titles = array("Total", CAppUI::tr("CMedecin-nom"), CAppUI::tr("CMedecin-prenom"), CAppUI::tr("CMedecin-type"), CAppUI::tr("CMedecin-tel"), CAppUI::tr("CMedecin-fax"), CAppUI::tr("CMedecin-email"), CAppUI::tr("CMedecin-adresse"), CAppUI::tr("CMedecin-cp"), CAppUI::tr("CMedecin-adeli"), CAppUI::tr("CMedecin-rpps")); $csvfile->writeLine($titles); foreach ($list as $_medecin_id => $_count) { $_medecin = $medecins[$_medecin_id]; $_line = array($_count, $_medecin->nom, $_medecin->prenom, $_medecin->type, $_medecin->tel, $_medecin->fax, $_medecin->email, $_medecin->adresse, $_medecin->cp, $_medecin->adeli, $_medecin->rpps); $csvfile->writeLine($_line); } $csvfile->stream("Médecins correspondants"); } else { $smarty = new CSmartyDP(); $smarty->assign("medecins", $medecins); $smarty->assign("counts", $list); $smarty->display("inc_stats_medecins.tpl");