diff options
Diffstat (limited to 'solution_proposal.inc')
| -rwxr-xr-x | solution_proposal.inc | 44 |
1 files changed, 42 insertions, 2 deletions
diff --git a/solution_proposal.inc b/solution_proposal.inc index 83841c5..444c073 100755 --- a/solution_proposal.inc +++ b/solution_proposal.inc @@ -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' => _list_of_states(), '#validated' => TRUE, '#states' => array( 'visible' => array( @@ -197,7 +197,7 @@ function lab_migration_solution_proposal_form($form, $form_state) $form['city'] = array( '#type' => 'select', '#title' => t('City'), - '#options' => _lm_list_of_cities(), + '#options' => _list_of_cities(), '#states' => array( 'visible' => array( ':input[name="country"]' => array( @@ -389,3 +389,43 @@ 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 _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 _list_of_cities() + { + $city = 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 _list_of_departments() + { + $department = array(); + $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; + }
\ No newline at end of file |