DailyDrillingReport.uispin.html
13.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<ui:group
let:activity="{# SELECT ?activity WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity}}"
let:createdAt="{# SELECT ?createdAt WHERE {?report ep-report:createdAt ?createdAt}}"
let:wbPart="{# SELECT ?wbPart WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-activity:onWellBore ?wbPart}}"
let:wb="{# SELECT ?wb WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-activity:onWellBore ?wbPart . ?wbPart ep-core:temporalPartOf ?wb}}"
let:rig="{# SELECT ?rig WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-activity:onRig/ep-core:temporalPartOf ?rig } }"
let:repType="{# SELECT ?repType WHERE {?report a ?repType . ?repType a ep-report:DailyDrillingReportFinalisationType} }"
let:rigType="{# SELECT ?rigType WHERE { ?rig a ?rigType . ?rigType a ep-fac:FixedOrMoveableRigType} }"
let:wbTightType="{# SELECT ?wbTightType WHERE { ?statusActivityWb a ?wbTightType . ?wbTightType a ep-well:WellBoreTightnessType} }"
let:wbPTType="{# SELECT ?wbPTType WHERE { ?statusActivityWb a ?wbPTType . ?wbPTType a ep-well:WellBoreHphtType} }"
let:firstActivity="{# SELECT ?firstActivity WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-core:hasPart ?firstActivity . ?firstActivity a ep-activity:DrillingActivity . ?firstActivity ep-activity:startedAt ?startedAt} ORDER BY (?startedAt) LIMIT 1}"
let:lastActivity="{# SELECT ?firstActivity WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-core:hasPart ?firstActivity . ?firstActivity a ep-activity:DrillingActivity . ?firstActivity ep-activity:startedAt ?startedAt} ORDER BY DESC(?startedAt) LIMIT 1}"
let:statusActivity="{# SELECT ?statusActivity WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-core:hasPart ?statusActivity . ?statusActivity a ep-activity:DailyDrillingActivityToStatus}}"
let:statusActivityWb="{# SELECT ?statusActivityWb WHERE {?activity a ep-activity:DailyDrillingActivity . ?report ep-report:reportOn ?activity . ?activity ep-core:hasPart ?statusActivity . ?statusActivity a ep-activity:DailyDrillingActivityToStatus . ?statusActivity ep-activity:onWellBore ?statusActivityWb}}" >
<ui:group
let:activityStart="{# SELECT ?activityStart WHERE {?activity ep-activity:startedAt ?activityStart}}"
let:activityEnd="{# SELECT ?activityEnd WHERE {?activity ep-activity:finishedAt ?activityEnd}}"
let:spudDate="{# SELECT ?spudDate WHERE {?wb ep-well:wellBoreSpudAt ?spudDate}}"
let:completeDate="{# SELECT ?completeDate WHERE {?wb ep-well:wellBoreCompletedAt ?completeDate}}"
>
<h1>Summary report Wellbore: {= rhspin:npdName(?wb) }</h1>
<div>Period: {= fn:concat(ep-spin-lib:normalizeDateTime(?activityStart), ' - ', ep-spin-lib:normalizeDateTime(?activityEnd)) } </div>
<div>Report Number: {# SELECT ?repNum WHERE {?report ep-report:dailyDrillingReportNumber ?repNum}} </div>
<hr />
<table>
<tr>
<td class="ddrSummaryLeft">
<rhswp:NameValuePair arg:name="NPD Wellbore Id:" arg:value="{= rhspin:npdId(?wb) }" />
<rhswp:NameValuePair arg:name="Report Status:" arg:value="{= ep-spin-lib:selectDailyDrillingReportFlag(?repType) }" />
<rhswp:NameValuePair arg:name="Creation time:" arg:value="{= ep-spin-lib:normalizeDateTime(?createdAt) }" />
<rhswp:NameValuePair arg:name="Operator:" arg:value="{# SELECT ?operatorName WHERE {?activity ep-activity:drillingOperator ?operator . ?operator ep-core:name ?operatorName }}" />
<rhswp:NameValuePair arg:name="Drilling contractor:" arg:value="{# SELECT ?contractorName WHERE {?activity ep-activity:drillingContractor ?contractor . ?contractor ep-core:name ?contractorName}}" />
<rhswp:NameValuePair arg:name="Rig name:" arg:value="{= rhspin:npdName(?rig) }" />
<rhswp:NameValuePair arg:name="NPD Rig Id:" arg:value="{= rhspin:npdId(?rig) }" />
<rhswp:NameValuePair arg:name="Fixed rig:" arg:value="{= ep-spin-lib:selectFixedOrMoveableRigFlag(?rigType) }" />
<rhswp:NameValuePair arg:name="Elevation RKB-MSL m:" arg:value="{# SELECT ?kellyElevMeas WHERE {?activity ep-activity:onRig ?rigState . ?rigState ep-core:hasPart ?kellyBushing . ?kellyBushing a ep-eqt:KellyBushing . ?kellyBushing ep-eqt:elevationOfKellyBushing ?kellyElev . ?kellyElev ep-core:metre ?kellyElevMeas}}" />
<rhswp:NameValuePair arg:name="Water depth MSL m:" arg:value="{# SELECT ?waterDepthVal WHERE {?activity ep-activity:onRig ?rigState . ?rigState a ep-fac:TemporalPartOfARig . ?rigState ep-core:hasPart ?water . ?water a ep-fac:SurroundingWater . ?water ep-fac:depthOfSurroundingWater ?waterDepth . ?waterDepth ep-core:metre ?waterDepthVal}}" />
<rhswp:NameValuePair arg:name="Tight well:" arg:value="{= ep-spin-lib:selectWellBoreTightnessFlag(?wbTightType) }" />
<rhswp:NameValuePair arg:name="High pressure - High temperature:" arg:value="{= ep-spin-lib:selectWellBoreHphtFlag(?wbPTType) }" />
<rhswp:NameValuePair arg:name="Temperature degC:" arg:value="{# SELECT ?buttHoleTempVal WHERE {?statusActivityWb ep-well:averageBottomHoleTemperature ?buttHoleTemp . ?buttHoleTemp ep-core:celsius ?buttHoleTempVal}}" />
<rhswp:NameValuePair arg:name="Pressure psig:" arg:value="{# SELECT ?buttHolePresVal WHERE {?statusActivityWb ep-well:averageBottomHolePressure ?buttHolePres . ?buttHolePres ep-core:psig ?buttHolePresVal}}" />
<rhswp:NameValuePair arg:name="Spud date:" arg:value="{= IF(bound(?spudDate), spif:dateFormat(?spudDate, 'yyyy-MMM-dd'), ?unbound) }" />
<rhswp:NameValuePair arg:name="Date Well Complete:" arg:value="{= IF(bound(?completeDate), spif:dateFormat(?completeDate, 'yyyy-MMM-dd'), ?unbound) }" />
<rhswp:NameValuePair arg:name="Wellbore type:" arg:value="{# SELECT ?wbTypeName WHERE {?activity a ?wbType . ?wbType a ep-activity:WellBoreDrillingType . ?wbType rdfs:label ?wbTypeName}}" />
</td>
<td class="ddrSummaryRight">
<rhswp:NameValuePair arg:name="Depth at Kick Off mMD:" arg:value="{# SELECT ?koDepthM WHERE {?wb ep-core:hasPart ?koWb . ?koWb a ep-well:WellBoreKickOff . ?koWb ep-well:measuredDepth ?measDepth . ?measDepth ep-core:metre ?koDepthM}}" />
<rhswp:NameValuePair arg:name="Depth at Kick Off mTVD:" arg:value="{# SELECT ?koDepthT WHERE {?wb ep-core:hasPart ?koWb . ?koWb a ep-well:WellBoreKickOff . ?koWb ep-well:trueVerticalDepth ?measDepth . ?measDepth ep-core:metre ?koDepthT}}" />
<rhswp:NameValuePair arg:name="Depth mMD:" arg:value="{# SELECT ?buttHoleMDVal WHERE {?statusActivityWb ep-well:finalBottomHoleMeasuredDepth ?buttHoleMD . ?buttHoleMD ep-core:metre ?buttHoleMDVal}}" />
<rhswp:NameValuePair arg:name="Depth mTVD:" arg:value="{# SELECT ?buttHoleTVDVal WHERE {?statusActivityWb ep-well:finalBottomHoleTrueVerticalDepth ?buttHoleTVD . ?buttHoleTVD ep-core:metre ?buttHoleTVDVal}}" />
<rhswp:NameValuePair arg:name="Dist Drilled m:" arg:value="{# SELECT ?distDrilledVal WHERE {?statusActivity ep-activity:distanceDrilled ?distDrilled . ?distDrilled ep-core:metre ?distDrilledVal}}" />
<rhswp:NameValuePair arg:name="Penetration Rate m/h:" arg:value="{# SELECT ?penRateVal WHERE {?statusActivity ep-activity:finalRateOfDrilling ?penRate . ?penRate ep-core:metre_hour-1 ?penRateVal}}" />
<rhswp:NameValuePair arg:name="Hole Dia in:" arg:value="{# SELECT ?holeDiaVal WHERE {?lowerPartWb ep-core:spatialPartOf ?statusActivityWb . ?lowerPartWb a ep-well:LowerPartOfAWellBore . ?lowerPartWb ep-core:temporalPartOf ?partOfAWellBoreSizeSection . ?partOfAWellBoreSizeSection ep-core:spatialPartOf ?wellBoreSizeSection . ?wellBoreSizeSection a ?wellBoreSizeClass . ?wellBoreSizeClass a ep-well:ClassOfWellBoreSectionBySize . ?wellBoreSizeClass rdfs:label ?holeDiaVal }}" />
<rhswp:NameValuePair arg:name="Plug Back Depth mMD:" arg:value="{# SELECT ?pbDepthVal WHERE {?statusActivityWb ep-well:measuredDepthOfPlugTop ?pbDepth . ?pbDepth ep-core:metre ?pbDepthVal}}" />
<rhswp:NameValuePair arg:name="Pressure Test Type:" arg:value="{# SELECT ?pTestActTypeText WHERE {?statusActivity ep-core:hasPart ?pTestAct . ?pTestAct a ?pTestActType . ?pTestActType rdfs:subClassOf ep-activity:WellBorePressureTest . ?pTestActType rdfs:label ?pTestActTypeText}}" />
<rhswp:NameValuePair arg:name="Formation Strength g/cm3:" arg:value="{# SELECT ?rockFormStrengthVal WHERE {?statusActivityWb ep-core:hasPart ?rockFormation . ?rockFormation a ep-well:SurroundingRockFormation . ?rockFormation ep-well:strengthOfRockFormation ?rockFormStrength . ?rockFormStrength ep-core:gram_cm-3 ?rockFormStrengthVal}}" />
<rhswp:NameValuePair arg:name="Depth At Formation Strength mMD:" arg:value="{# SELECT ?rockFormDepthMmdVal WHERE {?statusActivityWb ep-core:hasPart ?rockFormation . ?rockFormation a ep-well:SurroundingRockFormation . ?rockFormation ep-well:measuredDepth ?rockFormDepthMmd . ?rockFormDepthMmd ep-core:metre ?rockFormDepthMmdVal}}" />
<rhswp:NameValuePair arg:name="Depth At Formation Strength mTVD:" arg:value="{# SELECT ?rockFormDepthTvdVal WHERE {?statusActivityWb ep-core:hasPart ?rockFormation . ?rockFormation a ep-well:SurroundingRockFormation . ?rockFormation ep-well:trueVerticalDepth ?rockFormDepthTvd . ?rockFormDepthTvd ep-core:metre ?rockFormDepthTvdVal}}" />
<rhswp:NameValuePair arg:name="Depth At Last Casing mMD:" arg:value="{# SELECT ?lastCasingDepthMmdVal WHERE {?statusActivityWb ep-core:hasPart ?lastCasing . ?lastCasing a ep-eqt:LastCasingOfAWellBore . ?lastCasing ep-core:temporalPartOf ?casing . ?casing ep-well:measuredDepthToTheBottomOfAPartOfAWellBore ?lastCasingDepthMmd . ?lastCasingDepthMmd ep-core:metre ?lastCasingDepthMmdVal}}" />
<rhswp:NameValuePair arg:name="Depth At Last Casing MTVD:" arg:value="{# SELECT ?lastCasingDepthTvdVal WHERE {?statusActivityWb ep-core:hasPart ?lastCasing . ?lastCasing a ep-eqt:LastCasingOfAWellBore . ?lastCasing ep-core:temporalPartOf ?casing . ?casing ep-well:trueVerticalDepthToTheBottomOfAPartOfAWellBore ?lastCasingDepthTvd . ?lastCasingDepthTvd ep-core:metre ?lastCasingDepthTvdVal}}" />
<rhswp:NameValuePair arg:name="Dia Last Casing In:" arg:value="{# SELECT ?lastCasingDiaVal WHERE {?statusActivityWb ep-core:hasPart ?lastCasing . ?lastCasing a ep-eqt:LastCasingOfAWellBore . ?lastCasing ep-core:temporalPartOf ?casing . ?casing a ?pipeOutsideDiameterAPI_5CTClass . ?pipeOutsideDiameterAPI_5CTClass a ep-eqt:PipeOutsideDiameterAPI_5CTClass . ?pipeOutsideDiameterAPI_5CTClass rdfs:label ?lastCasingDiaVal}}" />
</td>
</tr></table>
<hr />
<h2>Summary of Activity (24 Hours)</h2>
<p>{# SELECT ?summaryText WHERE {?statusActivity ep-activity:descriptionOfActivitiesWithinTheDailyReportingPeriod ?summaryText}}</p>
<hr />
<h2>Summary of Planned Activity (Next 24 Hours)</h2>
<p>{# SELECT ?plannedText WHERE {?statusActivity ep-activity:descriptionOfActivitiesForecastForTheNextDailyReportingPeriod ?plannedText}}</p>
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:Operations" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:EquipmentFailure" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:BitRecord" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:CasingLinerTubingInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:CementInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:CementFluidInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:DrillingFluidInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:PorePressure" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:SurveyStation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:LogInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:CoreInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:WellTestInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:FormationTest" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:StratigraphicInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:LithologyInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:WellControlIncident" />
<ui:forEach ui:resultSet="{# SELECT DISTINCT ?startedAt ?comment WHERE {?report ep-report:reportOn ?reportOn . ?reportOn ep-core:hasPart ?wci . ?wci a ?wciClass . ?wciClass rdfs:subClassOf ep-activity:WellControlIncident . OPTIONAL { ?wci ep-activity:startedAt ?startedAt . } . ?wci ep-core:description ?comment . } ORDER BY (?startedAt) }" >
<p>{= ?comment }</p>
</ui:forEach>
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:PerforationInformation" />
<ddrswp:Table arg:report="{= ?report }" arg:template="ddr-tables:GasReadingInformation" />
</ui:group>
</ui:group>