{ "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ı
omeruzer https://laravel.com/docs/9.x/eloquent-relationships#querying-relationship-existence
mgsmus
$serviceCategory=ServiceDestinationService::with('services.categories') ->whereHas('services',function($q) use ($category){ $q->whereHas('categories',function($q2) use ($category){ $q2->where('id',$category->id); }); }) ->where('service_destination_id',$city->id);
bu şekil yaptım ama hata alıyorum yanlış mı yaptım ?
omeruzer merhaba bu yazım şeklinde hata var. whereHas işlemleri iç içe değil peş peşe olmalı servis ile kategorinin ilişkisini göremedim. Bu yüzden peş peşe gelir. Bu işlem ilişkili tablolar için join yaptıysanız whereHas değil normal where kullanmalısınız.
omeruzer Ne hatası alıyorsunuz?
Laravel Türkiye Forumları, ücretsiz forum uygulaması Flarum ile yapılmıştır.