mambax7 / xoops-martin

     * @param $order_id

     * @return array

     */

    public function GetOrderRooms($order_id)

    {

        if (!$order_id) {

            return $order_id;

        }

        global $xoopsDB;

        $sql = "SELECT mor.room_id , mor.room_count ,mor.room_date , r.room_name , h.hotel_id , 

            rp.room_is_today_special,rp.room_price,rp.room_advisory_range_small,rp.room_advisory_range_max ,

            h.hotel_name,hotel_city_id ";

        $sql .= "FROM " . $xoopsDB->prefix("martin_order_room") . " mor ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room") . " r ON ( r.room_id = mor.room_id ) ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room_price") . " rp ON ( r.room_id = rp.room_id AND mor.room_date = rp.room_date ) ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_hotel") . " h ON ( r.hotel_id = h.hotel_id ) ";

        $sql .= " WHERE 1 = 1 ";

        $sql .= $order_id > 0 ? " AND mor.order_id = $order_id " : " ";

        $sql .= " Group by mor.room_date order by mor.room_id DESC ";

        //echo '<pre>'.$sql;exit;

        $result = $xoopsDB->query($sql);

        $rows   = array();

        while ($row = $xoopsDB->fetchArray($result)) {

            $rows[] = $row;

        }

        return $rows;

    }

    /**

     * @get       order query rooms

     * @param $order_id

     * @return array

     */

    public function GetOrderQueryRooms($order_id)

    {

        if (!$order_id) {

            return $order_id;

        }

        global $xoopsDB;

        $sql = "SELECT mor.room_id , mor.room_count ,mor.room_date , mor.room_price , r.* , 

            rp.room_is_today_special,rp.room_advisory_range_small,rp.room_advisory_range_max ,

            h.hotel_name,hotel_city_id ";

        $sql .= "FROM " . $xoopsDB->prefix("martin_order_query_room") . " mor ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room") . " r ON ( r.room_id = mor.room_id ) ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_room_price") . " rp ON ( r.room_id = rp.room_id AND mor.room_date = rp.room_date ) ";

        $sql .= " LEFT JOIN " . $xoopsDB->prefix("martin_hotel") . " h ON ( r.hotel_id = h.hotel_id ) ";

        $sql .= " WHERE 1 = 1 ";

        $sql .= $order_id > 0 ? " AND mor.order_id = $order_id " : " ";

        $sql .= " Group by mor.room_date order by mor.room_id DESC ";

        //echo '<pre>'.$sql;exit;

        $result = $xoopsDB->query($sql);

        $rows   = array();

        while ($row = $xoopsDB->fetchArray($result)) {

            $rows[] = $row;

        }

        return $rows;

    }

    /**

     * @得到类别列表