1 <app-sql-validate-changes-dialog-component [(visible)]="showDialog1">
2 <span *ngIf="showVerifySpinner" class="ecomp-spinner"></span>
3 <div *ngIf="!showVerifySpinner">
5 <div class="card-body" style="width: 800px; height: 615px; ">
6 <div style="height:600px; overflow: scroll;">
7 <div class="modalTitle">{{Validatestatus}}</div>
8 <button (click)="closeValidateModal()" *ngIf="Validateclosable" aria-label="Close"
9 class="dialog__close-btn">X
12 <app-sql-validate-success-dialog-component
13 [tableObj]="validateResponseString"></app-sql-validate-success-dialog-component>
14 <!-- <app-sql-validate-error-dialog-component *ngIf="!ValidatePostResponse.query" [tableObj] = "GetValidateResponseString()"></app-sql-validate-error-dialog-component> -->
17 <div class="card-footer" style="width: 800px;">
18 <button (click)="closeValidateModal()" class="btn btn-alt btn-small" style="font-size: 17px;">Close
23 </app-sql-validate-changes-dialog-component>
25 <app-form-fields-add-edit [(visible)]="showDialog">
27 <div class="card-header">
28 <div class="modalTitle">Report Form Field - Edit</div>
29 <button (click)="close()" *ngIf="closable" aria-label="Close" class="dialog__close-btn">X</button>
34 <div class="card-body" style="width: 100px; height: 760px; ">
35 <div style="height:737px; overflow: scroll; overflow-x: hidden;">
40 <label class="defaultLabelFontSize">Field Name:</label><label><input [(ngModel)]="fieldName"
41 class="defaultFontSize"
44 value="{{fieldName}}"/></label>
50 <div class="field-group">
51 <label>Field Type:</label>
52 <select [(ngModel)]="fieldType" class="browser-default custom-select defaultFontSize" id="fieldType"
53 required="required" value="{{fieldType}}">
54 <option class="defaultFontSize" selected>Select Field Type</option>
55 <option class="defaultFontSize" value="TEXT">Text Box</option>
56 <option class="defaultFontSize" value="TEXTAREA">TEXTAREA</option>
57 <option class="defaultFontSize" value="LIST_BOX">List Box</option>
58 <option class="defaultFontSize" value="LIST_MULTI_SELECT">Multi-select List Box</option>
59 <option class="defaultFontSize" value="HIDDEN">Hidden</option>
65 <div class="field-group">
66 <label>Visible:</label>
67 <select [(ngModel)]="visible" class="browser-default custom-select defaultFontSize" id="visible"
68 required="required" value="{{visible}}">
69 <option class="defaultFontSize" selected value="YES">YES</option>
70 <option class="defaultFontSize" value="NO">NO</option>
77 <label class="defaultLabelFontSize">Is used in Group By Clause?:</label>
78 <label class="defaultLabelFontSize" class="checkbox" for="groupFormField">
79 <input [(ngModel)]="groupFormField" class="ng-valid ng-dirty ng-valid-parse ng-touched"
81 type="checkbox" value="{{groupFormField}}"><i class="skin"></i><span></span>
88 <label class="defaultLabelFontSize">SQL as Default Value:</label>
89 <label class="defaultLabelFontSize" class="checkbox" for="isDefaultSql">
90 <input [(ngModel)]="isDefaultSql" class="ng-valid ng-dirty ng-valid-parse ng-touched"
92 type="checkbox" value="{{isDefaultSql}}"><i class="skin"></i><span></span>
96 <div *ngIf="isDefaultSql">
99 <div class="field-group">
100 <label>Default SQL:</label>
101 <textarea [(ngModel)]="fieldDefaultSQL" class="defaultFontSize" id="fieldDefaultSQL"
102 type="textarea" value="{{fieldDefaultSQL}}"></textarea>
104 <button (click)="verify('Default')" class="btn btn-alt btn-small verify-button">
111 <div *ngIf="(fieldDefaultSQL == null || fieldDefaultSQL == '') && isDefaultSql == false">
112 <label class="defaultLabelFontSize">Default Value:</label>
113 <label><input [(ngModel)]="defaultValue" class="defaultFontSize" id="defaultValue" type="text"
114 value="{{defaultValue}}"/></label>
121 <div class="field-group">
122 <label>Verify Field Value As:</label>
123 <select [(ngModel)]="validationType" class="browser-default custom-select defaultFontSize"
124 id="validationType" required="required" value="{{validationType}}">
125 <option class="defaultFontSize" selected value="">Select Visibility</option>
126 <option class="defaultFontSize" value="">Do Not Perform Validation</option>
127 <option class="defaultFontSize" value="INTEGER">Integer</option>
128 <option class="defaultFontSize" value="POSITIVE_INTEGER">Positive Integer</option>
129 <option class="defaultFontSize" value="DATE">Date</option>
130 <option class="defaultFontSize" value="TIMESTAMP_SEC">Timestamp(Hour, Min, Sec)</option>
131 <option class="defaultFontSize" value="TIMESTAMP_MIN">Timestamp(Hour, Min)</option>
132 <option class="defaultFontSize" value="TIMESTAMP_HOUR">Timestamp(Hour)</option>
133 <option class="defaultFontSize" value="NON_NEGATIVE_INTEGER">Positive Integer Can not Be Zero
135 <option class="defaultFontSize" value="FLOAT">Any Number</option>
136 <option class="defaultFontSize" value="NON_NEGATIVE_FLOAT">Positive Number</option>
137 <option class="defaultFontSize" value="POSITIVE_FLOAT">Positive Number Can Not Be Zero</option>
142 <div *ngIf='showDateRange || this.validationType === "DATE"'>
144 <label class="defaultLabelFontSize">SQL as Default Range Value:</label>
145 <label class="defaultLabelFontSize" class="checkbox" for="isDefaultSqlRange">
146 <input [(ngModel)]="isDefaultSqlRange" class="ng-valid ng-dirty ng-valid-parse ng-touched"
147 id="isDefaultSqlRange"
148 type="checkbox" value="{{isDefaultSqlRange}}"><i class="skin"></i><span></span>
153 <div *ngIf="!isDefaultSqlRange" class="field-group">
154 <label class="defaultLabelFontSize">rangeStartDate:</label>
156 <mat-form-field style="float: left;"><input [(ngModel)]="rangeStartDate"
157 [matDatepicker]="picker"
158 class="defaultFontSize" matInput>
159 <mat-datepicker-toggle [for]="picker" matSuffix></mat-datepicker-toggle>
160 <mat-datepicker #picker></mat-datepicker>
168 <div *ngIf="!isDefaultSqlRange" class="field-group">
169 <label class="defaultLabelFontSize">rangeEndDate:</label>
171 <mat-form-field style="float: left;"><input [(ngModel)]="rangeEndDate" [matDatepicker]="picker"
172 class="defaultFontSize" matInput>
173 <mat-datepicker-toggle [for]="picker" matSuffix></mat-datepicker-toggle>
174 <mat-datepicker #picker></mat-datepicker>
183 <div class="field-group" *ngIf="isDefaultSqlRange">
184 <label>RangeStartDate Sql:</label>
185 <textarea [(ngModel)]="rangeStartDateSQL" class="defaultFontSize" id="rangeStartDateSQL" type="textarea"
186 value="{{rangeStartDateSQL}}"></textarea>
188 <button (click)="verify('startDateRange')" class="btn btn-alt btn-small verify-button">Verify
196 <div class="field-group" *ngIf="isDefaultSqlRange">
197 <label>RangeEndDate Sql:</label>
198 <textarea [(ngModel)]="rangeEndDateSQL" class="defaultFontSize" id="rangeEndDateSQL" type="textarea"
199 value="{{rangeEndDateSQL}}"></textarea>
201 <button (click)="verify('endDateRange')" class="btn btn-alt btn-small verify-button">Verify
209 <div class="field-group">
210 <label>SQL Generating Custom List of Values:</label>
211 <textarea [(ngModel)]="fieldSQL" class="defaultFontSize" id="fieldSQL" type="textarea"
212 value="{{fieldSQL}}"></textarea>
214 <button (click)="verify('Regular')" class="btn btn-alt btn-small"
215 style="font-size: 17px;">Verify
222 <label class="defaultLabelFontSize">Provide Predefined List of Values: Do not use Predefined list -
223 Generate list from database:</label><label><input [(ngModel)]="predefinedValue"
224 class="defaultFontSize"
225 id="predefinedValue" type="text"
226 value="{{predefinedValue}}"/></label>
227 <button (click)="addToList(predefinedValue)" class="btn btn-alt btn-small" style="font-size: 17px;">
235 <div *ngFor="let value of predefinedValueList">
236 <div style="margin-left: 5px;">
237 <label>{{value.name}}</label>
238 <mat-icon (click)="deleteFromList(value.id)" aria-hidden="false" aria-label="delete">
247 <div class="card-footer" style="width: 1000px; padding-left: 770px;">
248 <button (click)="save();" *ngIf="!showConfirmButton" class="btn btn-alt btn-small" style="font-size: 17px;">
251 <button (click)="complete();" *ngIf="showConfirmButton" class="btn btn-alt btn-small"
252 style="font-size: 17px;">Confirm
253 </button>
254 <button (click)="close()" class="btn btn-alt btn-small" style="font-size: 17px;">Cancel</button>
259 </app-form-fields-add-edit>
262 <div class="stdForm">
264 <div class="tab-content">
265 <h3>Step 4 - Report Form Fields</h3>
268 <span *ngIf="showSpinner" class="ecomp-spinner"></span>
272 <h4>Form Field Groups</h4>
274 <div *ngFor="let group of Groups">
275 <button class="formFieldGroupButton" mat-button>{{group.name}}</button>
276 <mat-icon (click)="deleteGroup(group.name)" aria-hidden="false" aria-label="delete" style="margin-left: 21%;">
279 <mat-icon (click)="editGroup(group)" aria-hidden="false" aria-label="edit" class="edit-group">edit</mat-icon>
280 <table class="app-data-table" style="margin-top: 10px;">
282 <th class="defaultFontSize">Order Number</th>
283 <th class="defaultFontSize">Field Name</th>
284 <th class="defaultFontSize">Delete From Group</th>
286 <tr *ngFor="let item of group.formFieldList; let i = index;">
294 <mat-icon (click)="deleteFromGroup(item.id)" aria-hidden="false" aria-label="delete">delete
303 <div class="field-group">
304 <table style="width: auto; margin-left: 70%;">
307 <button (click)="createGroup()" class="btn btn-alt btn-small" style="font-size: 17px;">Create
312 <button (click)="saveFormFieldGroups()" class="btn btn-alt btn-small" style="font-size: 17px;">Save
321 <h4>Form Field List</h4>
322 <div *ngIf="!showSpinner">
324 <table class="app-data-table" style="margin-top: 10px;">
326 <th class="defaultFontSize">Order Number</th>
327 <th class="defaultFontSize">Field Name</th>
328 <th class="defaultFontSize">Edit</th>
329 <th class="defaultFontSize">Order</th>
330 <th class="defaultFontSize">Delete</th>
332 <tr *ngFor="let item of formFieldsListObj; let i = index;">
340 <mat-icon (click)="edit(item.id); setDisplayMode('Edit');" aria-hidden="false" aria-label="edit">
345 <mat-icon (click)="moveUpward(i)" *ngIf="!isFirst(i)" aria-hidden="false" aria-label="expand_less">
348 <mat-icon (click)="moveDownward(i)" *ngIf="!isLast(i)" aria-hidden="false" aria-label="expand_more">
353 <mat-icon (click)="delete(item.id)" aria-hidden="false" aria-label="delete">delete</mat-icon>
359 <table class="showbuttons">
362 <button (click)="add(); setDisplayMode('Add');" class="btn btn-alt btn-small add-reOrder-button">
367 <button (click)="reOrder()" *ngIf="showReOrderButton"
368 class="btn btn-alt btn-small add-reOrder-button">ReOrder