package ru.ttk.billing.event.GlobalScript;

import bitel.billing.server.contract.bean.ContractManager;
import bitel.billing.server.tariff.TariffTreeSet;
import java.util.Calendar;
import java.util.GregorianCalendar;
import ru.bitel.bgbilling.kernel.script.server.dev.GlobalScriptBase;
import ru.bitel.bgbilling.server.util.Setup;
import ru.bitel.common.sql.ConnectionSet;

public class test extends GlobalScriptBase{
    @Override
    public void execute( Setup setup, ConnectionSet connectionSet )
            throws Exception{
        Calendar dt = new GregorianCalendar();
        int cid = 79343;
       
        TariffTreeSet tts = new ContractManager(connectionSet.getConnection()).getRealtimeTariffTreeSet(cid, dt, "npay", 7, true);

    }   
}

11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream - java.lang.InstantiationException: ru.bitel.bgbilling.modules.npay.tariff.server.CalculateModeTariffTreeNode
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at java.lang.Class.newInstance0(Class.java:340)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at java.lang.Class.newInstance(Class.java:308)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.tariff.TariffModuleTree.createNode(TariffModuleTree.java:206)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.tariff.TariffModuleTree.loadTree(TariffModuleTree.java:133)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.tariff.TariffModuleTree.load(TariffModuleTree.java:39)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.tariff.TariffTreeSet.getModuleTree(TariffTreeSet.java:51)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.tariff.TariffTreeSet.addTariffTree(TariffTreeSet.java:73)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.contract.bean.ContractManager.getRealtimeTariffTreeSet(ContractManager.java:656)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at bitel.billing.server.contract.bean.ContractManager.getRealtimeTariffTreeSet(ContractManager.java:597)
11-14/16:05:04 ERROR ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream -     at ru.ttk.billing.event.GlobalScript.test.execute(test.java:26)
....

TariffTreeSet tts = new ContractManager( connectionSet.getConnection() ).getRealtimeTariffTreeSet( cid, dt, "ipn", 4, true );

package ru.ttk.billing.event.GlobalScript;

import bitel.billing.common.TimeUtils;
import bitel.billing.server.npay.bean.ServiceObject;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Calendar;
import java.util.Collections;
import java.util.List;
import ru.bitel.bgbilling.kernel.script.server.dev.GlobalScriptBase;
import ru.bitel.bgbilling.kernel.tariff.tree.server.TariffModuleTree;
import ru.bitel.bgbilling.kernel.tariff.tree.server.TariffModuleTreeSet;
import ru.bitel.bgbilling.kernel.tariff.tree.server.TariffModuleTreeSetDao;
import ru.bitel.bgbilling.modules.npay.tariff.server.NPayTariffContext;
import ru.bitel.bgbilling.modules.npay.tariff.server.NPayTariffRequest;
import ru.bitel.bgbilling.server.util.Setup;
import ru.bitel.common.Preferences;
import ru.bitel.common.model.Period;
import ru.bitel.common.sql.ConnectionSet;

/**
 *
 * @author lda
 */
public class test extends GlobalScriptBase{
   
