<?xml version="1.0" encoding="UTF-8"?>
|
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1 -->
|
<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="transFromDeliveryReportZhongXingBB" pageWidth="580" pageHeight="860" columnWidth="560" leftMargin="10" rightMargin="10" topMargin="10" bottomMargin="10" uuid="b8bdfe85-c191-4434-bc5a-7ee05da5bbb1">
|
<property name="com.jaspersoft.studio.unit." value="pixel"/>
|
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
|
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
|
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="装备"/>
|
<parameter name="id" class="java.lang.Long"/>
|
<queryString>
|
<![CDATA[SELECT wp.start_metre startMetre,wp.end_metre endMetre,wp."number",wp.product_standard productStandard,wp.routine_reel_number routineReelNumber,wp.create_user createUser,wp.gross_weight,bs.unit,to_char(qa.create_time,'yyyy/mm/dd') as createTime,A.volt_age_class voltAgeClass,A.product_name productName,A.outer_color outerColor,ws.part_batch_no partBatchNo
|
FROM warehouse_packaging wp
|
LEFT JOIN warehouse_join_stock_order wjso ON wjso."id" = wp.stock_order_id
|
LEFT JOIN plan_customer_order A ON A.id = wjso.customer_order_id
|
LEFT JOIN warehouse_stock ws ON ws."id" = wjso.stock_id
|
LEFT JOIN quality_apply_part qap ON qap.system_no = ws.system_no and qap.part_id = ws.part_id AND qap.lot_batch_no = ws.part_batch_no
|
LEFT JOIN quality_apply qa ON qa."id" = qap.apply_id
|
LEFT JOIN basic_part bs ON bs."id" = ws.part_id
|
WHERE wp."id" = $P!{id}
|
ORDER BY qap."id" DESC
|
LIMIT 1]]>
|
</queryString>
|
<field name="startMetre" class="java.math.BigDecimal">
|
<property name="com.jaspersoft.studio.field.label" value="delivertime"/>
|
</field>
|
<field name="endMetre" class="java.math.BigDecimal">
|
<property name="com.jaspersoft.studio.field.label" value="contactperson"/>
|
</field>
|
<field name="productStandard" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="phone"/>
|
</field>
|
<field name="routineReelNumber" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="escortnum"/>
|
</field>
|
<field name="createUser" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="deliverymethod"/>
|
</field>
|
<field name="number" class="java.math.BigDecimal">
|
<property name="com.jaspersoft.studio.field.label" value="number"/>
|
</field>
|
<field name="gross_weight" class="java.math.BigDecimal">
|
<property name="com.jaspersoft.studio.field.label" value="gross_weight"/>
|
</field>
|
<field name="unit" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="delivertime"/>
|
</field>
|
<field name="createTime" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="delivertime"/>
|
</field>
|
<field name="voltAgeClass" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="gross_weight"/>
|
</field>
|
<field name="productName" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="escortnum"/>
|
</field>
|
<field name="outerColor" class="java.lang.String">
|
<property name="com.jaspersoft.studio.field.label" value="escortnum"/>
|
</field>
|
<background>
|
<band splitType="Stretch"/>
|
</background>
|
<pageHeader>
|
<band height="343" splitType="Stretch">
|
<staticText>
|
<reportElement x="180" y="0" width="200" height="40" uuid="6969f52b-7711-48c2-b18c-471e43f104eb"/>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="20" isBold="true" isItalic="false"/>
|
</textElement>
|
<text><![CDATA[产品合格证]]></text>
|
</staticText>
|
<staticText>
|
<reportElement x="0" y="40" width="560" height="20" uuid="6076b374-4244-434e-a3b5-353f69024885"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="11" isBold="true"/>
|
</textElement>
|
<text><![CDATA[ISO9001:2015认证号：04321Q30717ROM]]></text>
|
</staticText>
|
<frame>
|
<reportElement positionType="Float" x="0" y="60" width="560" height="20" uuid="6ca7d58a-90ec-4ec3-99c0-e8e6fb850835"/>
|
<staticText>
|
<reportElement positionType="Float" stretchType="ElementGroupHeight" x="0" y="0" width="70" height="20" uuid="6a792ae4-4e27-4cc0-ad48-c660459cf2c3"/>
|
<box bottomPadding="0">
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="11"/>
|
<paragraph lineSpacing="Fixed"/>
|
</textElement>
|
<text><![CDATA[ 产品名称:]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement positionType="Float" stretchType="ElementGroupHeight" x="70" y="0" width="210" height="20" uuid="39a74f53-b6f4-4ecb-af0e-641464cd8745"/>
|
<box bottomPadding="0">
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="11"/>
|
<paragraph tabStopWidth="0"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{productName}]]></textFieldExpression>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="ElementGroupHeight" x="280" y="0" width="70" height="20" uuid="7e51b9c6-c952-4162-b5a1-b29a0f166c1a"/>
|
<box bottomPadding="0">
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="11"/>
|
</textElement>
|
<text><![CDATA[长度:]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement positionType="Float" stretchType="ElementGroupHeight" x="350" y="0" width="210" height="20" uuid="a231b2fa-cc9d-4bf8-b54f-a66d9e95652a"/>
|
<box bottomPadding="0">
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="11"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{number}.stripTrailingZeros().toPlainString()]]></textFieldExpression>
|
</textField>
|
</frame>
|
<image>
|
<reportElement x="0" y="0" width="115" height="40" uuid="43c23904-b9bb-4a6b-9be3-ddd918ad23a8"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<imageExpression><![CDATA["http://192.168.20.88/mes/jasper/img/ztt-logo.png"]]></imageExpression>
|
</image>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="80" width="70" height="20" uuid="4dc86ecf-43d7-4f83-8171-10904b259acb"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[型号规格：]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="100" width="70" height="20" uuid="297a21b9-f672-44eb-bf5e-c922161dd39d"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[产品颜色：]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="120" width="70" height="20" uuid="98791d53-65ac-411b-833d-ebb036abc92c"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[流水号：]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="140" width="70" height="20" uuid="337d41ad-2b7f-41e9-a17f-c0eddb70cef1"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[盘号：]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="160" width="70" height="20" uuid="dd213940-ae63-4953-bea2-ecf52a6da604"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[制造日期：]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="180" width="560" height="20" uuid="0788407c-bf1d-4ea8-abd6-13ece2c2c5b5"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[ 中天科技装备电缆有限公司]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="70" y="80" width="210" height="20" isPrintWhenDetailOverflows="true" uuid="e952720f-b3b5-464b-92f2-ca0b1758b6de"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
</textField>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="70" y="100" width="210" height="20" isPrintWhenDetailOverflows="true" uuid="6f2b424e-4d17-4b13-b0dc-98a2e68d2b09"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{outerColor}]]></textFieldExpression>
|
</textField>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="70" y="120" width="210" height="20" isPrintWhenDetailOverflows="true" uuid="1b6781a6-ba1f-4f03-9d72-10cf24a3a7c5"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
</textField>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="70" y="140" width="210" height="20" isPrintWhenDetailOverflows="true" uuid="a123e901-8a83-4a63-a4c2-a8d06087b909"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
</textField>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="70" y="160" width="210" height="20" isPrintWhenDetailOverflows="true" uuid="4f24a26b-c570-4902-8c17-44bea0f11577"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="280" y="80" width="70" height="20" uuid="01800710-d7be-493c-ae77-775bc9235c6a"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[起止米标：]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement positionType="Float" stretchType="ElementGroupHeight" x="350" y="80" width="210" height="20" uuid="ae6c4bcf-b4cf-45e0-aac7-f2634aa79f59"/>
|
<box bottomPadding="0">
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="11"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{startMetre}.stripTrailingZeros().toPlainString()+"-"+$F{endMetre}.stripTrailingZeros().toPlainString()]]></textFieldExpression>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="280" y="100" width="70" height="20" uuid="d1e12afe-c8fa-4384-bfaf-c10cc66e4eb3"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[电压等级：]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="350" y="100" width="210" height="20" uuid="e710fd21-399b-4652-9dd4-354c275e3bb3"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="280" y="120" width="70" height="20" uuid="4de17041-f460-4ee1-80ef-1d909bcc8425"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[产品标准：]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="350" y="120" width="210" height="20" uuid="a596a406-7d3d-482b-a071-596b26469409"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{productStandard}]]></textFieldExpression>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="280" y="140" width="70" height="20" uuid="c22cbcce-03a8-4b97-b8da-1da6d37d51f8"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[检验员：]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="350" y="140" width="210" height="20" uuid="8aebcadc-5194-430c-aa01-f4f8c4cd4a04"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{createUser}]]></textFieldExpression>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="280" y="160" width="70" height="20" uuid="658e4fda-d0d9-4f42-ab4d-c340a6a574b9"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[毛重：]]></text>
|
</staticText>
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
<reportElement stretchType="RelativeToBandHeight" x="350" y="160" width="210" height="20" uuid="3e0b3fc6-a6f2-4849-b84f-a61ac237e4be"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<textFieldExpression><![CDATA[$F{gross_weight}]]></textFieldExpression>
|
</textField>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="200" width="560" height="20" uuid="a44050f9-d1b4-4043-8b77-30bbc0abc16d"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[ 地址：江苏省南通市经济技术开发区新开南路]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="220" width="560" height="20" uuid="fc34c368-b6ea-4cd9-96b4-30bee1e0cd2f"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[ 电话(TEL):0513-89059077 传真(FAX):0513-89059076]]></text>
|
</staticText>
|
<staticText>
|
<reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="240" width="560" height="20" uuid="25f00e24-c577-4455-b5c3-936850f231e4"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<textElement textAlignment="Left" verticalAlignment="Middle">
|
<font fontName="中文黑体" size="12"/>
|
</textElement>
|
<text><![CDATA[ 注意事项：]]></text>
|
</staticText>
|
<image>
|
<reportElement x="0" y="260" width="112" height="65" uuid="01ee3bb6-e46d-41c7-ab53-58d5b150422a"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<imageExpression><![CDATA["http://192.168.20.88/mes/jasper/img/1.png"]]></imageExpression>
|
</image>
|
<image>
|
<reportElement x="112" y="260" width="112" height="65" uuid="9a30e4da-4179-4ffa-8447-1337d6686d30"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<imageExpression><![CDATA["http://192.168.20.88/mes/jasper/img/2.png"]]></imageExpression>
|
</image>
|
<image>
|
<reportElement x="224" y="260" width="112" height="65" uuid="2907c68a-127d-44a2-a790-d2ad4c454bcb"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<imageExpression><![CDATA["http://192.168.20.88/mes/jasper/img/3.png"]]></imageExpression>
|
</image>
|
<image>
|
<reportElement x="336" y="260" width="112" height="65" uuid="88dc7cbf-68d4-4f9b-85a7-b298404f33e8"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<imageExpression><![CDATA["http://192.168.20.88/mes/jasper/img/4.png"]]></imageExpression>
|
</image>
|
<image>
|
<reportElement x="448" y="260" width="112" height="65" uuid="098e5492-53cf-4f6a-a2a7-c528ef17d0ef"/>
|
<box>
|
<pen lineWidth="0.25"/>
|
</box>
|
<imageExpression><![CDATA["http://192.168.20.88/mes/jasper/img/5.png"]]></imageExpression>
|
</image>
|
</band>
|
</pageHeader>
|
<lastPageFooter>
|
<band/>
|
</lastPageFooter>
|
</jasperReport>
|
