Yii framework - CMenu Custommize

<?php $this->widget('zii.widgets.CMenu', array(
                'items' => array(
        array(
            'label' => '<i class="fa fa-dashboard fa-fw"></i> <span> Dashboard</span></i>',
            'url' => array('/site/index'),
            'itemOptions' => array(
            //'class'=>'active',
            ),
        ),
                   
      
                   
             
       //PackageTours Config          
        array(
                        'label' => '<i class="fa fa-bar-chart-o fa-fw"></i> <span> Package Tours</span> <span class="fa arrow"></span></i>',
                        'url' => '#',
                        'linkOptions'=> array(
                            'class' => 'nav nav-second-level',
                           'data-toggle' => 'dropdown',
                            ),
                        'itemOptions' => array('class'=>'nav nav-second-level'),
                        'items' => array(
                            array(
                                'label' => '<i class="icon-user"></i>Package List',
                                'url' => '#'
                            ),
                            array(
                                'label' => '<i class="icon-calendar"></i> Add Package',
                                'url' => '#',
                            ),

                        )
                    ),
                              
                                 
                   
                   
                   
         //Hotel Config          
        array(
                        'label' => '<i class="fa fa-bar-chart-o fa-fw"></i> <span>Hotel Profile</span> <span class="fa arrow"></span></i>',
                        'url' => '#',
                        'linkOptions'=> array(
                            'class' => 'nav nav-second-level',
                            'data-toggle' => 'dropdown',
                            ),
                        'itemOptions' => array('class'=>'nav nav-second-level'),
                        'items' => array(
                            array(
                                'label' => '<i class="icon-user"></i> Hotel List',
                                'url' => '#'
                            ),
                            array(
                                'label' => '<i class="icon-calendar"></i> Add Hotel',
                                'url' => '#',
                            ),

      
                        )
                    ),
                              
                   
                   
                   
                   
                   
                   
                   
                   
                   
        //report           
        array(
                        'label' => '<i class="fa fa-bar-chart-o fa-fw"></i> <span>Report</span> <span class="fa arrow"></span></i>',
                        'url' => '#',
                        'linkOptions'=> array(
                            'class' => 'nav nav-second-level',
                           // 'data-toggle' => 'dropdown',
                            ),
                        'itemOptions' => array('class'=>'nav nav-second-level'),
                        'items' => array(
                            array(
                                'label' => '<i class="icon-user"></i> My Profile',
                                'url' => '#'
                            ),
                            array(
                                'label' => '<i class="icon-calendar"></i> My Calendar',
                                'url' => '#',
                            ),
                            array(
                                'label' => '<i class="icon-tasks"></i> My Tasks</a>',
                                'url' => '#',
                            ),
                            array(
                                'label' => '',
                                array(
                                    'class' => 'divider',
                                )
                            ),
                            array(
                                'label' => '<i class="icon-key"></i> Log Out',
                                'url' => array('site/logout'),
                            ),
                        )
                    ),
                   
                   
                   
                   
                   
                   
                   
                   
                    //config
                    array(
                        'label' => '<i class="fa fa-gear fa-fw"></i> <span> Setting </span> <span class="fa arrow"></span></i>',
                        'url' => '#',
                        'linkOptions'=> array(
                            'class' => 'nav nav-second-level',
                           // 'data-toggle' => 'dropdown',
                            ),
                        'itemOptions' => array('class'=>'nav nav-second-level'),
                        'items' => array(
                            array(
                                'label' => '<i class="icon-user"></i> My Profile',
                                'url' => '#'
                            ),
                            array(
                                'label' => '<i class="icon-calendar"></i> My Calendar',
                                'url' => '#',
                            ),
                            array(
                                'label' => '<i class="icon-tasks"></i> My Tasks</a>',
                                'url' => '#',
                            ),
                            array(
                                'label' => '',
                                array(
                                    'class' => 'divider',
                                )
                            ),
                            array(
                                'label' => '<i class="fa fa-sign-out"></i> Log Out',
                                'url' => array('site/logout'),
                            ),
                        )
                    ),
                   
   
                         array(
            'label' => '<i class="fa fa-sign-out fa-fw"></i> <span> Log Out </span></i>',
            'url' => array('/site/logout'),
            'itemOptions' => array(
            //'class'=>'active',
            ),
        ),
                 
                ),
                'encodeLabel' => false,
                'htmlOptions' => array(
                    'class'=>'nav',
                        ),
                'submenuHtmlOptions' => array(
                    'class' => 'nav nav-second-level',
                )
            ));?>

Yii framework - CHtml::link() example

<?php  
echo CHtml::link(CHtml::encode(Yii::app()->name),

array('controller/action'),

array('class'=>'navbar-brand',
));
?> 

 

 

Yii Gridview List

Controller Code 

Out View

Code View

Yii : Custom Running Numbers

Yii Gen Custom Running Numbers Max ID

