diff options
| author | Sashi20 | 2024-07-30 11:10:03 +0530 |
|---|---|---|
| committer | Sashi20 | 2024-07-30 11:10:03 +0530 |
| commit | 66a6be5f43f9e721a09a80025ddf2f171aa28ef0 (patch) | |
| tree | d23021a64ce570bc649e7a6577efd815f4fe8603 | |
| parent | b31c2a82aba2aabe1f708ed26a979d759a8e409a (diff) | |
| download | r_textbook_companion-66a6be5f43f9e721a09a80025ddf2f171aa28ef0.tar.gz r_textbook_companion-66a6be5f43f9e721a09a80025ddf2f171aa28ef0.tar.bz2 r_textbook_companion-66a6be5f43f9e721a09a80025ddf2f171aa28ef0.zip | |
Arrange completion date in descending order
| -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 b3d2ebe..e32e3a5 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 po.completion_date"); + AND pe.id = tcbm.pref_id ORDER BY po.completion_date DESC"); $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 po.completion_date"); + AND pe.id = tcbm.pref_id GROUP BY pe.id having c >= 1 ORDER BY po.completion_date DESC"); } //$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 po.completion_date", 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 DESC", 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 ORDER BY po.completion_date", array( + AND pe.id = tcbm.pref_id AND loc.category_id= :category_id AND tcbm.sub_category = :sub_category ORDER BY po.completion_date DESC", array( "category_id" => $category_default_value, ":sub_category" => $subcategory_default_value )); |