1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
<?php
function generate_pdf()
{
require('fpdf/fpdf.php');
global $user;
$x = $user->uid;
$proposal_id = arg(2);
$query2 = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status=1 AND proposal_id=".$proposal_id);
$data2 = db_fetch_object($query2);
$query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id=".$proposal_id);
$data3 = db_fetch_object($query3);
//var_dump($data3->gender);
$gender = array('salutation' => 'Mr. /Ms.', 'gender' => 'He/She');
if($data3->gender){
if($data3->gender == 'M'){
$gender = array('salutation' => 'Mr.', 'gender' => 'He');
}else{
$gender = array('salutation' => 'Ms.', 'gender' => 'She');
}
}
//die;
/*if($data3->proposal_status == 3)
{*/
$pdf=new FPDF('L', 'mm', 'Letter');
if (!$pdf)
{
echo "Error!";
}
$pdf->AddPage();
$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);
$pdf->Image("/Sites/scilab_in/sites/default/files/scilab_logo.png", 10, 9, 0, 15);
$path = drupal_get_path('module', 'textbook_companion');
$pdf->Image($path."/pdf/images/fossee.png", 228, 9, 0, 15);
$pdf->SetFont('Arial','B',25);
$pdf->Ln(30);
$pdf->Cell(240,8,'Certificate', 0,1,'C');
$pdf->Ln(5);
$pdf->SetFont('Arial','B',12);
$pdf->Cell(240,8,'Textbook Companion', '0','1','C');
$pdf->Ln(20);
//$pdf->Cell(240,8,'IIT Bombay', '0','1','C');
$pdf->SetFont('Arial','',12);
if(strtolower($data3->branch)!="others")
{
$pdf->MultiCell(240,8,'This is to certify that '.$gender['salutation']." ".$data3->full_name.' from the Department of '.$data3->branch.', '.$data3->university.' has successfully completed Internship under Scilab Textbook Companion for a duration equivalent to six weeks. '.$gender['gender'].' has coded, in Scilab, all the solved examples of the allotted textbook: '.$data2->book.' by '.$data2->author.'.', 0);
}
else
{
$pdf->MultiCell(240,8,'This is to certify that '.$gender['salutation']." ".$data3->full_name.' from '.$data3->university.' has successfully completed training under Scilab Textbook Companion for a duration equivalent to six weeks. '.$gender['gender'].' has coded, in Scilab, all the solved examples of the allotted textbook: '.$data2->book.' by '.$data2->author.'.', 0);
} $pdf->Cell(10,10,'The work done is available at ', '0','0','L');
$pdf->SetX(75);
$pdf->SetFont('','U');
$pdf->SetTextColor(0,0,255);
$pdf->write(10,'http://scilab.in','http://scilab.in');
$pdf->SetFont('','');
$pdf->SetTextColor(0,0,0);
$pdf->write(10,'.','.');
$pdf->Ln(10);
$pdf->SetFont('Arial','',12);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(10,10,'This work was funded by the FOSSEE project, IIT Bombay (for more details visit', '0','0','L');
$pdf->SetX(170);
$pdf->SetFont('','U');
$pdf->SetTextColor(0,0,255);
$pdf->write(10,'http://fossee.in','http://fossee.in');
$pdf->SetX(198);
$pdf->SetFont('','');
$pdf->SetTextColor(0,0,0);
$pdf->write(10,').');
$pdf->SetY(-50);
$pdf->SetX(209);
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('','B');
$pdf->Image($path."/pdf/images/sign.png", 212, 151, 0, 15);
//$pdf->SetX(206);
$pdf->Cell(0,7,'Prof. Madhu Belur', 0,1,'L');
$pdf->SetX(195);
$pdf->Cell(0,7,'Principal Investigator - FOSSEE',0,1,'L');
$pdf->SetX(195);
$pdf->Cell(0,7,' Dept. of Electrical Engineering', 0,1,'L');
$pdf->SetX(216);
$pdf->Cell(0,7,'IIT Bombay', 0,1,'L');
$cur_date=date('jS F, Y');
$pdf->SetY(180);
$pdf->SetFont('','');
$pdf->Cell(200,0,' Date: '.$cur_date.'',0,1,'L');
//$pdf->Cell(200,0,' Date: 28th August, 2013',0,1,'L');
$pdf->Cell(200,15,'Email: textbook@scilab.in', 0,1,'L');
$pdf->Output();
/*}
else
{
drupal_set_message('Your Book Is Still Under Review.', 'status');
}*/
}
?>
|