在cakehp3中使用ajax通过控制器从模型中检索数据


Retrieve data from model via controller using ajax in cakephp 3

我正在使用cakehp3开发一个网站。我对此很陌生。我正在尝试从我的ItinerariesController中的函数getSelectedItineraryData()中检索数据。这是我的控制器代码:

public function getSelectedItineraryData()
    {
        $selected_itinerary = @$this->request->data('id');
        $locationdata = $this->Itineraries->find('locationdetails', [
            'selected_itinerary' => $selected_itinerary
        ]);
     return json_encode($locationdata);
    }

这使用了位于模型文件ItinerariesTable中的自定义查找器方法。

public function findLocationdetails(Query $query, array $options)
    {
        return $this->find()
            ->distinct(['Intineraries.id'])
            ->matching('Itineraries', function ($q) use ($options) {
                return $q->where(['Itineraries.name IN' => $options['selected_itinerary']]);
            });
    }

这是对控制器进行调用的ajax请求:

function getwypts(callback){
         $.ajax({
        url: "/Itineraries/getSelectedItineraryData/" + selected_i,
        type: "POST",
        data: {
        id: selected_i
        },
        //async: false,
        success: function(result, status) {
            var dayint = 1;
            alert(result);
            itins = JSON.parse(result);
            var day_arr = JSON.parse(itins.day_array);
            var json_day_list = JSON.parse(itins.json_day_data);
            $('#temp_dir_array').val(JSON.stringify(day_arr));
            $('#sel_id_name').text(itins.name);
            start_n = itins.start_name;
            end_n = itins.end_name;
            var tempp = JSON.parse(itins.day_array);
            waypt_obj.start = itins.start;
            waypt_obj.end = itins.end;
            waypt_obj.waypt = itins.arr_intin;
            for (dayint = 0; dayint < json_day_list.length; dayint++) {
                temp11 = tempp[dayint];
                $("#itin_list").append('<div id="itinerary_item_' + (dayint + 1) + '"  value="' + dayint + '"><a  href="#" style= "border: 2px solid red;list-style-position: inside; margin: 5px" class="list-group-item testing"><input type="hidden" id="viewport_wp_item" value="' + tempp[dayint][0] + '" ></input><div class="alert alert-success"><b>Day  ' + (dayint + 1) + ' of Trip (Overnight stay at ' + json_day_list[dayint].overnight + ')</b></div><div id="" class="alert alert-info"><b>Places Visited: ' + json_day_list[dayint].places + '</b><br>' + json_day_list[dayint].desc + '</div></a></div>');
            }
            if(callback) {
            callback();
            }
        }
    });
    }

我遇到的问题是,这个请求返回一个空结果。这似乎是因为自定义查找器方法没有返回正确的响应。我的控制器出了什么问题?还是错误来自其他地方?提前谢谢,我已经试了好几个小时了。

只需将其放在控制器上即可。希望你的问题能得到解决!

public function getSelectedItineraryData($ID)
{
    $selected_itinerary = $ID;
    $locationdata = $this->Itineraries->find('locationdetails', [
        'selected_itinerary' => $selected_itinerary
    ]);
 return json_encode($locationdata);
}