`
y806839048
  • 浏览: 1120658 次
  • 性别: Icon_minigender_1
  • 来自: 上海
文章分类
社区版块
存档分类
最新评论

davinci图形渲染思路

阅读更多

 

自己设计一套新的bi工具也不外乎此,其他逻辑思路简单

获取图形信息---获取图形对应的视图信息---获取视图对应的数据信息

 

 

 

获取图形信息---获取图形对应的视图信息---获取视图对应的数据信息

 

 

http://localhost:8080/api/v3/views?projectId=3---获取project对应的视图以及对应的数据源

"select v.id, v.`name`, v.`description`, s.name as 'sourceName'",

            "from `view` v ",

            "left join source s on s.id = v.source_id ",

            "where v.project_id = #{projectId}" 

 

http://localhost:8080/api/v3/widgets/4

获取当前图形的信息包括配置信息--位置颜色类型

 

http://localhost:8080/api/v3/views/4

获取图形对应的视图sql信息---可供选择的字段---指标维度

维度group 字段

指标聚合计算

 

 

http://localhost:8080/api/v3/views/4/getdata

获取配配图形对应的维度,指标---值--渲染

筛选字段在gedata中的filter中

http://localhost:8080/api/v3/views/4/getdistinctvalue

用于筛选的字段首选会把其值列出

参数类:

ViewExecuteParam

 

 

 

sql条件信息的配置保存使用过程

 

查询的时候还要调用widget获取信息,最后才是用widget返回的条件配,调用getdata  组合放入ViewExecuteParam中

 

即:getWidgetInfo

 

 

http://127.0.0.1:8080/api/v3/widgets/4  获取wdiget列表返回的config字段信息中的查询sql会被用于getdata  组合放入ViewExecuteParam中。模板根据这个动态生成sql

 

需要配合自定义组合sql,如选择用and 或者 or 这里也应保存标志位,以便页面可以下次展现条件的and 还是or

 

Widget  这个中的config增加 filterAndFlag=true  查询条件在这里,

 

 

@Data

public class Widget extends RecordInfo<Widget> {

    private Long id;

 

    private String name;

 

    private String description;

 

    private Long viewId;

 

    private Long projectId;

 

    private Long type;

 

    private Boolean publish = false;

 

    private String config;

 

}

 

 

{"data":[],"cols":[{"name":"update_time","visualType":"date","type":"category","config":true,"field":{"alias":"","desc":"","useExpression":false},"format":{"formatType":"default"}}],"rows":[],"metrics":[{"name":"data_value@davinci@1870DA57",

"visualType":"string","type":"value","agg":"sum","config":true,"chart":{"id":3,"name":"bar","title":"柱状图","icon":"icon-chart-bar","coordinate":"cartesian","rules":[{"dimension":[0,9999],"metric":[1,9999]}],"dimetionAxis":"col","data":

{"cols":{"title":"列","type":"category"},"rows":{"title":"行","type":"category"},"metrics":{"title":"指标","type":"value"},"filters":{"title":"筛选","type":"all"},"color":{"title":"颜色","type":"category"},"label":{"title":"标签","type":"all"}

,"tip":{"title":"提示信息","type":"value"}},"style":{"xAxis":{"showLine":true,"lineStyle":"solid","lineSize":"1","lineColor":"#D9D9D9","showLabel":true,"labelFontFamily":"PingFang SC","labelFontSize":"12","labelColor":"#666"},"yAxis":

{"showLine":true,"lineStyle":"solid","lineSize":"1","lineColor":"#D9D9D9","showLabel":true,"labelFontFamily":"PingFang SC","labelFontSize":"12","labelColor":"#666","showTitleAndUnit":true,"titleFontFamily":"PingFang SC","titleFontSize":"12",

"titleColor":"#666"},"splitLine":{"showHorizontalLine":true,"horizontalLineStyle":"dashed","horizontalLineSize":"1","horizontalLineColor":"#D9D9D9","showVerticalLine":false,"verticalLineStyle":"dashed","verticalLineSize":"1",

"verticalLineColor":"#D9D9D9"},"pivot":{"fontFamily":"PingFang SC","fontSize":"12","color":"#666","lineStyle":"solid","lineColor":"#D9D9D9","headerBackgroundColor":"#f7f7f7"}}},"field":{"alias":"","desc":"","useExpression":false},"format":

{"formatType":"default"}}],

"filters":[{"name":"data_date","type":"category",

"config":{"sqlModel":[{"name":"data_date","type":"filter","value":["'2019-08-12'","'2019-08-09'"],"operator":"in","sqlType":"VARCHAR"}],

"filterSource":["2019-08-12","2019-08-09"]}},{"name":"update_time","type":"category",

"config":{"sql":"update_time >= '2019-11-06 14:19:06' and update_time <= '2019-11-20 14:19:06'","

filterSource":{"selectedDate":"other","datepickerValue":["2019-11-06 14:19:06","2019-11-20 14:19:06"]}}}],

 

 

"color":{"title":"颜色","type":"category","value":{"all":"#509af2","data_value@davinci@1870DA57":"#509af2"},"items":[]},"label":{"title":"标签","type":"all","items":[]},"tip":

{"title":"提示信息","type":"value","items":[]},"chartStyles":{"xAxis":{"showLine":true,"lineStyle":"solid","lineSize":"1","lineColor":"#D9D9D9","showLabel":true,"labelFontFamily":"PingFang SC","labelFontSize":"12","labelColor":"#666"},

"yAxis":{"showLine":true,"lineStyle":"solid","lineSize":"1","lineColor":"#D9D9D9","showLabel":true,"labelFontFamily":"PingFang SC","labelFontSize":"12","labelColor":"#666","showTitleAndUnit":true,"titleFontFamily":"PingFang SC",

"titleFontSize":"12","titleColor":"#666"},"splitLine":{"showHorizontalLine":true,"horizontalLineStyle":"dashed","horizontalLineSize":"1","horizontalLineColor":"#D9D9D9","showVerticalLine":false,"verticalLineStyle":"dashed",

"verticalLineSize":"1","verticalLineColor":"#D9D9D9"},"pivot":{"fontFamily":"PingFang SC","fontSize":"12","color":"#666","lineStyle":"solid","lineColor":"#D9D9D9","headerBackgroundColor":"#f7f7f7"}},"selectedChart":1,"pagination":

{"pageNo":0,"pageSize":0,"withPaging":false,"totalCount":0},"dimetionAxis":"col","renderType":"clear","orders":[],"mode":"pivot","model":{"index_code":{"sqlType":"VARCHAR","visualType":"string","modelType":"value"},"data_date":

{"sqlType":"VARCHAR","visualType":"string","modelType":"category"},"data_value":{"sqlType":"VARCHAR","visualType":"string","modelType":"value"},"publish_time":{"sqlType":"DATETIME","visualType":"date","modelType":"value"},

"update_time":{"sqlType":"DATETIME","visualType":"date","modelType":"category"}},"controls":[],"computed":[],"cache":false,"expired":300,"autoLoadData":true}

 

 

 

 

 

 

 

 

 

分享到:
评论

相关推荐

    汽车编程-德国Vector DaVinci Configurator Pro AUTOSAR标准的软件配置工具软件.docx

    汽车编程-德国Vector DaVinci Configurator Pro AUTOSAR标准的软件配置工具软件 在汽车电子领域,AUTOSAR(Automotive Open System Architecture)是德国开发的一种开源的汽车软件架构标准。它旨在提供一个通用的、...

    Davinci Configurator

    《使用DaVinci Configurator整合AUTOSAR模块的教程》 在现代汽车电子系统中,AUTOSAR(AUTomotive Open System ARchitecture)是一种广泛采用的软件架构,旨在提高软件组件的复用性和可移植性。而DaVinci ...

    da_Vinci_Xi_System_User_Manual.pdf

    da Vinci Xi手术机器人系统用户手册 da Vinci Xi手术机器人系统是Intuitive Surgical, Inc.开发的一款先进的手术机器人系统,旨在提供高效、安全的手术环境。该系统用户手册详细介绍了da Vinci Xi系统的使用和操作...

    Vector Davinci官方帮助配置使用手册(AutoSAR).pdf

    Vector Davinci是Vector公司开发的适用于AutoSAR基础软件平台MICROSAR的集成开发环境(IDE)。AutoSAR(汽车电子架构软件平台)是一个全球性的开放合作项目,旨在开发汽车电子标准的软件架构。在本手册中,会详细...

    ChatGPT接入项目实例 Python 调用davinci 002 api 示例 text-davinci-002

    ChatGPT接入项目实例 Python 调用davinci 002 api 示例 text-davinci-002

    davinci-dev-0.3.zip

    《达芬奇开发环境 davinci-dev-0.3 深度解析》 "达芬奇(davinci)",这个名字听起来或许让人联想到文艺复兴时期的杰出艺术家,但在IT领域,它可能代表了一种创新的开发工具或框架。本文将深入探讨名为"davinci-dev-...

    Davinci_Develop

    "达芬奇开发者"(Davinci Developer)是面向这一领域,专为实现向量(Vector)汽车电子开发而设计的一款强大工具。它集成了多种功能,旨在提升开发效率,确保软件质量,并简化复杂的嵌入式系统开发流程。 一、向量...

    TI-DaVinci.rar_davinci_ti davinci o

    - 图形加速:了解DaVinci处理器如何通过硬件加速实现高质量的OSD渲染。 5. **系统集成与优化**: - 系统设计考虑:如何将DaVinci处理器整合到更大的系统中,包括内存管理、外设接口和电源管理等方面。 - 性能...

    Vector工具链(davinci)配置AutoSAR工程所需的dbc文件

    很多做AUTOSAR软件集成时,没有配置davinci所需的dbc文件,我分享一下

    DaVinci系统培训课程操作说明.pdf

    "DaVinci系统培训课程操作说明.pdf" 本资源是 Honeywell Measurex 公司为 Customer 提供的 DaVinci 系统培训课程操作说明,涵盖了 DaVinci 系统的基本概念、操作指南和注意事项。本文档旨在为系统操作员和 Customer...

    使用Davinci 添加Rte信号.7z

    本教程将详细讲解如何在DaVinci Developer工具中添加并管理RTE信号。 一、了解RTE与信号 RTE是Autosar系统中的核心组件,它负责在ECU(Electronic Control Unit)上运行时,管理SWC间的通信。信号(Signal)是...

    da Vinci Xi user manual

    - Intuitive、Intuitive Surgical、Beyond the Limits of the Human Hand、daVinci、daVinci S、daVinci Si、daVinci Xi、daVinci X、EndoWrist、TilePro、OnSite等均为Intuitive Surgical, Inc.的商标或注册商标。...

    MATLAB + DaVinci autosar工具链开发文档.pdf

    AUTOSAR 就是AUTomotive Open System ARchitecture,MATLAB + DaVinci(国内主流)进行AUTOSAR开发车用ECU软件的工具链使用说明文档。

    DaVinci开发环境搭建

    根据提供的标题、描述、标签及部分内容,我们可以提炼出与DaVinci开发环境搭建相关的几个关键知识点。 ### DaVinci开发环境搭建概述 DaVinci系列是德州仪器(TI)推出的一系列高性能嵌入式多媒体处理器,它集成了...

    DaVinCi 配置EcuM模块的技术手册

    《DaVinCi 配置EcuM模块的技术手册》提供了关于EcuM模块的详尽指导,特别是针对基于RH850芯片的诊断模块配置。EcuM(Electronic Control Unit Manager)是AUTOSAR(AUTomotive Open System ARchitecture)架构中的...

    davinci-resizer.zip_Resizer_davinci_davinci resizer _resizer DEV

    《 davinci-resizer.zip:TI Davinci系列硬件缩放工具详解及应用》 在嵌入式视频处理领域,TI(Texas Instruments)的Davinci系列处理器以其强大的视频编解码能力而闻名。针对这一系列处理器,TI推出了一款名为da...

    DaVinci MCAL Configurator配置ARXML(瑞萨RH850)

    《DaVinci MCAL Configurator配置ARXML在瑞萨RH850平台的应用详解》 在汽车电子系统开发中,AUTOSAR(AUTomotive Open System ARchitecture,汽车开放系统架构)已经成为一种广泛采用的标准,它定义了软件组件、...

    DaVinCi 配置 PduR模块的技术手册,内容涉及PduR功能模块介绍,API接口等

    DaVinCi 配置 PduR模块的技术手册,内容涉及PduR功能模块介绍,API接口等.基于RH850芯片的DaVinCi诊断模块配置手册。虽然说是RH850芯片SIP包里的,但是文档内的内容是标准化的,通用化的。包括函数接口等服务都是...

    DaVinci Resolve 16之Fusion视觉特效

    此外,本书也可能会讲授一些高级技巧,比如如何与其他页面交互、如何使用DaVinci Resolve内置的颜色校正功能来增强视觉效果的呈现,以及如何调整和渲染最终的视觉效果以用于不同的输出格式和媒体。 DaVinci Resolve...

    test_uart.rar_davinci_davinci uart_davinci 串口

    标题中的“test_uart.rar”表明这是一个与UART(通用异步收发传输器)相关的测试工程文件,用于在Davinci平台上进行串口通信的验证。Davinci是TI(德州仪器)公司推出的一种数字信号处理器(DSP)和视频处理器的集成...

Global site tag (gtag.js) - Google Analytics