Examples with MessageAttachment com.bc.pmpheep.back.po.MessageAttachment used on opensource projects

Example 1 with MessageAttachment

use of com.bc.pmpheep.back.po.MessageAttachment in project pmph by BCSquad.

the class MigrationStageSeven method userMessage_messageAttachment.

public void userMessage_messageAttachment() {
    // case WHEN e.sysflag=0 then 1 when e.sysflag=1 and e.usertype=2 then 3 else 2 end
    String sql = "select " + "DISTINCT  " + "a.msgid , " + "a.msgcontent , " + "case WHEN a.msgtype =12  then  1         else 0 end msgtype , " + "a.msgtitle title, " + "case WHEN a.msgtype =12  then  d.new_pk  else 0   end senderid , " + "case WHEN a.msgtype =12 and d.sysflag=0 then 1 when a.msgtype=12 and d.sysflag=1 and d.usertype=2 then 3 when a.msgtype=12 then 2  else 0 end  sendertype ,  " + "ifnull(e.new_pk,f.new_pk)  receiverid, " + "case WHEN e.new_pk is null then case WHEN f.sysflag=0 then 1 when f.sysflag=1 and f.usertype=2 then 3 else 2 end " + "     else                       case WHEN e.sysflag=0 then 1 when e.sysflag=1 and e.usertype=2 then 3 else 2 end " + "end   receivertype, " + "case WHEN e.new_pk is null then a.recivetype " + "     else b.recivetype " + "end isread  , " + "0   iswithdraw, " + "b.isdelete  isdeleted, " + "b.senddate gt, " + "ifnull(b.recivedate,b.senddate) ut " + "from sys_messages a " + "LEFT JOIN sys_msgrecive b on b.msgid=a.msgid " + "LEFT JOIN (select a.userid,a.new_pk,a.sysflag,b.usertype from sys_user a left join sys_userext b on b.userid=a.userid )  d on  d.userid =a.formuser  " + "LEFT JOIN (select a.userid,a.new_pk,a.sysflag,b.usertype from sys_user a left join sys_userext b on b.userid=a.userid )  e on  e.userid =b.touser " + "LEFT JOIN (select a.userid,a.new_pk,a.sysflag,b.usertype from sys_user a left join sys_userext b on b.userid=a.userid )  f on  f.userid =a.touser ";
    // String tableName="";
    // JdbcHelper.addColumn(tableName); //增加new_pk字段
    List<Map<String, Object>> maps = JdbcHelper.getJdbcTemplate().queryForList(sql);
    List<Map<String, Object>> excel = new LinkedList<>();
    Map<String, String> msgidOldAndNew = new HashMap<String, String>(maps.size());
    Map<String, Object> result = new LinkedHashMap<>();
    // 模块名称
    excptionList.add(new Object[] { "消息" });
    // 模块标题
    excptionList.add(new Object[] { "消息标题", "问题", "原因分析", "处理方式" });
    int excptionListOldSize = excptionList.size();
    int count = 0;
    int correctCount = 0;
    int[] state = { 0, 0, 0, 0, 0, 0 };
    StringBuilder reason = new StringBuilder();
    StringBuilder dealWith = new StringBuilder();
    for (Map<String, Object> map : maps) {
        StringBuilder exception = new StringBuilder("");
        // 先保存这条记录
        String title = (String) map.get("title");
        if (StringUtil.isEmpty(title)) {
            map.put(SQLParameters.EXCEL_EX_HEADER, exception.append("消息标题查询到为空值。"));
            excptionList.add(new Object[] { "", "消息标题为空", "", "不导入该条数据" });
            excel.add(map);
            if (state[0] == 0) {
                reason.append("查询不到对应的消息。");
                dealWith.append("放弃迁移。");
                state[0] = 1;
            }
            continue;
        }
        Long senderid = (Long) map.get("senderid");
        if (ObjectUtil.isNull(senderid)) {
            map.put(SQLParameters.EXCEL_EX_HEADER, exception.append("发送者id查询到为空值。"));
            excptionList.add(new Object[] { title, "找不到对应的发送者", "清理了测试用户引起", "不导入该条数据" });
            excel.add(map);
            if (state[1] == 0) {
                reason.append("找不到消息的发送者。");
                dealWith.append("放弃迁移。");
                state[1] = 1;
            }
            continue;
        }
        Long receiverid = (Long) map.get("receiverid");
        if (ObjectUtil.isNull(receiverid)) {
            map.put(SQLParameters.EXCEL_EX_HEADER, exception.append("接收者id查询到为空值。"));
            excptionList.add(new Object[] { title, "找不到对应的接收者", "清理了测试用户引起", "不导入该条数据" });
            excel.add(map);
            if (state[2] == 0) {
                reason.append("找不到消息的接收者。");
                dealWith.append("放弃迁移。");
                state[2] = 1;
            }
            continue;
        }
        Short msgtype = new Short(String.valueOf(map.get("msgtype")));
        if (ObjectUtil.isNull(msgtype)) {
            map.put(SQLParameters.EXCEL_EX_HEADER, exception.append("消息类型查询到为空值。"));
            excptionList.add(new Object[] { title, "找不到对应的消息类型", "原平台最开始没有分类消息", "设置为'系统消息'类型导入新库表" });
            excel.add(map);
            msgtype = 0;
            if (state[3] == 0) {
                reason.append("找不到消息的类型。");
                dealWith.append("设为默认值迁入数据库。");
                state[3] = 1;
            }
        }
        Short sendertype = new Short(String.valueOf(map.get("sendertype")));
        if (ObjectUtil.isNull(sendertype)) {
            map.put(SQLParameters.EXCEL_EX_HEADER, exception.append("发送者类型查询到为空值。"));
            excptionList.add(new Object[] { title, "找不到对应的发送者类型", "", "设置为'系统消息'类型导入新库表" });
            excel.add(map);
            sendertype = 0;
            if (state[4] == 0) {
                reason.append("找不到发送者人员类型。");
                dealWith.append("设为默认值迁入数据库。");
                state[4] = 1;
            }
        }
        Short receivertype = new Short(String.valueOf((map.get("receivertype"))));
        if (ObjectUtil.isNull(receivertype)) {
            map.put(SQLParameters.EXCEL_EX_HEADER, exception.append("接收者类型查询到为空值。"));
            excptionList.add(new Object[] { title, "找不到对应的接收者类型", "", "设置为'系统消息'类型导入新库表" });
            excel.add(map);
            receivertype = 0;
            if (state[5] == 0) {
                reason.append("找不到消息接收者的人员类型。");
                dealWith.append("设为默认值迁入数据库。");
                state[5] = 1;
            }
        }
        Boolean isread = "1".equals(map.get("isread"));
        Boolean iswithdraw = "1".equals(map.get("iswithdraw"));
        Boolean isdeleted = "1".equals(map.get("isdeleted"));
        Timestamp gt = (Timestamp) map.get("gt");
        Timestamp ut = (Timestamp) map.get("ut");
        UserMessage userMessage = new UserMessage("---------", title, msgtype, senderid, sendertype, receiverid, receivertype, isread, iswithdraw, isdeleted, gt, ut);
        userMessage = userMessageSevice.addUserMessage(userMessage);
        count++;
        long pk = userMessage.getId();
        if (count % 1000 == 0) {
            // 打印进度
            logger.info("执行了:" + (count * 100.0) / maps.size() + "%");
        }
        // 对html里面内置的图片处理
        String msgid = String.valueOf(map.get("msgid"));
        // MongoDB对应主键
        String msg_id = msgidOldAndNew.get(msgid);
        if (StringUtil.isEmpty(msg_id)) {
            // 消息主体没有存入
            String msgcontent = (String) map.get("msgcontent");
            if (msgcontent.contains("img src=")) {
                List<String> srcs = JdbcHelper.getImgSrc(msgcontent);
                for (String src : srcs) {
                    try {
                        String mongoId = fileService.migrateFile(src.replace("/pmph_imesp", ""), FileType.MSG_IMG, pk);
                        msgcontent = msgcontent.replace(src, "/pmpheep/image/" + mongoId);
                    } catch (IOException ex) {
                        logger.warn("无法根据文章内容中的图片路径找到指定文件{}", ex.getMessage());
                    }
                }
            }
            Message message = new Message(msgcontent);
            message = messageService.add(message);
            msg_id = message.getId();
            msgidOldAndNew.put(msgid, msg_id);
            // 附件处理
            sql = "select c.* from sys_messages a  " + "LEFT JOIN (   " + "sELECT * FROM pub_addfileinfo WHERE tablename ='SYS_MESSAGES' AND childsystemname='sysNotice'   " + ")C ON C.tablekeyid = A.msgid where c.fileid is not null and  a.msgid =?";
            List<Map<String, Object>> message_attachments = JdbcHelper.getJdbcTemplate().queryForList(sql, new Object[] { msgid });
            for (Map<String, Object> message_attachment : message_attachments) {
                MessageAttachment messageAttachment = new MessageAttachment();
                messageAttachment.setMsgId(msg_id);
                messageAttachment.setAttachment("-----------");
                messageAttachment.setAttachmentName((String) message_attachment.get("filename"));
                messageAttachment = messageAttachmentService.addMessageAttachment(messageAttachment);
                String mongoId = null;
                try {
                    mongoId = fileService.migrateFile((String) message_attachment.get("fildir"), FileType.MSG_FILE, messageAttachment.getId());
                } catch (Exception e) {
                }
                if (null != mongoId) {
                    messageAttachment.setAttachment(mongoId);
                    messageAttachmentService.updateMessageAttachment(messageAttachment);
                }
            }
        }
        userMessage.setMsgId(msg_id);
        userMessageSevice.updateUserMessage(userMessage);
        if (null == map.get("exception")) {
            correctCount++;
        }
    }
    // 没有错误数据
    if (excptionList.size() == excptionListOldSize) {
        excptionList.remove(excptionList.size() - 1);
        excptionList.remove(excptionList.size() - 1);
    }
    if (excel.size() > 0) {
        try {
            excelHelper.exportFromMaps(excel, "消息-用户映射表（多对多）", "user_message");
        } catch (IOException ex) {
            logger.error("异常数据导出到Excel失败", ex);
        }
    }
    if (correctCount != maps.size()) {
        result.put(SQLParameters.EXCEL_HEADER_TABLENAME, "user_message");
        result.put(SQLParameters.EXCEL_HEADER_DESCRIPTION, "消息-用户映射表（多对多）");
        result.put(SQLParameters.EXCEL_HEADER_SUM_DATA, maps.size());
        result.put(SQLParameters.EXCEL_HEADER_MIGRATED_DATA, count);
        result.put(SQLParameters.EXCEL_HEADER_CORECT_DATA, correctCount);
        result.put(SQLParameters.EXCEL_HEADER_TRANSFERED_DATA, count - correctCount);
        result.put(SQLParameters.EXCEL_HEADER_NO_MIGRATED_DATA, maps.size() - count);
        result.put(SQLParameters.EXCEL_HEADER_EXCEPTION_REASON, reason.toString());
        result.put(SQLParameters.EXCEL_HEADER_DEAL_WITH, dealWith.toString());
        SQLParameters.STATISTICS_RESULT.add(result);
    }
    logger.info("'{}'表迁移完成，异常条目数量：{}", "sys_messages", excel.size());
    logger.info("原数据库中共有{}条数据，迁移了{}条数据", maps.size(), count);
    // 记录信息
    Map<String, Object> msg = new HashMap<>();
    msg.put("result", "sys_messages  表迁移完成" + count + "/" + maps.size());
    SQLParameters.STATISTICS.add(msg);
}

