0087add1027b036b94662ed0f74058d1a77fed5c.svn-base 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439
  1. BemsWebApplication.WeekEnergyConsumption = 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($G.TimeTypesForDayMonth),
  18. //timeBoxForSearch = BWA.SearchView.createDateTimeBox(),
  19. formulaGet = new BWA.Chart.FormulaGet(BWA.UserInfo.SiteId());
  20. //var buildingDataSource = BemsWebApplication.db.createDataSource('CmBuilding', true, true),
  21. var buildingDataSource = BemsWebApplication.db.createDataSource('CmBuilding', true),
  22. floorDataSource = BemsWebApplication.db.createDataSource('CmFloor'),
  23. zoneDataSource = BemsWebApplication.db.createDataSource('CmZone'),
  24. fuelTypesDataSource = BemsWebApplication.db.createDataSource('BemsFuelType'),
  25. //check_input = ko.observable(false),
  26. //check_input2 = ko.observable(false),
  27. buildings = ko.observableArray(),
  28. timeTypesForSearch = ko.observableArray(),
  29. timeTypeIdForSearch = ko.observable(0),
  30. floorsForSearch = ko.observableArray(),
  31. zonesForSearch = ko.observableArray(),
  32. fuelTypesForSearch = ko.observableArray(),
  33. buildingIdForSearch = ko.observable(),
  34. buildingNameForSearch = ko.observable(),
  35. floorIdForSearch = ko.observable(),
  36. floorNameForSearch = ko.observable(),
  37. zoneIdForSearch = ko.observable(),
  38. zoneNameForSearch = ko.observable(),
  39. fuelTypeIdForSearch = ko.observable(),
  40. deferredForSearch = new $.Deferred();
  41. var deferredForLoadData = new $.Deferred();
  42. var chart = BWA.Chart.Instance('chartWEEKA', 'dxChart');
  43. var locationEnableForSearch = ko.observable(false);
  44. var chartDataArray = ko.observableArray();
  45. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  46. // 팝업창뷰 보이기 속성 제어용 변수 선언
  47. var DataGridPopup_Visible = ko.observable(false);
  48. // 그래프 출력 이후 엑셀출력을 위한 팝업창을 위해 임시 저장용 배열 선언
  49. var dataArrayresult = ko.observableArray();
  50. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  51. chartDataArray([
  52. { DateTime: new Date(2014, 11, 16, 0), OutdoorTemperature: -3.4, OutdoorHumidity: 40, Value: 30 },
  53. { DateTime: new Date(2014, 11, 16, 0, 15), OutdoorTemperature: -1.1, OutdoorHumidity: 44, Value: 32 },
  54. { DateTime: new Date(2014, 11, 16, 0, 30), OutdoorTemperature: 3, OutdoorHumidity: 48, Value: 33 },
  55. { DateTime: new Date(2014, 11, 16, 0, 45), OutdoorTemperature: 4, OutdoorHumidity: 55, Value: 34 },
  56. { DateTime: new Date(2014, 11, 16, 1), OutdoorTemperature: 8, OutdoorHumidity: 54, Value: 50 },
  57. { DateTime: new Date(2014, 11, 16, 2), OutdoorTemperature: 10, OutdoorHumidity: 53, Value: 60 },
  58. { DateTime: new Date(2014, 11, 16, 3), OutdoorTemperature: 11, Value: 80 },
  59. { DateTime: new Date(2014, 11, 16, 4), OutdoorTemperature: 12, OutdoorHumidity: 48, Value: 100 },
  60. { DateTime: new Date(2014, 11, 16, 5), OutdoorTemperature: 12, OutdoorHumidity: 40 },
  61. { DateTime: new Date(2014, 11, 16, 6), Value: 120 }
  62. ]);
  63. var goalUpperBound = ko.observable(40);
  64. function handleClickTreeItem(element, data) {
  65. var eq = BWA.DataUtil.constructEqualFilter;
  66. var depth = data.depth;
  67. //data = data.data;
  68. switch (depth) {
  69. case BUILDING_DEPTH: // building
  70. data = data.data;
  71. buildingIdForSearch(data.BuildingId());
  72. buildingNameForSearch(data.Name());
  73. floorIdForSearch(null);
  74. floorNameForSearch('');
  75. zoneIdForSearch(null);
  76. zoneNameForSearch('');
  77. break;
  78. case FLOOR_DEPTH: // floor
  79. buildingNameForSearch(data.parentData.data.Name());
  80. //alert(buildingIdForSearch());
  81. data = data.data;
  82. buildingIdForSearch(data.BuildingId());
  83. floorIdForSearch(data.FloorId());
  84. floorNameForSearch(data.Name());
  85. zoneIdForSearch(null);
  86. zoneNameForSearch('');
  87. break;
  88. case ZONE_DEPTH: // zone
  89. floorNameForSearch(data.parentData.data.Name());
  90. buildingNameForSearch(data.parentData.parentData.data.Name());
  91. data = data.data;
  92. buildingIdForSearch(data.BuildingId());
  93. //alert(buildingIdForSearch());
  94. //buildingNameForSearch(data.Name());
  95. floorIdForSearch(data.FloorId());
  96. //alert(floorIdForSearch());
  97. //floorNameForSearch(data.parent.data.Name());
  98. zoneIdForSearch(data.ZoneId());
  99. zoneNameForSearch(data.Name());
  100. break;
  101. }
  102. }
  103. function handleSearchViewInitializeUpdate() {
  104. //alert('handleSearchViewInitializeUpdate');
  105. $('#locationTreeViewInSearchViewW').cwTreeView({
  106. width: '40%',
  107. height: '480px',
  108. onClickTreeItem: handleClickTreeItem,
  109. delegateDataSource: BWA.DataUtil.getLocationDataSourceDelegateForTreeView(
  110. buildingDataSource,
  111. floorDataSource,
  112. zoneDataSource
  113. )
  114. });
  115. }
  116. function handleViewShown() {
  117. //alert('handleViewShown'); // 2
  118. if (initialized === false) {
  119. //alert('handleViewShown1'); // 3
  120. chart = chart(BWA.ChartOptions.WeekEnergyConsumption.getChartOptions(timeBoxForSearch.type(), goalUpperBound));
  121. //chart = chart(BWA.ChartOptions.LocEnergyConsumption.getSeriesOptions(timeBoxForSearch.type(), fuelTypeIdForSearch(), goalUpperBound));
  122. floorNameForSearch('');
  123. zoneNameForSearch('');
  124. initialized = true;
  125. }
  126. if (shouldReload) {
  127. //shouldReload = false;
  128. //dataSource.pageIndex(0);
  129. //dataSource.load();
  130. }
  131. }
  132. function handleViewHidden() {
  133. $SearchView.visibleObservable(false); // hcLee 2015 03 23
  134. visiblePopup(false);
  135. //hideOverlay();
  136. // var dataGrid = $('#gridContainer').dxDataGrid('instance');
  137. // dataGrid.clearSelection();
  138. }
  139. function handleViewShowing() {
  140. //alert('handleViewShowing'); // 1
  141. $.when(fuelTypesDataSource.load(), buildingDataSource.load()).done(function (fuelTypes, dbBuildings) {
  142. fuelTypes = fuelTypes[0];
  143. dbBuildings = dbBuildings[0];
  144. fuelTypesForSearch(_.rest(fuelTypes));
  145. deferredForSearch.resolve();
  146. if (_.isEmpty(dbBuildings) === false) {
  147. buildingIdForSearch(dbBuildings[0].BuildingId());
  148. buildingNameForSearch(dbBuildings[0].Name());
  149. handleSearchInSearchView();
  150. }
  151. });
  152. }
  153. function refreshList() {
  154. //dataSource.pageIndex(0);
  155. //dataSource.load();
  156. }
  157. var searchViewOptions = {
  158. searchViewItems: [
  159. //{ id: 'TimeTypeId', defaultValue: 3, value: timeTypeIdForSearch, dataSource: $G.TimeTypes},
  160. { id: 'FuelTypeId', ignoreValue: 0, defaultValue: $Code.FuelType.ELECTRICITY, value: fuelTypeIdForSearch, dataSource: fuelTypesForSearch }
  161. ],
  162. promiseDataInSearchView: deferredForSearch.promise()
  163. };
  164. function handleSearchInSearchView() {
  165. visiblePopup(true);
  166. $("#large-indicator").dxLoadIndicator({
  167. height: 60,
  168. width: 60
  169. });
  170. var date = timeBoxForSearch.getDate(),
  171. timeType = timeBoxForSearch.type();
  172. //alert('handleSearchInSearchView');
  173. var commonParameters = {
  174. //TimeIntervalType: $Code.TimeIntervalType.QUARTERMIN,
  175. TimeIntervalType: $Code.TimeType.DAY,//timeBoxForSearch.type(),
  176. StartDate: date.startDate,
  177. EndDate: date.endDate
  178. };
  179. var pointHistoryParameters = {
  180. BuildingId: buildingIdForSearch(),
  181. FloorId: floorIdForSearch(),
  182. ZoneId: zoneIdForSearch(),
  183. FuelTypeId: fuelTypeIdForSearch()
  184. //FuelTypeId: $Code.FuelType.ELECTRICITY,
  185. };
  186. var temperatureParameters = {
  187. FacilityTypeId: FT.OUTDOOR,
  188. FacilityCode: FC.OUTDOOR,
  189. FormulaId: F[FT.OUTDOOR].TEMPERATURE,
  190. };
  191. var humidityParameters = _.extend({}, temperatureParameters, {
  192. FormulaId: F[FT.OUTDOOR].HUMIDITY,
  193. });
  194. $.when(
  195. pointHistoryGet.apiGet(_.extend(pointHistoryParameters, commonParameters)))
  196. /*
  197. pointHistoryGet.apiGet(_.extend(pointHistoryParameters, commonParameters)),
  198. formulaGet.apiGet(_.extend(temperatureParameters, commonParameters))) */
  199. //.done(function(values, temperatures, humidities) {
  200. //.done(function (values, temperatures) {
  201. .done(function (values) {
  202. var values7 = new Array(0, 0, 0, 0, 0, 0, 0);
  203. var values7Cnt = new Array(0, 0, 0, 0, 0, 0, 0);
  204. //_.each(values[0], function(x) {
  205. _.each(values, function (x) {
  206. values7[moment(x.DateTime).toDate().getDay()] += x.Value;
  207. values7Cnt[moment(x.DateTime).toDate().getDay()]++;
  208. });
  209. var days7 = new Array('일요일', '월요일', '화요일', '수요일', '목요일', '금요일', '토요일');
  210. var dataArray = [];
  211. for (var i = 0; i < 7; i++) {
  212. dataArray.push({ week: days7[i], Value: (values7Cnt[i] == 0) ? 0 : values7[i] / values7Cnt[i] });
  213. //dataArray.push({ week: days7[i], Value: values7[i] });
  214. }
  215. dataArrayresult = dataArray;
  216. //chart2 = chart(BWA.ChartOptions.LocEnergyConsumption.getSeriesOptions(timeBoxForSearch.type(), goalUpperBound));
  217. var options = BWA.ChartOptions.WeekEnergyConsumption.getSeriesOptions(timeBoxForSearch.type(), fuelTypeIdForSearch(), goalUpperBound());
  218. chart().option('argumentAxis', null); // 2015 05 21 결국 이 코드가 필요 함 (시간 축 에러 해결)
  219. //chart().cle
  220. //chart().option(null);
  221. //options.dataSource = null;
  222. //chart().option(options);
  223. options.dataSource = dataArray;
  224. chart().option(options);
  225. //chart().option('dataSource', dataArray);
  226. // chart().option('dataSource', dataArray);
  227. // chart().option('dataSource', chartDataArray());
  228. // chartDataArray(values);
  229. $('#st').text('' + "" + buildingNameForSearch() + " - " +
  230. floorNameForSearch() + " - " + zoneNameForSearch() + "(" + date.startDate.getFullYear() + "년 " + (date.startDate.getMonth() + 1) + "월 " + date.startDate.getDate() + "일 ~ " +
  231. date.endDate.getFullYear() + "년 " + (date.endDate.getMonth() + 1) + "월 " + date.endDate.getDate() + "일)");
  232. visiblePopup(false);
  233. })
  234. .fail(function (error) {
  235. //alert(error);
  236. visiblePopup(false);
  237. });
  238. //buildingNameForSearch
  239. }
  240. function handleMenuItemClick(e) {
  241. var chartIntance = chart();
  242. var chartOptions = chartIntance._options;
  243. var series = chartIntance.getAllSeries();
  244. var table = [];
  245. var columns = [chartOptions.argumentAxis.title];
  246. var values = {};
  247. _.each(chartOptions.valueAxis, function (a) {
  248. columns.push(a.title.text);
  249. });
  250. _.each(series, function (s, i) {
  251. _.each(s.pointsByArgument, function (point, argument) {
  252. var array = values[argument];
  253. if (_.isArray(array) === false) {
  254. array = values[argument] = [];
  255. }
  256. array[i] = point.value;
  257. });
  258. });
  259. var csvRows = [columns.join(',')];
  260. _.each(values, function (values, argument) {
  261. csvRows.push([$G.dateTime(moment(Number(argument))), values.join(',')].join(','));
  262. });
  263. var csvContent = csvRows.join("\r\n");
  264. var agent = navigator.userAgent.toLowerCase();
  265. if (window.navigator.msSaveOrOpenBlob) {
  266. var fileData = ['\uFEFF' + csvContent];
  267. var blobObject = new Blob(fileData);
  268. window.navigator.msSaveOrOpenBlob(blobObject, 'export.csv');
  269. }
  270. else {
  271. var csvString = 'data:text/csv;utf-8,\uFEFF' + encodeURI(csvContent);
  272. var a = $('#csvExporter');
  273. a.attr({
  274. 'href': csvString,
  275. 'target': '_blank',
  276. 'download': 'export.csv'
  277. });
  278. // a.trigger('click');
  279. var aa = document.getElementById('csvExporter');
  280. aa.click();
  281. }
  282. }
  283. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  284. function DataGridPopup_ButtonClick() {
  285. DataGridPopup_Visible(true);
  286. }
  287. function handlePopupShown() {
  288. // 컬럼명 업데이트
  289. var ColumnCaptionName = "";
  290. switch (fuelTypeIdForSearch()) {
  291. case $Code.FuelType.ELECTRICITY:
  292. ColumnCaptionName = "전기";
  293. break;
  294. case $Code.FuelType.GAS:
  295. ColumnCaptionName = "가스";
  296. break;
  297. case $Code.FuelType.WATER:
  298. ColumnCaptionName = "수도";
  299. break;
  300. }
  301. viewModel.WeekEnergyConsumptionDataGridOptions.columns[1].caption = ColumnCaptionName;
  302. // 데이타소스 업데이트
  303. $("#WeekEnergyConsumptionDataGrid_Container").dxDataGrid("instance").option("dataSource", dataArrayresult);
  304. // 팝업창 갱신
  305. DataGridPopup_Visible(true);
  306. }
  307. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  308. var viewModel = $.extend(BWA.CommonView.create(
  309. params, viewInfo, searchViewOptions, ko.observable(null), handleViewShown, null,
  310. handleSearchInSearchView, handleSearchViewInitializeUpdate), {
  311. refreshList: refreshList,
  312. viewShowing: handleViewShowing,
  313. viewHidden: handleViewHidden, // hcLee 2015 03 23
  314. locationEnableForSearch: locationEnableForSearch,
  315. handleMenuItemClick: handleMenuItemClick,
  316. menuItems: [{
  317. text: '엑셀(csv) 내보내기'
  318. }]
  319. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  320. , WeekEnergyConsumptionDataGridPopup_ButtonClicked: DataGridPopup_ButtonClick
  321. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  322. });
  323. viewModel.timeBoxForSearch = timeBoxForSearch;
  324. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  325. viewModel.WeekEnergyConsumptionDataGridPopupOptions = {
  326. width: '480px',
  327. height: '400px', // cyim 2017.05.30 : 테스트 결과 Devextreme 버그임. px 로 지정하면 초기 출력시 정확하게 가운데에 있지만, auto 설정시 화면아래에 위치하게 됨
  328. contentTemplate: "content",
  329. showTitle: true,
  330. title: "도표",
  331. visible: DataGridPopup_Visible,
  332. dragEnabled: true,
  333. closeOnOutsideClick: true,
  334. shownAction: handlePopupShown,
  335. animation: window.utils.popup.createAnimation()
  336. };
  337. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  338. viewModel.popupOptions = {
  339. width: 300,
  340. height: 100,
  341. contentTemplate: "info",
  342. showTitle: false,
  343. title: "메세지",
  344. visible: visiblePopup,
  345. dragEnabled: false,
  346. shading: false,
  347. closeOnOutsideClick: false
  348. };
  349. //viewModel.check_input = check_input;
  350. //viewModel.check_input2 = check_input2;
  351. //var dd = new Date(2015, 4, 0);
  352. //var selectedDay = document.form1.JLDAY.value;
  353. //var lastDay = dd.getDate();
  354. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  355. // 주석이 너무 없음. 나중에 변경 작업을 진행하는 누군가가 시간 소비를 하지 않기 위해...남김
  356. // 시간 포맷은 그래프에 귀속해야 되므로 포맷은 변경하지 않는 것이 유리함
  357. // 전기,가스,수도 와 같이 선택적으로 변경해야 된다면 아래와 같이 캡션은 고정하지 말것
  358. viewModel.WeekEnergyConsumptionDataGridOptions = {
  359. dataSource: dataArrayresult,
  360. paging: { pageSize: 17 },
  361. columns: [
  362. { dataField: 'week', caption: "날짜", width: '33%', alignment: 'center', },// dataType: 'date', format: 'yyyy-MM-dd HH:mm' },
  363. { dataField: 'Value', width: '33%', alignment: 'center', format: 'fixedPoint', precision: 2 },
  364. ],
  365. // 엑셀 출력
  366. "export": {
  367. enabled: true,
  368. fileName: '에너지 사용량(요일별)'
  369. }
  370. };
  371. // 2017.09.08 : 그리드 도표 작업 : 팝업창 추가
  372. return viewModel;
  373. };