1 files changed, 96 insertions, 0 deletions
diff --git a/pdf/verify_certificates.inc b/pdf/verify_certificates.inc
new file mode 100755
index 0000000..e9731b8
--- /dev/null
+++ b/pdf/verify_certificates.inc
@@ -0,0 +1,96 @@
+<?php
+function verify_certificates($qr_code = 0)
+{
+	$qr_code = arg(3);
+	$page_content = "";
+	if ($qr_code)
+	{
+		$page_content = verify_qrcode_fromdb($qr_code);
+	} //$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>DWSIM 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>";
+	} //$proposal_id
+	else
+	{
+		$page_content = "<b>Sorry ! The serial number you entered seems to be invalid. Please try again ! <b>";
+	}
+	return $page_content;
+}