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