Election_TNELA2026/target/classes/reports/microobsereverdepartment.jrxml

<?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="DepartmentSummary"
              pageWidth="1008"
              pageHeight="612"
              orientation="Landscape"
              columnWidth="968"
              leftMargin="20"
              rightMargin="20"
              topMargin="20"
              bottomMargin="20">

    <!-- PARAMETERS -->
    <parameter name="constituency" class="java.lang.String"/>

    <!-- FIELDS -->
    <field name="office" class="java.lang.String"/>
    <field name="address" class="java.lang.String"/>
    <field name="pincode" class="java.lang.String"/>
    <field name="phone" class="java.lang.String"/>
    <field name="total_orders" class="java.lang.Long"/>
    <field name="po" class="java.lang.Long"/>
    <field name="po1" class="java.lang.Long"/>
    <field name="po2" class="java.lang.Long"/>
    <field name="po3" class="java.lang.Long"/>
    <field name="po4" class="java.lang.Long"/>
    <field name="mob" class="java.lang.Long"/>

    <!-- PAGE HEADER -->
    <pageHeader>
        <band height="60">
            <staticText>
                <reportElement x="0" y="0" width="968" height="25"/>
                <textElement textAlignment="Center">
                    <font size="14" isBold="true"/>
                </textElement>
                <text><![CDATA[Micro Observer - FIRST DAY TRAINING - DEPARTMENT WISE BREAK UP SUMMARY]]></text>
            </staticText>

            <textField>
                <reportElement x="157" y="35" width="653" height="20"/>
                <textElement>
                    <font size="11" isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA["CONSTITUENCY : " + $P{constituency}]]></textFieldExpression>
            </textField>
        </band>
    </pageHeader>

    <!-- COLUMN HEADER -->
    <columnHeader>
        <band height="80">

            <!-- Department -->
            <staticText>
                <reportElement x="157" y="0" width="350" height="80"/>
                <box><pen lineWidth="1"/></box>
                <textElement textAlignment="Center" verticalAlignment="Middle">
                    <font isBold="true" size="10"/>
                </textElement>
                <text><![CDATA[DEPARTMENT DETAILS / ADDRESS]]></text>
            </staticText>

            <!-- Total -->
            <staticText>
                <reportElement x="507" y="0" width="120" height="80"/>
                <box><pen lineWidth="1"/></box>
                <textElement textAlignment="Center" verticalAlignment="Middle">
                    <font isBold="true" size="9"/>
                </textElement>
                <text><![CDATA[NO OF APPOINTMENT ORDERS ISSUED]]></text>
            </staticText>

            <!-- Officer Headers -->
            <staticText><reportElement x="627" y="0" width="183" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="9"/></textElement><text><![CDATA[Micro Observer]]></text></staticText>
           <!-- <staticText><reportElement x="393" y="0" width="143" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="9"/></textElement><text><![CDATA[POLLING OFFICER 1]]></text></staticText>
            <staticText><reportElement x="536" y="0" width="143" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="9"/></textElement><text><![CDATA[POLLING OFFICER 2]]></text></staticText>
            <staticText><reportElement x="679" y="0" width="143" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="9"/></textElement><text><![CDATA[POLLING OFFICER 3]]></text></staticText>
            <staticText><reportElement x="822" y="0" width="146" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="9"/></textElement><text><![CDATA[POLLING OFFICER 4]]></text></staticText>-->

            <!-- ISSUED / HANDED OVER (MATCHES DETAIL WIDTHS EXACTLY) -->
            <staticText><reportElement x="627" y="40" width="91" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS ISSUED]]></text></staticText>
            <staticText><reportElement x="718" y="40" width="92" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS HANDED OVER]]></text></staticText>

           <!-- <staticText><reportElement x="393" y="40" width="71" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS ISSUED]]></text></staticText>
            <staticText><reportElement x="464" y="40" width="72" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS HANDED OVER]]></text></staticText>

            <staticText><reportElement x="536" y="40" width="71" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS ISSUED]]></text></staticText>
            <staticText><reportElement x="607" y="40" width="72" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS HANDED OVER]]></text></staticText>

            <staticText><reportElement x="679" y="40" width="71" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS ISSUED]]></text></staticText>
            <staticText><reportElement x="750" y="40" width="72" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS HANDED OVER]]></text></staticText>

            <staticText><reportElement x="822" y="40" width="73" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS ISSUED]]></text></staticText>
            <staticText><reportElement x="895" y="40" width="73" height="40"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true" size="7"/></textElement><text><![CDATA[NO OF APPOINTMENT ORDERS HANDED OVER]]></text></staticText>-->

        </band>
    </columnHeader>

    <!-- DETAIL (ONE RECORD PER PAGE) -->
    <detail>
        <band height="140" splitType="Prevent">
        <textField isStretchWithOverflow="true">
    <reportElement x="157" y="0" width="350" height="140"/>
    <box>
        <pen lineWidth="1"/>
    </box>

    <textElement verticalAlignment="Top" markup="styled">
        <font size="10"/>
        <paragraph leftIndent="8"/>
    </textElement>
    <textFieldExpression><![CDATA[
($F{office} == null ? "" : 
    $F{office}
        .replaceAll("&", "&amp;")
        .replaceAll("<", "&lt;")
        .replaceAll(">", "&gt;")
)
+ "\n\n" + 
($F{address} == null ? "" : 
    $F{address}
        .replaceAll(",\\s*,+", ", ")   // ✅ FIX DOUBLE COMMA
        .replaceAll("&", "&amp;")
        .replaceAll("<", "&lt;")
        .replaceAll(">", "&gt;")
)
+ "\n\n<style isBold='true'>Pincode : </style>" + 
($F{pincode} == null ? "-" : 
    $F{pincode}
        .replaceAll("&", "&amp;")
        .replaceAll("<", "&lt;")
        .replaceAll(">", "&gt;")
)
+ "\n<style isBold='true'>Phone : </style>" + 
($F{phone} == null ? "-" : 
    $F{phone}
        .replaceAll("&", "&amp;")
        .replaceAll("<", "&lt;")
        .replaceAll(">", "&gt;")
)
]]></textFieldExpression>

  <!--  <textFieldExpression><![CDATA[
($F{office} == null ? "" : 
    $F{office}.replaceAll("&", "&amp;").replaceAll("<", "&lt;").replaceAll(">", "&gt;")
)
+ "\n\n" + 
($F{address} == null ? "" : 
    $F{address}.replaceAll("&", "&amp;").replaceAll("<", "&lt;").replaceAll(">", "&gt;")
)
+ "\n\n<style isBold='true'>Pincode : </style>" + 
($F{pincode} == null ? "-" : 
    $F{pincode}.replaceAll("&", "&amp;").replaceAll("<", "&lt;").replaceAll(">", "&gt;")
)
+ "\n<style isBold='true'>Phone : </style>" + 
($F{phone} == null ? "-" : 
    $F{phone}.replaceAll("&", "&amp;").replaceAll("<", "&lt;").replaceAll(">", "&gt;")
)
]]></textFieldExpression>-->
</textField>

           <!-- <textField isStretchWithOverflow="true">
                <reportElement x="0" y="0" width="180" height="140"/>
                <box><pen lineWidth="1"/></box>
                <textElement verticalAlignment="Top" markup="styled">
                    <font size="10"/>
                    <paragraph leftIndent="8"/>
                </textElement>
                <textFieldExpression><![CDATA[
$F{office}
+ "\n\n" + $F{address}
+ "\n\n <style isBold='true'>Pincode : </style>" + ($F{pincode} == null ? "" : $F{pincode})
+ "\n <style isBold='true'>Phone : </style>" + ($F{phone} == null ? "" : $F{phone})
]]></textFieldExpression>
            </textField>-->

            <textField><reportElement x="507" y="0" width="120" height="140"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center"/><textFieldExpression><![CDATA[$F{total_orders}]]></textFieldExpression></textField>

            <textField><reportElement x="627" y="0" width="91" height="140"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center"/><textFieldExpression><![CDATA[$F{mob}]]></textFieldExpression></textField>
            <textField><reportElement x="718" y="0" width="92" height="140"/><box><pen lineWidth="1"/></box><textFieldExpression><![CDATA[""]]></textFieldExpression></textField>

           <!-- <textField><reportElement x="393" y="0" width="71" height="140"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center"/><textFieldExpression><![CDATA[$F{po1}]]></textFieldExpression></textField>
            <textField><reportElement x="464" y="0" width="72" height="140"/><box><pen lineWidth="1"/></box><textFieldExpression><![CDATA[""]]></textFieldExpression></textField>

            <textField><reportElement x="536" y="0" width="71" height="140"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center"/><textFieldExpression><![CDATA[$F{po2}]]></textFieldExpression></textField>
            <textField><reportElement x="607" y="0" width="72" height="140"/><box><pen lineWidth="1"/></box><textFieldExpression><![CDATA[""]]></textFieldExpression></textField>

            <textField><reportElement x="679" y="0" width="71" height="140"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center"/><textFieldExpression><![CDATA[$F{po3}]]></textFieldExpression></textField>
            <textField><reportElement x="750" y="0" width="72" height="140"/><box><pen lineWidth="1"/></box><textFieldExpression><![CDATA[""]]></textFieldExpression></textField>

            <textField><reportElement x="822" y="0" width="73" height="140"/><box><pen lineWidth="1"/></box><textElement textAlignment="Center"/><textFieldExpression><![CDATA[$F{po4}]]></textFieldExpression></textField>
            <textField><reportElement x="895" y="0" width="73" height="140"/><box><pen lineWidth="1"/></box><textFieldExpression><![CDATA[""]]></textFieldExpression></textField>-->

            <break>
                <reportElement x="0" y="0" width="1" height="1"/>
            </break>

        </band>
    </detail>

    <!-- PAGE FOOTER -->
    <pageFooter>
        <band height="20">
            <textField>
                <reportElement x="768" y="5" width="200" height="15"/>
                <textElement textAlignment="Right">
                    <font isBold="true"/>
                </textElement>
                <textFieldExpression><![CDATA["PAGE NUMBER : " + $V{PAGE_NUMBER}]]></textFieldExpression>
            </textField>
        </band>
    </pageFooter>

</jasperReport>