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