diff options
Diffstat (limited to 'pdf')
| -rwxr-xr-x | pdf/generate_pdf.inc | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/pdf/generate_pdf.inc b/pdf/generate_pdf.inc index af9e361..5dd91c5 100755 --- a/pdf/generate_pdf.inc +++ b/pdf/generate_pdf.inc @@ -11,10 +11,16 @@ function generate_pdf() ':prop_id' => $proposal_id )); $data2 = $query2->fetchObject(); - $query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id= :prop_id", array( + $query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id= :prop_id AND proposal_status =3", array( ':prop_id' => $proposal_id )); $data3 = $query3->fetchObject(); + if($data3){ + if($data3->uid != $x){ + drupal_set_message('Certificate is not available','error'); + return; + } + } $query4 = db_query("SELECT COUNT( tce.id ) AS example_count FROM textbook_companion_example tce LEFT JOIN textbook_companion_chapter tcc ON tce.chapter_id = tcc.id LEFT JOIN textbook_companion_preference tcpe ON tcc.preference_id = tcpe.id @@ -23,6 +29,10 @@ function generate_pdf() ':prop_id' => $proposal_id )); $data4 = $query4->fetchObject(); + if($data4->example_count == 0) { + drupal_set_message('Certificate is not available','error'); + return; + } $number_of_example = $data4->example_count; $gender = array( 'salutation' => 'Mr. /Ms.', |