diff options
| -rwxr-xr-x | tbc/views.py | 6 |
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 |