附件和图片的浏览下载（针对邮件）

xinyb

2024-09-19 95fe959933ca26c25f23ebf17f590dbdf7c7fbbf

附件和图片的浏览下载（针对邮件）

 WebRoot/WEB-INF/web.xml

@@ -196,6 +196,16 @@
</filter-mapping>

<filter>
    <filter-name>mailImageFilter</filter-name>
    <filter-class>com.yc.crm.mail.listener.EmailImageFilter</filter-class>
    <async-supported>true</async-supported>
</filter>
<filter-mapping>
    <filter-name>mailImageFilter</filter-name>
    <url-pattern>/uploads/email/*</url-pattern>
</filter-mapping>

<filter>
    <filter-name>formidFilter</filter-name>
    <filter-class>com.yc.action.build.FormidFilter</filter-class>
    <async-supported>true</async-supported>

 src/com/yc/crm/mail/listener/EmailImageFilter.java

New file
@@ -0,0 +1,187 @@
package com.yc.crm.mail.listener;

import com.yc.crm.mail.service.MailFileIfc;
import com.yc.factory.FactoryBean;
import com.yc.sdk.shopping.entity.ImageEntity;
import com.yc.sdk.shopping.entity.ImageUrlParametersEntity;
import com.yc.sdk.shopping.util.SettingKey;
import org.apache.catalina.connector.ClientAbortException;
import org.springframework.stereotype.Component;
import org.springframework.util.FileCopyUtils;

import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.*;


/**
 * @BelongsProject: eCoWorksV3
 * @BelongsPackage: com.yc.crm.mail.listener
 * @author: xinyb
 * @CreateTime: 2024-09-14  17:10
 * @Description:
 */
@Component
public class EmailImageFilter implements Filter {

    @Override
    public void init(FilterConfig filterConfig) throws ServletException {
        Filter.super.init(filterConfig);
    }

    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        HttpServletRequest request = (HttpServletRequest) servletRequest;
        HttpServletResponse response = (HttpServletResponse) servletResponse;
        String reqUri = request.getRequestURI();

        String hostUrl = SettingKey.getHostUrl(request);
        String queryString = request.getQueryString();

