会员计划统计

String sql = "SELECT SUM(amount) amout FROM vip_account va WHERE user_id = ? AND is_cash = 0 AND fp_id IS NOT NULL"; List> list1 = queryDslJdbcTemplate.getJdbcOperations().queryForList(sql, userId); BigDecimal invest1 = list1.get(0).get("amout")!=null? (BigDecimal) list1.get(0).get("amout"):new BigDecimal(0);

    String sql2 = "SELECT SUM(ba.price_principal) total "
            + "FROM borrows_accept ba LEFT JOIN borrows b ON b.id=ba.bo_id "
            + "WHERE ba.user_id=? AND b.bo_is_success=1 AND ba.is_pay=0 AND ba.is_vip=0";
    List<Map<String,Object>> list2 = queryDslJdbcTemplate.getJdbcOperations().queryForList(sql2, userId);
    BigDecimal invest2 = list2.get(0).get("total")!=null? (BigDecimal) list2.get(0).get("total"):new BigDecimal(0);
    String sql5 = "SELECT SUM(amount_payed) total FROM vip_form vf"
            + " LEFT JOIN debt_transfer dt ON dt.id = vf.dt_id"
            + " WHERE vf.user_id = ?"
            + " AND vf.mode IN(8,9,10,11) AND dt.dt_rebuy_status = 0";
    List<Map<String,Object>> list4 = queryDslJdbcTemplate.getJdbcOperations().queryForList(sql5, userId);
    BigDecimal invest4 = list4.get(0).get("total")!=null? (BigDecimal) list4.get(0).get("total"):new BigDecimal(0);