package UIC.UIC02;

import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import UIB.COM.XmlSqlParsersFactory;

import CoreFS.SA01.CoreIComponent;
import CoreFS.SA06.CoreReturnObject;

public class UIC020120 extends CoreIComponent{
	
	public CoreReturnObject query(String queryDate,String queryDate1,String queryDate2) throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIC020150_02.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,//
				new Object[] {
						queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2,
						queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate1,queryDate2,queryDate2,queryDate2,queryDate2	
						});
	}
	
	public CoreReturnObject queryhot(String queryDate,String queryDate1,String queryDate2) throws SQLException {
		String sql = XmlSqlParsersFactory.getSql("UIC020140_02.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql,//
				new Object[] {
						queryDate,queryDate1,queryDate,queryDate1,queryDate,queryDate
						
						});
	}
	
	public CoreReturnObject queryTeam(String queryDate,String queryDate1,String queryDate2) throws SQLException, ParseException {
		
		String sql = "delete from SCM_GROUP_3QDATETEST";
		this.getDao("KgDao").ExcuteNonQuery(sql);
		
		String[] s1 = new String[] {"晚","晚","休","早","早","中","中","休"};	//甲
		String[] s2 = new String[] {"休","早","早","中","中","休","晚","晚"};	//乙
		String[] s3 = new String[] {"早","中","中","休","晚","晚","休","早"};	//丙
		String[] s4 = new String[] {"中","休","晚","晚","休","早","早","中"};	//丁
		
		long beginTime = getDaySub("20210601", queryDate.substring(0, 8));
		long endTime = getDaySub("20210601", queryDate1.substring(0, 8));
		
		int a = (int) (beginTime%8);
		int b = (int) (endTime - beginTime);
		
		String z5 = "";		//时间
		
		for(int i=0 ; b!=-1; b--,a++)
		{
			if(a==8) {
				a=0;
			}
			
			String z1 = s1[a];	//甲
			String z2 = s2[a];	//乙
			String z3 = s3[a];	//丙
			String z4 = s4[a];	//丁
			if(i==0) {
				z5 = queryDate.substring(0, 8);
				i++;
			}
			else
			{
				z5 = autoIncrease(z5);
			}
			String sql1 = "insert into SCM_GROUP_3QDATETEST (JIA,YI,BING,DING,SDATE) values(?, ?, ?, ?, ?)";
			this.getDao("KgDao").ExcuteNonQuery(
					sql1,
					new Object[] {
							z1, z2, z3, z4, z5
							});
		}

		
		String sql2 = XmlSqlParsersFactory.getSql("UIC020140_03.SELECT");
		return this.getDao("KgDao").ExcuteQuery(
				sql2,
				new Object[] {
						queryDate.substring(0, 8),queryDate1.substring(0, 8),queryDate.substring(0, 6)
						});
	}
	
	/**
     * 时间相减得到天数
     * @param beginStr
     * @param endStr
     * @return
     * long
     * @author zengmingzan
     */
	public static long getDaySub(String beginStr,String endStr)
	{
       long day=0;
       SimpleDateFormat sdf= new SimpleDateFormat("yyyyMMdd");
       Date begin;
       Date end;
       try
       {
           begin = sdf.parse(beginStr);
           end = sdf.parse(endStr);
           day =(end.getTime()-begin.getTime())/(24*60*60*1000);
       } catch (ParseException e){
           e.printStackTrace();
       }
       return day;
	}
	
	/**
     * 日期自增
     * @param time
     * @return
     * String
     * @author zengmingzan
     */
	public static String autoIncrease(String time)
	{
		SimpleDateFormat sdf= new SimpleDateFormat("yyyyMMdd");
        Date oldTime;
        Date newTime = new Date();
        String nextTime = "";
        try
        {
            oldTime = sdf.parse(time);
            long old = oldTime.getTime() + (24*60*60*1000);
            newTime.setTime(old);
            nextTime = sdf.format(newTime);
        } catch (ParseException e){
            e.printStackTrace();
        }
        return nextTime;
	}
	
}