Improve Your Coding Skills

Yii 2

The latest version of Yii 2 is 2.0.7, released on February 14, 2016. Yii 2.0 is a complete rewrite of Yii on top of PHP 5.4.0. It is aimed to become a state-of-the-art of the new generation of PHP framework. Yii 2.0 is not compatible with 1.1.

Yii2 Website.

http://www.yiiframework.com/download/#yii2

Yii2 Documentation.

http://www.yiiframework.com/doc-2.0/guide-index.html

Installing Yii

You can install Yii in two ways, using the Composer package manager or by downloading an archive file. The former is the preferred way, as it allows you to install new extensions or update Yii by simply running a single command.

Steps - Install from an Archive File

Yii 2 with advanced application template (Download one of the following archive files, and then extract it to a Web-accessible folder (eg /var/www/html).)
Yii Application Initialization. eg var/www/html/yii2.7# php init

Open your browser goto http://localhost/yii2.7/frontend/web/index.php

Get result is

Database Configuration

* Database configuration placed in the common/config directory of application folder.

/application/common/config/main_local.php

Example of set database configuration

'db' => [

'class' => 'yii\db\Connection',

'dsn' => 'mysql:host=localhost;dbname=students',

'username' => 'root',

'password' => 'root123',

'charset' => 'utf8',

More Details

http://www.yiiframework.com/doc-2.0/guide-start-databases.html

Migrate Database

yii basic working tables add to own database

This will create tables needed for the application to work.

Command for migration

php yii migrate

Video Installing the Advance Template in Yii

GETTING STARTED

After you install the application, you have to conduct the following steps to initialize

the installed application. You only need to do these once for all.

1. Run command `init` to initialize the application with a specific environment.

2. Create a new database and adjust the `components['db']` configuration in `common/config/main-local.php` accordingly.

3. Apply migrations with console command `yii migrate`. This will create tables needed for the application to work.

4. Set document roots of your Web server:

- for frontend `/path/to/yii-application/frontend/web/` and using the URL `http://frontend/`

- for backend `/path/to/yii-application/backend/web/` and using the URL `http://backend/`

To login into the application, you need to first sign up, with any of your email address, username and password.Then, you can login into the application with same email address and password at any time.

Generate report of table format.

Code placed on controller action

Objective of this report for generating month wise admission count each year.

$sql = $sql = "SELECT YEAR( date_of_join ) as eyear , MONTH( date_of_join ) as emonth , COUNT( `admission_number` ) as totalstudents FROM `students` WHERE YEAR( `date_of_join` ) BETWEEN 2013 AND 2015 GROUP BY YEAR( date_of_join ) , MONTH( date_of_join ) ORDER BY YEAR( date_of_join ) , MONTH( date_of_join ) ASC ";

$models = Students::findBySql($sql)->all();

Above this query generating result as


eyear	emonth	totalstudents
2013	1	195
2013	2	147
2013	3	171
2013	4	206
2013	5	303
2013	6	286
2013	7	186
2013	8	181
2013	9	231
2013	10	278
2013	11	398
2013	12	296
2014	1	179
2014	2	69
2014	3	117
2014	4	134
2014	5	235
2014	6	422
2014	7	212
2014	8	271
2014	9	378
2014	10	451
2014	11	339
2014	12	289
2015	1	188
2015	2	220
2015	3	198
2015	4	84
2015	5	165
2015	6	402

$model array represent the above result.

I want to expect result is

COMPARISON REPORT LOGICLAB DISTANCE EDUCATION
Year/Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
2013	195	147	171	206	303	286	186	181	231	278	398	296	2878
2014	179	69	117	134	235	422	212	271	378	451	339	289	3096
2015	188	220	198	84	165	402	265	174	2	1	0	1	1700
Total	562	436	486	424	703	1110	663	626	611	730	737	586	7674

Answer

One Solution

<?php

use yii\helpers\Html;

use yii\helpers\ArrayHelper;

$this->title = 'Comparison Report';

$this->params['breadcrumbs'][] = ['label' => 'Comparison Report Criteria', 'url' => ['studentreport/comparisonrpt']];

$this->params['breadcrumbs'][] = $this->title;

//set heading.

$caption = 'COMPARISON REPORT';

$caption .= '<BR>'.Yii::$app->params['center_name'];

$caption .= ' '.Yii::$app->params['center_caption'];

<tr style= "background-color: #F2F2F2"><td>Year/Month</td>

<td>Total</td> </tr>

<?php

//total colums print with show university

$dataList=ArrayHelper::map($model, 'eyear', 'eyaer');

foreach ($dataList as $key => $value) {

echo '<tr><td>'.$value.'</td>';

for($i=1;$i<=12;$i++){

echo '<td id='.$value.$i.'>0</td>';

}

echo '<td id='.$value.'>0</td></tr>'; //for print row toatal.

}

//bootam row.

echo '<tr style= "background-color: #4CAF50"><td>Total</td>';

for($i=1;$i<=12;$i++){

echo '<td id='.$i.'>0</td>';

}

echo '<td id="gtotal">0</td></tr>';

//1.isplay University counts, 2.row total, 3.column total, 4. Grand total.

foreach ($model as $key => $value) {

echo "<script> document.getElementById('".$value['eyear'].$value['emonth']."').innerHTML = ".$value['totalstudents']." </script>";

echo "<script> "

. "document.getElementById('".$value['eyar']."').innerHTML = parseInt(document.getElementById('".$value['eyear']."').innerHTML) + ". $value['totalstudents'].";"

. "document.getElementById('".$value['emonth']."').innerHTML = parseInt(document.getElementById('".$value['emonth']."').innerHTML) + ". $value['totalstudents'].";"

. "document.getElementById('gtotal').innerHTML = parseInt(document.getElementById('gtotal').innerHTML) + ". $value['totalstudents']

. "</script>";

}

</table>

</section>

Improve Your Coding Skills

Menus

Sunday, 6 March 2016

Installing Yii

Yii 2

Thursday, 10 December 2015

Array of database result to mannually display in table

Generate report of table format.