jyrTj-pro.jrxml 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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="jyrTj-pro" language="groovy" pageWidth="595" pageHeight="855" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d3106f06-af0a-4da7-96d9-1b2988ed16bd">
  3. <property name="ireport.zoom" value="1.0"/>
  4. <property name="ireport.x" value="0"/>
  5. <property name="ireport.y" value="0"/>
  6. <parameter name="is_year" class="java.lang.Boolean">
  7. <defaultValueExpression><![CDATA[true]]></defaultValueExpression>
  8. </parameter>
  9. <field name="NAME" class="java.lang.String"/>
  10. <field name="NUM" class="java.math.BigDecimal"/>
  11. <field name="WHNUM" class="java.math.BigDecimal"/>
  12. <field name="YEAR" class="java.math.BigDecimal"/>
  13. <field name="MONTH" class="java.math.BigDecimal"/>
  14. <field name="CCL" class="java.math.BigDecimal"/>
  15. <field name="SL" class="java.math.BigDecimal"/>
  16. <variable name="c_num" class="java.math.BigDecimal" calculation="Sum">
  17. <variableExpression><![CDATA[$F{NUM}]]></variableExpression>
  18. </variable>
  19. <variable name="c_whnum" class="java.math.BigDecimal" calculation="Sum">
  20. <variableExpression><![CDATA[$F{WHNUM}]]></variableExpression>
  21. </variable>
  22. <variable name="c_year" class="java.math.BigDecimal" calculation="Sum">
  23. <variableExpression><![CDATA[$F{YEAR}]]></variableExpression>
  24. </variable>
  25. <variable name="c_month" class="java.math.BigDecimal" calculation="Sum">
  26. <variableExpression><![CDATA[$F{MONTH}]]></variableExpression>
  27. </variable>
  28. <variable name="c_ccl" class="java.math.BigDecimal" calculation="Sum">
  29. <variableExpression><![CDATA[$F{CCL}]]></variableExpression>
  30. </variable>
  31. <variable name="c_sl" class="java.math.BigDecimal" calculation="Sum">
  32. <variableExpression><![CDATA[$F{SL}]]></variableExpression>
  33. </variable>
  34. <background>
  35. <band splitType="Stretch"/>
  36. </background>
  37. <title>
  38. <band height="40" splitType="Stretch">
  39. <textField>
  40. <reportElement x="0" y="0" width="555" height="40" uuid="acf306dc-395e-4527-88cf-2ed803c1470d"/>
  41. <textElement textAlignment="Center">
  42. <font size="20"/>
  43. </textElement>
  44. <textFieldExpression><![CDATA["港口经营人信息统计(截止"+new java.text.SimpleDateFormat("yyyy.MM.dd").format(new Date())+")"]]></textFieldExpression>
  45. </textField>
  46. </band>
  47. </title>
  48. <columnHeader>
  49. <band height="20" splitType="Stretch">
  50. <staticText>
  51. <reportElement x="0" y="0" width="90" height="20" uuid="51b5e370-bd54-4bc1-8b6c-1ecaa16121ea"/>
  52. <box leftPadding="2" rightPadding="2">
  53. <topPen lineWidth="0.5"/>
  54. <leftPen lineWidth="0.5"/>
  55. <bottomPen lineWidth="0.5"/>
  56. <rightPen lineWidth="0.5"/>
  57. </box>
  58. <textElement textAlignment="Center" verticalAlignment="Middle">
  59. <font fontName="宋体" size="10"/>
  60. </textElement>
  61. <text><![CDATA[所在地]]></text>
  62. </staticText>
  63. <staticText>
  64. <reportElement x="90" y="0" width="80" height="20" uuid="470b29c2-c9ff-4e9e-8b93-f911260b8c7e"/>
  65. <box leftPadding="2" rightPadding="2">
  66. <topPen lineWidth="0.5"/>
  67. <leftPen lineWidth="0.5"/>
  68. <bottomPen lineWidth="0.5"/>
  69. <rightPen lineWidth="0.5"/>
  70. </box>
  71. <textElement textAlignment="Center" verticalAlignment="Middle">
  72. <font fontName="宋体" size="10"/>
  73. </textElement>
  74. <text><![CDATA[企业数]]></text>
  75. </staticText>
  76. <staticText>
  77. <reportElement x="170" y="0" width="90" height="20" uuid="095ac58b-b7e4-4964-afc9-2fad282f5a88"/>
  78. <box leftPadding="2" rightPadding="2">
  79. <topPen lineWidth="0.5"/>
  80. <leftPen lineWidth="0.5"/>
  81. <bottomPen lineWidth="0.5"/>
  82. <rightPen lineWidth="0.5"/>
  83. </box>
  84. <textElement textAlignment="Center" verticalAlignment="Middle">
  85. <font fontName="宋体" size="10"/>
  86. </textElement>
  87. <text><![CDATA[危货企业数]]></text>
  88. </staticText>
  89. <staticText>
  90. <reportElement x="260" y="0" width="100" height="20" uuid="9d5656f4-f58a-40f6-b556-9f259055c31c">
  91. <printWhenExpression><![CDATA[$P{is_year}]]></printWhenExpression>
  92. </reportElement>
  93. <box leftPadding="2" rightPadding="2">
  94. <topPen lineWidth="0.5"/>
  95. <leftPen lineWidth="0.5"/>
  96. <bottomPen lineWidth="0.5"/>
  97. <rightPen lineWidth="0.5"/>
  98. </box>
  99. <textElement textAlignment="Center" verticalAlignment="Middle">
  100. <font fontName="宋体" size="10"/>
  101. </textElement>
  102. <text><![CDATA[本年新增危货企业数]]></text>
  103. </staticText>
  104. <staticText>
  105. <reportElement x="260" y="0" width="100" height="20" uuid="c5c8a875-dd6f-427a-864e-5586686304de">
  106. <printWhenExpression><![CDATA[!$P{is_year}]]></printWhenExpression>
  107. </reportElement>
  108. <box leftPadding="2" rightPadding="2">
  109. <topPen lineWidth="0.5"/>
  110. <leftPen lineWidth="0.5"/>
  111. <bottomPen lineWidth="0.5"/>
  112. <rightPen lineWidth="0.5"/>
  113. </box>
  114. <textElement textAlignment="Center" verticalAlignment="Middle">
  115. <font fontName="宋体" size="10"/>
  116. </textElement>
  117. <text><![CDATA[本月新增危货企业数]]></text>
  118. </staticText>
  119. <staticText>
  120. <reportElement x="445" y="0" width="110" height="20" uuid="d309cf61-aca3-45c2-8232-022845baf601"/>
  121. <box leftPadding="2" rightPadding="2">
  122. <topPen lineWidth="0.5"/>
  123. <leftPen lineWidth="0.5"/>
  124. <bottomPen lineWidth="0.5"/>
  125. <rightPen lineWidth="0.5"/>
  126. </box>
  127. <textElement textAlignment="Center" verticalAlignment="Middle">
  128. <font fontName="宋体" size="10"/>
  129. </textElement>
  130. <text><![CDATA[储罐总容量(万立方米)]]></text>
  131. </staticText>
  132. <staticText>
  133. <reportElement x="360" y="0" width="85" height="20" uuid="856301f4-0e30-4b1a-bb07-7c423b8450d2"/>
  134. <box leftPadding="2" rightPadding="2">
  135. <topPen lineWidth="0.5"/>
  136. <leftPen lineWidth="0.5"/>
  137. <bottomPen lineWidth="0.5"/>
  138. <rightPen lineWidth="0.5"/>
  139. </box>
  140. <textElement textAlignment="Center" verticalAlignment="Middle">
  141. <font fontName="宋体" size="10"/>
  142. </textElement>
  143. <text><![CDATA[储罐总数量(个)]]></text>
  144. </staticText>
  145. </band>
  146. </columnHeader>
  147. <detail>
  148. <band height="20" splitType="Stretch">
  149. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  150. <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="90" height="20" uuid="1b5d8424-6c73-46c0-8942-50082c68b598"/>
  151. <box leftPadding="5">
  152. <topPen lineWidth="0.5"/>
  153. <leftPen lineWidth="0.5"/>
  154. <bottomPen lineWidth="0.5"/>
  155. <rightPen lineWidth="0.5"/>
  156. </box>
  157. <textElement verticalAlignment="Middle">
  158. <font fontName="Serif"/>
  159. </textElement>
  160. <textFieldExpression><![CDATA[com.yjpt.util.PropReader.getProperty($F{NAME})]]></textFieldExpression>
  161. </textField>
  162. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  163. <reportElement stretchType="RelativeToTallestObject" x="90" y="0" width="80" height="20" uuid="de0e8334-19b8-4efc-9565-2012f964abc9"/>
  164. <box leftPadding="5">
  165. <topPen lineWidth="0.5"/>
  166. <leftPen lineWidth="0.5"/>
  167. <bottomPen lineWidth="0.5"/>
  168. <rightPen lineWidth="0.5"/>
  169. </box>
  170. <textElement verticalAlignment="Middle">
  171. <font fontName="Serif"/>
  172. </textElement>
  173. <textFieldExpression><![CDATA[$F{NUM}]]></textFieldExpression>
  174. </textField>
  175. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  176. <reportElement stretchType="RelativeToTallestObject" x="170" y="0" width="90" height="20" uuid="76daf893-d3a3-4a40-851a-435f7a0327b7"/>
  177. <box leftPadding="5">
  178. <topPen lineWidth="0.5"/>
  179. <leftPen lineWidth="0.5"/>
  180. <bottomPen lineWidth="0.5"/>
  181. <rightPen lineWidth="0.5"/>
  182. </box>
  183. <textElement verticalAlignment="Middle">
  184. <font fontName="Serif"/>
  185. </textElement>
  186. <textFieldExpression><![CDATA[$F{WHNUM}]]></textFieldExpression>
  187. </textField>
  188. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  189. <reportElement stretchType="RelativeToTallestObject" x="260" y="0" width="100" height="20" uuid="32b5f801-8430-4040-aa60-be1900301de0"/>
  190. <box leftPadding="5">
  191. <topPen lineWidth="0.5"/>
  192. <leftPen lineWidth="0.5"/>
  193. <bottomPen lineWidth="0.5"/>
  194. <rightPen lineWidth="0.5"/>
  195. </box>
  196. <textElement verticalAlignment="Middle">
  197. <font fontName="Serif"/>
  198. </textElement>
  199. <textFieldExpression><![CDATA[$P{is_year}?$F{YEAR}:$F{MONTH}]]></textFieldExpression>
  200. </textField>
  201. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  202. <reportElement stretchType="RelativeToTallestObject" x="445" y="0" width="110" height="20" uuid="295ae524-d28a-4d36-b6d6-3ebe6add2148"/>
  203. <box leftPadding="5">
  204. <topPen lineWidth="0.5"/>
  205. <leftPen lineWidth="0.5"/>
  206. <bottomPen lineWidth="0.5"/>
  207. <rightPen lineWidth="0.5"/>
  208. </box>
  209. <textElement verticalAlignment="Middle">
  210. <font fontName="Serif"/>
  211. </textElement>
  212. <textFieldExpression><![CDATA[$F{CCL}]]></textFieldExpression>
  213. </textField>
  214. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  215. <reportElement stretchType="RelativeToTallestObject" x="360" y="0" width="85" height="20" uuid="c9132b3e-4380-41df-990e-994a8cf0b324"/>
  216. <box leftPadding="5">
  217. <topPen lineWidth="0.5"/>
  218. <leftPen lineWidth="0.5"/>
  219. <bottomPen lineWidth="0.5"/>
  220. <rightPen lineWidth="0.5"/>
  221. </box>
  222. <textElement verticalAlignment="Middle">
  223. <font fontName="Serif"/>
  224. </textElement>
  225. <textFieldExpression><![CDATA[$F{SL}]]></textFieldExpression>
  226. </textField>
  227. </band>
  228. </detail>
  229. <summary>
  230. <band height="20" splitType="Stretch">
  231. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  232. <reportElement stretchType="RelativeToTallestObject" x="90" y="0" width="80" height="20" uuid="ccd1ea5b-f8da-46fa-b76c-0786e030be1d"/>
  233. <box leftPadding="5">
  234. <topPen lineWidth="0.5"/>
  235. <leftPen lineWidth="0.5"/>
  236. <bottomPen lineWidth="0.5"/>
  237. <rightPen lineWidth="0.5"/>
  238. </box>
  239. <textElement verticalAlignment="Middle">
  240. <font fontName="Serif"/>
  241. </textElement>
  242. <textFieldExpression><![CDATA[$V{c_num}]]></textFieldExpression>
  243. </textField>
  244. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  245. <reportElement stretchType="RelativeToTallestObject" x="260" y="0" width="100" height="20" uuid="6bd55985-df40-4d44-a1c2-bb401dfda967"/>
  246. <box leftPadding="5">
  247. <topPen lineWidth="0.5"/>
  248. <leftPen lineWidth="0.5"/>
  249. <bottomPen lineWidth="0.5"/>
  250. <rightPen lineWidth="0.5"/>
  251. </box>
  252. <textElement verticalAlignment="Middle">
  253. <font fontName="Serif"/>
  254. </textElement>
  255. <textFieldExpression><![CDATA[$P{is_year}?$V{c_year}:$V{c_month}]]></textFieldExpression>
  256. </textField>
  257. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  258. <reportElement stretchType="RelativeToTallestObject" x="170" y="0" width="90" height="20" uuid="7c615af7-03c8-47d5-8a1f-ded11b403b3a"/>
  259. <box leftPadding="5">
  260. <topPen lineWidth="0.5"/>
  261. <leftPen lineWidth="0.5"/>
  262. <bottomPen lineWidth="0.5"/>
  263. <rightPen lineWidth="0.5"/>
  264. </box>
  265. <textElement verticalAlignment="Middle">
  266. <font fontName="Serif"/>
  267. </textElement>
  268. <textFieldExpression><![CDATA[$V{c_whnum}]]></textFieldExpression>
  269. </textField>
  270. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  271. <reportElement stretchType="RelativeToTallestObject" x="445" y="0" width="110" height="20" uuid="a998a5f3-2191-438e-8dc5-caf967e04c54"/>
  272. <box leftPadding="5">
  273. <topPen lineWidth="0.5"/>
  274. <leftPen lineWidth="0.5"/>
  275. <bottomPen lineWidth="0.5"/>
  276. <rightPen lineWidth="0.5"/>
  277. </box>
  278. <textElement verticalAlignment="Middle">
  279. <font fontName="Serif"/>
  280. </textElement>
  281. <textFieldExpression><![CDATA[$V{c_ccl}]]></textFieldExpression>
  282. </textField>
  283. <staticText>
  284. <reportElement x="0" y="0" width="90" height="20" uuid="b84473d2-5401-4907-8738-1a40af065f64"/>
  285. <box>
  286. <topPen lineWidth="0.5"/>
  287. <leftPen lineWidth="0.5"/>
  288. <bottomPen lineWidth="0.5"/>
  289. <rightPen lineWidth="0.5"/>
  290. </box>
  291. <textElement textAlignment="Center" verticalAlignment="Middle">
  292. <font fontName="宋体" size="10" isBold="true"/>
  293. </textElement>
  294. <text><![CDATA[合计]]></text>
  295. </staticText>
  296. <textField isStretchWithOverflow="true" isBlankWhenNull="true">
  297. <reportElement stretchType="RelativeToTallestObject" x="360" y="0" width="85" height="20" uuid="88afca9a-587c-4d21-8a7b-dc61edda4d42"/>
  298. <box leftPadding="5">
  299. <topPen lineWidth="0.5"/>
  300. <leftPen lineWidth="0.5"/>
  301. <bottomPen lineWidth="0.5"/>
  302. <rightPen lineWidth="0.5"/>
  303. </box>
  304. <textElement verticalAlignment="Middle">
  305. <font fontName="Serif"/>
  306. </textElement>
  307. <textFieldExpression><![CDATA[$V{c_sl}]]></textFieldExpression>
  308. </textField>
  309. </band>
  310. </summary>
  311. </jasperReport>