近期Yii2学习用法总结 [ 2.0 版本 ]

1、一些常用的参数总结：

系统类型: <?= php_uname() ?>
解译引擎:  <?= $_SERVER['SERVER_SOFTWARE'] ?>，
Zend：    <?= Zend_Version() ?>
数据库:    MySql:<?= (new yii\db\Query())->select('VERSION()')->one()['VERSION()'] ?>
服务器
             服务器IP：<?= GetHostByName($_SERVER['SERVER_NAME']) ?>
             程序目录：<?= Yii::$app->BasePath ?>

2、Yii2设定场景规则的形式

  public function scenarios()
    {
        return [
            'create' => ['username', 'email', 'password', 'status', 'role','sex','citys','provinces','countrys','mobile_phone'],
            'update' => ['username', 'email', 'status', 'role','sex','citys','provinces','countrys','mobile_phone'],
            'delete' => ['status'],
            'signup' => ['username', 'email', 'password', 'role'],
        ];
    }

另外还有一种：

 $storeUser->save(false);

这个可以把所有的规则去掉，只留设定的规则

3、YIi2原生与非原生的对比

Html::a('取消订单','javascript:;',['url'=>Url::to(['benefit-to-pro/min-product','base_id'=>$model->base_id]),'class'=>'openmodal'])

<a href=javascript:;  src=\aiyidd\backend\web\index.php?r=benefit-to-pro/min-product&base_id=$model->base_id  class=openmodal>追踪查看价格</a>

4、自定义表单样式

 <?php $form = ActiveForm::begin([
             'options' => ['class' => 'form-horizontal'],  
             'fieldConfig' => [
                'options'=>['class'=>'control-group'],  
                'template' => "{label}<div class=\"controls\">{input}<span class=\"help-inline\">{error}</span></div>",  
                'inputOptions'=>['class'=>'input-xlarge'],
                'labelOptions' => ['class' => 'control-label'], 
            ],  
        ]); ?>

    <?= $form->field($model, 'title')->textInput(['maxlength' => 255]) ?>

    <?= $form->field($model, 'pic')->widget('pjkui\kindeditor\KindEditor',['editorType'=>'image-dialog','callbackjs'=>'$("#brand").attr("src",url);']) ?>
    
    <img  src="<?php echo $model->pic ?>" width="540" height="225" style='width:540px;height:225px' id="brand">
    
    <?= $form->field($model, 'status')->radioList(['1'=>'正常','0'=>'不可用','2'=>'发布中']) ?>
   
    <?= Html::submitButton($model->isNewRecord ? '创建' : '修改', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>
    
<?php ActiveForm::end(); ?>

5、自定义分页样式

 <?= GridView::widget([
        'dataProvider' => $dataProvider,
        //'filterModel' => $searchModel,
        'layout'=>'<div id="DataTables_Table_0_wrapper" class="dataTables_wrapper">
                                            {items}
                                            <div class="row-fluid">
                                              <div class="span12"><div class="dataTables_info" id="DataTables_Table_0_info">{summary}</div></div>
                                              <div class="span12 center"> 
                                                        <div class="dataTables_paginate paging_bootstrap pagination">
                                                          {pager}
                                                        </div>
                                                   </div>
                                               </div>
                                         </div>

                                          <div class="row">
             
                                         ',
                           
                            'pager'=>[
                                 'prevPageLabel'=>'← 上一页',    
                                 'nextPageLabel'=>'下一页 →', 
                            ],
       'columns' => [
            ['class' => 'yii\grid\SerialColumn'],
            ['class' => 'yii\grid\CheckboxColumn',
                'checkboxOptions' => function($model, $key, $index, $column) {
                    return ['value' => $model->id];
                }],
            ['attribute'=>'pics','value'=>function($model){
                $path = '/static/images/brand-head.jpg';
                if(!empty($model->pics_arr)){
                    $path = $model->pics_arr[0]['path'];
                }
                return "<img src='$path' width=75 height=75>";
            },'format'=>'html'],
            'name',
            ['label'=>'品牌', 'attribute' => 'name_zh',  'value' => 'brand.name_zh'],
            ['label'=>'类目', 'attribute' => 'catename',  'value' => 'category.name'],
            [
                'attribute' => 'status',
                'label' => '状态',
                'value'=>function($model){
                       return $model->status_text;
                 },
                'filter' => \common\models\ProductBase::get_status(),
            ],

            ['attribute'=>'storage_time','format'=>['date', 'php:Y-m-d']],
             ['label'=>'更多操作', 'format' => 'raw',  'value' => function($model){
                                    return  "<a class='btn btn-success' href='".Url::to(['product-base/view','id'=>$model->id])."' alt='查看'>
                                                 <i class='icon-zoom-in'></i>  
                                             </a>
                                             <a class='btn btn-info' href='".Url::to(['product-base/update','id'=>$model->id])."' alt='修改'>
                                                 <i class='icon-edit'></i>  
                                             </a>
                                             <a class='btn btn-danger' href='".Url::to(['product-base/delete','id'=>$model->id])."' alt='删除'>
                                                 <i class='icon-trash'></i>  
                                             </a>
                                             ";
                                }],
            [
                'label' => '更多操作',
                'format'=>'raw',
                'value' => function($model){
                    return Html::a('店铺商品', ['product/index','id' => $model->id], ['title' => '店铺商品','class'=>'btn btn-info btn-setting']);
                }
            ],
        ],
    ]); ?>

5、Yii2查询的用法

   $request = Yii::$app->request;
        $shopid = $request->post('shopid');
        $gps = $request->post('gps');
        $connection = Yii::$app->db;
        $sqlb = "select s.* from store_show s where s.type=0 and s.store_id='" . $shopid . "' ";
        $rowsb = $connection->createCommand($sqlb)->query();