Enables editing of ForeignKey, ManyToMany and CharField using jQuery UI Autocomplete.

User experience

selecting:

selected:

[Note: screen shots are from the older version. Styling has changed slightly]

1. The user types a search term into the text field
2. An ajax request is sent to the server.
3. The dropdown menu is populated with results.
4. User selects by clicking or using arrow keys
5. Selected result displays in the "deck" area directly below the input field.
6. User can click trashcan icon to remove a selected item

Features

• Django 1.2+
• Optional boostrap mode allows easy installation by automatic inclusion of jQueryUI from the googleapis CDN
• Compatible with staticfiles, appmedia, django-compressor etc
• Popup to add a new item is supported
• Admin inlines now supported
• Ajax Selects works in the admin and also in public facing forms.
• Rich formatting can be easily defined for the dropdown display and the selected "deck" display.
• Templates and CSS are fully customizable
• JQuery triggers enable you to add javascript to respond when items are added or removed, so other interface elements on the page can react
• Default (but customizable) security prevents griefers from pilfering your data via JSON requests

Quick Installation

Get it

`pip install django-ajax-selects`

or easy_install django-ajax-selects or download or checkout the distribution or install using buildout by adding django-ajax-selects to your eggs

on fedora: su -c 'yum install django-ajax-selects' (note: this version may not be up to date)

In settings.py :

# add the app
INSTALLED_APPS = (
            ...,
            'ajax_select'
            )

# define the lookup channels in use on the site
AJAX_LOOKUP_CHANNELS = {
    #   pass a dict with the model and the field to search against
    'person'  : {'model':'example.person', 'search_field':'name'}
}
# magically include jqueryUI/js/css
AJAX_SELECT_BOOTSTRAP = True
AJAX_SELECT_INLINES = 'inline'

In your urls.py:

from django.conf.urls.defaults import *

from django.contrib import admin
from ajax_select import urls as ajax_select_urls

admin.autodiscover()

urlpatterns = patterns('',
    # include the lookup urls
    (r'^admin/lookups/', include(ajax_select_urls)),
    (r'^admin/', include(admin.site.urls)),
)

In your admin.py:

from django.contrib import admin
from ajax_select import make_ajax_form
from ajax_select.admin import AjaxSelectAdmin
from example.models import *

class PersonAdmin(admin.ModelAdmin):
    pass
admin.site.register(Person,PersonAdmin)

# subclass AjaxSelectAdmin
class LabelAdmin(AjaxSelectAdmin):
    # create an ajax form class using the factory function
    #                     model,fieldlist,   [form superclass]
    form = make_ajax_form(Label,{'owner':'person'})
admin.site.register(Label,LabelAdmin)

This setup will give most people the ajax powered editing they need by bootstrapping in JS/CSS and implementing default security and simple ajax lookup channels.

NOT SO QUICK INSTALLATION

Things that can be customized:

• how and from where jQuery, jQueryUI, jQueryUI theme are loaded
• whether to include js/css inline or for better performance via staticfiles or django-compress etc.
• define custom LookupChannel classes to customize:
  • HTML formatting for the drop down results and the item-selected display
  • custom search queries, ordering, user specific filtered results
  • custom channel security (default is staff only)
• customizing the CSS
• each channel could define its own template to change display or add extra javascript
• custom javascript can respond to jQuery triggers when items are selected or removed

Architecture

A single view services all of the ajax search requests, delegating the searches to named 'channels'. Each model that needs to be searched for has a channel defined for it. More than one channel may be defined for a Model to serve different needs such as public vs admin or channels that filter the query by specific categories etc. The channel also has access to the request and the user so it can personalize the query results. Those channels can be reused by any Admin that wishes to lookup that model for a ManyToMany or ForeignKey field.

A simple channel can be specified in settings.py, a more complex one (with custom search, formatting, personalization or auth requirements) can be written in a lookups.py file.

There are three model field types with corresponding form fields and widgets:

Database field	Form field	Form widget
models.CharField	AutoCompleteField	AutoCompleteWidget
models.ForeignKey	AutoCompleteSelectField	AutoCompleteSelectWidget
models.ManyToManyField	AutoCompleteSelectMultipleField	AutoCompleteSelectMultipleWidget

