1 files changed, 54 insertions, 0 deletions
diff --git a/display_books.inc b/display_books.inc
new file mode 100644
index 0000000..dd8706d
--- /dev/null
+++ b/display_books.inc
@@ -0,0 +1,54 @@
+<?php
+/* function to display books in progress */
+function tbc_books_in_progress_all()
+{
+	$output = "";
+	$query = db_select('list_of_category');
+	$query->fields('list_of_category');
+	$query->orderBy('id', 'ASC');
+	$category_list = $query->execute();
+	
+	$query = "
+  SELECT po.creation_date, pe.book as book, pe.author as author, pe.publisher as publisher,pe.edition as edition, pe.isbn as isbn, pe.year as year, pe.id as pe_id, loc.category_name as category, loc.category_id as cat_id
+FROM textbook_companion_preference pe 
+LEFT JOIN textbook_companion_proposal po ON pe.proposal_id = po.id
+LEFT JOIN list_of_category loc on pe.category = loc.category_id
+WHERE po.proposal_status IN (1,4) AND pe.approval_status = 1  
+ORDER BY po.creation_date DESC
+  ";
+	$result = db_query($query);
+	$proposal_rows = array();
+	$i = 1;
+	$category_data = _tbc_list_of_category($preference_data->category);
+	$output = "<hr>";
+	while ($row = $result->fetchObject())
+	{
+		$proposal_date = date("d-m-Y", $row->creation_date); // remove comment to display year
+		if ($row->category != NULL)
+		{
+			$category = $row->category;
+		} //$row->category != NULL
+		else
+		{
+			$category = "Not assigned";
+		}
+		$preference_rows[] = array(
+			$i,
+			$proposal_date,
+			$row->book . "<br><br>[ Author: " . $row->author . ", Publisher: " . $row->publisher . ", Year: " . $row->year . ", Edition: " . $row->edition . ", ISBN: " . $row->isbn . " ]",
+			$category
+		);
+		$i++;
+	} //$row = $result->fetchObject()
+	$preference_header = array(
+		'No',
+		'Proposal Date',
+		'Book',
+		'Category'
+	);
+	$output .= theme('table', array(
+		'header' => $preference_header,
+		'rows' => $preference_rows
+	));
+	return $output;
+}