?? contrat.jrxml
字號:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="contrat"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<parameter name="header" isForPrompting="true" class="java.lang.String"/>
<parameter name="footer" isForPrompting="true" class="java.lang.String"/>
<parameter name="sql" isForPrompting="false" class="java.lang.String"/>
<parameter name="libelle" isForPrompting="true" class="java.lang.String"/>
<queryString><![CDATA[$P!{sql}]]></queryString>
<field name="CONTRACT_NUMBER" class="java.lang.String"/>
<field name="BANK_CODE" class="java.lang.String"/>
<field name="BANK_NAME" class="java.lang.String"/>
<field name="BRANCH_CODE" class="java.lang.String"/>
<field name="RACINE_AGENT_DE_VENTE" class="java.lang.String"/>
<field name="SOUSCRIPTION_DATE" class="java.sql.Timestamp"/>
<field name="LAST_MODIF_DATE" class="java.sql.Timestamp"/>
<field name="BMCE_CLIENT" class="java.lang.String"/>
<field name="OPERATION_TYPE" class="java.lang.String"/>
<field name="CANAL_TYPE" class="java.lang.String"/>
<field name="ACCOUNT_NUMBER" class="java.lang.String"/>
<field name="ACQUIRER_BRANCH_CODE" class="java.lang.String"/>
<field name="CARD_NUMBER" class="java.lang.String"/>
<field name="CARD_TYPE" class="java.lang.String"/>
<field name="START_VAL_DATE" class="java.sql.Timestamp"/>
<field name="END_VAL_DATE" class="java.sql.Timestamp"/>
<field name="FAMILY_FIRST_NAME" class="java.lang.String"/>
<field name="NICKNAME" class="java.lang.String"/>
<field name="DOCUMENT_CODE" class="java.lang.String"/>
<field name="BIRTH_DATE" class="java.sql.Timestamp"/>
<field name="ACTIVITY_DESCRIPTION" class="java.lang.String"/>
<field name="ADDRESS" class="java.lang.String"/>
<field name="PHONE" class="java.lang.String"/>
<field name="EMAIL" class="java.lang.String"/>
<field name="PRODUCT_NAME" class="java.lang.String"/>
<field name="PRODUCT_CODE" class="java.lang.String"/>
<field name="FEES_CODE" class="java.lang.String"/>
<field name="FEES_WORDING" class="java.lang.String"/>
<field name="SERVICE_WORDING" class="java.lang.String"/>
<field name="BENEF_CARD_NUMBER_1" class="java.lang.String"/>
<field name="BENEF_EXPIRY_DATE_1" class="java.sql.Timestamp"/>
<field name="BENEF_FAMILY_FIRST_N_1" class="java.lang.String"/>
<field name="BENEFIT_NICKNAME_1" class="java.lang.String"/>
<field name="BENEFIT_PHONE_NBR_1" class="java.lang.String"/>
<field name="BENEF_CARD_NUMBER_2" class="java.lang.String"/>
<field name="BENEF_EXPIRY_DATE_2" class="java.sql.Timestamp"/>
<field name="BENEF_FAMILY_FIRST_N_2" class="java.lang.String"/>
<field name="BENEFIT_NICKNAME_2" class="java.lang.String"/>
<field name="BENEFIT_PHONE_NBR_2" class="java.lang.String"/>
<field name="BENEF_CARD_NUMBER_3" class="java.lang.String"/>
<field name="BENEF_EXPIRY_DATE_3" class="java.sql.Timestamp"/>
<field name="BENEF_FAMILY_FIRST_N_3" class="java.lang.String"/>
<field name="BENEFIT_NICKNAME_3" class="java.lang.String"/>
<field name="BENEFIT_PHONE_NBR_3" class="java.lang.String"/>
<field name="BENEF_CARD_NUMBER_4" class="java.lang.String"/>
<field name="BENEF_EXPIRY_DATE_4" class="java.sql.Timestamp"/>
<field name="BENEF_FAMILY_FIRST_N_4" class="java.lang.String"/>
<field name="BENEFIT_NICKNAME_4" class="java.lang.String"/>
<field name="BENEFIT_PHONE_NBR_4" class="java.lang.String"/>
<field name="BENEF_CARD_NUMBER_5" class="java.lang.String"/>
<field name="BENEF_EXPIRY_DATE_5" class="java.sql.Timestamp"/>
<field name="BENEF_FAMILY_FIRST_N_5" class="java.lang.String"/>
<field name="BENEFIT_NICKNAME_5" class="java.lang.String"/>
<field name="BENEFIT_PHONE_NBR_5" class="java.lang.String"/>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="50" isSplitAllowed="true" >
<image evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="0" y="-13" width="535" height="49" key="image-1"/>
<box></box>
<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA[$P{header}]]></imageExpression>
</image>
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="676" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="85" y="55" width="102" height="17" forecolor="#000000" backcolor="#FFFFFF" key="textField">
<printWhenExpression><![CDATA[new Boolean(!($F{CONTRACT_NUMBER}.equals( null )))]]></printWhenExpression>
</reportElement>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CONTRACT_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="5" y="55" width="80" height="17" forecolor="#000000" backcolor="#FFFFFF" key="staticText" positionType="Float"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<text><![CDATA[N擄 de contrat:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="56" y="10" width="131" height="17" forecolor="#000000" backcolor="#FFFFFF" key="textField">
<printWhenExpression><![CDATA[new Boolean(!($F{BANK_CODE}.equals( null )))]]></printWhenExpression>
</reportElement>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{BANK_CODE}+" "+$F{BANK_NAME}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="5" y="10" width="51" height="17" forecolor="#000000" backcolor="#FFFFFF" key="staticText" positionType="Float"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<text><![CDATA[Banque:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="447" y="10" width="85" height="17" forecolor="#000000" backcolor="#FFFFFF" key="textField">
<printWhenExpression><![CDATA[new Boolean(!($F{BRANCH_CODE}.equals( null )))]]></printWhenExpression>
</reportElement>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{BRANCH_CODE}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="198" y="10" width="51" height="17" forecolor="#000000" backcolor="#FFFFFF" key="staticText" positionType="Float"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<text><![CDATA[Agence:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="318" y="56" width="150" height="17" forecolor="#000000" backcolor="#FFFFFF" key="textField">
<printWhenExpression><![CDATA[new Boolean(!($F{SOUSCRIPTION_DATE}.equals( null )))]]></printWhenExpression>
</reportElement>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{SOUSCRIPTION_DATE}.toString().substring(8,10)+"/"+$F{SOUSCRIPTION_DATE}.toString().substring(5,7)+"/"+$F{SOUSCRIPTION_DATE}.toString().substring(0,4)]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="198" y="56" width="120" height="17" forecolor="#000000" backcolor="#FFFFFF" key="staticText" positionType="Float"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<text><![CDATA[Date de souscription:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="359" y="77" width="130" height="17" forecolor="#000000" backcolor="#FFFFFF" key="textField">
<printWhenExpression><![CDATA[new Boolean(!($F{LAST_MODIF_DATE}.equals( null )))]]></printWhenExpression>
</reportElement>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement>
<font fontName="Times New Roman" size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{LAST_MODIF_DATE}.toString().substring(8,10)+"/"+$F{LAST_MODIF_DATE}.toString().substring(5,7)+"/"+$F{LAST_MODIF_DATE}.toString().substring(0,4)]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="198" y="77" width="161" height="17" forecolor="#000000" backcolor="#FFFFFF" key="staticText" positionType="Float"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -