Views handler for profile.module - number field

merlinofchaos - thanks for the tip and links to the new documentation.

I didn't explain myself too well. I'll need to do two things with my new number profile field:

1) filter in views by greater than / less than
2) sort in views by number value

Both of these goals get tripped up by the fact the profile.module is storing the number as text in the database. I've solved #1 with the following code:

// this is added to the filter
      $others = array(
        'list-type' => 'list',
        'operator' => 'views_handler_operator_gtlt',
        'handler' => 'views_handler_filter_profile_number',
      );

// this is the handler
function views_handler_filter_profile_number($op, $filter, $filterinfo, &$query) {
  switch (trim($filter['value'])) {
    case (''):
      return;
      break;
  }
  switch ($op) {
    case 'handler':
      $table = $filterinfo['table'];
      $column = $filterinfo['field'];
      $field = "$table.$column";
      $query->ensure_table($table);

          $query->add_where("(%s + 0) {$filter['operator']} %d",
            $field, $filter['value']);
    break;
  }
}

The sort code is still giving me problems. I've read the documentation but I must be missing this point. Here is my sort function:

// this is added to the filter
      $others = array(
        'sortable' => true,
		'sort_handler' => 'views_handler_sort_profile_number',
		);

// this is the sort handler 
function views_handler_sort_profile_number($op, &$query, $sortinfo, $sort) {

  $table = $sortinfo['table'];
  $field = "(value + 0)";

  $query->add_field($field, $table);
  $query->orderby[] = "$field $sort[sortorder]";
}

Any pointer or suggestions would be greatly appreciated.

Thanks,

Jason

Thank you for putting me on the right track. I think I'm close, but the views sorting still doesn't work for me. Here are the settings I have:

For the array:

    [profile_producer_total] => Array
    (
        [name] => profile_values
        [provider] => internal
        [join] => Array
        (
            [left] => Array
            (
                [table] => users
                [field] => uid
            )
            [right] => Array
            (
                [field] => uid
            )
            [extra] => Array
            (
                [fid] => 4
            )
        )
        [fields] => Array
        (
            [value] => Array
            (
                [name] => Profile: Received money
                [help] => Number based profile field help
                [sortable] => 1
            )
        )
        [sorts] => Array
        (
            [value] => Array
            (
                [name] => Profile: Received money
                [help] => Number based profile field help
                [sort_handler] => views_handler_sort_profile_number
            )
        )
        [filters] => Array
        (
            [value] => Array
            (
                [name] => Profile: Received money
                [help] => Number based profile field help
                [list-type] => list
                [operator] => views_handler_operator_gtlt
                [handler] => views_handler_filter_profile_number
            )
        )
    )

and for the functions:

/**
 * Custom filter handler for converting numbers in profile_value.value 
 * (stored as text) to a number 
 */
function views_handler_filter_profile_number($op, $filter, $filterinfo, &$query) {
  switch (trim($filter['value'])) {
    case (''):
      return;
      break;
  }
  switch ($op) {
    case 'handler':
      $table = $filterinfo['table'];
      $column = $filterinfo['field'];
      $field = "$table.$column";
      $query->ensure_table($table);

          $query->add_where("(%s + 0) {$filter['operator']} %d",
            $field, $filter['value']);
    break;
  }
}

/**
 * Custom sort handler for converting numbers in profile_value.value 
 * (stored as text) to a number 
 */
function views_handler_sort_profile_number($op, &$query, $sortinfo, $sort) {
  $field = "(profile_values.value + 0)";
  $query->add_orderby(NULL,$field, $sort['sortorder']);
}

Thanks again for all the help. If this works - this could be used as a helper function for those who need to treat a textfield as a number.