~[if#1.prefschool.mobilehidephoto=1]
~[SetPostValue:photodisplay=hide]
[else#1]
~[if#2.~(studentscreenaccess;photo.html)=1]
~[SetPostValue:photodisplay=show]
[else#2]
~[SetPostValue:photodisplay=hide]
[/if#2]
[/if#1]
- ~[text:psx.html.admin_mobile.birthdaylist.birthdays_for,param:~[gpv:dateselect]]
~[tlist_sql;
SELECT
CASE
WHEN to_char(s.dob,'DD') = to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY')-1,'DD')
THEN 'prevDay'
WHEN to_char(s.dob,'DD') = to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY'),'DD')
THEN 'currDay'
WHEN to_char(s.dob,'DD') = to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY')+1,'DD')
THEN 'nextDay'
ELSE 'feb29Day'
END as dayClass,
s.DCID,
s.ID as id,
s.Last_Name, s.First_Name,
CASE
WHEN s.Grade_Level = -2 THEN 'PK3'
WHEN s.Grade_Level = -1 THEN 'PK4'
WHEN s.Grade_Level = 0 THEN 'K'
WHEN s.Grade_Level = 1 THEN '1st'
WHEN s.Grade_Level = 2 THEN '2nd'
WHEN s.Grade_Level = 3 THEN '3rd'
ELSE to_char(s.Grade_Level) || 'th'
END AS Grade,
round(months_between(to_date('~[gpv:dateselect]','MM/DD/YY'), s.dob)/12) HowOld
FROM Students s
WHERE 1 = floor(months_between(to_date('~[gpv:dateselect]','MM/DD/YY')+1, s.dob)/12)
-
floor(months_between(to_date('~[gpv:dateselect]','MM/DD/YY')-2, s.dob)/12)
AND s.Enroll_Status=0
~[if.district.office][else]
AND s.SchoolID = ~(curschoolid)
[/if.district.office]
ORDER BY
CASE WHEN to_char(to_date('~[gpv:dateselect]','MM/DD/YYYY'),'MMDD')
IN ('1231','0101') THEN to_char(s.dob+2,'MMDD')
ELSE to_char(s.dob,'MMDD') END,
LastFirst;nonemessage=~[text:psx.html.admin_mobile.birthdaylist.no_birthdays_on_or_near_,param:~[gpv:dateselect]]
;makestudentselection]
~[if.~[gpv:photodisplay]=hide]
-
~(s.last_name;t), ~(s.first_name;t)
[else]
-
ph.jpeg)
~(s.last_name;t), ~(s.first_name;t)
[/if]
(~(Grade;t))
~(Howold;l)~[text:psx.html.admin_mobile.birthdaylist.years]~(dayClass;t;if.test=prevDay;then=yesterday;else.if=nextDay;then=tomorrow;else.if=feb29Day;then=Feb 29;else=today)
[/tlist_sql]