= GridView::widget([
'dataProvider' => $dataProvider,
'filterModel' => $searchModel,
'columns' => [
[
'attribute' => 'id', //保持可以排序,必须保留attribute属性,如果去除排序,可以使用header属性命名
'value' => 'id',
'contentOptions' => [ 'width' => '35px' ],
'attribute' => 'id',
],
'user',
'policyNo',
'expiryDate' => [
'attribute' => 'expiryDate',
'value' => function ($model) { //使用函数来处理属性值
return $model->FormatData($model->expiryDate);
}]
,
'insurance_online_id',
// 'create_time',
['class' => 'yii\grid\ActionColumn',
'template'=>'{delete}' //这里可以设置只保留的操作
],
],
]); ?>
Form表单部分:
1、组件使用方法:
文本框:textInput();
密码框:passwordInput();
单选框:radio(),radioList();
复选框:checkbox(),checkboxList();
下拉框:dropDownList();
隐藏域:hiddenInput();
文本域:textarea([‘rows’=>3]);
文件上传:fileInput();
提交按钮:submitButton();
重置按钮:resetButtun();
$form = ActiveForm::begin(['action' => ['test/getpost'],'method'=>'post',]); ?>
echo $form->field($model, 'username')->textInput(['maxlength' => ]) ?>
echo $form->field($model, 'password')->passwordInput(['maxlength' => ]) ?>
echo $form->field($model, 'sex')->radioList([''=>'男',''=>'女']) ?>
echo $form->field($model, 'edu')->dropDownList([''=>'大学',''=>'高中',''=>'初中'], ['prompt'=>'请选择','style'=>'width:120px']) ?>
echo $form->field($model, 'file')->fileInput() ?>
echo $form->field($model, 'hobby')->checkboxList([''=>'篮球',''=>'足球',''=>'羽毛球',''=>'乒乓球']) ?>
echo $form->field($model, 'info')->textarea(['rows'=>]) ?>
echo $form->field($model, 'userid')->hiddenInput(['value'=>]) ?>
= $form->field($model, 'userid')->hiddenInput(['value'=>])->label(false); ?>
echo Html::submitButton('提交', ['class'=>'btn btn-primary','name' =>'submit-button']) ?>
echo Html::resetButton('重置', ['class'=>'btn btn-primary','name' =>'submit-button']) ?>
时间插件
use yii\jui\DatePicker;
= $form->field($model, 'expiryDate')->textInput(['maxlength' => true])->widget(\yii\jui\DatePicker::className(),[
'language'=>'zh-CN',
'dateFormat' => 'yyyy-MM-dd'
]) ?>
echo "开始时间:";
Yii::import('application.extensions.CJuiDateTimePicker.CJuiDateTimePicker');
$this->widget('CJuiDateTimePicker', array(
'name' => 'SplashConfig[begin_time]',
'value' => $model->begin_time,
'mode' => 'datetime', //use "time","date" or "datetime" (default)
'options' => array(
'dateFormat' => 'yy-mm-dd'
), // jquery plugin options
'language' => 'zh',
'htmlOptions' => array('style' => "width:123px","readonly" => "readonly")
)); ?>
YII使用Mysql FIND_IN_SET函数
if ($this->city_ids) {
$criteria->addCondition('FIND_IN_SET(:city_ids, city_ids)');
$criteria->params[':city_ids'] = $this->city_ids;
}
YII 判断是否是Ajax请求,获取请求参数
//yii 1 ,是否是post
if (Yii::app()->request->isPostRequest) {
$key1 = Yii::app()->request->getParam('key1');
echo 'ajax';
}
//yii 1 是否是ajax
if (Yii::app()->request->isAjaxRequest) {
echo 'ajax';
}
//yii2 是否是ajax
Yii::$app->request->isAjax
YII1中模板创建URL
<?php echo Yii::app()->createUrl('/KnowledgeAuthUser/admin');?>
YII1 checkbox
$auth_list = KnowledgeAuthList::getAllAuth();
foreach ($auth_list as $key => $val) {
$checked = in_array(strval($val['id']), $have_ids = isset($have_ids) ? $have_ids : [] ) ? true: false;
echo CHtml::checkBox("KnowledgeAuthUser[auth_list][]", $checked, array("value" => $val['id'], 'class' => 'customer_level')) . $val['auth_name'] . ' ';
}
?>
YII1注册引入JS扩展文件(layer.js)
$assets = Yii::app()->request->hostInfo."/v2/sto/classic/www/js/layer/layer.js";
$cs = Yii::app()->getClientScript();
$cs->registerScriptFile($assets);
?>
YII1 fandall查询指定字段
modelName::model() -> find() //找出的是一个对象
modelName::model() -> findALL() //找出的是一个对象集合的数组
$criteria = new CDbCriteria;
$criteria->select = 'username,id,email';
$criteria->order = 'id DESC';
$users = modelName::model()->findAll( $criteria );
$users = $this->user->find(array(
'select'=>array('id','username','email'),
'order' => 'id DESC',
'condition' => 'state=:state AND id=:id',
'params' => array(':state'=>'',':id' => ''),
));
echo Yii::app()->request->redirect('http://www.baidu.com');