带Laravel的neasted模型的快速加载问题

Question

任何想法为什么下面的代码是正常工作，返回设备与传感器和测量

public function getLastMinutes($device_id,$sensor_id,$minutes = 10) {
...
        $devices = Auth::user()->devices()->where("device_id",$device_id)->with(array('sensors.measurements' => function($query) use ($minutes,$sensor_id) {
            $date = new DateTime;
            $date->modify(-1*$minutes.' minutes');
            $formatted_date = $date->format('Y-m-d H:i:s');

            $query->where('measurements.created_at','>=',$formatted_date);

        }))->get()->toArray();
        return Response::json($devices);
...

但是，当我添加第二个where（“sensor_id”，$sensor_id）时，返回的json对象中的度量值消失了

public function getLastMinutes($device_id,$sensor_id,$minutes = 10) {
...
        $devices = Auth::user()->devices()->where("device_id",$device_id)->with(array('sensors.measurements' => function($query) use ($minutes,$sensor_id) {
            $date = new DateTime;
            $date->modify(-1*$minutes.' minutes');
            $formatted_date = $date->format('Y-m-d H:i:s');

            $query->where("sensor_id",$sensor_id)->where('measurements.created_at','>=',$formatted_date);

        }))->get()->toArray();
        return Response::json($devices);
...

我遗漏了什么？

谢谢你的帮助！

Answer 1

我解决了这个问题。通过在对象查询中使用（数组（'sensors.measures…）执行，您无法访问传感器…这意味着通过执行此$query-

所以从这个（错）

    public function getLastMinutes($device_id,$sensor_id,$minutes = 10) {
...
        $devices = Auth::user()->devices()->where("device_id",$device_id)->with(array('sensors.measurements' => function($query) use ($minutes,$sensor_id) {
            $date = new DateTime;
            $date->modify(-1*$minutes.' minutes');
            $formatted_date = $date->format('Y-m-d H:i:s');

            $query->where("sensor_id",$sensor_id)->where('measurements.created_at','>=',$formatted_date);

        }))->get()->toArray();
        return Response::json($devices);
...

到这个（正确）

...
$devices = Auth::user()->devices()->where("device_id",$device_id)
            ->with(array('sensors' => function($query) use ($sensor_id) {
                $query->where('sensors.sensor_id',$sensor_id);
            }))
            ->with(array('sensors.measurements' => function($query) use ($minutes,$sensor_id) {
                $date = new DateTime;
                $date->modify(-1*$minutes.' minutes');
                $formatted_date = $date->format('Y-m-d H:i:s');
                $query->where('measurements.created_at','>=',$formatted_date);
            }))
            ->get()->toArray();
            return Response::json($devices);
...

小提示。laravel-dedegbar是一个伟大的项目，你应该去看看，但它实际上并没有帮到我，因为我有一个SPA，Laravel正在做一个RESTFUL json服务器，出于某种原因laravel-degbar没有启动...但是这个小这段代码非常棒（摘自在Laravel 3/4中执行查询）

        $queries = DB::getQueryLog();
        $last_query = end($queries);
        return Response::json($last_query);

希望能帮助你