AAAAhome/academiac/www/administrator/components/com_csvi/models/fields/csviakeebasubsorderproduct.php000060400000004137151466400470027757 0ustar00input; $template = $jinput->get('template', null, null); $db = JFactory::getDbo(); $query = $db->getQuery(true); $orderproduct = $template->get('orderproduct', 'order', array(), 'array'); if (!empty($orderproduct)) { $query->select($db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id', 'value')); $query->select($db->quoteName('title', 'text')); $query->from($db->quoteName('#__akeebasubs_subscriptions', 's')); $query->leftJoin($db->quoteName('#__akeebasubs_levels', 'l').' ON '.$db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id').' = '.$db->quoteName('l').'.'.$db->quoteName('akeebasubs_level_id')); $query->where($db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id').' IN ('.implode(',', $orderproduct).')'); $query->order($db->quoteName('title')); $query->group($db->quoteName('s').'.'.$db->quoteName('akeebasubs_level_id')); $db->setQuery($query); $products = $db->loadObjectList(); if (empty($products)) $products = array(); return array_merge(parent::getOptions(), $products); } else return parent::getOptions(); } } ?>