<p>
<br />
<?php
if(!user_access('toponimo admin')){
drupal_access_denied();
exit;
}
if(isset($_GET['ekin'])){
// doit();
$output .= '<p>Katastroko lekukotasunak inportatu dira.</p>';
} else {
print '<p>Katastroko lekukotasunak jaso: '.l('ekin', $_GET['q'], array('query' => 'ekin=1')).'</p>';
}
function doit(){
$tree = taxonomy_get_tree(6);
foreach($tree as $term){
$elementu[$term->name] = $term->tid;
}
$node = node_load(arg(1));
$file = array_pop($node->files);
$src = file_get_contents($file->filepath);
$rows = explode("\n", $src);
// $rows = array_slice($rows, 0, 100);
foreach($rows as $row){
$f = explode("\t", $row);
$objektu = isset($elementu[$f[5]]) ? $elementu[$f[5]] : $f[5];
$parent_node = db_fetch_object(db_query('SELECT nid, vid FROM content_type_partzela WHERE field_ref_value = "%s"', $f[0]));
// db_query('INSERT INTO topo_katastro_lekukotasun (id, ref, letra, iturri, aldaera, elementu, ohar, berriemale, urte, nid) VALUES (%d, "%s", "%s", "%s", "%s", "%s", "%s", "%s", "%s", %d)', $f[1], $f[0], $f[2], $f[3], $f[4], $f[5], $f[6], $f[7], $f[8], $parent_node->nid);
$children[$parent_node->nid][] = $f[1];
}
foreach($children as $k => $v){
foreach($v as $kk => $vv){
db_query('REPLACE INTO content_field_lekukotasun(vid, nid, delta, field_lekukotasun_value) VALUES(%d, %d, %d, %d)', $k, $k, $kk, $vv);
}
}
}
?></p>
