inventoryTransS.jrxml
5.44 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<?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>