| | |
|---|
| | | int user_id = SpringMVCContextHolder.getCurrentUser().getUser_id(); |
|---|
| | | String queryFilter = queryFilterService.getQueryFilter(fs); |
|---|
| | | StringBuffer str = new StringBuffer(); |
|---|
| | | str.append("SELECT * FROM ( "); |
|---|
| | | str.append(" select lc.*,lcn.uuid flow_node_uuid from product_oa_cooperate_flow_node as lcn LEFT JOIN product_oa_cooperates as lc "); |
|---|
| | | str.append(" on lc.uuid=lcn.cooperate_uuid where lcn.receiver=? and lcn.status=? and sender_name is not null "); |
|---|
| | | if (!StringUtils.isEmpty(queryFilter)) { |
|---|
| | | str.append(" and ").append(queryFilter); |
|---|
| | | } |
|---|
| | | str.append(" ) a"); |
|---|
| | | DataTableEntity dt = baseDao.listTable(str.toString(), new Object[]{user_id, 2}, fs.getInteger(CmnConst.PAGESIZE), fs.getInteger(CmnConst.CPAGE)); |
|---|
| | | dt.getMeta().addAliasTable("product_oa_cooperates", "lc"); |
|---|
| | | dt.getMeta().addAliasTable("product_oa_cooperate_flow_node", "lcn"); |
|---|
