1 <app-save-sql-changes-dialog-component [(visible)]="showSaveColDialog">
4 <div class="card-body" style="height: 200px;">
5 <div class="modalTitle">{{EditColstatus}}</div>
6 <button *ngIf="SQLclosable" (click)="close()" aria-label="Close" class="dialog__close-btn">X</button>
8 <h4>{{EditColmessage}}</h4>
10 <div class="card-footer"style="width: 500px;">
11 <button (click)="showSaveColDialog = !showSaveColDialog; showDialog!=showDialog;" class="btn btn-alt btn-small">Close</button>
14 </app-save-sql-changes-dialog-component>
16 <app-columns-edit-component [(visible)]="showDialog">
18 <div class="card-header">
19 <div class="modalTitle">{{message}}</div>
20 <button *ngIf="closable" (click)="close()" aria-label="Close" class="dialog__close-btn">X</button>
23 <div class="card-body" style="width: 1000px; height: 532px; ">
24 <div style="height:500px; overflow: scroll;">
25 <div class="tab-pane">
26 <div class="field-group">
27 <label class="defaultFontSize1">Column ID:</label><label class="boxMargin defaultFontSize">{{finalEditRowGetObj.colId}}</label>
32 <label class="defaultFontSize1">Column Name:</label><label class="boxMargin defaultFontSize">{{finalEditRowGetObj.colName}}</label>
37 <label class="defaultFontSize1">Depends on formfield:</label><label><input class=" defaultFontSize" id="depeondsOnForField" type="text" [(ngModel)]="dependsOnFormFields" value="{{finalEditRowGetObj.depeondsOnForField}}"/></label>
42 <label class="defaultFontSize1" for="dataType">Data Type:</label>
43 <select class="browser-default custom-select" required="required" placeholder="Select Report Type" [(ngModel)]="dataType" value="{{finalEditRowGetObj.dataType}}">
44 <option class="defaultFontSize1" selected>Select Data Type </option>
45 <option class="defaultFontSize1" value="Number" >Number</option>
46 <option class="defaultFontSize1" value="Date" >Date</option>
47 <option class="defaultFontSize1" value="Character" >Character</option>
48 <option class="defaultFontSize1" value="Hyperlink" >Hyperlink</option>
53 <label class="defaultFontSize1">Group By Pos:</label><label><input class="defaultFontSize" id="groupByPos" type="text" [(ngModel)]="groupByPos" value="{{finalEditRowGetObj.groupByPos}}"/></label>
58 <label class="defaultFontSize1">Custom Text for Sub-Total:</label><label><input class="defaultFontSize" id="subTotalCustomText" type="text" [(ngModel)]="customTextForSubTotal" value="{{finalEditRowGetObj.subTotalCustomText}}"/></label>
63 <label class="defaultFontSize1">Hide Repeated Values:</label>
64 <label class="defaultFontSize1" for="hideFormFieldsAfterRun" class="checkbox">
65 <input id="hideFormFieldsAfterRun" type="checkbox" class="ng-valid ng-dirty ng-valid-parse ng-touched" [(ngModel)]="hideRepeatedValues" value="{{finalEditRowGetObj.hideRepeatedKey}}"><i class="skin"></i><span></span>
71 <label class="defaultFontSize1">Multi Group Column Level:</label>
72 <label><select class="browser-default custom-select defaultFontSize" required="required" placeholder="Select Report Type" [(ngModel)]="multiGroupColumnLevel" value="{{finalEditRowGetObj.multiGroupColumnLevel}}">
73 <option class="defaultFontSize1" selected>Select Level </option>
74 <option class="defaultFontSize1" value="1" >1</option>
75 <option class="defaultFontSize1" value="2" >2</option>
76 <option class="defaultFontSize1" value="3" >3</option>
77 <option class="defaultFontSize1" value="4" >4</option>
84 <label class="defaultFontSize1">Multi group Column Range : Colspan:</label><label><input class="defaultFontSize" id="colspan" type="text" [(ngModel)]="colspan" value="{{finalEditRowGetObj.colspan}}"/></label>
89 <label class="displayName">Display Name:</label><label><input class="defaultFontSize" id="displayName" type="text" [(ngModel)]="displayName" value="{{finalEditRowGetObj.displayName}}"/></label>
94 <label class="defaultFontSize1">Display Width (In Pxls):</label><label><input class="defaultFontSize" id="displayWidthInPixel" type="text" [(ngModel)]="displayWidthInPixel" value="{{finalEditRowGetObj.displayWidthInPixel}}"/></label>
99 <label class="defaultFontSize1">No Wrap ?:</label>
100 <label class="defaultFontSize" for="noWrap" class="checkbox">
101 <input id="noWrap" type="checkbox" class="ng-valid ng-dirty ng-valid-parse ng-touched" [(ngModel)]="noWrap" value="{{finalEditRowGetObj.noWrap}}"><i class="skin"></i><span></span>
107 <label class="defaultFontSize1">Indent Parameter to display value:</label>
108 <label><select class="browser-default custom-select defaultFontSize" required="required" placeholder="Select Indent" [(ngModel)]="indentation" value="{{finalEditRowGetObj.indentation}}">
109 <option class="defaultFontSize" selected>Select Indent </option>
110 <option class="defaultFontSize" value="1" >1</option>
111 <option class="defaultFontSize" value="2" >2</option>
112 <option class="defaultFontSize" value="3" >3</option>
119 <label class="defaultFontSize1">Display Alignment:</label>
120 <label><select class="browser-default custom-select defaultFontSize" required="required" placeholder="Select Report Type" [(ngModel)]="displayAlignment" value="{{finalEditRowGetObj.displayAlignment}}">
121 <option class="defaultFontSize" selected>Select Alignment </option><option value="Left" >Left</option>
122 <option class="defaultFontSize" value="Center" >Center</option>
123 <option class="defaultFontSize" value="Right" >Right</option>
130 <label class="defaultFontSize1">Display Header Alignment:</label>
131 <label><select class="browser-default custom-select defaultFontSize" required="required" placeholder="Select Report Type" [(ngModel)]="displayHeaderAlignment" value="{{finalEditRowGetObj.displayHeaderAlignment}}">
132 <option selected>Select Header Alignment </option>
133 <option value="Left" >Left</option>
134 <option value="Center" >Center</option>
135 <option value="Right" >Right</option>
142 <label class="defaultFontSize1">Sortable:</label>
143 <label class="defaultFontSize" for="sortable" class="checkbox">
144 <input id="sortable" type="checkbox" class="ng-valid ng-dirty ng-valid-parse ng-touched" [(ngModel)]="sortable" value="{{finalEditRowGetObj.sortable}}"><i class="skin"></i><span></span>
150 <label class="defaultFontSize1">Visible:</label>
151 <label class="defaultFontSize" for="visible" class="checkbox">
152 <input id="visible" type="checkbox" class="ng-valid ng-dirty ng-valid-parse ng-touched" [(ngModel)]="visible" value="true"><i class="skin"></i><span></span>
158 <label class="defaultFontSize1">Drill-down Link: <mat-icon aria-hidden="false" aria-label="edit" (click)="drillDownLinkPage()">edit</mat-icon> </label>
159 <label><select class="browser-default custom-select defaultFontSize" required="required" placeholder="Select Report Type" [(ngModel)]="drilldownURL" value="{{finalEditRowGetObj.drilldownURL}}">
160 <option class="defaultFontSize" selected>Select Drill Down Link </option>
161 <option class="defaultFontSize" *ngFor="let URLObj of URLListObjArray" value="{{URLObj.name}}" >{{URLObj.name}}</option>
168 <label class="defaultFontSize1">Total for the column:</label>
169 <label><select class="browser-default custom-select defaultFontSize" required="required" placeholder="Select Report Type" [(ngModel)]="displayTotal" value="{{finalEditRowGetObj.displayTotal}}">
170 <option selected>Select Total </option>
171 <option *ngFor="let TotalListObj of TotalColListObjArray" value="{{TotalListObj.id}}" >{{TotalListObj.id}}</option>
178 <div class="card-footer" style="width: 1000px; padding-left: 820px;">
179 <button (click)="save();" class="btn btn-alt btn-small">Save</button>
180 <button (click)="showDialog = !showDialog" class="btn btn-alt btn-small">Cancel</button>
183 </app-columns-edit-component>
185 <div class="app-data-table" >
187 <table mat-table class="full-width-table app-data-table" matSort aria-label="Elements">
189 <ng-container matColumnDef="id">
190 <th mat-header-cell *matHeaderCellDef mat-sort-header class="defaultFontSize">ID</th>
191 <td mat-cell *matCellDef="let row">{{row.id}}</td>
195 <ng-container matColumnDef="no">
196 <th mat-header-cell *matHeaderCellDef mat-sort-header class="defaultFontSize">NO</th>
197 <td mat-cell *matCellDef="let row">{{row.no}}</td>
201 <ng-container matColumnDef="name">
202 <th mat-header-cell *matHeaderCellDef mat-sort-header class="defaultFontSize">NAME</th>
203 <td mat-cell *matCellDef="let row">{{row.name}}</td>
207 <ng-container matColumnDef="edit">
208 <th mat-header-cell *matHeaderCellDef mat-sort-header class="defaultFontSize">EDIT</th>
209 <td mat-cell *matCellDef="let row"><mat-icon aria-hidden="false" aria-label="edit" (click)="editRecord(row.id)">edit</mat-icon></td>
213 <tr mat-header-row *matHeaderRowDef="displayedColumns"></tr>
214 <tr mat-row *matRowDef="let row; columns: displayedColumns;"></tr>
217 <mat-paginator #paginator
218 [length]="dataSource?.data.length"
221 [pageSizeOptions]="[25, 50, 100, 250]">