/**
  * Import SDA in CSV format
  * @return mixed
  */
 public function actionExcel1()
 {
     $model = new Sda();
     if ($model->load(Yii::$app->request->post())) {
         $row = 1;
         $congid = $_POST['Sda']['id'];
         $model->fileName = UploadedFile::getInstance($model, 'fileName');
         $time = time();
         $model->fileName->saveAs('csv/' . $time . '.' . $model->fileName->extension);
         $model->fileName = 'csv/' . $time . '.' . $model->fileName->extension;
         $handle = fopen($model->fileName, "r");
         while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
             $row++;
             if ($row == 2) {
                 print_r($row);
             } else {
                 die;
                 // Getting Priority  ID
                 $priority_name = SdaPriority::find()->where(['priority_name' => $data[2]])->one();
                 $priority_name = $priority_name['id'];
                 // Getting Sda Type  ID
                 $sdatype = SdaTypes::find()->where(['sda_name' => $data[11]])->one();
                 $sda_type = $sdatype['id'];
                 // Getting companydetails Type  ID
                 $cmp = CompanyDetails::find()->where(['name' => $data[15]])->one();
                 $cmp = $cmp['id'];
                 $sql = "insert into sda(congress_id,title,abstract_id,priority,abstract,date,session_start_time,session_end_time,presentation_start_time,presentation_end_time,presenter,sda_type_id,location,session_id,authors,company_id,team,link_to_poster,poster_board_no,product) values ('{$congid}','{$data['0']}','{$data['1']}','{$priority_name}','{$data['3']}','{$data['5']}','{$data['6']}','{$data['7']}','{$data['8']}','{$data['9']}','{$data['10']}',{$sda_type},'{$data['12']}','{$data['13']}','{$data['14']}','2','{$data['16']}','{$data['17']}','{$data['18']}','{$data['19']}')";
                 $query = Yii::$app->db->createCommand($sql)->execute();
             }
         }
         fclose($handle);
         return $this->redirect(Url::home());
     }
     return $this->render('excel', ['model' => $model]);
 }