Startseite Erkunden Hilfe
Anmelden
eric
/
Eric-ontology
1
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Branch: main
Branches Tags
Eric-ontology
/
queries
/
supplier-product-quotes.rq

supplier-product-quotes.rq 2.4 KB
Permalink Verlauf Originalformat

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 
  1. PREFIX gesli: <https://gesli.example/ontology#>
    2. 

  2. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
    3. 

  3. 

  4. SELECT ?brandName ?productName ?transportMode ?transportSubMode
    5. 

  5.        ?serviceForm ?routeType ?originLocation ?destinationLocation ?transitPortName
    6. 

  6.        ?supplierName ?platformSupplierType ?offeringCode ?offeringChannel ?agencyLevel
    7. 

  7.        ?capacityCommitment ?bookingSuccessRate ?spaceReleaseSuccessRate
    8. 

  8.        ?quoteNo ?supplierCostAmount ?currency ?validFrom ?validTo
    9. 

  9.        ?scheduleCode ?documentCutoffTime ?estimatedDepartureTime ?estimatedArrivalTime
    10. 

  10. WHERE {
    11. 

  11.   ?quote a gesli:SupplierQuote ;
    12. 

  12.          gesli:quoteNo ?quoteNo ;
    13. 

  13.          gesli:quotedForOffering ?offering ;
    14. 

  14.          gesli:supplierCostAmount ?supplierCostAmount ;
    15. 

  15.          gesli:currency ?currency .
    16. 

  16. 

  17.   ?offering a gesli:SupplierProductOffering ;
    18. 

  18.             gesli:offeringCode ?offeringCode ;
    19. 

  19.             gesli:offeredBySupplier ?supplier ;
    20. 

  20.             gesli:offeringProduct ?product .
    21. 

  21. 

  22.   ?supplier rdfs:label ?supplierName .
    23. 

  23.   ?product gesli:productName ?productName ;
    24. 

  24.            gesli:transportMode ?transportMode ;
    25. 

  25.            gesli:transportSubMode ?transportSubMode ;
    26. 

  26.            gesli:serviceForm ?serviceForm ;
    27. 

  27.            gesli:routeType ?routeType ;
    28. 

  28.            gesli:originLocation ?originLocation ;
    29. 

  29.            gesli:destinationLocation ?destinationLocation .
    30. 

  30. 

  31.   OPTIONAL {
    32. 

  32.     ?product gesli:hasServiceBrand ?brand .
    33. 

  33.     ?brand gesli:brandName ?brandName .
    34. 

  34.   }
    35. 

  35.   OPTIONAL { ?supplier gesli:platformSupplierType ?platformSupplierType . }
    36. 

  36.   OPTIONAL { ?offering gesli:offeringChannel ?offeringChannel . }
    37. 

  37.   OPTIONAL { ?offering gesli:agencyLevel ?agencyLevel . }
    38. 

  38.   OPTIONAL { ?offering gesli:capacityCommitment ?capacityCommitment . }
    39. 

  39.   OPTIONAL { ?offering gesli:bookingSuccessRate ?bookingSuccessRate . }
    40. 

  40.   OPTIONAL { ?offering gesli:spaceReleaseSuccessRate ?spaceReleaseSuccessRate . }
    41. 

  41.   OPTIONAL { ?product gesli:transitPortName ?transitPortName . }
    42. 

  42.   OPTIONAL { ?quote gesli:validFrom ?validFrom . }
    43. 

  43.   OPTIONAL { ?quote gesli:validTo ?validTo . }
    44. 

  44.   OPTIONAL {
    45. 

  45.     ?quote gesli:quoteAppliesToSchedule ?schedule .
    46. 

  46.     ?schedule gesli:scheduleCode ?scheduleCode .
    47. 

  47.     OPTIONAL { ?schedule gesli:documentCutoffTime ?documentCutoffTime . }
    48. 

  48.     OPTIONAL { ?schedule gesli:estimatedDepartureTime ?estimatedDepartureTime . }
    49. 

  49.     OPTIONAL { ?schedule gesli:estimatedArrivalTime ?estimatedArrivalTime . }
    50. 

  50.   }
    51. 

  51. }
    52. 

  52. ORDER BY ?productName ?supplierName ?quoteNo
    53.