yfwlwCut/script_file/qxz_online.py

# -*- coding: utf-8 -*-
# File Name:mqtt_chat_client.py
# Python Version:3.5.1

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

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
from apps.AppInfoManage.models import Equip, Equip_type, MyUser, CBDphoto, CBDstatus, QXZdata, SCDstatus, CBDstatus, Equip_SimInfo, CBDdata, BZYphoto, RecentCBDdata,RecentSCDdata,\
Msg_Conf, Msg_Send, JKphoto, YBQphoto, QXZstatus_New
import re
import datetime
import time
import random
from apps.SimInfo.views import get_siminfo
from apps.ReportManage.all_dict import insect_dict_new, transpont_equip_scd
import shutil


qxz_list = QXZstatus_New.objects.all()
nowtime = datetime.datetime.now()

for i in qxz_list:
    if i.upl_time.year == nowtime.year and i.upl_time.month == nowtime.month and i.upl_time.day == nowtime.day:
        pass
    else:
        i.is_online = "0"
        i.off_time = datetime.datetime.now()
        i.save()
        print("设备id",i.equip_id_id)