source: branches/1.2/workflow/inc/local/classes/class.wf_location.php @ 1349

<?php
/**
 * Class for getting city/state information
 * @license http://www.gnu.org/copyleft/gpl.html GPL
 * @package Workflow
 * @subpackage local
 */

class wf_location
{  /**
        * @var object $db banco de dados
        * @access private
        */
        var $db;
   /**
        * @var array $cityInfo Armazena informações sobre a cidade
        * @access public
        */
        var $cityInfo;
   /**
        * @var array $stateInfo Armazena as informações sobre o Estado
        * @access public
        */
        var $stateInfo;
   /**
        * @var array $citiesFromState Armazena as cidades de um estado
        * @access public
        */
        var $citiesFromState;

        /**
         * Inicializa os arrays da classe
         * return void
         * @access private
         */
        function initialize()
        {
                $this->db = &$GLOBALS['workflow']['workflowObjects']->getDBExpresso()->Link_ID;
                $this->db->setFetchMode(ADODB_FETCH_ASSOC);
                $this->cityInfo = array();
                $this->stateInfo = array();
                $this->citiesFromState = array();
        }

        /**
         * Construtor da classe
         * return object
         * @access public
         */
        function wf_location()
        {
                $this->initialize();
        }

        /**
         * Busca as informações da cidade pelo numero id passado
         * @param int $city_id Numero ID da cidade
         * @return mixed (array ou boolean)
         * @access public
         */
        function getCityById($city_id)
        {
                if (!is_numeric($city_id))
                        return false;

                $city_id = (int) $city_id;
                if (isset($this->cityInfo[$city_id]))
                        return $this->cityInfo[$city_id];

                $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
                        c.id_city = ?";

                $result = $this->db->query($sql, array($city_id));
                $output = $result->fetchRow();

                $this->cityInfo[$city_id] = $output;
                return $output;
        }

   /**
        * Busca as informações do estado pelo id passado
        * @param int $state_id Numero ID do estado
        * @return mixed (array ou boolean)
        * @access public
        */
        function getStateById($state_id)
        {
                if (!is_numeric($state_id))
                        return false;

                $state_id = (int) $state_id;
                if (isset($this->stateInfo[$state_id]))
                        return $this->stateInfo[$state_id];

                $sql =
                "SELECT
                        id_state,
                        state_name,
                        state_symbol
                FROM
                        phpgw_cc_state
                WHERE
                        id_country = 'BR' AND
                        id_state = ?";

                $result = $this->db->query($sql, array($state_id));
                $output = $result->fetchRow();

                $this->stateInfo[$city_id] = $output;
                return $output;
        }
    /**
         * Busca as cidades de um estado
         * @param int $state_id Numero ID do estado
         * @return mixed (array ou boolean)
         * @access public
         */
        function getCitiesFromState($state_id)
        {
                if (!is_numeric($state_id))
                        return false;

                $state_id = (int) $state_id;
                if (isset($this->citiesFromState[$state_id]))
                        return $this->citiesFromState[$state_id];

                $sql =
                "SELECT
                        c.id_city AS id_city,
                        c.city_name AS city_name
                FROM
                        phpgw_cc_state s,
                        phpgw_cc_city c
                WHERE
                        c.id_state = s.id_state AND
                        s.id_country = 'BR' AND
                        c.id_state = ?
                ORDER BY
                        city_name";

                $result = $this->db->query($sql, array($state_id));
                $output = array();
                while ($row = $result->fetchRow())
                        $output[] = $row;

                $this->citiesFromState[$state_id] = $output;
                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;
        }
}
?>