BiTel

dynaction:contract.ActionUpdateContractLimit=ru.xxx.ActionUpdateContractLimit

package ru.xxx;
 
import java.sql.SQLException;
 
import ru.bitel.bgbilling.common.BGException;
import ru.bitel.bgbilling.common.BGMessageException;
import ru.bitel.common.Utils;
 
/**
 * Перегруженный экшен для проверки некоторых параметров:
 * 2. Скрипт реализующий запрет изменения "лимита" договора в случае если поле комментарий пустое.
 *
 * В конфиг сервера прописывается:
 * dynaction:contract.ActionUpdateContractLimit=ru.xxx.ActionUpdateContractLimit
 * @author dimon
 */
public class ActionUpdateContractLimit
   extends bitel.billing.server.contract.action.ActionUpdateContractLimit
{
   @Override
    public void doAction()
       throws SQLException, BGException
   {
      //[2]
      //module=contract
      //action=UpdateContractLimit
      //comment=%ED%E5%E3%E5%ED
      // получаем параметры как в экшене
      String comment = getParameter( "comment", "" );
      // если 1) комментарий пустой => ругаемся
      if( Utils.isBlankString( comment ) )
      {
         throw new BGMessageException( "Введите комментарий" );
      }
      // иначе вызываем родительский метод
      super.doAction();
   }
}

