<?
	//******判斷該時段該學員是否有預約******//
	//判定現在為何時段
	/******時段更改時,這邊的時間要跟著改*******/
	function Chk_learnPeriod($date,$time){
	         $tmptime=split(":",$time);
			 //require_once('global.ini.php');
			 //$tmpsq=$timesq;
			 
			 if(($tmptime[0]>="8" && $tmptime[0]<"12") || ($tmptime[0]=="12" && $tmptime[1]<="10")){
			 $timesq="0";
			 }
                         if(($tmptime[0]>"12" && $tmptime[0]<"15") || ($tmptime[0]=="15" && $tmptime[1]<="35") || ($tmptime[0]=="12" && $tmptime[1]>"10")){
                         $timesq="1";
                         }
			 if(($tmptime[0]>"15" && $tmptime[0]<"19") || ($tmptime[0]=="19" && $tmptime[1]<="10") || ($tmptime[0]=="15" && $tmptime[1]>"35")){
                         $timesq="2";
                         }
			 if(($tmptime[0]>"19" && $tmptime[0]<"22") || ($tmptime[0]=="19" && $tmptime[1]>"10") || ($tmptime[0]=="22" && $tmptime[1]<="10")){
			 $timesq="3";
			 }
	
	          return($timesq);
	} 
	
	
	//為了怕主機時間有誤,彈性放寬前後10分鐘
    function Chk_StuResered($db,$tb,$dept,$stu_from,$code,$date,$time){
             $timesq=Chk_learnPeriod($date,$time);
             
			 //select elearn數位學院內部系統的預約table
			 $link=start_db($db);
			 $sql="Select * From $tb Where stu_from='$stu_from' And code='$code' And date='$date' And timesq='$timesq' And dept_code='$dept' ";
			 $result=exec_db($sql,$link);
			 $num=mysql_num_rows($result);
			 
			 if($num==1){
			 $sql2="Select * From $tb Where stu_from='$stu_from' And code='$code' And date='$date' And timesq='$timesq' And dept_code='$dept' And reser_sta='y' ";
			 $result2=exec_db($sql2,$link);
			 $num2=mysql_num_rows($result2);
			    if($num2==1){
			       $sta="1";
				   $rs=fetch_db($result2);
				}else{
				   $sta="2";
				}      
			 }else{
			       $sta="0";
			 }
			 $Reserdata[0]=$sta;
			 $Reserdata[1]=$timesq;
			 $Reserdata[2]=$rs["nno"];
			 $Reserdata[3]=$rs["checkin_sta"];
			 $Reserdata[4]=$rs["checkin_date"];
			 
             return ($Reserdata);    
    
   }

   //******select 學生的點數資料*****************************************************/
   function select_stu_pt($db,$tb,$stufrom,$id){
           $link=start_db($db);
           $sql="Select code,pt_allbuy,pt_real,pt_canuse,pt_used,pt_allbuy_old,pt_canuse_old From $tb Where stu_from='$stufrom' AND code='$id' ";
		   $result=exec_db($sql,$link);
		   $num=mysql_num_rows($result);
		   if($num>0){
		   $rs=fetch_db($result);
		   $Arrdata=array($rs["pt_allbuy"],$rs["pt_real"],$rs["pt_canuse"],$rs["pt_used"],$rs["pt_allbuy_old"],$rs["pt_canuse_old"]);
		   }
           mysql_close();
           return  ($Arrdata);     
   
   }

   //******更新學員登入session id資料*****************************************************/
   function Up_stuloginSession($stufrom,$sq,$code,$sess){
           require('../include/global.ini.php');
		   //require('../include/db.ini.php');
           
		   $link=start_db($db_waywin_elearn_tp);
           if($stufrom=="1")           
		     $tb=$tb_member_f;
		   else
		     $tb=$tb_member_e;
			 	 
		   //先檢查該時段是否已登入過
		   $sql1="SELECT sn FROM $tb WHERE memberAcount='$code' AND SUBSTRING(last_login_inter,1,10)='".$ymd_back10."' AND timesq='$sq' AND login_sess!='' ";
		   $result=exec_db($sql1,$link);
		   $num=mysql_num_rows($result);
		   
		   //有跳出登出視窗,沒有則寫入session id
		   if($num==1){
		      $Res='y';
		   }else{
		      $Res='n';
			  session_regenerate_id();//重新發配SESSION_ID
              $sql="UPDATE $tb SET timesq='$sq',login_sess='".session_id()."' WHERE memberAcount='$code' ";
		      $result=exec_db($sql,$link);
              $_SESSION[timesq]=$sq;//紀錄觀看的時段
		   }
           mysql_close();
           return($Res);     
   
   }

	
?>