Adding syllabus link field in proposal form

2 files changed, 26 insertions, 3 deletions

diff --git a/manage_proposal.inc b/manage_proposal.inc
index 634af0b..3535ee3 100755
--- a/manage_proposal.inc
+++ b/manage_proposal.inc
@@ -263,6 +263,11 @@ function lab_migration_proposal_approval_form($form, $form_state)
         '#markup' => $proposal_data->r_version,
         '#title' => t('R Version')
     );
+    $form['syllabus_link'] = array(
+        '#type' => 'item',
+        '#markup' => $proposal_data->syllabus_link,
+        '#title' => t('Syllabus Link'),
+    );
     $form['lab_title'] = array(
         '#type' => 'item',
         '#markup' => $proposal_data->lab_title,
@@ -546,6 +551,11 @@ function lab_migration_proposal_status_form($form, $form_state)
         '#markup' => $proposal_data->r_version,
         '#title' => t('R Version')
     );
+    $form['syllabus_link'] = array(
+        '#type' => 'item',
+        '#markup' => $proposal_data->syllabus_link,
+        '#title' => t('Syllabus Link'),
+    );
     $form['lab_title'] = array(
         '#type' => 'item',
         '#markup' => $proposal_data->lab_title,
@@ -970,7 +980,11 @@ function lab_migration_proposal_edit_form($form, $form_state)
         '#options' => _lm_list_of_software_version(),
         '#markup' => $proposal_data->r_version
     );
-
+    $form['syllabus_link'] = array(
+        '#type' => 'item',
+        '#markup' => $proposal_data->syllabus_link,
+        '#title' => t('Syllabus Link'),
+    );
     $form['lab_title'] = array(
         '#type' => 'textfield',
         '#title' => t('Title of the Lab'),
diff --git a/proposal.inc b/proposal.inc
index 381b40e..281aff3 100755
--- a/proposal.inc
+++ b/proposal.inc
@@ -233,6 +233,14 @@ function lab_migration_proposal_form($form, &$form_state)
             )
         )
     );
+    $form['syllabus_link'] = array(
+        '#type' => 'textfield',
+        '#title' => t('Syllabus Link'),
+        '#required' => TRUE,
+        '#attributes' => array(
+            'placeholder' => 'Add the syllabus link '
+        )
+    );
     $form['syllabus_copy'] = array(
         '#type' => 'fieldset',
         '#title' => t('<span class="form-required form-item" title="This field is required.">Syllabus copy (PDF) Files *</span>'),
@@ -505,9 +513,9 @@ function lab_migration_proposal_form_submit($form, &$form_state)
     $university = $v['university'];    
     $directory_name = _lm_dir_name($lab_title, $proposar_name, $university);
     $result = "INSERT INTO {lab_migration_proposal} 
-    (uid, approver_uid, name_title, name, contact_ph, department, university, city, pincode, state, country, operating_system, r_version, lab_title, approval_status, solution_status, solution_provider_uid, solution_display, creation_date, approval_date, solution_date, solution_provider_name_title, solution_provider_name, solution_provider_contact_ph, solution_provider_department, solution_provider_university, directory_name,syllabus_copy_file_path) VALUES
+    (uid, approver_uid, name_title, name, contact_ph, department, university, city, pincode, state, country, operating_system, r_version, syllabus_link, lab_title, approval_status, solution_status, solution_provider_uid, solution_display, creation_date, approval_date, solution_date, solution_provider_name_title, solution_provider_name, solution_provider_contact_ph, solution_provider_department, solution_provider_university, directory_name,syllabus_copy_file_path) VALUES
     (:uid, :approver_uid, :name_title, :name, :contact_ph, :department, :university, :city, :pincode, :state, :country, :operating_system, 
-     :r_version, :lab_title, :approval_status, :solution_status, :solution_provider_uid, :solution_display, :creation_date, 
+     :r_version, :syllabus_link, :lab_title, :approval_status, :solution_status, :solution_provider_uid, :solution_display, :creation_date, 
      :approval_date, :solution_date, :solution_provider_name_title, :solution_provider_name,
       :solution_provider_contact_ph, :solution_provider_department, :solution_provider_university, :directory_name,:syllabus_copy_file_path)";
     $args = array(
@@ -524,6 +532,7 @@ function lab_migration_proposal_form_submit($form, &$form_state)
         ":country" => $v['country'],
         ":operating_system" => $v['operating_system'],
         ":r_version" => $form_state['values']['version'],
+        ":syllabus_link" => $v['syllabus_link'],
         ":lab_title" => $v['lab_title'],
         ":approval_status" => 0,
         ":solution_status" => $solution_status,