<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown --> <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="inventoryTrans" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="021febb9-ba92-4db2-a4e7-e9e7f112e792"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="myAdapter"/> <queryString language="SQL"> <![CDATA[SELECT i.materialCode,m.name,m.spec,SUM(i.taskQty) taskQty from inventory_transaction i INNER JOIN material m on i.materialCode=m.code and (i.transactionType=30 or i.transactionType=40) and i.created >date_sub(curdate(), INTERVAL 30 DAY) GROUP BY i.materialCode,m.name,m.spec ORDER BY taskQty desc]]> </queryString> <field name="materialCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="materialCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_transaction"/> </field> <field name="name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="name"/> <property name="com.jaspersoft.studio.field.tree.path" value="material"/> </field> <field name="spec" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="spec"/> <property name="com.jaspersoft.studio.field.tree.path" value="material"/> </field> <field name="taskQty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="taskQty"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <staticText> <reportElement x="220" y="30" width="100" height="30" uuid="5d01f7b9-e2ba-45ca-a815-1c88383d0ea2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="16"/> </textElement> <text><![CDATA[华恒库存出库交易]]></text> </staticText> </band> </title> <pageHeader> <band height="48" splitType="Stretch"> <staticText> <reportElement x="160" y="10" width="100" height="30" uuid="2eb87fc1-1cba-45f2-ba32-d01503be359b"/> <textElement textAlignment="Right" verticalAlignment="Middle"/> <text><![CDATA[时间]]></text> </staticText> <textField pattern="MMMMM dd, yyyy"> <reportElement x="260" y="10" width="100" height="30" uuid="e7d28891-6914-40c2-bdf7-17e375670c3b"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="33" splitType="Stretch"> <staticText> <reportElement x="250" y="0" width="100" height="30" uuid="b98a1182-05b6-47de-b42d-93ab5a24d5a6"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[物料规格]]></text> </staticText> <staticText> <reportElement x="350" y="3" width="100" height="30" uuid="217e8701-9f23-4602-857b-b3cc117b5c1b"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[数量]]></text> </staticText> <staticText> <reportElement x="150" y="0" width="100" height="30" uuid="e48a2bea-beb0-4919-b982-77ddc8ca6808"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[物料名称]]></text> </staticText> <staticText> <reportElement x="50" y="0" width="100" height="30" uuid="aa71cbe5-b6e3-4cfe-92d6-b6c5c5e2c402"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[物料编码]]></text> </staticText> </band> </columnHeader> <detail> <band height="33" splitType="Stretch"> <textField> <reportElement x="50" y="0" width="100" height="30" uuid="787886f9-1be7-4846-8f6f-a276f0f03851"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{materialCode}]]></textFieldExpression> </textField> <textField> <reportElement x="150" y="-3" width="100" height="30" uuid="40e1a9b7-0427-4a28-b83b-96c590733e6b"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <textField> <reportElement x="250" y="0" width="100" height="30" uuid="b79c0ba5-c219-426a-bc56-0f68db3ae8fc"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{spec}]]></textFieldExpression> </textField> <textField> <reportElement x="350" y="1" width="100" height="30" uuid="9d3f5b1f-9224-4cc7-8676-3cdb10463341"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{taskQty}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="27" splitType="Stretch"> <textField> <reportElement x="475" y="-3" width="100" height="30" uuid="a7a31527-f442-4b48-8e9a-d824c755f6f5"/> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>