84730445da4cdefb2bf91ce7c609c274ad9485dc.svn-base 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542
  1. BemsWebApplication.EnthalpyEnergyConsumption = function (params, viewInfo) {
  2. "use strict";
  3. var BUILDING_DEPTH = 1,
  4. FLOOR_DEPTH = 2,
  5. ZONE_DEPTH = 3;
  6. var CODE = $Code,
  7. FuelType = CODE.FuelType,
  8. FT = CODE.FacilityType,
  9. FC = CODE.FacilityCode,
  10. F = CODE.Formula,
  11. TIT = CODE.TimeIntervalType;
  12. var visiblePopup = ko.observable(false);
  13. var initialized = false,
  14. shouldReload = false,
  15. dataSource;
  16. var pointHistoryGet = new BWA.Chart.PointHistoryGet(BWA.UserInfo.SiteId()),
  17. timeBoxForSearch = BWA.SearchView.createDateTimeBox(),
  18. formulaGet = new BWA.Chart.FormulaGet(BWA.UserInfo.SiteId());
  19. var buildingDataSource = BemsWebApplication.db.createDataSource('CmBuilding', true),
  20. floorDataSource = BemsWebApplication.db.createDataSource('CmFloor'),
  21. zoneDataSource = BemsWebApplication.db.createDataSource('CmZone'),
  22. fuelTypesDataSource = BemsWebApplication.db.createDataSource('BemsFuelType'),
  23. buildings = ko.observableArray(),
  24. timeTypesForSearch = ko.observableArray(),
  25. timeTypeIdForSearch = ko.observable(0),
  26. floorsForSearch = ko.observableArray(),
  27. zonesForSearch = ko.observableArray(),
  28. fuelTypesForSearch = ko.observableArray(),
  29. buildingIdForSearch = ko.observable(),
  30. buildingNameForSearch = ko.observable(),
  31. floorIdForSearch = ko.observable(),
  32. floorNameForSearch = ko.observable(),
  33. zoneIdForSearch = ko.observable(),
  34. zoneNameForSearch = ko.observable(),
  35. fuelTypeIdForSearch = ko.observable(),
  36. deferredForSearch = new $.Deferred();
  37. var deferredForLoadData = new $.Deferred();
  38. var chart = BWA.Chart.Instance('chartEHPA', 'dxChart');
  39. var locationEnableForSearch = ko.observable(false);
  40. var chartDataArray = ko.observableArray();
  41. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  42. // 팝업창뷰 보이기 속성 제어용 변수 선언
  43. var DataGridPopup_Visible = ko.observable(false);
  44. // 그래프 출력 이후 엑셀출력을 위한 팝업창을 위해 임시 저장용 배열 선언
  45. var dataArrayresult = ko.observableArray();
  46. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  47. chartDataArray([
  48. { DateTime: new Date(2014, 11, 16, 0), OutdoorTemperature: -3.4, OutdoorHumidity: 40, Value: 30 },
  49. { DateTime: new Date(2014, 11, 16, 0, 15), OutdoorTemperature: -1.1, OutdoorHumidity: 44, Value: 32 },
  50. { DateTime: new Date(2014, 11, 16, 0, 30), OutdoorTemperature: 3, OutdoorHumidity: 48, Value: 33 },
  51. { DateTime: new Date(2014, 11, 16, 0, 45), OutdoorTemperature: 4, OutdoorHumidity: 55, Value: 34 },
  52. { DateTime: new Date(2014, 11, 16, 1), OutdoorTemperature: 8, OutdoorHumidity: 54, Value: 50 },
  53. { DateTime: new Date(2014, 11, 16, 2), OutdoorTemperature: 10, OutdoorHumidity: 53, Value: 60 },
  54. { DateTime: new Date(2014, 11, 16, 3), OutdoorTemperature: 11, Value: 80 },
  55. { DateTime: new Date(2014, 11, 16, 4), OutdoorTemperature: 12, OutdoorHumidity: 48, Value: 100 },
  56. { DateTime: new Date(2014, 11, 16, 5), OutdoorTemperature: 12, OutdoorHumidity: 40 },
  57. { DateTime: new Date(2014, 11, 16, 6), Value: 120 }
  58. ]);
  59. var goalUpperBound = ko.observable(40);
  60. function SetPointer(values1, values2) {
  61. var len = 0;
  62. var tmpArray = new Array();
  63. var values1MinMax = 0;
  64. var values2MinMax = 0;
  65. if (values1.length > values2.length) {
  66. len = values2.length;
  67. } else {
  68. len = values1.length;
  69. }
  70. if (len <= 1) {
  71. utils.toast.show("지표를 연산 할 데이터 범위가 적어도 하나 이상 존재해야 합니다.");
  72. $('#pointerText').text("상관성 지표 : 연산 데이터가 부족합니다.");
  73. } else {
  74. var values1Min = 9999;
  75. var values1Max = -9999;
  76. for (var i = 0; i < values1.length; i++) {
  77. if (values1[i].Value <= values1Min)
  78. values1Min = values1[i].Value;
  79. if (values1[i].Value >= values1Max)
  80. values1Max = values1[i].Value;
  81. }
  82. values1MinMax = values1Max - values1Min;
  83. var values2Min = 9999;
  84. var values2Max = -9999;
  85. for (var i = 0; i < values2.length; i++) {
  86. if (values2[i].Value <= values2Min)
  87. values2Min = values2[i].Value;
  88. if (values2[i].Value >= values2Max)
  89. values2Max = values2[i].Value;
  90. }
  91. values2MinMax = values2Max - values2Min;
  92. for (var i = 0; i < len - 1; i++) {
  93. //tmpArray.push({ value1: values1[i] - values1[i + 1], value2: values2[i] - values2[i + 1] });
  94. tmpArray.push((((values1[i].Value - values1[i + 1].Value) / values1MinMax * 100) / ((values2[i].Value - values2[i + 1].Value) / values2MinMax * 100)).toFixed(2));
  95. }
  96. var sum = 0;
  97. var cnt = 0;
  98. for (var j = 0; j < tmpArray.length; j++) {
  99. if (isFinite(tmpArray[j]) && !isNaN(tmpArray[j])) {
  100. //sum = sum + Math.abs(tmpArray[j]);
  101. sum = sum + parseFloat(tmpArray[j].toString());
  102. cnt++;
  103. }
  104. }
  105. if (isFinite((sum / cnt).toFixed(2)) && !isNaN((sum / cnt).toFixed(2))) {
  106. $('#pointerText').text("상관성 지표 : " + (sum / cnt).toFixed(2).toString() + "%");
  107. } else {
  108. $('#pointerText').text("상관성 지표 : 0%");
  109. }
  110. }
  111. }
  112. function handleClickTreeItem(element, data) {
  113. var eq = BWA.DataUtil.constructEqualFilter;
  114. var depth = data.depth;
  115. //data = data.data;
  116. switch (depth) {
  117. case BUILDING_DEPTH: // building
  118. data = data.data;
  119. buildingIdForSearch(data.BuildingId());
  120. buildingNameForSearch(data.Name());
  121. floorIdForSearch(null);
  122. floorNameForSearch('');
  123. zoneIdForSearch(null);
  124. zoneNameForSearch('');
  125. break;
  126. case FLOOR_DEPTH: // floor
  127. buildingNameForSearch(data.parentData.data.Name());
  128. data = data.data;
  129. buildingIdForSearch(data.BuildingId());
  130. floorIdForSearch(data.FloorId());
  131. floorNameForSearch(data.Name());
  132. zoneIdForSearch(null);
  133. zoneNameForSearch('');
  134. break;
  135. case ZONE_DEPTH: // zone
  136. floorNameForSearch(data.parentData.data.Name());
  137. buildingNameForSearch(data.parentData.parentData.data.Name());
  138. data = data.data;
  139. buildingIdForSearch(data.BuildingId());
  140. floorIdForSearch(data.FloorId());
  141. zoneIdForSearch(data.ZoneId());
  142. zoneNameForSearch(data.Name());
  143. break;
  144. }
  145. }
  146. function handleSearchViewInitializeUpdate() {
  147. //alert('handleSearchViewInitializeUpdate');
  148. $('#locationTreeViewInSearchViewE').cwTreeView({
  149. width: '40%',
  150. height: '480px',
  151. onClickTreeItem: handleClickTreeItem,
  152. delegateDataSource: BWA.DataUtil.getLocationDataSourceDelegateForTreeView(
  153. buildingDataSource,
  154. floorDataSource,
  155. zoneDataSource
  156. )
  157. });
  158. }
  159. function handleViewShown() {
  160. if (initialized === false) {
  161. chart = chart(BWA.ChartOptions.EnthalpyEnergyConsumption.getChartOptions(timeBoxForSearch.type(), goalUpperBound));
  162. floorNameForSearch('');
  163. zoneNameForSearch('');
  164. initialized = true;
  165. }
  166. if (shouldReload) {
  167. }
  168. }
  169. function handleViewHidden() {
  170. $SearchView.visibleObservable(false); // hcLee 2015 03 23
  171. visiblePopup(false);
  172. }
  173. function handleViewShowing() {
  174. $.when(fuelTypesDataSource.load(), buildingDataSource.load()).done(function (fuelTypes, dbBuildings) {
  175. fuelTypes = fuelTypes[0];
  176. dbBuildings = dbBuildings[0];
  177. fuelTypesForSearch(_.rest(fuelTypes));
  178. deferredForSearch.resolve();
  179. if (_.isEmpty(dbBuildings) === false) {
  180. buildingIdForSearch(dbBuildings[0].BuildingId());
  181. buildingNameForSearch(dbBuildings[0].Name());
  182. handleSearchInSearchView();
  183. }
  184. });
  185. }
  186. function refreshList() {
  187. }
  188. var searchViewOptions = {
  189. searchViewItems: [
  190. { id: 'FuelTypeId', ignoreValue: 0, defaultValue: $Code.FuelType.ELECTRICITY, value: fuelTypeIdForSearch, dataSource: fuelTypesForSearch }
  191. ],
  192. promiseDataInSearchView: deferredForSearch.promise()
  193. };
  194. function handleSearchInSearchView() {
  195. visiblePopup(true);
  196. $("#large-indicator").dxLoadIndicator({
  197. height: 60,
  198. width: 60
  199. });
  200. var date = timeBoxForSearch.getDate(),
  201. timeType = timeBoxForSearch.type();
  202. var commonParameters = {
  203. TimeIntervalType: timeBoxForSearch.type(),
  204. StartDate: date.startDate,
  205. EndDate: date.endDate
  206. };
  207. var pointHistoryParameters = {
  208. BuildingId: buildingIdForSearch(),
  209. FloorId: floorIdForSearch(),
  210. ZoneId: zoneIdForSearch(),
  211. FuelTypeId: fuelTypeIdForSearch()
  212. };
  213. var temperatureParameters = {
  214. FacilityTypeId: FT.OUTDOOR,
  215. FacilityCode: FC.OUTDOOR,
  216. FormulaId: F[FT.OUTDOOR].TEMPERATURE,
  217. };
  218. var humidityParameters = _.extend({}, temperatureParameters, {
  219. FormulaId: F[FT.OUTDOOR].HUMIDITY,
  220. });
  221. $.when(
  222. pointHistoryGet.apiGet(_.extend(pointHistoryParameters, commonParameters)),
  223. formulaGet.apiGet(_.extend(temperatureParameters, commonParameters)),
  224. formulaGet.apiGet(_.extend(humidityParameters, commonParameters)))
  225. .done(function (values, temperatures, humidities) {
  226. SetPointer(values[0], temperatures[0]);
  227. var dataArray = [];
  228. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  229. var dataArray_Temp = [];
  230. var dataArray_Temp1 = [];
  231. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  232. _.each(values[0], function (x) {
  233. dataArray_Temp.push({
  234. DateTime: BWA.Chart.getCustermTimeArgumentAxisString(timeBoxForSearch.type(), moment(x.DateTime).toDate()),
  235. Value: x.Value
  236. });
  237. });
  238. for (var i = 0; i < temperatures[0].length; i++)
  239. {
  240. dataArray_Temp1.push({
  241. DateTime: BWA.Chart.getCustermTimeArgumentAxisString(timeBoxForSearch.type(), moment(temperatures[0][i].DateTime).toDate()),
  242. enthalpy: BWA.Bems.refinegetENTHALPY(temperatures[0][i].Value, humidities[0][i].Value / 100)
  243. });
  244. }
  245. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  246. // 배열을 하나로 합치자
  247. var array_length_size = Math.max(dataArray_Temp.length, dataArray_Temp1.length);
  248. // 크기가 동일한 경우에만 허용함 (예외 방어용)
  249. if (dataArray_Temp.length == dataArray_Temp1.length) {
  250. for (var i = 0; i < array_length_size; i++) {
  251. dataArray.push(
  252. {
  253. DateTime: dataArray_Temp[i].DateTime,
  254. Value: dataArray_Temp[i].Value,
  255. enthalpy: dataArray_Temp1[i].enthalpy
  256. });
  257. }
  258. }
  259. dataArrayresult = dataArray;
  260. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  261. var options = BWA.ChartOptions.EnthalpyEnergyConsumption.getSeriesOptions(timeBoxForSearch.type(), fuelTypeIdForSearch(), goalUpperBound());
  262. options.dataSource = dataArray;
  263. chart().option(options);
  264. $('#st').text('' + "" + buildingNameForSearch() + " - " +
  265. floorNameForSearch() + " - " + zoneNameForSearch());
  266. visiblePopup(false);
  267. })
  268. .fail(function (error) {
  269. //alert(error);
  270. visiblePopup(false);
  271. });
  272. //buildingNameForSearch
  273. }
  274. function handleMenuItemClick(e) {
  275. var chartIntance = chart();
  276. var chartOptions = chartIntance._options;
  277. var series = chartIntance.getAllSeries();
  278. var table = [];
  279. var columns = [chartOptions.argumentAxis.title];
  280. var values = {};
  281. _.each(chartOptions.valueAxis, function (a) {
  282. columns.push(a.title.text);
  283. });
  284. _.each(series, function (s, i) {
  285. _.each(s.pointsByArgument, function (point, argument) {
  286. var array = values[argument];
  287. if (_.isArray(array) === false) {
  288. array = values[argument] = [];
  289. }
  290. array[i] = point[0].value;
  291. });
  292. });
  293. var csvRows = [columns.join(',')];
  294. _.each(values, function (values, argument) {
  295. csvRows.push([$G.dateTime(moment(Number(argument))), values.join(',')].join(','));
  296. });
  297. var csvContent = csvRows.join("\r\n");
  298. var agent = navigator.userAgent.toLowerCase();
  299. if (window.navigator.msSaveOrOpenBlob) {
  300. var fileData = ['\uFEFF' + csvContent];
  301. var blobObject = new Blob(fileData);
  302. window.navigator.msSaveOrOpenBlob(blobObject, 'export.csv');
  303. }
  304. else {
  305. var csvString = 'data:text/csv;utf-8,\uFEFF' + encodeURI(csvContent);
  306. var a = $('#csvExporter');
  307. a.attr({
  308. 'href': csvString,
  309. 'target': '_blank',
  310. 'download': 'export.csv'
  311. });
  312. // a.trigger('click');
  313. var aa = document.getElementById('csvExporter');
  314. aa.click();
  315. }
  316. }
  317. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  318. function DataGridPopup_ButtonClick() {
  319. DataGridPopup_Visible(true);
  320. }
  321. function handlePopupShown() {
  322. // 컬럼명 업데이트
  323. var ColumnCaptionName = "";
  324. switch (fuelTypeIdForSearch()) {
  325. case $Code.FuelType.ELECTRICITY:
  326. ColumnCaptionName = "전기";
  327. break;
  328. case $Code.FuelType.GAS:
  329. ColumnCaptionName = "가스";
  330. break;
  331. case $Code.FuelType.WATER:
  332. ColumnCaptionName = "수도";
  333. break;
  334. }
  335. viewModel.EnthalpyEnergyConsumptionDataGridOptions.columns[1].caption = ColumnCaptionName;
  336. // 데이타소스 업데이트
  337. $("#EnthalpyEnergyConsumptionDataGrid_Container").dxDataGrid("instance").option("dataSource", dataArrayresult);
  338. // 팝업창 갱신
  339. DataGridPopup_Visible(true);
  340. }
  341. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  342. var viewModel = $.extend(BWA.CommonView.create(
  343. params, viewInfo, searchViewOptions, ko.observable(null), handleViewShown, null,
  344. handleSearchInSearchView, handleSearchViewInitializeUpdate), {
  345. refreshList: refreshList,
  346. viewShowing: handleViewShowing,
  347. viewHidden: handleViewHidden, // hcLee 2015 03 23
  348. locationEnableForSearch: locationEnableForSearch,
  349. handleMenuItemClick: handleMenuItemClick,
  350. menuItems: [{
  351. text: '엑셀(csv) 내보내기'
  352. }]
  353. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  354. , EnthalpyEnergyConsumptionDataGridPopup_ButtonClicked: DataGridPopup_ButtonClick
  355. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  356. });
  357. viewModel.timeBoxForSearch = timeBoxForSearch;
  358. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  359. viewModel.EnthalpyEnergyConsumptionDataGridPopupOptions = {
  360. width: '480px',
  361. height: '750px', // cyim 2017.05.30 : 테스트 결과 Devextreme 버그임. px 로 지정하면 초기 출력시 정확하게 가운데에 있지만, auto 설정시 화면아래에 위치하게 됨
  362. contentTemplate: "content",
  363. showTitle: true,
  364. title: "도표",
  365. visible: DataGridPopup_Visible,
  366. dragEnabled: true,
  367. closeOnOutsideClick: true,
  368. shownAction: handlePopupShown,
  369. animation: window.utils.popup.createAnimation()
  370. };
  371. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  372. viewModel.popupOptions = {
  373. width: 300,
  374. height: 140,
  375. contentTemplate: "info",
  376. showTitle: false,
  377. title: "작업중",
  378. visible: visiblePopup,
  379. dragEnabled: false,
  380. shading: false,
  381. closeOnOutsideClick: false
  382. };
  383. //대기압
  384. var height = 101325 * Math.pow((1 - 2.25577 * Math.pow(10, -5) * 50), 5.2559);
  385. //alert(height);
  386. //포화공기 압력
  387. function getSAP(temp) {
  388. var cl = new Array(-5674.5359, 6.3925247, -0.009677843, 6.22157E-07, 2.07478E-09, -9.48402E-13, 4.1635019);
  389. var ch = new Array(-5800.2206, 1.3914993, -0.048640239, 4.17648E-05, -1.44521E-08, 6.5459673);
  390. var at = temp + 273.15;
  391. if (temp < 0)
  392. return Math.exp(cl[0] / at + cl[1] + cl[2] * at + cl[3] * Math.pow(at, 2) + cl[4] * Math.pow(at, 3) + cl[5] * Math.pow(at, 4) + cl[6] * Math.log(at));
  393. return Math.exp(ch[0] / at + ch[1] + ch[2] * at + ch[3] * Math.pow(at, 2) + ch[4] * Math.pow(at, 3) + ch[5] * Math.log(at));
  394. }
  395. //var SAP = getSAP(80/100, 30.0);
  396. //alert(SAP);
  397. // 절대습도
  398. function getAH(humi, temp) {
  399. return (0.62198 * humi * getSAP(temp)) / (height - humi * getSAP(temp));
  400. }
  401. //var AH = getAH(80/100, 30);
  402. //alert(AH);
  403. function getENTHALPY(humi, temp) {
  404. return 1.006 * temp + (2501 + (1.86 * temp)) * getAH(humi, temp);
  405. }
  406. var e = getENTHALPY(80 / 100, 30);
  407. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  408. // 주석이 너무 없음. 나중에 변경 작업을 진행하는 누군가가 시간 소비를 하지 않기 위해...남김
  409. // 시간 포맷은 그래프에 귀속해야 되므로 포맷은 변경하지 않는 것이 유리함
  410. // 전기,가스,수도 와 같이 선택적으로 변경해야 된다면 아래와 같이 캡션은 고정하지 말것
  411. viewModel.EnthalpyEnergyConsumptionDataGridOptions = {
  412. dataSource: dataArrayresult,
  413. paging: { pageSize: 17 },
  414. columns: [
  415. { dataField: 'DateTime', caption: "날짜", width: '33%', alignment: 'center', },// dataType: 'date', format: 'yyyy-MM-dd HH:mm' },
  416. { dataField: 'Value', width: '33%', alignment: 'center', format: 'fixedPoint', precision: 2 },
  417. { dataField: 'enthalpy', caption: "엔탈피", width: '33%', alignment: 'center', format: 'fixedPoint', precision: 2 }
  418. ],
  419. // 엑셀 출력
  420. "export": {
  421. enabled: true,
  422. fileName: '에너지 사용량(엔탈피)'
  423. }
  424. };
  425. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  426. return viewModel;
  427. };