1 files changed, 51 insertions, 0 deletions
diff --git a/pdf/1 b/pdf/1
new file mode 100755
index 0000000..c795012
--- /dev/null
+++ b/pdf/1
@@ -0,0 +1,51 @@
+<?php
+	function _list_all_certificates()
+	{
+		global $user;
+                $uid1 = $user->uid;
+
+                $query2 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status=3 AND uid=".$user->uid);
+                $data2 = db_fetch_object($query2);
+                if($data2->id)
+                {
+                        $search_rows = array();
+                        global $output;
+			$output = '';
+                        $query3 = db_query("SELECT * FROM textbook_companion_preference WHERE approval_status=1 AND proposal_id=".$data2->id);
+
+                        while ($search_data3 = db_fetch_object($query3))
+                        {
+  $search_rows[] = array($search_data3->isbn,$search_data3->book,$search_data3->author,l('Download Certificate', 'certificate/generate_pdf/'.$search_data3->id));
+                        }
+                        if ($search_rows)
+                        {
+                                $search_header = array('ISBN', 'Book Name', 'Author', 'Download Certificates');
+                                $output = theme_table($search_header, $search_rows);
+				return $output;
+                        }
+                        else
+                        {
+                                echo("Error");
+				return '';
+                        }
+                }
+                else
+                {
+                        $query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid=".$user->uid);
+	                $data3 = db_fetch_object($query2);
+			var_dump($query3);
+			die;
+			if($data3)
+			{
+				drupal_set_message('<strong>Your book is still under Review!</strong>', 'status');	
+				return '';
+			}
+			else
+			{
+				drupal_set_message('<strong>You need to propose a book <a href="/proposal">Book Proposal</a></strong>', 'status');
+				return '';
+			}
+                }
+
+}               
+?>