📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/proposal.php
<?php include_once("include/head.php"); ?> <div class="main-panel"> <div class="content-wrapper"> <div class="card"> <div class="card-body"> <div class="row"> <div class="col-md-3"> <h4 class="card-title">PROPOSAL LIST</h4> </div> <div class="col-md-9"> <!--<a href="add-proposal.php" class="btn btn-primary" style="float: right; margin-bottom: 10px;">Add Proposal</a>--> </div> </div> <div class="row"> <div class="col-12"> <?php if (isset($_SESSION['success_message'])) { echo '<div class="alert alert-success">' . $_SESSION['success_message'] . '</div>'; unset($_SESSION['success_message']); } if (isset($_SESSION['error_message'])) { echo '<div class="alert alert-danger">' . $_SESSION['error_message'] . '</div>'; unset($_SESSION['error_message']); } ?> <div class="table-responsive"> <table id="order-listing" class="table"> <thead> <tr> <th>Proposal Id</th> <th>Client Name</th> <th>Phone</th> <th>Date</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php $getBranchId = $_GET['branch-id']; if ($userType === 'Admin') { if (isset($getBranchId) && !empty($getBranchId)) { $sql = "SELECT * FROM proposals WHERE branch_id = $getBranchId ORDER BY id DESC"; } else { $sql = "SELECT * FROM proposals ORDER BY id DESC"; } } else { if (isset($getBranchId) && !empty($getBranchId)) { $sql = "SELECT * FROM proposals WHERE branch_id = $getBranchId AND created_by IN ($team) ORDER BY id DESC"; } else { $sql = "SELECT * FROM proposals WHERE created_by IN ($team) ORDER BY id DESC"; } } // $sql = "SELECT * FROM proposals ORDER BY id DESC"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo '<tr> <td>' .'PROP00' . $row['id'] . '</td> <td>' . $row['client_name'] . '</td> <td>' . $row['phone'] . '</td> <td>' . $row['created_at'] . '</td> <td><label class="badge badge-info">' . $row['status'] . '</label></td> <td> <a href="proposal-edit.php?proposal_id=' . $row['id'] . '" class="btn-sm btn-success">Edit</a> <a href="proposal-view.php?proposal_id=' . $row['id'] . '" class="btn-sm btn-info">View</a> <a href="proposal-view.php?proposal_id=' . $row['id'] . '" class="btn-sm btn-primary">Send</a> <a href="client-status-edit.php?id=' . $row['client_id']. '" class="btn-secondary btn-sm">Calls</a> </td> </tr>'; } } else { echo '<tr><td colspan="6">No Proposals found</td></tr>'; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> <?php include_once("include/footer.php"); ?> </body> </html>
Save
Cancel