/**
* Charge les consultations du patient
*
* @param array|null $where [optional] Clauses SQL
*
* @return CConsultation[]
*/
function loadRefsConsultations($where = null)
{
$consultation = new CConsultation();
$group_id = CGroups::loadCurrent()->_id;
$curr_user = CAppUI::$user;
if ($this->_id) {
if ($where === null) {
$where = array();
}
if (!$curr_user->isAdmin()) {
$where[] = "functions_mediboard.consults_partagees = '1' ||\r\n (functions_mediboard.consults_partagees = '0' && functions_mediboard.function_id = '{$curr_user->function_id}')";
}
$where["patient_id"] = "= '{$this->_id}'";
if (CAppUI::conf("dPpatients CPatient multi_group") == "hidden") {
$where["functions_mediboard.group_id"] = "= '{$group_id}'";
}
$order = "plageconsult.date DESC, consultation.heure DESC";
$leftjoin = array();
$leftjoin["plageconsult"] = "consultation.plageconsult_id = plageconsult.plageconsult_id";
$leftjoin["users_mediboard"] = "plageconsult.chir_id = users_mediboard.user_id";
$leftjoin["functions_mediboard"] = "users_mediboard.function_id = functions_mediboard.function_id";
return $this->_ref_consultations = $consultation->loadList($where, $order, null, null, $leftjoin);
}
return $this->_ref_consultations = array();
}
* @link http://www.mediboard.org
*/
CCanDo::checkRead();
$date = CValue::get("date", CMbDT::date());
$group = CGroups::loadCurrent();
$consultation = new CConsultation();
$where = array();
$where["consultation.grossesse_id"] = "IS NOT NULL";
$where["plageconsult.date"] = "= '{$date}'";
$where["group_id"] = " = '{$group->_id}'";
$ljoin = array();
$ljoin["plageconsult"] = "plageconsult.plageconsult_id = consultation.plageconsult_id";
$ljoin["users_mediboard"] = "plageconsult.chir_id = users_mediboard.user_id";
$ljoin["functions_mediboard"] = "functions_mediboard.function_id = users_mediboard.function_id";
$order = "heure ASC";
/** @var CConsultation[] $listConsults */
$listConsults = $consultation->loadList($where, $order, null, null, $ljoin);
$plage = CMbObject::massLoadFwdRef($listConsults, "plageconsult_id");
CMbObject::massLoadFwdRef($plage, "chir_id");
CMbObject::massLoadFwdRef($listConsults, "sejour_id");
$grossesses = CMbObject::massLoadFwdRef($listConsults, "grossesse_id");
CMbObject::massLoadFwdRef($grossesses, "parturiente_id");
foreach ($listConsults as $_consult) {
$_consult->loadRefPraticien();
$_consult->loadRefSejour()->loadRefGrossesse();
$_consult->loadRefGrossesse()->loadRefParturiente();
}
$smarty = new CSmartyDP();
$smarty->assign("date", $date);
$smarty->assign("listConsults", $listConsults);
$smarty->display("inc_tdb_consultations.tpl");
$transmission = new CTransmissionMedicale();
$transmissions = array_merge($transmissions, $transmission->loadList($whereTrans, "date"));
CStoredObject::massLoadFwdRef($transmissions, "user_id");
array_multisort(CMbArray::pluck($transmissions, "date"), SORT_ASC, $transmissions);
// Observations
$observation = new CObservationMedicale();
$whereObs = $where;
$whereObs["date"] = "BETWEEN '{$datetime_delta}' AND '{$datetime_avg}'";
$observations = $observation->loadList($whereObs, "date");
CStoredObject::massLoadFwdRef($observations, "user_id");
// Consultations
$consultation = new CConsultation();
$whereConsult = $where;
$whereConsult["plageconsult.date"] = "BETWEEN '{$datetime_delta}' AND '{$datetime_avg}'";
$ljoin = array("plageconsult" => "plageconsult.plageconsult_id = consultation.plageconsult_id");
$consultations = $consultation->loadList($whereConsult, "plageconsult.date", null, null, $ljoin);
CStoredObject::massLoadFwdRef($consultations, "plageconsult_id");
$smarty_cstes = new CSmartyDP("modules/dPpatients");
$smarty_cstes->assign("empty_lines", 2);
$smarty_cstes->assign("offline", 1);
// Constantes des 12 dernières heures
$where_cste = array("datetime" => "BETWEEN '" . CMbDT::subDateTime("12:00:00", $datetime_avg) . "' AND '{$datetime_avg}'");
CPrescriptionLine::$_offline_lite = true;
CPrescriptionLineMix::$_offline_lite = true;
CPrescription::$_offline_lite = true;
foreach ($sejours as $_sejour) {
$patient = $_sejour->loadRefPatient();
$_sejour->loadRefPraticien();
$_sejour->loadJourOp($date);
if ($service_id == "urgence") {
$_sejour->_veille = CMbDT::date($_sejour->entree) != $date;
$where = array();
$where["sejour.entree"] = " BETWEEN '{$debut}' AND '{$fin}'";
$where["sejour.annule"] = "= '0'";
$where["consultation.annule"] = "= '0'";
if (!$interv_with_no_codes) {
$where[] = "LENGTH(consultation.codes_ccam) > 0";
}
if ($all_prats) {
$prats = $user->loadPraticiens(PERM_READ);
$where["plageconsult.chir_id"] = CSQLDataSource::prepareIn(array_keys($prats));
} else {
$where["plageconsult.chir_id"] = "= '{$user->_id}'";
}
/* @var CConsultation[] $consultations*/
$consultation = new CConsultation();
$consultations = $consultation->loadList($where, null, null, null, $ljoin);
$totals["consultations"] = count($consultations);
/** @var CPlageConsult[] $plages */
$plages = CStoredObject::massLoadFwdRef($consultations, "plageconsult_id");
CStoredObject::massLoadFwdRef($consultations, "sejour_id");
CStoredObject::massLoadFwdRef($consultations, "patient_id");
// Pré-chargement des users
$where = array("user_id" => CSQLDataSource::prepareIn(CMbArray::pluck($plages, "chir_id")));
$user->loadList($where);
/** @var CMediusers[] $chirs */
$chirs = CStoredObject::massLoadFwdRef($plages, "chir_id");
CStoredObject::massLoadFwdRef($chirs, "function_id");
CStoredObject::massLoadBackRefs($consultations, "actes_ccam");
foreach ($consultations as $key => $_consult) {
// Chargemement des codes CCAM
$_consult->loadExtCodesCCAM();
$chir_id = CValue::get("chir_id");
$function_id = CValue::get("function_id");
$list_chir_ids = array();
$user = new CMediusers();
$user->load($chir_id);
$ds = $user->getDS();
if ($function_id) {
$users = CConsultation::loadPraticiens(PERM_EDIT, $function_id);
$list_chir_ids = array_keys($users);
} else {
$list_chir_ids = array($chir_id);
}
// Liste des consultations a avancer si desistement
$now = CMbDT::date();
$where = array("plageconsult.date" => " > '{$now}'", "plageconsult.chir_id" => $ds->prepareIn($list_chir_ids), "consultation.si_desistement" => "= '1'", "consultation.annule" => "= '0'");
$ljoin = array("plageconsult" => "plageconsult.plageconsult_id = consultation.plageconsult_id");
$consultation_desist = new CConsultation();
/** @var CConsultation[] $consultations */
$consultations = $consultation_desist->loadList($where, "date, heure", null, null, $ljoin);
foreach ($consultations as $_consult) {
$_consult->loadRefPatient();
$_consult->loadRefPlageConsult();
$_consult->loadRefCategorie();
$_consult->loadRefPraticien()->loadRefFunction();
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("consultations", $consultations);
$smarty->assign("function_id", $function_id);
$smarty->assign("user", $user);
$smarty->display("inc_list_consult_si_desistement.tpl");
$where_consult[] = $where_examen;
}
if ($traitement_consult) {
$where_traitement = "`traitement` LIKE '%{$traitement_consult}%'";
$where_consult[] = $where_traitement;
}
if ($where_consult) {
$where_consult = implode(" OR ", $where_consult);
}
}
$patients_consult = array();
$order_consult = "patient_id";
$total_consults = null;
if ($where_consult) {
$total_consults = $consult->countList($where_consult);
$consultations = $consult->loadList($where_consult, $order_consult, "{$page_consult}, 30");
}
foreach ($consultations as $value) {
$value->loadRefPatient();
}
// Recherche sur les sejours
/** @var CSejour[] $sejours */
$sejours = array();
$sejour = new CSejour();
$patients_sejour = array();
$where_sejour = null;
if ($recherche_sejour == "and") {
if ($typeAdmission_sejour) {
$where_sejour["type"] = "LIKE '%{$typeAdmission_sejour}%'";
}
if ($convalescence_sejour) {
/**
* Load consultations
*
* @param bool $withCanceled Include cancelled consults
* @param bool $withClosed Include closed consults
* @param bool $withPayees Include payed consults
*
* @return CConsultation[]
*/
function loadRefsConsultations($withCanceled = true, $withClosed = true, $withPayees = true)
{
$where["plageconsult_id"] = "= '{$this->_id}'";
if (!$withCanceled) {
$where["annule"] = "= '0'";
}
if (!$withClosed) {
$where["chrono"] = "!= '" . CConsultation::TERMINE . "'";
}
$order = "heure";
$consult = new CConsultation();
$this->_ref_consultations = $consult->loadList($where, $order);
foreach ($this->_ref_consultations as $_consult) {
$this->_cumulative_minutes += $_consult->duree * $this->_freq_minutes;
}
if (!$withPayees) {
foreach ($this->_ref_consultations as $key => $consult) {
/** @var CConsultation $consult */
$facture = $consult->loadRefFacture();
if ($facture->_id && $facture->patient_date_reglement) {
unset($this->_ref_consultations[$key]);
}
}
}
return $this->_ref_consultations;
}
$prat = $consultation->_ref_plageconsult->_ref_chir;
$prat->loadRefs();
$patient = $consultation->_ref_patient;
$patient->loadRefs();
$prat->loadRefFunction();
$chir_ids = array_keys($prat->_ref_function->loadRefsUsers());
$ds = $consultation->getDS();
// nexts rdvs for the same function
$ljoin = array("plageconsult" => "plageconsult.plageconsult_id = consultation.plageconsult_id");
$where = array();
$where["date"] = ">= '{$date}' ";
$where["patient_id"] = " = '{$consultation->patient_id}' ";
$where[] = "plageconsult.chir_id " . $ds->prepareIn($chir_ids) . " OR plageconsult.remplacant_id " . $ds->prepareIn($chir_ids);
$where["annule"] = " != '1' ";
$where[$consultation->_spec->key] = " != '{$consultation->_id}'";
/** @var CConsultation[] $consultations */
$consultations = $consultation->loadList($where, "date ASC, heure ASC", null, null, $ljoin);
foreach ($consultations as $_consult) {
$_consult->_ref_patient = $consultation->_ref_patient;
$_consult->loadRefPraticien()->loadRefFunction();
$_consult->_ref_plageconsult->loadRefRemplacant();
}
$today = CMbDT::date();
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("consultation", $consultation);
$smarty->assign("consultations", $consultations);
$smarty->assign("patient", $patient);
$smarty->assign("prat", $prat);
$smarty->assign("today", $today);
$smarty->display("view_consultation.tpl");
/**
* Chargement de toutes les consultations de la facture
*
* @return object
**/
function loadRefsConsultation()
{
if (count($this->_ref_consults)) {
return $this->_ref_consults;
}
$consult = new CConsultation();
if ($this->_id) {
if (CModule::getActive("dPfacturation")) {
$ljoin = array();
$ljoin["facture_liaison"] = "facture_liaison.object_id = consultation.consultation_id";
$where = array();
$where["facture_liaison.facture_id"] = " = '{$this->_id}'";
$where["facture_liaison.facture_class"] = " = '{$this->_class}'";
$where["facture_liaison.object_class"] = " = 'CConsultation'";
$this->_ref_consults = $consult->loadList($where, null, null, "consultation.consultation_id", $ljoin);
}
} elseif ($this->_consult_id) {
$consult->consultation_id = $this->_consult_id;
$this->_ref_consults = $consult->loadMatchingList();
}
if (count($this->_ref_consults) > 0) {
// Chargement des actes de consultations
foreach ($this->_ref_consults as $_consult) {
$_consult->loadRefPlageConsult();
$_consult->loadRefsActes($this->numero, 1);
$_consult->loadExtCodesCCAM();
$this->rangeActes($_consult);
}
$this->_ref_last_consult = end($this->_ref_consults);
$this->_ref_first_consult = reset($this->_ref_consults);
} else {
$this->_ref_last_consult = new CConsultation();
$this->_ref_first_consult = new CConsultation();
}
return $this->_ref_consults;
}
}
}
}
//consultations
$consult = new CConsultation();
$whereC = array();
$whereC["plageconsult_id"] = " = '{$_plage->_id}' ";
$whereC["annule"] = " = '{$show_cancelled}'";
if ($status) {
$whereC["chrono"] = " = '{$status}'";
}
if ($facturated) {
$whereC["facture"] = " = '1'";
}
/** @var CConsultation[] $consults */
$consults = $consult->loadList($whereC, "heure");
foreach ($consults as $_consult) {
if ($_consult->heure < $min_hour) {
$min_hour = CMbDT::format($_consult->heure, "%H");
}
if ($actes != "") {
$_actes = $_consult->loadRefsActes();
$nb_actes = $_consult->_count_actes;
// avec des actes
if ($actes && !$nb_actes) {
continue;
}
// sans actes
if ($actes === "0" && $nb_actes > 0) {
continue;
}
$group = CGroups::loadCurrent();
$consultation = new CConsultation();
$where = array();
$where["consultation.grossesse_id"] = "IS NOT NULL";
$where["consultation.annule"] = "= '0'";
$where["plageconsult.date"] = "= '{$date}'";
$where["functions_mediboard.group_id"] = "= '{$group->_id}'";
$ljoin = array();
$ljoin["plageconsult"] = "plageconsult.plageconsult_id = consultation.plageconsult_id";
$ljoin["users_mediboard"] = "plageconsult.chir_id = users_mediboard.user_id";
$ljoin["functions_mediboard"] = "functions_mediboard.function_id = users_mediboard.function_id";
$curr_user = CMediusers::get();
if ($curr_user->isPraticien() || $curr_user->isSageFemme()) {
$where["plageconsult.chir_id"] = "= '{$curr_user->_id}'";
}
/** @var CConsultation[] $listConsults */
$listConsults = $consultation->loadList($where, "heure ASC", null, null, $ljoin);
$plages = CStoredObject::massLoadFwdRef($listConsults, "plageconsult_id");
CStoredObject::massLoadFwdRef($plages, "chir_id");
CStoredObject::massLoadFwdRef($listConsults, "sejour_id");
$grossesses = CStoredObject::massLoadFwdRef($listConsults, "grossesse_id");
CStoredObject::massLoadFwdRef($grossesses, "parturiente_id");
foreach ($listConsults as $_consult) {
$_consult->loadRefPraticien();
$_consult->loadRefSejour()->loadRefGrossesse();
$_consult->loadRefGrossesse()->loadRefParturiente();
}
$smarty = new CSmartyDP();
$smarty->assign("date", $date);
$smarty->assign("listConsults", $listConsults);
$smarty->display("inc_tdb_consultations.tpl");
$plageconsult_id = $plageSel->plageconsult_id;
}
$plageSel->loadRefsFwd(1);
$plageSel->loadRefsNotes();
$plageSel->loadRefsBack();
//check 3333tel
if (CModule::getActive("3333tel")) {
C3333TelTools::checkPlagesConsult($plageSel, $plageSel->_ref_chir->function_id);
}
$pause = new CConsultation();
//find the unique pause;
if ($plageSel->_id) {
$where_p = array();
$where_p["plageconsult_id"] = " = '{$plageSel->_id}' ";
$where_p["patient_id"] = " IS NULL";
$list = $pause->loadList($where_p);
if (count($list) == 1) {
/** @var CConsultation $pause */
$pause = reset($list);
$plageSel->_pause = $pause->heure;
$plageSel->_pause_id = $pause->_id;
$plageSel->_pause_repeat_time = $pause->duree;
}
}
if ($plageSel->_affected) {
$firstconsult = reset($plageSel->_ref_consultations);
$_firstconsult_time = substr($firstconsult->heure, 0, 5);
$lastconsult = end($plageSel->_ref_consultations);
$_lastconsult_time = substr($lastconsult->heure, 0, 5);
}
// Détails sur les consultation affichées
CCanDo::checkEdit();
$consult_id = CValue::get("consult_id");
$first_consult = new CConsultation();
$first_consult->load($consult_id);
$plage_consult = $first_consult->loadRefPlageConsult();
$first_consult->loadRefPatient();
$first_consult->loadRefPraticien();
$date = $plage_consult->date;
$praticien = new CMediusers();
$praticiens = $praticien->loadPraticiens(PERM_EDIT);
$next_consult = new CConsultation();
$ljoin = array();
$where = array();
$where["patient_id"] = " = '{$first_consult->patient_id}'";
$where["date"] = " >= '{$date}'";
$ljoin["plageconsult"] = "plageconsult.plageconsult_id = consultation.plageconsult_id";
/** @var CConsultation[] $next_consults */
$next_consults = $next_consult->loadList($where, "date ASC", null, null, $ljoin);
foreach ($next_consults as $_key => $_consult) {
$_consult->loadRefPraticien();
//no rights on prat, skip the consult
if (!$_consult->_ref_praticien->canDo()->edit) {
unset($next_consults[$_key]);
}
}
//smarty
$smarty = new CSmartyDP();
$smarty->assign("consults", $next_consults);
$smarty->assign("consult", $first_consult);
$smarty->assign("praticiens", $praticiens);
$smarty->display("inc_edit_multiconsult.tpl");
