<!DOCTYPE html>
<html>
  <head>
<script src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.13.2/jquery-ui.min.js"></script>
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
      <table id="main-table" class="display nowrap" width="100%">
        <thead>
          <tr>
                                    <th>
                                        Business Unit
                                    </th>
                                    <th>
                                        Project Name
                                    </th>
                                    <th>
                                        Status
                                    </th>
                                    <th>
                                        Phase
                                    </th>
                                    <th>
                                        Completion Date
                                    </th>
                                    <th>
                                        IT Capabilities
                                    </th>
                                    <th>
                                        Business Sponsor
                                    </th>
                                    <th>
                                        # of Risks
                                    </th>
                                    <th>
                                        Capex
                                    </th>
                                    <th>
                                        Proj Lead
                                    </th>
                                    <th>
                                        Last Update
                                    </th>
                                </tr>
        </thead>
       
        <tbody>
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                            <tr class="group"><td colspan="11" style="font-weight: bold;">Corp Project</td></tr><tr class="odd">
                                            
                                            <td style="width: 15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EfuLKx3TJoZGkVngcYtUqK0BAKhsxaYyzmJHczEjiZLkAw?e=W4MHf8" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(3, 'Mativ Domain Migration 2023')">Mativ Domain Migration 2023</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Cancelled
                                            </td>
                                            <td style="">
                                                10/20/2023
                                            </td>
                                            <td style="">
                                                Deliver Data &amp; Analytics , Standardize Infrastructure
                                            </td>
                                            <td style="">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                0
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Raj Gangaram
                                            </td>
                                            <td style="display: none;">
                                                12/13/2023
                                            </td>
                                        </tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EfZvsDzv8tNNoDmwhX0m_FgBV3ulB0s3FY1IrVxflcWrHw?e=OpnzOb" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(4, 'Support Improvement Plan 2023')">Support Improvement Plan 2023</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                10/16/2023
                                            </td>
                                            <td style="">
                                                Improve Site Support
                                            </td>
                                            <td style="">
                                                
                                            </td>
                                            <td style="display: none;">
                                                0
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Creighton Kelly
                                            </td>
                                            <td style="display: none;">
                                                09/08/2023
                                            </td>
                                        </tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EcBbn2zWtGpGrjWduwN7avEBQMJhzVxkQn-iqW06zy7Ylw?e=IVg25B" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(5, 'Network and Infrastructure Hardware Refresh 2023')">Network and Infrastructure Hardware Refresh 2023</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                12/07/2023
                                            </td>
                                            <td style="">
                                                Standardize Infrastructure
                                            </td>
                                            <td style="">
                                                
                                            </td>
                                            <td style="display: none;">
                                                1
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Michael McKay
                                            </td>
                                            <td style="display: none;">
                                                09/06/2023
                                            </td>
                                        </tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EW4Q8ODDrtRFhDJywn0Uvd4BQMbACR1wGqa4nHHJ88S2iQ?e=n8CCaA" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(7, 'Digital IT PMO Phase 3')">Digital IT PMO Phase 3</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                10/10/2023
                                            </td>
                                            <td style="">
                                                Build Partnerships, Project Governance
                                            </td>
                                            <td style="">
                                                Rajeev Kapur
                                            </td>
                                            <td style="display: none;">
                                                3
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                09/15/2023
                                            </td>
                                        </tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/Eel2fQXt_41BvEUemC2K024BW6QInkcFHCJooEMV4AMufg?e=tI1OeV" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(11, 'Supply Chain BI 2023')">Supply Chain BI 2023</a>
                                                    <span class="text-primary" data-popup="popover" title="" data-content="test project summary" data-original-title="Project Summary" aria-describedby="popover462764">
                                                        <i class="icon-help mr-2"></i>
                                                    </span>
                                            </td>
                                            <td>
                                                <span class="badge badge-warning">At Risk </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Deliver Data &amp; Analytics , Modernize Cloud Apps, Standardize Infrastructure
                                            </td>
                                            <td style="">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                1
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Keith Hopkins
                                            </td>
                                            <td style="display: none;">
                                                12/15/2023
                                            </td>
                                        </tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EaJHjvY6GwhEmwARCEF_k9sBoaa_zUeHQ9M-gzmtmJnvGg?e=0c2nrU" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(16, 'Cybersecurity')">Cybersecurity</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Closeout/Complete
                                            </td>
                                            <td style="">
                                                04/28/2023
                                            </td>
                                            <td style="">
                                                Evolve Cybersecurity
                                            </td>
                                            <td style="">
                                                
                                            </td>
                                            <td style="display: none;">
                                                5
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Robert Andriulli
                                            </td>
                                            <td style="display: none;">
                                                10/01/2023
                                            </td>
                                        </tr><tr class="group"><td colspan="11" style="font-weight: bold;">Healthcare &amp; Wellness</td></tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EcYJpKQLWedMgBKLcx_wDfcB2WlvXhWWdRL4kVCp5UgH7w?e=vqywEm" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(13, 'Complaint System - External Supplier Site Upgrade')">Complaint System - External Supplier Site Upgrade</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Simplify Business Apps
                                            </td>
                                            <td style="">
                                                Isam Brahim
                                            </td>
                                            <td style="display: none;">
                                                2
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                12/13/2023
                                            </td>
                                        </tr><tr class="group"><td colspan="11" style="font-weight: bold;">Industrials</td></tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EW4Q8ODDrtRFhDJywn0Uvd4BQMbACR1wGqa4nHHJ88S2iQ?e=n8CCaA" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(7, 'Digital IT PMO Phase 3')">Digital IT PMO Phase 3</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                10/10/2023
                                            </td>
                                            <td style="">
                                                Build Partnerships, Project Governance
                                            </td>
                                            <td style="">
                                                Rajeev Kapur
                                            </td>
                                            <td style="display: none;">
                                                3
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                09/15/2023
                                            </td>
                                        </tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EUFXt84vO3tFu9dUYnj_5XABh_xBQ1tCBra5eLQ_lUEwMA?e=Y6teEK" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(9, 'Sales BI 2023')">Sales BI 2023</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-warning">At Risk </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Deliver Data &amp; Analytics 
                                            </td>
                                            <td style="">
                                                
                                            </td>
                                            <td style="display: none;">
                                                2
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Keith Hopkins
                                            </td>
                                            <td style="display: none;">
                                                08/31/2023
                                            </td>
                                        </tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EUOBcD3396NBpGBAapS4aj8B1MDVhk7B4JNFtV0IkLpdMg?e=21l6qj" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(10, 'SAP India Rollout 2023')">SAP India Rollout 2023</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-warning">At Risk </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Simplify Business Apps
                                            </td>
                                            <td style="">
                                                
                                            </td>
                                            <td style="display: none;">
                                                2
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Arabinda Chakraborty
                                            </td>
                                            <td style="display: none;">
                                                09/01/2023
                                            </td>
                                        </tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/Eel2fQXt_41BvEUemC2K024BW6QInkcFHCJooEMV4AMufg?e=tI1OeV" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(11, 'Supply Chain BI 2023')">Supply Chain BI 2023</a>
                                                    <span class="text-primary" data-popup="popover" title="" data-content="test project summary" data-original-title="Project Summary" aria-describedby="popover462764">
                                                        <i class="icon-help mr-2"></i>
                                                    </span>
                                            </td>
                                            <td>
                                                <span class="badge badge-warning">At Risk </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Deliver Data &amp; Analytics , Modernize Cloud Apps, Standardize Infrastructure
                                            </td>
                                            <td style="">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                1
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Keith Hopkins
                                            </td>
                                            <td style="display: none;">
                                                12/15/2023
                                            </td>
                                        </tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/r/sites/ITProjectUpdates/_layouts/15/Doc.aspx?sourcedoc=%7BE987AE7B-2C37-41C9-B634-3831F056D600%7D&amp;file=PRO001235%20Special%20Price%20Request.pptx&amp;action=edit&amp;mobileredirect=true" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(12, 'PRO001235 - Special Price Request')">PRO001235 - Special Price Request</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Simplify Business Apps, Manage Financials
                                            </td>
                                            <td style="">
                                                Marc Fournier
                                            </td>
                                            <td style="display: none;">
                                                1
                                            </td>
                                            <td style="display: none;">
                                                Yes
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                09/21/2023
                                            </td>
                                        </tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EcYJpKQLWedMgBKLcx_wDfcB2WlvXhWWdRL4kVCp5UgH7w?e=vqywEm" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(13, 'Complaint System - External Supplier Site Upgrade')">Complaint System - External Supplier Site Upgrade</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Simplify Business Apps
                                            </td>
                                            <td style="">
                                                Isam Brahim
                                            </td>
                                            <td style="display: none;">
                                                2
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                12/13/2023
                                            </td>
                                        </tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EW4Q8ODDrtRFhDJywn0Uvd4BQMbACR1wGqa4nHHJ88S2iQ?e=n8CCaA" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(14, 'Product Database Refresh')">Product Database Refresh</a>
                                                    <span class="text-primary" data-popup="popover" title="" data-content="Change is for adding Italian to technical data sheets and product details" data-original-title="Project Summary" aria-describedby="popover462764">
                                                        <i class="icon-help mr-2"></i>
                                                    </span>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Planning
                                            </td>
                                            <td style="">
                                                10/06/2023
                                            </td>
                                            <td style="">
                                                Modernize Cloud Apps
                                            </td>
                                            <td style="">
                                                Damien Cadour
                                            </td>
                                            <td style="display: none;">
                                                2
                                            </td>
                                            <td style="display: none;">
                                                Yes
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                09/26/2023
                                            </td>
                                        </tr><tr class="group"><td colspan="11" style="font-weight: bold;">Information Technology</td></tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EW4Q8ODDrtRFhDJywn0Uvd4BQMbACR1wGqa4nHHJ88S2iQ?e=n8CCaA" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(18, 'ENH001215 - GNPD Enhancements')">ENH001215 - GNPD Enhancements</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Initiation
                                            </td>
                                            <td style="">
                                                12/31/2023
                                            </td>
                                            <td style="">
                                                Modernize Cloud Apps
                                            </td>
                                            <td style="">
                                                Martin Saville
                                            </td>
                                            <td style="display: none;">
                                                0
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                11/06/2023
                                            </td>
                                        </tr><tr class="group"><td colspan="11" style="font-weight: bold;">Packaging and Specialty Paper</td></tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/Eel2fQXt_41BvEUemC2K024BW6QInkcFHCJooEMV4AMufg?e=tI1OeV" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(11, 'Supply Chain BI 2023')">Supply Chain BI 2023</a>
                                                    <span class="text-primary" data-popup="popover" title="" data-content="test project summary" data-original-title="Project Summary" aria-describedby="popover462764">
                                                        <i class="icon-help mr-2"></i>
                                                    </span>
                                            </td>
                                            <td>
                                                <span class="badge badge-warning">At Risk </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Deliver Data &amp; Analytics , Modernize Cloud Apps, Standardize Infrastructure
                                            </td>
                                            <td style="">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                1
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Keith Hopkins
                                            </td>
                                            <td style="display: none;">
                                                12/15/2023
                                            </td>
                                        </tr><tr class="odd">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EW4Q8ODDrtRFhDJywn0Uvd4BQMbACR1wGqa4nHHJ88S2iQ?e=n8CCaA" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(19, 'Shebnem Test')">Shebnem Test</a>
                                                    <span class="text-primary" data-popup="popover" title="" data-content="This is a test project" data-original-title="Project Summary" aria-describedby="popover462764">
                                                        <i class="icon-help mr-2"></i>
                                                    </span>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Ideation
                                            </td>
                                            <td style="">
                                                12/29/2023
                                            </td>
                                            <td style="">
                                                Support Digital Brand, Standardize Infrastructure
                                            </td>
                                            <td style="">
                                                Carrie Rose
                                            </td>
                                            <td style="display: none;">
                                                3
                                            </td>
                                            <td style="display: none;">
                                                Yes
                                            </td>
                                            <td style="display: none;">
                                                Shebnem Harris
                                            </td>
                                            <td style="display: none;">
                                                12/13/2023
                                            </td>
                                        </tr><tr class="group"><td colspan="11" style="font-weight: bold;">Release Liners</td></tr><tr class="even">
                                            
                                            <td style="width:15%;" class="dtr-control" tabindex="0">
                                                <a href="https://mativglobal.sharepoint.com/:p:/s/ITProjectUpdates/EQyQGmsJEchPn4XRtSeAhqEBSCU7A8nabSXE7ViE8My41w?e=ZGZXuM" target="_blank" style="text-decoration: underline;" onclick="ProjectClick(8, 'ITASA LN ERP Harmonization 2023')">ITASA LN ERP Harmonization 2023</a>
                                            </td>
                                            <td>
                                                <span class="badge badge-success">On Target </span>
                                            </td>
                                            <td style="">
                                                Execution
                                            </td>
                                            <td style="">
                                                09/29/2023
                                            </td>
                                            <td style="">
                                                Simplify Business Apps
                                            </td>
                                            <td style="">
                                                
                                            </td>
                                            <td style="display: none;">
                                                0
                                            </td>
                                            <td style="display: none;">
                                                No
                                            </td>
                                            <td style="display: none;">
                                                Ivan Valdemoros
                                            </td>
                                            <td style="display: none;">
                                                09/01/2023
                                            </td>
                                        </tr></tbody>
      </table>
    </div>
  </body>
