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
|
<?php
function _list_pssp_custom_certificates()
{
global $user;
$query_id = db_query("SELECT id FROM om_pssp_proposal WHERE approval_status=3");
$exist_id = $query_id->fetchObject();
if ($exist_id){
if ($exist_id->id) {
if ($exist_id->id < 1) {
drupal_set_message('<strong>You need to propose a flowsheet <a href="http://dwsim.fossee.in/flowsheeting-project/proposal">Flowsheet Proposal</a></strong> or if you have already proposed then your flowsheet is under reviewing process', 'status');
return '';
} //$exist_id->id < 3
else {
$search_rows = array();
global $output;
$output = '';
$query3 = db_query("SELECT id,project_guide_name,project_guide_university,project_title FROM
om_pssp_proposal WHERE project_guide_name != '' AND project_guide_university != '' AND approval_status=3");
$i = 1;
while ($search_data3 = $query3->fetchObject()) {
$search_rows[] = array(
$i,
$search_data3->project_title,
$search_data3->project_guide_name,
l('Download Certificate', 'powersystems/pssp/certificates-custom/pdf/' . $search_data3->id)
);
$i++;
//$search_data3->id
} //$search_data3 = $query3->fetchObject()
if ($search_rows) {
$search_header = array(
'No',
'Project Title',
'Project Guide Name',
'Download Certificates'
);
$output = theme('table', array(
'header' => $search_header,
'rows' => $search_rows
));
return $output;
} //$search_rows
else {
echo ("Error");
return '';
}
}
}
} //$exist_id->id
else {
drupal_set_message('<strong>You need to propose a flowsheet <a href="http://dwsim.fossee.in/flowsheeting-project/proposal">Flowsheet Proposal</a></strong> or if you have already proposed then your flowsheet is under reviewing process', 'status');
$page_content = "<span style='color:red;'> No certificate available </span>";
return $page_content;
}
}
|
