package com.matrix.system.hive.action;
|
|
import com.matrix.core.anotations.RemoveRequestToken;
|
import com.matrix.core.anotations.SaveRequestToken;
|
import com.matrix.core.pojo.AjaxResult;
|
import com.matrix.core.pojo.PaginationVO;
|
import com.matrix.core.tools.WebUtil;
|
import com.matrix.system.common.bean.SysUsers;
|
import com.matrix.system.common.dao.SysUsersDao;
|
import com.matrix.system.hive.action.util.QueryUtil;
|
import com.matrix.system.hive.bean.Onlinebooking;
|
import com.matrix.system.hive.bean.SysShopInfo;
|
import com.matrix.system.hive.dao.OnlinebookingDao;
|
import com.matrix.system.hive.dao.SysShopInfoDao;
|
import com.matrix.core.tools.DateUtil;
|
import com.matrix.system.hive.plugin.util.ExcelUtil;
|
import com.matrix.system.hive.service.OnlinebookingService;
|
import com.matrix.system.shopXcx.bean.ShopProduct;
|
import com.matrix.system.shopXcx.dao.ShopProductDao;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
import org.springframework.web.servlet.ModelAndView;
|
|
import javax.annotation.Resource;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.io.IOException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
/**
|
*
|
* @date 2016-10-10 15:23
|
*/
|
@Controller
|
@RequestMapping(value = "admin/onlinebooking")
|
public class OnlinebookingController extends BaseController{
|
|
@Resource
|
private OnlinebookingService currentService;
|
|
@Autowired
|
private OnlinebookingDao onlinebookingDao;
|
|
@Autowired
|
private ShopProductDao productDao;
|
|
@Autowired
|
SysUsersDao staffInfoDao;
|
|
@Autowired
|
SysShopInfoDao shopInfoDao;
|
|
|
/**
|
* 列表显示
|
*/
|
@RequestMapping(value = "/showList")
|
public @ResponseBody
|
AjaxResult showList(Onlinebooking onlinebooking, PaginationVO pageVo) {
|
QueryUtil.setQueryLimit(onlinebooking);
|
List<Onlinebooking> list = onlinebookingDao.selectInPageForWx(onlinebooking);
|
//相关数据赋值
|
list.stream().forEach(order -> {
|
ShopProduct shopProduct = productDao.selectById(order.getProductId());
|
order.setShopProduct(shopProduct);
|
if (order.getStaffId() != null) {
|
SysUsers shopstaffInfo = staffInfoDao.selectById(Long.parseLong(order.getStaffId() + ""));
|
order.setStaffInfo(shopstaffInfo);
|
}
|
SysShopInfo shopInfo = shopInfoDao.selectById(order.getShopId());
|
order.setShopInfo(shopInfo);
|
});
|
AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, "查询成功");
|
result.setRows(list);
|
result.setTotal(onlinebookingDao.selectInPageForWxCount(onlinebooking));
|
return result;
|
}
|
|
/**
|
* 新增或者修改页面
|
*/
|
@RemoveRequestToken
|
@RequestMapping(value = "/addOrModify")
|
public @ResponseBody AjaxResult addOrModify(Onlinebooking onlinebooking) {
|
if (onlinebooking.getId() != null) {
|
return modify(currentService, onlinebooking, "onlinebooking");
|
} else {
|
return add(currentService, onlinebooking, "onlinebooking");
|
}
|
}
|
|
/**
|
* 进入修改界面
|
*/
|
@SaveRequestToken
|
@RequestMapping(value = "/editForm")
|
public String editForm(Long id) {
|
Onlinebooking onlinebooking;
|
if (id != null) {
|
onlinebooking = currentService.findById(id);
|
WebUtil.getRequest().setAttribute("obj", onlinebooking);
|
}
|
return "admin/onlinebooking-form";
|
}
|
|
|
/**
|
* 删除
|
*/
|
@RequestMapping(value = "/del")
|
public @ResponseBody AjaxResult del(String keys) {
|
return remove(currentService, keys);
|
}
|
|
/**
|
* 导出消耗统计
|
*
|
* @throws IOException
|
*/
|
@RequestMapping(value = "/exportOnlinebooking")
|
public @ResponseBody
|
ModelAndView report(HttpServletRequest request, HttpServletResponse response, Onlinebooking onlinebooking) throws IOException {
|
|
onlinebooking.setShopId(getMe().getShopId());
|
onlinebooking.setStatus(new String(onlinebooking.getStatus().trim().getBytes("ISO-8859-1"), "UTF-8"));
|
List<Onlinebooking> dataList = currentService.findByModel(onlinebooking);
|
|
//组装excel数据
|
List<List<Object>> list = new ArrayList<>();
|
if(dataList.size()>0){
|
for(Onlinebooking obj:dataList){
|
List<Object> temp = new ArrayList<>();
|
temp.add(obj.getVipInfo().getVipName());
|
String strDate= DateUtil.dateToString(obj.getTime(), DateUtil.DATE_FORMAT_SS);
|
temp.add(strDate);
|
temp.add(obj.getStatus());
|
//时间转为字符串
|
temp.add(obj.getReason());
|
temp.add(obj.getRemark());
|
temp.add(obj.getShopName());
|
String crtDate=DateUtil.dateToString(obj.getCreateTime(), DateUtil.DATE_FORMAT_SS);
|
temp.add(crtDate);
|
list.add(temp);
|
}
|
}
|
|
String[] tdNames ={"会员姓名","预约时间","状态","取消原因","备注","所属门店","创建时间"};
|
XSSFWorkbook workbook = ExcelUtil.createSimple2007("预约单记录",tdNames,list );
|
|
return null;
|
|
}
|
|
}
|
