PHP CPatient::countList方法代码示例

$departements[] = "HC";
// Haute Corse
$departements[] = "MA";
// Martinique
$departements[] = "MY";
// Mayotte
$departements[] = "PS";
// Nouvelle Calédonie
$departements[] = "PF";
// Polynésie française
$departements[] = "RE";
// Réunion
$departements[] = "PM";
// Saitn Pierre et Miquelon
$departements[] = "WF";
// Wallis et Futuna
// Nombre de patients
$patient = new CPatient();
$nb_patients = $patient->countList();
// Création du template
$smarty = new CSmartyDP();
$smarty->assign("nb_patients", $nb_patients);
$smarty->assign("active_types", $active_types);
$smarty->assign("mandatory_types", $mandatory_types);
$smarty->assign("active_appareils", $active_appareils);
$smarty->assign("all_types", $all_types);
$smarty->assign("all_mandatory_types", $all_types);
$smarty->assign("all_appareils", $all_appareils);
$smarty->assign("pass", CValue::get("pass"));
$smarty->assign("departements", $departements);
$smarty->display("configure.tpl");

$where["nom"] = "LIKE '{$nom}%'";
if ($sexe != "") {
    $where["sexe"] = "= '{$sexe}'";
}
/*if ($IPP) {
  /*$patient = new CPatient;
  $patient->_IPP = $patient_ipp;
  $patient->loadFromIPP();
}*/
$order = "nom, prenom, naissance";
$step = 30;
$limit = "{$page}, {$step}";
$patient = new CPatient();
$patient->nom = $nom;
$patient->prenom = $prenom;
$patient->nom_jeune_fille = $nom_jeune_fille;
$patient->sexe = $sexe;
//$patient->_IPP            = $IPP;
$nb_pat = $patient->countList($where);
/** @var CPatient[] $patients CPatient[] */
$patients = $patient->loadList($where, $order, $limit);
CPatient::massLoadIPP($patients);
foreach ($patients as $_patient) {
    $_patient->loadFirstLog()->loadRefUser();
}
$smarty = new CSmartyDP();
$smarty->assign("patient", $patient);
$smarty->assign("patients", $patients);
$smarty->assign("nb_pat", $nb_pat);
$smarty->assign("page", $page);
$smarty->display("inc_list_demographic.tpl");

 /**
  * Get the number patient stateless
  *
  * @return int
  */
 static function verifyStatus()
 {
     $patient = new CPatient();
     $where = array("status" => "IS NULL");
     return $patient->countList($where);
 }

