def ToList(self):
lstValue = [
self.infoID, self.usrID, self.usrOrderType, self.targetID,
self.targetName, self.targetMarket, self.targetMarketBoard,
self.targetPrice, self.targetPrice_Ex, self.targetPosition,
myData_Trans.Tran_ToStr(self.targetIndustries, symbol='、'),
myData_Trans.Tran_ToStr(self.targetConcepts, symbol='、'),
self.tradeType, self.tradeType_sub, self.tradeNum, self.tradeMoney,
self.tradePosition, self.tradeProfit, self.tradeProfit_total,
self.tradeTime.strftime("%Y-%m-%d %H:%M:%S"), self.isDel,
self.recorder,
self.recordTime.strftime('%Y-%m-%d %H:%M:%S'), self.remark
]
return lstValue
def ORC(path, templateSign, options={}, out_debug=False):
# 读取图片文件
dtStart = datetime.datetime.now()
dicResult = {'words': [], 'wordText': ""}
with open(path, 'rb') as fp:
image = fp.read()
try:
# 带参数调用通用文字识别
result = aipORC.basicGeneral(image, options)
if (out_debug):
print("==> ORC @ %s, 耗时 %s 秒" %
(os.path.basename(path),
str((datetime.datetime.now() - dtStart).seconds)))
# 转换为易识别结果
words = []
for x in result['words_result']:
words.append(x['words'])
dicResult = {
'words': words,
'wordText': myData_Trans.Tran_ToStr(words, "\n")
}
return dicResult
except KeyError:
return dicResult
def get(self, msgID):
#提取消息内容
bufMsgs = gol._Get_Setting('bufferMsgs') #消息缓存
pMsg = bufMsgs.Find(msgID)
if (pMsg == None):
return ""
return myData_Trans.Tran_ToStr(pMsg.msg['value'])
def _getDefault_Param(self): #默认配置
if (self.pSets != None):
self.paramsSet = {}
self.paramsList = []
keys = self.pSets.setList.keys()
lstParam = []
for x in keys:
pSet = self.pSets._Find(x)
if (pSet != None and pSet.IsEnable()):
lstSets = self.paramsSet.get(pSet.stockInfo.source_set,
None)
if (lstSets == None):
self.paramsSet[pSet.stockInfo.source_set] = []
lstSets = self.paramsSet.get(pSet.stockInfo.source_set,
None)
lstSets.append(pSet)
#记录设置编号
if (pSet.stockInfo.source_set == self.type):
lstParam.append(
myData.iif(pSet.stockInfo.source_code == "",
pSet.setTag,
pSet.stockInfo.source_code))
self.paramsList = lstParam
strParams = myData_Trans.Tran_ToStr(lstParam).replace(".", '')
return strParams
def upload_company(companyID=""):
form = myCompanyForm() #生成form实例，给render_template渲染使用
needRefresh = True
editSucess = False
if form.validate_on_submit(
): #调用form实例里面的validate_on_submit()功能，验证数据是否安全，如是返回True，默认返回False
if form.save.data: # 保存按钮被单击
# 组装row信息
pValues = []
if (True):
pValues.append("-1")
pValues.append(form.companyID.data)
pValues.append(form.companyName.data)
pValues.append(form.companyInStreet.data)
pValues.append(form.companyInVillage.data)
pValues.append(form.companyAdrr.data)
pValues.append(form.companyScale.data)
pValues.append(form.companyContacts.data)
pValues.append(form.companyPhone.data)
companyHasProcess = myData.iif(
form.companyHasProcess.data == "是", True, False)
pValues.append(companyHasProcess)
pValues.append(form.companyNumProcess.data)
pValues.append(form.companyRecycle.data)
pValues.append(form.companyVolumeTotal.data)
pValues.append(
myData_Trans.Tran_ToDatetime_str(
form.companyRedate.data))
pValues.append(form.companyRevolume.data)
pValues.append(form.companyTransferredvolume.data)
pValues.append(form.companyNoTransferredvolume.data)
pValues.append(form.imgName_1.data)
pValues.append(form.imgName_2.data)
pValues.append(form.imgName_3.data)
pValues.append(form.imgName_4.data)
pValues.append(form.imgName_5.data)
pValues.append(form.imgName_6.data)
# 添加并保存信息
rowInfo = myData_Trans.Tran_ToStr(pValues, ',')
dbCompany = gol._Get_Value('dbCompany')
if (dbCompany.Add_Row_BySimply(rowInfo, True, True) != ""):
editSucess = True
else:
# 保存时，验证失败，不需要刷新
if form.save.data:
needRefresh = False
return render_template('company_active carbon.html',
title='company upload',
form=form,
companyID=companyID,
needRefresh=needRefresh,
editSucess=editSucess)
def _getDefault_Param(self): #默认配置
pSets = gol._Get_Value('setsQuote')
if (pSets != None):
keys = pSets.setList.keys()
lstParam = []
for x in keys:
pSet = pSets._Find(x)
if (pSet != None and pSet.IsEnable()):
lstParam.append(pSet.setTag)
strParams = myData_Trans.Tran_ToStr(lstParam)
return strParams
def getParams(self):
setsSpider = gol._Get_Value('setsSpider') #实例 爬虫设置
lstStock = setsSpider._Find_ByTypes("quote")
lstIDs = []
for x in lstStock:
if (x.IsValid()):
lstIDs.append(x.spiderName)
if (len(lstIDs) < 1): return None
stockIds = myData_Trans.Tran_ToStr(lstIDs).replace(".", "")
parms = {"queryIDs": stockIds}
return parms
def _Init(self):
#提取字段信息
dtSetting = myIO_xlsx.DtTable()
dtSetting.dataFieldType = ["","","","","bool","",""]
dtSetting.Load_csv(self.Path_SetSpider, 1, 0, isUtf = True)
if(len(dtSetting.dataMat) < 1 or len(dtSetting.dataField) < 1): return
#转换为功能权限对象集
lstFields_ind = dtSetting.Get_Index_Fields(self.lstFields)
for dtRow in dtSetting.dataMat:
if(len(dtRow) < len(self.lstFields)): continue
strSet = myData_Trans.Tran_ToStr(dtRow, ',')
self._Init_BySet_str(strSet)
def upload_company(companyID=""):
form = myCompanyForm() #生成form实例，给render_template渲染使用
needRefresh = True
editSucess = False
if form.validate_on_submit(
): #调用form实例里面的validate_on_submit()功能，验证数据是否安全，如是返回True，默认返回False
if form.save.data: # 保存按钮被单击
# 组装row信息
pValues = []
if (True):
pValues.append("-1")
if (form.companyID.data == "000000000000000000"):
companyID = "_" + myIO.create_UUID()
pValues.append(companyID)
else:
pValues.append(form.companyID.data)
pValues.append(form.companyName.data)
pValues.append(form.companyInStreet.data)
pValues.append(form.companyInVillage.data)
pValues.append(form.companyAdrr.data)
pValues.append(form.companyScale.data)
pValues.append(form.companySpecialcase.data)
pValues.append(form.companyManangeclass.data)
pValues.append(form.companyContacts.data)
pValues.append(form.companyPhone.data)
pValues.append(form.imgName_1.data)
pValues.append(form.imgName_2.data)
pValues.append(form.imgName_3.data)
pValues.append(form.imgName_4.data)
pValues.append(form.imgName_5.data)
pValues.append(form.imgName_6.data)
# 添加并保存信息
rowInfo = myData_Trans.Tran_ToStr(pValues, ',')
dbCompany = gol._Get_Value('dbCompany')
if (dbCompany.Add_Row_BySimply(rowInfo, True, True) != ""):
editSucess = True
else:
# 保存时，验证失败，不需要刷新
if form.save.data:
needRefresh = False
return render_template('company.html',
title='company upload',
form=form,
companyID=companyID,
needRefresh=needRefresh,
editSucess=editSucess)
def _checkIot_CmdsState_doing_Meter(self, ids):
# 操作任务状态查询
if (len(ids) < 1): return True
data = {'ids': myData_Trans.Tran_ToStr(ids)}
resp = self._DoWeb_Post("抄表记录状态", "admin/meter_task/state_update",
data, {})
soup = BeautifulSoup(resp.content.decode('unicode-escape'), 'lxml')
# 提取任务状态信息内容
pJson = myData_Json.Json_Object()
pJson.Trans_FromStr(soup.string)
pDatas = pJson['data']
for x in pDatas:
#通知任务状态
taskInfo = dict(x)
taskInfo['type'] = 'meter'
self.Notify_CmdState(taskInfo)
return True
def getOptInfos(self, nameETF="50ETF", month_Delta=1, extype="sh"):
# 获得当前有哪几个月份的合约
stockId, lstMonth = self.getOptInfos_Month(nameETF)
lstMonth = {}.fromkeys(lstMonth).keys()
# 获取所有期权名称
lstOpt_names = []
for x in lstMonth:
lstOpt_names = lstOpt_names + self.getOptInfos_Code(
stockId, x, "UP")
lstOpt_names = lstOpt_names + self.getOptInfos_Code(
stockId, x, "DOWN")
# 提取期权信息
queryList = myData_Trans.Tran_ToStr(lstOpt_names, ',')
url = "http://hq.sinajs.cn/list=" + queryList
req = urllib.request.Request(url)
res_data = urllib.request.urlopen(req)
res = res_data.read().decode(encoding="gbk")
lines = res.split('\n')
infos = []
for line in lines:
if (line == ""): continue
values = line.split('=')
stkid = values[0][11:]
info = values[1][1:len(values[1]) - 4]
vargs = info.split(',')
# 组装返回信息
info = {}
info['name'] = stkid[7:] + "." + extype
info['display_name'] = vargs[37]
info['type'] = 'opt'
info['extype2'] = "XSHG"
info['source_code'] = stkid
infos.append(info)
return infos
def _Done_Text(self, Text, msgID = "", usrInfo = {}):
#提取命令内容@*
if(Text.count("@*") != 1): return ""
cmds = Text.strip()[2:].split(" ")
cmd = cmds[0].strip()
nNum = len(cmds)
myDebug.Print(Text.strip())
#命令处理
strReturn = ""
if(cmd == "帮助"):
return self._Title_Helper()
elif(cmd == "排名"):
if("墨紫" == usrInfo.get('usrNameNick', "")):
#提取排名信息
pDB = gol._Get_Setting('zxcdbStockReturns')
nTop = 10
if(len(cmds) > 1 and myData_Trans.Is_Numberic(cmds[1])):
nTop = myData_Trans.To_Int(cmds[1])
lstRanks = pDB.Get_Ranks(nTop = nTop)
strRanks = "年收益排名(" + str(datetime.datetime.now().year) + ")：" + myData_Trans.Tran_ToStr(lstRanks, "\r\n")
return strRanks
return strReturn
def _Trans_ToStr(self, rowInfos, nSpace=0, isSimple=False, bTitle=False):
return myData_Trans.Tran_ToStr(self._Trans_ToList(rowInfos), ',')
