Tutorial Yii2 Bagian 18-19 : Role-Based Access Control (RBAC)

Posted on November 2, 2017November 2, 2017 by admin

RBAC merupakan fitur penting yang perlu ada di aplikasi yang kita buat, karena digunakan untuk mengatur akses yang mana yang boleh dilihat oleh role tertentu. 1. Siapkan tabel-tabel yang dibutuhkan yaitu tabel auth_assignment, auth_item, auth_item_child, dan auth_rule, file sql nya seperti ini :

drop table if exists `auth_assignment`;
drop table if exists `auth_item_child`;
drop table if exists `auth_item`;
drop table if exists `auth_rule`;

create table `auth_rule`
(
`name` varchar(64) not null,
`data` text,
`created_at` integer,
`updated_at` integer, primary key (`name`)
) engine InnoDB;

create table `auth_item`
(
`name` varchar(64) not null,
`type` integer not null,
`description` text,
`rule_name` varchar(64),
`data` text,
`created_at` integer,
`updated_at` integer,
primary key (`name`),
foreign key (`rule_name`) references `auth_rule` (`name`) on delete set null on update cascade,
key `type` (`type`)
) engine InnoDB;

create table `auth_item_child`
(
`parent` varchar(64) not null,
`child` varchar(64) not null,
primary key (`parent`, `child`),
foreign key (`parent`) references `auth_item` (`name`) on delete cascade on update cascade,
foreign key (`child`) references `auth_item` (`name`) on delete cascade on update cascade
) engine InnoDB;

create table `auth_assignment`
(
`item_name` varchar(64) not null,
`user_id` varchar(64) not null,
`created_at` integer,
primary key (`item_name`, `user_id`),
foreign key (`item_name`) references `auth_item` (`name`) on delete cascade on update cascade
) engine InnoDB;

drop table if exists `auth_assignment`;

drop table if exists `auth_item_child`;

drop table if exists `auth_item`;

drop table if exists `auth_rule`;

create table `auth_rule`

(

`name` varchar(64) not null,

`data` text,

`created_at` integer,

`updated_at` integer, primary key (`name`)

) engine InnoDB;

create table `auth_item`

(

`name` varchar(64) not null,

`type` integer not null,

`description` text,

`rule_name` varchar(64),

`data` text,

`created_at` integer,

`updated_at` integer,

primary key (`name`),

foreign key (`rule_name`) references `auth_rule` (`name`) on delete set null on update cascade,

key `type` (`type`)

) engine InnoDB;

create table `auth_item_child`

(

`parent` varchar(64) not null,

`child` varchar(64) not null,

primary key (`parent`, `child`),

foreign key (`parent`) references `auth_item` (`name`) on delete cascade on update cascade,

foreign key (`child`) references `auth_item` (`name`) on delete cascade on update cascade

) engine InnoDB;

create table `auth_assignment`

(

`item_name` varchar(64) not null,

`user_id` varchar(64) not null,

`created_at` integer,

primary key (`item_name`, `user_id`),

foreign key (`item_name`) references `auth_item` (`name`) on delete cascade on update cascade

) engine InnoDB;

2. Misalnya kita ingin memberikan rule kepada user untuk membuat branch. Read more about Tutorial Yii2 Bagian 18-19 : Role-Based Access Control (RBAC)[…]

Tutorial Yii2 Bagian 17 : Mengupload File ke Server

Posted on November 2, 2017November 2, 2017 by admin

Di tutorial ini kita akan melakukan upload untuk menyimpan logo dalam format .jpg. 1. Pertama-tama kita harus menambahkan kolom logo di tabel Company dengan format varchar. 2. Tambahkan public variable $file pada model Companies.php

public $file;

1	public $file;

3. Mendefinisikan di public function rules bahwa file ini berupa tipe file dan tambahkan logo sebagai string :

    public function rules()
    {
        return [
            [['company_name', 'company_email', 'company_address'], 'required'],
            [['company_start_date', 'company_created_date'], 'safe'],
            [['company_status'], 'string'],
            [['file'],'file'],
            [['company_name','logo', 'company_email'], 'string', 'max' => 100],
            [['company_address', 'logo'], 'string', 'max' => 255]
        ];
    }

