import tabulate


def print_audits_list(app, audits, title=None, echo=False):

    nb_total_audits = len(audits)
    nb_display_audits = nb_total_audits
    
    # Add id value for each file report line
    for id, audit in enumerate(audits):
        audits[id]['id'] = id

    # Display data table
    result = []
    result.append('')
    if title and title is not None:
        result.append(title)
    result.append('Nb. audits: {nb_display_audits}/{nb_total_audits}'.format(nb_display_audits=nb_display_audits, nb_total_audits=nb_total_audits))
    if nb_display_audits > 0:
        # Get table to display
        headers = ['ID', 'NAME', 'TYPE', 'URL']
        colalign = ('center', 'left', 'center', 'left',)
        data = [[audits[i]['id'], audits[i]['name'], audits[i]['type'].upper(), audits[i]['url']] for i in range(0, nb_total_audits)]
        table = tabulate.tabulate(data, headers, tablefmt="pretty", colalign=colalign)
        result.append(table)
    else:
        # No result to display
        result.append('Aucun fichier à afficher. Merci de vérifier les paramètres indiqués.')
    result.append('')

    if echo:
        result_text = '\n'.join(result)
        app.echo(result_text)
    
    return result
    

# def print_report_summary(app, report, data, title=None, echo=False):
#     #Get table data
#     data = [[key, value] for key, value in data.items()]
#     table = tabulate.tabulate(data, tablefmt="pretty", colalign=('left', 'right'), maxcolwidths=[30, 8])

#     # Display data table
#     result = []
#     result.append('')
#     if title and title is not None:
#         result.append(title)
#         result.append('')   
#     result.append('Report name: {report_name}'.format(report_name=report['name']))
#     result.append('Report type: {report_type}'.format(report_type=report['type']))
#     result.append('Report URL: {report_url}'.format(report_url=report['url']))
#     result.append('')
#     result.append('Summary:')
#     result.append(table)
#     result.append('')

#     if echo:
#         result_text = '\n'.join(result)
#         app.echo(result_text)
        
#     return result


# def print_errors(app, report, data, limit=None, search=None, workspace=None, name=None, id=None, echo=False):
#     # Get headers, columns and data
#     if report['type'].lower() in ['wms', 'wfs']:
#         headers = ['ID', 'WORKSPACE', 'NAME', 'STATUS', 'ERROR CODE', 'MESSAGE']
#         colalign = ('right', 'left', 'left', 'center', 'left', 'left')
#         maxcolwidths = [5, 20, 20, 8, 15, 60]
#         data_errors = [[d['id'], d['workspace'], d['name'], 'OK' if d['error'] == 0 else 'ERROR', d['error_code'], d['message']] for d in data['errors']]
#     else:
#         headers = ['ID', 'NAME', 'STATUS', 'ERROR CODE', 'MESSAGE']
#         colalign = ('right', 'left', 'center', 'left', 'left')
#         maxcolwidths = [5, 20, 8, 15, 60]
#         data_errors = [[d['id'], d['name'], 'OK' if d['error'] == 0 else 'ERROR', d['error_code'], d['message']] for d in data['errors']]
        
#     nb_total_errors = data['nb_errors']
#     nb_display_errors = len(data_errors)

#     # Display data table
#     result = []
#     result.append('')
#     result.append('Report name: {report_name}'.format(report_name=report['name']))
#     result.append('Report type: {report_type}'.format(report_type=report['type']))
#     result.append('Report URL: {report_url}'.format(report_url=report['url']))
#     result.append('')
#     result.append('Nb. errors: {nb_display_errors}/{nb_total_errors}'.format(nb_display_errors=nb_display_errors, nb_total_errors=nb_total_errors))
#     if search and search is not None:
#         result.append('Search parameter: {search}'.format(search=search))
#     if workspace and workspace is not None:
#         result.append('Workspace parameter: {workspace}'.format(workspace=workspace))
#     if name and name is not None:
#         result.append('Name parameter: {name}'.format(name=name))
#     if id and id is not None:
#         result.append('Id parameter: {id}'.format(id=id))
#     if limit and limit is not None:
#         data_errors = data_errors[0:int(limit)]
#         result.append('Limit parameter: {limit}'.format(limit=limit))
#     if nb_display_errors > 0:
#         result.append('Errors:')
#         table = tabulate.tabulate(data_errors, headers, tablefmt="grid", colalign=colalign, maxcolwidths=maxcolwidths)
#         result.append(table)
#     else:
#         result.append('')
#         result.append('No layer to display')
#     result.append('')

#     if echo:
#         result_text = '\n'.join(result)
#         app.echo(result_text)
        
#     return result


