def queryState(ID):
res = {"success": 1, "data": 0, "msg": ""}
typeDone = gol._Get_Value('chargingDone', '启动')
state = gol._Get_Value('chargingState', 0)
times = gol._Get_Value('chargingTimes', 0)
# 模拟状态调整
time.sleep(1)
if (times < 5):
times += 1
gol._Set_Value('chargingTimes', times, True)
if (typeDone == "启动"):
res['msg'] = "充电启动中"
elif (typeDone == "停止"):
res['msg'] = "充电停止中"
else:
gol._Set_Value('chargingTimes', 0, True)
if (typeDone == "启动"):
gol._Set_Value('chargingState', 11, True)
res['success'] = 1
res['data'] = 11
res['msg'] = "充电已启动"
elif (typeDone == "停止"):
gol._Set_Value('chargingState', -1, True)
res['success'] = 1
res['data'] = -1
res['msg'] = "充电已停止"
return myData_Json.Trans_ToJson_str(res)
def stockSetQuery_risk():
#载入配置
usrID = request.args.get('usrID', "")
stockName = request.args.get('stockName', "")
stockTag = request.args.get('stockTag', "")
#筛选
res = {"success": 1, "data": "", "msg": ""}
try:
#strUrl = "http://" + request.remote_addr + ":8669/zxcAPI/robot" #实际网络地址在阿里云有问题，原因未明
strUrl = "http://127.0.0.1:8669/zxcAPI/robot"
strPath = F'stock/QuoteSetRisk/Query?usrID={usrID}&code_id={stockTag}&code_name={stockName}'
#设置查询接口执行
pWeb = myWeb_urlLib.myWeb(strUrl, bPrint=False)
strReturn = pWeb.Do_API_get(strPath, "zxcAPI-py")
print("查询结果：\n", strUrl, "--\n", strReturn, "\n")
jsonRes = myData_Json.Trans_ToJson(strReturn)
res['data'] = jsonRes['text']
res['success'] = int(jsonRes['result'])
except Exception as err:
res['success'] = 0
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
def stockSetQuery_info():
#载入配置
stockName = request.args.get('stockName', "")
stockTag = request.args.get('stockTag', "").split('.')
usrID = request.args.get('usrID', "")
#筛选
res = {"success": 1, "data": "", "msg": ""}
try:
#strUrl = "http://" + request.remote_addr + ":8669/zxcAPI/robot" #实际网络地址在阿里云有问题，原因未明
strUrl = "http://127.0.0.1:8669/zxcAPI/robot"
strPath = 'stock/QuoteSetInfo/Query?stockName=' + stockName + "&exType=" + stockTag[
0] + "&stockID=" + stockTag[1] + "&usrID=" + usrID
#设置查询接口执行
pWeb = myWeb_urlLib.myWeb(strUrl, bPrint=False)
strReturn = pWeb.Do_API_get(strPath, "zxcAPI-py")
print("查询结果：\n", strUrl, "--\n", strReturn, "\n")
jsonRes = myData_Json.Trans_ToJson(strReturn)
#结果处理
res['data'] = jsonRes['text']
res['success'] = int(jsonRes['result'])
except Exception as err:
res['success'] = 0
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
def companysQuery():
#载入配置
pageIndex = myData_Trans.To_Int(request.args.get('pageIndex', 1))
pageSize = myData_Trans.To_Int(request.args.get('pageSize', 15))
companyID = request.args.get('companyID', "")
companyName = request.args.get('companyName', "")
companyInStreet = request.args.get('companyInStreet', "")
companyInVillage = request.args.get('companyInVillage', "")
companyAdrr = request.args.get('companyAdrr', "")
companyScale = request.args.get('companyScale', "")
companySpecialcase = request.args.get('companySpecialcase', "")
companyManangeclass = request.args.get('companyManangeclass', "")
companyContacts = request.args.get('companyContacts', "")
#组装筛选条件
fliter = ""
if (companyID != ""): fliter += " && companyID == " + companyID
if (companyName != ""):
fliter += " && companyName %like% " + companyName
if (companyInStreet != ""):
fliter += " && companyInStreet == " + companyInStreet
if (companyInVillage != ""):
fliter += " && companyInVillage == " + companyInVillage
if (companyAdrr != ""): fliter += " && companyAdrr == " + companyAdrr
if (companyScale != ""):
fliter += " && companyScale == " + companyScale
if (companySpecialcase != ""):
fliter += " && companySpecialcase == " + companySpecialcase
if (companyManangeclass != ""):
fliter += " && companyManangeclass == " + companyManangeclass
if (companyContacts != ""):
fliter += " && companyContacts == " + companyContacts
if (fliter != ""): fliter = fliter[4:]
#筛选
res = {"success": 1, "data": "", "msg": ""}
try:
dbCompany = gol._Get_Value('dbCompany')
totalCount, pCompanys = dbCompany.getCompanys(param=fliter,
isDel=False,
page=pageIndex,
per_page=pageSize)
res['data'] = pCompanys
res['totalCount'] = totalCount
except Exception as err:
res['success'] = 0
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
def output(self, lstReturn):
pMsg = copy.deepcopy(gol._Get_Setting('Return_strFormat', {}))
if (lstReturn != None and len(lstReturn) > 1):
datas = []
for x in lstReturn:
datas.append(x.toDict())
pMsg['datas'] = datas
pMsg['result'] = True
strJson = myData_Json.Trans_ToJson_str(pMsg)
path = self.Dir_Swaps + "/Quote_" + myData_Trans.Tran_ToDatetime_str(
None, "%Y-%m-%d-%H-%M-%S") + ".json"
myIO.Save_File(path, strJson, isUtf=True, isNoBoom=True)
return True
return False
def chargingStop():
# 模拟停
res = {"success": 1, "data": "", "msg": ""}
state = gol._Get_Value('chargingState', 0)
typeDone = gol._Get_Value('chargingDone', '')
if (typeDone == '启动'):
res['success'] = 0
res['msg'] = "充电停止中"
elif (state > 0):
res['msg'] = "尝试停止充电"
gol._Set_Value('chargingDone', '停止', True)
else:
res['success'] = 0
res['msg'] = "错误"
return myData_Json.Trans_ToJson_str(res)
def toJsonstr(self):
dictValue = {}
dictValue["exType"] = self.extype
dictValue["exName"] = self.exName
dictValue["exArea"] = self.area
dictValue["codeType"] = self.type
dictValue["codeID"] = self.code_id
dictValue["codeName"] = self.code_name
dictValue["codeNameEN"] = self.code_name_En
dictValue["isIndex"] = self.isIndex
dictValue["tradeStatus"] = self.tradeStatus
dictValue["srcName"] = self.source_set
dictValue["srcCode"] = self.source_code
dictValue["exType2"] = self.extype2
return myData_Json.Trans_ToJson_str(dictValue)
def companysQuery_save():
#载入配置
companyID = request.args.get('companyID', "")
companyName = request.args.get('companyName', "")
companyInStreet = request.args.get('companyInStreet', "")
companyInVillage = request.args.get('companyInVillage', "")
companyScale = request.args.get('companyScale', "")
companyHasProcess = request.args.get('companyHasProcess', "")
#组装筛选条件
fliter = ""
if (companyID != ""): fliter += " && companyID == " + companyID
if (companyName != ""): fliter += " && companyName == " + companyName
if (companyInStreet != ""):
fliter += " && companyInStreet == " + companyInStreet
if (companyInVillage != ""):
fliter += " && companyInVillage == " + companyInVillage
if (companyScale != ""):
fliter += " && companyScale == " + companyScale
if (companyHasProcess != ""):
fliter += " && companyHasProcess == " + str(
myData.iif(companyHasProcess == "是", True, False))
if (fliter != ""): fliter = fliter[4:]
#筛选
res = {"success": 1, "data": "", "msg": ""}
try:
dbCompany = gol._Get_Value('dbCompany')
totalCount, pCompanys = dbCompany.getCompanys(param=fliter,
isDel=False,
page=1,
per_page=99999999)
#保存
path = appWeb.baseDir + "/static/data/Companys/企业信息数据表.csv"
dbCompany.Save_as_csv(path, pCompanys, True)
res['filename'] = "企业信息数据表.csv"
res['filefloder'] = "Companys"
res['totalCount'] = totalCount
except Exception as err:
res['success'] = 0
res['msg'] = err
return myData_Json.Trans_ToJson_str(res)
def companysQuery_del():
#载入配置
companyID = request.args.get('companyID', "")
companyName = request.args.get('companyName', "")
#删除
res = {"success": 1, "data": "", "msg": ""}
try:
dbCompany = gol._Get_Value('dbCompany')
pCompany = dbCompany.getCompany(companyID, companyName)
if (pCompany != None):
pCompany["isDel"] = True
dbCompany.Save_DB()
res['data'] = "删除成功。"
else:
res['data'] = "公司信息不存在。"
except Exception as err:
res['success'] = 0
res['data'] = "删除失败。"
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
def toJsonstr(self):
return myData_Json.Trans_ToJson_str(self.toDict())
def getResult(self):
return myData_Json.Trans_ToJson_str(self.modelResult)
"temperature_outlet": 100,
"smoke_speed_outlet": 5,
"wind_speed_outlet": ""
}
},
"infoTarget": [{
"id": "1",
"longitude": 113.83,
"latitude": 22.83,
"height": 0
}, {
"id": "2",
"longitude": 113.835,
"latitude": 22.835,
"height": 0
}],
"infoEnvironment": {
"wind_speed": 2,
"wind_direction": "SW",
"wind_height": 10,
"air_stability": "C",
"temperature": 26,
"cloudy_is": True
}
}
jsonParam = myData_Json.Trans_ToJson_str(param)
pModel.initParam_str(jsonParam)
pModel.runModel()
print(pModel.getResult())
def companysQuery_save2():
#载入配置
companyID = request.args.get('companyID', "")
companyName = request.args.get('companyName', "")
companyInStreet = request.args.get('companyInStreet', "")
companyInVillage = request.args.get('companyInVillage', "")
companyAdrr = request.args.get('companyAdrr', "")
companyScale = request.args.get('companyScale', "")
companySpecialcase = request.args.get('companySpecialcase', "")
companyManangeclass = request.args.get('companyManangeclass', "")
companyContacts = request.args.get('companyContacts', "")
companyContacts = request.args.get('companyContacts', "")
#组装筛选条件
fliter = ""
if (companyID != ""): fliter += " && companyID == " + companyID
if (companyName != ""): fliter += " && companyName == " + companyName
if (companyInStreet != ""):
fliter += " && companyInStreet == " + companyInStreet
if (companyInVillage != ""):
fliter += " && companyInVillage == " + companyInVillage
if (companyAdrr != ""): fliter += " && companyAdrr == " + companyAdrr
if (companyScale != ""):
fliter += " && companyScale == " + companyScale
if (companySpecialcase != ""):
fliter += " && companySpecialcase == " + companySpecialcase
if (companyManangeclass != ""):
fliter += " && companyManangeclass == " + companyManangeclass
if (companyContacts != ""):
fliter += " && companyContacts == " + companyContacts
if (fliter != ""): fliter = fliter[4:]
#筛选
res = {"success": 1, "data": "", "msg": ""}
try:
dbCompany = gol._Get_Value('dbCompany')
totalCount, pCompanys = dbCompany.getCompanys(param=fliter,
isDel=False,
page=1,
per_page=99999999)
#保存
path = appWeb.baseDir + "/static/data/Companys/企业信息数据表.csv"
dbCompany.Save_as_csv(path, pCompanys, True)
res['filename'] = "企业信息数据表.csv"
res['filefloder'] = "Companys"
res['totalCount'] = totalCount
"""
import requests
from openpyxl.drawing import image
from openpyxl import Workbook
image_bytes=requests.get('https://images2015.cnblogs.com/blog/1135581/201704/1135581-20170407154037347-2055197925.png').content
data_stream=image.BytesIO(image_bytes)
im=image.Image(data_stream)
wb=Workbook()
ws=wb.active
#设置单元格的行高列宽
c=ws.column_dimensions['A']
#设置行高列宽公式里面的96为图片的水平和垂直分辨率。即所谓的dpi。
c.width=im.width*12/96
r=ws.row_dimensions[1]
r.height=im.height*72/96
ws.add_image(im,'A1')
wb.save('demo.xlsx')
"""
path = appWeb.baseDir + "/static/data/Companys/企业信息数据表.csv"
dbCompany.Save_as_csv(path, pCompanys, True)
res['filename'] = "企业信息数据表.csv"
res['filefloder'] = "Companys"
res['totalCount'] = totalCount
except Exception as err:
res['success'] = 0
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
def companysQuery_save():
#载入配置
companyID = request.args.get('companyID', "")
companyName = request.args.get('companyName', "")
companyInStreet = request.args.get('companyInStreet', "")
companyInVillage = request.args.get('companyInVillage', "")
companyAdrr = request.args.get('companyAdrr', "")
companyScale = request.args.get('companyScale', "")
companySpecialcase = request.args.get('companySpecialcase', "")
companyManangeclass = request.args.get('companyManangeclass', "")
companyContacts = request.args.get('companyContacts', "")
companyContacts = request.args.get('companyContacts', "")
#组装筛选条件
fliter = ""
if (companyID != ""): fliter += " && companyID == " + companyID
if (companyName != ""):
fliter += " && companyName %like% " + companyName
if (companyInStreet != ""):
fliter += " && companyInStreet == " + companyInStreet
if (companyInVillage != ""):
fliter += " && companyInVillage == " + companyInVillage
if (companyAdrr != ""): fliter += " && companyAdrr == " + companyAdrr
if (companyScale != ""):
fliter += " && companyScale == " + companyScale
if (companySpecialcase != ""):
fliter += " && companySpecialcase == " + companySpecialcase
if (companyManangeclass != ""):
fliter += " && companyManangeclass == " + companyManangeclass
if (companyContacts != ""):
fliter += " && companyContacts == " + companyContacts
if (fliter != ""): fliter = fliter[4:]
#筛选
res = {"success": 1, "data": "", "msg": ""}
try:
dbCompany = gol._Get_Value('dbCompany')
totalCount, pCompanys = dbCompany.getCompanys(param=fliter,
isDel=False,
page=1,
per_page=99999999)
if (totalCount == 0):
res['success'] = 0
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
#保存属性信息
nameUUID = myIO.create_UUID()
dirTemp = myIO.checkPath(appWeb.baseDir +
"static/data/temp/temp_" + nameUUID + "/")
myIO.mkdir(dirTemp, True, True)
nameFile = "企业信息数据表"
if (totalCount == 1): nameFile = pCompanys[0]['companyName']
nameFile = nameFile + "_" + nameUUID
dbCompany.Save_as_csv(dirTemp + nameFile + ".csv", pCompanys, True)
#保存相关图片
files = []
newfiles = []
imgSrcdir = appWeb.baseDir
dictImgs = {
"imgName_1": "图片_相关部门证明",
"imgName_2": "图片_正门照片",
"imgName_3": "图片_生产车间照片",
"imgName_4": "图片_营业执照注销",
"imgName_5": "图片_断水断电证明",
"imgName_6": "图片_执法笔录",
}
for x in pCompanys:
#文件夹保存图片
dirCompany = dirTemp + x['companyName'] + "/"
for name in dictImgs:
nameImg = dictImgs[name].replace("图片_", "")
filesImg = x[name].split(';')
targetDir = dirCompany + nameImg
# 拷贝文件到文件夹
ind = 0
for xx in filesImg:
ind += 1
if (xx == ''): continue
pathDest = myIO.copyFile(imgSrcdir + xx, targetDir,
nameImg + "_" + str(ind))
files.append(pathDest)
newfiles.append(pathDest.replace(dirTemp, ""))
files.append(dirTemp + nameFile + ".csv")
newfiles.append(nameFile + ".csv")
#压缩文件
zip_name = nameFile
zip_path = appWeb.baseDir + "static/data/Companys/"
#if(myIO.Save_Files_zip(files, newfiles, zip_path, zip_name)):
if (myIO.Save_Floders_zip(dirTemp, zip_path, zip_name)):
res['filename'] = zip_name + '.zip'
res['filefloder'] = "Companys"
res['totalCount'] = totalCount
else:
res['success'] = 0
res['msg'] = str(err)
myIO.deldir(dirTemp)
except Exception as err:
res['success'] = 0
res['msg'] = str(err)
return myData_Json.Trans_ToJson_str(res)
def queryDetail(ID):
res = {"success": 1, "data": 0, "msg": ""}
details = {'duration': "15分钟", 'power': "0.6kWh", 'cost': "1元"}
res['data'] = details
return myData_Json.Trans_ToJson_str(res)