PHP DatabaseManager::getTablePrefix方法代码示例

 /**
  * Builds the necessary fields on the object
  *
  * @return void
  */
 public function build()
 {
     $model = $this->config->getDataModel();
     $options = $this->suppliedOptions;
     $this->tablePrefix = $this->db->getTablePrefix();
     //set some options-based defaults
     $options['title'] = $this->validator->arrayGet($options, 'title', $options['column_name']);
     $options['sort_field'] = $this->validator->arrayGet($options, 'sort_field', $options['column_name']);
     //if the supplied item is an accessor, make this unsortable for the moment
     if (method_exists($model, camel_case('get_' . $options['column_name'] . '_attribute')) && $options['column_name'] === $options['sort_field']) {
         $options['sortable'] = false;
     }
     //however, if this is not a relation and the select option was supplied, str_replace the select option and make it sortable again
     if ($select = $this->validator->arrayGet($options, 'select')) {
         $options['select'] = str_replace('(:table)', $this->tablePrefix . $model->getTable(), $select);
     }
     //now we do some final organization to categorize these columns (useful later in the sorting)
     if (method_exists($model, camel_case('get_' . $options['column_name'] . '_attribute')) || $select) {
         $options['is_computed'] = true;
     } else {
         $options['is_included'] = true;
     }
     //run the visible property closure if supplied
     $visible = $this->validator->arrayGet($options, 'visible');
     if (is_callable($visible)) {
         $options['visible'] = $visible($this->config->getDataModel()) ? true : false;
     }
     $this->suppliedOptions = $options;
 }

 /**
  * Given a model, field, type (filter or edit), and constraints (either int or array), returns an array of options
  *
  * @param string	$field
  * @param string	$type			//either 'filter' or 'edit'
  * @param array		$constraints	//an array of ids of the other model's items
  * @param array		$selectedItems	//an array of ids that are currently selected
  * @param string	$term			//the search term
  *
  * @return array
  */
 public function updateRelationshipOptions($field, $type, $constraints, $selectedItems, $term = null)
 {
     //first get the related model and fetch the field's options
     $model = $this->config->getDataModel();
     $relatedModel = $model->{$field}()->getRelated();
     $relatedTable = $relatedModel->getTable();
     $relatedKeyName = $relatedModel->getKeyName();
     $relatedKeyTable = $relatedTable . '.' . $relatedKeyName;
     $fieldObject = $this->getFieldObjectByName($field, $type);
     //if we can't find the field, return an empty array
     if (!$fieldObject) {
         return array();
     }
     //make sure we're grouping by the model's id
     $query = $relatedModel->newQuery();
     //set up the selects
     $query->select(array($this->db->raw($this->db->getTablePrefix() . $relatedTable . '.*')));
     //format the selected items into an array
     $selectedItems = $this->formatSelectedItems($selectedItems);
     //if this is an autocomplete field, check if there is a search term. If not, just return the selected items
     if ($fieldObject->getOption('autocomplete') && !$term) {
         if (sizeof($selectedItems)) {
             $this->filterQueryBySelectedItems($query, $selectedItems, $fieldObject, $relatedKeyTable);
             return $this->formatSelectOptions($fieldObject, $query->get());
         } else {
             return array();
         }
     }
     //applies constraints if there are any
     $this->applyConstraints($constraints, $query, $fieldObject);
     //if there is a search term, limit the result set by that term
     $this->filterBySearchTerm($term, $query, $fieldObject, $selectedItems, $relatedKeyTable);
     //perform any user-supplied options filter
     $filter = $fieldObject->getOption('options_filter');
     $filter($query);
     //finally we can return the options
     return $this->formatSelectOptions($fieldObject, $query->get());
 }