|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
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: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: |
---CFC---
<cffunction name="getProduction2" access="remote" returntype="any">
<cfargument name="page" required="yes">
<cfargument name="pageSize" required="yes">
<cfargument name="gridsortcolumn" required="no">
<cfargument name="gridsortdirection" required="no">
<!--- Include/Exclude Arguments --->
<cfargument name="companyIncl" type="string" required="false" default="false">
<cfargument name="countryIncl" type="string" required="false" default="false">
<cfargument name="regionIncl" type="string" required="false" default="false">
<cfargument name="basinIncl" type="string" required="false" default="false">
<cfargument name="fieldIncl" type="string" required="false" default="false">
<cfargument name="waterCatIncl" type="string" required="false" default="false">
<cfargument name="waterDepthIncl" type="string" required="false" default="false">
<cfargument name="APICatIncl" type="string" required="false" default="false">
<cfargument name="APIGravityIncl" type="string" required="false" default="false">
<cfargument name="maturityIncl" type="string" required="false" default="false">
<cfargument name="statusIncl" type="string" required="false" default="false">
<cfargument name="sourceRockIncl" type="string" required="false" default="false">
<cfargument name="productionSystemIncl" type="string" required="false" default="false">
<cfargument name="gasQualityIncl" type="string" required="false" default="false">
<cfargument name="harshConditionIncl" type="string" required="false" default="false">
<cfargument name="processingIncl" type="string" required="false" default="false">
<cfargument name="recoveryCatIncl" type="string" required="false" default="false">
<cfargument name="operatedIncl" type="string" required="false" default="false">
<cfargument name="OECDCatIncl" type="string" required="false" default="false">
<cfargument name="EquityIncl" type="string" required="false" default="false">
<!--- Selector Arguments --->
<cfargument name="ProductionTypeSelector" type="string" required="false" default="">
<cfargument name="ProductionVolumeSelector" type="string" required="false" default="">
<cfargument name="ProductionUnitSelector" type="string" required="false" default="">
<cfargument name="PriceCaseSelector" type="string" required="false" default="">
<cfargument name="Country1" type="string" required="false" default="">
<cfargument name="Region1" type="string" required="false" default="">
<cfargument name="Basin1" type="string" required="false" default="">
<cfargument name="Field1" type="string" required="false" default="">
<cfargument name="waterCatSelector" type="string" required="false" default="">
<cfargument name="waterDepthLow" type="string" required="false" default="">
<cfargument name="waterDepthHigh" type="string" required="false" default="">
<cfargument name="APICatSelector" type="string" required="false" default="">
<cfargument name="APIGravityLow" type="string" required="false" default="">
<cfargument name="APIGravityHigh" type="string" required="false" default="">
<cfargument name="ProjectCertaintySelector" type="string" required="false" default="">
<cfargument name="StatusSelector" type="string" required="false" default="">
<cfargument name="SourceRockSelector" type="string" required="false" default="">
<cfargument name="ProductionSystemSelector" type="string" required="false" default="">
<cfargument name="GasQualitySelector" type="string" required="false" default="">
<cfargument name="HarshConditionSelector" type="string" required="false" default="">
<cfargument name="ProcessingSelector" type="string" required="false" default="">
<cfargument name="RecoveryCategorySelector" type="string" required="false" default="">
<cfargument name="OperatedCategorySelector" type="string" required="false" default="">
<cfargument name="OECDCategorySelector" type="string" required="false" default="">
<cfargument name="minYear" type="string" required="false" default="2009">
<cfargument name="maxYear" type="string" required="false" default="2030">
<cfargument name="discountRate" type="string" required="false" default="">
<!--- Company Arguments --->
<cfargument name="Company1" type="string" required="false" default="">
<!---Define Variables--->
<cfset var Production="">
<!---Do Search--->
<cfquery name="Production" datasource="myDB" result="result">
SELECT PriceCase
<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, CompanyID</cfif>
<cfif ARGUMENTS.countryIncl IS "True">, Country</cfif>
<cfif ARGUMENTS.regionIncl IS "True">, Region</cfif>
<cfif ARGUMENTS.basinIncl IS "True">, Basin</cfif>
<cfif ARGUMENTS.fieldIncl IS "True"> , Field, FieldID</cfif>
<cfif ARGUMENTS.waterCatIncl IS "True">, WaterCat, WaterCatSortOrder</cfif>
<cfif ARGUMENTS.waterDepthIncl IS "True">, FieldWaterDepthFt</cfif>
<cfif ARGUMENTS.APICatIncl IS "True">, APICat, APICatSortOrder</cfif>
<cfif ARGUMENTS.APIGravityIncl IS "True">, APIGravity</cfif>
<cfif ARGUMENTS.maturityIncl IS "True">, ProjectCertainty, ProjectCertaintySortOrder</cfif>
<cfif ARGUMENTS.statusIncl IS "True">, CurrentStatus</cfif>
<cfif ARGUMENTS.sourceRockIncl IS "True">, SourceRock</cfif>
<cfif ARGUMENTS.productionSystemIncl IS "True">, ProductionSystem</cfif>
<cfif ARGUMENTS.gasQualityIncl IS "True">, GasQuality</cfif>
<cfif ARGUMENTS.harshConditionIncl IS "True">, HarshCondition</cfif>
<cfif ARGUMENTS.processingIncl IS "True">, Processing</cfif>
<cfif ARGUMENTS.recoveryCatIncl IS "True">, RecoveryCategory</cfif>
<cfif ARGUMENTS.operatedIncl IS "True">, Operated</cfif>
<cfif ARGUMENTS.OECDCatIncl IS "True">, OECDCat</cfif>
, Coalesce(Round(([1995]),4),0) AS y1995
, Coalesce(Round(([1996]),4),0) AS y1996
, Coalesce(Round(([1997]),4),0) AS y1997
, Coalesce(Round(([1998]),4),0) AS y1998
, Coalesce(Round(([1999]),4),0) AS y1999
, Coalesce(Round(([2000]),4),0) AS y2000
, Coalesce(Round(([2001]),4),0) AS y2001
, Coalesce(Round(([2002]),4),0) AS y2002
, Coalesce(Round(([2003]),4),0) AS y2003
, Coalesce(Round(([2004]),4),0) AS y2004
, Coalesce(Round(([2005]),4),0) AS y2005
, Coalesce(Round(([2006]),4),0) AS y2006
, Coalesce(Round(([2007]),4),0) AS y2007
, Coalesce(Round(([2008]),4),0) AS y2008
, Coalesce(Round(([2009]),4),0) AS y2009
, Coalesce(Round(([2010]),4),0) AS y2010
, Coalesce(Round(([2011]),4),0) AS y2011
, Coalesce(Round(([2012]),4),0) AS y2012
, Coalesce(Round(([2013]),4),0) AS y2013
, Coalesce(Round(([2014]),4),0) AS y2014
, Coalesce(Round(([2015]),4),0) AS y2015
, Coalesce(Round(([2016]),4),0) AS y2016
, Coalesce(Round(([2017]),4),0) AS y2017
, Coalesce(Round(([2018]),4),0) AS y2018
, Coalesce(Round(([2019]),4),0) AS y2019
, Coalesce(Round(([2020]),4),0) AS y2020
, Coalesce(Round(([2021]),4),0) AS y2021
, Coalesce(Round(([2022]),4),0) AS y2022
, Coalesce(Round(([2023]),4),0) AS y2023
, Coalesce(Round(([2024]),4),0) AS y2024
, Coalesce(Round(([2025]),4),0) AS y2025
, Coalesce(Round(([2026]),4),0) AS y2026
, Coalesce(Round(([2027]),4),0) AS y2027
, Coalesce(Round(([2028]),4),0) AS y2028
, Coalesce(Round(([2029]),4),0) AS y2029
, Coalesce(Round(([2030]),4),0) AS y2030
FROM
(SELECT FieldModelResult.PriceCase
, FieldModelResult.MYear
<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, AdjustedWI.Company, AdjustedWI.CompanyID</cfif>
<cfif ARGUMENTS.countryIncl IS "True">, Country.Country</cfif>
<cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
<cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
<cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
<cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
<cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
<cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
<cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
<cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
<cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status AS CurrentStatus</cfif>
<cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
<cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
<cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
<cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
<cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
<cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
<cfif ARGUMENTS.operatedIncl IS "True">, CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END AS Operated</cfif>
<cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>
, <cfif ARGUMENTS.ProductionTypeSelector IS "Net Boe">ROUND(COALESCE(SUM(FieldModelResult.NetBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif>* AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Gas">ROUND(COALESCE(SUM(FieldModelResult.NetGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Oil">ROUND(COALESCE(SUM(FieldModelResult.NetOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Boe">ROUND(COALESCE(SUM(FieldModelResult.GrossBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Gas">ROUND(COALESCE(SUM(FieldModelResult.GrossGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Oil">ROUND(COALESCE(SUM(FieldModelResult.GrossOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
</cfif>
FROM Field
INNER JOIN FieldModelResult ON Field.FieldID = FieldModelResult.FieldID
INNER JOIN AdjustedWI ON FieldModelResult.FieldID = AdjustedWI.FieldID AND FieldModelResult.MYear = AdjustedWI.MYear
INNER JOIN Country ON Field.CountryID = Country.CountryID
INNER JOIN FieldDetail ON Field.FieldID = FieldDetail.FieldID
WHERE
0=0
<cfif isDefined('Form.Company1')>AND (AdjustedWI.Company IN (<cfqueryparam value="#FORM.Company1#" cfsqltype="cf_sql_varchar" list="yes">))</cfif>
<cfif isDefined('Form.Country1')>AND Country.Country IN (<cfqueryparam value="#FORM.Country1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif isDefined('Form.Region1')>AND FieldDetail.Region IN (<cfqueryparam value="#FORM.Region1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif isDefined('Form.Basin1')>AND FieldDetail.Basin IN (<cfqueryparam value="#FORM.Basin1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif isDefined('Form.Field1')>AND Field.Field IN (<cfqueryparam value="#FORM.Field1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif NOT isDefined('FORM.EquityIncl')>AND AdjustedWI.EquitySource = 1</cfif>
<cfif isDefined('FORM.StatusSelector')>AND FieldModelResult.Status IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.StatusSelector#" list="yes">)</cfif>
AND (FieldModelResult.PriceCase = <cfqueryparam value="#ARGUMENTS.PriceCaseSelector#" cfsqltype="cf_sql_varchar">)
<cfif isDefined('FORM.waterCatSelector')>AND FieldDetail.WaterCatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.waterCatSelector#" list="yes">)</cfif>
<cfif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS NOT ""> AND (FieldDetail.FieldWaterDepthFt BETWEEN <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS ""> AND (FieldDetail.FieldWaterDepthFT >= <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.waterDepthLow IS "" AND ARGUMENTS.waterDepthHigh IS NOT ""> AND (FieldDetail.FieldWaterDepthFt <= <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_integer">)
</cfif>
<cfif isDefined('FORM.APICatSelector')>AND FieldDetail.APICatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.APICatSelector#" list="yes">)</cfif>
<cfif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS NOT ""> AND (FieldDetail.APIGravity BETWEEN <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS ""> AND (FieldDetail.APIGravity >= <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.APIGravityLow IS "" AND ARGUMENTS.APIGravityHigh IS NOT ""> AND (FieldDetail.APIGravity <= <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_integer">)
</cfif>
<cfif isDefined('FORM.ProjectCertaintySelector')>AND FieldDetail.ProjectCertaintyID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProjectCertaintySelector#" list="yes">)</cfif>
<cfif isDefined('FORM.SourceRockSelector')>AND FieldDetail.SourceRockID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.SourceRockSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.ProductionSystemSelector')>AND FieldDetail.ProductionSystemID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProductionSystemSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.GasQualitySelector')>AND FieldDetail.GasQualityID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.GasQualitySelector#" list="yes">)</cfif>
<cfif isDefined('FORM.HarshConditionSelector')>AND FieldDetail.HarshConditionID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.HarshConditionSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.ProcessingSelector')>AND FieldDetail.ProcessingID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProcessingSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.RecoveryCategorySelector')>AND FieldDetail.RecoveryCategoryID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.RecoveryCategorySelector#" list="yes">)</cfif>
<cfif isDefined('FORM.OperatedCategorySelector')>
<cfif listLen(FORM.OperatedCategorySelector) EQ 3>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) LIKE '%')
</cfif>
<cfif listLen(FORM.OperatedCategorySelector) EQ 2>
<cfif listContainsNoCase(FORM.OperatedCategorySelector,1) AND listContainsNoCase(FORM.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,1) AND listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Unknown')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,2) AND listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Non-Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>
<cfif listLen(FORM.OperatedCategorySelector) EQ 1>
<cfif listContainsNoCase(FORM.OperatedCategorySelector,1)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>
</cfif>
<cfif isDefined('FORM.OECDCategorySelector')>AND FieldDetail.OECDCatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.OECDCategorySelector#" list="yes">)</cfif>
AND (FieldModelResult.MYear BETWEEN <cfqueryparam value="#FORM.minYear#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#FORM.maxYear#" cfsqltype="cf_sql_integer">)
GROUP BY FieldModelResult.PriceCase
, FieldModelResult.MYear
<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, AdjustedWI.CompanyID</cfif>
<cfif ARGUMENTS.countryIncl IS NOT "">, Country.Country</cfif>
<cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
<cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
<cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
<cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
<cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
<cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
<cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
<cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
<cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status</cfif>
<cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
<cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
<cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
<cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
<cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
<cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
<cfif ARGUMENTS.operatedIncl IS "True">, FieldDetail.Operator</cfif>
<cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>) q1
PIVOT
(SUM(ProductionData) FOR q1.MYear IN
([1995],[1996],[1997],[1998],[1999],[2000],[2001],[2002],[2003],[2004],[2005],[2006],[2007],[2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020],[2021],[2022],[2023],[2024],[2025],[2026],[2027],[2028],[2029],[2030])) AS pvt
<cfif gridsortcolumn neq ''>
order by #gridsortcolumn# #gridsortdirection#
</cfif>
</cfquery>
<cfreturn queryconvertforgrid(Production,page,pagesize)/>
</cffunction>
---CFM---
<div style="width:1000px; clear:both;" align="center">
<cfoutput>
<cfform name="tableform">
<cfgrid format="html" name="grid_Tables" pagesize="25" selectmode="row"
bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
<cfif isDefined('Form.Company1') OR isDefined('FORM.companyIncl')><cfgridcolumn name="Company" header="Company"></cfif>
<cfif isDefined('FORM.countryIncl')><cfgridcolumn name="Country" header="Country"></cfif>
<cfif isDefined('FORM.regionIncl')><cfgridcolumn name="Region" header="Region"></cfif>
<cfif isDefined('FORM.basinIncl')><cfgridcolumn name="Basin" header="Basin"></cfif>
<cfif isDefined('FORM.OECDCatIncl')><cfgridcolumn name="OECDCat" header="OECD Category"></cfif>
<cfif isDefined('FORM.fieldIncl')><cfgridcolumn name="Field" header="Field"></cfif>
<cfif isDefined('FORM.operatedIncl')><cfgridcolumn name="Operated" header="Operated Category"></cfif>
<cfif isDefined('FORM.waterCatIncl')><cfgridcolumn name="WaterCat" header="Water Depth Category"></cfif>
<cfif isDefined('FORM.waterDepthIncl')><cfgridcolumn name="FieldWaterDepthFt" header="Water Depth (Ft)"></cfif>
<cfif isDefined('FORM.APICatIncl')><cfgridcolumn name="APICat" header="API Category"></cfif>
<cfif isDefined('FORM.APIGravityIncl')><cfgridcolumn name="APIGravity" header="API Gravity"></cfif>
<cfif isDefined('FORM.maturityIncl')><cfgridcolumn name="ProjectCertainty" header="Project Maturity"></cfif>
<cfif isDefined('FORM.statusIncl')><cfgridcolumn name="CurrentStatus" header="Status"></cfif>
<cfif isDefined('FORM.sourceRockIncl')><cfgridcolumn name="SourceRock" header="Source Rock"></cfif>
<cfif isDefined('FORM.productionSystemIncl')><cfgridcolumn name="ProductionSystem" header="Production System"></cfif>
<cfif isDefined('FORM.gasQualityIncl')><cfgridcolumn name="GasQuality" header="Gas Quality"></cfif>
<cfif isDefined('FORM.harshConditionIncl')><cfgridcolumn name="HarshCondition" header="Harsh Conditions"></cfif>
<cfif isDefined('FORM.processingIncl')><cfgridcolumn name="Processing" header="Processing"></cfif>
<cfif isDefined('FORM.recoveryCatIncl')><cfgridcolumn name="RecoveryCategory" header="Recovery Category"></cfif>
<cfif 1995 GTE #FORM.minYear# AND 1995 LTE #FORM.maxYear#><cfgridcolumn name="y1995" header="1995"></cfif>
<cfif 1996 GTE #FORM.minYear# AND 1996 LTE #FORM.maxYear#><cfgridcolumn name="y1996" header="1996"></cfif>
<cfif 1997 GTE #FORM.minYear# AND 1997 LTE #FORM.maxYear#><cfgridcolumn name="y1997" header="1997"></cfif>
<cfif 1998 GTE #FORM.minYear# AND 1998 LTE #FORM.maxYear#><cfgridcolumn name="y1998" header="1998"></cfif>
<cfif 1999 GTE #FORM.minYear# AND 1999 LTE #FORM.maxYear#><cfgridcolumn name="y1999" header="1999"></cfif>
<cfif 2000 GTE #FORM.minYear# AND 2000 LTE #FORM.maxYear#><cfgridcolumn name="y2000" header="2000"></cfif>
<cfif 2001 GTE #FORM.minYear# AND 2001 LTE #FORM.maxYear#><cfgridcolumn name="y2001" header="2001"></cfif>
<cfif 2002 GTE #FORM.minYear# AND 2002 LTE #FORM.maxYear#><cfgridcolumn name="y2002" header="2002"></cfif>
<cfif 2003 GTE #FORM.minYear# AND 2003 LTE #FORM.maxYear#><cfgridcolumn name="y2003" header="2003"></cfif>
<cfif 2004 GTE #FORM.minYear# AND 2004 LTE #FORM.maxYear#><cfgridcolumn name="y2004" header="2004"></cfif>
<cfif 2005 GTE #FORM.minYear# AND 2005 LTE #FORM.maxYear#><cfgridcolumn name="y2005" header="2005"></cfif>
<cfif 2006 GTE #FORM.minYear# AND 2006 LTE #FORM.maxYear#><cfgridcolumn name="y2006" header="2006"></cfif>
<cfif 2007 GTE #FORM.minYear# AND 2007 LTE #FORM.maxYear#><cfgridcolumn name="y2007" header="2007"></cfif>
<cfif 2008 GTE #FORM.minYear# AND 2008 LTE #FORM.maxYear#><cfgridcolumn name="y2008" header="2008"></cfif>
<cfif 2009 GTE #FORM.minYear# AND 2009 LTE #FORM.maxYear#><cfgridcolumn name="y2009" header="2009"></cfif>
<cfif 2010 GTE #FORM.minYear# AND 2010 LTE #FORM.maxYear#><cfgridcolumn name="y2010" header="2010"></cfif>
<cfif 2011 GTE #FORM.minYear# AND 2011 LTE #FORM.maxYear#><cfgridcolumn name="y2011" header="2011"></cfif>
<cfif 2012 GTE #FORM.minYear# AND 2012 LTE #FORM.maxYear#><cfgridcolumn name="y2012" header="2012"></cfif>
<cfif 2013 GTE #FORM.minYear# AND 2013 LTE #FORM.maxYear#><cfgridcolumn name="y2013" header="2013"></cfif>
<cfif 2014 GTE #FORM.minYear# AND 2014 LTE #FORM.maxYear#><cfgridcolumn name="y2014" header="2014"></cfif>
<cfif 2015 GTE #FORM.minYear# AND 2015 LTE #FORM.maxYear#><cfgridcolumn name="y2015" header="2015"></cfif>
<cfif 2016 GTE #FORM.minYear# AND 2016 LTE #FORM.maxYear#><cfgridcolumn name="y2016" header="2016"></cfif>
<cfif 2017 GTE #FORM.minYear# AND 2017 LTE #FORM.maxYear#><cfgridcolumn name="y2017" header="2017"></cfif>
<cfif 2018 GTE #FORM.minYear# AND 2018 LTE #FORM.maxYear#><cfgridcolumn name="y2018" header="2018"></cfif>
<cfif 2019 GTE #FORM.minYear# AND 2019 LTE #FORM.maxYear#><cfgridcolumn name="y2019" header="2019"></cfif>
<cfif 2020 GTE #FORM.minYear# AND 2020 LTE #FORM.maxYear#><cfgridcolumn name="y2020" header="2020"></cfif>
<cfif 2021 GTE #FORM.minYear# AND 2021 LTE #FORM.maxYear#><cfgridcolumn name="y2021" header="2021"></cfif>
<cfif 2022 GTE #FORM.minYear# AND 2022 LTE #FORM.maxYear#><cfgridcolumn name="y2022" header="2022"></cfif>
<cfif 2023 GTE #FORM.minYear# AND 2023 LTE #FORM.maxYear#><cfgridcolumn name="y2023" header="2023"></cfif>
<cfif 2024 GTE #FORM.minYear# AND 2024 LTE #FORM.maxYear#><cfgridcolumn name="y2024" header="2024"></cfif>
<cfif 2025 GTE #FORM.minYear# AND 2025 LTE #FORM.maxYear#><cfgridcolumn name="y2025" header="2025"></cfif>
<cfif 2026 GTE #FORM.minYear# AND 2026 LTE #FORM.maxYear#><cfgridcolumn name="y2026" header="2026"></cfif>
<cfif 2027 GTE #FORM.minYear# AND 2027 LTE #FORM.maxYear#><cfgridcolumn name="y2027" header="2027"></cfif>
<cfif 2028 GTE #FORM.minYear# AND 2028 LTE #FORM.maxYear#><cfgridcolumn name="y2028" header="2028"></cfif>
<cfif 2029 GTE #FORM.minYear# AND 2029 LTE #FORM.maxYear#><cfgridcolumn name="y2029" header="2029"></cfif>
<cfif 2030 GTE #FORM.minYear# AND 2030 LTE #FORM.maxYear#><cfgridcolumn name="y2030" header="2030"></cfif>
</cfgrid>
</cfform>
</cfoutput>
</div>
|
Advertisement
| Hall of Fame |