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
(3242, '1094508', 47, '2023-04-05 10:56:00', 'Audit_25402897029902.wav', '2023-04-06 03:34:58', '2023-04-06 04:55:52', 'IMPROPER RESOLUTION//IMPROPER 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 70%\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                                                                1094508\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                                                                Subhranil Dhar \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_25402897029902.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                                                            2023-04-05 10:56: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                                                            IMPROPER RESOLUTION//IMPROPER 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 style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    IMPROPER RESOLUTION: Agent gave incorrect resolution to the customer regarding subscription activatation.\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                                                                    IMPROPER NOTES: Agent failed to mention on the ticket about the subscription activation issue customer was facing.\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 | Support Ticket ID\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                                                                    Compliance/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;70% -- 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/3242/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/3242/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
(3243, '1094562', 47, '2023-04-05 12:59:00', 'Audit_25539986293127.wav', '2023-04-06 03:48:26', '2023-04-06 04:55:59', '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                                                                1094562\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                                                                Subhranil Dhar \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_25539986293127.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                                                            2023-04-05 12: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                                                            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 | Support Ticket ID\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                                                                    Compliance/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/3243/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/3243/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
(3244, '1094567', 47, '2023-04-05 13:09:00', 'Audit_80703306843816.wav', '2023-04-06 04:05:54', '2023-04-07 09:22: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                                                                1094567\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                                                                Subhranil Dhar \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_80703306843816.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                                                            2023-04-05 13:09: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 | Support Ticket ID\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                                                                    Compliance/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/3244/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/3244/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
(3245, '1094273', 47, '2023-04-03 17:35:00', 'Audit_69205775111582.wav', '2023-04-06 04:40:52', '2023-04-07 01:28:10', '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                                                                1094273\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                                                                Subhranil Dhar \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_69205775111582.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                                                            2023-04-03 17:35: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 | Support Ticket ID\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                                                                    Compliance/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/3245/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/3245/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
(3246, '1094779', 47, '2023-04-06 13:20:00', 'Audit_01884896867218.wav', '2023-04-06 04:55:54', '2023-04-07 01:29:04', 'IMPROPER 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                                                                1094779\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                                                                Subhranil Dhar \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_01884896867218.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                                                            2023-04-06 13:20: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                                                            IMPROPER 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                                                                    IMPROPER NOTES: The agent pitched the student for class 11 subscription no mention in the ticket. \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 | Support Ticket ID\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                                                                    Compliance/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/3246/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/3246/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
(3247, '1094783', 33, '2023-04-06 13:30:00', 'Audit_38158715990987.wav', '2023-04-06 06:46:15', '2023-04-06 06:47:54', '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                                                                1094783\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                                                                Prottay  Mondal \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_38158715990987.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                                                            2023-04-06 13:30: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 | Support Ticket ID\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                                                                    Compliance/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/3247/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/3247/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
(3248, '1094764', 33, '2023-04-06 12:41:00', 'Audit_62498378448907.wav', '2023-04-06 07:30:07', '2023-04-06 07:32:10', '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                                                                1094764\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                                                                Prottay  Mondal \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_62498378448907.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                                                            2023-04-06 12:41: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 | Support Ticket ID\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                                                                    Compliance/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/3248/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/3248/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
(3249, '1094383', 33, '2023-04-04 17:31:00', 'Audit_11963599053593.wav', '2023-04-06 07:49:07', '2023-04-06 07: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                                                                1094383\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                                                                Prottay  Mondal \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_11963599053593.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                                                            2023-04-04 17:31: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 | Support Ticket ID\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                                                                    Compliance/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/3249/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/3249/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
(3250, '1069629', 33, '2023-04-01 13:22:00', 'Audit_00233531499645.wav', '2023-04-06 08:28:25', '2023-04-06 08:28:58', 'INCORRECT TICKET CREATION', 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                                                                1069629\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                                                                Prottay  Mondal \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_00233531499645.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                                                            2023-04-01 13:22: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                                                            INCORRECT TICKET CREATION\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                                                                    INCORRECT TICKET CREATION: Agent should have raised the issue in the student account but agent raised the ticket in the student account. \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 | Support Ticket ID\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                                                                    Compliance/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/3250/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/3250/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
(3251, '1069779', 33, '2023-04-05 17:09:00', 'Audit_11329755102090.wav', '2023-04-06 09:28:40', '2023-04-07 09:22:59', 'IMPROPER 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                                                                1069779\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                                                                Prottay  Mondal \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_11329755102090.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                                                            2023-04-05 17:09: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                                                            IMPROPER 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                                                                    IMPROPER NOTES: Agent failed to mention all the queries asked by the MP, Agent notes quality is very poor. \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 | Support Ticket ID\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                                                                    Compliance/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/3251/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/3251/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
(3252, '1094682', 48, '2023-04-05 19:05:00', 'Audit_21341285945984.wav', '2023-04-06 09:38:38', '2023-04-07 06:46:48', 'NO ASSURANCE FOUND//SURVEY NOT PITCHED', 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                                                                1094682\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                                                                Rohin Mukherjee \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_21341285945984.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                                                            2023-04-05 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                                                            NO ASSURANCE FOUND//SURVEY NOT PITCHED\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                                                                    NO ASSURANCE FOUND: Agent failed to give assurance to the customer \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 style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\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                                                                    SURVEY NOT PITCHED: Agent failed to pitch for survey to the customer\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/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/3252/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/3252/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
(3253, '1094112', 48, '2023-03-31 18:14:00', 'Audit_97334284138353.wav', '2023-04-06 09:58:26', '2023-04-07 06:47:41', 'IMPROPER 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                                                                1094112\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                                                                Rohin Mukherjee \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_97334284138353.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                                                            2023-03-31 18:14: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                                                            IMPROPER 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                                                                    IMPROPER NOTES: Agent has incorrectly mentioned the calling number on the notes. Correct Calling Number: 8159846611\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 | Support Ticket ID\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                                                                    Compliance/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/3253/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/3253/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
(3254, '1094352', 48, '2023-04-04 16:09:00', 'Audit_51772855823843.wav', '2023-04-06 10:09:07', '2023-04-07 06:47:32', 'HOLD PROTOCOL NOT FOLLOWED//SURVEY NOT PITCHED', 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                                                                1094352\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                                                                Rohin Mukherjee \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_51772855823843.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                                                            2023-04-04 16:09: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                                                            HOLD PROTOCOL NOT FOLLOWED//SURVEY NOT PITCHED\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 style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    HOLD PROTOCOL NOT FOLLOWED: Agent failed to inform the customer before placing the call on hold. \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 style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\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                                                                    SURVEY NOT PITCHED: Agent failed to pitch for survey to the customer \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/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/3254/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/3254/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
(3255, '1094158', 48, '2023-04-01 19:53:00', 'Audit_68278635347158.wav', '2023-04-06 10:35:38', '2023-04-06 11:54:43', 'IMPROPER 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                                                                1094158\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                                                                Rohin Mukherjee \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_68278635347158.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                                                            2023-04-01 19:53: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                                                            IMPROPER 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                                                                    IMPROPER NOTES: Agent mentioned on the notes that the study metarial has been dispatched but the study metarial was not dispatched when the agent was taking the call. \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 | Support Ticket ID\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                                                                    Compliance/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/3255/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/3255/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
(3256, '1094746', 35, '2023-04-06 11:11:00', 'Audit_69243732623974.wav', '2023-04-07 02:14:36', '2023-04-07 02:42: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                                                                1094746\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                                                                Sudipa Ghosh \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_69243732623974.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                                                            2023-04-06 11:11: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 | Support Ticket ID\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                                                                    Compliance/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/3256/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/3256/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
(3257, '1094793', 35, '2023-04-06 13:56:00', 'Audit_48998283614361.wav', '2023-04-07 02:38:09', '2023-04-07 02:42:35', '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                                                                1094793\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                                                                Sudipa Ghosh \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_48998283614361.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                                                            2023-04-06 13:56: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 | Support Ticket ID\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                                                                    Compliance/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/3257/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/3257/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);
