function adminGetInOutRecordsForPerson($db, $personid, $limit=0)
{
// rerturns a my-sql query result set
if ($db && $personid)
{
if ($limit>0)
{
// only return up to the number of results specified
return(mysql_query_log(
"SELECT InOutTime.id AS inoutid"
. ", InOutTime.recorddate AS recorddate"
. ", InOutTime.indatetime AS indatetime"
. ", InOutTime.outdatetime AS outdatetime"
. ", DATE_FORMAT(InOutTime.indatetime, '%H:%i') AS displayintime"
. ", DATE_FORMAT(InOutTime.outdatetime, '%H:%i') AS displayouttime"
. ", InOutTime.breakminutes AS breakminutes"
. ", InOutTime.extraminutes AS extraminutes"
. ", InOutTime.comments AS comments"
. ", LEFT(InOutTime.comments, 10) AS shortcomments"
. ", DayTypeValues.daytype AS daytype"
// below we actually calculate totalhours for display
. ", ( IF ((InOutTime.indatetime='1001-01-01 00:00:00' OR InOutTime.outdatetime='1001-01-01 00:00:00'), '', TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(InOutTime.outdatetime) - UNIX_TIMESTAMP(InOutTime.indatetime)- (InOutTime.breakminutes * 60)+(InOutTime.extraminutes * 60)), '%H:%i'))) AS totalhours "
. " FROM InOutTime, DayTypeValues"
. " WHERE InOutTime.personid=" . $personid
. " AND InOutTime.daytypeid=DayTypeValues.id"
. " ORDER BY recorddate DESC LIMIT " . $limit
, $db));
}
else
{
// Return ALL the records for this person
return(mysql_query_log(
"SELECT InOutTime.id AS inoutid"
. ", InOutTime.recorddate AS recorddate"
. ", InOutTime.indatetime AS indatetime"
. ", InOutTime.outdatetime AS outdatetime"
. ", DATE_FORMAT(InOutTime.indatetime, '%H:%i') AS displayintime"
. ", DATE_FORMAT(InOutTime.outdatetime, '%H:%i') AS displayouttime"
. ", InOutTime.breakminutes AS breakminutes"
. ", InOutTime.extraminutes AS extraminutes"
. ", InOutTime.comments AS comments"
. ", LEFT(InOutTime.comments, 10) AS shortcomments"
. ", DayTypeValues.daytype AS daytype"
// below we actually calculate totalhours for display
. ", ( IF ((InOutTime.indatetime='1001-01-01 00:00:00' OR InOutTime.outdatetime='1001-01-01 00:00:00'), '', TIME_FORMAT(SEC_TO_TIME(UNIX_TIMESTAMP(InOutTime.outdatetime) - UNIX_TIMESTAMP(InOutTime.indatetime)- (InOutTime.breakminutes * 60)+(InOutTime.extraminutes * 60)), '%H:%i'))) AS totalhours "
. " FROM InOutTime, DayTypeValues"
. " WHERE InOutTime.personid=" . $personid
. " AND InOutTime.daytypeid=DayTypeValues.id"
. " ORDER BY recorddate DESC"
, $db));
}
}
} // adminGetInOutRecordsForPerson()