package cn.com.lzt.car.alarm;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.com.lzt.car.carfleet.entity.CarFleetEntity;
import org.apache.commons.lang.xwork.StringUtils;
import org.apache.log4j.Logger;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.util.DateUtils;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.tag.vo.datatable.SortDirection;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

@Controller
@RequestMapping("/carAlarmController")
public class CarAlarmController {
	private static final Logger logger = Logger.getLogger(CarAlarmController.class);
	@Autowired
	SystemService systemService; 
	/**
	 * 预警统计列表 页面跳转
	 * 
	 * @return
	 */
	@RequestMapping(params = "list")
	public ModelAndView list(HttpServletRequest request) {
		return new ModelAndView("cn/com/lzt/car/alarm/carAlarmList");
	}
	
	/**
	 * easyui AJAX请求数据
	 * 
	 * @param request
	 * @param response
	 * @param dataGrid
	 */

	@RequestMapping(params = "datagrid")
	public void datagrid(CarAlarmEntity alarm,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(CarAlarmEntity.class, dataGrid);
//		预警类型
		String alarmtypeid = request.getParameter("alarmtypeid");
		// 查询条件组装器
		if (StringUtils.isNotBlank(alarmtypeid)) {
			cq.eq("alarm_type_id", alarmtypeid);
		}
		//档案类型
		String archiveType = request.getParameter("archiveType");
		if (StringUtils.isNotBlank(archiveType)) {
			cq.eq("archiveType", Integer.valueOf(archiveType));
		}
		//预警级别
		String alarmLevel = request.getParameter("alarmLevel");
		if (StringUtils.isNotBlank(alarmLevel)) {
			cq.eq("alarmLevel", Integer.valueOf(alarmLevel));
		}
		//预警时间
		String alarmtime_begin = request.getParameter("alarmtime_begin");
		String alarmtime_end = request.getParameter("alarmtime_end");
		try {
			if(StringUtils.isNotEmpty(alarmtime_begin)) {
				long begin = DateUtils.getMillis(DateUtils.datetimeFormat.parse(alarmtime_begin+" 00:00:00")) / 1000;
				cq.ge("alarm_time", String.valueOf(begin));
			}
			if( StringUtils.isNotEmpty(alarmtime_end)) {
				long end = DateUtils.getMillis(DateUtils.datetimeFormat.parse(alarmtime_end+" 23:59:59")) / 1000;
				cq.le("alarm_time", String.valueOf(end));
			}
		} catch (ParseException e) {
			logger.error(e.getMessage());
			e.printStackTrace();
		}
		cq.addOrder("alarm_time", SortDirection.desc);
		//处理状态
		String status = request.getParameter("status");
		if(StringUtils.isNotEmpty(status)) {

			cq.eq("status", Integer.valueOf(status));
		}
		//查询条件组装器
		cq.add();
		this.systemService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}
	//原预警明细
	@RequestMapping(params = "datagridOld")
	public void datagridOld(CarAlarmEntity alarm,HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
		CriteriaQuery cq = new CriteriaQuery(CarAlarmEntity.class, dataGrid);

		String carid = request.getParameter("carid");
		// 查询条件组装器
		if (StringUtils.isNotBlank(carid)) {
			cq.eq("carid", carid);
		}

		String plate = request.getParameter("plate");
		if (StringUtils.isNotBlank(plate)) {
			// 模糊查询
			cq.like("plate", "%" + plate + "%");
			alarm.setPlate(null);
		}
		String cartype = request.getParameter("cartype");
		if(StringUtils.isNotEmpty(cartype)) {
			List<String> caridList = systemService.findListbySql("select id from t_b_car where type = '"+cartype+"'");
			cq.in("carid", caridList.toArray());
		}
		String alarmtime_begin = request.getParameter("alarmtime_begin");
		String alarmtime_end = request.getParameter("alarmtime_end");
		try {
			if(StringUtils.isNotEmpty(alarmtime_begin)) {
				long begin = DateUtils.getMillis(DateUtils.datetimeFormat.parse(alarmtime_begin+" 00:00:00")) / 1000;
				cq.ge("alarm_time", String.valueOf(begin));
			}
			if( StringUtils.isNotEmpty(alarmtime_end)) {
				long end = DateUtils.getMillis(DateUtils.datetimeFormat.parse(alarmtime_end+" 23:59:59")) / 1000;
				cq.le("alarm_time", String.valueOf(end));
			}
		} catch (ParseException e) {
			logger.error(e.getMessage());
			e.printStackTrace();
		}
		cq.addOrder("alarm_time", SortDirection.desc);
		//查询条件组装器
		cq.add();
		this.systemService.getDataGridReturn(cq, true);
		TagUtil.datagrid(response, dataGrid);
	}
	@RequestMapping(params = "goUpdate")
	public ModelAndView goUpdate(CarAlarmEntity carAlarm, HttpServletRequest req) {
		if (StringUtil.isNotEmpty(carAlarm.getId())) {
			carAlarm = this.systemService.getEntity(CarAlarmEntity.class, carAlarm.getId());
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
			String dateStr = sdf.format(new Date(Long.parseLong(carAlarm.getAlarm_time()) * 1000));
			carAlarm.setAlarmDate(dateStr);
			req.setAttribute("entity", carAlarm);
		}
		return new ModelAndView("cn/com/lzt/car/alarm/carAlarm-update");
	}
	
}