有一个需求,就是想通过 RPA 工具,(类爬虫工具),把一个网站的数据落成结构化的数据,比如 EXCEL 或者 TXT , 在对数据进行分析 ; (背景,研发、测试、产品都在类似禅道这样的系统进行相关任务单填写工时,想把数据弄下来,进行人效分析);
1
Evrins 142 天前
这个需求不应该直接对接 禅道 的 api 吗?
|
2
zangai 142 天前
实在智能
|
3
CadonHo 142 天前
禅道有专门的 api ,直接从 api 里获取数据效率更高
|
4
EndlessMemory 142 天前
影刀看看
|
5
dassh 142 天前
直接查数据库吧
SELECT x.realname as 姓名, x.product_name as 所属产品, x.id as 编号, x.task_name as 任务名称, x.pri as 优先级, x.estStarted as 预计开始, x.realStarted as 实际开始, x.deadline as 截止日期, x.finishedDate as 实际完成, DATEDIFF(x.finishedDate, x.deadline) as 延期(天), format(x.estimate,1) as 最初预计, format(x.consumed,1) as 任务总消耗 FROM (SELECT a.id,a.project, b.realname, a.name as task_name, a.pri, d.name as product_name, a.consumed, a.estimate, a.estStarted, a.deadline, a.realStarted, a.finishedDate FROM `zt_task` a join zt_user b on a.finishedBy = b.account join (select project, min(product) as product from zt_projectproduct group by project) c on a.project = c.project join zt_product d on c.product = d.id where a.status in ("done", "closed") and a.deleted = 1 and a.finishedDate >={start} and a.finishedDate < {end} ) x ORDER BY x.realname, x.product_name, x.finishedDate |