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