'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' => '',
'#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.="Participation Details
| Name | ";
$page_content.="".$data3->full_name." |
";
$page_content.="| Project | ";
$page_content.="R Textbook Companion |
";
$page_content.="| Books completed | ";
$page_content.="".$data2->book." |
";
$page_content.="| Book Author | ";
$page_content.="".$data2->author." |
";
$page_content.="
";
}else{
$page_content="Sorry ! The serial number you entered seems to be invalid. Please try again ! ";
}
return $page_content;
}