[gridview] -- 超详细使用

最新推荐文章于 2023-12-29 15:54:29 发布
最新推荐文章于 2023-12-29 15:54:29 发布
阅读量8.4k 收藏 6
点赞数 2
分类专栏： Yii2

原文地址 : https://segmentfault.com/a/1190000006868819


Yii2 GridView是实现yii网格视图的小部件，一般用于报表视图的展示。今天，结合DataProvider（ArrayDataProvider以及SqlDataProvider）说一下GridView中的几个Columns(SerialColumn,DataColumn,ActionColumn)。

教程一 

1.页面显示的时间戳转换
a.

[
        'label'=>'创建日期',
        'attribute' => 'created_at',
        'filter' => false, //不显示搜索框
        'value' => function($data) {
               return date('Y-m-d H:i:s',$data->created_at); }
],

b.

[
        'label'=>'创建日期',
        'attribute' => 'created_at',
        'format' => ['date', 'php:Y-m-d H:i:s'],
],

2.为字段加超链接

[ 
      'attribute'=>'title’,
      'format'=>'raw’,
      'value'=> function($data){return Html::a($data->title,['exam/index', 
            'id' => $data->_id],['title' => '审核']);} 
],

[
     'label'=>'更多操作’, 
     'format'=>'raw’,
     'value' => function($data) { 
           $url = "http://www.baidu.com”; 
           return Html::a('添加权限组', $url, ['title' => '审核']); } 
],

3.下拉菜单搜索

[
            'label' => '当前状态',
            'attribute' => 'status',
            'filter' => Html::dropDownList('AppBaseSearch[status
]',$searchModel-> status,
                    [ '' => '请选择',
                    ‘0' => '审核拒绝', 
                    ‘1' => '审核通过', 
		]),

     'value' => function($date) {
                    switch ($date-> status) {
                        case 1';
                            return '审核通过';
                            break;
                        case ‘0';
                            return '审核拒绝';
                            break;
                        default:
                            return '未知状态';
                            break;
                    }
                }
            ],

4.私人定制增删改按钮

[
                'header' => "查看／审核",
                'class' => 'yii\grid\ActionColumn',
                'template'=> '{view} {update} {delete}',
                'headerOptions' => ['width' => '140'],
                'buttons' => [
                    'view' => function ($url, $model, $key) {
                        return Html::a(Html::tag('span', '', ['class' => "glyphicon fa fa-eye"]), ['admin/view-app', 'id'=>$model->app_id], ['class' => "btn btn-xs btn-success", 'title' => '查看']);
                    },
                    'update' => function ($url, $model, $key) use($uid){
                          return Html::a('通过', ['admin/reviewapp','id'=>$model->app_id, 'status’=>1], ['class' => "btn btn-xs btn-info"]);
                    },
                    'delete' => function ($url, $model, $key) {
                            return Html::a('拒绝', ['admin/reviewapp', 'id' => $model->app_id, 'status’=>0], ['class' => "btn btn-xs btn-danger"]);
                    }
                ]
],

教程二

1. SerialColumn

SerialColumn就是连续的列，主要用于网格的行号，属于自增式的列。用法很简单：

echo GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'], // 连续编号
        // 其他数据列和操作列
    ]
]);

展示结果：

#
1
2

2. DataColumn

DataColumn主要展示数据的，所有跟数据有关的展示基本都在这个Column中实现。因此用法也很多，但是有一条，如果对数据不做处理，那么字段必须是ArrayDataProvider对象的allModels的二维数组的key或者是SqlDataProvider对象sql查询结果二维数组的key。

用法一：表头即字段名，首字母大写

echo GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        'orderNo',   //订单编号
        'username'   // 用户名
    ]
]);

展示结果：

OrderNo Username
123345698763 Test用户
236479547829 Joyven

用法二：定义表头并格式化数据

echo GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        'time:date:日期',
        'pv:raw:PV',
        'uv:raw:UV',
    ]
]);

展示结果：

日期 PV UV
2016年9月10日 8500 6384
2016年9月9日 8378 6523

