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.

406 lines
16 KiB

​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"
  3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports
  5. http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"
  6. name="AttendanceSheet"
  7. pageWidth="1008"
  8. pageHeight="612"
  9. orientation="Landscape"
  10. leftMargin="20"
  11. rightMargin="20"
  12. topMargin="20"
  13. bottomMargin="20"
  14. columnWidth="968">
  15. <!-- PROPERTIES -->
  16. <property name="net.sf.jasperreports.awt.ignore.missing.font" value="true"/>
  17. <property name="net.sf.jasperreports.default.font.name" value="Helvetica"/>
  18. <!-- PARAMETERS -->
  19. <!-- <parameter name="constituency" class="java.lang.String"/>
  20. <parameter name="training_center_name" class="java.lang.String"/>
  21. <parameter name="training_center_address" class="java.lang.String"/>
  22. <parameter name="category" class="java.lang.String"/>-->
  23. <field name="category" class="java.lang.String"/>
  24. <field name="training_center_name" class="java.lang.String"/>
  25. <field name="training_center_address" class="java.lang.String"/>
  26. <field name="constituency" class="java.lang.String"/>
  27. <field name="constituency_no" class="java.lang.String"/>
  28. <!-- FIELDS -->
  29. <field name="slno" class="java.lang.String"/>
  30. <field name="unique_no" class="java.lang.String"/>
  31. <field name="hallno" class="java.lang.String"/>
  32. <field name="name" class="java.lang.String"/>
  33. <field name="designation" class="java.lang.String"/>
  34. <field name="address1" class="java.lang.String"/>
  35. <field name="address2" class="java.lang.String"/>
  36. <field name="address3" class="java.lang.String"/>
  37. <field name="pincode" class="java.lang.String"/>
  38. <field name="r_mobile_no" class="java.lang.String"/>
  39. <field name="img_full_path" class="java.lang.String"/>
  40. <field name="office_name" class="java.lang.String"/>
  41. <field name="batch" class="java.lang.String"/>
  42. <!-- <field name="img_full_path" class="java.lang.Object"/>-->
  43. <variable name="SNO_VAR" class="java.lang.Integer"
  44. resetType="Group" resetGroup="CategoryGroup"
  45. calculation="Count">
  46. <variableExpression><![CDATA[$F{batch}]]></variableExpression>
  47. </variable>
  48. <!-- PAGE HEADER -->
  49. <!--<pageHeader>
  50. <band height="110">
  51. <staticText>
  52. <reportElement x="0" y="0" width="968" height="25"/>
  53. <textElement textAlignment="Center">
  54. <font size="14" isBold="true"/>
  55. </textElement>
  56. <text><![CDATA[POLLING PERSONNEL FIRST DAY TRAINING ATTENDANCE SHEET]]></text>
  57. </staticText>
  58. <textField>
  59. <reportElement x="0" y="35" width="120" height="15"/>
  60. <textElement><font isBold="true"/></textElement>
  61. <textFieldExpression><![CDATA["CONSTITUENCY :"]]></textFieldExpression>
  62. </textField>
  63. <textField>
  64. <reportElement x="130" y="35" width="600" height="15"/>
  65. <textFieldExpression><![CDATA[$P{constituency}]]></textFieldExpression>
  66. </textField>
  67. <textField>
  68. <reportElement x="0" y="55" width="120" height="15"/>
  69. <textElement><font isBold="true"/></textElement>
  70. <textFieldExpression><![CDATA["TRAINING CENTER :"]]></textFieldExpression>
  71. </textField>
  72. <textField>
  73. <reportElement x="130" y="55" width="800" height="15"/>
  74. <textFieldExpression><![CDATA[$P{training_center_name}]]></textFieldExpression>
  75. </textField>
  76. <textField>
  77. <reportElement x="130" y="70" width="800" height="15"/>
  78. <textFieldExpression><![CDATA[$P{training_center_address}]]></textFieldExpression>
  79. </textField>
  80. <textField>
  81. <reportElement x="0" y="90" width="120" height="15"/>
  82. <textElement><font isBold="true"/></textElement>
  83. <textFieldExpression><![CDATA["CATEGORY :"]]></textFieldExpression>
  84. </textField>
  85. <textField>
  86. <reportElement x="130" y="90" width="600" height="15"/>
  87. <textFieldExpression><![CDATA[$P{category}]]></textFieldExpression>
  88. </textField>
  89. </band>
  90. </pageHeader>-->
  91. <!-- ================= GROUP (NEW PAGE PER CATEGORY) ================= -->
  92. <group name="CategoryGroup" isStartNewPage="true" isResetPageNumber="true">
  93. <groupExpression><![CDATA[$F{category} + "-" + $F{batch}]]></groupExpression>
  94. </group>
  95. <!-- ================= PAGE HEADER ================= -->
  96. <pageHeader>
  97. <band height="110">
  98. <!-- <textField>
  99. <reportElement x="700" y="35" width="150" height="20"/>
  100. <textElement textAlignment="Right">
  101. <font size="12" isBold="true"/>
  102. </textElement>
  103. <textFieldExpression><![CDATA[
  104. "BATCH : " + ($F{batch} == null ? "" : $F{batch})
  105. ]]></textFieldExpression>
  106. </textField>-->
  107. <!-- TITLE -->
  108. <staticText>
  109. <reportElement x="0" y="0" width="968" height="25"/>
  110. <textElement textAlignment="Center">
  111. <font size="14" isBold="true"/>
  112. </textElement>
  113. <text><![CDATA[COUNTING STAFF TRAINING ATTENDANCE SHEET]]></text>
  114. </staticText>
  115. <!-- TRAINING CENTER -->
  116. <!--<staticText>
  117. <reportElement x="0" y="35" width="140" height="15"/>
  118. <textElement><font isBold="true"/></textElement>
  119. <text><![CDATA[TRAINING CENTER :]]></text>
  120. </staticText>
  121. <textField>
  122. <reportElement x="150" y="35" width="800" height="15"/>
  123. <textFieldExpression><![CDATA["Amma Maligai Auditorium"]]></textFieldExpression>
  124. </textField>
  125. <textField>
  126. <reportElement x="150" y="50" width="800" height="15"/>
  127. <textFieldExpression><![CDATA[
  128. "Greater Chennai Corporation, 16, E.V.R Periyar Salai,\n" +
  129. "(Back Side of Ripon Buildings), Chennai - 600003"
  130. ]]></textFieldExpression>
  131. </textField>
  132. <staticText>
  133. <reportElement x="0" y="70" width="140" height="15"/>
  134. <textElement><font isBold="true"/></textElement>
  135. <text><![CDATA[CATEGORY :]]></text>
  136. </staticText>
  137. <textField>
  138. <reportElement x="150" y="70" width="600" height="15"/>
  139. <textFieldExpression><![CDATA[$F{category}]]></textFieldExpression>
  140. </textField>-->
  141. <staticText>
  142. <reportElement x="0" y="35" width="150" height="20"/>
  143. <textElement>
  144. <font size="12" isBold="true"/>
  145. </textElement>
  146. <text><![CDATA[TRAINING CENTER]]></text>
  147. </staticText>
  148. <!-- COLON -->
  149. <staticText>
  150. <reportElement x="150" y="35" width="20" height="20"/>
  151. <textElement>
  152. <font size="12" isBold="true"/>
  153. </textElement>
  154. <text><![CDATA[:]]></text>
  155. </staticText>
  156. <!-- VALUE -->
  157. <textField isStretchWithOverflow="true">
  158. <reportElement x="170" y="35" width="780" height="20"/>
  159. <textElement>
  160. <font size="12"/>
  161. </textElement>
  162. <textFieldExpression><![CDATA["Amma Maligai Auditorium"]]></textFieldExpression>
  163. </textField>
  164. <!-- ADDRESS (NEXT LINE) -->
  165. <textField isStretchWithOverflow="true">
  166. <reportElement x="170" y="50" width="780" height="30"/>
  167. <textElement>
  168. <font size="12"/>
  169. </textElement>
  170. <textFieldExpression><![CDATA[
  171. "Greater Chennai Corporation, 16, E.V.R Periyar Salai,(Back Side of Ripon Buildings), Chennai - 600003"
  172. ]]></textFieldExpression>
  173. </textField>
  174. <!-- CATEGORY -->
  175. <!-- CATEGORY LABEL -->
  176. <staticText>
  177. <reportElement x="0" y="75" width="150" height="20"/>
  178. <textElement>
  179. <font size="12" isBold="true"/>
  180. </textElement>
  181. <text><![CDATA[CATEGORY]]></text>
  182. </staticText>
  183. <!-- COLON -->
  184. <staticText>
  185. <reportElement x="150" y="75" width="20" height="20"/>
  186. <textElement>
  187. <font size="12" isBold="true"/>
  188. </textElement>
  189. <text><![CDATA[:]]></text>
  190. </staticText>
  191. <!-- VALUE -->
  192. <textField>
  193. <reportElement x="170" y="75" width="300" height="20"/>
  194. <textElement>
  195. <font size="12"/>
  196. </textElement>
  197. <textFieldExpression><![CDATA[$F{category} + " - " + $F{batch}]]></textFieldExpression>
  198. </textField>
  199. </band>
  200. </pageHeader>
  201. <!-- COLUMN HEADER -->
  202. <columnHeader>
  203. <band height="55">
  204. <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
  205. 1]]></text></staticText>
  206. <staticText><reportElement x="50" 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
  207. 2]]></text></staticText>
  208. <!--<staticText><reportElement x="120" y="0" width="60" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[HALL NO
  209. 3]]></text></staticText>-->
  210. <!-- REDUCED TO 280 -->
  211. <staticText><reportElement x="120" 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
  212. 3]]></text></staticText>
  213. <staticText><reportElement x="440" y="0" width="100" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[PHOTO
  214. 4]]></text></staticText>
  215. <staticText><reportElement x="540" 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
  216. 5]]></text></staticText>
  217. <!--<staticText><reportElement x="640" y="0" width="60" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[FORM12 RECEIVED
  218. (YES/NO)
  219. 7]]></text></staticText>-->
  220. <!-- MORE SPACE -->
  221. <staticText><reportElement x="640" y="0" width="100" height="55"/><box><pen lineWidth="0.8"/></box><textElement textAlignment="Center" verticalAlignment="Middle"><font isBold="true"/></textElement><text><![CDATA[SIGNATURE
  222. 6]]></text></staticText>
  223. <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
  224. 7]]></text></staticText>
  225. </band>
  226. </columnHeader>
  227. <!-- DETAIL -->
  228. <detail>
  229. <band height="90">
  230. <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>
  231. <textField><reportElement x="50" y="0" width="70" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{unique_no}]]></textFieldExpression></textField>
  232. <!--<textField><reportElement x="120" y="0" width="60" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" verticalAlignment="Middle"/><textFieldExpression><![CDATA[$F{hallno}]]></textFieldExpression></textField>-->
  233. <textField isStretchWithOverflow="true">
  234. <reportElement x="120" y="0" width="320" height="90"/>
  235. <box><pen lineWidth="0.6"/></box>
  236. <textElement markup="styled">
  237. <paragraph leftIndent="8"/>
  238. </textElement>
  239. <!-- <textFieldExpression><![CDATA[
  240. $F{name}+"\n"+
  241. "<b>"+$F{designation}+"</b>\n"+
  242. $F{address1}+", "+$F{address2}+", "+$F{address3}+" - "+$F{pincode}
  243. ]]></textFieldExpression>-->
  244. <textFieldExpression><![CDATA[
  245. $F{name} + "\n\n" +
  246. "<style isBold=\"true\">" + $F{designation} + "</style>\n" +
  247. ($F{office_name} == null ? "" : $F{office_name}.replace("&", "&amp;") + ", ") +
  248. ($F{address1} == null ? "" : $F{address1}.replace("&", "&amp;")) + ", " +
  249. ($F{address2} == null ? "" : $F{address2}.replace("&", "&amp;")) + ", " +
  250. ($F{address3} == null ? "" : $F{address3}.replace("&", "&amp;")) + " - " +
  251. ($F{pincode} == null ? "" : $F{pincode}.replace("&", "&amp;"))
  252. ]]></textFieldExpression>
  253. </textField>
  254. <image scaleImage="FillFrame" onErrorType="Blank">
  255. <reportElement x="440" y="0" width="100" height="90">
  256. <printWhenExpression><![CDATA[$F{img_full_path} != null]]></printWhenExpression>
  257. </reportElement>
  258. <box>
  259. <pen lineWidth="0.6"/>
  260. </box>
  261. <imageExpression><![CDATA[
  262. new java.net.URL($F{img_full_path})
  263. ]]></imageExpression>
  264. </image>
  265. <staticText>
  266. <reportElement x="440" y="0" width="100" height="90">
  267. <printWhenExpression><![CDATA[$F{img_full_path} == null]]></printWhenExpression>
  268. </reportElement>
  269. <box>
  270. <pen lineWidth="0.6"/>
  271. </box>
  272. <textElement textAlignment="Center" verticalAlignment="Middle">
  273. <font size="10" isBold="true"/>
  274. </textElement>
  275. <text><![CDATA[No Photo Available]]></text>
  276. </staticText>
  277. <!-- <image scaleImage="FillFrame"
  278. hAlign="Center"
  279. vAlign="Middle"
  280. onErrorType="Blank">
  281. <reportElement x="440" y="0"
  282. width="100"
  283. height="90"/>
  284. <box>
  285. <pen lineWidth="0.6"/>
  286. </box>
  287. <imageExpression><![CDATA[
  288. $F{img_full_path} == null
  289. ? null
  290. : new java.net.URL($F{img_full_path})
  291. ]]></imageExpression>-->
  292. <!--<imageExpression><![CDATA[
  293. $F{img_full_path} == null ? null :
  294. new java.io.ByteArrayInputStream((byte[])$F{img_full_path})
  295. ]]></imageExpression>-->
  296. <!-- <staticText><reportElement x="440" y="0" width="100" height="90"/><box><pen lineWidth="0.6"/></box></staticText>-->
  297. <textField><reportElement x="540" y="0" width="100" height="90"/><box><pen lineWidth="0.6"/></box><textElement textAlignment="Center" />
  298. <!--- <textFieldExpression><![CDATA[$F{r_mobile_no}]]></textFieldExpression>-->
  299. <textFieldExpression><![CDATA[$F{r_mobile_no} == null ? "-" : $F{r_mobile_no}]]></textFieldExpression>
  300. </textField>
  301. <!--<staticText><reportElement x="640" y="0" width="60" height="90"/><box><pen lineWidth="0.6"/></box></staticText>-->
  302. <staticText><reportElement x="640" y="0" width="100" height="90"/><box><pen lineWidth="0.6"/></box></staticText>
  303. <staticText><reportElement x="740" y="0" width="180" height="90"/><box><pen lineWidth="0.6"/></box></staticText>
  304. </band>
  305. </detail>
  306. <pageFooter>
  307. <band height="20">
  308. <!-- <textField isStretchWithOverflow="true">
  309. <reportElement x="0" y="5" width="700" height="15"/>
  310. <textElement textAlignment="Left">
  311. <font isBold="true"/>
  312. </textElement>
  313. <textFieldExpression><![CDATA[
  314. "Note: Respective Polling Officers must fill the columns DESIGNATION, PHOTO, CELL NO before signing the attendance"
  315. ]]></textFieldExpression>
  316. </textField>-->
  317. <textField>
  318. <reportElement x="768" y="5" width="200" height="15"/>
  319. <textElement textAlignment="Right">
  320. <font isBold="true"/>
  321. </textElement>
  322. <textFieldExpression><![CDATA["PAGE NUMBER : " + $V{PAGE_NUMBER}]]></textFieldExpression>
  323. </textField>
  324. </band>
  325. </pageFooter>
  326. </jasperReport>