<?

date_default_timezone_set("Asia/Bangkok");

function prn_curiculum($sel=''){
    $ret = '<SELECT NAME="CURICULUM"><option value="2551">2551</option></SELECT>';
    return $ret;
}

function get_cur_term(){
    $m = date("md");
    if($m >= 0401 && $m <= 1016) {return 1;}
    else {return 2;}
}

function get_cur_year_ed(){
    $y = date("Y") +543;
    $m = date("md");
    if(get_cur_term()==2 && $m <0401 ){return ($y-1);}
    else return $y;
}

function prn_year($sel=0){
    if($sel==0) $sel = get_cur_year_ed();
    $ret = "<SELECT NAME='YEAR'>";
    for($i=get_cur_year_ed()-8;$i<=get_cur_year_ed()+5;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i'  $selected>  $i &nbsp; &nbsp; &nbsp; </option>";    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function prn_term($sel=0){
    if($sel==0) $sel = get_cur_term();
    $ret = "<SELECT NAME='TERM'>";
    $ret .= "<option value='0'> เลือก </option>";
    for($i=1;$i<=2;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i'  $selected> ภาคเรียนที่ $i &nbsp; &nbsp; &nbsp; </option>";    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function prn_days($sel=''){
    global $days;
    $ret = "<SELECT NAME='DAY'>";
    $ret.= "<option value='0'> เลือก </option>";
    for($i=1;$i<=7;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i'  $selected> $days[$i] &nbsp; &nbsp; &nbsp; </option>";    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function check_save_logteach($date1,$date2){
    global $db ;
    $d1 = sprintf("%4d-%02d-%02d",date("Y",$date1) +543, date( "n", $date1),date( "j",$date1));
    $d2 = sprintf("%4d-%02d-%02d",date("Y",$date2) +543, date( "n", $date2),date( "j",$date2));
    $row = $db->num_rows(TB_logteach,"*","date_teach BETWEEN '$d1' AND '$d2'");
    if($row >1 ) {
        return true ;
    }
    else {
        return false ;
    }
}

function prn_week($y=0 , $t=0, $sel=''){
    global $thai_month_short ;
    if($t==0) $t = get_cur_term();
    if($y==0) $y = get_cur_year_ed();
    $y = $y - 543 ;
    $weekn =($t==1) ? date("W", strtotime("1-5-" . $y) ) : date("W", strtotime("12-10-" . $y) );
    $ret = "<SELECT NAME='WEEK'>";
    $ret.= "<option value='0'> เลือก </option>";
    for($i=0; $i<=24; $i++){
        $ii = $i;
        $selected = ($sel == $ii)? " selected " : " " ;
        $w  = ($weekn+$i >52) ? $weekn+$i -52 : $weekn+$i;
        if(strlen($w)<=1) $w = "0" . $w ;
        $yy = ($weekn+$i >52) ? $y+1 : $y ;
        $date1 = strtotime($yy."W".$w."0");
        $date2 = strtotime($yy."W".$w."6") ;
        $m1 = date( "n", $date1 ); // First day of week mount
        $m2 = date( "n", $date2 ); // Last day of week mount
        $d1 = date( "j", $date1 ); // First day of week
        $d2 = date( "j", $date2 ); // Last day of week
        if(strlen($d1)<=1) $d1 = "&nbsp; " . $d1 ;
        if(strlen($d2)<=1) $d2 = "&nbsp; " . $d2 ;

        if($ii <= 9) $d1 = "&nbsp;" . $d1 ;
        $ss = (check_save_logteach($date1,$date2))? "S" : "";
        $ret.= "<option value='$ii'  $selected> $ii &nbsp; &nbsp; $d1 $thai_month_short[$m1] - $d2 $thai_month_short[$m2] $ss</option>";    }
    $ret.= "</SELECT>\n";
    return $ret;
}
function get_date($yb=0 , $t=0, $w=0,$dw){
    $y = $yb - 543 ;
    //if($t==2 && $w<=15) $y++;
    $wstart =($t==1) ? date("W", strtotime("1-5-" . $y) ) : date("W", strtotime("12-10-" . $y) );
    $weekn =  ($wstart + $w > 52) ? $wstart + $w -52 : $wstart + $w ;
    $yy    = ($wstart + $w > 52) ? $y+1 : $y ;
    if(strlen($weekn)<=1) $weekn = "0" . $weekn ;
    $dw-=1;
    $yyy = date( "Y", strtotime($yy."W".$weekn.$dw) );
    $m = date( "n", strtotime($yy."W".$weekn.$dw) );
    $d = date( "j", strtotime($yy."W".$weekn.$dw) );
    return   sprintf("%4d-%02d-%02d",$yyy+543,$m,$d);
}
function get_date_th($yb=0 , $t=0, $w=0,$dw){
    global $thai_month_short ;
    $d = get_date($yb , (int) $t , (int) $w ,$dw);
    $b = explode("-",$d);
    return $b[2] ." " . $thai_month_short[(int)$b[1]] ;
}

function prn_class($sel=''){
    $ret = "<SELECT NAME='CLASS'>";
    $ret.= "<option value='0'> เลือก </option>";
    for($i=1;$i<=6;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i' $selected> มัธยมศึกษาปีที่ $i </option>";
    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function prn_room($sel=''){
    $ret = "<SELECT NAME='ROOM'>";
    $ret.= "<option value='0'> เลือก </option>";
    for($i=1;$i<=15;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i' $selected> $i </option>";
    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function prn_period($sel=''){
    $ret = "<SELECT NAME='PERIOD'>";
    $ret.= "<option value='0'> เลือก </option>";
    for($i=1;$i<=9;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i' $selected> $i </option>";
    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function prn_numperiod($sel=''){
    $ret = "<SELECT NAME='NUMPERIOD'>";
    for($i=1;$i<=4;$i++){
        $selected = ($sel == $i)? " selected " : " " ;
        $ret.= "<option value='$i' $selected> $i </option>";
    }
    $ret.= "</SELECT>\n";
    return $ret;
}

function prn_subject_list($sel='',$where=''){
    global $db;
    //$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
    $res['subject'] = $db->select_query("SELECT * FROM ".TB_subject." ORDER BY code ");
    $ret = "<SELECT NAME='CODE'><option>เลือก</option>";
    while ($arr['subject'] = $db->fetch($res['subject'])){
            $select = ($arr['subject']['code'] == $sel) ? " selected " : " ";
            $ret.= "<option value=\"".$arr['subject']['code']."\"" . $select ;
            $ret.= ">".$arr['subject']['code'] . " " .$arr['subject']['name']."</option>";
    }
    $ret.= "</SELECT>	";
    return $ret ;
}

function prn_teacher_list($sel='',$where=''){
    global $db;
    if($sel=='') $sel=$_SESSION['user_user'];
    //$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
    $res['teacher'] = $db->select_query("SELECT * FROM ".TB_user." ORDER BY id ");
    $ret = "<SELECT NAME='TEACHER'><option>เลือก</option>";
    while ($arr['teacher'] = $db->fetch($res['teacher'])){
            $select = ($arr['teacher']['username'] == $sel) ? " selected " : " ";
            $ret.= "<option value=\"".$arr['teacher']['username']."\"" . $select ;
            $ret.= ">".$arr['teacher']['category_name'] . "</option>";
    }
    $ret.= "</SELECT>	";
    return $ret ;
}

function prn_class_list($sel='',$where=''){
    global $db;
    if($sel=='') $sel=$_SESSION['user_user'];
    //$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
    $res['room'] = $db->select_query("SELECT * FROM ".TB_mt_room." ORDER BY room ");
    $ret = "<SELECT NAME='CLASSROOM'><option value=''>เลือก</option>";
    while ($arr['room'] = $db->fetch($res['room'])){
            $select = ($arr['room']['room'] == $sel) ? " selected " : " ";
            $ret.= "<option value=\"".$arr['room']['room']."\"" . $select ;
            $ret.= ">".$arr['room']['room']. " " . $arr['room']['rname'] . "</option>";
    }
    $ret.= "</SELECT>	";
    return $ret ;
}

function hspace($c=1){return str_repeat("&nbsp;",$c); }

function get_teach_table($u="",$y='',$t=''){
    global $db;
    $aret = array();
    if($u=='') $u=$_SESSION['user_user'];   
    if($y==0) $y = get_cur_year_ed();
    if($t==0) $t = get_cur_term();
    $sql  = "SELECT * FROM ".TB_teach_table;
    $sql .=" WHERE teacher ='" . $u ."' AND year=" . $y ." AND term=" . $t ." ";
    $res['dat'] = $db->select_query($sql); 
    while ($arr['dat'] = $db->fetch($res['dat'])){
        $ress = $db->select_query("SELECT * FROM ".TB_subject . " WHERE code='" . $arr['dat']['code']."'");
        $arrs =$db->fetch($ress);
        $aret[$arr['dat']['day']][$arr['dat']['period']] = array_merge($arr['dat'],array("name"=>$arrs['name']));
    }
    return $aret;
}

function prn_teach_table($a = array()){
    global $periodtime ,$days;
    $style="left=25px;border-collapse: collapse;";
    $ret = "<table border=1 style='$style' ><tr><td> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </td>";
    for($i=1;$i<=9;$i++) $ret .= "<td align=center>" .$i."<br>". $periodtime[$i] . "-" . $periodtime[$i+1] . "</td>"; 
    $ret .= "</tr>";
    for($i=2;$i<=6;$i++){
        $ret .= "<tr><td align=center>" . $days[$i] . "</td>";
        for($j=1;$j<=9;$j++){
            if(isset($a[$i][$j])){
                $ret .= "<td align=center colspan=" . $a[$i][$j]['numperiod'] ;
                $ret .= " title='" . $a[$i][$j]['name'] ."' >";
                $ret .= $a[$i][$j]['code'] ."\n<br>";
                if($a[$i][$j]['class'] != 0){
                    $ret .= "ม.". $a[$i][$j]['class'] ;
                    if($a[$i][$j]['room'] !=0)
                        $ret .= "/" .$a[$i][$j]['room'] ."\n";
                }
                $ret .= $a[$i][$j]['classroom'] ."</td>";
                $j += $a[$i][$j]['numperiod'] -1;
            }else {
                $ret .= "<td> </td>";
            }
        }
        $ret .= "</tr>";
    }
    $ret .= "</table>";

    return $ret ;
}


function getStartAndEndDate($week, $year) {
    $dto = new DateTime();
    $dto->setISODate($year, $week);
    $ret['week_start'] = $dto->format('Y-m-d');
    $dto->modify('+6 days');
    $ret['week_end'] = $dto->format('Y-m-d');
    return $ret;
  }
  
  //$week_array = getStartAndEndDate(52,2013);
  //print_r($week_array);
?>