INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(337, '31563', 9, '2021-10-01 10:59:00', 'Audit_06253613622391.wav', '2021-10-05 16:38:05', '2021-10-05 17:15:33', 'Ticket raised under wrong category', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 85%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31563\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Pal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_06253613622391.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-01 10:59:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Ticket raised under wrong category\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Ticket raised under wrong category\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/337/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/337/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(338, '31574', 9, '2021-10-01 11:51:00', 'Audit_14059839102988.wav', '2021-10-05 16:39:24', '2021-10-05 17:15:39', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31574\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Pal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_14059839102988.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-01 11:51:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/338/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/338/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(339, '31507', 9, '2021-09-30 18:07:00', 'Audit_48292857548057.wav', '2021-10-05 16:40:28', '2021-10-05 18:03:45', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31507\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Pal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_48292857548057.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-09-30 18:07:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/339/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/339/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(340, '31545', 16, '2021-09-30 19:05:00', 'Audit_33114890462651.wav', '2021-10-05 18:07:11', '2021-10-05 18:08:59', 'Calling number not mentioned in notes, complete issue not captured in notes', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 85%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31545\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Farhaj Mridha \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_33114890462651.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-09-30 19:05:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Calling number not mentioned in notes, complete issue not captured in notes\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Calling number not mentioned in notes, complete issue not captured in notes\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/340/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/340/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(341, '31841', 16, '2021-10-04 14:47:00', 'Audit_86748835373314.wav', '2021-10-05 18:11:08', '2021-10-05 18:12:24', '1.Calling number not mentioned in notes\r\n2.Ticket raised under wrong category\r\n3.Call disconnected but not mentioned in notes', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 85%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31841\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Farhaj Mridha \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_86748835373314.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-04 14:47:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            1.Calling number not mentioned in notes\r\n2.Ticket raised under wrong category\r\n3.Call disconnected but not mentioned in notes\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    1.Calling number not mentioned in notes\r\n2.Ticket raised under wrong category\r\n3.Call disconnected but not mentioned in notes\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/341/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/341/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(342, '31926', 16, '2021-10-04 19:27:00', 'Audit_30766796799898.wav', '2021-10-05 18:14:07', '2021-10-05 18:14:56', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31926\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Farhaj Mridha \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_30766796799898.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-04 19:27:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/342/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/342/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(343, '31852', 16, '2021-10-04 16:02:00', 'Audit_77416181643156.wav', '2021-10-05 18:15:47', '2021-10-05 18:16:07', 'Ticket raised under wrong category', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 85%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31852\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Farhaj Mridha \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_77416181643156.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-04 16:02:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Ticket raised under wrong category\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Ticket raised under wrong category\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/343/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/343/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(344, '31450', 8, '2021-09-30 14:57:00', 'Audit_79294687628842.wav', '2021-10-06 14:47:50', '2021-10-07 09:51:53', 'Assurance is missing, call disconnected not mentioned in notes', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 80%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31450\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Riya Roy \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_79294687628842.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-09-30 14:57:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Assurance is missing, call disconnected not mentioned in notes\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Assurance for help is missing\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    call disconnected but not updated in notes\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;80% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/344/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/344/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(345, '31303', 8, '2021-09-29 17:04:00', 'Audit_48174330791335.wav', '2021-10-06 14:50:56', '2021-10-07 09:51:45', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31303\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Riya Roy \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_48174330791335.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-09-29 17:04:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/345/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/345/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(346, '30911', 8, '2021-09-27 17:07:00', 'Audit_15258336051704.wav', '2021-10-06 14:54:19', '2021-10-07 09:51:32', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                30911\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Riya Roy \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_15258336051704.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-09-27 17:07:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/346/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/346/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(347, '31688', 17, '2021-10-01 17:23:00', 'Audit_03383563837658.wav', '2021-10-06 15:18:37', '2021-10-06 16:14:13', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31688\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sayan chakrabarty \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_03383563837658.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-01 17:23:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/347/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/347/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(348, '31672', 17, '2021-10-01 16:26:00', 'Audit_37779428864223.wav', '2021-10-06 15:32:05', '2021-10-06 16:14:20', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31672\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sayan chakrabarty \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_37779428864223.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-01 16:26:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/348/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/348/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(349, '31598', 17, '2021-10-01 12:29:00', 'Audit_60966561793224.wav', '2021-10-06 15:33:55', NULL, 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31598\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sayan chakrabarty \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_60966561793224.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-01 12:29:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/349/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/349/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'PENDING', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(350, '31598', 17, '2021-10-01 12:29:00', 'Audit_67654784713371.wav', '2021-10-06 16:51:47', '2021-10-07 20:13:08', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31598\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sayan chakrabarty \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_67654784713371.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-01 12:29:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/350/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/350/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 1);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(351, '31989', 5, '2021-10-05 20:27:00', 'Audit_09775046200257.wav', '2021-10-06 16:53:35', '2021-10-06 22:35:03', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                31989\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Abhishek Bag \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_09775046200257.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-05 20:27:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/351/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/351/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(352, '32083', 5, '2021-10-05 17:33:00', 'Audit_02560425021566.wav', '2021-10-06 16:55:03', '2021-10-06 22:35:14', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                32083\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Abhishek Bag \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_02560425021566.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-10-05 17:33:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/352/27\"\r\n                                                                                class=\"btn btn-primary btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-flag\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Agree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/352/56\"\r\n                                                                                class=\"btn btn-warning btn-icon-split float-right\">\r\n                                                                                <span class=\"icon text-white-50\">\r\n                                                                                    <i class=\"fas fa-exclamation-triangle\"></i>\r\n                                                                                </span>\r\n                                                                                <span class=\"text\">I Disagree</span>\r\n                                                                            </a>\r\n                                                                        </p>\r\n                                                                    </th>\r\n                                                                    <th></th>\r\n                                                                </tr>\r\n                                                </tbody>\r\n                                                </thead>\r\n                                            </table>\r\n                                        </div>\r\n\r\n                                        <hr>\r\n                                       \r\n                                    <hr>\r\n\r\n                        </div>\r\n                        \r\n\r\n                </div>\r\n                <!-- End of Main Content -->\r\n\r\n                <!-- Footer -->\r\n                <footer class=\"sticky-footer bg-white\">\r\n    <div class=\"container my-auto\">\r\n        <div class=\"copyright text-center my-auto\">\r\n            <span>Copyright &copy; Tutopia Admin 2021</span>\r\n        </div>\r\n    </div>\r\n</footer>\r\n                <!-- End of Footer -->\r\n\r\n            </div>\r\n            <!-- End of Content Wrapper -->\r\n\r\n    </div>\r\n    <!-- End of Page Wrapper -->\r\n\r\n    <!-- Bootstrap core JavaScript-->\r\n\r\n</body>\r\n\r\n</html>', 'AGREED', 0);
