Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function postImport(){
- $file = Input::file('file');
- if (is_null($file)) {
- Session::flash('message', 'Veuillez sélectionner un fichier !');
- return Redirect::to('import');
- }
- $destinationPath = 'uploads/';
- $filename = $file->getClientOriginalName();
- $extension =$file->getClientOriginalExtension();
- if ($extension != 'csv') {
- Session::flash('message', "Le format de fichier n'est pas valide. Veuillez selectionner un fichier .csv ");
- return Redirect::to('import');
- }
- $uploadSuccess = Input::file('file')->move($destinationPath, $filename);
- if( $uploadSuccess )
- {
- $csv = Excel::load('/public/uploads/'.$filename, function($reader) { })->toObject();
- $count = count($csv);
- questionList::truncate();
- $quest= '1';
- $rightAnswer = '2';
- $explanation = '3';
- $wrongAnswer1 = '4';
- $wrongAnswer2 = '5';
- $wrongAnswer3 = '6';
- $theme = '7';
- $category = '8';
- $difficulty = '9';
- $diff = "0";
- for ( $i = 0 ; $i < $count ; $i++)
- {
- $question = new questionList;
- $question->question = $csv[$i]->$quest;
- $question->rightAnswer =$csv[$i]->$rightAnswer;
- $question->explanation = $csv[$i]->$explanation;
- $question->wrongAnswer1 = $csv[$i]->$wrongAnswer1;
- $question->wrongAnswer2 = $csv[$i]->$wrongAnswer2;
- $question->wrongAnswer3 = $csv[$i]->$wrongAnswer3;
- $question->theme = strtolower($csv[$i]->$theme);
- $question->category = strtolower($csv[$i]->$category);
- $csv[$i]->$difficulty = str_replace(' ', '', $csv[$i]->$difficulty);
- if($csv[$i]->$difficulty =="Facile*"){
- $diff="1";
- }
- if($csv[$i]->$difficulty =="Moyen**"){
- $diff="2";
- }
- if($csv[$i]->$difficulty =="Difficile***"){
- $diff="3";
- }
- $question->difficulty = $diff ;
- $question->timestamps = false;
- if ($question->save())
- {
- }
- else
- {
- Session::flash('message', 'Le fichier importé ne respecte pas la mise en forme requise. Des erreues
- ont été détéctées sur les lignes suivantes : ');
- return Redirect::to('import');
- }
- }
- }
- $version = Cache::get('QuestionVersion');
- $version = $version + 1;
- Cache::forever('QuestionVersion', $version);
- Session::flash('success', 'Votre liste de question a été correctement importée');
- return Redirect::to('import');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement