package ru.rta.bgbilling.inet;

import ru.bitel.bgbilling.kernel.container.managed.ServerContext;
import ru.bitel.bgbilling.kernel.event.EventProcessor;
import ru.bitel.bgbilling.kernel.script.server.dev.GlobalScriptBase;
import ru.bitel.bgbilling.server.util.Setup;
import ru.bitel.common.sql.ConnectionSet;
import java.sql.*;
import java.util.*;
import ru.bitel.oss.systems.inventory.resource.server.bean.DevicePortSubscriptionDao;
import bitel.billing.common.TimeUtils;

public class test2
   extends GlobalScriptBase
{
int device_type_id_bill;

   @Override
   public void execute( Setup setup, ConnectionSet connectionSet )
      throws Exception
   {
Calendar date = Calendar.getInstance();
java.sql.Date sqldate = TimeUtils.convertCalendarToSqlDate(date);

Connection con = connectionSet.getConnection();
DevicePortSubscriptionDao dpsd = new DevicePortSubscriptionDao(con, 15);
if(dpsd.list(558, 2, sqldate, sqldate).size() > 0){print("занят");} //(int deivceid, int port, sqldateFrom, sqldateTo)
else{print("свободен");}

   }
}

ServerContext context = ServerContext.get();   
DeviceInterfaceService deviceService =  context.getService( DeviceInterfaceService.class, INET_MODULE_ID );
if ( deviceService.devicePortSubscriptionList( ... ).size() > 0 )
{
   print("занят")
}