KNH_Project
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
|
<?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="LabelPrint" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2d6e79e1-5224-4dd3-84a7-02fc2392806e">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="enc_id" class="java.lang.Long"/>
<queryString>
<![CDATA[SELECT
concat(t_patient.`patient_f_name`,' ',t_patient.`patient_m_name`,' ',t_patient.`patient_l_name`) AS patent_name,
DATE_FORMAT(t_patient.`birth_date`,'%d/%m/%y') AS birth_date,
t_patient.`patient_id` AS patient_id,
t_patient.`patient_gender` AS patient_gender
FROM
`t_patient` t_patient INNER JOIN `t_pat_enc` t_pat_enc ON t_patient.`id` = t_pat_enc.`mrn_id`
WHERE
t_pat_enc.`enc_id`=$P{enc_id}]]>
</queryString>
<field name="patent_name" class="java.lang.String"/>
<field name="birth_date" class="java.lang.String"/>
<field name="patient_id" class="java.lang.String"/>
<field name="patient_gender" class="java.lang.String"/>
<detail>
<band height="82" splitType="Stretch">
<staticText>
<reportElement uuid="80125d2a-e111-4012-b2f8-28f2236124f7" x="0" y="2" width="74" height="20"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Patient ID # :]]></text>
</staticText>
<textField>
<reportElement uuid="a3f15d32-4550-4b6b-b438-6a2c95e18ed5" x="74" y="2" width="224" height="20"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{patient_id}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="43860369-24bf-4418-abfa-daf0ee2b6bd3" x="0" y="22" width="74" height="20"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Name :]]></text>
</staticText>
<textField>
<reportElement uuid="c0ea2e5c-9739-460b-a297-1950f5b6d7c6" x="74" y="22" width="224" height="20"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{patent_name}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="c9457af1-9151-4ea7-b3c4-14e7c3e304d4" x="0" y="42" width="74" height="20"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Gender :]]></text>
</staticText>
<textField>
<reportElement uuid="d3963c0f-dde8-47f2-8f38-527162578fdb" x="74" y="42" width="224" height="20"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{patient_gender}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="10a3e54c-8554-4595-b0cb-51ed33f8fae5" x="0" y="62" width="74" height="20"/>
<textElement verticalAlignment="Middle">
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[Dob :]]></text>
</staticText>
<textField>
<reportElement uuid="477e9e82-94d0-4c49-bf61-fc4f27c1d3cf" x="74" y="62" width="224" height="20"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{birth_date}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
|
Revision |
Author |
Commited |
Message |
1
|
girijabapi
|
Fri 27 Jul, 2018 13:29:42 +0000 |
|