AAAAhome/academiac/www/administrator/components/com_csvi/models/fields/csviakeebasubsorderuser.php000060400000003710151466173160027254 0ustar00input; $template = $jinput->get('template', null, null); $db = JFactory::getDbo(); $query = $db->getQuery(true); $orderuser = $template->get('orderuser', 'order', array(), 'array'); if (!empty($orderuser)) { $query->select($db->quoteName('user_id', 'value')); $query->select($db->quoteName('name', 'text')); $query->from($db->quoteName('#__akeebasubs_subscriptions', 's')); $query->leftJoin($db->quoteName('#__users', 'u').' ON '.$db->quoteName('s').'.'.$db->quoteName('user_id').' = '.$db->quoteName('u').'.'.$db->quoteName('id')); $query->where($db->quoteName('s').'.'.$db->quoteName('user_id').' IN ('.implode(',', $orderuser).')'); $query->order($db->quoteName('name')); $query->group($db->quoteName('user_id')); $db->setQuery($query); $customers = $db->loadObjectList(); if (empty($customers)) $customers = array(); return array_merge(parent::getOptions(), $customers); } else return parent::getOptions(); } } ?>