mambax7 / xoops-martin

     * @param int $hotel_id

     * @return array

     */

    public function getHotelList($hotel_id = 0)

    {

        $rows = array();

        $sql  = "SELECT hotel_id ,hotel_name FROM " . $this->db->prefix("martin_hotel");

        $sql .= $hotel_id > 0 ? " WHERE hotel_id = $hotel_id" : "";

        $sql .= " order BY hotel_rank ,hotel_id DESC ";

        $result = $this->db->query($sql);

        while ($row = $this->db->fetchArray($result)) {

            $rows[$row['hotel_id']] = $row['hotel_name'];

        }

        return $rows;

    }

    /**

     * @get       service list

     * @param int $service_id

     * @return array

     */

    public function getServiceList($service_id = 0)

    {

        $rows = array();

        $sql  = "SELECT service_id ,service_name FROM " . $this->db->prefix("martin_hotel_service");

        $sql .= $hotel_id > 0 ? " WHERE service_id = $service_id" : "";

        $result = $this->db->query($sql);

        while ($row = $this->db->fetchArray($result)) {

            $rows[$row['service_id']] = $row['service_name'];

        }

        return $rows;

    }

    /**

     * @get       relation count

     * @param int $room_type_id

     * @return array

     */

    public function getRoomTypeList($room_type_id = 0)

    {

        $rows = array();

        $sql  = "SELECT * FROM " . $this->db->prefix("martin_room_type");

        $sql .= $room_type_id > 0 ? " WHERE room_type_id = $room_type_id" : "";

        $result = $this->db->query($sql);

        while ($row = $this->db->fetchArray($result)) {

            $rows[$row['room_type_id']] = $row['room_type_info'];

        }

        return $rows;

    }

    /**

     * @get       room type list

     * @param int $room_id

     * @return array

     */

    public function getRoomList($room_id = 0)

    {

        $rows = array();

        $sql  = "SELECT room_id,room_name FROM " . $this->db->prefix("martin_room");

        $sql .= $room_id > 0 ? " WHERE room_id = $room_id" : "";

        $result = $this->db->query($sql);

        while ($row = $this->db->fetchArray($result)) {

            $rows[$row['room_id']] = $row['room_name'];

        }

        return $rows;

    }

    /**

     * insert update room type