Generally the helper functions documented below can be used to generate a complete form or an individual field (with widget) for a form. In rare cases you might need to specify the ajax form field explicitly in your Form.

Example App

See the example app for a full working admin site with many variations and comments. It installs quickly using virtualenv and sqllite and comes fully configured.

settings.py

AJAX_LOOKUP_CHANNELS

Defines the available lookup channels.

• channel_name : {'model': 'app.modelname', 'search_field': 'name_of_field_to_search' }

This will create a channel automatically

chanel_name : ( 'app.lookups', 'YourLookup' )
    This points to a custom Lookup channel name YourLookup in app/lookups.py

AJAX_LOOKUP_CHANNELS = {
    #   channel : dict with settings to create a channel
    'person'  : {'model':'example.person', 'search_field':'name'},
    
    # channel: ( module.where_lookup_is, ClassNameOfLookup )
    'song'   : ('example.lookups', 'SongLookup'),
}

AJAX_SELECT_BOOTSTRAP

Sets if it should automatically include jQuery/jQueryUI/theme. On large formsets this will cause it to check each time but it will only jQuery the first time.

• True: [easiest] use jQuery if already present, else use the admin's jQuery else load from google's CDN use jqueryUI if present else load from google's CDN use jqueryUI theme if present else load one from google's CDN

• False/None/Not set: [default] you should then include jQuery, jqueryUI + theme in your template or js compressor stack

AJAX_SELECT_INLINES

This controls if and how these:

ajax_select/static/js/ajax_select.js 
ajax_select/static/css/ajax_select.css 

are included inline in the html with each form field.

• 'inline': [easiest] Includes the js and css inline This gets you up and running easily and is fine for small sites. But with many form fields this will be less efficient.

• 'staticfiles': @import the css/js from {{STATIC_URL}}/ajax_selects using django.contrib.staticfiles Requires staticfiles to be installed and to run its management command to collect files. This still imports the css/js multiple times and is thus inefficient but otherwise harmless.

  When using staticfiles you may implement your own ajax_select.css and customize to taste as long as your app is before ajax_select in the INSTALLED_APPS.

• False/None: [default] Does not inline anything. You should include the css/js files in your compressor stack or include them in the head of the admin/base_site.html template. This is the most efficient but takes the longest to configure.

urls.py

Simply include the ajax_select urls in your site's urlpatterns:

from django.conf.urls.defaults import *

from django.contrib import admin
from ajax_select import urls as ajax_select_urls

admin.autodiscover()

urlpatterns = patterns('',
    (r'^admin/lookups/', include(ajax_select_urls)),
    (r'^admin/', include(admin.site.urls)),
)

lookups.py

By convention this is where you would define custom lookup channels

Subclass LookupChannel and override any method you wish to customize.

1.1x Upgrade note: previous versions did not have a parent class. The methods format_result and format_item have been renamed to format_match and format_item_display respectively. Those old lookup channels will still work and the previous methods will be used. It is still better to adjust your lookup channels to inherit from the new base class.

from ajax_select import LookupChannel
from django.utils.html import escape
from django.db.models import Q
from example.models import *

class PersonLookup(LookupChannel):

    model = Person

    def get_query(self,q,request):
        return Person.objects.filter(Q(name__icontains=q) | Q(email__istartswith=q)).order_by('name')

    def get_result(self,obj):
        u""" result is the simple text that is the completion of what the person typed """
        return obj.name

    def format_match(self,obj):
        """ (HTML) formatted item for display in the dropdown """
        return self.format_item_display(obj)

    def format_item_display(self,obj):
        """ (HTML) formatted item for displaying item in the selected deck area """
        return u"%s<div><i>%s</i></div>" % (escape(obj.name),escape(obj.email))

Note that raw strings should always be escaped with the escape() function

Methods you can override in your LookupChannel

model [property]

The model class this channel searches

min_length [property, default=1]

Minimum query length to return a result. Large datasets can choke if they search too often with small queries. Better to demand at least 2 or 3 characters. This param is also used in jQuery's UI when filtering results from its own cache.

search_field [property, optional]

Name of the field for the query to search with icontains. This is used only in the default get_query implementation. Usually better to just implement your own get_query

get_query(self,q,request)

