kkonganti@101: #!/usr/bin/env python
kkonganti@101: 
kkonganti@101: import sys
kkonganti@101: import yaml
kkonganti@101: from textwrap import dedent
kkonganti@101: 
kkonganti@101: def main() :
kkonganti@101:     """
kkonganti@101:     Takes a tab-delimited text file with a mandatory header
kkonganti@101:     column and generates an HTML table.
kkonganti@101:     """
kkonganti@101: 
kkonganti@101:     args = sys.argv
kkonganti@101:     if (len(args) < 2 or len(args) > 3):
kkonganti@101:         print(f"\nTwo CL arguments are required!\n")
kkonganti@101:         exit(1)
kkonganti@101: 
kkonganti@101:     table_sum_on = args[1].lower()
kkonganti@101:     workflow_name = args[2].lower()
kkonganti@101: 
kkonganti@101:     with open(f"{table_sum_on}.tblsum.txt", "r") as tbl:
kkonganti@101:         header = tbl.readline()
kkonganti@101:         header_cols = header.strip().split('\t')
kkonganti@101: 
kkonganti@101:         html = [
kkonganti@101:             dedent(
kkonganti@101:                 f"""<script type="text/javascript">
kkonganti@101:                     $(document).ready(function () {{
kkonganti@101:                         $('#cpipes-process-custom-res-{table_sum_on}').DataTable({{
kkonganti@101:                             scrollX: true,
kkonganti@101:                             fixedColumns: true, dom: 'Bfrtip',
kkonganti@101:                             buttons: [
kkonganti@101:                                 'copy',
kkonganti@101:                                 {{
kkonganti@101:                                     extend: 'print',
kkonganti@101:                                     title: 'CPIPES: MultiQC Report: {table_sum_on}'
kkonganti@101:                                 }},
kkonganti@101:                                 {{
kkonganti@101:                                     extend: 'excel',
kkonganti@101:                                     filename: '{table_sum_on}_results',
kkonganti@101:                                 }},
kkonganti@101:                                 {{
kkonganti@101:                                     extend: 'csv',
kkonganti@101:                                     filename: '{table_sum_on}_results',
kkonganti@101:                                 }}
kkonganti@101:                             ]
kkonganti@101:                         }});
kkonganti@101:                     }});
kkonganti@101:                 </script>
kkonganti@101:                 <div class="table-responsive">
kkonganti@101:                 <style>
kkonganti@101:                 #cpipes-process-custom-res tr:nth-child(even) {{
kkonganti@101:                     background-color: #f2f2f2;
kkonganti@101:                 }}
kkonganti@101:                 </style>
kkonganti@101:                 <table class="table" style="width:100%" id="cpipes-process-custom-res-{table_sum_on}">
kkonganti@101:                 <thead>
kkonganti@101:                 <tr>"""
kkonganti@101:             )
kkonganti@101:         ]
kkonganti@101: 
kkonganti@101:         for header_col in header_cols:
kkonganti@101:             html.append(
kkonganti@101:                 dedent(
kkonganti@101:                     f"""
kkonganti@101:                         <th> {header_col} </th>"""
kkonganti@101:                 )
kkonganti@101:             )
kkonganti@101:         
kkonganti@101:         html.append(
kkonganti@101:             dedent(
kkonganti@101:                 """
kkonganti@101:                 </tr>
kkonganti@101:                 </thead>
kkonganti@101:                 <tbody>"""
kkonganti@101:             )
kkonganti@101:         )
kkonganti@101: 
kkonganti@101:         for row in tbl:
kkonganti@101:             html.append("<tr>\n")
kkonganti@101:             data_cols = row.strip().split('\t')
kkonganti@101:             if ( len(header_cols) != len(data_cols) ):
kkonganti@101:                 print(f"\nWARN: Number of header columns ({len(header_cols)}) and data " +
kkonganti@101:                     f"columns ({len(data_cols)}) are not equal!\nWill append empty columns!\n")
kkonganti@101:                 if ( len(header_cols) > len(data_cols) ):
kkonganti@101:                     data_cols += (( len(header_cols) - len(data_cols) ) * ' ' )
kkonganti@101:                     print(len(data_cols))
kkonganti@101:                 else:
kkonganti@101:                     header_cols += (( len(data_cols) - len(header_cols) ) * ' ') 
kkonganti@101: 
kkonganti@101:             html.append(
kkonganti@101:                 dedent(
kkonganti@101:                     f"""
kkonganti@101:                         <td><samp>{data_cols[0]}</samp></td>
kkonganti@101:                     """
kkonganti@101:                 )
kkonganti@101:             )
kkonganti@101: 
kkonganti@101:             for data_col in data_cols[1:]:
kkonganti@101:                 html.append(
kkonganti@101:                     dedent(
kkonganti@101:                         f"""<td>{data_col}</td>
kkonganti@101:                         """
kkonganti@101:                     )
kkonganti@101:                 )
kkonganti@101:             html.append("</tr>\n")
kkonganti@101:         html.append("</tbody>\n")
kkonganti@101:         html.append("</table>\n")
kkonganti@101:         html.append("</div>\n")
kkonganti@101: 
kkonganti@101:         mqc_yaml = {
kkonganti@101:             "id": f"{table_sum_on.upper()}_collated_table",
kkonganti@101:             "section_name": f"{table_sum_on.upper()}",
kkonganti@101:             "section_href": f"https://cfsan-git.fda.gov/Kranti.Konganti/{workflow_name}",
kkonganti@101:             "plot_type": "html",
kkonganti@101:             "description": "The results table shown here is a collection from all samples.",
kkonganti@101:             "data": ('').join(html),
kkonganti@101:         }
kkonganti@101: 
kkonganti@101:         with open(f"{table_sum_on.lower()}_mqc.yml", "w") as html_mqc:
kkonganti@101:             yaml.dump(mqc_yaml, html_mqc, default_flow_style=False)
kkonganti@101: 
kkonganti@101: if __name__ == "__main__":
kkonganti@101:     main()