# -*- coding: utf-8 -*-
# *** Spyder Python Console History Log ***

## ---(Thu Jul  1 16:01:32 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runcell(0, 'C:/Users/B180093/.spyder-py3/python_test/file_read.py')

## ---(Thu Jul  1 16:31:16 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runcell(0, 'C:/Users/B180093/.spyder-py3/python_test/file_read.py')

## ---(Thu Jul  1 16:33:02 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runcell(0, 'C:/Users/B180093/.spyder-py3/python_test/file_read.py')

## ---(Thu Jul  1 16:42:47 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(excel_data)
sub_assignee.append({'name': temp[i]})

## ---(Fri Jul  2 11:46:15 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print('ddd')
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(dump)
print(type(dump))
dump = dict(r2.text)
print(type(dump))
dump = eval(r2.text)
print(type(dump))
print(dump.keys())
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Mon Jul  5 09:06:55 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runcell(0, 'C:/Users/B180093/.spyder-py3/python_test/file_read.py')
print(excel_data.loc[0])
print(excel_data.loc[4])
print(excel_data.loc34])
print(excel_data.loc[3])
print(excel_data.loc[3]['Project Key'])
print(type(excel_data.loc[3]['Project Key']))
print(excel_data.loc[3]['Project Key'] == 'nan')
print(excel_data.loc[3]['Project Key'] == 'NaN')
print(pd.notnull(excel_data.loc[3]['Project Key']))
print(pd.null(excel_data.loc[3]['Project Key']))
print(pd.isnull(excel_data.loc[3]['Project Key']))
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(excel_data.loc[1])
print(excel_data.loc[1]['Issue Type'])
print(type(excel_data.loc[1]['Issue Type']))
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(data['fields']['issuetype'])
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
print(type(r))
print(r.status_code, r.text)
print(type(r))
print(type(r.status_code), r.text)
print(excel_data[excel_data.loc[2]['Parent No'] == excel_data['No']]['Result'])
runfile('C:/Users/B180093/.spyder-py3/python_test/file_read.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/python_test/untitled0.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runcell(0, 'C:/Users/B180093/.spyder-py3/python_test/test2.py')
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(final_result['1']['Start date'])
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(final_result[4]['Start date'])
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Tue Jul  6 10:44:02 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runcell(0, 'C:/Users/B180093/.spyder-py3/python_test/test2.py')
print(type(final_result[1]['Start date']))
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(final_result[1])
print(len(final_result))
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
print(r.status_code, r.text)
print(dump)
runfile('C:/Users/B180093/.spyder-py3/python_test/test2.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('X:/anaconda3/envs/telechips/testcode/test.py', wdir='X:/anaconda3/envs/telechips/testcode')

## ---(Mon Jul 19 08:25:18 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/tims_issuecreate/test_chip_option.py', wdir='C:/Users/B180093/.spyder-py3/tims_issuecreate')

## ---(Tue Jul 20 08:22:51 2021)---
runfile('Z:/anaconda3/envs/telechips/test_request.py', wdir='Z:/anaconda3/envs/telechips')
runfile('X:/anaconda3/envs/telechips/testcode/test.py', wdir='X:/anaconda3/envs/telechips/testcode')

## ---(Thu Jul 22 08:56:36 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
debugfile('X:/anaconda3/envs/telechips/main/tcs.py', wdir='X:/anaconda3/envs/telechips/main')

## ---(Thu Jul 22 17:26:06 2021)---
runfile('C:/Users/B180093/.spyder-py3/tims_issuecreate/test_chip_option.py', wdir='C:/Users/B180093/.spyder-py3/tims_issuecreate')
runcell(0, 'C:/Users/B180093/.spyder-py3/tims_issuecreate/test_chip_option.py')
runfile('C:/Users/B180093/.spyder-py3/tims_issuecreate/test_chip_option.py', wdir='C:/Users/B180093/.spyder-py3/tims_issuecreate')

## ---(Mon Jul 26 08:13:39 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('Z:/python_cron/untitled0.py', wdir='Z:/python_cron')
runcell(0, 'Z:/python_cron/untitled0.py')
runfile('Z:/python_testcode/test2.py', wdir='Z:/python_testcode')
runcell(0, 'Z:/python_testcode/test2.py')
runfile('Z:/python_testcode/test2.py', wdir='Z:/python_testcode')
print(data[0])
print(data)
runfile('Z:/python_testcode/test2.py', wdir='Z:/python_testcode')
print(columns[0])
print(len(columns))
runfile('Z:/python_testcode/test2.py', wdir='Z:/python_testcode')
print(data.loc[0])
runfile('Z:/python_testcode/test2.py', wdir='Z:/python_testcode')
print(table_td)
runfile('Z:/python_testcode/test2.py', wdir='Z:/python_testcode')

## ---(Wed Jul 28 08:48:30 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Thu Jul 29 08:37:17 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Fri Jul 30 09:32:03 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Mon Aug  2 09:21:32 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Aug  3 08:25:13 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Wed Aug  4 09:35:46 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Aug  6 10:30:01 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/untitled0.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Aug 10 09:58:56 2021)---
runfile('X:/anaconda3/envs/telechips/testcode/bot_view_count.py', wdir='X:/anaconda3/envs/telechips/testcode')

## ---(Fri Aug 20 11:28:15 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/bot_view_count.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Wed Aug 25 09:51:24 2021)---
runfile('Y:/anaconda3/envs/telechips/main/untitled0.py', wdir='Y:/anaconda3/envs/telechips/main')

## ---(Thu Aug 26 09:05:09 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/docx_create.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Fri Aug 27 11:27:01 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/test.py')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'Y:/anaconda3/envs/telechips/main/tcs.py')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/test.py')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Aug 30 08:58:43 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/test.py')
print(type('Q898XL-132'.split('-')[0]))
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print('Q898XL-132'.split('-')[0])
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(type(r.status_code))

## ---(Tue Aug 31 10:09:30 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Y:/anaconda3/envs/telechips/testcode/git_commit_request_test.py', wdir='Y:/anaconda3/envs/telechips/testcode')
print(profield_data1 == list)
print(type(profield_data1))
runfile('Y:/anaconda3/envs/telechips/testcode/git_commit_request_test.py', wdir='Y:/anaconda3/envs/telechips/testcode')
print(isinstance(profield_data1, list))
runfile('Y:/anaconda3/envs/telechips/testcode/git_commit_request_test.py', wdir='Y:/anaconda3/envs/telechips/testcode')

## ---(Wed Sep  1 14:37:19 2021)---
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Sep  3 14:06:30 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Sep  7 11:11:16 2021)---
runfile('C:/Users/B180093/.spyder-py3/untitled0.py', wdir='C:/Users/B180093/.spyder-py3')
print(team_code)
runfile('C:/Users/B180093/.spyder-py3/Worklog_dev_ratio.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Sep  8 09:12:17 2021)---
runfile('Y:/anaconda3/envs/telechips/testcode/bot_view_count.py', wdir='Y:/anaconda3/envs/telechips/testcode')

## ---(Wed Sep 15 08:52:24 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(type(calendar.monthrange(year, month-1)[1]))
print(calendar.monthrange(year, month-1)[1])
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(working_date_min2)
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(working_date_min)
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/untitled0.py', wdir='C:/Users/B180093/.spyder-py3')
print(r.text)
runfile('C:/Users/B180093/.spyder-py3/untitled0.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/untitled0.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Sep 16 08:42:19 2021)---
runfile('C:/Users/B180093/.spyder-py3/Lineworks_bot_message_singleuser.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/python_test/carousel_test.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/python_test/test_bot_flex.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/Lineworks_bot_message_singleuser.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/Lineworks_bot_message_worklog_sample.py', wdir='C:/Users/B180093/.spyder-py3')
print(calendar.monthrange(year, month-1)[1])
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
print(calendar.monthrange(year, month-1)[1])
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
print(calendar.monthrange(year, month-1)[1])
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
print(user_data)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
print(working_date)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
print(year_before, month_before)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Sep 27 09:35:42 2021)---
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
import requests
import simplejson as json
from datetime import datetime
from dateutil.relativedelta import relativedelta
import pymongo
import calendar

# pymongo에 접속해서 id, pw data를 가져 옴(rnd_rest_api_account)
conn = pymongo.MongoClient("219.240.43.93", 27017)
db = conn.tcs
col = db.id_pw
pw_data = col.find({})
id_pw = {'os_username': pw_data[1]['id'], 'os_password': pw_data[1]['pw']}

# user_data document에서 G-leader, CTO, T-Leader를 제외한 연구원들의 정보를 가져옴
col = db.user_data
#user_data = list(col.find({"leader": {"$nin": ["G-Leader", "CTO", "T-Leader"]}}))
user_data = list(col.find({"name": "신호찬 (Chance H Shin)"}))
#user_data = list(col.find({"team": "RND Innovation Team"}))


headers = {
    'Content-Type': 'application/json; charset=UTF-8',
    'consumerKey': 'IuAF6mCrW4FiTxWF6bmm',
    'Authorization': 'Bearer AAABAXONcN0Ch9T4YmhyDiRG+1ilvRZoM1MoutdUZLzV6++m3h+/fipKAlD0I1OKCbAJFWhuiQV07ldyuY1M3qu0pVEKqWcrhPdK5k2PKp2Xo42bfFsPleMt8D0+ZHqJVGrXPdw3JheNM5hkVqpzEc0l24vlpymIeLTg74+aEUFa+SpI6mjkbP5vJwD5kR8auewDnQgmuE1cwdBVlveJq2ZDC7ohbAF29Hfd/Wmc75h72LAC3W1Zea+4LF/UpKoBnSxCmqSInyWmyYwAJ5HBrPp/9PdoxB5SqRma2aFswhmwvaR/6AClqjmuAKdGlcgA+DertSmLCCer7i2iNXxNimgqXsrvEAHQQpLwtrv8IGdcV/sf'
}

today = datetime.now()  # 현재일시
year = today.year  # 이번달의 년도
month = today.month  # 이번달
date = today.day  # 오늘날짜

if month == '3' or month == '6' or month == '9' or month == '12':
    # 전월 계산
    month_ago = today - relativedelta(month = -1)
    year_before = str(month_ago.year)  #전월의 년도
    month_before = str(month_ago.month)  #전월
    date_before = calendar.monthrange(year, month-1)[1]  #전달의 마지막 날짜
    
    print(month_ago)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
import requests
import simplejson as json
from datetime import datetime
from dateutil.relativedelta import relativedelta
import pymongo
import calendar

# pymongo에 접속해서 id, pw data를 가져 옴(rnd_rest_api_account)
conn = pymongo.MongoClient("219.240.43.93", 27017)
db = conn.tcs
col = db.id_pw
pw_data = col.find({})
id_pw = {'os_username': pw_data[1]['id'], 'os_password': pw_data[1]['pw']}

# user_data document에서 G-leader, CTO, T-Leader를 제외한 연구원들의 정보를 가져옴
col = db.user_data
#user_data = list(col.find({"leader": {"$nin": ["G-Leader", "CTO", "T-Leader"]}}))
user_data = list(col.find({"name": "신호찬 (Chance H Shin)"}))
#user_data = list(col.find({"team": "RND Innovation Team"}))


headers = {
    'Content-Type': 'application/json; charset=UTF-8',
    'consumerKey': 'IuAF6mCrW4FiTxWF6bmm',
    'Authorization': 'Bearer AAABAXONcN0Ch9T4YmhyDiRG+1ilvRZoM1MoutdUZLzV6++m3h+/fipKAlD0I1OKCbAJFWhuiQV07ldyuY1M3qu0pVEKqWcrhPdK5k2PKp2Xo42bfFsPleMt8D0+ZHqJVGrXPdw3JheNM5hkVqpzEc0l24vlpymIeLTg74+aEUFa+SpI6mjkbP5vJwD5kR8auewDnQgmuE1cwdBVlveJq2ZDC7ohbAF29Hfd/Wmc75h72LAC3W1Zea+4LF/UpKoBnSxCmqSInyWmyYwAJ5HBrPp/9PdoxB5SqRma2aFswhmwvaR/6AClqjmuAKdGlcgA+DertSmLCCer7i2iNXxNimgqXsrvEAHQQpLwtrv8IGdcV/sf'
}

today = datetime.now()  # 현재일시
year = today.year  # 이번달의 년도
month = today.month  # 이번달
date = today.day  # 오늘날짜

if month == 3 or month == 6 or month == 9 or month == 12:
    # 전월 계산
    month_ago = today - relativedelta(month = -1)
    year_before = str(month_ago.year)  #전월의 년도
    month_before = str(month_ago.month)  #전월
    date_before = calendar.monthrange(year, month-1)[1]  #전달의 마지막 날짜
    
    print(month_ago)
import requests
import simplejson as json
from datetime import datetime
from dateutil.relativedelta import relativedelta
import pymongo
import calendar

# pymongo에 접속해서 id, pw data를 가져 옴(rnd_rest_api_account)
conn = pymongo.MongoClient("219.240.43.93", 27017)
db = conn.tcs
col = db.id_pw
pw_data = col.find({})
id_pw = {'os_username': pw_data[1]['id'], 'os_password': pw_data[1]['pw']}

# user_data document에서 G-leader, CTO, T-Leader를 제외한 연구원들의 정보를 가져옴
col = db.user_data
#user_data = list(col.find({"leader": {"$nin": ["G-Leader", "CTO", "T-Leader"]}}))
user_data = list(col.find({"name": "신호찬 (Chance H Shin)"}))
#user_data = list(col.find({"team": "RND Innovation Team"}))


headers = {
    'Content-Type': 'application/json; charset=UTF-8',
    'consumerKey': 'IuAF6mCrW4FiTxWF6bmm',
    'Authorization': 'Bearer AAABAXONcN0Ch9T4YmhyDiRG+1ilvRZoM1MoutdUZLzV6++m3h+/fipKAlD0I1OKCbAJFWhuiQV07ldyuY1M3qu0pVEKqWcrhPdK5k2PKp2Xo42bfFsPleMt8D0+ZHqJVGrXPdw3JheNM5hkVqpzEc0l24vlpymIeLTg74+aEUFa+SpI6mjkbP5vJwD5kR8auewDnQgmuE1cwdBVlveJq2ZDC7ohbAF29Hfd/Wmc75h72LAC3W1Zea+4LF/UpKoBnSxCmqSInyWmyYwAJ5HBrPp/9PdoxB5SqRma2aFswhmwvaR/6AClqjmuAKdGlcgA+DertSmLCCer7i2iNXxNimgqXsrvEAHQQpLwtrv8IGdcV/sf'
}

today = datetime.now()  # 현재일시
year = today.year  # 이번달의 년도
month = today.month  # 이번달
date = today.day  # 오늘날짜

if month == 3 or month == 6 or month == 9 or month == 12:
    # 전월 계산
    month_ago = today + relativedelta(month = -1)
    year_before = str(month_ago.year)  #전월의 년도
    month_before = str(month_ago.month)  #전월
    date_before = calendar.monthrange(year, month-1)[1]  #전달의 마지막 날짜
    
    print(month_ago)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
import requests
import simplejson as json
from datetime import datetime
from dateutil.relativedelta import relativedelta
import pymongo
import calendar

# pymongo에 접속해서 id, pw data를 가져 옴(rnd_rest_api_account)
conn = pymongo.MongoClient("219.240.43.93", 27017)
db = conn.tcs
col = db.id_pw
pw_data = col.find({})
id_pw = {'os_username': pw_data[1]['id'], 'os_password': pw_data[1]['pw']}

# user_data document에서 G-leader, CTO, T-Leader를 제외한 연구원들의 정보를 가져옴
col = db.user_data
#user_data = list(col.find({"leader": {"$nin": ["G-Leader", "CTO", "T-Leader"]}}))
user_data = list(col.find({"name": "신호찬 (Chance H Shin)"}))
#user_data = list(col.find({"team": "RND Innovation Team"}))


headers = {
    'Content-Type': 'application/json; charset=UTF-8',
    'consumerKey': 'IuAF6mCrW4FiTxWF6bmm',
    'Authorization': 'Bearer AAABAXONcN0Ch9T4YmhyDiRG+1ilvRZoM1MoutdUZLzV6++m3h+/fipKAlD0I1OKCbAJFWhuiQV07ldyuY1M3qu0pVEKqWcrhPdK5k2PKp2Xo42bfFsPleMt8D0+ZHqJVGrXPdw3JheNM5hkVqpzEc0l24vlpymIeLTg74+aEUFa+SpI6mjkbP5vJwD5kR8auewDnQgmuE1cwdBVlveJq2ZDC7ohbAF29Hfd/Wmc75h72LAC3W1Zea+4LF/UpKoBnSxCmqSInyWmyYwAJ5HBrPp/9PdoxB5SqRma2aFswhmwvaR/6AClqjmuAKdGlcgA+DertSmLCCer7i2iNXxNimgqXsrvEAHQQpLwtrv8IGdcV/sf'
}

today = datetime.now()  # 현재일시
year = today.year  # 이번달의 년도
month = today.month  # 이번달
date = today.day  # 오늘날짜

if month == 3 or month == 6 or month == 9 or month == 12:
    # 전월 계산
    month_ago = today + relativedelta(months = -1)
    year_before = str(month_ago.year)  #전월의 년도
    month_before = str(month_ago.month)  #전월
    date_before = calendar.monthrange(year, month-1)[1]  #전달의 마지막 날짜
    
    col = db.working_date
    # 전월 최소시간 계산
    working_date_min1 = list(col.find({'$and': [{'year': int(year_before)}, {'month': int(month_before)}]}, {'_id': 0}))
    working_date_min = (working_date_min1[0]['working_date']) * 8  #전월의 최소 근무시간
    
    conn.close()
    
    # 전월 최대시간 계산
    working_date_max = int(7.428 * (date_before))
    
    # -2월 계산
    month_2ago = today + relativedelta(months = -2)
    year_2before = str(month_2ago.year)  #전월의 년도
    month_2before = str(month_2ago.month)  #전월
    date_2before = calendar.monthrange(year, month-2)[1]  #전달의 마지막 날짜
    
    print(month_2before)
import requests
import simplejson as json
from datetime import datetime
from dateutil.relativedelta import relativedelta
import pymongo
import calendar

# pymongo에 접속해서 id, pw data를 가져 옴(rnd_rest_api_account)
conn = pymongo.MongoClient("219.240.43.93", 27017)
db = conn.tcs
col = db.id_pw
pw_data = col.find({})
id_pw = {'os_username': pw_data[1]['id'], 'os_password': pw_data[1]['pw']}

# user_data document에서 G-leader, CTO, T-Leader를 제외한 연구원들의 정보를 가져옴
col = db.user_data
#user_data = list(col.find({"leader": {"$nin": ["G-Leader", "CTO", "T-Leader"]}}))
user_data = list(col.find({"name": "신호찬 (Chance H Shin)"}))
#user_data = list(col.find({"team": "RND Innovation Team"}))


headers = {
    'Content-Type': 'application/json; charset=UTF-8',
    'consumerKey': 'IuAF6mCrW4FiTxWF6bmm',
    'Authorization': 'Bearer AAABAXONcN0Ch9T4YmhyDiRG+1ilvRZoM1MoutdUZLzV6++m3h+/fipKAlD0I1OKCbAJFWhuiQV07ldyuY1M3qu0pVEKqWcrhPdK5k2PKp2Xo42bfFsPleMt8D0+ZHqJVGrXPdw3JheNM5hkVqpzEc0l24vlpymIeLTg74+aEUFa+SpI6mjkbP5vJwD5kR8auewDnQgmuE1cwdBVlveJq2ZDC7ohbAF29Hfd/Wmc75h72LAC3W1Zea+4LF/UpKoBnSxCmqSInyWmyYwAJ5HBrPp/9PdoxB5SqRma2aFswhmwvaR/6AClqjmuAKdGlcgA+DertSmLCCer7i2iNXxNimgqXsrvEAHQQpLwtrv8IGdcV/sf'
}

today = datetime.now()  # 현재일시
year = today.year  # 이번달의 년도
month = today.month  # 이번달
date = today.day  # 오늘날짜

if month == 3 or month == 6 or month == 9 or month == 12:
    # 전월 계산
    month_ago = today + relativedelta(months = -1)
    year_before = str(month_ago.year)  #전월의 년도
    month_before = str(month_ago.month)  #전월
    date_before = calendar.monthrange(year, month-1)[1]  #전달의 마지막 날짜
    
    col = db.working_date
    # 전월 최소시간 계산
    working_date_min1 = list(col.find({'$and': [{'year': int(year_before)}, {'month': int(month_before)}]}, {'_id': 0}))
    working_date_min = (working_date_min1[0]['working_date']) * 8  #전월의 최소 근무시간
    
    conn.close()
    
    # 전월 최대시간 계산
    working_date_max = int(7.428 * (date_before))
    
    # -2월 계산
    month_2ago = today + relativedelta(months = -2)
    year_2before = str(month_2ago.year)  #전월의 년도
    month_2before = str(month_2ago.month)  #전월
    date_2before = calendar.monthrange(year, month-2)[1]  #전달의 마지막 날짜
    
    print(date_2before)
import requests
import simplejson as json
from datetime import datetime
from dateutil.relativedelta import relativedelta
import pymongo
import calendar

# pymongo에 접속해서 id, pw data를 가져 옴(rnd_rest_api_account)
conn = pymongo.MongoClient("219.240.43.93", 27017)
db = conn.tcs
col = db.id_pw
pw_data = col.find({})
id_pw = {'os_username': pw_data[1]['id'], 'os_password': pw_data[1]['pw']}

# user_data document에서 G-leader, CTO, T-Leader를 제외한 연구원들의 정보를 가져옴
col = db.user_data
#user_data = list(col.find({"leader": {"$nin": ["G-Leader", "CTO", "T-Leader"]}}))
user_data = list(col.find({"name": "신호찬 (Chance H Shin)"}))
#user_data = list(col.find({"team": "RND Innovation Team"}))


headers = {
    'Content-Type': 'application/json; charset=UTF-8',
    'consumerKey': 'IuAF6mCrW4FiTxWF6bmm',
    'Authorization': 'Bearer AAABAXONcN0Ch9T4YmhyDiRG+1ilvRZoM1MoutdUZLzV6++m3h+/fipKAlD0I1OKCbAJFWhuiQV07ldyuY1M3qu0pVEKqWcrhPdK5k2PKp2Xo42bfFsPleMt8D0+ZHqJVGrXPdw3JheNM5hkVqpzEc0l24vlpymIeLTg74+aEUFa+SpI6mjkbP5vJwD5kR8auewDnQgmuE1cwdBVlveJq2ZDC7ohbAF29Hfd/Wmc75h72LAC3W1Zea+4LF/UpKoBnSxCmqSInyWmyYwAJ5HBrPp/9PdoxB5SqRma2aFswhmwvaR/6AClqjmuAKdGlcgA+DertSmLCCer7i2iNXxNimgqXsrvEAHQQpLwtrv8IGdcV/sf'
}

today = datetime.now()  # 현재일시
year = today.year  # 이번달의 년도
month = today.month  # 이번달
date = today.day  # 오늘날짜

if month == 3 or month == 6 or month == 9 or month == 12:
    # 전월 계산
    month_ago = today + relativedelta(months = -1)
    year_before = str(month_ago.year)  #전월의 년도
    month_before = str(month_ago.month)  #전월
    date_before = calendar.monthrange(year, month-1)[1]  #전달의 마지막 날짜
    
    col = db.working_date
    # 전월 최소시간 계산
    working_date_min1 = list(col.find({'$and': [{'year': int(year_before)}, {'month': int(month_before)}]}, {'_id': 0}))
    working_date_min = (working_date_min1[0]['working_date']) * 8  #전월의 최소 근무시간
    
    conn.close()
    
    # 전월 최대시간 계산
    working_date_max = int(7.428 * (date_before))
    
    # -2월 계산
    month_2ago = today + relativedelta(months = -2)
    year_2before = str(month_2ago.year)  #전월의 년도
    month_2before = str(month_2ago.month)  #전월
    date_2before = calendar.monthrange(year, month-2)[1]  #전달의 마지막 날짜
    
    print(year_2before)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(type(today.day))
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Sep 27 16:07:23 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Sep 28 08:55:10 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/test.py')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(today)
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Sep 29 09:14:07 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/Lineworks_noti_worklog.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Sep 30 09:09:04 2021)---
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Oct  1 11:11:02 2021)---
runfile('Z:/python_cron/Lineworks_noti_month_worklog.py', wdir='Z:/python_cron')
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Z:/python_cron/Lineworks_noti_month_worklog.py', wdir='Z:/python_cron')
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Z:/python_cron/Lineworks_noti_month_worklog.py', wdir='Z:/python_cron')
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Z:/python_cron/Lineworks_noti_month_worklog.py', wdir='Z:/python_cron')
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
print(body)
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Z:/python_cron/Lineworks_noti_month_worklog.py', wdir='Z:/python_cron')
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Oct  1 14:34:09 2021)---
runfile('C:/Users/B180093/.spyder-py3/Worklog_noti_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
print(user_data)
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Z:/python_cron/Lineworks_noti_month_worklog.py', wdir='Z:/python_cron')
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Oct  5 10:56:25 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/tempo_test.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/tempo_test.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/tempo_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Oct  6 10:54:25 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/profield_dataDB_create_page.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/project_role_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/profield_dataDB_create_page.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Oct  7 09:49:58 2021)---
runfile('C:/Users/B180093/.spyder-py3/tempo_test.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/tempo_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Oct  8 08:30:49 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Oct 12 13:48:31 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Oct 18 10:15:37 2021)---
runfile('C:/Users/B180093/.spyder-py3/Worklog_dev_ratio.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Oct 19 10:59:48 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Oct 22 13:59:21 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Oct 22 15:56:37 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_request.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Oct 25 14:07:23 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_atlassian_cloud.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Oct 26 15:54:21 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Oct 28 16:42:41 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Nov  1 10:13:31 2021)---
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')
day = datetime.now()
print(day.month)
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
day = datetime.now() + timedelta(days=-3)
print(day.month)
print(type(day.month))
runfile('C:/Users/B180093/.spyder-py3/test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_worklog_noti.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Nov  2 09:22:57 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_worklog_noti.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Nov  4 14:29:20 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_tims_copy_debug.py', wdir='C:/Users/B180093/.spyder-py3')
clear
print(r.text)
clear
runfile('C:/Users/B180093/.spyder-py3/test_tims_copy_debug.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('Y:/anaconda3/envs/telechips/main/rest.py', wdir='Y:/anaconda3/envs/telechips/main')
runfile('C:/Users/B180093/.spyder-py3/test_tims_copy_debug.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Nov  5 17:17:24 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_tims_copy_debug.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Nov 10 09:02:31 2021)---
runfile('Y:/anaconda3/envs/telechips/testcode/bot_view_count.py', wdir='Y:/anaconda3/envs/telechips/testcode')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/css_data_parse.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/css_data_parse.py')
print(len(data1['list'][0]['child']))
runfile('C:/Users/B180093/.spyder-py3/css_data_parse.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/css_data_parse.py')
runfile('C:/Users/B180093/.spyder-py3/css_data_parse.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/css_data_parse.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/css_data_parse.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/css_data_parse.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Nov 15 10:47:18 2021)---
runcell(0, 'Y:/anaconda3/envs/telechips/main/tcs.py')

## ---(Tue Nov 16 09:56:16 2021)---
runfile('C:/Users/B180093/.spyder-py3/python_test/docx_create.py', wdir='C:/Users/B180093/.spyder-py3/python_test')

## ---(Wed Nov 17 10:10:50 2021)---
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Nov 17 10:29:57 2021)---
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Nov 17 10:32:45 2021)---
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/python_test/docx_create.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Nov 19 09:24:43 2021)---
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/gerrit_api_test.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/ldap_auth.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Mon Nov 22 09:39:18 2021)---
runfile('C:/Users/B180093/.spyder-py3/ldap_auth.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('Y:/anaconda3/envs/telechips/testcode/bot_view_count.py', wdir='Y:/anaconda3/envs/telechips/testcode')
runfile('Y:/anaconda3/envs/telechips/testcode/test_htmltopdf.py', wdir='Y:/anaconda3/envs/telechips/testcode')
runfile('Z:/python_cron/Lineworks_noti_worklog.py', wdir='Z:/python_cron')

## ---(Wed Nov 24 08:32:00 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_tims_tcs_issuecopy.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_tims_tcs_issuecopy.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_tims_tcs_issuecopy.py', wdir='C:/Users/B180093/.spyder-py3')
print(tims_data['fields']['customfield_11300'])
print(tims_data['fields']['customfield_12001']['value'])
print(tims_data['fields']['customfield_12200']['value'])
print(tims_data['fields']['customfield_12002']['value'])
print(tims_data['fields']['customfield_10003']['value'])
print(tims_data['fields']['comment'])
print(tims_data['fields']['comment']['body'])
print(tims_data['fields']['comment'][0]['body'])
print(tims_data['fields']['comment'][0]['comments'])
print(tims_data['fields']['comment']['comments'][0]['body'])
runfile('C:/Users/B180093/.spyder-py3/test_tims_tcs_issuecopy.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/python_test/carousel_test.py', wdir='C:/Users/B180093/.spyder-py3/python_test')
runfile('C:/Users/B180093/.spyder-py3/test_tims_tcs_issuecopy.py', wdir='C:/Users/B180093/.spyder-py3')
print(tims_data['fields']['customfield_12001'])
runfile('C:/Users/B180093/.spyder-py3/test_tims_tcs_issuecopy.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/test_css_api.py')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_patchissue_css.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runcell(0, 'C:/Users/B180093/.spyder-py3/test_patchissue_css.py')
runfile('C:/Users/B180093/.spyder-py3/test_patchissue_css.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Nov 25 08:43:55 2021)---
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_patchissue_css.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(len(data_sdk_patch_list['list']))
runfile('C:/Users/B180093/.spyder-py3/test_patchissue_css.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list)
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list['TCC803x_Android10_IVI__1.0.0'])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(len(sdk_list['TCC803x_Android10_IVI__1.0.0'][2]))
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Nov 25 13:21:05 2021)---
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list[0])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list.keys()[0])
print(list(sdk_list.keys()))
print(list(sdk_list.keys())[0])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list.keys())
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list)
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
print(day.microsecond)

