/** * 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]); }
</div> </div> <div class="col-xs-6 col-sm-4 p5"> <div class="ml20"> <?php echo $form->field($model, 'title', array('labelOptions' => array('class' => 'f18')))->textInput(['class' => 'form-control intp']); ?> </div></div> <div class="col-xs-6 col-sm-4 p5"> <div class="ml20"> <?php echo $form->field($model, 'priority', array('labelOptions' => array('class' => 'f18')))->dropDownList(ArrayHelper::map(SdaPriority::find()->asArray()->all(), 'id', 'priority_name'), ['id' => 'sda-priority', 'class' => 'form-control intp', 'selection' => $model->priority]); ?> </div></div> <div class="col-xs-6 col-sm-4 p5"> <div class="ml20"> <?php echo $form->field($model, 'authors', array('labelOptions' => array('class' => 'f18')))->textArea(['class' => 'form-control intp', 'rows' => '6', 'style' => 'height:65px !important;']); ?> </div></div> <div class="col-xs-6 col-sm-4 p5"> <div class="ml20">
<?php echo $form->field($model, 'session_id', ['labelOptions' => ['class' => 'sr-only']])->textInput(['maxlength' => '100', 'class' => 'form-control', 'placeholder' => $model->getAttributeLabel('session_id')]); ?> <?php echo $form->field($model, 'product', array('labelOptions' => array('class' => 'sr-only', 'label' => 'Product')))->dropDownList(ArrayHelper::map(Products::find()->orderBy(['name' => SORT_ASC])->asArray()->all(), 'id', 'name'), ['maxlength' => '100', 'class' => 'form-control', 'selection' => $model->product, 'prompt' => 'Select Product']); ?> </div> </div> <div class="container"> <div class="row"> <?php echo $form->field($model, 'poster_board_no', ['labelOptions' => ['class' => 'sr-only']])->textInput(['maxlength' => '100', 'class' => 'form-control', 'placeholder' => $model->getAttributeLabel('poster_board_no')]); ?> <?php echo $form->field($model, 'priority', array('labelOptions' => array('class' => 'sr-only', 'label' => 'Product')))->dropDownList(ArrayHelper::map(SdaPriority::find()->asArray()->all(), 'id', 'priority_name'), ['id' => 'sda-priority', 'class' => 'form-control', 'selection' => $model->priority, 'prompt' => 'Select Priority']); ?> </div> </div> <div class="container"> <div class="row"> <?php echo $form->field($model, 'startdate', array('labelOptions' => array('class' => 'sr-only')))->widget(\yii\jui\DatePicker::classname(), ['options' => ['class' => 'form-control', 'placeholder' => 'Start Date']]); ?> </div> <div class="row"> <?php echo $form->field($model, 'enddate', array('labelOptions' => array('class' => 'sr-only')))->widget(\yii\jui\DatePicker::classname(), ['options' => ['class' => 'form-control', 'placeholder' => 'End Date']]); ?>