Page History

banderson
jsmith
abc

SELECT subject_id, subject_source subject_source_id FROM grouper_members WHERE subject_id like 'ag%'

0 0 6 * * ?

CREATE OR REPLACE VIEW current_year_v AS SELECT YEAR(CURDATE()) AS current_year;

CREATE OR REPLACE VIEW current_month_v AS SELECT  MONTH(CURDATE()) AS current_month;

CREATE OR REPLACE VIEW classes_helper_1_v AS 
SELECT  gg.id AS id,  gg.name AS NAME FROM grouper_groups gg, current_year_v AS cyv 
WHERE (gg.name IN(
CONCAT('ref:student:class',(cyv.current_year + 1)),
CONCAT('ref:student:class',(cyv.current_year + 2)),
CONCAT('ref:student:class',(cyv.current_year + 3)) ));

CREATE OR REPLACE VIEW classes_helper_2_v AS 
SELECT gg.id, gg.name 
FROM grouper_groups gg, current_month_v cmv, current_year_v cyv 
WHERE (gg.name in (CONCAT('ref:student:class',cyv.current_year))
and cmv.current_month <= 6) or 
(gg.name IN (CONCAT('ref:student:class', cyv.current_year+4)) 
AND cmv.current_month > 6);

CREATE OR REPLACE VIEW classes_v AS 
SELECT id, NAME FROM classes_helper_1_v 
UNION SELECT id, NAME FROM classes_helper_2_v