Update Stat Cats - HRVHS Patrons (Grad Year/Class)

--Match Grad Year to Class--

-- Only works when they have an entry in the Grad Year Stat Cat, have to create it otherwise --

-- 43 = Class
-- 69 = Grad Year
-- 214 = Hood River High School

BEGIN;

-- Seniors --

            UPDATE actor.stat_cat_entry_usr_map SET stat_cat_entry='Senior'
                WHERE stat_cat=43 and target_usr IN
                (
            SELECT target_usr
                FROM actor.stat_cat_entry_usr_map
                    WHERE stat_cat=69 AND stat_cat_entry ='2017'
                    AND target_usr IN
                        (SELECT id FROM actor.usr WHERE home_ou=214 AND deleted =false)
                )
            ;

-- Juniors --

            UPDATE actor.stat_cat_entry_usr_map SET stat_cat_entry='Junior'
                WHERE stat_cat=43 and target_usr IN
                (
            SELECT target_usr
                FROM actor.stat_cat_entry_usr_map
                    WHERE stat_cat=69 AND stat_cat_entry ='2018'
                    AND target_usr IN
                        (SELECT id FROM actor.usr WHERE home_ou=214 AND deleted =false)
                )
            ;

-- Sophomores --

            UPDATE actor.stat_cat_entry_usr_map SET stat_cat_entry='Sophomore'
                WHERE stat_cat=43 and target_usr IN
                (
            SELECT target_usr
                FROM actor.stat_cat_entry_usr_map
                    WHERE stat_cat=69 AND stat_cat_entry ='2019'
                    AND target_usr IN
                        (SELECT id FROM actor.usr WHERE home_ou=214 AND deleted =false)
                )
            ;

-- Freshman --

            UPDATE actor.stat_cat_entry_usr_map SET stat_cat_entry='Freshman'
                WHERE stat_cat=43 and target_usr IN
                (
            SELECT target_usr
                FROM actor.stat_cat_entry_usr_map
                    WHERE stat_cat=69 AND stat_cat_entry ='2020'
                    AND target_usr IN
                        (SELECT id FROM actor.usr WHERE home_ou=214 AND deleted =false)
                )
            ;

COMMIT;