task.jrxml
3.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown -->
<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="task" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="baf55988-0610-49d8-946e-683c7bdbd023">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="myAdapter"/>
<queryString language="SQL">
<![CDATA[SELECT s.userName,COUNT(t.createdBy) count from task_header t INNER JOIN sys_user s on t.createdBy=s.loginName and created >date_sub(curdate(), INTERVAL 30 DAY) GROUP BY s.userName ORDER BY count desc]]>
</queryString>
<field name="userName" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="userName"/>
<property name="com.jaspersoft.studio.field.tree.path" value="sys_user"/>
</field>
<field name="count" class="java.lang.Long">
<property name="com.jaspersoft.studio.field.label" value="count"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="79" splitType="Stretch">
<staticText>
<reportElement x="207" y="30" width="140" height="30" uuid="a0a599c3-7454-46d2-83ac-9ebddabddbe6"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="20"/>
</textElement>
<text><![CDATA[任务执行次数]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="30" splitType="Stretch">
<staticText>
<reportElement x="160" y="0" width="100" height="30" uuid="3fc9dcd1-959b-4520-8333-9f2ce2047ef1"/>
<textElement textAlignment="Right" verticalAlignment="Middle"/>
<text><![CDATA[日期:]]></text>
</staticText>
<textField pattern="MMMMM dd, yyyy">
<reportElement x="260" y="0" width="100" height="30" uuid="ad4b28fb-a670-49f3-be63-d7413f000efb"/>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="45" splitType="Stretch">
<staticText>
<reportElement x="180" y="10" width="100" height="30" uuid="ce9fe089-7e3a-4c11-8f2b-68d6739baa75"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[操作人员]]></text>
</staticText>
<staticText>
<reportElement x="280" y="10" width="100" height="30" uuid="6771fd49-0265-4033-bdb4-e1df20730ad2"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[次数]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="30" splitType="Stretch">
<textField>
<reportElement x="180" y="0" width="100" height="30" uuid="08384a0d-8f3f-466b-bfad-9853ba264241"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{userName}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="280" y="0" width="100" height="30" uuid="615d7de2-4187-44e4-b936-d8c6cf5e7dc0"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{count}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="3" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="31" splitType="Stretch">
<textField>
<reportElement x="470" y="-3" width="100" height="30" uuid="7f9bd68b-4857-4ebe-afca-a60a3a9ac1d8"/>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>