PHP CSejour::countList方法代码示例

$date = CValue::getOrSession("date", CMbDT::date());
$page = CValue::get("page", 0);
$next = CMbDT::date("+1 day", $date);
$sejour = new CSejour();
$where = array();
$where["entree"] = "< '{$next}'";
$where["sortie"] = "> '{$date}'";
$where["group_id"] = "= '{$group->_id}'";
$where["annule"] = "= '0'";
$order = array();
$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();

$whereVeille["type"] = "= 'comp'";
$countPresentVeille = $sejourVeille->countList($whereVeille);
// entree du jour
$sejourEntreeJour = new CSejour();
$whereEntree = array();
$whereEntree["sejour.entree"] = "BETWEEN '{$date_debut}' AND '{$date_fin}'";
$whereEntree["annule"] = "= '0'";
$whereEntree["type"] = "= 'comp'";
$countEntreeJour = $sejourEntreeJour->countList($whereEntree);
// sorties du jour
$sejourSortieJour = new CSejour();
$whereSortie = array();
$whereSortie["sejour.sortie"] = "BETWEEN '{$date_debut}' AND '{$date_fin}'";
$whereSortie["annule"] = "= '0'";
$whereSortie["type"] = "= 'comp'";
$countSortieJour = $sejourSortieJour->countList($whereSortie);
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("date", $date);
$smarty->assign("totalHospi", $totalHospi);
$smarty->assign("totalMedecin", $totalMedecin);
$smarty->assign("totalAmbulatoire", $totalAmbulatoire);
$smarty->assign("services", $services);
$smarty->assign("list_affectations", $list_affectations);
$smarty->assign("total_service", $total_service);
$smarty->assign("countPresentVeille", $countPresentVeille);
$smarty->assign("countSortieJour", $countSortieJour);
$smarty->assign("countEntreeJour", $countEntreeJour);
$smarty->assign("countPresentJour", $countPresentJour);
$smarty->assign("listPrat", $listPrat);
$smarty->assign("totalPrat", $totalPrat);

