/**
* 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);
}
