猿问

按值而不是键对 Laravel pluck() 进行排序?

我有一个表单,其中包含一些由 JSON 填充的选择元素。它看起来像下面这样。


{

    "suppliers":

        {"1":"Amazon","2":"Apple"},

    "manufacturers":

        {"1":"Apple","2":"Lenovo"},

    "categories":

        {"2":"Tablet","3":"Laptop","4":"Desktop"},

    "status":

        {"1":"Ready to Deploy","2":"Deployed","3":"Damaged","4":"Destroyed"}

}

如何按值(名称)而不是键(id)排序?我已经尝试了所有我能想到的方法,并且搜索了我能想到的每一个短语,但它仍然没有按照我需要的字母顺序排序。请注意,如果直接在浏览器中查看 JSON,下面的 orderBy 将以正确的顺序对其进行排序,但在表单中,我的选择元素仍然按键排序。


public function getFormData()

{

    $suppliers = DB::table('supplier')->orderBy('sup_name','asc')->pluck('sup_name','id');

    $manufacturers = DB::table('manufacturer')->orderBy('man_name','asc')->pluck('man_name','id');

    $categories = DB::table('category')->where('parent_id', 1)->orderBy('cat_name','asc')->pluck('cat_name', 'id');

    $status = DB::table('status')->orderBy('status','asc')->pluck('status', 'id');


    return json_encode(compact('suppliers', 'manufacturers', 'categories', 'status'));

}

编辑:


使用来自@Snapey 的以下语法,我能够获得正确的排序顺序


public function getFormData()

{

    $suppliers = DB::table('supplier')->orderBy('sup_name','asc')->get(['sup_name','id']);

    $manufacturers = DB::table('manufacturer')->orderBy('man_name','asc')->get(['man_name','id']);

    $categories = DB::table('category')->where('parent_id', 1)->orderBy('cat_name','asc')->get(['cat_name', 'id']);

    $status = DB::table('status')->orderBy('status','asc')->get(['status', 'id']);

    return json_encode(compact('suppliers', 'manufacturers', 'categories', 'status'));

}

新输出:


{

    "suppliers":

        [{"sup_name":"Amazon","id":1},{"sup_name":"Apple","id":2}],

    "manufacturers":

        [{"man_name":"Apple","id":1},{"man_name":"Lenovo","id":2}],

    "categories":

        [{"cat_name":"Desktop","id":4},{"cat_name":"Laptop","id":3},{"cat_name":"Tablet","id":2}],

    "status":

        [{"status":"Damaged","id":3},{"status":"Deployed","id":2},{"status":"Destroyed","id":4},{"status":"Ready to Deploy","id":1}]

}

不幸的是,现在我在我的选择元素中得到了“object Object”并且值被关闭了。

蛊毒传说
浏览 126回答 2
2回答

忽然笑

将 id 作为命名元素包含在内,而不是将其用作数组索引。例如;&nbsp;$suppliers = DB::table('supplier')->orderBy('sup_name','asc')->get(['sup_name','id']);然后在 json 中你将有一个id属性编辑:对于您的其他问题,例如$.each(data, function(key, value) {&nbsp;&nbsp; if(oldValue === value.id || newId === value.id){&nbsp;&nbsp; &nbsp; $elem.append('<option value="' + value.id + '" selected="selected">' + value.sup_name + '</option>');}else{&nbsp; &nbsp;$elem.append('<option value="' + value.id + '">' + value.sup_name + '</option>'); } });&nbsp;因为现在,数组中的每一项都是一个以 sup_name 和 id 作为属性的对象

米脂

以下将删除关键数字,只为您留下一个具有新顺序的数组:public function getFormData(){&nbsp; &nbsp; $suppliers = DB::table('supplier')->orderBy('sup_name','asc')->pluck('sup_name','id');&nbsp; &nbsp; $suppliers = array_values($suppliers);&nbsp; &nbsp; $manufacturers = DB::table('manufacturer')->orderBy('man_name','asc')->pluck('man_name','id');&nbsp; &nbsp; $manufacturers = array_values($manufacturers);&nbsp; &nbsp; $categories = DB::table('category')->where('parent_id', 1)->orderBy('cat_name','asc')->pluck('cat_name', 'id');&nbsp; &nbsp; $categories = array_values($categories);&nbsp; &nbsp; $status = DB::table('status')->orderBy('status','asc')->pluck('status', 'id');&nbsp; &nbsp; $status = array_values($status);&nbsp; &nbsp; return json_encode(compact('suppliers', 'manufacturers', 'categories', 'status'));}
随时随地看视频慕课网APP
我要回答