Yii2 Tips 28 : Dependent Dropdown Without Extension

Posted on January 3, 2018 by admin

This tip will show you how to create dependent dropdown without using any extensions. 1. Create table country and table city. 2. Create models Country and City using gii. 3. Add actionDependentDropdown on your controller (i.e. TestController.php)

public function actionDependentDropdown(){
$model = new \common\models\City();

if($model->load(Yii::$app->request->post())){
    echo "<pre>";
    print_r($model);
    echo "</pre>";
    die();
}

return $this->render('dependent-dropdown',[
        'model'=>$model,
    ]);
}

public function actionDependentDropdown(){

$model = new \common\models\City();

if($model->load(Yii::$app->request->post())){

echo "<pre>";

print_r($model);

echo "</pre>";

die();

}

return $this->render('dependent-dropdown',[

'model'=>$model,

]);

}

4. Add the view file, dependent-dropdown.php inside the view folder, take note to the ‘onchange’ event when the Read more about Yii2 Tips 28 : Dependent Dropdown Without Extension[…]

Yii2 Tips 27 : Import Data from Excel

Posted on January 3, 2018 by admin

1. Install yii2 export

composer require --prefer-dist hscstudio/yii2-export "1.0.0"

1	composer require --prefer-dist hscstudio/yii2-export "1.0.0"

2. Excel file , i.e (take note on the baseRow and baseColumn) : 3. Create table and the model

<?php

namespace common\models;

use Yii;

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

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

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

<?php

namespace common\models;

use Yii;

