#

luxiaotao1123

2021-06-21 f6c8a961595ea54f2c9a6b7da589480481cc6283

#

 src/main/java/com/slcf/controller/WaitPakInLogController.java

@@ -5,6 +5,7 @@

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
@@ -86,4 +87,27 @@
        }        
    }
    
    /**
     * 导出所有
     * @param response
     */
    @RequestMapping("/exportWaitPakInLog.action")
    public void ExportExcel(WaitPakInLogCondition waitPakInLogCondition, HttpServletResponse response, HttpServletRequest request){
        try {
            waitPakInLogService.ExportWaitPakInLogList(waitPakInLogCondition,response);

            // 插入日志
            UserBean user = (UserBean) request.getSession().getAttribute("USER");
            SysLogBean sysLog = new SysLogBean();
            sysLog.setLogin_no(user.getUser_account());
            sysLog.setMachine_ip(request.getRemoteAddr());
            sysLog.setForm_no("exportWaitPakInLog.action");
            sysLog.setTts_keyname("导出入库通知历史档到EXCEL");
            sysLog.setModi_user(user.getUser_account());
            sysLogService.insertSysLog(sysLog);
        }catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

}

 src/main/java/com/slcf/controller/WaitPakOutLogController.java

@@ -5,6 +5,7 @@

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
@@ -86,4 +87,27 @@
        }        
    }
    
    /**
     * 导出所有
     * @param response
     */
    @RequestMapping("/exportWaitPakOutLog.action")
    public void ExportExcel(WaitPakOutLogCondition waitPakOutLogCondition, HttpServletResponse response, HttpServletRequest request){
        try {
            waitPakOutLogService.ExportWaitPakOutLogList(waitPakOutLogCondition,response);

            // 插入日志
            UserBean user = (UserBean) request.getSession().getAttribute("USER");
            SysLogBean sysLog = new SysLogBean();
            sysLog.setLogin_no(user.getUser_account());
            sysLog.setMachine_ip(request.getRemoteAddr());
            sysLog.setForm_no("exportWaitPakOutLog.action");
            sysLog.setTts_keyname("导出出库通知历史档到EXCEL");
            sysLog.setModi_user(user.getUser_account());
            sysLogService.insertSysLog(sysLog);
        }catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

}

 src/main/java/com/slcf/dao/WaitPakInLogDao.java

@@ -27,4 +27,10 @@
    @Select("select * from cust_wait_pakin_log order by sheet_no,mat_no desc")
    public List<WaitPakInLogBean> getWaitPakInLogList();
    
    /**
     * 不分页查询所有信息，用于excel导出
     * @return
     */
    public List<WaitPakInLogBean> getWaitPakInLogAll(WaitPakInLogCondition condition);

}

 src/main/java/com/slcf/dao/WaitPakOutLogDao.java

@@ -27,4 +27,10 @@
    @Select("select * from cust_wait_pakout_log order by sheet_no,mat_no desc")
    public List<WaitPakOutLogBean> getWaitPakOutLogList();
    
    /**
     * 不分页查询所有信息，用于excel导出
     * @return
     */
    public List<WaitPakOutLogBean> getWaitPakOutLogAll(WaitPakOutLogCondition condition);

}

 src/main/java/com/slcf/service/WaitPakInLogService.java

@@ -6,6 +6,8 @@
import com.slcf.bean.WaitPakInLogCondition;
import com.slcf.pojo.WaitPakInLogBean;

import javax.servlet.http.HttpServletResponse;

/**
 * 入库通知历史档接口
 * @author admin
@@ -23,4 +25,7 @@
     */
    public List<WaitPakInLogBean> getWaitPakInLogList();
    
    //导出excel
    public void ExportWaitPakInLogList(WaitPakInLogCondition condition, HttpServletResponse response);

}

 src/main/java/com/slcf/service/WaitPakOutLogService.java

@@ -6,6 +6,8 @@
import com.slcf.bean.WaitPakOutLogCondition;
import com.slcf.pojo.WaitPakOutLogBean;

import javax.servlet.http.HttpServletResponse;

