268 lines
15 KiB
PHP
268 lines
15 KiB
PHP
<?php
|
|
$config->bi = new stdclass();
|
|
$config->bi->pickerHeight = 150;
|
|
|
|
$config->bi->conditionList = array();
|
|
$config->bi->conditionList['='] = '=';
|
|
$config->bi->conditionList['!='] = '!=';
|
|
$config->bi->conditionList['<'] = '<';
|
|
$config->bi->conditionList['>'] = '>';
|
|
$config->bi->conditionList['>='] = '≥ ';
|
|
$config->bi->conditionList['<='] = '≤ ';
|
|
$config->bi->conditionList['IN'] = 'IN';
|
|
$config->bi->conditionList['NOT IN'] = 'NOT IN';
|
|
$config->bi->conditionList['IS NOT NULL'] = 'IS NOT NULL';
|
|
$config->bi->conditionList['IS NULL'] = 'IS NULL';
|
|
|
|
$config->bi->duckdbExcludeTables = array('metriclib', 'repofiles', 'repohistory', 'queue', 'duckdbqueue', 'action');
|
|
|
|
$config->bi->builtin = new stdclass();
|
|
$config->bi->builtin->modules = new stdclass();
|
|
$config->bi->builtin->screens = array(1, 2, 3, 4, 5, 6, 7, 8,1001);
|
|
|
|
$config->bi->default = new stdclass();
|
|
$config->bi->default->styles = json_decode('{"filterShow":false,"hueRotate":0,"saturate":1,"contrast":1,"brightness":1,"opacity":1,"rotateZ":0,"rotateX":0,"rotateY":0,"skewX":0,"skewY":0,"blendMode":"normal","animations":[]}');
|
|
$config->bi->default->status = json_decode('{"lock":false,"hide":false}');
|
|
$config->bi->default->request = json_decode('{"requestDataType":0,"requestHttpType":"get","requestUrl":"","requestInterval":null,"requestIntervalUnit":"second","requestContentType":0,"requestParamsBodyType":"none","requestSQLContent":{"sql":"select * from where"},"requestParams":{"Body":{"form-data":{},"x-www-form-urlencoded":{},"json":"","xml":""},"Header":{},"Params":{}}}');
|
|
$config->bi->default->events = json_decode('{"baseEvent":{"click":null,"dblclick":null,"mouseenter":null,"mouseleave":null},"advancedEvents":{"vnodeMounted":null,"vnodeBeforeMount":null}}');
|
|
|
|
// 是否开启 base/dao exec 的记录 zt_duckdbqueue 功能
|
|
$config->bi->cdnUrl = 'https://dl.zentao.net/duckdb/';
|
|
$config->bi->duckdbHelp = 'https://www.zentao.net/book/zentaopms/1313.html';
|
|
|
|
$config->bi->duckdbBin = array();
|
|
$config->bi->duckdbBin['win'] = array('path' => '/bin/duckdb/', 'file' => 'duckdb.exe', 'fileUrl' => $config->bi->cdnUrl . 'win/duckdb.zip');
|
|
$config->bi->duckdbBin['linux'] = array('path' => '/opt/zbox/bin/', 'file' => 'duckdb', 'fileUrl' => $config->bi->cdnUrl . 'linux/amd64/duckdb.zip');
|
|
|
|
$config->bi->duckdbExt = array();
|
|
$config->bi->duckdbExt['win'] = array('dm' => 'sync2parquet.exe', 'mysql' => 'mysql_scanner.duckdb_extension');
|
|
$config->bi->duckdbExt['linux'] = array('dm' => 'sync2parquet', 'mysql' => 'mysql_scanner.duckdb_extension');
|
|
|
|
$config->bi->duckdbExtUrl = array();
|
|
$config->bi->duckdbExtUrl['win'] = array('dm' => $config->bi->cdnUrl . 'win/sync2parquet.exe', 'mysql' => $config->bi->cdnUrl . 'win/mysql_scanner.duckdb_extension.zip');
|
|
$config->bi->duckdbExtUrl['linux'] = array('dm' => $config->bi->cdnUrl . 'linux/amd64/sync2parquet', 'mysql' => $config->bi->cdnUrl . 'linux/amd64/mysql_scanner.duckdb_extension.zip');
|
|
|
|
$charts = array();
|
|
$charts['32'] = array("root" => 1, "name" => "产品", "grade" => 1);
|
|
$charts['33'] = array("root" => 1, "name" => "项目", "grade" => 1);
|
|
$charts['34'] = array("root" => 1, "name" => "测试", "grade" => 1);
|
|
$charts['35'] = array("root" => 1, "name" => "组织", "grade" => 1);
|
|
$charts['36'] = array("root" => 1, "name" => "需求", "grade" => 2);
|
|
$charts['37'] = array("root" => 1, "name" => "发布", "grade" => 2);
|
|
$charts['38'] = array("root" => 1, "name" => "项目", "grade" => 2);
|
|
$charts['39'] = array("root" => 1, "name" => "任务", "grade" => 2);
|
|
$charts['40'] = array("root" => 1, "name" => "迭代", "grade" => 2);
|
|
$charts['41'] = array("root" => 1, "name" => "成本", "grade" => 2);
|
|
$charts['42'] = array("root" => 1, "name" => "工期", "grade" => 2);
|
|
$charts['43'] = array("root" => 1, "name" => "需求", "grade" => 2);
|
|
$charts['44'] = array("root" => 1, "name" => "Bug", "grade" => 2);
|
|
$charts['45'] = array("root" => 1, "name" => "项目集", "grade" => 2);
|
|
$charts['46'] = array("root" => 1, "name" => "项目", "grade" => 2);
|
|
$charts['47'] = array("root" => 1, "name" => "产品", "grade" => 2);
|
|
$charts['48'] = array("root" => 1, "name" => "计划", "grade" => 2);
|
|
$charts['49'] = array("root" => 1, "name" => "迭代", "grade" => 2);
|
|
$charts['50'] = array("root" => 1, "name" => "发布", "grade" => 2);
|
|
$charts['51'] = array("root" => 1, "name" => "需求", "grade" => 2);
|
|
$charts['52'] = array("root" => 1, "name" => "任务", "grade" => 2);
|
|
$charts['53'] = array("root" => 1, "name" => "Bug", "grade" => 2);
|
|
$charts['54'] = array("root" => 1, "name" => "文档", "grade" => 2);
|
|
$charts['55'] = array("root" => 1, "name" => "成本", "grade" => 2);
|
|
$charts['56'] = array("root" => 1, "name" => "人员", "grade" => 2);
|
|
$charts['57'] = array("root" => 1, "name" => "工时", "grade" => 2);
|
|
$charts['64'] = array("root" => 1, "name" => "行为", "grade" => 2);
|
|
$charts['65'] = array("root" => 2, "name" => "产品", "grade" => 1);
|
|
$charts['66'] = array("root" => 2, "name" => "项目", "grade" => 1);
|
|
$charts['67'] = array("root" => 2, "name" => "测试", "grade" => 1);
|
|
$charts['68'] = array("root" => 2, "name" => "组织", "grade" => 1);
|
|
$charts['69'] = array("root" => 2, "name" => "进度", "grade" => 2);
|
|
$charts['70'] = array("root" => 2, "name" => "成本", "grade" => 2);
|
|
$charts['71'] = array("root" => 2, "name" => "工期", "grade" => 2);
|
|
$charts['72'] = array("root" => 2, "name" => "项目", "grade" => 2);
|
|
$charts['73'] = array("root" => 2, "name" => "迭代", "grade" => 2);
|
|
$charts['74'] = array("root" => 2, "name" => "发布", "grade" => 2);
|
|
$charts['75'] = array("root" => 2, "name" => "需求", "grade" => 2);
|
|
$charts['76'] = array("root" => 2, "name" => "任务", "grade" => 2);
|
|
$charts['77'] = array("root" => 2, "name" => "Bug", "grade" => 2);
|
|
$charts['86'] = array("root" => 2, "name" => "成本", "grade" => 2);
|
|
$charts['87'] = array("root" => 3, "name" => "产品", "grade" => 1);
|
|
$charts['88'] = array("root" => 3, "name" => "项目", "grade" => 1);
|
|
$charts['89'] = array("root" => 3, "name" => "测试", "grade" => 1);
|
|
$charts['90'] = array("root" => 3, "name" => "组织", "grade" => 1);
|
|
$charts['91'] = array("root" => 3, "name" => "Bug", "grade" => 2);
|
|
$charts['92'] = array("root" => 3, "name" => "用例", "grade" => 2);
|
|
$charts['93'] = array("root" => 3, "name" => "需求", "grade" => 2);
|
|
$charts['94'] = array("root" => 3, "name" => "Bug", "grade" => 2);
|
|
$charts['95'] = array("root" => 3, "name" => "用例", "grade" => 2);
|
|
$charts['102'] = array("root" => 1, "name" => "DevOps", "grade" => 1);
|
|
$charts['103'] = array("root" => 1, "name" => "DevOps", "grade" => 2);
|
|
|
|
$pivots = array();
|
|
$pivots['59'] = array("root" => 1, "name" => "产品", "grade" => 1);
|
|
$pivots['60'] = array("root" => 1, "name" => "项目", "grade" => 1);
|
|
$pivots['61'] = array("root" => 1, "name" => "测试", "grade" => 1);
|
|
$pivots['62'] = array("root" => 1, "name" => "组织", "grade" => 1);
|
|
$pivots['63'] = array("root" => 1, "name" => "产品", "grade" => 2);
|
|
$pivots['64'] = array("root" => 1, "name" => "项目集", "grade" => 2);
|
|
$pivots['79'] = array("root" => 2, "name" => "产品", "grade" => 1);
|
|
$pivots['80'] = array("root" => 2, "name" => "项目", "grade" => 1);
|
|
$pivots['81'] = array("root" => 2, "name" => "测试", "grade" => 1);
|
|
$pivots['82'] = array("root" => 2, "name" => "组织", "grade" => 1);
|
|
$pivots['83'] = array("root" => 2, "name" => "项目", "grade" => 2);
|
|
$pivots['84'] = array("root" => 2, "name" => "进度", "grade" => 2);
|
|
$pivots['85'] = array("root" => 2, "name" => "成本", "grade" => 2);
|
|
$pivots['86'] = array("root" => 2, "name" => "工期", "grade" => 2);
|
|
$pivots['96'] = array("root" => 3, "name" => "产品", "grade" => 1);
|
|
$pivots['97'] = array("root" => 3, "name" => "项目", "grade" => 1);
|
|
$pivots['98'] = array("root" => 3, "name" => "测试", "grade" => 1);
|
|
$pivots['99'] = array("root" => 3, "name" => "组织", "grade" => 1);
|
|
$pivots['100'] = array("root" => 3, "name" => "Bug", "grade" => 2);
|
|
|
|
$config->bi->builtin->modules->charts = $charts;
|
|
$config->bi->builtin->modules->pivots = $pivots;
|
|
|
|
$config->bi->duckSQLTemp = array();
|
|
$config->bi->duckSQLTemp['mysql'] = "LOAD '{EXTENSIONPATH}';ATTACH 'host={HOST} user={USER} password={PASSWORD} port={PORT} database={DATABASE}' as mysqldb(TYPE MYSQL);USE mysqldb;{COPYSQL}";
|
|
$config->bi->duckSQLTemp['dm'] = '{EXTENSIONPATH} --driver="{DRIVER}" --db="host={HOST} user={USER} password={PASSWORD} port={PORT} database={DATABASE}" --copy="{COPYSQL}"';
|
|
|
|
$config->bi->drivers = array('mysql', 'duckdb', 'dm');
|
|
$config->bi->defaultDriver = 'mysql';
|
|
|
|
$config->bi->columnTypes = new stdclass();
|
|
$config->bi->columnTypes->mysql['TINY'] = 'number';
|
|
$config->bi->columnTypes->mysql['SHORT'] = 'number';
|
|
$config->bi->columnTypes->mysql['LONG'] = 'number';
|
|
$config->bi->columnTypes->mysql['FLOAT'] = 'number';
|
|
$config->bi->columnTypes->mysql['DOUBLE'] = 'number';
|
|
$config->bi->columnTypes->mysql['TIMESTAMP'] = 'string';
|
|
$config->bi->columnTypes->mysql['LONGLONG'] = 'string';
|
|
$config->bi->columnTypes->mysql['INT24'] = 'number';
|
|
$config->bi->columnTypes->mysql['DATE'] = 'date';
|
|
$config->bi->columnTypes->mysql['TIME'] = 'string';
|
|
$config->bi->columnTypes->mysql['DATETIME'] = 'date';
|
|
$config->bi->columnTypes->mysql['YEAR'] = 'date';
|
|
$config->bi->columnTypes->mysql['ENUM'] = 'string';
|
|
$config->bi->columnTypes->mysql['SET'] = 'string';
|
|
$config->bi->columnTypes->mysql['TINYBLOB'] = 'string';
|
|
$config->bi->columnTypes->mysql['MEDIUMBLOB'] = 'string';
|
|
$config->bi->columnTypes->mysql['LONG_BLOB'] = 'string';
|
|
$config->bi->columnTypes->mysql['BLOB'] = 'string';
|
|
$config->bi->columnTypes->mysql['VAR_STRING'] = 'string';
|
|
$config->bi->columnTypes->mysql['STRING'] = 'string';
|
|
$config->bi->columnTypes->mysql['NULL'] = 'null';
|
|
$config->bi->columnTypes->mysql['NEWDATE'] = 'date';
|
|
$config->bi->columnTypes->mysql['INTERVAL'] = 'string';
|
|
$config->bi->columnTypes->mysql['GEOMETRY'] = 'string';
|
|
$config->bi->columnTypes->mysql['NEWDECIMAL'] = 'number';
|
|
|
|
/* Dameng native_type. */
|
|
$config->bi->columnTypes->mysql['int'] = 'number';
|
|
$config->bi->columnTypes->mysql['varchar'] = 'string';
|
|
$config->bi->columnTypes->mysql['text'] = 'string';
|
|
$config->bi->columnTypes->mysql['timestamp'] = 'string';
|
|
$config->bi->columnTypes->mysql['date'] = 'date';
|
|
$config->bi->columnTypes->mysql['time'] = 'string';
|
|
$config->bi->columnTypes->mysql['double'] = 'number';
|
|
$config->bi->columnTypes->mysql['number'] = 'number';
|
|
$config->bi->columnTypes->mysql['bigint'] = 'number';
|
|
|
|
/* DuckDB native_type. */
|
|
$config->bi->columnTypes->duckdb['BIGINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['INT8'] = 'number';
|
|
$config->bi->columnTypes->duckdb['LONG'] = 'number';
|
|
$config->bi->columnTypes->duckdb['UBIGINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['HUGEINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['UHUGEINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['INTEGER'] = 'number';
|
|
$config->bi->columnTypes->duckdb['UINTEGER'] = 'number';
|
|
$config->bi->columnTypes->duckdb['SMALLINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['INT2'] = 'number';
|
|
$config->bi->columnTypes->duckdb['SHORT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['INT4'] = 'number';
|
|
$config->bi->columnTypes->duckdb['INT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['SIGNED'] = 'number';
|
|
$config->bi->columnTypes->duckdb['USMALLINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['TINYINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['INT1'] = 'number';
|
|
$config->bi->columnTypes->duckdb['UTINYINT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['REAL'] = 'number';
|
|
$config->bi->columnTypes->duckdb['FLOAT4'] = 'number';
|
|
$config->bi->columnTypes->duckdb['FLOAT'] = 'number';
|
|
$config->bi->columnTypes->duckdb['DOUBLE'] = 'number';
|
|
$config->bi->columnTypes->duckdb['FLOAT8'] = 'number';
|
|
$config->bi->columnTypes->duckdb['BOOLEAN'] = 'number';
|
|
$config->bi->columnTypes->duckdb['BOOL'] = 'number';
|
|
$config->bi->columnTypes->duckdb['LOGICAL'] = 'number';
|
|
$config->bi->columnTypes->duckdb['BLOB'] = 'string';
|
|
$config->bi->columnTypes->duckdb['VARCHAR'] = 'string';
|
|
$config->bi->columnTypes->duckdb['CHAR'] = 'string';
|
|
$config->bi->columnTypes->duckdb['BPCHAR'] = 'string';
|
|
$config->bi->columnTypes->duckdb['TEXT'] = 'string';
|
|
$config->bi->columnTypes->duckdb['STRING'] = 'string';
|
|
$config->bi->columnTypes->duckdb['DATE'] = 'date';
|
|
$config->bi->columnTypes->duckdb['TIMESTAMP'] = 'date';
|
|
$config->bi->columnTypes->duckdb['DATETIME'] = 'date';
|
|
$config->bi->columnTypes->duckdb['TIME'] = 'date';
|
|
$config->bi->columnTypes->duckdb['DECIMAL'] = 'number';
|
|
$config->bi->columnTypes->duckdb['NUMERIC'] = 'number';
|
|
|
|
$config->bi->columnTypes->INTEGER = 'number';
|
|
$config->bi->columnTypes->UINTEGER = 'number';
|
|
$config->bi->columnTypes->UTINYINT = 'number';
|
|
$config->bi->columnTypes->SMALLINT = 'number';
|
|
$config->bi->columnTypes->FLOAT = 'number';
|
|
$config->bi->columnTypes->BOOLEAN = 'number';
|
|
$config->bi->columnTypes->VARCHAR = 'string';
|
|
$config->bi->columnTypes->TIMESTAMP = 'date';
|
|
$config->bi->columnTypes->DATE = 'date';
|
|
|
|
$config->bi->duckdb = new stdclass();
|
|
$config->bi->duckdb->ztvtables = array();
|
|
$config->bi->duckdb->ztvtables['dayactions'] = <<<EOT
|
|
SELECT * FROM ztv_dayactions
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['dayuserlogin'] = <<<EOT
|
|
SELECT * FROM ztv_dayuserlogin
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['dayeffort'] = <<<EOT
|
|
SELECT * FROM ztv_dayeffort
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['daystoryopen'] = <<<EOT
|
|
SELECT * FROM ztv_daystoryopen
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['daystoryclose'] = <<<EOT
|
|
SELECT * FROM ztv_daystoryclose
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['daytaskopen'] = <<<EOT
|
|
SELECT * FROM ztv_daytaskopen
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['daytaskfinish'] = <<<EOT
|
|
SELECT * FROM ztv_daytaskfinish
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['daybugopen'] = <<<EOT
|
|
SELECT * FROM ztv_daybugopen
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['daybugresolve'] = <<<EOT
|
|
SELECT * FROM ztv_daybugresolve
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['productstories'] = <<<EOT
|
|
SELECT * FROM ztv_productstories
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['productbugs'] = <<<EOT
|
|
SELECT * FROM ztv_productbugs
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['projectsummary'] = <<<EOT
|
|
SELECT * FROM ztv_projectsummary
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['executionsummary'] = <<<EOT
|
|
SELECT * FROM ztv_executionsummary
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['projectstories'] = <<<EOT
|
|
SELECT * FROM ztv_projectstories
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['projectbugs'] = <<<EOT
|
|
SELECT * FROM ztv_projectbugs
|
|
EOT;
|
|
$config->bi->duckdb->ztvtables['projectteams'] = <<<EOT
|
|
SELECT * FROM ztv_projectteams
|
|
EOT;
|