diff options
| -rwxr-xr-x[-rw-r--r--] | README.md | 0 | ||||
| -rwxr-xr-x | lab_details.inc | 2 | ||||
| -rwxr-xr-x | solution_proposal.inc | 44 |
3 files changed, 43 insertions, 3 deletions
diff --git a/README.md b/README.md index 3f9f26a..3f9f26a 100644..100755 --- a/README.md +++ b/README.md diff --git a/lab_details.inc b/lab_details.inc index aef0ee4..baf30a3 100755 --- a/lab_details.inc +++ b/lab_details.inc @@ -6,7 +6,7 @@ function lab_migration_completed_labs_all() $query = db_select('lab_migration_proposal'); $query->fields('lab_migration_proposal'); $query->condition('approval_status', 3); - $query->orderBy('approval_date',DESC); + $query->orderBy('approval_date', DESC); $result = $query->execute(); //$result = db_query($query); if ($result->rowCount() == 0) 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 |