You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

318 lines
13 KiB

<?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="AttendanceSheet"
pageWidth="1008"
pageHeight="612"
orientation="Landscape"
leftMargin="20"
rightMargin="20"
topMargin="20"
bottomMargin="20"
columnWidth="968">
<!-- PROPERTIES -->
<property name="net.sf.jasperreports.awt.ignore.missing.font" value="true"/>
<property name="net.sf.jasperreports.default.font.name" value="Helvetica"/>
<!-- PARAMETERS -->
<!-- <parameter name="constituency" class="java.lang.String"/>
<parameter name="training_center_name" class="java.lang.String"/>
<parameter name="training_center_address" class="java.lang.String"/>
<parameter name="category" class="java.lang.String"/>-->
<field name="training_center_name" class="java.lang.String"/>
<field name="training_center_address" class="java.lang.String"/>
<field name="constituency" class="java.lang.String"/>
<field name="constituency_no" class="java.lang.String"/>
<!-- FIELDS -->
<field name="slno" class="java.lang.String"/>
<field name="unique_no" class="java.lang.String"/>
<field name="hallno" class="java.lang.String"/>
<field name="name" class="java.lang.String"/>
<field name="designation" class="java.lang.String"/>
<field name="address1" class="java.lang.String"/>
<field name="address2" class="java.lang.String"/>
<field name="address3" class="java.lang.String"/>
<field name="pincode" class="java.lang.String"/>
<field name="r_mobile_no" class="java.lang.String"/>
<field name="img_full_path" class="java.lang.String"/>
<field name="office_name" class="java.lang.String"/>
<field name="batch" class="java.lang.String"/>
<field name="ro_office" class="java.lang.String"/>
<field name="category" class="java.lang.String"/>
<field name="team_code" class="java.lang.String"/>
<!-- <field name="img_full_path" class="java.lang.Object"/>-->
<variable name="SNO_VAR" class="java.lang.Integer"
resetType="Group" resetGroup="CategoryGroup"
calculation="Count">
<variableExpression><![CDATA[$F{batch}]]></variableExpression>
</variable>
<!-- PAGE HEADER -->
<!-- ================= GROUP (NEW PAGE PER CATEGORY) ================= -->
<group name="CategoryGroup" isStartNewPage="true" isResetPageNumber="true">
<groupExpression><![CDATA[$F{batch}]]></groupExpression>
</group>
<!-- ================= PAGE HEADER ================= -->
<pageHeader>
<band height="110">
<!-- TITLE -->
<staticText>
<reportElement x="0" y="0" width="968" height="25"/>
<textElement textAlignment="Center">
<font size="14" isBold="true"/>
</textElement>
<text><![CDATA[COUNTING STAFF TRAINING ATTENDANCE SHEET]]></text>
</staticText>
<staticText>
<reportElement x="0" y="35" width="150" height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[TRAINING CENTER]]></text>
</staticText>
<!-- COLON -->
<staticText>
<reportElement x="150" y="35" width="20" height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<!-- VALUE -->
<textField isStretchWithOverflow="true">
<reportElement x="170" y="35" width="780" height="20"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression><![CDATA[$F{ro_office}]]></textFieldExpression>
</textField>
<!-- ADDRESS (NEXT LINE) -->
<!-- <textField isStretchWithOverflow="true">
<reportElement x="170" y="50" width="780" height="30"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression><![CDATA[
"Nungambakkam Chennai-600034"
]]></textFieldExpression>
</textField> -->
<!-- CATEGORY -->
<!-- CATEGORY LABEL -->
<staticText>
<reportElement x="0" y="75" width="150" height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[CATEGORY]]></text>
</staticText>
<!-- COLON -->
<staticText>
<reportElement x="150" y="75" width="20" height="20"/>
<textElement>
<font size="12" isBold="true"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<!-- VALUE -->
<textField>
<reportElement x="170" y="75" width="300" height="20"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression><![CDATA[$F{batch}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<!-- COLUMN HEADER -->
<columnHeader>
<band height="55">
<staticText><reportElement x="0" y="0" width="50" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[S.NO
1]]></text></staticText>
<staticText><reportElement x="50" y="0" width="60" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[TEAM CODE
2]]></text></staticText>
<staticText><reportElement x="110" y="0" width="70" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[UNIQUE NO
3]]></text></staticText>
<staticText><reportElement x="180" y="0" width="120" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[CATEGORY
4]]></text></staticText>
<!-- REDUCED TO 280 -->
<staticText><reportElement x="300" y="0" width="320" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[NAME, DESIGNATION AND ADDRESS
5]]></text></staticText>
<staticText><reportElement x="620" y="0" width="100" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[PHOTO
6]]></text></staticText>
<staticText><reportElement x="720" y="0" width="100" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[CELL NO
7]]></text></staticText>
<!-- MORE SPACE -->
<staticText><reportElement x="820" y="0" width="100" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[SIGNATURE
8]]></text></staticText>
<!-- <staticText><reportElement x="740" y="0" width="180" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[REMARKS
7]]></text></staticText>-->
</band>
</columnHeader>
<!-- DETAIL -->
<detail>
<band height="90">
<textField><reportElement x="0" y="0" width="50" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$V{SNO_VAR}]]></textFieldExpression></textField>
<textField><reportElement x="50" y="0" width="60" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{team_code}]]></textFieldExpression></textField>
<textField><reportElement x="110" y="0" width="70" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{unique_no}]]></textFieldExpression></textField>
<textField><reportElement x="180" y="0" width="120" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{category} + " - " + $F{batch}]]></textFieldExpression></textField>
<!--<textField><reportElement x="300" y="0" width="320" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{hallno}]]></textFieldExpression></textField>-->
<textField isStretchWithOverflow="true">
<reportElement x="300" y="0" width="320" height="90"/>
<box><pen lineWidth="0.6"/></box>
<textElement markup="styled">
<paragraph leftIndent="8"/>
</textElement>
<!-- <textFieldExpression><![CDATA[
$F{name}+"\n"+
"<b>"+$F{designation}+"</b>\n"+
$F{address1}+", "+$F{address2}+", "+$F{address3}+" - "+$F{pincode}
]]></textFieldExpression>-->
<textFieldExpression><![CDATA[
$F{name} + "\n\n" +
"<style isBold=\"true\">" + $F{designation} + "</style>\n" +
($F{office_name} == null ? "" : $F{office_name}.replace("&", "&amp;") + ", ") +
($F{address1} == null ? "" : $F{address1}.replace("&", "&amp;")) + ", " +
($F{address2} == null ? "" : $F{address2}.replace("&", "&amp;")) + ", " +
($F{address3} == null ? "" : $F{address3}.replace("&", "&amp;")) + " - " +
($F{pincode} == null ? "" : $F{pincode}.replace("&", "&amp;"))
]]></textFieldExpression>
</textField>
<image scaleImage="FillFrame" onErrorType="Blank">
<reportElement x="620" y="0" width="100" height="90">
<printWhenExpression><![CDATA[$F{img_full_path} != null]]></printWhenExpression>
</reportElement>
<box>
<pen lineWidth="0.6"/>
</box>
<imageExpression><![CDATA[
new java.net.URL($F{img_full_path})
]]></imageExpression>
</image>
<staticText>
<reportElement x="620" y="0" width="100" height="90">
<printWhenExpression><![CDATA[$F{img_full_path} == null]]></printWhenExpression>
</reportElement>
<box>
<pen lineWidth="0.6"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="10" isBold="true"/>
</textElement>
<text><![CDATA[No Photo Available]]></text>
</staticText>
<!-- <image scaleImage="FillFrame"
hAlign="Center"
vAlign="Middle"
onErrorType="Blank">
<reportElement x="440" y="0"
width="100"
height="90"/>
<box>
<pen lineWidth="0.6"/>
</box>
<imageExpression><![CDATA[
$F{img_full_path} == null
? null
: new java.net.URL($F{img_full_path})
]]></imageExpression>-->
<!--<imageExpression><![CDATA[
$F{img_full_path} == null ? null :
new java.io.ByteArrayInputStream((byte[])$F{img_full_path})
]]></imageExpression>-->
<!-- <staticText><reportElement x="440" y="0" width="100" height="90"/><box><pen lineWidth="0.6"/></box></staticText>-->
<textField><reportElement x="720" y="0" width="100" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" />
<!--- <textFieldExpression><![CDATA[$F{r_mobile_no}]]></textFieldExpression>-->
<textFieldExpression><![CDATA[$F{r_mobile_no} == null ? "-" : $F{r_mobile_no}]]></textFieldExpression>
</textField>
<!--<staticText><reportElement x="640" y="0" width="60" height="90"/><box><pen lineWidth="0.6"/></box></staticText>-->
<staticText><reportElement x="820" y="0" width="100" height="90"/><box><pen lineWidth="0.6"/></box></staticText>
<!-- <staticText><reportElement x="740" y="0" width="180" height="90"/><box><pen lineWidth="0.6"/></box></staticText> -->
</band>
</detail>
<pageFooter>
<band height="20">
<!-- <textField isStretchWithOverflow="true">
<reportElement x="0" y="5" width="700" height="15"/>
<textElement textAlignment="Left">
<font isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[
"Note: Respective Polling Officers must fill the columns DESIGNATION, PHOTO, CELL NO before signing the attendance"
]]></textFieldExpression>
</textField>-->
<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>