首页 > 解决方案 > 如何发送json以使用jquery查看?

问题描述

我对 jquery 真的很陌生,我需要一种将数据从我的控制器传递到我的视图的方法。我通过控制器从 json 数据库中获取数据,数据显示在控制台中,我唯一缺少的是在视图中显示它(在列表或表格中)。

路线:

Route::get('wdays/{task_id}', ['uses' => 'WorkdayController@index', 'as' => 'wday.index']);

控制器:

public function index($task_id)
{
    $sum = "(select sum(hours) from work_days where work_days.task_id = taskID) as sumHours";

    $wdays = DB::table('work_days')
        ->leftJoin('tasks', 'tasks.id', '=', 'work_days.task_id')
        ->where('work_days.task_id', '=', $task_id)
        ->where('work_days.status', '=', 0)
        ->select(DB::raw("work_days.wday_id as id,
        work_days.description as description,
        work_days.hours as hours,
        work_days.week as week,
        work_days.task_id as taskID,
        $sum
        "))
        ->get();

    return ['wdays' => $wdays];

} 

jQuery:

    $.getJSON('wdays/' + data.id, function (wdays) {

        $(wdays).each(function (key, value) {

            console.log(value);

        });

    });

这是我从 console.log 得到的:

{wdays: Array(1)}
        wdays: Array(1)
            0:
                description: "test"
                hours: "1.0000"
                id: 2338
                sumHours: "1.0000"
                taskID: 1881
                week: "2019-01-01"
            __proto__: Object
            length: 1
        __proto__: Array(0)
    __proto__: Object

谢谢!

标签: jqueryjsondatabaselaravel

解决方案


推荐阅读