PHP-Code:
$sorte = array("a.name","a.zusatz1","a.certificated","a.email","a.bookingdate","a.paid","a.zusatz2","a.zusatz3","a.zusatz4","a.zusatz5","a.zusatz6","a.zusatz7","a.zusatz8",);
$richt = array(" ASC"," DESC");
// get the total number of records
$database->setQuery( "SELECT count(*) FROM #__sembookings AS a"
. (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
);
$total = $database->loadResult();
if( $total<=$limitstart ) {
$limitstart = $limitstart - $limit;
}
if( $limitstart < 0) {
$limitstart = 0;
}
$ttlimit = "";
if($limit > 0) {
$ttlimit = "\nLIMIT $limitstart, $limit";
}
$pageNav = new JPagination( $total, $limitstart, $limit );
$database->setQuery( "SELECT a.*"
. "\nFROM #__sembookings AS a"
. "\nLEFT JOIN #__users AS u ON u.id = a.checked_out"
. (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
. "\nORDER BY " . $sorte[$ordid] . $richt[$ricid]
. $ttlimit
);
$rows = $database->loadObjectList();
// get list of categories
$kategorien[] = JHTML::_('select.option', '0', JTEXT::_('SEM_0027') );
$database->setQuery( "SELECT id AS value, title AS text FROM #__categories WHERE section='com_seminar' ORDER BY ordering" );
$kategorien = array_merge( $kategorien, $database->loadObjectList() );
$clistt = JHTML::_('select.genericlist', $kategorien, 'katid', 'class="inputbox" size="1" onchange="document.adminForm.limitstart.value=0;document.adminForm.submit();"',
'value', 'text', $katid );
$sortierung[] = JHTML::_('select.option', '0', JTEXT::_('SEM_0059') );
$sortierung[] = JHTML::_('select.option', '1', JTEXT::_('SEM_2023') );
$sortierung[] = JHTML::_('select.option', '2', JTEXT::_('SEM_0097') );
$sortierung[] = JHTML::_('select.option', '3', JTEXT::_('SEM_0052') );
$sortierung[] = JHTML::_('select.option', '4', JTEXT::_('SEM_0032') );
$sortierung[] = JHTML::_('select.option', '5', JTEXT::_('SEM_0065') );
$sortierung[] = JHTML::_('select.option', '6', JTEXT::_('SEM_2024') );
$sortierung[] = JHTML::_('select.option', '7', JTEXT::_('SEM_2025') );
$sortierung[] = JHTML::_('select.option', '8', JTEXT::_('SEM_2026') );
$sortierung[] = JHTML::_('select.option', '9', JTEXT::_('SEM_2027') );
$sortierung[] = JHTML::_('select.option', '10', JTEXT::_('SEM_2028') );
$sortierung[] = JHTML::_('select.option', '11', JTEXT::_('SEM_2029') );
$sortierung[] = JHTML::_('select.option', '12', JTEXT::_('SEM_2030') );
$olistt = JHTML::_('select.genericlist', $sortierung, 'ordid', 'class="inputbox" size="1" onchange="document.adminForm.limitstart.value=0;document.adminForm.submit();"',
'value', 'text', $ordid );
$richtung[] = JHTML::_('select.option', '0', JTEXT::_('SEM_2004') );
$richtung[] = JHTML::_('select.option', '1', JTEXT::_('SEM_2005') );
$rlistt = JHTML::_('select.genericlist', $richtung, 'ricid', 'class="inputbox" size="1" onchange="document.adminForm.limitstart.value=0;document.adminForm.submit();"',
'value', 'text', $ricid );
Lesezeichen