Thursday, 10 December 2015

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

<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>

Saturday, 24 October 2015

Yii2 Pjax Tutorial

What is AJAX?

AJAX = Asynchronous JavaScript and XML.

AJAX is a technique for creating fast and dynamic web pages.

AJAX allows web pages to be updated asynchronously by exchanging small amounts of data with the server behind the scenes. This means that it is possible to update parts of a web page, without reloading the whole page.

Classic web pages, (which do not use AJAX) must reload the entire page if the content should change.

Examples of applications using AJAX: Google Maps, Gmail, YouTube, and Facebook.

YII2 PJAX

pjax is a jQuery plugin that allows quick website navigation by combining ajax and pushState. It works by sending a special request to the server every time a link is clicked or a form is submitted. The server sends back the content that needs to be updated, pjax replaces old content with new content and pushes the new URL to browser history, without the need to update the whole page.

Regular requests download the whole page. Pjax can ask the server to send only the required part of the content.

Steps using pjax in yii2 framework

1 Add one line in the beginning of your view.

<?php
use yii\widgets\Pjax;
?>

2 Add two lines around the content that needs partial updating.

<?php Pjax::begin(); ?>
Content that needs to be updated
<?php Pjax::end(); ?>

Ajax Search With the GridView

Getting Values From a Table Using Ajax

Submitting Forms Using Ajax

Friday, 16 October 2015

Yii2 ListBox Field

ListBox Field

Using below we can create the list box base on model attribute of yii2.0 framework. We added the following options like prompt, size, disabled, style etc

public static string activeListBox ( $model, $attribute, $items, $options = [] )
$model	yii\base\Model	The model object
$attribute	string	The attribute name or expression. See getAttributeName() for the format about attribute expression.
$items	array	The option data items. The array keys are option values, and the array values are the corresponding option labels. The array can also be nested (i.e. some array values are arrays too). For each sub-array, an option group will be generated whose label is the key associated with the sub-array. If you have a list of data models, you may convert them into the format described above using yii\helpers\ArrayHelper::map(). Note, the values and labels will be automatically HTML-encoded by this method, and the blank spaces in the labels will also be HTML-encoded.
$options	array	The tag options in terms of name-value pairs. The following options are specially handled: prompt: string, a prompt text to be displayed as the first option; options: array, the attributes for the select option tags. The array keys must be valid option values, and the array values are the extra attributes for the corresponding option tags. For example, `[ 'value1' => ['disabled' => true], 'value2' => ['label' => 'value 2'], ];` groups: array, the attributes for the optgroup tags. The structure of this is similar to that of 'options', except that the array keys represent the optgroup labels specified in $items. unselect: string, the value that will be submitted when no option is selected. When this attribute is set, a hidden field will be generated so that if no option is selected in multiple mode, we can still obtain the posted unselect value. encodeSpaces: bool, whether to encode spaces in option prompt and option value with` ` character. Defaults to false. encode: bool, whether to encode option prompt and option value characters. Defaults to`true`. This option is available since 2.0.3. The rest of the options will be rendered as the attributes of the resulting tag. The values will be HTML-encoded using encode(). If a value is null, the corresponding attribute will not be rendered. See renderTagAttributes() for details on how attributes are being rendered.
return	string	The generated list box tag

Listbox with prompt text

<?= $form->field($model, 'population')-> listBox(
   array('1'=>'1',2=>'2',3=>3,4=>4,5=>5),
   array('prompt'=>'Select')
   ); ?>

Listbox with size

<?= $form->field($model, 'population')-> listBox(
   array('1'=>'1',2=>'2',3=>3,4=>4,5=>5),
   array('prompt'=>'Select','size'=>3)
   ); ?>

Listbox with disabled, style properties

<?= $form->field($model, 'population')-> listBox(
   array('1'=>'1',2=>'2',3=>3,4=>4,5=>5),
   array('disabled' => true,'style'=>'background:gray;color:#fff;'))
   ->label('Gender'); ?>

Setting default values in List box

<?php $model->offerCategory = ['monday', 'tuesday'] ?>
<?=$form->field($model, 'offerCategory')->listBox([
        'monday' => 'Monday',
        'tuesday' => 'Tuesday',
        'wednesday' => 'Wednesday',
        'thursday' => 'Thursday',
        'friday' => 'Friday',
        'saturday' => 'Saturday',
        'sunday' => 'Sunday'
        ],['multiple' => 'true',
    ]) ?>

//$mymodels = array of models doesnt work of course
$form->field($mymodels, 'post_types')->listBox($items);

data items call function from students modules

<?= echo $form->field($model, 'batch')->listBox(Students::getBatch(), [

'multiple' => true,

'size' => 7,])

->label(FALSE);

Example Yii2 listbox multi-select field

Create related function as getWeekdaysList in Appointment.php modules.

