static function getMappings($filter_type, $limitstart, $limit, $filter_order, $filter_order_Dir, $search) { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select($db->quoteName(array('id', 'joomla_app', 'joomla_field', 'moodle_field'))); $query->from($db->quoteName('#__joomdle_field_mappings')); $wheres = array(); if ($filter_type != '') { $query->where($db->quoteName('joomla_app') . ' = ' . $db->quote($filter_type)); } if ($search) { $query->where($db->quoteName('joomla_field') . ' LIKE ' . $search . " OR " . $db->quoteName('moodle_field') . ' LIKE ' . $search); } $query->order("{$filter_order} {$filter_order_Dir}"); $db->setQuery($query, $limitstart, $limit); $mappings = $db->loadAssocList(); if (!$mappings) { return array(); } foreach ($mappings as $mapping) { $mapping['joomla_field_name'] = JoomdleHelperMappings::get_field_name($mapping['joomla_app'], $mapping['joomla_field']); $mapping['moodle_field_name'] = JoomdleHelperMappings::get_moodle_field_name($mapping['moodle_field']); $m[] = $mapping; } return $m; }