<?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="mypage" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="269017e1-91e2-41c1-8c72-e94c48e4265a"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="myAdapter"/> <queryString language="SQL"> <![CDATA[select id, materialCode, locationCode, qty, inventorySts, TIMESTAMPDIFF(DAY,created,NOW()) as time from inventory_detail]]> </queryString> <field name="id" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="id"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <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_detail"/> </field> <field name="locationCode" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="locationCode"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="qty" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="qty"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="inventorySts" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="inventorySts"/> <property name="com.jaspersoft.studio.field.tree.path" value="inventory_detail"/> </field> <field name="time" class="java.lang.Long"> <property name="com.jaspersoft.studio.field.label" value="time"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <staticText> <reportElement x="220" y="30" width="100" height="30" isRemoveLineWhenBlank="true" uuid="8b09e723-8b9c-4cf0-8797-cadf3e5b6af5"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="20"/> </textElement> <text><![CDATA[库存报表]]></text> </staticText> </band> </title> <pageHeader> <band height="40" splitType="Stretch"> <staticText> <reportElement x="-10" y="6" width="100" height="30" isRemoveLineWhenBlank="true" uuid="3255876e-83de-41f7-ac80-c0e0002183d8"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[公司:]]></text> </staticText> <staticText> <reportElement x="90" y="6" width="100" height="30" isRemoveLineWhenBlank="true" uuid="d7fe09d1-e13b-4c2c-8370-8ab5f4fe27e0"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[华恒机器人]]></text> </staticText> <staticText> <reportElement x="340" y="5" width="100" height="30" isRemoveLineWhenBlank="true" uuid="129192ee-63ff-42ac-bad8-6ea886aa7df1"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[时间:]]></text> </staticText> <textField pattern="MMMMM dd, yyyy"> <reportElement x="440" y="5" width="100" height="30" isRemoveLineWhenBlank="true" uuid="0e9b0a78-271c-46c3-a9a5-ada603e1d586"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="40" splitType="Stretch"> <staticText> <reportElement x="-20" y="10" width="90" height="30" isRemoveLineWhenBlank="true" uuid="a46711b9-185c-4f72-8ba4-3913cf7ffa36"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[序号]]></text> </staticText> <staticText> <reportElement x="70" y="10" width="100" height="30" isRemoveLineWhenBlank="true" uuid="316c901d-5d62-4cf9-96b0-9292282b83d4"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[物料]]></text> </staticText> <staticText> <reportElement x="170" y="10" width="100" height="30" isRemoveLineWhenBlank="true" uuid="d2889df8-acf6-42f3-baf8-cee479d95744"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[库位]]></text> </staticText> <staticText> <reportElement x="270" y="10" width="100" height="30" isRemoveLineWhenBlank="true" uuid="648755a4-c6e4-4d43-842f-cbbcccf3b602"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[数量]]></text> </staticText> <staticText> <reportElement x="370" y="10" width="100" height="30" isRemoveLineWhenBlank="true" uuid="7400f621-cdcc-4c01-affc-b5247c64c279"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[状态]]></text> </staticText> <staticText> <reportElement x="470" y="10" width="100" height="30" isRemoveLineWhenBlank="true" uuid="445b4f01-fe14-4433-a239-3a9ce548b9a2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <text><![CDATA[距今时间]]></text> </staticText> </band> </columnHeader> <detail> <band height="31" splitType="Stretch"> <textField> <reportElement x="-20" y="0" width="90" height="30" isRemoveLineWhenBlank="true" uuid="8c955db5-fc66-441b-863c-92d5f92120b3"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression> </textField> <textField> <reportElement x="70" y="0" width="100" height="30" isRemoveLineWhenBlank="true" uuid="a45ff2e7-b85b-42d3-a2e6-30e5e78e4979"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{materialCode}]]></textFieldExpression> </textField> <textField> <reportElement x="170" y="0" width="100" height="30" isRemoveLineWhenBlank="true" uuid="5225baa7-39e2-4e37-8905-f0be6c22383e"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{locationCode}]]></textFieldExpression> </textField> <textField> <reportElement x="270" y="0" width="100" height="30" isRemoveLineWhenBlank="true" uuid="9db2444d-b495-40aa-bee9-cd5b86b709b2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression> </textField> <textField> <reportElement x="370" y="0" width="100" height="30" isRemoveLineWhenBlank="true" uuid="13b8f525-a4f3-4d10-9056-934b6ceb8baa"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{inventorySts}]]></textFieldExpression> </textField> <textField> <reportElement x="470" y="0" width="100" height="30" isRemoveLineWhenBlank="true" uuid="17b64d38-bd90-49e7-9547-356eec6efb1f"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="华文宋体" size="10"/> </textElement> <textFieldExpression><![CDATA[$F{time}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>