import java.sql.*;
import java.util.*;
import java.math.*;

import bitel.billing.server.contract.bean.*;
import bitel.billing.server.bill.bean.*;
import bitel.billing.server.util.*;


BigDecimal quan = new BigDecimal( 1 );
Calendar time = event.getGenerateTime();
Calendar DateNow = Calendar.getInstance();

bill_doc = new Bill();
   bill_doc.setCid(223);
   bill_doc.setContractTitle("Test!!!");
   bill_doc.setCreateDate(DateNow.getTime());
   bill_doc.setMm(0);
   bill_doc.setTypeId(1);
   bill_doc.setNumber(1);
   bill_doc.setNumberInMonth(1);
   bill_doc.setNumberInYear(1);
   bill_doc.setTypeTitle("Еуыт!!!");
   bill_doc.setUid(1);
   bill_doc.setYy(2011);
   bill_doc.setAccountId(1);
   position_value_list = new java.util.ArrayList();

 
   
      position = new Position();
      position.setId(11);
      position.setName("jkhdkjsdhfksdhf");
      position.setSumm("100");
      position.setTitle("ekrl;ewkr;lkwer");
 
      position_value = new PositionValue();
      position_value.setCid(11);
      position_value.setName("we;wekr;lkwer");
      position_value.setPosition(position);
      position_value.setPositionId(1);
      position_value.setSumma(quan);
 
      position_value_list.add(position_value);

bill_manager = new BillManager(setup,con,6,setup.getSetup().getModuleSetup(6));
bill_manager.addBillDoc(1,bill_doc,position_value_list,Collections.emptyList());

