sql-server - laravel 对谷歌图表使用 mssql 存储过程

Question

现在我得到了所有图表。但我只需要一个id=1-10. 请帮我

模型

public function Overall_byDepartment()
{
    $sQuery  = "EXEC  [dbo].[WebReport_Overall_byDepartment]" ;
    $aRawResults = DB::connection($this->connection)->select($sQuery);
    return $aRawResults; 
}

标签： sql-serverlaravelstored-procedures

Answer 1

控制器

public function index(Request $request) 
{
    $aData= $this->oChartManager->Overall_byDepartment();
    $this->aData['sReportName'] = 'dashboard';
    $this->oChartManager->setReportName('dashboard');
    $this->aData['aData']= $aData ;

    $result[] = ['department_name','oascore','level0_score' ];
    foreach ($aData as $value)  {
        $value = [(string)$value->department_name,
            (float)$value->oascore,
            (float)$value->level0_score,
        ];      

        array_push($result, $value);

    return view('reports.template')->with('aData',json_encode($result));
}