dhis2-devs team mailing list archive

Thread
Date

[Branch ~dhis2-devs-core/dhis2/trunk] Rev 9159: Added jrxml report on data analysis usage

To: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: noreply@xxxxxxxxxxxxx
Date: Mon, 03 Dec 2012 17:56:16 -0000
Reply-to: noreply@xxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

------------------------------------------------------------
revno: 9159
committer: Lars Helge Øverland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Mon 2012-12-03 18:55:53 +0100
message:
  Added jrxml report on data analysis usage
added:
  resources/jrxml/
  resources/jrxml/data_analysis_usage_stats.jrxml


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription

=== added directory 'resources/jrxml'
=== added file 'resources/jrxml/data_analysis_usage_stats.jrxml'
--- resources/jrxml/data_analysis_usage_stats.jrxml	1970-01-01 00:00:00 +0000
+++ resources/jrxml/data_analysis_usage_stats.jrxml	2012-12-03 17:55:53 +0000
@@ -0,0 +1,214 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<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="report1" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ce21c66a-4fd0-43ce-963f-b69dd85fd919">
+	<property name="ireport.zoom" value="1.3310000000000004"/>
+	<property name="ireport.x" value="0"/>
+	<property name="ireport.y" value="0"/>
+	<queryString>
+		<![CDATA[select (
+  select count(*) from map ) as maps, (
+  select count(distinct userid) from map ) as mapusers, (
+  select count(*) from chart ) as charts, (
+  select count(distinct userid) from chart ) as chartusers, (
+  select count(*) from interpretation ) as interpretations, (
+  select count(*) from interpretation_comments ) as comments, (
+  select count(*) from usersetting where name='dashboardConfig' ) as dashboards, (
+  select count(*) from users ) as users, (
+  select count(*) from message ) as messages, (
+  select count(*) from userinfo
+    where (introduction is not null
+    or gender is not null
+    or nationality is not null
+    or education is not null
+    or interests is not null
+    or languages is not null )) as profiles;]]>
+	</queryString>
+	<field name="maps" class="java.lang.Long"/>
+	<field name="mapusers" class="java.lang.Long"/>
+	<field name="charts" class="java.lang.Long"/>
+	<field name="chartusers" class="java.lang.Long"/>
+	<field name="interpretations" class="java.lang.Long"/>
+	<field name="comments" class="java.lang.Long"/>
+	<field name="dashboards" class="java.lang.Long"/>
+	<field name="users" class="java.lang.Long"/>
+	<field name="messages" class="java.lang.Long"/>
+	<field name="profiles" class="java.lang.Long"/>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="370" splitType="Stretch">
+			<staticText>
+				<reportElement uuid="20210923-852e-4e3c-9007-b5e26098a416" x="205" y="20" width="319" height="33"/>
+				<textElement>
+					<font size="22"/>
+				</textElement>
+				<text><![CDATA[Data analysis usage stats]]></text>
+			</staticText>
+			<textField>
+				<reportElement uuid="3d5864c8-72a6-421e-856f-9d8530e69e16" x="393" y="118" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{maps}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement uuid="6897cf6a-c3ac-49dc-bc01-15d88ddd5010" x="205" y="118" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Maps]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="14dded0d-bdcd-463b-a7b0-8958dcea40b2" x="205" y="138" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Map distinct users]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="41e44f66-0fdb-4c85-978b-737cc5f4d5b8" x="205" y="158" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Charts]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="65c88e84-cc59-4e2f-9635-a0bc110b4380" x="205" y="178" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Chart distinct users]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="702c1830-259a-4b1a-bc3f-22d4ced65209" x="205" y="198" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Interpretations]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="218" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Interpretation comments]]></text>
+			</staticText>
+			<textField>
+				<reportElement uuid="586ce00d-696d-4fdf-a0b5-0acccd0cdfda" x="393" y="138" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{mapusers}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement uuid="6dd0a303-48b7-4bbc-9df8-d663dc1a1667" x="393" y="158" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{charts}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement uuid="e0fc648b-eef4-42b0-b856-8be4f7aef4f6" x="393" y="178" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{chartusers}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement uuid="a5eb2f14-6ae9-442a-8737-bfd21c3552ad" x="393" y="198" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{interpretations}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement uuid="939900f9-ed9a-40fa-88a8-e575944a279e" x="393" y="218" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{comments}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement uuid="4f4cbe49-5474-4fce-bf76-88ac27c72f05" x="393" y="279" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{users}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="279" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Users total]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="238" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Messages and comments]]></text>
+			</staticText>
+			<textField>
+				<reportElement uuid="74405f58-92f3-4bbc-af17-585b52bd835d" x="393" y="238" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{messages}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement uuid="b86c5db4-009f-4643-b6aa-e009501abeab" x="393" y="258" width="131" height="20"/>
+				<textElement>
+					<font size="11" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{dashboards}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="258" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[Dashboards set up]]></text>
+			</staticText>
+			<textField>
+				<reportElement uuid="4803d3a3-8fd7-4807-b738-6bb12cea15c9" x="393" y="299" width="131" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{profiles}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement uuid="ff90bdf5-fffa-4112-a3fc-26dbf63e412d" x="205" y="299" width="188" height="20"/>
+				<textElement>
+					<font size="11"/>
+				</textElement>
+				<text><![CDATA[User profiles]]></text>
+			</staticText>
+			<staticText>
+				<reportElement uuid="20210923-852e-4e3c-9007-b5e26098a416" x="205" y="60" width="319" height="33"/>
+				<textElement>
+					<font size="14"/>
+				</textElement>
+				<text><![CDATA[(Saved favorites by type)]]></text>
+			</staticText>
+		</band>
+	</title>
+	<pageHeader>
+		<band height="19" splitType="Stretch"/>
+	</pageHeader>
+	<columnHeader>
+		<band height="21" splitType="Stretch"/>
+	</columnHeader>
+	<detail>
+		<band height="13" splitType="Stretch"/>
+	</detail>
+	<columnFooter>
+		<band height="14" splitType="Stretch"/>
+	</columnFooter>
+	<pageFooter>
+		<band height="14" splitType="Stretch"/>
+	</pageFooter>
+	<summary>
+		<band height="16" splitType="Stretch"/>
+	</summary>
+</jasperReport>