<?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="TAR_OTADJ_HONDA" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="782" 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.*" /> <import value="com.csc.library.report.*" /> <import value="com.csc.library.utilities.CscCalendar" /> <parameter name="PAGE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["PAGE"]]></defaultValueExpression> </parameter> <parameter name="HEAD1" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["TIME ATTENDANCE"]]></defaultValueExpression> </parameter> <parameter name="COMPANY" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="startdate" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["DAY START"]]></defaultValueExpression> </parameter> <parameter name="enddate" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["DAY END"]]></defaultValueExpression> </parameter> <parameter name="remark" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["REMARK"]]></defaultValueExpression> </parameter> <parameter name="VPAGE1" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["TAR_OTADJ_HONDA"]]></defaultValueExpression> </parameter> <parameter name="LANG" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[lang]]></parameterDescription> <defaultValueExpression ><![CDATA["THA"]]></defaultValueExpression> </parameter> <parameter name="REPORTHEADER" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="EMPID" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["EMPID"]]></defaultValueExpression> </parameter> <parameter name="SEQ" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["SEQ"]]></defaultValueExpression> </parameter> <parameter name="DATE" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Date" ]]></defaultValueExpression> </parameter> <parameter name="SHIFT" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["SHIFT"]]></defaultValueExpression> </parameter> <parameter name="START" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["START"]]></defaultValueExpression> </parameter> <parameter name="FINISH" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["FINISH"]]></defaultValueExpression> </parameter> <parameter name="1.5" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["1.5"]]></defaultValueExpression> </parameter> <parameter name="2" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["2"]]></defaultValueExpression> </parameter> <parameter name="3" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["3"]]></defaultValueExpression> </parameter> <parameter name="REMARK" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["REMARK"]]></defaultValueExpression> </parameter> <parameter name="BRANCH" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["BRANCH"]]></defaultValueExpression> </parameter> <parameter name="POSITION" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["POSITION"]]></defaultValueExpression> </parameter> <parameter name="DEPARTMENT" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["DEPARTMENT"]]></defaultValueExpression> </parameter> <parameter name="STARTDATE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["STARTDATE"]]></defaultValueExpression> </parameter> <parameter name="DAYS" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["DAYS"]]></defaultValueExpression> </parameter> <parameter name="TOTAL" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["TOTAL"]]></defaultValueExpression> </parameter> <parameter name="STDATE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="ENDDATE" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="OVERTIME" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["OVERTIME"]]></defaultValueExpression> </parameter> <parameter name="TOTAL_HOURS" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Total Hours"]]></defaultValueExpression> </parameter> <parameter name="ACCU." isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Accu."]]></defaultValueExpression> </parameter> <parameter name="JOB_DESCRIPTION" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Job Description" ]]></defaultValueExpression> </parameter> <parameter name="SIGNATURE" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Signature"]]></defaultValueExpression> </parameter> <parameter name="SEC.MGR." isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Sec.Mgr"]]></defaultValueExpression> </parameter> <parameter name="DEPT.MGR." isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Dept.Mgr"]]></defaultValueExpression> </parameter> <parameter name="DIV.MGR." isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Div.Mgr"]]></defaultValueExpression> </parameter> <parameter name="DETAIL_OF_OVERTIME_WORKING" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["DETAIL OF OVERTIME WORKING"]]></defaultValueExpression> </parameter> <parameter name="REASON" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Reasons"]]></defaultValueExpression> </parameter> <parameter name="CAUSE_OF_UNABLE_TO_RECORD_THE_ATTENDANCE_IN_ATTENDANCE_MACHINE" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["CAUSE OF UNABLE TO RECORD THE ATTENDANCE IN ATTENDANCE MACHINE"]]></defaultValueExpression> </parameter> <parameter name="TIME_IN" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Time In"]]></defaultValueExpression> </parameter> <parameter name="TIME_OUT" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Time Out"]]></defaultValueExpression> </parameter> <parameter name="PLACE/DETAIL_OF_OUTSIDE_WORKING" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["Place/Detail of Outside Working"]]></defaultValueExpression> </parameter> <parameter name="SECT./DEPT.MGR." isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[label]]></parameterDescription> <defaultValueExpression ><![CDATA["Sect./Dept.Mgr"]]></defaultValueExpression> </parameter> <parameter name="MONTHLIST" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[compenent]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <parameter name="YEARLIST" isForPrompting="false" class="java.lang.String"> <parameterDescription><![CDATA[component]]></parameterDescription> <defaultValueExpression ><![CDATA[""]]></defaultValueExpression> </parameter> <field name="vw_time_trans__itemno" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__itemno]]></fieldDescription> </field> <field name="vw_time_trans__itemnopermonth" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__itemnopermonth]]></fieldDescription> </field> <field name="vw_time_trans__employeeid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__employeeid]]></fieldDescription> </field> <field name="vw_time_trans__dayofweekint" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__dayofweekint]]></fieldDescription> </field> <field name="vw_time_trans__yearid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__yearid]]></fieldDescription> </field> <field name="vw_time_trans__monthid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__monthid]]></fieldDescription> </field> <field name="vw_time_trans__dayofweekchar" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__dayofweekchar]]></fieldDescription> </field> <field name="vw_time_trans__dateid" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__dateid]]></fieldDescription> </field> <field name="vw_time_trans__doctype" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__doctype]]></fieldDescription> </field> <field name="vw_time_trans__lv_ty" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__lv_ty]]></fieldDescription> </field> <field name="vw_time_trans__time0id" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__time0id]]></fieldDescription> </field> <field name="vw_time_trans__c_tm_bg" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__c_tm_bg]]></fieldDescription> </field> <field name="vw_time_trans__c_tm_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__c_tm_en]]></fieldDescription> </field> <field name="vw_time_trans__m_tm_bg" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__m_tm_bg]]></fieldDescription> </field> <field name="vw_time_trans__m_tm_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__m_tm_en]]></fieldDescription> </field> <field name="vw_time_trans__ac_ot" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ac_ot]]></fieldDescription> </field> <field name="vw_time_trans__ap_ot" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ap_ot]]></fieldDescription> </field> <field name="vw_time_trans__ot1" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot1]]></fieldDescription> </field> <field name="vw_time_trans__ot5" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot5]]></fieldDescription> </field> <field name="vw_time_trans__ot2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot2]]></fieldDescription> </field> <field name="vw_time_trans__ot3" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot3]]></fieldDescription> </field> <field name="vw_time_trans__ac_otb100" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ac_otb100]]></fieldDescription> </field> <field name="vw_time_trans__ap_otb100" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ap_otb100]]></fieldDescription> </field> <field name="vw_time_trans__ot1b100" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot1b100]]></fieldDescription> </field> <field name="vw_time_trans__ot5b100" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot5b100]]></fieldDescription> </field> <field name="vw_time_trans__ot2b100" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot2b100]]></fieldDescription> </field> <field name="vw_time_trans__ot3b100" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__ot3b100]]></fieldDescription> </field> <field name="vw_time_trans__forget_in" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__forget_in]]></fieldDescription> </field> <field name="vw_time_trans__forget_out" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__forget_out]]></fieldDescription> </field> <field name="vw_time_trans__source_in" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__source_in]]></fieldDescription> </field> <field name="vw_time_trans__source_out" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__source_out]]></fieldDescription> </field> <field name="vw_time_trans__eventgrpth" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__eventgrpth]]></fieldDescription> </field> <field name="vw_time_trans__eventgrpen" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__eventgrpen]]></fieldDescription> </field> <field name="vw_time_trans__remark" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__remark]]></fieldDescription> </field> <field name="vw_time_trans__isstopot" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__isstopot]]></fieldDescription> </field> <field name="vw_time_trans__tdaystopot" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__tdaystopot]]></fieldDescription> </field> <field name="vw_time_trans__edaystopot" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__edaystopot]]></fieldDescription> </field> <field name="vw_time_trans__fullname_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__fullname_th]]></fieldDescription> </field> <field name="vw_time_trans__fullname_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__fullname_en]]></fieldDescription> </field> <field name="vw_time_trans__emp_position" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__emp_position]]></fieldDescription> </field> <field name="vw_time_trans__emp_group" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__emp_group]]></fieldDescription> </field> <field name="vw_time_trans__branch" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__branch]]></fieldDescription> </field> <field name="vw_time_trans__bu1" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__bu1]]></fieldDescription> </field> <field name="vw_time_trans__bu2" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__bu2]]></fieldDescription> </field> <field name="vw_time_trans__bu3" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__bu3]]></fieldDescription> </field> <field name="vw_time_trans__bu4" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__bu4]]></fieldDescription> </field> <field name="vw_time_trans__bu5" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__bu5]]></fieldDescription> </field> <field name="vw_time_trans__costcenter" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__costcenter]]></fieldDescription> </field> <field name="vw_time_trans__startdate" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__startdate]]></fieldDescription> </field> <field name="vw_time_trans__mposdsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mposdsp_th]]></fieldDescription> </field> <field name="vw_time_trans__mposdsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mposdsp_en]]></fieldDescription> </field> <field name="vw_time_trans__mgrpdsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mgrpdsp_th]]></fieldDescription> </field> <field name="vw_time_trans__mgrpdsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mgrpdsp_en]]></fieldDescription> </field> <field name="vw_time_trans__mbrchdsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mbrchdsp_th]]></fieldDescription> </field> <field name="vw_time_trans__mbrchdsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mbrchdsp_en]]></fieldDescription> </field> <field name="vw_time_trans__u1dsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u1dsp_th]]></fieldDescription> </field> <field name="vw_time_trans__u1dsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u1dsp_en]]></fieldDescription> </field> <field name="vw_time_trans__u2dsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u2dsp_th]]></fieldDescription> </field> <field name="vw_time_trans__u2dsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u2dsp_en]]></fieldDescription> </field> <field name="vw_time_trans__u3dsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u3dsp_th]]></fieldDescription> </field> <field name="vw_time_trans__u3dsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u3dsp_en]]></fieldDescription> </field> <field name="vw_time_trans__u4dsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u4dsp_th]]></fieldDescription> </field> <field name="vw_time_trans__u4dsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u4dsp_en]]></fieldDescription> </field> <field name="vw_time_trans__u5dsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u5dsp_th]]></fieldDescription> </field> <field name="vw_time_trans__u5dsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__u5dsp_en]]></fieldDescription> </field> <field name="vw_time_trans__mcosdsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mcosdsp_th]]></fieldDescription> </field> <field name="vw_time_trans__mcosdsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mcosdsp_en]]></fieldDescription> </field> <field name="vw_time_trans__mt0dsp_th" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mt0dsp_th]]></fieldDescription> </field> <field name="vw_time_trans__mt0dsp_en" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__mt0dsp_en]]></fieldDescription> </field> <field name="vw_time_trans__reason" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__reason]]></fieldDescription> </field> <field name="vw_time_trans__outside_detail" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__outside_detail]]></fieldDescription> </field> <field name="vw_time_trans__accu" class="java.lang.String"> <fieldDescription><![CDATA[Field returned by vw_time_trans__accu]]></fieldDescription> </field> <variable name="HHOT5" class="java.lang.Integer" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf(Integer.parseInt($F{vw_time_trans__ot5}.substring(0,new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__ot5},"").indexOf("."))))]]></variableExpression> </variable> <variable name="MMOT5" class="java.lang.Integer" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf(Integer.parseInt(new ReportUDF().getDoubleFormat($F{vw_time_trans__ot5},"").substring(new ReportUDF().getDoubleFormat($F{vw_time_trans__ot5},"").indexOf(".")+1)))]]></variableExpression> </variable> <variable name="HHMMOT5" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{HHOT5}.intValue()+($V{MMOT5}.intValue()/60)+"."+($V{MMOT5}.intValue()%60)),"")]]></variableExpression> </variable> <variable name="HHMMOT2" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{HHOT2}.intValue()+($V{MMOT2}.intValue()/60)+"."+($V{MMOT2}.intValue()%60)),"")]]></variableExpression> </variable> <variable name="MMOT2" class="java.lang.Integer" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf(Integer.parseInt(new ReportUDF().getDoubleFormat($F{vw_time_trans__ot2},"").substring(new ReportUDF().getDoubleFormat($F{vw_time_trans__ot2},"").indexOf(".")+1)))]]></variableExpression> </variable> <variable name="HHOT2" class="java.lang.Integer" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf(Integer.parseInt($F{vw_time_trans__ot2}.substring(0,new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__ot2},"").indexOf("."))))]]></variableExpression> </variable> <variable name="HHMMOT3" class="java.lang.String" resetType="None" calculation="Nothing"> <variableExpression><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{HHOT3}.intValue()+($V{MMOT3}.intValue()/60)+"."+($V{MMOT3}.intValue()%60)),"")]]></variableExpression> </variable> <variable name="MMOT3" class="java.lang.Integer" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf(Integer.parseInt(new ReportUDF().getDoubleFormat($F{vw_time_trans__ot3},"").substring(new ReportUDF().getDoubleFormat($F{vw_time_trans__ot3},"").indexOf(".")+1)))]]></variableExpression> </variable> <variable name="HHOT3" class="java.lang.Integer" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[Integer.valueOf(Integer.parseInt($F{vw_time_trans__ot3}.substring(0,new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__ot3},"").indexOf("."))))]]></variableExpression> </variable> <variable name="SUM_OT5_B100" class="java.lang.Double" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[new Double($F{vw_time_trans__ot5b100})]]></variableExpression> <initialValueExpression><![CDATA[new Double("0.00")]]></initialValueExpression> </variable> <variable name="SUM_OT2_B100" class="java.lang.Double" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[new Double($F{vw_time_trans__ot2b100})]]></variableExpression> <initialValueExpression><![CDATA[new Double("0.00")]]></initialValueExpression> </variable> <variable name="SUM_OT3_B100" class="java.lang.Double" resetType="Group" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[new Double($F{vw_time_trans__ot3b100})]]></variableExpression> <initialValueExpression><![CDATA[new Double("0.00")]]></initialValueExpression> </variable> <variable name="SUM_ACCU" class="java.lang.Double" resetType="Group" incrementType="Group" incrementGroup="dateid" resetGroup="employeeid" calculation="Sum"> <variableExpression><![CDATA[new Double($F{vw_time_trans__ot5b100})]]></variableExpression> <initialValueExpression><![CDATA[new Double("0")]]></initialValueExpression> </variable> <group name="employeeid" isStartNewPage="true" > <groupExpression><![CDATA[$F{vw_time_trans__employeeid}]]></groupExpression> <groupHeader> <band height="92" isSplitAllowed="true" > <printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="299" y="80" width="38" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-44"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{SEC.MGR.}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="412" y="73" width="38" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-56"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="151" y="79" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-40"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{ACCU.}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="53" width="782" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="91" width="782" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="0" y="67" width="37" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="37" y="79" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-5"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{START}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="61" y="79" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-6"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{FINISH}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="85" y="79" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-7"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{1.5}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="107" y="79" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-8"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{2}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="129" y="79" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-9"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{3}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="3" y="5" width="778" height="14" forecolor="#000000" backcolor="#FFFFFF" key="textField-21"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["I'm "+$F{vw_time_trans__fullname_en} + " "+"Code : "+$F{vw_time_trans__employeeid} + " "+"Dept./Sect. "+ $F{vw_time_trans__u3dsp_en}+"/"+$F{vw_time_trans__u2dsp_en} + " "+$F{vw_time_trans__mbrchdsp_en} + " "+"Accept do O.T. after Office Hour and Holiday."]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="37" y="66" width="745" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-5"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="38" y="79" width="135" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-6"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="37" y="67" width="48" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-38"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{OVERTIME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="85" y="67" width="88" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-39"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL_HOURS}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="37" y="54" width="0" height="37" key="line-7"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="38" y="54" width="373" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-41"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{DETAIL_OF_OVERTIME_WORKING}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="85" y="67" width="0" height="24" key="line-8"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="173" y="67" width="0" height="24" key="line-9"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="174" y="73" width="125" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-42"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{JOB_DESCRIPTION}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="299" y="67" width="0" height="24" key="line-10"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="300" y="67" width="111" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-43"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{SIGNATURE}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="299" y="79" width="113" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-11"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="337" y="80" width="38" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-45"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{DEPT.MGR.}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="374" y="80" width="38" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-46"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{DIV.MGR.}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="412" y="54" width="0" height="37" key="line-13"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="450" y="73" width="47" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-47"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{REASON}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="497" y="67" width="0" height="24" key="line-14"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="413" y="54" width="369" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-48"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{CAUSE_OF_UNABLE_TO_RECORD_THE_ATTENDANCE_IN_ATTENDANCE_MACHINE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="498" y="73" width="39" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-49"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TIME_IN}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="537" y="73" width="39" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-50"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TIME_OUT}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="576" y="73" width="129" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-51"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{PLACE/DETAIL_OF_OUTSIDE_WORKING}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="576" y="67" width="0" height="24" key="line-15"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="705" y="67" width="0" height="24" key="line-16"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="706" y="67" width="76" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-52"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{SIGNATURE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="706" y="79" width="76" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-55"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{SECT./DEPT.MGR.}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="450" y="67" width="0" height="24" key="line-17"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="61" y="80" width="0" height="11" key="line-22"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="107" y="80" width="0" height="11" key="line-23"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="129" y="80" width="0" height="11" key="line-24"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="151" y="80" width="0" height="11" key="line-25"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="337" y="80" width="0" height="12" key="line-40"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="374" y="79" width="0" height="12" key="line-41"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="0" y="53" width="0" height="14" key="line-47"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="0" y="67" width="0" height="24" key="line-48"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="781" y="67" width="0" height="25" key="line-53"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="781" y="54" width="0" height="13" key="line-54"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="537" y="67" width="0" height="24" key="line-55"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="706" y="79" width="75" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-57"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="3" y="20" width="469" height="14" forecolor="#000000" backcolor="#FFFFFF" key="textField-60"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="true" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["ข้าพเจ้ายินยอมทำงานล่วงเวลาในวันทำงาน,ทำงานในวันหยุดหรือทำงานล่วงเวลาในวันหยุด"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="517" y="20" width="263" height="14" forecolor="#000000" backcolor="#FFFFFF" key="textField-61"/> <box topBorder="1Point" topBorderColor="#000000" leftBorder="1Point" leftBorderColor="#000000" rightBorder="1Point" rightBorderColor="#000000" bottomBorder="1Point" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="true" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Please return to HR Within 3 working days of the following month."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="3" y="35" width="778" height="14" forecolor="#000000" backcolor="#FFFFFF" key="textField-62"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Overtime Request On Holiday must Approve by Division Manager Before Time. (การขอทำงานล่วงเวลาในวันหยุด ต้องได้รับอนุมัติจากผู้จัดการส่วนงานก่อนทุกครั้ง)"]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="41" isSplitAllowed="true" > <printWhenExpression><![CDATA[new Boolean(true)]]></printWhenExpression> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="151" y="1" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-71"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{SUM_OT5_B100}.doubleValue()+$V{SUM_OT2_B100}.doubleValue()+$V{SUM_OT3_B100}.doubleValue()),"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="129" y="1" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-70"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{SUM_OT3_B100}),"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="107" y="1" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-69"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{SUM_OT2_B100}),"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="85" y="1" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-68"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new ReportUDF().getDoubleFormat(String.valueOf($V{SUM_OT5_B100}),"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="1" y="1" width="82" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-30"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{TOTAL}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="15" width="174" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-3"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="13" width="174" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-4"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement x="85" y="1" width="0" height="12" key="line-26"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="107" y="1" width="0" height="12" key="line-27"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="129" y="1" width="0" height="12" key="line-28"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="151" y="1" width="0" height="13" key="line-35"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="173" y="1" width="0" height="14" key="line-36"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="0" y="1" width="0" height="15" key="line-50"/> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="2" y="17" width="469" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-63"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["GA = GO ABORD ปฏิบัติงานต่างประเทศ,OTHERS = อื่นๆ ด้วยความจำเป็นบุคคล กรุณารูดบัตรและทำงานชดเชยตามเวลาที่ขอไปในวันนั้นหรือวันถัดไป"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="475" y="17" width="305" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-64"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["ACKNOWLEDGE BY EMPLOYEE.........................................................................................."]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="207" y="3" width="573" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-65"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Reason : FS = FORGET TO SLIDE ลืมรูดบัตร , CF = CARD FORGET ลืมบัตร , CL = CARD LOST บัตรหาย , CD = CARD DAMAGE บัตรชำรุด , UC = UP COUNTRY ปฏิบัติงานต่างจังหวัด"]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="1" width="782" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-68"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> </band> </groupFooter> </group> <group name="dateid" > <groupExpression><![CDATA[$F{vw_time_trans__dateid}]]></groupExpression> <groupHeader> <band height="0" isSplitAllowed="true" > </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="19" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="3" y="2" width="778" height="16" forecolor="#000000" backcolor="#FFFFFF" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{REPORTHEADER}+" "+(($P{MONTHLIST}.equals(""))?"":new CscCalendar($P{MONTHLIST}).getEngLongMonth())+" "+$P{YEARLIST}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="13" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="1" y="0" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-12"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{vw_time_trans__dateid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="37" y="0" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-14"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__m_tm_bg},"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="61" y="0" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-15"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__m_tm_en},"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="85" y="0" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-16"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__ot5b100},"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="107" y="0" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-17"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new com.csc.library.report.ReportUDF().getDoubleFormat($F{vw_time_trans__ot2b100},"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="129" y="0" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-18"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new ReportUDF().getDoubleFormat($F{vw_time_trans__ot3b100},"")]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="174" y="0" width="125" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-29"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[($F{vw_time_trans__lv_ty}.equals("I"))?"Holiday": ($F{vw_time_trans__lv_ty}.equals("H"))?$F{vw_time_trans__dayofweekchar}: ($F{vw_time_trans__isstopot}.equals("on"))?"No Overtime" :$F{vw_time_trans__remark}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="412" y="0" width="38" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-57"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{vw_time_trans__dateid}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="498" y="0" width="39" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-58"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[($F{vw_time_trans__source_in}.equals("5"))? new ReportUDF().getDoubleFormat($F{vw_time_trans__c_tm_bg},""):""]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="537" y="0" width="39" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-59"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[($F{vw_time_trans__source_out}.equals("5"))?new ReportUDF().getDoubleFormat($F{vw_time_trans__c_tm_en},""):""]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="85" y="0" width="0" height="12" key="line-21"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="107" y="0" width="0" height="12" key="line-29"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="61" y="0" width="0" height="12" key="line-30"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="37" y="0" width="0" height="12" key="line-31"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="129" y="0" width="0" height="12" key="line-32"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="151" y="0" width="0" height="12" key="line-33"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="173" y="0" width="0" height="12" key="line-37"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="299" y="0" width="0" height="12" key="line-38"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="374" y="0" width="0" height="12" key="line-39"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="450" y="0" width="0" height="12" key="line-42"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="497" y="0" width="0" height="12" key="line-43"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="537" y="0" width="0" height="12" key="line-44"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="576" y="0" width="0" height="12" key="line-45"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="705" y="0" width="0" height="12" key="line-46"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="0" y="0" width="0" height="12" key="line-49"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="781" y="0" width="1" height="12" key="line-51"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement mode="Opaque" x="0" y="12" width="782" height="0" forecolor="#000000" backcolor="#FFFFFF" key="line-56"/> <graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" /> </line> <line direction="TopDown"> <reportElement x="337" y="0" width="0" height="12" key="line-58"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="412" y="0" width="0" height="12" key="line-59"/> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="314" y="5" width="2" height="4" key="line-60"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 ||new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <line direction="BottomUp"> <reportElement x="315" y="3" width="9" height="6" key="line-61"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 || new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="450" y="0" width="47" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-72"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{vw_time_trans__reason}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="576" y="0" width="129" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-73"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{vw_time_trans__outside_detail}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="151" y="0" width="22" height="12" forecolor="#000000" backcolor="#FFFFFF" key="textField-75"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single"> <font fontName="Cordia New" pdfFontName="CORDIA.TTF" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Identity-H" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[new ReportUDF().getDoubleFormat($V{SUM_ACCU}.toString(),"")]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="351" y="5" width="2" height="4" key="line-69"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 ||new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <line direction="BottomUp"> <reportElement x="352" y="3" width="9" height="6" key="line-70"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 || new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="389" y="5" width="2" height="4" key="line-71"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 ||new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <line direction="BottomUp"> <reportElement x="390" y="3" width="9" height="6" key="line-72"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 || new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <line direction="TopDown"> <reportElement x="740" y="5" width="2" height="4" key="line-73"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 ||new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> <line direction="BottomUp"> <reportElement x="741" y="3" width="9" height="6" key="line-74"> <printWhenExpression><![CDATA[(new Double($F{vw_time_trans__ot5}).doubleValue()>0 || new Double($F{vw_time_trans__ot2}).doubleValue()>0 || new Double($F{vw_time_trans__ot3}).doubleValue()>0)?new Boolean(true):new Boolean(false)]]></printWhenExpression> </reportElement> <graphicElement stretchType="NoStretch"/> </line> </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>