package com.matrix.system.hive.action;

import com.matrix.core.anotations.RemoveRequestToken;
import com.matrix.core.anotations.SaveRequestToken;
import com.matrix.core.constance.MatrixConstance;
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.hive.action.util.QueryUtil;
import com.matrix.system.hive.bean.SysOutStore;
import com.matrix.system.hive.bean.SysOutStoreItem;
import com.matrix.system.hive.dao.SysOutStoreItemDao;
import com.matrix.system.hive.dao.WarehouseDao;
import com.matrix.system.hive.plugin.util.ExcelUtil;
import com.matrix.system.hive.service.SysOutStoreService;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.propertyeditors.CustomDateEditor;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.bind.annotation.InitBinder;
import org.springframework.web.bind.annotation.RequestBody;
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.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;



/**
 * 出库
 * 
 * @author jiangyouyao
 * @date 2016-07-25
 */
@Controller
@RequestMapping(value = "admin/outstore")
public class OutStoreController extends BaseController {

	@Resource
	private SysOutStoreService currentService;
	private SysOutStoreItemDao outStoreItemDao;



	public static final String fnCode = "outStore";
	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";
	public static final String excelOut = fnCode + ":excelOut";
	/**
	 * 列表显示
	 */

	@Autowired
	WarehouseDao warehouseDao;
	@RequestMapping(value = "/showList")
	public @ResponseBody
	AjaxResult showList(SysOutStore sysOutStore, PaginationVO pageVo) {
		SysUsers users = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
		sysOutStore.setShopId(users.getShopId());
		return showList(currentService, sysOutStore, pageVo);
	}

	/**
	 * 添加或修改出库单
	 */
	@RequestMapping(value = "/addOrModify")
	@RemoveRequestToken
	public @ResponseBody AjaxResult addOrModify(SysOutStore sysOutStore) {
		if (sysOutStore.getId() != null) {

			return modify(currentService, sysOutStore, "出库单");
		} else {
			return add(currentService, sysOutStore, "出库单");
		}
	}

	@RequestMapping(value = "/addOrModifyJson")
	@ResponseBody
	public AjaxResult addOrModifyJson(@RequestBody SysOutStore sysOutStore) {
		SysUsers sysUsers = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY);
		if (sysOutStore.getId() != null) {

			return modify(currentService, sysOutStore, "出库单");
		} else {
			return add(currentService, sysOutStore, "出库单");
		}
	}

	@RequestMapping(value = "/editForm")
	@SaveRequestToken
	public String editForm() {
		return "admin/hive/store/outStore-form";
	}
	
	/**
	 * 弹出框，积分规则
	 */
	@RequestMapping(value = "/findById")
	public @ResponseBody AjaxResult findById(Long id) {
		SysOutStore sysOutStore = currentService.findById(id);
		List<SysOutStoreItem> outStoreItemList= outStoreItemDao.selectByOrderId(id);
		sysOutStore.setOutStoreItems(outStoreItemList);
		return AjaxResult.buildSuccessInstance(Arrays.asList(sysOutStore));
	}
	
	@RequestMapping(value = "/toCheck")
	@SaveRequestToken
	public String toCheck(Long id, HttpServletRequest request) {
		SysOutStore sysOutStore;
		if (id != null) {
			sysOutStore = currentService.findById(id);
			request.setAttribute("obj", sysOutStore);
		}
		return "admin/hive/store/outStore-check";
	}
	
	@RequestMapping(value = "/checkForm")
	@RemoveRequestToken
	public @ResponseBody AjaxResult checkForm(SysOutStore sysOutStore) {
		int i=0;
		if (sysOutStore.getId() != null) {

			i=currentService.checkInfo(sysOutStore);
		}
		if(i>0){
			return new AjaxResult(AjaxResult.STATUS_SUCCESS,  "审核成功！");
		}
		else{
			return new AjaxResult(AjaxResult.STATUS_FAIL, "审核失败");
		}
	}
	
	@RequestMapping(value = "/lookForm")
	@SaveRequestToken
	public String lookForm(Long id, HttpServletRequest request) {
		SysOutStore sysOutStore;
		if (id != null) {
			sysOutStore = currentService.findById(id);
			request.setAttribute("obj", sysOutStore);
		}
		return "admin/hive/store/outStore-look";
	}
	
	/**
	 * @param bin
	 */
	@InitBinder
	public void initBinder(ServletRequestDataBinder bin) {
		SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		CustomDateEditor dateEditor = new CustomDateEditor(format, true);
		bin.registerCustomEditor(Date.class, dateEditor);
	}
	
	/**
 	 * 导出库存
 	 * @param model
 	 * @param request
 	 * @param response
 	 * @return
 	 */
 	@RequestMapping(value = "/exportExcel")
	public @ResponseBody ModelAndView report(ModelMap model, HttpServletRequest request, HttpServletResponse response,
			SysOutStore sysOutStore) {

		// 这里是从数据库里查数据并组装成我们想要的数据结构的过程
		QueryUtil.setQueryLimit(sysOutStore);
		List<SysOutStore> dataList = currentService.findInPage(sysOutStore, null);
		List<List<Object>> list = new ArrayList<>();
		if (dataList.size() > 0) {
			for (SysOutStore outStore : dataList) {
				List<SysOutStoreItem> outStoreItemList = outStoreItemDao.selectByOrderId(sysOutStore.getId());
				for (SysOutStoreItem obj:outStoreItemList) {
					List<Object> temp = new ArrayList<>();
					temp.add(outStore.getShopName());
					temp.add(outStore.getSuName());
					temp.add(outStore.getServiceNo());
					temp.add(obj.getGoods().getName());
					temp.add(obj.getGoods().getName());
					temp.add(obj.getAmount());
					temp.add(obj.getRemark());
					list.add(temp);
				}
			}
		}
		
		String[] tdNames ={ "产品名称", "门店名称","服务单号","商品名称", "存货名称", "数量","备注"};
  	    XSSFWorkbook workbook = ExcelUtil.createSimple2007("出库明细",tdNames,list );

        return null;
	}
}