saveMany()

public function agents_group(){ header('Access-Control-Allow-Origin:*'); $this->layout = ""; $this->autoRender = false; $agent_1 = $this->Agent->find('all', array('conditions' => array('or' => array('Agent.level=1', 'Agent.level=3')), 'recursive' => -1)); $sqlstr = ''; $sqlstr0 = ''; $update_data=array(); foreach ($agent_1 as $k => $v) { $agent_2 = $this->Agent->query("select GROUP_CONCAT(id SEPARATOR ',') as idlist,GROUP_CONCAT(realname SEPARATOR ',') as namelist from agents where father_id={$v['Agent']['id']}"); $ids = $v['Agent']['id']; $son_nams = $v['Agent']['realname']; if ($agent_2[0][0]['idlist']) { $ids = $agent_2[0][0]['idlist'] . ',' . $v['Agent']['id']; $son_nams = $agent_2[0][0]['namelist'] . ',' . $v['Agent']['realname']; //$sqlstr .= "update agents set sonids='{$ids}',son_nams='{$son_nams}' where id={$v['Agent']['id']};"; } else { //$sqlstr0 .= "update agents set sonids='{$ids}',son_nams='{$son_nams}' where id={$v['Agent']['id']};"; } $tmp_data=array( 'Agent' => array('id' =>$v['Agent']['id'], 'sonids' =>$ids,'son_nams'=>$son_nams)); } $r=$this->Agent->saveMany($update_data); var_dump($r); //$result = $this->Agent->query($sqlstr); //$result0 = $this->Agent->query($sqlstr0); //var_dump($result . '-agents_group-' . $result0 . $sqlstr0);}