Modifying the certificate

2 files changed, 29 insertions, 22 deletions

diff --git a/lab_migration.module b/lab_migration.module
index 134cb89..63b0362 100755
--- a/lab_migration.module
+++ b/lab_migration.module
@@ -872,11 +872,6 @@ function lab_migration_certificate_participation_form($form, $form_state)
                 '#title' => t('Department'),
                 '#required' => TRUE
         );
-        $form['semester_details'] = array(              
-                '#type' => 'textfield',
-                '#title' => t('Semester details'),
-                '#required' => TRUE
-                );
         $form['proposal_id'] = array(
                 '#type' => 'textfield',
                 '#title' => t('Lab Proposal Id'),
@@ -894,8 +889,8 @@ function lab_migration_certificate_participation_form_submit($form, &$form_state
         global $user;
         $v = $form_state["values"];
         $result = "INSERT INTO {lab_migration_certificate} 
-    (uid, name_title, name, email_id, institute_name, institute_address, lab_name, department, semester_details,proposal_id,creation_date) VALUES
-    (:uid, :name_title, :name, :email_id, :institute_name, :institute_address, :lab_name, :department, :semester_details,:proposal_id,:creation_date)";
+    (uid, name_title, name, email_id, institute_name, institute_address, lab_name, department, proposal_id,creation_date) VALUES
+    (:uid, :name_title, :name, :email_id, :institute_name, :institute_address, :lab_name, :department, :proposal_id,:creation_date)";
         $args = array(
                 ":uid" => $user->uid,
                 ":name_title" => trim($v['name_title']),
@@ -905,7 +900,6 @@ function lab_migration_certificate_participation_form_submit($form, &$form_state
                 ":institute_address" => trim($v['institute_address']),
                 ":lab_name" => trim($v['lab_name']),
                 ":department" => trim($v['department']),
-                ":semester_details" => trim($v['semester_details']),
                 ":proposal_id" => $v['proposal_id'],
                 ":creation_date" => time()
         );
@@ -968,11 +962,6 @@ function lab_migration_certificate_participation_edit_form($form, $form_state)
                                 '#title' => t('Department'),
                                 '#default_value' => $details_list->department
                         );
-                        $form['semester_details'] = array(
-                                '#type' => 'textfield',
-                                '#title' => t('Semester details'),
-                                '#default_value' => $details_list->semester_details
-                        );
                         $form['proposal_id'] = array(
                                 '#type' => 'textfield',
                                 '#title' => t('Lab Proposal Id'),
@@ -1010,8 +999,7 @@ function lab_migration_certificate_participation_edit_form_submit($form, &$form_
     institute_name=:institute_name, 
     institute_address=:institute_address, 
     lab_name=:lab_name, 
-    department=:department, 
-    semester_details=:semester_details,
+    department=:department,
     proposal_id=:proposal_id,
     creation_date=:creation_date
     WHERE id=:certi_id";
@@ -1024,7 +1012,6 @@ function lab_migration_certificate_participation_edit_form_submit($form, &$form_
                 ":institute_address" => trim($v['institute_address']),
                 ":lab_name" => trim($v['lab_name']),
                 ":department" => trim($v['department']),
-                ":semester_details" => trim($v['semester_details']),
                 ":proposal_id" => trim($v['proposal_id']),
                 ":creation_date" => time(),
                 ":certi_id" => $v['certi_id']
diff --git a/pdf/cert_new.inc b/pdf/cert_new.inc
index 911b122..0d0ac5b 100755
--- a/pdf/cert_new.inc
+++ b/pdf/cert_new.inc
@@ -69,8 +69,8 @@ function generate_pdf()
 	$pdf->SetFont('Times', 'I', 15);
 	//$pdf->SetFont('Arial', 'BI', 25);
 	$pdf->SetTextColor(129, 80, 47);
-	$pdf->Cell(320, 12, $data3->name_title . ' ' . $data3->name, '0', '1', 'C');
-	$pdf->Ln(0);
+	$pdf->Cell(320, 10, $data3->name_title . ' ' . $data3->name, '0', '1', 'C');
+	//$pdf->Ln(0);
 	$pdf->SetFont('Times', 'I', 14);
 	if (strtolower($data3->branch) != "others") {
 		$pdf->SetFont('Times', 'I', 14);
@@ -87,18 +87,28 @@ function generate_pdf()
 		//$pdf->Ln(0);
 		$pdf->SetTextColor(129, 80, 47);
 		$pdf->SetFont('Times','I',14);
-		$pdf->Cell(320, 12, $data3->lab_title, '0', '1', 'C');
+		$pdf->Cell(320, 8, $data3->lab_title, '0', '1', 'C');
 		$pdf->SetTextColor(0, 0, 0);
 		$pdf->Ln(0);
 		//$txt= $pdf->WriteHTML("<span>under</span>");
 		$pdf->SetFont('Times', 'I', 14);
 		$pdf->Cell(320, 8, 'to a eSim-only Lab', '0', '1', 'C');
 		$pdf->Ln(0);
+		$pdf->Cell(320, 5, '', '0', '1', 'C');
+						$pdf->SetX(125);
+						$pdf->SetTextColor(0, 0, 0);
+						$pdf->write(0, 'The work done is available at ');
+						$pdf->SetFont('Times', 'U' , '14');
+						$pdf->SetTextColor(139, 69, 19);
+						$pdf->write(0, 'https://esim.fossee.in/', 'https://esim.fossee.in/');
+						$pdf->SetFont('', '');
+						$pdf->SetTextColor(0, 0, 0);
+						$pdf->write(0, '.', '.');
 	} //strtolower($data3->branch) != "others"
 	else {
 		$pdf->SetFont('Times', 'I', 14);
 		$pdf->SetTextColor(0, 0, 0);
-		$pdf->Cell(320, 12, 'from the Department of ' . $data3->department . ', ', '0', '1', 'C');
+		$pdf->Cell(320, 8, 'from the Department of ' . $data3->department . ', ', '0', '1', 'C');
 		$pdf->Ln(0);
 		$pdf->SetTextColor(0, 0, 0);
 		$pdf->Cell(240, 8, $data3->university . ' college', '0', '1', 'C');
@@ -106,11 +116,21 @@ function generate_pdf()
 		$pdf->Cell(240, 8, 'has successfully migrated the', '0', '1', 'C');
 		$pdf->Ln(0);
 		$pdf->SetTextColor(139, 69, 16);
-		$pdf->Cell(320, 12, $data3->lab_title, '0', '1', 'C');
+		$pdf->Cell(320, 8, $data3->lab_title, '0', '1', 'C');
 		$pdf->SetTextColor(0, 0, 0);
 		$pdf->Ln(0);
 		$pdf->SetFont('Times', '', 14);
 		$pdf->Cell(320, 8, 'to a eSim-only Lab', '0', '1', 'C');
+		$pdf->Cell(320, 5, '', '0', '1', 'C');
+		$pdf->SetX(125);
+		$pdf->SetTextColor(0, 0, 0);
+		$pdf->write(0, 'The work done is available at ');
+		$pdf->SetFont('Times', 'U' , '14');
+		$pdf->SetTextColor(139, 69, 19);
+		$pdf->write(0, 'https://esim.fossee.in/', 'https://esim.fossee.in/');
+		$pdf->SetFont('', '');
+		$pdf->SetTextColor(0, 0, 0);
+		$pdf->write(0, '.', '.');
 		//$pdf->Cell(240, 8, 'He/she has coded ' . $number_of_example . ' solved examples using DWSIM from the', '0', '1', 'C');
 		//$pdf->Ln(0);
 		//$pdf->Cell(240, 8, 'Book: ' . $data2->book . ', Author: ' . $data2->author . '.', '0', '1', 'C');
@@ -155,7 +175,7 @@ function generate_pdf()
 	$pdf->Ln(10);
 	$sign1 = $path . "/pdf/images/sign1.png";
 	//$sign2 = $path . "/pdf/images/sign2.png";
-	$pdf->Image($sign1, $pdf->GetX()+110, $pdf->GetY() + 40, 85, 0);
+	$pdf->Image($sign1, $pdf->GetX()+118, $pdf->GetY() + 40, 85, 0);
 	//$pdf->Image($sign2, $pdf->GetX()+160, $pdf->GetY() + 45, 85, 0);
 	$pdf->Image($pngAbsoluteFilePath, $pdf->GetX()+15, $pdf->GetY()+70, 30, 0);
 	$fossee = $path . "/pdf/images/fossee.png";