<?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)
		/*while($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($query3);
			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 '';
			}
                }
//}
} */            

function _list_all_certificates()
	{
		global $user;
		$query_id =db_query("SELECT id FROM textbook_companion_proposal WHERE proposal_status=3 AND uid=".$user->uid);
		$exist_id = db_fetch_object($query_id);
		if($exist_id->id)
		{
			if($exist_id->id<3)
			{
				drupal_set_message('<strong>You need to propose a book <a href="/proposal">Book Proposal</a></strong>', 'status');
				return '';
			}
			else
			{
		$search_rows = array();
		global $output;
		$output = '';
		$query3 = db_query("SELECT prop.id,pref.isbn,pref.book,pref.author FROM textbook_companion_proposal as prop,textbook_companion_preference as pref WHERE prop.proposal_status=3 AND pref.approval_status=1 AND pref.proposal_id=prop.id AND prop.uid=".$user->uid);
		while ($search_data3 = db_fetch_object($query3))
		{
			if($search_data3->id)
			{
			$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
	{
		drupal_set_message('<strong>You need to propose a book <a href="/proposal">Book Proposal</a></strong>', 'status');
						return '';
	}
}  
?>