使用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);}
1 回答
郎朗坤
TA貢獻1921條經驗 獲得超9個贊
$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"));
- 1 回答
- 0 關注
- 164 瀏覽
添加回答
舉報
0/150
提交
取消