{
"id": 171,
"service_id": 35,
"service_destination_id": 2,
"services": {
"id": 35,
"user_id": 1,
"provider_id": 1,
"gallery": [
{
"src": "/service/3.webp"
},
{
"src": "/service/6.webp"
},
{
"src": "/service/5.webp"
},
{
"src": "/service/4.webp"
},
{
"src": "/service/1.webp"
},
{
"src": "/service/2.webp"
}
],
"pricing_policy": "package",
"cost_currency": "GBP",
"sale_currency": "EUR",
"low_old_price": "30.00",
"low_price": "12.00",
"high_price": "30.00",
"code": "757271",
"step": 1,
"instant_booking": false,
"sellability": true,
"status": true,
"fails": "",
"deleted_at": null,
"cover": "/service/3.webp",
"label": "SERVICE-35 en",
"translated_routes": {
"en": {
"serviceSlug": "service-35-en"
},
"tr": {
"serviceSlug": "service-35-tr"
}
},
"title": "SERVICE-35 en",
"slug": "service-35-en",
"content": "SERVICE-35 Content en<div class=\"dynamic-icons dynamic-component-section dynamic-icons dynamic-icons_desktop\">\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_shopping_price_s_iednzu.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Free cancellation - 24 hours notice </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_time_calendar_s_yikoy1.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Fixed date booking </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_other_print_s_s9kha3.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Show mobile or printed voucher </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_time_time_s_dyiyef.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> 6 Hrs Duration </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_travel_earth_s_zf6etl.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> English </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_travel_poi_s_pwcl07.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> Join in group </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_transfer_car_s_m6usgm.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> Hotel pick up </span>\r\n </div>\r\n </div>\r\n <div class=\"klk-markdown\">\r\n <ul>\r\n <li>Enjoy traditional activities such as camel riding and henna tattoos</li>\r\n <li>Experience the thrill of a 4x4 ride on the Evening Desert Safari tour</li>\r\n <li>End the Evening Desert Safari with BBQ dinner while enjoying a Tanoura & belly dancing show and shisha</li>\r\n <li>Get convenient round trip transportation from your hotel</li>\r\n </ul>\r\n </div>\r\n ",
"description": "SERVICE-35 Description en",
"meta_title": "SERVICE-35 META-Title en",
"meta_description": "SERVICE-35 META-Description en",
"translations": [
{
"id": 69,
"title": "SERVICE-35 en",
"slug": "service-35-en",
"description": "SERVICE-35 Description en",
"content": "SERVICE-35 Content en<div class=\"dynamic-icons dynamic-component-section dynamic-icons dynamic-icons_desktop\">\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_shopping_price_s_iednzu.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Free cancellation - 24 hours notice </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_time_calendar_s_yikoy1.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Fixed date booking </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_other_print_s_s9kha3.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Show mobile or printed voucher </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_time_time_s_dyiyef.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> 6 Hrs Duration </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_travel_earth_s_zf6etl.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> English </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_travel_poi_s_pwcl07.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> Join in group </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_transfer_car_s_m6usgm.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> Hotel pick up </span>\r\n </div>\r\n </div>\r\n <div class=\"klk-markdown\">\r\n <ul>\r\n <li>Enjoy traditional activities such as camel riding and henna tattoos</li>\r\n <li>Experience the thrill of a 4x4 ride on the Evening Desert Safari tour</li>\r\n <li>End the Evening Desert Safari with BBQ dinner while enjoying a Tanoura & belly dancing show and shisha</li>\r\n <li>Get convenient round trip transportation from your hotel</li>\r\n </ul>\r\n </div>\r\n ",
"meta_title": "SERVICE-35 META-Title en",
"meta_description": "SERVICE-35 META-Description en",
"locale": "en",
"service_id": 35
},
{
"id": 70,
"title": "SERVICE-35 tr",
"slug": "service-35-tr",
"description": "SERVICE-35 Description tr",
"content": "SERVICE-35 Content tr<div class=\"dynamic-icons dynamic-component-section dynamic-icons dynamic-icons_desktop\">\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_shopping_price_s_iednzu.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Free cancellation - 24 hours notice </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_time_calendar_s_yikoy1.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Fixed date booking </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_other_print_s_s9kha3.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> Show mobile or printed voucher </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img src=\"https://res.klook.com/image/upload/Activity Icon/br_icon_time_time_s_dyiyef.png\" alt=\"activity-icon\" class=\"activity-icon\" />\r\n <span class=\"activity-icons_desc\"> 6 Hrs Duration </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_travel_earth_s_zf6etl.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> English </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_travel_poi_s_pwcl07.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> Join in group </span>\r\n </div>\r\n <div class=\"activity-icons_item\">\r\n <img\r\n src=\"https://res.klook.com/image/upload/v1639383609/Activity%20Icon/br_icon_transfer_car_s_m6usgm.png\"\r\n alt=\"activity-icon\"\r\n class=\"activity-icon\"\r\n />\r\n <span class=\"activity-icons_desc\"> Hotel pick up </span>\r\n </div>\r\n </div>\r\n <div class=\"klk-markdown\">\r\n <ul>\r\n <li>Enjoy traditional activities such as camel riding and henna tattoos</li>\r\n <li>Experience the thrill of a 4x4 ride on the Evening Desert Safari tour</li>\r\n <li>End the Evening Desert Safari with BBQ dinner while enjoying a Tanoura & belly dancing show and shisha</li>\r\n <li>Get convenient round trip transportation from your hotel</li>\r\n </ul>\r\n </div>\r\n ",
"meta_title": "SERVICE-35 META-Title tr",
"meta_description": "SERVICE-35 META-Description tr",
"locale": "tr",
"service_id": 35
}
],
"categories": [
{
"id": 2,
"status": true,
"gallery": [
{
"src": "/assets/demo/cat-banner5.jpeg"
},
{
"src": "/assets/demo/cat-banner2.jpeg"
},
{
"src": "/assets/demo/cat-banner4.jpeg"
},
{
"src": "/assets/demo/cat-banner1.jpeg"
},
{
"src": "/assets/demo/cat-banner3.jpeg"
}
],
"parent_id": 1,
"cover": "/assets/demo/cat-banner5.jpeg",
"title": "Theme & Water Parks",
"slug": "theme-water-parks",
"description": null,
"content": null,
"meta_title": null,
"meta_description": null,
"url": "/attractions-tickets/theme-water-parks",
"pivot": {
"service_id": 35,
"service_category_id": 2
}
},
{
"id": 9,
"status": true,
"gallery": [
{
"src": "/assets/demo/cat-banner1.jpeg"
},
{
"src": "/assets/demo/cat-banner3.jpeg"
},
{
"src": "/assets/demo/cat-banner2.jpeg"
},
{
"src": "/assets/demo/cat-banner4.jpeg"
},
{
"src": "/assets/demo/cat-banner5.jpeg"
}
],
"parent_id": 1,
"cover": "/assets/demo/cat-banner1.jpeg",
"title": "Regular Shows",
"slug": "regular-shows",
"description": null,
"content": null,
"meta_title": null,
"meta_description": null,
"url": "/attractions-tickets/regular-shows",
"pivot": {
"service_id": 35,
"service_category_id": 9
}
},
{
"id": 13,
"status": true,
"gallery": [
{
"src": "/assets/demo/cat-banner5.jpeg"
},
{
"src": "/assets/demo/cat-banner3.jpeg"
},
{
"src": "/assets/demo/cat-banner1.jpeg"
},
{
"src": "/assets/demo/cat-banner4.jpeg"
},
{
"src": "/assets/demo/cat-banner2.jpeg"
}
],
"parent_id": 10,
"cover": "/assets/demo/cat-banner5.jpeg",
"title": "Tours in The Air",
"slug": "tours-in-the-air",
"description": null,
"content": null,
"meta_title": null,
"meta_description": null,
"url": "/tours-must-sees/tours-in-the-air",
"pivot": {
"service_id": 35,
"service_category_id": 13
}
},
{
"id": 16,
"status": true,
"gallery": [
{
"src": "/assets/demo/cat-banner1.jpeg"
},
{
"src": "/assets/demo/cat-banner2.jpeg"
},
{
"src": "/assets/demo/cat-banner3.jpeg"
},
{
"src": "/assets/demo/cat-banner4.jpeg"
},
{
"src": "/assets/demo/cat-banner5.jpeg"
}
],
"parent_id": 10,
"cover": "/assets/demo/cat-banner1.jpeg",
"title": "Multi-day Tours",
"slug": "multi-day-tours",
"description": null,
"content": null,
"meta_title": null,
"meta_description": null,
"url": "/tours-must-sees/multi-day-tours",
"pivot": {
"service_id": 35,
"service_category_id": 16
}
},
{
"id": 17,
"status": true,
"gallery": [
{
"src": "/assets/demo/cat-banner1.jpeg"
},
{
"src": "/assets/demo/cat-banner3.jpeg"
},
{
"src": "/assets/demo/cat-banner2.jpeg"
},
{
"src": "/assets/demo/cat-banner4.jpeg"
},
{
"src": "/assets/demo/cat-banner5.jpeg"
}
],
"parent_id": null,
"cover": "/assets/demo/cat-banner1.jpeg",
"title": "Outdoors & Sports",
"slug": "outdoors-sports",
"description": null,
"content": null,
"meta_title": null,
"meta_description": null,
"url": "/outdoors-sports",
"pivot": {
"service_id": 35,
"service_category_id": 17
}
}
]
}
},
$category = ServiceCategoryTranslation::where('slug',$request->category)->first();
$serviceCategory=ServiceDestinationService::with('services.categories')->where('service_destination_id',$city->id);
merhaba laravel ile bir join işlemi yaptım (services) hatta ikinci tabloya geçtim (categories) ben burda şöyle bir sorgu yapmak istiyorum categories bir dizi çoklu kategori yapısı var yukarda istek olarak $category->id den gelen id categories tablosunda varsa veriyi getirmesini yoksa getirmemesini istiyorum join yaptığım categories de nasıl sorgu yapabilirim? Yukarda Tüm verinin bir tanesini koydum data->services->categories içinde ki veriye göre getir veya getirme olayı