views.py

# Django
from django.template.response import TemplateResponse

# Django-DataTables
import datatables

# Django-FortuneCookie
from fortunecookie.models import *


class FortuneCookieTable(datatables.DataTable):

    # pk = datatables.CheckboxColumn()
    fortune = datatables.Column(
        label='Your Fortune',
        sort_field='fortune_lower',
    )

    fortune_lower = datatables.Column(
        label='Lower Fortune',
        bVisible=False,
        bSearchable=False,
    )

    lucky_numbers = datatables.Column(
        display_field='lucky_numbers_display',
        sClass='okie',
        asSorting=["asc", "desc", "desc"],
        bSearchable=False,
    )

    chinese_word = datatables.Column(
        label='Chinese Word',
        sort_field='chinese_word.english_word',
        search_field='chinese_word.english_word',
        sClass='okie',
        # bSearchable=False,
    )

    def get_queryset(self):
        qs = self.get_default_queryset()
        qs = qs.extra(select={
            'fortune_lower': 'LOWER(fortune)',
        })
        return qs

    class Meta:
        model = FortuneCookie
        bInfo = True
        bSort = True
        bPaginate = False
        bJQueryUI = True
        sScrollY = '200px'
        aaSorting = [[2, "desc"]]
        aLengthMenu = [[3, 10, 25, 50, -1], [3, 10, 25, 50, "All"]]
        # fnInitComplete = '''function(oSettings, json) {
        #    alert("Init Complete!"); }'
        # bServerSide = True
        # sAjaxSource = '/'
        # fnServerData = '''function( sUrl, aoData, fnCallback ) {
        #     $.ajax( {
        #         "url": sUrl,
        #         "data": aoData,
        #         "success": fnCallback,
        #         "dataType": "jsonp",
        #         "cache": false} );}'''


@datatables.datatable(FortuneCookieTable, name='fct')
def index(request):
    qs = request.fct.get_queryset()
    request.fct.update_queryset(qs)
    return TemplateResponse(request, 'index.html', {'table': request.fct})