public static function day($date)
{
$data = DB::instance()->query("\r\n SELECT A.id, concat(A.end_date, ' ', A.end_time) as 'date', A.desc_short as 'task', A.completion as 'completion', 'assignment' as 'type', S.name as 'parent_name', concat('page=subjects&subject=', S.abbreviation) as 'parent_page', S.name as 'subject_name', S.abbreviation as 'subject'\r\n FROM `" . Users::showSid() . "_assignments` A\r\n INNER JOIN `subjects` S\r\n ON A.subject = S.abbreviation\r\n WHERE A.end_date = ? OR (A.completion = 0 AND A.end_date < ?)\r\n UNION\r\n SELECT E.id, E.date, concat(E.weight, ' ', S.name) as 'task', E.mark as 'completion', 'exam' as 'type', S.name as 'parent_name', concat('page=subjects&subject=', S.abbreviation) as 'parent_page', S.name as 'subject_name', S.abbreviation as 'subject'\r\n FROM `" . Users::showSid() . "_exams` E\r\n INNER JOIN `subjects` S\r\n ON E.subject = S.abbreviation\r\n WHERE E.date = ?\r\n UNION\r\n SELECT P.id, P.date_end as 'date', P.goal as 'task', P.completion, 'planning' as 'type', S.name as 'parent_name', concat('page=subjects&subject=', S.abbreviation) as 'parent_page', S.name as 'subject_name', S.abbreviation as 'subject'\r\n FROM `" . Users::showSid() . "_planning` P\r\n INNER JOIN `subjects` S\r\n ON P.parent_table = 'subjects' AND P.parent_id = S.id\r\n WHERE (P.date_start <= ? AND P.date_end >= ?) OR (P.completion = 0 AND P.date_end < ?)\r\n UNION\r\n SELECT P.id, P.date_end as 'date', P.goal as 'task', P.completion, 'planning' as 'type', A.desc_short as 'parent_name', concat('page=assignments_item&id=', A.id) as 'parent_page', S.name as 'subject_name', S.abbreviation as 'subject'\r\n FROM `" . Users::showSid() . "_planning` P\r\n INNER JOIN `" . Users::showSid() . "_assignments` A\r\n ON P.parent_table = 'assignments' AND P.parent_id = A.id\r\n INNER JOIN `subjects` S\r\n ON A.subject = S.abbreviation\r\n WHERE (P.date_start <= ? AND P.date_end >= ?) OR (P.completion = 0 AND P.date_end < ?)\r\n UNION\r\n SELECT P.id, P.date_end as 'date', P.goal as 'task', P.completion, 'planning' as 'type', concat(E.weight, ' ', S.name) as 'parent_name', concat('page=exams_item&id=', E.id) as 'parent_page', S.name as 'subject_name', S.abbreviation as 'subject'\r\n FROM `" . Users::showSid() . "_planning` P\r\n INNER JOIN `" . Users::showSid() . "_exams` E\r\n ON P.parent_table = 'exams' AND P.parent_id = E.id\r\n INNER JOIN `subjects` S\r\n ON E.subject = S.abbreviation\r\n WHERE (P.date_start <= ? AND P.date_end >= ?) OR (P.completion = 0 AND P.date_end < ?)\r\n ORDER BY completion DESC, date ASC\r\n ", array(DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date), DateFormat::sqlDate($date)));
$results = $data->results();
foreach ($results as $entry) {
self::parseEvent($entry);
}
return $results;
}
private static function getFormattedInput($fields)
{
$data = array();
foreach ($fields as $field => $type) {
if (Input::has($field)) {
if ($type === 'datetime') {
$data[$field] = DateFormat::sql(Input::get($field));
} elseif ($type === 'date') {
$data[$field] = DateFormat::sqlDate(Input::get($field));
} elseif ($type === 'time') {
$data[$field] = DateFormat::sqlTime(Input::get($field));
} else {
$data[$field] = Input::get($field);
}
}
}
return $data;
}
