public function init()
{
//khoi tao session
$session = Yii::$app->session;
if (isset($_GET['lang'])) {
$session->set('language', $_GET['lang']);
}
$languageInput = $session->get('language');
$languageInput = $session['language'];
$languageInput = isset($_SESSION['language']) ? $_SESSION['language'] : 'EN';
Yii::$app->language = $languageInput;
$fileName = "lang/language.xlsx";
$data = \moonland\phpexcel\Excel::import($fileName, ['setIndexSheetByName' => true]);
$record = $data['Sheet1'];
foreach ($record as $keys => $value) {
foreach ($value as $keyOfValue => $valueOfValue) {
if ($keyOfValue != 'Keys' && $keyOfValue != $languageInput) {
unset($value[$keyOfValue]);
}
}
$word[] = '"' . implode('"=>"', $value) . '",';
}
mkdir("lang/" . $languageInput);
$myfile = fopen("lang/" . $languageInput . "/app.php", "w");
$txt = "<?php \nreturn [ \n";
fwrite($myfile, $txt);
$txt = "];\n?>";
foreach ($word as $word) {
fwrite($myfile, $word . "\n");
}
fwrite($myfile, $txt);
fclose($myfile);
}
public function actionDepartures($id)
{
$model = new Flights();
$model->airport_id = $id;
$model->icaofrom = $model->airport->icao;
$model->isarrival = 0;
if (!Yii::$app->user->isGuest && Yii::$app->user->identity->isadmin) {
Yii::$app->user->returnUrl = '/booking/departures/' . $id;
if ($p = Yii::$app->request->post('Flights')) {
$model->attributes = $p;
$model->save();
$this->refresh();
}
if ($t = Yii::$app->request->post('admin_link_turnaround')) {
$fid = Yii::$app->request->post('admin_link_ownid');
$of = Flights::findOne($fid);
$of->turnaround_id = $t;
$tf = Flights::findOne($t);
$tf->turnaround_id = $fid;
$of->save();
$tf->save();
$this->refresh();
}
if ($uf = UploadedFile::getInstanceByName('batch_loading')) {
if ($uf->type == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') {
$data = \moonland\phpexcel\Excel::import($uf->tempName, ['setFirstRecordAsKeys' => true]);
foreach ($data as $item) {
if (isset($item['Airline']) && isset($item['To']) && isset($item['Flight']) && isset($item['Gate']) && isset($item['Aircraft']) && isset($item['Departure']) && isset($item['Arrival'])) {
if (!($m = Flights::find()->andWhere(['airline' => $item['Airline'], 'flightnumber' => $item['Flight']])->one())) {
$m = new Flights();
}
$m->airport_id = $id;
$m->icaofrom = $m->airport->icao;
$m->isarrival = 0;
$m->airline = $item['Airline'];
$m->icaoto = $item['To'];
$m->flightnumber = $item['Flight'];
$m->gate = $item['Gate'];
$m->aircraft = $item['Aircraft'];
$m->timefrom = $item['Departure'];
$m->timeto = $item['Arrival'];
$m->save();
}
}
$this->refresh();
}
}
}
return $this->render('arrivals', ['model' => $model]);
}
