使用2个不同的数据在图表中显示laravel [英] Using 2 different data to show in chart laravel

问题描述

我目前正在使用chartTV创建图表，但是由于某种原因我的图表似乎没有出现在刀片中，可以看到标题，但看不到图表.我想创建一个地区图折线图，其中将显示本周已录用和未录用的人数.我试图做这样的事情，但它不起作用.有人可以指导我正确执行吗?我该怎么办?

I am currently using chartTV to create a chart but my chart doesn't seem to appear inside my blade for some reason, the title can be seen but not the graph. I want to create an areaspline chart where it will show number of people hired and not hired this week. I tried doing something like this but it not working. Can someone guide me in doing it correctly? How should I do it?

我的 dashboardController :

$user1s = DB::table('evaluations')
             ->select('evaluations.Evaluation_Status','evaluations.created_at' ) 
             ->where('Evaluation_Status', '=', 'No') 
             ->get();
$user2s = DB::table('evaluations')
             ->select('evaluations.Evaluation_Status','evaluations.created_at' ) 
             ->where('evaluations.Evaluation_Status', '=', 'Yes') 
             ->get();

Charts::Database($user1s, $user2s, 'areaspline', 'highcharts')
       ->title('My nice chart')
       ->labels(['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday','Saturday', 'Sunday'])
       ->dataset('Hired', [$user1s])
       ->dataset('Not Hired', [$user2s]);

return view('dashboard', ['chart' => $chart]);

我的 dashboard.blade.php

{!! Charts::assets() !!}
{!! $chart->render() !!}

推荐答案

如果使用来自不同数据库表的数据，则可以使用多数据库图表.这些API与Charts :: multi相似.唯一的区别是如何指定数据集.

Multi database charts can be used if using data from different database tables. The APIs are similar to Charts::multi. The only differentiation is how datasets are specified.

$charts = Charts::multiDatabase('areaspline', 'highcharts')
            ->title('My nice chart')
            ->colors(['#ff0000', '#ffffff'])
            ->labels(['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday','Saturday', 'Sunday'])
            ->dataset('Hired', $user1s)
            ->dataset('Not Hired', $user2s);

这篇关于使用2个不同的数据在图表中显示laravel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！