        HttpSession session = request.getSession();
        String rootPath = session.getServletContext().getRealPath("/");
        ImageUrlParametersEntity imageUrlParametersEntity = getImageUrlParameters(reqUri);
        File file = new File(rootPath.substring(0, rootPath.length() - 1) + reqUri);
        try {
            if (file != null && file.exists()) {
                filterChain.doFilter(request, response);
                return;
            }

            MailFileIfc mailFileIfc= (MailFileIfc) FactoryBean.getBean("MailFileImpl");
            ImageEntity image = mailFileIfc.getImageFile(
                    imageUrlParametersEntity.getUnids(),
                    imageUrlParametersEntity.getWidth(),
                    imageUrlParametersEntity.getHeight(),
                    (imageUrlParametersEntity.getWidth() == null
                            && imageUrlParametersEntity.getHeight() == null ? true : false),
                    request, imageUrlParametersEntity.getAttachmentPath(), imageUrlParametersEntity.getFormidPath());
            if (image == null) {
                System.out.println("输出缩略图时出错,出错文件reqUri：" + hostUrl + reqUri + (queryString != null && !"".equals(queryString) ? "?" + queryString : ""));
                return;
            }

            if (image != null && image.getOriginalFileName() != null && (
                    image.getOriginalFileName().toLowerCase().endsWith(".pdf")
                            || image.getOriginalFileName().toLowerCase().endsWith(".doc")
                            || image.getOriginalFileName().toLowerCase().endsWith(".xls")
                            || image.getOriginalFileName().toLowerCase().endsWith(".ppt")
                            || image.getOriginalFileName().toLowerCase().endsWith(".docx")
                            || image.getOriginalFileName().toLowerCase().endsWith(".xlsx")
                            || image.getOriginalFileName().toLowerCase().endsWith(".pptx")
            )) {
                //不是图片格式，附件打开预览会自动下载，在这里处理直接跳过下面的生成输出流 by danaus 2023-07-10 09:49
                filterChain.doFilter(request, response);
                return;
            } else {
                //图片格式，直接显示
                response.setStatus(HttpServletResponse.SC_OK);
                InputStream is = null;
                try {
                    is = new FileInputStream(image.getFile());
                    //设置页面另存为时的文件名
                    response.setHeader("Content-Disposition", "inline; filename="
                            + (image != null && image.getOriginalFileName() != null ? new String(image.getOriginalFileName().getBytes("utf-8"), "ISO_8859_1") : ""));
                    String type = "image/";
                    //输出流
                    response.setContentType(type + image.getFileType());
                    OutputStream output = response.getOutputStream();
                    try {
                        FileCopyUtils.copy(is, output);
                    } catch (ClientAbortException | IllegalStateException e) {
                        System.out.println(getClass() + " reqUri:" + reqUri + ", Error:" + e.getMessage());
                    }
                    return;
                    // 这里不能再执行   chain.doFilter(request, response) ， 因为是新生成的文件，如果用  chain.doFilter 输出，则浏览器收到 404 文件不存的错误 ，
                    // 为了解决这个问题，使用  response 流 Stream 输出解决
                    //chain.doFilter(request, response);
                } catch (Exception e) {
                    System.out.println("输出缩略图时出错,出错文件reqUri：" + hostUrl + reqUri + (queryString != null && !"".equals(queryString) ? "?" + queryString : "") + ",错误原因:" + (e.getCause() != null ? e.getCause().getMessage() : e.getMessage()));
                    e.printStackTrace();
                } finally {
                    try {
                        if (is != null) is.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
            }
        } catch (Exception e) {
            servletResponse.setContentType("text/html;charset=utf-8");
            PrintWriter out = servletResponse.getWriter();
            out.print(e.getCause() != null ? e.getCause().getMessage() : e.getMessage());
            out.flush();
            out.close();
        }
    }

    /**
     * 获取图片宽度和高度参数
     *
     * @param fileName
     * @return
     */
    private ImageUrlParametersEntity getImageUrlParameters(String reqUri) {
        ImageUrlParametersEntity imageUrlParametersEntity = new ImageUrlParametersEntity();
        String str[] = reqUri.split("/");
        if (str.length >= 5) {
            String attachmentPath = str[2];  //imageUrlParametersEntity
            String dbId = str[3];  //数据库连接 ID

            String formidPath = str[4];  //功能号，如果是 shopping ,则对应的是 images 值
            String fileName = str[5];   //文件名

            int pos = fileName.indexOf(".");   //去掉扩展名
            String unids = "";       //获取 unid 名字
            String fileType = "";  //文件扩展名
            if (pos < 0) {
                unids = fileName;
            }
            if (pos >= 0) {
                unids = fileName.substring(0, pos);
                fileType = fileName.substring(pos + 1, fileName.length());
            }

            pos = unids.indexOf("_");   //从 size 处截断
            Integer width = null;
            Integer height = null;
            if (pos > 0) {
                String size = unids.substring(pos + 1, unids.length());   //取下划线后面的 size
                String w[] = size.split("x");
                if (w != null && w.length > 0) {
                    width = Integer.parseInt(w[0]);
                    height = Integer.parseInt(w[1]);

                }
                unids = unids.substring(0, pos);   //再次取 unid（ 去掉 size ）
            }
            imageUrlParametersEntity.setDbId(dbId);
            imageUrlParametersEntity.setFileName(fileName);
            imageUrlParametersEntity.setUnids(unids);
            imageUrlParametersEntity.setFileType(fileType);
            imageUrlParametersEntity.setWidth(width);
            imageUrlParametersEntity.setHeight(height);
            imageUrlParametersEntity.setAttachmentPath(attachmentPath);
            imageUrlParametersEntity.setFormidPath(formidPath);


            String unid = "", seq = "";
            String unidStr[] = unids.split(SettingKey.NAVSPLIT);   //
            unid = unidStr[0];
            imageUrlParametersEntity.setUnid(unid);
            if (unidStr.length > 1) {
                String seqs[] = unidStr[1].split(";");
                seq = seqs[seqs.length - 1];   //只取最后一个 seq , 因为有时候传过来的值是:  7394;7382 ,如果不处理会导致语法错误
                imageUrlParametersEntity.setMailSeq(seq);
            }
        }
        return imageUrlParametersEntity;
    }

    @Override
    public void destroy() {
        Filter.super.destroy();
    }
}

