视图

简单视图格式:

{
    //简写模式(不支持函数)
    //select:'f1,order_id.order_no,order_id.order_no my_order_no',

    //支持函数模式
    select: [
    {
        field:'f1',
    }
    ,
    {
        field:'sum_f1',
        fun:'sum',
        args:['f1'],

        //args:[{field:'f1'},{value:'xxx'}],
      },
      {
        field:'order_no',
        fieldRefPath:'order_id.order_no',//关联表字段
      },
      {
        field:'count_order_no',
        fun:'count',args:['order_id.order_no']
      },
      {
        field:'count_order_no',
        fun:'count',//函数计算字段
        args:['order_no'],
      },
      {
        field:'record_count',
        fun:'count',
        args:['1']
      },
    ],

    //可以是whereList也可以是groupList
    where: [
        {field:'f1',operation:'=',value:'x'}
    ],

    groupBy:['f1'],

    //可以是whereList也可以是groupList
    having:[
        {field:'f1',operation:'=',value:'x'},
    ],
    orderBy:[{field:'f1',order:'desc'}], //排序
    limit: 1
}