用法三：数据过滤，class、attribute、label、format均不是必须要的。class默认是yii\grid\DataColumn，attribute是指定排序的字段key，一定是dataProvider中提供的数据的key，如果不指定，对于过滤的数据，不能点击表头排序。

echo GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        [
        'value' => function($data) {
            if (isset($data['time'])) {
                return date('Y-m-d', $data['time']);
            }
        },
        'attribute' => 'time', //用于排序，如果不写，不能点击表头排序，非必须
        'label' => '日期', // 自定义表头，非必须
        'format' => 'raw', // 格式方式，非必须
        ],
        'pv:raw:PV',
        [
        'class' => 'yii\grid\DataColumn',
        'value' => function ($data) {
            if (isset($data['orderCr'])) {
                return ($data['orderCr'] * 100) . '%';
            }
        },
        'attribute' => 'orderCr',
        'label' => '下单转化率',
        'format' => 'raw',
    ],
    ]
]);

关于format支持的格式：

format 说明 参数 返回 备注
raw Formats the value as is without any formatting. This method simply returns back the parameter without any format.The only exception is a nullvalue which will be formatted using [[nullDisplay]]. @param mixed $value the value to be formatted. @return string the formatted result. -
text Formats the value as an HTML-encoded plain text. @param string $value the value to be formatted. @return string the formatted result. -
ntext Formats the value as an HTML-encoded plain text with newlines converted into breaks. @param string $value the value to be formatted. @return string the formatted result. -
html Formats the value as HTML text.The value will be purified using [[HtmlPurifier]] to avoid XSS attacks.Use [[asRaw()]] if you do not want any purification of the value. @param string $value the value to be formatted.@param array or null $config the configuration for the HTMLPurifier class. @return string the formatted result. -
date Formats the value as a date. @param integer or string or DateTime $value the value to be formatted. The following types of value are supported: 1.an integer representing a UNIX timestamp; 2.a string that can be parsed to create a DateTime object.The timestamp is assumed to be in [[defaultTimeZone]] unless a time zone is explicitly given; 3.a PHP DateTimeobject @param string $format the format used to convert the value into a date string.If null, [[dateFormat]] will be used. This can be "short", "medium", "long", or "full", which represents a preset format of different lengths.It can also be a custom format as specified in the ICU manual.Alternatively this can be a string prefixed with php: representing a format that can be recognized by the PHP date()-function. @return string the formatted result. @throwsInvalidParamException if the input value can not be evaluated as a date value. @throwsInvalidConfigException if the date format is invalid.
time Formats the value as a time. @param integer or string or DateTime $value the value to be formatted. The following types of value are supported:1. an integer representing a UNIX timestamp; 2. a string that can be parsed to create a DateTime object.The timestamp is assumed to be in [[defaultTimeZone]] unless a time zone is explicitly given; 3. a PHP DateTimeobject @param string $format the format used to convert the value into a date string.If null, [[timeFormat]] will be used.This can be "short", "medium", "long", or "full", which represents a preset format of different lengths.It can also be a custom format as specified in the ICU manual.Alternatively this can be a string prefixed with php: representing a format that can be recognized by the PHP date()-function. @return string the formatted result. @throwsInvalidParamException if the input value can not be evaluated as a date value. @throwsInvalidConfigException if the date format is invalid.@seetimeFormat
paragraphs Formats the value as HTML-encoded text paragraphs.Each text paragraph is enclosed within a<p> tag.One or multiple consecutive empty lines divide two paragraphs. @param string $value the value to be formatted. @return string the formatted result. -
email Formats the value as a mailto link. @param string $value the value to be formatted. @param array $options the tag options in terms of name-value pairs. See [[Html::mailto()]]. @return string the formatted result. -
image Formats the value as an image tag. @param mixed $value the value to be formatted. @param array $options the tag options in terms of name-value pairs. See [[Html::img()]]. @return string the formatted result. -
url Formats the value as a hyperlink. @param mixed $value the value to be formatted. @param array $options the tag options in terms of name-value pairs. See [[Html::a()]]. @return string the formatted result. -
boolean Formats the value as a boolean. @param mixed $value the value to be formatted. @return string the formatted result. @seebooleanFormat -
datetime Formats the value as a datetime. @param integer or string or DateTime $value the value to be formatted. The following types of value are supported: 1. an integer representing a UNIX timestamp; 2. a string that can be parsed to create a DateTime object. The timestamp is assumed to be in [[defaultTimeZone]] unless a time zone is explicitly given.; 3. a PHP DateTime object @param string $format the format used to convert the value into a date string. If null, [[dateFormat]] will be used. This can be "short", "medium", "long", or "full", which represents a preset format of different lengths. It can also be a custom format as specified in the ICU manual. Alternatively this can be a string prefixed with php:representing a format that can be recognized by the PHP date()-function. @return string the formatted result. @throwsInvalidParamException if the input value can not be evaluated as a date value.@throwsInvalidConfigException if the date format is invalid. @seedatetimeFormat -
timestamp Formats a date, time or datetime in a float number as UNIX timestamp (seconds since 01-01-1970). @param integer or string or DateTime $value the value to be formatted. The followingtypes of value are supported:1. an integer representing a UNIX timestamp; 2. a string that can be parsed to create a DateTime object. The timestamp is assumed to be in [[defaultTimeZone]] unless a time zone is explicitly given.; 3. a PHP DateTime object @return string the formatted result. -
relativetime Formats the value as the time interval between a date and now in human readable form.This method can be used in three different ways:1. Using a timestamp that is relative to now.2. Using a timestamp that is relative to the$referenceTime.3. Using aDateIntervalobject. @param integer or string or DateTime or DateInterval $value the value to be formatted. The following types of value are supported:1. an integer representing a UNIX timestamp; 2. a string that can beparsed to create a DateTime object.The timestamp is assumed to be in [[defaultTimeZone]] unless a time zone is explicitly given.; 3. a PHP DateTime object; 4. a PHP DateInterval object (a positive time interval will refer to the past, a negative one to the future) @param integer or string or DateTime $referenceTime if specified the value is used as a reference time instead ofnow when $value is not a DateIntervalobject. @return string the formatted result. @throwsInvalidParamException if the input value can not be evaluated as a date value.
intger Formats the value as an integer number by removing any decimal digits without rounding. @param mixed $value the value to be formatted. @param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]]. @param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric.
decimal Formats the value as a decimal number.Property [[decimalSeparator]] will be used to represent the decimal point. The value is rounded automatically to the defined decimal digits. @param mixed $value the value to be formatted. @param integer $decimals the number of digits after the decimal point. If not given the number of digits is determined from the [[locale]] and if the PHP intl extension is not available defaults to 2. @param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]]. @param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric.@seedecimalSeparator@seethousandSeparator
percent Formats the value as a percent number with "%" sign. @param mixed $value the value to be formatted. It must be a factor e.g. 0.75 will result in 75%. @param integer $decimals the number of digits after the decimal point.@param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]].@param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric.
scientific Formats the value as a scientific number. @param mixed $value the value to be formatted. @param integer $decimals the number of digits after the decimal point. @param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]].@param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric.
currency Formats the value as a currency number.This function does not requires the PHP intl extension to be installed to work but it is highly recommended to install it to get good formatting results. @param mixed $value the value to be formatted. @param string $currency the 3-letter ISO 4217 currency code indicating the currency to use.If null, [[currencyCode]] will be used.@param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]]. @param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric. @throwsInvalidConfigException if no currency is given and [[currencyCode]] is not defined.
spellout Formats the value as a number spellout.This function requires thePHP intl extension to be installed. @param mixed $value the value to be formatted @return string the formatted result. @throwsInvalidParamException if the input value is not numeric. @throwsInvalidConfigException when the PHP intl extension is not available.
ordinal Formats the value as a ordinal value of a number. This function requires thePHP intl extension to be installed. @param mixed $value the value to be formatted @return string the formatted result. @throwsInvalidParamException if the input value is not numeric. @throwsInvalidConfigException when the PHP intl extension is not available.
shortsize Formats the value in bytes as a size in human readable form for example 12 KB.This is the short form of [[asSize]]. If [[sizeFormatBase]] is 1024, binary prefixes (e.g. kibibyte/KiB, mebibyte/MiB, ...) are used in the formatting result. @param integer $value value in bytes to be formatted. @param integer $decimals the number of digits after the decimal point. @param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]]. @param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric. @seesizeFormat @seeasSize
size Formats the value in bytes as a size in human readable form, for example 12 kilobytes. If [[sizeFormatBase]] is 1024, binary prefixes (e.g. kibibyte/KiB, mebibyte/MiB, ...) are used in the formatting result. @param integer $value value in bytes to be formatted. @param integer $decimals the number of digits after the decimal point. @param array $options optional configuration for the number formatter. This parameter will be merged with [[numberFormatterOptions]]. @param array $textOptions optional configuration for the number formatter. This parameter will be merged with [[numberFormatterTextOptions]]. @return string the formatted result. @throwsInvalidParamException if the input value is not numeric. @seesizeFormat @seeasShortSize

