forum.bitel.ru :: Просмотр темы - bg 5.2 Акт сверки v 0.2

<?xml version="1.0" encoding="UTF-8" ?>

<!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">
 
 </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">
 
 </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>
 
 </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">
 
 </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>
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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>
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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>

Автор:	langello [ 04 апр 2013, 13:00 ]
Заголовок сообщения:	bg 5.2 Акт сверки v 0.2
Сервер: вер. 5.2 сборка от 17.03.2013 14:10:31 os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_37 Акт сверки (он нам больше подходит): http://wiki.bgbilling.ru/index.php/%D0% ... 0%BA%D0%B8 viewtopic.php?f=12&t=4186 Выдает такую ошибку: Error in method invocation: Method getContractByID( int ) not found in class'bitel.billing.server.contract.bean.ContractManager' : at Line: 27 : in file: inline evaluation of: ``import java.sql.; import java.util.; import java.util.regex.*; import java.mat . . . '' : .getContractByID ( cid ) Called from method: fillReport : at Line: -1 : in file: <Called from Java Code> : <Compiled Java Code> at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:179) at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) ..... Где что исправить???

Автор:	Phricker [ 04 апр 2013, 13:01 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
getContractById( int ) надо сделать.

Автор:	skyb [ 04 апр 2013, 13:48 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
обромляйте код в тег [code]

Автор:	Phricker [ 04 апр 2013, 14:15 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
Phricker писал(а): Код: getContractById( int ); надо сделать.

Автор:	stark [ 04 апр 2013, 14:41 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
Если заработает, то поправьте wiki пожалуйста

forum.bitel.ru http://forum.bitel.ru/

bg 5.2 Акт сверки v 0.2 http://forum.bitel.ru/viewtopic.php?f=12&t=7923	Страница 1 из 1

Автор:	Phricker [ 04 апр 2013, 16:36 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
Научили на свою голову пользоваться тегом code Он у вас ругается на Код: Error in method invocation: Method getContractByID( int ) not found getContractByID был заменен на getContractById Поэтому открываете в блокноте (или в чем вы там открываете этот отчет) и делаете глобальную замену getContractByID на getContractById

Автор:	langello [ 05 апр 2013, 08:44 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
Заменил : Код: getContractByID был заменен на getContractById Получил ошибку: Код: Attempt to resolve method: formatBigDecimalSumm() on undefined variable or class name: Utils : at Line: 50 : in file: inline evaluation of: ``import java.sql.; import java.util.; import java.util.regex.; import java.mat . . . '' : Utils .formatBigDecimalSumm ( inRest .abs ( ) ) Импортировал библиотеку: Код:* import ru.bitel.common.Utils; Получил ошибку: Код: Error in method invocation: Static method tableExists( ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper, java.lang.String ) not found in class'ru.bitel.common.Utils' : at Line: 71 : in file: inline evaluation of: ``import java.sql.; import java.util.; import java.util.regex.; import java.mat . . . '' : Utils .tableExists ( con , tableName ) Called from method: fillReport : at Line: -1 : in file: <Called from Java Code> : <Compiled Java Code> at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:77) Заменил на : Код:* import ru.bitel.common.Utils.; Получил ошибку: Код:* Attempt to resolve method: formatBigDecimalSumm() on undefined variable or class name: Utils : at Line: 50 : in file: inline evaluation of: ``import java.sql.; import java.util.; import java.util.regex.; import java.mat . . . '' : Utils .formatBigDecimalSumm ( inRest .abs ( ) ) Судя по сему не нравится строка: Код:* params.put( "inRestDebet", Utils.formatBigDecimalSumm( inRest.abs() ) ); И что делать далее подскажите.

Автор:	aiwbend [ 05 апр 2013, 09:28 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
вроде бы bu.getBalanceSumma1 возвращает уже в формате 0.00, а метод применяется если делаете операции с числами. Опираций я не увидел. попробуйте заменить все Код: Utils.formatBigDecimalSumm( inRest.abs() ) ) на Код: inRest.abs() думаю должно корректно отображаться. только не знаю возвращает ли bu.getBalanceSumma1 null. Скорей всего formatBigDecimalSumm для случая с null и использовался, тк по описанию в API он еще маскирует null на BigDecimal.ZERO.

Автор:	skn [ 05 апр 2013, 11:09 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
Код: import ru.bitel.bgbilling.server.util.ServerUtils; Код: ServerUtils.tableExists( Connection con, String tableName )

Автор:	langello [ 05 апр 2013, 12:57 ]
Заголовок сообщения:	Re: bg 5.2 Акт сверки v 0.2
Спасибо я уже сам допер: значить так : правим Код: getContractByID на Код: getContractById правим в тексте Код: Utils.tableExists на Код: ServerUtils.tableExists у меня импортированные библиотеки: Код: 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.; import ru.bitel.bgbilling.server.util.; import ru.bitel.common.;

Страница 1 из 1	Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/