1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Ipteatement1_subreport1" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="36037982-5155-4026-80c4-3c4c31c97eba">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="id" class="java.lang.Long"/>
<queryString>
<![CDATA[SELECT
DATE_FORMAT(t_inpatent_admission.`admission_date`,'%d/%m/%Y %h:%i %p') AS t_inpatent_admission_admission_date,
concat(t_patient.`patient_f_name`,' ',t_patient.`patient_m_name`,' ',t_patient.`patient_l_name`) AS patient_name,
concat('Dr. ',t_doctor_information.`doctor_name`) AS t_doctor_information_doctor_name,
DATE_FORMAT(t_inpatent_admission.`release_date`,'%d/%m/%Y') AS t_inpatent_admission_release_date,
DATE_FORMAT(t_pat_enc_anesthesia.`operation_date`,'%d/%m/%Y') AS t_pat_enc_anesthesia_operation_date,
t_inpatent_admission.`inpatient_id` AS t_inpatent_admission_inpatient_id,
t_inpatent_admission.`patient_disease` AS t_inpatient_admission_disease,
t_bed_master.`bed_number` AS t_bed_master_bed_number,
t_pat_enc_anesthesia.`operation_type` AS t_pat_enc_anesthesia_operation_type,
t_pat_enc_diagnosis.`diagnosis_id` AS t_pat_enc_diagnosis_diagnosis_id,
t_pat_enc_medication.`med_date` AS t_pat_enc_medication_med_date,
t_pat_enc_medication.`med_timing` AS t_pat_enc_medication_med_timing,
t_pat_enc_medication.`medTake_timing` AS t_pat_enc_medication_medTake_timing,
t_pat_enc_medication.`frequency` AS t_pat_enc_medication_frequency,
t_medication_master.`medication_name` AS t_medication_master_medication_name,
t_pat_enc_vitalsign.`vital_date` AS t_pat_enc_vitalsign_vital_date,
t_pat_enc_vitalsign.`blood_pressure` AS t_pat_enc_vitalsign_blood_pressure,
t_pat_enc_vitalsign.`pulse` AS t_pat_enc_vitalsign_pulse,
t_inpatent_admission.`ipd_no` AS t_inpatent_admission_ipd_no,
t_pat_enc_vitalsign.`temperature` AS t_pat_enc_vitalsign_temperature
FROM
`t_patient` t_patient INNER JOIN `t_inpatent_admission` t_inpatent_admission ON t_patient.`id` = t_inpatent_admission.`patient_id`
INNER JOIN `t_bed_master` t_bed_master ON t_inpatent_admission.`bed_id` = t_bed_master.`id`
INNER JOIN `t_doctor_information` t_doctor_information ON t_inpatent_admission.`doctor_id` = t_doctor_information.`id`
INNER JOIN `t_pat_enc` t_pat_enc ON t_inpatent_admission.`enc_id` = t_pat_enc.`enc_id`
INNER JOIN `t_pat_enc_anesthesia` t_pat_enc_anesthesia ON t_pat_enc.`enc_id` = t_pat_enc_anesthesia.`enc_id`
INNER JOIN `t_pat_enc_diagnosis` t_pat_enc_diagnosis ON t_pat_enc_anesthesia.`enc_id` = t_pat_enc_diagnosis.`enc_id`
INNER JOIN `t_pat_enc_medication` t_pat_enc_medication ON t_pat_enc_diagnosis.`enc_id` = t_pat_enc_medication.`enc_id`
INNER JOIN `t_pat_enc_procedure` t_pat_enc_procedure ON t_pat_enc_medication.`enc_id` = t_pat_enc_procedure.`enc_id`
INNER JOIN `t_medication_master` t_medication_master ON t_pat_enc_medication.`medication_id` = t_medication_master.`id`
INNER JOIN `t_pat_enc_vitalsign` t_pat_enc_vitalsign ON t_pat_enc_procedure.`enc_id` = t_pat_enc_vitalsign.`enc_id`
WHERE
t_pat_enc.`enc_id` = $P{id}
group by t_pat_enc_vitalsign.vital_date]]>
</queryString>
<field name="t_pat_enc_vitalsign_blood_pressure" class="java.lang.String"/>
<field name="t_pat_enc_medication_med_date" class="java.lang.String"/>
<field name="t_pat_enc_vitalsign_pulse" class="java.lang.String"/>
<field name="t_pat_enc_vitalsign_temperature" class="java.lang.String"/>
<field name="t_pat_enc_medication_med_timing" class="java.lang.String"/>
<field name="t_medication_master_medication_name" class="java.lang.String"/>
<field name="t_pat_enc_medication_frequency" class="java.lang.String"/>
<field name="t_pat_enc_medication_medTake_timing" class="java.lang.String"/>
<field name="t_pat_enc_vitalsign_vital_date" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="128">
<textField>
<reportElement x="58" y="60" width="60" height="20" uuid="6e4b8891-450c-4213-a707-eb0818f8f9b9"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{t_pat_enc_vitalsign_temperature}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="58" y="0" width="60" height="20" uuid="2d20c49b-bc1e-4995-ad7a-6cac60a93ad8"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{t_pat_enc_vitalsign_vital_date}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="3" y="20" width="42" height="20" uuid="67969768-8290-4335-8916-b02094b4c64c"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Pulse]]></text>
</staticText>
<staticText>
<reportElement x="3" y="0" width="42" height="20" uuid="c723c451-1631-4b5c-be66-f1592282cb34"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Date]]></text>
</staticText>
<staticText>
<reportElement x="3" y="60" width="42" height="20" uuid="60e810be-0cbe-4c1e-ab6a-c2a45b4d7f99"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Temp]]></text>
</staticText>
<textField>
<reportElement x="58" y="20" width="60" height="20" uuid="a1521185-7725-451c-8d4d-c9523e6f68c8"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{t_pat_enc_vitalsign_pulse}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="58" y="40" width="60" height="20" uuid="34ac8815-2587-4e43-8380-00c91d620058"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{t_pat_enc_vitalsign_blood_pressure}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="3" y="40" width="42" height="20" uuid="833411c3-2b24-4583-81ac-60e44c8d2d69"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[BP]]></text>
</staticText>
<staticText>
<reportElement x="48" y="1" width="10" height="20" uuid="6d20d742-324e-49e6-81bb-3205bdb38eb0"/>
<textElement verticalAlignment="Middle"/>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement x="48" y="20" width="10" height="20" uuid="44cee3c8-8d6a-48eb-807d-f26915bfb54b"/>
<textElement verticalAlignment="Middle"/>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement x="48" y="40" width="10" height="20" uuid="0842f9fa-5ee1-44dc-80db-6d2cfb7275b8"/>
<textElement verticalAlignment="Middle"/>
<text><![CDATA[:]]></text>
</staticText>
<staticText>
<reportElement x="48" y="60" width="10" height="20" uuid="a06f16e8-3671-4743-8a74-a92fe7205701"/>
<textElement verticalAlignment="Middle"/>
<text><![CDATA[:]]></text>
</staticText>
</band>
</detail>
</jasperReport>
|
girijabapi
View complete history
Commits RSS feed for