    @Override
    public void execute( Setup setup, ConnectionSet connectionSet )
            throws Exception{

        int cid = 79343;
        int mid = 7;
        Calendar dt = TimeUtils.clear_HOUR_MIN_MIL_SEC(Calendar.getInstance());
        Calendar startMonth = TimeUtils.getStartMonth( dt );
        Calendar endMonth = TimeUtils.getEndMonth( dt );     
        int daysInMonth = startMonth.getActualMaximum( Calendar.DAY_OF_MONTH );
        Connection con = connectionSet.getConnection();
        Connection conSlave = connectionSet.getSlaveConnection();
        try {       
            TariffModuleTreeSetDao tariffModuleTreeSetDao = new TariffModuleTreeSetDao( con );

            Preferences moduleSetup = setup.getModuleSetup( mid );
           
            NPayTariffContext context  = new NPayTariffContext( moduleSetup, con, mid, startMonth, endMonth, endMonth, String.valueOf(cid), null );
            context.setPrecalcOpenPeriod( new Period( TimeUtils.convertCalendarToDate( startMonth ), null ) );
           
            String query =
                "SELECT cid, sid, col, emid, eid " +
                "FROM npay_service_object_" + mid + " " +
                "WHERE (date1 IS NULL OR date1<=?) AND (date2 IS NULL OR date2>=?) ";
            query += " AND cid IN (" + cid + ")";
            query += " ORDER BY cid, sid";

            PreparedStatement ps = conSlave.prepareStatement( query );
            ps.setDate( 1, TimeUtils.convertCalendarToSqlDate( dt ) );
            ps.setDate( 2, TimeUtils.convertCalendarToSqlDate( dt ) );
            ResultSet rs = ps.executeQuery();
            while( rs.next() ){
                    ServiceObject serviceObject = new ServiceObject();

                    serviceObject.setContractId( rs.getInt( 1 ) );
                    serviceObject.setServiceId( rs.getInt( 2 ) );
                    serviceObject.setDate1( TimeUtils.convertCalendarToDate(startMonth ));
                    serviceObject.setDate2( TimeUtils.convertCalendarToDate(endMonth ) );
                    serviceObject.setCol( rs.getInt( 3 ) );
                    serviceObject.setEntityMid( rs.getInt( 4 ) );
                    serviceObject.setEntityId( rs.getInt( 5 ) );
                   
                    int emid = serviceObject.getEntityMid();
                    int eid = serviceObject.getEntityId();
                    int col = serviceObject.getCol();
                    int sid = serviceObject.getServiceId();
                   
                    Calendar serviceStart = TimeUtils.convertDateToCalendar( serviceObject.getDate1() );
                    Calendar serviceEnd = TimeUtils.convertDateToCalendar( serviceObject.getDate2() );
                   
                    Calendar date1 = (Calendar)serviceStart.clone();
                    Calendar date2 = (Calendar)serviceEnd.clone();
                   
                    TariffModuleTreeSet tts = tariffModuleTreeSetDao.getTariffTreeSetForDay(cid, dt, "npay", mid, emid, eid);
                    for( TariffModuleTreeSet.Entry tariffPeriod : tts.entries() ){
                        List<NPayTariffRequest.NPayServiceCost> serviceCostList = Collections.singletonList( new NPayTariffRequest.NPayServiceCost( sid, serviceStart, serviceEnd, date1, date2, col ) );
                        NPayTariffRequest req = new NPayTariffRequest( mid, cid, sid );
                        req.setInfoEnable( true );
                        req.setConnectionSet( connectionSet );
                        req.setAccountingMonthDays( daysInMonth );
                        req.setTime( date1 );

                        req.setServiceCost( sid,  serviceCostList);

                        final TariffModuleTree tree = tariffPeriod.getTree();

                        tree.execute( req, context );

                        if( req.isAccepted() ){
                            boolean isDayMode = req.toString().indexOf("Day mode") != -1;
                            for( NPayTariffRequest.NPayServiceCost serviceCost : req.getServiceCostList() ){
                                print("cost="+serviceCost.cost);
                                print("isDayMode="+isDayMode);
                            }
                        }
                    }
            }            
            ps.close();
            tariffModuleTreeSetDao.freeResources();
        }catch( Exception e ){
            e.printStackTrace();
        }
    }
}

SELECT p.id, p.title, mtree_node.type, sum(MID(DATA,13)) AS abon, SUBSTRING_INDEX(DATA, "%", 1) AS type
FROM tariff_plan AS p
LEFT JOIN tariff_tree_link ON tariff_tree_link.tpid=p.id
LEFT JOIN module_tariff_tree ON module_tariff_tree.tree_id=tariff_tree_link.tree_id AND module_tariff_tree.mid=5
LEFT JOIN mtree_node ON mtree_node.mtree_id=module_tariff_tree.id
WHERE mtree_node.type LIKE '%_cost'
GROUP BY p.id