首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >动态更改angular2查询生成器中的配置。

动态更改angular2查询生成器中的配置。
EN

Stack Overflow用户
提问于 2018-11-15 05:22:09
回答 1查看 4.9K关注 0票数 2

在这里,我试图根据Angular2-query-builder中的字段值来更改操作符。我的TS文件。

代码语言:javascript
复制
    @Component({
      selector: 'my-app',
      template: `
        <div>
          <h2>Hello {{name}}</h2>
        </div>
        <query-builder [(ngModel)]='uiExpression' [config]='config' (ngModelChange)="apply()" #que (onChangeCallback)="onchange()">
              <ng-container *queryButtonGroup="let ruleset; let addRule=addRule; let addRuleSet=addRuleSet; let removeRuleSet=removeRuleSet">
                <button mat-button (click)="addRule()">+ Rule</button>
                <button mat-button (click)="addRuleSet()">+ Ruleset</button>
                <button mat-button (click)="removeRuleSet()">- Ruleset</button>
              </ng-container>
              <ng-container *queryRemoveButton="let rule; let removeRule=removeRule">
                <button mat-icon-button color="accent" (click)="removeRule(rule)">
                  <mat-icon>remove</mat-icon>
                </button>
              </ng-container>
              <ng-container *querySwitchGroup="let ruleset">
                <mat-radio-group *ngIf="ruleset" [(ngModel)]="ruleset.condition">
                  <mat-radio-button value="and">And</mat-radio-button>
                  <mat-radio-button value="or">Or</mat-radio-button>
                </mat-radio-group>
              </ng-container>
              <ng-container *queryInput="let rule; type: 'string'">
                <mat-form-field>
                  <input matInput [(ngModel)]="rule.value">
                </mat-form-field>
              </ng-container>
              <ng-container *queryInput="let rule; type: 'number'">
                <mat-form-field>
                  <input matInput type="number" [(ngModel)]="rule.value">
                </mat-form-field>
              </ng-container>
              <ng-container *queryInput="let rule; type: 'date'">
                <mat-form-field>
                  <input matInput [matDatepicker]="picker" [(ngModel)]="rule.value">
                  <mat-datepicker-toggle matSuffix [for]="picker"></mat-datepicker-toggle>
                  <mat-datepicker #picker></mat-datepicker>
                </mat-form-field>
              </ng-container>
              <ng-container *queryInput="let rule; let field=field; let options=options; type: 'multiselect'">
                <mat-form-field>
                  <mat-select multiple [(ngModel)]="rule.value">
                    <mat-option *ngFor="let opt of options" [value]="opt.value">
                      {{ opt.name }}
                    </mat-option>
                  </mat-select>
                </mat-form-field>
              </ng-container>
              <ng-container *queryField="let rule; let fields=fields; let changeField=changeField">
                <mat-form-field>
                  <mat-select [(ngModel)]="rule.field" (ngModelChange)="changeFields($event, rule)">
                    <mat-option *ngFor="let field of fields" [value]="field.value">{{field.name}}</mat-option>
                  </mat-select>
                </mat-form-field>
              </ng-container>
              <ng-container *queryOperator="let rule; let operators=operators">
                <mat-form-field>
                  <mat-select [(ngModel)]="rule.operator" (ngModelChange)="changeOperator(rule)">
                    <mat-option *ngFor="let value of operators" [value]="value">{{value}}</mat-option>
                  </mat-select>
                </mat-form-field>
              </ng-container>
              </query-builder>
            <div>{{userExpression}}</div>
      `,
    })    
    export class App {
public operators = [
        {
            "attributeType": "STRING",
            "operators": [
                { "displayOperator": "Equals", "sqlOperator": " =(VALUE)" },
                { "displayOperator": "Does not Equal", "sqlOperator": "<>(VALUE)" },
                { "displayOperator": "Starts With", "sqlOperator": "LIKE %(VALUE)" },
                { "displayOperator": "Ends With", "sqlOperator": "LIKE (VALUE)%" },
                { "displayOperator": "Contains", "sqlOperator": "LIKE %(VALUE)%" },
                { "displayOperator": "Does Not Contain", "sqlOperator": "NOT LIKE %(VALUE)" },
                { "displayOperator": "Does Not Start With", "sqlOperator": "NOT LIKE (VALUE)%" },
                { "displayOperator": "Does Not End With", "sqlOperator": "NOT LIKE %(VALUE)%" }
            ]
        },
        {
            "attributeType": "Numeric",
            "operators": [
                { "displayOperator": "Equals", "sqlOperator": " =(VALUE)" },
                { "displayOperator": "Does not Equal", "sqlOperator": "<>(VALUE)" },
                { "displayOperator": "Greater", "sqlOperator": ">(VALUE)" },
                { "displayOperator": "Equal or Greater", "sqlOperator": ">=(VALUE)" },
                { "displayOperator": "Less", "sqlOperator": "<(VALUE)" },
                { "displayOperator": "Equal or Less", "sqlOperator": "<=(VALUE)" },
                { "displayOperator": "Within", "sqlOperator": "BETWEEN (VALUE1) AND (VALUE2)" },
            ]
        },
        {
            "attributeType": "Date",
            "operators": [
                { "displayOperator": "Equals", "sqlOperator": " =(VALUE)" },
                { "displayOperator": "On or After", "sqlOperator": ">=(VALUE)" },
                { "displayOperator": "Before", "sqlOperator": "<(VALUE)" },
                { "displayOperator": "Between", "sqlOperator": "BETWEEN (VALUE1) AND (VALUE2)" }
            ]
        }
    ]
          AttributeDummy: any[] = [
            {
              "userColumnName": "Attribute 1",
              "colType": "multiselect",
              "isListType": "Y",
              "userColumnOptions": [
                { name: "Male", value: "m" },
                { name: "Female", value: "f" }
              ]
            },
            {
              "userColumnName": "Attribute 2",
              "colType": "date",
              "isListType": "N",
              "userColumnOptions": ""
            },
            {
              "userColumnName": "Attribute 3",
              "colType": "string",
              "isListType": "N",
              "userColumnOptions": ""
            },
            {
              "userColumnName": "Attribute 4",
              "colType": "number",
              "isListType": "N",
              "userColumnOptions": ""
            }
          ]
          name: string;
          uiExpression = {};
          fieldsS = {}
          @Input() config: QueryBuilderConfig = {
            fields: {}
          }
          userExpression: String = 'Attribute = undefined';
          constructor() {
            this.name = `Plunker! v${VERSION.full}`;
            for (var i = 0; i < this.AttributeDummy.length; i++) {
              // operators: (this.AttributeDummy[i].colType.toLowerCase()==this.operator.operators[0].attributeType.toLowerCase()) ? this.operator.operators[0].operators : 
              // (this.AttributeDummy[i].colType.toLowerCase()==this.operator.operators[1].attributeType.toLowerCase()) ? this.operator.operators[1].operators : 
              // (this.AttributeDummy[i].colType.toLowerCase()==this.operator.operators[2].attributeType.toLowerCase()) ? this.operator.operators[2].operators : ''
              this.fieldsS[this.AttributeDummy[i].userColumnName] = {
                name: this.AttributeDummy[i].userColumnName,
                type: this.AttributeDummy[i].colType.toLowerCase(),
                operators: this.operators,
                options: this.AttributeDummy[i].userColumnOptions
              }
              this.config.fields = this.fieldsS;
              this.detect.markForCheck();
              console.log('config ', JSON.stringify(this.config))
            }
            if (this.AttributeDummy.length > 0) {
              console.log('attributes length > 0');
              this.uiExpression = {
                condition: 'and',
                rules: [
                  {
                    field: this.AttributeDummy[0].userColumnName,
                    operator: this.operators[0]
                  }
                ]
              }
            }
          }
        }