public function rules()

{

return [

[['company_name', 'company_email', 'company_address'], 'required'],

[['company_start_date', 'company_created_date'], 'safe'],

[['company_status'], 'string'],

[['file'],'file'],

[['company_name','logo', 'company_email'], 'string', 'max' => 100],

[['company_address', 'logo'], 'string', 'max' => 255]

];

}

Tutorial Yii2 Bagian 16 : Membuat Ajax Search pada Gridview dengan PJax

Posted on November 2, 2017November 2, 2017 by admin

Membuat ajax search pada index.php menggunakan PJax cukup mudah :

use yii\widgets\Pjax;

1	use yii\widgets\Pjax;

Modifikasi index.php dengan menambahkan baris ini :

<?php Pjax::begin();?>
...
...
...
<?php Pjax::end(); ?>

<?php Pjax::begin();?>

...

<?php Pjax::end(); ?>

Sehingga index.php menjadi seperti ini :

<?php

use yii\helpers\Html;
use yii\grid\GridView;
use dosamigos\datepicker\DatePicker;
use yii\widgets\Pjax;

/* @var $this yii\web\View */
/* @var $searchModel backend\models\CompaniesSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */

$this->title = 'Companies';
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="companies-index">

    <h1><?= Html::encode($this->title) ?></h1>
    <?php // echo $this->render('_search', ['model' => $searchModel]); ?>

    <p>
        <?= Html::a('Create Companies', ['create'], ['class' => 'btn btn-success']) ?>
    </p>
    <?php Pjax::begin();?>
    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],

            //'company_id',
            'company_name',
            'company_email:email',
            'company_address',
            [
                'attribute'=>'company_start_date',
                'value'=>'company_start_date',
                'format'=>'raw',
                'filter'=>DatePicker::widget([
                    'model' => $searchModel,
                    'attribute' => 'company_start_date',
                        'clientOptions' => [
                            'autoclose' => true,
                            'format' => 'yyyy-m-d'
                        ]
                ])
            ],
            //'company_start_date',
            // 'company_created_date',
            // 'company_status',
            // 'logo',

            ['class' => 'yii\grid\ActionColumn'],
        ],
    ]); ?>
    <?php Pjax::end(); ?>
</div>

<?php

use yii\helpers\Html;

use yii\grid\GridView;

use dosamigos\datepicker\DatePicker;

use yii\widgets\Pjax;

/* @var $this yii\web\View */

/* @var $searchModel backend\models\CompaniesSearch */

/* @var $dataProvider yii\data\ActiveDataProvider */

$this->title = 'Companies';

$this->params['breadcrumbs'][] = $this->title;

<h1><?= Html::encode($this->title) ?></h1>

<?php // echo $this->render('_search', ['model' => $searchModel]); ?>

<?= Html::a('Create Companies', ['create'], ['class' => 'btn btn-success']) ?>

<?php Pjax::begin();?>

