Changeset 2137

Timestamp:

03/02/10 16:24:13 (14 years ago)

Author:

asaikawa

Message:

Ticket #943 - Criado metodo para recuperar cidades pelo inicio do nome, limitando em 10 registros

File:

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

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

@@ -167 +167 @@
                 return $output;
         }
-        /**
-         * Busca os estados brasileiros
-         * @return mixed (array ou boolean)
-         * @access public
-         */
-        function getStates()
-        {
-                $sql =
-                "SELECT
-                        id_state,
-                        state_name
-                FROM
-                        phpgw_cc_state
-                WHERE
-                        id_country = 'BR'
+    /**
+         * Busca as cidades por parte do nome, sem considerar maiúsculas e/ou minúsculas e nem acentuação (retorna 10 resultados)
+         * @param string Parte do nome da cidade
+         * @param int $state_id Numero ID do estado
+         * @param bool $include_districts True, busca cidades e distritos. False, busca apenas cidades.
+         * @return mixed (array ou boolean)
+         * @access public
+         */
+        function getCitiesByKey($key, $state_id = 0, $include_districts = true)
+        {
+                if (!is_string($key) || !is_numeric($state_id) || !is_bool($include_districts))
+                        return false;
+
+                $where = "";
+                if($state_id > 0){
+                        $where = " AND c.id_state = " . $state_id;
+                }
+
+                if(!$include_districts){
+                        $where = " AND c.is_district = 'F' ";
+                }
+
+                $sql =
+                "SELECT
+                        c.id_city AS id_city,
+                        c.city_name AS city_name,
+                        s.id_state AS id_state,
+                        s.state_name AS state_name,
+                        s.state_symbol AS state_symbol
+                FROM
+                        phpgw_cc_state s,
+                        phpgw_cc_city c
+                WHERE
+                        c.id_state = s.id_state AND
+                        s.id_country = 'BR' AND
+                        TO_ASCII(c.city_name) ILIKE TO_ASCII('" . $key . "%')
+                        " . $where . "
                 ORDER BY
-                        state_name";
+                        city_name
+                LIMIT 10";
 
                 $result = $this->db->query($sql);
@@ -192 +215 @@
                 return $output;
         }
+        /**
+         * Busca os estados brasileiros
+         * @return mixed (array ou boolean)
+         * @access public
+         */
+        function getStates()
+        {
+                $sql =
+                "SELECT
+                        id_state,
+                        state_name
+                FROM
+                        phpgw_cc_state
+                WHERE
+                        id_country = 'BR'
+                ORDER BY
+                        state_name";
+
+                $result = $this->db->query($sql);
+                $output = array();
+                while ($row = $result->fetchRow())
+                        $output[] = $row;
+
+                return $output;
+        }
 }
 ?>