return a query set searching for the query string q, ordering as appropriate. Either implement this method yourself or set the search_field property. Note that you may return any iterable so you can even use yield and turn this method into a generator, or return an generator or list comprehension.

get_result(self,obj):

The text result of autocompleting the entered query. This is currently displayed only for a moment in the text field after the user has selected the item. Then the item is displayed in the item_display deck and the text field is cleared. Future versions may offer different handlers for how to display the selected item(s). In the current version you may add extra script and use triggers to customize.

format_match(self,obj):

(HTML) formatted item for displaying item in the result dropdown

format_item_display(self,obj):

(HTML) formatted item for displaying item in the selected deck area (directly below the text field). Note that we use jQuery .position() to correctly place the deck area below the text field regardless of whether the widget is in the admin, and admin inline or an outside form. ie. it does not depend on django's admin css to correctly place the selected display area.

get_objects(self,ids):

Get the currently selected objects when editing an existing model

Note that the order of the ids supplied for ManyToMany fields is dependent on how the objects manager fetches it. ie. what is returned by yourmodel.fieldname_set.all()

In most situations (especially postgres) this order is random, not the order that you originally added them in the interface. With a bit of hacking I have convinced it to preserve the order [see OrderedManyToMany.md for solution]

can_add(self,user,argmodel):

Check if the user has permission to add one of these models. This enables the green popup + Default is the standard django permission check

check_auth(self,request):

To ensure that nobody can get your data via json simply by knowing the URL. The default is to limit it to request.user.is_staff and raise a PermissionDenied exception. By default this is an error with a 401 response, but your middleware may intercept and choose to do other things.

Public facing forms should write a custom LookupChannel to implement as needed. Also you could choose to return HttpResponseForbidden("who are you?") instead of raising PermissionDenied

admin.py

make_ajax_form(model,fieldlist,superclass=ModelForm,show_m2m_help=False)

If your application does not otherwise require a custom Form class then you can use the make_ajax_form helper to create the entire form directly in admin.py. See forms.py below for cases where you wish to make your own Form.

• model: your model
• fieldlist: a dict of {fieldname : channel_name, ... }
• superclass: [default ModelForm] Substitute a different superclass for the constructed Form class.
• show_m2m_help: [default False] Leave blank [False] if using this form in a standard Admin. Set it True for InlineAdmin classes or if making a form for use outside of the Admin. See discussion below re: Help Text

######Example

from ajax_select import make_ajax_form
from ajax_select.admin import AjaxSelectAdmin
from yourapp.models import YourModel

class YourModelAdmin(AjaxSelectAdmin):
    # create an ajax form class using the factory function
    #                     model,fieldlist,   [form superclass]
    form = make_ajax_form(Label,{'owner':'person'})

admin.site.register(YourModel,YourModelAdmin)

You may use AjaxSelectAdmin as a mixin class and multiple inherit if you have another Admin class that you would like to use. You may also just add the hook into your own Admin class:

def get_form(self, request, obj=None, **kwargs):
    form = super(YourAdminClass,self).get_form(request,obj,**kwargs)
    autoselect_fields_check_can_add(form,self.model,request.user)
    return form

Note that ajax_selects does not need to be in an admin. Popups will still use an admin view (the registered admin for the model being added), even if the form from where the popup was launched does not.

forms.py

subclass ModelForm just as usual. You may add ajax fields using the helper or directly.

make_ajax_field(model,model_fieldname,channel,show_m2m_help = False,**kwargs)

A factory function to makes an ajax field + widget. The helper ensures things are set correctly and simplifies usage and imports thus reducing programmer error. All kwargs are passed into the Field so it is no less customizable.

• model: the model that this ModelForm is for
• model_fieldname: the field on the model that is being edited (ForeignKey, ManyToManyField or CharField)
• channel: the lookup channel to use for searches
• show_m2m_help: [default False] When using in the admin leave this as False. When using in AdminInline or outside of the admin then set it to True. see Help Text section below.

#####Example

from ajax_select import make_ajax_field

class ReleaseForm(ModelForm):

    class Meta:
        model = Release

    group  = make_ajax_field(Release,'group','group')

Using ajax selects in a FormSet

There is possibly a better way to do this, but here is an initial example:

forms.py

from django.forms.models import modelformset_factory
from django.forms.models import BaseModelFormSet
from ajax_select.fields import AutoCompleteSelectMultipleField, AutoCompleteSelectField