# def print_layers(app, report, data, limit=None, search=None, workspace=None, name=None, id=None, echo=False):
#     # Get headers, columns and data
#     if report['type'].lower() in ['wms', 'wfs']:
#         headers = ['ID', 'WORKSPACE', 'NAME', 'STATUS', 'NB ERRORS']
#         colalign = ('right', 'left', 'left', 'center', 'right')
#         data_layers = [[d['id'], d['workspace'], d['name'], 'OK' if d['nb_errors'] == 0 else 'ERROR', d['nb_errors']] for d in data['layers']]
#     else:
#         headers = ['ID', 'NAME', 'STATUS', 'NB ERRORS']
#         colalign = ('right', 'left', 'center', 'right')
#         data_layers = [[d['id'], d['name'], 'OK' if d['nb_errors'] == 0 else 'ERROR', d['nb_errors']] for d in data['layers']]
        
#     nb_total_layers = data['nb_layers']
#     nb_display_layers = len(data['layers'])

#     # Display data table
#     result = []
#     result.append('')
#     result.append('Report name: {report_name}'.format(report_name=report['name']))
#     result.append('Report type: {report_type}'.format(report_type=report['type']))
#     result.append('Report URL: {report_url}'.format(report_url=report['url']))
#     result.append('')
#     result.append('Nb. layers: {nb_display_layers}/{nb_total_layers}'.format(nb_display_layers=nb_display_layers, nb_total_layers=nb_total_layers))
#     if search and search is not None:
#         result.append('Search parameter: {search}'.format(search=search))
#     if workspace and workspace is not None:
#         result.append('Workspace parameter: {workspace}'.format(workspace=workspace))
#     if name and name is not None:
#         result.append('Name parameter: {name}'.format(name=name))
#     if id and id is not None:
#         result.append('Id parameter: {id}'.format(id=id))
#     if limit and limit is not None:
#         data_layers = data_layers[0:int(limit)]
#         result.append('Limit parameter: {limit}'.format(limit=limit))
#     if nb_display_layers > 0:
#         result.append('Layers:')
#         table = tabulate.tabulate(data_layers, headers, tablefmt="pretty", colalign=colalign)
#         result.append(table)
#     else:
#         result.append('')
#         result.append('No layer to display')
#     result.append('')

#     if echo:
#         result_text = '\n'.join(result)
#         app.echo(result_text)
        
#     return result


# def print_layer_errors(app, report, data, echo=False):
#     # Get headers, columns and data    
#     headers = ['ID', 'CODE', 'MESSAGE']
#     colalign = ('right', 'left', 'left')
#     maxcolwidths = [5, 20, 80]
#     data_errors = [[d['error_id'], d['error_code'], d['error_message']] for d in data]

#     # Display data table
#     result = []
#     if len(data_errors) > 0:
#         table = tabulate.tabulate(data_errors, headers, tablefmt="grid", colalign=colalign, maxcolwidths=maxcolwidths)
#         result.append('Errors:')
#         result.append(table)
#     else:
#         result.append('No error to display')
#     result.append('')
    
#     if echo:
#         result_text = '\n'.join(result)
#         app.echo(result_text)
        
#     return result


# def print_workspaces(app, report, data, limit=None, search=None, echo=False):
#     # Get headers, columns and data
#     headers = ['ID', 'WORKSPACE', 'STATUS', 'NB ERRORS', 'NB LAYERS', 'NB LAYERS OK', 'NB LAYERS ERROR']
#     colalign = ('right', 'left', 'center', 'right', 'right', 'right', 'right')
#     data_ws = [[d['id'], d['workspace'], 'OK' if d['nb_errors'] == 0 else 'ERROR', d['nb_errors'], d['nb_layers'], d['nb_layers_ok'], d['nb_layers_error'], ] for d in data['workspaces']]
        
#     nb_total_ws = data['nb_workspaces']
#     nb_display_ws = len(data_ws)
    
#     # Display data table
#     result = []
#     result.append('')
#     result.append('Report name: {report_name}'.format(report_name=report['name']))
#     result.append('Report type: {report_type}'.format(report_type=report['type']))
#     result.append('Report URL: {report_url}'.format(report_url=report['url']))
#     result.append('')
#     result.append('Nb. workspaces: {nb_display_ws}/{nb_total_ws}'.format(nb_display_ws=nb_display_ws, nb_total_ws=nb_total_ws))
#     if search and search is not None:
#         result.append('Search parameter: {search}'.format(search=search))
#     if limit and limit is not None:
#         data_ws = data_ws[0:int(limit)]
#         result.append('Limit parameter: {limit}'.format(limit=limit))
#     if nb_display_ws > 0:
#         result.append('Workspaces:')
#         table = tabulate.tabulate(data_ws, headers, tablefmt="pretty", colalign=colalign)
#         result.append(table)
#     else:
#         result.append('')
#         result.append('No workspace to display')
#     result.append('')

#     if echo:
#         result_text = '\n'.join(result)
#         app.echo(result_text)
        
#     return result