import  requests
import urllib3
urllib3.disable_warnings()
from jira import  JIRA
import pandas as pd
def login_jira(username,password):jira = JIRA("https://jira.cn/",basic_auth=(username,password))#projects=jira.project(id=13)# jql='project="云鏈-供應鏈中臺-材料域" AND created >= 2020-07-1 AND created <=now() 'testIssue = jira.issue("jira-13244")print(testIssue)#issues=jira.search_issues('project="PS" AND creator=currentUser() order by created DESC', maxResults=1000)issues=jira.search_issues('project="PS" AND assignee=currentUser()  AND updated > "-1d"  AND assignee=currentUser() AND (status="待處理" OR status="開發中" OR status="待開發" OR status = "重新打開" OR status = "修復中") order by priority DESC', maxResults=1000)a=["key","標題","狀態","子任務","createtime","項目名","link","優先級",'解決時間',"對應開發","問題類型","問題報告人"]datas=[]for index,issue in enumerate(issues):# b = [issue.key, issue.fields.summary, issue.fields.status, issue.fields.subtasks, issue.fields.created,#      issue.fields.project.name,#      issue.self, issue.fields.priority, issue.fields.description, issue.fields.versions[0].name if len(issue.fields.versions)>0 else None,#      issue.fields.resolutiondate, issue.fields.assignee, issue.fields.issuetype,"陳權"]b = [issue.key, issue.fields.summary, issue.fields.status, issue.fields.subtasks, issue.fields.created,issue.fields.project.name,issue.self, issue.fields.priority,issue.fields.resolutiondate, issue.fields.assignee, issue.fields.issuetype,"測試"]datas.append(b)print(datas)df=pd.DataFrame(datas,columns=a)# pd.DataFrame.from_dict(datas,orient='index',columns=[a])print(df)df_tmp=df.query("狀態!='完成'")df_tmp.to_csv("./static_excel_ptt.csv", encoding='utf_8_sig',header=["key","標題","狀態","子任務","createtime","項目名","link","優先級",'解決時間',"對應開發","問題類型","問題報告人"])return jiradef get_comments_content(issue):return [comment.body for comment in issue.fields.comment.comments]if __name__ == '__main__':login_jira("user","pswd")

import  requests
import urllib3
urllib3.disable_warnings()
from jira import  JIRA
import pandas as pd
def login_jira(username,password):jira = JIRA("https://jira.cn/",basic_auth=(username,password))#projects=jira.project(id=13)# jql='project="云鏈-供應鏈中臺-材料域" AND created >= 2020-07-1 AND created <=now() 'testIssue = jira.issue("jira-13244")print(testIssue)#issues=jira.search_issues('project="PS" AND creator=currentUser() order by created DESC', maxResults=1000)issues=jira.search_issues('project="PS" AND assignee=currentUser()  AND updated > "-1d"  AND assignee=currentUser() AND (status="待驗證" OR status="開發中" OR status="進行中" OR status="修復中") order by priority DESC', maxResults=1000)a=["key","標題","狀態","子任務","createtime","項目名","link","優先級",'解決時間',"對應開發","問題類型","問題報告人"]datas=[]for index,issue in enumerate(issues):# b = [issue.key, issue.fields.summary, issue.fields.status, issue.fields.subtasks, issue.fields.created,#      issue.fields.project.name,#      issue.self, issue.fields.priority, issue.fields.description, issue.fields.versions[0].name if len(issue.fields.versions)>0 else None,#      issue.fields.resolutiondate, issue.fields.assignee, issue.fields.issuetype,"陳權"]b = [issue.key, issue.fields.summary, issue.fields.status, issue.fields.subtasks, issue.fields.created,issue.fields.project.name,issue.self, issue.fields.priority,issue.fields.resolutiondate, issue.fields.assignee, issue.fields.issuetype,"測試"]datas.append(b)print(datas)df=pd.DataFrame(datas,columns=a)# pd.DataFrame.from_dict(datas,orient='index',columns=[a])print(df)df_tmp=df.query("狀態!='完成'")df_tmp.to_csv("./static_excel_ptt.csv", encoding='utf_8_sig',header=["key","標題","狀態","子任務","createtime","項目名","link","優先級",'解決時間',"對應開發","問題類型","問題報告人"])return jiradef get_comments_content(issue):return [comment.body for comment in issue.fields.comment.comments]if __name__ == '__main__':login_jira("user","pswd")

---

創作不易，小小的支持一下吧！