backup ReportBarcodeWarranty

<?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>