$criteria = new CDbCriteria; $criteria->select = 'max(carrent_id) AS maxCarrentID'; $row = $CarRental->model()->find($criteria); $nextID = $row['maxCarrentID']; $CurYear = substr(date('Ym'), 2, 4); $year = substr($nextID, 0, 4); $number = substr($nextID, 5, 4) + 1; if ($nextID = 0) { $CurYear = substr(date('Ym'), 2, 4); $runNumber = sprintf('%04d', 1); $newCarrentID = $CurYear . "-" . $runNumber; } else { // check Diff Year if ($CurYear = $year) { $CurYear = substr(date('Ym'), 2, 4); $runNumber = sprintf('%04d', $number); $newCarrentID = $CurYear . "-" . $runNumber; } else { $CurYear = substr(date('Ym'), 2, 4); $runNumber = sprintf('%04d', 1); $newCarrentID = $CurYear . "-" . $runNumber; } }

Yii DateFormat Input To Mysql Format

Yii Learning | Yii Chang Date Format From dd/mm/yyyy to yyyy-mm-dd

date('Y-m-d', CDateTimeParser::parse($_POST['tbAccjvs']['JVDATE'], 'dd/mm/yyyy'));

Good Luck By Yii Learning

Yii Function : createMultipleInsertCommand

Yii 1.1.14

$builder = Yii::app()->db->schema->commandBuilder; $command=$builder->createMultipleInsertCommand('tbl_accjvs', array( array('MemberID'=>$MemberID,'MINOR_CODE'=>$minorCode,'JVACC_CODE'=>$jvcrCode,'JVDATE'=>$jvDate,'JVNO'=>'','JVITEM'=>$jvItem,'JVAMT'=>$jvAmt, 'JVCR'=>'Y', 'JVDR'=>'N', 'JVREMARK'=>$jvRemark,'JVPOSTDATE'=>$jvPostDate,'JVUPDATE'=>$jvPostDate), array('MemberID'=>$MemberID,'MINOR_CODE'=>$minorCode,'JVACC_CODE'=>$jvdrCode,'JVDATE'=>$jvDate,'JVNO'=>'','JVITEM'=>$jvItem,'JVAMT'=>$jvAmt, 'JVCR'=>'N', 'JVDR'=>'Y', 'JVREMARK'=>$jvRemark,'JVPOSTDATE'=>$jvPostDate,'JVUPDATE'=>$jvPostDate), )); $command->execute();

yii cgridview image size | Yii View

<?php

$this->widget('bootstrap.widgets.TbGridView', array(
    'type' => 'striped bordered condensed',
    'itemsCssClass' => 'table table-striped table-bordered table-condensed',
    'id' => 'search-grid', // id ของตาราง CGridView
    'dataProvider' => $tmpOrderList, // ข้อมูล dataProvider จากภายใน Model ของ function search()
    'template' => "{items}",
    'columns' => array(
        array(
            'header' => 'No.',
            'value' => '$this->grid->dataProvider->pagination->currentPage*$this->grid->dataProvider->pagination->pageSize + $row+1', //  row is zero based
        ),
        array(
            'name' => 'pictures',
            'type' => 'html',
            'value' => '(!empty($data->PICTURES))?CHtml::image("./images/Purchase/".$data->PICTURES,"",array("style"=>"width:180px;")):"no image"',
        ),
        'PRODUCT_CODE',
        'REF_CODE',
        'DESING',
        'COLOR',
        'SIZE_S',
        'SIZE_M',
        'SIZE_XL',
        'SIZE_F',
        'ORDER_QTY',
        'UNIT_PRICE',
        array(
            'name' => 'UNIT_PRICE',
            'value' => 'Yii::app()->numberFormatter->formatCurrency($data->UNIT_PRICE, "THB")',
        ),
        array(
            'name' => 'TOTAL_PRICE',
            'value' => 'Yii::app()->numberFormatter->formatCurrency($data->TOTAL_PRICE, "THB")',
        ),
        array(
            'class' => 'bootstrap.widgets.TbButtonColumn',
            'template' => ' {edit} {delete}',
            'buttons' => array
                (
                'edit' => array
                    (
                    'label' => 'Edit',
                    'icon' => 'pencil white',
                    'url' => 'Yii::app()->createUrl("Product/AddProduct", array("prdID"=>$data->ID))',
                    'options' => array(
                        'class' => 'btn btn-small btn-success',
                    ),
                ),
                'delete' => array
                    (
                    'label' => 'Del',
                    'icon' => 'icon-trash white',
                    'url' => 'Yii::app()->createUrl("Product/delProduct", array("prdID"=>$data->ID))',
                    'options' => array(
                        'class' => 'btn btn-small btn-danger',
                    ),
                ),
            ),
            'htmlOptions' => array(
                'style' => 'width: 80px',
            ),
        )
    ),
));
?>