/** * Display a listing of the resource. * * @return Response */ public function index() { $categories = Category::all(); if (\Input::get('pivot') == 1) { foreach ($categories as $key => $category) { $pivot = \DB::table('project_category')->where('category_id', $category->id)->lists('project_id'); $categories[$key] = array_add($categories[$key], 'projects_pivot', $pivot); } } return response()->json(array('error' => false, 'categories' => $categories->toArray()), 200); }
function setProjects($csv, $ds_sync) { $cols = $this->columns; // String Keys $config = $this->config; // Integer position $categories = Category::all(); foreach ($csv as $row) { $project = Project::firstOrCreate(array('data_id' => $row[$cols[$config->id->col]])); $project->datasource_id = $this->id; $project->data_source_sync_id = $ds_sync->id; $project->title = $row[$cols[$config->title->col]]; $project->description = $row[$cols[$config->desc->col]]; if ($config->geo->type == 'address') { $project->geo_type = 'address'; $project->geo_address = $row[$cols[$config->geo->address->col]]; } if ($config->geo->type == 'lat_lng') { $project->geo_type = 'lat_lng'; $project->geo_lat = $row[$cols[$config->geo->lat_lng->lat->col]]; $project->geo_lng = $row[$cols[$config->geo->lat_lng->lng->col]]; } $project->status = $row[$cols[$config->status->col]]; $project->data = $row; foreach ($categories as $category) { $project->assignCategory($category); } $project->save(); } }
public function showCategories() { $categories = Category::all(); $data = array('categories' => $categories); return view('dashboard.categories', $data); }