package com.matrix.system.hive.action;
|
|
import com.matrix.core.constance.MatrixConstance;
|
import com.matrix.core.pojo.AjaxResult;
|
import com.matrix.core.pojo.PaginationVO;
|
import com.matrix.core.tools.DateUtil;
|
import com.matrix.core.tools.StringUtils;
|
import com.matrix.core.tools.WebUtil;
|
import com.matrix.core.tools.excl.ExcelSheetPO;
|
import com.matrix.core.tools.excl.ExcelVersion;
|
import com.matrix.system.common.bean.SysUsers;
|
import com.matrix.system.common.tools.ResponseHeadUtil;
|
import com.matrix.system.constance.Dictionary;
|
import com.matrix.system.hive.bean.ShoppingGoods;
|
import com.matrix.system.hive.bean.SysStoreInfo;
|
import com.matrix.system.hive.dao.SysStoreInfoDao;
|
import com.matrix.system.hive.service.SysStoreInfoService;
|
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 javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.io.OutputStream;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
|
/**
|
* 库存
|
*
|
* @author jiangyouyao
|
* @date 2016-07-20
|
*/
|
@Controller
|
@RequestMapping(value = "admin/store")
|
public class StoreController extends BaseController {
|
@Resource
|
private SysStoreInfoService currentService;
|
|
@Resource
|
private SysStoreInfoDao sysStoreInfoDao;
|
|
|
//记录编辑前的值Before_Edit_Value
|
public static final String BEV = "Store_BEV";
|
|
public static final String fnCode = "store";
|
public static final String fnCode1 = "store1";
|
public static final String fnCode2 = "store2";
|
public static final String search = ":search";
|
public static final String edit = ":edit";
|
public static final String del = ":del";
|
public static final String add = ":add";
|
public static final String excelOut = ":excelOut";
|
|
|
/**
|
* 列表显示
|
*/
|
@RequestMapping(value = "/showList")
|
public @ResponseBody
|
AjaxResult showList(SysStoreInfo sysStoreInfo, PaginationVO pageVo) {
|
SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
|
sysStoreInfo.setShopId(users.getShopId());
|
sysStoreInfo.setCompanyId(users.getCompanyId());
|
if (StringUtils.isNotBlank(sysStoreInfo.getName())) {
|
ShoppingGoods goods = new ShoppingGoods();
|
goods.setName(sysStoreInfo.getName());
|
sysStoreInfo.setGoods(goods);
|
}
|
List<SysStoreInfo> dataList = currentService.findInPage(sysStoreInfo, pageVo);
|
AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList, currentService.findTotal(sysStoreInfo));
|
return result;
|
}
|
|
/**
|
* 按产品批次显示
|
* @param sysStoreInfo
|
* @param pageVo
|
* @return
|
*/
|
@RequestMapping(value = "/showCountList")
|
public @ResponseBody
|
AjaxResult showCountList(SysStoreInfo sysStoreInfo, PaginationVO pageVo) {
|
SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
|
sysStoreInfo.setShopId(users.getShopId());
|
sysStoreInfo.setCompanyId(users.getCompanyId());
|
|
List<SysStoreInfo> dataList = sysStoreInfoDao.selectCountInPage(sysStoreInfo, pageVo);
|
AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList, sysStoreInfoDao.selectCountTotalRecord(sysStoreInfo));
|
return result;
|
}
|
|
|
|
/**
|
* 新增或修改页面
|
*/
|
@RequestMapping(value = "/addOrModify")
|
public @ResponseBody
|
AjaxResult addOrModify(SysStoreInfo sysStoreInfo) {
|
|
if (!getMe().getShopRole().equals(Dictionary.FLAG_YES_Y)) {
|
sysStoreInfo.setStoreId(getMe().getShopId());
|
}
|
|
if (sysStoreInfo.getId() != null) {
|
|
return modify(currentService, sysStoreInfo, "库存");
|
} else {
|
|
return add(currentService, sysStoreInfo, "库存");
|
}
|
}
|
|
/**
|
* 进入修改界面
|
*/
|
@RequestMapping(value = "/editForm")
|
public String editForm(Long id) {
|
SysStoreInfo sysStoreInfo;
|
if (id != null) {
|
sysStoreInfo = currentService.findById(id);
|
WebUtil.getRequest().setAttribute("obj", sysStoreInfo);
|
}
|
return "admin/hive/products/goods-form";
|
}
|
|
|
/**
|
* 删除
|
*/
|
@RequestMapping(value = "/del")
|
public @ResponseBody
|
AjaxResult del(String keys) {
|
|
return remove(currentService, keys);
|
}
|
|
|
/**
|
* 库存按批次导出
|
*/
|
@RequestMapping(value = "/storeExportExcel")
|
public void storeExportExcel(SysStoreInfo sysStoreInfo, HttpServletResponse response) throws IOException {
|
SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
|
sysStoreInfo.setShopId(users.getShopId());
|
sysStoreInfo.setCompanyId(users.getCompanyId());
|
if (StringUtils.isNotBlank(sysStoreInfo.getName())) {
|
ShoppingGoods goods = new ShoppingGoods();
|
goods.setName(sysStoreInfo.getName());
|
sysStoreInfo.setGoods(goods);
|
}
|
doStoreInfoExportExcel(response,sysStoreInfo);
|
}
|
|
/**
|
* 库存按批次导出-不区分门店
|
*/
|
@RequestMapping(value = "/erpStoreExportExcel")
|
public void erpStoreExportExcel(SysStoreInfo sysStoreInfo, HttpServletResponse response) throws IOException {
|
SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
|
sysStoreInfo.setCompanyId(users.getCompanyId());
|
if (StringUtils.isNotBlank(sysStoreInfo.getName())) {
|
ShoppingGoods goods = new ShoppingGoods();
|
goods.setName(sysStoreInfo.getName());
|
sysStoreInfo.setGoods(goods);
|
}
|
doStoreInfoExportExcel(response,sysStoreInfo);
|
}
|
|
|
|
|
|
|
/**
|
* 按产品维度导出库存
|
*/
|
@RequestMapping(value = "/goodsCountExportExcel")
|
public void goodsCountExportExcel(ModelMap model, HttpServletRequest request, HttpServletResponse response,
|
SysStoreInfo sysStoreInfo) throws IOException {
|
SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
|
sysStoreInfo.setShopId(users.getShopId());
|
sysStoreInfo.setCompanyId(users.getCompanyId());
|
doGoodsCountExportExcel(response, sysStoreInfo);
|
return;
|
}
|
|
/**
|
* 按产品维度导出库存不区分门店
|
*/
|
@RequestMapping(value = "/erpGoodsCountExportExcel")
|
public void erpGoodsCountExportExcel(ModelMap model, HttpServletRequest request, HttpServletResponse response,
|
SysStoreInfo sysStoreInfo) throws IOException {
|
SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
|
sysStoreInfo.setCompanyId(users.getCompanyId());
|
doGoodsCountExportExcel(response, sysStoreInfo);
|
return;
|
}
|
|
|
/**
|
* 产品维度库存导出
|
*/
|
private void doGoodsCountExportExcel(HttpServletResponse response, SysStoreInfo sysStoreInfo) throws IOException {
|
List<ExcelSheetPO> res = new ArrayList<>();
|
ExcelSheetPO orderSheet = new ExcelSheetPO();
|
String title = "库存明细";
|
orderSheet.setSheetName(title);
|
orderSheet.setTitle(title);
|
String[] header = {"产品名称", "产品编号", "库存量","入库平均价", "产品单位", "库存预警值", "所属仓库", "分类"};
|
orderSheet.setHeaders(header);
|
List<SysStoreInfo> dataList = sysStoreInfoDao.selectCountInPage(sysStoreInfo, null);
|
|
|
List<List<Object>> list = new ArrayList<>();
|
if (dataList.size() > 0) {
|
for (SysStoreInfo item : dataList) {
|
List<Object> temp = new ArrayList<>();
|
ShoppingGoods getGoods = item.getGoods();
|
if(getGoods!=null){
|
temp.add(getGoods.getName());
|
temp.add(getGoods.getGoodsNo());
|
temp.add(item.getStoreTotal());
|
temp.add(item.getGoodsPrice());
|
temp.add(getGoods.getUnit());
|
temp.add(getGoods.getAlarmNum());
|
temp.add(getGoods.getName());
|
temp.add(item.getStoreName());
|
list.add(temp);
|
}
|
}
|
}
|
orderSheet.setDataList(list);
|
res.add(orderSheet);
|
response = ResponseHeadUtil.setExcelHead(response);
|
response.setHeader("Content-Disposition",
|
"attachment;filename=" + java.net.URLEncoder.encode(title + DateUtil.getTimeMark() + ".xlsx".trim(), "UTF-8"));
|
OutputStream os = response.getOutputStream();
|
com.matrix.core.tools.excl.ExcelUtil.createWorkbookAtOutStream(ExcelVersion.V2007, res, os, true);
|
}
|
|
|
/**
|
* 库存明细导出
|
*/
|
private void doStoreInfoExportExcel(HttpServletResponse response, SysStoreInfo sysStoreInfo) throws IOException {
|
List<ExcelSheetPO> res = new ArrayList<>();
|
ExcelSheetPO orderSheet = new ExcelSheetPO();
|
String title = "库存明批次汇总";
|
orderSheet.setSheetName(title);
|
orderSheet.setTitle(title);
|
String[] header = {"产品名称", "产品编号", "批次", "库存量","入库单价", "产品单位", "库存预警值", "所属仓库", "分类"};
|
orderSheet.setHeaders(header);
|
List<SysStoreInfo> dataList = currentService.findInPage(sysStoreInfo, null);
|
|
|
List<List<Object>> list = new ArrayList<>();
|
if (dataList.size() > 0) {
|
for (SysStoreInfo item : dataList) {
|
List<Object> temp = new ArrayList<>();
|
ShoppingGoods getGoods = item.getGoods();
|
if(getGoods!=null){
|
temp.add(getGoods.getName());
|
temp.add(getGoods.getGoodsNo());
|
temp.add(item.getBatch());
|
temp.add(item.getStoreTotal());
|
temp.add(item.getGoodsPrice());
|
temp.add(getGoods.getUnit());
|
temp.add(getGoods.getAlarmNum());
|
temp.add(getGoods.getName());
|
temp.add(item.getStoreName());
|
list.add(temp);
|
}
|
}
|
}
|
orderSheet.setDataList(list);
|
res.add(orderSheet);
|
response = ResponseHeadUtil.setExcelHead(response);
|
response.setHeader("Content-Disposition",
|
"attachment;filename=" + java.net.URLEncoder.encode(title + DateUtil.getTimeMark() + ".xlsx".trim(), "UTF-8"));
|
OutputStream os = response.getOutputStream();
|
com.matrix.core.tools.excl.ExcelUtil.createWorkbookAtOutStream(ExcelVersion.V2007, res, os, true);
|
}
|
|
}
|
