public static AQLQuery LaborEpiCurve(DateTime date, EpiCurveParameter parameter)
{
return(new AQLQuery("LaborEpiCurve", $@"SELECT e/ehr_id/value as PatientID,
i/items[at0001]/value/value as FallID,
d/items[at0001]/value/defining_code/code_string as Flag,
d/items[at0024]/value/defining_code/code_string as VirusCode,
d/items[at0024]/value/value as Virus,
m/items[at0015]/value/value as Datum
FROM EHR e
CONTAINS COMPOSITION c[openEHR-EHR-COMPOSITION.report-result.v1]
CONTAINS (CLUSTER i[openEHR-EHR-CLUSTER.case_identification.v0]
and OBSERVATION v[openEHR-EHR-OBSERVATION.laboratory_test_result.v1]
CONTAINS (CLUSTER m[openEHR-EHR-CLUSTER.specimen.v1]
and CLUSTER s[openEHR-EHR-CLUSTER.laboratory_test_panel.v0]
CONTAINS (CLUSTER d[openEHR-EHR-CLUSTER.laboratory_test_analyte.v1])))
WHERE c/name/value='Virologischer Befund'
and d/items[at0001]/name/value='Nachweis'
and d/items[at0024]/value/defining_code/code_string MATCHES { parameter.PathogenCodesToAqlMatchString() }
and m/items[at0015]/value/value>='{ date.ToString("yyyy-MM-dd") }' and m/items[at0015]/value/value<'{ date.AddDays(1).ToString("yyyy-MM-dd") }'"));
}
public ActionResult <List <EpiCurveModel> > Labor_ErregerProTag_TTEsKSs([FromBody] TimespanParameter parameter)
{
_logger.LogInformation("CALLED Labor_ErregerProTag_TTEsKSs with parameters: \n\r Starttime: {start} \n\r Endtime: {end} \n\r internal PathogenList: 94500-6, 94745-7, 94558-4", parameter.Starttime, parameter.Endtime);
try
{
EpiCurveParameter epiParams = new EpiCurveParameter()
{
Endtime = parameter.Endtime, Starttime = parameter.Starttime, PathogenCodes = new List <string>()
{
"94500-6", "94745-7", "94558-4"
}
};
return(_labData.Labor_Epikurve(epiParams));
}
catch (Exception e)
{
_logger.LogWarning("CALLED Labor_ErregerProTag_TTEsKSs:" + e.Message);
return(ErrorHandling(e));
}
}
public void ProcessorTest()
{
RestDataAccess _data = TestConnection.Initialize();
EpiCurveParameter parameter = new EpiCurveParameter
{
Starttime = new DateTime(2021, 1, 1),
Endtime = new DateTime(2021, 1, 10),
PathogenCodes = new List <string>()
{
"94500-6", "94745-7", "94558-4"
}
};
EpiCurveFactory epiCurveFactory = new EpiCurveFactory(_data, NullLogger <EpiCurveFactory> .Instance);
List <EpiCurveModel> actual = epiCurveFactory.Process(parameter);
List <EpiCurveModel> expected = GetExpectedEpiCurveModels();
Assert.Equal(expected.Count, actual.Count);
for (int i = 0; i < actual.Count; i++)
{
Assert.Equal(expected[i].Anzahl, actual[i].Anzahl);
Assert.Equal(expected[i].Anzahl_cs, actual[i].Anzahl_cs);
Assert.Equal(expected[i].anzahl_gesamt, actual[i].anzahl_gesamt);
Assert.Equal(expected[i].anzahl_gesamt_av28, actual[i].anzahl_gesamt_av28);
Assert.Equal(expected[i].anzahl_gesamt_av7, actual[i].anzahl_gesamt_av7);
Assert.Equal(expected[i].Datum, actual[i].Datum);
Assert.Equal(expected[i].ErregerBEZL, actual[i].ErregerBEZL);
Assert.Equal(expected[i].ErregerBEZL, actual[i].ErregerBEZL);
Assert.Equal(expected[i].ErregerID, actual[i].ErregerID);
Assert.Equal(expected[i].MAVG28, actual[i].MAVG28);
Assert.Equal(expected[i].MAVG28_cs, actual[i].MAVG28_cs);
Assert.Equal(expected[i].MAVG7, actual[i].MAVG7);
Assert.Equal(expected[i].MAVG7_cs, actual[i].MAVG7_cs);
Assert.Equal(expected[i].StationID, actual[i].StationID);
}
}
public List <EpiCurveModel> Labor_Epikurve(EpiCurveParameter parameter)
{
return(_epiCurveFac.Process(parameter));
}
