代码保留

/**     * 新用户推荐关注     */    private void queryRecommendNewUsers() {        eb.consumer("lingjin.recommend.queryRecommendNewUsers", msg -> {            JsonObject data = (JsonObject) msg.body();            //分页            String start = data.getString("start");            String length = data.getString("length");            String cids = (String) data.remove("cids");            if (cids.contains("\"")) {                cids = StringUtils.substringBetween(cids, "\"", "\"");            }            String limit = " limit " + start + "," + length;            //查询条件            String uid = data.getString("uid");            JsonArray param = new JsonArray();            String sql = "select DISTINCT u.id,(select count(*) from " + u_follow + " uf where uf.uid=u.id and uf.fuid=" + uid + " and uf.status=1) ifFollow," +                    "(select count(*) from " + u_follow + " uf where uf.uid=" + uid + " and uf.fuid=u.id and uf.status=1) uifFollow," +                    "uc.company_full,uc.department_short,u.headimg,u.`name` " +                    "from " + o_recommend + " o," + u_card + " uc," + u_user + " u," + u_user_cat + " uuc" +                    " where uc.id=u.card_id and o.location=2 and o.edate>now() and o.sdate

now() and o.sdate<now() and u.id=o.aid and o.aid=uuc.uid and u.id!=" + uid + " and uuc.cid in (" + cids + ")";            queryPage(db, sql, csql, param, msg);        });    }

转载于:https://my.oschina.net/u/2523763/blog/608107