public static function getWeekdaysList()
        {
            return [
                'monday' => 'Monday',
                'tuesday' => 'Tuesday',
                'wednesday' => 'Wednesday',
                'thursday' => 'Thursday',
                'friday' => 'Friday',
                'saturday' => 'Saturday',
                'sunday' => 'Sunday',
            ];
        }

Then in my _form.php

<?= $form->field($model, 'weekdays')->listBox(app\models\Appointment::getWeekdaysList(), [
    'multiple' => true,
    'size' => 7,
]) ?>

Access values in controller action

public function actionFeepaidcontacts()
    {....
        ...
        if ($model->load(Yii::$app->request->post())){
                                                  //your code pasted here.
                echo $model->weekdays[0];            or
                
                foreach ($model->weekdays as $key => $value) {
                     echo $value;          //print selected weekdays
                }
                
        }
        ....
        ....    
     }

*Selected listbox items stored as form of one dimensional array.

Related links:

listBox() public method

Advanced Multi Select

PHP Programming Tips

INDEX
PHP - add item to beginning of associative array
PHP sizeof() Function
Split multiple lines and input them in separate row in a database
How to print a debug log
PHP prepend leading zero before single digit number
Show a number to 2 decimal places
Comparing Dates in PHP
Adding days to Date in PHP

PHP - add item to beginning of associative array

How can I add an item to the beginning of an associative array?

For example, say I have an array like this:

$arr = array('key1' => 'value1', 'key2' => 'value2');

Answers:

You could use the union operator:

$arr1 = array('key0' => 'value0') + $arr1;

One way is with array_merge:

<?php
$arr = array('key1' => 'value1', 'key2' => 'value2');
$arr = array_merge(array('key0' => 'value0'), $arr);  ?>

PHP sizeof() Function

The sizeof() function returns the number of elements in an array.

<?php
$cars=array("Volvo","BMW","Toyota");
echo sizeof($cars);
?>

Example

for($i=0;$i<sizeof($batch);$i++){
echo '<td>'. $batch[$i]['batch_name'].'</td>';
}

Split multiple lines and input them in separate row in a database

How to explode a multi-line string?

PHP explode() Function

Definition and Usage

The explode() function breaks a string into an array.

Syntax

explode(separator,string,limit)

Depending on your os a newline can be "\n", "\r\n" or "\r".

Give this a shot:

$strip=explode("<br>", nl2br($linkfield));

or maybe safer:

$strip=explode("\n", str_replace(array("\n", "\r\n"), "\n", $linkfield));

$address=explode("\n", str_replace(array("\n", "\r\n"), "\n", $student->present_address));
print_r($address);

Output

Array ( [0] => SHANEESH P [1] => OPP MUNICIPAL OFFICE [2] => MALAPPURAM [3] => KERALA [4] => INDIA )

<?php
$text = $_POST['userlist'];
$array = explode('\n', $text);
?>

How to print a debug log

file_put_contents('your_log_file', 'your_content');

error_log ('your_content', 3, 'your_log_file');

Example

file_put_contents('error_log', $userid);

Value stored to error_log file in your folder.

PHP prepend leading zero before single digit number

str_pad($number, 2, '0', STR_PAD_LEFT);

Add zero to before number.

<?pph

$m=1;

$p= str_pad($m, 3, '0', STR_PAD_LEFT);

echo $p;

Output : 001

show a number to 2 decimal places

You can use number_format():

return number_format((float)$number, 2, '.', '');

$padded = sprintf('%0.2f', $unpadded);

echo round(5.045, 2);

Comparing Dates in PHP

How to compare Dates in php

<?php

$exp_date = "2017-01-10";
$todays_date = date("Y-m-d");

$today = strtotime($todays_date);
$expiration_date = strtotime($exp_date);

if ($expiration_date > $today) {
echo "yes";
} else {
echo "no";
}

?>

Adding days to Date in PHP

<?php

$Date = date("Y-m-d"); // "2010-09-17";

echo date('Y-m-d', strtotime($Date. ' + 1 days'));

echo '<br>';

echo date('Y-m-d', strtotime($Date. ' + 360 days'));

Improve Your Coding Skills

Menus

Thursday, 10 December 2015

Array of database result to mannually display in table

Generate report of table format.

Saturday, 24 October 2015

Yii2 Pjax Tutorial

Yii2 Pjax Tutorial

What is AJAX?

Friday, 16 October 2015

Yii2 ListBox Field

ListBox Field

Setting default values in List box

Example Yii2 listbox multi-select field

PHP Programming Tips

PHP - add item to beginning of associative array

PHP sizeof() Function

Split multiple lines and input them in separate row in a database

How to explode a multi-line string?

PHP explode() Function

Definition and Usage

Syntax

How to print a debug log

PHP prepend leading zero before single digit number

show a number to 2 decimal places

Comparing Dates in PHP

How to compare Dates in php

Adding days to Date in PHP