diff options
Diffstat (limited to 'ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql')
3 files changed, 62 insertions, 57 deletions
diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.css b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.css index fb9d85b8..bf51ea3a 100644 --- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.css +++ b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.css @@ -71,7 +71,7 @@ input { line-height: normal; } -.btn { +.btns { background-color: transparent; background-clip: padding-box; border: 1px solid transparent; @@ -80,7 +80,7 @@ input { cursor: pointer; display: inline-block; font-family: "Omnes-ECOMP-W02-Medium", Arial; - font-size: 1.9rem; + font-size: 16px; font-weight: normal; line-height: 1; margin: 0 7px 10px 0; @@ -94,63 +94,17 @@ input { overflow: hidden; } -.btn:focus { - outline: 1px dotted #000; - outline-offset: -5px; -} - -.btn:last-child { - margin-right: 0; -} - -.btn::-moz-focus-inner { - padding: 0; - border: 0; -} - -.btn i[class*="icon-primary-"].icon-primary-small { - font-size: 17px; - top: -2px; -} - -.btn i[class*="icon-primary-"].icon-primary-medium { - font-size: 30px; - top: -2px; -} - -.btn i[class*="icon-primary-"].icon-primary-large { - font-size: 36px; - top: -2px; -} - -.btn-alt { +.btns-alt { border-color: #087ac2 transparent #0568ae; background-color: #0568ae; background: linear-gradient(to bottom, #087ac2 0%, #0568ae 100%); color: #ffffff; } -.btn-alt:hover { - color: #ffffff; - outline-color: #ffffff !important; - background: linear-gradient(to bottom, #0568ae 0%, #087ac2 100%); -} - -.btn-alt:focus { - color: #ffffff; - outline-color: #ffffff !important; - background: linear-gradient(to bottom, #0568ae 0%, #087ac2 100%); -} - -.btn-alt:active { - color: #ffffff; - outline-color: #ffffff !important; - background: linear-gradient(to bottom, #0568ae 0%, #087ac2 100%); -} -.btn-small { +.btns-small { padding: 10px 19px 9px 18px; - font-size: 17px; + font-size: 15px; border-radius: 8px; } diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html index 270ee870..01215576 100644 --- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html +++ b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.html @@ -9,7 +9,7 @@ <label>{{SQLmessage}}</label> </div> <div class="card-footer"> - <button (click)="showSaveSQLDialog = !showSaveSQLDialog" class="btn btn-alt btn-small close-model">Close + <button (click)="showSaveSQLDialog = !showSaveSQLDialog" class="btns btns-alt btns-small close-model">Close </button> </div> </div> @@ -38,7 +38,7 @@ </div> </div> <div class="card-footer"> - <button (click)="closeValidateModal()" class="btn btn-alt btn-small close-model">Close</button> + <button (click)="closeValidateModal()" class="btns btns-alt btns-small close-model">Close</button> </div> </div> </app-sql-validate-changes-dialog-component> @@ -57,12 +57,52 @@ <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']}}"></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> - <br/> <div class="field-group"> <pre> - <div class="divider"></div><button (click)="validate()" class="btn btn-alt btn-small">Validate & Save</button> + <div class="divider"></div><button (click)="validate()" class="btns btns-alt btns-small">Validate & Save</button> </pre> </div> <br/> diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts index afa84c63..7a547e3d 100644 --- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts +++ b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/ngapp/src/app/pages/analytics/Report_List/Report/sql/sql.component.ts @@ -36,6 +36,7 @@ export class SQLComponent implements OnInit { @Input() SQLclosable = true; @Input() Validateclosable = true; + keyWordAssistance: any[]; constructor(private _http: HttpClient, private _router: Router, private _sqlService: SqlService) { @@ -43,13 +44,20 @@ export class SQLComponent implements OnInit { this.SQLPostResponse = true; this.ValidatePostResponse = {}; this.showErrorSqlMessage = false; + this.keyWordAssistance = []; + } ngOnInit() { - this.showSpinner = true; this.showSaveSQLDialog = false; this.SQLPostResponse = true; this.ValidatePostResponse = {}; + this.keyWordAssistance.push( 'SELECT', 'DISTINCT', 'FROM', 'WHERE', + 'GROUP BY', 'HAVING', 'ORDER BY', 'ASC', 'DESC', 'AND', 'OR', 'NOT', 'EXISTS', + 'IS', 'NULL', 'IN', 'BETWEEN', 'COUNT(', 'SUM(', 'AVG(', 'MAX(', 'MIN(', 'NVL(', + 'DECODE(', 'SYSDATE', 'TO_CHAR(', 'TO_NUMBER(', 'TO_DATE(', + 'TRUNC(', 'ROUND(', 'ABS(', 'SUBSTR(', 'REPLACE(', 'LOWER(', 'UPPER(', + 'LTRM(', 'RTRIM(', 'LPAD(', 'RPAD(', 'linkToReport'); this._sqlService.getSQLTabData(this.reportId1) .subscribe((response) => { this.showSpinner = true; @@ -153,4 +161,7 @@ export class SQLComponent implements OnInit { return this.ValidateResponseString; } + addText(word: string) { + this.sqlText = this.sqlText + ' ' + word + ' '; + } } |