📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/calls.php
<?php include_once("include/head.php"); // ini_set('display_errors', 1); // ini_set('display_startup_errors', 1); // error_reporting(E_ALL); ?> <script> window.onload = function() { function hideMessage() { setTimeout(function() { const messageElement = document.getElementById('message'); if (messageElement) { messageElement.style.display = 'none'; } }, 5000); } if (document.getElementById('message')) { hideMessage(); } }; </script> <div class="main-panel"> <div class="content-wrapper"> <?php if (isset($_SESSION['success_message'])) { echo '<div id="message" class="alert alert-success">' . $_SESSION['success_message'] . '</div>'; unset($_SESSION['success_message']); echo '<script>hideMessage();</script>'; } if (isset($_SESSION['error_message'])) { echo '<div id="message" class="alert alert-danger">' . $_SESSION['error_message'] . '</div>'; unset($_SESSION['error_message']); echo '<script>hideMessage();</script>'; } ?> <div class="card"> <div class="card-body"> <div class="row"> <div class="col-md-3"><h4 class="card-title">CLIENT CALLS LIST</h4></div> <div class="col-md-9"> <!--<a href="add-vendor.php" class="btn btn-primary" style="float: right; margin-bottom: 10px;">Add Vendor</a>--> </div> </div> </div> <div class="row"> <div class="col-12"> <div class="table-responsive"> <table id="order-listing" class="table"> <thead> <tr> <th>S.No</th> <th>Client Id</th> <th>Client Name</th> <th>Phone</th> <th>Call Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php $count=1; $call_status = $_GET['call-status']; // if ($userType === 'Admin') { // if (isset($call_status) && !empty($call_status)) { // $sql = "SELECT c.id, c.name, c.phone, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id // AND f.call_date = ( SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id ) WHERE f.call_status = '$call_status'; "; // } else { // $sql = " SELECT c.id, c.name, c.phone, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id // AND f.call_date = (SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id) "; // } // } else { // $teamFilter = !empty($teamIdsString) ? " AND c.assigned_to IN ($teamIdsString)" : ""; // if (isset($call_status) && !empty($call_status)) { // $sql = "SELECT c.id, c.name, c.phone, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id // AND f.call_date = (SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id) WHERE f.call_status = '$call_status' $teamFilter; "; // } else { // $sql = "SELECT c.id, c.name, c.phone, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id // AND f.call_date = (SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id ) GROUP BY // c.id, // c.name, // c.phone; $teamFilter; "; // } // } if ($userType === 'Admin') { if (isset($call_status) && !empty($call_status)) { $sql = "SELECT c.id, c.name, c.phone, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id AND f.call_date = ( SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id ) WHERE f.call_status = '$call_status'; "; } else { $sql = " SELECT c.id, c.name, c.phone, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id AND f.call_date = (SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id) "; } } else { $teamFilter = !empty($teamIdsString) ? " AND c.assigned_to IN ($teamIdsString)" : ""; if (isset($call_status) && !empty($call_status)) { $sql = "SELECT c.id, c.name, c.phone, c.assigned_to, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id AND f.call_date = (SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id) WHERE f.call_status = '$call_status' $teamFilter; "; } else { $sql = "SELECT c.id, c.name, c.phone, c.assigned_to, COALESCE(f.call_status, 'NA') AS call_status FROM clients c LEFT JOIN follow_ups f ON c.id = f.client_id AND f.call_date = (SELECT MAX(f2.call_date) FROM follow_ups f2 WHERE f2.client_id = c.id ) GROUP BY c.id, c.name, c.phone $teamFilter; "; } } // echo $sql; if ($result = mysqli_query($conn, $sql)) { if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { // print_r($row); $callStatus = $row['call_status']; switch ($callStatus) { case 'follow_up': $callStatus = 'Follow-up'; break; case 'not_interested': $callStatus = 'Not Interested'; break; case 'interested': $callStatus = 'Interested'; break; case 'wrong_no': $callStatus = 'Wrong Number'; break; case 'busy': $callStatus = 'Busy'; break; case 'meeting': $callStatus = 'Meeting'; break; case 'visit': $callStatus = 'Visit'; break; case 'custom_container': $callStatus = 'Custom Container'; break; default: $callStatus = 'NA'; break; } ?> <tr> <td><?php echo $count++ ?></td> <td><?php echo 'CID-00' . htmlspecialchars($row['id']); ?></td> <td><?php echo htmlspecialchars($row['name']); ?></td> <td><?php echo htmlspecialchars($row['phone']); ?></td> <td><?php echo htmlspecialchars($callStatus); ?></td> <td> <?php $display = 'd-none'; if($userType == 'Employee'){ if($row['assigned_to'] == $logginedUserid) { $display = ''; } } ?> <a href="client-follow-up-history.php?id=<?php echo urlencode($row['id']); ?>" class="btn btn-secondary btn-sm">History</a> <button type="button" class="btn btn-danger btn-sm ml-1" data-toggle="modal" data-target="#exampleModal-5">Delete</button> <a href="client-status-edit.php?id=<?php echo urlencode($row['id']); ?>" class="btn btn-primary btn-sm ml-1 <?php echo $display ?>">Edit</a> </td> <?php } } else { echo '<tr><td colspan="6">0 results</td></tr>'; } } else { echo "Error executing the query: " . mysqli_error($conn); } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="modal fade" id="exampleModal-5" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel-3" aria-hidden="true"> <div class="modal-dialog modal-md" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="exampleModalLabel-3">Vendor Delete</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> Are you sure you want to delete the Vendor </div> </div> </div> </div> <?php include('include/footer.php') ?> </body> </html>
Save
Cancel