Databases
StackOverflow2013
Postsdbo
POArranging search results inside page via jquery in a search comparison
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POArranging search results inside page via jquery in a search comparison
    text
    copied!<p>I am making a booking comparison engine, and I have a very sensitive problem. </p> <p>The deal is that I have 3-4 different sources to compare results. And each data provider has it's own API, and in each search method you have another pagination, so you can send them request:</p> <ul> <li>pageSize</li> <li>pageNumber</li> <li>search params</li> </ul> <p>and you get basically back:</p> <ul> <li>search Results</li> <li>resultQuantity </li> <li>the number of objects returned with that given search params</li> </ul> <p>So I populate them via JQuery. Actually an Ajax GET request is sent to my </p> <blockquote> <p>www.mysite.com/search_script.php</p> </blockquote> <p>And the results are populated.</p> <p>Lets say we have:</p> <ol> <li>Source1.com/api.php</li> <li>Source2.com/api.php</li> </ol> <p>and on our website we need to arrange a good pagination. Saying good I mean made professionally, so that we don't load too much the browser, and the server also with too much API queries. </p> <p>I have thought that I could make it in this way: </p> <p>If in my site I have pagination of 10 results per page, then I would query both sources with requests to send back 5 results per page.</p> <p>But I would then face 2 types of problems:</p> <ul> <li><p>1st page returns 5 of 23 2nd only 4<br> 5+4,5+0,5+0......</p></li> <li><p>Both have more than 5, but one ends before than second one let's say 12 and 5 5-5,5-0,5/0</p></li> <li><p>...</p></li> </ul> <p>Not a good solution... </p> <p>What is a workout for such situation????</p> <p>1st is soap call </p> <pre><code> SOAP 1.2 The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values. POST /partnerV3/Webservice.asmx HTTP/1.1 Host: webservices.interhome.com Content-Type: application/soap+xml; charset=utf-8 Content-Length: length &lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"&gt; &lt;soap12:Header&gt; &lt;ServiceAuthHeader xmlns="http://www.interhome.com/webservice"&gt; &lt;Username&gt;string&lt;/Username&gt; &lt;Password&gt;string&lt;/Password&gt; &lt;/ServiceAuthHeader&gt; &lt;/soap12:Header&gt; &lt;soap12:Body&gt; &lt;Search xmlns="http://www.interhome.com/webservice"&gt; &lt;inputValue&gt; &lt;Page&gt;int&lt;/Page&gt; &lt;PageSize&gt;int&lt;/PageSize&gt; &lt;OrderDirection&gt;NotSet or Ascending or Descending&lt;/OrderDirection&gt; &lt;OrderBy&gt;NotSet or Favorite or Price or Place&lt;/OrderBy&gt; &lt;LanguageCode&gt;string&lt;/LanguageCode&gt; &lt;CurrencyCode&gt;string&lt;/CurrencyCode&gt; &lt;SalesOfficeCode&gt;string&lt;/SalesOfficeCode&gt; &lt;Quicksearch&gt;string&lt;/Quicksearch&gt; &lt;CountryCode&gt;string&lt;/CountryCode&gt; &lt;RegionCode&gt;string&lt;/RegionCode&gt; &lt;PlaceCode&gt;string&lt;/PlaceCode&gt; &lt;CheckIn&gt;string&lt;/CheckIn&gt; &lt;Duration&gt;int&lt;/Duration&gt; &lt;ThemeFilter&gt;NotSet or Cheepcheep or Countryside or Familyfriendly or HolidayVillage or LakesAndMountains or Nightlife or Selection or SomewhereQuiet or SummerHoliday or Cities or SuitableForSeniors&lt;/ThemeFilter&gt; &lt;HouseApartmentType&gt;NotSet or Apartment or DetachedHouse or House&lt;/HouseApartmentType&gt; &lt;Facilities&gt; &lt;Facilities&gt;NotSet or Aircondition or Balcony or BBQ or Cot or Dishwasher or Fireplace or Internet or InternetWiFi or Jacuzzi or LuxuriousFurnishings or ModernFurnishings or NiceKitchen or NiceSourroundings or Parking or LiftsInhouse or NonSmoker or Pets1 or Pets2 or Pets3 or PetsNo or PoolAll or PoolChildren or PoolIndoor or PoolPrivate or Sauna or Swimmingpool or TV or WashingMachine or Wheelchair&lt;/Facilities&gt; &lt;Facilities&gt;NotSet or Aircondition or Balcony or BBQ or Cot or Dishwasher or Fireplace or Internet or InternetWiFi or Jacuzzi or LuxuriousFurnishings or ModernFurnishings or NiceKitchen or NiceSourroundings or Parking or LiftsInhouse or NonSmoker or Pets1 or Pets2 or Pets3 or PetsNo or PoolAll or PoolChildren or PoolIndoor or PoolPrivate or Sauna or Swimmingpool or TV or WashingMachine or Wheelchair&lt;/Facilities&gt; &lt;/Facilities&gt; &lt;Accessibilities&gt; &lt;Accessibilities&gt;NotSet or FamilyFrienldy or LiftsInhouse or NonSmoking or PetsWelcome or PetsNotAllowed or SuitableForSeniors or WheelchairAccessible&lt;/Accessibilities&gt; &lt;Accessibilities&gt;NotSet or FamilyFrienldy or LiftsInhouse or NonSmoking or PetsWelcome or PetsNotAllowed or SuitableForSeniors or WheelchairAccessible&lt;/Accessibilities&gt; &lt;/Accessibilities&gt; &lt;Activities&gt; &lt;Activities&gt;NotSet or Biking or CrossCountrySkiing or Golfing or Hiking or MountainBiking or Nightlife or NordicWalking or Riding or Sailing or Skiing or Snowboarding or Surfing or Tennis or ThemeParkNearby or Toboggan or Windsurfing or SkiingSnowboarding&lt;/Activities&gt; &lt;Activities&gt;NotSet or Biking or CrossCountrySkiing or Golfing or Hiking or MountainBiking or Nightlife or NordicWalking or Riding or Sailing or Skiing or Snowboarding or Surfing or Tennis or ThemeParkNearby or Toboggan or Windsurfing or SkiingSnowboarding&lt;/Activities&gt; &lt;/Activities&gt; &lt;Situations&gt; &lt;Situations&gt;NotSet or ByTheSea or InAHistoricTown or InAMajorCity or InTheCountryside or InALakesideTown or SomewhereQuiet or OnAIsland or Center100 or Center500 or Center1000 or Golf200 or Golf500 or Golf5000 or Lake50 or Lake1000 or Lake10000 or Sea50 or Sea1000 or Sea10000 or Skilift50 or Skilift500 or Skilift10000 or CountryView or LakeView or MountainView or SeaView&lt;/Situations&gt; &lt;Situations&gt;NotSet or ByTheSea or InAHistoricTown or InAMajorCity or InTheCountryside or InALakesideTown or SomewhereQuiet or OnAIsland or Center100 or Center500 or Center1000 or Golf200 or Golf500 or Golf5000 or Lake50 or Lake1000 or Lake10000 or Sea50 or Sea1000 or Sea10000 or Skilift50 or Skilift500 or Skilift10000 or CountryView or LakeView or MountainView or SeaView&lt;/Situations&gt; &lt;/Situations&gt; &lt;PropertyTypes&gt; &lt;PropertyTypes&gt;NotSet or Apartment or Bungalow or CastleManor or Chalet or DetachedHouse or Farmhouse or HistoricProperty or HolidayVillage or SpecialProperty or Villa&lt;/PropertyTypes&gt; &lt;PropertyTypes&gt;NotSet or Apartment or Bungalow or CastleManor or Chalet or DetachedHouse or Farmhouse or HistoricProperty or HolidayVillage or SpecialProperty or Villa&lt;/PropertyTypes&gt; &lt;/PropertyTypes&gt; &lt;SpecialOffer&gt;NotSet or AnySpecialOffer or EarlyBooker or LastMinute&lt;/SpecialOffer&gt; &lt;PaxMin&gt;int&lt;/PaxMin&gt; &lt;PaxMax&gt;int&lt;/PaxMax&gt; &lt;RoomsMin&gt;int&lt;/RoomsMin&gt; &lt;RoomsMax&gt;int&lt;/RoomsMax&gt; &lt;BedroomsMin&gt;int&lt;/BedroomsMin&gt; &lt;BedroomsMax&gt;int&lt;/BedroomsMax&gt; &lt;BathroomsMin&gt;int&lt;/BathroomsMin&gt; &lt;BathroomsMax&gt;int&lt;/BathroomsMax&gt; &lt;QualityMin&gt;int&lt;/QualityMin&gt; &lt;QualityMax&gt;int&lt;/QualityMax&gt; &lt;DistanceToCenter&gt;int&lt;/DistanceToCenter&gt; &lt;DistanceToGolfCourse&gt;int&lt;/DistanceToGolfCourse&gt; &lt;DistanceToLake&gt;int&lt;/DistanceToLake&gt; &lt;DistanceToSea&gt;int&lt;/DistanceToSea&gt; &lt;DistanceToSeaOrLake&gt;int&lt;/DistanceToSeaOrLake&gt; &lt;DistanceToSkiLifts&gt;int&lt;/DistanceToSkiLifts&gt; &lt;/inputValue&gt; &lt;/Search&gt; &lt;/soap12:Body&gt; &lt;/soap12:Envelope&gt; HTTP/1.1 200 OK Content-Type: application/soap+xml; charset=utf-8 Content-Length: length &lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"&gt; &lt;soap12:Body&gt; &lt;SearchResponse xmlns="http://www.interhome.com/webservice"&gt; &lt;SearchResult&gt; &lt;ResultCount&gt;int&lt;/ResultCount&gt; &lt;Items&gt; &lt;SearchResultItem&gt; &lt;AccommodationCode&gt;string&lt;/AccommodationCode&gt; &lt;Country&gt;string&lt;/Country&gt; &lt;CountryCode&gt;string&lt;/CountryCode&gt; &lt;Region&gt;string&lt;/Region&gt; &lt;RegionCode&gt;string&lt;/RegionCode&gt; &lt;Place&gt;string&lt;/Place&gt; &lt;PlaceCode&gt;string&lt;/PlaceCode&gt; &lt;Zip&gt;string&lt;/Zip&gt; &lt;CurrencyCode&gt;string&lt;/CurrencyCode&gt; &lt;Price&gt;decimal&lt;/Price&gt; &lt;Quality&gt;int&lt;/Quality&gt; &lt;Type&gt;string&lt;/Type&gt; &lt;Pax&gt;int&lt;/Pax&gt; &lt;Rooms&gt;int&lt;/Rooms&gt; &lt;BedRooms&gt;int&lt;/BedRooms&gt; &lt;Pets&gt;int&lt;/Pets&gt; &lt;Cots&gt;int&lt;/Cots&gt; &lt;AdditionBeds&gt;int&lt;/AdditionBeds&gt; &lt;Parking&gt;boolean&lt;/Parking&gt; &lt;TV&gt;boolean&lt;/TV&gt; &lt;Dishwasher&gt;boolean&lt;/Dishwasher&gt; &lt;Washingmachine&gt;boolean&lt;/Washingmachine&gt; &lt;Aircondition&gt;boolean&lt;/Aircondition&gt; &lt;Pool&gt;boolean&lt;/Pool&gt; &lt;Tennis&gt;boolean&lt;/Tennis&gt; &lt;Sauna&gt;boolean&lt;/Sauna&gt; &lt;Wheelchair&gt;boolean&lt;/Wheelchair&gt; &lt;GeoLng&gt;decimal&lt;/GeoLng&gt; &lt;GeoLat&gt;decimal&lt;/GeoLat&gt; &lt;InsideDescription&gt;string&lt;/InsideDescription&gt; &lt;Picture&gt;string&lt;/Picture&gt; &lt;/SearchResultItem&gt; &lt;SearchResultItem&gt; &lt;AccommodationCode&gt;string&lt;/AccommodationCode&gt; &lt;Country&gt;string&lt;/Country&gt; &lt;CountryCode&gt;string&lt;/CountryCode&gt; &lt;Region&gt;string&lt;/Region&gt; &lt;RegionCode&gt;string&lt;/RegionCode&gt; &lt;Place&gt;string&lt;/Place&gt; &lt;PlaceCode&gt;string&lt;/PlaceCode&gt; &lt;Zip&gt;string&lt;/Zip&gt; &lt;CurrencyCode&gt;string&lt;/CurrencyCode&gt; &lt;Price&gt;decimal&lt;/Price&gt; &lt;Quality&gt;int&lt;/Quality&gt; &lt;Type&gt;string&lt;/Type&gt; &lt;Pax&gt;int&lt;/Pax&gt; &lt;Rooms&gt;int&lt;/Rooms&gt; &lt;BedRooms&gt;int&lt;/BedRooms&gt; &lt;Pets&gt;int&lt;/Pets&gt; &lt;Cots&gt;int&lt;/Cots&gt; &lt;AdditionBeds&gt;int&lt;/AdditionBeds&gt; &lt;Parking&gt;boolean&lt;/Parking&gt; &lt;TV&gt;boolean&lt;/TV&gt; &lt;Dishwasher&gt;boolean&lt;/Dishwasher&gt; &lt;Washingmachine&gt;boolean&lt;/Washingmachine&gt; &lt;Aircondition&gt;boolean&lt;/Aircondition&gt; &lt;Pool&gt;boolean&lt;/Pool&gt; &lt;Tennis&gt;boolean&lt;/Tennis&gt; &lt;Sauna&gt;boolean&lt;/Sauna&gt; &lt;Wheelchair&gt;boolean&lt;/Wheelchair&gt; &lt;GeoLng&gt;decimal&lt;/GeoLng&gt; &lt;GeoLat&gt;decimal&lt;/GeoLat&gt; &lt;InsideDescription&gt;string&lt;/InsideDescription&gt; &lt;Picture&gt;string&lt;/Picture&gt; &lt;/SearchResultItem&gt; &lt;/Items&gt; &lt;/SearchResult&gt; &lt;/SearchResponse&gt; &lt;/soap12:Body&gt; &lt;/soap12:Envelope&gt; </code></pre> <p>and the second is the same ....</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload