Davinci BI报表工具~

r囧r小猫 2022-12-28 09:16 358阅读 0赞

前文：

外部数据用SparingCloud做数据接口，对内部当然时用BI工具平台提供查询，释放开发，让运营想怎么查就怎么查，缩短开发流程。

# 一、安装 #

## 1.1 环境 ##

### 1.1.1 JDK1.8 ###

略

## 1.1.2 phantomjs ##

#解压bzip2工具
    yum -y install bzip2
    yum install fontconfig
    
    #下载解压重命名
    wget https://bitbucket.org/ariya/phantomjs/downloads/phantomjs-2.1.1-linux-x86_64.tar.bz2
    tar -jxvf phantomjs-2.1.1-linux-x86_64.tar.bz2
    mv phantomjs-2.1.1-linux-x86_64 /opt/phantomjs
    
    #环境变量
    vim /etc/profile
    PHANTOMJS_HOME=/opt/phantomjs
    export PATH=$PATH:$PHANTOMJS_HOME/bin
    
    source /etc/profile
    phantomjs --version

### 1.1.3 mysql客户端 ###

yum install -y mysql

## 1.2 安装部署 ##

### 1.2.1 下载 ###

#下载解压
    wget https://github.com/edp963/davinci/releases/download/v0.3.0-rc/davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc.zip
    unzip davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc.zip -d /opt/davinci
    
    #把需要的提取出来
    mv /opt/davinci/davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc/* /opt/davinci
    rm -rf /opt/davinci/davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc
    rm -rf /opt/davinci/__MACOSX
    
    #环境配置
    vim /etc/profile
    export DAVINCI3_HOME=/opt/davinci
    
    source /etc/profile

### 1.2.2 初始化数据库及表 ###

#创建数据库 
    mysql -h bt-01 -P 3306 -uroot -p123456
    MySQL [(none)]> create database davinci;
    
    #修改初始化脚本
    vim $DAVINCI3_HOME/bin/initdb.sh
    mysql -P 3306 -h bt-01 -u root -p123456 davinci < $DAVINCI3_HOME/bin/davinci.sql
    
    sh $DAVINCI3_HOME/bin/initdb.sh

### 1.2.3 配置数据库(元数据) ###

cd config
    cp application.yml.example application.yml
    vim application.yml
    
    server:
      protocol: http
      address: bt-04
      port: 22333
      
      ## davinci datasource config
      datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://bt-01:3306/davinci?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
        username: root
        password: 123456
        driver-class-name: com.mysql.jdbc.Driver
        
      ## some mailboxes need to be set separately password for the SMTP service)
      mail:
        host: smtp.163.com
        port: 25
        username: cesarchoy
        fromAddress: cesarchoy@163.com
        password: XXXXXXXXXXXXXXXX
        nickname: Davinci
        
      phantomjs_home: /opt/phantomjs

### 1.3 启动 ###

bin/start-server.sh

# 二、使用 #

## 2.1 注册 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 1][]

## 2.2 Source(配置数据源) ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 2][]

## 2.3 View(写SQL/配置数据) ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 4][]

## 2.4 Widget(制作图表) ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 5][]

## 2.5 Dashboard(形成报板) ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 6][]

## 2.6 一个成果！ ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 7][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 8][]

# 三、推荐 #

官方文档：[https://edp963.github.io/davinci/docs/zh/2.4-dashboard][https_edp963.github.io_davinci_docs_zh_2.4-dashboard]

如果访问不了，请再修改hosts文件

# GitHub Start 
    140.82.113.3      github.com
    140.82.114.20     gist.github.com
    
    151.101.184.133    assets-cdn.github.com
    151.101.184.133    raw.githubusercontent.com
    151.101.184.133    gist.githubusercontent.com
    151.101.184.133    cloud.githubusercontent.com
    151.101.184.133    camo.githubusercontent.com
    151.101.184.133    avatars0.githubusercontent.com
    199.232.68.133     avatars0.githubusercontent.com
    199.232.28.133     avatars1.githubusercontent.com
    151.101.184.133    avatars1.githubusercontent.com
    151.101.184.133    avatars2.githubusercontent.com
    199.232.28.133     avatars2.githubusercontent.com
    151.101.184.133    avatars3.githubusercontent.com
    199.232.68.133     avatars3.githubusercontent.com
    151.101.184.133    avatars4.githubusercontent.com
    199.232.68.133     avatars4.githubusercontent.com
    151.101.184.133    avatars5.githubusercontent.com
    199.232.68.133     avatars5.githubusercontent.com
    151.101.184.133    avatars6.githubusercontent.com
    199.232.68.133     avatars6.githubusercontent.com
    151.101.184.133    avatars7.githubusercontent.com
    199.232.68.133     avatars7.githubusercontent.com
    151.101.184.133    avatars8.githubusercontent.com
    199.232.68.133     avatars8.githubusercontent.com
    
    # GitHub End
    
    #github
    140.82.114.3 github.com
    199.232.69.194 github.global.ssl.fastly.net
    185.199.108.153 assets-cdn.github.com
    199.232.96.133 avatars0.githubusercontent.com
    
    185.199.108.153  edp963.github.io

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70]: /images/20221120/ce19e22ac5fe4a10a537710e38c14572.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 1]: /images/20221120/9bc5b494121b4054b85885fa18666af0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201216152855473.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201216152719444.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201216152729512.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/202012161527036.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20201216153755109.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20201223110004666.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20201223105129264.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY4NzA3NA==,size_16,color_FFFFFF,t_70
[https_edp963.github.io_davinci_docs_zh_2.4-dashboard]: https://edp963.github.io/davinci/docs/zh/2.4-dashboard