BiTel

#код модуля
activate.login.service.1.mid=3
#список возможных тарифов, коды, через запятую
activate.login.service.1.tariffs=1

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

import bitel.billing.server.call.bean.CardCallUtils;
import bitel.billing.server.call.bean.LoginUtils;
import bitel.billing.server.card.bean.Card;
import bitel.billing.server.card.bean.CardManager;


int voiceipMid = 1;
int dialupMid = 2;
// кол-во одновременных сессий
int sessionCol = 1;

PreparedStatement ps = con.prepareStatement( "SELECT id FROM card_data_5 WHERE cid=? AND status=?" );
ps.setInt( 1, cid );
ps.setInt( 2, Card.CARD_ACTIVATE_CONTRACT );

ResultSet rs = ps.executeQuery();
if( rs.next() )
{
    int cardId = rs.getInt( 1 );

    CardManager cm = new CardManager( setup, mid );
    List<Card> cards = cm.getCards( String.valueOf( cardId ) );
    Card card = cards.get( 0 );

    // если нет dialup логина
    LoginUtils lu = LoginUtils.getLoginUtils( "dialup", con, dialupMid, setup );
    if( lu.getContractLogins( cid ).size() == 0 )
    {
        int loginId = new CardCallUtils( con, dialupMid ).createLogin( cid, card, sessionCol );
    }

    // если нет voiceip логина
    lu = LoginUtils.getLoginUtils( "voiceip", con, voiceipMid, setup );
    if( lu.getContractLogins( cid ).size() == 0 )
    {
        int loginId = new CardCallUtils( con, voiceipMid ).createLogin( cid, card, sessionCol );
    }
}

Eval error: Sourced file: inline evaluation of: ``import java.sql.Connection; import java.sql.PreparedStatement; import ja
va.sql.R . . . '' : Undefined argument: cid

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;

import bitel.billing.server.call.bean.CardCallUtils;
import bitel.billing.server.call.bean.LoginUtils;
import bitel.billing.server.card.bean.Card;
import bitel.billing.server.card.bean.CardManager;


int voiceipMid = 3;
int dialupMid = 1;
int cardMid = 11;

String cardTable = "card_data_" + String.valueOf( cardMid );
int cid = event.getContractID();

// кол-во одновременных сессий
int sessionCol = 1;

PreparedStatement ps = con.prepareStatement( "SELECT id FROM " + cardTable + " WHERE cid=? AND status=?" );
ps.setInt( 1, cid );
ps.setInt( 2, Card.CARD_ACTIVATE_CONTRACT );

ResultSet rs = ps.executeQuery();
if( rs.next() )
{
    int cardId = rs.getInt( 1 );

    CardManager cm = new CardManager( setup, cardMid );
    //List<Card> cards = cm.getCards( String.valueOf( cardId ) );
   List cards = cm.getCards( String.valueOf( cardId ) );
    Card card = (Card)cards.get( 0 );

    // если нет dialup логина
    LoginUtils lu = LoginUtils.getLoginUtils( "dialup", con, dialupMid, setup );
    if( lu.getContractLogins( cid ).size() == 0 )
    {
        int loginId = new CardCallUtils( con, dialupMid ).createLogin( cid, card, sessionCol );
    }

    // если нет voiceip логина
    lu = LoginUtils.getLoginUtils( "voiceip", con, voiceipMid, setup );
    if( lu.getContractLogins( cid ).size() == 0 )
    {
        int loginId = new CardCallUtils( con, voiceipMid ).createLogin( cid, card, sessionCol );
    }
}