Cake php与Ext js通过在网格中显示数据问题

Question

我使用 extjs 网格视图创建 cakephp 。

为此，我创建了

1）一个我在其中编写的movie_controller控制器文件

function index() {
        $this->recursive = 0;                                      
        $this->set('movies', $this->Movie->find("all"));

    }

2）第二个在view/movies/index.ctp中创建index.ctp文件

 <?php echo  '{"rows":'.$javascript->Object($movies).'}'; ?>

3）然后在js文件中我调用这个index.ctp文件

而不是在网格中获取数据。 在 Firebug 中调试时，它显示此数组

{"rows":[{"Movie":{"id":"1","date_":"1970-01-01","notes":"Note13455-"," asset_id":"1","maint_picture":"","maint_condition1":"差","maint_condition2":"新","maint_condition3":"优秀","maint_condition4":"好"}},{"Movie":{"id":"2","date_":"2009-03-20","notes" :"注释2","asset_id":"1"," maint_picture":null,"maint_condition1":"优秀","maint_condition2":"优秀","maint_condition3":"新","maint_condition4":"差"}}]}

==>在此 json 文件中，我如何删除在开始所有记录中显示的电影数组。

Answer 1

<?php echo  '{"rows":'.$javascript->Object($movies['Movie']).'}'; ?>

Answer 2

如果想从数组中删除第一个数组，我们必须在网格中逐个打印数组。
完成了。

<?php
$output='{"rows":[';
$total=$ta=count($movies);
for($i=0;$i<$total;$i++)
{
$t=$i+1;
  if($t==$total)
  {
    $output.=$javascript->Object($movies[$i]['Movie']);
  }
  else
  {
    $output.=$javascript->Object($movies[$i]['Movie']).',';
  }
}
$output.=']}';

echo $output;
 ?>  

Answer 3

你越来越近了。尝试使用控制器中的 $movies 变量完成所有工作（记住 MVC 模式！不要破坏它！）。

您可以通过执行类似...

// in your controller
$data = null;
$movies = $this->Movie->find('all');

foreach ($movies as $key => $value) {
    foreach ($value['Movie'] as $k => $v {
        $data['rows'][$key][$k] = $v;
    }
}

然后将其转换为 json 对象来实现。

基本上我认为它没有加载数据，因为你的 json 看起来像这样

{"rows":[{"Movie":{"id":"1","date_":"1970-01-01","notes": "Note13455-","asset_id":"1","maint_picture":"","maint_condition1":"差","maint_condition2":"新","maint_condition3":"优秀","maint_condition4":"好"}},{"Movie":{"id":"2","date_":"2009-03-20","notes" :"注释2","asset_id":"1"," maint_picture":null,"maint_condition1":"优秀","maint_condition2":"优秀","maint_condition3":"新","maint_condition4":"差"}}]}

它应该看起来像这样

{
“行”：[{
“id”：“1”，
"date_":"1970-01-01",
"notes":"Note13455-",
"asset_id":"1",
“维护图片”：“”，
"maint_condition1":"差",
"maint_condition2":"新",
"maint_condition3":"优秀",
"maint_condition4":"好"
}, {
“id”：“2”，
"date_":"2009-03-20",
"notes":"注释2",
"asset_id":"1",
“维护图片”：空，
"maint_condition1":"优秀",
"maint_condition2":"优秀",
"maint_condition3":"新",
"maint_condition4":"差"
}
]}

您想要删除 "Movies": {..object..} 部分，因此它只是一个对象数组，例如 {id: 1},{id: 2}, {id: 3} 等。

确保您在 JsonReader 中将行设置为根！

var reader = new Ext.data.JsonReader({
    root: 'rows'
});