<?xml version="1.0" encoding="UTF-8"?> <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="material" language="groovy" pageWidth="240" pageHeight="141" whenNoDataType="AllSectionsNoDetail" columnWidth="240" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="79975b38-5e6c-4eab-9bc4-c6eb16eedad0"> <property name="ireport.zoom" value="1.3310000000000015"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="materialId" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <queryString> <![CDATA[SELECT * FROM material WHERE id = $P{materialId}]]> </queryString> <field name="id" class="java.lang.Integer"> <fieldDescription><![CDATA[ID]]></fieldDescription> </field> <field name="code" class="java.lang.String"> <fieldDescription><![CDATA[物料编码]]></fieldDescription> </field> <field name="companyCode" class="java.lang.String"> <fieldDescription><![CDATA[货主编码]]></fieldDescription> </field> <field name="warehouseCode" class="java.lang.String"> <fieldDescription><![CDATA[仓库编码]]></fieldDescription> </field> <field name="name" class="java.lang.String"> <fieldDescription><![CDATA[名称]]></fieldDescription> </field> <field name="spec" class="java.lang.String"> <fieldDescription><![CDATA[规格]]></fieldDescription> </field> <field name="unit" class="java.lang.String"> <fieldDescription><![CDATA[单位]]></fieldDescription> </field> <field name="type" class="java.lang.String"> <fieldDescription><![CDATA[类别]]></fieldDescription> </field> <field name="abcClass" class="java.lang.String"> <fieldDescription><![CDATA[ABC分类]]></fieldDescription> </field> <field name="daysToExpire" class="java.lang.Integer"> <fieldDescription><![CDATA[保质期(天)]]></fieldDescription> </field> <field name="locatingRule" class="java.lang.String"> <fieldDescription><![CDATA[定位规则]]></fieldDescription> </field> <field name="allocationRule" class="java.lang.String"> <fieldDescription><![CDATA[分配规则]]></fieldDescription> </field> <field name="replenishmentRule" class="java.lang.String"> <fieldDescription><![CDATA[补货规则]]></fieldDescription> </field> <field name="emptyLocRule" class="java.lang.String"> <fieldDescription><![CDATA[空货位规则]]></fieldDescription> </field> <field name="pickingRule" class="java.lang.String"> <fieldDescription><![CDATA[拣货规则]]></fieldDescription> </field> <field name="receivingFlow" class="java.lang.String"> <fieldDescription><![CDATA[入库流程]]></fieldDescription> </field> <field name="shippingFlow" class="java.lang.String"> <fieldDescription><![CDATA[出库流程]]></fieldDescription> </field> <field name="attributeTemplateCode" class="java.lang.String"> <fieldDescription><![CDATA[属性模版]]></fieldDescription> </field> <field name="trackSerialNum" class="java.lang.Integer"> <fieldDescription><![CDATA[记录序列号]]></fieldDescription> </field> <field name="autoGenSerialNum" class="java.lang.Integer"> <fieldDescription><![CDATA[自动生成序列号]]></fieldDescription> </field> <field name="autoGenSerialNumFormat" class="java.lang.String"> <fieldDescription><![CDATA[自动生成序列号表达式]]></fieldDescription> </field> <field name="snTemplateCode" class="java.lang.String"> <fieldDescription><![CDATA[序列号模版]]></fieldDescription> </field> <field name="expiringDays" class="java.lang.Integer"> <fieldDescription><![CDATA[临期预警天数]]></fieldDescription> </field> <field name="minShelfLifeDays" class="java.lang.Integer"> <fieldDescription><![CDATA[收货预警天数]]></fieldDescription> </field> <field name="enable" class="java.lang.Boolean"> <fieldDescription><![CDATA[状态]]></fieldDescription> </field> <field name="created" class="java.sql.Timestamp"> <fieldDescription><![CDATA[创建时间]]></fieldDescription> </field> <field name="createdBy" class="java.lang.String"> <fieldDescription><![CDATA[创建用户]]></fieldDescription> </field> <field name="lastUpdated" class="java.sql.Timestamp"> <fieldDescription><![CDATA[创建时间]]></fieldDescription> </field> <field name="lastUpdatedBy" class="java.lang.String"> <fieldDescription><![CDATA[更新用户]]></fieldDescription> </field> <field name="version" class="java.lang.Integer"> <fieldDescription><![CDATA[数据版本]]></fieldDescription> </field> <field name="userDef1" class="java.lang.String"> <fieldDescription><![CDATA[是否AGV区域发货]]></fieldDescription> </field> <field name="userDef2" class="java.lang.String"> <fieldDescription><![CDATA[自定义字段2]]></fieldDescription> </field> <field name="userDef3" class="java.lang.String"> <fieldDescription><![CDATA[商品同步标识]]></fieldDescription> </field> <field name="userDef4" class="java.lang.String"> <fieldDescription><![CDATA[自定义字段4]]></fieldDescription> </field> <field name="userDef5" class="java.lang.String"> <fieldDescription><![CDATA[自定义字段5]]></fieldDescription> </field> <field name="userDef6" class="java.lang.String"> <fieldDescription><![CDATA[自定义字段6]]></fieldDescription> </field> <field name="userDef7" class="java.lang.String"> <fieldDescription><![CDATA[自定义字段7]]></fieldDescription> </field> <field name="userDef8" class="java.lang.String"> <fieldDescription><![CDATA[自定义字段8]]></fieldDescription> </field> <field name="deleted" class="java.lang.Boolean"> <fieldDescription><![CDATA[删除标记]]></fieldDescription> </field> <field name="isMix" class="java.lang.Boolean"> <fieldDescription><![CDATA[是否允许混放]]></fieldDescription> </field> <variable name="QRShow" class="java.lang.String"> <variableExpression><![CDATA[$F{code}+"/"+$F{type}+"/"+$F{name}+"/"+$F{spec}]]></variableExpression> <initialValueExpression><![CDATA[$F{code}+"/"+$F{type}+"/"+$F{name}+"/"+$F{spec}]]></initialValueExpression> </variable> <title> <band height="141" splitType="Stretch"> <staticText> <reportElement x="5" y="2" width="60" height="26" uuid="1932b8a8-c71f-49d3-8bcc-07279085335e"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <text><![CDATA[物料编码]]></text> </staticText> <staticText> <reportElement x="5" y="54" width="60" height="26" uuid="b205c5bd-243b-4663-92ea-3e7d512e3665"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <text><![CDATA[物料类别]]></text> </staticText> <staticText> <reportElement x="5" y="28" width="60" height="26" uuid="fc4d8844-0049-4150-b9d8-f44afdab721a"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <text><![CDATA[物料名称]]></text> </staticText> <staticText> <reportElement x="5" y="80" width="60" height="26" uuid="1dacbaa8-ef65-4659-ba05-b10a148792c5"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <text><![CDATA[物料规格]]></text> </staticText> <staticText> <reportElement x="5" y="106" width="60" height="33" uuid="cae91b9a-62e2-4716-8943-cd89c13b9040"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <text><![CDATA[物料数量]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="65" y="2" width="150" height="26" uuid="65f1c486-0e5a-4836-8fb1-2c3d765e8c12"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{code}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="65" y="54" width="65" height="26" uuid="f94ddd88-6a85-457f-b438-3dc9c732b934"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{type}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="65" y="28" width="150" height="26" uuid="39cd9f74-2957-4217-b970-9f2066e7046b"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="65" y="80" width="65" height="26" uuid="3807ab57-3175-4a00-ac3f-b73a21075400"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{spec}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="65" y="106" width="65" height="33" uuid="aec0a63e-7aec-44b4-8d62-182c61e2169a"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="10" isBold="true"/> </textElement> </textField> <image> <reportElement x="130" y="54" width="85" height="85" uuid="64ab64bf-b12a-4cb2-a9df-7a2616e78b20"/> <box> <pen lineWidth="1.0" lineColor="#000000"/> <topPen lineWidth="1.0" lineColor="#000000"/> <leftPen lineWidth="1.0" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineColor="#000000"/> <rightPen lineWidth="1.0" lineColor="#000000"/> </box> <imageExpression> <![CDATA[com.google.zxing.client.j2se.MatrixToImageWriter.toBufferedImage(new com.google.zxing.qrcode.QRCodeWriter().encode(new String($V{QRShow}.getBytes("UTF-8"), "ISO-8859-1"), com.google.zxing.BarcodeFormat.QR_CODE, 200, 200))]]></imageExpression> </image> </band> </title> </jasperReport>