Example 2 with MessageAttachment

use of com.bc.pmpheep.back.po.MessageAttachment in project pmph by BCSquad.

the class UserMessageServiceImpl method getUserMessageById.

@Override
public Map<String, Object> getUserMessageById(Long userMsgId) {
    Map<String, Object> resultMap = new HashMap<String, Object>();
    if (ObjectUtil.isNull(userMsgId)) {
        throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.NULL_PARAM, "消息ID为空！");
    }
    UserMessage userMessage = userMessageDao.getUserMessageById(userMsgId);
    if (ObjectUtil.isNull(userMessage)) {
        throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.NULL_PARAM, "用户消息对象为空！");
    }
    String realName = null;
    if (Const.SENDER_TYPE_0 == userMessage.getSenderType() || Const.SENDER_TYPE_1 == userMessage.getSenderType()) {
        PmphUser pmphUser = pmphUserService.get(userMessage.getSenderId());
        realName = pmphUser.getRealname();
    }
    if (Const.SENDER_TYPE_2 == userMessage.getSenderType()) {
        WriterUser writerUser = writerUserService.get(userMessage.getSenderId());
        realName = writerUser.getRealname();
    }
    if (Const.SENDER_TYPE_3 == userMessage.getSenderType()) {
        OrgUser orgUser = orgUserService.getOrgUserById(userMessage.getSenderId());
        realName = orgUser.getRealname();
    }
    // 主键ID
    resultMap.put("msgId", userMessage.getId());
    // 标题
    resultMap.put("title", userMessage.getTitle());
    // 发送者
    resultMap.put("senderName", realName);
    // 发送时间
    resultMap.put("senderDate", userMessage.getGmtCreate());
    // 获取消息内容
    Message message = messageService.get(userMessage.getMsgId());
    if (ObjectUtil.notNull(message)) {
        // throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE,
        // CheckedExceptionResult.NULL_PARAM, "消息对象为空！");
        // 内容
        resultMap.put("content", message.getContent());
        List<MessageAttachment> messageAttachments = messageAttachmentService.getMessageAttachmentByMsgId(message.getId());
        if (CollectionUtil.isNotEmpty(messageAttachments)) {
            for (MessageAttachment mAttachment : messageAttachments) {
                String attachmentId = mAttachment.getAttachment();
                mAttachment.setAttachment(Const.FILE_DOWNLOAD + attachmentId);
            }
        }
        // 内容附件
        resultMap.put("MessageAttachment", messageAttachments);
    }
    return resultMap;
}

