";
//CABECERA
$database->setQuery( "SELECT * FROM #__obrens WHERE id='$refid'");
$rows = $database->loadObjectList();
foreach($rows as $row1) {
echo "";
echo '| '.$row1->titulo.' | ';
echo '
';
echo "";
//Titulo
echo "| ".LIT_TITULO.": | ";
echo "$row1->titulo | ";
//Autor
echo " ";
echo "| ".LIT_AUTOR.": | ";
echo "$row1->autor | ";
echo " ";
}
$cadena = '';
echo "";
echo "
Partitura: |
";
//Partitura pdf
$cadena = $obrens_rutafich . $refid . $obrens_nomfich . $refid . $obrens_extpdf;
if (file_exists($rutalocal . $cadena)) {
echo "";
echo " ";
echo LIT_PARTITURA.$obrens_extpdf;
echo ' (en formato PDF)';
echo ' | ';
echo " | ";
}
//Partitura mus
$cadena = '';
$cadena = $obrens_rutafich . $refid . $obrens_nomfich . $refid . $obrens_extmus;
if (file_exists($rutalocal . $cadena)) {
echo "";
echo " ";
echo LIT_PARTITURA.'.mus';
echo ' (en formato MUS)';
echo ' | ';
echo " | ";
}
// Partitura mid
$cadena = '';
//Hallamos el numero de columnas que vamos a tener
$database->setQuery( "SELECT count(id) as ncol FROM #__obrens_cab_detalles WHERE idobra='$refid'");
$row = NULL;
$database->loadObject( $row );
$arrTablaEnt = darDetallesObra($refid, $row->ncol);
$arrTabla = $arrTablaEnt[1];
$cadena = trim($arrTabla[0][0]);
if ($cadena != '') {
echo " ";
echo $cadena;
echo " (en formato MIDI)";
echo ' | ';
}
echo "";
echo ('
');
//DETALLES
//Rellenamos el array con el contenido correspondiente si tiene contenido
if ($arrTablaEnt[0] != 0) {
//Dibujamos la tabla detalle
echo "
";
echo "
";
echo "Ficheros MIDI por cuerdas: ";
echo "";
for ($j = 0; $j < $row->ncol + 1; $j++) {
echo "";
for ($i = 0; $i < $row->ncol + 1; $i++) {
if ($j == 0) {
echo "| ".$arrTabla[$j][$i]." | ";
}
else {
if ($i == 0) {
echo "".$arrTabla[$j][$i]." | ";
}
else {
if ($arrTabla[$j][$i] != "")
echo "".$arrTabla[$j][$i]." | ";
else
echo "".$arrTabla[$j][$i]." | ";
}
}
}
echo " ";
}
echo (' ');
}
?>
setQuery( "SELECT * FROM #__categories WHERE section = 'com_obrens' AND published = '1' AND id='$catid'" );
$row = $database->loadObjectList();
foreach($row as $rows1) {
echo "$rows1->id $rows1->title
$rows1->description
";
}
echo "";
$line=1;
$database->setQuery("SELECT * FROM #__obrens WHERE published='1' AND catid='$catid' ORDER BY ordering, titulo");
$srows = $database->loadObjectList();
foreach($srows as $srow1) {
$linecolor = ($line % 2) + 1;
echo "
";
echo "
";
if ($artref_showpicture) echo " | ";
echo "";
echo "";
echo "$srow1->titulo";
echo "
$srow1->autor";
echo " | ";
echo " |
";
echo "
";
echo " | $srow1->beschreibung | ";
echo " ";
if ($artref_showbeschrlink) echo "» ".ARTREF_MEHR." ";
echo " | ";
echo " | ";
$line++;
}
echo " ";
echo "« "._BACK." ";
return;
}
//Einzelne Kategorie Inhalt Auflistung
function ShowCatList($Itemid, $vcatid, $artref_showphone, $artref_showmail, $artref_showwebsite, $artref_showstatus, $artref_showbeschrlink) {
global $mosConfig_dbprefix;
global $database, $stati, $vcatid, $startpage, $artref_refperside;
//Rodax
$art_perpage = 100;//$artref_refperside;
echo "";
$columnspan = $artref_showstatus + 2;
$database->setQuery( "SELECT c.*, COUNT(DISTINCT s1.id) AS num"
. "\nFROM #__categories AS c"
. "\nLEFT JOIN #__obrens AS s1 ON s1.catid = c.id"
. "\nWHERE c.section='com_obrens' AND c.published='1'"
. "\nGROUP BY c.id"
. "\nORDER BY c.ordering, c.title"
);
$rows = $database->loadObjectList();
foreach($rows as $row1) {
if($row1->id == $vcatid){
if ($row1->num > 0) {
echo "$row1->title
$row1->description";
# Feststellen der Anzahl der verfügbaren Datensätze
$database->setQuery("SELECT COUNT(id) AS amount FROM ".$mosConfig_dbprefix."artref WHERE catid = $vcatid");
$row = NULL;
$database->loadObject( $row );
$count = $row->amount;
# Berechnen der Gesamtseiten
$gesamtseiten = floor($count / $art_perpage);
$seitenrest = $count % $art_perpage;
if ($seitenrest>0) {
$gesamtseiten++;
}
# Feststellen der aktuellen Seite
if (isset($startpage)) {
if ($startpage>$gesamtseiten) {
$startpage = $gesamtseiten;
} else if ($startpage<1) {
$startpage = 1;
}
} else {
$startpage = 1;
}
echo "".ARTREF_EintrinListA." ".$count." ".ARTREF_EintrinListB."
";
echo " ";
# Limit und Seite Vor- & Rueckfunktionen
$start = ( $startpage - 1 ) * $art_perpage;
echo " | ";
$line=1;
// kopfteil
echo "";
#Liste befüllen
$database->setQuery("SELECT * FROM #__obrens WHERE published='1' AND catid='$row1->id' ORDER BY ordering, titulo LIMIT $start,$art_perpage");
$srows = $database->loadObjectList();
foreach($srows as $srow1) {
$linecolor = ($line % 2) + 1;
$AREF_titulo = "$srow1->titulo";
echo "";
echo "";
if($srow1->picture==""){
echo " ";
}else{
echo "";
}
echo " | ";
echo "";
if ($artref_showbeschrlink) {
echo "$AREF_titulo
$srow1->autor";
} else {
echo "$AREF_titulo
$srow1->autor";
}
echo " | ";
$i = $srow1->status;
if ($artref_showstatus) echo "".ARTREF_STATUS.":
$stati[$i] | ";
echo " ";
$line++;
}
}
}
}
echo " ";
echo "".ARTREF_Pages.": ";
# Ausgeben der Seite zurueck Funktion
$seiterueck = $startpage - 1;
if ($seiterueck>0) {
echo "« ";
}
#Ausgeben der einzelnen Seiten
for ($i=1; $i <= $gesamtseiten; $i++) {
if ($i==$startpage) {
echo "$i ";
} else {
echo "$i ";
}
}
# Ausgeben der Seite vorwärts Funktion
$seitevor = $startpage + 1;
if ($seitevor<=$gesamtseiten) {
echo "» ";
}
echo " ";
echo "
« "._BACK."";
return;
}
###################################################################################
#CUERPO
###################################################################################
# Estilo de vista
if ($obrens_verlista=="1" AND $func=="") $func = "list";
if ($obrens_verlista=="2" AND $func=="") $func = "cats";
# Cabecera
RefHeader($Itemid);
# Contenido
switch ($func) {
case 'viewcategory':
ShowCatList($Itemid, $catid, $artref_showphone, $artref_showmail, $artref_showwebsite, $artref_showstatus, $artref_showbeschrlink);
break;
case 'cats':
ShowCats($Itemid, $artref_showpicture);
break;
case 'list':
ShowList($obrens_vercabecera, $artref_showbeschrlink, $obrens_ordenlista);
break;
case 'fullview':
ShowObra($refid, $Itemid);
break;
default:
$database->setQuery( "SELECT c.*, COUNT(DISTINCT s1.id) AS num"
. "\nFROM #__categories AS c"
. "\nLEFT JOIN #__obrens AS s1 ON s1.catid = c.id"
. "\nWHERE c.section='com_obrens' AND c.published='1'"
. "\nGROUP BY c.id"
. "\nORDER BY c.ordering, c.titulo"
);
$rows = $database->loadObjectList();
foreach($rows as $row1) {
if ($row1->num > 0) {
echo "";
echo "$row1->title
$row1->description
| ";
$line=1;
$database->setQuery("SELECT * FROM #__obrens WHERE published='1' AND catid='$row1->id' ORDER BY ordering, titulo");
$srows = $database->loadObjectList();
foreach($srows as $srow1) {
$linecolor = ($line % 2) + 1;
echo "";
echo "";
if ($artref_showpicture) echo " | ";
echo "";
echo "";
echo "$srow1->partiturapdf";
echo "$srow1->titulo";
echo "
$srow1->autor";
echo " | ";
$i = $srow1->status;
if ($artref_showstatus) echo "$stati[$i]";
echo " |
";
echo "
";
if ($artref_showphone) echo "| ".LIT_PARTITURAMUS." | $srow1->partituramus | ";
# Show Email
if ($artref_showmail) {
echo "| ".LIT_NCOLFIL." | ";
if ($srow1->ncolfil) {
echo "$srow1->ncolfil";
} else {
echo "-";
}
echo " | ";
}
echo " ";
if ($artref_showbeschrlink) echo "» ".ARTREF_MEHR." ";
echo " |
";
echo " | ";
$line++;
}
echo " ";
}
}
break;
}
# Footer
if ($obrens_verfooter == "1")
RefFooter($ObrEns_version);
?> |
![](\"components/com_obrens/images/tynimam.jpg\")
Ensayo $ObrEns_version por Rodax Software S.L";
return;
}
# Dibujar Cabecera
function RefHeader($Itemid) {
global $database;
echo "
