Adding second software version

2 files changed, 17 insertions, 6 deletions

diff --git a/proposal.inc b/proposal.inc
index 276b07d..2b8dba1 100755
--- a/proposal.inc
+++ b/proposal.inc
@@ -304,12 +304,12 @@ function science_and_concept_map_proposal_form($form, &$form_state, $no_js_use =
 		)
 	);
 	$form['second_software'] = array(
-		'#type' => 'textfield',
-		'#title' => t('Enter Second Software (If applicable)'),
-		'#size' => 250,
+		'#type' => 'select',
+		'#title' => t('Select Second Software (If applicable)'),
+		'#options' => _soul_list_of_second_software_version(),
 		'#attributes' => array(
-			'placeholder' => t('Enter Second Software')
-		),
+                'placeholder' => t('Select Second Software')
+            ),
 	);
 	$form['project_title'] = array(
 		'#type' => 'textarea',
diff --git a/science_and_concept_map.module b/science_and_concept_map.module
index 8d2d4e3..f8e49dd 100755
--- a/science_and_concept_map.module
+++ b/science_and_concept_map.module
@@ -773,7 +773,18 @@ function _df_list_of_departments()
 	} //$department_list_data = $department_list->fetchObject()
 	return $department;
 }
-
+function _soul_list_of_second_software_version()
+{
+    $second_software = array();
+    $query = db_select('soul_science_and_concept_map_second_software');
+    $query->fields('soul_science_and_concept_map_second_software');
+    $second_software_list = $query->execute();
+    while ($second_software_list_data = $second_software_list->fetchObject())
+      {
+        $second_software[$second_software_list_data->second_software] = $second_software_list_data->second_software;
+      }
+    return $second_software;
+}
 function _soul_list_of_category()
   {
     $category = array();