Array of database result to mannually display in table

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'];

?>

          

<!-- Main content -->

<section class="invoice">

            

     <table  class="table" >           

                <tr style= "background-color: #bfcfd2" ><td colspan="14"><b><?=$caption?></b></td></tr>                    

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

                        <td>Jan</td>

                        <td>Feb</td>

                        <td>Mar</td>

                        <td>Apr</td>

                        <td>May</td>

                        <td>Jun</td>

                        <td>Jul</td>

                        <td>Aug</td>

                        <td>Sep</td>

                        <td>Oct</td>

                        <td>Nov</td>

                        <td>Dec</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>