<?= GridView::widget([

'dataProvider' => $dataProvider,

'filterModel' => $searchModel,

'columns' => [

['class' => 'yii\grid\SerialColumn'],

//'company_id',

'company_name',

'company_email:email',

'company_address',

[

'attribute'=>'company_start_date',

'value'=>'company_start_date',

'format'=>'raw',

'filter'=>DatePicker::widget([

'model' => $searchModel,

'attribute' => 'company_start_date',

'clientOptions' => [

'autoclose' => true,

'format' => 'yyyy-m-d'

]

])

//'company_start_date',

// 'company_created_date',

// 'company_status',

// 'logo',

['class' => 'yii\grid\ActionColumn'],

]); ?>

<?php Pjax::end(); ?>

</div>

Sekarang kita tidak perlu merefresh halaman untuk melakukan pencarian pada gridview. Tutorial ini sebagai dokumentasi dan pembelajaran pribadi sekalian belajar terjemahin bahasa Inggris, dan siapa tahu bermanfaat buat orang Read more about Tutorial Yii2 Bagian 16 : Membuat Ajax Search pada Gridview dengan PJax[…]

Tutorial Yii2 Bagian 15: Datepicker pada Filter Field Gridview

Posted on November 2, 2017November 2, 2017 by admin

Kali ini kita akan membuat datepicker pada filter field gridview yang berada di index.php. Modifikasi index.php yang berada di dalam folder backend/modules/settings/views/companies. Tambahkan

use dosamigos\datepicker\DatePicker;

1	use dosamigos\datepicker\DatePicker;

Dan

[
                'attribute'=>'company_start_date',
                'value'=>'company_start_date',
                'format'=>'raw',
                'filter'=>DatePicker::widget([
                    'model' => $searchModel,
                    'attribute' => 'company_start_date',
                        'clientOptions' => [
                            'autoclose' => true,
                            'format' => 'yyyy-m-d'
                        ]
                ])
            ],

[

'attribute'=>'company_start_date',

'value'=>'company_start_date',

'format'=>'raw',

'filter'=>DatePicker::widget([

'model' => $searchModel,

'attribute' => 'company_start_date',

'clientOptions' => [

'autoclose' => true,

'format' => 'yyyy-m-d'

]

])

Sehingga index.php menjadi seperti ini :

<?php

use yii\helpers\Html;
use yii\grid\GridView;
use dosamigos\datepicker\DatePicker;

/* @var $this yii\web\View */
/* @var $searchModel backend\models\CompaniesSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */

$this->title = 'Companies';
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="companies-index">

    <h1><?= Html::encode($this->title) ?></h1>
    <?php // echo $this->render('_search', ['model' => $searchModel]); ?>

    <p>
        <?= Html::a('Create Companies', ['create'], ['class' => 'btn btn-success']) ?>
    </p>

    <?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],

            //'company_id',
            'company_name',
            'company_email:email',
            'company_address',
            [
                'attribute'=>'company_start_date',
                'value'=>'company_start_date',
                'format'=>'raw',
                'filter'=>DatePicker::widget([
                    'model' => $searchModel,
                    'attribute' => 'company_start_date',
                        'clientOptions' => [
                            'autoclose' => true,
                            'format' => 'yyyy-m-d'
                        ]
                ])
            ],
            //'company_start_date',
            // 'company_created_date',
            // 'company_status',
            // 'logo',

            ['class' => 'yii\grid\ActionColumn'],
        ],
    ]); ?>

</div>

<?php

use yii\helpers\Html;

use yii\grid\GridView;

use dosamigos\datepicker\DatePicker;

/* @var $this yii\web\View */

/* @var $searchModel backend\models\CompaniesSearch */

/* @var $dataProvider yii\data\ActiveDataProvider */

$this->title = 'Companies';

$this->params['breadcrumbs'][] = $this->title;

<h1><?= Html::encode($this->title) ?></h1>

<?php // echo $this->render('_search', ['model' => $searchModel]); ?>

<?= Html::a('Create Companies', ['create'], ['class' => 'btn btn-success']) ?>

