def get_otc_market_manipulate_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_market_manipulate_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCMarketManipulateReportDTO(stat_date=data.STATDATE, inter_comp_cus_num=data.INTERCOMPCUSNUM, inter_comp_trd=data.INTERCOMPTRD, inter_comp_pos=data.INTERCOMPPOS) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_et_sub_company_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_et_sub_company_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCEtSubCompanyReportDTO(stat_date=data.STATDATE, commodity_id=data.COMMODITYID, main_body_name=data.MAINBODYNAME, otc_sub_pos_amount=data.OTCSUBPOSAMOUNT, et_sub_pos_amount=data.ETSUBPOSAMOUNT) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_et_cus_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_et_cus_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCEtCusReportDTO(stat_date=data.STATDATE, et_account_cus_num=data.ETACCOUNTCUSNUM, otc_cus_pos_amount=data.OTCCUSPOSAMOUNT, et_cus_pos_amount=data.ETCUSPOSAMOUNT, et_cus_right=data.ETCUSRIGHT) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_et_commodity_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_et_commodity_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCEtCommodityReportDTO(stat_date=data.STATDATE, commodity_id=data.COMMODITYID, otc_pos_amount=data.OTCPOSAMOUNT, otc_pos_ratio=data.OTCPOSRATIO, et_pos_amount=data.ETPOSAMOUNT, et_pos_ratio=data.ETPOSRATIO, otc_et_ratio=data.OTCETRATIO) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_cus_type_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_cus_type_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCCusTypeReportDTO(stat_date=data.STATDATE, cus_type=data.CUSTYPE, asset_type=data.ASSETTYPE, trd_trans_num=data.TRDTRANSNUM, trd_notion_amount=data.TRDNOTIONAMOUNT, pos_trans_num=data.POSTRANSNUM, pos_notion_amount=data.POSNOTIONAMOUNT, in_market_cus_num=data.INMARKETCUSNUM) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_comp_propagate_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_comp_propagate_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCCompPropagateReportDTO(stat_date=data.STATDATE, inter_comp_num=data.INTERCOMPNUM, inter_comp_trd_amount=data.INTERCOMPTRDAMOUNT, comp_trd_amount_total=data.COMPTRDAMOUNTTOTAL, trd_ratio=data.TRDRATIO, inter_comp_pos_amount=data.INTERCOMPPOSAMOUNT, comp_pos_amount_total=data.COMPPOSAMOUNTTOTAL, pos_ratio=data.POSRATIO) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_market_dist_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_market_dist_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCMarketDistReportDTO(stat_date=data.STATDATE, total_pos=data.TOTALPOS, top3_pos=data.TOP3POS, top3_pos_dist=data.TOP3POSDIST, top5_pos=data.TOP5POS, top5_pos_dist=data.TOP5POSDIST, top10_pos=data.TOP10POS, top10_pos_dist=data.TOP10POSDIST, dist_type=data.DISTTYPE) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_summary_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_summary_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCSummaryReportDTO(stat_date=data.STATDATE, trd_notion_amount=data.TRDNOTIONAMOUNT, trd_trans_num=data.TRDTRANSNUM, opt_fee_amount=data.OPTFEEAMOUNT, trd_cus_num=data.TRDCUSNUM, pos_notion_amount=data.POSNOTIONAMOUNT, pos_trans_num=data.POSTRANSNUM, pos_cus_num=data.POSCUSNUM, in_market_cus_num=data.INMARKETCUSNUM, full_market_cus_num=data.FULLMARKETCUSNUM, pos_value=data.POSVALUE) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_cus_pos_percentage_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_cus_pos_percentage_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCCusPosPercentageReport(stat_date=data.STATDATE, analogue_name=data.ANALOGUENAME, under_ass_varit=data.UNDERASSVARIT, cus_positive_delta=data.CUSPOSITIVEDELTA, cus_short_position=data.CUSSHORTPOSITION, cus_negative_delta=data.CUSNEGATIVEDELTA, cus_long_position=data.CUSLONGPOSITION, exchange_max_pos=data.EXCHANGEMAXPOS, exchange_pos=data.EXCHANGEPOS, cus_exg_otc_ratio=data.CUSEXGOTCRATIO, ) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_trade_summary_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_trade_summary_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCTradeSummaryReportDTO(stat_date=data.STATDATE, open_trd_notion_amount=data.OPENTRDNOTIONAMOUNT, close_trd_notion_amount=data.CLOSETRDNOTIONAMOUNT, end_trd_notion_amount=data.ENDTRDNOTIONAMOUNT, trd_notion_amount=data.TRDNOTIONAMOUNT, trd_open_premium=data.TRDOPENPREMIUM, trd_close_premium=data.TRDCLOSEPREMIUM, trd_end_premium=data.TRDENDPREMIUM, premium_amount=data.PREMIUMAMOUNT, trd_open_cus_num=data.TRDOPENCUSNUM, trd_close_cus_num=data.TRDCLOSECUSNUM, trd_end_cus_num=data.TRDENDCUSNUM, trd_cus_num=data.TRDCUSNUM) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)
def get_otc_position_summary_report(db_session, start_date, end_date, page, page_size): total_count, report_list = OTCReportRepo.get_otc_position_summary_list(db_session, start_date, end_date, page, page_size) report_dto_list = [] total_count = total_count if total_count is not None else 0 if report_list is not None and len(report_list) > 0: for data in report_list: dto = OTCPositionSummaryReportDTO(stat_date=data.STATDATE, pos_call_buy_amount=data.POSCALLBUYAMOUNT, pos_put_buy_amount=data.POSPUTBUYAMOUNT, pos_other_buy_amount=data.POSOTHERBUYAMOUNT, pos_buy_amount_total=data.POSBUYAMOUNTTOTAL, pos_call_sell_amount=data.POSCALLSELLAMOUNT, pos_put_sell_amount=data.POSPUTSELLAMOUNT, pos_sell_amount_total=data.POSSELLAMOUNTTOTAL, pos_call_buy_c_value=data.POSCALLBUYCVALUE, pos_put_buy_c_value=data.POSPUTBUYCVALUE, pos_other_buy_c_value=data.POSOTHERBUYCVALUE, pos_buy_value_total=data.POSBUYVALUETOTAL, pos_call_sell_c_value=data.POSCALLSELLCVALUE, pos_put_sell_c_value=data.POSPUTSELLCVALUE, pos_sell_value_total=data.POSSELLVALUETOTAL) report_dto_list.append(dto) return PageDTO(total_count, report_dto_list)