3. ActionColumn

ActionColumn是对一行数据进行操作的句柄。class指定处理的类，必须。 header指定表头显示，如果不写，默认为空。非必须。template中默认有三个：{view} {update} {delete}，如果需要其他的，自行添加，比如下面添加了{onshelf} {offshelf}{robot}这三个。buttons除了默认的三个可以不写，其他都必须写。

echo GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        [
            'class' => 'yii\grid\ActionColumn',
            'header' => '操作’,
            'template' => '{view} {update} {delete} {onshelf} {offshelf} {robot}',
            'buttons' => [
                'onshelf' => function ($url, $model, $key){
                    return    $model['status'] ? '' : Html::a('<span class="glyphicon glyphicon-ok"></span>',
                        ['item/shelf'],
                        ['title' => '上架商品', 'data' => ['method' => 'post', 'id' => $key, 'type' => 'on'], 'class'=> 'shelf']);
                },
                'offshelf' => function ($url, $model, $key){
                    return    $model['status'] ? Html::a('<span class="glyphicon glyphicon-remove"></span>',
                        ['item/shelf'],
                        ['title' => '下架商品', 'data' => ['method' => 'post', 'id' => $key, 'type' => 'off'], 'class'=> 'shelf']) : '';
                },
                
                'robot' => function ($url, $model, $key){
                    return     Html::a('<span class="glyphicon glyphicon-knight"></span>',
                        ['robot/like', 'id' => $model['pid'] ],
                        ['title' => '自动点赞', 'class' => 'post-autolike', 'data' => ['method' => 'post']]) ;
                },
            ]
        ],
    ],
]);

