def get_login_trace_report_data(db, request, session_user, client_id): if request.csv: converter = ConvertJsonToCSV(db, request, session_user, "LoginTraceReport") if converter.FILE_DOWNLOAD_PATH is None: return clientreport.ExportToCSVEmpty() else: return clientreport.ExportToCSVSuccess( link=converter.FILE_DOWNLOAD_PATH) else: result, total_record = process_login_trace_report( db, request, client_id) return clientmasters.GetLoginTraceReportDataSuccess( log_trace_activities=result, total_count=total_record)
def get_status_report_consolidated(db, request, session_user, session_category): if not request.csv: country_id = request.c_id legal_entity_id = request.legal_entity_id domain_id = request.d_id unit_id = request.unit_id act = request.act compliance_task = request.compliance_task frequency_id = request.frequency_id user_type_id = request.user_type_id status_name = request.status_name usr_id = request.usr_id from_date = request.from_date to_date = request.to_date csv = request.csv f_count = request.f_count t_count = request.t_count status_report_consolidated_list = report_status_report_consolidated( db, country_id, legal_entity_id, domain_id, unit_id, act, compliance_task, frequency_id, user_type_id, status_name, usr_id, from_date, to_date, session_user, f_count, t_count ) total_count = 0 if request.count_qry: total_count = report_status_report_consolidated_total( db, country_id, legal_entity_id, domain_id, unit_id,act, compliance_task, frequency_id, user_type_id, status_name, usr_id, from_date, to_date, session_user ) logo_url = legal_entity_logo_url( db, legal_entity_id ) return clientreportnew.GetStatusReportConsolidatedSuccess( status_report_consolidated_list, total_count, logo_url ) else: converter = ConvertJsonToCSV( db, request, session_user, "StatusReportConsolidated" ) return clientreport.ExportToCSVSuccess( link=converter.FILE_DOWNLOAD_PATH )
def process_assigneewise_compliances(db, request, session_user, session_category): if request.csv: converter = ConvertJsonToCSV(db, request, session_user, "AssigneeWise", session_category) return clientreport.ExportToCSVSuccess( link=converter.FILE_DOWNLOAD_PATH) else: country_id = request.country_id business_group_id = request.business_group_id legal_entity_id = request.legal_entity_ids[0] division_id = request.division_id unit_id = request.unit_id user_id = request.user_id chart_data = get_assigneewise_compliances_list( db, country_id, business_group_id, legal_entity_id, division_id, unit_id, session_user, user_id, session_category) return dashboard.GetAssigneeWiseCompliancesChartSuccess( chart_data=chart_data)
def get_statutory_settings_unit_Wise(db, request, session_user, session_category): if not request.csv: country_id = request.c_id bg_id = request.bg_id legal_entity_id = request.legal_entity_id domain_id = request.d_id unit_id = request.unit_id div_id = request.div_id cat_id = request.cat_id act = request.act compliance_task = request.compliance_task frequency_id = request.frequency_id status_name = request.status_name csv = request.csv f_count = request.f_count t_count = request.t_count statutory_settings_unit_Wise_list = report_statutory_settings_unit_Wise( db, country_id, bg_id, legal_entity_id, domain_id, unit_id, div_id, cat_id, act, compliance_task, frequency_id, status_name, session_user, f_count, t_count ) total_count = 0 if request.count_qry: total_count = report_statutory_settings_unit_Wise_total( db, country_id, bg_id, legal_entity_id, domain_id, unit_id, div_id, cat_id, act, compliance_task, frequency_id, status_name, session_user ) logo_url = legal_entity_logo_url( db, legal_entity_id ) return clientreportnew.GetStatutorySettingsUnitWiseSuccess( statutory_settings_unit_Wise_list, total_count, logo_url ) else: converter = ConvertJsonToCSV( db, request, session_user, "StatutorySettingsUnitWise" ) return clientreport.ExportToCSVSuccess( link=converter.FILE_DOWNLOAD_PATH )