A2 date complete logics

[td928]

SInce A2 jobs have no CO, they also don't have any completion dates. We have special logics written up for completion date for Demolition so one way to approach it is to also write some customized logics for it in _mid.sql

  (CASE 
      WHEN a.job_type = 'Demolition'
          THEN 
              CASE 
              WHEN a.date_statusx IS NOT NULL
                  THEN a.date_permittd
              ELSE NULL END
      WHEN a.job_type = 'Alteration (A2)'
          THEN a.date_statusx::text
      ELSE b._date_complete END) as date_complete,