Example 3 with MessageAttachment

use of com.bc.pmpheep.back.po.MessageAttachment in project pmph by BCSquad.

the class UserMessageServiceImpl method saveFileToMongoDB.

/**
 * <pre>
 * 功能描述：保存文件到MongoDB
 * 使用示范：
 *
 * @param files 临时文件路径
 * @param msgId messageId
 * @throws CheckedServiceException
 * </pre>
 */
private void saveFileToMongoDB(HttpServletRequest request, String[] files, String msgId) throws IOException {
    // 添加附件到MongoDB表中
    if (ArrayUtil.isNotEmpty(files)) {
        for (int i = 0; i < files.length; i++) {
            byte[] fileByte = (byte[]) request.getSession(false).getAttribute(files[i]);
            String fileName = (String) request.getSession(false).getAttribute("fileName_" + files[i]);
            InputStream sbs = new ByteArrayInputStream(fileByte);
            String gridFSFileId = fileService.save(sbs, fileName, FileType.MSG_FILE, CastUtil.castLong(msgId));
            if (StringUtil.isEmpty(gridFSFileId)) {
                throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.FILE_UPLOAD_FAILED, "文件上传失败!");
            }
            // 保存对应数据
            MessageAttachment mAttachment = messageAttachmentService.addMessageAttachment(new MessageAttachment(msgId, gridFSFileId, fileName));
            if (ObjectUtil.isNull(mAttachment.getId())) {
                throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.NULL_PARAM, "MessageAttachment对象保存失败!");
            }
        // String localFile = files[i];
        // String fileDirectory =
        // localFile.substring(0, localFile.lastIndexOf(File.separatorChar));
        // FileUtil.delete(fileDirectory);// 删除本地临时文件
        }
    }
}

