Tutorial Yii2 Bagian 22 : Menambahkan Class pada Baris di Gridview

Posted on November 3, 2017November 3, 2017 by admin

Di tabel Branches terdapat atribut status aktif dan tidak aktif. Kita akan memberikan warna yang berbeda melalui Class di dalam gridview di index.php. 1. Modifikasi index.php yang berada di folder views/branches dan berikan rowOptions :

'rowOptions' => function($model){
                    if($model->branch_status == 'active'){
                        return ['class'=>'success'];
                    }else{
                        return ['class'=>'danger'];
                    }

                    },

'rowOptions' => function($model){

if($model->branch_status == 'active'){

return ['class'=>'success'];

}else{

return ['class'=>'danger'];

}

Maka akan berubah berdasarkan classnya, baris branch yang berstatus aktif dan tidak. Tutorial ini sebagai dokumentasi dan pembelajaran pribadi sekalian belajar terjemahin Read more about Tutorial Yii2 Bagian 22 : Menambahkan Class pada Baris di Gridview[…]

Tutorial Yii2 Bagian 21 : Mengirim Email beserta Attachment

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

Di kesempatan kali ini kita akan membahas cara untuk membuat form email dan memberikan pilihan untuk menyertakan attachment pada email tersebut. 1. Buat tabel email dengan atribut ini : 2. Buat model dan crud menggunakan gii pada tabel email.

<?php

namespace backend\models;

use Yii;

/**
 * This is the model class for table "emails".
 *
 * @property integer $id
 * @property string $receiver_name
 * @property string $receiver_email
 * @property string $subject
 * @property string $content
 * @property string $attachment
 */
class Emails extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'emails';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['receiver_name', 'receiver_email', 'subject', 'content', 'attachment'], 'required'],
            [['content'], 'string'],
            [['receiver_name'], 'string', 'max' => 50],
            [['receiver_email'], 'string', 'max' => 200],
            [['subject', 'attachment'], 'string', 'max' => 255]
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'receiver_name' => 'Receiver Name',
            'receiver_email' => 'Receiver Email',
            'subject' => 'Subject',
            'content' => 'Content',
            'attachment' => 'Attachment',
        ];
    }
}

<?php

namespace backend\models;

use Yii;

/**

* This is the model class for table "emails".

* @property integer $id

* @property string $receiver_name

* @property string $receiver_email

* @property string $subject

* @property string $content

* @property string $attachment

class Emails extends \yii\db\ActiveRecord

{

/**

* @inheritdoc

public static function tableName()

{

return 'emails';

}

/**

* @inheritdoc

public function rules()

{

return [

[['receiver_name', 'receiver_email', 'subject', 'content', 'attachment'], 'required'],

[['content'], 'string'],

[['receiver_name'], 'string', 'max' => 50],

[['receiver_email'], 'string', 'max' => 200],

[['subject', 'attachment'], 'string', 'max' => 255]

];

}

/**

* @inheritdoc

public function attributeLabels()

{

return [

'id' => 'ID',

'receiver_name' => 'Receiver Name',

'receiver_email' => 'Receiver Email',

'subject' => 'Subject',

'content' => 'Content',

'attachment' => 'Attachment',

];

}

3. Tambahkan mailer di dalam config/main.php

        'mailer'=>[
            'class'=>'yii\swiftmailer\Mailer',
            'useFileTransport'=>false,
        ],

'mailer'=>[

'class'=>'yii\swiftmailer\Mailer',

'useFileTransport'=>false,

4. Modifikasi file _form.php dengan menambahkan tipe input Read more about Tutorial Yii2 Bagian 21 : Mengirim Email beserta Attachment[…]

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)[…]

indocoder.com

Category: Tutorial Yii2 Framework

Tutorial Yii2 Bagian 22 : Menambahkan Class pada Baris di Gridview

Tutorial Yii2 Bagian 21 : Mengirim Email beserta Attachment

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