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