function getCheckInEntry($userid, $date = '')
{
    $where_query = "";
    if (!isEmptyString($date)) {
        $where_query = " AND TO_DAYS(t.datein) = TO_DAYS('" . $date . "') ";
    }
    $conn = Doctrine_Manager::connection();
    $query = "SELECT * FROM timesheet AS t where t.`userid` = '" . $userid . "' order by t.timesheetdate desc, t.id desc limit 1 ";
    // debugMessage($query);
    $result = $conn->fetchRow($query);
    if (!$result) {
        $timesheet = new Timesheet();
        $result = $timesheet->toArray();
    }
    // debugMessage($result);
    return $result;
}