summaryrefslogtreecommitdiff
path: root/pdf/m_tbc_generate_pdf.inc
diff options
context:
space:
mode:
Diffstat (limited to 'pdf/m_tbc_generate_pdf.inc')
-rwxr-xr-xpdf/m_tbc_generate_pdf.inc358
1 files changed, 358 insertions, 0 deletions
diff --git a/pdf/m_tbc_generate_pdf.inc b/pdf/m_tbc_generate_pdf.inc
new file mode 100755
index 0000000..4942472
--- /dev/null
+++ b/pdf/m_tbc_generate_pdf.inc
@@ -0,0 +1,358 @@
+<?php
+function generate_tbc_pdf()
+ {
+ $mpath = drupal_get_path('module', 'migration_certificates');
+ require($mpath . '/pdf/fpdf/fpdf.php');
+ require($mpath . '/pdf/phpqrcode/qrlib.php');
+ global $user;
+ $x = $user->uid;
+ $proposal_id = arg(3); // proposal id of lab
+ $lab_certi_id = arg(4);
+ if ($proposal_id != NULL && $lab_certi_id != NULL)
+ {
+ $query3 = db_query("SELECT * FROM m_tbc_certificate WHERE proposal_id= :prop_id AND id=:certi_id", array(
+ ':prop_id' => $proposal_id,
+ ":certi_id" => $lab_certi_id
+ ));
+ $data3 = $query3->fetchObject();
+ //var_dump($data3->type);die;
+ if ($data3->type == 'Proposer')
+ {
+//var_dump("1st mere ko call kiya");die;
+ $pdf = new FPDF('L', 'mm', 'Letter');
+ if (!$pdf)
+ {
+ echo "Error!";
+ } //!$pdf
+ $pdf->AddPage();
+ $image_bg = $mpath . "/pdf/images/bg.png";
+ $pdf->Image($image_bg, 0, 0, $pdf->w, $pdf->h);
+ $pdf->Rect(5, 5, 267, 207, 'D'); //For A4
+ $pdf->SetMargins(18, 1, 18);
+ $pdf->Line(7.0, 7.0, 270.0, 7.0);
+ $pdf->Line(7.0, 7.0, 7.0, 210.0);
+ $pdf->Line(270.0, 210.0, 270.0, 7.0);
+ $pdf->Line(7.0, 210.0, 270.0, 210.0);
+ $path = drupal_get_path('module', 'migration_certificates');
+ $image1 = $mpath . "/pdf/images/scilab.png";
+ $pdf->Ln(15);
+ $pdf->Cell(200, 8, $pdf->Image($image1, 100, 19, 0, 28), 0, 1, 'C');
+ $pdf->Ln(25);
+ $pdf->SetFont('Arial', 'BI', 25);
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Cell(240, 8, 'Certificate of Lab Migration', '0', 1, 'C');
+ $pdf->Ln(4);
+ $pdf->SetFont('Arial', 'BI', 12);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->Cell(240, 8, 'This is to certify that under the supervision/guidance of ' . $data3->name_title . ' ' . $data3->name . ',', '0', 1, 'C');
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Ln(2);
+ $pdf->Cell(240, 8, 'from the ' . $data3->department . ',', '0', 1, 'C');
+ $pdf->Ln(0);
+ $pdf->SetFont('Arial', 'BI', 12);
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Cell(240, 8, $data3->institute_name . ', ' . $data3->institute_address, '0', '1', 'C');
+ $pdf->Ln(2);
+ $pdf->SetFont('Arial', 'BI', 12);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->Cell(240, 8, ' has successfully migrated the ', '0', '1', 'C');
+ $pdf->Ln(0);
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Cell(240, 8, $data3->lab_name, '0', '1', 'C');
+ //$pdf->Ln(0);
+ //$pdf->SetTextColor(0,0,0);
+ //$pdf->Cell(240,8,'in ', '0','1','C');
+ $pdf->Ln(0);
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Cell(240, 8, '(' . $data3->semester_details . ')', '0', '1', 'C');
+ $pdf->Ln(0);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->Cell(240, 8, 'to a Scilab-only lab.', '0', '1', 'C');
+ $pdf->Ln(0);
+ //$proposal_get_id=0;
+ $UniqueString = "";
+ $tempDir = $path . "/pdf/temp_prcode/";
+ //$UniqueString=generateRandomString();
+ $query = db_select('m_tbc_certificate_qr_code');
+ $query->fields('m_tbc_certificate_qr_code', array(
+ 'qr_code'
+ ));
+ //$query->condition('qr_code', $UniqueString);
+ $query->condition('proposal_id', $proposal_id);
+ $result = $query->execute();
+ $data = $result->fetchObject();
+ $DBString = $data->qr_code;
+ //$proposal_get_id=$data->proposal_id;
+ if ($DBString == "" || $DBString == "null")
+ {
+ $UniqueString = generateRandomString();
+ $query = "
+ INSERT INTO m_tbc_certificate_qr_code
+ (proposal_id,qr_code,certificate_id,gen_date)
+ VALUES
+ (:proposal_id,:qr_code,:certificate_id,:gen_date)
+ ";
+ $args = array(
+ ":proposal_id" => $proposal_id, // id is not the proposal id its lab migration certificate table id
+ ":qr_code" => $UniqueString,
+ ":certificate_id" => $lab_certi_id,
+ ":gen_date" => time()
+ );
+ /* storing the row id in $result */
+ $result = db_query($query, $args, array(
+ 'return' => Database::RETURN_INSERT_ID
+ ));
+ } //$DBString == "" || $DBString == "null"
+ else
+ {
+ $UniqueString = $DBString;
+ }
+ $codeContents = "http://scilab.in/m_tbc/certificates/verify/" . $UniqueString;
+ $fileName = 'generated_qrcode.png';
+ $pngAbsoluteFilePath = $tempDir . $fileName;
+ $urlRelativeFilePath = $path . "/pdf/temp_prcode/" . $fileName;
+ QRcode::png($codeContents, $pngAbsoluteFilePath);
+ $pdf->Cell(240, 4, '', '0', '1', 'C');
+ $pdf->SetX(95);
+ $pdf->SetFont('', 'U');
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->SetFont('', '');
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->write(0, '.', '.');
+ $pdf->Ln(5);
+ $pdf->SetX(198);
+ $pdf->SetFont('', '');
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->SetY(-70);
+ $pdf->SetX(200);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->SetFont('', '');
+ //$sign = $path . "/pdf/images/kannan-sign.png";
+ //$pdf->Image($sign, $pdf->GetX(), $pdf->GetY() - 10, 50, 0);
+ //$pdf->Cell(0,7,'', 0,1,'L');
+ $pdf->SetFont('Arial', 'I', 12);
+ $pdf->Cell(0, 8, 'Prof. Kannan Moudgalya', 0, 1, 'L');
+ $pdf->SetX(194);
+ $pdf->Cell(0, 7, 'Principal Investigator - FOSSEE', 0, 1, 'L');
+ $pdf->SetX(190);
+ $pdf->Cell(0, 7, ' Dept. of Chemical Engg., IIT Bombay.', 0, 1, 'L');
+ $pdf->SetX(29);
+ $pdf->SetFont('Arial', 'B', 10);
+ $pdf->Cell(0, 2, $UniqueString, 0, 0, 'C');
+ //$image4=$path."/pdf/images/verify_content_tbc.png";
+ //$pdf->Image($image4, $pdf->GetX(), $pdf->GetY(),20, 0);
+ $pdf->SetY(-40);
+ $pdf->SetX(80);
+ $image3 = $path . "/pdf/images/iitb.png";
+ $image2 = $path . "/pdf/images/fossee.png";
+ $pdf->Image($image2, $pdf->GetX() - 15, $pdf->GetY() + 7, 40, 0);
+ $pdf->Image($pngAbsoluteFilePath, $pdf->GetX() + 50, $pdf->GetY() - 5, 30, 0);
+ $pdf->Image($image3, $pdf->GetX() + 110, $pdf->GetY() + 3, 15, 0);
+ $image4 = $path . "/pdf/images/verify_content_tbc.png";
+ $pdf->Image($image4, $pdf->GetX() - 15, $pdf->GetY() + 28, 150, 0);
+ $pdf->SetFont('Arial', 'I', 8);
+ $pdf->SetTextColor(0, 0, 0);
+ $filename = str_replace(' ', '-', $data3->proposal_id) . '-Scilab-Lab-migration-Certificate.pdf';
+ $file = $path . '/pdf/temp_certificate/' . $proposal_id . '_' . $filename;
+ $pdf->Output($file, 'F');
+ header("Content-Type: application/octet-stream");
+ header("Content-Disposition: attachment; filename=" . $filename);
+ header("Content-Type: application/octet-stream");
+ header("Content-Type: application/download");
+ header("Content-Description: File Transfer");
+ header("Content-Length: " . filesize($file));
+ flush(); // this doesn't really matter.
+ $fp = fopen($file, "r");
+ while (!feof($fp))
+ {
+ echo fread($fp, 65536);
+ flush(); // this is essential for large downloads
+ } //!feof($fp)
+ fclose($fp);
+ unlink($file);
+ drupal_goto('m_tbc/certificate');
+ return;
+ } //$data3->type = 'Proposer'
+ elseif ($data3->type == 'Participant')
+ {
+ $pdf = new FPDF('L', 'mm', 'Letter');
+ if (!$pdf)
+ {
+ echo "Error!";
+ } //!$pdf
+ $pdf->AddPage();
+ $image_bg = $mpath . "/pdf/images/bg.png";
+ $pdf->Image($image_bg, 0, 0, $pdf->w, $pdf->h);
+ $pdf->Rect(5, 5, 267, 207, 'D'); //For A4
+ $pdf->SetMargins(18, 1, 18);
+ $pdf->Line(7.0, 7.0, 270.0, 7.0);
+ $pdf->Line(7.0, 7.0, 7.0, 210.0);
+ $pdf->Line(270.0, 210.0, 270.0, 7.0);
+ $pdf->Line(7.0, 210.0, 270.0, 210.0);
+ $path = drupal_get_path('module', 'migration_certificates');
+ $image1 = $mpath . "/pdf/images/scilab.png";
+ $pdf->Ln(15);
+ $pdf->Cell(200, 8, $pdf->Image($image1, 100, 19, 0, 28), 0, 1, 'C');
+ $pdf->Ln(25);
+ $pdf->SetFont('Arial', 'BI', 25);
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Cell(240, 8, 'Certificate of Participation', '0', 1, 'C');
+ $pdf->Ln(3);
+ $pdf->SetFont('Arial', 'BI', 12);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->Cell(240, 8, 'This is to certify that', '0', '1', 'C');
+ $pdf->Ln(4);
+ $pdf->SetFont('Arial', 'BI', 20);
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->Cell(240, 8, $data3->name, '0', 1, 'C');
+ $pdf->Ln(5);
+ $pdf->SetFont('Arial', 'I', 12);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->Cell(240, 8, 'from the Department of ' . $data3->department . ', ', '0', '1', 'C');
+ $pdf->Ln(0);
+ $pdf->Cell(240, 8, iconv('UTF-8', 'windows-1252', $data3->institute_name) , '0', 1, 'C');
+ $pdf->Ln(0);
+ $pdf->Cell(240, 8, ' has successfully completed Internship under Scilab Textbook Companion, He/she has coded solved examples using Scilab from the ', '0', 1, 'C');
+ $pdf->Ln(0);
+ $pdf->Ln(0);
+ $pdf->Cell(240, 8, 'Book: ' . $data3->book_name . ', Author: ' . $data3->author . '.', '0', '1', 'C');
+ $pdf->Ln(0);
+ $pdf->Ln(0);
+ $pdf->Cell(240, 4, '', '0', '1', 'C');
+ $pdf->SetX(95);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->write(0, 'The work done is available at ');
+ $pdf->SetFont('', 'U');
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->write(0, 'http://scilab.in/', 'http://scilab.in/');
+ $pdf->SetFont('', '');
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->write(0, '.', '.');
+ //$proposal_get_id=0;
+ $UniqueString = "";
+ $tempDir = $path . "/pdf/temp_prcode/";
+ //$UniqueString=generateRandomString();
+ $query = db_select('m_tbc_certificate_qr_code');
+ $query->fields('m_tbc_certificate_qr_code', array(
+ 'qr_code',
+ 'certificate_id'
+ ));
+ //$query->condition('qr_code', $UniqueString);
+ $query->condition('proposal_id', $proposal_id);
+ $query->condition('certificate_id', $lab_certi_id);
+ $result = $query->execute();
+ $data = $result->fetchObject();
+ $DBString = $data->qr_code;
+ //$proposal_get_id=$data->proposal_id;
+ if ($DBString == "" || $DBString == "null")
+ {
+ $UniqueString = generateRandomString();
+ $query = "
+ INSERT INTO m_tbc_certificate_qr_code
+ (proposal_id,qr_code,certificate_id,gen_date)
+ VALUES
+ (:proposal_id,:qr_code,:certificate_id,:gen_date)
+ ";
+ $args = array(
+ ":proposal_id" => $proposal_id, // id is not the proposal id its lab migration certificate table id
+ ":qr_code" => $UniqueString,
+ ":certificate_id" => $lab_certi_id,
+ ":gen_date" => time()
+ );
+ /* storing the row id in $result */
+ $result = db_query($query, $args, array(
+ 'return' => Database::RETURN_INSERT_ID
+ ));
+ } //$DBString == "" || $DBString == "null"
+ else
+ {
+ $UniqueString = $DBString;
+ }
+ $codeContents = "http://scilab.in/m_tbc/certificates/verify/" . $UniqueString;
+ $fileName = 'generated_qrcode.png';
+ $pngAbsoluteFilePath = $tempDir . $fileName;
+ $urlRelativeFilePath = $path . "/pdf/temp_prcode/" . $fileName;
+ QRcode::png($codeContents, $pngAbsoluteFilePath);
+ $pdf->Cell(240, 4, '', '0', '1', 'C');
+ $pdf->SetX(95);
+ $pdf->SetFont('', 'U');
+ $pdf->SetTextColor(139, 69, 19);
+ $pdf->SetFont('', '');
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->write(0, '.', '.');
+ $pdf->Ln(5);
+ $pdf->SetX(198);
+ $pdf->SetFont('', '');
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->SetY(-70);
+ $pdf->SetX(200);
+ $pdf->SetTextColor(0, 0, 0);
+ $pdf->SetFont('', '');
+ //$sign = $path . "/pdf/images/kannan-sign.png";
+ //$pdf->Image($sign, $pdf->GetX(), $pdf->GetY() - 10, 50, 0);
+ //$pdf->Cell(0,7,'', 0,1,'L');
+ $pdf->SetFont('Arial', 'I', 12);
+ $pdf->Cell(0, 8, 'Prof. Kannan Moudgalya', 0, 1, 'L');
+ $pdf->SetX(194);
+ $pdf->Cell(0, 7, 'Principal Investigator - FOSSEE', 0, 1, 'L');
+ $pdf->SetX(190);
+ $pdf->Cell(0, 7, ' Dept. of Chemical Engg., IIT Bombay.', 0, 1, 'L');
+ $pdf->SetX(29);
+ $pdf->SetFont('Arial', 'B', 10);
+ $pdf->Cell(0, 2, $UniqueString, 0, 0, 'C');
+ $pdf->SetY(-40);
+ $pdf->SetX(80);
+ $image3 = $path . "/pdf/images/iitb.png";
+ $image2 = $path . "/pdf/images/fossee.png";
+ $pdf->Image($image2, $pdf->GetX() - 15, $pdf->GetY() + 7, 40, 0);
+ $pdf->Image($pngAbsoluteFilePath, $pdf->GetX() + 50, $pdf->GetY() - 5, 30, 0);
+ $pdf->Image($image3, $pdf->GetX() + 110, $pdf->GetY() + 3, 15, 0);
+ $image4 = $path . "/pdf/images/verify_content_tbc.png";
+ //$pdf->Image($image4, $pdf->GetX(), $pdf->GetY(),0, 10);
+ $pdf->Image($image4, $pdf->GetX() - 15, $pdf->GetY() + 28, 150, 0);
+ $pdf->SetFont('Arial', 'I', 8);
+ $pdf->SetTextColor(0, 0, 0);
+ $filename = str_replace(' ', '-', $data3->id) . '-Scilab-M-TBC-Participation-Certificate.pdf';
+ $file = $path . '/pdf/temp_certificate/' . $proposal_id . '_' . $filename;
+ $pdf->Output($file, 'F');
+ header("Content-Type: application/octet-stream");
+ header("Content-Disposition: attachment; filename=" . $filename);
+ header("Content-Type: application/octet-stream");
+ header("Content-Type: application/download");
+ header("Content-Description: File Transfer");
+ header("Content-Length: " . filesize($file));
+ flush(); // this doesn't really matter.
+ $fp = fopen($file, "r");
+ while (!feof($fp))
+ {
+ echo fread($fp, 65536);
+ flush(); // this is essential for large downloads
+ } //!feof($fp)
+ fclose($fp);
+ unlink($file);
+ drupal_goto('m_tbc/certificate');
+ return;
+ } //$data3->type = 'Proposer'
+ else
+ {
+ drupal_goto('m_tbc/certificate');
+ }
+ } //$proposal_id != NULL && $lab_certi_id !== NULL
+ else
+ {
+ drupal_set_message('Your Book Is Still Under Review.', 'status');
+ }
+ }
+function generateRandomString($length = 5)
+ {
+ $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
+ $charactersLength = strlen($characters);
+ $randomString = '';
+ for ($i = 0; $i < $length; $i++)
+ {
+ $randomString .= $characters[rand(0, $charactersLength - 1)];
+ } //$i = 0; $i < $length; $i++
+ return $randomString;
+ }
+
+
generated by cgit (git 2.34.1) at 2025-03-12 20:19:31 +0000