Hi,
ich habe jetzt schon mehrere Versuche gestrartet, aber bekamm leider nichts hin! Ich habe sogar die halloworld03 angeschaut, und nach dieser habe ich auch kein Erfolg! ??? ? :'( '(
view.html.php
Code:
function display($tpl = null) {
## If we want the add/edit form..
if($this->getLayout() == 'form') {
$this->_displayForm($tpl);
return;
}
global $mainframe, $option;
$db = JFactory::getDBO();
//DEVNOTE:give me ordering from request
$filter_order = $mainframe->getUserStateFromRequest( $context.'filter_order', 'filter_order', 'ordering' );
$filter_order_Dir = $mainframe->getUserStateFromRequest( $context.'filter_order_Dir', 'filter_order_Dir', '' );
//DEVNOTE:remember the actual order and column
$lists['order'] = $filter_order;
$lists['order_Dir'] = $filter_order_Dir;
## Making the query for getting the currency from the config table
$sql = 'SELECT currency, offdate FROM #__management_config WHERE id = 1';
$db->setQuery($sql);
$data = $db->loadObject();
## Model is defined in the controller
$model =& $this->getModel();
## Getting the items into a variable
$items =& $this->get('list');
## Getting the pagination thing :-)
$pagination = $this->get( 'Pagination' );
$this->assignRef('items', $items);
$this->assignRef( 'pagination' , $pagination);
$this->assignRef('items', $items);
$this->assignRef('data', $data);
parent::display($tpl);
}
models/mission.php
Code:
class FreeModelMission extends JModel {
## Empty data variabele
var $_data = null;
var $_id = null;
var $_ordering = null;
var $_orderby = null;
var $_total;
var $_pagination;
function __construct()
{
parent::__construct();
global $mainframe, $option;
$config = JFactory::getConfig();
## Get the pagination request variables
$limit = $mainframe->getUserStateFromRequest( 'global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int' );
$limitstart = $mainframe->getUserStateFromRequest( 'products.limitstart', 'limitstart', 0, 'int' );
## In case limit has been changed, adjust limitstart accordingly
$limitstart = ($limit != 0 ? (floor($limitstart / $limit) * $limit) : 0);
$this->setState('limit', $limit);
$this->setState('limitstart', $limitstart);
$this->id = JRequest::getInt('cid', 0);
$this->_id = JRequest::getInt('cid', 0);
}
function _buildContentOrderBy()
{
global $mainframe, $context;
//DEVNOTE:give me ordering from request
$filter_order = $mainframe->getUserStateFromRequest( $context.'filter_order', 'filter_order', 'misid' );
$filter_order_Dir = $mainframe->getUserStateFromRequest( $context.'filter_order_Dir', 'filter_order_Dir', '' );
if ($filter_order == 'c.misid'){
$orderby = ' ORDER BY c.misid, c.hits ';
} else {
$orderby = ' ORDER BY '.$filter_order.' '.$filter_order_Dir.' , c.misid, c.hits ';
}
return $orderby;
}
function getList()
{
if (empty($this->_data))
{
$db = JFactory::getDBO();
$orderby = $this->_buildContentOrderBy();
## Making the query for showing all the mission in list function
$sql = 'SELECT a.fatname, b.vatname, c.*, d.catname, d.color FROM #__management_person AS a, #__management_free AS b, #__management_mission AS c, #__management_category AS d '
. ' WHERE c.fatid = a.fatid '
. ' AND c.vatid = b.vatid '
. ' AND c.catid = d.catid'
. $orderby;;
$db->setQuery($sql, $this->getState('limitstart'), $this->getState('limit' ));
$this->data = $db->loadObjectList();
}
return $this->data;
}
default.php
Code:
<script language="javascript" type="text/javascript">
function tableOrdering( order, dir, task ) {
var form = document.adminForm;
form.filter_order.value = order;
form.filter_order_Dir.value = dir;
document.adminForm.submit( task );
}
</script>
Code:
<?php echo JHTML::_('grid.sort', 'ID#', 'id', $this->lists['order_Dir'], $this->lists['order']); ?></th>
<th width="33%"><div align="left">
<?php echo JHTML::_('grid.sort', 'MMISSION', 'type', $this->lists['order_Dir'], $this->lists['order']); ?></div></th>
<th width="10%">
<?php echo JHTML::_('grid.sort', 'ONDATE', 'ondate', $this->lists['order_Dir'], $this->lists['order']); ?></th>
<th width="10%">
<?php echo JHTML::_('grid.sort', 'OFFDATE', 'offdate', $this->lists['order_Dir'], $this->lists['order']); ?></th>
<th width="20%">
<?php echo JHTML::_('grid.sort', 'CATEGORY', 'catname', $this->lists['order_Dir'], $this->lists['order']); ?></th>
Bitte um Hilfe!
Gruss Grazioli