https://х.х.х.85:8443/bgbilling/executer?payed_type=1&module=bill&gr_mode=or&account_id=0&contract=&user_type=1&billNumber=&pageSize=0&package=0&from=&m=4&type=&BGBillingSecret=liYB7fiFPtU&until=&date_type=1&sort_mode=0&countOfBill=0&action=Bill&mid=9&gr=&secondary_sort_mode=-1&y=2014&
[ length = 551 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="221215CCE9B2B" status="ok"><table number="1" pageCount="1" pageIndex="1" pageSize="0" recordCount="1" summ="500.00"><data><row cid="966" contract="0000628" contract_and_comment="0000628 [ Фонд ]" create_dt="19.05.2014" createdby="Вн" id="3" number="j00000000002" pay_dt="" payedby="" status="не оплачен" summ="500.00" type="1" type_title="Счет" unload_status="не выгружен"/></data></table><separator separator=","/><pay pay="0"/></data>
https://х.х.х.85:8443/bgbilling/executer?mm=4&module=bill&parsed=1&action=BillPositionList&mid=9&BGBillingSecret=vqLH92UuFnI&
[ length = 384 ] xml = <?xml version="1.0" encoding="windows-1251"?><data secret="BAAC9CC2A3567D" status="ok"><positions><positionsCB><item id="1" title="Телематические услуги связи"/></positionsCB><pos extractor="" id="1" name="Телематические услуги связи за $nextmonth" qtyNumsAfterComma="" quantity="" summ="" title="Телематические услуги связи" unit="" unitCode=""/></positions></data>
https://х.х.х.85:8443/bgbilling/executer?module=bill&ids=3%3A966%3B&value=true&action=SetPayed&mid=9&date=19.05.2014&BGBillingSecret=pYeD8lhGWUoD4&

&action=SetPayed&

bitel.billing.server.bill.action.ActionSetPayed

package ru.skyb.scripts.action;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import bitel.billing.server.contract.bean.Contract;
import bitel.billing.server.contract.bean.ContractManager;
import ru.bitel.bgbilling.common.BGException;

public class ActionSetPayed
extends bitel.billing.server.bill.action.ActionSetPayed
{
   @Override
    public void doAction()
       throws SQLException, BGException
   {
      System.out.println(cid);
      super.doAction();
   }
}

String[] idm = ids.split( "\\s*[;,]\\s*" );
for( int i = 0; i < idm.length; i++ )
{
    String[] par = idm[i].split( ":" );
    int cid = par[1];
    int id = par[0];
}

package ru.skyb.scripts.action;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import bitel.billing.server.contract.bean.Contract;
import bitel.billing.server.contract.bean.ContractManager;
import ru.bitel.bgbilling.common.BGException;

public class ActionSetPayed
extends bitel.billing.server.bill.action.ActionSetPayed
{
   @Override
    public void doAction()
       throws SQLException, BGException
   {
      String[] idm = ids.split( "\\s*[;,]\\s*" );
      for( int i = 0; i < idm.length; i++ )
      {
           String[] par = idm[i].split( ":" );
          int cid = par[1];
          int id = par[0];
         System.out.println(cid);
      }
/*      super.doAction();
      ContractManager cm = new ContractManager (con);
      Contract c = cm.getContractById(cid);
*/
      

   }
}

String ids = getParameter("ids", "");

String[] idm = ids.split( "\\s*[;,]\\s*" );

ids - строка вида "id:cid; id:cid ", где id- код счета, cid-код договора.

package ru.skyb.scripts.action;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import bitel.billing.server.bill.bean.BillManager;
import bitel.billing.server.bill.bean.BillDoc;
import java.util.Date;

import bitel.billing.server.contract.bean.Contract;
import bitel.billing.server.contract.bean.ContractManager;
import ru.bitel.bgbilling.common.BGException;
import ru.bitel.bgbilling.kernel.event.EventProcessor;
import bitel.billing.server.bill.bean.BillManager;
import bitel.billing.server.bill.bean.AbstractManager;

public class ActionSetPayed
extends bitel.billing.server.bill.action.ActionSetPayed
{
   @Override
    public void doAction()
       throws SQLException, BGException
   {
      try
      {
      String title = getParameter("title", "");
      String pay = getParameter("value", "");
      ContractManager cm = new ContractManager (con);
      Contract c = cm.getContractByTitle(title);
      int cid = c.getId();
      System.out.println("Title " + title + " cid " + cid);
      //super.doAction();


      String query = "SELECT id, cid FROM bill_data_8 WHERE cid = 24323 AND unload_status = 0";
      PreparedStatement contractPs = con.prepareStatement(query);
      ResultSet contractRs = contractPs.executeQuery();
      while (contractRs.next())
         {
            int id = contractRs.getInt( 1 );
            BillManager bm = new BillManager(this.setup, this.con, this.mid, this.moduleSetup);
            System.out.println ("id " + id + " bm " + bm);
                 bm.setPayed( id+":"+cid,0,true,true,new Date(),null );
      }
                                      }catch (Exception e) {
               e.printStackTrace();
                  }
   }
}

06-02/22:26:38  INFO ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream - Title 900019 cid 24323
06-02/22:26:38  INFO ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream - id 2593 bm bitel.billing.server.bill.bean.BillManager@21746151
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1 AS bill_data LEFT JOIN bill_doc_type_-1 AS type ON bill_data.type=type.id WHE' at line 1
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.Util.getInstance(Util.java:386)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.bill.bean.BillManager.getBill(BillManager.java:728)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.bill.bean.BillManager.setPayed(BillManager.java:546)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.bill.bean.BillManager.setPayed(BillManager.java:538)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at ru.skyb.scripts.action.ActionSetPayed.doAction(ActionSetPayed.java:65)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doModule(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer$1.run(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.security.AccessController.doPrivileged(Native Method)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at javax.security.auth.Subject.doAs(Subject.java:396)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doPost(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doGet(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.lang.Thread.run(Thread.java:662)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream - java.lang.NullPointerException
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.bill.bean.BillManager.setPayed(BillManager.java:547)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.bill.bean.BillManager.setPayed(BillManager.java:538)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at ru.skyb.scripts.action.ActionSetPayed.doAction(ActionSetPayed.java:65)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doModule(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer$1.run(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.security.AccessController.doPrivileged(Native Method)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at javax.security.auth.Subject.doAs(Subject.java:396)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doPost(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.Executer.doGet(Unknown Source)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
06-02/22:26:38 ERROR ["http-bio-/0.0.0.0-8081"-exec-9] LoggingPrintStream -     at java.lang.Thread.run(Thread.java:662)