}
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");
