01. <?
02. require_once('connectiondb.php');
03.require_once('calendar/calendar/classes/tc_calendar.php');
04.$strSQLShow = "SELECT dbo.USERINFO.USERID, dbo.USERINFO.Name, dbo.USERINFO.DEFAULTDEPTID, dbo.DEPARTMENTS.DEPTNAME
05.FROM dbo.USERINFO INNER JOIN dbo.DEPARTMENTS ON dbo.USERINFO.DEFAULTDEPTID = dbo.DEPARTMENTS.DEPTID
06.WHERE (dbo.USERINFO.STATE ='$PERSON_TYPE_ID') AND (NOT EXISTS
07.(SELECT dbo.CHECKINOUT.USERID,dbo.CHECKINOUT.CHECKTIME FROM dbo.CHECKINOUT
08.dbo.CHECKINOUT INNER JOIN dbo.USERINFO ON dbo.CHECKINOUT.USERID = dbo.USERINFO.USERID
09.WHERE (USERID = dbo.USERINFO.USERID) AND (CONVERT(CHAR(10),CHECKTIME,23) BETWEEN '$DChk' AND '$DChk1') AND (USERID=dbo.CHECKINOUT.USERID)))
10.ORDER BY USERINFO.DEFAULTDEPTID,CHECKTIME ASC";
11.$objQueryShow = mssql_query($strSQLShow) or die ("Error Query [".$strSQLShow."]");
12.$Num_Rows = mssql_num_rows($objQueryShow);
13.?>
