public function editorData()
 {
     $data = new \StdClass();
     $data->chartTypes = ChartType::lists('name', 'id');
     $data->logos = Logo::lists('name', 'url');
     $query = DB::table("variables")->join('datasets', 'variables.fk_dst_id', '=', 'datasets.id')->join('dataset_categories', 'datasets.fk_dst_cat_id', '=', 'dataset_categories.id')->join('dataset_subcategories', 'datasets.fk_dst_subcat_id', '=', 'dataset_subcategories.id')->orderBy('dataset_categories.id', 'ASC')->orderBy('dataset_subcategories.id', 'ASC')->select('variables.name', 'variables.id', 'variables.unit', 'datasets.name as dataset', 'dataset_categories.name as category', 'dataset_subcategories.name as subcategory');
     $optgroups = [];
     foreach ($query->get() as $result) {
         if (!isset($optgroups[$result->subcategory])) {
             $optgroup = new \StdClass();
             $optgroup->name = $result->subcategory;
             $optgroup->variables = [];
             $optgroups[$result->subcategory] = $optgroup;
         }
         if ($result->name != $result->dataset) {
             $result->name = $result->dataset . " - " . $result->name;
         }
         $optgroups[$result->subcategory]->variables[] = $result;
     }
     $data->optgroups = $optgroups;
     return $data;
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit(Chart $chart, Request $request)
 {
     $config = json_decode($chart->config);
     if ($request->ajax()) {
         return response()->json($config);
     } else {
         $data = new \StdClass();
         $data->variables = Variable::with('Dataset')->get();
         $data->categories = DatasetCategory::all();
         $data->subcategories = DatasetSubcategory::all();
         $data->chartTypes = ChartType::lists('name', 'id');
         $logoUrl = Setting::where('meta_name', 'logoUrl')->first();
         $data->logoUrl = !empty($logoUrl) ? url('/') . '/' . $logoUrl->meta_value : '';
         return view('charts.edit', compact('chart'))->with('data', $data);
     }
 }
Exemplo n.º 3
0
 public function edit($id)
 {
     $chart = Chart::findOrFail($id);
     $locations = Location::lists('name', 'id');
     $units = ChartUnit::lists('unit', 'id');
     $types = ChartType::lists('type', 'id');
     $auth = $chart->auth;
     $visible = $chart->visible;
     return view('partials.editChart', compact('chart', 'locations', 'units', 'types', 'auth', 'visible'));
 }