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;
}
