public function delete()
{
// Check for request forgeries
JSession::checkToken() or die(JText::_('JINVALID_TOKEN'));
// Get items to remove from the request.
$cid = JFactory::getApplication()->input->get('cid', array(), 'array');
if (!is_array($cid) || count($cid) < 1) {
JLog::add(JText::_($this->text_prefix . '_NO_ITEM_SELECTED'), JLog::WARNING, 'jerror');
} else {
// Get the model.
$model = $this->getModel();
// Make sure the item ids are integers
jimport('joomla.utilities.arrayhelper');
JArrayHelper::toInteger($cid);
// Remove the items.
if ($model->delete($cid)) {
$this->setMessage(JText::plural($this->text_prefix . '_N_ITEMS_DELETED', count($cid)));
} else {
$this->setMessage($model->getError());
}
}
$version = new JVersion();
if ($version->isCompatible('3.0')) {
// Invoke the postDelete method to allow for the child class to access the model.
$this->postDeleteHook($model, $cid);
}
$this->setRedirect(JRoute::_('index.php?option=' . $this->option . '&view=' . $this->view_list, false));
}
public function selectnfredirect()
{
// collect input data : which url needs to be redirected ?
$notFoundUrlId = JRequest::getInt('notfound_url_id');
// which URL to redirect to?
$cid = JRequest::getVar('cid', array(0), 'default', 'array');
JArrayHelper::toInteger($cid);
if (count($cid) > 1) {
// more than one target url selected, display error
$this->setError(JText16::_('COM_SH404SEF_SELECT_ONLY_ONE_URL_TO_REDIRECT'));
$this->display();
return;
}
// only one url, use it
$targetUrlId = $cid[0];
if (empty($targetUrlId)) {
// bad url, probably not an integer was passed
$this->setError(JText16::_('COM_SH404SEF_INVALID_REDIRECT_TARGET_ID'));
$this->display();
return;
}
// get model and ask it to do the job
$model =& $this->getModel($this->_defaultModel);
$model->redirectNotFoundUrl($notFoundUrlId, $targetUrlId);
// check errors
$error = $model->getError();
if (!empty($error)) {
$this->setError($error);
}
// standard display
$this->display();
}
/**
* Method to save the submitted ordering values for records via AJAX.
*
* @return void
*
* @since 3.0
*/
public function saveOrderAjax()
{
// Get the input
$pks = $this->input->post->get('cid', array(), 'array');
$order = $this->input->post->get('order', array(), 'array');
// Sanitize the input
JArrayHelper::toInteger($pks);
JArrayHelper::toInteger($order);
// Get the model
$model = $this->getModel();
// Save the ordering
$return = $model->saveorder($pks, $order);
if ($return)
{
echo "1";
}
// Close the application
JFactory::getApplication()->close();
}
/**
* Method to auto-populate the model state.
*
* Note. Calling getState in this method will result in recursion.
*
* @return void
*
* @since 1.6
*/
protected function populateState($ordering = null, $direction = null)
{
$app = JFactory::getApplication('administrator');
// Adjust the context to support modal layouts.
if ($layout = $app->input->get('layout', 'default', 'cmd')) {
$this->context .= '.' . $layout;
}
// Load the filter state.
$search = $this->getUserStateFromRequest($this->context . '.filter.search', 'filter_search');
$this->setState('filter.search', $search);
$active = $this->getUserStateFromRequest($this->context . '.filter.active', 'filter_active');
$this->setState('filter.active', $active);
$state = $this->getUserStateFromRequest($this->context . '.filter.state', 'filter_state');
$this->setState('filter.state', $state);
$groupId = $this->getUserStateFromRequest($this->context . '.filter.group', 'filter_group_id', null, 'int');
$this->setState('filter.group_id', $groupId);
$range = $this->getUserStateFromRequest($this->context . '.filter.range', 'filter_range');
$this->setState('filter.range', $range);
$groups = json_decode(base64_decode($app->input->get('groups', '', 'BASE64')));
if (isset($groups)) {
JArrayHelper::toInteger($groups);
}
$this->setState('filter.groups', $groups);
$excluded = json_decode(base64_decode($app->input->get('excluded', '', 'BASE64')));
if (isset($excluded)) {
JArrayHelper::toInteger($excluded);
}
$this->setState('filter.excluded', $excluded);
// Load the parameters.
$params = JComponentHelper::getParams('com_users');
$this->setState('params', $params);
// List state information.
parent::populateState('a.name', 'asc');
}
public function toggleInList()
{
// Check for request forgeries
JRequest::checkToken() or die(JText::_('JINVALID_TOKEN'));
// Get items to publish from the request.
$cid = JRequest::getVar('cid', array(), '', 'array');
$data = array('showInListView' => 1, 'hideFromListView' => 0);
$task = $this->getTask();
$value = JArrayHelper::getValue($data, $task, 0, 'int');
if (empty($cid)) {
JError::raiseWarning(500, JText::_($this->text_prefix . '_NO_ITEM_SELECTED'));
} else {
// Get the model.
$model = $this->getModel();
// Make sure the item ids are integers
JArrayHelper::toInteger($cid);
// Publish the items.
if (!$model->addToListView($cid, $value)) {
JError::raiseWarning(500, $model->getError());
} else {
if ($value == 1) {
$ntext = $this->text_prefix . '_N_ITEMS_ADDED_TO_LIST_VIEW';
} else {
$ntext = $this->text_prefix . '_N_ITEMS_REMOVED_FROM_LIST_VIEW';
}
$this->setMessage(JText::plural($ntext, count($cid)));
}
}
$this->setRedirect(JRoute::_('index.php?option=' . $this->option . '&view=' . $this->view_list, false));
}
function savesetting()
{
$juser =& JFactory::getUser();
if ($juser->guest) {
$error = 'Bạn phải đăng nhập để thực hiện chức năng này';
$this->setError($error);
return false;
}
$post = JRequest::get('post');
JArrayHelper::toInteger($post);
$data = array();
$data['user_id'] = $juser->id;
$data['show_counter'] = $post['show_counter'] == 0 ? 0 : 1;
$data['email_subscribe'] = $post['email_subscribe'] == 0 ? 0 : 1;
$data['email_notify'] = $post['email_notify'] == 0 ? 0 : 1;
$data['pre_check'] = $post['pre_check'] == 0 ? 0 : 1;
$row =& $this->getTable('users');
if (!$row->bind($data)) {
$this->setError($this->_db->getErrorMsg());
return false;
}
if (!$row->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
return true;
}
/**
* Execute the controller.
*
* @return void
*
* @since 3.1
*/
public function execute()
{
// Get the application
/* @var InstallationApplicationWeb $app */
$app = $this->getApplication();
// Check for request forgeries.
JSession::checkToken() or $app->sendJsonResponse(new Exception(JText::_('JINVALID_TOKEN'), 403));
// Get array of selected languages
$lids = $this->input->get('cid', array(), 'array');
JArrayHelper::toInteger($lids, array());
// Get the languages model.
$model = new InstallationModelLanguages();
if (!$lids) {
// No languages have been selected
$app->enqueueMessage(JText::_('INSTL_LANGUAGES_NO_LANGUAGE_SELECTED'), 'warning');
} else {
// Install selected languages
$model->install($lids);
// Publish the Content Languages.
$model->publishContentLanguages();
$app->enqueueMessage(JText::_('INSTL_LANGUAGES_MORE_LANGUAGES'), 'notice');
}
// Redirect to the page.
$r = new stdClass();
$r->view = 'defaultlanguage';
$app->sendJsonResponse($r);
}
/**
* Returns an array of categories for the given extension.
*
* @param string $extension The extension option.
* @param array $config An array of configuration options. By default, only published and unpublished categories are returned.
*
* @return array Categories for the extension
*
* @since 11.1
*/
public function categories($extension, $config = array('filter.published' => array(0, 1)))
{
$config = (array) $config;
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('a.id, a.title, a.level, a.parent_id');
$query->from('#__categories AS a');
$query->where('a.parent_id > 0');
// Filter on extension.
$query->where('extension = ' . $db->quote($extension));
// Filter on the published state
if (isset($config['filter.published'])) {
if (is_numeric($config['filter.published'])) {
$query->where('a.published = ' . (int) $config['filter.published']);
} elseif (is_array($config['filter.published'])) {
JArrayHelper::toInteger($config['filter.published']);
$query->where('a.published IN (' . implode(',', $config['filter.published']) . ')');
}
}
$query->order('a.lft');
$db->setQuery($query);
$items = $db->loadObjectList();
$allitems = array();
foreach ($items as &$item) {
$repeat = $item->level - 1 >= 0 ? $item->level - 1 : 0;
$item->title = str_repeat('- ', $repeat) . $item->title;
$allitems[$item->id] = $item->title;
}
return $allitems;
}
public function feature()
{
JSession::checkToken() or die(JText::_('JINVALID_TOKEN'));
$app = JFactory::getApplication();
$cid = $app->input->post->get('documentid', array(), 'array');
$data = array('feature' => 1, 'unfeature' => 0);
$task = $this->getTask();
$value = JArrayHelper::getValue($data, $task, 0, 'int');
$rootCat = JUDownloadFrontHelperCategory::getRootCategory();
if (empty($cid)) {
JError::raiseWarning(500, JText::_('COM_JUDOWNLOAD_NO_ITEM_SELECTED'));
} else {
$model = $this->getModel();
JArrayHelper::toInteger($cid);
if (!$model->feature($cid, $value)) {
JError::raiseWarning(500, $model->getError());
} else {
if ($value == 1) {
$ntext = $this->text_prefix . '_N_ITEMS_FEATURED';
} elseif ($value == 0) {
$ntext = $this->text_prefix . '_N_ITEMS_UNFEATURED';
}
$this->setMessage(JText::plural($ntext, count($cid)));
}
}
$extension = $app->input->get('extension');
$extensionURL = $extension ? '&extension=' . $extension : '';
$catURL = '&cat_id=' . $app->input->getInt('cat_id', $rootCat->id);
$this->setRedirect(JRoute::_('index.php?option=' . $this->option . '&view=' . $this->view_list . $catURL . $extensionURL, false));
}
/**
* Method to set the publishing state for a row or list of rows in the database
* table. The method respects checked out rows by other users and will attempt
* to checkin rows that it can after adjustments are made.
*
* @param mixed An optional array of primary key values to update. If not
* set the instance property value is used.
* @param integer The publishing state. eg. [0 = unpublished, 1 = published, 2=archived, -2=trashed]
* @param integer The user id of the user performing the operation.
*
* @return boolean True on success.
* @since 1.0
*/
public function publish($pks = null, $state = 1, $userId = 0)
{
// Initialise variables.
$k = $this->_tbl_key;
// Sanitize input.
JArrayHelper::toInteger($pks);
$userId = (int) $userId;
$state = (int) $state;
// If there are no primary keys set check to see if the instance key is set.
if (empty($pks)) {
if ($this->{$k}) {
$pks = array($this->{$k});
} else {
$this->setError(JText::_('JLIB_DATABASE_ERROR_NO_ROWS_SELECTED'));
return false;
}
}
// Get an instance of the table
$table = JTable::getInstance('List', 'NewsletterTable');
// For all keys
foreach ($pks as $pk) {
// Load the banner
if (!$table->load($pk)) {
$this->setError($table->getError());
}
// Change the state
$table->state = $state;
// Store the row
if (!$table->store()) {
$this->setError($table->getError());
}
}
return count($this->getErrors()) == 0;
}
public static function getArray($name, $default = array(), $type = 'array', $hash = 'default', $mask = 0)
{
// explode name
$parts = explode('.', $name);
if (count($parts) > 1) {
$name = $parts[0];
$key = $parts[1];
}
$array = self::getVar($name, $default, $hash, 'array', $mask);
if (isset($key)) {
if (is_array($array) && array_key_exists($key, $array)) {
$value = $array[$key];
settype($value, $type);
return $value;
}
return $default;
}
if ($type == 'string') {
JArrayHelper::toString($array);
} else {
if ($type == 'int') {
JArrayHelper::toInteger($array);
}
}
return $array;
}
private function setQueryConditions(&$query)
{
$db = $this->getDBO();
if ($this->getState('itemId')) {
$query->leftJoin($db->quoteName('#__k2_tags_xref', 'xref') . ' ON ' . $db->quoteName('xref.tagId') . ' = ' . $db->quoteName('tag.id'));
$query->where($db->quoteName('xref.itemId') . ' = ' . (int) $this->getState('itemId'));
}
if (is_numeric($this->getState('state'))) {
$query->where($db->quoteName('tag.state') . ' = ' . (int) $this->getState('state'));
}
if ($this->getState('id')) {
$id = $this->getState('id');
if (is_array($id)) {
JArrayHelper::toInteger($id);
$query->where($db->quoteName('tag.id') . ' IN (' . implode(',', $id) . ')');
} else {
$query->where($db->quoteName('tag.id') . ' = ' . (int) $id);
}
}
if ($this->getState('alias')) {
$query->where($db->quoteName('tag.alias') . ' = ' . $db->quote($this->getState('alias')));
}
if ($this->getState('search')) {
$search = JString::trim($this->getState('search'));
$search = JString::strtolower($search);
if ($search) {
$search = $db->escape($search, true);
$query->where('( LOWER(' . $db->quoteName('tag.name') . ') LIKE ' . $db->Quote('%' . $search . '%', false) . '
OR ' . $db->quoteName('tag.id') . ' = ' . (int) $search . '
OR LOWER(' . $db->quoteName('tag.alias') . ') LIKE ' . $db->Quote('%' . $search . '%', false) . ')');
}
}
}
/**
* Method to remove a record.
*/
public function delete()
{
// Check for request forgeries.
JSession::checkToken() or jexit(JText::_('JInvalid_Token'));
// Initialise variables.
$user = JFactory::getUser();
$ids = JRequest::getVar('cid', array(), '', 'array');
if (!JFactory::getUser()->authorise('core.admin', $this->option)) {
JError::raiseError(500, JText::_('JERROR_ALERTNOAUTHOR'));
jexit();
} elseif (empty($ids)) {
JError::raiseWarning(500, JText::_('COM_USERS_NO_LEVELS_SELECTED'));
} else {
// Get the model.
$model = $this->getModel();
JArrayHelper::toInteger($ids);
// Remove the items.
if (!$model->delete($ids)) {
JError::raiseWarning(500, $model->getError());
} else {
$this->setMessage(JText::plural('COM_USERS_N_LEVELS_DELETED', count($ids)));
}
}
$this->setRedirect('index.php?option=com_users&view=levels');
}
/**
* Update a set of extensions.
*
* @return void
*
* @since 1.6
*/
public function update()
{
// Check for request forgeries.
JSession::checkToken() or jexit(JText::_('JINVALID_TOKEN'));
/** @var InstallerModelUpdate $model */
$model = $this->getModel('update');
$uid = $this->input->get('cid', array(), 'array');
JArrayHelper::toInteger($uid, array());
// Get the minimum stability.
$component = JComponentHelper::getComponent('com_installer');
$params = $component->params;
$minimum_stability = $params->get('minimum_stability', JUpdater::STABILITY_STABLE, 'int');
$model->update($uid, $minimum_stability);
if ($model->getState('result', false)) {
$cache = JFactory::getCache('mod_menu');
$cache->clean();
}
$app = JFactory::getApplication();
$redirect_url = $app->getUserState('com_installer.redirect_url');
// Don't redirect to an external URL.
if (!JUri::isInternal($redirect_url)) {
$redirect_url = '';
}
if (empty($redirect_url)) {
$redirect_url = JRoute::_('index.php?option=com_installer&view=update', false);
} else {
// Wipe out the user state when we're going to redirect.
$app->setUserState('com_installer.redirect_url', '');
$app->setUserState('com_installer.message', '');
$app->setUserState('com_installer.extension_message', '');
}
$this->setRedirect($redirect_url);
}
public function featured($pks, $value = 0)
{
// Sanitize the ids.
$pks = (array) $pks;
JArrayHelper::toInteger($pks);
if (empty($pks)) {
$this->setError(JText::_('COM_CONTACT_NO_ITEM_SELECTED'));
return false;
}
$table = $this->getTable();
try {
$db = $this->getDbo();
$query = $db->getQuery(true);
$query->update('#__bookpro_tour');
$query->set('featured = ' . (int) $value);
$query->where('id IN (' . implode(',', $pks) . ')');
$db->setQuery($query);
$db->execute();
} catch (Exception $e) {
$this->setError($e->getMessage());
return false;
}
$table->reorder();
// Clean component's cache
$this->cleanCache();
return true;
}
/**
* Method to set the publishing state for a row or list of rows in the database
* table. The method respects checked out rows by other users and will attempt
* to checkin rows that it can after adjustments are made.
*
* @param mixed An optional array of primary key values to update. If not
* set the instance property value is used.
* @param integer The publishing state. eg. [0 = unpublished, 1 = published]
* @param integer The user id of the user performing the operation.
* @return boolean True on success.
* @since 1.0.4
*/
public function publish($pks = null, $state = 1, $userId = 0)
{
// Initialise variables.
$k = $this->_tbl_key;
// Sanitize input.
JArrayHelper::toInteger($pks);
$userId = (int) $userId;
$state = (int) $state;
// If there are no primary keys set check to see if the instance key is set.
if (empty($pks)) {
if ($this->{$k}) {
$pks = array($this->{$k});
} else {
$this->setError(JText::_('JLIB_DATABASE_ERROR_NO_ROWS_SELECTED'));
return false;
}
}
// Build the WHERE clause for the primary keys.
$where = $k . '=' . implode(' OR ' . $k . '=', $pks);
// Update the publishing state for rows with the given primary keys.
$this->_db->setQuery('UPDATE `' . $this->_tbl . '`' . ' SET state = ' . (int) $state . ' WHERE (' . $where . ')');
$this->_db->execute();
// Check for a database error.
if ($this->_db->getErrorNum()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
// If the JTable instance value is in the list of primary keys that were set, set the instance.
if (in_array($this->{$k}, $pks)) {
$this->state = $state;
}
$this->setError('');
return true;
}
public function delete()
{
JSession::checkToken() or jexit(JText::_('JINVALID_TOKEN'));
$app = JFactory::getApplication();
$cid = $app->input->get('cid', array(), 'array');
if (!is_array($cid) || count($cid) < 1) {
JError::raiseWarning(500, JText::_($this->text_prefix . '_NO_ITEM_SELECTED'));
} else {
// Get the model.
$model = $this->getModel();
// Make sure the item ids are integers
jimport('joomla.utilities.arrayhelper');
JArrayHelper::toInteger($cid);
// Remove the items.
if ($model->delete($cid)) {
$this->setMessage(JText::plural($this->text_prefix . '_N_ITEMS_DELETED', count($cid)));
} else {
$this->setMessage($model->getError());
}
}
$vars = '';
$extension = $app->input->get('extension', '');
if ($extension) {
$vars = '&extension=' . $extension;
}
$this->setRedirect(JRoute::_('index.php?option=' . $this->option . '&view=' . $this->view_list . $vars, false));
}
protected function removeInstances($module_name)
{
$db = $this->parent->getDbo();
// Lets delete all the module copies for the type we are uninstalling
$query = 'SELECT `id`' . ' FROM `#__modules`' . ' WHERE module = ' . $db->quote($module_name);
$db->setQuery($query);
try {
$modules = $db->loadColumn();
} catch (Exception $e) {
$modules = array();
}
// Do we have any module copies?
if (count($modules)) {
// Ensure the list is sane
JArrayHelper::toInteger($modules);
$modID = implode(',', $modules);
// Wipe out any items assigned to menus
$query = 'DELETE' . ' FROM #__modules_menu' . ' WHERE moduleid IN (' . $modID . ')';
$db->setQuery($query);
try {
$db->execute();
} catch (Exception $e) {
JError::raiseWarning(100, JText::sprintf('JLIB_INSTALLER_ERROR_MOD_UNINSTALL_EXCEPTION', $db->stderr(true)));
}
// Wipe out any instances in the modules table
$query = 'DELETE' . ' FROM #__modules' . ' WHERE id IN (' . $modID . ')';
$db->setQuery($query);
try {
$db->execute();
} catch (Exception $e) {
JError::raiseWarning(100, JText::sprintf('JLIB_INSTALLER_ERROR_MOD_UNINSTALL_EXCEPTION', $db->stderr(true)));
}
}
}
/**
* Function to convert a string or array into a single string
*
* @param mixed $values Array or string to use as values
* @param string $filter Filter to apply to the values to quote or (int) them
* @param array $removeValues Items to remove/filter from the source array
*
* @return string
*/
public static function multipleSanitised($values, $filter = 'integer', $removeValues = array(''))
{
$db = JFactory::getDbo();
// Extra verification to avoid null values
if (is_null($values)) {
return false;
}
if (!is_array($values)) {
// Convert comma separated values to arrays
$values = (array) explode(',', $values);
}
// If all is selected remove filter
if (in_array('*', $values)) {
return null;
}
// Remove undesired source values
if (!empty($removeValues)) {
$values = array_diff($values, $removeValues);
}
// Filter to sanitise data
switch ($filter) {
case 'integer':
JArrayHelper::toInteger($values);
break;
default:
$values = array_map(array($db, 'quote'), $values);
break;
}
return $values;
}
/**
* Logic to remove
*/
function remove()
{
// Check for request forgeries
JRequest::checkToken() or jexit('Invalid Token');
// Get the model
$model = $this->getModel('groups');
// Get the selected items
$cid = JRequest::getVar('cid', array(0), 'post', 'array');
// Force array elements to be integers
JArrayHelper::toInteger($cid, array(0));
$msg = '';
// No items are selected
if (!is_array($cid) || count($cid) < 1) {
JError::raiseWarning(500, JText::_('SELECT ITEM DELETE'));
} else {
$model->remove($cid);
$total = count($cid);
$msg = JText::sprintf('RST_GROUPS_DELETED', $total);
// Clean the cache, if any
$cache =& JFactory::getCache('com_rsticketspro');
$cache->clean();
}
// Redirect
$this->setRedirect('index.php?option=com_rsticketspro&view=groups', $msg);
}
/**
* Method to set the publishing state for a row or list of rows in the database
* table. The method respects checked out rows by other users and will attempt
* to checkin rows that it can after adjustments are made.
*
* @param mixed $pks An optional array of primary key values to update. If not
* set the instance property value is used.
* @param integer $state The publishing state. eg. [0 = unpublished, 1 = published]
* @param integer $userId The user id of the user performing the operation.
*
* @return boolean True on success.
*
* @since 1.6
*/
public function publish($pks = null, $state = 1, $userId = 0)
{
$k = $this->_tbl_key;
// Sanitize input.
JArrayHelper::toInteger($pks);
$state = (int) $state;
// If there are no primary keys set check to see if the instance key is set.
if (empty($pks)) {
if ($this->{$k}) {
$pks = array($this->{$k});
} else {
$this->setError(JText::_('JLIB_DATABASE_ERROR_NO_ROWS_SELECTED'));
return false;
}
}
// Build the WHERE clause for the primary keys.
$where = $k . ' IN (' . implode(',', $pks) . ')';
// Update the publishing state for rows with the given primary keys.
$this->_db->setQuery('UPDATE ' . $this->_db->quoteName($this->_tbl) . ' SET ' . $this->_db->quoteName('state') . ' = ' . (int) $state . ' WHERE (' . $where . ')');
try {
$this->_db->execute();
} catch (RuntimeException $e) {
$this->setError($e->getMessage());
return false;
}
// If the JTable instance value is in the list of primary keys that were set, set the instance.
if (in_array($this->{$k}, $pks)) {
$this->state = $state;
}
$this->setError('');
return true;
}
function getZones($ids, $columns = '*', $key = 'zone_id', $returnArrayWithOneColumn = false)
{
if (is_numeric($ids)) {
$ids = array($ids);
} elseif (!is_array($ids)) {
return array();
}
if ($key == 'zone_id') {
JArrayHelper::toInteger($ids);
} else {
foreach ($ids as $k => $id) {
$ids[$k] = $this->database->Quote($id);
}
}
$query = 'SELECT ' . preg_replace('#[^a-z_, ]#', '', $columns) . ' FROM #__hikashop_zone WHERE ' . preg_replace('#[^a-z_]#', '', $key) . ' IN (' . implode(',', $ids) . ')';
$this->database->setQuery($query);
if ($returnArrayWithOneColumn) {
if (!HIKASHOP_J25) {
return $this->database->loadResultArray();
} else {
return $this->database->loadColumn();
}
} else {
return $this->database->loadObjectList();
}
}
function &getEventLists()
{
if (is_null($this->_eventLists)) {
$this->_eventLists = array();
$db = FabrikWorker::getDbo(true);
$params = $this->getPluginParams();
$lists = (array) $params->get('calendar_table');
JArrayHelper::toInteger($lists);
$dateFields = (array) $params->get('calendar_startdate_element');
$dateFields2 = (array) $params->get('calendar_enddate_element');
$labels = (array) $params->get('calendar_label_element');
$colours = (array) $params->get('colour');
$db->setQuery("SELECT id AS value, label AS text FROM #__{package}_lists WHERE id IN ('" . implode("','", $lists) . "')");
$rows = $db->loadObjectList();
for ($i = 0; $i < count($rows); $i++) {
if (!isset($colours[$i])) {
$colours[$i] = '';
}
$rows[$i]->startdate_element = $dateFields[$i];
$rows[$i]->enddate_element = JArrayHelper::getValue($dateFields2, $i);
$rows[$i]->label_element = $labels[$i];
$rows[$i]->colour = $colours[$i];
}
$this->_eventLists = $rows;
}
return $this->_eventLists;
}
function fetchElement($name, $value, &$node, $control_name)
{
$access = JFactory::getACL();
// Include user in groups that have access to edit their articles, other articles, or manage content.
$action = array('com_content.article.edit_own', 'com_content.article.edit_article', 'com_content.manage');
$groups = $access->getAuthorisedUsergroups($action, true);
// Check the results of the access check.
if (!$groups) {
return false;
}
// Clean up and serialize.
JArrayHelper::toInteger($groups);
$groups = implode(',', $groups);
// Build the query to get the users.
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('u.id AS value');
$query->select('u.name AS text');
$query->from('#__users AS u');
$query->join('INNER', '#__user_usergroup_map AS m ON m.user_id = u.id');
$query->where('u.block = 0');
$query->where('m.group_id IN (' . $groups . ')');
// Get the users.
$db->setQuery((string) $query);
$users = $db->loadObjectList();
// Check for a database error.
if ($db->getErrorNum()) {
JError::raiseNotice(500, $db->getErrorMsg());
return false;
}
return JHtml::_('select.genericlist', $users, $name, 'class="inputbox" size="1"', 'value', 'text', $value);
}
public function exportData()
{
// Check for request forgeries
JSession::checkToken() or die(JText::_('JINVALID_TOKEN'));
// check if export is allowed for this user.
$user = JFactory::getUser();
if ($user->authorise('help_document.export', 'com_costbenefitprojection') && $user->authorise('core.export', 'com_costbenefitprojection')) {
// Get the input
$input = JFactory::getApplication()->input;
$pks = $input->post->get('cid', array(), 'array');
// Sanitize the input
JArrayHelper::toInteger($pks);
// Get the model
$model = $this->getModel('Help_documents');
// get the data to export
$data = $model->getExportData($pks);
if (CostbenefitprojectionHelper::checkArray($data)) {
// now set the data to the spreadsheet
$date = JFactory::getDate();
CostbenefitprojectionHelper::xls($data, 'Help_documents_' . $date->format('jS_F_Y'), 'Help documents exported (' . $date->format('jS F, Y') . ')', 'help documents');
}
}
// Redirect to the list screen with error.
$message = JText::_('COM_COSTBENEFITPROJECTION_EXPORT_FAILED');
$this->setRedirect(JRoute::_('index.php?option=com_costbenefitprojection&view=help_documents', false), $message, 'error');
return;
}
function remove()
{
$option = 'com_jobboard';
$cid = JRequest::getVar('cid', array(), '', 'array');
JArrayHelper::toInteger($cid);
$doc =& JFactory::getDocument();
$style = " .icon-48-job_posts {background-image:url(components/com_jobboard/images/job_posts.png); no-repeat; }";
$doc->addStyleDeclaration($style);
$this->setToolbar();
$un_deletable = array();
$undeletables = false;
$count_cid = count($cid);
if ($count_cid) {
for ($i = 0; $i <= $count_cid; $i++) {
if ($cid[$i] == 1 || $cid[$i] == 6 || $cid[$i] == 7) {
$un_deletable[] = $cid[$i];
unset($cid[$i]);
$undeletables = true;
}
}
if ($undeletables == false) {
$success_msg = $count_cid == 1 ? JText::_('COM_JOBBOARD_STATUS_DELETED') : JText::_('COM_JOBBOARD_STATUSES_DELETED');
$cids = implode(',', $cid);
$jobs_model =& $this->getModel('Statuses');
$delete_result = $jobs_model->deleteStatuses($cids);
if ($delete_result != true) {
$this->setRedirect('index.php?option=com_jobboard&view=statuses', $delete_result);
} else {
$this->setRedirect('index.php?option=com_jobboard&view=statuses', $success_msg);
}
}
if ($undeletables == true) {
$undel_messg = JText::_('COM_JOBBOARD_ITEM_NO_DELETE') . ': #' . $un_deletable[0];
if ($count_cid == 1) {
$this->setRedirect('index.php?option=' . $option . '&view=statuses', $undel_messg);
} else {
$unDeletableCount = count($un_deletable);
$success_msg = $count_cid == 2 && $unDeletableCount == 1 || $count_cid <= 3 && $unDeletableCount > 1 ? JText::_('COM_JOBBOARD_STATUS_DELETED') : JText::_('COM_JOBBOARD_STATUSES_DELETED');
$cids = implode(',', $cid);
$jobs_model =& $this->getModel('Statuses');
$delete_result = $jobs_model->deleteStatuses($cids);
if ($unDeletableCount > 1) {
for ($i = 1; $i < $unDeletableCount; $i++) {
$undel_messg .= ', #' . $un_deletable[$i];
}
}
if ($unDeletableCount == $count_cid) {
$success_msg = $undel_messg;
} else {
$success_msg .= '; ' . $undel_messg;
}
if ($delete_result != true) {
$this->setRedirect('index.php?option=com_jobboard&view=statuses', $delete_result);
} else {
$this->setRedirect('index.php?option=com_jobboard&view=statuses', $success_msg);
}
}
}
}
}
function _delete_templateinvite()
{
$app = JFactory::getApplication();
// initialize variables
$db = JFactory::getDBO();
$cid = JFactory::getApplication()->input->get('cid', array(), 'array');
$msgType = '';
JArrayHelper::toInteger($cid);
if (count($cid)) {
// are there one or more rows to delete?
/*
if (count($cid) == 1) {
$row = JTable::getInstance('template_invite');
$row->load($cid[0]);
} else {
$msg = JText::sprintf('AUP_MSGSUCCESSFULLYDELETED', JText::_('AUP_RULES'), '');
}
*/
$query = "DELETE FROM #__alpha_userpoints_template_invite" . "\n WHERE (`id` = " . implode(' OR `id` = ', $cid) . ")";
$db->setQuery($query);
if (!$db->query()) {
$msg = $db->getErrorMsg();
$msgType = 'error';
}
}
JControllerLegacy::setRedirect('index.php?option=com_alphauserpoints&task=templateinvite', $msg, $msgType);
JControllerLegacy::redirect();
}
/**
* Constructor
*
* @since 1.0
*/
function __construct()
{
parent::__construct();
$cid = JRequest::getVar('cid', array(0), '', 'array');
JArrayHelper::toInteger($cid, array(0));
$this->setId($cid[0]);
}
public function saveOrder()
{
// Check for request forgeries
JRequest::checkToken() or jexit('Invalid Token');
$mainframe = JFactory::getApplication();
$jinput = $mainframe->input;
$db = JFactory::getDBO();
$cid = $jinput->post->get('cid', array(0), 'array');
//JRequest::getVar( 'cid', array(0), 'post', 'array' );
$order = $jinput->post->get('order', array(0), 'array');
//JRequest::getVar( 'order', array (0), 'post', 'array' );
$total = count($cid);
$conditions = array();
JArrayHelper::toInteger($cid, array(0));
JArrayHelper::toInteger($order, array(0));
$row = JTable::getInstance('MultiProfile', 'CTable');
// Update the ordering for items in the cid array
for ($i = 0; $i < $total; $i++) {
$row->load((int) $cid[$i]);
if ($row->ordering != $order[$i]) {
$row->ordering = $order[$i];
$row->store();
}
}
$mainframe = JFactory::getApplication();
$mainframe->redirect('index.php?option=com_community&view=multiprofile', JText::_('COM_COMMUNITY_MULTIPROFILE_ORDERING_SAVED'), 'message');
}
function load($value)
{
$this->values = array();
$config =& hikashop_config();
$forced = array((int) $config->get('main_currency'));
$filters = array('currency_published = 1');
if ($this->displayType == 'auto') {
$app = JFactory::getApplication();
if ($app->isAdmin()) {
if (is_array($value)) {
$forced = array_merge($forced, $value);
JArrayHelper::toInteger($forced);
} else {
$forced[] = (int) $value;
}
} else {
$filters[] = 'currency_displayed = 1';
}
$filters[] = 'currency_id IN (' . implode(',', $forced) . ')';
} elseif ($this->displayType == 'all') {
$filters[] = 'currency_displayed = 1';
$this->values[] = JHTML::_('select.option', 0, JText::_('HIKA_NONE'));
}
if (empty($this->currencies)) {
$query = 'SELECT * FROM ' . hikashop_table('currency') . ' WHERE (' . implode(') OR (', $filters) . ')';
$db = JFactory::getDBO();
$db->setQuery($query);
$this->currencies = $db->loadObjectList('currency_id');
}
if (!empty($this->currencies)) {
foreach ($this->currencies as $currency) {
$this->values[] = JHTML::_('select.option', (int) $currency->currency_id, $currency->currency_symbol . ' ' . $currency->currency_code);
}
}
}
