import java.io.*;
import javax.servlet.*;
import java.sql.*;
import java.util.*;
import java.text.DateFormat;

import Base.Action.*;
import Base.DataBean.*;

public class InitWeek extends Action
{ 

       DefaultDataBean m_dBean = null;
       Statement stmt=null;
       private int termmark;
       private String start,end,termstart,termend;
       java.util.Date startdate,enddate,middle;
        public int perform(DefaultDataBean dBean)  throws IOException, ServletException
        {
              m_dBean = dBean;
              int weeknum;
			//高翔修改
	      System.out.println("here ok!");		
              termstart = dBean.getAttributeStr("termweek.start");
	      termend=dBean.getAttributeStr("termweek.end");
	      termmark=Integer.parseInt(dBean.getAttributeStr("termweek.id"));
	      DateFormat df = DateFormat.getDateInstance();
	      System.out.println(termstart);
              try {
                       startdate = df.parse(termstart);
                       enddate=df.parse(termend);
                       middle=df.parse(termstart);
              }
              catch(Exception e) {
              	       System.out.println("here ok1");	
                      setError(2001,"內部錯誤"); return 0; 
             }
             stmt = (Statement)dBean.getAttribute("Action.perform.Statement");
        	 if(stmt == null ) { setError(1000,"數據庫連接失敗 (no Statement object)");System.out.println("here ok2");	 return 0; }
        	 
             if(startdate.getDay()!=0){
             	weeknum=1;
             	start=df.format(startdate);
             	startdate.setTime(startdate.getTime()+(7-startdate.getDay())*24*60*60*1000);
             	end=df.format(startdate);
             	int i=1;
             	if(!addweek(termmark,weeknum,start,end)){
             			setError(1000,"數據庫更新失敗 (no Statement object)");
             			System.out.println("here ok3");	
             			return 0;
             			}
             	System.out.println("asd");
             	while((startdate.getTime()+24*60*60*1000*7)<=enddate.getTime()){
             		System.out.println("come here!");
             		weeknum=weeknum+1;
             		System.out.println("come here0");
             		middle.setTime(startdate.getTime()+24*60*60*1000);
             		System.out.println("come here1");
             		start=df.format(middle);
             		System.out.println("come here2");
             		startdate.setTime(startdate.getTime()+24*60*60*1000*7);
             		System.out.println("come here3");
             		end=df.format(startdate);
             		System.out.println("come here4");
             		i=i+1;
             		if(!addweek(termmark,weeknum,start,end)){
             			setError(1000,"數據庫更新失敗 (no Statement object)");
             			System.out.println("here ok4");	
             			return 0;
             			}             		
             		}
             	if(enddate.getDay()!=0){
             		weeknum=weeknum+1;
             		middle.setTime(startdate.getTime()+24*60*60*1000);
             		start=df.format(middle);
             		end=df.format(enddate);
             		if(!addweek(termmark,weeknum,start,end)){

             			setError(1000,"數據庫更新失敗 (no Statement object)");
             			return 0;
             			}
             		}	
             	}else{
             	int i=1;
             	weeknum=0;
             	while((startdate.getTime()+24*60*60*1000*7)<=enddate.getTime()){
             		weeknum=weeknum+1;
             		middle.setTime(startdate.getTime()+24*60*60*1000);
             		start=df.format(middle);
             		startdate.setTime(startdate.getTime()+24*60*60*1000*7);
             		end=df.format(startdate);
             		i=i+1;
             		if(!addweek(termmark,weeknum,start,end)){
             			setError(1000,"數據庫更新失敗 (no Statement object)");
             			return 0;
             			}             		
             		}
             	if(enddate.getDay()!=0){
             		weeknum=weeknum+1;
             		middle.setTime(startdate.getTime()+24*60*60*1000);
             		start=df.format(middle);
             		end=df.format(enddate);
             		if(!addweek(termmark,weeknum,start,end)){
             			setError(1000,"數據庫更新失敗 (no Statement object)");
             			return 0;
             			}
             		}
             	}
             	return 1;
        }
        private boolean addweek(int termmark,int weeknum,String start,String end){
        	boolean result=false;
        	String sqlstr="insert into kjc_termweek (termmark,weeknum,start,end) values("+termmark+","
        	+weeknum+",'"+start+"','"+end+"')";
        	System.out.println(sqlstr);	
        	try{
        	int a=stmt.executeUpdate(sqlstr);
        	if(a==1){
        	result=true;
                }
                }catch(Exception e){
                System.out.println(e.toString());
        	setError(1000,"數據庫更新失敗 (no Statement object)");
             	return result;
        	}
                return result;
       }
        void setError(int errCode ,String errReason)
        {
             if(m_dBean != null)
             {
             	if(errReason == null) { errReason = new String(""); errCode = 101; }
             	m_dBean.putAttribute("Action.perform.errReason",errReason );
             	m_dBean.putAttribute("Action.perform.errCode",new Integer(errCode) );
             }
             return;
        }



}