展示效果：

操作
查看 更新 删除 上架商品 下架商品 自动点赞

把相应的文字替换成icon图标以及链接即可。


不惧前行
关注
  • 2
    点赞
  • 踩
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
vxe-table导出xlsx，当前数据，全量数据
老黑的博客
12-06 2798
vxe-table导出全量数据，导出xlsx格式数据
GridView超级嵌套
12-16
例如，如果主GridView显示产品，子GridView则可以显示该产品的详细属性或相关评论。 3. **数据绑定**：在子GridView的RowDataBound事件处理程序中，我们需要获取主GridView当前行的数据键值，然后根据这个键值查询...
Vue中的vxe-table教程24-高级表格-完整查询功能
weixin_42289273的博客
01-15 4405
效果图： 1. index.html代码 <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> <!-- 使用 cdn 引用方式需要注意是否锁定版本，默认指向最新版本 --> <!-- vue需引入--> <script src="htt
vxe-table中vxe-grid(高级表格)的使用
Gemini_Kanon的博客
02-28 2万+
vxe-table中vxe-grid(高级表格)的使用，列编辑下拉框渲染动态数据
vxe-table/vxe-grid 国际化的使用、支持多语言
最新发布
yangxiaoman123的博客
12-29 1097
背景：在vxe-table中，会有些组件自身带的文案需要做成国际化，比如表格下的分页、日期插件等。技术背景：vue3+TypeScript+vxe-table。
ExtJS入门教程(超级详细)
03-13
1、Ext类 ………………………………… 2 2...71、Ext.grid.GridView类 …………… 59 72、Ext.grid.GroupingView类 ………… 60 73、Ext.grid.EditorGridPanel类 ……… 62 74、Ext.grid.PropertyGrid类 …………… 65
Android 超级简单的Adapter.zip
07-10
在Android开发中，Adapter是一个非常重要的组件，它用于在数据集和UI视图之间建立桥梁，使得数据可以被适配并展示在ListView、GridView、RecyclerView等控件中。本资源"Android 超级简单的Adapter.zip"提供了一个...
超方便的C#编写 winform程序GridView打印功能
02-18
总之，"超方便的C#编写 Winform程序GridView打印功能"是针对Winform应用中常见需求的一种解决方案。它涉及数据操作、图形绘制、用户交互等多个方面，通过自定义代码实现了在.NET Framework 2.0环境下的GridView数据...
C#控件命名规范汇总(超详细)
12-25
类 型 前 缀 示 例 Adrotator adrt adrtTopAd BulletedList blst blstCity Button btn btnSubmit Calendar cal calMettingDates CheckBox chk chkBlue CheckBoxList ...HyperLink
vxe-table中vxe-grid的使用
热门推荐
成在坚持，贵在坚持
01-14 2万+
vxe-grid的使用 渲染表格的话，不可能所有的数据都是靠自己手动生成的，需要通过v-for渲染出来， v-for循环生成列 <template> <div> <vxe-table border="inner" highlight-hover-row highlight-current-row ref="xTable" height="300"
VXE 通用Grid 例子
℡メ㏑╭ァ小凯
10-13 6333
主要记录下，里面有尾部汇总+汇总后自动跟随列拖动。
Yii::GridView::widget 用法汇总
野生猴子
01-03 4650
[ 'label'=>'类型', 'value'=>function($data){ return \common\models\Services\SystemParamServices::getDescribeByCode($data->refund_type); } ], //自定义更多操作 ['class' => 'yii\grid
android中使用gridview显示文本内容
The Last Song 的专栏
04-12 7809
官方的demo和例子都是显示图片，这里我反过来把它当table用，显示最基本的数据信息 1、首先定义基本的layout信息 <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="horizontal" android:layout_width="fill
Android开发学习笔记：浅谈GridView
hao201011的专栏
12-01 2217
GridView(网格视图)是按照行列的方式来显示内容的，一般用于显示图片，图片等内容，比如实现九宫格图，用GridView是首选，也是最简单的。主要用于设置Adapter。 GridView常用的XML属性：   属性名称 描述 android:columnWidth 设置列的宽度。 android:gravity
gridview如何使用
05-16
GridView 是一个 Android 中常用的基于网格布局的控件，可以用于展示多个数据项。下面是一个 GridView 的使用示例： 1. 在布局文件中添加 GridView 控件： ```xml <GridView android:id="@+id/grid_view" android:layout_width="match_parent" android:layout_height="match_parent" android:numColumns="3" /> ``` 2. 在 Activity 中获取 GridView 控件，并设置 Adapter： ```java GridView gridView = findViewById(R.id.grid_view); gridView.setAdapter(new MyAdapter(this)); ``` 其中，MyAdapter 是自定义的 Adapter 类，需要继承自 BaseAdapter，并实现以下几个方法： ```java @Override public int getCount() { // 返回数据项数量 return mData.size(); } @Override public Object getItem(int position) { // 返回指定位置的数据项 return mData.get(position); } @Override public long getItemId(int position) { // 返回指定位置的数据项 ID return position; } @Override public View getView(int position, View convertView, ViewGroup parent) { // 创建或重用一个 View，并为其设置数据 View view = convertView; if (view == null) { view = LayoutInflater.from(mContext).inflate(R.layout.grid_item, parent, false); } TextView textView = view.findViewById(R.id.text_view); textView.setText(mData.get(position)); return view; } ``` 其中，mData 是要展示的数据，R.layout.grid_item 是每个数据项的布局文件，可以根据需要自定义。以上的示例中，每个数据项是一个 TextView，其文本内容为 mData 中对应位置的字符串。 3. 运行程序，即可看到 GridView 中展示了多个数据项。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值