yfwlwCut/script_file/send_flow_alarm.py

from qcloudsms_py import SmsSingleSender
from qcloudsms_py.httpclient import HTTPError
from qcloudsms_py import SmsMultiSender
import os
import django
import sys

BASE_DIR = os.path.dirname(os.path.abspath(__file__))  # 定位到你的django根目录
sys.path.append(os.path.abspath(os.path.join(BASE_DIR, os.pardir)))

os.environ.setdefault("DJANGO_SETTINGS_MODULE",
                      "yfwlw_pro.settings")  # project_name 项目名称
django.setup()
import json
import time
import requests
import datetime
from apps.ReportManage.all_dict import mobile_list, insect_dict_new
from apps.AppInfoManage.models import Equip, Equip_type, CBDphoto, Msg_Send, Msg_Conf, Equip_SimInfo, SCDstatus, CBDstatus


# 短信应用 SDK AppID
appid = 1400227496  # SDK AppID 以1400开头
# 短信应用 SDK AppKey
appkey = "c9aba961bd30072f1e1b9272077abaea"

simlist = Equip_SimInfo.objects.all()
for i in simlist:
    dateTime_p = datetime.datetime.strptime(i.expiry_date,'%Y-%m-%d %H:%M:%S')
    # 判断sim卡是否30天到期
    if dateTime_p - datetime.datetime.now() > datetime.timedelta(days=30):
        pass
    elif datetime.timedelta(days=0) > dateTime_p - datetime.datetime.now() > datetime.timedelta(days=0):
        print("发送短信通知")
    elif dateTime_p - datetime.datetime.now() < datetime.timedelta(days=0):
        if i.equip_id.equip_type_id == 2:
            print("杀虫灯")
            # 判断杀虫灯状态30天内是否有数据
            if datetime.datetime.now() - SCDstatus.objects.get(equip_id=i.equip_id).upl_time > datetime.timedelta(days=30):
                pass
            else:
                print("停用账号")
        elif i.equip_id.equip_type_id == 3:
            print("测报灯")
            # 判断测报灯状态30天内是否有数据
            if datetime.datetime.now() - CBDstatus.objects.get(equip_id=i.equip_id).upl_time > datetime.timedelta(days=30):
                pass
            else:
                print("停用账号")