package com.shlanbao.tzsc.pms.sch.calendar.service.impl;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.FillUserInfoUtil;
import com.shlanbao.tzsc.utils.tools.LogAnno;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.shlanbao.tzsc.base.dao.SchCalendarDaoI;
import com.shlanbao.tzsc.base.mapping.MdShift;
import com.shlanbao.tzsc.base.mapping.MdTeam;
import com.shlanbao.tzsc.base.mapping.SchCalendar;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.sch.calendar.beans.CalendarBean;
import com.shlanbao.tzsc.pms.sch.calendar.service.CalendarServiceI;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;

import freemarker.template.utility.StringUtil;

import javax.servlet.http.HttpServletRequest;

@Service
public class CalendarServiceImpl extends BaseService implements CalendarServiceI{
	@Autowired
	private SchCalendarDaoI schCalendarDao;
	@Autowired
	private HttpServletRequest request;
	@Override
	public List<CalendarBean> getCurMonthCalendars(String date, String workshop)
			throws Exception {
				/* String hql = "from SchCalendar o left join fetch o.mdTeam t left join fetch o.mdShift s where 1=1 and  to_char(o.date,'yyyy-mm')='"+date.substring(0, 7)+"' and o.mdWorkshop.code='"+workshop+"' order by o.mdShift.code asc";
				List<SchCalendar> list=schCalendarDao.query(hql);*/
				StringBuffer sb=new StringBuffer("select ms.name as shiftName,mt.name as teamName, ");
				sb.append("sc.id,to_char(sc.date_,'yyyy-mm-dd') ,to_char(sc.stim,'yyyy-mm-dd hh24:mi:ss') ,to_char(sc.etim,'yyyy-mm-dd hh24:mi:ss'),sc.workshop ");
				sb.append("from sch_calendar sc ");
				sb.append("left join md_shift ms on ms.id=sc.shift ");
				sb.append("left join md_team mt on mt.id=sc.team ");
				sb.append("where to_char(sc.date_,'yyyy-mm')='"+date.substring(0, 7)+"' ");
				sb.append("and sc.workshop='"+workshop+"' ");
				sb.append("order by ms.code asc");
				List<?> ls=schCalendarDao.queryBySql(sb.toString());
				List<CalendarBean> calendarBeans=new ArrayList<CalendarBean>();
				CalendarBean calendarBean = null;
				Object[] str=null;
				if(ls!=null && ls.size()>0){
					for (Object obj : ls) {
						calendarBean=new CalendarBean();
						str=(Object[]) obj;
						calendarBean.setShift(StringUtil.tryToString(str[0]));
						calendarBean.setTeam(StringUtil.tryToString(str[1]));
						calendarBean.setId(StringUtil.tryToString(str[2]));
						calendarBean.setDate(StringUtil.tryToString(str[3]));
						calendarBean.setStim(StringUtil.tryToString(str[4]));
						calendarBean.setEtim(StringUtil.tryToString(str[5]));
						calendarBean.setWorkshop(StringUtil.tryToString(str[6]));
						calendarBeans.add(calendarBean);
						calendarBean = null;
					}
				}
				return calendarBeans;
	}

	@LogAnno(operateType = "更新选择日期的排班")
	@Override
	public void updateSelectDate(Map<String, String> param) {
		for(int i = 0 ; i< 3 ;i++){
			if(param.containsKey("id"+i)){
				SchCalendar calendar = schCalendarDao.findById(SchCalendar.class, param.get("id" + i));
				Date sdate = DateUtil.formatStringToDate(param.get("stime" + i), "yyyy-MM-dd HH:mm:ss");
				Date edate = DateUtil.formatStringToDate(param.get("etime" + i), "yyyy-MM-dd HH:mm:ss");
				calendar.setStim(sdate);
				calendar.setEtim(edate);
				FillUserInfoUtil.fillUpdateUserInfo(calendar,request);
				schCalendarDao.update(calendar);
			}


		}

	}

	@Override
	public List<SchCalendar> getNowCalendars() {
		 return  schCalendarDao.query("from SchCalendar o where sysdate between o.stim and o.etim");
	}
}