AD Report Params

/* report bid_schedule */
        $query = "select id from opportunities
        left join opportunities_cstm on id = id_c
        where
            (
            status_division_8_c like '%Pre Bid%'  OR
            status_division_8_c like '%Post Bid%' OR
            status_division_10_c like '%Pre Bid%'  OR
            status_division_10_c like '%Post Bid%' OR
            status_installation_c like '%Pre Bid%'  OR
            status_installation_c like '%Post Bid%'
            )
        and opportunities.deleted=0
        {$this->user_filter}
        ORDER BY bid_open_datetime_c ASC ";
        $results = $db->query($query);

/* report speculative_planning */
        $query = " select id from opportunities join opportunities_cstm on id=id_c
            where (
              status_division_8_c like '%Speculative/Planning%' OR
              status_division_10_c like '%Speculative/Planning%' OR
              status_installation_c like '%Speculative/Planning%'
            ) and deleted = 0
            {$this->user_filter}
            ORDER BY bid_open_datetime_c ASC ";
        $results = $db->query($query);

/* report followup */
        $query = " select id from opportunities join opportunities_cstm on id=id_c
            where deleted = 0 and
            bid_open_datetime_c <= (GETDATE()) and (
            status_division_8_c like '%Followup%' or
            status_division_10_c like '%Followup%' or
            status_installation_c like '%Followup%'
            )
            {$this->user_filter}
            order by bid_open_datetime_c ASC ";
        $results = $db->query($query);