Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="Blank_A4_Landscape" pageWidth="254" pageHeight="82" orientation="Landscape" columnWidth="244" leftMargin="5" rightMargin="5" topMargin="2" bottomMargin="2" uuid="e7847621-3291-4ffe-a502-aaa6ee6f783d">
- <property name="com.jaspersoft.studio.unit." value="inch"/>
- <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
- <property name="ireport.zoom" value="3.0"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="0"/>
- <subDataset name="dataset1" uuid="7311a7f0-0cb7-495a-aedc-8e907af470eb"/>
- <queryString>
- <![CDATA[SELECT f_get_product_code(A.product_id)||'#'||F.serial_number AS qr_code,
- f_get_product_code(A.product_id) AS model, F.serial_number AS serial_number,
- D.warranty_type_name AS warranty_type_name,
- CASE WHEN D.flg_print_detail = 'Y' THEN true ELSE false END AS is_print_detail,
- G.detail_field, G.detail_value
- FROM sl_do_item A
- INNER JOIN sl_so_item B ON B.so_item_id = A.ref_id AND B.product_id = A.product_id
- INNER JOIN sl_so_warranty_item C ON C.so_item_id = B.so_item_id
- INNER JOIN m_warranty_type D ON D.warranty_type_id = C.warranty_type_id
- INNER JOIN sl_do_product E ON E.do_item_id = A.do_item_id
- INNER JOIN in_product_balance F ON F.product_balance_id = E.product_balance_id
- LEFT JOIN m_warranty_type_detail G ON G.warranty_type_id = D.warranty_type_id
- WHERE A.do_id = 16837 AND A.tenant_id = 10
- ORDER BY qr_code, model, serial_number, warranty_type_name, is_print_detail]]>
- </queryString>
- <field name="qr_code" class="java.lang.String"/>
- <field name="model" class="java.lang.String"/>
- <field name="serial_number" class="java.lang.String"/>
- <field name="warranty_type_name" class="java.lang.String"/>
- <field name="is_print_detail" class="java.lang.Boolean"/>
- <field name="detail_field" class="java.lang.String"/>
- <field name="detail_value" class="java.lang.String"/>
- <variable name="ProductWarrantyNumber" class="java.lang.Integer" resetType="None" incrementType="Group" incrementGroup="ProductWarranty" calculation="Count"/>
- <group name="ProductWarranty">
- <groupExpression><![CDATA[$F{qr_code} + $F{model} + $F{serial_number} + $F{warranty_type_name} + $F{is_print_detail}.toString()]]></groupExpression>
- <groupHeader>
- <band height="33" splitType="Stretch">
- <staticText>
- <reportElement x="79" y="10" width="58" height="5" uuid="44df8b0b-efd7-4fbe-a033-d07ec0002bbc"/>
- <textElement>
- <font fontName="DejaVu Sans" size="4" isBold="true"/>
- </textElement>
- <text><![CDATA[Model / No Serial]]></text>
- </staticText>
- <textField isBlankWhenNull="true">
- <reportElement x="142" y="10" width="102" height="5" uuid="28e69ee5-54db-4c7b-815a-46a3b072d660"/>
- <textElement>
- <font fontName="DejaVu Sans" size="4" isBold="true" isPdfEmbedded="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{model}+" / "+$F{serial_number}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="79" y="17" width="58" height="5" uuid="68401576-07fe-4cb0-b12f-d3f867416e24">
- <property name="com.jaspersoft.studio.unit.height" value="inch"/>
- </reportElement>
- <textElement>
- <font fontName="DejaVu Sans" size="4" isBold="true"/>
- </textElement>
- <text><![CDATA[Jenis Garansi]]></text>
- </staticText>
- <textField isBlankWhenNull="true">
- <reportElement x="142" y="17" width="102" height="5" uuid="adc9b67d-3380-48cc-a4c6-29963f506806">
- <property name="com.jaspersoft.studio.unit.height" value="inch"/>
- </reportElement>
- <textElement>
- <font fontName="DejaVu Sans" size="4" isBold="true" isPdfEmbedded="false"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{warranty_type_name}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="138" y="10" width="4" height="5" uuid="abdf2fbe-5c41-4a18-9650-1253bf45bbb4"/>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="4" isBold="true"/>
- </textElement>
- <text><![CDATA[: ]]></text>
- </staticText>
- <staticText>
- <reportElement x="138" y="17" width="4" height="5" uuid="354dc7ec-30ef-43a0-8d0c-9baf9a2b458d"/>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="4" isBold="true"/>
- </textElement>
- <text><![CDATA[: ]]></text>
- </staticText>
- </band>
- </groupHeader>
- <groupFooter>
- <band/>
- </groupFooter>
- </group>
- <detail>
- <band height="19" splitType="Stretch">
- <textField>
- <reportElement x="45" y="0" width="199" height="13" uuid="0def111b-1e81-4c03-b2b7-1fae0e9b8c23"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="6"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{detail_field}]]></textFieldExpression>
- </textField>
- <image onErrorType="Blank">
- <reportElement x="11" y="0" width="13" height="13" uuid="3179b907-a2b6-46e3-95e9-f8ca63563a8e"/>
- <imageExpression><![CDATA[com.google.zxing.client.j2se.MatrixToImageWriter.toBufferedImage(
- new com.google.zxing.qrcode.QRCodeWriter().encode(
- $F{qr_code},
- com.google.zxing.BarcodeFormat.QR_CODE, 450, 450))]]></imageExpression>
- </image>
- </band>
- </detail>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement