Yii Grid View Custom Action Link

             [
        'class' => 'yii\grid\ActionColumn',
        'template' => '{view} {update} {delete}',
        'buttons' => [
                'view' => function ($url,$model) {
                        return Html::a(
                                '<span class="btn btn-success btn-rounded btn-xs">View</span>',
                                $url);
                },
                'update' => function ($url,$model,$key) {
                                return Html::a('<span class="btn btn-primary btn-rounded btn-xs">Edit</span>', $url);
                },
                          'delete' => function ($url,$model,$key) {
                                return Html::a('<span class="btn btn-danger btn-rounded btn-xs">Delete</span>', $url, [ 'data' => [
                'confirm' => "Are you sure you want to delete profile?",
                'method' => 'post',
            ],]);
                },
        ],
],

Allow Access to Specific User role in controller in Yii Framework

Set On Coltroller   


 public function behaviors()
    {
        return [
            'verbs' => [
                'class' => VerbFilter::className(),
                'actions' => [
                    'delete' => ['POST'],
                ],
            ],     'access' => [
                        'class' => \yii\filters\AccessControl::className(),
                        'only' => ['index','create','update','view'],
                        'rules' => [
                            // allow authenticated users
                            [
                                'allow' => true,
                                'roles' => ['@'],
                                'matchCallback' => function ($rule, $action) {
                            if (Yii::$app->user->identity->role==1) {
                                return true;
                            }
                            return false;
                                }
                            ],
                            // everything else is denied
                        ],
                    ],
        ];
    }

Server Side datatable in Yii Framework

Step 1  view set helper

use yii\helpers\Html;
use yii\helpers\Url;

Step 2 Table design in view 

   <table id="dtofficer" class="table table-striped table-bordered" width="100%" cellspacing="0">
   
        <thead>
            <tr>
                <th>Sr. No.</th>
                <th> Employee Name</th>
                <th> Employee Salary</th>
                <th> Employee Age</th>
           
                <th>Action</th>
            </tr>
        </thead>
 
        <tfoot>
           
    </table>

Step 3 Call Script in view

<?php

$this->registerCssFile(Yii::$app->urlManager->baseUrl . '/css/dk/dataTables.bootstrap.css');
$this->registerJsFile(Yii::$app->urlManager->baseUrl . '/css/dk/jquery.dataTables.min.js', ['depends' => [\yii\web\JqueryAsset::className()]]);
$this->registerJsFile(Yii::$app->urlManager->baseUrl . '/css/dk/dataTables.bootstrap.min.js', ['depends' => [\yii\web\JqueryAsset::className()]]);
$this->registerJsFile(Yii::$app->urlManager->baseUrl . '/css/dk/datatables.responsive.js', ['depends' => [\yii\web\JqueryAsset::className()]]);
$this->registerJsFile(Yii::$app->urlManager->baseUrl . '/css/dk/fnReloadAjax.js', ['depends' => [\yii\web\JqueryAsset::className()]]);
$urlOne = Url::to(['site/officerdata']);
$script = <<< JS
    $(document).ready(function() {
       
        var dataTable = $('#dtofficer').DataTable({
        "processing": true,
        "serverSide": true,
       
        "ajax": {
            url: "$urlOne",
            type: "post",
            error: function()
            {
               alert('error');
            }
         
        }
    });
       
        $('#dtofficer tbody').on( 'click', '.selrow', function () {
            $("#fmfirereport-fire_detail_id").val($(this).text());
            });
    });
JS;
$this->registerJs($script);
?>

Step -4 Controller

public function actionOfficerdata() {

        

        $requestData = $_REQUEST;

        

        $columns = array(

            0 => 'id',

            1 => 'employee_name',

            2 => 'employee_salary',

            3 => 'employee_age'

             );

        

       $sql = "SELECT  * from employee where 1=1";

       

        $data = Yii::$app->db->createCommand($sql)->queryAll();

        

        $totalData = count($data);

        $totalFiltered = $totalData;

     

        // $sql.="WHERE 1=1";

        

        if (!empty($requestData['search']['value']))

        {

            $sql.=" AND ( employee_name LIKE '" . $requestData['search']['value'] . "%' ";

            $sql.=" OR employee_salary LIKE '" . $requestData['search']['value'] . "%'";

            $sql.=" OR employee_age LIKE '" . $requestData['search']['value'] . "%')";

          

        }

        $data = Yii::$app->db->createCommand($sql)->queryAll();

        $totalFiltered = count($data);

       

        $sql.=" ORDER BY " . $columns[$requestData['order'][0]['column']] . "   " . $requestData['order'][0]['dir'] . "  LIMIT " . $requestData['start'] . " ," . 

        $requestData['length'] . "   ";

       

        $result = Yii::$app->db->createCommand($sql)->queryAll();

       

        $data = array();

        $i=1;

        

        foreach ($result as $key => $row)

        {

          

            $nestedData = array();

            $url = Url::to(['employee/update', 'id' => $row['id']]);

            $nestedData[] = $i;

            $nestedData[] = $row["employee_name"];

            $nestedData[] = $row["employee_salary"];

            $nestedData[] = $row["employee_age"];

            $nestedData[] = '<a href="'.$url.'"><span class="glyphicon glyphicon-pencil"></span></a>';

             $data[] = $nestedData;

             $i++;

        }

        

        $json_data = array(

            "draw" => intval($requestData['draw']), 

            "recordsTotal" => intval($totalData),

            "recordsFiltered" => intval($totalFiltered),

            "data" => $data   // total data array

        );

        echo json_encode($json_data);

    }

Yii2 Create Dropdown select options with custom Query

         $gisv = Yii::$app->db->createCommand("SELECT u.id as id, CONCAT_WS(' ',dep.dep_name,des.des_name, name) as name FROM `user` as u inner join mst_department dep on dep.d_id=u.department_id inner join mst_designation des on des.ds_id=u.designation_id  where u.role=3");
                                   
  $geb = $gisv->queryAll();
                                 
    $keuzeData = ArrayHelper::map($geb, 'id', 'name');
                       
              echo $form->field($model, 'employee_id')->dropDownList($keuzeData, ['prompt' => '--Select Employee--'])->label(false);
                                       

Export Excel using sql query

$select = $_REQUEST['sql'];

mysql_query('SET NAMES utf8;');
$export = mysql_query($select);
//$fields = mysql_num_rows($export); // thanks to Eric
$fields = mysql_num_fields($export); // by KAOSFORGE
//$report_title='<Row><Cell ss:StyleID="2"><Data ss:Type="String">dileep</Data></Cell><Row>';
$col_title='';
$data ='';
for ($i = 0; $i < $fields; $i++) {
    $col_title .= '<Cell ss:StyleID="2"><Data ss:Type="String">'.mysql_field_name($export, $i).'</Data></Cell>';
}

$col_title = '<Row>'.$col_title.'</Row>';

while($row = mysql_fetch_row($export)) {
    $line = '';
    foreach($row as $value) {
        if ((!isset($value)) OR ($value == "")) {
            $value = '<Cell ss:StyleID="1"><Data ss:Type="String"></Data></Cell>\t';
        } else {
            $value = str_replace('"', '', $value);
            $value = '<Cell ss:StyleID="1"><Data ss:Type="String">' . $value . '</Data></Cell>\t';
        }
        $line .= $value;
    }
    $data .= trim("<Row>".$line."</Row>")."\n";
}

$data = str_replace("\r","",$data);
date_default_timezone_set('Asia/Kolkata');
header("Content-Type: application/vnd.ms-excel;");
header("Content-Disposition: attachment; filename=export_".date('d-m-Y H:i:s').".xls");
header("Pragma: no-cache");
header("Expires: 0");

$xls_header = '<?xml version="1.0" encoding="utf-8"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author></Author>
<LastAuthor></LastAuthor>
<Company></Company>
</DocumentProperties>
<Styles>
<Style ss:ID="1">
<Alignment ss:Horizontal="Left"/>
</Style>
<Style ss:ID="2">
<Alignment ss:Horizontal="Left"/>
<Font ss:Bold="1"/>
</Style>

</Styles>
<Worksheet ss:Name="Export">
<Table>';

$xls_footer = '</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Selected/>
<FreezePanes/>
<FrozenNoSplit/>
<SplitHorizontal>1</SplitHorizontal>
<TopRowBottomPane>1</TopRowBottomPane>
</WorksheetOptions>
</Worksheet>
</Workbook>';

print $xls_header.$col_title.$data.$xls_footer;
exit;

Dynamic Box with JQuery

<script src="jquery-1.10.2.min.js" type="text/javascript" /></script>
<script>
$(document).ready(function(){
$(".addCF").click(function(){
$("#customFields").append('<tr valign="top"><td><select class="select" name="select[]"><option value="">-select-</option><option value="a">a</option><option value="b">b</option><option value="c">c</option></select> &nbsp; <input type="text" class="selval" name="selval[]" readonly /> &nbsp; <a href="javascript:void(0);" class="remCF">Remove</a></td></tr>');
});
$("#customFields").on('click','.remCF',function(){
$(this).parent().parent().remove();
});

});

$(document).on('change','.select',function() {
var selval = $(this).val();
$(this).parent('td').find('.selval').val(selval);
//alert(selval);
});
</script>



    <table class="form-table" id="customFields">
<tr valign="top">

<td>
<select class="select" name="select[]">
    <option value="">-select-</option><option value="a">a</option><option value="b">b</option><option value="c">c</option></select> &nbsp; <input type="text" class="selval" name="selval[]" readonly /> &nbsp;
<a href="javascript:void(0);" class="addCF">Add</a>
</td>
</tr>
</table>

Yii CRUD Generator

This generator generates a controller and views that implement CRUD (Create, Read, Update, Delete) operations for the specified data model.

Model Class-      app\models\TahsileMaster

Search Model Class- app\models\TahsileMastersearch

Controller Class- backend\controllers\TahsileController

View Path-

Link for merg

Yii Set .htaccess for direct access project (frontend) & admin(backend)

Step 1.

Options +FollowSymlinks
RewriteEngine On

# deal with admin first
RewriteCond %{REQUEST_URI} ^/(admin) <------
RewriteRule ^admin/assets/(.*)$ backend/web/assets/$1 [L]
RewriteRule ^admin/css/(.*)$ backend/web/css/$1 [L]

RewriteCond %{REQUEST_URI} !^/backend/web/(assets|css)/  <------
RewriteCond %{REQUEST_URI} ^/(admin)  <------
RewriteRule ^.*$ backend/web/index.php [L]


RewriteCond %{REQUEST_URI} ^/(assets|css)  <------
RewriteRule ^assets/(.*)$ frontend/web/assets/$1 [L]
RewriteRule ^css/(.*)$ frontend/web/css/$1 [L]

RewriteCond %{REQUEST_URI} !^/(frontend|backend)/web/(assets|css)/  <------
RewriteCond %{REQUEST_URI} !index.php
RewriteCond %{REQUEST_FILENAME} !-f [OR]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^.*$ frontend/web/index.php

Note : if you are trying in local server then replace ^/ with ^/project_name/ where you see arrow sign. Remove those arrow sign <------ after setup is done.

Step 2.

create file Request.php in

common\components

and put below code:

<?php

namespace common\components;

class Request extends \yii\web\Request

{

   public $web;

   public $adminUrl;

   public function getBaseUrl()

   {

       return str_replace($this->web, "", parent::getBaseUrl()) . $this->adminUrl;

   }

   /*

     If you don't have this function, the admin site will 404 if you leave off

     the trailing slash.

     E.g.:

     Wouldn't work:

     site.com/admin

     Would work:

     site.com/admin/

     Using this function, both will work.

    */

   public function resolvePathInfo()

   {

       if ($this->getUrl() === $this->adminUrl)

       {

           return "";

       } else

       {

           return parent::resolvePathInfo();

       }

   }

}

Step 3.  put code

Installing component. Write below code in frontend/config/main.php and backend/config/main.phpfiles respectively.

//frontend, under components array
'request'=>[
    'class' => 'common\components\Request',
    'web'=> '/frontend/web'
],
'urlManager' => [
        'enablePrettyUrl' => true,
        'showScriptName' => false,
],

// backend, under components array
'request'=>[
    'class' => 'common\components\Request',
    'web'=> '/backend/web',
    'adminUrl' => '/admin'
],
'urlManager' => [
        'enablePrettyUrl' => true,
        'showScriptName' => false,
],

For Short URL:-

add rules in url manager

         'rules' =>
            [
                'country-add'=>'country/create',

                 'country-view/<id:\d>' => 'country/view', 

           ] 

Database Migrate in Yii

-> After Database Connctive

CMD in

D:\wamp\www\Yii2\>yii migrate

Yii Migration Tool (based on Yii v2.0.6)

Creating migration history table "migration"...Done.

Total 1 new migration to be applied:

       m130524_201442_init

Apply the above migration? (yes|no) [no]:yes

*** applying m130524_201442_init

   > create table {{%user}} ... done (time: 1.185s)

*** applied m130524_201442_init (time: 1.335s)

Migrated up successfully.

D:\wamp\www\Yii2\>

Theme Installing

#   frontend->assets->AppAsset.php

Put here css & js links

like as

public $css = [

       //'css/site.css',

       'assets/css/bootstrap.css',

       'assets/css/font-awesome.css',

       'assets/js/morris/morris-0.4.3.min.css',

       'assets/css/custom-styles.css',

            'http://fonts.googleapis.com/css?family=Open+Sans',

   ];

   public $js = [

       'assets/js/jquery-1.10.2.js',

       'assets/js/bootstrap.min.js',

       'assets/js/jquery.metisMenu.js',

       'assets/js/morris/raphael-2.1.0.min.js',

       'assets/js/morris/morris.js',

       'assets/js/custom-scripts.js',

   ];

put links files on web folder

# set views in layout  main & index  

Yii2 dropdown multiple selected values

Form

 <?= 
  $form->field($model, 'categories')            
         ->dropDownList($model->CategoryDropdown,
         [
          'class'=>'chosen-select input-md required',
          'multiple'=>'multiple'              
         ]             
        )->label("Add Categories");
 ?>

Controller:

 public function actionCreate(){
 ...
     $model->categories = implode(",",$_POST['Company']['categories']);
    ...
    return $this->render('create', [
            'model' => $model,           
        ]);
 }

public function actionUpdate($id)
{
    $model = $this->findModel($id); 
    $model->categories = explode(',', $model->categories);        
    ...
    if($model->load(Yii::$app->request->post()))
    {
         $model->categories = implode(",",$_POST['Company']['categories']);    
         ...
         $model->save()
    }
    return $this->render('update', [
                'model' => $model,                    
            ]); 
  }