home *** CD-ROM | disk | FTP | other *** search
/ 61.19.244.139 / 61.19.244.139.zip / 61.19.244.139 / 2015-02-28 / sale-online-report_subreport1.jrxml next >
Extensible Markup Language  |  2015-02-28  |  18KB  |  381 lines
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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="sale-online-report_subreport1" pageWidth="802" pageHeight="555" orientation="Landscape" columnWidth="802" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="7a3a367c-3cd1-460c-8678-ed616ad70dba">
  3.     <property name="ireport.zoom" value="1.210000000000019"/>
  4.     <property name="ireport.x" value="4"/>
  5.     <property name="ireport.y" value="0"/>
  6.     <parameter name="PARENT_ID" class="java.lang.String"/>
  7.     <field name="address" class="java.lang.String">
  8.         <fieldDescription><![CDATA[address]]></fieldDescription>
  9.     </field>
  10.     <field name="agentId" class="java.lang.String">
  11.         <fieldDescription><![CDATA[agentId]]></fieldDescription>
  12.     </field>
  13.     <field name="agentIdH" class="java.lang.String">
  14.         <fieldDescription><![CDATA[agentIdH]]></fieldDescription>
  15.     </field>
  16.     <field name="agreeDate" class="java.util.Date">
  17.         <fieldDescription><![CDATA[agreeDate]]></fieldDescription>
  18.     </field>
  19.     <field name="amphur" class="java.lang.String">
  20.         <fieldDescription><![CDATA[amphur]]></fieldDescription>
  21.     </field>
  22.     <field name="annualPrem" class="java.math.BigDecimal">
  23.         <fieldDescription><![CDATA[annualPrem]]></fieldDescription>
  24.     </field>
  25.     <field name="beginDate" class="java.util.Date">
  26.         <fieldDescription><![CDATA[beginDate]]></fieldDescription>
  27.     </field>
  28.     <field name="beneficiaryName" class="java.lang.String">
  29.         <fieldDescription><![CDATA[beneficiaryName]]></fieldDescription>
  30.     </field>
  31.     <field name="class" class="java.lang.Class">
  32.         <fieldDescription><![CDATA[class]]></fieldDescription>
  33.     </field>
  34.     <field name="commAmt" class="java.math.BigDecimal">
  35.         <fieldDescription><![CDATA[commAmt]]></fieldDescription>
  36.     </field>
  37.     <field name="commDoiAmt" class="java.math.BigDecimal">
  38.         <fieldDescription><![CDATA[commDoiAmt]]></fieldDescription>
  39.     </field>
  40.     <field name="commDoiRate" class="java.math.BigDecimal">
  41.         <fieldDescription><![CDATA[commDoiRate]]></fieldDescription>
  42.     </field>
  43.     <field name="commHeadAmt" class="java.math.BigDecimal">
  44.         <fieldDescription><![CDATA[commHeadAmt]]></fieldDescription>
  45.     </field>
  46.     <field name="commHeadRate" class="java.math.BigDecimal">
  47.         <fieldDescription><![CDATA[commHeadRate]]></fieldDescription>
  48.     </field>
  49.     <field name="commRate" class="java.math.BigDecimal">
  50.         <fieldDescription><![CDATA[commRate]]></fieldDescription>
  51.     </field>
  52.     <field name="createBy" class="java.lang.String">
  53.         <fieldDescription><![CDATA[createBy]]></fieldDescription>
  54.     </field>
  55.     <field name="createDate" class="java.util.Date">
  56.         <fieldDescription><![CDATA[createDate]]></fieldDescription>
  57.     </field>
  58.     <field name="deductAmt" class="java.math.BigDecimal">
  59.         <fieldDescription><![CDATA[deductAmt]]></fieldDescription>
  60.     </field>
  61.     <field name="driver1DateofBirth" class="java.util.Date">
  62.         <fieldDescription><![CDATA[driver1DateofBirth]]></fieldDescription>
  63.     </field>
  64.     <field name="driver1LicenseNo" class="java.lang.String">
  65.         <fieldDescription><![CDATA[driver1LicenseNo]]></fieldDescription>
  66.     </field>
  67.     <field name="driver1Name" class="java.lang.String">
  68.         <fieldDescription><![CDATA[driver1Name]]></fieldDescription>
  69.     </field>
  70.     <field name="driver1OccuCode" class="java.lang.String">
  71.         <fieldDescription><![CDATA[driver1OccuCode]]></fieldDescription>
  72.     </field>
  73.     <field name="driver1RegId" class="java.lang.String">
  74.         <fieldDescription><![CDATA[driver1RegId]]></fieldDescription>
  75.     </field>
  76.     <field name="driver1Sex" class="java.lang.String">
  77.         <fieldDescription><![CDATA[driver1Sex]]></fieldDescription>
  78.     </field>
  79.     <field name="driver1Title" class="java.lang.String">
  80.         <fieldDescription><![CDATA[driver1Title]]></fieldDescription>
  81.     </field>
  82.     <field name="driver2DateofBirth" class="java.util.Date">
  83.         <fieldDescription><![CDATA[driver2DateofBirth]]></fieldDescription>
  84.     </field>
  85.     <field name="driver2LicenseNo" class="java.lang.String">
  86.         <fieldDescription><![CDATA[driver2LicenseNo]]></fieldDescription>
  87.     </field>
  88.     <field name="driver2Name" class="java.lang.String">
  89.         <fieldDescription><![CDATA[driver2Name]]></fieldDescription>
  90.     </field>
  91.     <field name="driver2OccuCode" class="java.lang.String">
  92.         <fieldDescription><![CDATA[driver2OccuCode]]></fieldDescription>
  93.     </field>
  94.     <field name="driver2RegId" class="java.lang.String">
  95.         <fieldDescription><![CDATA[driver2RegId]]></fieldDescription>
  96.     </field>
  97.     <field name="driver2Sex" class="java.lang.String">
  98.         <fieldDescription><![CDATA[driver2Sex]]></fieldDescription>
  99.     </field>
  100.     <field name="driver2Title" class="java.lang.String">
  101.         <fieldDescription><![CDATA[driver2Title]]></fieldDescription>
  102.     </field>
  103.     <field name="driverNum" class="java.lang.Short">
  104.         <fieldDescription><![CDATA[driverNum]]></fieldDescription>
  105.     </field>
  106.     <field name="endDate" class="java.util.Date">
  107.         <fieldDescription><![CDATA[endDate]]></fieldDescription>
  108.     </field>
  109.     <field name="exportDate" class="java.util.Date">
  110.         <fieldDescription><![CDATA[exportDate]]></fieldDescription>
  111.     </field>
  112.     <field name="exportStatus" class="java.lang.String">
  113.         <fieldDescription><![CDATA[exportStatus]]></fieldDescription>
  114.     </field>
  115.     <field name="extraPrem" class="java.math.BigDecimal">
  116.         <fieldDescription><![CDATA[extraPrem]]></fieldDescription>
  117.     </field>
  118.     <field name="feeAmt" class="java.math.BigDecimal">
  119.         <fieldDescription><![CDATA[feeAmt]]></fieldDescription>
  120.     </field>
  121.     <field name="insureName" class="java.lang.String">
  122.         <fieldDescription><![CDATA[insureName]]></fieldDescription>
  123.     </field>
  124.     <field name="insureTitle" class="java.lang.String">
  125.         <fieldDescription><![CDATA[insureTitle]]></fieldDescription>
  126.     </field>
  127.     <field name="insureType" class="java.lang.String">
  128.         <fieldDescription><![CDATA[insureType]]></fieldDescription>
  129.     </field>
  130.     <field name="invoiceNo" class="java.lang.String">
  131.         <fieldDescription><![CDATA[invoiceNo]]></fieldDescription>
  132.     </field>
  133.     <field name="issueDate" class="java.util.Date">
  134.         <fieldDescription><![CDATA[issueDate]]></fieldDescription>
  135.     </field>
  136.     <field name="licenseCode" class="java.lang.String">
  137.         <fieldDescription><![CDATA[licenseCode]]></fieldDescription>
  138.     </field>
  139.     <field name="loadDoc" class="java.lang.String">
  140.         <fieldDescription><![CDATA[loadDoc]]></fieldDescription>
  141.     </field>
  142.     <field name="netPremium" class="java.math.BigDecimal">
  143.         <fieldDescription><![CDATA[netPremium]]></fieldDescription>
  144.     </field>
  145.     <field name="occuCode" class="java.lang.String">
  146.         <fieldDescription><![CDATA[occuCode]]></fieldDescription>
  147.     </field>
  148.     <field name="packageCode" class="java.lang.String">
  149.         <fieldDescription><![CDATA[packageCode]]></fieldDescription>
  150.     </field>
  151.     <field name="payDueDate" class="java.util.Date">
  152.         <fieldDescription><![CDATA[payDueDate]]></fieldDescription>
  153.     </field>
  154.     <field name="polType" class="java.lang.String">
  155.         <fieldDescription><![CDATA[polType]]></fieldDescription>
  156.     </field>
  157.     <field name="policyNo" class="java.lang.String">
  158.         <fieldDescription><![CDATA[policyNo]]></fieldDescription>
  159.     </field>
  160.     <field name="premCal" class="java.lang.String">
  161.         <fieldDescription><![CDATA[premCal]]></fieldDescription>
  162.     </field>
  163.     <field name="printDate" class="java.util.Date">
  164.         <fieldDescription><![CDATA[printDate]]></fieldDescription>
  165.     </field>
  166.     <field name="printStatus" class="java.lang.String">
  167.         <fieldDescription><![CDATA[printStatus]]></fieldDescription>
  168.     </field>
  169.     <field name="province" class="java.lang.String">
  170.         <fieldDescription><![CDATA[province]]></fieldDescription>
  171.     </field>
  172.     <field name="receiptAddress1" class="java.lang.String">
  173.         <fieldDescription><![CDATA[receiptAddress1]]></fieldDescription>
  174.     </field>
  175.     <field name="receiptAddress2" class="java.lang.String">
  176.         <fieldDescription><![CDATA[receiptAddress2]]></fieldDescription>
  177.     </field>
  178.     <field name="receiptDate" class="java.util.Date">
  179.         <fieldDescription><![CDATA[receiptDate]]></fieldDescription>
  180.     </field>
  181.     <field name="receiptName" class="java.lang.String">
  182.         <fieldDescription><![CDATA[receiptName]]></fieldDescription>
  183.     </field>
  184.     <field name="receiptNo" class="java.lang.String">
  185.         <fieldDescription><![CDATA[receiptNo]]></fieldDescription>
  186.     </field>
  187.     <field name="regId" class="java.lang.String">
  188.         <fieldDescription><![CDATA[regId]]></fieldDescription>
  189.     </field>
  190.     <field name="status" class="java.lang.String">
  191.         <fieldDescription><![CDATA[status]]></fieldDescription>
  192.     </field>
  193.     <field name="statusDate" class="java.util.Date">
  194.         <fieldDescription><![CDATA[statusDate]]></fieldDescription>
  195.     </field>
  196.     <field name="subAgent" class="java.lang.String">
  197.         <fieldDescription><![CDATA[subAgent]]></fieldDescription>
  198.     </field>
  199.     <field name="subjectPrem" class="java.math.BigDecimal">
  200.         <fieldDescription><![CDATA[subjectPrem]]></fieldDescription>
  201.     </field>
  202.     <field name="tambol" class="java.lang.String">
  203.         <fieldDescription><![CDATA[tambol]]></fieldDescription>
  204.     </field>
  205.     <field name="totalPremium" class="java.math.BigDecimal">
  206.         <fieldDescription><![CDATA[totalPremium]]></fieldDescription>
  207.     </field>
  208.     <field name="updateBy" class="java.lang.String">
  209.         <fieldDescription><![CDATA[updateBy]]></fieldDescription>
  210.     </field>
  211.     <field name="updateDate" class="java.util.Date">
  212.         <fieldDescription><![CDATA[updateDate]]></fieldDescription>
  213.     </field>
  214.     <field name="vatAmt" class="java.math.BigDecimal">
  215.         <fieldDescription><![CDATA[vatAmt]]></fieldDescription>
  216.     </field>
  217.     <field name="vehAge" class="java.lang.Short">
  218.         <fieldDescription><![CDATA[vehAge]]></fieldDescription>
  219.     </field>
  220.     <field name="vehBrand" class="java.lang.String">
  221.         <fieldDescription><![CDATA[vehBrand]]></fieldDescription>
  222.     </field>
  223.     <field name="vehBrandmodel" class="java.lang.String">
  224.         <fieldDescription><![CDATA[vehBrandmodel]]></fieldDescription>
  225.     </field>
  226.     <field name="vehCc" class="java.lang.Short">
  227.         <fieldDescription><![CDATA[vehCc]]></fieldDescription>
  228.     </field>
  229.     <field name="vehChassis" class="java.lang.String">
  230.         <fieldDescription><![CDATA[vehChassis]]></fieldDescription>
  231.     </field>
  232.     <field name="vehChassisModel" class="java.lang.String">
  233.         <fieldDescription><![CDATA[vehChassisModel]]></fieldDescription>
  234.     </field>
  235.     <field name="vehCode" class="java.lang.String">
  236.         <fieldDescription><![CDATA[vehCode]]></fieldDescription>
  237.     </field>
  238.     <field name="vehColor" class="java.lang.String">
  239.         <fieldDescription><![CDATA[vehColor]]></fieldDescription>
  240.     </field>
  241.     <field name="vehGrp" class="java.lang.String">
  242.         <fieldDescription><![CDATA[vehGrp]]></fieldDescription>
  243.     </field>
  244.     <field name="vehLicense" class="java.lang.String">
  245.         <fieldDescription><![CDATA[vehLicense]]></fieldDescription>
  246.     </field>
  247.     <field name="vehLicenseProv" class="java.lang.String">
  248.         <fieldDescription><![CDATA[vehLicenseProv]]></fieldDescription>
  249.     </field>
  250.     <field name="vehMachine" class="java.lang.String">
  251.         <fieldDescription><![CDATA[vehMachine]]></fieldDescription>
  252.     </field>
  253.     <field name="vehOption" class="java.lang.String">
  254.         <fieldDescription><![CDATA[vehOption]]></fieldDescription>
  255.     </field>
  256.     <field name="vehSeat" class="java.lang.Short">
  257.         <fieldDescription><![CDATA[vehSeat]]></fieldDescription>
  258.     </field>
  259.     <field name="vehSize" class="java.lang.Character">
  260.         <fieldDescription><![CDATA[vehSize]]></fieldDescription>
  261.     </field>
  262.     <field name="vehWeigth" class="java.lang.Integer">
  263.         <fieldDescription><![CDATA[vehWeigth]]></fieldDescription>
  264.     </field>
  265.     <field name="vehYrprod" class="java.lang.String">
  266.         <fieldDescription><![CDATA[vehYrprod]]></fieldDescription>
  267.     </field>
  268.     <field name="vehYrreg" class="java.lang.String">
  269.         <fieldDescription><![CDATA[vehYrreg]]></fieldDescription>
  270.     </field>
  271.     <field name="zipcode" class="java.lang.String">
  272.         <fieldDescription><![CDATA[zipcode]]></fieldDescription>
  273.     </field>
  274.     <background>
  275.         <band splitType="Stretch"/>
  276.     </background>
  277.     <detail>
  278.         <band height="42" splitType="Stretch">
  279.             <printWhenExpression><![CDATA[($P{PARENT_ID}).equals($F{agentId})]]></printWhenExpression>
  280.             <textField>
  281.                 <reportElement x="471" y="0" width="65" height="20" uuid="f4c1f6d5-02aa-4a0f-85ae-ac1129a7a1b4"/>
  282.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  283.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  284.                 </textElement>
  285.                 <textFieldExpression><![CDATA[$F{vehLicense}]]></textFieldExpression>
  286.             </textField>
  287.             <textField>
  288.                 <reportElement x="5" y="0" width="79" height="20" uuid="2d232cb8-f61e-4f07-b093-553d506a620e"/>
  289.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  290.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  291.                 </textElement>
  292.                 <textFieldExpression><![CDATA[$F{policyNo}]]></textFieldExpression>
  293.             </textField>
  294.             <textField pattern="dd/MM/yyyy">
  295.                 <reportElement x="206" y="0" width="52" height="20" uuid="bbe16fee-a1ee-47da-a314-9ec0ab38c785"/>
  296.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  297.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  298.                 </textElement>
  299.                 <textFieldExpression><![CDATA[$F{endDate}]]></textFieldExpression>
  300.             </textField>
  301.             <textField>
  302.                 <reportElement x="86" y="0" width="70" height="20" uuid="eca132e7-7f3a-42bc-86b8-a166af4a8ad6"/>
  303.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  304.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  305.                 </textElement>
  306.                 <textFieldExpression><![CDATA[$F{packageCode}]]></textFieldExpression>
  307.             </textField>
  308.             <textField pattern="dd/MM/yyyy">
  309.                 <reportElement x="160" y="0" width="44" height="20" uuid="d672ba0b-fedc-4b22-8b7a-c27471f36a9f"/>
  310.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  311.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  312.                 </textElement>
  313.                 <textFieldExpression><![CDATA[$F{beginDate}]]></textFieldExpression>
  314.             </textField>
  315.             <textField>
  316.                 <reportElement x="261" y="0" width="80" height="20" uuid="70836853-2454-41da-8f7c-bb687f3ec4c4"/>
  317.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  318.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  319.                 </textElement>
  320.                 <textFieldExpression><![CDATA[$F{insureTitle}+$F{insureName}]]></textFieldExpression>
  321.             </textField>
  322.             <textField>
  323.                 <reportElement x="407" y="0" width="63" height="20" uuid="49215f95-5f42-4b83-94da-243226a6de27"/>
  324.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  325.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  326.                 </textElement>
  327.                 <textFieldExpression><![CDATA[$F{vehBrand}]]></textFieldExpression>
  328.             </textField>
  329.             <textField>
  330.                 <reportElement x="407" y="20" width="63" height="20" uuid="862c4df4-e8ba-4f69-acc7-3a4e1512f136"/>
  331.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  332.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  333.                 </textElement>
  334.                 <textFieldExpression><![CDATA[$F{vehBrandmodel}]]></textFieldExpression>
  335.             </textField>
  336.             <textField>
  337.                 <reportElement x="471" y="20" width="65" height="20" uuid="991c7e22-81ef-460a-96a6-c0d6e5c79707"/>
  338.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  339.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  340.                 </textElement>
  341.                 <textFieldExpression><![CDATA[$F{vehLicenseProv}]]></textFieldExpression>
  342.             </textField>
  343.             <textField>
  344.                 <reportElement x="537" y="0" width="72" height="20" uuid="d14c7ef8-7401-401a-8d56-0cdd25328413"/>
  345.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  346.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  347.                 </textElement>
  348.                 <textFieldExpression><![CDATA[$F{vehChassisModel}]]></textFieldExpression>
  349.             </textField>
  350.             <textField>
  351.                 <reportElement x="342" y="0" width="64" height="20" uuid="88988666-01e0-4902-8170-0819e21c3696"/>
  352.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  353.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  354.                 </textElement>
  355.                 <textFieldExpression><![CDATA[$F{vehCode}]]></textFieldExpression>
  356.             </textField>
  357.             <textField pattern="#,##0.00;-#,##0.00">
  358.                 <reportElement x="658" y="0" width="61" height="20" uuid="d3908c77-9a2b-4e13-8f87-e6ac83633d86"/>
  359.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  360.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  361.                 </textElement>
  362.                 <textFieldExpression><![CDATA[$F{totalPremium}]]></textFieldExpression>
  363.             </textField>
  364.             <textField pattern="#,##0.00;-#,##0.00">
  365.                 <reportElement x="610" y="0" width="46" height="20" uuid="03ea7a97-3b98-4fb1-bb76-eae1b3b4829f"/>
  366.                 <textElement textAlignment="Center" verticalAlignment="Middle">
  367.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  368.                 </textElement>
  369.                 <textFieldExpression><![CDATA[$F{netPremium}]]></textFieldExpression>
  370.             </textField>
  371.             <textField>
  372.                 <reportElement x="721" y="0" width="79" height="40" uuid="231c8da6-8689-484b-8c7b-7e63f2e26db5"/>
  373.                 <textElement textAlignment="Center" verticalAlignment="Top">
  374.                     <font fontName="AngsanaDSE" size="14" pdfFontName="ANGSA.ttf" pdfEncoding="Identity-H"/>
  375.                 </textElement>
  376.                 <textFieldExpression><![CDATA[$F{subAgent}==null ?"-":$F{subAgent}]]></textFieldExpression>
  377.             </textField>
  378.         </band>
  379.     </detail>
  380. </jasperReport>
  381.