PHP CostbenefitprojectionHelper::hisCountries方法代码示例

 /**
  * Method override to check if you can edit an existing record.
  *
  * @param   array   $data  An array of input data.
  * @param   string  $key   The name of the key for the primary key.
  *
  * @return  boolean
  *
  * @since   1.6
  */
 protected function allowEdit($data = array(), $key = 'id')
 {
     // get user object.
     $user = JFactory::getUser();
     // get record id.
     $recordId = (int) isset($data[$key]) ? $data[$key] : 0;
     if (!$user->authorise('core.options', 'com_costbenefitprojection')) {
         // make absolutely sure that this health data can be edited
         $is = CostbenefitprojectionHelper::userIs($user->id);
         $countries = CostbenefitprojectionHelper::hisCountries($user->id);
         $country = CostbenefitprojectionHelper::getId('health_data', $recordId, 'id', 'country');
         if (3 != $is || !CostbenefitprojectionHelper::checkArray($countries) || !in_array($country, $countries)) {
             return false;
         }
     }
     // Access check.
     $access = $user->authorise('health_data.access', 'com_costbenefitprojection.health_data.' . (int) $recordId) && $user->authorise('health_data.access', 'com_costbenefitprojection');
     if (!$access) {
         return false;
     }
     if ($recordId) {
         // The record has been set. Check the record permissions.
         $permission = $user->authorise('health_data.edit', 'com_costbenefitprojection.health_data.' . (int) $recordId);
         if (!$permission && !is_null($permission)) {
             if ($user->authorise('health_data.edit.own', 'com_costbenefitprojection.health_data.' . $recordId)) {
                 // Now test the owner is the user.
                 $ownerId = (int) isset($data['created_by']) ? $data['created_by'] : 0;
                 if (empty($ownerId)) {
                     // Need to do a lookup from the model.
                     $record = $this->getModel()->getItem($recordId);
                     if (empty($record)) {
                         return false;
                     }
                     $ownerId = $record->created_by;
                 }
                 // If the owner matches 'me' then allow.
                 if ($ownerId == $user->id) {
                     if ($user->authorise('health_data.edit.own', 'com_costbenefitprojection')) {
                         return true;
                     }
                 }
             }
             return false;
         }
     }
     // Since there is no permission, revert to the component permissions.
     return $user->authorise('health_data.edit', $this->option);
 }

 /**
  * Batch move items to a new category
  *
  * @param   integer  $value     The new category ID.
  * @param   array    $pks       An array of row IDs.
  * @param   array    $contexts  An array of item contexts.
  *
  * @return  boolean  True if successful, false otherwise and internal error is set.
  *
  * @since	12.2
  */
 protected function batchMove($values, $pks, $contexts)
 {
     if (empty($this->batchSet)) {
         // Set some needed variables.
         $this->user = JFactory::getUser();
         $this->table = $this->getTable();
         $this->tableClassName = get_class($this->table);
         $this->contentType = new JUcmType();
         $this->type = $this->contentType->getTypeByTable($this->tableClassName);
         $this->canDo = CostbenefitprojectionHelper::getActions('country');
     }
     if (!$this->canDo->get('country.edit') && !$this->canDo->get('country.batch')) {
         $this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_CANNOT_EDIT'));
         return false;
     }
     if (!$this->user->authorise('core.options', 'com_costbenefitprojection')) {
         // make absolutely sure that this country can be moved
         $is = CostbenefitprojectionHelper::userIs($user->id);
         $countries = CostbenefitprojectionHelper::hisCountries($this->user->id);
         if (3 == $is && CostbenefitprojectionHelper::checkArray($countries)) {
             foreach ($pks as $nr => $pk) {
                 if (!in_array($pk, $countries)) {
                     unset($pks[$nr]);
                 }
             }
             if (empty($pks)) {
                 $this->setError(JText::sprintf('JLIB_APPLICATION_ERROR_BATCH_MOVE_ROW_NOT_FOUND', 0));
                 return false;
             }
         } else {
             $this->setError(JText::sprintf('JLIB_APPLICATION_ERROR_BATCH_MOVE_ROW_NOT_FOUND', 0));
             return false;
         }
     }
     // make sure published only updates if user has the permission.
     if (isset($values['published']) && !$this->canDo->get('country.edit.state')) {
         unset($values['published']);
     }
     // remove move_copy from array
     unset($values['move_copy']);
     // Parent exists so we proceed
     foreach ($pks as $pk) {
         if (!$this->user->authorise('country.edit', $contexts[$pk])) {
             $this->setError(JText::_('JLIB_APPLICATION_ERROR_BATCH_CANNOT_EDIT'));
             return false;
         }
         // Check that the row actually exists
         if (!$this->table->load($pk)) {
             if ($error = $this->table->getError()) {
                 // Fatal error
                 $this->setError($error);
                 return false;
             } else {
                 // Not fatal error
                 $this->setError(JText::sprintf('JLIB_APPLICATION_ERROR_BATCH_MOVE_ROW_NOT_FOUND', $pk));
                 continue;
             }
         }
         // insert all set values.
         if (CostbenefitprojectionHelper::checkArray($values)) {
             foreach ($values as $key => $value) {
                 // Do special action for access.
                 if ('access' == $key && strlen($value) > 0) {
                     $this->table->{$key} = $value;
                 } elseif (strlen($value) > 0 && isset($this->table->{$key})) {
                     $this->table->{$key} = $value;
                 }
             }
         }
         // Check the row.
         if (!$this->table->check()) {
             $this->setError($this->table->getError());
             return false;
         }
         if (!empty($this->type)) {
             $this->createTagsHelper($this->tagsObserver, $this->type, $pk, $this->typeAlias, $this->table);
         }
         // Store the row.
         if (!$this->table->store()) {
             $this->setError($this->table->getError());
             return false;
         }
     }
     // Clean the cache
     $this->cleanCache();
     return true;
 }

 /**
  * Method to get a list of options for a list input.
  *
  * @return	array		An array of JHtml options.
  */
 public function getOptions()
 {
     $jinput = JFactory::getApplication()->input;
     $client = $jinput->get('id', 0, 'INT');
     $countries = CostbenefitprojectionHelper::hisCountries(null, $client, 'company');
     $db = JFactory::getDBO();
     $query = $db->getQuery(true);
     $query->select($db->quoteName(array('a.year', 'a.country'), array('year', 'country')));
     $query->from($db->quoteName('#__costbenefitprojection_health_data', 'a'));
     $query->where($db->quoteName('a.published') . ' = 1');
     if (CostbenefitprojectionHelper::checkArray($countries)) {
         $query->where($db->quoteName('a.country') . ' IN (' . implode(',', $countries) . ')');
     }
     $query->order('a.country ASC');
     $db->setQuery((string) $query);
     $items = $db->loadObjectList();
     $options = array();
     if ($items) {
         $years = array();
         foreach ($items as $item) {
             if (!CostbenefitprojectionHelper::checkArray($years) || !in_array($item->year . '_' . $item->country, $years)) {
                 if (!CostbenefitprojectionHelper::checkArray($countries) || $client == 0) {
                     $countryName = ' (' . CostbenefitprojectionHelper::getCountryName($item->country) . ')';
                 } else {
                     $countryName = '';
                 }
                 $options[] = JHtml::_('select.option', $item->year, $item->year . $countryName);
                 $years[$item->year] = $item->year . '_' . $item->country;
             }
         }
     }
     return $options;
 }

 /**
  * Method to get a list of options for a list input.
  *
  * @return	array		An array of JHtml options.
  */
 public function getOptions()
 {
     // Get the user object.
     $user = JFactory::getUser();
     // Create a new query object.
     $db = JFactory::getDBO();
     $query = $db->getQuery(true);
     $query->select($db->quoteName(array('a.id', 'a.name'), array('id', 'country_name')));
     $query->from($db->quoteName('#__costbenefitprojection_country', 'a'));
     $query->where($db->quoteName('a.published') . ' = 1');
     if (!$user->authorise('core.options', 'com_costbenefitprojection')) {
         $countries = CostbenefitprojectionHelper::hisCountries($user->id);
         if (CostbenefitprojectionHelper::checkArray($countries)) {
             $countries = implode(',', $countries);
             // only load this users companies
             $query->where('a.id IN (' . $countries . ')');
         } else {
             // dont allow user to see any countries
             $query->where('a.id = -4');
         }
     }
     $query->order('a.name ASC');
     $db->setQuery((string) $query);
     $items = $db->loadObjectList();
     $options = array();
     if ($items) {
         $options[] = JHtml::_('select.option', '', 'Select a country');
         foreach ($items as $item) {
             $options[] = JHtml::_('select.option', $item->id, $item->country_name);
         }
     }
     return $options;
 }

 protected function setCountries($limited = false)
 {
     // Create a new query object.
     $query = $this->db->getQuery(true);
     // Get from #__costbenefitprojection_country as a
     $query->select($this->db->quoteName(array('a.id', 'a.name'), array('id', 'name')));
     $query->from($this->db->quoteName('#__costbenefitprojection_country', 'a'));
     if ($limited) {
         // get his countries
         $ids = CostbenefitprojectionHelper::hisCountries($this->user->id);
         // limit to only load his countries
         $query->where('a.id IN (' . implode(',', $ids) . ')');
     } else {
         $query->where('CHAR_LENGTH(a.causesrisks) > 5');
         $query->where('CHAR_LENGTH(a.percentfemale) > 5');
         $query->where('CHAR_LENGTH(a.percentmale) > 5');
         $query->where('CHAR_LENGTH(a.datayear) > 3');
         $query->where('CHAR_LENGTH(a.productivity_losses) > 0');
         $query->where('CHAR_LENGTH(a.sick_leave) > 0');
         $query->where('CHAR_LENGTH(a.medical_turnovers) > 0');
     }
     $query->where('a.published = 1');
     $query->order('a.name ASC');
     // load the query
     $this->db->setQuery($query);
     $this->db->execute();
     if ($this->db->getNumRows()) {
         return $this->db->loadAssocList('id', 'name');
     }
     return false;
 }

 /**
  * Method to get list export data.
  *
  * @return mixed  An array of data items on success, false on failure.
  */
 public function getExportData($pks)
 {
     // setup the query
     if (CostbenefitprojectionHelper::checkArray($pks)) {
         // Set a value to know this is exporting method.
         $_export = true;
         // Get the user object.
         $user = JFactory::getUser();
         // Create a new query object.
         $db = JFactory::getDBO();
         $query = $db->getQuery(true);
         // Select some fields
         $query->select('a.*');
         // From the costbenefitprojection_health_data table
         $query->from($db->quoteName('#__costbenefitprojection_health_data', 'a'));
         $query->where('a.id IN (' . implode(',', $pks) . ')');
         // Filter by countries (admin sees all)
         if (!$user->authorise('core.options', 'com_costbenefitprojection')) {
             $is = CostbenefitprojectionHelper::userIs($user->id);
             $countries = CostbenefitprojectionHelper::hisCountries($user->id);
             if (3 == $is && CostbenefitprojectionHelper::checkArray($countries)) {
                 $countries = implode(',', $countries);
                 // only load this users health data
                 $query->where('a.country IN (' . $countries . ')');
             } else {
                 // dont allow user to see any health data
                 $query->where('a.country = -4');
             }
         }
         // Implement View Level Access
         if (!$user->authorise('core.options', 'com_costbenefitprojection')) {
             $groups = implode(',', $user->getAuthorisedViewLevels());
             $query->where('a.access IN (' . $groups . ')');
         }
         // Order the results by ordering
         $query->order('a.ordering  ASC');
         // Load the items
         $db->setQuery($query);
         $db->execute();
         if ($db->getNumRows()) {
             $items = $db->loadObjectList();
             // set values to display correctly.
             if (CostbenefitprojectionHelper::checkArray($items)) {
                 // get user object.
                 $user = JFactory::getUser();
                 foreach ($items as $nr => &$item) {
                     $access = $user->authorise('health_data.access', 'com_costbenefitprojection.health_data.' . (int) $item->id) && $user->authorise('health_data.access', 'com_costbenefitprojection');
                     if (!$access) {
                         unset($items[$nr]);
                         continue;
                     }
                     // unset the values we don't want exported.
                     unset($item->asset_id);
                     unset($item->checked_out);
                     unset($item->checked_out_time);
                 }
             }
             // Add headers to items array.
             $headers = $this->getExImPortHeaders();
             if (CostbenefitprojectionHelper::checkObject($headers)) {
                 array_unshift($items, $headers);
             }
             return $items;
         }
     }
     return false;
 }