Advertisement
Guest User

Untitled

a guest
Sep 1st, 2014
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.90 KB | None | 0 0
  1. public function postImport(){
  2.  
  3. $file = Input::file('file');
  4.  
  5. if (is_null($file)) {
  6. Session::flash('message', 'Veuillez sélectionner un fichier !');
  7. return Redirect::to('import');
  8. }
  9.  
  10. $destinationPath = 'uploads/';
  11. $filename = $file->getClientOriginalName();
  12. $extension =$file->getClientOriginalExtension();
  13.  
  14. if ($extension != 'csv') {
  15. Session::flash('message', "Le format de fichier n'est pas valide. Veuillez selectionner un fichier .csv ");
  16. return Redirect::to('import');
  17. }
  18.  
  19.  
  20. $uploadSuccess = Input::file('file')->move($destinationPath, $filename);
  21.  
  22. if( $uploadSuccess )
  23. {
  24. $csv = Excel::load('/public/uploads/'.$filename, function($reader) { })->toObject();
  25.  
  26. $count = count($csv);
  27.  
  28. questionList::truncate();
  29.  
  30. $quest= '1';
  31. $rightAnswer = '2';
  32. $explanation = '3';
  33. $wrongAnswer1 = '4';
  34. $wrongAnswer2 = '5';
  35. $wrongAnswer3 = '6';
  36. $theme = '7';
  37. $category = '8';
  38. $difficulty = '9';
  39. $diff = "0";
  40. for ( $i = 0 ; $i < $count ; $i++)
  41. {
  42.  
  43. $question = new questionList;
  44. $question->question = $csv[$i]->$quest;
  45. $question->rightAnswer =$csv[$i]->$rightAnswer;
  46. $question->explanation = $csv[$i]->$explanation;
  47. $question->wrongAnswer1 = $csv[$i]->$wrongAnswer1;
  48. $question->wrongAnswer2 = $csv[$i]->$wrongAnswer2;
  49. $question->wrongAnswer3 = $csv[$i]->$wrongAnswer3;
  50. $question->theme = strtolower($csv[$i]->$theme);
  51. $question->category = strtolower($csv[$i]->$category);
  52.  
  53.  
  54. $csv[$i]->$difficulty = str_replace(' ', '', $csv[$i]->$difficulty);
  55.  
  56. if($csv[$i]->$difficulty =="Facile*"){
  57. $diff="1";
  58. }
  59. if($csv[$i]->$difficulty =="Moyen**"){
  60. $diff="2";
  61. }
  62. if($csv[$i]->$difficulty =="Difficile***"){
  63. $diff="3";
  64. }
  65.  
  66. $question->difficulty = $diff ;
  67. $question->timestamps = false;
  68.  
  69. if ($question->save())
  70. {
  71.  
  72. }
  73. else
  74. {
  75. Session::flash('message', 'Le fichier importé ne respecte pas la mise en forme requise. Des erreues
  76. ont été détéctées sur les lignes suivantes : ');
  77. return Redirect::to('import');
  78. }
  79.  
  80. }
  81.  
  82. }
  83. $version = Cache::get('QuestionVersion');
  84. $version = $version + 1;
  85. Cache::forever('QuestionVersion', $version);
  86.  
  87. Session::flash('success', 'Votre liste de question a été correctement importée');
  88. return Redirect::to('import');
  89.  
  90. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement