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

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

<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>

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

indocoder.com

Tag: tutorial yii2

Tutorial Yii2 Bagian 21 : Mengirim Email beserta Attachment

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