ts_projdetailmember_06.jrxml

一个timesheet程序,用来统计开发人员的度量衡web在线程序.用于软件行业

<?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.SUN
FROM
     VTIMESHEET_FIRST TS,VPROJMANAGER
WHERE
(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[Week
Starting]]></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"