dashboardbuilder/dashboardbuilder.net

Dashboard Builder是一款基于PHP的数据驱动可视化与商业分析工具,通过机器学习提供洞察力。它使用PHP编写,并添加了拖放灵活性层,可以轻松预测未来,无需编写代码。

v7.2.0 2024-09-28 16:17 UTC

README

Dashboard Builder是一款基于PHP的库,是数据驱动的可视化与商业分析工具,通过机器学习提供洞察力。它使用PHP编写,并添加了拖放灵活性层,可以轻松预测未来,无需编写代码。

Dashboard Builder为您生成的仪表板PHP和通用HTML代码,可以无缝集成到任何用PHP编写的Web应用程序或任何PHP框架(如Wordpress、Laravel、CodeIgniter、Joomla等)。

要求

PHP Version 7.2 or later 
Apache 2 or later,  Nginx or any other Servcers support PHP
Windows 7 or later /Linux 3 or later/Ubuntu or any other platforms support Apache, Nginx etc.
Firefox 52, Chrome 57, IE 8, or any other Browsers support SVG

安装

通过Composer

composer require dashboardbuilder/dashboardbuilder.net

通过Git

git clone  https://github.com/DashboardBuilder/dashboardbuilder.net

安装程序

  1. 下载 https://github.com/DashboardBuilder/dashboardbuilder.net/releases
  2. 在网站根目录中提取产品存档。例如,your-folder
  3. 在浏览器中打开它以运行安装程序。例如,localhost/dashboarduilder

集成

  • 要在您的应用程序中集成,您需要将PHP代码复制到您的PHP应用程序中。
  1. “inc”、“assets”和“css”文件夹将被替换为您放置'lib'文件夹的路径(如果已更改)
 <script src="assets/js/dashboard.min.js"></script>  <! --  copy this file to assets/js folder -- >
 <link rel="stylesheet" href="css/bootstrap.min.css"> <! --  Bootstrap CSS file, change the path accordingly -- >
  1. 更新放置“inc/dashboard_dist.php”的包含路径。(如果已更改)

    包含(“inc/dashboard_dist.php”);更多详细信息请参阅https://dashboardbuilder.net/php-dashboard上的'入门'部分。

有关查询和支持,请参阅https://dashboardbuilder.net/support上的'支持'。

https://dashboardbuilder.net/data-visualization上参考数据可视化工具,以了解定义、示例、程序、技术和元素。

许可证

在使用前必须阅读并同意LICENSE.txt。

结果

PHP代码

<?php
/**
 * DashboardBuilder
 *
 * @author Diginix Technologies www.diginixtech.com
 * Support <support@dashboardbuider.net> - https://www.dashboardbuilder.net
 * @copyright (C) 2017 Dashboardbuilder.net
 * @version 2.1.0
 * @license: license.txt
 */

include("inc/dashboard_dist.php");  // copy this file to inc folder 

// for chart #1
$data = new dashboardbuilder(); 
$data->type =  "line";

$data->source =  "Database"; 
$data->rdbms =  "sqlite"; 
$data->servername =  "";
$data->username =  "";
$data->password =  "";
$data->dbname =  "dataNorthwind.db";
$data->xaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.orderdate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->xaxisCol[0]=  "xaxis";
$data->yaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.orderdate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->yaxisCol[0]=  "yaxis";

$data->name = "col1";
$data->title = "my title";
$data->xaxistitle = "x-axis title";
$data->yaxistitle = "y-axis title";


$result[1] = $data->result();?>

<!DOCTYPE html>
<html>
<head>
	<script src="assets/js/dashboard.min.js"></script> <!-- copy this file to assets/js folder -->
	<link rel="stylesheet" href="css/bootstrap.min.css"> <!-- Bootstrap CSS file, change the path accordingly -->
	
<style> 
<!-- adjust the height width as per your need -->;
/*
#col0{
height:350px;
}
#col1{
height:350px;
}
*/
</style>

</head>
<body> 
<div class="container">

<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-heading"></div>
	<div class="panel-body">
		<?php echo $result[1];?>
	</div>
</div>
</div>
</div>
</body>