如何解决“在数组上调用成员函数get（）”：Laravel 5.4

Question

使用maatwebsite / laravel-excel从数据库下载已生成数据的文件时遇到麻烦。错误：在数组上调用成员函数get（）。以前，当我仅使用一个字段从数据库中选择数据时，该文件可以生成（.csv）。但是，当我尝试使用别名“ as”进行查询时，无法获得数据。public function getdoc($type){    -- with this query : success --    //$temp = AlarmV2::select('msisdn')->get();    $today = "20181008";    -- with this query : error --    $temp = DB::select(DB::raw("select regionalid,    nvl(sum(case when lastactiontype='0' then totalcharge end),0) as creditlimit_usage,     count(case when lastactiontype='0' then msisdn end) as creditlimit_rec,    from alarms_v2    where alarmdate = '$today'    -- fatal error exception :Call to a member function get() on array --    group by regionalid order by regionalid"))->get();    return Excel::create('datadoc', function ($excel) use ($temp) {        $excel->sheet('mySheet', function ($sheet) use ($temp) {            $sheet->fromArray($temp);        });    })->download($type);}

Answer 1

$temp = DB::select(DB::raw("select regionalid,

    nvl(sum(case when lastactiontype='0' then totalcharge end),0) as creditlimit_usage, 

    count(case when lastactiontype='0' then msisdn end) as creditlimit_rec,

    from alarms_v2

    where alarmdate = '$today'

    -- fatal error exception :Call to a member function get() on array --

    group by regionalid order by regionalid"))->get();

在这里，您不需要调用该get()方法。因为select（）方法已经执行查询并返回结果数组。因此，请像下面这样做：

$temp = DB::select(DB::raw("select regionalid,

        nvl(sum(case when lastactiontype='0' then totalcharge end),0) as creditlimit_usage, 

        count(case when lastactiontype='0' then msisdn end) as creditlimit_rec,

        from alarms_v2

        where alarmdate = '$today'

        group by regionalid order by regionalid"));