$ds = CSQLDataSource::get("std");
// Sejours pour lesquels le kine est référent
if ($mode == "count" || $mode == "referenced") {
    $join = array();
    $join["patients"] = "patients.patient_id = sejour.patient_id";
    $order = "nom, prenom";
    $join["bilan_ssr"] = "bilan_ssr.sejour_id = sejour.sejour_id";
    $join["technicien"] = "technicien.technicien_id = bilan_ssr.technicien_id";
    $where = array();
    $where["sejour.type"] = "= 'ssr'";
    $where["sejour.entree"] = "<= '{$planning->date_max}'";
    $where["sejour.sortie"] = ">= '{$planning->date_min}'";
    $where["sejour.annule"] = "= '0'";
    $where["technicien.kine_id"] = "= '{$kine_id}'";
    if ($mode == "count") {
        $counts["referenced"] = $sejour->countList($where, null, $join);
    } else {
        $sejours = $sejour->loadList($where, $order, null, null, $join);
    }
}
// Sejours pour lesquels le kine est remplaçant
if ($mode == "count" || $mode == "replaced") {
    $order = "nom, prenom";
    $join = array();
    $join["patients"] = "patients.patient_id = sejour.patient_id";
    $join["replacement"] = "replacement.sejour_id = sejour.sejour_id";
    $join["plageconge"] = "plageconge.plage_id = replacement.conge_id";
    $where = array();
    $where["sejour.type"] = "= 'ssr'";
    $where["sejour.entree"] = "<= '{$planning->date_max}'";
    $where["sejour.sortie"] = ">= '{$planning->date_min}'";

    }
    if ($consult->adresse_par_prat_id && $consult->adresse_par_prat_id != $pat->_ref_medecin_traitant->_id) {
        $consult->loadRefAdresseParPraticien();
    }
    // grossesse
    if (CModule::getActive("maternite")) {
        $consult->loadRefGrossesse();
    }
    $sejour = new CSejour();
    $whereSejour = array();
    $group = CGroups::loadCurrent();
    $whereSejour["type"] = "!= 'consult'";
    $whereSejour[] = "'{$consult->_date}' BETWEEN DATE(entree) AND DATE(sortie)";
    $whereSejour["patient_id"] = "= '{$consult->patient_id}'";
    $whereSejour["group_id"] = "= '{$group->_id}'";
    $consult->_count_matching_sejours = $sejour->countList($whereSejour);
    //next consultation ?
    $dateW = $consult->_ref_plageconsult->date;
    $where = array();
    $whereN["patient_id"] = " = '{$consult->patient_id}'";
    $whereN["date"] = " >= '{$dateW}'";
    $ljoin["plageconsult"] = "plageconsult.plageconsult_id = consultation.plageconsult_id";
    $count_next_plage = $consult->countList($whereN, null, $ljoin);
}
if (!$modal) {
    // Save history
    $params = array("consult_urgence_id" => $consult_urgence_id, "consultation_id" => $consultation_id, "plageconsult_id" => $plageconsult_id, "sejour_id" => $sejour_id, "date_planning" => $date_planning, "grossesse_id" => $grossesse_id);
    $object = null;
    $type = CViewHistory::TYPE_VIEW;
    if ($consultation_id) {
        $object = $consult;

    $where["sejour.type"] = "!= 'urg'";
}
if ($_type_admission != "seances") {
    $where[] = "affectation.affectation_id IS NULL";
}
if ($where_service) {
    $where[] = $where_service;
}
$leftjoin["affectation"] = "sejour.sejour_id = affectation.sejour_id";
// Filtre sur les fonctions
if ($filterFunction) {
    $leftjoin["users_mediboard"] = "sejour.praticien_id = users_mediboard.user_id";
    $where["users_mediboard.function_id"] = " = '{$filterFunction}'";
}
$sejour = new CSejour();
$alerte = $sejour->countList($where, null, $leftjoin);
CApp::$chrono->stop("Patient à placer dans la semaine");
CApp::$chrono->start();
$affectation = new CAffectation();
$affectation->entree = CMbDT::addDateTime("08:00:00", $date);
$affectation->sortie = CMbDT::addDateTime("23:00:00", $date);
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("services_ids", $services_ids);
$smarty->assign("affectation", $affectation);
$smarty->assign("date", $date);
$smarty->assign("demain", CMbDT::date("+ 1 day", $date));
$smarty->assign("heureLimit", $heureLimit);
$smarty->assign("mode", $mode);
$smarty->assign("emptySejour", $emptySejour);
$smarty->assign("filterFunction", $filterFunction);

    if ($convalescence_sejour) {
        $where_convalescence = "`convalescence` LIKE '%{$convalescence_sejour}%'";
        $where_sejour[] = $where_convalescence;
    }
    if ($remarque_sejour) {
        $where_remarque = "`rques` LIKE '%{$remarque_sejour}%'";
        $where_sejour[] = $where_remarque;
    }
    if ($where_sejour) {
        $where_sejour = implode(" OR ", $where_sejour);
    }
}
$order_sejour = "patient_id";
$total_sejours = null;
if ($where_sejour) {
    $total_sejours = $sejour->countList($where_sejour);
    $sejours = $sejour->loadList($where_sejour, $order_sejour, "{$page_sejour}, 30");
}
foreach ($sejours as $value) {
    $value->loadRefPatient();
}
// Recherches sur les Interventions
/** @var COperation[] $interventions */
$interventions = array();
$intervention = new COperation();
$patients_intervention = array();
$where_intervention = null;
if ($recherche_intervention == "and") {
    if ($materiel_intervention) {
        $where_intervention["materiel"] = "LIKE '%{$materiel_intervention}%'";
    }

    $sejour = new CSejour();
    $action = CValue::get("action", "start");
    // Tous les départs possibles
    $idMins = array("start" => CValue::get("id_start", "000000"), "continue" => CValue::getOrSession("idContinue"), "retry" => CValue::getOrSession("idRetry"));
    $idMin = CValue::first(@$idMins[$action], "000000");
    CValue::setSession("idRetry", $idMin);
    // Requêtes
    $where = array();
    $where[$sejour->_spec->key] = "> '{$idMin}'";
    $where['annule'] = " = '0'";
    $date_min = CValue::getOrSession('date_min', CMbDT::dateTime("-7 day"));
    $date_max = CValue::getOrSession('date_max', CMbDT::dateTime("+1 day"));
    // Bornes
    $where['entree'] = " BETWEEN '{$date_min}' AND '{$date_max}'";
    // Comptage
    $count_sejours = $sejour->countList($where);
    $max = min(CValue::get("count", 30), $count_sejours);
    CAppUI::stepAjax("Export de {$max} sur {$count_sejours} objets de type 'CSejour' à partir de l'ID '{$idMin}'", UI_MSG_OK);
    // Time limit
    $seconds = max($max / 20, 120);
    CAppUI::stepAjax("Limite de temps du script positionné à '{$seconds}' secondes", UI_MSG_OK);
    CApp::setTimeLimit($seconds);
    // Export réel
    $sejours = $sejour->loadList($where, $sejour->_spec->key, "0, {$max}");
}
$errors = 0;
$exchange = 0;
foreach ($sejours as $_sejour) {
    $_sejour->loadRefPraticien();
    $_sejour->loadRefPatient();
    $_sejour->loadNDA($receiver->group_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;
         $series[$key]['data'][$i] = array($i, intval($count));
     }
     $series[$key]['subtotal'] = $sub_total;
     $key++;
 }
 // suppression des series vides
 foreach ($series as $_key => $_serie) {
     if ($_serie['subtotal'] == 0) {
         unset($series[$_key]);
     }
 }
 $series = array_values($series);
 break;