01-14/18:27:38  INFO [http-8080-5] script - Process event cid:233; event:Event bitel.billing.server.script.bean.event.PaymentEvent cid: 233; module: 0; type: 1; userId: 1
01-14/18:27:38  INFO [http-8080-5] script - Process event cid:233; event:Event bitel.billing.server.script.bean.event.PaymentEvent cid: 233; module: 0; type: 1; userId: 1
01-14/18:27:38  INFO [pool-1-thread-28] ScriptInstance - Eval script Function [id:9; title:Выставление счета по приходу платежа]
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream - java.lang.NullPointerException
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at ru.bitel.bgbilling.modules.bill.server.bean.NumerationPoolManager.formatNumber(NumerationPoolManager.java:175)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bitel.billing.server.bill.bean.BillManager.addBillDoc(BillManager.java:598)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at java.lang.reflect.Method.invoke(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.Reflect.invokeMethod(Reflect.java:137)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.Reflect.invokeObjectMethod(Reflect.java:83)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.Name.invokeMethod(Name.java:858)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bsh.Interpreter.eval(Interpreter.java:653)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at ru.bitel.bgbilling.kernel.script.server.bean.ScriptInstance.eval(ScriptInstance.java:352)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$SimpleScriptRunner.runScript(ScriptMachine.java:70)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine.runScriptImpl(ScriptMachine.java:220)
01-14/18:27:38  INFO [http-8080-5] script - Process time => 92
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$ThreadedScriptMachine.access$0(ScriptMachine.java:1)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$ThreadedScriptMachine$1.call(ScriptMachine.java:361)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$ThreadedScriptMachine$1.call(ScriptMachine.java:1)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at java.util.concurrent.FutureTask.run(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
01-14/18:27:38 ERROR [pool-1-thread-28] LoggingPrintStream -    at java.lang.Thread.run(Unknown Source)

import bitel.billing.server.util.*;
import ru.bitel.bgbilling.server.util.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import java.math.BigDecimal;
import bitel.billing.server.bill.bean.*;
import bitel.billing.server.contract.bean.*;
import bitel.billing.common.*;
import java.io.StringWriter;
//import bitel.billing.server.bill.bean.BillManager;
import bitel.billing.server.bill.bean.InvoiceManager;


public void main( setup, con, conSlave )
{
   int mid = 8; //mid модуля Бухгалтерии
   int accountId =1; // id счета банка

   Calendar month = new GregorianCalendar();
   //корректировка времени
   month.add( Calendar.HOUR, -2 );

   int mm = month.get(Calendar.MONTH);
   int yy = month.get(Calendar.YEAR);
   month.set(Calendar.DAY_OF_MONTH,1);

   BalanceUtils bu = new BalanceUtils( conSlave );   
   ModuleSetup moduleSetup = setup.getModuleSetup( mid );
   TemplateBillManager man = new TemplateBillManager( moduleSetup, conSlave, mid, true );
   List templateBillList = man.getTemplatePayBillList( moduleSetup, yy, mm, null, null, null, null );
   print("doc for create = "+templateBillList.size());
   //делаем
   DocumentBuilderFactory dFactory = DocumentBuilderFactory.newInstance();
   DocumentBuilder docBuilder = dFactory.newDocumentBuilder();
   Document doc = docBuilder.newDocument();
   Element bills = doc.createElement("bills");
   doc.appendChild(bills);
   for( TemplateBill templateBill : templateBillList )
   {
      Element row = createElement( bills,"bill" );
      BigDecimal subBillSumm = BigDecimal.ZERO;
      row.setAttribute( "rest", Utils.formatBigDecimalSumm( bu.getBalance( month.getTime(), templateBill.getContractId() ) ) );
      row.setAttribute( "account_id",String.valueOf(accountId ));
      BigDecimal billSumm = fillBillData( row, templateBill );
      if( templateBill.getSubBillList() != null )
      {
         for( TemplateBill templateSubBill : templateBill.getSubBillList() )
         {
            Element subBill = createElement( row, "sub_bill" );
            subBillSumm = subBillSumm.add( fillBillData( subBill, templateSubBill ) );
         }
      }
      row.setAttribute( "sub_bill_summ", Utils.formatBigDecimalSumm( subBillSumm ) );
      row.setAttribute( "summ", Utils.formatBigDecimalSumm( billSumm.add( subBillSumm ) ) );
   }
//посомтрим что получилось
   ByteArrayOutputStream sos = new ByteArrayOutputStream();
   CommonUtils.serializeXML(doc , sos, "utf-8");
   String xml = sos.toString();
//   print(xml);
   InputStream is = new ByteArrayInputStream( xml.getBytes( "windows-1251" ) );
   //BillManager pbm = new BillManager( setup, con, mid, moduleSetup );
   InvoiceManager pbm = new InvoiceManager( setup, con, mid, moduleSetup );
   pbm.addBillDocs( -1, is, yy, mm, month );


}
private BigDecimal fillBillData( Element row, TemplateBill templateBill )
{
BigDecimal billSumm = BigDecimal.ZERO;

row.setAttribute( "id", String.valueOf( templateBill.getContractDocTypeId() ) );
row.setAttribute( "type", String.valueOf( templateBill.getDocTypeId() ) );
row.setAttribute( "cid", String.valueOf( templateBill.getContractId() ) );

row.setAttribute( "contract", templateBill.getContractTitle() );
row.setAttribute( "contract_comment", templateBill.getContractComment() );

for( PositionValue value : templateBill.getPositionList() )
{
BigDecimal summ = value.getSumma();

Element posEl = createElement( row, "pos" );
value.toElement( posEl );

Position pos = value.getPosition();
posEl.setAttribute( "insum", Utils.booleanToStringInt( pos.isInSum() ) );
posEl.setAttribute( "awlz", Utils.booleanToStringInt( pos.isAddWhenLessZero() ) );

if( pos.isInSum() )
{
billSumm = billSumm.add( summ );
}
}

row.setAttribute( "summ", Utils.formatBigDecimalSumm( billSumm ) );

return billSumm;
}

protected Element createElement( Element element, String name )
{
Element newElement = null;
if( element == null )
{
newElement = null;
}
else
{
newElement = element.getOwnerDocument().createElement( name );
element.appendChild( newElement );
}
return newElement;
}

import java.sql.*;
import java.util.*;
import java.math.*;

import bitel.billing.server.contract.bean.*;
import bitel.billing.server.bill.bean.*;
import bitel.billing.server.util.*;


Calendar time = event.getGenerateTime();
Calendar DateNow = Calendar.getInstance();
cid = event.getContractId();
print("cid:"+cid);



BillManager bill_manager = new BillManager(setup,con,6,setup.getSetup().getModuleSetup(6));



Bill bill_doc = new Bill();
bill_doc.setCid(cid);

bill_doc.setCreateDate(DateNow.getTime());
print (DateNow.getTime());
bill_doc.setMm(1);
bill_doc.setSumm(new BigDecimal(100));
bill_doc.setTypeId(4);
bill_doc.setTypeTitle("test");

bill_doc.setYy(2011);


bill_doc.setAccountId(1);
bill_doc.setNpid(1);

Position position = new Position();
position.setId(11);
position.setName("Test!");
position.setQuantity("1");
position.setSumm("100");
position.setTitle("Test!");
position.setUnit("руб.");

PositionValue position_value = new PositionValue();
position_value.setCid(cid);
position_value.setName("Test!");
position_value.setPosition(position);
position_value.setPositionId(1);
position_value.setQuantity(new BigDecimal(1));
position_value.setSumma(new BigDecimal(100));
position_value.setUnit("шт.");

ArrayList position_value_list = new java.util.ArrayList();
position_value_list.add(position_value);
ArrayList bill_doc_list = new java.util.ArrayList();
bill_doc_list.add(bill_doc);


bill_manager.addBillDoc(1,bill_doc,position_value_list,bill_doc_list);
//bill_manager.addBillDoc(1,bill_doc,position_value_list,Collections.emptyList());
print ("end");

1-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream - java.lang.NullPointerException
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.bill.bean.PositionValue.toElement(PositionValue.java:153)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.bill.bean.AbstractManager.addBillDocData(AbstractManager.java:935)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.bill.bean.BillManager.serializeBillToXML(BillManager.java:697)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.bill.bean.BillManager.addBillDoc(BillManager.java:622)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at sun.reflect.GeneratedMethodAccessor300.invoke(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at java.lang.reflect.Method.invoke(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.Reflect.invokeMethod(Reflect.java:137)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.Reflect.invokeObjectMethod(Reflect.java:83)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.Name.invokeMethod(Name.java:858)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bsh.Interpreter.eval(Interpreter.java:653)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at ru.bitel.bgbilling.kernel.script.server.bean.ScriptInstance.eval(ScriptInstance.java:352)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$SimpleScriptRunner.runScript(ScriptMachine.java:70)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine.runScriptImpl(ScriptMachine.java:190)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$ThreadedScriptMachine.access$0(ScriptMachine.java:1)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$ThreadedScriptMachine$1.call(ScriptMachine.java:361)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at bitel.billing.server.script.bean.ScriptMachine$ThreadedScriptMachine$1.call(ScriptMachine.java:1)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at java.util.concurrent.FutureTask.run(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
01-18/12:14:51 ERROR [pool-2-thread-84] LoggingPrintStream -    at java.lang.Thread.run(Unknown Source)

import bitel.billing.server.util.*;
import ru.bitel.bgbilling.server.util.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import java.math.BigDecimal;
import bitel.billing.server.bill.bean.*;
import bitel.billing.server.contract.bean.*;
import bitel.billing.common.*;
import java.io.StringWriter;
import bitel.billing.server.bill.bean.BillManager;


public void main( setup, con, conSlave )
{
int mid = 65; //mid модуля Бухгалтерии
int accountId =1; // id счета банка

Calendar month = new GregorianCalendar();
int mm = month.get(Calendar.MONTH);
int yy = month.get(Calendar.YEAR);
month.set(Calendar.DAY_OF_MONTH,1);

BalanceUtils bu = new BalanceUtils( conSlave );   
ModuleSetup moduleSetup = setup.getModuleSetup( mid );
TemplateBillManager man = new TemplateBillManager( moduleSetup, conSlave, mid, false );
List templateBillList = man.getTemplatePayBillList( moduleSetup, yy, mm, null, null, null, null );
print("doc for create = "+templateBillList.size());
//делаем
DocumentBuilderFactory dFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = dFactory.newDocumentBuilder();
Document doc = docBuilder.newDocument();
Element bills = doc.createElement("bills");
doc.appendChild(bills);
for( TemplateBill templateBill : templateBillList )
{

Element row = createElement( bills,"bill" );
BigDecimal subBillSumm = BigDecimal.ZERO;
row.setAttribute( "rest", Utils.formatBigDecimalSumm( bu.getBalance( month.getTime(), templateBill.getContractId() ) ) );
row.setAttribute( "account_id",String.valueOf(accountId ));
BigDecimal billSumm = fillBillData( row, templateBill );
if( templateBill.getSubBillList() != null )
{
for( TemplateBill templateSubBill : templateBill.getSubBillList() )
{
Element subBill = createElement( row, "sub_bill" );
subBillSumm = subBillSumm.add( fillBillData( subBill, templateSubBill ) );
}
}
row.setAttribute( "sub_bill_summ", Utils.formatBigDecimalSumm( subBillSumm ) );
row.setAttribute( "summ", Utils.formatBigDecimalSumm( billSumm.add( subBillSumm ) ) );
}
//посомтрим что получилось
ByteArrayOutputStream sos = new ByteArrayOutputStream();
CommonUtils.serializeXML(doc , sos, "windows-1251");
String xml = sos.toString();
//print(xml);
InputStream is = new ByteArrayInputStream( xml.getBytes( "cp1251" ) );
BillManager pbm = new BillManager( setup, con, mid, moduleSetup );
pbm.addBillDocs( -1, is, yy, mm, new Date() );


}
private BigDecimal fillBillData( Element row, TemplateBill templateBill )
{
BigDecimal billSumm = BigDecimal.ZERO;

row.setAttribute( "id", String.valueOf( templateBill.getContractDocTypeId() ) );
row.setAttribute( "type", String.valueOf( templateBill.getDocTypeId() ) );
row.setAttribute( "cid", String.valueOf( templateBill.getContractId() ) );

row.setAttribute( "contract", templateBill.getContractTitle() );
row.setAttribute( "contract_comment", templateBill.getContractComment() );

for( PositionValue value : templateBill.getPositionList() )
{
BigDecimal summ = value.getSumma();

Element posEl = createElement( row, "pos" );
value.toElement( posEl );

Position pos = value.getPosition();
posEl.setAttribute( "insum", Utils.booleanToStringInt( pos.isInSum() ) );
posEl.setAttribute( "awlz", Utils.booleanToStringInt( pos.isAddWhenLessZero() ) );

if( pos.isInSum() )
{
billSumm = billSumm.add( summ );
}
}

row.setAttribute( "summ", Utils.formatBigDecimalSumm( billSumm ) );

return billSumm;
}

protected Element createElement( Element element, String name )
{
Element newElement = null;
if( element == null )
{
newElement = null;
}
else
{
newElement = element.getOwnerDocument().createElement( name );
element.appendChild( newElement );
}
return newElement;
}

BillManager pbm = new BillManager( setup, con, mid, moduleSetup );

InvoiceManager pbm = new InvoiceManager( setup, con, mid, moduleSetup );

bill.pos.<код позиции>.summ=<вычисляемая сумма позиции>