def asset_value_history_detail():
query_params = request.json
fundname = query_params.get('params')
server_host = server_constant.get_server_model('host')
session = server_host.get_db_session('jobs')
sql = "select `unit_net`,`net_asset_value`,`product_name`,`date_str`,`sum_value`,`real_capital`,`nav_change` from \
asset_value_info where `product_name`='%s'" % fundname
date_utils = DateUtils()
data = []
for line in session.execute(sql):
tmp_data = dict(
unit_net=float(line[0]),
net_asset_value=float('%.2f' % float(line[1])),
product_name=line[2],
date=date_utils.datetime_toString(line[3]),
sum_value=float(line[4]),
real_capital=float('%.2f' % float(line[5])),
nav_change=float('%.4f' % float(line[6]))
)
data.append(tmp_data)
session.close()
data = sorted(data, key=lambda data_item: data_item['date'])
date_list = map(lambda data_item: data_item['date'], data)
asset_value_list = map(lambda data_item: data_item['net_asset_value'], data)
unit_net_list = map(lambda data_item: data_item['unit_net'], data)
sum_unit_net_list = map(lambda data_item: data_item['sum_value'], data)
real_capital_list = map(lambda data_item: data_item['real_capital'], data)
result = {'date_list': date_list, 'asset_value_list': asset_value_list, 'unit_net_list': unit_net_list,
'sum_unit_net_list': sum_unit_net_list, 'real_capital_list': real_capital_list}
return make_response(jsonify(code=200, data=result), 200)
def __query_date_info(session_portfolio, pf_account_list):
pf_account_id_list = []
for pf_account in pf_account_list:
pf_account_id_list.append(str(pf_account.id))
query_sql = "select date from portfolio.pf_position a where a.id in (%s) group by date" % ','.join(
pf_account_id_list)
date_list = []
for date_str in session_portfolio.execute(query_sql):
date_list.append(date_str[0])
date_utils = DateUtils()
return date_utils.get_trading_day_list(date_list[0], date_list[-1])
def save_msg(title, content, role_id):
date_utils = DateUtils()
create_time = str(date_utils.get_now())
host_server_model = server_constant.get_server_model('host')
session = host_server_model.get_db_session('jobs')
user_obj_list = session.query(UserList).filter(
UserList.role_id == role_id).all()
for user_obj in user_obj_list:
obj_msg = EodMessage(title=title,
content=content,
create_time=create_time)
obj_msg.user_id = user_obj.id
session.add(obj_msg)
session.commit()
session.close()
def zabbix_log_monitor(server_list):
if not DateUtils().is_trading_time():
return 0
subject = '[Zabbix_Problem] TFCalculator Error'
context = []
for server_name in server_list:
tf = TFCalculatorInit(server_name, [], [])
rst = tf.log_monitor()
if rst:
context.append('<li>%s:</li>' % server_name)
context.extend(rst)
print 1
else:
print 0
if context:
email_utils2.send_email_group_all(subject, '<br>'.join(context), 'html')
# -*- coding: utf-8 -*-
from eod_aps.model.schema_strategy import StrategyParameter, StrategyChangeHistory, StrategyOnline
from eod_aps.model.server_constans import ServerConstant
from eod_aps.tools.date_utils import DateUtils
from eod_aps.wsdl.cta_strategy_wsdl import *
from cfg import custom_log
server_constant = ServerConstant()
date_utils = DateUtils()
def __strategy_online(session, strategy_change_history):
query = session.query(StrategyOnline)
strategy_online_db = query.filter(
StrategyOnline.name == strategy_change_history.name).first()
if strategy_online_db is None:
custom_log.log_error_task('unfind strategy:%s' %
strategy_change_history.name)
return
target_server_list = strategy_online_db.target_server.split('|')
parameter_server_list = strategy_online_db.parameter_server.split('|')
for index in range(0, len(target_server_list)):
server_name = target_server_list[index]
parameter_value = parameter_server_list[index]
server_model = server_constant.get_server_model(server_name)
session_strategy = server_model.get_db_session('strategy')
strategy_parameter = StrategyParameter()
strategy_parameter.time = date_utils.get_now()
def asset_value():
# query_params = request.args
query_params = request.json
size = query_params.get('size', 10)
page = query_params.get('page', 1)
server_host = server_constant.get_server_model('host')
session = server_host.get_db_session('jobs')
fund_name = query_params.get('fund_name')
search_date_item = query_params.get('search_date')
export_flag = False
fundNames = []
for fund in session.execute('select product_name from asset_value_info group by product_name'):
tmp_fund = dict(
value=fund[0],
label=fund[0]
)
fundNames.append(tmp_fund)
data = []
ret = session.execute(
"select `unit_net`,`net_asset_value`,`product_name`,`date_str`,`sum_value`,`real_capital`,`nav_change` from \
asset_value_info").fetchall()
date_utils = DateUtils()
for line in ret:
tmp_data = dict(
unit_net='%.4f' % float(line[0]),
net_asset_value='%.2f' % float(line[1]),
product_name=line[2],
date=date_utils.datetime_toString(line[3]),
sum_value='%.4f' % float(line[4]),
real_capital='%.2f' % float(line[5]),
nav_change='%.2f%%' % (float('%.4f' % float(line[6])) * 100)
)
data.append(tmp_data)
data = sorted(data, key=lambda data_item: data_item['date'], reverse=True)
sql = "select b.`product_name` AS `fund_name`,b.date_s AS `date`,b.`sum_value` AS `max_sum_value`,b.date_str AS \
`max_date`,d.`sum_value` AS `min_sum_value`,d.date_str AS `min_date` from (select product_name,sum_value,date_str,date_format(`date_str`,'%Y') AS `date_s` from (select * from asset_value_info order by date_str desc) as a group by product_name,date_format(a.`date_str`,'%Y')) as b inner join (select product_name,sum_value,date_str,date_format(`date_str`,'%Y') AS `date_s` from (select * from asset_value_info order by date_str) as c group by product_name,date_format(c.`date_str`,'%Y')) as d on b.product_name=d.product_name and b.date_s=d.date_s"
val_ret = session.execute(sql).fetchall()
year_list = []
val_change_data = []
fund_info_dict = get_fund_info_dict()
temp_net_rate_dict = {}
for line in val_ret:
if str(line[0]) not in temp_net_rate_dict:
temp_net_rate_dict[line[0]] = [(line[1], line[4])]
# temp_net_rate_dict[line[0]] = [(line[1], line[2])]
temp_net_rate_dict[line[0]].append((line[1], line[2]))
else:
temp_net_rate_dict[line[0]].append((line[1], line[2]))
if line[1] not in year_list:
year_list.append(str(line[1]))
# if temp_data:
# if str(line[0]) in temp_data.values():
# temp_data[str(line[1])] = '%.2f%%' % ((float(line[2]) - float(line[4])) / float(line[4]) * 100)
# if val_ret.index(line) + 1 == len(val_ret):
# val_change_data.append(temp_data)
# else:
# val_change_data.append(temp_data)
# temp_data = {'fund_name': str(line[0]),
# str(line[1]): '%.2f%%' % ((float(line[2]) - float(line[4])) / float(line[4]) * 100)}
# else:
# temp_data[str(line[1])] = '%.2f%%' % ((float(line[2]) - float(line[4])) / float(line[4]) * 100)
# temp_data['fund_name'] = str(line[0])
for k, v in temp_net_rate_dict.items():
if str(k) not in fund_info_dict:
continue
temp_data = dict()
temp_data['fund_name'] = str(k)
# v = sorted(v, key=lambda data_item: data_item[0], reverse=True)
for index, item in enumerate(v):
if index != 0:
temp_data[item[0]] = '%.2f%%' % (
((float(item[1]) - float(v[index - 1][1])) / float(v[index - 1][1])) * 100)
# else:
# temp_data[item[0]] = '%.2f%%' % (((float(item[1]) - 1) / 1) * 100)
tmp_dict = filter(lambda data_item: data_item['product_name'] == str(k), data)[0]
temp_data['unit_net'] = tmp_dict['unit_net']
temp_data['sum_value'] = tmp_dict['sum_value']
temp_data['net_asset_value'] = tmp_dict['net_asset_value']
temp_data['real_capital'] = tmp_dict['real_capital']
temp_data['nav_change'] = tmp_dict['nav_change']
temp_data['date'] = tmp_dict['date']
temp_data['create_time'] = str(fund_info_dict[str(k)])
val_change_data.append(temp_data)
year_list = sorted(year_list, reverse=True)
right_sort_prop = query_params.get('right_sort_prop', '')
right_sort_order = query_params.get('right_sort_order', '')
if right_sort_prop:
if right_sort_order == 'ascending':
val_change_data = sorted(val_change_data, key=lambda data_item: data_item[right_sort_prop], reverse=True)
else:
val_change_data = sorted(val_change_data, key=lambda data_item: data_item[right_sort_prop])
session.close()
sort_prop = query_params.get('sort_prop', '')
sort_order = query_params.get('sort_order', '')
if search_date_item:
start_date, end_date = search_date_item
data = filter(lambda data_item: start_date <= data_item['date'] <= end_date, data)
export_flag = True
if fund_name:
data = filter(lambda data_item: data_item['product_name'] == fund_name, data)
export_flag = True
if sort_prop:
if sort_order == 'ascending':
data = sorted(data, key=lambda data_item: data_item[sort_prop], reverse=True)
else:
data = sorted(data, key=lambda data_item: data_item[sort_prop])
start = (int(page) - 1) * int(size)
end = int(page) * int(size)
total = len(data)
if total < end:
end = total
export_data = data
if not export_flag:
export_data = data[start:end]
data = data[start:end]
pagination = {'total': total, 'size': int(size), 'currentPage': int(page)}
result = {'data': data, 'fundNames': fundNames, 'pagination': pagination, 'year_list': year_list,
'val_change_data': val_change_data, 'export_data': export_data}
return make_response(jsonify(code=200, data=result), 200)