[BUG] Veg exports incorrectly calculate the `Cycle`

[cwainright]

Problems present in:

• [x] qExport_All_Events
• [x] qExport_All_CWD
• [x] qExport_All_Herbaceous
• [x] qExport_All_Plot_Floor_Conditions
• [x] qExport_All_Quadrat_Conditions
• [x] qExport_All_Sapling_Foliage_Conditions
• [x] qExport_All_Sapling_Stems
• [x] qExport_All_Saplings
• [x] qExport_All_Seedlings
• [x] qExport_All_Shrub_Seedlings
• [x] qExport_All_Shrubs
• [x] qExport_All_Stems
• [x] qExport_Conditions
  • [x] qActive_Sapling_Conditions
  • [x] qActive_Tree_Conditions
• [x] qExport_AllVines
  • [x] qExport_All_Sapling_Vines
  • [x] qExport_All_Tree_Vines
• [x] qSum_Tree_and_Sapling_Cycles
• [x] qActive_Sapling_Data

Each of these queries calculates Cycle as 1+Int((Year([Event_Date])-2006)/4). Since Covid wrecked 2020, the result returned by that calculation is off by one for each year after 2019 and will be off in perpetuity unless the queries are fixed.

possible solution:

-- building block
-- this is how you join table `PanelSeason` to `tbl_Events`
-- this code chunk is re-used in each of the queries above (basically, in each instance of `tbl_Events as E`)

SELECT 
*
FROM 
  ((
    SELECT 
      Event_ID, 
      Str(Year([Event_Date])) AS str_year 
    FROM 
      tbl_Events
  )  AS tbl_E
  INNER JOIN (
    SELECT 
      Cycle, 
      Str(PanelSeason.FieldSeason) as str_season 
    FROM 
      PanelSeason
  ) AS tbl_P
ON 
  tbl_P.str_season = tbl_E.str_year)
;

[cwainright]

references ticket 115

[cwainright]

All queries drafted to use lookup table PanelSeason instead of calculating Cycle. Unit testing now.

[cwainright]

"l_Unit_Code" should be "Unit_Code" and "usys_temp_qdf_Unit_Code"s should be deleted