shestakow1993

import bitel.billing.common.TimeUtils;
import bitel.billing.server.ActionBase;
import bitel.billing.server.call.bean.Login;
import bitel.billing.server.contract.bean.Contract;
import bitel.billing.server.contract.bean.ContractManager;
import bitel.billing.server.dialup.bean.DialUpLogin;
import bitel.billing.server.dialup.bean.DialUpLoginManager;
import bitel.billing.server.processor.dialup.DialUpSessionRealtime;
import org.json.JSONObject;

shestakow1993

При авторизации


radius 11-25/17:57:17  INFO [rdsLstnr-p-7-t-7] InetRadiusListenerWorker - RESPONSE (6ms):
Packet type: Access-Accept
Identifier: 87
Authenticator: {F4 BA D1 4D 1F 1A 4F F9 C5 96 33 F8 AA A1 44 E5}
Attributes:
  Framed-IP-Address=10.10.10.164
  Filter-Id=1

shestakow1993

package ru.bgcrm.dyn;


import org.apache.http.HttpResponse;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.DefaultHttpClient;
import ru.bgcrm.event.Event;
import ru.bgcrm.event.listener.DynamicEventListener;
import ru.bgcrm.event.process.ProcessChangedEvent;

shestakow1993

/**
 * Sends notifications with params from enum  @SlackChats.class
 */
public class Notification {
    /**
     *
     * @param message string messages text
     * @param slackChats CONSTANT from SlackChat
     */
    public static void sendMessage(String message, SlackChats slackChats){

shestakow1993

import java.sql.Connection;

import java.util.Arrays;
import java.util.Calendar;
import java.util.List;
import javax.jws.WebService;

shestakow1993

select address_house.id as id, address_area.title as address, address_street.title as street,address_house.house as house from address_street
left join address_house on address_house.streetid=address_street.id
LEFT JOIN address_area on address_area.id=address_house.areaid
LEFT JOIN address_config on address_config.record_id=address_house.id
WHERE address_street.cityid=2 and address_area.id !=54
ORDER BY address_area.title,address_street.title,address_house.house;

shestakow1993

import java.sql.Connection;
import java.util.Date;
import java.util.GregorianCalendar;

public class RecalculationAfterDeleteOrDeactivate extends EventScriptBase {
@Override
public void onEvent(Event event, Setup setup, ConnectionSet set) throws Exception {
	
	ContractTariffOptionChangedEvent e =(ContractTariffOptionChangedEvent)event;
	Connection con=set.getConnection();

shestakow1993

INFO [main] DefaultServerSetup - Binding javax.jms.ConnectionFactory[org.apache.activemq.ActiveMQConnectionFactory@5c30cc] to java:comp/env/mq/connectionFactory
05-24/17:23:43  INFO [main] DefaultServerSetup - Init DB connection pools
05-24/17:23:43  INFO [main] DefaultServerSetup - Binding JDBC pool "master" to java:comp/env/jdbc/master
05-24/17:23:43  INFO [main] AnnotatedMBean - Register MBean ru.bitel.bgbilling.server.dbcp:type=DatabaseConnectionPool,name=master
05-24/17:23:44  INFO [main] DefaultServerSetup - Init trash pools...
05-24/17:23:44 ERROR [main] LoggingPrintStream - java.sql.SQLException: Column 'domainIds' not found.
05-24/17:23:44 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
05-24/17:23:44 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
05-24/17:23:44 ERROR [main] LoggingPrintStream -        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
05-24/17:23:44 ERRO

shestakow1993

select TABLE_NAME from information_schema.TABLES WHERE TABLE_TYPE='BASE TABLE' and TABLE_SCHEMA ='bgbilling' and TABLE_NAME LIKE 'pattern1%'INTO OUTFILE '/tmp/passwdp1.txt' ;
select TABLE_NAME from information_schema.TABLES WHERE TABLE_TYPE='BASE TABLE' and TABLE_SCHEMA ='bgbilling' and TABLE_NAME LIKE 'pattern2%'INTO OUTFILE '/tmp/passwdp2.txt' ;
....
....
select TABLE_NAME from information_schema.TABLES WHERE TABLE_TYPE='BASE TABLE' and TABLE_SCHEMA ='bgbilling' and TABLE_NAME LIKE 'patternN%'INTO OUTFILE '/tmp/passwdpn.txt' ;

shestakow1993

Connection connection = connectionSet.getConnection();
		ObjectManager objectManager =new ObjectManager(connection);
		
		int objectId = 3689;
		ContractObject yearContracrtDiscountObjeckt= objectManager.getObject(objectId);
		yearContracrtDiscountObjeckt.setDate2(TimeUtils.convertDateToCalendar(new Date()));
		System.out.println(yearContracrtDiscountObjeckt.getContractId()+" ");