public function GetDataJson(){
$cv_id=$this->getRouter()->GetUrlParam('cvId');
$ds=$this->GetSets($cv_id);
echo '<pre>';
print_r($ds);
$data_json=json_encode($ds); 将结果集转化为json，
echo $data_json;
}
/*
* 返回查找结果的数据集，并且拼凑出自己想要的形式。
返回结果类型：
Array
(
[11] => Array
(
[cr_id] => 1
[v_id] => 1
[v_name] => 我爱我家
[v_link] => http://2
[is_part] => 0
[duration] => 5630
[begin_time] => Array
(
[1] => 2356666
[22] => 523642
)
)
[12] => Array
(
[cr_id] => 1
[v_id] => 2
[v_name] => 我爱我家
[v_link] => http://3
[is_part] => 0
[duration] => 5638
[begin_time] => Array
(
[23] => 1256
)
)
)
*/
protected function GeSets($cv_id) {
include_once 'Model/ZjCarouselVideo.php';
include_once 'Model/ZjlCarouselEpg.php';
$criteria_carousel_video = new ZjCarouselVideoCriteria();
$criteria_carousel_epg = new ZjCarouselEpgCriteria();
$criteria_carousel_video->cr_id_Equals =$cv_id;
$carousel_video = $this->Phreezer->Query("ZjCarouselVideo",$criteria_carousel_video);
$carousel_video = $carousel_video->ToObjectArray(true,$this->SimpleObjectParams());
foreach($carousel_video as $key => $val){
foreach($val as $k =>$v){
if ($k=='id') continue;
$re_cv[$val->id][$k]=$v;
}
}
foreach($re_cv as $key => $val){
$criteria_carousel_epg->cr_id_Equals=$val['cr_id'];
$criteria_carousel_epg->v_id_Equals=$val['v_id'];
$carousel_video_epg=$this->Phreezer->Query('ZjCarouselEpg',$criteria_carousel_epg);
$carousel_video_epg=$carousel_video_epg->ToObjectArray(true,$this->SimpleObjectParams());
$i=0;
foreach ($carousel_video_epg as $key => $val){
$epg_info['cr_id']=$val->cr_id;
$epg_info['v_id']=$val->v_id;
$epg_info[$i]['cr_epg_id']=$val->cr_epg_id;
$epg_info[$i]['begin_time']=$val->begin_time;
$i++;
}
$cr_epg[]=$epg_info;
$criteria_carousel_epg=new ZjCarouselEpgCriteria();
$epg_info=array();
}
foreach ($re_cv as $k_video => $v_video){
foreach ($cr_epg as $k_epg=>$v_epg){
if($v_epg['cr_id']==$v_video['cr_id']&&$v_epg['v_id']==$v_video['v_id']){
array_shift($v_epg);
array_shift($v_epg);
foreach ($v_epg as $v_k=>$v_info){
$v_video['begin_time'][$v_info['cr_epg_id']]=$v_info['begin_time'];
}
}
$re_cv[$k_video]=$v_video;
}
}
return $re_cv;
}