[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [6752] bkbooking: reverted to original application re
|
From: |
Kjell Arne Espedal |
|
Subject: |
[Fmsystem-commits] [6752] bkbooking: reverted to original application report with path fix |
|
Date: |
Wed, 12 Jan 2011 08:41:53 +0000 |
Revision: 6752
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6752
Author: kjell
Date: 2011-01-12 08:41:53 +0000 (Wed, 12 Jan 2011)
Log Message:
-----------
bkbooking: reverted to original application report with path fix
Modified Paths:
--------------
trunk/booking/jasper/templates/application.jrxml
Modified: trunk/booking/jasper/templates/application.jrxml
===================================================================
--- trunk/booking/jasper/templates/application.jrxml 2011-01-12 08:32:52 UTC
(rev 6751)
+++ trunk/booking/jasper/templates/application.jrxml 2011-01-12 08:41:53 UTC
(rev 6752)
@@ -2,7 +2,7 @@
<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"
language="groovy" pageWidth="595" pageHeight="842" columnWidth="555"
leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="0.9090909090909091"/>
<property name="ireport.x" value="0"/>
- <property name="ireport.y" value="120"/>
+ <property name="ireport.y" value="478"/>
<property name="net.sf.jasperreports.export.pdf.tagged" value="true"/>
<property name="net.sf.jasperreports.export.pdf.tag.language"
value="EN-US"/>
<style name="table">
@@ -25,6 +25,40 @@
<style name="Sans_Bold" fontName="FreeSerif" fontSize="10"
isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false"/>
<style name="Sans_Italic" fontName="FreeSerif" fontSize="10"
isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false"/>
<style name="Sans_Bold_Italic" fontName="FreeSerif" fontSize="10"
isBold="true" isItalic="true" isUnderline="false" isStrikeThrough="false"/>
+ <subDataset name="resources">
+ <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
+ <queryString>
+ <![CDATA[SELECT bb_resource.name AS resource_name,
bb_resource.type AS resource_type FROM
bb_application,bb_application_resource,bb_resource WHERE bb_application.id =
$P!{APPLICATION_ID} AND bb_application.id =
bb_application_resource.application_id AND bb_application_resource.resource_id
= bb_resource.id]]>
+ </queryString>
+ <field name="resource_name" class="java.lang.String"/>
+ <field name="resource_type" class="java.lang.String"/>
+ </subDataset>
+ <subDataset name="targetaudience">
+ <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
+ <queryString>
+ <![CDATA[SELECT bb_targetaudience.name AS
targetaudience FROM bb_application_targetaudience,bb_targetaudience WHERE
bb_application_targetaudience.application_id = $P!{APPLICATION_ID} AND
bb_application_targetaudience.targetaudience_id = bb_targetaudience.id]]>
+ </queryString>
+ <field name="targetaudience" class="java.lang.String"/>
+ </subDataset>
+ <subDataset name="agegroup">
+ <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
+ <queryString>
+ <![CDATA[SELECT bb_agegroup.name AS agegroup ,
bb_application_agegroup.male, bb_application_agegroup.female FROM
bb_agegroup,bb_application_agegroup WHERE
bb_application_agegroup.application_id = $P!{APPLICATION_ID} AND
bb_application_agegroup.agegroup_id = bb_agegroup.id AND bb_agegroup.active = 1
ORDER BY bb_agegroup.sort]]>
+ </queryString>
+ <field name="agegroup" class="java.lang.String"/>
+ <field name="male" class="java.lang.Integer"/>
+ <field name="female" class="java.lang.Integer"/>
+ </subDataset>
+ <subDataset name="comment">
+ <parameter name="APPLICATION_ID" class="java.lang.Integer"/>
+ <queryString language="SQL">
+ <![CDATA[SELECT
+ to_char(time,'DD/MM/YYYY HH24:MI') AS date, author, comment FROM
"bb_application_comment" bb_application_comment WHERE
bb_application_comment.application_id = $P!{APPLICATION_ID} AND
bb_application_comment.type = 'comment']]>
+ </queryString>
+ <field name="date" class="java.lang.String"/>
+ <field name="author" class="java.lang.String"/>
+ <field name="comment" class="java.lang.String"/>
+ </subDataset>
<parameter name="BK_APPLICATION_ID" class="java.lang.String"/>
<parameter name="BK_BUILDING_NAME" class="java.lang.String"/>
<parameter name="BK_PATH" class="java.lang.String"/>
@@ -85,6 +119,26 @@
</textElement>
<text><![CDATA[Leie av kommunale bygg, anlegg
og byrom.]]></text>
</staticText>
+ <componentElement>
+ <reportElement x="227" y="131" width="312"
height="13"/>
+ <jr:list
xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components
http://jasperreports.sourceforge.net/xsd/components.xsd";
printOrder="Horizontal">
+ <datasetRun subDataset="resources">
+ <datasetParameter
name="APPLICATION_ID">
+
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
+ </datasetParameter>
+
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
+ </datasetRun>
+ <jr:listContents height="13"
width="312">
+ <textField>
+ <reportElement
style="Sans_Bold" x="0" y="0" width="312" height="13"/>
+ <textElement>
+ <font
isUnderline="false" pdfFontName="Helvetica" isPdfEmbedded="true"/>
+ </textElement>
+ <textFieldExpression
class="java.lang.String"><![CDATA[$F{resource_name}]]></textFieldExpression>
+ </textField>
+ </jr:listContents>
+ </jr:list>
+ </componentElement>
<staticText>
<reportElement style="headers" x="6" y="105"
width="546" height="20"/>
<textElement/>
@@ -96,12 +150,45 @@
<text><![CDATA[Formål]]></text>
</staticText>
<staticText>
+ <reportElement style="headers" x="6" y="443"
width="546" height="20"/>
+ <textElement/>
+ <text><![CDATA[Målgruppe og estimert antall
deltakerte]]></text>
+ </staticText>
+ <break>
+ <reportElement x="0" y="612" width="100"
height="1"/>
+ </break>
+ <staticText>
<reportElement style="Sans_Bold" x="58" y="184"
width="286" height="13"/>
<textElement>
<font isBold="true"
isPdfEmbedded="true"/>
</textElement>
<text><![CDATA[Søker har lest og akseptert
følgende dokument:]]></text>
</staticText>
+ <componentElement>
+ <reportElement x="58" y="482" width="195"
height="13"/>
+ <jr:list
xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components
http://jasperreports.sourceforge.net/xsd/components.xsd"; printOrder="Vertical">
+ <datasetRun subDataset="targetaudience">
+ <datasetParameter
name="APPLICATION_ID">
+
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
+ </datasetParameter>
+
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
+ </datasetRun>
+ <jr:listContents height="13"
width="195">
+ <textField>
+ <reportElement x="0"
y="0" width="195" height="13"/>
+ <textElement/>
+ <textFieldExpression
class="java.lang.String"><![CDATA[$F{targetaudience}]]></textFieldExpression>
+ </textField>
+ </jr:listContents>
+ </jr:list>
+ </componentElement>
+ <staticText>
+ <reportElement x="58" y="469" width="100"
height="13"/>
+ <textElement>
+ <font isBold="true"
isPdfEmbedded="true"/>
+ </textElement>
+ <text><![CDATA[Målgruppe:]]></text>
+ </staticText>
<textField pattern="###0.00">
<reportElement x="58" y="261" width="126"
height="13"/>
<textElement/>
@@ -118,6 +205,9 @@
<line>
<reportElement x="6" y="304" width="546"
height="1" forecolor="#C0C0C0"/>
</line>
+ <line>
+ <reportElement x="6" y="461" width="546"
height="1" forecolor="#C0C0C0"/>
+ </line>
<textField>
<reportElement style="Sans_Bold" x="58" y="53"
width="156" height="13"/>
<textElement>
@@ -166,12 +256,124 @@
<textElement/>
<textFieldExpression
class="java.lang.String"><![CDATA["Til: " + $F{to}]]></textFieldExpression>
</textField>
+ <componentElement>
+ <reportElement key="table" style="table"
x="292" y="469" width="191" height="143"/>
+ <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";>
+ <datasetRun subDataset="agegroup">
+ <datasetParameter
name="APPLICATION_ID">
+
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
+ </datasetParameter>
+
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
+ </datasetRun>
+ <jr:column width="128">
+ <jr:columnHeader height="19"
rowSpan="1">
+ <staticText>
+ <reportElement
style="table_CELL_DARK" x="0" y="0" width="128" height="19"/>
+ <textElement>
+ <font
isBold="true" isItalic="true"/>
+ </textElement>
+
<text><![CDATA[Antall deltakere]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:detailCell height="20"
rowSpan="1">
+ <textField>
+ <reportElement
style="table_CELL_DARK" x="0" y="0" width="128" height="19"/>
+ <textElement>
+ <font
isBold="true"/>
+ </textElement>
+
<textFieldExpression
class="java.lang.String"><![CDATA[$F{agegroup}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ <jr:column width="47">
+ <jr:columnHeader height="19"
rowSpan="1">
+ <staticText>
+ <reportElement
style="table_CELL_DARK" x="0" y="0" width="47" height="19"/>
+ <textElement>
+ <font
isBold="true"/>
+ </textElement>
+
<text><![CDATA[Mann]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:detailCell height="20"
rowSpan="1">
+ <textField>
+ <reportElement
style="table_CELL_LIGHT" x="0" y="0" width="47" height="19"/>
+ <textElement/>
+
<textFieldExpression
class="java.lang.Integer"><![CDATA[$F{male}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ <jr:column width="48">
+ <jr:columnHeader height="19"
rowSpan="1">
+ <staticText>
+ <reportElement
style="table_CELL_DARK" x="0" y="0" width="47" height="19"/>
+ <textElement>
+ <font
isBold="true"/>
+ </textElement>
+
<text><![CDATA[Kvinne]]></text>
+ </staticText>
+ </jr:columnHeader>
+ <jr:detailCell height="20"
rowSpan="1">
+ <textField>
+ <reportElement
style="table_CELL_LIGHT" x="0" y="0" width="47" height="19"/>
+ <textElement/>
+
<textFieldExpression
class="java.lang.Integer"><![CDATA[$F{female}]]></textFieldExpression>
+ </textField>
+ </jr:detailCell>
+ </jr:column>
+ </jr:table>
+ </componentElement>
<textField>
<reportElement style="Sans_Normal" x="244"
y="79" width="197" height="13"/>
<textElement/>
<textFieldExpression
class="java.lang.String"><![CDATA["E-post: " +
$F{contact_email}]]></textFieldExpression>
</textField>
</band>
+ <band height="306">
+ <elementGroup>
+ <componentElement>
+ <reportElement x="6" y="32" width="546"
height="52"/>
+ <jr:list
xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components";
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components
http://jasperreports.sourceforge.net/xsd/components.xsd"; printOrder="Vertical">
+ <datasetRun
subDataset="comment">
+ <datasetParameter
name="APPLICATION_ID">
+
<datasetParameterExpression><![CDATA[$F{application_id}]]></datasetParameterExpression>
+ </datasetParameter>
+
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
+ </datasetRun>
+ <jr:listContents height="52"
width="546">
+ <textField>
+ <reportElement
x="0" y="0" width="104" height="13"/>
+ <textElement>
+ <font
isBold="true"/>
+ </textElement>
+
<textFieldExpression
class="java.lang.String"><![CDATA[$F{date}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement
x="104" y="0" width="117" height="13"/>
+ <textElement>
+ <font
isBold="true"/>
+ </textElement>
+
<textFieldExpression
class="java.lang.String"><![CDATA[$F{author}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement
x="0" y="13" width="546" height="39"/>
+ <textElement/>
+
<textFieldExpression
class="java.lang.String"><![CDATA[$F{comment}]]></textFieldExpression>
+ </textField>
+ </jr:listContents>
+ </jr:list>
+ </componentElement>
+ </elementGroup>
+ <elementGroup/>
+ <staticText>
+ <reportElement style="headers" x="6" y="6"
width="546" height="20"/>
+ <textElement/>
+ <text><![CDATA[Merknader]]></text>
+ </staticText>
+ <line>
+ <reportElement x="6" y="21" width="546"
height="1" forecolor="#C0C0C0"/>
+ </line>
+ </band>
</detail>
<pageFooter>
<band height="28">
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [6752] bkbooking: reverted to original application report with path fix,
Kjell Arne Espedal <=