diff options
Diffstat (limited to 'solution_proposal.inc')
| -rwxr-xr-x | solution_proposal.inc | 69 |
1 files changed, 65 insertions, 4 deletions
diff --git a/solution_proposal.inc b/solution_proposal.inc index 83841c5..b854771 100755 --- a/solution_proposal.inc +++ b/solution_proposal.inc @@ -115,7 +115,7 @@ function lab_migration_solution_proposal_form($form, $form_state) $form['solution_provider_department'] = array( '#type' => 'select', '#title' => t('Department/Branch'), - '#options' => _list_of_departments(), + '#options' => lm_list_of_departments(), '#required' => TRUE ); $form['solution_provider_university'] = array( @@ -184,7 +184,7 @@ function lab_migration_solution_proposal_form($form, $form_state) $form['all_state'] = array( '#type' => 'select', '#title' => t('State'), - '#options' => _lm_list_of_states(), + '#options' => lm_list_of_states(), '#validated' => TRUE, '#states' => array( 'visible' => array( @@ -197,7 +197,8 @@ function lab_migration_solution_proposal_form($form, $form_state) $form['city'] = array( '#type' => 'select', '#title' => t('City'), - '#options' => _lm_list_of_cities(), + '#options' => lm_list_of_cities(), + '#validated' => TRUE, '#states' => array( 'visible' => array( ':input[name="country"]' => array( @@ -219,7 +220,7 @@ function lab_migration_solution_proposal_form($form, $form_state) $form['version'] = array( '#type' => 'select', '#title' => t('Version'), - '#options' => _list_of_software_version(), + '#options' => lm_list_of_software_version(), '#required' => TRUE ); $form['older'] = array( @@ -389,3 +390,63 @@ function lab_migration_solution_proposal_form_submit($form, &$form_state) drupal_set_message('Error sending email message.', 'error');*/ drupal_goto('lab-migration/open-proposal'); } + + +function lm_list_of_departments() + { + $department = array( + 0 => '-Select-' + ); + $query = db_select('list_of_departments'); + $query->fields('list_of_departments'); + $query->orderBy('id', 'DESC'); + $department_list = $query->execute(); + while ($department_list_data = $department_list->fetchObject()) + { + $department[$department_list_data->department] = $department_list_data->department; + } + return $department; + } +function lm_list_of_states() + { + $states = array( + 0 => '-Select-' + ); + $query = db_select('list_states_of_india'); + $query->fields('list_states_of_india'); + //$query->orderBy('', ''); + $states_list = $query->execute(); + while ($states_list_data = $states_list->fetchObject()) + { + $states[$states_list_data->state] = $states_list_data->state; + } + return $states; + } +function lm_list_of_cities() + { + $states = array( + 0 => '-Select-' + ); + $query = db_select('list_cities_of_india'); + $query->fields('list_cities_of_india'); + $query->orderBy('city', 'ASC'); + $city_list = $query->execute(); + while ($city_list_data = $city_list->fetchObject()) + { + $city[$city_list_data->city] = $city_list_data->city; + } + return $city; + } + function lm_list_of_software_version() + { + $software_version = array(); + $query = db_select('openfoam_software_version'); + $query->fields('openfoam_software_version'); + $query->orderBy('id', 'ASC'); + $software_version_list = $query->execute(); + while ($software_version_list_data = $software_version_list->fetchObject()) + { + $software_version[$software_version_list_data->version] = $software_version_list_data->version; + } + return $software_version; + }
\ No newline at end of file |