function getElements($kat_id, $knoten_arr, $KAT_ID, $ID, $mod, $modus, $base_file) { include 'db_connect1.php'; include 'global_config.php'; //include 'functions/ajax_functions.php'; $result10 = mysql_query("SELECT * FROM {$table4} WHERE parent='{$kat_id}' ORDER BY kategorie"); $num10 = mysql_num_rows($result10); for ($i10 = 0; $i10 < $num10; $i10++) { $kategorie = mysql_result($result10, $i10, 'kategorie'); $parent = mysql_result($result10, $i10, 'parent'); $level = mysql_result($result10, $i10, 'level'); $kat_id = mysql_result($result10, $i10, 'kat_id'); $space = ''; for ($N = 0; $N < $level; $N++) { $space .= "   "; } $kat_id_pos = array_search($kat_id, $knoten_arr); $kat_id_back = $knoten_arr[$kat_id_pos - 1]; if (in_array($kat_id, $knoten_arr)) { $img = "<IMG src='../../share/images/minus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='{$ziel}?kat_id={$kat_id_back}&mod={$mod}&pic_id=0'>" . $img . "</a> "; echo "<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\")'>" . $kategorie . "</SPAN>"; echo "\n\t\t\t\t\t</TD>\n\t\t\t\t\t</TR>"; getElements($kat_id, $knoten_arr, $KAT_ID, $ID, $mod, $modus, $base_file); } else { $img = "<IMG src='../../share/images/plus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='{$ziel}?kat_id={$kat_id}&mod={$mod}&pic_id=0'>" . $img . "</a> "; echo "<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\")'>" . $kategorie . "</SPAN>"; echo "\n\t\t\t\t\t</TD>\n\t\t\t\t\t</TR>"; } } }
function getHrefByDom($arr, $url) { $htmDoc = new DOMDocument(); $htmDoc->loadHTMLFile($url); $len = count($arr); foreach ($arr as $value) { $htmDoc = getElements($htmDoc, $value); } return $htmDoc; }
function getElements($kat_id, $knoten_arr, $KAT_ID, $ID, $mod, $modus, $base_file, $bewertung) { global $ziel; include 'global_config.php'; include $sr . '/bin/share/db_connect1.php'; include $sr . '/bin/share/global_config.php'; $sel_one = "<IMG src='{$inst_path}/pic2base/bin/share/images/one.gif' width='22' height='11' hspace='0' vspace='0' border='0' title='einzelne Bilder dieser Kategorie auswählen'>"; $sel_all = "<IMG src='{$inst_path}/pic2base/bin/share/images/all.gif' width='22' height='11' hspace='0' vspace='0' border='0' title='alle Bilder dieser Kategorie auswählen'>"; $result10 = mysql_query("SELECT * FROM {$table4} WHERE parent='{$kat_id}' ORDER BY kategorie"); $num10 = mysql_num_rows($result10); for ($i10 = 0; $i10 < $num10; $i10++) { $kategorie = mysql_result($result10, $i10, 'kategorie'); $parent = mysql_result($result10, $i10, 'parent'); $level = mysql_result($result10, $i10, 'level'); $kat_id = mysql_result($result10, $i10, 'kat_id'); $space = ''; for ($N = 0; $N < $level; $N++) { $space .= "  "; } $result13 = mysql_query("SELECT * FROM {$table11} WHERE kat_id = '{$kat_id}' AND info <> ''"); $num13 = mysql_num_rows($result13); if ($num13 !== 0) { $font_color = 'blue'; } else { $font_color = 'black'; } $kat_id_pos = array_search($kat_id, $knoten_arr); if ($kat_id_pos > 0) { $kat_id_back = $knoten_arr[$kat_id_pos - 1]; } if (in_array($kat_id, $knoten_arr)) { $img = "<IMG src='{$inst_path}/pic2base/bin/share/images/minus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='{$ziel}?kat_id={$parent}&mod={$mod}&pic_id=0'>" . $img . "</a> "; echo "<span style='cursor:pointer; color:{$font_color}' onClick=\"showKatInfo('{$kat_id}')\" title='Informationen zur Kategorie {$kategorie}' alt='Info' />" . $kategorie . "</span></TD>"; if ($base_file == 'edit_remove_kat' or $base_file == 'recherche2' or $base_file == 'edit_bewertung') { $sel_one = "<img src='{$inst_path}/pic2base/bin/share/images/ok.gif' width='15' height='15' />"; $sel_all = ' '; } echo "\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",0,0,0)'>" . $sel_one . "</SPAN></TD>\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",1,0,0)'>" . $sel_all . "</SPAN>\n\t\t\t\t\t</TD>\n\t\t\t\t\t<TD></TD>\n\t\t\t\t\t</TR>"; getElements($kat_id, $knoten_arr, $KAT_ID, $ID, $mod, $modus, $base_file, $bewertung); } else { $img = "<IMG src='{$inst_path}/pic2base/bin/share/images/plus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='{$ziel}?kat_id={$kat_id}&mod={$mod}&pic_id=0'>" . $img . "</a> "; echo "<span style='cursor:pointer; color:{$font_color}' onClick=\"showKatInfo('{$kat_id}')\" title='Informationen zur Kategorie {$kategorie}' alt='Info' />" . $kategorie . "</span></TD>"; if ($base_file == 'edit_remove_kat' or $base_file == 'recherche2' or $base_file == 'edit_bewertung') { $sel_one = "<img src='{$inst_path}/pic2base/bin/share/images/ok.gif' width='15' height='15' />"; $sel_all = ' '; } echo "\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",0,0,0)'>" . $sel_one . "</SPAN></TD>\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",1,0,0)'>" . $sel_all . "</SPAN>\n\t\t\t\t\t</TD>\n\t\t\t\t\t<TD style='font-size:12px;text-align:right;'>" . getNumberOfPictures($kat_id, $modus, $bewertung) . "</TD>\n\t\t\t\t\t</TR>"; } } }
function getElements($kat_id, $knoten_arr, $KAT_ID) { include '../../share/db_connect1.php'; include '../../share/global_config.php'; $result10 = mysql_query("SELECT * FROM {$table4} WHERE parent='{$kat_id}' ORDER BY kategorie"); $num10 = mysql_num_rows($result10); for ($i10 = 0; $i10 < $num10; $i10++) { $kategorie = mysql_result($result10, $i10, 'kategorie'); $parent = mysql_result($result10, $i10, 'parent'); $level = mysql_result($result10, $i10, 'level'); $kat_id = mysql_result($result10, $i10, 'kat_id'); $space = ''; for ($N = 0; $N < $level; $N++) { $space .= "   "; } $kat_id_pos = array_search($kat_id, $knoten_arr); if ($kat_id_pos > 0) { $kat_id_back = $knoten_arr[$kat_id_pos - 1]; } if (in_array($kat_id, $knoten_arr)) { //echo $kat_id_back; $img = "<IMG src='../../share/images/minus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat3'>\n\t\t\t\t\t" . $space . "<a href='kategorie0.php?kat_id={$kat_id_back}'>" . $img . "</a> \n\t\t\t\t\t<a href='kat_add.php?kat_id={$KAT_ID}&level={$level}&ID={$kat_id}' title='Neue Unterkategorie einfügen' id='std'>" . $kategorie . "</a>\n\t\t\t\t\t</TD>\n\t\t\t\t\t\n\t\t\t\t\t<TD id='kat2'><a href='kat_edit.php?kat_id={$KAT_ID}&ID={$kat_id}' title='Kategorie bearbeiten'><img src='../../share/images/edit.gif' style='border:none;' width='11' height='11' hspace='0' vspace='0' border='0' alt='Edit-Icon'></a>\n\t\t\t\t\t</TD>"; if ($kat_id !== '1') { echo "\n\t\t\t\t\t\t<TD id='kat2'><a href='kat_delete.php?kat_id={$kat_id}&ID={$kat_id}' title='Kategorie löschen'><img src=\"../../share/images/delete.gif\" width=\"11\" height=\"11\" hspace=\"0\" vspace=\"0\" border=\"0\" alt='Delete-Icon' /></a>\n\t\t\t\t\t\t</TD>"; } else { echo "<TD id='kat2'><BR></TD>"; } echo "\n\t\t\t\t\t\n\t\t\t\t\t</TR>"; getElements($kat_id, $knoten_arr, $KAT_ID); } else { $img = "<IMG src='../../share/images/plus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat3'>\n\t\t\t\t\t" . $space . "<a href='kategorie0.php?kat_id={$kat_id}'>" . $img . "</a> \n\t\t\t\t\t<a href='kat_add.php?kat_id={$KAT_ID}&level={$level}&ID={$kat_id}' title='Neue Unterkategorie einfügen' id='std'>" . $kategorie . "</a>\n\t\t\t\t\t</TD>\n\t\t\t\t\t\n\t\t\t\t\t<TD id='kat2'><a href='kat_edit.php?kat_id={$KAT_ID}&ID={$kat_id}' title='Kategorie bearbeiten'><img src='../../share/images/edit.gif' style='border:none;' width='11' height='11' hspace='0' vspace='0' border='0' alt='Edit-Icon'></a>\n\t\t\t\t\t</TD>"; if ($kat_id !== '1') { echo "\n\t\t\t\t\t\t<TD id='kat2'><a href='kat_delete.php?kat_id={$kat_id}&ID={$kat_id}' title='Kategorie löschen'><img src=\"../../share/images/delete.gif\" width=\"11\" height=\"11\" hspace=\"0\" vspace=\"0\" border=\"0\" alt='Delete-Icon' /></a>\n\t\t\t\t\t\t</TD>"; } else { echo "<TD id='kat2'><BR></TD>"; } echo "\n\t\t\t\t\t\n\t\t\t\t\t</TR>"; } } }
function getElements($kat_id, $knoten_arr, $KAT_ID, $ID) { include '../../share/db_connect1.php'; include '../../share/global_config.php'; $result10 = mysql_query("SELECT * FROM {$table4} WHERE parent='{$kat_id}' ORDER BY kategorie"); $num10 = mysql_num_rows($result10); for ($i10 = 0; $i10 < $num10; $i10++) { $kategorie = mysql_result($result10, $i10, 'kategorie'); $parent = mysql_result($result10, $i10, 'parent'); $level = mysql_result($result10, $i10, 'level'); $kat_id = mysql_result($result10, $i10, 'kat_id'); $space = ''; for ($N = 0; $N < $level; $N++) { $space .= "   "; } $kat_id_pos = array_search($kat_id, $knoten_arr); if ($kat_id_pos > 0) { $kat_id_back = $knoten_arr[$kat_id_pos - 1]; } //echo "Kat-ID: ".$kat_id.", ID: ".$ID.", Font_Color: ".setFontColor($ID, $kat_id)."<BR>"; if (in_array($kat_id, $knoten_arr)) { //echo $kat_id_back; $img = "<IMG src='../../share/images/minus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='kategorie0.php?kat_id={$kat_id_back}'>" . $img . "</a>  <font color=" . setFontColor($ID, $kat_id) . ">" . $kategorie . "</font>\n\t\t\t\t\t</TD>\n\t\t\t\t\t<TD id='kat2'></TD>\n\t\t\t\t\t</TR>"; getElements($kat_id, $knoten_arr, $KAT_ID, $ID); } else { $img = "<IMG src='../../share/images/plus.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='kategorie0.php?kat_id={$kat_id}'>" . $img . "</a>  <font color=" . setFontColor($ID, $kat_id) . ">" . $kategorie . "</font>\n\t\t\t\t\t</TD>\n\t\t\t\t\t<TD id='kat2'></TD>\n\t\t\t\t\t</TR>"; } } }
function getElements($kat_id, $knoten_arr, $KAT_ID, $ID, $mod, $modus, $base_file, $bewertung) { global $ziel; include 'global_config.php'; include $sr . '/bin/share/db_connect1.php'; include $sr . '/bin/share/global_config.php'; $sel_one = "<IMG src='{$inst_path}/pic2base/bin/share/images/one.gif' width='22' height='11' hspace='0' vspace='0' border='0' title='einzelne Bilder dieser Kategorie auswählen'>"; $sel_all = "<IMG src='{$inst_path}/pic2base/bin/share/images/all.gif' width='22' height='11' hspace='0' vspace='0' border='0' title='alle Bilder dieser Kategorie auswählen'>"; $result10 = mysql_query("SELECT * FROM {$table4} WHERE parent='{$kat_id}' ORDER BY kategorie"); $num10 = mysql_num_rows($result10); for ($i10 = 0; $i10 < $num10; $i10++) { $kategorie = mysql_result($result10, $i10, 'kategorie'); $parent = mysql_result($result10, $i10, 'parent'); $level = mysql_result($result10, $i10, 'level'); $kat_id = mysql_result($result10, $i10, 'kat_id'); $space = ''; for ($N = 0; $N < $level; $N++) { $space .= "  "; } //zu welchen Kategorien gibt es Lexikon-Eintraege? $result13 = mysql_query("SELECT * FROM {$table11} WHERE kat_id = '{$kat_id}' AND info <> ''"); $num13 = mysql_num_rows($result13); if ($num13 !== 0) { $book = "<img src='{$inst_path}/pic2base/bin/share/images/book_green.gif' width='15' height='15' title='Kategorie-Informationen lesen / bearbeiten' />"; } else { $book = "<img src='{$inst_path}/pic2base/bin/share/images/book_grey.gif' width='15' height='15' title='Kategorie-Informationen hinzufügen' />"; } $kat_id_pos = array_search($kat_id, $knoten_arr); if ($kat_id_pos > 0) { $kat_id_back = $knoten_arr[$kat_id_pos - 1]; } if (in_array($kat_id, $knoten_arr)) { $treestatus = 'minus'; $img = "<IMG src='{$inst_path}/pic2base/bin/share/images/minus.gif' width='11' height='11' hspace='0' vspace='0' border='0' title='eine Ebene nach oben gehen'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='{$ziel}?kat_id={$parent}&mod={$mod}&pic_id=0'>" . $img . "</a> "; if ($base_file == 'edit_remove_kat' or $base_file == 'recherche2' or $base_file == 'edit_bewertung') { echo "<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",0,0,0,\"{$treestatus}\")' title='Hier klicken, um alle Bilder der Kategorie {$kategorie} anzuzeigen'>" . $kategorie . "</span></TD>"; $sel_one = $book; echo "\n\t\t\t\t\t<TD>\n\t\t\t\t\t<span style='cursor:pointer;' onClick='showKatInfo(\"{$kat_id}\")'>" . $sel_one . "</SPAN></TD>\n\t\t\t\t\t<TD></TD>\n\t\t\t\t\t<TD></TD>\n\t\t\t\t\t</TR>"; } else { echo "<span style='cursor:pointer;' onClick=\"showKatInfo('{$kat_id}')\" title='Informationen zur Kategorie {$kategorie}' alt='Info' />" . $kategorie . "</span></TD>"; echo "\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",0,0,0,\"{$treestatus}\")'>" . $sel_one . "</SPAN></TD>\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",1,0,0,\"{$treestatus}\")'>" . $sel_all . "</SPAN></TD>\n\t\t\t\t\t<TD></TD>\n\t\t\t\t\t</TR>"; } getElements($kat_id, $knoten_arr, $KAT_ID, $ID, $mod, $modus, $base_file, $bewertung); } else { $treestatus = 'plus'; //Das plus wird nur gezeigt, wenn es weitere Unterkategorien gibt: $result11 = mysql_query("SELECT * FROM {$table4} WHERE parent = '{$kat_id}'"); $num11 = mysql_num_rows($result11); if ($num11 > 0) { $img = "<IMG src='{$inst_path}/pic2base/bin/share/images/plus.gif' width='11' height='11' hspace='0' vspace='0' border='0' title='Unterkategorien anzeigen'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "<a href='{$ziel}?kat_id={$kat_id}&mod={$mod}&pic_id=0'>" . $img . "</a> "; } else { $img = "<IMG src='{$inst_path}/pic2base/bin/share/images/platzhalter.gif' width='11' height='11' hspace='0' vspace='0' border='0'>"; echo "<TR id='kat'>\n\t\t\t\t\t<TD id='kat1'>\n\t\t\t\t\t" . $space . "" . $img . " "; } if ($base_file == 'edit_remove_kat' or $base_file == 'recherche2' or $base_file == 'edit_bewertung') { echo "<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",0,0,0,\"{$treestatus}\")' title='Hier klicken, um alle Bilder der Kategorie {$kategorie} anzuzeigen'>" . $kategorie . "</span></TD>"; $sel_one = $book; echo "\n\t\t\t\t\t<TD>\n\t\t\t\t\t<span style='cursor:pointer;' onClick='showKatInfo(\"{$kat_id}\")'>" . $sel_one . "</SPAN></TD>\n\t\t\t\t\t<TD></TD>\n\t\t\t\t\t<TD style='font-size:12px;text-align:right;'>" . getNumberOfPictures($kat_id, $modus, $bewertung, $treestatus) . "</TD>\n\t\t\t\t\t</TR>"; } else { echo "<span style='cursor:pointer;' onClick=\"showKatInfo('{$kat_id}')\" title='Informationen zur Kategorie {$kategorie}' alt='Info' />" . $kategorie . "</span></TD>"; echo "\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",0,0,0,\"{$treestatus}\")'>" . $sel_one . "</SPAN></TD>\n\t\t\t\t\t<TD>\n\t\t\t\t\t<SPAN style='cursor:pointer;' onClick='getPreview(\"{$KAT_ID}\",\"{$kat_id}\",\"{$mod}\",0,\"{$modus}\",\"{$base_file}\",\"{$bewertung}\",1,0,0,\"{$treestatus}\")'>" . $sel_all . "</SPAN></TD>\n\t\t\t\t\t<TD style='font-size:12px;text-align:right;'>" . getNumberOfPictures($kat_id, $modus, $bewertung, $treestatus) . "</TD>\n\t\t\t\t\t</TR>"; } } } }
function getcategories($filename, $request) { $dom = new DOMDocument(); $dom->load($filename); $cats = $dom->getElementsByTagName('cat'); $html = "<ul id=\"categories\">\n"; for ($i = 0; $i < $cats->length; $i++) { $cat = $cats->item($i); $catval = $cat->getAttribute('value'); $catkey = stripspace($catval); $selected = $catkey == $request[0] ? ' active' : ''; $html .= "\t" . '<li class="apiheading' . $selected . '"><h2><a id="' . $i . '" href="/' . $catkey . '">' . $catval . "</a></h2>\n"; $html .= "\t" . '<ul class="subcategories">' . "\n"; $subcats = $cat->getElementsByTagName('subcat'); for ($j = 0; $j < $subcats->length; $j++) { $subcat = $subcats->item($j); $subcatval = $subcat->getAttribute('value'); $subcatkey = stripspace($subcatval); list($fn_html, $fn_selected) = getElements($catval, $subcat, $request, 'function'); list($sel_html, $sel_selected) = getElements($catval, $subcat, $request, 'selector'); list($prop_html, $prop_selected) = getElements($catval, $subcat, $request, 'property'); $selected = $subcatkey == $request[1] || $fn_selected || $sel_selected || $prop_selected ? ' class="active"' : ''; $html .= "\t\t" . '<li id="subcategory' . $j . '"' . $selected . '><a href="/' . $catkey . '/' . $subcatkey . '">' . $subcatval . "</a>\n"; $html .= "\t\t" . '<ul class="functions">' . "\n"; $html .= $fn_html; $html .= $sel_html; $html .= $prop_html; $html .= "\t\t</ul></li>\n"; } $html .= "\t</ul></li>\n"; } return $html; }
<?php $parse_uri = explode('wp-content', $_SERVER['SCRIPT_FILENAME']); require_once $parse_uri[0] . 'wp-load.php'; if ( isset($_POST['id_proyecto']) && isset($_POST['filtro']) ) { $tipo = $_POST['filtro']; $id_proyecto = $_POST['id_proyecto']; $term = null; $elements = null; $fields = array(); $term = getProyecto($id_proyecto); $elements = getElements($term[0]); foreach ($elements as $key => $element) { if( $tipo == 'todas') { $field = null; $field['name'] = $element->name; $field['estado'] = getElementField($element, 'obra_estado', true); $field['cabezote'] = getElementField($element, 'obra_cabezote'); $geolocalizacion = getElementField($element, 'obra_geolocalizacion'); $field['latitud'] = $geolocalizacion['lat']; $field['longitud'] = $geolocalizacion['lng']; $field['avance'] = getElementField($element, 'obra_avance');