removing unused db file
[policy/engine.git] / ecomp-sdk-app / src / main / webapp / WEB-INF / fusion / raptor / wizard_map.jsp
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 <%@ page import="org.openecomp.portalsdk.analytics.xmlobj.DataColumnType" %>
21 <%@ page import="org.openecomp.portalsdk.analytics.util.AppConstants" %>
22 <%@ page import="org.openecomp.portalsdk.analytics.model.definition.ReportDefinition" %>
23 <%@ page import="org.openecomp.portalsdk.analytics.system.AppUtils" %>
24 <%@ page import="org.openecomp.portalsdk.analytics.controller.WizardSequence" %>
25 <%@ page import="java.util.List" %>
26 <%@ page import="java.util.Iterator" %>
27 <%@page import="org.openecomp.portalsdk.analytics.xmlobj.ReportMap"%>
28 <%
29     ReportDefinition rdef = (ReportDefinition) request.getAttribute(AppConstants.SI_REPORT_DEFINITION);
30     WizardSequence ws = rdef.getWizardSequence();
31         boolean isCrossTab = rdef.getReportType().equals(AppConstants.RT_CROSSTAB);
32         boolean isSQLBased = rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED);    
33         ReportMap repMap = rdef.getReportMap();
34         String addressColumn = "";
35         String latColumn = "";
36         String longColumn = "";
37         String legendColumn = "";
38         String colorColumn = "";
39         String dataColumn = "";
40         String isMapAllowed = "";
41         String addAddress = "N";
42         String useDefaultSize = "";
43         String width = "";
44         String height = "";
45
46         int reportMapSize = 0;
47         if (repMap != null){
48                 if (repMap.getAddressColumn() != null)
49                         addressColumn = repMap.getAddressColumn();
50                 
51                 if (repMap.getDataColumn() != null)
52                         dataColumn = repMap.getDataColumn();
53                 if (repMap.getIsMapAllowedYN() != null)
54                         isMapAllowed = repMap.getIsMapAllowedYN();
55                 if (repMap.getAddAddressInDataYN() != null)
56                         addAddress = repMap.getAddAddressInDataYN();
57                 if (repMap.getLatColumn() != null)
58                         latColumn = repMap.getLatColumn();
59                 if (repMap.getLongColumn() != null)
60                         longColumn = repMap.getLongColumn();
61                 if (repMap.getColorColumn() != null)
62                         colorColumn = repMap.getColorColumn();
63                 if (repMap.getLegendColumn() != null)
64                         legendColumn = repMap.getLegendColumn();
65                 if (repMap.getUseDefaultSize() != null)
66                         useDefaultSize = repMap.getUseDefaultSize();
67                 if (repMap.getHeight() != null)
68                         height = repMap.getHeight();
69                 if (repMap.getWidth() != null)
70                         width = repMap.getWidth();
71                 
72                 reportMapSize = repMap.getMarkers().size();
73         }
74         
75 %>
76 <%@page import="org.openecomp.portalsdk.analytics.xmlobj.Marker"%>
77
78 <script>
79 function enable_text(status)
80 {
81 //status=!status; 
82 document.forma.height.disabled = status;
83 document.forma.width.disabled = status;
84 }
85
86 function isNumberKey(evt)
87 {
88
89   if (document.forma.useDefaultSize.checked==true)
90   {
91           document.forma.height.disabled = status;
92           document.forma.width.disabled = status;
93           return false;
94   }
95                         
96    var charCode = (evt.which) ? evt.which : event.keyCode
97    if (charCode > 31 && (charCode < 48 || charCode > 57))
98       return false;
99
100    return true;
101 }
102
103
104 function checkValue()
105 {
106            
107            if (document.forma.isMapAllowed.checked==false)
108            {
109                   return true;
110            }
111            if (document.forma.useDefaultSize.checked==true)
112            {
113                   return true;
114            }
115            if ((document.forma.height.value < 1) )
116            {
117                    alert(document.forma.height.name + ' can not be zero');
118                    document.forma.height.focus(); return false;
119            } 
120            if ((document.forma.width.value < 1) )
121            {
122                    alert(document.forma.width.name + ' can not be zero');
123                    document.forma.width.focus(); return false;
124            } 
125            return true;
126 }
127
128 </script>
129 <table class=mTAB width="100%" class="tableBorder" border="0" cellspacing="1" cellpadding="3" align=center>
130         <tr>
131                 <td class=rbg1 colspan=8 valign="Middle"><b class=rtableheader>Step <%= ws.getCurrentStepIndex() %> of <%= ws.getStepCount() %> - Report <%= ws.getCurrentStep() %></b></td>
132         </tr>
133         <tr class=rbg1>
134                 
135         </tr>
136         <tr>
137                 <td align="left" width="10%">Map Enabled ?</td>
138                 <td colspan=8>
139                         <input id = "isMapAllowed" name="isMapAllowed" type="checkbox" value="Y" <%if(isMapAllowed != null && isMapAllowed.equals("Y")){ %> checked <%} %>/>
140                 </td>
141         </tr>
142         
143                 <tr>
144                 <td align="left" width="10%">Default Size ?</td>
145                 <td width="15%">
146                         <input id = "useDefaultSize" name="useDefaultSize" type="checkbox" 
147                          onclick="enable_text(this.checked)" 
148                         value="Y" <%if(useDefaultSize != null && useDefaultSize.equals("Y")){ %> checked <%} %>/>
149                 </td>
150                 
151                 <td align="left" width="10%">Height </td>
152                 <td width="15%">
153                         <input id = "height" name="height" onkeypress="return isNumberKey(event)"   type="textbox" value="<%=height%> "   />
154                         <!-- 
155                         <input id = "dummy" name=""dummy" type="textbox"  visible="false"  />
156                          -->
157                          <input type="hidden" name="checkbox" value="checked">
158                 </td>
159                 
160                 <td align="left" width="10%">Width </td>
161                 <td width="15%">
162                         <input id = "width" name="width"  onkeypress="return isNumberKey(event)"    type="textbox" value="<%=width%> "    />
163                 </td>
164                 <td colspan="2">&nbsp;</td>
165         </tr>
166         
167         
168         <tr>
169                 <td align="left" width="10%">Lat Column</td>
170                 <td width="15%">
171                         <select name="latColumn">
172                                 <option value=""> --Select-- </option>
173 <%
174                                 int iCount = 0;
175                                 List reportCols = rdef.getAllColumns();
176                                 Iterator iter = reportCols.iterator();
177                                 for(; iter.hasNext(); iCount++) { 
178                                         DataColumnType dct = (DataColumnType) iter.next();
179 %>                              
180                                         <option value="<%= dct.getColId() %>" <%if(latColumn.equals(dct.getColId())){ %> selected <%}%> ><%= dct.getDisplayName() %></option>
181 <%
182                                 }
183 %>
184                         </select>
185                 
186                 
187                 </td>
188                 
189                 <td align="left" width="10%">Long Column</td>
190                 <td width="15%">
191                         <select name="longColumn">
192                                 <option value=""> --Select-- </option>
193 <%
194                                 iCount = 0;
195                                 iter = reportCols.iterator();
196                                 for(; iter.hasNext(); iCount++) { 
197                                         DataColumnType dct = (DataColumnType) iter.next();
198 %>                              
199                                         <option value="<%= dct.getColId() %>" <%if(longColumn.equals(dct.getColId())){ %> selected <%}%> ><%= dct.getDisplayName() %></option>
200 <%
201                                 }
202 %>
203                         </select>
204                 
205                 
206                 </td>
207                 <td align="left" width="10%">Color Column</td>
208                 <td width="15%">
209                         <select name="colorColumn">
210                                 <option value=""> --Select-- </option>
211 <%
212                                 iCount = 0;
213                                 iter = reportCols.iterator();
214                                 for(; iter.hasNext(); iCount++) { 
215                                         DataColumnType dct = (DataColumnType) iter.next();
216 %>                              
217                                         <option value="<%= dct.getColId() %>" <%if(colorColumn.equals(dct.getColId())){ %> selected <%}%> ><%= dct.getDisplayName() %></option>
218 <%
219                                 }
220 %>
221                         </select>
222                 
223                 
224                 </td>
225                 <td align="left" width="10%">Legend Column</td>
226                 <td width="15%">
227                         <select name="legendColumn">
228                                 <option value=""> --Select-- </option>
229 <%
230                                 iCount = 0;
231                                 iter = reportCols.iterator();   
232                                 for(; iter.hasNext(); iCount++) { 
233                                         DataColumnType dct = (DataColumnType) iter.next();                              
234 %>
235                                         <option value="<%= dct.getColId() %>" <%if(legendColumn.equals(dct.getColId())){ %> selected <%}%> ><%= dct.getDisplayName() %></option>
236 <%
237                                 }
238 %>
239                         </select>
240                 
241                 
242                 </td>
243                 
244         </tr>
245         <tr>
246                 <td align="left" width="10%">&nbsp;</td>
247                 <td colspan=7>
248                         <input type="button" value="Add Marker Details" onclick="javascript:createClicked();"/>
249                 </td>
250         </tr>
251         <input type="hidden" name="markerCount" id="markerCount" value="<%=reportMapSize%>" />
252         <tr style="display:none;" id="cloneableRow">
253                                         
254                 <td align="left" width="10%">Data Header </td>
255                 <td width="15%">
256                         <input type="text" name="dataHeader" value="" />
257                 
258                 </td>
259                 <td align="left" width="10%">Display Column</td>
260                 <td width="15%">
261                         <select name="dataColumn">
262                                 <option value=""> --Select-- </option>
263 <%
264                                 iCount = 0;
265                                 iter = reportCols.iterator();   
266                                 for(; iter.hasNext(); iCount++) { 
267                                         DataColumnType dct = (DataColumnType) iter.next();                              
268 %>
269                                         <option value="<%= dct.getColId() %>" <%if(dataColumn.equals(dct.getColId())){ %> selected <%}%> ><%= dct.getDisplayName() %></option>
270 <%
271                                 }
272 %>
273                         </select>
274                 
275                 
276                 </td>           
277                 <td width="5%">
278                         <img onclick="javascript:deleteRow(this);" height="12" alt="Remove" width="12" src="<%=AppUtils.getImgFolderURL()%>deleteicon.gif" border="0" value="" />
279                 </td>
280             <td colspan="3">&nbsp;</td>
281         </tr>
282         
283         
284 <%              for (int i = 1; repMap != null && i < repMap.getMarkers().size(); i ++){ 
285                 Marker marker = (Marker) repMap.getMarkers().get(i);
286 %>
287                 <tr>
288                 <td align="left" width="10%">Data Header</td>
289                 <td width="15%">
290                         <input type="text" name="dataHeader<%=i%>" value="<%=marker.getDataHeader()%>" />
291                 </td>
292                 
293                 <td align="left" width="10%">Display Column</td>
294                 <td width="15%">
295                         <select name="dataColumn<%=i%>">
296                                 <option value=""> --Select-- </option>
297 <%
298                                 iCount = 0;
299                                 iter = reportCols.iterator();   
300                                 for(; iter.hasNext(); iCount++) { 
301                                         DataColumnType dct = (DataColumnType) iter.next();                              
302 %>
303                                         <option value="<%= dct.getColId() %>" <%if(marker.getDataColumn().equals(dct.getColId())){ %> selected <%}%> ><%= dct.getDisplayName() %></option>
304 <%
305                                 }
306 %>
307                         </select>
308                 
309                 
310                 </td>
311                 <td width="5%">
312                         <img onclick="javascript:deleteRow(this);" height="12" alt="Remove" width="12" src="<%=AppUtils.getImgFolderURL()%>deleteicon.gif" border="0" value="" />
313                 </td>
314                 <td colspan="3">&nbsp;</td>
315                 </tr>
316                 <%}%>
317
318         
319         
320 </table>
321 <br>
322
323 <script >
324
325 function createClicked() {
326         var alreadyEditable = "New";
327         
328         var row = document.getElementById('cloneableRow');
329         var newR = duplicateRowByIndex(row, 0);
330         var tbl = getParentTable(newR);
331         var editIndex = 0;
332         if (document.all.markerCount != null || document.all.markerCount.value != ""){
333                 editIndex = document.all.markerCount.value;
334         }
335         if (tbl.rows.length%2 == 0){
336                 newR.className="alternateRow";
337         }
338         for (var xx = 0; xx < newR.cells.length; xx ++){
339                 for (var yy=0; yy < newR.cells[xx].childNodes.length; yy++){
340                         if (newR.cells[xx].childNodes[yy] != null 
341                                 && newR.cells[xx].childNodes[yy].name){
342                                 newR.cells[xx].childNodes[yy].name = "" + newR.cells[xx].childNodes[yy].name + editIndex;
343                                 newR.cells[xx].childNodes[yy].id = newR.cells[xx].childNodes[yy].name ;
344                         }
345                 }
346         }
347         editIndex = parseInt(editIndex) + parseInt(1);
348         document.all.markerCount.value = editIndex;
349         newR.style.display = "block";
350         //document.getElementById('scrollableTable').scrollTop =0;
351     return false;
352 }  
353
354 function deleteRow(item){
355         var row = getParentRow(item);
356         var tab = getParentTable(row);
357         tab.deleteRow(row.rowIndex);
358         
359 }
360
361 duplicateRowByIndex = function()
362 {
363         if(arguments.length == 0 ) { return };
364         pRow = arguments[0];
365         var tbl = getParentTable(pRow);
366         var newRowIndex = 1 ;
367         if(arguments[1] && parseInt(arguments[1]) != NaN )
368         {
369                 newRowIndex = parseInt(arguments[1]);
370                 if(newRowIndex == 0 ){ newRowIndex = tbl.rows.length - 1 ; }
371         }
372
373         if(pRow == null) { return ; }
374         var oldRow = pRow;
375         var newRow = oldRow.cloneNode(true);
376         if (arguments[1] == 0){
377                 oldRow.parentNode.insertBefore(newRow, oldRow.nextSibling);
378         }
379         else{
380                 oldRow.parentNode.insertBefore(newRow, tbl.rows[newRowIndex]);
381         }
382         newRow.id = "";
383         return newRow;
384 }
385
386 function getParentRow(cell)
387 {
388         var pNode = cell.parentNode;
389         for( var xx = 0 ; xx < 10 ; xx++)
390         {
391                 if(pNode.cells) { return pNode;}
392                 else { pNode = pNode.parentNode; }
393         }
394         alert("Unable to find parent row"); return false;
395 }
396
397 function getParentTable(row)
398 {
399         var pNode = row.parentNode;
400         for( var xx = 0 ; xx < 10 ; xx++)
401         {
402
403                 if(pNode.rows && (pNode.tagName == "TABLE" || pNode.tagName == "table")) {return pNode;}
404                 else { pNode = pNode.parentNode; }
405         }
406         alert("Unable to find parent table"); return false;
407 }
408
409
410
411 function dataValidate() {
412         return checkValue();
413         //return true;
414 }
415
416 </script>
417
418
419
420
421 <%!
422         private String nvl(String s)                  { return (s==null)?"":s; }
423         private String nvl(String s, String sDefault) { return nvl(s).equals("")?sDefault:s; } 
424 %>