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
118
119
120
121
122
123
124
125
126
127
|
<?php
function verify_certificates($qr_code=0)
{
$qr_code = arg(3);
$page_content="";
if($qr_code){
$page_content=verify_qrcode_fromdb($qr_code);
}else{
$verify_certificates_form = drupal_get_form("verify_certificates_form");
$page_content = drupal_render($verify_certificates_form);
}
return $page_content;
}
function verify_certificates_form($form, &$form_state)
{
$form = array();
$form['Title'] = array(
'#type' => 'markup',
'#markup' => ''
);
$form["QR_code"] = array(
"#type" => "textfield",
"#title" => "Enter QR Code",
"#default_value" => '',
"#required" => TRUE
);
$form["submit"] = array(
"#type" => "submit",
"#value" => "Verify",
'#ajax' => array(
'callback' => 'verify_certificates_form_submit',
'progress' => array(
'message' => ''
)
),
);
$form['displaytable'] = array(
'#type' => 'markup',
'#prefix' => '<div><div id="displaytable" style="font-weight:bold;padding-top:10px">',
'#suffix' => '</div></div>',
'#markup' => ''
);
return $form;
}
function verify_certificates_form_submit($form, &$form_state)
{
$page_content= "";
$v = $form_state["values"];
$qr_code=$v["QR_code"];
$page_content = verify_qrcode_fromdb($qr_code);
$form['displaytable']['#markup'] =$page_content;
$commands[] = ajax_command_html("#displaytable", drupal_render($form['displaytable']));
return array(
'#type' => 'ajax',
'#commands' => $commands
);
}
function verify_qrcode_fromdb($qr_code){
$query = db_select('textbook_companion_qr_code');
$query->fields('textbook_companion_qr_code', array(
'proposal_id',
));
$query->condition('qr_code', $qr_code);
$result = $query->execute();
$proposal_id = $result->fetchObject()->proposal_id;
if($proposal_id){
$query2 = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status=1 AND proposal_id= :prop_id",
array(':prop_id' => $proposal_id));
$data2 = $query2->fetchObject();
$query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id= :prop_id", array(':prop_id' =>$proposal_id));
$data3 = $query3->fetchObject();
$page_content="";
$page_content.="<h4>Participation Details</h4><table><tr><td>Name</td>";
$page_content.="<td>".$data3->full_name."</td></tr>";
$page_content.="<tr><td>Project</td>";
$page_content.="<td>R Textbook Companion</td></tr>";
$page_content.="<tr><td>Books completed</td>";
$page_content.="<td>".$data2->book."</td></tr>";
$page_content.="<tr><td>Book Author</td>";
$page_content.="<td>".$data2->author."</td></tr>";
$page_content.="</table>";
}else{
$page_content="<b>Sorry ! The serial number you entered seems to be invalid. Please try again ! <b>";
}
return $page_content;
}
|
