public static function getArchiveWotD($year, $month) { $query = "SELECT displayDate, lexicon, replace(displayDate, '-', '/') linkDate, DAYOFWEEK(displayDate) dayOfWeek, DAYOFMONTH(displayDate) dayOfMonth \n FROM WordOfTheDay W\n JOIN WordOfTheDayRel R ON W.id=R.wotdId\n JOIN Definition D ON R.refId=D.id AND D.status=0 AND R.refType='Definition'\n WHERE MONTH(displayDate)={$month} AND YEAR(displayDate)={$year}\n ORDER BY displayDate"; //TODO $dbRes = db_execute($query); $results = array(); foreach ($dbRes as $row) { $wotda = new WotDArchive(); $wotda->set($row); $results[] = $wotda; } return $results; }
function createCalendar($year, $month) { $days = listDaysOfMonth($year, $month); $today = date('Y-m-d'); $words = WordOfTheDay::getArchiveWotD($year, $month); $inv = array(); foreach ($words as $k => $v) { $inv[$v->displayDate] = $k; } $new_words = array(); foreach ($days as $day) { if ($day <= $today && array_key_exists($day, $inv)) { $new_words[] = $words[$inv[$day]]; } else { $new_words[] = WotDArchive::setOnlyDate($day); } } return $new_words; }