diff options
| author | Sashi20 | 2024-07-30 11:06:24 +0530 |
|---|---|---|
| committer | Sashi20 | 2024-07-30 11:06:24 +0530 |
| commit | b31c2a82aba2aabe1f708ed26a979d759a8e409a (patch) | |
| tree | 530e2e4e097cfb5cd6307da59164818f0bdf7403 | |
| parent | c377ceb56c51deabccb2d4db3319c19e9aef6998 (diff) | |
| download | r_textbook_companion-b31c2a82aba2aabe1f708ed26a979d759a8e409a.tar.gz r_textbook_companion-b31c2a82aba2aabe1f708ed26a979d759a8e409a.tar.bz2 r_textbook_companion-b31c2a82aba2aabe1f708ed26a979d759a8e409a.zip | |
Order completed books by completion date
| -rwxr-xr-x | display_books.inc | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/display_books.inc b/display_books.inc index 11d64b1..b3d2ebe 100755 --- a/display_books.inc +++ b/display_books.inc @@ -169,7 +169,7 @@ function tbc_books_display_new_category_form($form, &$form_state) LEFT JOIN textbook_companion_book_main_subcategories tcbm ON pe.id = tcbm.pref_id LEFT JOIN list_of_category loc ON tcbm.main_category = loc.category_id WHERE po.proposal_status = 3 AND pe.approval_status = 1 - AND pe.id = tcbm.pref_id ORDER BY pe.book"); + AND pe.id = tcbm.pref_id ORDER BY po.completion_date"); $count_row = $countresult->fetchObject(); $book_count = $count_row->c; $form['completed_book_count'] = array( @@ -305,7 +305,7 @@ function _list_of_all_completed_books($category_default_value = NULL, $subcatego LEFT JOIN textbook_companion_book_main_subcategories tcbm ON pe.id = tcbm.pref_id LEFT JOIN list_of_category loc ON tcbm.main_category = loc.category_id WHERE po.proposal_status = 3 AND pe.approval_status = 1 - AND pe.id = tcbm.pref_id GROUP BY pe.id having c >= 1 ORDER BY pe.book"); + AND pe.id = tcbm.pref_id GROUP BY pe.id having c >= 1 ORDER BY po.completion_date"); } //$category_default_value <= 0 && $subcategory_default_value == NULL elseif ($category_default_value > 0 && $subcategory_default_value == NULL) { @@ -317,7 +317,7 @@ function _list_of_all_completed_books($category_default_value = NULL, $subcatego LEFT JOIN textbook_companion_book_main_subcategories tcbm ON pe.id = tcbm.pref_id LEFT JOIN list_of_category loc ON tcbm.main_category = loc.category_id WHERE po.proposal_status = 3 AND pe.approval_status = 1 - AND pe.id = tcbm.pref_id AND loc.category_id= :category_id GROUP BY pe.id having c >= 1 ORDER BY pe.book", array( + AND pe.id = tcbm.pref_id AND loc.category_id= :category_id GROUP BY pe.id having c >= 1 ORDER BY po.completion_date", array( "category_id" => $category_default_value )); } //$category_default_value > 0 && $subcategory_default_value == NULL @@ -331,7 +331,7 @@ function _list_of_all_completed_books($category_default_value = NULL, $subcatego LEFT JOIN textbook_companion_book_main_subcategories tcbm ON pe.id = tcbm.pref_id LEFT JOIN list_of_category loc ON tcbm.main_category = loc.category_id WHERE po.proposal_status = 3 AND pe.approval_status = 1 - AND pe.id = tcbm.pref_id AND loc.category_id= :category_id AND tcbm.sub_category = :sub_category", array( + AND pe.id = tcbm.pref_id AND loc.category_id= :category_id AND tcbm.sub_category = :sub_category ORDER BY po.completion_date", array( "category_id" => $category_default_value, ":sub_category" => $subcategory_default_value )); |