if ($current_m == "ssr") {
    $sejour->_type_admission = "ssr";
}
$sejour->service_id = $service_id;
$sejour->praticien_id = $prat_id;
// Liste des séjours en attente de validation
$g = CGroups::loadCurrent()->_id;
$where = array();
$where["group_id"] = "= '{$g}'";
$where["recuse"] = "= '-1'";
$where["annule"] = "= '0'";
if ($current_m == "ssr") {
    $where["type"] = "= 'ssr'";
}
$where["entree"] = ">= '" . CMbDT::date() . "'";
$nb_sejours_attente = $sejour->countList($where);
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("current_m", $current_m);
$smarty->assign("sejour", $sejour);
$smarty->assign("date_demain", $date_demain);
$smarty->assign("date_actuelle", $date_actuelle);
$smarty->assign("date", $date);
$smarty->assign("recuse", $recuse);
$smarty->assign("envoi_mail", $envoi_mail);
$smarty->assign("order_way", $order_way);
$smarty->assign("order_col", $order_col);
$smarty->assign("services", $services);
$smarty->assign("prats", $prats);
$smarty->assign("hier", $hier);
$smarty->assign("demain", $demain);

$datetime_check = "{$date} {$hour_instantane}:00:00";
// Comptage des patients présents
$wherePresents = $where;
if ($mode) {
    $wherePresents[] = "'{$date}' BETWEEN DATE(affectation.entree) AND DATE(affectation.sortie)";
} else {
    $wherePresents[] = "('{$datetime_check}' BETWEEN affectation.entree AND affectation.sortie) AND affectation.effectue = '0'";
}
$presents = $affectation->countList($wherePresents, null, $ljoin);
$wherePresentsNP = $whereNP;
if ($mode) {
    $wherePresentsNP[] = "'{$date}' BETWEEN DATE(sejour.entree) AND DATE(sejour.sortie)";
} else {
    $wherePresentsNP[] = "'{$datetime_check}' BETWEEN sejour.entree AND sejour.sortie";
}
$presentsNP = $sejour->countList($wherePresentsNP, null, $ljoinNP);
// Comptage des déplacements
if ($vue) {
    unset($where["sejour.confirme"]);
    $where["effectue"] = "= '0'";
}
$whereEntrants = $whereSortants = $where;
$whereSortants["affectation.sortie"] = "BETWEEN '{$limit1}' AND '{$limit2}'";
$whereEntrants["affectation.entree"] = "BETWEEN '{$limit1}' AND '{$limit2}'";
$whereEntrants["sejour.entree"] = "!= affectation.entree";
$whereSortants["sejour.sortie"] = "!= affectation.sortie";
$dep_entrants = $affectation->countList($whereEntrants, null, $ljoin);
$dep_sortants = $affectation->countList($whereSortants, null, $ljoin);
// Comptage des entrées/sorties
foreach ($mouvements as $type => &$_mouvement) {
    if ($type_hospi && $type_hospi != $type || $type_hospi == "ambu") {

 /**
  * Count sejours including a specific date
  *
  * @param string $datetime Date to check for inclusion
  * @param array  $where    Array of additional where clauses
  * @param array  $leftjoin Array of left join clauses
  *
  * @return int Count null if module is not installed
  */
 static function countForDateTime($datetime, $where = null, $leftjoin = null)
 {
     $where[] = "sejour.entree <= '{$datetime}'";
     $where[] = "sejour.sortie >= '{$datetime}'";
     $sejour = new CSejour();
     return $sejour->countList($where, null, $leftjoin);
 }

if (count($services_ids) && $enabled_service) {
    $ljoin["affectation"] = "affectation.sejour_id = sejour.sejour_id AND affectation.sortie = sejour.sortie";
    $where["affectation.service_id"] = CSQLDataSource::prepareIn($services_ids);
}
// filtre sur le praticien
if ($prat_id) {
    $where["sejour.praticien_id"] = "= '{$prat_id}'";
}
$group = CGroups::loadCurrent();
$sejour = new CSejour();
$where["sejour.annule"] = "= '0'";
$where["sejour.group_id"] = "= '{$group->_id}'";
// Liste des admissions par jour
foreach ($days as $_date => $num) {
    $date_min = CMbDT::dateTime("00:00:00", $_date);
    $date_max = CMbDT::dateTime("23:59:00", $_date);
    $where["sejour.entree"] = "<= '{$date_max}'";
    $where["sejour.sortie"] = ">= '{$date_min}'";
    $days[$_date] = $sejour->countList($where, null, $ljoin);
}
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("hier", $hier);
$smarty->assign("demain", $demain);
$smarty->assign("bank_holidays", $bank_holidays);
$smarty->assign('date', $date);
$smarty->assign('lastmonth', $lastmonth);
$smarty->assign('nextmonth', $nextmonth);
$smarty->assign('days', $days);
$smarty->assign('enabled_service', $enabled_service);
$smarty->display('inc_vw_all_presents.tpl');

$type = CValue::get("type");
$entree = CValue::get("entree");
$group = CGroups::loadCurrent();
$group->loadConfigValues();
$sejour = new CSejour();
$nb_sejour = 0;
if ($type && $entree) {
    $where = array("type" => "= '{$type}'", "annule" => "= '0'", "group_id" => "= '{$group->_id}'");
    $min = $entree;
    $max = CMbDT::date("+1 DAY", $min);
    if ($type == "ambu") {
        $where[] = "entree BETWEEN '{$min}' AND '{$max}'";
    } elseif ($type == "comp") {
        $where[] = "'{$max}' BETWEEN entree AND sortie";
    }
    $nb_sejour = $sejour->countList($where);
}
$occupation = -1;
if ($type == "ambu" && $group->_configs["max_ambu"]) {
    $occupation = $nb_sejour / $group->_configs["max_ambu"] * 100;
} else {
    if ($type == "comp" && $group->_configs["max_comp"]) {
        $occupation = $nb_sejour / $group->_configs["max_comp"] * 100;
    }
}
$pct = min($occupation, 100);
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("occupation", $occupation);
$smarty->assign("pct", $pct);
$smarty->display("inc_show_occupation_lits.tpl");