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; }