package com.matrix.system.hive.action;
|
|
import java.io.IOException;
|
import java.io.OutputStream;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
|
import com.matrix.core.pojo.AjaxResult;
|
import com.matrix.core.pojo.PaginationVO;
|
|
import com.matrix.core.tools.DateUtil;
|
import com.matrix.system.hive.bean.SysCheckDetail;
|
import com.matrix.system.hive.bean.SysCheckInfo;
|
import com.matrix.system.hive.plugin.util.ExcelUtil;
|
import com.matrix.system.hive.service.CodeService;
|
import com.matrix.system.hive.service.SysCheckDetailService;
|
import com.matrix.system.hive.service.SysCheckInfoService;
|
import com.matrix.system.hive.service.SysStoreInfoService;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.apache.poi.ss.formula.functions.T;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.ui.ModelMap;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
import org.springframework.web.servlet.ModelAndView;
|
|
|
|
|
/**
|
* 盘点单明细controller
|
*
|
* @Title: CheckInfoDetailController.java
|
* @Package com.zkingsoft.actions.admin
|
* @description
|
* @author jyy
|
* @email 18075895212@qq.com
|
* @date 2016年9月3日 下午4:15:09
|
*/
|
@Controller
|
@RequestMapping(value = "admin/checkDetail")
|
public class CheckInfoDetailController extends BaseController {
|
public static final String fnCode = "checkDetail";
|
public static final String search = fnCode + ":search";
|
public static final String edit = fnCode + ":edit";
|
public static final String del = fnCode + ":del";
|
public static final String add = fnCode + ":add";
|
|
|
|
@Resource
|
private SysCheckDetailService currentService;
|
|
@Resource
|
private SysStoreInfoService sysStoreInfoService;
|
@Resource
|
private CodeService codeService;
|
@Resource
|
private SysCheckInfoService sysCheckInfoService;
|
|
/**
|
* 列表显示
|
*/
|
@RequestMapping(value = "/showList")
|
public @ResponseBody
|
AjaxResult showList(SysCheckDetail sysCheckDetail, PaginationVO pageVo) {
|
List<SysCheckDetail> dataList = currentService.findInPage(sysCheckDetail, pageVo);
|
AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList, currentService.findTotal(sysCheckDetail));
|
return result;
|
}
|
|
/**
|
* 列表显示
|
*/
|
@RequestMapping(value = "/editCheckDetail")
|
public @ResponseBody AjaxResult editCheckDetail(SysCheckInfo sysCheckInfo) {
|
int i = currentService.modifyList(sysCheckInfo);
|
if (i > 0) {
|
return new AjaxResult(AjaxResult.STATUS_SUCCESS, "保存成功");
|
} else {
|
return new AjaxResult(AjaxResult.STATUS_SUCCESS, "保存失败");
|
}
|
}
|
|
/**
|
* @author jiangyouyao @Title: report 盘点单明细导出 @param @param
|
* model @param @param request @param @param response @param @param
|
* vipInfo @param @return 设定文件 @return ModelAndView 返回类型 @throws
|
*/
|
@RequestMapping(value = "/exportExcel")
|
public void report(HttpServletRequest request, HttpServletResponse response,
|
SysCheckDetail sysCheckDetail) throws IOException {
|
List<List<List<Object>>> list = new ArrayList<>();
|
// 表格1内容
|
List<List<Object>> list1 = new ArrayList<>();
|
// 查询出来调拨单
|
SysCheckInfo checkInfo = sysCheckInfoService.findById(sysCheckDetail.getCheckId());
|
List<Object> temp1 = new ArrayList<>();
|
temp1.add(checkInfo.getCheckType());
|
temp1.add(checkInfo.getCheckNo());
|
// 时间转为字符串
|
String strDate = DateUtil.dateToString(checkInfo.getCheckDate(), DateUtil.DATE_FORMAT_DD);
|
temp1.add(strDate);
|
temp1.add(checkInfo.getMakingManName());
|
temp1.add(checkInfo.getAppManName());
|
temp1.add(checkInfo.getCheckStatus());
|
list1.add(temp1);
|
list.add(list1);
|
// 表格2内容
|
List<List<Object>> list2 = new ArrayList<>();
|
// 调拨单明细
|
SysCheckDetail queryVo = new SysCheckDetail();
|
queryVo.setCheckId(sysCheckDetail.getCheckId());
|
List<SysCheckDetail> dataList = currentService.findByModel(queryVo);
|
if (dataList.size() > 0) {
|
for (SysCheckDetail obj : dataList) {
|
|
List<Object> temp = new ArrayList<>();
|
if(obj.getGoods()!=null){
|
temp.add(obj.getGoods().getGoodsNo());
|
temp.add(obj.getGoods().getName());
|
temp.add(obj.getBeginBalance());
|
temp.add(obj.getActuallySum());
|
temp.add(obj.getRemark());
|
temp.add(obj.getGoods().getGoodsSortName());
|
temp.add(obj.getGoods().getUnit());
|
}
|
list2.add(temp);
|
}
|
}
|
list.add(list2);
|
HSSFWorkbook workbook = ExcelUtil.generateExcelMore("盘点单以及明细",
|
new String[][] { { "盘点单类型", "盘点单编号", "盘点时间", "制单人", "审核人", "盘点状态" },
|
{ "存货编号", "存货名称", "存货数量", "实盘数", "备注", "存货分类", "存货单位"} },
|
list);
|
|
response.setContentType("application/vnd.ms-excel");
|
response.setHeader("Content-disposition", "attachment;filename=checkDetails.xls");
|
OutputStream ouputStream = response.getOutputStream();
|
workbook.write(ouputStream);
|
ouputStream.flush();
|
ouputStream.close();
|
|
}
|
}
|
