package com.slcf.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

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.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.slcf.pojo.UserBean;
import com.slcf.bean.AdjDetailCondition;
import com.slcf.bean.LocDetailCondition;
import com.slcf.pojo.AdjDetailBean;
import com.slcf.pojo.LocDetailBean;
import com.slcf.pojo.LocationBean;
import com.slcf.pojo.MatCodeBean;
import com.slcf.pojo.SysLogBean;
import com.slcf.service.AdjDetailService;
import com.slcf.service.LocDetailService;
import com.slcf.service.MatCodeService;
import com.slcf.service.RoleService;
import com.slcf.service.LocationService;
import com.slcf.service.SysLogService;
import com.slcf.util.AuthorityCode;

/**
 * 库存调整控制器层
 * @author admin
 * @date 2018年11月15日
 */
@Controller
@RequestMapping("/stock")
public class AdjDetailController {

	@Resource
	AdjDetailService adjDetailService;
	@Autowired
	LocDetailService locDetailService;
	@Autowired
	MatCodeService matCodeService;
	@Autowired
	LocationService locationService;
	@Autowired
	SysLogService sysLogService;
	@Autowired
	RoleService roleService;
	
	@RequestMapping("goAdjDetail.action")
	public String goAdjDetailPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.AdjDetailCode);
			request.getSession().setAttribute("AUTHCODE",authCode);
			// 插入日志
			UserBean user = (UserBean) request.getSession().getAttribute("USER");
			SysLogBean sysLog = new SysLogBean();
			sysLog.setLogin_no(user.getUser_account());
			sysLog.setMachine_ip(request.getRemoteAddr());
			sysLog.setForm_no("goAdjDetail.action");
			sysLog.setTts_keyname("访问:库存调整");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "adjDetail";
	}
	
	/**
	 * 添加
	 * @param adjDetail
	 * @param request
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/insertAdjLoc.action")
	public Integer insertAdjLoc(AdjDetailCondition adjDetailCon,HttpServletRequest request){
		int result=0;
		try {
			UserBean user=(UserBean)request.getSession().getAttribute("USER");			
			if(adjDetailCon != null) {								
				LocDetailBean detail = locDetailService.queryLocDetailById(adjDetailCon.getLoc_no(), adjDetailCon.getMat_no());
				if(detail!=null) {//修改
					int s_qty = detail.getQty();
					int s_ctns = detail.getCtns();
					double s_wt = detail.getWt();
					detail.setQty(s_qty + adjDetailCon.getAdj_qty());
					detail.setCtns(s_ctns + adjDetailCon.getAdj_ctns());
					detail.setWt(s_wt + adjDetailCon.getAdj_wt());
					detail.setMemo(adjDetailCon.getMemo());
					result = locDetailService.upLocDetail(detail);
					
					if(result>0) {
						AdjDetailBean adjDetail = new AdjDetailBean();
						adjDetail.setLoc_no(adjDetailCon.getLoc_no());
						adjDetail.setMat_no(adjDetailCon.getMat_no());
						adjDetail.setS_qty(s_qty);
						adjDetail.setS_ctns(s_ctns);
						adjDetail.setS_wt(s_wt);
						adjDetail.setAdj_qty(adjDetailCon.getAdj_qty());
						adjDetail.setAdj_ctns(adjDetailCon.getAdj_ctns());
						adjDetail.setAdj_wt(adjDetailCon.getAdj_wt());
						adjDetail.setQty(detail.getQty());
						adjDetail.setCtns(detail.getCtns());
						adjDetail.setWt(detail.getWt());
						adjDetail.setMemo(adjDetailCon.getMemo());
						adjDetail.setModi_user(user.getUser_account());
						adjDetailService.insertAdjDetail(adjDetail);
					}
				}
				else {//插入
					LocDetailBean locDetail = new LocDetailBean();
					locDetail.setLoc_no(adjDetailCon.getLoc_no());
					locDetail.setMat_no(adjDetailCon.getMat_no());
					locDetail.setQty(adjDetailCon.getAdj_qty());
					locDetail.setCtns(adjDetailCon.getAdj_ctns());
					locDetail.setWt(adjDetailCon.getAdj_wt());
					locDetail.setMemo(adjDetailCon.getMemo());
					locDetail.setModi_user(user.getUser_account());
					result = locDetailService.insertLocDetail(locDetail);
					
					if(result>0) {
						AdjDetailBean adjDetail = new AdjDetailBean();
						adjDetail.setLoc_no(adjDetailCon.getLoc_no());
						adjDetail.setMat_no(adjDetailCon.getMat_no());
						adjDetail.setS_qty(0);
						adjDetail.setS_ctns(0);
						adjDetail.setS_wt(0);
						adjDetail.setAdj_qty(adjDetailCon.getAdj_qty());
						adjDetail.setAdj_ctns(adjDetailCon.getAdj_ctns());
						adjDetail.setAdj_wt(adjDetailCon.getAdj_wt());
						adjDetail.setQty(adjDetailCon.getAdj_qty());
						adjDetail.setCtns(adjDetailCon.getAdj_ctns());
						adjDetail.setWt(adjDetailCon.getAdj_wt());
						adjDetail.setMemo(adjDetailCon.getMemo());
						adjDetail.setModi_user(user.getUser_account());
						adjDetailService.insertAdjDetail(adjDetail);
					}
				}							
								
			}

			if(result>0) {
				// 插入日志
//				UserBean user = (UserBean) request.getSession().getAttribute("USER");
				SysLogBean sysLog = new SysLogBean();
				sysLog.setLogin_no(user.getUser_account());
				sysLog.setMachine_ip(request.getRemoteAddr());
				sysLog.setForm_no("insertAdjLoc.action");
				sysLog.setTts_keyname("库存调整插入明细:" + adjDetailCon.getLoc_no() + "-"+ adjDetailCon.getMat_no());
				sysLog.setModi_user(user.getUser_account());
				sysLogService.insertSysLog(sysLog);
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
			result=0;
		}
		return result;
	}
	
	/**
	 * 分页查询所有
	 * @param pageNumber
	 * @param pageSize
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/adjLocList.action")
	public Map<String,Object> queryLocDetailListByPages(LocDetailCondition locDetailCon){
		if(locDetailCon.getLoc_no()==null || locDetailCon.getLoc_no().equals("")) {
			return null;
		}
		Map<String,Object>map=locDetailService.queryLocDetailList(locDetailCon);
		return map;
	}
	
	/**
	 * 分页查询所有
	 * @param pageNumber
	 * @param pageSize
	 * @return
	 */
