diff options
Diffstat (limited to 'pdf/list_all_certificates.inc')
| -rwxr-xr-x | pdf/list_all_certificates.inc | 174 |
1 files changed, 95 insertions, 79 deletions
diff --git a/pdf/list_all_certificates.inc b/pdf/list_all_certificates.inc index e094d5f..57d1a49 100755 --- a/pdf/list_all_certificates.inc +++ b/pdf/list_all_certificates.inc @@ -1,97 +1,113 @@ <?php /* function _list_all_certificates() - { - global $user; - $uid1 = $user->uid; +{ +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); +$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 ''; - } - } +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= :uid", array( + ':uid' => $user->uid + )); + $exist_id = $query_id->fetchObject(); + if ($exist_id->id) { - global $user; - $query_id =db_query("SELECT id FROM textbook_companion_proposal WHERE proposal_status=3 AND uid= :uid", array(':uid' => $user->uid)); - $exist_id = $query_id->fetchObject(); - 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 ''; + } //$exist_id->id < 3 + else { - if($exist_id->id<3) + $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= :uid", array( + ':uid' => $user->uid + )); + while ($search_data3 = $query3->fetchObject()) { - drupal_set_message('<strong>You need to propose a book <a href="/proposal">Book Proposal</a></strong>', 'status'); - return ''; - } - else + 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) + ); + } //$search_data3->id + } //$search_data3 = $query3->fetchObject() + if ($search_rows) { - $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= :uid",array(':uid' => $user->uid)); - while ($search_data3 = $query3->fetchObject()) - { - if($search_data3->id) + $search_header = array( + 'ISBN', + 'Book Name', + 'Author', + 'Download Certificates' + ); + $output = theme('table', array( + 'header' => $search_header, + 'rows' => $search_rows + )); + return $output; + } //$search_rows + else { - $search_rows[] = array($search_data3->isbn,$search_data3->book,$search_data3->author,l('Download Certificate', 'certificate/generate_pdf/'.$search_data3->id)); + echo ("Error"); + return ''; } } - if($search_rows) - { - $search_header = array('ISBN', 'Book Name', 'Author', 'Download Certificates'); - $output = theme('table',array('header'=>$search_header, 'rows'=>$search_rows)); - return $output; - } - else - { - echo("Error"); - return ''; - } - } - } + } //$exist_id->id else { drupal_set_message('<strong>You need to propose a book <a href="/proposal">Book Proposal</a></strong>', 'status'); - return ''; + return ''; } -} +} ?> |