在更改属性时,正在尝试将查询生成器中的操作符动态更新到UI中。我将操作符列表更新为config,但它不会更新到UI中。

在这里,有一个参考链接:https://zebzhao.github.io/Angular-QueryBuilder/demo/我想根据这个字段更新操作符。

EN

回答 1

Stack Overflow用户

发布于 2019-06-12 17:08:20

我找不到这方面的任何好文件。我通过阅读query-builder.Component.jsrc来了解它是如何工作的,从而使它能够工作。

我在用

  • Angular2-查询生成器0.4.2
  • 角8.0.0

添加对QueryBuilderComponent的引用。

代码语言:javascript
复制
  @ViewChild(QueryBuilderComponent, { static: true }) queryBuilder: QueryBuilderComponent;

然后,在更新配置之后,调用queryBuilder上的queryBuilder来用新的配置值更新UI。

代码语言:javascript
复制
//set the options for your field
this.config.fields['myField'].options = [
   {name: 'a', value:'1'}, 
   {name: 'b', value:'2'}, 
   {name: 'c', value:'3'}
]

this.refreshField('myField);



private refreshField(field: string): void {
    // get the current rule
    const srcRule = this.queryBuilder.data.rules.find((x: Rule) => x.field === field) as Rule;

    if (srcRule) {

      // cache the current rule's selected value from our datasource
      const value = srcRule ? srcRule.value : undefined;

      // call change field to rebind new options to the UI
      this.queryBuilder.changeField(field, srcRule);

      // reset the previously selected value to the dropdown because changeField nulls out the value.
      srcRule.value = value;
    }
}
票数 3
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/53312918

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档