Jira看板，自动统计工作量
// ==UserScript==
// @name Jira Tools
// @namespace http://www.akuvox.com/
// @version 1.6
// @description Jira看板，自动统计工作量
// @author minjie.chen
// @match http://192.168.10.2:82/secure/RapidBoard.jspa?rapidView=11*
// @icon https://www.google.com/s2/favicons?sz=64&domain=10.2
// @grant none
// @license minjie.chen
// ==/UserScript==
(function() {
/*库方法*/
HTMLElement.prototype.appendHTML = function(html) {
var divTemp = document.createElement("div"), nodes = null
, fragment = document.createDocumentFragment();
divTemp.innerHTML = html;
nodes = divTemp.childNodes;
for (var i=0, length=nodes.length; i<length; i+=1) {
fragment.appendChild(nodes[i].cloneNode(true));
}
this.appendChild(fragment);
nodes = null;
fragment = null;
};
setInterval(doGetDataAndShowWorkload, 1000);
function doGetDataAndShowWorkload(){
// 页面及所有资源加载完成后执行的代码
$.get('http://192.168.10.2:82/rest/greenhopper/1.0/xboard/work/allData.json?rapidViewId=11&selectedProjectKey=ANDROID', function(data) {
// 请求成功，打印响应数据
showWorkload(data);
}).fail(function() {
// 请求失败，打印错误信息
showWorkload("");
});
}
var loadButton = true;
var isFirst = true;
function showWorkload(data){
//var element = document.getElementsByClassName("subnav-container")[0].parentNode;
var element = document.getElementById("ghx-operations");
if(loadButton){
loadButton = false;
document.getElementById('ghx-header').setAttribute('isshow',0);
element.appendHTML("<a class=\"aui-button aui-button-primary aui-style\" onclick=\"document.getElementById('LastMonthPBX').style.display = '';document.getElementById('ghx-header').setAttribute('isshow',1);\" >上月PBC</a><a class=\"aui-button aui-button-primary aui-style \" onclick=\"document.getElementById('CurMonthPBX').style.display = '';document.getElementById('ghx-header').setAttribute('isshow',1);\">本月PBC</a><a class=\"aui-button aui-button-primary aui-style \" onclick=\"document.getElementById('NextMonthPBX').style.display = '';document.getElementById('ghx-header').setAttribute('isshow',1);\" >下月PBC</a></br>");
}
if(document.getElementById("AkuvoxWorkload") !== null){
document.getElementById("AkuvoxWorkload").innerHTML = "";
element = document.getElementById("AkuvoxWorkload");
}
if(data == ""){
element.appendHTML("<span id=\"AkuvoxWorkload\" style=\"color: red;font-size: 20px;\">工作量统计错误，请刷新界面</span>");
return;
}
var allData = data.issuesData.issues;
var timeData = getMyWorkLoad(allData);
var displayName = getDisplayName();
console.log(timeData);
element.appendHTML("<span id=\"AkuvoxWorkload\" style=\"font-size: 20px;\">"+displayName+":本周工作量：<span style=\"color:red;\">"+hoursToDaysAndHours(timeData.thisWeekWorkload)+"</span>; 下周工作量：<span style=\"color:red;\">"+hoursToDaysAndHours(timeData.netWeekWorkload)+"</span><br>"+displayName+":本月工作量：<span style=\"color:red;\">"+hoursToDaysAndHours(timeData.thisMonthWorkload)+"</span>; 下月工作量：<span style=\"color:red;\">"+hoursToDaysAndHours(timeData.nextMonthWorkload)+"</span></span>");
var body = document.getElementById("jira");
var lastPbc = "";
for(var i = 0;i<timeData.lastMonthResult.length;i++){
var dueDate = ""
var worktime = ""
for(var j = 0;j<timeData.lastMonthResult[i].extraFields.length;j++){
if(timeData.lastMonthResult[i].extraFields[j].label == "到期日" || timeData.lastMonthResult[i].extraFields[j].label == "Due Date" || allData[i].extraFields[j].label == "Target end"){
dueDate = timeData.lastMonthResult[i].extraFields[j].html;
var regex = /<time[^>]*>([^<]*)<\/time>/;
var match = dueDate.match(regex);
if (match && match[1]) {
dueDate = match[1];
}
}
if(timeData.lastMonthResult[i].extraFields[j].label == "初始预估" || timeData.lastMonthResult[i].extraFields[j].label == "Original Estimate"){
worktime = timeData.lastMonthResult[i].extraFields[j].html;
}
}
lastPbc = lastPbc + ("<tr><td>" + timeData.lastMonthResult[i].summary + "</td><td>" + dueDate + "</td><td>" + dueDate+ "</td><td>" + worktime+ "</td><td>" + 0 + "</td><td>"+ 0+ "</td><td>" + 0 + "</td>");
}
var curPbc = "";
for(var i = 0;i<timeData.thisMonthResult.length;i++){
var dueDate = ""
var worktime = ""
for(var j = 0;j<timeData.thisMonthResult[i].extraFields.length;j++){
if(timeData.thisMonthResult[i].extraFields[j].label == "到期日" || timeData.thisMonthResult[i].extraFields[j].label == "Due Date" || allData[i].extraFields[j].label == "Target end"){
dueDate = timeData.thisMonthResult[i].extraFields[j].html;
var regex = /<time[^>]*>([^<]*)<\/time>/;
var match = dueDate.match(regex);
if (match && match[1]) {
dueDate = match[1];
}
}
if(timeData.thisMonthResult[i].extraFields[j].label == "初始预估" || timeData.thisMonthResult[i].extraFields[j].label == "Original Estimate"){
worktime = timeData.thisMonthResult[i].extraFields[j].html;
}
}
curPbc = curPbc + ("<tr><td>" + timeData.thisMonthResult[i].summary + "</td><td>" + dueDate + "</td><td>" + dueDate+ "</td><td>" + worktime+ "</td><td>" + 0 + "</td><td>"+ 0+ "</td><td>" + 0 + "</td>");
}
var nextPbc = "";
for(var i = 0;i<timeData.nextMonthResult.length;i++){
var dueDate = ""
var worktime = ""
for(var j = 0;j<timeData.nextMonthResult[i].extraFields.length;j++){
if(timeData.nextMonthResult[i].extraFields[j].label == "到期日" || timeData.nextMonthResult[i].extraFields[j].label == "Due Date" || allData[i].extraFields[j].label == "Target end"){
dueDate = timeData.nextMonthResult[i].extraFields[j].html;
var regex = /<time[^>]*>([^<]*)<\/time>/;
var match = dueDate.match(regex);
if (match && match[1]) {
dueDate = match[1];
}
}
if(timeData.nextMonthResult[i].extraFields[j].label == "初始预估" || timeData.nextMonthResult[i].extraFields[j].label == "Original Estimate"){
worktime = timeData.nextMonthResult[i].extraFields[j].html;
}
}
nextPbc = nextPbc + ("<tr><td>" + timeData.nextMonthResult[i].summary + "</td><td>" + dueDate + "</td><td>" + dueDate+ "</td><td>" + worktime+ "</td><td>" + 0 + "</td><td>"+ 0+ "</td><td>" + 0 + "</td>");
}
var last = body;
var cur = body;
var next = body;
var isShow = document.getElementById('ghx-header').getAttribute('isShow');
console.log("isShow:",isShow);
if(isShow == 0){
if(document.getElementById("LastMonthPBX") !== null){
console.log("dlaksjdlasjkl!!!!!!!!!!!!!!!!!!!!");
document.getElementById("LastMonthPBX").innerHTML = "";
document.getElementById("CurMonthPBX").innerHTML = "";
document.getElementById("NextMonthPBX").innerHTML = "";
//body.removeChild(document.getElementById("LastMonthPBX"));
//body.removeChild(document.getElementById("CurMonthPBX"));
//body.removeChild(document.getElementById("NextMonthPBX"));
last = document.getElementById("LastMonthPBX");
cur = document.getElementById("CurMonthPBX");
next = document.getElementById("NextMonthPBX");
}
last.appendHTML("<div id=\"LastMonthPBX\" class=\"jira-dialog box-shadow jira-dialog-open popup-width-custom jira-dialog-content-ready\" style=\"width: 810px; margin-left: -406px;top: 0%;"+(isFirst?"display:none":"")+"\">" +
"<span class=\"ghx-iconfont aui-icon aui-icon-small aui-iconfont-close-dialog\" onclick=\"document.getElementById('LastMonthPBX').style.display = 'none';document.getElementById('ghx-header').setAttribute('isshow',0);\" style=\"float: right;\"></span>" +
"<table border=\"1\"><tr><th>任务名称</th><th>计划完成时间</th><th>实际完成时间</th><th>工作量</th><th>已超期</th><th>未完成</th><th>难度系数</th></tr>"+lastPbc+"</table></div>");
cur.appendHTML("<div id=\"CurMonthPBX\" class=\"jira-dialog box-shadow jira-dialog-open popup-width-custom jira-dialog-content-ready\" style=\"width: 810px; margin-left: -406px;top: 0%;"+(isFirst?"display:none":"")+"\">" +
"<span class=\"ghx-iconfont aui-icon aui-icon-small aui-iconfont-close-dialog\" onclick=\"document.getElementById('CurMonthPBX').style.display = 'none';document.getElementById('ghx-header').setAttribute('isshow',0);\" style=\"float: right;\"></span>" +
"<table border=\"1\"><tr><th>任务名称</th><th>计划完成时间</th><th>实际完成时间</th><th>工作量</th><th>已超期</th><th>未完成</th><th>难度系数</th></tr>"+curPbc+"</table></div>");
next.appendHTML("<div id=\"NextMonthPBX\" class=\"jira-dialog box-shadow jira-dialog-open popup-width-custom jira-dialog-content-ready\" style=\"width: 810px; margin-left: -406px;top: 0%;"+(isFirst?"display:none":"")+"\">" +
"<span class=\"ghx-iconfont aui-icon aui-icon-small aui-iconfont-close-dialog\" onclick=\"document.getElementById('NextMonthPBX').style.display = 'none';document.getElementById('ghx-header').setAttribute('isshow',0);\" style=\"float: right;\"></span>" +
"<table border=\"1\"><tr><th>任务名称</th><th>计划完成时间</th><th>实际完成时间</th><th>工作量</th><th>已超期</th><th>未完成</th><th>难度系数</th></tr>"+nextPbc+"</table></div>");
}
isFirst=false;
}
function isDateInThisWeek(dateString) {
// 将日期字符串转换为 Date 对象
var date = new Date(dateString);
// 获取当前日期
var currentDate = new Date();
// 获取当前日期的星期几（0表示星期日，1表示星期一，以此类推）
var currentDayOfWeek = currentDate.getDay();
// 获取本周一的日期
var monday = new Date(currentDate);
monday.setDate(currentDate.getDate() - currentDayOfWeek + 1);
monday.setHours(0, 0, 0, 0);
// 获取本周日的日期
var sunday = new Date(currentDate);
sunday.setDate(currentDate.getDate() + (7 - currentDayOfWeek));
sunday.setHours(23, 59, 59, 999);
// 将待判断日期与本周一和本周日进行比较
return date >= monday && date <= sunday;
}
function isDateInNextWeek(dateString) {
// 将日期字符串转换为 Date 对象
var date = new Date(dateString);
// 获取当前日期
var currentDate = new Date();
// 获取当前日期的星期几（0表示星期日，1表示星期一，以此类推）
var currentDayOfWeek = currentDate.getDay();
// 计算下周一的日期
var nextMonday = new Date(currentDate);
nextMonday.setDate(currentDate.getDate() - currentDayOfWeek + 8);
nextMonday.setHours(0, 0, 0, 0);
// 计算下周日的日期
var nextSunday = new Date(currentDate);
nextSunday.setDate(currentDate.getDate() - currentDayOfWeek + 14);
nextSunday.setHours(23, 59, 59, 999);
// 将待判断日期与下周一和下周日进行比较
return date >= nextMonday && date <= nextSunday;
}
function isDateInThisMonth(dateString) {
// 将日期字符串转换为 Date 对象
var date = new Date(dateString);
// 获取当前日期
var currentDate = new Date();
// 获取当前日期的年份和月份
var currentYear = currentDate.getFullYear();
var currentMonth = currentDate.getMonth();
// 获取待判断日期的年份和月份
var targetYear = date.getFullYear();
var targetMonth = date.getMonth();
// 判断待判断日期是否属于本月
return currentYear === targetYear && currentMonth === targetMonth;
}
function isDateInLastMonth(dateString) {
// 将日期字符串转换为 Date 对象
var date = new Date(dateString);
// 获取当前日期
var currentDate = new Date();
// 获取当前日期的年份和月份
var currentYear = currentDate.getFullYear();
var currentMonth = currentDate.getMonth();
// 获取待判断日期的年份和月份
var targetYear = date.getFullYear();
var targetMonth = date.getMonth();
// 判断待判断日期是否是上个月
if (currentYear === (targetYear+1) && currentMonth === 0 && targetMonth === 11) {
return true; // 当前是1月，待判断日期是去年的12月
}
return currentYear === targetYear && currentMonth - 1 === targetMonth;
}
function isDateInNextMonth(dateString) {
// 将日期字符串转换为 Date 对象
var date = new Date(dateString);
// 获取当前日期
var currentDate = new Date();
// 获取当前日期的年份和月份
var currentYear = currentDate.getFullYear();
var currentMonth = currentDate.getMonth();
// 获取待判断日期的年份和月份
var targetYear = date.getFullYear();
var targetMonth = date.getMonth();
// 计算下个月的年份和月份
var nextMonthYear = currentYear;
var nextMonth = currentMonth + 1;
if (nextMonth === 12) {
nextMonthYear = currentYear + 1;
nextMonth = 0;
}
// 判断待判断日期是否属于下个月
return targetYear === nextMonthYear && targetMonth === nextMonth;
}
function timeToHours(time) {
// 定义时间单位与小时的换算关系
const weeksToHours = 5 * 8;
const daysToHours = 8;
let totalHours = 0;
var array = time.split(",");
for(var i = 0 ;i<array.length;i++){
const [amount, unit] = array[i].trim().split(' ');
// 根据单位进行换算，并累加到总小时数
if (unit === 'week' || unit === 'weeks') {
totalHours += parseInt(amount) * weeksToHours;
} else if (unit === 'day' || unit === 'days') {
totalHours += parseInt(amount) * daysToHours;
} else if (unit === 'hour' || unit === 'hours') {
totalHours += parseInt(amount);
}
}
return totalHours;
}
function getUserName(){
var currentURL = window.location.href;
if (currentURL.includes('quickFilter=')) {
// 提取quickFilter参数的值
const urlParams = new URLSearchParams(currentURL.split('?')[1]);
const quickFilterValue = urlParams.get('quickFilter');
if(quickFilterValue == 54){
return "minjie.chen"
}else if(quickFilterValue == 55){
return "guoyong.lin"
}else if(quickFilterValue == 59){
return "weijian.wang"
}else if(quickFilterValue == 57){
return "hao.jiang"
}else if(quickFilterValue == 56){
return "minghui.zhou"
}else if(quickFilterValue == 58){
return "kaijia.wu"
}else if(quickFilterValue == 60){
return "nairong.yang"
}else if(quickFilterValue == 127){
return "zhixian.yang"
}else if(quickFilterValue == 137){
return "shize.huang"
}else if(quickFilterValue == 138){
return "xianhong.zhang"
}else if(quickFilterValue == 179){
return "zixin.liu"
}else if(quickFilterValue == 190){
return "kai.xiong"
}else{
return document.getElementById("header-details-user-fullname").getAttribute('data-username');
}
} else {
return document.getElementById("header-details-user-fullname").getAttribute('data-username');
}
}
function getDisplayName(){
var currentURL = window.location.href;
if (currentURL.includes('quickFilter=')) {
// 提取quickFilter参数的值
const urlParams = new URLSearchParams(currentURL.split('?')[1]);
const quickFilterValue = urlParams.get('quickFilter');
if(quickFilterValue == 54){
return "陈敏杰"
}else if(quickFilterValue == 55){
return "林国勇"
}else if(quickFilterValue == 59){
return "王伟建"
}else if(quickFilterValue == 57){
return "江昊"
}else if(quickFilterValue == 56){
return "周明辉"
}else if(quickFilterValue == 58){
return "吴铠嘉"
}else if(quickFilterValue == 60){
return "杨乃容"
}else if(quickFilterValue == 127){
return "杨智贤"
}else if(quickFilterValue == 137){
return "黄世泽"
}else if(quickFilterValue == 138){
return "张显鸿"
}else if(quickFilterValue == 179){
return "刘紫馨"
}else if(quickFilterValue == 190){
return "熊凯"
}else{
return document.getElementById("header-details-user-fullname").getAttribute('data-displayname');
}
} else {
return document.getElementById("header-details-user-fullname").getAttribute('data-displayname');
}
}
function hoursToDaysAndHours(hours) {
// 计算天数和剩余小时数
var days = Math.floor(hours / 8);
var remainingHours = hours % 8;
// 构造结果字符串
var result = "";
if (days > 0) {
result += days + "天 ";
}
result += remainingHours + "小时";
return result;
}
function getMyWorkLoad(allData){
// 获得用户名
var userName = getUserName();
var thisWeekWorkload = 0;
var netWeekWorkload = 0;
var thisMonthWorkload = 0;
var nextMonthWorkload = 0;
var thisMonthResult = [];
var nextMonthResult = [];
var lastMonthResult = [];
for(var i = 0;i<allData.length;i++){
if(allData[i].assignee == userName){
var thisWeek = 0;
var nextWeek = 0;
var thisMonth = 0;
var nextMonth = 0;
var time = 0;
for(var j = 0;j<allData[i].extraFields.length;j++){
if(allData[i].extraFields[j].label == "初始预估" || allData[i].extraFields[j].label == "Original Estimate"){
time = timeToHours(allData[i].extraFields[j].html);
}else if(allData[i].extraFields[j].label == "到期日" || allData[i].extraFields[j].label == "Due Date" || allData[i].extraFields[j].label == "Target end"){
var targetTime = allData[i].extraFields[j].html;
var regex = /<time[^>]*>([^<]*)<\/time>/;
var match = targetTime.match(regex);
if (match && match[1]) {
targetTime = match[1];
}
if(isDateInThisWeek(targetTime)){
console.log("时间=",allData[i]);
thisWeek = time;
}
if(isDateInNextWeek(targetTime)){
nextWeek = time;
}
if(isDateInThisMonth(targetTime)){
thisMonth = time;
thisMonthResult.push(allData[i]);
break;
}
if(isDateInNextMonth(targetTime)){
nextMonth = time;
nextMonthResult.push(allData[i]);
break;
}
if(isDateInLastMonth(targetTime)){
lastMonthResult.push(allData[i]);
break;
}
}
}
thisWeekWorkload += thisWeek;
netWeekWorkload += nextWeek;
thisMonthWorkload += thisMonth;
nextMonthWorkload += nextMonth;
}
}
return {"thisWeekWorkload":thisWeekWorkload,"netWeekWorkload":netWeekWorkload,"thisMonthWorkload":thisMonthWorkload,"nextMonthWorkload":nextMonthWorkload,"thisMonthResult":thisMonthResult,"nextMonthResult":nextMonthResult,"lastMonthResult":lastMonthResult};
}
})();