</html>
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
 
  var groupColumn = 0;
        $(document).ready(function () {
          
            // Setup clone - header filter
            $('#main-table thead tr')
                .clone(true)
                .addClass('filters')
                .appendTo('#main-table thead');
            //Generate filter inputs and apply filter.
            var table = $('#main-table').DataTable({
                columnDefs: [{ visible: false, targets: groupColumn }, { width: '10%', targets: 5 }],
                destroy: true,
                orderCellsTop: true,
                fixedHeader: true,
                pageLength: 50,
                dom: 'Bfrtip',
                buttons: {
                    dom: {
                        button: {
                            className: 'dt-button button-page-length btn btn-secondary'
                        }
                    },
                    buttons: [
                        {
                            extend: 'excelHtml5',
                            className: 'btn btn-secondary',
                            exportOptions: {
                                columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
                            },
                            title: "",
                            filename: "All Projects List"
                        },
                        'pageLength'
                    ]
                },
                "order": [[groupColumn, "asc"]],
                "oLanguage": {
                    "sEmptyTable": "No data available."
                },
                "drawCallback": function (settings) {
                    var api = this.api();
                    var rows = api.rows({
                        page: 'current'
                    }).nodes();
                    var last = null;
                    api.column(groupColumn, {
                        page: 'current'
                    }).data().each(function (group, i) {
                        if (last !== group) {
                            $(rows).eq(i).before(
                                '<tr class="group"><td colspan="11" style="font-weight: bold;">' + group + '</td></tr>'
                            );
                            last = group;
                        }
                    });
                },
                initComplete: function () {
                    var api = this.api();
                    // For each column
                    api
                        .columns()
                        .eq(0)
                        .each(function (colIdx) {
                            // Set the header cell to contain the input element
                            var cell = $('.filters th').eq(
                                $(api.column(colIdx).header()).index()
                            );
                            var title = $(cell).text();
                            if ($(api.column(colIdx).header()).index() >= 0) {
                                if ($(api.column(colIdx).header()).index() == 3) {
                                    $(cell).html('<input type="text" id="ReqDateRead" class="form-control datepicker" placeholder="MM/dd/yyyy" />');
                                }
                                else if ($(api.column(colIdx).header()).index() == 7) {
                                    $(cell).html('<input type="checkbox" class="form-check-input filterCheckbox" name="capex" />');
                                }
                                else if ($(api.column(colIdx).header()).index() == 9) {
                                    $(cell).html('<input type="text" id="lastUpdateDate" class="form-control datepicker" placeholder="MM/dd/yyyy" />');
                                }
                                else {
                                    $(cell).html('<input type="text" class="form-control" style="width:100%" placeholder="Search" />');
                                }
                            }
                            // On every keypress in this input
                            $(
                                'input',
                                $('.filters th').eq($(api.column(colIdx).header()).index())
                            )
                                .off('keyup change')
                                .on('change', function (e) {
                                    // Get the search value
                                    $(this).attr('title', $(this).val());
                                    var regexr = '({search})'; //$(this).parents('th').find('select').val();
                                    var cursorPosition = this.selectionStart;
                                    // Search the column for that value
                                    api
                                        .column(colIdx)
                                        .search(
                                            this.value != ''
                                                ? regexr.replace('{search}', '(((' + this.value + ')))')
                                                : '',
                                            this.value != '',
                                            this.value == ''
                                        )
                                        .draw();
                                })
                                .on('keyup', function (e) {
                                    e.stopPropagation();
                                    $(this).trigger('change');
                                    $(this)
                                        .focus()[0];
                                    //.setSelectionRange(cursorPosition, cursorPosition);
                                });
                        });
                },
            });
            var dateRangeStart, dateRangeEnd;
            $("#main-table_filter").prepend('<div class="filter-date-range-picker"><input class="form-control form-control-sm" id="date_range" type="text" placeholder="Select dates" style="width: 230px; margin-right: 10px;"></div>');
            $("#date_range").daterangepicker({
                autoUpdateInput: false,
                locale: {
                    "format": "MM/DD/YYYY",
                    "cancelLabel": "Clear",
                }
            });
            $("#date_range").on('apply.daterangepicker', function (ev, picker) {
                dateRangeStart = moment(picker.startDate.format('MM/DD/YYYY'), 'MM/DD/YYYY');
                dateRangeEnd = moment(picker.endDate.format('MM/DD/YYYY'), 'MM/DD/YYYY');
                $(this).val(dateRangeStart.format('MM/DD/YYYY') + ' to ' + dateRangeEnd.format('MM/DD/YYYY'));
                $.fn.dataTable.ext.search.push(function (settings, data, dataIndex) {
                    let min = dateRangeStart;
                    let max = dateRangeEnd;
                    let date = new Date(data[3]);
                    if (
                        (min === null && max === null) ||
                        (min === null && date <= max) ||
                        (min <= date && max === null) ||
                        (min <= date && date <= max)
                    ) {
                        return true;
                    }
                    return false;
                });
                table.draw();
            });
            $("#date_range").on('cancel.daterangepicker', function (ev, picker) {
                dateRangeStart = dateRangeEnd = null;
                $(this).val('');
                table.draw();
            });
            $('#range').on('change', table.draw);
            $('#range').change();
            table.buttons().container()
                .appendTo('#datatable-buttons_wrapper .col-md-6:eq(0)');
            $(".dataTables_length select").addClass('form-select form-select-sm');
            //Set datepicker
            $(".datepicker").datepicker({
                format: 'MM/dd/yyyy'
            });
            //Open calander when click on icon.
            $('.date-icon').on('click', function () {
                $('.datepicker').focus();
            });
            $('input:checkbox[name="capex"]').on('change', function () {
                //build a regex filter string with an or(|) condition
                var checked = $('input:checkbox[name="capex"]').is(':checked');
                if (checked) {
                    checked = "Yes"
                } else {
                    checked = ""
                }
                table.column(8).search(checked).draw(false);
            });
            // Order by the grouping
            $('#main-table tbody').on('click', 'tr.group', function () {
                var currentOrder = table.order()[0];
                if (currentOrder[0] === groupColumn && currentOrder[1] === 'asc') {
                    table.order([groupColumn, 'desc']).draw();
                }
                else {
                    table.order([groupColumn, 'asc']).draw();
                }
            });
        });
3 errors 7 warnings
Line 108: Use '!==' to compare with ''.
Line 109: Bad line breaking before '?'.
Line 111: Use '!==' to compare with ''.
Line 112: Use '===' to compare with ''.
Line 120: Expected an assignment or function call and instead saw an expression.
Line 144: 'let' is available in ES6 (use esnext option) or Mozilla JS extensions (use moz).
Line 145: 'let' is available in ES6 (use esnext option) or Mozilla JS extensions (use moz).
Line 146: 'let' is available in ES6 (use esnext option) or Mozilla JS extensions (use moz).
Line 197: Missing semicolon.
Line 199: Missing semicolon.
Output 300px

This bin was created anonymously and its free preview time has expired. Get a free unrestricted account

Dismiss x
public
Bin info
anonymouspro
0viewers