Update functions to display the list of cities and states

1 files changed, 54 insertions, 0 deletions

diff --git a/lab_migration.module b/lab_migration.module
index d50b896..dda426f 100755
--- a/lab_migration.module
+++ b/lab_migration.module
@@ -760,5 +760,59 @@ function lm_ucname($string)
     return $string;
   }
  
+ 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()
+  {
+    $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 _lm_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;
+  }
+function _lm_list_of_software_version()
+  {
+    $software_version = array();
+    $query = db_select('r_software_version');
+    $query->fields('r_software_version');
+    $query->orderBy('id', 'DESC');
+    $software_version_list = $query->execute();
+    while ($software_version_list_data = $software_version_list->fetchObject())
+      {
+        $software_version[$software_version_list_data->r_version] = $software_version_list_data->r_version;
+      }
+    return $software_version;
+  }