<?= GridView::widget([

'dataProvider' => $dataProvider,

'filterModel' => $searchModel,

'columns' => [

['class' => 'yii\grid\SerialColumn'],

//'company_id',

'company_name',

'company_email:email',

'company_address',

[

'attribute'=>'company_start_date',

'value'=>'company_start_date',

'format'=>'raw',

'filter'=>DatePicker::widget([

'model' => $searchModel,

'attribute' => 'company_start_date',

'clientOptions' => [

'autoclose' => true,

'format' => 'yyyy-m-d'

]

])

//'company_start_date',

// 'company_created_date',

// 'company_status',

// 'logo',

['class' => 'yii\grid\ActionColumn'],

]); ?>

</div>

Hasilnya, pada index.php dapat di search berdasarkan tanggal : Tutorial ini sebagai dokumentasi dan pembelajaran pribadi sekalian belajar terjemahin bahasa Inggris, dan siapa tahu bermanfaat buat orang Read more about Tutorial Yii2 Bagian 15: Datepicker pada Filter Field Gridview[…]

Tutorial Yii2 Bagian 14 : Membuat DropDown Search Select2 Widget

Posted on November 2, 2017November 2, 2017 by admin

Sekarang kita akan membuat DropDown Search dengan menggunakan tools yang disediakan oleh vendor kartik-v yaitu Yii2 Select2 Widget. 1. Install Yii2 Widget Select2 dengan memberikan perintah ini pada directory advanced :

$ sudo php composer.phar require kartik-v/yii2-widget-select2 "@dev"

1	$ sudo php composer.phar require kartik-v/yii2-widget-select2 "@dev"

2. Modifikasi file _form.php yang berada di folder \backend\views\branches dengan menambahkan

<span class="pl-s1"><span class="pl-k">use</span> <span class="pl-c1">kartik\select2\Select2</span>;</span>

1	<span class="pl-s1"><span class="pl-k">use</span> <span class="pl-c1">kartik\select2\Select2</span>;</span>

dan copy paste dari web kartik :

<span class="pl-s1"><span class="pl-c1">echo</span> <span class="pl-smi">$form</span><span class="pl-k">-&gt;</span>field(<span class="pl-smi">$model</span>, <span class="pl-s"><span class="pl-pds">'</span>state_1<span class="pl-pds">'</span></span>)<span class="pl-k">-&gt;</span>widget(<span class="pl-c1">Select2</span><span class="pl-k">::</span>classname(), [</span>
<span class="pl-s1">    <span class="pl-s"><span class="pl-pds">'</span>data<span class="pl-pds">'</span></span> <span class="pl-k">=&gt;</span> <span class="pl-smi">$data</span>,</span>
<span class="pl-s1">    <span class="pl-s"><span class="pl-pds">'</span>language<span class="pl-pds">'</span></span> <span class="pl-k">=&gt;</span> <span class="pl-s"><span class="pl-pds">'</span>de<span class="pl-pds">'</span></span>,</span>
<span class="pl-s1">    <span class="pl-s"><span class="pl-pds">'</span>options<span class="pl-pds">'</span></span> <span class="pl-k">=&gt;</span> [<span class="pl-s"><span class="pl-pds">'</span>placeholder<span class="pl-pds">'</span></span> <span class="pl-k">=&gt;</span> <span class="pl-s"><span class="pl-pds">'</span>Select a state ...<span class="pl-pds">'</span></span>],</span>
<span class="pl-s1">    <span class="pl-s"><span class="pl-pds">'</span>pluginOptions<span class="pl-pds">'</span></span> <span class="pl-k">=&gt;</span> [</span>
<span class="pl-s1">        <span class="pl-s"><span class="pl-pds">'</span>allowClear<span class="pl-pds">'</span></span> <span class="pl-k">=&gt;</span> <span class="pl-c1">true</span></span>
<span class="pl-s1">    ],</span>
<span class="pl-s1">]);</span>

echo $form->field($model, 'state_1')->widget(Select2::classname(), [

'data' => $data,

'language' => 'de',

'options' => ['placeholder' => 'Select a state ...'],

'pluginOptions' => [

'allowClear' => true

],

]);

Ganti $data sehingga filenya menjadi Read more about Tutorial Yii2 Bagian 14 : Membuat DropDown Search Select2 Widget[…]

indocoder.com

indocoder.com

Tutorial Yii2 Bagian 18-19 : Role-Based Access Control (RBAC)

Tutorial Yii2 Bagian 17 : Mengupload File ke Server

Tutorial Yii2 Bagian 16 : Membuat Ajax Search pada Gridview dengan PJax

Tutorial Yii2 Bagian 15: Datepicker pada Filter Field Gridview

Tutorial Yii2 Bagian 14 : Membuat DropDown Search Select2 Widget