public function getChart()
 {
     $cat = Category::all();
     // $total = Transaction::where('category_id','=',$cat->id)->orderBy('created_at', 'desc')->limit(1)->get();
     $kato = Category::all();
     $trans = Transaction::all();
     $produk = Product::all();
     $tro = Transaction::groupby('id')->get();
     $top = Transaction::orderBy('qty', 'desc')->limit(5)->get();
     $topcat = Transaction::orderBy('qty', 'desc')->groupBy('category_id')->limit(5)->get();
     return view('a.chart')->with('kato', $kato)->with('tro', $tro)->with('trans', $trans)->with('produk', $produk)->with('orders', Order::all())->with('tops', $top)->with('topcats', $topcat);
 }