diff options
Diffstat (limited to 'pdf/list_all_certificates.inc')
| -rwxr-xr-x | pdf/list_all_certificates.inc | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/pdf/list_all_certificates.inc b/pdf/list_all_certificates.inc new file mode 100755 index 0000000..4895a84 --- /dev/null +++ b/pdf/list_all_certificates.inc @@ -0,0 +1,49 @@ +<?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($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 ''; + } + } + +} +?> |