def api_invest_portfolio(): stocks = yield from Stock.findInvestment(tableName='stock') sum_amount = 0 if len(stocks) > 0: for s in stocks: sum_amount += s['current_amount'] s['current_amount'] = "%.2f" % (s['current_amount'] * -1.0) s['current_num'] = "%.0f" % s['current_num'] sum_stock = dict() sum_stock['stock_code'] = 'Total' sum_stock['current_num'] = '----' sum_stock['current_price'] = '----' sum_stock['current_amount'] = "%.2f" % (sum_amount * -1) stocks.append(sum_stock) return dict(stocks=stocks)
def api_invest_portfolio_all(): all_stocks = [] '申万组合' stocks = yield from Stock.findInvestment(tableName='stock') sum_amount = 0 if len(stocks) > 0: for s in stocks: sum_amount += s['current_amount'] s['current_amount'] = "%.2f" % (s['current_amount'] * -1.0) s['current_num'] = "%.0f" % s['current_num'] sum_stock = dict() sum_stock['stock_code'] = '申万总计' sum_stock['current_num'] = '--¥--' temp_sum_stock = sum_amount * -1 sum_stock['current_amount'] = "%.2f" % temp_sum_stock stocks.append(sum_stock) split_stock = dict() split_stock['stock_code'] = '' split_stock['current_num'] = '' split_stock['current_amount'] = '' stocks.append(split_stock) all_stocks.append(sum_stock) '中信组合' citic_stocks = yield from Stock_citic.findInvestment(tableName='stock_citic') sum_amount = 0 if len(citic_stocks) > 0: for s in citic_stocks: sum_amount += s['current_amount'] s['current_amount'] = "%.2f" % (s['current_amount'] * -1.0) s['current_num'] = "%.0f" % s['current_num'] citic_sum_stock = dict() citic_sum_stock['stock_code'] = '中信总计' citic_sum_stock['current_num'] = '--¥--' citic_temp_sum_stock = sum_amount * -1 citic_sum_stock['current_amount'] = "%.2f" % citic_temp_sum_stock citic_stocks.append(citic_sum_stock) for s in citic_stocks: stocks.append(s) stocks.append(split_stock) all_stocks.append(citic_sum_stock) all_sum_stock = dict() all_sum_stock['stock_code'] = 'A股总计' all_sum_stock['current_num'] = '--¥--' all_sum_stock['current_amount'] = "%.2f" % (temp_sum_stock + citic_temp_sum_stock) stocks.append(all_sum_stock) stocks.append(split_stock) all_stocks.append(all_sum_stock) '老虎组合' tiger_stocks = yield from Stock_tiger.findInvestment(tableName='stock_tiger') sum_amount = 0 if len(tiger_stocks) > 0: for s in tiger_stocks: sum_amount += s['current_amount'] s['current_amount'] = "%.2f" % (s['current_amount'] * Decimal(-1.0)) s['current_num'] = "%.0f" % s['current_num'] tiger_sum_stock = dict() tiger_sum_stock['stock_code'] = '老虎总计' tiger_sum_stock['current_num'] = '---$---' tiger_sum_stock['current_amount'] = str(sum_amount * -1) tiger_stocks.append(tiger_sum_stock) for s in tiger_stocks: stocks.append(s) all_stocks.append(tiger_sum_stock) '查询总计stock=all_stocks,查询明细stocks=stocks' return dict(stocks=all_stocks)