/**
 * 出库通知历史档接口
 * @author admin
@@ -23,4 +25,7 @@
     */
    public List<WaitPakOutLogBean> getWaitPakOutLogList();
    
    //导出excel
    public void ExportWaitPakOutLogList(WaitPakOutLogCondition condition, HttpServletResponse response);

}

 src/main/java/com/slcf/service/impl/WaitPakInLogServiceImpl.java

@@ -1,9 +1,15 @@
package com.slcf.service.impl;

import java.io.IOException;
import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.slcf.util.DateTimeUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@@ -11,6 +17,8 @@
import com.slcf.dao.WaitPakInLogDao;
import com.slcf.pojo.WaitPakInLogBean;
import com.slcf.service.WaitPakInLogService;

import javax.servlet.http.HttpServletResponse;

/**
 * 入库通知历史档接口实现
@@ -53,4 +61,81 @@
        }
    }
    
    public void ExportWaitPakInLogList(WaitPakInLogCondition condition, HttpServletResponse response) {
        //输出Excel文件
        try {
            //HSSFWorkbook对象(excel的文档对象)
            HSSFWorkbook workBook=new HSSFWorkbook();

            //sheet对象（excel的表单）
            HSSFSheet sheet=workBook.createSheet("入库通知历史档");

            //行数，参数为行索引(excel的行)
//                HSSFRow rowHead=sheet.createRow(0);//第一行  可以是0～65535之间的任何一个

//                //创建excel的单元格，参数为列索引，可以是0～255之间的任何一个
//                HSSFCell cellOne=rowHead.createCell(0);
//                cellOne.setCellValue("用户信息");//表头

            //合并单元格CellRangeAddress构造参数依次表示起始行，截至行，起始列， 截至列
//                sheet.addMergedRegion(new CellRangeAddress(0,0,0,5));

            sheet.setColumnWidth(0, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(1, (int)((20 + 0.72) * 256));
            sheet.setColumnWidth(2, (int)((15 + 0.72) * 256));
            sheet.setColumnWidth(3, (int)((15 + 0.72) * 256));
            sheet.setColumnWidth(4, (int)((15 + 0.72) * 256));
            sheet.setColumnWidth(5, (int)((25 + 0.72) * 256));
            sheet.setColumnWidth(6, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(7, (int)((8 + 0.72) * 256));
            sheet.setColumnWidth(8, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(9, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(10, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(11, (int)((25 + 0.72) * 256));

            HSSFRow rows=sheet.createRow(0);//第二行
            //创建单元格并设置单元格内容
            rows.createCell(0).setCellValue("库位号");
            rows.createCell(1).setCellValue("物料");
            rows.createCell(2).setCellValue("物料描述");
            rows.createCell(3).setCellValue("仓库号");
            rows.createCell(4).setCellValue("请求编号");
            rows.createCell(5).setCellValue("物料标签ID");
            rows.createCell(6).setCellValue("工厂");
            rows.createCell(7).setCellValue("数量");
            rows.createCell(8).setCellValue("单位");
            rows.createCell(9).setCellValue("托盘码");
            rows.createCell(10).setCellValue("用户ID");
            rows.createCell(11).setCellValue("异动时间");

            List<WaitPakInLogBean> list=waitPakInLogDao.getWaitPakInLogAll(condition);
            for(int i=0;i<list.size();i++){
                HSSFRow row=sheet.createRow(i+1);//从第三行开始
                //创建单元格并设置单元格内容
                row.createCell(0).setCellValue(list.get(i).getLoc_no());
                row.createCell(1).setCellValue(list.get(i).getMatnr());
                row.createCell(2).setCellValue(list.get(i).getMaktx());
                row.createCell(3).setCellValue(list.get(i).getLgnum());
                row.createCell(4).setCellValue(list.get(i).getTbnum());
                row.createCell(5).setCellValue(list.get(i).getZmatid());
                row.createCell(6).setCellValue(list.get(i).getWerks());
                row.createCell(7).setCellValue(list.get(i).getAnfme());
                row.createCell(8).setCellValue(list.get(i).getAltme());
                row.createCell(9).setCellValue(list.get(i).getZpallet());
                row.createCell(10).setCellValue(list.get(i).getBname());
                row.createCell(11).setCellValue(list.get(i).getModi_time());
            }
//            //输出Excel文件
//            try {
            OutputStream output=response.getOutputStream();
            response.reset();
            response.setHeader("Content-disposition", "attachment; filename=WaitPakInLog"+ DateTimeUtil.getStringDateTime(14)+".xls");
            response.setContentType("application/msexcel");
            workBook.write(output);
            output.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

}

 src/main/java/com/slcf/service/impl/WaitPakOutLogServiceImpl.java

@@ -1,9 +1,15 @@
package com.slcf.service.impl;

import java.io.IOException;
import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.slcf.util.DateTimeUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@@ -11,6 +17,8 @@
import com.slcf.dao.WaitPakOutLogDao;
import com.slcf.pojo.WaitPakOutLogBean;
import com.slcf.service.WaitPakOutLogService;

import javax.servlet.http.HttpServletResponse;

/**
 * 出库通知历史档接口实现
@@ -53,4 +61,84 @@
        }
    }
    
    public void ExportWaitPakOutLogList(WaitPakOutLogCondition condition, HttpServletResponse response) {
        //输出Excel文件
        try {
            //HSSFWorkbook对象(excel的文档对象)
            HSSFWorkbook workBook=new HSSFWorkbook();

            //sheet对象（excel的表单）
            HSSFSheet sheet=workBook.createSheet("出库通知历史档");

            //行数，参数为行索引(excel的行)
//                HSSFRow rowHead=sheet.createRow(0);//第一行  可以是0～65535之间的任何一个

//                //创建excel的单元格，参数为列索引，可以是0～255之间的任何一个
//                HSSFCell cellOne=rowHead.createCell(0);
//                cellOne.setCellValue("用户信息");//表头

            //合并单元格CellRangeAddress构造参数依次表示起始行，截至行，起始列， 截至列
//                sheet.addMergedRegion(new CellRangeAddress(0,0,0,5));

            sheet.setColumnWidth(0, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(1, (int)((20 + 0.72) * 256));
            sheet.setColumnWidth(2, (int)((15 + 0.72) * 256));
            sheet.setColumnWidth(3, (int)((15 + 0.72) * 256));
            sheet.setColumnWidth(4, (int)((15 + 0.72) * 256));
            sheet.setColumnWidth(5, (int)((25 + 0.72) * 256));
            sheet.setColumnWidth(6, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(7, (int)((8 + 0.72) * 256));
            sheet.setColumnWidth(8, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(9, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(10, (int)((10 + 0.72) * 256));
            sheet.setColumnWidth(11, (int)((25 + 0.72) * 256));
            sheet.setColumnWidth(12, (int)((25 + 0.72) * 256));

            HSSFRow rows=sheet.createRow(0);//第二行
            //创建单元格并设置单元格内容
            rows.createCell(0).setCellValue("仓库号");
            rows.createCell(1).setCellValue("转储编号");
            rows.createCell(2).setCellValue("行项目");
            rows.createCell(3).setCellValue("物料");
            rows.createCell(4).setCellValue("物料描述");
            rows.createCell(5).setCellValue("工厂");
            rows.createCell(6).setCellValue("数量");
            rows.createCell(7).setCellValue("单位");
            rows.createCell(8).setCellValue("源发地类型");
            rows.createCell(9).setCellValue("源发地仓位");
            rows.createCell(10).setCellValue("目的地类型");
            rows.createCell(11).setCellValue("目的地仓位");
            rows.createCell(12).setCellValue("用户ID");

            List<WaitPakOutLogBean> list=waitPakOutLogDao.getWaitPakOutLogAll(condition);
            for(int i=0;i<list.size();i++){
                HSSFRow row=sheet.createRow(i+1);//从第三行开始
                //创建单元格并设置单元格内容
                row.createCell(0).setCellValue(list.get(i).getLgnum());
                row.createCell(1).setCellValue(list.get(i).getTanum());
                row.createCell(2).setCellValue(list.get(i).getTapos());
                row.createCell(3).setCellValue(list.get(i).getMatnr());
                row.createCell(4).setCellValue(list.get(i).getMaktx());
                row.createCell(5).setCellValue(list.get(i).getWerks());
                row.createCell(6).setCellValue(list.get(i).getVsolm());
                row.createCell(7).setCellValue(list.get(i).getMeins());
                row.createCell(8).setCellValue(list.get(i).getVltyp());
                row.createCell(9).setCellValue(list.get(i).getVlpla());
                row.createCell(10).setCellValue(list.get(i).getNltyp());
                row.createCell(11).setCellValue(list.get(i).getNlpla());
                row.createCell(12).setCellValue(list.get(i).getBname());
            }
//            //输出Excel文件
//            try {
            OutputStream output=response.getOutputStream();
            response.reset();
            response.setHeader("Content-disposition", "attachment; filename=WaitPakOutLog"+ DateTimeUtil.getStringDateTime(14)+".xls");
            response.setContentType("application/msexcel");
            workBook.write(output);
            output.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

}

 src/main/resources/mapper/WaitPakInLogMapper.xml

@@ -54,4 +54,20 @@
<include refid="WaitPakInLogConditionSql"></include>
</where>
</select>


<!-- 不分页查询所有信息，用于excel导出 -->
<select id="getWaitPakInLogAll" parameterType="com.slcf.bean.WaitPakInLogCondition" resultType="com.slcf.pojo.WaitPakInLogBean">
    select a.*
    from cust_wait_pakin_log a
    <where>
        <![CDATA[
1=1
]]>
        <include refid="WaitPakInLogConditionSql"></include>
        <![CDATA[
order by a.appe_time,a.matnr,a.loc_no asc
]]>
    </where>
</select>
</mapper>

 src/main/resources/mapper/WaitPakOutLogMapper.xml

@@ -57,4 +57,20 @@
<include refid="WaitPakOutLogConditionSql"></include>
</where>
</select>


<!-- 不分页查询所有信息，用于excel导出 -->
<select id="getWaitPakOutLogAll" parameterType="com.slcf.bean.WaitPakOutLogCondition" resultType="com.slcf.pojo.WaitPakOutLogBean">
    select a.*
    from cust_wait_pakout_log a
    <where>
        <![CDATA[
1=1
]]>
        <include refid="WaitPakOutLogConditionSql"></include>
        <![CDATA[
order by a.appe_time desc
]]>
    </where>
</select>
</mapper>

 src/main/webapp/WEB-INF/pages/waitPakInLog.jsp

@@ -67,5 +67,13 @@
<table id="test-table" class="table table-hover text-nowrap"></table>
</div>

<!--toolbar  -->
<div id="toolbar" class="btn-toolbar">
    <button onclick="ExportExcel()" type="button" class="btn btn-success">
        <span class="glyphicon glyphicon-paste" aria-hidden="true" >导出</span>
    </button>
</div>


</body>
</html>

 src/main/webapp/WEB-INF/pages/waitPakOutLog.jsp

@@ -65,5 +65,12 @@
<table id="test-table" class="table table-hover text-nowrap"></table>
</div>

<!--toolbar  -->
<div id="toolbar" class="btn-toolbar">
    <button onclick="ExportExcel()" type="button" class="btn btn-success">
        <span class="glyphicon glyphicon-paste" aria-hidden="true" >导出</span>
    </button>
</div>

</body>
</html>

 src/main/webapp/jsFiles/waitPakInLog.js

@@ -252,3 +252,17 @@
    //$('#mydlg').data('bootstrapValidator').resetForm(true);
    $("input[type=reset]").trigger("click");
}

//导出
function ExportExcel(){
    if(confirm("确认导出excel？")){
        var url = "work/exportWaitPakInLog.action?";
        url += "matnr=" + $("#search_sheet_no").val();
        url += "&maktx=" + $("#search_mat_no").val();
        url += "&begin_date=" + $("#begin_date").val();
        url += "&end_date=" + $("#end_date").val();
        location.href=url;
    }else{
        return false;
    }
}

 src/main/webapp/jsFiles/waitPakOutLog.js

@@ -283,3 +283,17 @@
    //$('#mydlg').data('bootstrapValidator').resetForm(true);
    $("input[type=reset]").trigger("click");
}

//导出
function ExportExcel(){
    if(confirm("确认导出excel？")){
        var url = "work/exportWaitPakOutLog.action?";
        url += "matnr=" + $("#search_sheet_no").val();
        url += "&maktx=" + $("#search_mat_no").val();
        url += "&begin_date=" + $("#begin_date").val();
        url += "&end_date=" + $("#end_date").val();
        location.href=url;
    }else{
        return false;
    }
}