session_start(); /** Define Validate Access */ define( '_VALID_ACCESS', 1 ); /** Check Session User Login */ if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) { echo ""; echo "
กรุณาทำการ Login ก่อน
วัน / เดือน / ปี | เวลาเข้า | เวลาออก | หมายเหตุ |
".($i." ".$ThaiMonth[$month-1]." ".$year)." | "; $timeSplit = explode(":",date("H:i:s",strtotime($lateTimeFinish))); $this_date = mktime(date("H"),date("i"),date("s"),date("n"),date("j"),date("Y")); $select_date = mktime($timeSplit[0],$timeSplit[1],$timeSplit[2],date("n",strtotime($ymd)),date("j",strtotime($ymd)),date("Y",strtotime($ymd))); $sql = "select * from USERINFO , CHECKINOUT where USERINFO.Badgenumber = '".$_REQUEST['person']."' and USERINFO.USERID = CHECKINOUT.USERID and CHECKINOUT.CHECKTIME >= '".date("Y-m-d", strtotime($ymd))." ".date("H:i:s",strtotime($earlyTimeStart))."' and CHECKINOUT.CHECKTIME <= '".date("Y-m-d", strtotime($ymd))." ".date("H:i:s",strtotime($earlyTimeFinish))."' order by CHECKINOUT.CHECKTIME asc"; $mssql_conn->query($sql); if($mssql_conn->num_rows()){ $rs = $mssql_conn->getnext(); $checkin = 1; $checkin_time = date("H:i" , strtotime(substr($rs->CHECKTIME,-7))); //เข้างานปกติ } else{ $sql = "select * from USERINFO , CHECKINOUT where USERINFO.Badgenumber = '".$_REQUEST['person']."' and USERINFO.USERID = CHECKINOUT.USERID and CHECKINOUT.CHECKTIME >= '".date("Y-m-d", strtotime($ymd))." ".date("H:i:s",strtotime($lateTimeStart))."' and CHECKINOUT.CHECKTIME <= '".date("Y-m-d", strtotime($ymd))." ".date("H:i:s",strtotime($lateTimeFinish))."' order by CHECKINOUT.CHECKTIME asc"; $mssql_conn->query($sql); if($mssql_conn->num_rows()){ $rs = $mssql_conn->getnext(); $checkin = 2; $checkin_time = date("H:i" , strtotime(substr($rs->CHECKTIME,-7))); //เข้างานสาย } else{ if($select_date > $this_date) $checkin_time = "-"; else $checkin_time = "ไม่ลงเวลาเข้า"; $checkin = 3; //ขาดงาน } } echo "".$checkin_time." | "; $this_date = mktime(date("H"),date("i"),date("s"),date("n"),date("j"),date("Y")); $select_date = mktime(16,30,0,date("n",strtotime($ymd)),date("j",strtotime($ymd)),date("Y",strtotime($ymd))); $sql = "select * from USERINFO , CHECKINOUT where USERINFO.Badgenumber = '".$_REQUEST['person']."' and USERINFO.USERID = CHECKINOUT.USERID and CHECKINOUT.CHECKTIME >= '".date("Y-m-d", strtotime($ymd))." ".date("H:i:s",strtotime($leaveTimeStart))."' and CHECKINOUT.CHECKTIME <= '".date("Y-m-d", strtotime($ymd))." ".date("H:i:s",strtotime($leaveTimeFinish))."' order by CHECKINOUT.CHECKTIME desc"; $mssql_conn->query($sql); if($mssql_conn->num_rows()){ $rs = $mssql_conn->getnext(); $checkout = 1; //ลงเวลาออก $checkout_time = date("H:i" , strtotime(substr($rs->CHECKTIME,-7))); $status = "-"; } else{ if($select_date > $this_date){ $checkout = 3; //ยังไม่มีข้อมูล $checkout_time = "-"; $status = "-"; } else{ $checkout = 2; //ไม่ลงเวลาออก $checkout_time = "ไม่ลงเวลาออก"; } } echo "".$checkout_time." | "; $mysql_conn = mysql_connect("202.29.105.4","root","scphc@") or die('Could not connect: ' . mysql_error()); mysql_select_db("manage_db",$mysql_conn); mysql_query("SET NAMES 'tis620'"); $sql = "select * from Holiday_SCPHC where holidayDate >= '".date("Y-m-d", strtotime($ymd))."' and holidayDate <= '".date("Y-m-d", strtotime($ymd))."' "; $mssql_conn->query($sql); if($mssql_conn->num_rows()){ $rs = $mssql_conn->getnext(); $checkin = 10; //วันหยุดราชการ $holidayName = $rs->holidayName; } $sql = "select * from personal_tb , history_absent , history_absent_tb where personal_tb.Acno = '".$_REQUEST['person']."' and personal_tb.Teacher_code = history_absent_tb.Teacher_code and history_absent_tb.Absent_code = history_absent.Absent_code and history_absent_tb.Date_start <= '".($year."-".$month."-".$i)."' and history_absent_tb.Date_finish >= '".($year."-".$month."-".$i)."' and history_absent_tb.Status = 'อนุญาต' "; $result = mysql_query($sql); if(mysql_num_rows($result)){ $rs2 = mysql_fetch_object($result); switch($rs2->Absent_code){ case 1 : $checkin = 4; break; //ลากิจ case 2 : $checkin = 5; break; //ลาป่วย case 3 : $checkin = 6; break; //ลาพักผ่อน case 4 : $checkin = 7; break; //ลาคลอดบุตร case 5 : $checkin = 8; break; //ลาอุปสมบท } } else{ $sql = "select * from personal_tb , formaoffice where personal_tb.Acno = '".$_REQUEST['person']."' and personal_tb.Teacher_code = formaoffice.Teacher_code and formaoffice.Date_start <= '".($year."-".$month."-".$i)."' and formaoffice.Date_finish >= '".($year."-".$month."-".$i)."' and formaoffice.Flag2 = 'อนุมัติ' "; $result = mysql_query($sql); if(mysql_num_rows($result)) $checkin = 9; //ไปราชการ } mysql_close($mysql_conn); $weekend = date("w", strtotime($ymd)); $this_day = mktime(0,0,0,date("m"),date("d"),date("Y")); $compare_day = mktime(0,0,0,date("n", strtotime($ymd)),date("d", strtotime($ymd)),date("Y", strtotime($ymd))); if($checkin == 4) $status = "ลากิจ"; else if($checkin == 5) $status = "ลาป่วย"; else if($checkin == 6) $status = "ลาพักผ่อน"; else if($checkin == 7) $status = "ลาคลอดบุตร"; else if($checkin == 8) $status = "ลาอุปสมบท"; else if($checkin == 9) $status = "ไปราชการ"; else if($checkin == 10) $status = $holidayName; else{ if($weekend == 6) $status = "วันเสาร์"; if($weekend == 0) $status = "วันอาทิตย์"; if($compare_day > $this_day) $status = "-"; if($status == "" && $checkin != 3) $status = "-"; if($status == "" && $checkin == 3) $status = "ขาดงาน"; } echo "".$status." | "; echo "