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
(1694, '75112', 22, '2022-07-23 11:16:00', 'Audit_33592066052242.wav', '2022-07-28 06:25:23', '2022-07-28 07:06:33', '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                                                                75112\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                                                                Shiladitya 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_33592066052242.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-07-23 11:16: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                                                            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                                                                    Call has been disconnected at the time of further assistance, not mentioned in notes\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1694/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/1694/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
(1695, '75177', 22, '2022-07-24 19:18:00', 'Audit_88691240893085.wav', '2022-07-28 06:26:26', '2022-07-28 07:06:23', '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                                                                75177\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                                                                Shiladitya 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_88691240893085.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-07-24 19:18:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            overall good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1695/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/1695/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
(1696, '74972', 33, '2022-07-21 10:02:00', 'Audit_84992215996315.wav', '2022-07-28 08:20:47', '2022-07-28 08:36:26', 'Assurance is missing\r\nLack of confidence\r\nlack of energy in the call', 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                                                                74972\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Prottay  Mondal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_84992215996315.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-07-21 10:02:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Assurance is missing\r\nLack of confidence\r\nlack of energy in the call\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                                                                    Observed lack of confidence\r\nobserved lack of energy in the call\r\nobserved repetition 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 | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                          \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(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/1696/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/1696/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
(1697, '75144', 33, '2022-07-23 17:31:00', 'Audit_36866513143644.wav', '2022-07-28 08:37:24', '2022-07-28 09:00:04', 'Assurance is missing\r\nCSAT pitch is missing\r\nResolution is not proper\r\nwrong calling number mentioned in notes\r\nRaised ticket in wrong category', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: center;\" id=\"smsg\">\r\n                                                                            FAILED With 50%\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                                                                75144\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Prottay  Mondal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_36866513143644.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-07-23 17:31:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Assurance is missing\r\nCSAT pitch is missing\r\nResolution is not proper\r\nwrong calling number mentioned in notes\r\nRaised ticket in wrong category\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr 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 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                                                                    Customer asked whether live class timing has been changed or not- informed him to check the timing in our app\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                                                                    wrong contact number mentioned in notes\r\nTicket raised under wrong category\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Forgot to pitch CSAT\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;50% -- 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/1697/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/1697/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
(1698, '75594', 33, '2022-08-01 11:20:00', 'Audit_58996480502600.wav', '2022-08-04 05:06:34', '2022-08-04 06:22:00', 'The agent should be more confident. Knowledge gap for process knowledge found.\r\n\r\nFeedback: Refer & Earn should be properly informed. The Survey should be properly pitched as per script. Repeated mistakes will lead to mark deduction. ', 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                                                                75594\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Prottay  Mondal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_58996480502600.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 11:20:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            The agent should be more confident. Knowledge gap for process knowledge found.\r\n\r\nFeedback: Refer &amp; Earn should be properly informed. The Survey should be properly pitched as per script. Repeated mistakes will lead to mark deduction. \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                                                                    Informed that work on Arts live is in progress and will be available 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                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(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/1698/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/1698/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
(1699, '75623', 33, '2022-08-01 16:32:00', 'Audit_73901575853499.wav', '2022-08-04 05:16:51', '2022-08-04 06:22:09', 'The agent was lacking confidence on the call. \r\nFeedback: The student disconnected the call no mention in the ticket. Failure will lead to marking down in the next audit. ', 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 65%\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                                                                75623\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Prottay  Mondal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_73901575853499.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 16:32: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                                                            The agent was lacking confidence on the call. \r\nFeedback: The student disconnected the call no mention in the ticket. Failure will lead to marking down in the next audit. \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                                                                    No Apology was given to the student, No Empathy on 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 style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    The opening is not as per the script\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Ticket ID should have been informed when the student was repeatedly asking for it. \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;65% -- 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/1699/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/1699/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
(1700, '1051965', 5, '2022-08-01 19:30:00', 'Audit_99492086703583.wav', '2022-08-04 05:58:11', '2022-08-04 06:01:31', 'The agent should be more attentive towards the calls there was ample opportunity to share the ticket ID before ending the call. ', 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                                                                1051965\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Abhishek Bag \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_99492086703583.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 19:30:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            The agent should be more attentive towards the calls there was ample opportunity to share the ticket ID before ending the call. \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 | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Ticket ID not Shared \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(254, 0, 0);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57);text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;85% -- FAILED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1700/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/1700/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
(1701, '75622', 5, '2022-08-01 17:00:00', 'Audit_71255135113409.wav', '2022-08-04 06:00:52', '2022-08-04 06:01:27', 'Observed Lack of focus on the call. ', 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                                                                75622\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Abhishek Bag \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_71255135113409.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 17:00: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 focus on the call. \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    No Assurance was given to the customer\r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;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/1701/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/1701/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
(1702, '75768', 5, '2022-08-03 18:39:00', 'Audit_18355677249654.wav', '2022-08-04 06:03:43', '2022-08-04 06:12:34', '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                                                                75768\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Abhishek Bag \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_18355677249654.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-03 18:39:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall good. \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1702/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/1702/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
(1703, '75587', 13, '2022-08-01 11:25:00', 'Audit_75225440786810.wav', '2022-08-04 06:11:53', '2022-08-04 06:12:42', '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                                                                75587\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Mandal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_75225440786810.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 11:25:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall Good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1703/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/1703/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
(1704, '75568', 13, '2022-08-01 10:07:00', 'Audit_10467040260293.wav', '2022-08-04 06:16:39', '2022-08-04 06:17:03', 'Overall Good. \r\n\r\nFeedback: Not capturing the device details will lead to point deduction in the future.', 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                                                                75568\r\n                                                            </th>\r\n                                                        </tr>\r\n                                                        <tr>\r\n                                                            <th class=\"align-middle\">\r\n                                                                Audit Agent name\r\n                                                            </th>\r\n                                                            <th colspan=\"3\">\r\n                                                                Sourav Mandal \r\n                                                            </th>\r\n                                                        </tr>                                               \r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Audio Call recording\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            \r\n                                                                <a href=\"http://tutopia.info:3285/Audit_10467040260293.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 10:07:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall Good. \r\n\r\nFeedback: Not capturing the device details will lead to point deduction in the future.\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1704/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/1704/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
(1705, '1051971', 23, '2022-08-02 13:49:00', 'Audit_00196461973487.wav', '2022-08-04 06:30:17', '2022-08-04 06:37:24', '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                                                                1051971\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                                                                Manojit 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_00196461973487.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-02 13:49:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall Good. \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1705/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/1705/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
(1706, '75763', 23, '2022-08-03 18:37:00', 'Audit_28723624683252.wav', '2022-08-04 06:36:52', '2022-08-04 06:37:30', 'Overall Good\r\n\r\nFeedback: Acknowledgement should be direct, not indirect, failure will lead to mark deduction. The student mentioned source type as \"TV ADDs\" agent captured Walk-In in the ticket. The source type should be captured properly. \r\n', 2, '<!DOCTYPE html>\r\n<html lang=\"en\">\r\n\r\n<head>\r\n    <style>\r\n        table, th, td {\r\n             border: 1px solid rgb(116, 111, 111);\r\n             border-collapse: collapse;\r\n             padding: 5px;             \r\n             text-align: left;\r\n        }\r\n    </style>\r\n</head>\r\n\r\n<body id=\"page-top\">\r\n\r\n    <!-- Page Wrapper -->\r\n    <div id=\"wrapper\">\r\n            <!-- Content Wrapper -->\r\n            <div id=\"content-wrapper\" class=\"d-flex flex-column\">\r\n\r\n                <!-- Main Content -->\r\n                <div id=\"content\">\r\n                        <!-- Begin Page Content -->\r\n                        <div class=\"container-fluid\">                            \r\n                            <hr>\r\n                            \r\n                                    <hr>\r\n                                        <!-- Card Body -->\r\n                                        <div class=\"card-body table-responsive\">\r\n                                            <table class=\"table table-bordered align-middle\" width=\"100%\" cellspacing=\"0\">\r\n                                                <thead>  \r\n                                                        <tr>\r\n                                                            <th colspan=\"4\">\r\n                                                                \r\n                                                                    \r\n                                                                        <div style=\"background-color: rgb(0, 255, 1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: center;\" id=\"smsg\">\r\n                                                                            PASSED With 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                                                                75763\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                                                                Manojit 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_28723624683252.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-03 18: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\r\nFeedback: Acknowledgement should be direct, not indirect, failure will lead to mark deduction. The student mentioned source type as &#34;TV ADDs&#34; agent captured Walk-In in the ticket. The source type should be captured properly. \r\n\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1706/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/1706/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
(1707, '75635', 29, '2022-08-01 19:38:00', 'Audit_46823226906771.wav', '2022-08-04 06:44:19', '2022-08-04 06:44: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                                                                75635\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                                                                Amlan 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_46823226906771.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-01 19: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                                                            Overall Good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1707/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/1707/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
(1708, '75610', 29, '2022-08-03 12:26:00', 'Audit_73991673894022.wav', '2022-08-04 06:46:33', '2022-08-04 06:46:49', '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                                                                75610\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                                                                Amlan 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_73991673894022.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-03 12:26:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            Overall Good\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;100% -- PASSED\r\n                                                                            </th>\r\n                                                                              \r\n                                                                    \r\n                                                                    \r\n                                                                </tr>\r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Acceptance : Agree/Disagree\r\n                                                                    </th>\r\n                                                                    <th class=\"h4 text-center\">\r\n                                                                        <p>\r\n                                                                            <a href=\"http://tutopia.info:3285/common/acceptance/audit/1708/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/1708/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
(1709, '75664', 16, '2022-08-02 12:49:00', 'Audit_61972320000254.wav', '2022-08-04 07:02:55', '2022-08-04 07:03:36', 'The agent had the opportunity to pitch for a survey but the agent did not pitch, mentioning on the notes will not help when the agent had the opportunity. 1st Warning!', 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                                                                75664\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_61972320000254.wav\" target=\"blank\" class=\"btn btn-info btn-circle btn-sm\">\r\n                                                                    <i class=\"fas fa-file\">Play the file</i>\r\n                                                                </a> \r\n                                                                \r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Call Date &amp; Time\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            2022-08-02 12:49:00\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th class=\"align-middle\">\r\n                                                            Remarks\r\n                                                        </th>\r\n                                                        <th colspan=\"3\">\r\n                                                            The agent had the opportunity to pitch for a survey but the agent did not pitch, mentioning on the notes will not help when the agent had the opportunity. 1st Warning!\r\n                                                        </th>\r\n                                                    </tr>\r\n                                                    <tr>\r\n                                                        <th>Audit Matrix</th>\r\n                                                        <th class=\"text-center\">Input Weightage</th>\r\n                                                        <th class=\"text-center\">Final Weightage</th>\r\n                                                        <th class=\"text-center\">Comments</th>\r\n                                                    </tr>\r\n                                                <tbody>\r\n                                                    \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Acknowledgement and Assurance\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Communication Tone/ Approach\r\n                                                                    [CONVERSATIONAL APPROACH]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Confirm Understanding\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Resolution\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr style=color:red>\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Additional Effort and Information\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    0\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    FAILED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    Refer &amp; Earn not informed \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Hold\r\n                                                                    [END USER CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Opening and closing\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Ticket closure and Notes\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    CSAT | Support Ticket ID\r\n                                                                    [BUSINESS CRITICAL]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    15\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                        \r\n                                                            <tr >\r\n                                                                <td class=\"h6 align-middle\">\r\n                                                                    Compliance/work avoidance\r\n                                                                    [PROFESSIONAL CONDUCT]\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    5\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    PASSED\r\n                                                                </td>\r\n                                                                <td class=\"text-center\">\r\n                                                                    \r\n                                                                </td>\r\n                                                            </tr>\r\n\r\n                                                            \r\n                                                                <tr id=\"\" class=\"table-active font-weight-bold\">\r\n                                                                    <th>\r\n                                                                        Total Weightage\r\n                                                                    </th>                                                                    \r\n                                                                    \r\n                                                                    \r\n                                                                        \r\n                                                                            <th colspan=\"3\" style=\"background-color: rgb(0,255,1);padding: 10px 0 10px 0;font-size: large;color: rgb(65, 57, 57); text-align: left;\" id=\"smsg\">\r\n                                                                                &nbsp;&nbsp;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/1709/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/1709/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);
