$items = DB::connection('sqlsrv')
                ->table('dbo.Product')
                ->leftJoin('dbo.ProductRemain', 'dbo.Product.ProductID', '=', 'dbo.ProductRemain.ProductID')
                ->groupBy('dbo.Product.ProductCode', 'dbo.Product.ProductID')
                ->whereIn('PartnerID', ['334', '13568'])
                ->selectRaw('COALESCE(SUM(dbo.ProductRemain.ConfirmedRemain), 0) as TotalQuantity, dbo.Product.ProductCode')
                ->where('dbo.Product.ProductCode', 'HC2002T')
                ->get();