[Yii2 Framework] Export GridView dengan ext yii2-export

Tambahkan pada require di composer.json
"require": { "kartik-v/yii2-export": "*", "kartik-v/yii2-grid": "@dev", "kartik-v/yii2-mpdf": "*" },
lalu gunakan cmd masukke direktori tempat composer.json berada dan jalankan perintah:
composer update --prefer-dist
tambahkan modules gridview pada config/main.php
'modules' => [ 'gridview' => [ 'class' => '\kartik\grid\Module' // enter optional module parameters below - only if you need to // use your own export download action or custom translation // message source // 'downloadAction' => 'gridview/export/download', // 'i18n' => [] ] ],
buka index.php dan tambahkan script berikut, dan edit sesuai kebutuhan
<?php $gridColumns = [ 'nis', 'nama', 'alamat', [ 'attribute' => 'agama', 'value' => 'agama.nama' ], // 'agama_id', [ 'attribute' => 'jenisKelamin', 'value' => 'jenisKelamin.nama' ], // 'jenis_kelamin_id', ]; // Renders a export dropdown menu echo ExportMenu::widget([ 'dataProvider' => $dataProvider, 'columns' => $gridColumns ]); ?>

Posted in: Yii2

[Yii2 Framework] BlameableBehavior dan TimestampBehavior

tambah kolom pada tabel
            create_by tipe data INT
            update_by tipe data INT
            create_at tipe data DATETIME
            update_at tipedata DATETIME
tambah fungsi beahavior pada model siswa.php

<?php namespace frontend\models; use yii\behaviors\BlameableBehavior; use yii\behaviors\TimestampBehavior; class Siswa extends \yii\db\ActiveRecord { public function behaviors() { return [ [ 'class' => BlameableBehavior::className(), 'createdByAttribute' => 'create_by', 'updatedByAttribute' => 'update_by', ], [ 'class' => TimestampBehavior::className(), 'createdAtAttribute' => 'create_at', 'updatedAtAttribute' => 'update_at', 'value' => new Expression('NOW()'), ], ]; } public function attributeLabels() { return [ 'id' => 'ID', 'nis' => 'Nis', 'nama' => 'Nama', 'alamat' => 'Alamat', 'agama_id' => 'Agama', 'jenis_kelamin_id' => 'Jenis Kelamin', 'create_by' => 'Create By', 'update_by' => 'Update By', 'create_at' => 'Create At', 'update_at' => 'Update At' ]; } }

untuk edit tampilan di view klik disini

Posted in: Yii2

[Yii2 Framework] menampilkan tabel yang tidak berrelasi pada DetailView

edit view.php
<?= DetailView::widget([ 'model' => $model, 'attributes' => [ 'nis', 'nama', 'alamat', 'agama_id' => 'agama.nama', 'jenis_kelamin_id' => 'jenisKelamin.nama', //Jenis keal [ 'attribute' => 'create_by', 'value' => $model ->usercreate->username, 'label' => 'Create By' ], [ 'attribute' => 'update_by', 'value' => $model ->userupdate->username, 'label' => 'Update By' ], 'create_at', 'update_at' ], ]) ?>

sekarang kita buat fungsi relasi pada Siswa.php
class Siswa extends \yii\db\ActiveRecord { //.....................other function public function getUsercreate() { return $this->hasOne(User::className(), ['id' => 'create_by']); } public function getUserupdate() { return $this->hasOne(User::className(), ['id' => 'update_by']); } }

Posted in: Yii2

[Yii2 Framwork] Membuat Dropdown list pada form

Tambahkan scrip pada _form.php dan edit sesuai kebutuhan

1 2 3 4 5 6 7 8 9 10 11 12 13

<?= $form->field($model, 'companies_company_id')->dropDownList(      ArrayHelper::map(Companies::find()->all(),'company_id','company_name'),      [             'prompt'=>'Select Company',         ]     ); ?>       <?= $form->field($model, 'branches_branch_id')->dropDownList(      ArrayHelper::map(Branches::find()->all(),'branch_id','branch_name'),      [             'prompt'=>'Select Branch',         ]     ) ?>

Posted in: Yii2

[YII2 Framwork] Menampilkan, mengurutkan dan memfilter Model yang ber-Relasi Pada GridView

menggunakan model "Tour":

/**
 * @return \yii\db\ActiveQuery
 */
public function getCountry()
{
    return $this->hasOne(Country::className(), ['id' => 'country_id']);
}
 
/**
 * @return \yii\db\ActiveQuery
 */
public function getCity()
{
    return $this->hasOne(City::className(), ['id' => 'city_id']);
}

menambahkan nama country dan nama city pada GridView. didalam model  "TourSearch" :

class TourSearch extends Tour // extends from Tour see?
{
    // add the public attributes that will be used to store the data to be search
    public $city;
    public $country;
 
    // now set the rules to make those attributes safe
    public function rules()
    {
        return [
            // ... more stuff here
            [['city', 'country'], 'safe'],
            // ... more stuff here
        ];
    }
// ... model continues here

set pada gridview

// ... more grid configuration here
 'columns' => [
 // ... more columns configuration here
 [
 'attribute' => 'city',
 'value' => 'city.name'
 ],
 [
 'attribute' => 'country',
 'value' => 'country.name'
 ],
 // ... more stuff here

sekarang kita fokus pada fungction "search" pada "TourSearch"

public function search($params)
{
    // create ActiveQuery
    $query = Tour::find();
    // Important: lets join the query with our previously mentioned relations
    // I do not make any other configuration like aliases or whatever, feel free
    // to investigate that your self
    $query->joinWith(['city', 'country']);
 
    $dataProvider = new ActiveDataProvider([
        'query' => $query,
    ]);
 
    // Important: here is how we set up the sorting
    // The key is the attribute name on our "TourSearch" instance
    $dataProvider->sort->attributes['city'] = [
        // The tables are the ones our relation are configured to
        // in my case they are prefixed with "tbl_"
        'asc' => ['tbl_city.name' => SORT_ASC],
        'desc' => ['tbl_city.name' => SORT_DESC],
    ];
    // Lets do the same with country now
    $dataProvider->sort->attributes['country'] = [
        'asc' => ['tbl_country.name' => SORT_ASC],
        'desc' => ['tbl_country.name' => SORT_DESC],
    ];
    // No search? Then return data Provider
    if (!($this->load($params) && $this->validate())) {
        return $dataProvider;
    }
    // We have to do some search... Lets do some magic
    $query->andFilterWhere([
        //... other searched attributes here
    ])
    // Here we search the attributes of our relations using our previously configured
    // ones in "TourSearch"
    ->andFilterWhere(['like', 'tbl_city.name', $this->city])
    ->andFilterWhere(['like', 'tbl_country.name', $this->country]);
 
    return $dataProvider;
}

semoga bermanfaat, :)
sumber: http://www.yiiframework.com/wiki/653/displaying-sorting-and-filtering-model-relations-on-a-gridview/

Posted in: Yii2