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="reportAdjStockForOutlet" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6c4eaca3-bbef-458e-93fc-58464b84bff9">
- <property name="ireport.zoom" value="1.3310000000000246"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="102"/>
- <parameter name="ou_name" class="java.lang.String"/>
- <parameter name="warehouse_name" class="java.lang.String"/>
- <parameter name="doc_no" class="java.lang.String"/>
- <parameter name="doc_date" class="java.lang.String"/>
- <parameter name="activity_gl" class="java.lang.String"/>
- <parameter name="ou_rc" class="java.lang.String"/>
- <parameter name="remark" class="java.lang.String"/>
- <parameter name="approved_by" class="java.lang.String"/>
- <parameter name="created_by" class="java.lang.String"/>
- <parameter name="curr_code" class="java.lang.String"/>
- <parameter name="total_amount" class="java.math.BigDecimal"/>
- <queryString>
- <![CDATA[SELECT
- f_get_product_code(product_id) product_code, f_get_product_name(product_id) product_name,
- serial_number, qty, amount, 'IDR' curr_code
- FROM tt_report_adj_stock
- ORDER BY product_name ASC;]]>
- </queryString>
- <field name="product_code" class="java.lang.String"/>
- <field name="product_name" class="java.lang.String"/>
- <field name="serial_number" class="java.lang.String"/>
- <field name="qty" class="java.math.BigDecimal"/>
- <field name="amount" class="java.math.BigDecimal"/>
- <field name="curr_code" class="java.lang.String"/>
- <variable name="number" class="java.lang.Long" calculation="Sum">
- <variableExpression><![CDATA[1]]></variableExpression>
- <initialValueExpression><![CDATA[1]]></initialValueExpression>
- </variable>
- <background>
- <band splitType="Stretch"/>
- </background>
- <title>
- <band height="228" splitType="Stretch">
- <textField evaluationTime="Report">
- <reportElement x="531" y="60" width="16" height="20" uuid="74e638a7-9812-40c7-ae44-1ea262f19ff0"/>
- <box leftPadding="1"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="472" y="60" width="56" height="20" uuid="e039adac-cfb1-489a-8704-d29182a6620e"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of "]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="126" y="6" width="329" height="20" uuid="3e77d616-eb5b-4196-8b38-d3d2d1040d81"/>
- <textElement textAlignment="Center">
- <font size="13" isBold="false"/>
- </textElement>
- <text><![CDATA[ADJUSTMENT STOCK OUTLET]]></text>
- </staticText>
- <textField>
- <reportElement x="126" y="34" width="329" height="20" uuid="7c8a76c1-0aec-4cfe-a27b-47abd7bcc7c3"/>
- <textElement textAlignment="Center">
- <font size="13"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{ou_name}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="126" y="60" width="329" height="20" uuid="603fcb50-c1d7-488c-92ee-17bdc86a19ba"/>
- <textElement textAlignment="Center">
- <font size="13"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{warehouse_name}]]></textFieldExpression>
- </textField>
- <line>
- <reportElement x="0" y="80" width="555" height="1" uuid="69e72eda-f487-4cf8-adbd-369ce92db3d9"/>
- </line>
- <staticText>
- <reportElement x="0" y="84" width="126" height="15" uuid="0b50d19d-8892-4f1c-9d28-6c01bcafac21"/>
- <text><![CDATA[Adjustment No]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="101" width="126" height="15" uuid="eb24b71f-4422-4864-9617-5f03e63b76fc"/>
- <text><![CDATA[Adjustment Date]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="118" width="126" height="15" uuid="f8b4f4fd-4b00-4279-a670-4bc36fe90b49"/>
- <text><![CDATA[Activity GL]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="135" width="126" height="15" uuid="f4e95e49-7d19-4442-8112-6b4987cca200"/>
- <text><![CDATA[OU RC]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="152" width="126" height="15" uuid="34316264-8913-42b7-bae8-928e6e48a5d7"/>
- <text><![CDATA[Remark]]></text>
- </staticText>
- <staticText>
- <reportElement x="126" y="84" width="10" height="15" uuid="3ac7d7d6-7ff0-4e47-a9de-b9ae617b25f2"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="126" y="101" width="10" height="15" uuid="e691a5e8-eabe-4aff-a338-09a4437958ad"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="126" y="118" width="10" height="15" uuid="8d1162f7-8f13-4ed7-8d69-ed7c2f86860d"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="126" y="135" width="10" height="15" uuid="9ed02ac3-472b-41b5-b0a9-6d12f16ba020"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="126" y="152" width="10" height="15" uuid="58d6ec71-375a-4ca4-aba6-48308cc93e42"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField>
- <reportElement x="136" y="84" width="319" height="15" uuid="b782e9c8-a135-42c2-8f98-ccb3cdbcaf7c"/>
- <textFieldExpression><![CDATA[$P{doc_no}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="136" y="101" width="319" height="15" uuid="6e2a6ea4-d50b-437b-b599-cc8817333451"/>
- <textFieldExpression><![CDATA[new java.text.SimpleDateFormat("dd-MMMM-yyyy").format(new java.text.SimpleDateFormat("yyyyMMdd").parse($P{doc_date}))]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="136" y="118" width="319" height="15" uuid="c1cbf668-2c62-4ba5-b940-dc5ca3e72652"/>
- <textFieldExpression><![CDATA[$P{activity_gl}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="136" y="135" width="319" height="15" uuid="384f5668-be4a-48fa-98f0-e2e1b8061cae"/>
- <textFieldExpression><![CDATA[$P{ou_rc}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="136" y="152" width="319" height="70" uuid="d21bc8a3-94a5-49d7-b199-3bc85c1208d9"/>
- <textFieldExpression><![CDATA[$P{remark}]]></textFieldExpression>
- </textField>
- </band>
- </title>
- <pageHeader>
- <band height="20" splitType="Stretch">
- <staticText>
- <reportElement x="0" y="0" width="30" height="20" uuid="3db586fc-8499-4148-91a3-9872420e567c"/>
- <box>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="0.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8" isBold="true"/>
- </textElement>
- <text><![CDATA[No.]]></text>
- </staticText>
- <staticText>
- <reportElement x="30" y="0" width="106" height="20" uuid="3d291af0-7dfb-4bd6-b580-a9671a3ca79f"/>
- <box>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="0.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8" isBold="true"/>
- </textElement>
- <text><![CDATA[Product Code]]></text>
- </staticText>
- <staticText>
- <reportElement x="136" y="0" width="140" height="20" uuid="21faae05-6ed6-449e-8f31-441bb970cb99"/>
- <box>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="0.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8" isBold="true"/>
- </textElement>
- <text><![CDATA[Product Name]]></text>
- </staticText>
- <staticText>
- <reportElement x="276" y="0" width="110" height="20" uuid="3e408949-2d22-42a7-9176-6926d3e5c368"/>
- <box>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="0.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8" isBold="true"/>
- </textElement>
- <text><![CDATA[Serial Number]]></text>
- </staticText>
- <staticText>
- <reportElement x="386" y="0" width="80" height="20" uuid="2e939a82-dce4-4d80-8e01-2399870085af"/>
- <box>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="0.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8" isBold="true"/>
- </textElement>
- <text><![CDATA[Adj Qty]]></text>
- </staticText>
- <staticText>
- <reportElement x="466" y="0" width="89" height="20" uuid="845567ef-658e-4dfe-afcd-aaabb21dc300"/>
- <box>
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="0.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8" isBold="true"/>
- </textElement>
- <text><![CDATA[Adj Amount]]></text>
- </staticText>
- </band>
- </pageHeader>
- <detail>
- <band height="20" splitType="Stretch">
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="30" y="0" width="106" height="20" uuid="b7716895-1c1f-4d5a-b112-fbd4f96651bf"/>
- <box topPadding="1" leftPadding="4" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement>
- <font fontName="DejaVu Sans" size="9" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{product_code}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="136" y="0" width="140" height="20" uuid="3bbe5ce4-57d0-4d65-802d-01353c893c50"/>
- <box topPadding="1" leftPadding="4" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement>
- <font fontName="DejaVu Sans" size="9" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{product_name}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="276" y="0" width="110" height="20" uuid="7d85004c-2121-4e7b-911e-6fcb0947cae9"/>
- <box topPadding="1" leftPadding="4" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement>
- <font fontName="DejaVu Sans" size="9" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{serial_number}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="386" y="0" width="80" height="20" uuid="0fddd95d-2687-4c89-a4fb-83707a07c098"/>
- <box topPadding="1" leftPadding="4" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="9" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="466" y="0" width="89" height="20" uuid="acf80f51-fbef-47b9-98f8-9ed6efb89174"/>
- <box topPadding="1" leftPadding="4" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="9" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{curr_code}.equals("IDR")
- ?new java.text.DecimalFormat("#,##0",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($F{amount})
- :new java.text.DecimalFormat("#,##0.00",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($F{amount})]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="30" height="20" uuid="03a3c5a5-10e4-45b1-9f71-a0620784f445"/>
- <box topPadding="1" leftPadding="4" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <leftPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- <rightPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="9" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{number}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <pageFooter>
- <band height="42" splitType="Stretch"/>
- </pageFooter>
- <summary>
- <band height="98" splitType="Stretch">
- <staticText>
- <reportElement x="386" y="0" width="80" height="23" uuid="b79aa8c3-5eb7-49f6-bbea-d41a2d0ef196"/>
- <textElement>
- <font isBold="true"/>
- </textElement>
- <text><![CDATA[Total Amount]]></text>
- </staticText>
- <textField>
- <reportElement x="466" y="0" width="20" height="23" uuid="11099190-a3ec-4ebb-ba8f-20a266356a82"/>
- <textFieldExpression><![CDATA[$P{curr_code}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="486" y="0" width="68" height="23" uuid="e796d389-d944-4fc0-9c52-b89cf431432b"/>
- <textElement textAlignment="Right">
- <font isBold="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{curr_code}.equals("IDR")
- ?new java.text.DecimalFormat("#,##0",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($P{total_amount})
- :new java.text.DecimalFormat("#,##0.00",new java.text.DecimalFormatSymbols(java.util.Locale.UK)).format($P{total_amount})]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="386" y="28" width="168" height="15" uuid="e5f579da-dc79-4d9e-b8d2-fce7aa9095ea"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[Created By:]]></text>
- </staticText>
- <staticText>
- <reportElement x="0" y="28" width="126" height="15" uuid="85a14eb5-d582-4ed3-8ef9-8c3ee82ac3c8"/>
- <textElement textAlignment="Center"/>
- <text><![CDATA[Approved By:]]></text>
- </staticText>
- <textField>
- <reportElement x="386" y="77" width="168" height="20" uuid="dab243e5-caea-4d51-ab18-6e3e65ecb555"/>
- <textElement textAlignment="Center"/>
- <textFieldExpression><![CDATA[$P{created_by}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="0" y="77" width="126" height="20" uuid="c3cb897a-ee76-4446-bfbf-ede6ceaf7b27"/>
- <textElement textAlignment="Center"/>
- <textFieldExpression><![CDATA[$P{approved_by}]]></textFieldExpression>
- </textField>
- </band>
- </summary>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement