public function actionReestr()
{
//$model = new Geo();
if (Yii::$app->request->post()) {
$allow_array = ['ur_l.name' => ' as uname', 'ur_l.inn'];
$select = Yii::$app->request->post('select');
$where = Yii::$app->request->post('where');
$groupby = Yii::$app->request->post('groupby');
$count = Yii::$app->request->post('count');
//* магия *//
$selectK = array_keys($select);
foreach ($selectK as $selectK2) {
$newname = str_replace(".", "__", $selectK2);
$selectK3[] = $selectK2 . ' as ' . $newname;
$selectK4[$newname] = $select[$selectK2];
$selectK5[] = $newname;
}
//для подсчета количесства юр.лиц и розничных точек
$countK = array_keys($count);
foreach ($countK as $key => $countK2) {
$selectK4[$countK2] = $count[$countK2];
$selectK5[] = $countK2;
}
$model = MyJSON::All_excel($selectK3, $where, $groupby, $count);
// print_r($select);
Excel::export(['fileName' => 'Реестр (' . date('d.m.Y') . ')', 'models' => $model, 'headers' => $selectK4, 'columns' => $selectK5]);
}
return $this->render('reestr');
}
public function actionExportArrivals($id)
{
if (!Yii::$app->user->isGuest && Yii::$app->user->identity->isadmin) {
$model = Flights::find()->andWhere(['airport_id' => $id, 'isarrival' => 1])->all();
if (!$model) {
$model = new Flights();
}
\moonland\phpexcel\Excel::export(['models' => $model, 'fileName' => 'arrivals.xlsx', 'format' => 'Excel2007', 'columns' => ['airline', 'flightnumber', 'gate', 'aircraft', 'icaofrom', 'timefrom', 'timeto'], 'headers' => ['airline' => 'Airline', 'flightnumber' => 'Flight', 'gate' => 'Gate', 'aircraft' => 'Aircraft', 'icaofrom' => 'From', 'timefrom' => 'Departure', 'timeto' => 'Arrival']]);
}
}
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 getArryFile($paramFile)
{
$pathDefault = '/var/www/backup/ExternalData/default_format/';
$pathImport = '/var/www/backup/ExternalData/import_salespo/';
$fileData = $paramFile != '' ? $pathImport . $paramFile : $pathDefault . 'default_import_salespo.xlsx';
//$fileName='/var/www/backup/ExternalData/import_gudang/'.$fileData;
$config = '';
//$data = \moonland\phpexcel\Excel::import($fileName, $config);
$data = \moonland\phpexcel\Excel::widget(['id' => 'export-salespo-id', 'mode' => 'import', 'fileName' => $fileData, 'setFirstRecordAsKeys' => true, 'setIndexSheetByName' => true, 'getOnlySheet' => 'STOCK-SALESPO']);
//print_r($data);
$aryDataProvider = new ArrayDataProvider(['allModels' => $data, 'pagination' => ['pageSize' => 1000]]);
//return Spinner::widget(['preset' => 'medium', 'align' => 'center', 'color' => 'blue','hidden'=>false]);
return $aryDataProvider;
}
public function actionExcel($act)
{
//$model = Ur::findOne(10);
// $model=MyJSON::find()->ur_l()->all();
// $model= Users::find()->select(['id','username'])->where(['status' => '3'])->all();
// $model=Users::find()->select(['id','username'])->where(['status' => '3'])->all();
if ($act == 'apteki') {
$model = MyJSON::apteki_excel();
Excel::export(['models' => $model, 'fileName' => 'Розничные точки (' . date('d.m.Y') . ')', 'headers' => ['rname' => "Регион", 'name' => 'Юр.лицо', 'address' => "Адрес розничной точки", 'tip' => "Тип", 'contact_face' => "Контактное лицо", 'contact_face_dolj' => "Должность контактное лицо", 'contact_phone' => "Телефон розничной точки", 'contact_mail' => "E-mail", 'farmopeka' => "Фармопека", 'site' => "Сайт", 'su_login' => 'Логин в ААУ', 'password_simple' => 'Пароль в ААУ'], 'columns' => ['rname', 'name', 'address', 'tip', 'contact_face', 'contact_face_dolj', 'contact_phone', 'contact_mail', 'farmopeka', 'site', 'su_login', 'password_simple']]);
} else {
//$this->fileName='aaaa';
$model = MyJSON::ur_l_excel();
Excel::export(['fileName' => 'Юридически лица (' . date('d.m.Y') . ')', 'models' => $model, 'headers' => ['name' => "Юридическое лицо", 'inn' => 'ИНН', 'wabc' => 'WABC', 'rname' => "Регион", 'username' => "Региональный представитель", 'address' => "Адрес", 'contact_face' => "Контактное лицо", 'contact_phone' => "Телефон руководителя", 'contact_mail' => "E-mail руководителя", 'contact_dr' => 'День рождения руководителя', 'farmopeka' => 'Фармопека', 'count' => 'Количество розничных точек', 'su_login' => 'Логин в ААУ', 'password_simple' => 'Пароль в ААУ', 'plat' => 'Плательщик взносов'], 'columns' => ['name', 'inn', 'wabc', 'rname', 'username', 'address', 'contact_face', 'contact_phone', 'contact_mail', 'contact_dr', 'farmopeka', 'count', 'su_login', 'password_simple', 'plat']]);
}
}
/**
* Вывод отчетов EXCEL
*/
public function actionExcel($id = 11, $date = null)
{
$region_id = $id;
$model = Ot::ListAptekiAnsverXml($region_id, $date);
Excel::export(['models' => $model, 'headers' => ['rname' => 'Регион', 'username' => "Провизор-информатор", 'uname' => "Юридическое лицо", 'name' => "Ассортимент", 'nal' => 'Наличие', 'zakupka' => 'Закупка', 'prodaja' => 'Продажа'], 'columns' => ['rname', 'username', 'uname', 'name', 'nal', 'zakupka', 'prodaja']]);
}
public function getArryFile($paramFile)
{
$fileData = $paramFile != '' ? $paramFile : 'default_import_sales.xlsx';
$fileName = Yii::$app->basePath . '/web/upload/sales_import/' . $fileData;
$config = '';
//$data = \moonland\phpexcel\Excel::import($fileName, $config);
$data = \moonland\phpexcel\Excel::widget(['id' => 'export', 'mode' => 'import', 'fileName' => $fileName, 'setFirstRecordAsKeys' => true, 'setIndexSheetByName' => true, 'getOnlySheet' => 'IMPORT FORMAT STOCK']);
//print_r($data);
$aryDataProvider = new ArrayDataProvider(['allModels' => $data, 'pagination' => ['pageSize' => 1000]]);
//return Spinner::widget(['preset' => 'medium', 'align' => 'center', 'color' => 'blue','hidden'=>false]);
return $aryDataProvider;
}
<?php use app\models\Bukutamu; // export data only one worksheet. $allModels = Bukutamu::find()->all(); \moonland\phpexcel\Excel::widget(['models' => $allModels, 'mode' => 'export', 'columns' => ['nama', 'pesan', 'tanggal']]);
