CRM邮箱配置调整

xinyb

6 天以前 ee2316e2cb7afde1c54f5e4216a1b0d1e055749e

 src/com/yc/crm/mail/action/MailFolder.java

@@ -1,5 +1,7 @@
package com.yc.crm.mail.action;

import com.yc.crm.mail.entity.FolderEntity;
import com.yc.crm.mail.entity.MailModuleBelowEntity;
import com.yc.crm.mail.entity.T482107Entity;
import com.yc.crm.mail.service.MailFolderIfc;
import com.yc.crm.mail.util.AllBackMsg;
@@ -7,13 +9,18 @@
import com.yc.multiData.MultiDataSource;
import com.yc.multiData.SpObserver;
import com.yc.utils.SessionKey;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

/**
 * @BelongsProject: eCoWorksV3
@@ -24,13 +31,17 @@
 */
@CrossOrigin
@RestController
@RequestMapping("/crm/Email/Folder/")
@RequestMapping("/crm/mail/folder")
public class MailFolder {

    /**
     * 要获取rowId直接调用接口 http://yingchen.onbus.cn:9010/getRowid.do
     */
    @Autowired
    MailFolderIfc mailFolderIfc;

    /**
     *添加邮件文件夹
     * 添加邮件文件夹
     *
     * @param folder
     * @param request
@@ -53,18 +64,28 @@
            folder.setUserName(userName);
            DataSourceEntity dataSource = MultiDataSource.getDataSourceMap(request);//获取数据源
            SpObserver.setDBtoInstance("_" + dataSource.getDbId());
            mailFolderIfc.saveFolder(folder);
            msg.setSuccess("执行成功", "已保存");
            String rowId = mailFolderIfc.saveFolder(folder);
            Map<String, Object> map = new HashMap<>();
            if (StringUtils.isNotBlank(rowId)) {
                map.put("cod", 0);
                map.put("rowId", rowId);
                msg.setSuccess("已保存", map);
            } else {
                map.put("cod", -1);
                map.put("msg", "保存后返回rowId出错");
                msg.setSuccess("已保存", map);
            }
        } catch (Exception e) {
            msg.setError("执行出错", e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
            msg.setFail(e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
        } finally {
            SpObserver.setDBtoInstance();
        }
        return msg;
    }


    /**
     *修改邮件文件夹
     * 修改邮件文件夹
     *
     * @param folder
     * @param request
@@ -72,16 +93,26 @@
     * @return
     */
    @PostMapping("/updateFolder.do")
    public AllBackMsg updateFolder(T482107Entity folder, HttpServletRequest request, HttpServletResponse response) {
    public AllBackMsg updateFolder(@RequestBody T482107Entity folder, HttpServletRequest request, HttpServletResponse response) {
        AllBackMsg msg = new AllBackMsg();
        try {
            if (folder.getFolderId() == null || folder.getFolderId().equals(0)) {
                msg.setFail("缺少文本夹ID值，请检查");
                return msg;
            }
            HttpSession session = request.getSession();
            String userCode = (String) session.getAttribute(SessionKey.USERCODE);
            if (StringUtils.isBlank(userCode)) {
                msg.setFail("登录用户已过期，请检查");
                return msg;
            }
            folder.setUserCode(userCode);
            DataSourceEntity dataSource = MultiDataSource.getDataSourceMap(request);//获取数据源
            SpObserver.setDBtoInstance("_" + dataSource.getDbId());
            mailFolderIfc.updateFolder(folder);
            msg.setSuccess("执行成功", "已更新");
            msg.setOk("已更新");
        } catch (Exception e) {
            msg.setError("执行出错", e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
            msg.setFail(e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
        } finally {
            SpObserver.setDBtoInstance();
        }
@@ -89,7 +120,7 @@
    }

    /**
     *删除邮件文件夹
     * 删除邮件文件夹
     *
     * @param account
     * @param request
@@ -100,20 +131,24 @@
    public AllBackMsg deleteFolder(@RequestParam(defaultValue = "0") Integer folderId, HttpServletRequest request, HttpServletResponse response) {
        AllBackMsg msg = new AllBackMsg();
        try {
            if (folderId == 0) {
            if (folderId.equals(0)) {
                msg.setFail("邮件文件夹编号ID获取不到");
                return msg;
            }
            HttpSession session = request.getSession();
            String userCode = (String) session.getAttribute(SessionKey.USERCODE);
            if (StringUtils.isBlank(userCode)) {
                msg.setFail("登录用户已过期，请检查");
                return msg;
            }
            DataSourceEntity dataSource = MultiDataSource.getDataSourceMap(request);//获取数据源
            SpObserver.setDBtoInstance("_" + dataSource.getDbId());
            Integer cont = mailFolderIfc.deleteFolder(userCode, folderId);
            if (cont > 0) {
                msg.setSuccess("执行成功", "已删除");
                msg.setOk("已删除");
            }
        } catch (Exception e) {
            msg.setError("执行出错", e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
            msg.setFail(e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
        } finally {
            SpObserver.setDBtoInstance();
        }
@@ -121,30 +156,105 @@
    }

    /**
     *
     *
     * @param search   搜索
     * @param request
     * @param response
     * @return
     */
    @GetMapping("/getFolder.do")
    public AllBackMsg getFolder(String folderName, HttpServletRequest request, HttpServletResponse response) {
    public AllBackMsg getFolder(HttpServletRequest request, HttpServletResponse response) {
        AllBackMsg msg = new AllBackMsg();
        try {
            HttpSession session = request.getSession();
            String userCode = (String) session.getAttribute(SessionKey.USERCODE);
            if (StringUtils.isBlank(userCode)) {
                msg.setFail("登录用户已过期，请检查");
                return msg;
            }
            DataSourceEntity dataSource = MultiDataSource.getDataSourceMap(request);//获取数据源
            SpObserver.setDBtoInstance("_" + dataSource.getDbId());
            List<T482107Entity> t482107Entities = mailFolderIfc.getMailFolder(folderName);
            List<T482107Entity> t482107Entities = mailFolderIfc.getMailFolder(userCode);
            if (t482107Entities.size() > 0) {
                msg.setSuccess("操作成功", t482107Entities);
                //返回树结构
                msg.setSuccess("执行成功", getFolderList(t482107Entities, ""));
            }
        } catch (Exception e) {
            msg.setError("执行出错", e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
            msg.setFail(e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
        } finally {
            SpObserver.setDBtoInstance();
        }
        return msg;
    }

    /**
     * 文件夹树结构
     *
     * @param t482107
     * @param rowId
     * @return
     */
    public static List<FolderEntity> getFolderList(List<T482107Entity> t482107, String rowId) {
        List<FolderEntity> folder = new ArrayList<>();
        try {
            for (T482107Entity t : t482107) {
                if (folder.stream().filter(f -> f.getParentRowId().equals(rowId)).count() == 0) {
                    List<T482107Entity> fo = t482107.stream().filter(o -> o.getParentRowId().equals(rowId)).collect(Collectors.toList());
                    if (fo.size() > 0) {
                        for (T482107Entity y : fo) {
                            FolderEntity folderEntity = new FolderEntity();
                            folderEntity.setFolderId(y.getFolderId());
                            folderEntity.setFolderName(y.getFolderName());
                            folderEntity.setRowId(y.getRowId());
                            folderEntity.setParentRowId(y.getParentRowId());
                            folderEntity.setTreeControl(y.getTreeControl());
                            if (!y.getRowId().equals(y.getParentRowId())) {
                                folderEntity.setList(getFolderList(t482107, y.getRowId()));
                            }
                            folder.add(folderEntity);
                        }
                    }
                }
            }
            return folder;
        } catch (Exception e) {
            throw e;
        }
    }

    /**
     * 文件夹树结构
     *
     * @param t482107
     * @param rowId
     * @return
     */
    public static List<MailModuleBelowEntity> getFolderModule(List<T482107Entity> t482107, String rowId) {
        List<MailModuleBelowEntity> folder = new ArrayList<>();
        try {
            for (T482107Entity t : t482107) {
                if (folder.stream().filter(f -> f.getParentKey().equals(rowId)).count() == 0) {
                    List<T482107Entity> fo = t482107.stream().filter(o -> o.getParentRowId().equals(rowId)).collect(Collectors.toList());
                    if (fo.size() > 0) {
                        for (T482107Entity y : fo) {
                            MailModuleBelowEntity folder1 = new MailModuleBelowEntity();
                            folder1.setId(y.getFolderId());
                            folder1.setType("folder");
                            folder1.setKey(y.getRowId());
                            folder1.setParentKey(y.getParentRowId());
                            folder1.setName(y.getFolderName());
                            if (!y.getRowId().equals(y.getParentRowId())) {
                                folder1.setList(getFolderModule(t482107, y.getRowId()));
                            }
                            folder.add(folder1);
                        }
                    } else {
                        break;
                    }
                }
            }
            return folder;
        } catch (Exception e) {
            throw e;
        }
    }
}