| | |
|---|
| | | * @author: ZhouJie |
|---|
| | | * @Description: 协同办公 |
|---|
| | | */ |
|---|
| | | @Component |
|---|
| | | @Service |
|---|
| | | public class CooperatesService extends AbstractBaseService implements ICooperatesService { |
|---|
| | | @Autowired |
|---|
| | |
|---|
| | | FieldSetEntity fse = baseDao.getFieldSetEntity(CmnConst.PRODUCT_OA_COOPERATES, fs.getString(CmnConst.UUID), true); |
|---|
| | | DataTableEntity copsub = fse.getSubDataTable(CmnConst.PRODUCT_OA_COOPERATE_SUB); |
|---|
| | | baseDao.loadPromptData(copsub); |
|---|
| | | |
|---|
| | | for (int i = 0; i <copsub.getRows() ; i++) { |
|---|
| | | String userId = copsub.getString(i, "created_by_save_value"); |
|---|
| | | String userAvatar = userService.getUserAvatar(userId); |
|---|
| | | if (!StringUtils.isEmpty(userAvatar)) { |
|---|
| | | copsub.setFieldValue(i, "avatar", userAvatar); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | StringBuilder stringBuilder = new StringBuilder(); |
|---|
| | | stringBuilder.append(" select ifnull(concat(tricode,'-',receiver) ,receiver) code,uuid,title,cooperate_uuid,grade,receiver as id,receiver,sender, "); |
|---|
| | | stringBuilder.append(" receiver_name,(select user_name FROM product_sys_users where user_id=receiver) label,sender_name,status, "); |
|---|
| | |
|---|
| | | if (!StringUtils.isEmpty(queryFilter)) { |
|---|
| | | str.append(" and ").append(queryFilter); |
|---|
| | | } |
|---|
| | | str.append(" ) a"); |
|---|
| | | str.append(" order by start_time desc) 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"); |
|---|
