gdymtsceshi/WebContent/WEB-INF/report/952e51b598c84be380da2b5794365cd8.jrxml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.0.final using JasperReports Library version 6.4.1  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="952e51b598c84be380da2b5794365cd8" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="39cf1b59-0a1c-4815-bad2-35e376b5b038">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="l_fsm5"/>
	<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="Dataset1" uuid="a0d90d55-cf18-4fdf-b40e-71f61fe2c412">
		<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="l_mysql"/>
		<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="198"/>
		<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="794"/>
		<parameter name="StartDate" class="java.lang.String">
			<defaultValueExpression><![CDATA[$P{StartDate}]]></defaultValueExpression>
		</parameter>
		<parameter name="EndDate" class="java.lang.String">
			<defaultValueExpression><![CDATA[$P{EndDate}]]></defaultValueExpression>
		</parameter>
		<queryString language="SQL">
			<![CDATA[select count(*) cnt,author,sum(imgnum) imgnums,sum(wordnum) wordnums,sum(RelatingNum) RelatingNums  from t_web where author is not null and author !='' and tstate='finished' and releasetime>= $P{StartDate} and releasetime<= $P{EndDate} group by author order by cnt desc]]>
		</queryString>
		<field name="cnt" class="java.lang.Long"/>
		<field name="author" class="java.lang.String"/>
		<field name="imgnums" class="java.lang.Long"/>
		<field name="wordnums" class="java.lang.Long"/>
		<field name="RelatingNums" class="java.lang.Long"/>
	</subDataset>
	<parameter name="StartDate" class="java.lang.String"/>
	<parameter name="EndDate" class="java.lang.String"/>
	<queryString language="SQL">
		<![CDATA[select count(*) cnt,author from t_web group by author]]>
	</queryString>
	<field name="cnt" class="java.lang.Long"/>
	<field name="author" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="61" splitType="Stretch">
			<textField>
				<reportElement x="110" y="1" width="300" height="30" uuid="0d8a9de4-7ee2-4ebe-9eab-fa0e0c9d1a40"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="宋体" size="20" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA["人员稿件发布量统计"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="110" y="40" width="60" height="20" uuid="3f13015c-b265-4ef0-bf75-559472cf5e4e"/>
				<textElement>
					<font pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[开始日期]]></text>
			</staticText>
			<textField>
				<reportElement x="170" y="40" width="90" height="20" uuid="0e0f37fa-5253-4a73-b854-d42f8086c7df"/>
				<textElement>
					<font pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{StartDate}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="290" y="40" width="60" height="20" uuid="83d941c5-fec9-4941-85c8-ded12be1e4aa"/>
				<textElement>
					<font pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[结束日期]]></text>
			</staticText>
			<textField>
				<reportElement x="350" y="40" width="60" height="20" uuid="dbb4aa9a-b552-4880-b8a1-65c79f081d0d"/>
				<textElement>
					<font pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{EndDate}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="3" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band splitType="Stretch"/>
	</detail>
	<columnFooter>
		<band height="7" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="5" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="167" splitType="Stretch">
			<componentElement>
				<reportElement positionType="Float" x="23" y="3" width="490" height="160" uuid="f965a34f-7976-41ae-ab24-6194edffc6b9">
					<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
					<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
					<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
					<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
				</reportElement>
				<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="Blank">
					<datasetRun subDataset="Dataset1" uuid="73f75a77-fffa-49a5-8c35-ac1da27cf235">
						<datasetParameter name="StartDate">
							<datasetParameterExpression><![CDATA[$P{StartDate}]]></datasetParameterExpression>
						</datasetParameter>
						<datasetParameter name="EndDate">
							<datasetParameterExpression><![CDATA[$P{EndDate}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="100" uuid="856d3eff-2d59-4997-95da-e2f5b87cbc1a">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
						<jr:tableHeader style="Table_TH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
						</jr:tableHeader>
						<jr:tableFooter style="Table_TH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
						</jr:tableFooter>
						<jr:columnHeader style="Table_CH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
							<staticText>
								<reportElement x="0" y="0" width="100" height="30" uuid="937156ed-f18f-40da-b480-18977c22e8ca">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<text><![CDATA[作者]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
						</jr:columnFooter>
						<jr:detailCell style="Table_TD" height="30">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
							<textField>
								<reportElement x="0" y="0" width="100" height="30" uuid="c78b5158-1f7a-40e9-866d-20fddb346902">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{author}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="100" uuid="d8f8a2b5-411d-4780-8310-ffd6279216c4">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
						<jr:tableHeader style="Table_TH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
						</jr:tableHeader>
						<jr:tableFooter style="Table_TH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
						</jr:tableFooter>
						<jr:columnHeader style="Table_CH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
							<staticText>
								<reportElement x="0" y="0" width="100" height="30" uuid="85ff0e07-9a92-40af-85fb-53c5b292d8f8">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<text><![CDATA[发布量]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30" rowSpan="1">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
						</jr:columnFooter>
						<jr:detailCell style="Table_TD" height="30">
							<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
							<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
							<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
							<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
							<textField>
								<reportElement x="0" y="0" width="100" height="30" uuid="f4698009-3357-4757-8366-a92998c6d3ed">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{cnt}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="80" uuid="6e43fa26-4a00-4ebe-9e23-25a968b00442">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
						<jr:tableHeader style="Table_TH" height="30" rowSpan="1"/>
						<jr:tableFooter style="Table_TH" height="30" rowSpan="1"/>
						<jr:columnHeader style="Table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement x="0" y="0" width="80" height="30" uuid="e885c600-daaa-4fd8-b39c-5ae3288a2a94">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<text><![CDATA[图片数量]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement x="0" y="0" width="80" height="30" uuid="14a568ad-f94c-40a2-bdfa-62f7a168be2d"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{imgnums}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="a27b3e2c-329e-4b04-a31a-140dc391ec48">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>
						<jr:tableHeader style="Table_TH" height="30" rowSpan="1"/>
						<jr:tableFooter style="Table_TH" height="30" rowSpan="1"/>
						<jr:columnHeader style="Table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement x="0" y="0" width="90" height="30" uuid="e4c42826-dfdd-4af2-b790-49b0b771ffd6">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<text><![CDATA[文字数量]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement x="0" y="0" width="90" height="30" uuid="3ec86b8b-f14c-4bbd-b6a8-7f6df6af6e2a"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{wordnums}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="120" uuid="d0db20d7-0233-4177-898b-dada35ebc5ec">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/>
						<jr:tableHeader style="Table_TH" height="30" rowSpan="1"/>
						<jr:tableFooter style="Table_TH" height="30" rowSpan="1"/>
						<jr:columnHeader style="Table_CH" height="30" rowSpan="1">
							<staticText>
								<reportElement x="0" y="0" width="120" height="30" uuid="2cb8a946-216c-4300-ac16-0ed2f06cf253">
									<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
									<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
									<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
									<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
								</reportElement>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<text><![CDATA[相关新闻数量]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table_TD" height="30">
							<textField>
								<reportElement x="0" y="0" width="120" height="30" uuid="7f684c78-2c98-4030-a499-f226150d91ba"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{RelatingNums}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</summary>
</jasperReport>