?? ts_projdetailmember_06.jrxml
字號:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="TS_ProjDetailMember_06"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="612"
pageHeight="792"
columnWidth="576"
columnSpacing="0"
leftMargin="18"
rightMargin="18"
topMargin="54"
bottomMargin="18"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<parameter name="PSdate" isForPrompting="true" class="java.sql.Timestamp"/>
<parameter name="PEdate" isForPrompting="true" class="java.sql.Timestamp"/>
<parameter name="PResID" isForPrompting="true" class="java.lang.Integer"/>
<parameter name="SUBREPORT_DIR" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA[".\\"]]></defaultValueExpression>
</parameter>
<parameter name="PPath" isForPrompting="true" class="java.lang.String">
<defaultValueExpression ><![CDATA["\\rms_logo.gif"]]></defaultValueExpression>
</parameter>
<queryString><![CDATA[SELECT TS.WEEKBEGINING, TS.WEEKBEGINING+'0 day' as SUNDATE, TS.WEEKBEGINING+'1 day' as MONDATE, TS.WEEKBEGINING+'2 day' as TUEDATE, TS.WEEKBEGINING+'3 day' as WEDDATE, TS.WEEKBEGINING+'4 day' as THUDATE, TS.WEEKBEGINING+'5 day' as FRIDATE, TS.WEEKBEGINING+'6 day' as SATDATE, TS.FIRSTNAME, TS.LASTNAME, TS.RESOURCEID, TS.PROJECTCODE, TS.PROJECTNAME, TS.ACTIVITY, TS.PROJECTID, TS.BFINALIZED, TS.SAT, TS.FRI, TS.THU, TS.WED, TS.TUE, TS.MON, TS.SUNFROM VTIMESHEET_FIRST TS,VPROJMANAGERWHERE(TS.PROJECTID=VPROJMANAGER.PPROJECTID) AND (VPROJMANAGER.MRESOURCEID = $P{PResID}) AND TS.WEEKBEGINING+'6 day' >= $P{PSdate} AND TS.WEEKBEGINING <= $P{PEdate}AND TS.BFINALIZED = 'T'ORDER BY TS.PROJECTCODE ASC, TS.PROJECTNAME ASC, TS.FIRSTNAME ASC, TS.LASTNAME ASC, TS.WEEKBEGINING ASC, TS.ACTIVITY ASC]]></queryString>
<field name="WEEKBEGINING" class="java.sql.Timestamp"/>
<field name="FIRSTNAME" class="java.lang.String"/>
<field name="LASTNAME" class="java.lang.String"/>
<field name="RESOURCEID" class="java.math.BigDecimal"/>
<field name="PROJECTCODE" class="java.lang.String"/>
<field name="PROJECTNAME" class="java.lang.String"/>
<field name="ACTIVITY" class="java.lang.String"/>
<field name="PROJECTID" class="java.math.BigDecimal"/>
<field name="BFINALIZED" class="java.lang.String"/>
<field name="SAT" class="java.math.BigDecimal"/>
<field name="FRI" class="java.math.BigDecimal"/>
<field name="THU" class="java.math.BigDecimal"/>
<field name="WED" class="java.math.BigDecimal"/>
<field name="TUE" class="java.math.BigDecimal"/>
<field name="MON" class="java.math.BigDecimal"/>
<field name="SUN" class="java.math.BigDecimal"/>
<field name="MONDATE" class="java.sql.Timestamp"/>
<field name="FRIDATE" class="java.sql.Timestamp"/>
<field name="TUEDATE" class="java.sql.Timestamp"/>
<field name="WEDDATE" class="java.sql.Timestamp"/>
<field name="THUDATE" class="java.sql.Timestamp"/>
<field name="SUNDATE" class="java.sql.Timestamp"/>
<field name="SATDATE" class="java.sql.Timestamp"/>
<variable name="VResName" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[$F{RESOURCEID}.toString()+"-"+$F{FIRSTNAME}+"-"+$F{LASTNAME}]]></variableExpression>
</variable>
<variable name="VProjName" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[$F{PROJECTCODE}+"-"+$F{PROJECTNAME}]]></variableExpression>
</variable>
<variable name="VEmpName" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[$F{FIRSTNAME}+" "+$F{LASTNAME}]]></variableExpression>
</variable>
<variable name="VPageNumber" class="java.lang.String" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA["Page " + $V{PAGE_NUMBER} + " of " + $V{PAGE_NUMBER} + ""]]></variableExpression>
</variable>
<variable name="VSun" class="java.math.BigDecimal" resetType="Group" resetGroup="WeekBegin" calculation="Nothing">
<variableExpression><![CDATA[( $F{SUNDATE}.compareTo( $P{PSdate} )>=0 ?( $F{SUNDATE}.compareTo( $P{PEdate} )<=0 ? $F{SUN} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VMon" class="java.math.BigDecimal" resetType="None" calculation="Nothing">
<variableExpression><![CDATA[( $F{MONDATE}.compareTo( $P{PSdate} )>=0 ?( $F{MONDATE}.compareTo( $P{PEdate} )<=0 ? $F{MON} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VTue" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{TUEDATE}.compareTo( $P{PSdate} )>=0 ?( $F{TUEDATE}.compareTo( $P{PEdate} )<=0 ? $F{TUE} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VWed" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{WEDDATE}.compareTo( $P{PSdate} )>=0 ?( $F{WEDDATE}.compareTo( $P{PEdate} )<=0 ? $F{WED} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VThu" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{THUDATE}.compareTo( $P{PSdate} )>=0 ?( $F{THUDATE}.compareTo( $P{PEdate} )<=0 ? $F{THU} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VFri" class="java.math.BigDecimal" resetType="None" calculation="Nothing">
<variableExpression><![CDATA[( $F{FRIDATE}.compareTo( $P{PSdate} )>=0 ?( $F{FRIDATE}.compareTo( $P{PEdate} )<=0 ? $F{FRI} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VSat" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{SATDATE}.compareTo( $P{PSdate} )>=0 ?( $F{SATDATE}.compareTo( $P{PEdate} )<=0 ? $F{SAT} : $V{VNull} ) : $V{VNull} )]]></variableExpression>
</variable>
<variable name="VTotalH" class="java.math.BigDecimal" resetType="None" calculation="Nothing">
<variableExpression><![CDATA[$V{VSun}.add( $V{VMon}.add($V{VTue}.add($V{VWed}.add($V{VThu}.add($V{VFri}.add($V{VSat}))))) )]]></variableExpression>
</variable>
<variable name="VPTotalH" class="java.math.BigDecimal" resetType="Group" resetGroup="ProjName" calculation="Sum">
<variableExpression><![CDATA[$V{VTotalH}]]></variableExpression>
</variable>
<variable name="VNull" class="java.math.BigDecimal" resetType="None" calculation="Nothing">
<variableExpression><![CDATA[$F{SAT}.add( $F{SAT}.negate() )]]></variableExpression>
</variable>
<variable name="VTSun" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{SUNDATE}.compareTo( $P{PSdate} )>=0 ?( $F{SUNDATE}.compareTo( $P{PEdate} )<=0 ? $F{SUN} : null ) : null )]]></variableExpression>
</variable>
<variable name="VTMon" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{MONDATE}.compareTo( $P{PSdate} )>=0 ?( $F{MONDATE}.compareTo( $P{PEdate} )<=0 ? $F{MON} : null ) : null )]]></variableExpression>
</variable>
<variable name="VTTue" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{TUEDATE}.compareTo( $P{PSdate} )>=0 ?( $F{TUEDATE}.compareTo( $P{PEdate} )<=0 ? $F{TUE} : null ) : null )]]></variableExpression>
</variable>
<variable name="VTWed" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{WEDDATE}.compareTo( $P{PSdate} )>=0 ?( $F{WEDDATE}.compareTo( $P{PEdate} )<=0 ? $F{WED} : null ) : null )]]></variableExpression>
</variable>
<variable name="VTThu" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{THUDATE}.compareTo( $P{PSdate} )>=0 ?( $F{THUDATE}.compareTo( $P{PEdate} )<=0 ? $F{THU} : null ) : null )]]></variableExpression>
</variable>
<variable name="VTFri" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{FRIDATE}.compareTo( $P{PSdate} )>=0 ?( $F{FRIDATE}.compareTo( $P{PEdate} )<=0 ? $F{FRI} : null ) : null )]]></variableExpression>
</variable>
<variable name="VTSat" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
<variableExpression><![CDATA[( $F{SATDATE}.compareTo( $P{PSdate} )>=0 ?( $F{SATDATE}.compareTo( $P{PEdate} )<=0 ? $F{SAT} : null) : null )]]></variableExpression>
</variable>
<variable name="VATotalH" class="java.math.BigDecimal" resetType="Group" resetGroup="ResName" calculation="Sum">
<variableExpression><![CDATA[$V{VTotalH}]]></variableExpression>
</variable>
<group name="ProjName" isStartNewPage="true" >
<groupExpression><![CDATA[$V{VProjName}]]></groupExpression>
<groupHeader>
<band height="65" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="119" y="5" width="457" height="16" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{PROJECTCODE}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="5" width="119" height="16" key="staticText-3"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Netstar Project Code:]]></text>
</staticText>
<staticText>
<reportElement x="0" y="25" width="79" height="16" key="staticText-4"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Project Name:]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="79" y="25" width="497" height="16" key="textField"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{PROJECTNAME}]]></textFieldExpression>
</textField>
<elementGroup><!-- Start: 1 !-->
<staticText>
<reportElement x="0" y="47" width="98" height="16" key="staticText-10"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Project Manager: (Netstar):]]></text>
</staticText>
<subreport isUsingCache="true">
<reportElement x="98" y="47" width="478" height="14" key="subreport-1" isPrintWhenDetailOverflows="true"/>
<subreportParameter name="PProjectID">
<subreportParameterExpression><![CDATA[$F{PROJECTID}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "ManagerSub.jasper"]]></subreportExpression>
</subreport>
</elementGroup><!-- End 1 !-->
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="ProjectCode" isStartNewPage="true" >
<groupExpression><![CDATA[$V{VProjName}]]></groupExpression>
<groupHeader>
<band height="27" isSplitAllowed="true" >
<elementGroup><!-- Start: 2 !-->
<staticText>
<reportElement x="0" y="0" width="70" height="15" key="staticText-8"/>
<box></box>
<textElement>
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Period: From]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="dd-MMM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="69" y="0" width="82" height="15" key="textField"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{PSdate}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="152" y="0" width="17" height="15" key="staticText-9"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[to]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="dd-MMM-yyyy" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement x="170" y="0" width="82" height="15" key="textField"/>
<box></box>
<textElement textAlignment="Center">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$P{PEdate}]]></textFieldExpression>
</textField>
</elementGroup><!-- End 2 !-->
</band>
</groupHeader>
<groupFooter>
<band height="0" isSplitAllowed="true" >
</band>
</groupFooter>
</group>
<group name="ResName" >
<groupExpression><![CDATA[$F{RESOURCEID}]]></groupExpression>
<groupHeader>
<band height="51" isSplitAllowed="true" >
<staticText>
<reportElement x="70" y="8" width="63" height="24" key="staticText-12"/>
<box></box>
<textElement verticalAlignment="Bottom">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[WeekStarting]]></text>
</staticText>
<staticText>
<reportElement x="140" y="19" width="101" height="12" key="staticText-14"/>
<box></box>
<textElement verticalAlignment="Bottom">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Activities]]></text>
</staticText>
<staticText>
<reportElement x="252" y="20" width="80" height="12" key="staticText-16"/>
<box></box>
<textElement textAlignment="Right" verticalAlignment="Bottom">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Total]]></text>
</staticText>
<staticText>
<reportElement x="340" y="20" width="28" height="12" forecolor="#FF0000" key="staticText-17"/>
<box></box>
<textElement textAlignment="Right" verticalAlignment="Bottom">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Sun]]></text>
</staticText>
<staticText>
<reportElement x="543" y="20" width="30" height="12" forecolor="#FF0000" key="staticText-18"/>
<box></box>
<textElement textAlignment="Right" verticalAlignment="Bottom">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Sat]]></text>
</staticText>
<staticText>
<reportElement x="377" y="20" width="25" height="12" key="staticText-19"/>
<box></box>
<textElement textAlignment="Right" verticalAlignment="Bottom">
<font fontName="Verdana" pdfFontName="Helvetica-Bold" size="9" isBold="true"/>
</textElement>
<text><![CDATA[Mon]]></text>
</staticText>
<staticText>
<reportElement x="410" y="20" width="25"?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -