db={"cruises":[{"cruiseID":"00001","title":[{"locale":"en","value":"Alaska Whale Watching Photo Expedition"},{"locale":"pl","value":"Fotografowanie wielorybów na Alasce"}],"description":[{"locale":"en","value":"Photographying the Whale in Alaska is a unique experience. Join us on this tour to this unique area. This cruise is a luxury tour for those who want to see these majestic animals in their natural habitat and want to spend time with people of the same interest. There will be a pro photographer on the cruise to assist anybody who wants to sharpen their photograpging skills."},{"locale":"pl","value":"Fotografowanie wielorybów na Alasce jest unikalnym doświadczeniem. Dołącz do naszej wyprawy w to unikalne miejsce. To luksusowa wycieczka dla tych, którzy chcieliby zobaczyć te majestatyczne zwierzęta w ich naturalnym środowisku i spędzić czas z osobami o podobnych zainteresowaniach. Na statku będzie dostępny profesjonalny fotograf, który będzie służył radą wszytkim pragnącym podnieść swoje umiejętności fotografowania."}],"startDate":20210801,"endDate":20210809,"numDays":8,"startPort":"Juneau, Alaska","roomTypes":[{"roomID":"IPD"},{"roomID":"OPD"},{"roomID":"SDD"},{"roomID":"SD2"},{"roomID":"SJS"},{"roomID":"SDS"}]},{"cruiseID":"00002","title":[{"locale":"en","value":"Panama canal"},{"locale":"pl","value":"Kanał Panamski"}],"description":[{"locale":"en","value":"Cruise from San Diego to Mexico and on to the canal, then up to Miami. The canal is 77.1 Km (48 miles) long and connects the Atlantic Ocean with the Pacific Ocean. This cruise shows a side of the canal that is unique for those that what to see it in luxury."},{"locale":"pl","value":"Podróż z San Diego do Meksyku, przez kanał i potem do Miami. Kanał Panamski ma 77,1 km długości (48 mil) i łączy ocen spokojny z antaltyckim. Ta wycieczka pokazuje kanał w sposób pozwalający na luksusowe spędzanie czasu."}],"startDate":20210701,"endDate":20210715,"numDays":14,"startPort":"San Diego, California","roomTypes":[{"roomID":"IPD"},{"roomID":"OPD"},{"roomID":"SDD"},{"roomID":"SJS"},{"roomID":"SDS"}]}],rooms:[{"roomID":"IPD","roomDetails":{"roomType":"Inside Premier Double","title":[{"locale":"en","value":"Inside Premier Double cabin"},{"locale":"pl","value":"Wewnętrzna podwójna kabina klasy premium"}],"description":[{"locale":"en","value":"An Eco-friendly double room with desk, Tv and Shower"},{"locale":"pl","value":"Pokój dla dwóch osób z biurkiem, TV i prysznicem"}],"maxOccupants":2},"capacity":[{"cruiseID":"00001","total":21,"available":20}]},{"roomID":"OPD","roomDetails":{"roomType":"Seaview Premier Double","title":[{"locale":"en","value":"Premier Double cabin with seaview"},{"locale":"pl","value":"Podwójna kabina klasy premium z widokiem na morze"}],"description":[{"locale":"en","value":"An Eco-friendly double room with seaview, desk, Tv and Shower"},{"locale":"pl","value":"Pokój dla dwóch osób z biurkiem, TV i prysznicem"}],"maxOccupants":2},"capacity":[{"cruiseID":"00002","total":31,"available":29}]},{"roomID":"SDD","roomDetails":{"roomType":"Seaview Deluxe Room","title":[{"locale":"en","value":"Deluxe cabin with seaview"},{"locale":"pl","value":"Kabina deluxe z widokiem na morze"}],"description":[{"locale":"en","value":"For those wanting that extra bit of luxury. The Deluxe cabins come with a private balcony, desk, Tv and Shower"},{"locale":"pl","value":"Dla pragnących odrobiny luksusu. Kabine klasu deluxe z prywatnym balkonem, biurkiem, TV i prysznicem"}],"maxOccupants":2},"capacity":[{"cruiseID":"00001","total":11,"available":9},{"cruiseID":"00002","total":11,"available":7}]},{"roomID":"SD2","roomDetails":{"roomType":"Seaview Double Deluxe Room","title":[{"locale":"en","value":"Deluxe cabin with 2 double beds and a seaview"},{"locale":"pl","value":"Podwójna kabina klasy premium z dwoma podwójnymi łóżkami i widokiem na morze"}],"description":[{"locale":"en","value":"For those wanting that extra bit of luxury. The Double Deluxe cabins come with 2 double beds a private balcony, desk, Tv and Shower"},{"locale":"pl","value":"Dla pragnących odrobiny luksusu. Kabine klasu deluxe z prywatnym balkonem, biurkiem, TV i prysznicem i dwoma podójnymi łóżkami"}],"maxOccupants":4},"capacity":[{"cruiseID":"00001","total":21,"available":20},{"cruiseID":"00002","total":31,"available":30}]},{"roomID":"SJS","roomDetails":{"roomType":"Seaview Junior Suite","title":[{"locale":"en","value":"2 bedroom suite with seaview"},{"locale":"pl","value":"2 pokojowy apartament z widokiem na morze"}],"description":[{"locale":"en","value":"The Junior suite cabins come with 2 bedrooms, a separate sitting area, a private balcony, Tvs in each room and Shower"},{"locale":"pl","value":"Apartament z dwoma sypialniami, odrebną częścia dzienną, prywatnym balkonem, TV w każdym pokoju i pryszniecem"}],"maxOccupants":4},"capacity":[{"cruiseID":"00001","total":32,"available":20},{"cruiseID":"00002","total":34,"available":30}]},{"roomID":"SDS","roomDetails":{"roomType":"Seaview Deluxe Suite","title":[{"locale":"en","value":"3 bedroom suite with seaview"},{"locale":"pl","value":"3 pokojowy apartament z widokiem na morze"}],"description":[{"locale":"en","value":"The Deluxe suite cabins come with 3 bedrooms, a spacious entertaining room, a private balcony with hot tub, Tvs in each room and Bath with Jacuzzi"},{"locale":"pl","value":"Apartament z trzema sypialniami, przestronną, odrebną częścia dzienną, prywatnym balkonem z jacuzzi, TV w każdym pokoju i łazienką z jacuzzi"}],"maxOccupants":6},"capacity":[{"cruiseID":"00001","total":11,"available":10},{"cruiseID":"00002","total":21,"available":14}]}]}

db.cruises.aggregate([{$lookup:{from:"rooms",localField:"roomTypes.roomID",foreignField:"roomID",as:"roomTypes"}},{$addFields:{roomTypes:{$map:{input:"$roomTypes",in:{$mergeObjects:["$$this",{roomDetails:{$mergeObjects:["$$this.roomDetails",{description:{$reduce:{input:"$$this.roomDetails.description",initialValue:"",in:{$cond:[{$eq:["$$this.locale","pl"]},"$$this.value","$$value"]}}},title:{$reduce:{input:"$$this.roomDetails.title",initialValue:"",in:{$cond:[{$eq:["$$this.locale","pl"]},"$$this.value","$$value"]}}}}]},available:{$reduce:{input:"$$this.capacity",initialValue:0,in:{$cond:[{$eq:["$$this.cruiseID","$cruiseID"]},"$$this.available","$$value"]}}}}]}}}}},{"$addFields":{"title":{"$filter":{"input":"$title","cond":{"$eq":["$$this.locale","pl"]}}},"description":{"$filter":{"input":"$description","cond":{"$eq":["$$this.locale","pl"]}}}}},{"$addFields":{"title":{"$arrayElemAt":["$title.value",0]},"description":{"$arrayElemAt":["$description.value",0]}}},{$project:{_id:0,"roomTypes":{_id:0},"roomTypes.capacity":0}}])