[Fmsystem-commits] [6648] bkbooking: testfix for application jasperreport

[Kjell Arne Espedal]

Revision: 6648
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6648
Author:   kjell
Date:     2010-11-26 12:24:34 +0000 (Fri, 26 Nov 2010)
Log Message:
-----------
bkbooking: testfix for application jasperreport

Modified Paths:
--------------
    trunk/booking/jasper/templates/application.jrxml

Modified: trunk/booking/jasper/templates/application.jrxml
===================================================================
--- trunk/booking/jasper/templates/application.jrxml    2010-11-26 10:24:45 UTC 
(rev 6647)
+++ trunk/booking/jasper/templates/application.jrxml    2010-11-26 12:24:34 UTC 
(rev 6648)
@@ -62,7 +62,7 @@
        <parameter name="BK_APPLICATION_ID" class="java.lang.String"/>
        <parameter name="BK_BUILDING_NAME" class="java.lang.String"/>
        <queryString>
-               <![CDATA[SELECT bb_application.id AS application_id, 
bb_application.status AS application_status, to_char(bb_application.created, 
'DD/MM/YYYY HH24:MI') AS application_created, to_char(bb_application.modified, 
'DD/MM/YYYY HH24:MI') AS application_modified,bb_application.contact_name, 
bb_application.contact_email, 
bb_application.contact_phone,bb_application.description, 
to_char(bb_application_date.from_, 'DD/MM/YYYY HH24:MI') AS from, 
to_char(bb_application_date.to_, 'DD/MM/YYYY HH24:MI') AS to, bb_activity.name 
AS activity_name, bb_event.cost AS price,bb_application_comment.comment AS 
comment FROM bb_application, bb_application_date,bb_activity, bb_event, 
bb_application_comment WHERE bb_application.id = $P!{BK_APPLICATION_ID} AND 
bb_application.id = bb_application_date.application_id AND 
bb_application.activity_id = bb_activity.id AND bb_application.id = 
bb_event.application_id AND bb_application.id = 
bb_application_comment.application_id LIMIT 1]]>
+               <![CDATA[SELECT bb_application.id AS application_id, 
bb_application.status AS application_status, to_char(bb_application.created, 
'DD/MM/YYYY HH24:MI') AS application_created, to_char(bb_application.modified, 
'DD/MM/YYYY HH24:MI') AS application_modified,bb_application.contact_name, 
bb_application.contact_email, 
bb_application.contact_phone,bb_application.description, 
to_char(bb_application_date.from_, 'DD/MM/YYYY HH24:MI') AS from, 
to_char(bb_application_date.to_, 'DD/MM/YYYY HH24:MI') AS to, bb_activity.name 
AS activity_name, bb_event.cost AS price,bb_application_comment.comment AS 
comment FROM bb_application, bb_application_date,bb_activity, bb_event, 
bb_application_comment WHERE bb_application.id = ANY 
(string_to_array($P{BK_APPLICATION_ID}, ',')::int4[]) AND bb_application.id = 
bb_application_date.application_id AND bb_application.activity_id = 
bb_activity.id AND bb_application.id = bb_event.application_id AND 
bb_application.id = bb_application_comment.application_id LIMIT 1]]>
        </queryString>
        <field name="application_id" class="java.lang.Integer"/>
        <field name="application_status" class="java.lang.String"/>