78f413a6923c5171a595bb024af8766bfcb94176
[portal/sdk.git] /
1 /*-
2  * ================================================================================
3  * eCOMP Portal SDK
4  * ================================================================================
5  * Copyright (C) 2017 AT&T Intellectual Property
6  * ================================================================================
7  * Licensed under the Apache License, Version 2.0 (the "License");
8  * you may not use this file except in compliance with the License.
9  * You may obtain a copy of the License at
10  * 
11  *      http://www.apache.org/licenses/LICENSE-2.0
12  * 
13  * Unless required by applicable law or agreed to in writing, software
14  * distributed under the License is distributed on an "AS IS" BASIS,
15  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16  * See the License for the specific language governing permissions and
17  * limitations under the License.
18  * ================================================================================
19  */
20 package org.openecomp.portalsdk.analytics.model.runtime;
21
22 import java.util.ArrayList;
23 import java.util.Calendar;
24 import java.util.Map;
25
26 import javax.xml.bind.annotation.XmlAttribute;
27 import javax.xml.bind.annotation.XmlElement;
28
29 import org.json.JSONObject;
30 import org.openecomp.portalsdk.analytics.model.base.IdNameValue;
31 import org.openecomp.portalsdk.analytics.view.ColumnHeader;
32 import org.openecomp.portalsdk.analytics.view.DataValue;
33 import org.openecomp.portalsdk.analytics.xmlobj.ColFilterList;
34 import org.openecomp.portalsdk.analytics.xmlobj.DataColumnList;
35 import org.openecomp.portalsdk.analytics.xmlobj.DataColumnType;
36
37 /*class MetaColumn {
38     private String tableId;
39     private String dbColName;
40     private String crossTabValue;
41     private String colName;
42     private String displayName;
43     private Integer displayWidth;
44     private String displayWidthInPxls;
45     private String pdfDisplayWidthInPxls;
46     private String displayAlignment;
47     private String displayHeaderAlignment;
48     private int orderSeq;
49     private boolean visible;
50     private boolean calculated;
51     private String colType;
52     private String hyperlinkURL;
53     private String hyperlinkType;
54     private String actionImg;
55     private Integer groupByPos;
56     private String subTotalCustomText;
57     private Boolean hideRepeatedKey;
58     private String colFormat;
59     private boolean groupBreak;
60     private Integer orderBySeq;
61     private String orderByAscDesc;
62     private String displayTotal;
63     private String colOnChart;
64     private Integer chartSeq;
65     private String chartColor;
66     private String chartLineType;
67     private Boolean chartSeries;
68     private Boolean isRangeAxisFilled;
69     private Boolean createInNewChart;
70     private String drillDownType;
71     private Boolean drillinPoPUp;
72     private String drillDownURL;
73     private String drillDownParams;
74     private String comment;
75     private ColFilterList colFilterList;
76     private String semaphoreId;
77     private String dbColType;
78     private String chartGroup;
79     private String yAxis;
80     private String dependsOnFormField;
81     private String nowrap;
82     private Integer indentation;
83     private Boolean enhancedPagination;
84     private Integer level;
85     private Integer start;
86     private Integer colspan;
87     private String dataMiningCol;
88     private String colId;
89     
90         public String getTableId() {
91                 return tableId;
92         }
93         public void setTableId(String tableId) {
94                 this.tableId = tableId;
95         }
96         public String getDbColName() {
97                 return dbColName;
98         }
99         public void setDbColName(String dbColName) {
100                 this.dbColName = dbColName;
101         }
102         public String getCrossTabValue() {
103                 return crossTabValue;
104         }
105         public void setCrossTabValue(String crossTabValue) {
106                 this.crossTabValue = crossTabValue;
107         }
108         public String getColName() {
109                 return colName;
110         }
111         public void setColName(String colName) {
112                 this.colName = colName;
113         }
114         public String getDisplayName() {
115                 return displayName;
116         }
117         public void setDisplayName(String displayName) {
118                 this.displayName = displayName;
119         }
120         public Integer getDisplayWidth() {
121                 return displayWidth;
122         }
123         public void setDisplayWidth(Integer displayWidth) {
124                 this.displayWidth = displayWidth;
125         }
126         public String getDisplayWidthInPxls() {
127                 return displayWidthInPxls;
128         }
129         public void setDisplayWidthInPxls(String displayWidthInPxls) {
130                 this.displayWidthInPxls = displayWidthInPxls;
131         }
132         public String getPdfDisplayWidthInPxls() {
133                 return pdfDisplayWidthInPxls;
134         }
135         public void setPdfDisplayWidthInPxls(String pdfDisplayWidthInPxls) {
136                 this.pdfDisplayWidthInPxls = pdfDisplayWidthInPxls;
137         }
138         public String getDisplayAlignment() {
139                 return displayAlignment;
140         }
141         public void setDisplayAlignment(String displayAlignment) {
142                 this.displayAlignment = displayAlignment;
143         }
144         public String getDisplayHeaderAlignment() {
145                 return displayHeaderAlignment;
146         }
147         public void setDisplayHeaderAlignment(String displayHeaderAlignment) {
148                 this.displayHeaderAlignment = displayHeaderAlignment;
149         }
150         public int getOrderSeq() {
151                 return orderSeq;
152         }
153         public void setOrderSeq(int orderSeq) {
154                 this.orderSeq = orderSeq;
155         }
156         public boolean isVisible() {
157                 return visible;
158         }
159         public void setVisible(boolean visible) {
160                 this.visible = visible;
161         }
162         public boolean isCalculated() {
163                 return calculated;
164         }
165         public void setCalculated(boolean calculated) {
166                 this.calculated = calculated;
167         }
168         public String getColType() {
169                 return colType;
170         }
171         public void setColType(String colType) {
172                 this.colType = colType;
173         }
174         public String getHyperlinkURL() {
175                 return hyperlinkURL;
176         }
177         public void setHyperlinkURL(String hyperlinkURL) {
178                 this.hyperlinkURL = hyperlinkURL;
179         }
180         public String getHyperlinkType() {
181                 return hyperlinkType;
182         }
183         public void setHyperlinkType(String hyperlinkType) {
184                 this.hyperlinkType = hyperlinkType;
185         }
186         public String getActionImg() {
187                 return actionImg;
188         }
189         public void setActionImg(String actionImg) {
190                 this.actionImg = actionImg;
191         }
192         public Integer getGroupByPos() {
193                 return groupByPos;
194         }
195         public void setGroupByPos(Integer groupByPos) {
196                 this.groupByPos = groupByPos;
197         }
198         public String getSubTotalCustomText() {
199                 return subTotalCustomText;
200         }
201         public void setSubTotalCustomText(String subTotalCustomText) {
202                 this.subTotalCustomText = subTotalCustomText;
203         }
204         public Boolean getHideRepeatedKey() {
205                 return hideRepeatedKey;
206         }
207         public void setHideRepeatedKey(Boolean hideRepeatedKey) {
208                 this.hideRepeatedKey = hideRepeatedKey;
209         }
210         public String getColFormat() {
211                 return colFormat;
212         }
213         public void setColFormat(String colFormat) {
214                 this.colFormat = colFormat;
215         }
216         public boolean isGroupBreak() {
217                 return groupBreak;
218         }
219         public void setGroupBreak(boolean groupBreak) {
220                 this.groupBreak = groupBreak;
221         }
222         public Integer getOrderBySeq() {
223                 return orderBySeq;
224         }
225         public void setOrderBySeq(Integer orderBySeq) {
226                 this.orderBySeq = orderBySeq;
227         }
228         public String getOrderByAscDesc() {
229                 return orderByAscDesc;
230         }
231         public void setOrderByAscDesc(String orderByAscDesc) {
232                 this.orderByAscDesc = orderByAscDesc;
233         }
234         public String getDisplayTotal() {
235                 return displayTotal;
236         }
237         public void setDisplayTotal(String displayTotal) {
238                 this.displayTotal = displayTotal;
239         }
240         public String getColOnChart() {
241                 return colOnChart;
242         }
243         public void setColOnChart(String colOnChart) {
244                 this.colOnChart = colOnChart;
245         }
246         public Integer getChartSeq() {
247                 return chartSeq;
248         }
249         public void setChartSeq(Integer chartSeq) {
250                 this.chartSeq = chartSeq;
251         }
252         public String getChartColor() {
253                 return chartColor;
254         }
255         public void setChartColor(String chartColor) {
256                 this.chartColor = chartColor;
257         }
258         public String getChartLineType() {
259                 return chartLineType;
260         }
261         public void setChartLineType(String chartLineType) {
262                 this.chartLineType = chartLineType;
263         }
264         public Boolean getChartSeries() {
265                 return chartSeries;
266         }
267         public void setChartSeries(Boolean chartSeries) {
268                 this.chartSeries = chartSeries;
269         }
270         public Boolean getIsRangeAxisFilled() {
271                 return isRangeAxisFilled;
272         }
273         public void setIsRangeAxisFilled(Boolean isRangeAxisFilled) {
274                 this.isRangeAxisFilled = isRangeAxisFilled;
275         }
276         public Boolean getCreateInNewChart() {
277                 return createInNewChart;
278         }
279         public void setCreateInNewChart(Boolean createInNewChart) {
280                 this.createInNewChart = createInNewChart;
281         }
282         public String getDrillDownType() {
283                 return drillDownType;
284         }
285         public void setDrillDownType(String drillDownType) {
286                 this.drillDownType = drillDownType;
287         }
288         public Boolean getDrillinPoPUp() {
289                 return drillinPoPUp;
290         }
291         public void setDrillinPoPUp(Boolean drillinPoPUp) {
292                 this.drillinPoPUp = drillinPoPUp;
293         }
294         public String getDrillDownURL() {
295                 return drillDownURL;
296         }
297         public void setDrillDownURL(String drillDownURL) {
298                 this.drillDownURL = drillDownURL;
299         }
300         public String getDrillDownParams() {
301                 return drillDownParams;
302         }
303         public void setDrillDownParams(String drillDownParams) {
304                 this.drillDownParams = drillDownParams;
305         }
306         public String getComment() {
307                 return comment;
308         }
309         public void setComment(String comment) {
310                 this.comment = comment;
311         }
312         public ColFilterList getColFilterList() {
313                 return colFilterList;
314         }
315         public void setColFilterList(ColFilterList colFilterList) {
316                 this.colFilterList = colFilterList;
317         }
318         public String getSemaphoreId() {
319                 return semaphoreId;
320         }
321         public void setSemaphoreId(String semaphoreId) {
322                 this.semaphoreId = semaphoreId;
323         }
324         public String getDbColType() {
325                 return dbColType;
326         }
327         public void setDbColType(String dbColType) {
328                 this.dbColType = dbColType;
329         }
330         public String getChartGroup() {
331                 return chartGroup;
332         }
333         public void setChartGroup(String chartGroup) {
334                 this.chartGroup = chartGroup;
335         }
336         public String getyAxis() {
337                 return yAxis;
338         }
339         public void setyAxis(String yAxis) {
340                 this.yAxis = yAxis;
341         }
342         public String getDependsOnFormField() {
343                 return dependsOnFormField;
344         }
345         public void setDependsOnFormField(String dependsOnFormField) {
346                 this.dependsOnFormField = dependsOnFormField;
347         }
348         public String getNowrap() {
349                 return nowrap;
350         }
351         public void setNowrap(String nowrap) {
352                 this.nowrap = nowrap;
353         }
354         public Integer getIndentation() {
355                 return indentation;
356         }
357         public void setIndentation(Integer indentation) {
358                 this.indentation = indentation;
359         }
360         public Boolean getEnhancedPagination() {
361                 return enhancedPagination;
362         }
363         public void setEnhancedPagination(Boolean enhancedPagination) {
364                 this.enhancedPagination = enhancedPagination;
365         }
366         public Integer getLevel() {
367                 return level;
368         }
369         public void setLevel(Integer level) {
370                 this.level = level;
371         }
372         public Integer getStart() {
373                 return start;
374         }
375         public void setStart(Integer start) {
376                 this.start = start;
377         }
378         public Integer getColspan() {
379                 return colspan;
380         }
381         public void setColspan(Integer colspan) {
382                 this.colspan = colspan;
383         }
384         public String getDataMiningCol() {
385                 return dataMiningCol;
386         }
387         public void setDataMiningCol(String dataMiningCol) {
388                 this.dataMiningCol = dataMiningCol;
389         }
390         public String getColId() {
391                 return colId;
392         }
393         public void setColId(String colId) {
394                 this.colId = colId;
395         }  
396     
397 }*/
398
399 /*class Row {
400         private String displayValue;
401         private String dataType;
402         private String colId;
403         private boolean visible;
404         
405         
406         public boolean isVisible() {
407                 return visible;
408         }
409         public void setVisible(boolean visible) {
410                 this.visible = visible;
411         }
412         public String getDisplayValue() {
413                 return displayValue;
414         }
415         public void setDisplayValue(String displayValue) {
416                 this.displayValue = displayValue;
417         }
418         public String getDataType() {
419                 return dataType;
420         }
421         public void setDataType(String dataType) {
422                 this.dataType = dataType;
423         }
424         public String getColId() {
425                 return colId;
426         }
427         public void setColId(String colId) {
428                 this.colId = colId;
429         }
430         
431         
432 }*/
433 class FormFieldJSON {
434         private String fieldId;
435         private String fieldDisplayName;
436         private String fieldType;
437         private String validationType;
438         private boolean required;
439         //private String defaultValue;
440         
441         private Calendar rangeStartDate;
442         private Calendar rangeEndDate;
443         private String multiSelectListSize;
444         private String helpText;
445         private boolean visible;
446         private boolean triggerOtherFormFields;
447         private ArrayList<IdNameValue> formFieldValues;
448         
449         public String getFieldId() {
450                 return fieldId;
451         }
452         public void setFieldId(String fieldId) {
453                 this.fieldId = fieldId;
454         }
455         public String getFieldDisplayName() {
456                 return fieldDisplayName;
457         }
458         public void setFieldDisplayName(String fieldDisplayName) {
459                 this.fieldDisplayName = fieldDisplayName;
460         }
461         public String getFieldType() {
462                 return fieldType;
463         }
464         public void setFieldType(String fieldType) {
465                 this.fieldType = fieldType;
466         }
467         public String getValidationType() {
468                 return validationType;
469         }
470         public void setValidationType(String validationType) {
471                 this.validationType = validationType;
472         }
473         public boolean isRequired() {
474                 return required;
475         }
476         public void setRequired(boolean required) {
477                 this.required = required;
478         }
479         public Calendar getRangeStartDate() {
480                 return rangeStartDate;
481         }
482         public void setRangeStartDate(Calendar rangeStartDate) {
483                 this.rangeStartDate = rangeStartDate;
484         }
485         public Calendar getRangeEndDate() {
486                 return rangeEndDate;
487         }
488         public void setRangeEndDate(Calendar rangeEndDate) {
489                 this.rangeEndDate = rangeEndDate;
490         }
491         public String getMultiSelectListSize() {
492                 return multiSelectListSize;
493         }
494         public void setMultiSelectListSize(String multiSelectListSize) {
495                 this.multiSelectListSize = multiSelectListSize;
496         }
497         public String getHelpText() {
498                 return helpText;
499         }
500         public void setHelpText(String helpText) {
501                 this.helpText = helpText;
502         }
503         public boolean isVisible() {
504                 return visible;
505         }
506         public void setVisible(boolean visible) {
507                 this.visible = visible;
508         }
509         public boolean isTriggerOtherFormFields() {
510                 return triggerOtherFormFields;
511         }
512         public void setTriggerOtherFormFields(boolean triggerOtherFormFields) {
513                 this.triggerOtherFormFields = triggerOtherFormFields;
514         }
515         public ArrayList<IdNameValue> getFormFieldValues() {
516                 return formFieldValues;
517         }
518         public void setFormFieldValues(ArrayList<IdNameValue> formFieldValues) {
519                 this.formFieldValues = formFieldValues;
520         }
521
522         
523 }
524 public class ReportJSONRuntime {
525
526         private String reportID;
527         private String reportName;
528         private String reportDescr;
529         private String reportTitle;
530         private String reportSubTitle;
531         private boolean allowSchedule;
532         private boolean allowEdit;
533         private ArrayList <FormFieldJSON> formFieldList;
534         private String formfield_comments;
535         private ArrayList<ColumnHeader> reportDataColumns;
536         private ArrayList<Map<String,Object>> reportDataRows;
537         private int totalRows;
538         private int pageSize;
539         private String sqlWhole;
540         private boolean chartAvailable;
541         private boolean chartWizardAvailable;
542         private boolean displayData;
543         private boolean displayForm;
544         private boolean displayExcel;
545         private boolean displayPDF;
546         private String backBtnURL;
547         private String colIdxTobeFreezed;
548         private int numFormCols;
549         private String message;
550         private boolean hideFormFieldsAfterRun;
551         
552         
553         public boolean isChartAvailable() {
554                 return chartAvailable;
555         }
556         public void setChartAvailable(boolean chartAvailable) {
557                 this.chartAvailable = chartAvailable;
558         }
559         public ArrayList<Map<String,Object>> getReportDataRows() {
560                 return reportDataRows;
561         }
562         public void setReportDataRows(ArrayList<Map<String,Object>> reportDataRows) {
563                 this.reportDataRows = reportDataRows;
564         }
565         public String getReportID() {
566                 return reportID;
567         }
568         public void setReportID(String reportID) {
569                 this.reportID = reportID;
570         }
571         public String getReportName() {
572                 return reportName;
573         }
574         public void setReportName(String reportName) {
575                 this.reportName = reportName;
576         }
577         public String getReportDescr() {
578                 return reportDescr;
579         }
580         public void setReportDescr(String reportDescr) {
581                 this.reportDescr = reportDescr;
582         }
583         public String getReportTitle() {
584                 return reportTitle;
585         }
586         public void setReportTitle(String reportTitle) {
587                 this.reportTitle = reportTitle;
588         }
589         public String getReportSubTitle() {
590                 return reportSubTitle;
591         }
592         public void setReportSubTitle(String reportSubTitle) {
593                 this.reportSubTitle = reportSubTitle;
594         }
595         public boolean isAllowSchedule() {
596                 return allowSchedule;
597         }
598         public void setAllowSchedule(boolean allowSchedule) {
599                 this.allowSchedule = allowSchedule;
600         }
601         public ArrayList getFormFieldList() {
602                 return formFieldList;
603         }
604         public void setFormFieldList(ArrayList formFieldList) {
605                 this.formFieldList = formFieldList;
606         }
607         public String getFormfield_comments() {
608                 return formfield_comments;
609         }
610         public void setFormfield_comments(String formfield_comments) {
611                 this.formfield_comments = formfield_comments;
612         }
613         public ArrayList<ColumnHeader> getReportDataColumns() {
614                 return reportDataColumns;
615         }
616         public void setReportDataColumns(ArrayList<ColumnHeader> reportDataColumns) {
617                 this.reportDataColumns = reportDataColumns;
618         }
619
620         public int getTotalRows() {
621                 return totalRows;
622         }
623         public void setTotalRows(int totalRows) {
624                 this.totalRows = totalRows;
625         }
626         public int getPageSize() {
627                 return pageSize;
628         }
629         public void setPageSize(int pageSize) {
630                 this.pageSize = pageSize;
631         }
632         public String getSqlWhole() {
633                 return sqlWhole;
634         }
635         public void setSqlWhole(String sqlWhole) {
636                 this.sqlWhole = sqlWhole;
637         }
638         
639         public boolean isAllowEdit() {
640                 return allowEdit;
641         }
642         public void setAllowEdit(boolean allowEdit) {
643                 this.allowEdit = allowEdit;
644         }
645         public String getBackBtnURL() {
646                 return backBtnURL;
647         }
648         public void setBackBtnURL(String backBtnURL) {
649                 this.backBtnURL = backBtnURL;
650         }
651         public String getColIdxTobeFreezed() {
652                 return colIdxTobeFreezed;
653         }
654         public void setColIdxTobeFreezed(String colIdxTobeFreezed) {
655                 this.colIdxTobeFreezed = colIdxTobeFreezed;
656         }
657         public int getNumFormCols() {
658                 return numFormCols;
659         }
660         public void setNumFormCols(int numFormCols) {
661                 this.numFormCols = numFormCols;
662         }
663         public boolean isDisplayData() {
664                 return displayData;
665         }
666         public void setDisplayData(boolean displayData) {
667                 this.displayData = displayData;
668         }
669         public boolean isDisplayForm() {
670                 return displayForm;
671         }
672         public void setDisplayForm(boolean displayForm) {
673                 this.displayForm = displayForm;
674         }
675         public boolean isDisplayExcel() {
676                 return displayExcel;
677         }
678         public void setDisplayExcel(boolean displayExcel) {
679                 this.displayExcel = displayExcel;
680         }
681         public boolean isDisplayPDF() {
682                 return displayPDF;
683         }
684         public void setDisplayPDF(boolean displayPDF) {
685                 this.displayPDF = displayPDF;
686         }
687         public String getMessage() {
688                 return message;
689         }
690         public void setMessage(String message) {
691                 this.message = message;
692         }
693         public boolean isChartWizardAvailable() {
694                 return chartWizardAvailable;
695         }
696         public void setChartWizardAvailable(boolean chartWizardAvilable) {
697                 this.chartWizardAvailable = chartWizardAvilable;
698         }
699         public boolean isHideFormFieldsAfterRun() {
700                 return hideFormFieldsAfterRun;
701         }
702         public void setHideFormFieldsAfterRun(boolean hideFormFieldsAfterRun) {
703                 this.hideFormFieldsAfterRun = hideFormFieldsAfterRun;
704         }
705         
706    
707
708         
709 }