/**

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

* @property integer $id

* @property string $title

* @property string $description

class Category extends \yii\db\ActiveRecord

{

/**

* @inheritdoc

public static function tableName()

{

return 'category';

}

/**

* @inheritdoc

public function rules()

{

return [

[['description'], 'string'],

[['title'], 'string', 'max' => 255],

];

}

/**

* @inheritdoc

public function attributeLabels()

{

return [

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

'title' => Yii::t('app', 'Title'),

'description' => Yii::t('app', 'Description'),

];

}

4. Put actionImport (or whatever the name is), to your controller

public function actionImport(){
        $modelImport = new \yii\base\DynamicModel([
                    'fileImport'=>'File Import',
                ]);
        $modelImport->addRule(['fileImport'],'required');
        $modelImport->addRule(['fileImport'],'file',['extensions'=>'ods,xls,xlsx'],['maxSize'=>1024*1024]);

        if(Yii::$app->request->post()){
            $modelImport->fileImport = \yii\web\UploadedFile::getInstance($modelImport,'fileImport');
            if($modelImport->fileImport && $modelImport->validate()){
                $inputFileType = \PHPExcel_IOFactory::identify($modelImport->fileImport->tempName);
                $objReader = \PHPExcel_IOFactory::createReader($inputFileType);
                $objPHPExcel = $objReader->load($modelImport->fileImport->tempName);
                $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
                $baseRow = 3;
                while(!empty($sheetData[$baseRow]['B'])){
                    $model = new \common\models\Category;
                    $model->title = (string)$sheetData[$baseRow]['B'];
                    $model->description = (string)$sheetData[$baseRow]['C'];
                    $model->save();
                    $baseRow++;
                }
                Yii::$app->getSession()->setFlash('success','Success');
            }else{
                Yii::$app->getSession()->setFlash('error','Error');
            }
        }

        return $this->render('import',[
                'modelImport' => $modelImport,
            ]);
    }

public function actionImport(){

$modelImport = new \yii\base\DynamicModel([

'fileImport'=>'File Import',

]);

$modelImport->addRule(['fileImport'],'required');

$modelImport->addRule(['fileImport'],'file',['extensions'=>'ods,xls,xlsx'],['maxSize'=>1024*1024]);

if(Yii::$app->request->post()){

$modelImport->fileImport = \yii\web\UploadedFile::getInstance($modelImport,'fileImport');

if($modelImport->fileImport && $modelImport->validate()){

$inputFileType = \PHPExcel_IOFactory::identify($modelImport->fileImport->tempName);

$objReader = \PHPExcel_IOFactory::createReader($inputFileType);

$objPHPExcel = $objReader->load($modelImport->fileImport->tempName);

$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

$baseRow = 3;

while(!empty($sheetData[$baseRow]['B'])){

$model = new \common\models\Category;

$model->title = (string)$sheetData[$baseRow]['B'];

$model->description = (string)$sheetData[$baseRow]['C'];

$model->save();

$baseRow++;

}

Yii::$app->getSession()->setFlash('success','Success');

}else{

Yii::$app->getSession()->setFlash('error','Error');

}

return $this->render('import',[

'modelImport' => $modelImport,

]);

}

5. Create import.php

<?php 
	use yii\widgets\ActiveForm;
	use yii\helpers\Html;
?>
<h1>Import Data</h1>
<?php $form = ActiveForm::begin(['options'=>['enctype'=>'multipart/form-data']]);?>

<?= $form->field($modelImport,'fileImport')->fileInput() ?>

<?= Html::submitButton('Import',['class'=>'btn btn-primary']);?>

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

<?php

use yii\widgets\ActiveForm;

use yii\helpers\Html;

<h1>Import Data</h1>

<?php $form = ActiveForm::begin(['options'=>['enctype'=>'multipart/form-data']]);?>

<?= $form->field($modelImport,'fileImport')->fileInput() ?>

<?= Html::submitButton('Import',['class'=>'btn btn-primary']);?>

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

Yii2 Tips 26 : All About Gridview

Posted on January 3, 2018 by admin

This is my personal notes on Gridview and their tips. First, I have gridview table with the following structure and content : Next step is to create the GridviewModel model and the CRUD using Gii. A. Gridview Tips : Dropdown Search using Kartik Gridview The end result will be like this, there is dropdown list Read more about Yii2 Tips 26 : All About Gridview[…]

Yii2 Tips 25 : All About Form Validation

Posted on January 3, 2018 by admin

Model

<?php
namespace common\models;

use Yii;
use yii\base\Model;

class ValidationForm extends \backend\models\Branches
{
    public $email;
    public $url;
    public $boolean;
    public $boolean2;
    public $password;
    public $password_repeat;
    public $compare;
    public $integer;
    public $inrange;

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['email'],'email'],
            [['url'],'url'],
            [['boolean'],'boolean'],
            [['boolean2'],'boolean','trueValue'=>'male','falseValue'=>'female'],
            [['password_repeat'],'compare','compareAttribute'=>'password'],
            [['compare'],'compare','compareValue' => 30, 'operator' => '>='],
            [['integer'],'integer','min' => 10, 'max'=>20],
            [['inrange'],'in','range'=>['one','two','three'],'not'=>false],
        ];
    }

    public function attributeLabels()
    {
        return [
            'email' => Yii::t('app', 'Email'),
        ];
    }
}

<?php

namespace common\models;

use Yii;

use yii\base\Model;

class ValidationForm extends \backend\models\Branches

{

public $email;

public $url;

public $boolean;

public $boolean2;

public $password;

public $password_repeat;

public $compare;

public $integer;

public $inrange;

/**

* @inheritdoc

public function rules()

{

return [

[['email'],'email'],

[['url'],'url'],

[['boolean'],'boolean'],

[['boolean2'],'boolean','trueValue'=>'male','falseValue'=>'female'],

[['password_repeat'],'compare','compareAttribute'=>'password'],

[['compare'],'compare','compareValue' => 30, 'operator' => '>='],

[['integer'],'integer','min' => 10, 'max'=>20],

[['inrange'],'in','range'=>['one','two','three'],'not'=>false],

];

}

public function attributeLabels()

{

return [

'email' => Yii::t('app', 'Email'),

];

}

Controller

<?php
namespace frontend\controllers;

use Yii;

class ValidationController extends \yii\web\Controller
{
    public function actionIndex(){
        return $this->render('index');
    }

    public function actionValidate(){

        $model = new \common\models\ValidationForm();

        if($model->load(Yii::$app->request->post())){
            echo "<pre>";
            print_r($model);
            echo "</pre>";
            die();
        }

        return $this->render('_form',[
                'model' => $model,
            ]);
    }

}

<?php

namespace frontend\controllers;

use Yii;

class ValidationController extends \yii\web\Controller

{

public function actionIndex(){

return $this->render('index');

}

public function actionValidate(){

$model = new \common\models\ValidationForm();

if($model->load(Yii::$app->request->post())){

echo "<pre>";

print_r($model);

echo "</pre>";

die();

}

return $this->render('_form',[

'model' => $model,

]);

}

View

<?php

use yii\widgets\ActiveForm;
use yii\helpers\Html;

?>

<div class="dummy-form">

    <?php $form = ActiveForm::begin(); ?>

    <?= $form->field($model,'email')->textInput();?>

    <?= $form->field($model,'url')->textInput();?>

    <?= $form->field($model,'boolean')->textInput();?>

    <?= $form->field($model,'boolean2')->textInput();?>

    <?= $form->field($model,'password')->textInput();?>

    <?= $form->field($model,'password_repeat')->textInput();?>

    <?= $form->field($model,'compare')->textInput();?>

    <?= $form->field($model,'integer')->textInput();?>

    <?= $form->field($model,'inrange')->textInput();?>

    <div class="form-group">
        <?= Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>
    </div>

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

</div>

<?php

use yii\widgets\ActiveForm;

use yii\helpers\Html;

<?php $form = ActiveForm::begin(); ?>

<?= $form->field($model,'email')->textInput();?>

<?= $form->field($model,'url')->textInput();?>

<?= $form->field($model,'boolean')->textInput();?>

<?= $form->field($model,'boolean2')->textInput();?>

<?= $form->field($model,'password')->textInput();?>

<?= $form->field($model,'password_repeat')->textInput();?>

<?= $form->field($model,'compare')->textInput();?>

<?= $form->field($model,'integer')->textInput();?>

<?= $form->field($model,'inrange')->textInput();?>

<?= Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>

</div>

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

</div>

Yii2 Tips 24 : All About ActiveForm

Posted on January 3, 2018 by admin

Model

<?php
namespace common\models;

use Yii;
use yii\base\Model;

class DummyForm extends \backend\models\Branches
{
    public $textInput;
    public $textInputPlaceholderNolabel;
    public $textFieldWithHint;
    public $disabledTextInput;
    public $readOnlyTextInput;
    public $autoFocusTextInput;
    public $select2DropDown;
    public $dropDownList;
    public $select2DropDownMultiple;
    public $radioList;
    public $checkBox;
    public $dateTimePicker;
    public $datePicker;


    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            // username and password are both required
            [['checkBox','dateTimePicker','datePicker'],'safe'],
            [['textInput'], 'required'],
            [['autoFocusTextInput','disabledTextInput','readOnlyTextInput'], 'string', 'max' => 100],
            [['radioList','select2DropDownMultiple','select2DropDown','dropDownList'],'integer'],
        ];
    }

    public function attributeLabels()
    {
        return [
            'textInput' => Yii::t('app', 'Text Input with Initial Value'),
            'textFieldWithHint' => Yii::t('app','Text Input with Hint'),
            'textInputPlaceholderNolabel' => Yii::t('app','Text Input With Placeholder and Without Label'),
            'disabledTextInput' => Yii::t('app','Disabled Text Input'),
            'readOnlyTextInput' => Yii::t('app', 'Read Only Text Input with Initial Value'),
            'autoFocusTextInput' => Yii::t('app','Auto Focus Text Input'),
            'select2DropDown' => Yii::t('app','Dropdown Select2 Widget'),
            'dropDownList' => Yii::t('app','Drop Down List'),
            'select2DropDownMultiple' => Yii::t('app', 'Select2 with Multiple Select'),
            'radioList' => Yii::t('app','Radio Button'),
            'checkBox' => Yii::t('app','Check Box List with Label and Pre Checked'),
            'dateTimePicker' => Yii::t('app','Date Time Picker'),
            'datePicker' => Yii::t('app','Date Picker'),
        ];
    }
}

<?php

namespace common\models;

use Yii;

use yii\base\Model;

class DummyForm extends \backend\models\Branches

{

public $textInput;

public $textInputPlaceholderNolabel;

public $textFieldWithHint;

public $disabledTextInput;

public $readOnlyTextInput;

public $autoFocusTextInput;

public $select2DropDown;

public $dropDownList;

public $select2DropDownMultiple;

public $radioList;

public $checkBox;

public $dateTimePicker;

public $datePicker;

/**

* @inheritdoc

public function rules()

{

return [

// username and password are both required

[['checkBox','dateTimePicker','datePicker'],'safe'],

[['textInput'], 'required'],

[['autoFocusTextInput','disabledTextInput','readOnlyTextInput'], 'string', 'max' => 100],

[['radioList','select2DropDownMultiple','select2DropDown','dropDownList'],'integer'],

];

}

public function attributeLabels()

{

return [

'textInput' => Yii::t('app', 'Text Input with Initial Value'),

'textFieldWithHint' => Yii::t('app','Text Input with Hint'),

'textInputPlaceholderNolabel' => Yii::t('app','Text Input With Placeholder and Without Label'),

'disabledTextInput' => Yii::t('app','Disabled Text Input'),

'readOnlyTextInput' => Yii::t('app', 'Read Only Text Input with Initial Value'),

'autoFocusTextInput' => Yii::t('app','Auto Focus Text Input'),

'select2DropDown' => Yii::t('app','Dropdown Select2 Widget'),

'dropDownList' => Yii::t('app','Drop Down List'),

'select2DropDownMultiple' => Yii::t('app', 'Select2 with Multiple Select'),

'radioList' => Yii::t('app','Radio Button'),

'checkBox' => Yii::t('app','Check Box List with Label and Pre Checked'),

'dateTimePicker' => Yii::t('app','Date Time Picker'),

'datePicker' => Yii::t('app','Date Picker'),

];

}

Controller

<?php
namespace frontend\controllers;

use Yii;

class TestController extends \yii\web\Controller
{
    public function actionIndex(){
        return $this->render('index');
    }

    public function actionForm(){

        $model = new \common\models\DummyForm();

        $countries = [
            '1' => 'Indonesia',
            '2' => 'Malaysia',
            '3' => 'Thailand', 
            '4' => 'Singapore',
        ];

        $gender = [
            '1' => 'Male',
            '2' => 'Female',
        ];

        if($model->load(Yii::$app->request->post())){
            echo "<pre>";
            print_r($model);
            echo "</pre>";
            die();
        }

        return $this->render('_form',[
                'model' => $model,
                'countries' => $countries,
                'gender' => $gender,
            ]);
    }

}

<?php

namespace frontend\controllers;

use Yii;

class TestController extends \yii\web\Controller

{

public function actionIndex(){

return $this->render('index');

}

public function actionForm(){

$model = new \common\models\DummyForm();

$countries = [

'1' => 'Indonesia',

'2' => 'Malaysia',

'3' => 'Thailand',

'4' => 'Singapore',

];

$gender = [

'1' => 'Male',

'2' => 'Female',

];

if($model->load(Yii::$app->request->post())){

echo "<pre>";

print_r($model);

echo "</pre>";

die();

}

return $this->render('_form',[

'model' => $model,

'countries' => $countries,

'gender' => $gender,

]);

}

View Form

<?php

use yii\widgets\ActiveForm;
use yii\helpers\Html;
use kartik\select2\Select2;
use kartik\datetime\DateTimePicker;
use kartik\date\DatePicker;

$this->registerCss("
        .hint-block{
            color:red;
        }
    ");

?>

<div class="dummy-form">

    <?php $form = ActiveForm::begin(); ?>

    <?= $form->field($model,'textInput')->textInput()->input('textInput',['value' => 'Initial Value']); ?>

    <hr>

    <?= $form->field($model, 'disabledTextInput')->textInput()->input('disabledTextInput',
                    ['disabled' => true,   
                    ]) ?>

    <hr>

    <?= $form->field($model, 'readOnlyTextInput')->textInput()->input('readOnlyTextInput',
                    ['readOnly' => true,   
                    'value' => 'Initial Value',
                    ]) ?>

    <hr>

    <?= $form->field($model, 'autoFocusTextInput')->textInput()->input('autoFocusTextInput',
                    ['autoFocus' => true,   
                    ]) ?>

    <hr>

    <?= $form->field($model, 'textInputPlaceholderNolabel')->textInput()->input('textInputPlaceholderNolabel',
                    ['placeholder' => 'Text Input With Placeholder and Without Label',   
                    ])
                    ->label(false) ?>

    <hr>

    <?= $form->field($model, 'textFieldWithHint')->textInput()->hint('*) Ini adalah text input dengan hint') ?>

    <hr>

    <?= $form->field($model, 'dropDownList')->dropDownList([ 'Inactive', 'Active', ], ['prompt' => 'Select Status']) ?>

    <hr>

    <?= $form->field($model,'select2DropDown')->widget(Select2::classname(),[
                'data' => $countries,
                'language' => 'en',
                'options' => ['placeholder' => 'Select Country'],
                'pluginOptions' => ['allowClear' => true],
        ]);
    ?>

    <hr>

    <?= $form->field($model,'select2DropDownMultiple')->widget(Select2::classname(),[
                'data' => $countries,
                'language' => 'en',
                'options' => ['placeholder' => 'Select Countries','multiple' => true],
                'pluginOptions' => ['allowClear' => true],
        ]);
    ?>

    <hr>

    <?php $model->radioList = '2';?>
    <?= $form->field($model, 'radioList')->checkboxList($gender,
            ['item' => function ($index, $label, $name, $checked, $value){
            return '<label class="radio-inline">' . Html::radio($name, $checked, ['value' => $value]) . $label . '</label>';}])
            ->label('<em>Radio List with Label and PreChecked</em>');           
    ?>

    <hr>

    <?php $model->checkBox = [1,2];?>
    <?= $form->field($model, 'checkBox')->checkboxList($countries)?>


    <hr>

    <?=DateTimePicker::widget([
    'model' => $model,
    'attribute' => 'dateTimePicker',
    'options' => ['placeholder' => 'Kartik DateTimePicker'],
    'pluginOptions' => [
        'format' => 'yyyy-mm-dd hh:ii:ss',
        'autoclose' => true,
        'todayHighlight' => true
    ]
    ]); ?>

    <hr>

    <?=$form->field($model, 'datePicker')->label(false)->widget(DatePicker::className(),[
        'model' => $model, 
        'attribute'=>'datePicker',
        'options' => ['placeholder' => 'Kartik DatePicker'],
        'pluginOptions' => [
            'format' => 'yyyy-mm-dd',
            'autoclose' => true,
            'todayHighlight' => true,
        ]     
    ]); ?>

    <div class="form-group">
        <?= Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>
    </div>

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

</div>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

<?php

use yii\widgets\ActiveForm;

use yii\helpers\Html;

use kartik\select2\Select2;

use kartik\datetime\DateTimePicker;

use kartik\date\DatePicker;

$this->registerCss("

.hint-block{

color:red;

}

");

<?php $form = ActiveForm::begin(); ?>

<?= $form->field($model,'textInput')->textInput()->input('textInput',['value' => 'Initial Value']); ?>

<hr>

<?= $form->field($model, 'disabledTextInput')->textInput()->input('disabledTextInput',

['disabled' => true,

]) ?>

<hr>

<?= $form->field($model, 'readOnlyTextInput')->textInput()->input('readOnlyTextInput',

['readOnly' => true,

'value' => 'Initial Value',

]) ?>

<hr>

<?= $form->field($model, 'autoFocusTextInput')->textInput()->input('autoFocusTextInput',

['autoFocus' => true,

]) ?>

<hr>

<?= $form->field($model, 'textInputPlaceholderNolabel')->textInput()->input('textInputPlaceholderNolabel',

['placeholder' => 'Text Input With Placeholder and Without Label',

])

->label(false) ?>

<hr>

<?= $form->field($model, 'textFieldWithHint')->textInput()->hint('*) Ini adalah text input dengan hint') ?>

<hr>

<?= $form->field($model, 'dropDownList')->dropDownList([ 'Inactive', 'Active', ], ['prompt' => 'Select Status']) ?>

<hr>

<?= $form->field($model,'select2DropDown')->widget(Select2::classname(),[

'data' => $countries,

'language' => 'en',

'options' => ['placeholder' => 'Select Country'],

'pluginOptions' => ['allowClear' => true],

]);

<hr>

<?= $form->field($model,'select2DropDownMultiple')->widget(Select2::classname(),[

'data' => $countries,

'language' => 'en',

'options' => ['placeholder' => 'Select Countries','multiple' => true],

'pluginOptions' => ['allowClear' => true],

]);

<hr>

<?php $model->radioList = '2';?>

<?= $form->field($model, 'radioList')->checkboxList($gender,

['item' => function ($index, $label, $name, $checked, $value){

return '<label class="radio-inline">' . Html::radio($name, $checked, ['value' => $value]) . $label . '</label>';}])

->label('<em>Radio List with Label and PreChecked</em>');

<hr>

<?php $model->checkBox = [1,2];?>

<?= $form->field($model, 'checkBox')->checkboxList($countries)?>

<hr>

<?=DateTimePicker::widget([

'model' => $model,

'attribute' => 'dateTimePicker',

'options' => ['placeholder' => 'Kartik DateTimePicker'],

'pluginOptions' => [

'format' => 'yyyy-mm-dd hh:ii:ss',

'autoclose' => true,

'todayHighlight' => true

]

]); ?>

<hr>

<?=$form->field($model, 'datePicker')->label(false)->widget(DatePicker::className(),[

'model' => $model,

'attribute'=>'datePicker',

'options' => ['placeholder' => 'Kartik DatePicker'],

'pluginOptions' => [

'format' => 'yyyy-mm-dd',

'autoclose' => true,

'todayHighlight' => true,

]

]); ?>

<?= Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>

</div>

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

</div>

indocoder.com

Tag: yii2 tips

Yii2 Tips 28 : Dependent Dropdown Without Extension

Yii2 Tips 27 : Import Data from Excel

Yii2 Tips 26 : All About Gridview

Yii2 Tips 25 : All About Form Validation

Yii2 Tips 24 : All About ActiveForm