<?php

?>
<div class="col-12">
    <div class="card mb-4">
        <div class="card-header pb-0">

        </div>
        <div class="card-body px-0 pt-0 pb-2">
            <div class="table-responsive p-0">
                <table class="table table-bordered" id="example" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>NO. PO</th>
                            <th>ID CUST.</th>
                            <th>CUST. NAME</th>
                            <th>ACTION</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $sql = mysqli_query($con, "SELECT noPo, idCust, custName FROM customerpo WHERE noPo NOT IN (SELECT statusmail.noPo FROM statusmail) GROUP BY noPO");
                        while ($row = mysqli_fetch_assoc($sql)) {
                        ?>
                        <tr>
                            <td><?php echo $row['noPo'] ?></td>
                            <td><?php echo $row['idCust'] ?></td>
                            <td><?php echo $row['custName'] ?></td>
                            <td><a class="btn btn-primary"
                                    href="?menu=actionMail&po=<?php echo $row['noPo'] ?>&idcust=<?php echo $row['idCust'] ?>">SEND
                                    MAIL</a></td>
                        </tr>
                        <?php } ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>