trying to implement natural sorting

1 files changed, 4 insertions, 2 deletions

diff --git a/tbc/views.py b/tbc/views.py
index 5167978..21f059c 100755
--- a/tbc/views.py
+++ b/tbc/views.py
@@ -451,7 +451,8 @@ def BookDetails(request, book_id=None):
         else:
             context['user'] = request.user
     book = Book.objects.get(id=book_id)
-    chapters = Chapters.objects.filter(book=book).order_by('name','pk')
+    query = 'SELECT * from tbc_chapters where book_id = (SELECT id from tbc_book where id='+book_id+') ORDER BY LENGTH(name), name;'
+    chapters = Chapters.objects.raw(query)
     images = ScreenShots.objects.filter(book=book)
     context['chapters'] = chapters
     context['images'] = images
@@ -464,7 +465,8 @@ def BookReview(request, book_id=None):
     if is_reviewer(request.user):
         if book_id:
             book = Book.objects.get(id=book_id)
-            chapters = Chapters.objects.filter(book=book).order_by('id')
+            query = 'SELECT * from tbc_chapters where book_id = (SELECT id from tbc_book where id='+book_id+') ORDER BY LENGTH(name), name;'
+            chapters = Chapters.objects.raw(query)
             images = ScreenShots.objects.filter(book=book)
             context['chapters'] = chapters
             context['images'] = images