diff options
Diffstat (limited to 'pdf/cert_new.inc')
| -rwxr-xr-x | pdf/cert_new.inc | 155 |
1 files changed, 155 insertions, 0 deletions
diff --git a/pdf/cert_new.inc b/pdf/cert_new.inc new file mode 100755 index 0000000..a58c8c9 --- /dev/null +++ b/pdf/cert_new.inc @@ -0,0 +1,155 @@ +<?php +function generate_pdf() +{ + $mpath = drupal_get_path('module', 'om_pssp'); + require($mpath.'/pdf/fpdf/fpdf.php'); + require($mpath.'/pdf/phpqrcode/qrlib.php'); + global $user; + $x = $user->uid; + $proposal_id = arg(4); + $query3 = db_query("SELECT * FROM om_pssp_proposal WHERE approval_status=3 AND uid= :uid AND id=:proposal_id", array( + ':uid' => $user->uid, + ':proposal_id'=>$proposal_id + )); + $data3 = $query3->fetchObject(); + if($data3){ + if($data3->uid != $x){ + drupal_set_message('Certificate is not available','error'); + return; + } + } + $gender = array( + 'salutation' => 'Mr. /Ms.', + 'gender' => 'He/She' + ); + if ($data3->gender) { + if ($data3->gender == 'M') { + $gender = array( + 'salutation' => 'Mr.', + 'gender' => 'He' + ); + } //$data3->gender == 'M' + else { + $gender = array( + 'salutation' => 'Ms.', + 'gender' => 'She' + ); + } + } //$data3->gender + $pdf = new FPDF('L', 'mm', 'Letter'); + if (!$pdf) { + echo "Error!"; + } //!$pdf + $pdf->AddPage(); + $pdf->AddFont('Cmr10','','cmr10.php'); + $image_bg = $mpath . "/pdf/images/bg_cert.png"; + $pdf->Image($image_bg, 0, 0, $pdf->w, $pdf->h); + $pdf->SetMargins(18, 1, 18); + $path = drupal_get_path('module', 'om_pssp'); + $pdf->Ln(45); + $pdf->SetFont('Cmr10', '', 14); + $pdf->SetTextColor(0, 0, 0); + $pdf->Cell(240, 8, 'This is to certify that', '0', '1', 'C'); + $pdf->Ln(0); + $pdf->SetFont('Cmr10', '', 16); + $pdf->SetTextColor(37, 22, 247); + $contributor_name = WordWrap($data3->contributor_name,70); + $pdf->MultiCell(240, 8, $data3->name_title . '. ' . $contributor_name, '0', 'C'); + $pdf->Ln(0); + $pdf->SetFont('Cmr10', '', 14); + $title = WordWrap($data3->project_title,160); + $university = WordWrap('from ' . $data3->university . ' has successfully contributed under the ', 160); + $pdf->SetTextColor(0, 0, 0); + $pdf->MultiCell(240, 8, $university . 'OPENMODELICA POWER SYSTEMS SIMULATION PROJECT.', '0','C'); + $pdf->Ln(0); + $pdf->Cell(240, 8, 'He/She has created the following simulation', '0', '1', 'C'); + $pdf->SetTextColor(37, 22, 247); + $pdf->SetFont('Cmr10','',16); + $pdf->MultiCell(240, 8, $title, '0', 'C'); + $pdf->SetTextColor(0, 0, 0); + $pdf->SetFont('Cmr10','',14); + $pdf->Cell(240, 8, 'using OpenModelica. The code is available at ', '0', '', 'C'); + $pdf->SetTextColor(0, 0, 0); + $pdf->Ln(8); + $pdf->SetX(90); + $pdf->SetFont('Cmr10', '', 'U'); + $pdf->SetTextColor(37, 22, 247); + $pdf->write(5, 'https://om.fossee.in/powersystems/pssp', 'https://om.fossee.in/powersystems/pssp'); + $pdf->Ln(0); + $proposal_get_id = 0; + $UniqueString = ""; + $tempDir = $path . "/pdf/temp_prcode/"; + $query = db_select('om_pssp_qr_code'); + $query->fields('om_pssp_qr_code'); + $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 om_pssp_qr_code + (proposal_id,qr_code) + VALUES + (:proposal_id,:qr_code) + "; + $args = array( + ":proposal_id" => $proposal_id, + ":qr_code" => $UniqueString + ); + $result = db_query($query, $args, array( + 'return' => Database::RETURN_INSERT_ID + )); + } //$DBString == "" || $DBString == "null" + else { + $UniqueString = $DBString; + } + $codeContents = "https://om.fossee.in/powersystems/pssp/certificates/verify/" . $UniqueString; + $fileName = 'generated_qrcode.png'; + $pngAbsoluteFilePath = $tempDir . $fileName; + $urlRelativeFilePath = $path . "/pdf/temp_prcode/" . $fileName; + QRcode::png($codeContents, $pngAbsoluteFilePath); + $pdf->SetY(80); + $pdf->SetX(300); + $pdf->Ln(30); + $pdf->Image($pngAbsoluteFilePath, $pdf->GetX()+70 , $pdf->GetY() + 55, 28,28, 0); + $pdf->SetFont('Cmr10', '', 14); + $pdf->Ln(48); + $pdf->SetX(95); + $pdf->SetTextColor(0, 0, 0); + $pdf->Cell(200, 8, $UniqueString, '0', '1' , 'L'); + $pdf->SetY(150); + $pdf->SetX(800); + $pdf->SetFont('Arial', 'I', 8); + $pdf->SetTextColor(0, 0, 0); + $filename = str_replace(' ', '-', $data3->contributor_name) . '-OpenModelica-PSSP-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(); + $fp = fopen($file, "r"); + while (!feof($fp)) { + echo fread($fp, 65536); + flush(); + } //!feof($fp) + fclose($fp); + unlink($file); + //drupal_goto('flowsheeting-project/certificate'); + return; +} +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; +}
\ No newline at end of file |