Home Explore Help
Sign In
eric
/
Eric-ontology
1
0
Fork 0
Files 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 History Raw

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.