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
(919, '56608', 19, '2022-01-03 12:40:00', 'Audit_70611646821089.wav', '2022-01-17 07:02:45', '2022-01-17 22:53:57', 'Additional effort is missing', 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 95%\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                                                                56608\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                                                                Shreya 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_70611646821089.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                                                            2022-01-03 12:40: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                                                            Additional effort is missing\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 style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Additional effort is missing(didn&#39;t show any additional effort to convince customer for new sales)\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;95% -- 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/919/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/919/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
(920, '58364', 10, '2022-01-12 12:59:00', 'Audit_95301555722010.WAV', '2022-01-17 08:36:48', '2022-01-17 08:42:28', '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                                                                58364\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                                                                Swagatam 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_95301555722010.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                                                            2022-01-12 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 Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/920/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/920/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
(921, '59021', 10, '2022-01-15 18:13:00', 'Audit_92410087296134.WAV', '2022-01-17 08:38:50', '2022-01-17 08:42:34', 'Category wrong\r\nCSAT pitch missing', 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                                                                59021\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                                                                Swagatam 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_92410087296134.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                                                            2022-01-15 18:13: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                                                            Category wrong\r\nCSAT pitch missing\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Ticket raised under wrong category- it should be raised under New sales\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 Reminder\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                                                                    CSAT pitch is missing\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;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/921/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/921/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
(922, '59165', 6, '2022-01-17 15:30:00', 'Audit_26084965323226.WAV', '2022-01-18 01:25:24', '2022-01-18 04:20:36', '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                                                                59165\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                                                                Imran Hosain \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_26084965323226.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                                                            2022-01-17 15: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 Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/922/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/922/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
(923, '58920', 6, '2022-01-15 13:13:00', 'Audit_23673673230364.WAV', '2022-01-18 01:31:21', '2022-01-18 04:20:41', '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                                                                58920\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                                                                Imran Hosain \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_23673673230364.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                                                            2022-01-15 13:13:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/923/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/923/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
(924, '59257', 9, '2022-01-17 18:08:00', 'Audit_66624412026544.WAV', '2022-01-18 02:23:38', '2022-01-18 03:35:12', 'Opening is not proper\r\nAssurance missing', 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                                                                59257\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Pal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_66624412026544.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                                                            2022-01-17 18:08: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                                                            Opening is not proper\r\nAssurance missing\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Assurance for help is missing\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Opening is not proper\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(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/924/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/924/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
(925, '59275', 9, '2022-01-17 18:50:00', 'Audit_43159564787766.WAV', '2022-01-18 02:26:56', '2022-01-18 04:05:29', 'Assurance is missing\r\n', 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 95%\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                                                                59275\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Pal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_43159564787766.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                                                            2022-01-17 18:50:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Assurance is missing\r\n\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Assurance for help is missing\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Observed lack of energy\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;95% -- 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/925/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/925/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
(926, '58796', 13, '2022-01-14 15:17:00', 'Audit_07368174111046.WAV', '2022-01-18 05:13:43', '2022-01-18 05:17:59', 'Communication Tone is not proper', 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 95%\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                                                                58796\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Mandal \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_07368174111046.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                                                            2022-01-14 15:17: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                                                            Communication Tone is not proper\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 style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Communication Tone is not proper(Its like script reading)\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;95% -- 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/926/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/926/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
(927, '59039', 13, '2022-01-15 19:47:00', 'Audit_37241228330098.WAV', '2022-01-18 05:16:26', '2022-01-18 05:17:53', '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                                                                59039\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Mandal \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_37241228330098.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                                                            2022-01-15 19:47:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/927/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/927/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
(928, '59240', 13, '2022-01-17 15:55:00', 'Audit_63769620712567.WAV', '2022-01-18 05:35:11', '2022-01-18 05:38: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                                                                59240\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Mandal \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_63769620712567.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                                                            2022-01-17 15:55:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/928/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/928/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
(929, '59460', 8, '2022-01-18 19:57:00', 'Audit_39941647588452.WAV', '2022-01-19 02:59:31', '2022-01-19 03:03:52', 'Assurance missing\r\nObserved stammering ', 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(237, 197, 50);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 90%\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                                                                59460\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Riya Roy \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_39941647588452.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                                                            2022-01-18 19:57:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Assurance missing\r\nObserved stammering \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Assurance for help missing\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                                                                    Communication Tone/ Approach\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                                                                    observed stammering in 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                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                          \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(237, 197, 50);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;90% -- 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/929/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/929/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
(930, '59383', 8, '2022-01-18 13:49:00', 'Audit_76561509591582.WAV', '2022-01-19 03:02:04', '2022-01-19 03:03:40', 'Confirm understanding missing', 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                                                                59383\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Riya Roy \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_76561509591582.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                                                            2022-01-18 13:49: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                                                            Confirm understanding missing\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 style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    didn&#39;t ask if we could help him any other way or not\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(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/930/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/930/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
(931, '58850', 15, '2022-01-14 19:26:00', 'Audit_78286263093417.WAV', '2022-01-19 03:35:24', '2022-01-19 08:25:20', 'overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                58850\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                                                                Manodeep 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_78286263093417.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                                                            2022-01-14 19:26:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/931/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/931/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
(932, '58861', 15, '2022-01-14 19:53:00', 'Audit_07958676993902.WAV', '2022-01-19 03:37:43', '2022-01-19 08:25:02', '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                                                                58861\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                                                                Manodeep 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_07958676993902.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                                                            2022-01-14 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                                                            overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/932/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/932/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
(933, '59296', 11, '2022-01-17 19:23:00', 'Audit_16018111013526.WAV', '2022-01-19 07:18:07', '2022-01-20 06:35:56', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                59296\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav 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_16018111013526.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                                                            2022-01-17 19:23:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/933/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/933/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
(934, '58957', 11, '2022-01-15 14:41:00', 'Audit_28434880827570.WAV', '2022-01-19 07:20:25', '2022-01-20 06:36:05', '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                                                                58957\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav 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_28434880827570.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                                                            2022-01-15 14: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 Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/934/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/934/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);