 src/com/yc/crm/mail/service/MailFileIfc.java

New file
@@ -0,0 +1,45 @@
package com.yc.crm.mail.service;

import com.yc.crm.mail.entity.MailFileEntity;
import com.yc.entity.attachment.AttachmentEntity;
import com.yc.sdk.shopping.entity.ImageEntity;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

public interface MailFileIfc {

    /**
     * 附件保存
     *
     * @param unIdFile
     */
    abstract void saveAttachment(List<MailFileEntity> mailFile);

    /**
     * 邮件附件的调用处理
     *
     * @param unid
     * @return
     */
    abstract List<AttachmentEntity> getAttachmentEntityList(String unIdSeq);

    /**
     * 删除附件
     *
     * @param unId
     * @return
     */
    abstract Integer deleteAttachment(List<String> unId);

    /**
     * 获取图片实体对象 File
     * @param unid
     * @param rootPath
     * @param dbId
     * @return
     */
    public ImageEntity getImageFile(String unid, Integer width, Integer height, boolean isShowOrgImage, HttpServletRequest request, String attachmentPath, String formidPath ) throws Exception;


}

 src/com/yc/crm/mail/service/MailFileImpl.java

New file
@@ -0,0 +1,304 @@
package com.yc.crm.mail.service;

import com.yc.action.grid.GridUtils;
import com.yc.crm.mail.entity.MailFileEntity;
import com.yc.entity.DataSourceEntity;
import com.yc.entity.attachment.AttachmentEntity;
import com.yc.multiData.MultiDataSource;
import com.yc.sdk.shopping.entity.ImageEntity;
import com.yc.sdk.shopping.entity.ShoppingImageEntity;
import com.yc.sdk.shopping.util.BlobToFile;
import com.yc.sdk.shopping.util.SettingKey;
import com.yc.service.BaseService;
import com.yc.utils.ImageUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.jdbc.LobRetrievalFailureException;
import org.springframework.jdbc.core.support.AbstractLobStreamingResultSetExtractor;
import org.springframework.jdbc.support.lob.DefaultLobHandler;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
 * @BelongsProject: eCoWorksV3
 * @BelongsPackage: com.yc.crm.mail.service
 * @author: xinyb
 * @CreateTime: 2024-09-19  10:19
 * @Description:邮件附件或图片处理
 */
@Service("MailFileImpl")
public class MailFileImpl extends BaseService implements MailFileIfc {
    private final ShoppingImageEntity shoppingImage =  new ShoppingImageEntity() ;
    @Autowired
    private DefaultLobHandler defaultLobHandler;
    @Override
    public void saveAttachment(List<MailFileEntity> mailFile) {
        try {

        } catch (Exception e) {
            throw e;
        }
    }


    @Override
    public List<AttachmentEntity> getAttachmentEntityList(String unIdSeq) {
        String unId = null;
        if (StringUtils.isBlank(unIdSeq)) {
            return null;
        }
        String[] array = unIdSeq.split(";");
        unId = array[0];//在有值时候第一个必定是unId
        ArrayList<String> fieldId = new ArrayList<>(Arrays.asList(array));
        fieldId.remove(0);//去掉第一个元素（UNID）
        String sql = " set nocount on \n"
                + " declare @unid varchar(50) = " + GridUtils.prossSqlParm(unId) +
                ",@fieldid varchar(1000) = " + GridUtils.prossSqlParm(StringUtils.join(fieldId, ",")) + " \n";

        sql += " select UNID,seq,DocCode,RowId,FieldId,FormId, \n"
                + " PhysicalPath,PhysicalFile,OriginalFileName,FileSize,FileType, \n"
                + " AuthorCode,AuthorName,SmallPicPath,UploadTime,OriginalPicture \n"
                + " from _sys_Attachment \n"
                + " where unid = @unid ";
        if (fieldId.size() > 0) {
            if (isNumeric(fieldId.get(0))) {
                sql += " and seq in(select list from GetInStr(@fieldid)) \n";
            } else {
                sql += " and fieldid in(select list from GetInStr(@fieldid)) \n";
            }
        }
        List<Map<String, Object>> list = this.jdbcTemplate.queryForList(sql);
        List<AttachmentEntity> attachmentList = new ArrayList<AttachmentEntity>();
        for (int i = 0; list != null && i < list.size(); i++) {
            AttachmentEntity attachment = new AttachmentEntity();
            attachment.setUnid(unId);
            attachment.setPhysicalFile(list.get(i).get("PhysicalFile") == null ? null : (String) list.get(i).get("PhysicalFile"));
            attachment.setOriginalFileName(list.get(i).get("OriginalFileName") == null ? null : (String) list.get(i).get("OriginalFileName"));
            attachment.setOriginalPicture(list.get(i).get("OriginalPicture") == null ? null : (byte[]) list.get(i).get("OriginalPicture"));  //附件处理
            attachmentList.add(attachment);
        }
        return attachmentList;
    }



