public function getDelete($id) { $dataset = \App\Dataset::find($id); Schema::dropIfExists($dataset->table_name); foreach ($dataset->attributes as $attribute) { $attribute->delete(); } $dataset->delete(); return redirect('dataset'); }
public function update(Request $request) { $this->validate($request, ['name' => 'required|max:255', 'description' => 'required']); $input = $request->all(); $dataset = Dataset::find($input['id']); $dataset->name = $input['name']; $dataset->description = $input['description']; $dataset->save(); Session::flash('flash_message', '修改成功'); return \Redirect::back(); }
public function scopeUpdateSource($query, $datasetId, $newDatasourceId) { if (!empty($newDatasourceId)) { $dataset = Dataset::find($datasetId); //is it event necessary to update source? if ($dataset->fk_dsr_id != $newDatasourceId) { //get all variables $variables = $dataset->variables; foreach ($variables as $variable) { Variable::updateSource($variable->id, $newDatasourceId); } } } }
Route::get('user', 'UserController@index'); Route::get('user/{id}/lock', 'UserController@lock'); Route::get('user/{id}/unlock', 'UserController@unlock'); Route::get('user/{id}/destroy', 'UserController@destroy'); Route::get('user/appeal', 'UserController@appeal'); Route::get('user/{id}/deladmin', 'UserController@deladmin'); Route::get('user/{id}/add2admin', 'UserController@add2admin'); Route::get('user/{id}/delreception', 'UserController@delreception'); Route::get('user/{id}/add2reception', 'UserController@add2reception'); }); Route::group(['prefix' => 'tag', 'middleware' => ['auth']], function () { Route::get('/', function () { return view('tag.index', ['datasets' => \App\Dataset::all()]); }); Route::get('/{id}', function ($id) { return view('tag.tag', ['dataset' => \App\Dataset::find($id)]); }); }); Route::group(['prefix' => 'tag', 'middleware' => ['auth']], function () { Route::get('/', function () { return view('tag.index', ['datasets' => \App\Dataset::all(), 'user' => Auth::user()]); }); Route::get('/{id}', 'TagController@getNext'); Route::post('/{id}', 'TagController@postLabel'); }); Route::group(['prefix' => 'u'], function () { Route::get('login', 'Auth\\AuthController@getLogin'); Route::post('login', 'Auth\\AuthController@postLogin'); Route::get('logout', 'Auth\\AuthController@getLogout'); // Registration routes... Route::get('register', 'Auth\\AuthController@getRegister');
public function getNext($id) { // TODO: Delete unused 'count' $userid = $this->auth->user()->id; $batchId = $this->auth->user()->batch_id; $batch = \App\Batch::find($batchId); if ($batch == null) { \DebugBar::warning('$batch==null:'); $batch = $this->newBatch($id, $userid); $this->auth->user()->batch_id = $batch->id; $this->auth->user()->save(); } elseif ($batch->remain_count == 0) { \DebugBar::warning('$batch->remain_count == 0'); $standard = \App\StandardItem::find($batch->standard_item_id); // if user owns no valid batch or he/she has already done a batch $batch = $this->newBatch($id, $userid); if ($batch == null) { return view('tag.no_more', ['user' => $this->auth->user(), 'dataset' => \App\Dataset::find($id)]); } $this->auth->user()->batch_id = $batch->id; $this->auth->user()->save(); return view('tag.done', ['user' => $this->auth->user(), 'dataset' => \App\Dataset::find($id), 'standard' => $standard]); } $standard = \App\StandardItem::find($batch->standard_item_id); $items = $standard->Items; $item = $items[$batch->remain_count - 1]; return view('tag.tag', ['user' => $this->auth->user(), 'dataset' => \App\Dataset::find($id), 'standard' => $standard, 'batch' => $batch, 'item' => $item]); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // return view('back.dataset', ['dataset' => \App\Dataset::find($id)]); }
/** * Execute the command. * * @return void */ public function handle() { //set_time_limit( 600 ); //ini_set('memory_limit', '256M'); //bump up limits set_time_limit(600); ini_set('memory_limit', '256M'); return; //will we be checking entities $entityCheck = $this->validate_entities == 'on' ? false : true; //create new file $inputFileData = ['raw_data' => $this->data, 'fk_user_id' => $this->userId]; $inputFile = InputFile::create($inputFileData); $inputFileDataId = $inputFile->id; $multivariantDataset = $this->multivariant_dataset; $variables = $this->variables; if (!empty($variables)) { $entityData = []; //creating new datasource, if there is some $sourceName = $this->source_name; if (!empty($sourceName)) { $datasourceData = ['name' => $this->source_name, 'link' => $this->source_link, 'description' => $this->source_description]; $datasource = Datasource::create($datasourceData); } else { //fake datasoure $datasource = new \stdClass(); $datasource->id = null; } //create new dataset or pick existing one $datasetName = $this->new_dataset_name; $datasetData = ['name' => $datasetName, 'fk_dst_cat_id' => $this->category_id, 'fk_dst_subcat_id' => $this->subcategory_id, 'description' => $this->new_dataset_description, 'fk_dsr_id' => $datasource->id]; $dataset = Dataset::create($datasetData); $datasetId = $dataset->id; //process possible tags $tagsInput = $this->new_dataset_tags; if (!empty($tagsInput)) { $tagsArr = explode(',', $tagsInput); foreach ($tagsArr as $tag) { $tag = DatasetTag::create(['name' => $tag]); $tagId = $tag->id; $datasetTagLink = LinkDatasetsTags::create(['fk_dst_id' => $datasetId, 'fk_dst_tags_id' => $tagId]); } } //store inserted variables, for case of rolling back $inserted_variables = array(); foreach ($variables as $variableJsonString) { //convert back single out to actual single quote //$variableJsonString = str_replace( "'", "‘", $variableJsonString ); //setting json_decode second param to false, to try to save memory $variableObj = json_decode($variableJsonString, false); $variableData = ['name' => $variableObj->name, 'fk_var_type_id' => $this->variable_type, 'fk_dst_id' => $datasetId, 'unit' => $variableObj->unit, 'description' => $variableObj->description, 'fk_dsr_id' => $datasource->id]; //update of existing variable or new variable if (!isset($variableObj->id)) { //new variable $variable = Variable::create($variableData); } else { //update variable $variable = Variable::find($variableObj->id); $variable->fill($variableData); $variable->save(); } $variableId = $variable->id; $inserted_variables[] = $variable; $variableValues = $variableObj->values; foreach ($variableValues as $countryValue) { $entityData = ['name' => $countryValue->key, 'fk_ent_t_id' => 5, 'validated' => 0]; if ($entityCheck) { //entity validation (only if not multivariant dataset) //find corresponding iso code $entityIsoName = EntityIsoName::match($entityData['name'])->first(); if (!$entityIsoName) { //!haven't found corresponding country, throw an error! //rollback everything first foreach ($inserted_variables as $inserted_var) { $inserted_var->data()->delete(); $inserted_var->delete(); } //is new dataset if ($this->new_dataset === '1') { $dataset = Dataset::find($datasetId); //delete itself $dataset->delete(); } \Log::error('Error non-existing entity in dataset.'); \Log::error($entityData['name']); return redirect()->route('import')->with('message', 'Error non-existing entity in dataset.')->with('message-class', 'error'); } //enter standardized info $entityData['name'] = $entityIsoName->name; $entityData['code'] = $entityIsoName->code; $entityData['validated'] = 1; } //find try finding entity in db if (isset($entityIsoName)) { $entity = Entity::where('code', $entityIsoName->code)->first(); } else { //not standardized data $entity = Entity::where('code', $entityData['name'])->orWhere('name', $entityData['name'])->first(); } if (!$entity) { //entity haven't found in database, so insert it $entity = Entity::create($entityData); } //check to override validation if stored in db not validated and now is validate if ($entity->validated == 0 && $entityData['validated'] === 1) { $entity->validated = 1; $entity->save(); } $entityId = $entity->id; $countryValues = $countryValue->values; //prepare vars for mass insert $times = []; $values = []; //TODO - get latest time for base timeId $lastTime = Time::orderBy('id', 'desc')->first(); $timeId = !empty($lastTime) ? $lastTime->id : 0; foreach ($countryValues as $value) { if ($this->hasValue($value->x) && $this->hasValue($value->y)) { $timeId++; //create time $timeObj = $value->x; $timeValue = ['startDate' => isset($timeObj->sd) ? $timeObj->sd : "", 'endDate' => isset($timeObj->ed) ? $timeObj->ed : "", 'date' => isset($timeObj->d) ? $timeObj->d : "", 'label' => isset($timeObj->l) ? $timeObj->l : ""]; //convert timedomain $fk_ttype_id = 1; if (!empty($timeObj->td)) { $ttQuery = TimeType::query(); $fk_ttype_id = $ttQuery->whereRaw('LOWER(`name`) like ?', [$timeObj->td])->first()->id; } $timeValue['fk_ttype_id'] = $fk_ttype_id; //using mass insert instead //$time = Time::create( $timeValue ); //$timeId = $time->id; $times[] = $timeValue; //create value $dataValueData = ['value' => $value->y, 'fk_time_id' => $timeId, 'fk_input_files_id' => $inputFileDataId, 'fk_var_id' => $variableId, 'fk_ent_id' => $entityId, 'fk_dsr_id' => $datasource->id]; //using mass insert instead //$dataValue = DataValue::create( $dataValueData ); $values[] = $dataValueData; } } //mass insertion Time::insert($times); DataValue::insert($values); } } } }