//	@ResponseBody
//	@RequestMapping("/adjDetailList.action")
//	public Map<String,Object> queryAdjDetailListByPages(AdjDetailCondition adjDetailCon){
//		Map<String,Object>map=adjDetailService.queryAdjDetailList(adjDetailCon);
//		return map;
//	}
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/queryAdjDetailById.action")
	public AdjDetailBean queryAdjDetailById(@RequestParam("did")int id){
		try {
			return adjDetailService.queryAdjDetailById(id);
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/queryAdjLocById.action")
	public LocDetailBean queryAdjLocById(@RequestParam("loc_no")String loc_no,
			@RequestParam("mat_no")String mat_no,HttpServletRequest request){
		try {
			return locDetailService.queryLocDetailById(loc_no, mat_no);
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 验证物料编号是否存在
	 * @param did
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/checkCode.action")
	public Map<String,Object> checkMatCode(@RequestParam("did")String id,@RequestParam("loc_no")String loc_no){		
		Map<String,Object> map=new HashMap<String, Object>();
//		boolean flag=userService.validUserAccount(account, uid);
		try {
			MatCodeBean matCode = matCodeService.queryMatCodeById(id);
			LocationBean location = locationService.queryLocationById(loc_no);
			if(matCode!=null && location!=null){
				map.put("msg", "代号可用");
			}else{
				map.put("msg", "库位号/物料号不存在");
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return map;
	}
	
	/**
	 * 验证代号是否唯一
	 * @param did
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/checkAdjDetail.action")
	public Map<String,Object> checkAdjDetail(@RequestParam("did")int id){		
		Map<String,Object> map=new HashMap<String, Object>();
//		boolean flag=userService.validUserAccount(account, uid);
		try {
			AdjDetailBean AdjDetail = adjDetailService.queryAdjDetailById(id);
			if(AdjDetail==null){
				map.put("msg", "代号可用");
			}else{
				map.put("msg", "代号不可用");
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return map;
	}
	
	/**
	 * 修改信息
	 * @param adjDetailCon
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/upAdjDetail.action")
	public Integer upAdjDetail(AdjDetailCondition adjDetailCon,HttpServletRequest request){
		int result = 0;
		try {
			UserBean user=(UserBean)request.getSession().getAttribute("USER");
			String loc_no = adjDetailCon.getLoc_no();
			String mat_no = adjDetailCon.getMat_no();
			LocDetailBean locDetail = locDetailService.queryLocDetailById(loc_no, mat_no);
			if (locDetail != null) {
				if(adjDetailCon.getAdj_qty()!=0) {
					int qty = locDetail.getQty()>=adjDetailCon.getAdj_qty() ? (locDetail.getQty() + adjDetailCon.getAdj_qty()) : 0;
					locDetail.setQty(qty);
				}
				if(adjDetailCon.getAdj_ctns()!=0) {
					int ctns = locDetail.getCtns()>=adjDetailCon.getAdj_ctns() ? (locDetail.getCtns() + adjDetailCon.getAdj_ctns()) : 0;
					locDetail.setCtns(ctns);
				}
				if(adjDetailCon.getAdj_wt()!=0 ) {
					double wt = locDetail.getWt()>=adjDetailCon.getAdj_wt() ? (locDetail.getWt() + adjDetailCon.getAdj_wt()) : 0;
					locDetail.setWt(wt);
				}
				locDetail.setMemo(adjDetailCon.getMemo());
				result = locDetailService.upLocDetail(locDetail);
				
				if(result>0) {
					AdjDetailBean adjDetail = new AdjDetailBean();
					adjDetail.setLoc_no(loc_no);
					adjDetail.setMat_no(mat_no);

					adjDetail.setS_qty(adjDetailCon.getQty());
					adjDetail.setS_ctns(adjDetailCon.getCtns());
					adjDetail.setS_wt(adjDetailCon.getWt());
					adjDetail.setAdj_qty(adjDetailCon.getAdj_qty());
					adjDetail.setAdj_ctns(adjDetailCon.getAdj_ctns());
					adjDetail.setAdj_wt(adjDetailCon.getAdj_wt());
					adjDetail.setQty(locDetail.getQty());
					adjDetail.setCtns(locDetail.getCtns());
					adjDetail.setWt(locDetail.getWt());
					adjDetail.setMemo(adjDetailCon.getMemo());
					adjDetail.setModi_user(user.getUser_account());
					adjDetailService.insertAdjDetail(adjDetail);
				}
			}
			
			if(result>0) {
				// 插入日志
//				UserBean user = (UserBean) request.getSession().getAttribute("USER");
				SysLogBean sysLog = new SysLogBean();
				sysLog.setLogin_no(user.getUser_account());
				sysLog.setMachine_ip(request.getRemoteAddr());
				sysLog.setForm_no("upAdjDetail.action");
				sysLog.setTts_keyname("库存调整修改明细:" + adjDetailCon.getLoc_no() + "-"+ adjDetailCon.getMat_no());
				sysLog.setModi_user(user.getUser_account());
				sysLogService.insertSysLog(sysLog);
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 删除信息
	 * @param id
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/delAdjDetl.action")
	public int delAdjDetail(@RequestParam("loc_no")String loc_no,
			@RequestParam("mat_no")String mat_no,HttpServletRequest request){
		int result = 0;
		UserBean user = (UserBean) request.getSession().getAttribute("USER");
		try {					
			LocDetailBean locDetail = locDetailService.queryLocDetailById(loc_no, mat_no);
			if (locDetail != null) {
				result = locDetailService.delLocDetail(loc_no, mat_no);

				if(result>0) {
					AdjDetailBean adjDetail = new AdjDetailBean();
					adjDetail.setLoc_no(loc_no);
					adjDetail.setMat_no(mat_no);

					adjDetail.setS_qty(locDetail.getQty());
					adjDetail.setS_ctns(locDetail.getCtns());
					adjDetail.setS_wt(locDetail.getWt());
					adjDetail.setAdj_qty(0-locDetail.getQty());
					adjDetail.setAdj_ctns(0-locDetail.getCtns());
					adjDetail.setAdj_wt(0-locDetail.getWt());
					adjDetail.setQty(0);
					adjDetail.setCtns(0);
					adjDetail.setWt(0);
//					adjDetail.setMemo("");
					adjDetail.setModi_user(user.getUser_account());
					adjDetailService.insertAdjDetail(adjDetail);
				}
			}
			
			if(result>0) {
				// 插入日志
//				UserBean user = (UserBean) request.getSession().getAttribute("USER");
				SysLogBean sysLog = new SysLogBean();
				sysLog.setLogin_no(user.getUser_account());
				sysLog.setMachine_ip(request.getRemoteAddr());
				sysLog.setForm_no("delAdjDetail.action");
				sysLog.setTts_keyname("库存调整删除明细:" + loc_no+"-"+mat_no);
				sysLog.setModi_user(user.getUser_account());
				sysLogService.insertSysLog(sysLog);
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 查询所有
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/getAdjDetail.action")
	public List<AdjDetailBean> getAdjDetail(){
		try {
			return adjDetailService.getAdjDetailList();
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}		
	}
	
}