История страницы

public class DebtorsTableResult
    extends AssistantActionBase
{
    @Override
    public AssistantResponse showAction( AssistantRequest assistantRequest1 )
    throws BGException, BGMessageException
    {
        this.assistantRequest = assistantRequest1;

		//получение введённых данных из предыдущего мастера
        JSONObject data = assistantRequest.getData().getJSONObject( "fields" );
        int balanceLimit = Integer.parseInt( data.getString( "correctSum" ) );
        LocalDate searchDate = LocalDate.parse( data.getString( "datePayment" ) );

		//передача данных в метод для работы с ними, который возвращает строкой JSON с пользовательскими объектами для отображения в таблице
        String result = getDataOfTable( balanceLimit, searchDate );
        assistantResponse.addFieldData( "debtorsTable", new AssistantKeyValue[]{ new AssistantKeyValue( "ru.bitel.bgbilling.assistant.contract.DebtorTableFilter", result )} );

        return super.showAction( assistantRequest );
    }

    private String getDataOfTable( int balanceLimit, LocalDate startSearchDate )
    {
        List<DebtorTableFilter> debtors = new ArrayList<>();
        Connection con = ServerContext.get( ServerContext.class ).getConnection();
        String query = "SELECT c.id, c.title, cp.dt FROM contract AS c "
                       + "LEFT JOIN contract_payment AS cp ON cp.cid=c.id WHERE cp.dt > ? GROUP BY cid ORDER BY cp.id DESC";

        try( PreparedStatement ps = con.prepareStatement( query ) )
        {
            ps.setDate( 1, Date.valueOf( startSearchDate ) );
            ResultSet rs = ps.executeQuery();

            while( rs.next() )
            {
                DebtorTableFilter debtor  = new DebtorTableFilter();
                debtor.setContractId( rs.getInt( "c.id" ) );
                debtor.setContractTitle( rs.getString( "c.title" ) );
                LocalDate localDate = rs.getDate( "cp.dt" ).toLocalDate();
                debtor.setLastPaymentDate( localDate.toString() );

                debtors.add( debtor );
            }
        }
        catch( SQLException e )
        {
            ClientUtils.showErrorMessageDialog( e );
        }

        //удаляем из результатов всех, у кого баланс выше заданного лимита
        BalanceUtils balanceUtils = new BalanceUtils( con );
        Iterator<DebtorTableFilter> iterator = debtors.iterator();
        while( iterator.hasNext() )
        {
            DebtorTableFilter deb = iterator.next();
            BigDecimal balance = balanceUtils.getBalance( new java.util.Date(  ), deb.getContractId() );
            if( balance.compareTo( new BigDecimal( balanceLimit ) ) >= 0 )
            {
                iterator.remove();
            }
            else
            {
                deb.setBalance( balance );
            }
        }

        //здесь остались только с отрицательным балансом и для всех договоров нужно взять почту и телефон
        for( DebtorTableFilter deb : debtors )
        {
            String query1 = "SELECT mail.email, phone.value FROM contract AS c LEFT JOIN contract_parameter_type_3 AS mail ON mail.cid=c.id LEFT JOIN contract_parameter_type_phone AS phone ON phone.cid=c.id WHERE c.id=?";
            try( PreparedStatement ps = con.prepareStatement(query1) )
            {
                ps.setInt(1, deb.getContractId() );

                ResultSet rs = ps.executeQuery();

                while( rs.next() )
                {
                    deb.setEmail( rs.getString( "mail.email" ) );
                    deb.setTelephone( rs.getString( "phone.value" ) );
                }
            }
            catch( SQLException ex )
            {
                ClientUtils.showErrorMessageDialog( ex );
            }
        }
				//с помощью этого метода мы можем сериализовать List объектов в строку JSON-формата 
        return AssistantUtils.mapperWrite( debtors );
    }
}