from models import *

# create a superclass
class BaseTaskFormSet(BaseModelFormSet):

    # that adds the field in, overwriting the previous default field
    def add_fields(self, form, index):
        super(BaseTaskFormSet, self).add_fields(form, index)
        form.fields["project"] = AutoCompleteSelectField('project', required=False)

# pass in the base formset class to the factory
TaskFormSet = modelformset_factory(Task,fields=('name','project','area'),extra=0,formset=BaseTaskFormSet)

templates/

Each form field widget is rendered using a template. You may write a custom template per channel and extend the base template in order to implement these blocks:

{% block extra_script %}{% endblock %}
{% block help %}{% endblock %}

form Field	tries this first	default template
AutoCompleteField	templates/autocomplete_{{CHANNELNAME}}.html	templates/autocomplete.html
AutoCompleteSelectField	templates/autocompleteselect_{{CHANNELNAME}}.html	templates/autocompleteselect.html
AutoCompleteSelectMultipleField	templates/autocompleteselectmultiple_{{CHANNELNAME}}.html	templates/autocompleteselectmultiple.html

See ajax_select/static/js/ajax_select.js below for the use of jQuery trigger events

ajax_select/static/css/ajax_select.css

If you are using django.contrib.staticfiles then you can implement ajax_select.css and put your app ahead of ajax_select to cause it to be collected by the management command collectfiles.

If you are doing your own compress stack then of course you can include whatever version you want.

The display style now uses the jQuery UI theme and actually I find the drop down to be not very charming. The previous version (1.1x) which used the external jQuery AutoComplete plugin had nicer styling. I might decide to make the default more like that with alternating color rows and a stronger sense of focused item. Also the current jQuery one wiggles.

The CSS refers to one image that is served from github (as a CDN): 'https://github.com/crucialfelix/django-ajax-selects/raw/master/ajax_select/static/images/loading-indicator.gif'

Your own site's CSS could redefine that with a stronger declaration to point to whatever you like.

The trashcan icon comes from the jQueryUI theme by the css classes:

"ui-icon ui-icon-trash"

The css declaration:

.results_on_deck .ui-icon.ui-icon-trash { }

would be "stronger" than jQuery's style declaration and thus you could make trash look less trashy.

ajax_select/static/js/ajax_select.js

You probably don't want to mess with this one. But by using the extra_script block as detailed in templates/ above you can add extra javascript, particularily to respond to event Triggers.

Triggers are a great way to keep code clean and untangled. see: http://docs.jquery.com/Events/trigger

Two triggers/signals are sent: 'added' and 'killed'. These are sent to the $("#{{html_id}}_on_deck") element. That is the area that surrounds the currently selected items.

Extend the template, implement the extra_script block and bind functions that will respond to the trigger:

multi select:

{% block extra_script %}
    $("#{{html_id}}_on_deck").bind('added',function() {
            id = $("#{{html_id}}").val();
            alert('added id:' + id );
    });
    $("#{{html_id}}_on_deck").bind('killed',function() {
            current = $("#{{html_id}}").val()
            alert('removed, current is:' + current);
    });
{% endblock %}

select:

{% block extra_script %}
    $("#{{html_id}}_on_deck").bind('added',function() {
            id = $("#{{html_id}}").val();
            alert('added id:' + id );
    });
    $("#{{html_id}}_on_deck").bind('killed',function() {
            alert('removed');
    });
{% endblock %}

auto-complete text field:

{% block extra_script %}
    $('#{{ html_id }}').bind('added',function() {
            entered = $('#{{ html_id }}').val();
            alert( entered );
    });
{% endblock %}

There is no remove as there is no kill/delete button in a simple auto-complete. The user may clear the text themselves but there is no javascript involved. Its just a text field.

Planned Improvements

TODO: + pop ups are not working in AdminInlines yet

Contributors

Many thanks to all who found bugs, asked for things, and hassled me to get a new release out. I'm glad people find good use out of the app.

In particular thanks for help in the 1.2 version: sjrd (Sébastien Doeraene), Brian May

License

Dual licensed under the MIT and GPL licenses: http://www.opensource.org/licenses/mit-license.php http://www.gnu.org/licenses/gpl.html