diff options
Diffstat (limited to 'migration_certificates.module')
| -rwxr-xr-x | migration_certificates.module | 636 |
1 files changed, 636 insertions, 0 deletions
diff --git a/migration_certificates.module b/migration_certificates.module new file mode 100755 index 0000000..936c7eb --- /dev/null +++ b/migration_certificates.module @@ -0,0 +1,636 @@ +<?php +// $Id$ +/* + * Implementation of hook_menu(). + */ +function migration_certificates_menu() + { + $items = array(); + $items['lab_migration/certificate'] = array( + 'title' => 'List Of All Certificates LM', + 'description' => 'List of all available lab migration certificates', + 'page callback' => '_list_all_lm_certificates', + 'access arguments' => array( + 'Create custom Certificate' + ) + ); + $items['lab_migration/certificate/lm_proposer/form'] = array( + 'title' => 'Create Certificate', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'lab_migration_certificate_form' + ), + 'access arguments' => array( + 'Create custom Certificate' + ) + ); + $items['lab_migration/certificate/lm_proposer/form/edit'] = array( + 'title' => 'Edit Proposer Certificate', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'lab_migration_certificate_edit_form' + ), + 'access arguments' => array( + 'Create custom Certificate' + ) + ); + $items['lab_migration/certificate/lm_participation/form'] = array( + 'title' => 'Create Certificates for Participation', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'lab_migration_certificate_participation_form' + ), + 'access arguments' => array( + 'Create custom Certificate' + ) + ); + $items['lab_migration/certificate/lm_participation/form/edit'] = array( + 'title' => 'Edit Certificates for Participation', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'lab_migration_certificate_participation_edit_form' + ), + 'access arguments' => array( + 'Create custom Certificate' + ) + ); + $items['lab_migration/certificate/generate_pdf'] = array( + 'title' => 'Download Certificate', + 'description' => 'Download Certificate', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'generate_lm_pdf' + ), + 'access arguments' => array( + 'Create custom Certificate' + ), + 'file' => 'pdf/generate_pdf.inc' + ); + $items["lab_migration/certificates/verify"] = array( + "title" => "Lab Migration Certificate Verification", + "page callback" => "verify_lab_migration_certificates", + "access arguments" => array( + "Verify custom Certificate of lab" + ), + 'file' => 'pdf/verify_lab_migration_certificates.inc' + ); + /**************************************************************/ + $items['m_tbc/certificate/tbc_participation/form'] = array( + 'title' => 'Create Certificates for Participation', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'm_tbc_certificate_participation_form' + ), + 'access arguments' => array( + 'Create custom Certificate' + ), + 'file' => 'pdf/m_tbc_certi.inc' + ); + $items['m_tbc/certificate'] = array( + 'title' => 'List Of All Certificates Manual TBC ', + 'description' => 'List of all available TBC praticipation certificates', + 'page callback' => '_list_all_m_tbc_certificates', + 'access arguments' => array( + 'Create custom Certificate' + ), + 'file' => 'pdf/m_tbc_certi.inc' + ); + $items['m_tbc/certificate/tbc_participation/form/edit'] = array( + 'title' => 'Edit Certificates for Participation', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'm_tbc_certificate_participation_edit_form' + ), + 'access arguments' => array( + 'Create custom Certificate' + ) + ); + $items['m_tbc/certificate/generate_pdf'] = array( + 'title' => 'Download Certificate', + 'description' => 'Download Certificate', + 'page callback' => 'drupal_get_form', + 'page arguments' => array( + 'generate_tbc_pdf' + ), + 'access arguments' => array( + 'Create custom Certificate' + ), + 'file' => 'pdf/m_tbc_generate_pdf.inc' + ); + $items["m_tbc/certificates/verify"] = array( + "title" => "TBC Certificate Verification", + "page callback" => "verify_m_tbc_certificates", + "access arguments" => array( + "Verify custom Certificate of lab" + ), + 'file' => 'pdf/verify_m_tbc_certificates.inc' + ); + return $items; + } +/** + * Implementation of hook_perm(). + */ +function migration_certificates_permission() + { + return array( + "Create custom Certificate" => array( + "title" => t("create custom certificate "), + "description" => t("Create custom Certificate") + ), + "Verify custom Certificate of lab" => array( + "title" => t("Verify custom Certificate of lab"), + "description" => t("Verify custom Certificate of lab") + ) + ); + } +/********** Lab migration certificate form **************/ +function lab_migration_certificate_form($form, $form_state) + { + $form['name_title'] = array( + '#type' => 'select', + '#title' => t('Title'), + '#options' => array( + 'Dr.' => 'Dr.', + 'Prof.' => 'Prof.', + 'Mr.' => 'Mr.', + 'Mrs.' => 'Mrs.', + 'Ms.' => 'Ms.' + ), + '#required' => TRUE + ); + $form['name'] = array( + '#type' => 'textfield', + '#title' => t('Name of Proposer'), + '#maxlength' => 50, + '#required' => TRUE + ); + $form['email_id'] = array( + '#type' => 'textfield', + '#title' => t('Email'), + '#size' => 50 + ); + $form['institute_name'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue Name'), + '#required' => TRUE + ); + $form['institute_address'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue address'), + '#required' => TRUE + ); + $form['lab_name'] = array( + '#type' => 'textfield', + '#title' => t('Lab name'), + '#required' => TRUE + ); + $form['department'] = array( + '#type' => 'textfield', + '#title' => t('Department'), + '#required' => TRUE + ); + $form['semester_details'] = array( + '#type' => 'textfield', + '#title' => t('Semester details'), + '#required' => TRUE + ); + $form['proposal_id'] = array( + '#type' => 'textfield', + '#title' => t('Lab Proposal Id'), + '#description' => 'Note: You can find the respective Lab Proposal Id from the url for the completed lab. For example: The Lab Proposal Id is 64 for this completed lab. ( Url - scilab.in/lab_migration_run/64)', + '#required' => TRUE + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + return $form; + } +function lab_migration_certificate_form_submit($form, &$form_state) + { + global $user; + $v = $form_state["values"]; + $result = "INSERT INTO {lab_migration_certificate} + (uid, name_title, name, email_id, institute_name, institute_address, lab_name, department, semester_details,proposal_id,type,creation_date) VALUES + (:uid, :name_title, :name, :email_id, :institute_name, :institute_address, :lab_name, :department, :semester_details,:proposal_id,:type,:creation_date)"; + $args = array( + ":uid" => $user->uid, + ":name_title" => trim($v['name_title']), + ":name" => trim($v['name']), + ":email_id" => trim($v['email_id']), + ":institute_name" => trim($v['institute_name']), + ":institute_address" => trim($v['institute_address']), + ":lab_name" => trim($v['lab_name']), + ":department" => trim($v['department']), + ":semester_details" => trim($v['semester_details']), + ":proposal_id" => trim($v['proposal_id']), + ":type" => "Proposer", + ":creation_date" => time() + ); + $proposal_id = db_query($result, $args); + drupal_goto('lab_migration/certificate'); + } +/********** Lab migration certificate form **************/ +function lab_migration_certificate_edit_form($form, $form_state) + { + $type = arg(2); + $action = arg(4); + $proposal_id = arg(5); + $certi_id = arg(6); + //var_dump($type. "--".$action."--".$proposal_id."--".$certi_id); + //die; + if ($type == "lm_proposer" && $action == "edit") + { + $query = db_query("SELECT * FROM lab_migration_certificate WHERE proposal_id=:prop_id AND id=:certi_id", array( + ":prop_id" => $proposal_id, + ":certi_id" => $certi_id + )); + $details_list = $query->fetchobject(); + if ($details_list->type == "Proposer") + { + $form['name_title'] = array( + '#type' => 'select', + '#title' => t('Title'), + '#options' => array( + 'Dr.' => 'Dr.', + 'Prof.' => 'Prof.', + 'Mr.' => 'Mr.', + 'Mrs.' => 'Mrs.', + 'Ms.' => 'Ms.' + ), + '#default_value' => $details_list->name_title + ); + $form['name'] = array( + '#type' => 'textfield', + '#title' => t('Name of Proposer'), + '#maxlength' => 50, + '#default_value' => $details_list->name + ); + $form['email_id'] = array( + '#type' => 'textfield', + '#title' => t('Email'), + '#size' => 50, + '#default_value' => $details_list->email_id + ); + $form['institute_name'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue Name'), + '#default_value' => $details_list->institute_name + ); + $form['institute_address'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue address'), + '#default_value' => $details_list->institute_address + ); + $form['lab_name'] = array( + '#type' => 'textfield', + '#title' => t('Lab name'), + '#default_value' => $details_list->lab_name + ); + $form['department'] = array( + '#type' => 'textfield', + '#title' => t('Department'), + '#default_value' => $details_list->department + ); + $form['semester_details'] = array( + '#type' => 'textfield', + '#title' => t('Semester details'), + '#default_value' => $details_list->semester_details + ); + $form['proposal_id'] = array( + '#type' => 'textfield', + '#title' => t('Lab Proposal Id'), + '#description' => 'Note: You can find it in respective completed labs url -> scilab.in/lab_migration_run/64 <- this number is the proposal id for respective lab', + '#default_value' => $details_list->proposal_id + ); + $form['certi_id'] = array( + '#type' => 'hidden', + '#default_value' => $details_list->id + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + } //$details_list->type == "Proposer" + else + { + $form['err_message'] = array( + '#type' => 'item', + '#title' => t('Message'), + '#markup' => 'Invalid information' + ); + } + } //$type == "lm_proposer" && $action == "edit" + else + { + $form['err_message'] = array( + '#type' => 'item', + '#title' => t('Message'), + '#markup' => 'Invalid information' + ); + } + return $form; + } +function lab_migration_certificate_edit_form_submit($form, &$form_state) + { + global $user; + $v = $form_state["values"]; + $result = "UPDATE lab_migration_certificate SET + uid=:uid, + name_title=:name_title, + name=:name, + email_id=:email_id, + institute_name=:institute_name, + institute_address=:institute_address, + lab_name=:lab_name, + department=:department, + semester_details=:semester_details, + proposal_id=:proposal_id, + type=:type, + creation_date=:creation_date + WHERE id=:certi_id"; + $args = array( + ":uid" => $user->uid, + ":name_title" => trim($v['name_title']), + ":name" => trim($v['name']), + ":email_id" => trim($v['email_id']), + ":institute_name" => trim($v['institute_name']), + ":institute_address" => trim($v['institute_address']), + ":lab_name" => trim($v['lab_name']), + ":department" => trim($v['department']), + ":semester_details" => trim($v['semester_details']), + ":proposal_id" => trim($v['proposal_id']), + ":type" => "Proposer", + ":creation_date" => time(), + ":certi_id" => $v['certi_id'] + ); + $proposal_id = db_query($result, $args); + drupal_goto('lab_migration/certificate'); + } +function lab_migration_certificate_participation_form($form, $form_state) + { + $form['name_title'] = array( + '#type' => 'select', + '#title' => t('Title'), + '#options' => array( + 'Dr.' => 'Dr.', + 'Prof.' => 'Prof.', + 'Mr.' => 'Mr.', + 'Mrs.' => 'Mrs.', + 'Ms.' => 'Ms.' + ), + '#required' => TRUE + ); + $form['name'] = array( + '#type' => 'textfield', + '#title' => t('Name of Participant'), + '#maxlength' => 50, + '#required' => TRUE + ); + $form['email_id'] = array( + '#type' => 'textfield', + '#title' => t('Email'), + '#size' => 50, + '#default_value' => 'Not availbale' + ); + $form['institute_name'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue Name'), + '#required' => TRUE + ); + $form['institute_address'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue address'), + '#required' => TRUE + ); + $form['lab_name'] = array( + '#type' => 'textfield', + '#title' => t('Lab name'), + '#required' => TRUE + ); + $form['department'] = array( + '#type' => 'textfield', + '#title' => t('Department'), + '#required' => TRUE + ); + $form['semester_details'] = array( + '#type' => 'textfield', + '#title' => t('Semester details'), + '#required' => TRUE + ); + $form['proposal_id'] = array( + '#type' => 'textfield', + '#title' => t('Lab Proposal Id'), + '#description' => 'Note: You can find the respective Lab Proposal Id from the url for the completed lab. For example: The Lab Proposal Id is 64 for this completed lab. ( Url - scilab.in/lab_migration_run/64)', + '#required' => TRUE + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + return $form; + } +function lab_migration_certificate_participation_form_submit($form, &$form_state) + { + global $user; + $v = $form_state["values"]; + $result = "INSERT INTO {lab_migration_certificate} + (uid, name_title, name, email_id, institute_name, institute_address, lab_name, department, semester_details,proposal_id,type,creation_date) VALUES + (:uid, :name_title, :name, :email_id, :institute_name, :institute_address, :lab_name, :department, :semester_details,:proposal_id,:type,:creation_date)"; + $args = array( + ":uid" => $user->uid, + ":name_title" => trim($v['name_title']), + ":name" => trim($v['name']), + ":email_id" => trim($v['email_id']), + ":institute_name" => trim($v['institute_name']), + ":institute_address" => trim($v['institute_address']), + ":lab_name" => trim($v['lab_name']), + ":department" => trim($v['department']), + ":semester_details" => trim($v['semester_details']), + ":proposal_id" => $v['proposal_id'], + ":type" => "Participant", + ":creation_date" => time() + ); + $proposal_id = db_query($result, $args); + drupal_goto('lab_migration/certificate'); + } +/******** edit participation *********/ +function lab_migration_certificate_participation_edit_form($form, $form_state) + { + $type = arg(2); + $action = arg(4); + $proposal_id = arg(5); + $certi_id = arg(6); + if ($type == "lm_participation" && $action == "edit") + { + $query = db_query("SELECT * FROM lab_migration_certificate WHERE proposal_id=:prop_id AND id=:certi_id", array( + ":prop_id" => $proposal_id, + ":certi_id" => $certi_id + )); + $details_list = $query->fetchobject(); + if ($details_list->type == "Participant") + { + $form['name_title'] = array( + '#type' => 'select', + '#title' => t('Title'), + '#options' => array( + 'Dr.' => 'Dr.', + 'Prof.' => 'Prof.', + 'Mr.' => 'Mr.', + 'Mrs.' => 'Mrs.', + 'Ms.'=> 'Ms.' + ), + '#default_value' => $details_list->name_title + ); + $form['name'] = array( + '#type' => 'textfield', + '#title' => t('Name of Participant'), + '#maxlength' => 50, + '#default_value' => $details_list->name + ); + $form['email_id'] = array( + '#type' => 'textfield', + '#title' => t('Email'), + '#size' => 50, + '#default_value' => $details_list->email_id + ); + $form['institute_name'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue Name'), + '#default_value' => $details_list->institute_name + ); + $form['institute_address'] = array( + '#type' => 'textfield', + '#title' => t('Collage / Institue address'), + '#default_value' => $details_list->institute_address + ); + $form['lab_name'] = array( + '#type' => 'textfield', + '#title' => t('Lab name'), + '#default_value' => $details_list->lab_name + ); + $form['department'] = array( + '#type' => 'textfield', + '#title' => t('Department'), + '#default_value' => $details_list->department + ); + $form['semester_details'] = array( + '#type' => 'textfield', + '#title' => t('Semester details'), + '#default_value' => $details_list->semester_details + ); + $form['proposal_id'] = array( + '#type' => 'textfield', + '#title' => t('Lab Proposal Id'), + '#description' => 'Note: You can find the respective Lab Proposal Id from the url for the completed lab. For example: The Lab Proposal Id is 64 for this completed lab. ( Url - scilab.in/lab_migration_run/64)', + '#default_value' => $details_list->proposal_id + ); + $form['certi_id'] = array( + '#type' => 'hidden', + '#default_value' => $details_list->id + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + } //$details_list->type == "Participant" + else + { + $form['err_message'] = array( + '#type' => 'item', + '#title' => t('Message'), + '#markup' => 'Invalid information' + ); + } + } //$type == "lm_participation" && $action == "edit" + else + { + $form['err_message'] = array( + '#type' => 'item', + '#title' => t('Message'), + '#markup' => 'Invalid information' + ); + } + return $form; + } +function lab_migration_certificate_participation_edit_form_submit($form, &$form_state) + { + global $user; + $v = $form_state["values"]; + $result = "UPDATE lab_migration_certificate SET + uid=:uid, + name_title=:name_title, + name=:name, + email_id=:email_id, + institute_name=:institute_name, + institute_address=:institute_address, + lab_name=:lab_name, + department=:department, + semester_details=:semester_details, + proposal_id=:proposal_id, + type=:type, + creation_date=:creation_date + WHERE id=:certi_id"; + $args = array( + ":uid" => $user->uid, + ":name_title" => trim($v['name_title']), + ":name" => trim($v['name']), + ":email_id" => trim($v['email_id']), + ":institute_name" => trim($v['institute_name']), + ":institute_address" => trim($v['institute_address']), + ":lab_name" => trim($v['lab_name']), + ":department" => trim($v['department']), + ":semester_details" => trim($v['semester_details']), + ":proposal_id" => trim($v['proposal_id']), + ":type" => "Participant", + ":creation_date" => time(), + ":certi_id" => $v['certi_id'] + ); + $proposal_id = db_query($result, $args); + drupal_goto('lab_migration/certificate'); + } +/*************************************/ +function _list_all_lm_certificates() + { + $query = db_query("SELECT * FROM lab_migration_certificate"); + $search_rows = array(); + $output = ''; + $details_list = $query->fetchAll(); + foreach ($details_list as $details) + { + if ($details->type == "Proposer") + { + $search_rows[] = array( + $details->lab_name, + $details->institute_name, + $details->name, + $details->type, + l('Download Certificate', 'lab_migration/certificate/generate_pdf/' . $details->proposal_id . '/' . $details->id), + l('Edit Certificate', 'lab_migration/certificate/lm_proposer/form/edit/' . $details->proposal_id . '/' . $details->id) + ); + } //$details->type == "Proposer" + else + { + $search_rows[] = array( + $details->lab_name, + $details->institute_name, + $details->name, + $details->type, + l('Download Certificate', 'lab_migration/certificate/generate_pdf/' . $details->proposal_id . '/' . $details->id), + l('Edit Certificate', 'lab_migration/certificate/lm_participation/form/edit/' . $details->proposal_id . '/' . $details->id) + ); + } + } //$details_list as $details + $search_header = array( + 'Lab Name', + 'Institute name', + 'Name', + 'Type', + 'Download Certificates' + ); + $output .= theme('table', array( + 'header' => $search_header, + 'rows' => $search_rows + )); + return $output; + } |