## ---(Fri Nov 26 10:54:50 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list)
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list[0])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list[0][3])
print(len(sdk_list[0][3]))
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list[0])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(data[0])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
cler
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(sdk_list_dict.keys())
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(list(sdk_list_dict.keys()))

## ---(Mon Nov 29 10:17:14 2021)---
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear

## ---(Tue Nov 30 14:02:39 2021)---
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Dec  1 11:12:44 2021)---
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
clear
print(css_tims['list'])

## ---(Thu Dec  2 10:25:45 2021)---
runfile('C:/Users/B180093/.spyder-py3/project_key_category_DB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/teamcode_userDB_create.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_minor.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Dec  3 10:04:11 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Dec  7 09:43:40 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_recalculate.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Dec  7 13:16:54 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_RnDdashboard_dataDBcreate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Dec  7 17:04:10 2021)---
runfile('C:/Users/B180093/.spyder-py3/worklog_DBcreate.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Dec  9 09:27:46 2021)---
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
print(data_sdk_list)
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Dec 10 16:15:40 2021)---
runfile('Z:/python_cron/untitled0.py', wdir='Z:/python_cron')
runfile('Z:/python_cron/test2.py', wdir='Z:/python_cron')
runfile('Z:/python_cron/Wikicreate_profield_data.py', wdir='Z:/python_cron')

## ---(Tue Dec 14 17:43:14 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Dec 15 08:40:30 2021)---
runfile('C:/Users/B180093/.spyder-py3/Worklog_dev_ratio.py', wdir='C:/Users/B180093/.spyder-py3')
print(r.status_code, r.text)
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Thu Dec 16 12:15:11 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
print('TMTPD-123'.split('-'))
print('TMTPD-123'.split('-')[0])
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Fri Dec 17 08:45:01 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/DBcreate_css_sdk_list.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/ldap_auth.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Tue Dec 21 10:53:32 2021)---
runfile('C:/Users/B180093/.spyder-py3/test_css_api.py', wdir='C:/Users/B180093/.spyder-py3')
runfile('C:/Users/B180093/.spyder-py3/ldap_auth.py', wdir='C:/Users/B180093/.spyder-py3')

## ---(Wed Dec 22 08:38:49 2021)---
runfile('C:/Users/B180093/.spyder-py3/ldap_auth.py', wdir='C:/Users/B180093/.spyder-py3')