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
(17, '20836', 11, '2021-07-31 17:37:00', 'Audit_64113533256427.wav', '2021-08-04 13:58:40', '2021-08-05 20:15:55', '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                                                                20836\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_64113533256427.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-31 17:37: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/17/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/17/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
(18, '20647', 11, '2021-07-30 17:51:00', 'Audit_92205576146821.wav', '2021-08-04 14:01:26', '2021-08-05 20:16:39', 'Overall good', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 100%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                20647\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_92205576146821.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-30 17:51:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/18/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/18/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
(19, '20870', 18, '2021-07-31 06:48:00', 'Audit_35847051210011.wav', '2021-08-05 17:06:18', '2021-08-06 14:35:57', 'Hold time is more than 2 minutes, Wrong resolution given(customer was unable to send question, the page was buffering, informed customer to take subscription as resolution) ', 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                                                                20870\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                                                                Abhijeet Kumar \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_35847051210011.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-31 06:48:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Hold time is more than 2 minutes, Wrong resolution given(customer was unable to send question, the page was buffering, informed customer to take subscription as resolution) \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Wrong resolution given(customer was unable to send question, the page was buffering, informed customer to take subscription as resolution) \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Hold time is more than 2 minutes &amp; refreshing not done\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;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/19/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/19/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>', 'DISAGREED', 1);
INSERT INTO `audit_master` (`audit_id`, `ticket_id`, `emp_id`, `call_date_time`, `audit_file`, `audit_date_time`, `audit_update_time`, `audit_comments`, `audit_by`, `audit_mail_data`, `audit_approved`, `is_deleted`) VALUES
(20, '20118', 18, '2021-07-27 06:28:00', 'Audit_82069457359192.wav', '2021-08-05 17:14:23', '2021-08-06 12:58:40', 'CRM notes 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(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                                                                20118\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                                                                Abhijeet Kumar \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_82069457359192.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-27 06:28: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                                                            CRM notes 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 >\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                                                                    CRM notes is meaningless(Looking at the option of subscriber to class-10 subscriber.)\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/20/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/20/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
(21, '20646', 19, '2021-07-30 05:47:00', 'Audit_13565783357256.wav', '2021-08-05 17:54:47', '2021-08-06 12:55:36', 'Communication tone is low sometimes, observed lack of confidence ', 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                                                                20646\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_13565783357256.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-30 05: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                                                            Communication tone is low sometimes, observed lack of confidence \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                                                                    \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/21/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/21/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
(22, '20881', 16, '2021-07-31 06:38:00', 'Audit_28707756194688.wav', '2021-08-05 18:19:24', '2021-08-06 12:15:37', 'Short notes is not proper(Others(not interested)', 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                                                                20881\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Farhaj Mridha \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_28707756194688.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-31 06:38: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                                                            Short notes is not proper(Others(not interested)\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                                                                    Short notes is not proper. Not verified calls. Short notes: Others(not interested)\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/22/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/22/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
(23, '20852', 16, '2021-07-31 06:28:00', 'Audit_30134506973253.wav', '2021-08-05 18:21:42', '2021-08-06 12:26:39', 'Short notes 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(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                                                                20852\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Farhaj Mridha \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_30134506973253.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-31 06:28: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                                                            Short notes 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 >\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                                                                    Short notes(others not interested)\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/23/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/23/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
(24, '20192', 19, '2021-07-30 10:12:00', 'Audit_78287459670007.wav', '2021-08-05 18:48:55', '2021-08-06 12:51:51', 'Observed lack of confidence', 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                                                                20192\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_78287459670007.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-30 10:12: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                                                            Observed lack of confidence\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                                                                    Lack of confidence observed 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(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/24/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/24/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
(25, '12345', 12, '2021-07-29 02:45:00', 'Audit_67301378536102.wav', '2021-08-05 19:16:23', '2021-08-06 12:08:50', 'Not giving scope to customer for speaking, Assurance for help 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(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                                                                000\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                                                                Anwesha Ganguly \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_67301378536102.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-29 02:45: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                                                            Not giving scope to customer for speaking, Assurance for help 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 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 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                                                                    Not giving scope to customer for speaking\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/25/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/25/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
(26, '20300', 12, '2021-07-28 04:22:00', 'Audit_82664314731735.wav', '2021-08-05 19:24:38', '2021-08-06 12:09:41', 'Assurance for help 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                                                                20300\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                                                                Anwesha Ganguly \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_82664314731735.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-28 04:22:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Assurance for help 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 style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Assurance for help is missing\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\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/26/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/26/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
(27, '20763', 7, '2021-07-31 01:09:00', 'Audit_47219701764537.wav', '2021-08-06 11:28:46', '2021-08-06 12:54:19', 'Communication is not proper sometimes given pause to complete a sentence', 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                                                                20763\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                                                                Subhankar Chakraborty \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_47219701764537.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-31 01:09:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Communication is not proper sometimes given pause to complete a sentence\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 is not proper sometimes given pause to complete a sentence\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/27/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/27/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
(28, '20565', 7, '2021-07-30 01:21:00', 'Audit_51931039327494.wav', '2021-08-06 11:32:39', '2021-08-06 12:01:12', '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                                                                20565\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                                                                Subhankar Chakraborty \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_51931039327494.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-30 01:21: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/28/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/28/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
(29, '20113', 7, '2021-06-27 06:14:00', 'Audit_62328636893902.wav', '2021-08-06 11:39:28', '2021-08-06 12:13:15', 'Registered number & contact number of the customer is different but not mentioned contact number in notes', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 85%\r\n                                                                        </div>\r\n                                                                          \r\n                                                                \r\n                                                            </th>\r\n                                                        </tr>                                                  \r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                #Ticket Id\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                20113\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                                                                Subhankar Chakraborty \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_62328636893902.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-06-27 06:14:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Registered number &amp; contact number of the customer is different but not mentioned contact number in notes\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Registered number &amp; contact number of the customer is different but not mentioned contact number in notes\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT Reminder\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/29/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/29/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
(30, '12345', 14, '2021-07-31 03:37:00', 'Audit_08183850682291.wav', '2021-08-06 16:39:06', '2021-08-06 19:29:47', 'No ticket found in CRM', 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                                                                    <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=\"emsg\">\r\n                                                                        AUTO FAILED\r\n                                                                    </div>\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                                                                12345\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                                                                Kanishka  Das \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_08183850682291.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-31 03:37:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            No ticket found in CRM\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 style=color:red>\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                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    No ticket found in CRM\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                                                                        <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=\"emsg\">\r\n                                                                            &nbsp;&nbsp;AUTO FAILED\r\n                                                                        </th>\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/30/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/30/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
(31, '20609', 14, '2021-07-30 03:38:00', 'Audit_04365616093315.wav', '2021-08-06 17:01:40', '2021-08-06 19:29:17', 'Meaningless notes in CRM', 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                                                                20609\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                                                                Kanishka  Das \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_04365616093315.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-30 03:38: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                                                            Meaningless notes in CRM\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                                                                    Meaningless notes in CRM(Boot is showing the subject video cumming soon)\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/31/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/31/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
(32, '12345', 14, '2021-07-29 06:46:00', 'Audit_10558481527758.wav', '2021-08-06 17:08:35', '2021-08-06 19:28:17', 'No ticket found in CRM,CSAT 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                                                                    <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=\"emsg\">\r\n                                                                        AUTO FAILED\r\n                                                                    </div>\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                                                                12345\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                                                                Kanishka  Das \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_10558481527758.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2021-07-29 06:46:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            No ticket found in CRM,CSAT 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 >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT 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 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                                                                    PC work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    No ticket found in CRM\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                                                                        <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=\"emsg\">\r\n                                                                            &nbsp;&nbsp;AUTO FAILED\r\n                                                                        </th>\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/32/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/32/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);
