function farm_soil_nrcs_stir_autocomplete in farmOS 7

Autocomplete callback for STIR operations.

1 string reference to 'farm_soil_nrcs_stir_autocomplete'

farm_soil_nrcs_menu in modules/farm/farm_soil/farm_soil_nrcs/farm_soil_nrcs.module

Implements hook_menu().

File

modules/farm/farm_soil/farm_soil_nrcs/farm_soil_nrcs.module, line 23

Code for the Farm Soil NRCS feature.

Code

function farm_soil_nrcs_stir_autocomplete($string) {
  $matches = array();
  $query = db_select('farm_soil_nrcs_stir', 'fsns');
  $query
    ->fields('fsns', array(
    'operation',
  ));
  $query
    ->condition('fsns.operation', '%' . db_like($string) . '%', 'LIKE');
  $query
    ->range(0, 10);
  $result = $query
    ->execute();
  foreach ($result as $row) {
    $matches[$row->operation] = check_plain($row->operation);
  }
  drupal_json_output($matches);
}