<?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>
