1 <app-sql-validate-changes-dialog-component [(visible)]="showDialog1">
2 <div *ngIf="showVerifySpinner">
3 <div class="lds-ring"><div></div><div></div><div></div><div></div></div>
5 <div *ngIf="!showVerifySpinner">
7 <div class="card-body" style="width: 800px; height: 615px; ">
8 <div style="height:600px; overflow: scroll;">
9 <div class="modalTitle">{{Validatestatus}}</div>
10 <button *ngIf="Validateclosable" (click)="closeValidateModal()" aria-label="Close" class="dialog__close-btn">X</button>
12 <app-sql-validate-success-dialog-component [tableObj] = "validateResponseString"></app-sql-validate-success-dialog-component>
13 <!-- <app-sql-validate-error-dialog-component *ngIf="!ValidatePostResponse.query" [tableObj] = "GetValidateResponseString()"></app-sql-validate-error-dialog-component> -->
16 <div class="card-footer" style="width: 800px;">
17 <button style="font-size: 17px;" (click)="closeValidateModal()" class="btn btn-alt btn-small">Close</button>
21 </app-sql-validate-changes-dialog-component>
23 <app-form-fields-add-edit [(visible)]="showDialog" >
25 <div class="card-header">
26 <div class="modalTitle">Report Form Field - Edit</div>
27 <button *ngIf="closable" (click)="close()" aria-label="Close" class="dialog__close-btn">X</button>
32 <div class="card-body" style="width: 1000px; height: 770px; ">
33 <div style="height:765px; overflow: scroll;">
38 <label class="defaultFontSize1">Field Name:</label><label><input class="defaultFontSize" id="fieldName" type="text" [(ngModel)]="fieldName" value="{{fieldName}}"/></label>
45 <div class="field-group">
46 <label>Field Type:</label>
47 <select class="browser-default custom-select defaultFontSize" id="fieldType" required="required" [(ngModel)]="fieldType" value="{{fieldType}}">
48 <option class="defaultFontSize" selected>Select Field Type </option>
49 <option class="defaultFontSize" value="TEXT">Text Box</option>
50 <option class="defaultFontSize" value="TEXTAREA">TEXTAREA</option>
51 <option class="defaultFontSize" value="LIST_BOX">List Box</option>
52 <option class="defaultFontSize" value="LIST_MULTI_SELECT">Multi-select List Box</option>
53 <option class="defaultFontSize" value="HIDDEN">Hidden</option>
59 <div class="field-group">
60 <label>Visible:</label>
61 <select class="browser-default custom-select defaultFontSize" id="visible" required="required" [(ngModel)]="visible" value="{{visible}}">
62 <option class="defaultFontSize" value="YES" selected>YES</option>
63 <option class="defaultFontSize" value="NO">NO</option>
70 <label class="defaultFontSize1">Is used in Group By Clause?:</label>
71 <label class="defaultFontSize1" for="groupFormField" class="checkbox">
72 <input id="groupFormField" type="checkbox" class="ng-valid ng-dirty ng-valid-parse ng-touched" [(ngModel)]="groupFormField" value="{{groupFormField}}"><i class="skin"></i><span></span>
79 <label class="defaultFontSize1">SQL as Default Value:</label>
80 <label class="defaultFontSize1" for="defaultValue" class="checkbox">
81 <input id="defaultValue" type="checkbox" class="ng-valid ng-dirty ng-valid-parse ng-touched" [(ngModel)]="defaultValue" value="{{defaultValue}}"><i class="skin"></i><span></span>
85 <div *ngIf="defaultValue">
88 <div class="field-group">
89 <label>Default SQL:</label>
90 <textarea class="defaultFontSize" id="fieldDefaultSQL" type="textarea" [(ngModel)]="fieldDefaultSQL" value="{{fieldDefaultSQL}}"></textarea>
91 <button style="font-size: 17px;" (click)="verify('Default')" class="btn btn-alt btn-small">Verify</button>
98 <div class="field-group">
99 <label>Verify Field Value As:</label>
100 <select class="browser-default custom-select defaultFontSize" id="validationType" required="required" [(ngModel)]="validationType" value="{{validationType}}">
101 <option class="defaultFontSize" value="" selected>Select Visibility </option>
102 <option class="defaultFontSize" value="">Do Not Perform Validation</option>
103 <option class="defaultFontSize" value="INTEGER">Integer</option>
104 <option class="defaultFontSize" value="POSITIVE_INTEGER">Positive Integer</option>
105 <option class="defaultFontSize" value="DATE">Date</option>
106 <option class="defaultFontSize" value="TIMESTAMP_SEC">Timestamp(Hour, Min, Sec)</option>
107 <option class="defaultFontSize" value="TIMESTAMP_MIN">Timestamp(Hour, Min)</option>
108 <option class="defaultFontSize" value="TIMESTAMP_HOUR">Timestamp(Hour)</option>
109 <option class="defaultFontSize" value="NON_NEGATIVE_INTEGER">Positive Integer Can not Be Zero</option>
110 <option class="defaultFontSize" value="FLOAT">Any Number</option>
111 <option class="defaultFontSize" value="NON_NEGATIVE_FLOAT">Positive Number</option>
112 <option class="defaultFontSize" value="POSITIVE_FLOAT">Positive Number Can Not Be Zero</option>
117 <div class="field-group">
118 <label>SQL Generating Custom List of Values:</label>
119 <textarea class="defaultFontSize" id="fieldSQL" type="textarea" [(ngModel)]="fieldSQL" value="{{fieldSQL}}"></textarea>
120 <button style="font-size: 17px;" (click)="verify('Regular')" class="btn btn-alt btn-small">Verify</button>
125 <label class="defaultFontSize1">Provide Predefined List of Values: Do not use Predefined list - Generate list from database:</label><label><input class="defaultFontSize" id="predefinedValue" type="text" [(ngModel)]="predefinedValue" value="{{predefinedValue}}"/></label>
126 <button style="font-size: 17px;" (click)="addToList(predefinedValue)" class="btn btn-alt btn-small">Add to List</button>
132 <div *ngFor="let value of predefinedValueList">
133 <div style="margin-left: 5px;">
134 <label >{{value.name}}</label>
135 <mat-icon aria-hidden="false" aria-label="delete" (click)="deleteFromList(value.id)">delete</mat-icon>
142 <div class="card-footer" style="width: 1000px; padding-left: 770px;">
143 <button style="font-size: 17px;" *ngIf="!showConfirmButton" (click)="save();" class="btn btn-alt btn-small">Save</button>
144 <button style="font-size: 17px;" *ngIf="showConfirmButton" (click)="complete();" class="btn btn-alt btn-small">Confirm</button>
145 <button style="font-size: 17px;" (click)="close()" class="btn btn-alt btn-small">Cancel</button>
150 </app-form-fields-add-edit>
153 <div class="stdForm">
155 <div class="tab-content">
156 <h1>Step 4 - Report Form Fields</h1>
160 <div *ngIf="showSpinner">
161 <div class="lds-ring"><div></div><div></div><div></div><div></div></div>
166 <h3>Form Field Groups</h3>
168 <div *ngFor="let group of Groups">
169 <button class="formFieldGroupButton" mat-button >{{group.name}}</button><mat-icon style="margin-left: 21%;" aria-hidden="false" aria-label="delete" (click)="deleteGroup(group.name)">delete</mat-icon>
170 <table style="margin-top: 10px;" class="app-data-table">
172 <th class="defaultFontSize">Order Number</th>
173 <th class="defaultFontSize">Field Name</th>
174 <th class="defaultFontSize">Delete From Group</th>
176 <tr *ngFor="let item of group.formFieldList; let i = index;">
184 <mat-icon aria-hidden="false" aria-label="delete" (click)="deleteFromGroup(item.id)">delete</mat-icon>
192 <div class="field-group">
193 <table style="width: auto; margin-left: 70%;">
195 <td><button style="font-size: 17px;" class="btn btn-alt btn-small" (click)="createGroup()" >Create Group</button></td>
196 <td><button style="font-size: 17px;" class="btn btn-alt btn-small" (click)="saveFormFieldGroups()" >Save Group</button></td>
201 <h3>Form Field List</h3>
202 <div *ngIf="!showSpinner">
204 <table style="margin-top: 10px;" class="app-data-table">
206 <th class="defaultFontSize">Order Number</th>
207 <th class="defaultFontSize">Field Name</th>
208 <th class="defaultFontSize">Edit</th>
209 <th class="defaultFontSize">Order</th>
210 <th class="defaultFontSize">Delete</th>
212 <tr *ngFor="let item of formFieldsListObj; let i = index;">
220 <mat-icon aria-hidden="false" aria-label="edit" (click)="edit(item.id); setDisplayMode('Edit');">edit</mat-icon>
223 <mat-icon *ngIf="!isFirst(i)" aria-hidden="false" aria-label="expand_less" (click)="moveUpward(i)">expand_less</mat-icon>
224 <mat-icon *ngIf="!isLast(i)" aria-hidden="false" aria-label="expand_more" (click)="moveDownward(i)">expand_more</mat-icon>
227 <mat-icon aria-hidden="false" aria-label="delete" (click)="delete(item.id)">delete</mat-icon>
234 <div class="field-group">
235 <button style="font-size: 17px; margin-left: 80%;" class="btn btn-alt btn-small" (click)="add(); setDisplayMode('Add');" >Add</button>