function createEventMenu($data){ $data = json_decode(stripslashes($data)); if ($data->data){ $data = $data->data; $sql = "select group_id from user_group"; $this->setSQL($sql); $rs = $this->executeSQL(); $temp = Array(); while ($row = $rs->FetchNextObject()){ $insert_array = Array(); if (is_array($data)){ foreach($data as $field){ $insert_array['role_id'] = $field->id; $insert_array['group_id'] = $row->GROUP_ID; $temp[] = $insert_array; } }else{ $insert_array['role_id'] = $data->id; $insert_array['group_id'] = $row->GROUP_ID; $temp[] = $insert_array; } } $grid = new grid(true); $grid->setTable("role_menu_event_group"); $grid->addField( array( "field"=>"role_menu_event_id", "name"=>"role_menu_event_id", "primary"=>true ) ); $grid->addField( array( "field"=>"role_id", "name"=>"role_id" ) ); $grid->addField( array( "field"=>"group_id", "name"=>"group_id" ) ); $grid->doCreate(json_encode($temp)); } }