|
package com.matrix.system.hiveErp.action;
|
|
import com.matrix.core.pojo.AjaxResult;
|
import com.matrix.core.pojo.PaginationVO;
|
import com.matrix.core.tools.DateUtil;
|
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.tools.ResponseHeadUtil;
|
import com.matrix.system.constance.Dictionary;
|
import com.matrix.system.hive.action.BaseController;
|
import com.matrix.system.hive.action.util.QueryUtil;
|
import com.matrix.system.hive.bean.MoneyCardAssemble;
|
import com.matrix.system.hive.bean.ShoppingGoods;
|
import com.matrix.system.hive.bean.ShoppingGoodsAssemble;
|
import com.matrix.system.hive.dao.ShoppingGoodsAssembleDao;
|
import com.matrix.system.hive.dao.ShoppingGoodsDao;
|
import com.matrix.system.hive.service.MoneyCardAssembleService;
|
import com.matrix.system.hive.service.ShoppingGoodsService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
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.net.URLEncoder;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
|
/**
|
* 商品
|
*
|
* @author jiangyouyao
|
* @date 2016-8-22
|
*/
|
@Controller
|
@RequestMapping(value = "admin/erpShoppinggoods")
|
public class ErpShoppingGoodsController extends BaseController {
|
@Resource
|
private ShoppingGoodsService shoppingGoodsService;
|
|
@Resource
|
private MoneyCardAssembleService cardAssembleService;
|
|
@Autowired
|
private ShoppingGoodsAssembleDao shoppingGoodsAssembleDao;
|
|
|
//记录编辑前的值Before_Edit_Value
|
public static final String BEV = "shoppinggoods_BEV";
|
|
|
@Autowired
|
private ShoppingGoodsDao shoppingGoodsDao;
|
|
/**
|
* 列表显示
|
*/
|
@RequestMapping(value = "/showList")
|
public @ResponseBody
|
AjaxResult showList(ShoppingGoods shoppingGoods, PaginationVO pageVo) {
|
pageVo.setOrder("desc");
|
pageVo.setSort("createTime");
|
QueryUtil.setQueryLimitCom(shoppingGoods);
|
shoppingGoods.setIsDel(ShoppingGoods.NORMAL);
|
List<ShoppingGoods> dataList = shoppingGoodsService.findInPage(shoppingGoods, pageVo);
|
AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList, shoppingGoodsService.findTotal(shoppingGoods));
|
return result;
|
}
|
|
/**
|
* 进入线下产品修改界面
|
*/
|
@RequestMapping(value = "/editFormUderline")
|
public String editFormUderline(Long id) {
|
ShoppingGoods shoppingGoods;
|
if (id != null) {
|
WebUtil.getRequest().setAttribute("isUpdate", shoppingGoodsService.checkIsUpdate(id));
|
shoppingGoods = shoppingGoodsService.findById(id);
|
|
//查询的绑定关系
|
if (Dictionary.SHOPPING_GOODS_TYPE_JJCP.equals(shoppingGoods.getGoodType())) {
|
List<ShoppingGoodsAssemble> assembleList = shoppingGoodsAssembleDao.selectGoodsByShoppingGoodsId(shoppingGoods.getId());
|
shoppingGoods.setAssembleGoods(assembleList);
|
} else if (Dictionary.SHOPPING_GOODS_TYPE_XM.equals(shoppingGoods.getGoodType())) {
|
List<ShoppingGoodsAssemble> assembleList = shoppingGoodsAssembleDao.selectProjByShoppingGoodsId(shoppingGoods.getId());
|
shoppingGoods.setAssembleProj(assembleList);
|
} else if (Dictionary.SHOPPING_GOODS_TYPE_TC.equals(shoppingGoods.getGoodType())) {
|
|
List<ShoppingGoodsAssemble> assembleListGoods = shoppingGoodsAssembleDao.selectGoodsByShoppingGoodsId(shoppingGoods.getId());
|
shoppingGoods.setAssembleGoods(assembleListGoods);
|
List<ShoppingGoodsAssemble> assembleListProj = shoppingGoodsAssembleDao.selectProjByShoppingGoodsId(shoppingGoods.getId());
|
shoppingGoods.setAssembleProj(assembleListProj);
|
} else if (Dictionary.SHOPPING_GOODS_TYPE_ZHK.equals(shoppingGoods.getGoodType())) {
|
List<ShoppingGoodsAssemble> assembleList = shoppingGoodsAssembleDao.selectAssembleShoppingGoodsByShoppingGoodsId(shoppingGoods.getId());
|
shoppingGoods.setZongheCarGoods(assembleList);
|
}
|
|
|
// 如果是充值卡
|
if (shoppingGoods.getGoodType().equals(Dictionary.SHOPPING_GOODS_TYPE_CZK)) {
|
MoneyCardAssemble moneyCardAssembleQuery = new MoneyCardAssemble();
|
moneyCardAssembleQuery.setCardId(shoppingGoods.getId());
|
// 查询充值卡中的分类
|
moneyCardAssembleQuery.setType(Dictionary.CZK_ASSEMBLE_FL);
|
List<MoneyCardAssemble> cateIdList = cardAssembleService.findByModel(moneyCardAssembleQuery);
|
String cates = ",";
|
for (MoneyCardAssemble moneyCardAssemble : cateIdList) {
|
cates += moneyCardAssemble.getCateId() + ",";
|
}
|
WebUtil.getRequest().setAttribute("cates", cates);
|
// 查询充值卡中的产品
|
moneyCardAssembleQuery.setType(Dictionary.CZK_ASSEMBLE_SP);
|
List<MoneyCardAssemble> goodsIdList = cardAssembleService.findByModel(moneyCardAssembleQuery);
|
List<ShoppingGoods> goodsList = new ArrayList<>();
|
String goodsIds = "";
|
for (MoneyCardAssemble moneyCardAssemble : goodsIdList) {
|
goodsList.add(shoppingGoodsService.findById(moneyCardAssemble.getGoodsId()));
|
goodsIds += moneyCardAssemble.getGoodsId() + ",";
|
}
|
WebUtil.getRequest().setAttribute("goodsIds", goodsIds);
|
// 返回充值卡编辑界面
|
WebUtil.getRequest().setAttribute("obj", shoppingGoods);
|
return "admin/hive-erp/products/money-card-form";
|
} else if (shoppingGoods.getGoodType().equals(Dictionary.SHOPPING_GOODS_TYPE_ZHK)) {
|
WebUtil.getRequest().setAttribute("obj", shoppingGoods);
|
return "admin/hive-erp/products/zonghe-card-form";
|
}
|
|
|
|
WebUtil.getRequest().setAttribute("obj", shoppingGoods);
|
|
} else {
|
WebUtil.getRequest().setAttribute("isUpdate", true);
|
}
|
// 返回非充值卡页面
|
|
return "admin/hive-erp/products/goods-form";
|
}
|
|
|
/**
|
* 删除
|
*/
|
@RequestMapping(value = "/del")
|
public @ResponseBody
|
AjaxResult del(String keys) {
|
|
return remove(shoppingGoodsService, keys);
|
}
|
|
@RequestMapping(value = "/exportShoppinggoods")
|
public void exportShoppinggoods(ModelMap model, HttpServletRequest request, HttpServletResponse response, ShoppingGoods shoppingGoods) throws IOException {
|
if (shoppingGoods.getGoodType() != null && !"".equals(shoppingGoods.getGoodType())) {
|
shoppingGoods.setGoodType(new String(shoppingGoods.getGoodType().getBytes("iso-8859-1"), "UTF-8"));
|
}
|
List<ExcelSheetPO> res = new ArrayList<>();
|
ExcelSheetPO orderSheet = new ExcelSheetPO();
|
String title = "商品资料";
|
orderSheet.setSheetName(title);
|
orderSheet.setTitle(title);
|
String[] header = {"商品名称", "售价/(本金)", "参考价/(赠送金额)", "真实销量", "状态", "是否赠送", "类型", "分类", "套餐卡"};
|
orderSheet.setHeaders(header);
|
QueryUtil.setQueryLimitCom(shoppingGoods);
|
List<ShoppingGoods> dataList = shoppingGoodsService.findAll(shoppingGoods);
|
List<List<Object>> list = new ArrayList<>();
|
if (dataList.size() > 0) {
|
for (ShoppingGoods item : dataList) {
|
List<Object> temp = new ArrayList<>();
|
temp.add(item.getName());
|
temp.add(item.getSealPice());
|
temp.add(item.getReferencePice());
|
temp.add(item.getRealSealCount());
|
temp.add(item.getStaus());
|
temp.add(item.getIsPresent());
|
temp.add(item.getGoodType());
|
temp.add(item.getCateName());
|
temp.add(item.getIsCourse());
|
list.add(temp);
|
}
|
}
|
orderSheet.setDataList(list);
|
res.add(orderSheet);
|
response = ResponseHeadUtil.setExcelHead(response);
|
response.setHeader("Content-Disposition",
|
"attachment;filename=" + 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);
|
}
|
|
}
|
