コード例 #1
0
	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)); 
		}
	}