Yii2 Tips 23 : All About Where ActiveQuery

Posted on January 3, 2018 by admin

Select * From branches Where status_aktif = 1

\common\models\Branches::find()
->where(['status_aktif' => 1])
->all();

\common\models\Branches::find()

->where(['status_aktif' => 1])

->all();

Select * From branches Where status_aktif = 1 (Bind Param)

\common\models\Branches::find()
->where('status_aktif=:status_aktif',[':status_aktif' => 1])
->all();

\common\models\Branches::find()

->where('status_aktif=:status_aktif',[':status_aktif' => 1])

->all();

Select * From branches Where created_date <= now

\common\models\Branches::find()
->where(['<=', 'created_date', date('Y-m-d H:i:s')])
->all();

\common\models\Branches::find()

->where(['<=', 'created_date', date('Y-m-d H:i:s')])

->all();

Menampilkan nilai branches yang statusnya diterima (12), ditolak (13), pending (14)

\common\models\Branches::find()
->where(['IN', 'status', [StatusFlag::DITERIMA,  StatusFlag::DITOLAK,  StatusFlag::PENDING]])
->all();

\common\models\Branches::find()

->where(['IN', 'status', [StatusFlag::DITERIMA, StatusFlag::DITOLAK, StatusFlag::PENDING]])

->all();

Select * From branches Where name like ‘%%’

\common\models\Branches::find()
->where(['like', 'name', $this->name])
->all();

\common\models\Branches::find()

->where(['like', 'name', $this->name])

->all();

Yii2 Tips 22 : Mengirim Email

Posted on January 3, 2018 by admin

Tips untuk mengirim email di Yii2, SMTP Service yang saya gunakan adalah SMTP2Go. Langkah 1 : Tambahkan Mailer Tambahkan mailer di components main.php yang ada di folder config baik di common, backend, maupun frontend.

'mailer' => require(Yii::getAlias('@common').'/config/email.php'),

1	'mailer' => require(Yii::getAlias('@common').'/config/email.php'),

Kemudian buat file email.php di folder common/config :

<?php 
return [
	'class' => 'yii\swiftmailer\Mailer',
	'useFileTransport' => false,
	'transport' => [
		'class' => 'Swift_SmtpTransport',
		'host' => 'mail.smtp2go.com',
		'username' => 'yourusername@gmail.com',
		'password' => 'yoursmtppassword',
		'port' => 2525,
	],
	'viewPath' => '@common/mail',
	'messageConfig' => [
		'bcc' => [
			'emailbcc1@gmail.com',
			'emailbcc2@gmail.com',
		]
	]
];
?>

<?php

return [

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

'useFileTransport' => false,

'transport' => [

'class' => 'Swift_SmtpTransport',

'host' => 'mail.smtp2go.com',

'username' => '[email protected]',

'password' => 'yoursmtppassword',

'port' => 2525,

'viewPath' => '@common/mail',

'messageConfig' => [

'bcc' => [

'[email protected]',

]

];

Langkah 2 : Buat Notification Helper Notification Helper ini berguna untuk Read more about Yii2 Tips 22 : Mengirim Email[…]

Yii2 Tips 21 : Mengupload Multiple Files dengan FileInput Widget

Posted on January 3, 2018 by admin

Untuk mengupload multiple files dengan fileinput widget cukup memodifikasi sedikit dari Tips sebelumnya. Yang perlu dimodifikasi adalah pada _form.php,

<?= $form->field($model, 'namafile')

1	<?= $form->field($model, 'namafile')

menjadi array :

<?= $form->field($model, 'namafile[]')

1	<?= $form->field($model, 'namafile[]')

kemudian tambahkan berapa file yang bisa diupload dalam suatu waktu :

'maxFileCount'=> 10,

1	'maxFileCount'=> 10,

Dan aktifkan multiple upload :

'options' => ['multiple'=>true, 'accept' => '']

1	'options' => ['multiple'=>true, 'accept' => '']

Sehingga _form.php menjadi :

<?= $form->field($model, 'namafile[]')->widget(FileInput::className(),[
        'options' => ['multiple'=>true, 'accept' => '']
        'pluginOptions' => [
            'showRemove'=> false,
            'showUpload' => false,
            'showCancel' => false,
            'overwriteInitial' => false,
            'initialPreviewConfig' => $json,
            'previewFileType' => 'image',
            'initialPreview' => $img,
            'uploadAsync'=> true,
            'maxFileSize' => 3*1024*1024,
            'deleteUrl' => Url::to(['/file/delete-upload']),
            'allowedExtensions' => ['jpg','png','jpeg'],
            'maxFileCount'=> 10,
        ]
     ])?>
    <?php else : ?>
         <?= $form->field($model, 'namafile[]')->widget(FileInput::classname(), [
        'options' => ['multiple'=>true, 'accept' => '']
        'pluginOptions' => [
            'showUpload' => false,
            'maxFileCount'=> 10,
        ]
    ]); ?>

<?= $form->field($model, 'namafile[]')->widget(FileInput::className(),[

'options' => ['multiple'=>true, 'accept' => '']

'pluginOptions' => [

'showRemove'=> false,

'showUpload' => false,

'showCancel' => false,

'overwriteInitial' => false,

'initialPreviewConfig' => $json,

'previewFileType' => 'image',

'initialPreview' => $img,

'uploadAsync'=> true,

'maxFileSize' => 3*1024*1024,

'deleteUrl' => Url::to(['/file/delete-upload']),

'allowedExtensions' => ['jpg','png','jpeg'],

'maxFileCount'=> 10,

]

])?>

<?php else : ?>

<?= $form->field($model, 'namafile[]')->widget(FileInput::classname(), [

'options' => ['multiple'=>true, 'accept' => '']

'pluginOptions' => [

'showUpload' => false,

'maxFileCount'=> 10,

]

]); ?>

Ubah actionCreate pada Controller, dari getInstance menjadi getInstances Read more about Yii2 Tips 21 : Mengupload Multiple Files dengan FileInput Widget[…]

Yii2 Tips 20 : Mengupload File Menggunakan Kartik FileInput Widget

Posted on January 3, 2018 by admin

Upload file menggunakan kartik fileinput widget : Langkah 1 : Install Yii2 Extension Kartik FileInput

composer require kartik-v/yii2-widget-fileinput "@dev"

1	composer require kartik-v/yii2-widget-fileinput "@dev"

Langkah 2 : Buat Tabel dan Model Pada contoh ini, kita akan membuat tabel file dan model File dengan Gii.

<?php

namespace common\models;

use Yii;

/**
 * This is the model class for table "file".
 *
 * @property integer $id
 * @property string $namafile
 */
class File extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'file';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['namafile'], 'string', 'max' => 100],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'namafile' => Yii::t('app', 'Namafile'),
        ];
    }
}

