Esempio n. 1
0
 public function buscaTipoAcomodacoes()
 {
     $_sql = sprintf("\tSELECT COUNT(DISTINCT(h.tipo_acomodacao)) AS tipos \n\t\t\t\t\t\t\tFROM evnts_hotel h, evnts_hotel_evento he\n\t\t\t\t\t\t\tWHERE he.id_evento = %d\n\t\t\t\t\t\t\tAND h.situacao like 'A'\n\t\t\t\t\t\t\tAND he.id_hotel = h.id_hotel;", $this->_evento);
     $arr = parent::carrega_linha($_sql);
     return (int) $arr["tipos"];
 }
Esempio n. 2
0
 public function buscaHotel()
 {
     $_sql = sprintf("SELECT * \n\t\t\t\t\t\t   FROM evnts_hotel\n\t\t\t\t\t\t  WHERE id_hotel = %d;", $this->_hotel);
     // Carregando a linha;
     return parent::carrega_linha($_sql);
 }