if($_REQUEST['filter']=="" || $_REQUEST['filter']=="current"){$filter="WHERE `statuslive`='1'";}
if($_REQUEST['filter']=="archive"){$filter="WHERE `statuslive`='0'";}
$stmt = $GLOBALS['con']->prepare("SELECT `contractor_number`,`contractor_name`,`pri_contact`,`tel`,`email`,`statuslive` FROM `contractors` $filter")or die(mysqli_error($GLOBALS['con']));
$stmt->execute();$cc=$stmt->get_result();$stmt->close();
?>
<script>
$('#navBox').html(
    '<li class="breadcrumb-item"><a href="index.php?t=includes/master&p=contractor.php&view=list">Contractors</a><i class="fad fa-angle-double-right mx-2 mt-1" aria-hidden="true"></i></li><li class="breadcrumb-item active">Contractor List</li>'
)
</script>

<div class="row">
    <div class="col text-end">

                <div id="exportTitle" style="display:none">
            <p style="font-size:14px; font-weight:bold">EnRep Reporting System</p>
            <p style="font-size:12px"><a href="">Contractor List</a> : <a href="">Active contractors</a></p>
        </div>

        <div class="col text-end">
            <a href="index.php?t=includes/master&p=contractor.php&view=new" class="btn btn-secondary btn-sm"><i class="fad fa-plus" aria-hidden="true"></i> New Contractor</a>
            <a href="index.php?t=includes/master&p=contractor.php&view=list&filter=archive" class="btn btn-secondary btn-sm">View Archived contractors</a>
            <script>
            $('#navBox').html(
                '<li class="breadcrumb-item"><a href="index.php?t=includes/master&p=contractor.php&view=list">Contractors</a><i class="fad fa-angle-double-right mx-2 mt-1" aria-hidden="true"></i></li><li class="breadcrumb-item"><a href="javascript:void(0)">Contractor List</a><i class="fad fa-angle-double-right mx-2 mt-1" aria-hidden="true"></i></li><li class="breadcrumb-item active">Active contractors</li>'
            )
            </script>
        </div>
        
    </div>
</div>
<style>
#datatable>tbody>tr>td {
    vertical-align: middle
}
</style>
<table id="datatable" class="table table-striped table-sm table-bordered table-hover responsive" width="100%">
    <thead>
        <tr>
            <th>Name</th>
            <th>Primary Contact</th>
            <th>Phone</th>
            <th>Email</th>
            <th></th>
        </tr>
    </thead>
    <tbody>