    @Transactional(rollbackFor = Exception.class)
    @Override
    public Integer deleteAttachment(List<String> unId) {
        try {
            if (unId == null || unId.size() == 0) {
                return 0;
            }
            String sql = " set nocount on \n"
                    + " declare @unid varchar(4000) = '" + StringUtils.join(unId, ",") + "'  \n";
            sql += "delete _sys_Attachment where unid in (select list from GetInStr(@unid)) \n";
            sql += "select @@ROWCOUNT";
            return jdbcTemplate.queryForObject(sql, Integer.class);
        } catch (Exception e) {
            throw e;
        }
    }

    @Override
    public ImageEntity getImageFile(String unid, Integer width, Integer height, boolean isShowOrgImage, HttpServletRequest request, String attachmentPath, String formidPath) throws Exception {
        HttpSession session = request.getSession();
        if (unid == null || "".equals(unid)) {
            // this.print(response, "获取图片时，必须传递参数 " + SettingKey.UNID);
            return null;
        }
        if (isShowOrgImage) {
            width = null;
            height = null;
        }
        ShoppingImageEntity shoppingImageEntity = null ;
        DataSourceEntity dataSourceEntity = null;
        try {
            dataSourceEntity = MultiDataSource.getDataSourceMap( request) ;
            if (dataSourceEntity == null) {
                throw new Exception("没有找到数据源，获取图片文件失败!" ) ;
            }

            String rootPath = session.getServletContext().getRealPath("/");
            //String uuid = UUID.randomUUID().toString().toUpperCase();

            shoppingImageEntity = getImage( unid,rootPath ,dataSourceEntity.getDbId(),attachmentPath,formidPath);

            if (shoppingImageEntity == null || shoppingImageEntity.getImage() == null) {
                return null;
            }

            //取原图路径
            String shoppingImageFileName = SettingKey.getShoppingImageFileName(rootPath,unid, width,height, isShowOrgImage, dataSourceEntity.getDbId()+"", shoppingImageEntity.getFileType(),attachmentPath,formidPath);
            File file = shoppingImageEntity.getImage();

            if (file != null) {

                if (width != null && height != null && shoppingImageEntity.getFileType()!=null
                        //图片文件才缩放，否则会报错
                        && StringUtils.containsAny(shoppingImageEntity.getFileType().toLowerCase(),"jpg","png","gif","jpeg","tiff","bmp","raw","tga","fpx","webp")) {
                    // 缩放图片
                    ImageUtils.scale(file.getPath(), shoppingImageFileName, width, height);
                } else {
                    shoppingImageFileName = file.getPath(); // 不缩放
                }
                ImageEntity image = new ImageEntity();
                image.setFile(new File(shoppingImageFileName));
                image.setFileType(shoppingImageEntity.getFileType());
                image.setOriginalFileName(shoppingImageEntity.getOriginalFileName());
                return image;
            }
        } catch (IOException e) {
            System.out.println("输出缩略图时出错,出错文件名：" + (shoppingImageEntity!=null?shoppingImageEntity.getPhysicalFile():"") +  (dataSourceEntity!=null?"dbid:["+dataSourceEntity.getDbId() + "],系统名称：["+ dataSourceEntity.getSystemDescribe()+"]":"") );
            throw e;
        }catch (Exception e) {
            throw e ;
        } finally {
            //if (width != null && height != null && file != null && file.exists())
            //    file.delete();
        }
        return null;
    }

