blob: 0121557645c87de7479ca59f2588510594c545c9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
<app-save-sql-changes-dialog-component [(visible)]="showSaveSQLDialog">
<div class="card">
<div class="card-body">
<div class="modalTitle">{{SQLstatus}}</div>
<button (click)="closeSaveModal()" *ngIf="SQLclosable" aria-label="Close" class="dialog__close-btn">X
</button>
<br/>
<label>{{SQLmessage}}</label>
</div>
<div class="card-footer">
<button (click)="showSaveSQLDialog = !showSaveSQLDialog" class="btns btns-alt btns-small close-model">Close
</button>
</div>
</div>
</app-save-sql-changes-dialog-component>
<app-sql-validate-changes-dialog-component [(visible)]="showValidateSQLDialog">
<div class="card">
<div class="card-body card-body-style">
<div class="div-scroll">
<div class="modalTitle">{{Validatestatus}}</div>
<div *ngIf="showErrorSqlMessage" [innerHTML]="errorMessageString"></div>
<button (click)="closeValidateModal()" *ngIf="Validateclosable" aria-label="Close"
class="dialog__close-btn">X
</button>
<br/>
<div *ngIf="ValidatePostResponse.query">
<app-sql-validate-success-dialog-component
[tableObj]="GetValidateResponseString()"></app-sql-validate-success-dialog-component>
</div>
<div *ngIf="ValidatePostResponse.errormessage">
<app-sql-validate-error-dialog-component
[tableObj]="GetValidateResponseString()"></app-sql-validate-error-dialog-component>
</div>
</div>
</div>
<div class="card-footer">
<button (click)="closeValidateModal()" class="btns btns-alt btns-small close-model">Close</button>
</div>
</div>
</app-sql-validate-changes-dialog-component>
<div class="stdForm">
<br/>
<div class="tab-content">
<h3>Step 2 - Report SQL</h3>
</div>
<br/>
<span *ngIf="showSpinner" class="ecomp-spinner"></span>
<div *ngIf="!showSpinner">
<div class="forms-group">
<div class="tab-pane">
<div class="field-group">
<label>Report SQL</label> <br/>
<textarea [(ngModel)]="sqlText" class="defaultFontSize textarea-sql" id="sqlText" name="sqlText" type="textarea"
value="{{finalGetObj['query']}}" autocomplete="on"></textarea>
<b> Keyword Assistance:<br>
<a href="javascript:;" (click)="addText('SELECT')">SELECT</a>
<a href="javascript:;" (click)="addText('DISTINCT')">DISTINCT</a>
<a href="javascript:;" (click)="addText('FROM')">FROM</a>
<a href="javascript:;" (click)="addText('WHERE')">WHERE</a>
<a href="javascript:;" (click)="addText('GROUP BY')">GROUP BY</a>
<a href="javascript:;" (click)="addText('ORDER BY')">ORDER BY</a>
<a href="javascript:;" (click)="addText('ASC')">ASC</a>
<a href="javascript:;" (click)="addText('DESC')">DESC</a>
<a href="javascript:;" (click)="addText('AND')">AND</a>
<a href="javascript:;" (click)="addText('OR')">OR</a>
<a href="javascript:;" (click)="addText('NOT')">NOT</a>
<a href="javascript:;" (click)="addText('EXISTS')">EXISTS</a>
<a href="javascript:;" (click)="addText('IS')">IS</a>
<a href="javascript:;" (click)="addText('NULL')">NULL</a>
<a href="javascript:;" (click)="addText('IN')">IN</a>
<a href="javascript:;" (click)="addText('BETWEEN')">BETWEEN</a> <br>
<a href="javascript:;" (click)="addText('COUNT(')">COUNT(</a>
<a href="javascript:;" (click)="addText('SUM(')">SUM(</a>
<a href="javascript:;" (click)="addText('AVG(')">AVG(</a>
<a href="javascript:;" (click)="addText('MAX(')">MAX(</a>
<a href="javascript:;" (click)="addText('MIN(')">MIN(</a>
<a href="javascript:;" (click)="addText('NVL(')">NVL(</a>
<a href="javascript:;" (click)="addText('DECODE(')">DECODE(</a>
<a href="javascript:;" (click)="addText('SYDATE')">SYSDATE</a>
<a href="javascript:;" (click)="addText('TO_CHAR')">TO_CHAR</a>
<a href="javascript:;" (click)="addText('TO_NUMBER(')">TO_NUMBER(</a>
<a href="javascript:;" (click)="addText('TO_DATE(')">TO_DATE(</a>
<a href="javascript:;" (click)="addText('TRUNC(')">TRUNC(</a>
<a href="javascript:;" (click)="addText('ROUND(')">ROUND(</a>
<a href="javascript:;" (click)="addText('ABS(')">ABS(</a>
<a href="javascript:;" (click)="addText('SUBSTR(')">SUBSTR(</a> <br>
<a href="javascript:;" (click)="addText('REPLACE(')">REPLACE(</a>
<a href="javascript:;" (click)="addText('LOWER(')">LOWER(</a>
<a href="javascript:;" (click)="addText('UPPER(')">UPPER(</a>
<a href="javascript:;" (click)="addText('LTRM(')">LTRM(</a>
<a href="javascript:;" (click)="addText('RTRIM(')">RTRIM(</a>
<a href="javascript:;" (click)="addText('LPAD(')">LPAD(</a>
<a href="javascript:;" (click)="addText('RPAD(')">RPAD(</a>
<a href="javascript:;" (click)="addText('(linkToReport, , , )')">linkToReport</a>
</b>
</div>
<div class="field-group">
<pre>
<div class="divider"></div><button (click)="validate()" class="btns btns-alt btns-small">Validate & Save</button>
</pre>
</div>
<br/>
<br/>
</div>
</div>
</div>
<style scoped>
h1 {
font-size: 16px;
}
</style>
|