@JsonAutoDetect
public class DebtorsTableResultDebtorTableFilter
    extends AssistantActionBaseFilterTableModel
{
    @Overrideprivate int contractId;
  public AssistantResponse showAction(private AssistantRequestString assistantRequest1contractTitle;
)    private throwsString BGException,telephone;
BGMessageException    private {String email;
    private   this.assistantRequest = assistantRequest1String lastPaymentDate;
    private     JSONObject data = assistantRequest.getData().getJSONObject( "fields" )BigDecimal balance;

    @Override
  int balanceLimit = Integer.parseInt( data.getString( "correctSum" ) );public String getCorrectTitleColumn( int columnId )
    {
   LocalDate searchDate = LocalDate.parse( data.getString( "datePayment"  switch( columnId )
);        {
 String result = getDataOfTable( balanceLimit, searchDate );     case 0: return "ID assistantResponse.addFieldData( "debtorsTable", new AssistantKeyValue[]{ new AssistantKeyValue( "ru.bitel.bgbilling.assistant.contract.DebtorTableFilter", result )} );";
            case 1:    return super.showAction( assistantRequest )"Название";
    }      private String getDataOfTable(case int2: balanceLimit, LocalDate startSearchDate )return "Телефон";
      {      case 3:  List<DebtorTableFilter> debtors = new ArrayList<>()return "Почта";
        Connection con = ServerContext.get( ServerContext.class ).getConnection();
        String query = "SELECT c.id, c.title, cp.dt FROM contract AS c " case 4: return "Последняя оплата";
            case 5: return         + "LEFT JOIN contract_payment AS cp ON cp.cid=c.id WHERE cp.dt > ? GROUP BY cid ORDER BY cp.id DESC"Текущий баланс";
            default: return "<Неизвестный столбец>";
        }
try( PreparedStatement ps = con.prepareStatement(}
query
) )   @Override
    public {
            ps.setDate( 1, Date.valueOf( startSearchDate ) );String getCorrectData( int columnId )
    {
        ResultSet rs = ps.executeQuery()return null;
    }

    public int  while( rs.next(getContractId()
)             {
                DebtorTableFilter debtor  = new DebtorTableFilter()return contractId;
    }

    public void     debtor.setContractId( rs.getInt( "c.id"int contractId )
);    {
            debtor.setContractTitle( rs.getString( "c.title" ) );
                LocalDate localDate = rs.getDate( "cp.dt" ).toLocalDate()this.contractId = contractId;
    }

    public      debtor.setLastPaymentDate( localDate.toString() );String getContractTitle()
    {
             debtors.add( debtor )return contractTitle;
            }

    public   }
        catchvoid setContractTitle( SQLExceptionString econtractTitle )
        {
            ClientUtils.showErrorMessageDialog( e )this.contractTitle = contractTitle;
        }

    public    //удаляем из результатов всех, у кого баланс выше заданного лимита
        BalanceUtils balanceUtils = new BalanceUtils( con );String getTelephone()
        Iterator<DebtorTableFilter> iterator = debtors.iterator();
        while( iterator.hasNext() )
        {
            DebtorTableFilter deb = iterator.next()return telephone;
    }

    public  BigDecimal balance = balanceUtils.getBalancevoid setTelephone( new java.util.Date(  ), deb.getContractId() );String telephone )
    {
         if( balance.compareTo( new BigDecimal( balanceLimit ) ) >= 0 )this.telephone = telephone;
    }

    public   {
                iterator.remove();String getEmail()
            }
            else
            {
                deb.setBalance( balance )return email;
            }

    public   }

        //здесь остались только с отрицательным балансом и для всех договоров нужно взять почту и телефон
        for( DebtorTableFilter deb : debtors void setEmail( String email )
        {
            String query1 = "SELECT mailthis.email, phone.value FROM contract AS c LEFT JOIN contract_parameter_type_3 AS mail ON mail.cid=c.id LEFT JOIN contract_parameter_type_phone AS phone ON phone.cid=c.id WHERE c.id=?" email;
    }

    public String try( PreparedStatement ps = con.prepareStatement(query1getLastPaymentDate()
)             {
                ps.setInt(1, deb.getContractId() )return lastPaymentDate;
    }

    public       ResultSet rs = ps.executeQuery();

                while( rs.next() )
                void setLastPaymentDate( String lastPaymentDate )
    {
                    deb.setEmail( rs.getString( "mail.email" ) )this.lastPaymentDate = lastPaymentDate;
    }

    public          deb.setTelephone( rs.getString( "phone.value" ) );BigDecimal getBalance()
    {
        return balance;
  }             }

    public       catchvoid setBalance( SQLExceptionBigDecimal exbalance )
            {
                ClientUtils.showErrorMessageDialog( ex )this.balance = balance;
            }
        }

        return AssistantUtils.mapperWrite( debtors );
    }
}