Chartjs-Translate chart.js , bar chart label (month name) in French language in Laravel?

by

0👍

$allData = Gbvcase::select(
        DB::raw("(COUNT(*)) as count"),
        DB::raw("MONTHNAME(created_at) as month_name")
    )
    ->whereBetween('created_at', [Carbon::now()->subMonth(6), Carbon::now()] )
    ->orderBy('created_at', 'ASC')
    ->groupBy('month_name')
    ->get()
    ->toArray();

    $count_value = array_column($allData, 'count');
    $month_value = array_column($allData, 'month_name');

  //----This is the few lines I have added and got exactly what i wanted -------
    Carbon::setLocale('fr');
    $year = Carbon::now()->year;
    $month_value = array_map(function ($month) use ($year) {
        return Carbon::parse($year . '-' . $month . '-01')
    ->translatedFormat('F');
    }, $month_value);
    $month_value = array_map('ucfirst', $month_value);
   //------------------------        

    $this->chart->dataset('No of Cases', 'bar', $count_value)
    ->color('#E6951E')
    ->backgroundColor('#E6951E');

    // MANDATORY. Set the labels for the dataset points
    $this->chart->labels($month_value);

Leave a comment