自己设计一套新的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标准的软件配置工具软件 在汽车电子领域,AUTOSAR(Automotive Open System Architecture)是德国开发的一种开源的汽车软件架构标准。它旨在提供一个通用的、...
《使用DaVinci Configurator整合AUTOSAR模块的教程》 在现代汽车电子系统中,AUTOSAR(AUTomotive Open System ARchitecture)是一种广泛采用的软件架构,旨在提高软件组件的复用性和可移植性。而DaVinci ...
da Vinci Xi手术机器人系统用户手册 da Vinci Xi手术机器人系统是Intuitive Surgical, Inc.开发的一款先进的手术机器人系统,旨在提供高效、安全的手术环境。该系统用户手册详细介绍了da Vinci Xi系统的使用和操作...
Vector Davinci是Vector公司开发的适用于AutoSAR基础软件平台MICROSAR的集成开发环境(IDE)。AutoSAR(汽车电子架构软件平台)是一个全球性的开放合作项目,旨在开发汽车电子标准的软件架构。在本手册中,会详细...
ChatGPT接入项目实例 Python 调用davinci 002 api 示例 text-davinci-002
《达芬奇开发环境 davinci-dev-0.3 深度解析》 "达芬奇(davinci)",这个名字听起来或许让人联想到文艺复兴时期的杰出艺术家,但在IT领域,它可能代表了一种创新的开发工具或框架。本文将深入探讨名为"davinci-dev-...
"达芬奇开发者"(Davinci Developer)是面向这一领域,专为实现向量(Vector)汽车电子开发而设计的一款强大工具。它集成了多种功能,旨在提升开发效率,确保软件质量,并简化复杂的嵌入式系统开发流程。 一、向量...
- 图形加速:了解DaVinci处理器如何通过硬件加速实现高质量的OSD渲染。 5. **系统集成与优化**: - 系统设计考虑:如何将DaVinci处理器整合到更大的系统中,包括内存管理、外设接口和电源管理等方面。 - 性能...
很多做AUTOSAR软件集成时,没有配置davinci所需的dbc文件,我分享一下
"DaVinci系统培训课程操作说明.pdf" 本资源是 Honeywell Measurex 公司为 Customer 提供的 DaVinci 系统培训课程操作说明,涵盖了 DaVinci 系统的基本概念、操作指南和注意事项。本文档旨在为系统操作员和 Customer...
本教程将详细讲解如何在DaVinci Developer工具中添加并管理RTE信号。 一、了解RTE与信号 RTE是Autosar系统中的核心组件,它负责在ECU(Electronic Control Unit)上运行时,管理SWC间的通信。信号(Signal)是...
- 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.的商标或注册商标。...
AUTOSAR 就是AUTomotive Open System ARchitecture,MATLAB + DaVinci(国内主流)进行AUTOSAR开发车用ECU软件的工具链使用说明文档。
根据提供的标题、描述、标签及部分内容,我们可以提炼出与DaVinci开发环境搭建相关的几个关键知识点。 ### DaVinci开发环境搭建概述 DaVinci系列是德州仪器(TI)推出的一系列高性能嵌入式多媒体处理器,它集成了...
《DaVinCi 配置EcuM模块的技术手册》提供了关于EcuM模块的详尽指导,特别是针对基于RH850芯片的诊断模块配置。EcuM(Electronic Control Unit Manager)是AUTOSAR(AUTomotive Open System ARchitecture)架构中的...
《 davinci-resizer.zip:TI Davinci系列硬件缩放工具详解及应用》 在嵌入式视频处理领域,TI(Texas Instruments)的Davinci系列处理器以其强大的视频编解码能力而闻名。针对这一系列处理器,TI推出了一款名为da...
《DaVinci MCAL Configurator配置ARXML在瑞萨RH850平台的应用详解》 在汽车电子系统开发中,AUTOSAR(AUTomotive Open System ARchitecture,汽车开放系统架构)已经成为一种广泛采用的标准,它定义了软件组件、...
DaVinCi 配置 PduR模块的技术手册,内容涉及PduR功能模块介绍,API接口等.基于RH850芯片的DaVinCi诊断模块配置手册。虽然说是RH850芯片SIP包里的,但是文档内的内容是标准化的,通用化的。包括函数接口等服务都是...
此外,本书也可能会讲授一些高级技巧,比如如何与其他页面交互、如何使用DaVinci Resolve内置的颜色校正功能来增强视觉效果的呈现,以及如何调整和渲染最终的视觉效果以用于不同的输出格式和媒体。 DaVinci Resolve...
标题中的“test_uart.rar”表明这是一个与UART(通用异步收发传输器)相关的测试工程文件,用于在Davinci平台上进行串口通信的验证。Davinci是TI(德州仪器)公司推出的一种数字信号处理器(DSP)和视频处理器的集成...