Latest
select SUM(fpm.budgeted_black) budget_black,
SUM(fpm.budgeted_color) budget_color,
SUM(mtr.black_meter - fpm.commencement_black_meter) as cons_blk,
SUM(mtr.color_meter - fpm.commencement_color_meter) as cons_col,
SUM(mtr.black_meter * fpm.cpc_black) as cons_blk_cost,
SUM(mtr.color_meter * fpm.cpc_color) as cons_col_cost,

SUM((CASE WHEN fpm.commencement_black_meter IS NULL THEN mtr.black_meter ELSE (mtr.black_meter - fpm.commencement_black_meter) END)) consumed_black,
SUM((CASE WHEN fpm.commencement_color_meter IS NULL THEN mtr.color_meter ELSE (mtr.color_meter - fpm.commencement_color_meter) END)) consumed_color,

SUM((CASE WHEN org.commencement_date IS NULL THEN fpm.budgeted_black
	WHEN $org_commencement_date < $startingDate THEN fpm.budgeted_black ELSE (fpm.budgeted_black / 365 * 365) END)) budgeted_black,
SUM((CASE WHEN org.commencement_date IS NULL THEN fpm.budgeted_color
	WHEN $org_commencement_date < $startingDate THEN fpm.budgeted_color ELSE (fpm.budgeted_color / 365 * 365) END)) budgeted_color,

bldgs.bldg_id

from `y2019_meters` as `mtr`
inner join `y2019_floorplan_machines` as `fpm` on `fpm`.`proposed_serial_number` = `mtr`.`serial_number`
inner join `y2019_floorplans` as `fp` on `fp`.`fp_id` = `fpm`.`floorplans_id`
inner join `y2019_buildings` as `bldgs` on `bldgs`.`bldg_id` = `fp`.`buildings_id`
inner join `organizations` as `org` on `bldgs`.`organizations_id` = `org`.`org_id`
inner join (select max(created_date) as dt, serial_number
            from `y2019_meters`
            where `created_date` > '2018-07-01 00:00:00' and `created_date` < '2019-06-30 00:00:00'
            group by `serial_number`) as `serNumDateMetersMax` on `mtr`.`serial_number` = `serNumDateMetersMax`.`serial_number` and `mtr`.`created_date` = `serNumDateMetersMax`.`dt`
            
where `fpm`.`proposed_serial_number` in (select `fm`.`proposed_serial_number`
                                         from `y2019_floorplan_machines` as `fm`
                                         inner join `y2019_floorplans` as `fp` on `fp`.`fp_id` = `fm`.`floorplans_id`
                                         inner join `y2019_buildings` as `bldgs` on `bldgs`.`bldg_id` = `fp`.`buildings_id`
                                         where `bldgs`.`organizations_id` = 75)
group by bldgs.bldg_id;


https://stackoverflow.com/questions/17092112/laravel-eloquent-select-case
Move your raw() call inside the SELECT statement:

->select('shares.id AS share_id', 'users.id AS user_id', 'shares.connected_user_id',    
  'shares.original_language_id', 'shares.image',
  'users.first_name', 'users.last_name', 'users.email',
  'locations.city', 'provinces.name', 'countries.code',
  'locations.lat', 'locations.lng',
  'shares.created_at',
  DB::raw('(CASE WHEN users.id = ' . $user . ' THEN 1 ELSE 0 END) AS is_user')
  )
->orderBy('shares.created_at', 'desc')
/*******************************************************************************************/









select SUM(fpm.budgeted_black) budgeted_black,
SUM(fpm.budgeted_color) budgeted_color,
SUM(mtr.black_meter - fpm.commencement_black_meter) as cons_blk,
SUM(mtr.color_meter - fpm.commencement_color_meter) as cons_col,
SUM(mtr.black_meter * fpm.cpc_black) as cons_blk_cost,
SUM(mtr.color_meter * fpm.cpc_color) as cons_col_cost,
bldgs.bldg_id

from `y2019_meters` as `mtr`
inner join `y2019_floorplan_machines` as `fpm` on `fpm`.`proposed_serial_number` = `mtr`.`serial_number`
inner join `y2019_floorplans` as `fp` on `fp`.`fp_id` = `fpm`.`floorplans_id`
inner join `y2019_buildings` as `bldgs` on `bldgs`.`bldg_id` = `fp`.`buildings_id`
inner join `organizations` as `org` on `bldgs`.`organizations_id` = `org`.`org_id`
inner join (select max(created_date) as dt, serial_number
            from `y2019_meters`
            where `created_date` > '2018-07-01 00:00:00' and `created_date` < '2019-06-30 00:00:00'
            group by `serial_number`) as `serNumDateMetersMax` on `mtr`.`serial_number` = `serNumDateMetersMax`.`serial_number` and `mtr`.`created_date` = `serNumDateMetersMax`.`dt`
            
where `fpm`.`proposed_serial_number` in (select `fm`.`proposed_serial_number`
                                         from `y2019_floorplan_machines` as `fm`
                                         inner join `y2019_floorplans` as `fp` on `fp`.`fp_id` = `fm`.`floorplans_id`
                                         inner join `y2019_buildings` as `bldgs` on `bldgs`.`bldg_id` = `fp`.`buildings_id`
                                         where `bldgs`.`organizations_id` = 75)
group by bldgs.bldg_id