weixin_33720078 2019-09-02 11:42 采纳率: 0%
浏览 36

在Select2输出中为groupBy

I'm using Select2 for dynamic drop-down search with Ajax, same "type" (column name) is not grouping.

type

Tried to group similar column using groupBy() but its retrieving only first row.

sametype

As you can see above it's fetching all data perfectly but not grouping.

Controller:

 $data = DB::table('vehitrans')
                ->select("id", "name", "type")
                ->where('name', 'LIKE', "%$search%")->orWhere('type','LIKE', "%$search%")
                ->groupBy('type')
                ->get();

Ajax:

 processResults: function (data) {
            return {
              results:  $.map(data, function (item) {
                    return {
                        text: item.type,
                        children: [{
                         text: item.name,
                         id:item.id,
                        }]
                    }
                })
            }
          }

I want all "name" should come under its respective "type" eg.

Vehicles
   Car
   Tractor
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 优质github账号直接兑换rmb,感兴趣伙伴可以私信
    • ¥15 错误(10048): “调用exui内部功能”库命令的参数“参数4”不能接受空数据。怎么解决啊
    • ¥15 安装svn网络有问题怎么办
    • ¥15 Python爬取指定微博话题下的内容,保存为txt
    • ¥15 vue2登录调用后端接口如何实现
    • ¥65 永磁型步进电机PID算法
    • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
    • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
    • ¥15 如何处理复杂数据表格的除法运算
    • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)