#?安裝依賴
pip3?install?zhdate

pip3?install?pymysql

create?table?birthday
(
????id????????int?auto_increment
????????primary?key,
????name??????varchar(100)??not?null?comment?'名稱',
????yl_birth??varchar(100)??not?null?comment?'陰歷生日',
????remark????varchar(100)??null?comment?'備注',
????is_delete?int?default?0?null?comment?'0：正常? 1：刪除'
)
????comment?'生日';

import?pymysql

class?Birth(object):
????def?__init__(self):
????????self.db?=?pymysql.connect(host='**',
??????????????????????????????????user='root',
??????????????????????????????????password='**',
??????????????????????????????????database='xag')
????????self.cursor?=?self.db.cursor()

????def?__get_births(self):
????????#?獲取所有數(shù)據(jù)
????????self.cursor.execute("""
?????????????????????????????select?name,yl_birth,remark?from?birthday?where?is_delete=0;""")

????????datas?=?list(self.cursor.fetchall())

from?zhdate?import?ZhDate

...
??def?__get_diff(self,?birth):
????????"""
????????根據(jù)農歷生日，獲取當前日期距離的時間（天）
????????:param birth:?農歷生日，格式：10-25
????????:return:
????????"""
????????#?1、獲取今日的農歷日歷
????????now?=?str(datetime.now().strftime('%Y-%m-%d')).split("-")
????????#?年、月、日
????????year,?month,?day?=?int(now[0]),?int(now[1]),?int(now[2])

????????#?1、獲取陰歷生日，轉為陽歷
????????birth_month?=?int(birth.split("-")[0].strip())
????????birth_day?=?int(birth.split("-")[-1].strip())
????????birth_ying?=?ZhDate(year,?birth_month,?birth_day)

????????#?轉為陽歷
????????birth_yang?=?birth_ying.to_datetime()

????????#?2、計算距離當前日期的時間間隔（天）
????????today?=?datetime.now().strftime('%Y-%m-%d')
????????d1?=?datetime.strptime(today,?'%Y-%m-%d')

????????diff_day?=?(birth_yang-d1).days
????????return?diff_day

...
?#?遍歷數(shù)據(jù)
????????for?item?in?datas:
????????????name?=?item[0]
????????????birth?=?item[1]
????????????nickname?=?item[2]
????????????diff?=?self.__get_diff(birth)
...

import?requests
import?json

...
???def?send_wechat(self,?msg:?str):
????????"""發(fā)送信息到企業(yè)微信"""
????????#?這里填寫你的機器人的webhook鏈接
????????url?=?'https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key**'
????????headers?=?{"Content-Type":?"text/plain"}
????????data?=?{
????????????"msgtype":?"text",
????????????"text":?{
????????????????"content":?msg
????????????}
????????}
????????#?發(fā)送消息
????????requests.post(url,?headers=headers,?data=json.dumps(data))
...