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.LocationCondition;
import com.slcf.bean.LocationEntity;
import com.slcf.pojo.LocationBean;
import com.slcf.pojo.SysLogBean;
import com.slcf.service.LocationService;
import com.slcf.service.RoleService;
import com.slcf.service.SysLogService;
import com.slcf.util.AuthorityCode;

/**
 * 库位管理控制器层
 * @author admin
 * @date 2018年11月7日
 */
@Controller
@RequestMapping("/basic")
public class LocationController {

	@Resource
	LocationService locationService;
	@Autowired
	SysLogService sysLogService;
	@Autowired
	RoleService roleService;
	
	@RequestMapping("/goLocation.action")
	public String goLocationPage(HttpServletRequest request){
		try {
			String rid = request.getSession().getAttribute("ROLEID").toString();
			String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), 
					AuthorityCode.LocationCode);
			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("goLocation.action");
			sysLog.setTts_keyname("访问:库位管理");
			sysLog.setModi_user(user.getUser_account());
			sysLogService.insertSysLog(sysLog);
		}catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return "location";
	}
	
	/**
	 * 添加
	 * @param LocationEntity
	 * @param request
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/addLocation.action")
	public Integer insertLocation(LocationEntity location,HttpServletRequest request){
		int result=0;
		try {
			UserBean user=(UserBean)request.getSession().getAttribute("USER");			
			int srow = location.getS_row();
			int erow = location.getE_row();
			int sbay = location.getS_bay();
			int ebay = location.getE_bay();
			int slev = location.getS_lev();
			int elev = location.getE_lev();
			int whs_type = location.getWhs_type();			

			for(int i=srow; i<=erow; i++) {
				for(int j=sbay; j<=ebay; j++) {
					for(int k=slev; k<=elev; k++) {
						String loc_no = String.format("%02d", i) + String.format("%03d", j) + String.format("%02d", k);
						int crn_no = (i+1)/2;
						LocationBean loc = new LocationBean();
						loc.setLoc_no(loc_no);
						loc.setLoc_sts("O");
						loc.setModi_user(user.getUser_account());
						loc.setRow1(i);
						loc.setBay1(j);
						loc.setLev1(k);
						loc.setCrn_no(crn_no);
						loc.setWhs_type(whs_type);
						loc.setLoc_type(whs_type);   //库位类型
						locationService.insertLocation(loc);
						result++;
					}
				}
			}									
//			System.out.println(i+"++++++++++++");	
			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("addLocation.action");
				sysLog.setTts_keyname("初始化库位:排" + srow + "-" + erow + ",列" + sbay + "-" + ebay + ",层" + slev + "-" + elev);
				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("/locationList.action")
	public Map<String,Object> queryLocationListByPages(LocationCondition locationCon){
		Map<String,Object>map=locationService.queryLocationList(locationCon);
		return map;
	}
//	@ResponseBody
//	@RequestMapping("/locationList.action")
//	public Map<String,Object> queryLocationListByPages(
//			@RequestParam(value="pageNumber",defaultValue="1",required=false)int pageNumber,
//			@RequestParam("pageSize")int pageSize){
//		Map<String,Object>map=new HashMap<String, Object>();
//		try {
//			int count=locationService.queryLocationCount();
//			List<LocationBean>dlist=locationService.queryLocationList((pageNumber-1)*pageSize, pageSize);
//			map.put("total", count);
//			map.put("rows", dlist);			
//		}catch(Exception e) {
//			System.out.println(e.getMessage());
//		}
//		return map;
//	}
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/queryLocationById.action")
	public LocationBean queryLocationById(@RequestParam("did")String id){
		try {
			return locationService.queryLocationById(id);
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}
	}
	
	/**
	 * 验证工作代号是否唯一
	 * @param did
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/checkLocation.action")
	public Map<String,Object> checkLocation(@RequestParam("did")String id){		
		Map<String,Object> map=new HashMap<String, Object>();
//		boolean flag=userService.validUserAccount(account, uid);
		try {
			LocationBean Location = locationService.queryLocationById(id);
			if(Location==null){
				map.put("msg", "代号可用");
			}else{
				map.put("msg", "代号不可用");
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return map;
	}
	
	/**
	 * 修改信息
	 * @param LocationEntity
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/upLocation.action")
	public Integer upLocation(LocationBean location,HttpServletRequest request){
		int result = 0;
		try {
			UserBean user=(UserBean)request.getSession().getAttribute("USER");
			location.setModi_user(user.getUser_account());
			
			result=locationService.upLocation(location);
			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("upLocation.action");
				sysLog.setTts_keyname("修改库位:" + location.getLoc_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("/delLocation.action")
	public int delLocation(@RequestParam("did")String id,HttpServletRequest request){
		int result = 0;
		try {
			result=locationService.delLocation(id);
			
			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("delLocation.action");
				sysLog.setTts_keyname("删除库位,ID:" + id);
				sysLog.setModi_user(user.getUser_account());
				sysLogService.insertSysLog(sysLog);
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
	
	/**
	 * 查询所有
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/getLocation.action")
	public List<LocationBean> getLocation(){
		try {
			return locationService.getLocationList();
		}catch(Exception e) {
			System.out.println(e.getMessage());
			return null;
		}		
	}
	
	/**
	 * 重置库位表
	 * @return
	 */
	@ResponseBody
	@RequestMapping("/resetLocation.action")
	public int resetLocation(HttpServletRequest request){
		int result = 0;
		try {
			result=locationService.resetLocation();
			
			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("resetLocation.action");
				sysLog.setTts_keyname("重置库位表");
				sysLog.setModi_user(user.getUser_account());
				sysLogService.insertSysLog(sysLog);
			}
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}
		return result;
	}
	
	@ResponseBody
	@RequestMapping("/getRow.action")
	public Map<String,Object> getRow(){
		Map<String,Object> map=new HashMap<String, Object>();
		try {
			map.put("rows",locationService.getRowList()); 
		}catch(Exception e) {
			System.out.println(e.getMessage());
		}	
		return map;
	}
}