public function getForm()
{
$model = new \yii\base\DynamicModel(['search_text']);
$model->addRule(['search_text'], 'string', ['max' => 128]);
$model->addRule(['search_text'], 'required');
$model->load(Yii::$app->request->get());
return $this->render('faqsearch/form', ['model' => $model]);
}
public function actionAmbilTanggal()
{
$model = new \yii\base\DynamicModel(['tanggal']);
$model->addRule(['tanggal'], 'safe');
if ($model->load(Yii::$app->request->post())) {
$hsl = Yii::$app->request->post();
$tgl = $hsl['DynamicModel']['tanggal'];
return $this->redirect(['index', 'tgl' => $tgl]);
} else {
return $this->renderAjax('_indexform', ['model' => $model]);
}
}
public function actionBusca()
{
$dmodel = new \yii\base\DynamicModel(['cartao', 'inscricao', 'prova']);
$dmodel->addRule(['cartao'], 'string', ['max' => 13]);
$dmodel->addRule(['cartao'], 'required');
if ($dmodel->load(Yii::$app->request->get())) {
$dmodel->inscricao = substr($dmodel->cartao, 0, 9);
$dmodel->prova = substr($dmodel->cartao, 9);
return $this->redirect(['lancar', 'inscricao_idinscricao' => $dmodel->inscricao, 'prova_idprova' => $dmodel->prova]);
} else {
return $this->render('busca', ['dmodel' => $dmodel]);
}
}
public function actionPassword()
{
$model = new \yii\base\DynamicModel(['oldPassword', 'newPassword']);
$model->addRule(['oldPassword', 'newPassword'], 'required');
if ($model->load(Yii::$app->request->post())) {
$user = Yii::$app->user->identity;
if ($user->validatePassword($model->oldPassword)) {
$user->setPassword($model->newPassword);
if ($user->save()) {
Yii::$app->session->setFlash('success', 'Password baru berhasil disimpan');
return $this->goHome();
}
}
Yii::$app->session->setFlash('error', 'Password lama salah');
}
return $this->render('password', ['model' => $model]);
}
<?php
/**
* @author Semenov Alexander <*****@*****.**>
* @link http://skeeks.com/
* @copyright 2010 SkeekS (СкикС)
* @date 21.09.2016
*/
/* @var $this yii\web\View */
/* @var $searchModel common\models\searchs\Game */
/* @var $dataProvider yii\data\ActiveDataProvider */
$filter = new \yii\base\DynamicModel(['id']);
$filter->addRule('id', 'integer');
$filter->load(\Yii::$app->request->get());
if ($filter->id) {
$dataProvider->query->andWhere(['id' => $filter->id]);
}
?>
<? $form = \skeeks\cms\modules\admin\widgets\filters\AdminFiltersForm::begin([
'action' => '/' . \Yii::$app->request->pathInfo,
]); ?>
<?php
echo $form->field($searchModel, 'email')->setVisible();
?>
<?php
echo $form->field($searchModel, 'phone')->setVisible();
?>
<? $form::end(); ?>
/**
* Arsip an exiting DataManagement model.
* If asrip is successful, the browser will be redirected to the 'index' page.
* @param integer $id
* @return mixed
*/
public function actionArsip($id)
{
$model = new \yii\base\DynamicModel(['jenis', 'kewargaan', 'tanggal']);
$model->addRule(['tanggal'], 'safe');
$model->addRule(['jenis'], 'integer');
$model->addRule(['kewargaan'], 'string');
if ($model->load(Yii::$app->request->post())) {
switch ($model->jenis) {
case '1':
$kewarganegaraan = new TabelKewarganegaraan();
$kewarganegaraan->kewargaan = $model->kewargaan;
$kewarganegaraan->nik = $id;
$kewarganegaraan->nik_pencatat = Yii::$app->user->id;
if ($kewarganegaraan->validate()) {
$kewarganegaraan->save(false);
}
return $this->redirect(['index']);
case '2':
$meninggal = new TabelKematian();
$meninggal->nik = $id;
$meninggal->tanggal_kematian = Yii::$app->formatter->asDate($model->tanggal, 'yyyy-MM-dd');
$meninggal->nik_pencatat = Yii::$app->user->id;
if ($meninggal->validate()) {
$meninggal->save(false);
}
return $this->redirect(['index']);
}
} else {
return $this->renderAjax('arsip', ['model' => $model]);
}
}
/**
* CHART -> CHECK DATE
* @author Piter Novian [ptr.nov@gmail.com]
* @since 2.0
*/
public function actionAmbilTanggalChart()
{
$model = new \yii\base\DynamicModel(['tglchartmd']);
$model->addRule(['tglchartmd'], 'required');
if (!$model->load(Yii::$app->request->post())) {
return $this->renderAjax('_indexSalesMdChartForm', ['model' => $model]);
} else {
if (Yii::$app->request->isAjax) {
$model->load(Yii::$app->request->post());
return Json::encode(\yii\widgets\ActiveForm::validate($model));
}
}
}
public function actionExport()
{
$render = null;
$exchanger = new Exchanger();
$model = new \yii\base\DynamicModel(['tabel']);
$model->addRule(['tabel'], 'string', ['max' => 30]);
if ($model->load(Yii::$app->request->post()) && $model->validate()) {
switch ($model->tabel) {
case '1':
$this->exportPenduduk();
$this->writeLog("Melakukan eksport data Penduduk ke excel");
die;
break;
case '2':
$this->exportKeluarga();
$this->writeLog("Melakukan eksport data Kartu Keluarga ke excel");
die;
break;
case '3':
$this->exportAktivitasUser();
$this->writeLog("Melakukan eksport data Aktivitas User ke excel");
die;
break;
default:
break;
}
}
$xlsModel = new UploadXlsForm();
if ($xlsModel->load(Yii::$app->request->post())) {
libxml_use_internal_errors(true);
$file = UploadedFile::getInstance($xlsModel, 'file');
$filename = 'Data_Penduduk' . Date('YmdGis') . '.' . $file->extension;
define('XLS_PATH', '../runtime/upload/');
$upload = $file->saveAs(XLS_PATH . $filename);
if ($upload) {
$xlsFile = XLS_PATH . $filename;
try {
$inputFT = \PHPExcel_IOFactory::identify($xlsFile);
$objReader = \PHPExcel_IOFactory::createReader($inputFT);
$objPHPExcel = $objReader->load($xlsFile);
} catch (Exception $e) {
die('Error');
}
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
for ($row = 0; $row <= $highestRow; $row++) {
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, True, False);
// VarDumper::dump($rowData);
if ($row == 1) {
continue;
}
$baseModel = new DataManagement();
$subModel = new BaseUpdatable();
$domisili = new TabelDomisili();
$baseModel->nik = $rowData[0][0];
$baseModel->nama = $rowData[0][1];
$baseModel->tempat_lahir = $rowData[0][2];
$baseModel->tanggal_lahir = $rowData[0][3];
$baseModel->jenis_kelamin = Exchanger::getKodeJK($rowData[0][4]);
$baseModel->golongan_darah = $rowData[0][5];
$baseModel->tanggal_diterbitkan = $rowData[0][6];
$baseModel->nik_pencatat = $rowData[0][7];
$subModel->nik = $baseModel->nik;
$subModel->no_kk = $rowData[0][8];
$subModel->status_keluarga = Exchanger::getKodeStatusKeluarga($rowData[0][9]);
$subModel->ayah = $rowData[0][10];
$subModel->ibu = $rowData[0][11];
$subModel->agama = Exchanger::getKodeAgama($rowData[0][12]);
$domisili->kelurahan = $rowData[0][16];
$domisili->rt = $rowData[0][17];
$domisili->rw = $rowData[0][18];
$domisili->alamat = $rowData[0][19];
$subModel->status_perkawinan = Exchanger::getKodeStatusPerkawinan($rowData[0][20]);
$subModel->pekerjaan = $rowData[0][21];
$subModel->pendidikan_terakhir = Exchanger::getKodePendidikan($rowData[0][22]);
// $subModel->foto = BaseUpdatable::findOne($baseModel->nik)->foto;
$baseModel->save();
$subModel->save();
$domisili->save();
}
unlink(XLS_PATH . $filename);
$this->writeLog("Melakukan import excel Data Penduduk");
die;
$render = $this->redirect('export');
}
}
$modelCsv = new \yii\base\DynamicModel(['tabelcsv']);
$modelCsv->addRule(['tabelcsv'], 'string', ['max' => 30]);
if ($modelCsv->load(Yii::$app->request->post())) {
switch ($modelCsv->tabelcsv) {
case '1':
$this->exportPendudukCsv();
$this->writeLog("Melakukan eksport data Penduduk ke csv");
die;
break;
case '2':
$this->exportKeluargaCsv();
$this->writeLog("Melakukan eksport data Kartu Keluarga ke csv");
die;
break;
case '3':
$this->exportAktivitasUserCsv();
$this->writeLog("Melakukan eksport data Aktivitas User ke csv");
die;
break;
}
}
$uploadCsv = new UploadCsvForm();
if ($uploadCsv->load(Yii::$app->request->post())) {
$file = UploadedFile::getInstance($uploadCsv, 'file');
$filename = 'Data_Penduduk' . Date('YmdGis') . '.' . $file->extension;
$upload = $file->saveAs('../runtime/upload/' . $filename);
if ($upload) {
define('CSV_PATH', '../runtime/upload/');
$csvFile = CSV_PATH . $filename;
$csv = file($csvFile);
unset($csv[0]);
// Remove headers
foreach ($csv as $data) {
$baseModel = new DataManagement();
$in = explode(",", $data);
$baseModel->nik = $in[0];
$baseModel->nama = $in[1];
$baseModel->tempat_lahir = $in[2];
$baseModel->tanggal_lahir = $in[3];
$baseModel->jenis_kelamin = $in[4];
$baseModel->golongan_darah = $in[5];
$baseModel->tanggal_diterbitkan = $in[6];
$baseModel->nik_pencatat = $in[7];
$baseModel->save();
}
unlink('../runtime/upload/' . $filename);
$this->writeLog("Melakukan import csv data penduduk");
$render = $this->redirect('export');
}
}
if (empty($render)) {
return $this->render('index', ['modelCsv' => $modelCsv, 'uploadCsv' => $uploadCsv, 'model' => $model, 'upload' => $xlsModel]);
} else {
return $render;
}
}
