private function _getValueCounts($field_id)
{
$db = DevblocksPlatform::getDatabaseService();
// Selected custom field
if (null == ($field = DAO_CustomField::get($field_id))) {
return;
}
if (null == ($table = DAO_CustomFieldValue::getValueTableName($field_id))) {
return;
}
$sql = sprintf("SELECT field_value, count(field_value) AS hits " . "FROM %s " . "WHERE source_extension = %s " . "AND field_id = %d " . "GROUP BY field_value", $table, $db->qstr($field->source_extension), $field->id);
$rs_values = $db->Execute($sql);
$value_counts = array();
while (!$rs_values->EOF) {
$value = $rs_values->fields['field_value'];
$hits = intval($rs_values->fields['hits']);
$value_counts[$value] = intval($hits);
$rs_values->MoveNext();
}
arsort($value_counts);
return $value_counts;
}
