Changeset 7440 for trunk

Timestamp:

10/18/12 14:44:26 (12 years ago)

Author:

rafaelgobara

Message:

Ticket #3168 - Parametrizado o método para retornar ou não o nome acentuado

File:

• trunk/workflow/inc/local/classes/class.wf_location.php (modified) (2 diffs)

trunk/workflow/inc/local/classes/class.wf_location.php

@@ -177 +177 @@
          * @access public
          */
-        function getCitiesByKey($key, $state_id = 0, $include_districts = true)
+        function getCitiesByKey($key, $state_id = 0, $include_districts = true, $hasAccent = true)
         {
                 if (!is_string($key) || !is_numeric($state_id) || !is_bool($include_districts))
@@ -191 +191 @@
                 }
 
+                $city_name = 'c.city_name AS city_name,';
+
+                if(!$hasAccent)
+                {
+                        $city_name = 'TO_ASCII(c.city_name) AS city_name,';
+                }
+
                 $sql =
                 "SELECT
                         c.id_city AS id_city,
-                        c.city_name AS city_name,
+                        $city_name
                         s.id_state AS id_state,
                         s.state_name AS state_name,