Example 4 with MessageAttachment

use of com.bc.pmpheep.back.po.MessageAttachment in project pmph by BCSquad.

the class UserMessageServiceImpl method updateMyMessageDetail.

@Override
public MyMessageVO updateMyMessageDetail(Long id) throws CheckedServiceException {
    if (ObjectUtil.isNull(id)) {
        throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.NULL_PARAM, "消息id为空！");
    }
    MyMessageVO myMessageVO = userMessageDao.getMyMessageDetail(id);
    switch(myMessageVO.getSenderType()) {
        case 0:
            myMessageVO.setSenderName("系统");
            break;
        case 1:
            PmphUser pmphUser = pmphUserService.get(myMessageVO.getSenderId());
            myMessageVO.setSenderAvatar(pmphUser.getAvatar());
            myMessageVO.setSenderName(pmphUser.getRealname());
            break;
        case 2:
            WriterUser writerUser = writerUserService.get(myMessageVO.getSenderId());
            myMessageVO.setSenderAvatar(writerUser.getAvatar());
            myMessageVO.setSenderName(writerUser.getRealname());
            break;
        case 3:
            // 现在没有机构用户
            break;
        default:
            throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.NULL_PARAM, "发送者类型不正确！");
    }
    Message message = messageService.get(myMessageVO.getMsgId());
    if (ObjectUtil.isNull(message)) {
        throw new CheckedServiceException(CheckedExceptionBusiness.MESSAGE, CheckedExceptionResult.NULL_PARAM, "没有获取到消息详情");
    }
    myMessageVO.setContent(message.getContent());
    List<MessageAttachment> messageAttachments = messageAttachmentService.getMessageAttachmentByMsgId(myMessageVO.getMsgId());
    for (MessageAttachment messageAttachment : messageAttachments) {
        messageAttachment.setAttachment(RouteUtil.MONGODB_FILE + messageAttachment.getAttachment());
    }
    myMessageVO.setMessageAttachments(messageAttachments);
    UserMessage userMessage = new UserMessage();
    userMessage.setId(id);
    userMessage.setIsRead(true);
    userMessageDao.updateUserMessage(userMessage);
    return myMessageVO;
}