BiTel

mps.8.search.multi=1
mps.8.search.mode=contract
mps.8.search.pattern=\A(\d{9})Z:::$1
mps.8.search.1.mode=login
mps.8.search.1.pattern=\A(\d+)\Z:::$1
mps.8.search.1.mid=1

mps.10.search.multi=1
mps.10.search.mode=contract
mps.10.search.pattern=\A(\d{9})Z:::$1
mps.10.search.1.mode=login
mps.10.search.1.pattern=\A(\d+)\Z:::$1
mps.10.search.1.mid=12

/bgbilling/mpsexecuter/8/10?command=check&txn_id=111111111&account=101080684&sum=500.00

<response>
<result>0</result>
<osmp_txn_id>111111111</osmp_txn_id>
<comment/>
</response>

/bgbilling/mpsexecuter/8/10?command=check&txn_id=111111111&account=78863&sum=500.00

<response>
<result>5</result>
<osmp_txn_id>111111111</osmp_txn_id>
<comment>Договор не найден [78863]</comment>
</response>

search = new SearchContractByInetLogin();

package ru.bitel.bgbilling.modules.mps.server.bean;
....
public class FindContractUtils

public static int findContractByLogin(Connection con, int mid, String login)
  {
    int result = 0;
    if ((mid > 0) && (!Utils.isEmptyString(login))) {
      try
      {
        try
        {
          int ilogin = Integer.parseInt(login);
          String query = "SELECT cid FROM user_login_" + mid + " WHERE login=? AND (date1 IS NULL OR date1<=NOW()) AND (date2 IS NULL OR date2>=NOW())";
          PreparedStatement ps = con.prepareStatement(query);
          ps.setInt(1, ilogin);
         
          ResultSet rs = ps.executeQuery();
          if (rs.next()) {
            result = rs.getInt(1);
          }
          ps.close();
        }
        catch (NumberFormatException localNumberFormatException) {}
        if (ServerUtils.tableExists(con, "user_alias_" + mid))
        {
          String query = "SELECT cid FROM user_alias_" + mid + " , user_login_" + mid +
            "   WHERE login_id=id AND login_alias=? AND (date1 IS NULL OR date1<=NOW()) AND (date2 IS NULL OR date2>=NOW())";
         
          PreparedStatement ps = con.prepareStatement(query);
          ps.setString(1, login);
         
          ResultSet rs = ps.executeQuery();
          if (rs.next()) {
            result = rs.getInt(1);
          }
          ps.close();
        }
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
    return result;
  }

mps.10.search.1.mode=login_inet

<response>
<result>300</result>
<comment>Сервис временно не работает</comment>
</response>