<?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="TRRE036" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="730" columnSpacing="0" leftMargin="56" rightMargin="56" topMargin="28" bottomMargin="28" 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.*" /> <import value="com.csc.library.utilities.*" /> <field name="memployee__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__employeeid]]></fieldDescription> </field> <field name="ttraintrnee__trainingid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__trainingid]]></fieldDescription> </field> <field name="ttraintrnee__traineeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__traineeid]]></fieldDescription> </field> <field name="ttraintrnee__status" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__status]]></fieldDescription> </field> <field name="ttraintrnee__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__companyid]]></fieldDescription> </field> <field name="ttraintrnee__emp_position" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__emp_position]]></fieldDescription> </field> <field name="ttraintrnee__job" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__job]]></fieldDescription> </field> <field name="ttraintrnee__emp_group" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__emp_group]]></fieldDescription> </field> <field name="ttraintrnee__branch" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__branch]]></fieldDescription> </field> <field name="ttraintrnee__workarea" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__workarea]]></fieldDescription> </field> <field name="ttraintrnee__salatype" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__salatype]]></fieldDescription> </field> <field name="ttraintrnee__bossid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__bossid]]></fieldDescription> </field> <field name="ttraintrnee__bu1" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__bu1]]></fieldDescription> </field> <field name="ttraintrnee__bu2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__bu2]]></fieldDescription> </field> <field name="ttraintrnee__bu3" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__bu3]]></fieldDescription> </field> <field name="ttraintrnee__bu4" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__bu4]]></fieldDescription> </field> <field name="ttraintrnee__bu5" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__bu5]]></fieldDescription> </field> <field name="ttraintrnee__pl" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__pl]]></fieldDescription> </field> <field name="ttraintrnee__costcenter" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraintrnee__costcenter]]></fieldDescription> </field> <field name="ttraining__trainingid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__trainingid]]></fieldDescription> </field> <field name="ttraining__trtitle" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__trtitle]]></fieldDescription> </field> <field name="ttraining__status" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__status]]></fieldDescription> </field> <field name="ttraining__crsid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__crsid]]></fieldDescription> </field> <field name="ttraining__resdatefrm" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__resdatefrm]]></fieldDescription> </field> <field name="ttraining__resdateto" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__resdateto]]></fieldDescription> </field> <field name="ttraining__classdatefrm" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__classdatefrm]]></fieldDescription> </field> <field name="ttraining__classdateto" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__classdateto]]></fieldDescription> </field> <field name="ttraining__locid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__locid]]></fieldDescription> </field> <field name="ttraining__roomid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__roomid]]></fieldDescription> </field> <field name="ttraining__train_type" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__train_type]]></fieldDescription> </field> <field name="ttraining__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__companyid]]></fieldDescription> </field> <field name="ttraining__memo" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__memo]]></fieldDescription> </field> <field name="ttraining__timestart" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__timestart]]></fieldDescription> </field> <field name="ttraining__timestop" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__timestop]]></fieldDescription> </field> <field name="ttraining__qtyvalid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__qtyvalid]]></fieldDescription> </field> <field name="ttraining__duration" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by ttraining__duration]]></fieldDescription> </field> <field name="mcourse__crsid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsid]]></fieldDescription> </field> <field name="mcourse__crsdesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsdesc]]></fieldDescription> </field> <field name="mcourse__crsedesc" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__crsedesc]]></fieldDescription> </field> <field name="mcourse__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__companyid]]></fieldDescription> </field> <field name="mcourse__comment_gen" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__comment_gen]]></fieldDescription> </field> <field name="mcourse__property" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcourse__property]]></fieldDescription> </field> <field name="mcompany__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcompany__companyid]]></fieldDescription> </field> <field name="mcompany__logo" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by mcompany__logo]]></fieldDescription> </field> <field name="memployee__companyid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__companyid]]></fieldDescription> </field> <field name="memployee__emp_prefix" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__emp_prefix]]></fieldDescription> </field> <field name="memployee__fname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__fname]]></fieldDescription> </field> <field name="memployee__lname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__lname]]></fieldDescription> </field> <field name="memployee__efname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__efname]]></fieldDescription> </field> <field name="memployee__elname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__elname]]></fieldDescription> </field> <field name="memployee__status" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__status]]></fieldDescription> </field> <field name="memployee__fullname" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by memployee__fullname]]></fieldDescription> </field> <background> <band height="539" isSplitAllowed="true" > <image scaleImage="FillFrame" vAlign="Middle" hAlign="Center" onErrorType="Blank" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="730" height="539" key="image-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <graphicElement stretchType="NoStretch"/> <imageExpression class="java.lang.String"><![CDATA[new com.csc.library.session.InitialEnvironment("GLOBAL").getValue("TRAINING_UPLOAD-dir")+"CERTIFICATE_JET/Certificate-Master-background.jpg"]]></imageExpression> </image> </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="539" isSplitAllowed="true" > <image scaleImage="RetainShape" vAlign="Middle" hAlign="Center" onErrorType="Blank" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="287" y="402" width="157" height="108" key="image-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <graphicElement stretchType="NoStretch"/> <imageExpression class="java.lang.String"><![CDATA[new com.csc.library.session.InitialEnvironment("GLOBAL").getValue("TRAINING_UPLOAD-dir")+"CERTIFICATE_JET/Certificate-Completion-Logo.jpg"]]></imageExpression> </image> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="213" width="730" height="29" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="26" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{memployee__fullname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="283" width="730" height="29" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="26" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{mcourse__crsedesc}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="339" width="730" height="27" key="textField-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="20" isBold="false" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Course Duration: " + $F{ttraining__duration} + " Day"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="365" width="730" height="27" key="textField-4"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="20" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new CscCalendar().getDDthEngYYYY()]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="130" width="730" height="45" key="textField-5"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIAB.TTF" size="42" isBold="true" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Certificate of Achievement"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="254" width="730" height="29" key="textField-6"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="20" isBold="false" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["HAS SUCCESSFULLY COMPLETED"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="312" width="730" height="27" key="textField-7"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="20" isBold="false" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Conducted by the Jet Asia Academy"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="71" y="461" width="213" height="48" key="textField-8"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["COURSE INSTRUCTOR"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="447" y="462" width="213" height="47" key="textField-9"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="false" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["DIRECTOR OF TRAINING"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="178" width="730" height="29" key="textField-10"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="18" isBold="false" pdfEncoding ="Identity-H"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["This is to Certify that"]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport>