AAAAhome/academiac/www/administrator/components/com_csvi/models/fields/csvivirtuemartorderuser.php000060400000003561151466321230027346 0ustar00input; $template = $jinput->get('template', null, null); $db = JFactory::getDbo(); $orderuser = $template->get('orderuser', 'order', array(), null); $userids = implode(',', $orderuser); if (!empty($userids)) { $q = "SELECT DISTINCT user_id, IF (LENGTH(TRIM(CONCAT(first_name, ' ', middle_name, ' ', last_name))) = 0, '".JText::_('COM_CSVI_EXPORT_ORDER_USER_EMPTY')."', IF (TRIM(CONCAT(first_name, ' ', middle_name, ' ', last_name)) is NULL, '".JText::_('COM_CSVI_EXPORT_ORDER_USER_EMPTY')."', CONCAT(first_name, ' ', middle_name, ' ', last_name))) AS user_name FROM #__virtuemart_order_userinfos WHERE user_id IN (".$userids.") ORDER BY user_name;"; $db->setQuery($q); $customers = $db->loadObjectList(); if (empty($customers)) $customers = array(); return array_merge(parent::getOptions(), $customers); } else return parent::getOptions(); } } ?>