def export_allocate_server_report_data(db, request, session_user):
print request.csv
if request.csv:
converter = ConvertJsonToCSV(db, request, session_user,
"AllocateServerReport")
return consoleadmin.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH)
def process_export_audit_trails(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(db, request, session_user,
"AuditTraiReport")
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return generalprotocol.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH)
def process_export_client_login_trace(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(db, request, session_user,
"ClientLoginTraceReport")
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return generalprotocol.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH)
def process_ip_setting_report(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(db, request, session_user,
"IPSettingReport")
return consoleadmin.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH)
else:
(total_records,
group_ips_list) = ip_setting_report_data(db, request, session_user)
return consoleadmin.GetIPSettingsReportSuccess(
total_records=total_records, group_ips_list=group_ips_list)
def process_export_GroupAdminReportData(db, request, user_id):
if request.csv:
converter = ConvertJsonToCSV(
db, request, user_id, "GroupAdminRegistrationEMail"
)
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return technoreports.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
def process_export_ReassignUserReportData(db, request, user_id):
if request.csv:
converter = ConvertJsonToCSV(
db, request, user_id, "ReassignUserReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return technoreports.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
def process_export_user_mapping_details_reports_data(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "UserMappingReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return technoreports.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
def get_statutory_notification_list_report(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "StatutoryNotificationListReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return clientreport.ExportToCSVEmpty()
else:
return clientreport.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
result, total_record = process_statutory_notification_list_report(db, request)
return clientreport.GetStatutoryNotificationReportDataSuccess(stat_notf_list_report=result, total_count=total_record)
def get_audit_trail_report_data(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "AuditTrailReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return clientreport.ExportToCSVEmpty()
else:
return clientreport.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
result, total_record = process_audit_trail_report(db, request)
return clientreport.GetAuditTrailReportDataSuccess(audit_activities=result, total_count=total_record)
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_risk_report_data(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "RiskReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return clientreport.ExportToCSVEmpty()
else:
return clientreport.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
result, total_record = process_risk_report(db, request)
return clientreport.GetRiskReportSuccess(risk_report=result, total_count=total_record)
def get_user_wise_report(db, request, session_user, session_category):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "UserWiseReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return clientreport.ExportToCSVEmpty()
else:
return clientreport.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
result, total_record = process_user_wise_report(db, request)
return clientreport.GetUserWiseReportSuccess(user_compliances=result, total_count=total_record)
def process_get_assigned_statutory_report_data(db, request_frame, user_id):
if request_frame.csv:
converter = ConvertJsonToCSV(
db, request_frame, user_id, "StatutorySettingsReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return technoreports.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
result = get_assigned_statutories_report_data(db, request_frame, user_id)
unit_groups = result[0]
act_groups = result[1]
compliance_statutories_list = result[2]
return technoreports.GetAssignedStatutoryReportSuccess(unit_groups, act_groups, compliance_statutories_list, total_count=result[3])
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 get_work_flow_score_card(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
work_flow_score_card_list = report_work_flow_score_card(
db, country_id, legal_entity_id, domain_id, session_user, session_category
)
logo_url = legal_entity_logo_url(
db, legal_entity_id
)
return clientreportnew.GetWorkFlowScoreCardSuccess(work_flow_score_card_list, logo_url)
else:
converter = ConvertJsonToCSV(
db, request, session_user, "Reassign"
)
return clientreportnew.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
)
def process_get_domainwise_agreement_report_data(db, request, session_user):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "DomainwiseAgreementReport"
)
return technoreports.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
client_agreement_list = get_domainwise_agreement_report(
db, request.country_id, request.client_id, request.business_group_id, request.legal_entity_id,
request.domain_id, request.contract_from, request.contract_to,
request.from_count, request.page_count, session_user
)
total_count = get_domainwise_agreement_report_count(
db, request.country_id, request.client_id, request.business_group_id, request.legal_entity_id,
request.domain_id, request.contract_from, request.contract_to, session_user
)
return technoreports.GetDomainwiseAgreementReportDataSuccess(
domainwise_agreement_list=client_agreement_list, total_count=total_count
)
def get_client_details_report_data(db, request, session_user, session_category):
if request.csv:
converter = ConvertJsonToCSV(
db, request, session_user, "ClientDetails"
)
return clientreport.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
units = get_client_details_report(
db, request.country_id, request.business_group_id,
request.legal_entity_id, request.division_id, request.unit_id,
request.domain_ids, session_user, request.from_count, request.page_count
)
total_count = get_client_details_count(
db, request.country_id, request.business_group_id,
request.legal_entity_id, request.division_id, request.unit_id,
request.domain_ids, session_user
)
return clientreport.GetClientDetailsReportDataSuccess(
units=units, total_count=total_count
)
def get_reassignedhistory_report(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
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
reassigned_history_list = report_reassigned_history(
db, country_id, legal_entity_id, domain_id, unit_id,
act, compliance_task, usr_id, from_date, to_date, session_user, f_count, t_count
)
total_count = 0
if request.count_qry:
total_count = report_reassigned_history_total(
db, country_id, legal_entity_id, domain_id, unit_id,
act, compliance_task, usr_id, from_date, to_date, session_user
)
logo_url = legal_entity_logo_url(
db, legal_entity_id
)
return clientreportnew.GetReassignedHistoryReportSuccess(
reassigned_history_list, total_count, logo_url
)
else:
converter = ConvertJsonToCSV(
db, request, session_user, "Reassign"
)
return clientreportnew.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
def process_get_user_mapping_details_reports_data(db, request_frame, session_user):
if request_frame.csv:
converter = ConvertJsonToCSV(
db, request_frame, session_user, "UserMappingReport"
)
if converter.FILE_DOWNLOAD_PATH is None:
return technoreports.ExportToCSVEmpty()
else:
return technoreports.ExportToCSVSuccess(
link=converter.FILE_DOWNLOAD_PATH
)
else:
country_id = request_frame.country_id
client_id = request_frame.client_id
legal_entity_id = request_frame.legal_entity_id
user_mapping_none_values = request_frame.u_m_none
from_count = request_frame.from_count
page_count = request_frame.page_count
bgrp_id = division_id = catagory_id = unit_id = 0
if user_mapping_none_values.find(",") > 0:
bgrp_id = user_mapping_none_values.split(",")[0]
division_id = user_mapping_none_values.split(",")[1]
catagory_id = user_mapping_none_values.split(",")[2]
unit_id = user_mapping_none_values.split(",")[3]
usermapping_report_dataset = []
usermapping_report_dataset = get_usermapping_report_dataset(
db, int(session_user), client_id, legal_entity_id,
country_id, int(bgrp_id), int(division_id), int(catagory_id),
int(unit_id), from_count, page_count
)
techno_details = []
unit_domains = []
domains = []
print usermapping_report_dataset
if(len(usermapping_report_dataset) > 0):
for techno in usermapping_report_dataset[0]:
techno_details.append(core.UserMappingReportTechno(
techno["unit_id"], techno["techno_manager"], techno["techno_user"],
unit_code_with_name=techno["unit_name"]
))
for assign_domain in usermapping_report_dataset[1]:
unit_domains.append(core.UserMappingReportDomain(
assign_domain["unit_id"], assign_domain["employee_name"], assign_domain["user_category_name"], assign_domain["domain_id"]
))
for domain in usermapping_report_dataset[2]:
domains.append(technoreports.UserMappingDomain(
domain["domain_id"], domain["domain_name"], bool(domain["is_active"])
))
'''if(len(usermapping_report_dataset[0]) > 0):
techno_details = usermapping_report_dataset[0]
else:
techno_details = None,
if(len(usermapping_report_dataset[1]) > 0):
unit_domains = usermapping_report_dataset[1]
else:
unit_domains = None,
if(len(usermapping_report_dataset[2]) > 0):
domains = usermapping_report_dataset[2]
else:
domains = None'''
return technoreports.GetUserMappingReportDataSuccess(
techno_details=techno_details,
unit_domains=unit_domains,
usermapping_domain=domains,
total_count=usermapping_report_dataset[3]
)
def export_to_csv(db, request, session_user, session_category):
converter = ConvertJsonToCSV(db, request, session_user)
return clientreport.ExportToCSVSuccess(link=converter.FILE_DOWNLOAD_PATH)