CValue::setSession("ignore_files", $ignore_files);
CValue::setSession("generate_pdfpreviews", $generate_pdfpreviews);
CValue::setSession("date_min", $date_min);
$step = min($step, 1000);
CStoredObject::$useObjectCache = false;
$backrefs_tree = array("CPatient" => array("identifiants", "notes", "files", "documents", "permissions", "observation_result_sets", "constantes", "contextes_constante", "consultations", "correspondants", "correspondants_patient", "sejours", "dossier_medical", "correspondants_courrier", "grossesses", "allaitements", "patient_observation_result_sets", "patient_links", 'arret_travail', "facture_patient_consult", "facture_patient_sejour"), "CConsultation" => array("files", "documents", "notes", "consult_anesth", "examaudio", "examcomp", "examnyha", "exampossum", "sejours_lies", "intervs_liees", "consults_liees", "facturable", "actes_ngap", "actes_ccam", "codages_ccam", "actes_caisse"), "CConsultAnesth" => array("files", "documents", "notes", "techniques"), "CSejour" => array("identifiants", "files", "documents", "notes", "dossier_medical", "operations", "facturable", "actes_ngap", "actes_ccam", "codages_ccam", "actes_caisse"), "COperation" => array("files", "documents", "notes", "anesth_perops", "facturable", "actes_ngap", "actes_ccam", "actes_caisse"), "CCompteRendu" => array("files"), "CDossierMedical" => array("antecedents", "traitements", "etats_dent"), "CFactureCabinet" => array("items", "reglements"), "CFactureEtablissement" => array("items", "reglements"));
$fwdrefs_tree = array("CPatient" => array("medecin_traitant"), "CConstantesMedicales" => array("context_id", "patient_id", "user_id"), "CConsultation" => array("plageconsult_id", "sejour_id", "grossesse_id", "patient_id", "consult_related_id"), "CConsultAnesth" => array("consultation_id", "operation_id", "sejour_id", "chir_id"), "CPlageconsult" => array("chir_id"), "CSejour" => array("patient_id", "praticien_id", "service_id", "group_id", "grossesse_id"), "COperation" => array("sejour_id", "chir_id", "anesth_id", "plageop_id", "salle_id", "type_anesth", "consult_related_id", "prat_visite_anesth_id"), "CGrossesse" => array("group_id", "parturiente_id"), "CCorrespondant" => array("patient_id", "medecin_id"), "CMediusers" => array("user_id"), "CPlageOp" => array("chir_id", "anesth_id", "spec_id", "salle_id"), "CActeCCAM" => array("executant_id"), "CActeNGAP" => array("executant_id"), "CActeCaisse" => array("executant_id"), "CFraidDivers" => array("executant_id"), "CFactureItem" => array("object_id"), "CFactureLiaison" => array("facture_id", "object_id"), "CFactureCabinet" => array("group_id", "patient_id", "praticien_id"), "CFactureEtablissement" => array("group_id", "patient_id", "praticien_id"), "CTypeAnesth" => array("group_id"), "CFile" => array("object_id", "author_id"), "CCompteRendu" => array("object_id", "author_id", "user_id", "function_id", "group_id", "content_id", "locker_id"));
$patient = new CPatient();
$ds = $patient->getDS();
$order = array("patients.nom", "patients.nom_jeune_fille", "patients.prenom", "patients.naissance", "patients.patient_id");
if ($all_prats && !$date_min) {
    $limit = "{$start}, {$step}";
    /** @var CPatient[] $patients */
    $patients = $patient->loadList(null, $order, $limit);
    $patient_count = count($patients);
    $patient_total = $patient->countList();
} else {
    $ljoin_consult = array("consultation" => "consultation.patient_id = patients.patient_id", "plageconsult" => "plageconsult.plageconsult_id = consultation.plageconsult_id");
    $where_consult = array();
    if (!$all_prats) {
        $where_consult["plageconsult.chir_id"] = $ds->prepareIn($praticien_id);
    }
    if ($date_min) {
        $where_consult["plageconsult.date"] = $ds->prepare(">= ?", $date_min);
    }
    $patient_ids_consult = $patient->loadIds($where_consult, $order, null, "patients.patient_id", $ljoin_consult);
    $ljoin_sejour = array("sejour" => "sejour.patient_id = patients.patient_id");
    $where_sejour = array();
    if (!$all_prats) {
        $where_sejour["sejour.praticien_id"] = $ds->prepareIn($praticien_id);
    }

}
$merge_patient = CValue::getOrSession("_merge_patient");
$number_day = CValue::getOrSession("_number_day", 8);
$number_day = $number_day ?: 8;
if ($number_day > 31) {
    $number_day = 31;
} elseif ($number_day < 0) {
    $number_day = 0;
}
$now = CValue::getOrSession("_date_end", CMbDT::date());
$before = CMbDT::date("-{$number_day} DAYS", $now);
CValue::setSession("_number_day", $number_day);
CValue::setSession("_date_end", $now);
CValue::setSession("_merge_patient", $merge_patient);
$patient = new CPatient();
$count_patient = $patient->countList();
$count_status = $patient->countMultipleList(array("status" => "IS NOT NULL"), null, "status", null, array("status"));
$patient_link = new CPatientLink();
$count_status[] = array("total" => $patient_link->countList(), "status" => "DPOT");
//répartition total
$series = CPatientStateTools::createGraphPie($count_status);
foreach ($series["datum"] as $_k => $_serie) {
    $series["datum"][$_k]["percent"] = $series["count"] > 0 ? round($_serie["data"] / $series["count"] * 100) : 0;
}
//Répartition par journée
$values = array();
$ids = array();
if ($merge_patient) {
    $results = CPatientStateTools::getPatientMergeByDate($before, $now);
    for ($i = $number_day; $i >= 0; $i--) {
        $values["merged"][CMbDT::date("-{$i} DAYS", $now)] = 0;

 /**
  * Get all number patient by a state and the filter
  *
  * @param String $date_min Date minimum
  * @param String $date_max Date maximum
  *
  * @return array
  */
 static function getAllNumberPatient($date_min = null, $date_max = null)
 {
     $patients_count = array();
     $leftjoin = null;
     $where = array();
     if ($date_min) {
         $where["entree"] = ">= '{$date_min}'";
         $leftjoin["sejour"] = "patients.patient_id = sejour.patient_id";
     }
     if ($date_max) {
         $where["entree"] = "<= '{$date_max}'";
         $leftjoin["sejour"] = "patients.patient_id = sejour.patient_id";
     }
     $ds = CSQLDataSource::get("std");
     $request = new CRequest();
     $request->addSelect("`status`, COUNT(DISTINCT(`patients`.`patient_id`)) as `total`");
     $request->addTable("patients");
     $request->addLJoin($leftjoin);
     $request->addWhere($where);
     $request->addGroup("`status`");
     $result = $ds->loadList($request->makeSelect());
     $state_count = array();
     foreach ($result as $_result) {
         $state_count[$_result["status"]] = $_result["total"];
     }
     foreach (self::$list_state as $_state) {
         $patients_count[CMbString::lower($_state)] = CMbArray::get($state_count, $_state, 0);
         if ($_state == "CACH") {
             $where = array("vip" => "= '1'", "status" => "!= 'VALI'");
             $patient = new CPatient();
             $patients_count[CMbString::lower($_state)] = $patient->countList($where, null, $leftjoin);
         }
         if ($_state == "DPOT") {
             $patient_link = new CPatientLink();
             $patients_count[CMbString::lower($_state)] = $patient_link->countList($where, null, array("sejour" => "patient_link.patient_id1 = sejour.patient_id"));
         }
     }
     return $patients_count;
 }

    switch ($mode = CValue::get("mode")) {
        case "check":
            $ds = $patient->_spec->ds;
            $query = "SELECT `{$_field}`, COUNT( * ) AS  `counts`\r\n        FROM `patients`\r\n        GROUP BY `{$_field}`";
            foreach ($ds->loadHashList($query) as $value => $count) {
                $msgType = $value ? UI_MSG_OK : UI_MSG_WARNING;
                CAppUI::stepAjax("Nombre d'occurences pour '%s' valant '%s' : '%s'", $msgType, CAppUI::tr("CPatient-{$_field}-desc"), CAppUI::tr("CPatient.{$_field}.{$value}"), $count);
            }
            break;
        case "repair":
            $where = array();
            $where["{$_field}"] = "IS NULL";
            $repaired = 0;
            $max = CValue::get("max", 1000);
            $limit = "0, {$max}";
            CAppUI::stepAjax("Patients détectés pour une correction de '%s' : %s trouvés.", UI_MSG_OK, CAppUI::tr("CPatient-{$_field}-desc"), $patient->countList($where));
            foreach ($patient->loadList($where, null, $limit) as $_patient) {
                $_patient->{$_field} = "guess";
                if ($msg = $_patient->store()) {
                    CAppUI::stepAjax("Echec de la correction de %s pour le patient '%s' : %s", UI_MSG_WARNING, CAppUI::tr("CPatient-{$_field}-desc"), $_patient, $msg);
                    continue;
                }
                $repaired++;
            }
            CAppUI::stepAjax("%s patients corrigés", UI_MSG_OK, $repaired);
            break;
        default:
            CAppUI::stepAjax("Mode '{$mode}' non pris en charge", UI_MSG_ERROR);
            break;
    }
}