Wrox Programmer Forums
Go Back   Wrox Programmer Forums > XML > XSLT
Reload this Page xsl:Looping more than one time through same node
|
XSLT General questions and answers about XSLT. For issues strictly specific to the book XSLT 1.1 Programmers Reference, please post to that forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the XSLT section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Page 2 of 4 1 2 3 4
 
Old April 22nd, 2009, 03:35 AM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
Hi Martin,

Everything is working so beautifully.
But, the irony is : our system supports only xsl version 1.0


I have aggregated the whole response separately but when tried to integrated it into our existing system, it doesn't recognise for-each-group :(

Mary
 
Old April 22nd, 2009, 03:48 AM
mhkay's Avatar
Wrox Author
  
Join Date: Apr 2004
Posts: 4,962
Thanks: 0
Thanked 292 Times in 287 Posts
Default
If you really don't have the option of upgrading to XSLT 2.0 then (a) you have my deepest sympathy, and (b) you'll have to get your head around the complexities of the Muenchian grouping technique. It's described in numerous tutorials and in most XSLT textbooks, and it's not difficult once you get the hang of it, but it's a bit mind-blowing when first encountered.
__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference
 
Old April 22nd, 2009, 05:52 AM
Friend of Wrox
  
Join Date: Nov 2007
Posts: 1,243
Thanks: 0
Thanked 245 Times in 244 Posts
Default
Here is an attempt to translate the XSLT 2.0 stylesheet using xsl:for-each-group into an XSLT 1.0 stylesheet using Muenchian grouping:
Code:
<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">
  
  <xsl:output method="xml" indent="yes"/>
  
  <xsl:key name="k1"
           match="Rate[not(@Code = 'RAC')]"
           use="concat(@Code, '|', @Room)"/>
  
  <xsl:template match="Rates">
    <xsl:copy>
      <xsl:for-each select="Rate[not(@Code = 'RAC')][generate-id() = generate-id(key('k1', concat(@Code, '|', @Room))[1])]">
        <xsl:variable name="current-group" select="key('k1', concat(@Code, '|', @Room))"/>
        <Rate Guests="{sum($current-group/@Guests)}"
              Units="{sum($current-group/@Units)}"
              Code="{@Code}" Room="{@Room}">
          <aa>
            <xsl:for-each select="aa/Night">
              <xsl:variable name="pos" select="position()"/>
              <Night Amount="{sum($current-group/aa/Night[position() = $pos]/@Amount)}"
                     Code="{@Code}" Room="{@Room}"/>
            </xsl:for-each>
          </aa>
        </Rate>
      </xsl:for-each>
    </xsl:copy>
  </xsl:template>

</xsl:stylesheet>
Muenchian grouping is explained here: http://www.jenitennison.com/xslt/grouping/muenchian.xml
__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog
The Following User Says Thank You to Martin Honnen For This Useful Post:
maryj (April 23rd, 2009)
 
Old April 22nd, 2009, 06:04 AM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
You know what Martin...

I was reading your earlier post on grouping in xslt 1.0
"group by" in XSLT 1.0 (please help)

approx. completed my coding with the help of that.

But, really don't know how to thank u for all your timely help. I need to submit all this by tomorrow.

and again, now, its done :).......thanks a lot for all ur efforts

Thanks and Regards,
Mary
 
Old April 23rd, 2009, 12:43 PM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
Hi Martin,

I am having some trouble. Can I send you some attachments somewhere. I can't attach them here :( Its public forum.

Its on urgent basis. Please help !!

Best Regards,
Mary
 
Old April 24th, 2009, 03:23 AM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
There is another node above <Rates> which is also multiple times and needs to be considered as:

<Stay>
<Rates>
<Rate Room="DLX" Code="EP"/>
<Rate Room="SUV" Code="EP/>
</Rates>
</Stay>

<Stay>
<Rates>
<Rate Room="SDL" Code="EP/>
<Rate Room="DLX" Code="EP/>
</Rates>
</Stay>


Now, my code doesn't understands 'DLX' for <Stay> nodes separately.
It simply checks for concat ( @Room | @Code ) and adds results for this group.
Please advise where should the <Stay> for-each be placed so that it doesn't interfere with each other.

What I am doing right now is :

<xsl:for-each select="Stay">
<xsl:apply-templates mode="Rates" select="Rates"/>
</xsl:for-each>

After that, I have defined the key k1 and written the code earlier suggested by Martin for xslt 1.0.

The only thing remaining is : template 'Rates' should apply on each and every <Stay> node also.
 
Old April 28th, 2009, 01:34 AM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
Please help me out one more time.....

its real urgent

Regards,
Mary
 
Old April 28th, 2009, 09:04 AM
Friend of Wrox
  
Join Date: Nov 2007
Posts: 1,243
Thanks: 0
Thanked 245 Times in 244 Posts
Default
How does your current XML input look? Post a representative and well-formed sample of that. Then show the corresponding output the stylesheet should create.
__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog
  Spam!  
Old April 28th, 2009, 11:56 PM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
Hi Martin,

Thanks for coming back. I was nearly going to die :)

Size of all xmls is too big but anyways I am pasting them here for your easy reference.

This is my input xml :


.c9Y6TC { color:#0000ff; } .c194KG { color:#602020; } .cLUY2 { color:#ea8f0f; } .c18YC0 { color:#d00020; } .c5M9S0 { color:#000090; }
Code:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Body>
        <OTA_HotelAvailRQ xmlns="http://www.opentravel.org/OTA/2003/05" MaxResponses="50" PrimaryLangID="en" RateRangeOnly="true" SummaryOnly="false" Target="avail" TransactionIdentifier="avail" Version="1">
            <POS>
                <Source ISOCurrency="INR" PseudoCityCode="PCC" TerminalID="1">
                    <RequestorID ID="YATRA"/>
                </Source>
                <YatraRequests>
                    <YatraRequest AffiliateID="1A" AgentEmailID="" AgentTypeCode="" Description="" MidOfficeAgentID="" YatraRequestTypeCode=""/>
                </YatraRequests>
            </POS>
        </OTA_HotelAvailRQ>
        <ns1:OTA_HotelAvailRS Version="2.001" xmlns="http://www.opentravel.org/OTA/2003/05" xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
            <ns1:RoomStays>
                <ns1:RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="6" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="1" RoomTypeCode="DLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="6600.0" AmountBeforeTax="6600.0" AmountBeforeYatraMarkup="6600.0" BuyingAmount="6600.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="6600.0" AmountBeforeTax="6600.0" AmountBeforeYatraMarkup="6600.0" BuyingAmount="6600.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2200.0" AmountBeforeTax="2200.0" AmountBeforeYatraMarkup="2200.0" BuyingAmount="2200.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2200.0" AmountBeforeTax="2200.0" AmountBeforeYatraMarkup="2200.0" BuyingAmount="2200.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2200.0" AmountBeforeTax="2200.0" AmountBeforeYatraMarkup="2200.0" BuyingAmount="2200.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="0" MealPlanCode="6" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="CP" RoomRPH="1" RoomTypeCode="DLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="3210.0" AmountBeforeTax="3210.0" AmountBeforeYatraMarkup="3000.0" BuyingAmount="3000.0" CashBackAmount="1284.0" CashBackType="P-40" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="3210.0" AmountBeforeTax="3210.0" AmountBeforeYatraMarkup="3000.0" BuyingAmount="3000.0" CashBackAmount="1284.0" CashBackType="P-40" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1070.0" AmountBeforeTax="1070.0" AmountBeforeYatraMarkup="1000.0" BuyingAmount="1000.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="CP" SeasonRPH="2" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1070.0" AmountBeforeTax="1070.0" AmountBeforeYatraMarkup="1000.0" BuyingAmount="1000.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="CP" SeasonRPH="2" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1070.0" AmountBeforeTax="1070.0" AmountBeforeYatraMarkup="1000.0" BuyingAmount="1000.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="CP" SeasonRPH="2" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="6" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="2" RoomTypeCode="DLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="8400.0" AmountBeforeTax="8400.0" AmountBeforeYatraMarkup="8400.0" BuyingAmount="8400.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="8400.0" AmountBeforeTax="8400.0" AmountBeforeYatraMarkup="8400.0" BuyingAmount="8400.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2800.0" AmountBeforeTax="2800.0" AmountBeforeYatraMarkup="2800.0" BuyingAmount="2800.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2800.0" AmountBeforeTax="2800.0" AmountBeforeYatraMarkup="2800.0" BuyingAmount="2800.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2800.0" AmountBeforeTax="2800.0" AmountBeforeYatraMarkup="2800.0" BuyingAmount="2800.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="0" MealPlanCode="6" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="CP" RoomRPH="2" RoomTypeCode="DLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="5136.0" AmountBeforeTax="5136.0" AmountBeforeYatraMarkup="4800.0" BuyingAmount="4800.0" CashBackAmount="2054.4" CashBackType="P-40" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="5136.0" AmountBeforeTax="5136.0" AmountBeforeYatraMarkup="4800.0" BuyingAmount="4800.0" CashBackAmount="2054.4" CashBackType="P-40" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1712.0" AmountBeforeTax="1712.0" AmountBeforeYatraMarkup="1600.0" BuyingAmount="1600.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="CP" SeasonRPH="2" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1712.0" AmountBeforeTax="1712.0" AmountBeforeYatraMarkup="1600.0" BuyingAmount="1600.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="CP" SeasonRPH="2" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1712.0" AmountBeforeTax="1712.0" AmountBeforeYatraMarkup="1600.0" BuyingAmount="1600.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="CP" SeasonRPH="2" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                    </ns1:RoomRates>
                </ns1:RoomStay>
                <ns1:RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="1" RoomTypeCode="SUT">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="7500.0" AmountBeforeTax="7500.0" AmountBeforeYatraMarkup="7500.0" BuyingAmount="7500.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="7500.0" AmountBeforeTax="7500.0" AmountBeforeYatraMarkup="7500.0" BuyingAmount="7500.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2500.0" AmountBeforeTax="2500.0" AmountBeforeYatraMarkup="2500.0" BuyingAmount="2500.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2500.0" AmountBeforeTax="2500.0" AmountBeforeYatraMarkup="2500.0" BuyingAmount="2500.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2500.0" AmountBeforeTax="2500.0" AmountBeforeYatraMarkup="2500.0" BuyingAmount="2500.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="1" RoomTypeCode="SUT">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="6420.0" AmountBeforeTax="6420.0" AmountBeforeYatraMarkup="6000.0" BuyingAmount="6000.0" CashBackAmount="642.0" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="6420.0" AmountBeforeTax="6420.0" AmountBeforeYatraMarkup="6000.0" BuyingAmount="6000.0" CashBackAmount="642.0" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2140.0" AmountBeforeTax="2140.0" AmountBeforeYatraMarkup="2000.0" BuyingAmount="2000.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="2140.0" AmountBeforeTax="2140.0" AmountBeforeYatraMarkup="2000.0" BuyingAmount="2000.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="2140.0" AmountBeforeTax="2140.0" AmountBeforeYatraMarkup="2000.0" BuyingAmount="2000.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="1" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="5400.0" AmountBeforeTax="5400.0" AmountBeforeYatraMarkup="5400.0" BuyingAmount="5400.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="5400.0" AmountBeforeTax="5400.0" AmountBeforeYatraMarkup="5400.0" BuyingAmount="5400.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1800.0" AmountBeforeTax="1800.0" AmountBeforeYatraMarkup="1800.0" BuyingAmount="1800.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="1800.0" AmountBeforeTax="1800.0" AmountBeforeYatraMarkup="1800.0" BuyingAmount="1800.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="1800.0" AmountBeforeTax="1800.0" AmountBeforeYatraMarkup="1800.0" BuyingAmount="1800.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="1" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="4622.4" AmountBeforeTax="4622.4" AmountBeforeYatraMarkup="4320.0" BuyingAmount="4320.0" CashBackAmount="462.24" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="4622.4" AmountBeforeTax="4622.4" AmountBeforeYatraMarkup="4320.0" BuyingAmount="4320.0" CashBackAmount="462.24" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1540.8" AmountBeforeTax="1540.8" AmountBeforeYatraMarkup="1440.0" BuyingAmount="1440.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1540.8" AmountBeforeTax="1540.8" AmountBeforeYatraMarkup="1440.0" BuyingAmount="1440.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1540.8" AmountBeforeTax="1540.8" AmountBeforeYatraMarkup="1440.0" BuyingAmount="1440.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="2" RoomTypeCode="SUT">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="7500.0" AmountBeforeTax="7500.0" AmountBeforeYatraMarkup="7500.0" BuyingAmount="7500.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="7500.0" AmountBeforeTax="7500.0" AmountBeforeYatraMarkup="7500.0" BuyingAmount="7500.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2500.0" AmountBeforeTax="2500.0" AmountBeforeYatraMarkup="2500.0" BuyingAmount="2500.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2500.0" AmountBeforeTax="2500.0" AmountBeforeYatraMarkup="2500.0" BuyingAmount="2500.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2500.0" AmountBeforeTax="2500.0" AmountBeforeYatraMarkup="2500.0" BuyingAmount="2500.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="2" RoomTypeCode="SUT">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="6420.0" AmountBeforeTax="6420.0" AmountBeforeYatraMarkup="6000.0" BuyingAmount="6000.0" CashBackAmount="642.0" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="6420.0" AmountBeforeTax="6420.0" AmountBeforeYatraMarkup="6000.0" BuyingAmount="6000.0" CashBackAmount="642.0" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2140.0" AmountBeforeTax="2140.0" AmountBeforeYatraMarkup="2000.0" BuyingAmount="2000.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="2140.0" AmountBeforeTax="2140.0" AmountBeforeYatraMarkup="2000.0" BuyingAmount="2000.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="2140.0" AmountBeforeTax="2140.0" AmountBeforeYatraMarkup="2000.0" BuyingAmount="2000.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="2" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="5400.0" AmountBeforeTax="5400.0" AmountBeforeYatraMarkup="5400.0" BuyingAmount="5400.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="5400.0" AmountBeforeTax="5400.0" AmountBeforeYatraMarkup="5400.0" BuyingAmount="5400.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1800.0" AmountBeforeTax="1800.0" AmountBeforeYatraMarkup="1800.0" BuyingAmount="1800.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="1800.0" AmountBeforeTax="1800.0" AmountBeforeYatraMarkup="1800.0" BuyingAmount="1800.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="1800.0" AmountBeforeTax="1800.0" AmountBeforeYatraMarkup="1800.0" BuyingAmount="1800.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="2" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="4622.4" AmountBeforeTax="4622.4" AmountBeforeYatraMarkup="4320.0" BuyingAmount="4320.0" CashBackAmount="462.24" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="4622.4" AmountBeforeTax="4622.4" AmountBeforeYatraMarkup="4320.0" BuyingAmount="4320.0" CashBackAmount="462.24" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1540.8" AmountBeforeTax="1540.8" AmountBeforeYatraMarkup="1440.0" BuyingAmount="1440.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1540.8" AmountBeforeTax="1540.8" AmountBeforeYatraMarkup="1440.0" BuyingAmount="1440.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1540.8" AmountBeforeTax="1540.8" AmountBeforeYatraMarkup="1440.0" BuyingAmount="1440.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                    </ns1:RoomRates>
                </ns1:RoomStay>

                <ns1:RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="1" RoomTypeCode="RFS">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="14520.0" AmountBeforeTax="14520.0" AmountBeforeYatraMarkup="14520.0" BuyingAmount="14520.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="14520.0" AmountBeforeTax="14520.0" AmountBeforeYatraMarkup="14520.0" BuyingAmount="14520.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="4840.0" AmountBeforeTax="4840.0" AmountBeforeYatraMarkup="4840.0" BuyingAmount="4840.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="4840.0" AmountBeforeTax="4840.0" AmountBeforeYatraMarkup="4840.0" BuyingAmount="4840.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="4840.0" AmountBeforeTax="4840.0" AmountBeforeYatraMarkup="4840.0" BuyingAmount="4840.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="1" RoomTypeCode="RFS">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="9309.0" AmountBeforeTax="9309.0" AmountBeforeYatraMarkup="8700.0" BuyingAmount="8700.0" CashBackAmount="930.9" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="9309.0" AmountBeforeTax="9309.0" AmountBeforeYatraMarkup="8700.0" BuyingAmount="8700.0" CashBackAmount="930.9" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="3103.0" AmountBeforeTax="3103.0" AmountBeforeYatraMarkup="2900.0" BuyingAmount="2900.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="3103.0" AmountBeforeTax="3103.0" AmountBeforeYatraMarkup="2900.0" BuyingAmount="2900.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="3103.0" AmountBeforeTax="3103.0" AmountBeforeYatraMarkup="2900.0" BuyingAmount="2900.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>      
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="1" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="5280.0" AmountBeforeTax="5280.0" AmountBeforeYatraMarkup="5280.0" BuyingAmount="5280.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="5280.0" AmountBeforeTax="5280.0" AmountBeforeYatraMarkup="5280.0" BuyingAmount="5280.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1760.0" AmountBeforeTax="1760.0" AmountBeforeYatraMarkup="1760.0" BuyingAmount="1760.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="1760.0" AmountBeforeTax="1760.0" AmountBeforeYatraMarkup="1760.0" BuyingAmount="1760.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="1760.0" AmountBeforeTax="1760.0" AmountBeforeYatraMarkup="1760.0" BuyingAmount="1760.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="0" MealPlanCode="14" NumberOfGuests="1" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="1" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="3370.5" AmountBeforeTax="3370.5" AmountBeforeYatraMarkup="3150.0" BuyingAmount="3150.0" CashBackAmount="337.05" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="3370.5" AmountBeforeTax="3370.5" AmountBeforeYatraMarkup="3150.0" BuyingAmount="3150.0" CashBackAmount="337.05" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1123.5" AmountBeforeTax="1123.5" AmountBeforeYatraMarkup="1050.0" BuyingAmount="1050.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1123.5" AmountBeforeTax="1123.5" AmountBeforeYatraMarkup="1050.0" BuyingAmount="1050.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1123.5" AmountBeforeTax="1123.5" AmountBeforeYatraMarkup="1050.0" BuyingAmount="1050.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="2" RoomTypeCode="RFS">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="15420.0" AmountBeforeTax="15420.0" AmountBeforeYatraMarkup="15420.0" BuyingAmount="15420.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="15420.0" AmountBeforeTax="15420.0" AmountBeforeYatraMarkup="15420.0" BuyingAmount="15420.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="5140.0" AmountBeforeTax="5140.0" AmountBeforeYatraMarkup="5140.0" BuyingAmount="5140.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="5140.0" AmountBeforeTax="5140.0" AmountBeforeYatraMarkup="5140.0" BuyingAmount="5140.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="5140.0" AmountBeforeTax="5140.0" AmountBeforeYatraMarkup="5140.0" BuyingAmount="5140.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="2" RoomTypeCode="RFS">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="10272.0" AmountBeforeTax="10272.0" AmountBeforeYatraMarkup="9600.0" BuyingAmount="9600.0" CashBackAmount="1027.2" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="10272.0" AmountBeforeTax="10272.0" AmountBeforeYatraMarkup="9600.0" BuyingAmount="9600.0" CashBackAmount="1027.2" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="3424.0" AmountBeforeTax="3424.0" AmountBeforeYatraMarkup="3200.0" BuyingAmount="3200.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="3424.0" AmountBeforeTax="3424.0" AmountBeforeYatraMarkup="3200.0" BuyingAmount="3200.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="3424.0" AmountBeforeTax="3424.0" AmountBeforeYatraMarkup="3200.0" BuyingAmount="3200.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>      
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="RACK" RoomRPH="2" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups/>
                                    <ns1:Base AmountAfterTax="6180.0" AmountBeforeTax="6180.0" AmountBeforeYatraMarkup="6180.0" BuyingAmount="6180.0" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="6180.0" AmountBeforeTax="6180.0" AmountBeforeYatraMarkup="6180.0" BuyingAmount="6180.0" CurrencyCode="INR"/>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="2060.0" AmountBeforeTax="2060.0" AmountBeforeYatraMarkup="2060.0" BuyingAmount="2060.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2060.0" AmountBeforeTax="2060.0" AmountBeforeYatraMarkup="2060.0" BuyingAmount="2060.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="RACK" TaxAmount="0"/>
                                        <ns1:NightlyRate AmountAfterTax="2060.0" AmountBeforeTax="2060.0" AmountBeforeYatraMarkup="2060.0" BuyingAmount="2060.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="RACK" TaxAmount="0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" Code="TP" Percent="0"/>
                                    </ns1:Taxes>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                        <ns1:RoomRate ArtificialAllocation="1" MealPlanCode="14" NumberOfGuests="2" NumberOfUnits="1" OnRequest="false" RatePlanCode="EP" RoomRPH="2" RoomTypeCode="SDLX">
                            <ns1:Rates>
                                <ns1:Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                    </ns1:Markups>
                                    <ns1:Base AmountAfterTax="4333.5" AmountBeforeTax="4333.5" AmountBeforeYatraMarkup="4050.0" BuyingAmount="4050.0" CashBackAmount="433.35" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Total AmountAfterTax="4333.5" AmountBeforeTax="4333.5" AmountBeforeYatraMarkup="4050.0" BuyingAmount="4050.0" CashBackAmount="433.35" CashBackType="P-10" CurrencyCode="INR"/>
                                    <ns1:Taxes>
                                        <ns1:Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </ns1:Taxes>
                                    <ns1:NightlyRates>
                                        <ns1:NightlyRate AmountAfterTax="1444.5" AmountBeforeTax="1444.5" AmountBeforeYatraMarkup="1350.0" BuyingAmount="1350.0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1444.5" AmountBeforeTax="1444.5" AmountBeforeYatraMarkup="1350.0" BuyingAmount="1350.0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                        <ns1:NightlyRate AmountAfterTax="1444.5" AmountBeforeTax="1444.5" AmountBeforeYatraMarkup="1350.0" BuyingAmount="1350.0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="6" TaxAmount="0.0"/>
                                    </ns1:NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                </ns1:Rate>
                            </ns1:Rates>
                        </ns1:RoomRate>
                    </ns1:RoomRates>
                </ns1:RoomStay> 
            </ns1:RoomStays>
        </ns1:OTA_HotelAvailRS>
    </soapenv:Body>
</soapenv:Envelope>


The xslt that I am currently using is :


.c9Y6TC { color:#0000ff; } .c194KG { color:#602020; } .c49DIK { color:#ac306d; } .c18YC0 { color:#d00020; } .c5M9S0 { color:#000090; } .cLUY2 { color:#ea8f0f; } .cKJK { color:#006800; }
Code:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns="http://www.opentravel.org/OTA/2003/05" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:str="http://exslt.org/strings" xmlns:xalan="http://xml.apache.org/xalan" xmlns:helper="xalan://com.yatra.helper.YatraHelper"
                xmlns:Date="xalan://com.openjaw.utils.DateUtilities" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ota="http://www.opentravel.org/OTA/2003/05" xmlns:date="http://exslt.org/dates-and-times"
                xmlns:ns1="http://www.opentravel.org/OTA/2003/05" exclude-result-prefixes="xsl xalan Date date helper ota str">
    <xsl:output method="xml"/>

    <xsl:template match="/">
        <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <soapenv:Body>
                <OTA_HotelAvailRS>
                    <xsl:apply-templates select="//ota:OTA_HotelAvailRS/ota:RoomStays" mode="hotelAvail">
                        <xsl:with-param name="AffiliateID" select="//ota:OTA_HotelAvailRQ/ota:POS/ota:YatraRequests/ota:YatraRequest/@AffiliateID"/>
                    </xsl:apply-templates>
                </OTA_HotelAvailRS>
            </soapenv:Body>
        </soapenv:Envelope>
    </xsl:template>


    <xsl:template mode="hotelAvail" match="//ota:OTA_HotelAvailRS/ota:RoomStays">
        <xsl:param name="AffiliateID"/>
        <RoomStays>
            <xsl:for-each select="ota:RoomStay">   
                <RoomStay SupplierSystem="XHOTEL">
                    <xsl:choose>
                        <xsl:when test="$AffiliateID = '1A'">
                            <xsl:copy-of select="*[local-name() != 'RoomRates']"/>
                            <xsl:apply-templates mode="roomRates" select="ota:RoomRates"/>
                        </xsl:when>
                        <xsl:otherwise>
                            <xsl:copy-of select="*"/>
                        </xsl:otherwise>
                    </xsl:choose>
                </RoomStay>
            </xsl:for-each>
        </RoomStays>
    </xsl:template>

    <xsl:key name="k1" match="ota:RoomRates/ota:RoomRate[not(@RatePlanCode = 'RACK')]" use="concat(@RatePlanCode, '|', @RoomTypeCode)"/>

    <xsl:template match="ota:RoomRates" mode="roomRates">
        <xsl:copy>
            <xsl:for-each select="ota:RoomRate[generate-id() = generate-id(key('k1', concat(@RatePlanCode, '|', @RoomTypeCode))[1])]">
                <xsl:variable name="current-group" select="key('k1', concat(@RatePlanCode, '|', @RoomTypeCode))"/>
                <RoomRate NumberOfGuests="{sum($current-group/@NumberOfGuests)}" NumberOfUnits="{sum($current-group/@NumberOfUnits)}" RatePlanCode="{@RatePlanCode}" RoomTypeCode="{@RoomTypeCode}" ArtificialAllocation="{@ArtificialAllocation}"
                          MealPlanCode="{@MealPlanCode}" RoomRPH="{@RoomRPH}">
                    <xsl:message>units......<xsl:value-of select="sum($current-group/@NumberOfUnits)"/></xsl:message>
                    <xsl:attribute name="OnRequest">
                        <xsl:choose>
                            <xsl:when test="$current-group[@OnRequest='true']">true</xsl:when>
                            <xsl:otherwise>false</xsl:otherwise>
                        </xsl:choose>
                    </xsl:attribute>
                    <Rates>
                        <Rate>
                            <xsl:copy-of select="ota:Rates/ota:Rate/ota:Markups"/>
                            <Total AmountAfterTax="{sum($current-group/ota:Rates/ota:Rate/ota:Total/@AmountAfterTax)}" AmountBeforeTax="{sum($current-group/ota:Rates/ota:Rate/ota:Total/@AmountBeforeTax)}"
                                   AmountBeforeYatraMarkup="{sum($current-group/ota:Rates/ota:Rate/ota:Total/@AmountBeforeYatraMarkup)}" BuyingAmount="{sum($current-group/ota:Rates/ota:Rate/ota:Total/@BuyingAmount)}"
                                   CashBackAmount="{format-number(sum($current-group/ota:Rates/ota:Rate/ota:Total/@CashBackAmount),'####.##')}" CurrencyCode="{ota:Rates/ota:Rate/ota:Total/@CurrencyCode}"
                                   CashBackType="{ota:Rates/ota:Rate/ota:Total/@CashBackType}">
                            </Total>

                            <Base AmountAfterTax="{sum($current-group/ota:Rates/ota:Rate/ota:Base/@AmountAfterTax)}" AmountBeforeTax="{sum($current-group/ota:Rates/ota:Rate/ota:Base/@AmountBeforeTax)}"
                                  AmountBeforeYatraMarkup="{sum($current-group/ota:Rates/ota:Rate/ota:Base/@AmountBeforeYatraMarkup)}" BuyingAmount="{sum($current-group/ota:Rates/ota:Rate/ota:Base/@BuyingAmount)}"
                                  CashBackAmount="{format-number(sum($current-group/ota:Rates/ota:Rate/ota:Base/@CashBackAmount),'##.##')}" CurrencyCode="{ota:Rates/ota:Rate/ota:Base/@CurrencyCode}"
                                  CashBackType="{ota:Rates/ota:Rate/ota:Base/@CashBackType}">
                            </Base>

                            <NightlyRates>
                                <xsl:for-each select="ota:Rates/ota:Rate/ota:NightlyRates/ota:NightlyRate">
                                    <xsl:variable name="pos" select="position()"/>
                                    <NightlyRate AmountAfterTax="{sum($current-group/ota:Rates/ota:Rate/ota:NightlyRates/ota:NightlyRate[position() = $pos]/@AmountAfterTax)}"
                                                 AmountBeforeTax="{sum($current-group/ota:Rates/ota:Rate/ota:NightlyRates/ota:NightlyRate[position() = $pos]/@AmountBeforeTax)}"
                                                 AmountBeforeYatraMarkup="{sum($current-group/ota:Rates/ota:Rate/ota:NightlyRates/ota:NightlyRate[position() = $pos]/@AmountBeforeYatraMarkup)}"
                                                 BuyingAmount="{sum($current-group/ota:Rates/ota:Rate/ota:NightlyRates/ota:NightlyRate[position() = $pos]/@BuyingAmount)}"
                                                 TaxAmount="{sum($current-group/ota:Rates/ota:Rate/ota:NightlyRates/ota:NightlyRate[position() = $pos]/@TaxAmount)}" CurrencyCode="{@CurrencyCode}" NightNumber="{@NightNumber}" RatePlanCode="{@RatePlanCode}"
                                                 SeasonRPH="{@SeasonRPH}">
                                    </NightlyRate>
                                </xsl:for-each>
                            </NightlyRates>
                            <xsl:copy-of select="ota:Rates/ota:Rate/ota:AdditionalCharges"/>
                            <Taxes>
                                <xsl:choose>
                                    <xsl:when test="ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@RatePlanCode='RACK'">
                                        <Tax Amount="{sum($current-group/ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@Amount)}" Code="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@Code}" RatePlanCode="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@RatePlanCode}"/>
                                    </xsl:when>
                                    <xsl:otherwise>
                                        <Tax Amount="{sum($current-group/ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@Amount)}" ApplyOrder="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@ApplyOrder}" Code="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@Code}"
                                             PayableLocally="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@PayableLocally}" Percent="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@Percent}" Type="{ota:Rates/ota:Rate/ota:Taxes/ota:Tax/@Type}"/>
                                    </xsl:otherwise>
                                </xsl:choose>
                            </Taxes>
                        </Rate>
                    </Rates>
                </RoomRate>
            </xsl:for-each>
        </xsl:copy>  
    </xsl:template>

    <xsl:template match="@*">
        <xsl:attribute name="{name(.)}">
            <xsl:value-of select="."/>
        </xsl:attribute>
    </xsl:template>
</xsl:stylesheet>

The response that I am getting is :



.c9Y6TC { color:#0000ff; } .c194KG { color:#602020; } .cLUY2 { color:#ea8f0f; } .c18YC0 { color:#d00020; } .c5M9S0 { color:#000090; }
Code:
<?xml version="1.0"?>
<soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:Body>
        <OTA_HotelAvailRS xmlns="http://www.opentravel.org/OTA/2003/05">
            <RoomStays>
                <RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="CP" ArtificialAllocation="0" MealPlanCode="6" RoomTypeCode="DLX">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="8346" AmountBeforeTax="8346" AmountBeforeYatraMarkup="7800" BuyingAmount="7800" CashBackAmount="3338.4" CurrencyCode="INR" CashBackType="P-40"/>
                                    <Base AmountAfterTax="8346" AmountBeforeTax="8346" AmountBeforeYatraMarkup="7800" BuyingAmount="7800" CashBackAmount="3338.4" CurrencyCode="INR" CashBackType="P-40"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="2782" AmountBeforeTax="2782" AmountBeforeYatraMarkup="2600" BuyingAmount="2600" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="CP" SeasonRPH="2"/>
                                        <NightlyRate AmountAfterTax="2782" AmountBeforeTax="2782" AmountBeforeYatraMarkup="2600" BuyingAmount="2600" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="CP" SeasonRPH="2"/>
                                        <NightlyRate AmountAfterTax="2782" AmountBeforeTax="2782" AmountBeforeYatraMarkup="2600" BuyingAmount="2600" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="CP" SeasonRPH="2"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                    </ns1:RoomRates>
                </RoomStay>
                <RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="SUT">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="12840" AmountBeforeTax="12840" AmountBeforeYatraMarkup="12000" BuyingAmount="12000" CashBackAmount="1284" CurrencyCode="INR" CashBackType="P-10"/>
                                    <Base AmountAfterTax="12840" AmountBeforeTax="12840" AmountBeforeYatraMarkup="12000" BuyingAmount="12000" CashBackAmount="1284" CurrencyCode="INR" CashBackType="P-10"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="4280" AmountBeforeTax="4280" AmountBeforeYatraMarkup="4000" BuyingAmount="4000" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="4280" AmountBeforeTax="4280" AmountBeforeYatraMarkup="4000" BuyingAmount="4000" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="4280" AmountBeforeTax="4280" AmountBeforeYatraMarkup="4000" BuyingAmount="4000" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                        <RoomRate NumberOfUnits="4" NumberOfGuests="6" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="SDLX">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="16948.8" AmountBeforeTax="16948.8" AmountBeforeYatraMarkup="15840" BuyingAmount="15840" CashBackAmount="1694.88" CurrencyCode="INR" CashBackType="P-10"/>
                                    <Base AmountAfterTax="16948.8" AmountBeforeTax="16948.8" AmountBeforeYatraMarkup="15840" BuyingAmount="15840" CashBackAmount="1694.88" CurrencyCode="INR" CashBackType="P-10"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="5649.6" AmountBeforeTax="5649.6" AmountBeforeYatraMarkup="5280" BuyingAmount="5280" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="5649.6" AmountBeforeTax="5649.6" AmountBeforeYatraMarkup="5280" BuyingAmount="5280" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="5649.6" AmountBeforeTax="5649.6" AmountBeforeYatraMarkup="5280" BuyingAmount="5280" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                    </ns1:RoomRates>
                </RoomStay>
                <RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="RFS">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="19581" AmountBeforeTax="19581" AmountBeforeYatraMarkup="18300" BuyingAmount="18300" CashBackAmount="1958.1" CurrencyCode="INR" CashBackType="P-10"/>
                                    <Base AmountAfterTax="19581" AmountBeforeTax="19581" AmountBeforeYatraMarkup="18300" BuyingAmount="18300" CashBackAmount="1958.1" CurrencyCode="INR" CashBackType="P-10"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="6527" AmountBeforeTax="6527" AmountBeforeYatraMarkup="6100" BuyingAmount="6100" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="6"/>
                                        <NightlyRate AmountAfterTax="6527" AmountBeforeTax="6527" AmountBeforeYatraMarkup="6100" BuyingAmount="6100" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="6"/>
                                        <NightlyRate AmountAfterTax="6527" AmountBeforeTax="6527" AmountBeforeYatraMarkup="6100" BuyingAmount="6100" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="6"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                    </ns1:RoomRates>
                </RoomStay>
            </RoomStays>
        </OTA_HotelAvailRS>
    </soapenv:Body>
</soapenv:Envelope>

What I want is :


.c9Y6TC { color:#0000ff; } .c194KG { color:#602020; } .cLUY2 { color:#ea8f0f; } .c18YC0 { color:#d00020; } .c5M9S0 { color:#000090; }
Code:
<?xml version="1.0"?>
<soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:Body>
        <OTA_HotelAvailRS xmlns="http://www.opentravel.org/OTA/2003/05">
            <RoomStays>
                <RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="CP" ArtificialAllocation="0" MealPlanCode="6" RoomTypeCode="DLX">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="2"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="8346" AmountBeforeTax="8346" AmountBeforeYatraMarkup="7800" BuyingAmount="7800" CashBackAmount="3338.4" CurrencyCode="INR" CashBackType="P-40"/>
                                    <Base AmountAfterTax="8346" AmountBeforeTax="8346" AmountBeforeYatraMarkup="7800" BuyingAmount="7800" CashBackAmount="3338.4" CurrencyCode="INR" CashBackType="P-40"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="2782" AmountBeforeTax="2782" AmountBeforeYatraMarkup="2600" BuyingAmount="2600" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="CP" SeasonRPH="2"/>
                                        <NightlyRate AmountAfterTax="2782" AmountBeforeTax="2782" AmountBeforeYatraMarkup="2600" BuyingAmount="2600" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="CP" SeasonRPH="2"/>
                                        <NightlyRate AmountAfterTax="2782" AmountBeforeTax="2782" AmountBeforeYatraMarkup="2600" BuyingAmount="2600" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="CP" SeasonRPH="2"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                    </ns1:RoomRates>
                </RoomStay>
                <RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="SUT">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="12840" AmountBeforeTax="12840" AmountBeforeYatraMarkup="12000" BuyingAmount="12000" CashBackAmount="1284" CurrencyCode="INR" CashBackType="P-10"/>
                                    <Base AmountAfterTax="12840" AmountBeforeTax="12840" AmountBeforeYatraMarkup="12000" BuyingAmount="12000" CashBackAmount="1284" CurrencyCode="INR" CashBackType="P-10"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="4280" AmountBeforeTax="4280" AmountBeforeYatraMarkup="4000" BuyingAmount="4000" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="4280" AmountBeforeTax="4280" AmountBeforeYatraMarkup="4000" BuyingAmount="4000" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="4280" AmountBeforeTax="4280" AmountBeforeYatraMarkup="4000" BuyingAmount="4000" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="SDLX">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="4"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="16948.8" AmountBeforeTax="16948.8" AmountBeforeYatraMarkup="15840" BuyingAmount="15840" CashBackAmount="1694.88" CurrencyCode="INR" CashBackType="P-10"/>
                                    <Base AmountAfterTax="16948.8" AmountBeforeTax="16948.8" AmountBeforeYatraMarkup="15840" BuyingAmount="15840" CashBackAmount="1694.88" CurrencyCode="INR" CashBackType="P-10"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="5649.6" AmountBeforeTax="5649.6" AmountBeforeYatraMarkup="5280" BuyingAmount="5280" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="5649.6" AmountBeforeTax="5649.6" AmountBeforeYatraMarkup="5280" BuyingAmount="5280" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="4"/>
                                        <NightlyRate AmountAfterTax="5649.6" AmountBeforeTax="5649.6" AmountBeforeYatraMarkup="5280" BuyingAmount="5280" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="4"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                    </ns1:RoomRates>
                </RoomStay>
                <RoomStay SupplierSystem="XHOTEL">
                    <ns1:RoomRates xmlns:ns1="http://www.opentravel.org/OTA/2003/05">
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="RFS">
                            <Rates>
                                <Rate>
                                    <ns1:Markups>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                        <ns1:Markup Amount="7" Code="P" SeasonRPH="6"/>
                                    </ns1:Markups>
                                    <Total AmountAfterTax="19581" AmountBeforeTax="19581" AmountBeforeYatraMarkup="18300" BuyingAmount="18300" CashBackAmount="1958.1" CurrencyCode="INR" CashBackType="P-10"/>
                                    <Base AmountAfterTax="19581" AmountBeforeTax="19581" AmountBeforeYatraMarkup="18300" BuyingAmount="18300" CashBackAmount="1958.1" CurrencyCode="INR" CashBackType="P-10"/>
                                    <NightlyRates>
                                        <NightlyRate AmountAfterTax="6527" AmountBeforeTax="6527" AmountBeforeYatraMarkup="6100" BuyingAmount="6100" TaxAmount="0" CurrencyCode="INR" NightNumber="1" RatePlanCode="EP" SeasonRPH="6"/>
                                        <NightlyRate AmountAfterTax="6527" AmountBeforeTax="6527" AmountBeforeYatraMarkup="6100" BuyingAmount="6100" TaxAmount="0" CurrencyCode="INR" NightNumber="2" RatePlanCode="EP" SeasonRPH="6"/>
                                        <NightlyRate AmountAfterTax="6527" AmountBeforeTax="6527" AmountBeforeYatraMarkup="6100" BuyingAmount="6100" TaxAmount="0" CurrencyCode="INR" NightNumber="3" RatePlanCode="EP" SeasonRPH="6"/>
                                    </NightlyRates>
                                    <ns1:AdditionalCharges>
                                        <ns1:AdditionalCharge RoomAmenityCode="162">
                                            <ns1:Amount AmountAfterTax="0.0" AmountBeforeTax="0.0"/>
                                        </ns1:AdditionalCharge>
                                    </ns1:AdditionalCharges>
                                    <Taxes>
                                        <Tax Amount="0" ApplyOrder="1" Code="TP" PayableLocally="false" Percent="0" Type="1"/>
                                    </Taxes>
                                </Rate>
                            </Rates>
                        </RoomRate>
                        <RoomRate NumberOfUnits="2" NumberOfGuests="3" RoomRPH="1" OnRequest="false" RatePlanCode="EP" ArtificialAllocation="1" MealPlanCode="14" RoomTypeCode="SDLX">
                            
                        </RoomRate>
                    </ns1:RoomRates>
                </RoomStay>
            </RoomStays>
        </OTA_HotelAvailRS>
    </soapenv:Body>
</soapenv:Envelope>


Thanks for your help..
Mary
 
Old April 29th, 2009, 12:05 AM
Authorized User
  
Join Date: Apr 2009
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
Default
I have given all support xmls etc. but being very long , may be they need to be approved by moderator...jus waiting :)
Page 2 of 4 1 2 3 4





Similar Threads
Thread Thread Starter Forum Replies Last Post
looping in XSL itsmaheshp XSLT 3 February 24th, 2009 10:47 AM
The reference node is not a child of this node.XSL XMLUser XSLT 2 February 25th, 2008 05:22 AM
Plz help: looping variable in xsl priyatowin XSLT 1 September 11th, 2006 05:38 AM
Looping Time pupadu Classic ASP Basics 1 March 17th, 2005 07:26 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.