gdymtsceshi/WebContent/WEB-INF/report/26a5b9b9f2994d0a93a3770e2df59f20.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, t_web.columnid, t_column.columnname,sum(imgnum) imgnums,sum(wordnum) wordnums,sum(RelatingNum) RelatingNums FROM t_web INNER JOIN t_column ON t_column.ColumnID = t_web.ColumnID WHERE t_web.tstate = 'finished'  and releasetime>= $P{StartDate} and releasetime<= $P{EndDate} GROUP BY t_web.columnid, t_web.ColumnName ORDER BY cnt DESC]]>
		</queryString>
		<field name="cnt" class="java.lang.Long"/>
		<field name="columnid" class="java.lang.String"/>
		<field name="columnname" 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="70" 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="5" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="5" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="3" 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="20" y="0" width="470" 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{columnname}]]></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="70" uuid="aff702aa-dc11-4932-99e4-21dc4c7e4659">
						<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="70" height="30" uuid="290fab44-5daf-45dd-9291-d4c08cd9ba09"/>
								<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="70" height="30" uuid="a67687cf-a2a1-4a53-bcb7-3604a0431335"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{imgnums}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="babc5f3b-9b47-41b1-8da0-29e9b5e9d542">
						<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="d44ba9b3-d44b-4410-b736-09531d3c8890"/>
								<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="bec13fcb-6cb2-4a96-9663-f32c2e63f27f"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{wordnums}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="100" uuid="42325d50-6059-4461-ab38-f7ec81e5b4fe">
						<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="100" height="30" uuid="1d080f05-97da-4b9d-b29b-324d9f09cd3c"/>
								<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="100" height="30" uuid="f5146df5-3021-4e91-bbc0-9a0047b506d2"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font fontName="宋体" pdfFontName="STSong-Light" pdfEncoding="UniGB-UCS2-H" isPdfEmbedded="true"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{RelatingNums}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</summary>
</jasperReport>