Home Explore Help
Sign In
powerbyte
/
sicura_1.7.x
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 7ce23222af
Branches Tags
sicura_1.7.x
/
sicura.web
/
WebContent
/
Reports
/
repRemunerazioneSedaDetail.jrxml

repRemunerazioneSedaDetail.jrxml 14 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304 
  1. <?xml version="1.0" encoding="UTF-8"?>
    2. 

  2. <!-- Created with Jaspersoft Studio version 6.4.3.final utlizzo versione della libreria JasperReports6.4.3  -->
    3. 

  3. <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="repDisposizioniRid" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="78b2bfe6-e041-4a82-aa00-1decb32eca36">
    4. 

  4. 	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sicura"/>
    5. 

  5. 	<property name="com.jaspersoft.studio.unit." value="pixel"/>
    6. 

  6. 	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
    7. 

  7. 	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
    8. 

  8. 	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
    9. 

  9. 	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
    10. 

  10. 	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
    11. 

  11. 	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
    12. 

  12. 	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
    13. 

  13. 	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
    14. 

  14. 	<parameter name="trimestre" class="java.lang.String"/>
    15. 

  15. 	<parameter name="anno" class="java.lang.String"/>
    16. 

  16. 	<parameter name="idCreditore" class="java.lang.String"/>
    17. 

  17. 	<queryString>
    18. 

  18. 		<![CDATA[]]>
    19. 

  19. 	</queryString>
    20. 

  20. 	<field name="flagStampa" class="java.lang.Boolean">
    21. 

  21. 		<fieldDescription><![CDATA[flagStampa]]></fieldDescription>
    22. 

  22. 	</field>
    23. 

  23. 	<field name="statoTipoMandato" class="java.lang.String">
    24. 

  24. 		<fieldDescription><![CDATA[statoTipoMandato]]></fieldDescription>
    25. 

  25. 	</field>
    26. 

  26. 	<field name="idremuneration" class="java.lang.Integer">
    27. 

  27. 		<fieldDescription><![CDATA[idremuneration]]></fieldDescription>
    28. 

  28. 	</field>
    29. 

  29. 	<field name="divisa" class="java.lang.String">
    30. 

  30. 		<fieldDescription><![CDATA[divisa]]></fieldDescription>
    31. 

  31. 	</field>
    32. 

  32. 	<field name="tipoMandato" class="java.lang.String">
    33. 

  33. 		<fieldDescription><![CDATA[tipoMandato]]></fieldDescription>
    34. 

  34. 	</field>
    35. 

  35. 	<field name="datarendi" class="java.util.Date">
    36. 

  36. 		<fieldDescription><![CDATA[datarendi]]></fieldDescription>
    37. 

  37. 	</field>
    38. 

  38. 	<field name="idprevisioning" class="java.lang.Integer">
    39. 

  39. 		<fieldDescription><![CDATA[idprevisioning]]></fieldDescription>
    40. 

  40. 	</field>
    41. 

  41. 	<field name="dataRevocaMandato" class="java.util.Date">
    42. 

  42. 		<fieldDescription><![CDATA[dataRevocaMandato]]></fieldDescription>
    43. 

  43. 	</field>
    44. 

  44. 	<field name="prezzoUnitarioMandato" class="java.lang.String">
    45. 

  45. 		<fieldDescription><![CDATA[prezzoUnitarioMandato]]></fieldDescription>
    46. 

  46. 	</field>
    47. 

  47. 	<field name="identificativoMandato" class="java.lang.String">
    48. 

  48. 		<fieldDescription><![CDATA[identificativoMandato]]></fieldDescription>
    49. 

  49. 	</field>
    50. 

  50. 	<field name="dataAttivazioneMandato" class="java.util.Date">
    51. 

  51. 		<fieldDescription><![CDATA[dataAttivazioneMandato]]></fieldDescription>
    52. 

  52. 	</field>
    53. 

  53. 	<field name="iddetail" class="java.lang.Integer">
    54. 

  54. 		<fieldDescription><![CDATA[iddetail]]></fieldDescription>
    55. 

  55. 	</field>
    56. 

  56. 	<field name="flagNew" class="java.lang.Boolean">
    57. 

  57. 		<fieldDescription><![CDATA[flagNew]]></fieldDescription>
    58. 

  58. 	</field>
    59. 

  59. 	<field name="tipoSeda" class="java.lang.String">
    60. 

  60. 		<fieldDescription><![CDATA[tipoSeda]]></fieldDescription>
    61. 

  61. 	</field>
    62. 

  62. 	<field name="flagUtil" class="java.lang.Boolean">
    63. 

  63. 		<fieldDescription><![CDATA[flagUtil]]></fieldDescription>
    64. 

  64. 	</field>
    65. 

  65. 	<field name="inquiryResponseIdentification" class="java.lang.String">
    66. 

  66. 		<fieldDescription><![CDATA[inquiryResponseIdentification]]></fieldDescription>
    67. 

  67. 	</field>
    68. 

  68. 	<variable name="cnt" class="java.lang.Integer" calculation="Sum">
    69. 

  69. 		<variableExpression><![CDATA[1]]></variableExpression>
    70. 

  70. 		<initialValueExpression><![CDATA[0]]></initialValueExpression>
    71. 

  71. 	</variable>
    72. 

  72. 	<background>
    73. 

  73. 		<band splitType="Stretch"/>
    74. 

  74. 	</background>
    75. 

  75. 	<title>
    76. 

  76. 		<band height="85" splitType="Stretch">
    77. 

  77. 			<rectangle radius="4">
    78. 

  78. 				<reportElement x="-1" y="0" width="802" height="76" uuid="0f447564-02ac-4b99-988c-bbf646dae7ed"/>
    79. 

  79. 				<graphicElement>
    80. 

  80. 					<pen lineWidth="2.0" lineStyle="Solid"/>
    81. 

  81. 				</graphicElement>
    82. 

  82. 			</rectangle>
    83. 

  83. 			<staticText>
    84. 

  84. 				<reportElement x="2" y="3" width="338" height="41" uuid="e8ccdd76-c7a9-4e42-8d04-0cc742d5b77a"/>
    85. 

  85. 				<textElement verticalAlignment="Middle">
    86. 

  86. 					<font fontName="SansSerif" size="18" isBold="true" isItalic="true"/>
    87. 

  87. 				</textElement>
    88. 

  88. 				<text><![CDATA[Stampa dettaglio mandati SEDA]]></text>
    89. 

  89. 			</staticText>
    90. 

  90. 			<textField pattern="dd/MM/yyyy HH:mm">
    91. 

  91. 				<reportElement x="607" y="3" width="190" height="20" uuid="c044d3ed-504c-445e-8aeb-60333c865445"/>
    92. 

  92. 				<textElement textAlignment="Right" verticalAlignment="Middle"/>
    93. 

  93. 				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
    94. 

  94. 			</textField>
    95. 

  95. 			<staticText>
    96. 

  96. 				<reportElement x="607" y="31" width="191" height="21" uuid="a6fab253-5ecb-4de5-b0d9-323f87534b5c"/>
    97. 

  97. 				<textElement textAlignment="Right" verticalAlignment="Middle">
    98. 

  98. 					<font fontName="SansSerif"/>
    99. 

  99. 				</textElement>
    100. 

  100. 				<text><![CDATA[SICURA - Pagamenti e Incassi Telematici]]></text>
    101. 

  101. 			</staticText>
    102. 

  102. 			<textField isBlankWhenNull="true">
    103. 

  103. 				<reportElement x="13" y="43" width="120" height="19" uuid="410b59e2-d146-4fb0-8655-51cb5dc53b3d"/>
    104. 

  104. 				<textElement verticalAlignment="Middle"/>
    105. 

  105. 				<textFieldExpression><![CDATA[$P{trimestre}]]></textFieldExpression>
    106. 

  106. 			</textField>
    107. 

  107. 			<textField isBlankWhenNull="true">
    108. 

  108. 				<reportElement x="133" y="43" width="120" height="19" uuid="55ad0b2f-20bc-4b28-9533-78c109c1d0bc"/>
    109. 

  109. 				<textElement verticalAlignment="Middle"/>
    110. 

  110. 				<textFieldExpression><![CDATA[$P{anno}]]></textFieldExpression>
    111. 

  111. 			</textField>
    112. 

  112. 			<textField isBlankWhenNull="true">
    113. 

  113. 				<reportElement x="267" y="43" width="120" height="19" uuid="cea3c200-f158-446b-ae4a-df118a72be2a"/>
    114. 

  114. 				<textElement verticalAlignment="Middle"/>
    115. 

  115. 				<textFieldExpression><![CDATA[$P{idCreditore}]]></textFieldExpression>
    116. 

  116. 			</textField>
    117. 

  117. 		</band>
    118. 

  118. 	</title>
    119. 

  119. 	<pageHeader>
    120. 

  120. 		<band height="50" splitType="Stretch">
    121. 

  121. 			<rectangle>
    122. 

  122. 				<reportElement x="0" y="5" width="801" height="25" backcolor="#E0E0E0" uuid="f9c53436-6729-4203-bc8c-0c6b01c23252"/>
    123. 

  123. 			</rectangle>
    124. 

  124. 			<staticText>
    125. 

  125. 				<reportElement x="2" y="8" width="111" height="20" uuid="c3571b96-c185-4d72-b0e9-33e3972bdbce"/>
    126. 

  126. 				<textElement textAlignment="Center" verticalAlignment="Middle">
    127. 

  127. 					<font fontName="SansSerif" isBold="true"/>
    128. 

  128. 				</textElement>
    129. 

  129. 				<text><![CDATA[Idenfificativo mandato]]></text>
    130. 

  130. 			</staticText>
    131. 

  131. 			<staticText>
    132. 

  132. 				<reportElement x="118" y="8" width="88" height="20" uuid="e253f10b-b112-46cc-80ea-34987a705834"/>
    133. 

  133. 				<textElement verticalAlignment="Middle">
    134. 

  134. 					<font fontName="SansSerif" isBold="true"/>
    135. 

  135. 				</textElement>
    136. 

  136. 				<text><![CDATA[Data attivazione]]></text>
    137. 

  137. 			</staticText>
    138. 

  138. 			<staticText>
    139. 

  139. 				<reportElement x="206" y="7" width="60" height="20" uuid="c1722263-6f90-4755-9cba-6c995ad46bf6"/>
    140. 

  140. 				<textElement textAlignment="Center" verticalAlignment="Middle">
    141. 

  141. 					<font fontName="SansSerif" isBold="true"/>
    142. 

  142. 				</textElement>
    143. 

  143. 				<text><![CDATA[Data revoca]]></text>
    144. 

  144. 			</staticText>
    145. 

  145. 			<staticText>
    146. 

  146. 				<reportElement x="355" y="8" width="90" height="20" uuid="c8baaa1b-e5a7-4646-8d6d-d51dfaa6840f"/>
    147. 

  147. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    148. 

  148. 					<font fontName="SansSerif" isBold="true"/>
    149. 

  149. 				</textElement>
    150. 

  150. 				<text><![CDATA[Stato mandato]]></text>
    151. 

  151. 			</staticText>
    152. 

  152. 			<staticText>
    153. 

  153. 				<reportElement x="450" y="8" width="60" height="20" uuid="1ed777c7-ef7d-45c8-830a-ca751d5da699"/>
    154. 

  154. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    155. 

  155. 					<font fontName="SansSerif" isBold="true"/>
    156. 

  156. 				</textElement>
    157. 

  157. 				<text><![CDATA[Prezzo unit.]]></text>
    158. 

  158. 			</staticText>
    159. 

  159. 			<staticText>
    160. 

  160. 				<reportElement x="520" y="8" width="60" height="20" uuid="6ffed20b-99e7-4e5e-bf65-d79c433eb558"/>
    161. 

  161. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    162. 

  162. 					<font fontName="SansSerif" isBold="true"/>
    163. 

  163. 				</textElement>
    164. 

  164. 				<text><![CDATA[Divisa]]></text>
    165. 

  165. 			</staticText>
    166. 

  166. 			<line>
    167. 

  167. 				<reportElement x="1" y="30" width="798" height="1" uuid="54d7028d-d8c1-4933-b1a0-dc7e9355797e"/>
    168. 

  168. 			</line>
    169. 

  169. 			<line>
    170. 

  170. 				<reportElement x="1" y="2" width="798" height="1" uuid="dee55795-414e-494f-84f3-867819d1feef"/>
    171. 

  171. 			</line>
    172. 

  172. 			<staticText>
    173. 

  173. 				<reportElement x="277" y="8" width="78" height="20" uuid="0091738c-5f81-4700-aac1-ba9e4fae52af"/>
    174. 

  174. 				<textElement textAlignment="Center" verticalAlignment="Middle">
    175. 

  175. 					<font fontName="SansSerif" isBold="true"/>
    176. 

  176. 				</textElement>
    177. 

  177. 				<text><![CDATA[Origine mandato]]></text>
    178. 

  178. 			</staticText>
    179. 

  179. 			<staticText>
    180. 

  180. 				<reportElement x="592" y="7" width="88" height="20" uuid="404a30cc-202e-4eff-90fa-fd23fc37467b"/>
    181. 

  181. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    182. 

  182. 					<font fontName="SansSerif" isBold="true"/>
    183. 

  183. 				</textElement>
    184. 

  184. 				<text><![CDATA[Data acquisizione]]></text>
    185. 

  185. 			</staticText>
    186. 

  186. 			<staticText>
    187. 

  187. 				<reportElement x="690" y="7" width="100" height="20" uuid="ecc88a64-6c16-4b03-9313-810a3052c9d2"/>
    188. 

  188. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    189. 

  189. 					<font fontName="SansSerif" isBold="true"/>
    190. 

  190. 				</textElement>
    191. 

  191. 				<text><![CDATA[Tipo mandato]]></text>
    192. 

  192. 			</staticText>
    193. 

  193. 		</band>
    194. 

  194. 	</pageHeader>
    195. 

  195. 	<columnHeader>
    196. 

  196. 		<band splitType="Stretch"/>
    197. 

  197. 	</columnHeader>
    198. 

  198. 	<detail>
    199. 

  199. 		<band height="18" splitType="Stretch">
    200. 

  200. 			<textField isBlankWhenNull="true">
    201. 

  201. 				<reportElement x="5" y="0" width="108" height="18" uuid="a2f86cfd-075b-4e20-ab0a-a3ff4fc96a35"/>
    202. 

  202. 				<textElement verticalAlignment="Middle">
    203. 

  203. 					<font isBold="false"/>
    204. 

  204. 				</textElement>
    205. 

  205. 				<textFieldExpression><![CDATA[$F{identificativoMandato}]]></textFieldExpression>
    206. 

  206. 			</textField>
    207. 

  207. 			<textField isBlankWhenNull="true">
    208. 

  208. 				<reportElement x="118" y="0" width="81" height="18" uuid="ed6eed7c-30cb-4797-a20c-9fe89cc18c89"/>
    209. 

  209. 				<textElement textAlignment="Center" verticalAlignment="Middle">
    210. 

  210. 					<font isBold="false"/>
    211. 

  211. 				</textElement>
    212. 

  212. 				<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{dataAttivazioneMandato})]]></textFieldExpression>
    213. 

  213. 			</textField>
    214. 

  214. 			<textField isBlankWhenNull="true">
    215. 

  215. 				<reportElement x="290" y="0" width="60" height="18" uuid="f6e625b9-2112-4a00-aba3-a71de4b4b9c9"/>
    216. 

  216. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    217. 

  217. 					<font isBold="false"/>
    218. 

  218. 				</textElement>
    219. 

  219. 				<textFieldExpression><![CDATA[$F{tipoMandato}]]></textFieldExpression>
    220. 

  220. 			</textField>
    221. 

  221. 			<textField isBlankWhenNull="true">
    222. 

  222. 				<reportElement x="355" y="0" width="85" height="18" uuid="2cf15b2d-3be1-4d48-93b4-682bce7cd811"/>
    223. 

  223. 				<textElement verticalAlignment="Middle">
    224. 

  224. 					<font isBold="false"/>
    225. 

  225. 				</textElement>
    226. 

  226. 				<textFieldExpression><![CDATA[$F{statoTipoMandato}]]></textFieldExpression>
    227. 

  227. 			</textField>
    228. 

  228. 			<textField isBlankWhenNull="true">
    229. 

  229. 				<reportElement x="450" y="0" width="60" height="18" uuid="07505d9b-bc28-4345-b849-32a1773f4834"/>
    230. 

  230. 				<textElement textAlignment="Right" verticalAlignment="Middle">
    231. 

  231. 					<font isBold="false"/>
    232. 

  232. 				</textElement>
    233. 

  233. 				<textFieldExpression><![CDATA[$F{prezzoUnitarioMandato}]]></textFieldExpression>
    234. 

  234. 			</textField>
    235. 

  235. 			<textField isBlankWhenNull="true">
    236. 

  236. 				<reportElement x="206" y="0" width="70" height="18" uuid="a6ecdeb5-f0cd-45c7-a8d9-44ee5ca61e56"/>
    237. 

  237. 				<textElement textAlignment="Center" verticalAlignment="Middle">
    238. 

  238. 					<font isBold="false"/>
    239. 

  239. 				</textElement>
    240. 

  240. 				<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{dataRevocaMandato})]]></textFieldExpression>
    241. 

  241. 			</textField>
    242. 

  242. 			<textField isBlankWhenNull="true">
    243. 

  243. 				<reportElement x="520" y="0" width="60" height="18" uuid="4e35bdfe-538f-4bc5-a16b-99abf374f88b"/>
    244. 

  244. 				<textElement textAlignment="Center" verticalAlignment="Middle">
    245. 

  245. 					<font isBold="false"/>
    246. 

  246. 				</textElement>
    247. 

  247. 				<textFieldExpression><![CDATA[$F{divisa}]]></textFieldExpression>
    248. 

  248. 			</textField>
    249. 

  249. 			<textField isBlankWhenNull="true">
    250. 

  250. 				<reportElement x="600" y="0" width="60" height="18" uuid="bfc6d38a-9646-4cbd-ba7a-09017eb9513a"/>
    251. 

  251. 				<textElement verticalAlignment="Middle">
    252. 

  252. 					<font isBold="false"/>
    253. 

  253. 				</textElement>
    254. 

  254. 				<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{datarendi})]]></textFieldExpression>
    255. 

  255. 			</textField>
    256. 

  256. 			<textField isBlankWhenNull="true">
    257. 

  257. 				<reportElement x="690" y="0" width="100" height="18" uuid="52653189-44cc-497c-b445-f4436f69a722"/>
    258. 

  258. 				<textElement verticalAlignment="Middle">
    259. 

  259. 					<font isBold="false"/>
    260. 

  260. 				</textElement>
    261. 

  261. 				<textFieldExpression><![CDATA[$F{tipoSeda}]]></textFieldExpression>
    262. 

  262. 			</textField>
    263. 

  263. 		</band>
    264. 

  264. 	</detail>
    265. 

  265. 	<pageFooter>
    266. 

  266. 		<band height="61" splitType="Stretch">
    267. 

  267. 			<textField>
    268. 

  268. 				<reportElement x="299" y="20" width="100" height="30" uuid="9e11c3b5-aae2-471f-bd31-6dc5ddab4b25"/>
    269. 

  269. 				<textElement textAlignment="Right">
    270. 

  270. 					<font fontName="SansSerif"/>
    271. 

  271. 				</textElement>
    272. 

  272. 				<textFieldExpression><![CDATA["Pagina " + $V{PAGE_NUMBER}]]></textFieldExpression>
    273. 

  273. 			</textField>
    274. 

  274. 			<textField evaluationTime="Report">
    275. 

  275. 				<reportElement x="399" y="20" width="100" height="30" uuid="e7155d4f-286f-422e-a424-c05792b02da2"/>
    276. 

  276. 				<textElement textAlignment="Left">
    277. 

  277. 					<font fontName="SansSerif"/>
    278. 

  278. 				</textElement>
    279. 

  279. 				<textFieldExpression><![CDATA[" di " + $V{PAGE_NUMBER}]]></textFieldExpression>
    280. 

  280. 			</textField>
    281. 

  281. 		</band>
    282. 

  282. 	</pageFooter>
    283. 

  283. 	<summary>
    284. 

  284. 		<band height="43" splitType="Stretch">
    285. 

  285. 			<textField pattern="#,##0.###">
    286. 

  286. 				<reportElement x="128" y="20" width="124" height="20" uuid="8f378fe5-8cb3-45d9-82c6-300a5da958cf"/>
    287. 

  287. 				<textElement textAlignment="Right" verticalAlignment="Middle">
    288. 

  288. 					<font size="12"/>
    289. 

  289. 				</textElement>
    290. 

  290. 				<textFieldExpression><![CDATA[$V{cnt}]]></textFieldExpression>
    291. 

  291. 			</textField>
    292. 

  292. 			<staticText>
    293. 

  293. 				<reportElement x="8" y="21" width="120" height="20" uuid="970626fa-1621-4867-be2c-8cd335ceee83"/>
    294. 

  294. 				<textElement textAlignment="Left" verticalAlignment="Middle">
    295. 

  295. 					<font fontName="SansSerif" size="12" isBold="true"/>
    296. 

  296. 				</textElement>
    297. 

  297. 				<text><![CDATA[Numero mandati:]]></text>
    298. 

  298. 			</staticText>
    299. 

  299. 			<line>
    300. 

  300. 				<reportElement x="-2" y="10" width="798" height="1" uuid="3fd0d0e7-b6b0-4d37-8aa4-fd5bbbd8e05a"/>
    301. 

  301. 			</line>
    302. 

  302. 		</band>
    303. 

  303. 	</summary>
    304. 

  304. </jasperReport>
    305.