$patient->loadRefsCorrespondants();
$patient->loadRefsCorrespondantsPatient();
$correspondantsMedicaux = array();
if ($patient->_ref_medecin_traitant->_id) {
$correspondantsMedicaux["traitant"] = $patient->_ref_medecin_traitant;
}
foreach ($patient->_ref_medecins_correspondants as $correspondant) {
$correspondantsMedicaux["correspondants"][] = $correspondant->_ref_medecin;
}
$medecin_adresse_par = "";
if ($sejour->adresse_par_prat_id && $sejour->adresse_par_prat_id != $patient->_ref_medecin_traitant->_id) {
$medecin_adresse_par = new CMedecin();
$medecin_adresse_par->load($sejour->adresse_par_prat_id);
}
// Chargement des etablissements externes
$etab = new CEtabExterne();
$count_etab_externe = $etab->countList();
$sejours =& $patient->_ref_sejours;
$config = CAppUI::conf("dPplanningOp CSejour");
$hours = range($config["heure_deb"], $config["heure_fin"]);
$mins = range(0, 59, $config["min_intervalle"]);
$config = CAppUI::conf("dPplanningOp COperation");
$hours_duree = array("deb" => $config["duree_deb"], "fin" => $config["duree_fin"]);
$hours_urgence = array("deb" => $config["hour_urgence_deb"], "fin" => $config["hour_urgence_fin"]);
$mins_duree = $config["min_intervalle"];
$config = CAppUI::conf("dPplanningOp CSejour");
$heure_sortie_ambu = $config["heure_sortie_ambu"];
$heure_sortie_autre = $config["heure_sortie_autre"];
$heure_entree_veille = $config["heure_entree_veille"];
$heure_entree_jour = $config["heure_entree_jour"];
// Récupération de la liste des services
/**
* Récupération de l'établissement de provenance
*
* @param DOMNode $node ZFV Node
* @param CSejour $newVenue Admit
*
* @return void
*/
function getEtablissementProvenance(DOMNode $node, CSejour $newVenue)
{
if (!($finess = $this->queryTextNode("ZFV.1/DLD.1", $node))) {
return;
}
$etab_ext = new CEtabExterne();
$etab_ext->finess = $finess;
if (!$etab_ext->loadMatchingObjectEsc()) {
return;
}
$newVenue->etablissement_entree_id = $etab_ext->_id;
}
break;
// Nombre de transferts
// Nombre de transferts
case "transfers_count":
$data[$axe] = array("options" => array("title" => utf8_encode("Nombre de transferts")), "series" => array());
$series =& $data[$axe]['series'];
$sejour = new CSejour();
$end = end($dates);
$start = reset($dates);
$query = new CRequest();
$query->addSelect("sejour.etablissement_sortie_id");
$query->addTable("sejour");
$query->addGroup("sejour.etablissement_sortie_id");
$query->addWhere(array("sejour.entree" => "BETWEEN '{$start}' AND '{$end}'", "sejour.etablissement_sortie_id" => "IS NOT NULL"));
$etab_externe_ids = $sejour->_spec->ds->loadColumn($query->makeSelect());
$etab_externe = new CEtabExterne();
$etabs = $etab_externe->loadList(array($etab_externe->_spec->key => $etab_externe->_spec->ds->prepareIn($etab_externe_ids)));
$etabs["none"] = $etab_externe;
$etabs["none"]->_view = "Non renseigné";
$where["sejour.mode_sortie"] = "= 'transfert'";
$key = 0;
foreach ($etabs as $_id => $_etab) {
$series[$key] = array('data' => array(), 'label' => utf8_encode($_etab->_view));
$sub_total = 0;
foreach ($dates as $i => $_date) {
$_date_next = CMbDT::date("+1 {$period}", $_date);
$where['sejour.entree'] = "BETWEEN '{$_date}' AND '{$_date_next}'";
$where['sejour.etablissement_sortie_id'] = $_id === "none" ? "IS NULL" : "= '{$_id}'";
$count = $sejour->countList($where, null, $ljoin);
$total += $count;
$sub_total += $count;
<?php
/**
* $Id: vw_etab_externe.php 27432 2015-03-04 14:42:02Z flaviencrochard $
*
* @package Mediboard
* @subpackage dPetablissement
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision: 27432 $
*/
CCanDo::checkRead();
$start = intval(CValue::get("start", 0));
$keywords = CValue::get("keywords");
$etab_externe = new CEtabExterne();
$list_tab_externes = $etab_externe->seek($keywords ? $keywords : "%", null, "{$start}, 40", true, null, "nom, cp, ville");
$total_etab_externes = $etab_externe->_totalSeek;
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("total_etab_externes", $total_etab_externes);
$smarty->assign("list_etab_externes", $list_tab_externes);
$smarty->assign("current_page", $start);
$smarty->assign("keywords", $keywords);
$smarty->display("vw_etab_externe.tpl");
<?php
/**
* $Id$
*
* @package Mediboard
* @subpackage dPetablissement
* @author SARL OpenXtrem <*****@*****.**>
* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html
* @version $Revision$
*/
CCanDo::checkRead();
// Recuperation de l'id de l'etablissement externe
$etab_id = CValue::getOrSession("etab_id");
// Récupération des etablissements externes
$etab_externe = new CEtabExterne();
if ($etab_id) {
$etab_externe->load($etab_id);
$etab_externe->loadRefsNotes($etab_id);
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("etab_externe", $etab_externe);
$smarty->display("inc_etab_externe.tpl");
return;
} else {
CAppUI::setMsg("{$nbFiles} fichiers extraits", UI_MSG_OK);
}
$files = glob("{$dir}/*.csv");
foreach ($files as $_file) {
$fp = fopen($_file, "r");
$csv = new CCSVFile($fp);
$csv->readLine();
// first line
while ($line = $csv->readLine()) {
if (!isset($line[1])) {
continue;
}
$line = array_map("getValue", $line);
$etab = new CEtabExterne();
$etab->finess = getNum($line[0]);
if ($etab->loadMatchingObject()) {
continue;
}
$etab->siret = getNum($line[1]);
$etab->ape = $line[2];
$etab->nom = $line[3];
$etab->raison_sociale = $line[3];
$etab->adresse = "{$line['4']}\n{$line['5']}\n{$line['6']}";
$etab->cp = $line[7];
$etab->ville = $line[8];
$etab->tel = getNum($line[9]);
$etab->fax = getNum($line[10]);
$etab->repair();
$type = $etab->_id ? "modify" : "create";
