📁 File Manager
Editing:
/home/wedigitalindia/public_html/demo.wedigitalindia.com/dcl-erp/quotation.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">QUOTATION LIST</h4> </div> <div class="col-md-9"> <a href="add-quotation.php" class="btn btn-primary" style="float: right; margin-bottom: 10px;">Add Quotation</a> </div> </div> <div class="row"> <div class="col-12"> <div class="table-responsive"> <table id="order-listing" class="table"> <thead> <tr> <th>Quotation Id</th> <th>Name</th> <th>Account</th> <th>Amount</th> <th>Status</th> <th>Actions</th> </tr> </thead> <tbody> <?php $sql = "SELECT e.employee_id, CONCAT(e.first_name, ' ', e.last_name) AS employee_name, d.designation_name, e.contact_no, e.status, e.date_of_joining FROM employees e LEFT JOIN designations d ON e.designation_id = d.designation_id ORDER BY e.employee_id DESC"; $result = mysqli_query($conn, $sql); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo '<tr> <td>' .'QUOT00' . $row['employee_id'] . '</td> <td>' . $row['employee_name'] . '</td> <td>' . $row['designation_name'] . '</td> <td>' . $row['contact_no'] . '</td> <td>' . $row['date_of_joining'] . '</td> <td><label class="badge badge-info">' . $row['status'] . '</label></td> <td> <a href="employee-list-edit.php?employee_id=' . $row['employee_id'] . '" class="btn btn-outline-primary">Edit</a> <a href="employee-details.php?employee_id=' . $row['employee_id'] . '" class="btn btn-outline-success">View</a> </td> </tr>'; } } else { echo '<tr><td colspan="6">No employees found</td></tr>'; } ?> </tbody> </table> </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">Employee View</h5>--> <!-- <button type="button" class="close" data-dismiss="modal" aria-label="Close">--> <!-- <span aria-hidden="true">×</span>--> <!-- </button>--> <!-- </div>--> <!-- <div class="modal-body">--> <!-- <div class="row">--> <!-- <div class="col-md-12">--> <!-- <h6>Employee Name : </h6>--> <!-- </div>--> <!-- </div>--> <!-- </div>--> <!-- </div>--> <!-- </div>--> <!--</div>--> <?php include_once("include/footer.php"); ?> </body> </html>
Save
Cancel