Yii2 Case Study (1) : Angular JS

Posted on January 26, 2018 by admin

This is an example how to combine Yii2 with AngularJS. We have one table, game. 1. Table Preparation Table game : Create model Game.php using Gii, put it in common\models folder.

<?php

namespace common\models;

use Yii;

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

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['console', 'name'], 'string', 'max' => 255],
            [['year'], 'string', 'max' => 11],
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'console' => Yii::t('app', 'Console'),
            'name' => Yii::t('app', 'Name'),
            'year' => Yii::t('app', 'Year'),
        ];
    }
}

<?php

namespace common\models;

use Yii;

/**

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

* @property integer $id

* @property string $console

* @property string $name

* @property string $year

class Game extends \yii\db\ActiveRecord

{

/**

* @inheritdoc

public static function tableName()

{

return 'game';

}

/**

* @inheritdoc

public function rules()

{

return [

[['console', 'name'], 'string', 'max' => 255],

[['year'], 'string', 'max' => 11],

];

}

/**

* @inheritdoc

public function attributeLabels()

{

return [

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

'console' => Yii::t('app', 'Console'),

'name' => Yii::t('app', 'Name'),

'year' => Yii::t('app', 'Year'),

];

}

2. Create GameController.php, index.php, app.js and Use AngularJS 1.6 create frontend/controllers/GameController.php

<?php

namespace frontend\controllers;
use Yii;
use yii\web\Controller;
use common\models\Game;

class GameController extends Controller{
	public function beforeAction($action){
		$this->enableCsrfValidation = false;
		return parent::beforeAction($action);
	}

	public function actionIndex(){
		return $this->render('index');
	}
}

<?php

namespace frontend\controllers;

use Yii;

use yii\web\Controller;

use common\models\Game;

class GameController extends Controller{

public function beforeAction($action){

$this->enableCsrfValidation = false;

return parent::beforeAction($action);

}

public function actionIndex(){

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

}

create frontend/views/game/index.php Use AngularJS 1.6, and put https://ajax.googleapis.com/ajax/libs/angularjs/1.6.7/angular.min.js inside this file.

<div ng-app="App" ng-controller="AppCtrl">
	<h4>{{6+4}}</h4>
</div>

<?php
	echo $this->registerJsFile("https://ajax.googleapis.com/ajax/libs/angularjs/1.6.7/angular.min.js");
	echo $this->registerJsFile("js/app.js");
?>

</div>

<?php

echo $this->registerJsFile("https://ajax.googleapis.com/ajax/libs/angularjs/1.6.7/angular.min.js");

echo $this->registerJsFile("js/app.js");

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>

indocoder.com

Month: January 2018

Yii2 Case Study (1) : Angular JS

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