Код:
getContractById( int );
А моно по подробней?
Вот код:
Код:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="kernel_act_sverki"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="AllSectionsNoDetail"
isFloatColumnFooter="true"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<style
name="Center"
isDefault="false"
hAlign="Center"
padding="0"
topPadding="1"
leftPadding="2"
bottomPadding="1"
rightPadding="1"
/>
<style
name="border"
isDefault="false"
border="Thin"
borderColor="#000000"
/>
<style
name="Right"
isDefault="false"
hAlign="Right"
topPadding="1"
leftPadding="1"
bottomPadding="1"
rightPadding="1"
/>
<parameter name="_filter" isForPrompting="false" class="bitel.billing.server.admin.reports.BGReportFilter"/>
<parameter name="_months" isForPrompting="false" class="java.util.Map"/>
<parameter name="clientTitle" isForPrompting="false" class="java.lang.String"/>
<parameter name="contractNumber" isForPrompting="false" class="java.lang.String"/>
<parameter name="contractDate" isForPrompting="false" class="java.lang.String"/>
<parameter name="inRestDebet" isForPrompting="false" class="java.lang.String"/>
<parameter name="dateFrom" isForPrompting="false" class="java.lang.String"/>
<parameter name="dateTo" isForPrompting="false" class="java.lang.String"/>
<parameter name="sumDebet" isForPrompting="false" class="java.lang.String"/>
<parameter name="sumCredit" isForPrompting="false" class="java.lang.String"/>
<parameter name="debtor" isForPrompting="false" class="java.lang.String"/>
<parameter name="debted" isForPrompting="false" class="java.lang.String"/>
<parameter name="debt" isForPrompting="false" class="java.lang.String"/>
<parameter name="outRest" isForPrompting="false" class="java.lang.String"/>
<parameter name="inRestCredit" isForPrompting="false" class="java.lang.String"/>
<parameter name="outRestDebet" isForPrompting="false" class="java.lang.String"/>
<parameter name="outRestCredit" isForPrompting="false" class="java.lang.String"/>
<queryString language="bgbs"><![CDATA[import java.sql.*;
import java.util.*;
import java.util.regex.*;
import java.math.*;
import bitel.billing.common.*;
import bitel.billing.server.util.*;
import bitel.billing.server.contract.bean.*;
public void fillReport( con, filter, result )
{
monthFrom = filter.getCalendarParam( "month_from" );
dateTo = filter.getCalendarParam( "date_to" );
monthTo = dateTo.clone();
monthTo.add( Calendar.MONTH, -1 );
cid = filter.getIntParam( "contract" );
billModuleId = filter.getIntParam( "report.act_sverki.bill.module.id" );
params = new HashMap();
res = new ArrayList( 1000 );
nextMonth = monthTo.clone();
nextMonth.add( Calendar.DAY_OF_YEAR, 1 );
params.put( "dateFrom", TimeUtils.formatDate( monthFrom ) );
params.put( "dateTo", TimeUtils.formatDate( dateTo ) );
contract = new ContractManager( con ).getContractByID( cid );
if( contract != null )
{
params.put( "clientTitle", contract.getComment() );
params.put( "contractNumber", contract.getTitle() );
params.put( "contractDate", TimeUtils.formatDate( contract.getDateFrom() ) );
}
bu = new BalanceUtils( con );
inRest = bu.getBalanceSumma1( TimeUtils.convertCalendarToDate( monthFrom ), cid );
outRest = bu.getSaldo( TimeUtils.convertCalendarToDate( dateTo ), cid );
if( inRest.compareTo( BigDecimal.ZERO ) <=0 )
{
params.put( "inRestDebet", Utils.formatBigDecimalSumm( inRest.abs() ) );
params.put( "inRestCredit", "" );
}
else
{
params.put( "inRestDebet", "" );
params.put( "inRestCredit", Utils.formatBigDecimalSumm( inRest.abs() ) );
}
if( outRest.compareTo( BigDecimal.ZERO ) <=0 )
{
params.put( "outRestDebet", Utils.formatBigDecimalSumm( outRest.abs() ) );
params.put( "outRestCredit", "" );
}
else
{
params.put( "outRestDebet", "" );
params.put( "outRestCredit", Utils.formatBigDecimalSumm( outRest.abs() ) );
}
fullActSum = BigDecimal.ZERO;
fullPaySum = BigDecimal.ZERO;
docTreeMap = new TreeMap();
// акС'С<
tableName = "bill_invoice_data_" + billModuleId;
if( Utils.tableExists( con, tableName ) )
{
query = "SELECT yy, mm, format_number, summ FROM " + tableName + " WHERE cid=? ORDER BY yy, mm";
ps = con.prepareStatement( query );
ps.setInt( 1, cid );
rs = ps.executeQuery();
while( rs.next() )
{
yy = rs.getInt( 1 );
mm = rs.getInt( 2 );
summ = rs.getBigDecimal( 4 );
month = new GregorianCalendar( yy, mm, 1 );
if( TimeUtils.dateBeforeOrEq( monthFrom, month ) &&
TimeUtils.dateBeforeOrEq( month, monthTo ) )
{
month = TimeUtils.getEndMonth( month );
//
actDate = TimeUtils.format( month, "yyyy-MM-dd" );
actNum = rs.getString( 3 );
actSum = Utils.formatBigDecimalSumm( summ );
//
dateDocs = docTreeMap.get( actDate );
if( dateDocs == null )
{
dateDocs = new ArrayList();
docTreeMap.put( actDate, dateDocs );
}
dateDocs.add( new String[]{ "РЎС╪.С".в"-" + actNum + " Р_С' " + TimeUtils.formatDate( month ), actSum, "" } );
//
fullActSum = fullActSum.add( summ );
}
}
}
// РїР>Р°С'РчРРё
query = "SELECT dt, summa FROM contract_payment WHERE cid=? AND dt>=? AND dt<=? ORDER BY dt";
ps = con.prepareStatement( query );
ps.setInt( 1, cid );
ps.setDate( 2, TimeUtils.convertCalendarToSqlDate( monthFrom ) );
ps.setDate( 3, TimeUtils.convertCalendarToSqlDate( dateTo ) );
rs = ps.executeQuery();
while( rs.next() )
{
summ = rs.getBigDecimal( 2 );
//
payDate = TimeUtils.format( rs.getDate( 1 ), "yyyy-MM-dd" );
paySum = Utils.formatBigDecimalSumm( summ );
//
dateDocs = docTreeMap.get( payDate );
if( dateDocs == null )
{
dateDocs = new ArrayList();
docTreeMap.put( payDate, dateDocs );
}
dateDocs.add( new String[]{ "Р_РїР>Р°С'Р° " + TimeUtils.formatDate( rs.getDate( 1 ) ), "", paySum } );
//
fullPaySum = fullPaySum.add( summ );
}
for( docList : docTreeMap.values() )
{
for( line : docList )
{
map = new HashMap( 3 );
res.add( map );
//
map.put( "doc.text", line[0] );
map.put( "doc.debet", line[1] );
map.put( "doc.credit", line[2] );
}
}
params.put( "sumDebet", Utils.formatBigDecimalSumm( fullActSum ) );
params.put( "sumCredit", Utils.formatBigDecimalSumm( fullPaySum ) );
if( outRest.compareTo( BigDecimal.ZERO ) <= 0 )
{
params.put( "debtor", params.get( "clientTitle" ) );
params.put( "debted", filter.getStringParam( "report.act_sverki.org.name" ) );
}
else
{
params.put( "debtor", filter.getStringParam( "report.act_sverki.org.name" ) );
params.put( "debted", params.get( "clientTitle" ) );
}
params.put( "debt", Utils.formatBigDecimalSumm( outRest.abs() ) );
result.setParams( params );
result.setDataSource( res );
}]]></queryString>
<field name="doc.text" class="java.lang.String"/>
<field name="doc.debet" class="java.lang.String"/>
<field name="doc.credit" class="java.lang.String"/>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="157" isSplitAllowed="true" >
<staticText>
<reportElement
mode="Opaque"
x="0"
y="0"
width="535"
height="14"
forecolor="#000000"
backcolor="#FFFFFF"
key="element-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="conf/arial.ttf" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Cp1251" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Р_РєС' С_Р_РчС_РєРё]]></text>
</staticText>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="14"
width="535"
height="35"
key="textField-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Р_заиР_Р_С<С: С_Р°С_С╪РчС'Р_Р_ РїР_ С_Р_С_С'Р_С_Р_РёС_ Р_Р° " + $P{dateTo} + "\n" + "Р_РчРР_С_ " + $P{_filter}.getStringParam("report.act_sverki.org.name") +
"\nРё " + $P{clientTitle} +
"\nРїР_ Р_Р_Р_Р_Р_Р_С_С_ " + $P{contractNumber} + " Р_С' " +$P{contractDate}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="49"
width="380"
height="16"
key="textField-2"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{_filter}.getStringParam("report.act_sverki.city")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="380"
y="49"
width="155"
height="16"
key="textField-3"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{dateTo}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="65"
width="535"
height="72"
key="textField-4"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Р_С<, Р_РёРРчРїР_Р_РїРёС_Р°Р_С_РёРчС_С_, Р"РчР_РчС_Р°Р>С_Р_С<Р№ Р_РёС_РчРєС'Р_С_ " + $P{_filter}.getStringParam("report.act_sverki.org.name") + " "+ $P{_filter}.getStringParam("report.act_sverki.gendir") + ", С_ Р_Р_Р_Р_Р№ С_С'Р_С_Р_Р_С<, Рё _________________________ " + $P{clientTitle} + ", _____________________________________ c Р_С_С_Р_Р_Р№ С_С'Р_С_Р_Р_С<, РїС_Р_РёР·Р_РчР>Рё С_Р_РчС_РєС_ Р_заиР_Р_С<С: С_Р°С_С╪РчС'Р_Р_ Р·Р° РїРчС_РёР_Р_" +
"\nС_ " + $P{dateFrom} + " РїР_ " + $P{dateTo} +
"\nР' С_РчР·С_Р>С_С'Р°С'Рч С_Р_РчС_РєРё С_С_С'Р°Р_Р_Р_Р>РчР_Р_:"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="138"
width="268"
height="19"
key="textField-24"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Р_Р_ Р_Р°Р_Р_С<Р_ " + $P{_filter}.getStringParam("report.act_sverki.org.name")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="268"
y="138"
width="268"
height="19"
key="textField-25"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="Thin" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="10" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Р_Р_ Р_Р°Р_Р_С<Р_ " + $P{clientTitle}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height="42" isSplitAllowed="true" >
<staticText>
<reportElement
x="130"
y="0"
width="69"
height="21"
key="staticText-4"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Р"РР'РРў]]></text>
</staticText>
<staticText>
<reportElement
x="199"
y="0"
width="69"
height="21"
key="staticText-6"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="Thin" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Р_Р РР"Р_Рў]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="21"
width="130"
height="21"
key="textField-21"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["РЎР°Р>С_Р_Р_ Р_Р° " + $P{dateFrom}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="130"
y="21"
width="69"
height="21"
key="textField-22"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{inRestDebet}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="199"
y="21"
width="69"
height="21"
key="textField-23"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{inRestCredit}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="0"
width="130"
height="21"
key="staticText-7"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Р_аиР_РчР_Р_Р_Р°Р_РёРч Р_РїРчС_Р°С┼РёР№, Р_Р_РєС_Р_РчР_С'Р_Р_]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="268"
y="21"
width="130"
height="21"
key="textField-26"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="398"
y="21"
width="69"
height="21"
key="textField-27"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="467"
y="21"
width="69"
height="21"
key="textField-28"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="12" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="398"
y="0"
width="69"
height="21"
key="staticText-14"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Р"РР'РРў]]></text>
</staticText>
<staticText>
<reportElement
x="467"
y="0"
width="69"
height="21"
key="staticText-15"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="Thin" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Р_Р РР"Р_Рў]]></text>
</staticText>
<staticText>
<reportElement
x="268"
y="0"
width="130"
height="21"
key="staticText-16"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" leftPadding="3" rightBorder="None" rightBorderColor="#000000" rightPadding="3" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<text><![CDATA[Р_аиР_РчР_Р_Р_Р°Р_РёРч Р_РїРчС_Р°С┼РёР№, Р_Р_РєС_Р_РчР_С'Р_Р_]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="20" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="0"
width="130"
height="20"
key="textField-10"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{doc.text}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="199"
y="0"
width="69"
height="20"
key="textField-13"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{doc.credit}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="130"
y="0"
width="69"
height="20"
key="textField-14"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{doc.debet}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="268"
y="0"
width="130"
height="20"
key="textField-29"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="467"
y="0"
width="69"
height="20"
key="textField-30"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="398"
y="0"
width="69"
height="20"
key="textField-31"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="182" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="105"
width="260"
height="77"
key="textField-5"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["\nР_С' " + $P{_filter}.getStringParam("report.act_sverki.org.name") + "\n Р"РчР_РчС_Р°Р>С_Р_С<Р№ Р_РёС_РчРєС'Р_С_" + "\n " + "\n______________ (" + $P{_filter}.getStringParam("report.act_sverki.gendir") + ")"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="260"
y="105"
width="275"
height="77"
key="textField-6"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Left">
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["\nР_С' " + $P{clientTitle} + "\n_________________________\n " + "\n______________ ( )"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="40"
width="535"
height="65"
key="textField-7"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["\nР-Р°Р_Р_Р>РРчР_Р_Р_С_С'С_ " + $P{debtor} +
"\nРїРчС_РчР_ " + $P{debted} + " РїР_ Р_Р_Р_Р_Р_Р_С_С_ " + $P{contractNumber} + " Р_С' " +
"\n" + $P{contractDate} + " РїР_ С_Р_С_С'Р_С_Р_РёС_ Р_Р° " + $P{dateTo} +
"\nС_Р_С_С'Р°Р_Р>С_РчС' " + $P{debt} + " С_С_Р+."]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="0"
width="130"
height="20"
key="textField-32"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Р_Р+Р_С_Р_С'С< Р·Р° РїРчС_РёР_Р_"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="199"
y="0"
width="69"
height="20"
key="textField-33"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{sumCredit}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="130"
y="0"
width="69"
height="20"
key="textField-34"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{sumDebet}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="268"
y="0"
width="130"
height="20"
key="textField-35"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="467"
y="0"
width="69"
height="20"
key="textField-36"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="398"
y="0"
width="69"
height="20"
key="textField-37"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="20"
width="130"
height="20"
key="textField-38"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["РЎР°Р>С_Р_Р_ Р_Р° " + $P{dateTo}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="199"
y="20"
width="69"
height="20"
key="textField-39"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{outRestCredit}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="130"
y="20"
width="69"
height="20"
key="textField-40"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{outRestDebet}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="268"
y="20"
width="130"
height="20"
key="textField-41"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="1" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="467"
y="20"
width="69"
height="20"
key="textField-42"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="398"
y="20"
width="69"
height="20"
key="textField-43"/>
<box topBorder="Thin" topBorderColor="#000000" topPadding="2" leftBorder="Thin" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="Thin" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font fontName="Arial" pdfFontName="Helvetica" size="8" isBold="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
</textField>
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>