def setNewBassByCustomerName(self,customerName):
headers = {
'Accept': "application/json",
'Content-Type': "application/json;charset=UTF-8"
}
# 字典转化为json
try:
baseDao = BaseDao.BaseDao()
config = Config.Config()
config.customerName = customerName
configDao = ConfigDao()
config = configDao.get(config)
config = config.__dict__
configJson = json.dumps(config)
# 打印字典
print(config)
url = host + 'configProperties/add'
data = configJson
headers = headers
result = baseDao.safeRequests(url, data, headers, "")
if result.status_code == 200:
jsonResult = result.json()
if (jsonResult['retcode'] != 0):
raise Exception("请求错误，请查看信息:", jsonResult)
if jsonResult['data'] != '':
return jsonResult['data']
else:
print(Exception("错误信息", result.json()))
except Exception as e:
print(e)
def connect_test(o_num, status):
print(o_num, status)
success = BaseDao().update('o_detail', 'o_status', status, 'o_num', o_num)
if success:
return redirect('http://10.35.161.62:8888/admin/orders/orderdetail/')
else:
return ('操作数据库失败！')
def getUserAccountCheckFromSql(self, userInfo):
sql = """
SELECT
userAddress,
sum(money),
GROUP_CONCAT(
if ( status=0 and assetAddress!="",assetAddress,null)
)
FROM
user_asset
LEFT JOIN user_info ON user_asset.userAddress = user_info.address
WHERE
userAddress=%s
AND createTime > '2019-01-04 00:00:00'
GROUP BY userAddress
ORDER BY
createTime DESC
"""
array = []
param = []
param.append(userInfo.address)
print(sql)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.execteGetOneSql(sql, param)
userAccountCheck = UserAccountCheck.UserAccountCheck()
userAccountCheck.address = result[0]
userAccountCheck.money = result[1]
userAccountCheck.assetAddress = result[2]
return userAccountCheck
except Exception as e:
print(e)
pass
def updateAsset(self, usertAssetObject):
sql = """
UPDATE `old_blockchain`.`user_asset`
SET
`status` = %s
WHERE
userAddress=%s and
`assetAddress` = %s
LIMIT 1;
"""
array = []
array.append(usertAssetObject.status)
array.append(usertAssetObject.userAddress)
array.append(usertAssetObject.assetAddress)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.executeGetAllSql(sql, array)
print(result)
return result
except Exception as e:
print(e)
return
def collects():
# 收藏商品或店铺
req_data = request.get_json()
token = req_data.get('token')
if check_token(token):
user_id = get_token_user_id(token)
clt_id = req_data.get('clt_id')
type_id = req_data.get('type_id')
if (clt_id and type_id) is not None:
dao = BaseDao()
save_data = {
'user_id': user_id,
'clt_id': clt_id,
'type_id': type_id
}
result = dao.save('u_clt', **save_data)
if result:
return jsonify({'code': 200, 'msg': '收藏成功！'})
else:
return jsonify({'code': 400, 'msg': '查询数据库失败！'})
elif clt_id is not None and type_id is None: # 取消收藏
if clt_id:
dao = GoodsDao()
delet = dao.del_collect(clt_id)
if delet:
return jsonify({'code': 200, 'msg': '该收藏信息已删除！'})
else:
return jsonify({'code': 400, 'msg': '删除失败！'})
else:
return jsonify({'code': 400, 'msg': '未接收到需要删除的ID！'})
else:
return jsonify({'code': 400, 'msg': '请上传商铺或商品ID和type类型！'})
else:
return jsonify({'code': 400, 'msg': 'token验证失败！'})
def update(self, userInfo):
sql = """
UPDATE `old_blockchain`.`user_info`
SET `publicKey` = %s,
`privateKey` = %s,
`address` = %s
WHERE
(ISNULL(`publicKey`))
AND (ISNULL(`privateKey`))
AND (ISNULL(`address`))
AND (`userId` = %s)
AND (
`customerName` = %s
)
LIMIT 1;
"""
array = []
array.append(userInfo.publicKey)
array.append(userInfo.privateKey)
array.append(userInfo.address)
array.append(userInfo.userId)
array.append(userInfo.customerName)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.executeGetAllSql(sql, array)
print(result)
return result
except Exception as e:
print(e)
def baselist(cls, sql):
dao = BaseDao()
with dao.db as c:
c.execute(sql)
items = c.fetchall()
api_logger.info('select %s ok!' % sql)
return items
def delete_order(self, p_num):
dao = BaseDao()
sql1 = "select id from tn_user where p_num=%s" % p_num
with dao.db as c:
c.execute(sql1)
user_id = c.fetchone()[0]["id"]
sql2 = "delete tn_order from tn_order,tn_user where tn_order.user_id=%s" % user_id
with dao.db as c:
c.execute(sql2)
def c_presentation(self,course): # 介绍页
clist = ['id', 'name', 'img_url','description','degree', 'course_time',
'study_num', 'course_score','youneed_know', 'teacher_tell',
'teacher_id']
# 将字符串类型的列表数据转换为列表类型
course['youneed_know'],course['teacher_tell'] = eval(course['youneed_know']),eval(course['teacher_tell'])
precourse = {k:course[k] for k in clist} # 对返回数据按前端需求筛选
t_info = BaseDao().list('teachers',('t_name','t_job','t_pic'),
where='id',args=precourse['teacher_id'])[0]
return {'precourse':precourse,'t_info':t_info}
def elegant_city(self):
dao = BaseDao()
city_list = ["当季精选", "海岛精选", "热门目的地"]
city_dict = {}
for i in range(len(city_list)):
sql = "select name,img from cities where is_popular='%s'" % (
str(i + 2), )
with dao.db as c:
c.execute(sql)
items = c.fetchall()
city_dict[city_list[i]] = items
return city_dict
def upload_avator():
# 上传的头像字段为 img
# 表单参数： token
try:
file: FileStorage = request.files.get('img', None)
token = request.args.get('token', None)
if all((bool(file), bool(token))):
# 验证文件的类型, png/jpeg/jpg, 单张不能超过2M
# content-type: image/png, image/jpeg
if file.content_type in ('image/png',
'image/jpeg'):
filename = uuid.uuid4().hex \
+ os.path.splitext(file.filename)[-1]
file.save(filename)
# 上传到oss云服务器上
key = oss.upload_file(filename)
os.remove(filename) # 删除临时文件
# token = request.args.get('token')
# 将key写入到DB中
id = get_token_user_id(token)
sql = "update yl_user set photo=(%s) where id=%s"
db = BaseDao()
db.query(sql, key, id)
return jsonify({
'code': 200,
'msg': '上传文件成功',
'file_key': key
})
else:
return jsonify({
'code': 201,
'msg': '图片格式只支持png或jpeg'
})
return jsonify({
'code': 100,
'msg': 'POST请求参数必须有img和token'
})
except:
return jsonify({
"code":400,
"msg":"更换头像失败"
})
def get_img_url():
try:
token = request.args.get('token')
id = get_token_user_id(token)
sql = "select photo from yl_user where id=%s"
db = BaseDao()
key = db.query(sql, id)[0]['photo']
img_url = oss.get_small_url(key)
return jsonify({
"code": 400,
'url': img_url
})
except:
return jsonify({
"code":400,
"msg":"获取失败"
})
def get(self, config):
if config.customerName=="":
raise RuntimeError('出错了')
sql = """
select privateKey,publicKey,mchId,chainId,ledgerId,nodeId from config where customerName=%s
"""
param = []
param.append(config.customerName)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.executeGetAllSql(sql, param)
result = result[0]
config = Config.Config()
config.createUserPrivateKey,config.createUserPublicKey,config.mchId,config.chainId,config.ledgerId,config.nodeId=result
return config
except Exception as e:
print(e)
def findUserInfoByAddress(self, address):
sql = """
select id,name,address,publicKey,privateKey from user a left join user_info b on a.id = b.userId where address = %s
"""
array = []
param = []
param.append(address)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.execteGetOneSql(sql, param)
user = UserInfo.UserInfo()
user.id = result[0]
user.name = result[1]
user.address = result[2]
user.privateKey = result[4]
user.publicKey = result[3]
return user
except Exception as e:
print(e)
def get(self, newConfig):
if newConfig.customerName == "":
raise RuntimeError('出错了')
sql = """
select createUserPrivateKey,createUserPublicKey,mchId,chainId,nodeId,host from new_config where customerName=%s and isTest=%s
"""
param = []
param.append(newConfig.customerName)
param.append(newConfig.isTest)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.executeGetAllSql(sql, param)
result = result[0]
newConfig = NewConfig.NewConfig()
newConfig.createUserPrivateKey, newConfig.createUserPublicKey, newConfig.mchId, newConfig.chainId, newConfig.nodeId, newConfig.host = result
return newConfig
except Exception as e:
print(e)
def getBossAccount(self, customerName):
sql = """
select id,name,address,publicKey,privateKey from user a left join user_info b on a.id = b.userId where customerName = %s
and b.isBoss=0
"""
array = []
param = []
param.append(customerName)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.execteGetOneSql(sql, param)
user = UserInfo.UserInfo()
user.id = result[0]
user.name = result[1]
user.address = result[2]
user.privateKey = result[4]
user.publicKey = result[3]
return user
except Exception as e:
print(e)
def findAssetId(self, userAsset):
sql = """
select userAddress,assetAddress,money from user_asset where status=0 and userAddress =%s limit 0,5
"""
array = []
param = []
param.append(userAsset.userAddress)
try:
baseDao = BaseDao.BaseDao()
result = baseDao.executeGetAllSql(sql, param)
for row in result:
newUserAsset = UserAsset.UserAsset()
newUserAsset.userAddress = row[0]
newUserAsset.assetAddress = row[1]
newUserAsset.money = row[2]
array.append(newUserAsset)
return array
except Exception as e:
print(e)
return
def patient_message():
try:
req_data = {}
token = request.args.get('token') # 获取form中的token
req_data['p_user_id'] = get_token_user_id(token) # 通过token获取id
req_data['p_name'] = request.form.get('p_name') # 患者姓名
req_data['p_ID_number'] = request.form.get('p_ID_number') # 身份证号
req_data['p_sex'] = request.form.get('p_sex') # 性别
req_data['date_birth'] = request.form.get('date_birth') # 出生日期
req_data['p_weight'] = request.form.get('p_weight') # 体重
req_data['is_allergy'] = request.form.get('is_allergy') # 过敏史
req_data['medical_history'] = request.form.get(
'medical_history') # 过往病史
req_data['is_normal_liver'] = request.form.get('is_normal_liver') # 肝功
req_data['is_normal_kidney'] = request.form.get(
'is_normal_kidney') # 肾功
req_data['is_pregnancy_preparation'] = request.form.get(
'is_pregnancy_preparation') # 是否备孕
patient_dao = BaseDao()
patient_dao.save('patient', **req_data)
return jsonify({'code': 200, 'msg': '添加患者信息成功'})
except:
return jsonify({'code': 400, 'msg': '暂无数据'})
def update_address():
# 修改地址
req_data = request.get_json()
token = req_data.get('token')
add_id = req_data.get('address', None)
re_str = req_data.get('strs', None)
print(re_str, add_id)
if check_token(token):
user_id = get_token_user_id(token)
if add_id is not None and re_str is None: # 删除
dao = BaseDao()
dao.delete('u_address', 'user_address', add_id)
return jsonify({'code': 200, 'msg': '该地址已删除！'})
elif (add_id and re_str) is not None: # 修改
dao = AddDao()
dao.update('u_address', 'user_address', re_str, 'user_address',
add_id)
check_data = dao.check_address(user_id)
user_data = UserDao().get_profile(user_id)
if all((check_data, user_data)):
data = {
'addressList': [{
"receivePersonName":
user_data[0]['user_name'],
"receiveAddress":
check_data[0]['user_address'],
"receiveTEL":
user_data[0]['tel']
}]
}
return jsonify({'code': 200, 'msg': '地址修改成功！', 'data': data})
else:
return jsonify({'code': 400, 'msg': '数据库查询失败！'})
elif re_str is not None and add_id is None: # 添加
print(re_str)
dao = AddDao()
save_add = dao.save(
'u_address', **{
"user_id": user_id,
"user_address": re_str,
"is_default": 0
})
if save_add:
check_data = dao.check_address(user_id)
user_data = UserDao().get_profile(user_id)
if all((check_data, user_data)):
data = {
'addressList': [{
"receivePersonName":
user_data[0]['user_name'],
"receiveAddress":
check_data[0]['user_address'],
"receiveTEL":
user_data[0]['tel']
}]
}
return jsonify({
'code': 200,
'msg': '地址添加成功！',
'data': data
})
else:
return jsonify({'code': 400, 'msg': '数据库查询失败！'})
else:
return jsonify({'code': 400, 'msg': '地址添加失败！'})
else:
return jsonify({'code': 400, 'msg': '数据上传有误！'})
else:
return jsonify({'code': 400, 'msg': 'token验证失败！'})
from dao import BaseDao
from model import UserInfo
from model import UserAccountQueryDto
import time
from model import UserAccountCheck
from model import UserAsset
from model import GLOBAL_CONFIG
import requests
import json
headers = {
'Accept': "application/json",
'Content-Type': "application/json;charset=UTF-8"
}
globalConfig = GLOBAL_CONFIG.GLOBAL_CONFIG()
host = globalConfig.host
baseDao = BaseDao.BaseDao()
class NewUserDao(BaseDao.BaseDao):
def findUserInfo(self, customerName):
sql = """
select id,name,address,publicKey,privateKey from user a left join user_info b on a.id = b.userId where customerName = %s
and b.isBoss=1
"""
array = []
param = []
param.append(customerName)
try:
result = baseDao.executeGetAllSql(sql, param)