    private ShoppingImageEntity getImage(String unids, String rootPath, int dbId, String attachmentPath, String formidPath) {
        if  (unids == null || "".equals(unids))  return null ;
        String unid = "" ,mailSeq = "" ;
        String unidStr[] = unids.split(SettingKey.NAVSPLIT) ;   //
        unid = unidStr[0] ;
        if (unidStr.length > 1 ) {
            String seqs[] = unidStr[1].split(";") ;
            mailSeq = seqs[seqs.length-1];   //只取最后一个 seq , 因为有时候传过来的值是:  7394;7382 ,如果不处理会导致语法错误
        }

        String sql = " set nocount on ; \n"
                + " declare @myrowcount int,@myerror int \n"
                + " declare @unid varchar(50) = "+ GridUtils.prossSqlParm(unid)+" \n"
                + " declare @FormId int,@DocCode varchar(50),@FieldId varchar(50),@RowId varchar(50) \n"
                + " declare @OriginalFileName varchar(200),@PhysicalFile varchar(50),@FileType varchar(50),@FileSize bigint \n"
                + " declare @AuthorCode varchar(50),@AuthorName varchar(50),@OriginalPicture varbinary(max) \n"

                + " select top 1 @FormId = a.FormId,@DocCode = a.DocCode,@FieldId = a.FieldId,@RowId = a.RowId, \n"
                + "    @OriginalFileName = a.OriginalFileName ,@PhysicalFile = a.PhysicalFile,@FileType = a.FileType,\n"
                + "    @FileSize = isnull(a.FileSize,0),@AuthorCode = a.AuthorCode,@AuthorName = a.AuthorName,\n"
                + "    @OriginalPicture = a.OriginalPicture \n"
                + " from " + (formidPath!=null&&"9747".equals(formidPath)?"_sys_AttachmentLog":"_sys_Attachment9") + " a \n"
                + " where a.UNID = @unid  \n"
                + (mailSeq !=null && !"".equals(mailSeq)?" and a.fieldid = '" + mailSeq + "' \n":"")
                + " select @myrowcount  = @@rowcount,@myerror = @@error \n"

                + " if isnull(@myrowcount,0) = 0 \n"
                + " begin \n"
                + "    select top 1 @FormId = a.FormId,@DocCode = a.DocCode,@FieldId = a.FieldId,@RowId = a.RowId, \n"
                + "       @OriginalFileName = a.OriginalFileName ,@PhysicalFile = a.PhysicalFile,@FileType = a.FileType,\n"
                + "       @FileSize = isnull(a.FileSize,0),@AuthorCode = a.AuthorCode,@AuthorName = a.AuthorName,\n"
                + "       @OriginalPicture = a.OriginalPicture \n"
                + "    from "+ (formidPath!=null&&"9747".equals(formidPath)?"_sys_AttachmentLog":"_sys_Attachment") +" a \n"
                + "    where a.UNID = @unid  \n"
                + (mailSeq !=null && !"".equals(mailSeq)?"    and a.fieldid = '" + mailSeq + "' \n":"")
                + " end \n "
                + " select @FormId as FormId,@DocCode as DocCode,@FieldId as FieldId,@RowId as RowId, \n" +
                "       @OriginalFileName as OriginalFileName ,@PhysicalFile as PhysicalFile,@FileType as FileType,\n" +
                "       isnull(@FileSize,0) as FileSize,@AuthorCode as AuthorCode,@AuthorName as AuthorName,\n" +
                "       @OriginalPicture as OriginalPicture \n";
        try {
            this.jdbcTemplate.query(sql,new AbstractLobStreamingResultSetExtractor(){
                protected void handleNoRowFound() throws LobRetrievalFailureException {
                    System.out.println("在数据库id为：" + dbId + "中，导购管理  ShoppingImageImpl 未找到 unid＝" + unids + " 的图片文件(或附件)!");
                    shoppingImage.setFormId(-1);
                    shoppingImage.setDocCode("");
                    shoppingImage.setFieldId("");
                    shoppingImage.setRowId("");

                    shoppingImage.setOriginalFileName("");
                    shoppingImage.setPhysicalFile(null);
                    shoppingImage.setFileType("");
                    shoppingImage.setFileSize(0L);
                    shoppingImage.setAuthorCode("");
                    shoppingImage.setAuthorName("");
                    shoppingImage.setImage(null) ;
                }

                @Override
                protected void streamData(ResultSet rs) throws SQLException, IOException, DataAccessException {
                    shoppingImage.setFormId(rs.getString("FormId") == null?0:rs.getInt("FormId"));
                    shoppingImage.setDocCode(rs.getString("DocCode") == null?"":rs.getString("DocCode"));
                    shoppingImage.setFieldId(rs.getString("FieldId") == null?"":rs.getString("FieldId"));
                    shoppingImage.setRowId(rs.getString("RowId") == null?"":rs.getString("RowId"));

                    shoppingImage.setOriginalFileName(rs.getString("OriginalFileName") == null?null:rs.getString("OriginalFileName"));
                    shoppingImage.setPhysicalFile(rs.getString("PhysicalFile") == null?null:rs.getString("PhysicalFile"));
                    shoppingImage.setFileType(rs.getString("FileType") == null?null:rs.getString("FileType"));
                    shoppingImage.setFileSize(rs.getLong("FileSize"));
                    shoppingImage.setAuthorCode(rs.getString("AuthorCode") == null?null:rs.getString("AuthorName"));
                    shoppingImage.setAuthorName(rs.getString("AuthorName") == null?null:rs.getString("AuthorName"));


                    //取原图路径
                    String shoppingImageFileName = SettingKey.getShoppingImageFileName(rootPath,unids, null, null, true, dbId+"", shoppingImage.getFileType(),attachmentPath,formidPath);
                    InputStream is = null ;
                    byte[] bytes = null ;
                    try {
                        is = defaultLobHandler.getBlobAsBinaryStream(rs, "OriginalPicture");
                        if (is != null) {
                            bytes = ShoppingImageEntity.InputStreamToByte( is); //取二进制图片

                            File file = BlobToFile.writeBytesToFile(bytes,shoppingImageFileName);  //
                            if (file != null) {
                                shoppingImage.setImage(file);
                            }
                        }
                    } catch (IOException e) {
                        e.printStackTrace();
                        throw e ;
                    } finally {
                        bytes = null ;
                        if (is != null) is.close();
                    }

                }   // end function
            });

            return shoppingImage ;

        }catch(DataAccessException e ) {
            if (e instanceof EmptyResultDataAccessException){
                return null ;
            }else {
                System.out.println("dbid:" + dbId + ",error:" + (e.getCause() != null ?e.getCause().getMessage():e.getMessage())) ;
                e.printStackTrace();
                throw e;
            }
        }catch(Exception e){
            System.out.println("dbid:" + dbId + ",error:" + (e.getCause() != null ?e.getCause().getMessage():e.getMessage())) ;
            e.printStackTrace();
            throw e;
        }

    }
    /**
     * 判断是否为数字
     *
     * @param str
     * @return
     */
    private static boolean isNumeric(String str) {
        Pattern pattern = Pattern.compile("\\d+");
        Matcher matcher = pattern.matcher(str);
        return matcher.matches();
    }
}

 src/com/yc/sdk/shopping/entity/ImageUrlParametersEntity.java

@@ -13,6 +13,7 @@
    private String formidPath = null ; //功能号，如果是 shopping ,则对应的是 images 值
    private String unid = null ;
    private Integer seq = null ;
    private String mailSeq=null;//CRM的邮件附件需要到 xin 2024-9-19 11:22:27

    public String getUnid() {
        return unid;
@@ -26,6 +27,15 @@
    public void setSeq(Integer seq) {
        this.seq = seq;
    }

    public String getMailSeq() {
        return mailSeq;
    }

    public void setMailSeq(String mailSeq) {
        this.mailSeq = mailSeq;
    }

    public String getAttachmentPath() {
        return attachmentPath;
    }