<?php

namespace common\models;

use Yii;

/**

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

* @property integer $id

* @property string $namafile

class File extends \yii\db\ActiveRecord

{

/**

* @inheritdoc

public static function tableName()

{

return 'file';

}

/**

* @inheritdoc

public function rules()

{

return [

[['namafile'], 'string', 'max' => 100],

];

}

/**

* @inheritdoc

public function attributeLabels()

{

return [

'id' => Yii::t('app', 'ID'),

'namafile' => Yii::t('app', 'Namafile'),

];

}

Langkah 3 : Persiapkan Controller dan View Siapkan FileController.php kemudian tambahkan beberapa action sebagai berikut : 1. public function Read more about Yii2 Tips 20 : Mengupload File Menggunakan Kartik FileInput Widget[…]

Yii2 Tips 19 : Membuat Output View ke PDF

Posted on January 3, 2018 by admin

Membuat output pdf menggunakan kartik yii2 mpdf : Langkah 1 : Install yii2-mpdf extension Pada folder utama aplikasi, ketik

composer require kartik-v/yii2-mpdf "*"

1	composer require kartik-v/yii2-mpdf "*"

Tunggu sampai instalasi selesai Langkah 2 : Menambahkan action pada Controller Disini kita akan menambahkan actionReport pada SiteController.php

public function actionReport(){
        $content = $this->renderPartial('_reportView');
         
            // setup kartik\mpdf\Pdf component
            $pdf = new Pdf([
                // set to use core fonts only
                'mode' => Pdf::MODE_CORE, 
                // A4 paper format
                'format' => Pdf::FORMAT_A4, 
                // portrait orientation
                'orientation' => Pdf::ORIENT_PORTRAIT, 
                // stream to browser inline
                'destination' => Pdf::DEST_BROWSER, 
                // your html content input
                'content' => $content,  
                // format content from your own css file if needed or use the
                // enhanced bootstrap css built by Krajee for mPDF formatting 
                'cssFile' => '@vendor/kartik-v/yii2-mpdf/assets/kv-mpdf-bootstrap.min.css',
                // any css to be embedded if required
                'cssInline' => '.kv-heading-1{font-size:18px}', 
                 // set mPDF properties on the fly
                'options' => ['title' => 'Krajee Report Title'],
                 // call mPDF methods on the fly
                'methods' => [ 
                    'SetHeader'=>['PDF Header'], 
                    'SetFooter'=>['{PAGENO}'],
                ]
            ]);
         
            // return the pdf output as per the destination setting
            return $pdf->render();
    }

public function actionReport(){

$content = $this->renderPartial('_reportView');

// setup kartik\mpdf\Pdf component

$pdf = new Pdf([

// set to use core fonts only

'mode' => Pdf::MODE_CORE,

// A4 paper format

'format' => Pdf::FORMAT_A4,

// portrait orientation

'orientation' => Pdf::ORIENT_PORTRAIT,

// stream to browser inline

'destination' => Pdf::DEST_BROWSER,

// your html content input

'content' => $content,

// format content from your own css file if needed or use the

// enhanced bootstrap css built by Krajee for mPDF formatting

'cssFile' => '@vendor/kartik-v/yii2-mpdf/assets/kv-mpdf-bootstrap.min.css',

// any css to be embedded if required

'cssInline' => '.kv-heading-1{font-size:18px}',

// set mPDF properties on the fly

'options' => ['title' => 'Krajee Report Title'],

// call mPDF methods on the fly

'methods' => [

'SetHeader'=>['PDF Header'],

'SetFooter'=>['{PAGENO}'],

]

]);

// return the pdf output as per the destination setting

return $pdf->render();

}

Jangan lupa menambahkan

use kartik\mpdf\Pdf;

1	use kartik\mpdf\Pdf;

Langkah 3 : Menambahkan File View Pada contoh ini kita akan membuat Read more about Yii2 Tips 19 : Membuat Output View ke PDF[…]

indocoder.com

Tag: yii2 tips

Yii2 Tips 23 : All About Where ActiveQuery

Yii2 Tips 22 : Mengirim Email

Yii2 Tips 21 : Mengupload Multiple Files dengan FileInput Widget

Yii2 Tips 20 : Mengupload File Menggunakan Kartik FileInput Widget

Yii2 Tips 19 : Membuat Output View ke PDF