<?php ob_start(); include "../connect/db.php"; ?>
<!DOCTYPE html>
<html lang="en">

<head>
    <!-- Required meta tags-->
    <meta name="robots" content="noindex,nofollow">
<meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="au theme template">
    <meta name="author" content="Hau Nguyen">
    <meta name="keywords" content="au theme template">

    <!-- Title Page-->
    <title>Investment</title>

    <!-- Fontfaces CSS-->
    <link href="css/font-face.css" rel="stylesheet" media="all">
    <link href="vendor/font-awesome-4.7/css/font-awesome.min.css" rel="stylesheet" media="all">
    <link href="vendor/font-awesome-5/css/fontawesome-all.min.css" rel="stylesheet" media="all">
    <link href="vendor/mdi-font/css/material-design-iconic-font.min.css" rel="stylesheet" media="all">

    <!-- Bootstrap CSS-->
    <link href="vendor/bootstrap-4.1/bootstrap.min.css" rel="stylesheet" media="all">

    <!-- Vendor CSS-->
    <link href="vendor/animsition/animsition.min.css" rel="stylesheet" media="all">
    <link href="vendor/bootstrap-progressbar/bootstrap-progressbar-3.3.4.min.css" rel="stylesheet" media="all">
    <link href="vendor/wow/animate.css" rel="stylesheet" media="all">
    <link href="vendor/css-hamburgers/hamburgers.min.css" rel="stylesheet" media="all">
    <link href="vendor/slick/slick.css" rel="stylesheet" media="all">
    <link href="vendor/select2/select2.min.css" rel="stylesheet" media="all">
    <link href="vendor/perfect-scrollbar/perfect-scrollbar.css" rel="stylesheet" media="all">

    <!-- Main CSS-->
    <link href="css/theme.css" rel="stylesheet" media="all">

</head>

<body class="animsition">
    <div class="page-wrapper">

   
        <?php include"includes/header.php" ?>        

        <!-- PAGE CONTAINER-->
        <div class="page-container"> 

            <!-- MAIN CONTENT-->
            <div class="main-content">
                <div class="section__content section__content--p30">
                    <div class="container-fluid">
                        <div class="row">
                            <div class="col-lg-12" >
                                <div class="card">
                                    <div class="card-body" style="border-radius: 5px;box-shadow: 0 0 10px 5px #cecece;">
                                        <h5 class="card-title">Users</h5>
                                        <div class="table-responsive">
                                            <table class="table table-striped">
                                                <thead>
                                                    <tr>
                                                        <th scope="col">#</th>
                                                        <th scope="col">Amount</th>
                                                        <th scope="col">Investment Type</th>
                                                        <th scope="col">Investor</th>
                                                        <th scope="col">Status</th>
                                                        <th scope="col">d_o_inv</th>
                                                    </tr>
                                                </thead>
                                                <tbody> 
                                                    <?php
                                                        $tosin = mysqli_query($con,"SELECT * FROM investments ");
                                                        $user = mysqli_num_rows($tosin);
                                                        if( $user == 0 ){
                                                            echo'
                                                                <tr>
                                                                    <td colspan="8">Oops! No Investments has been made</td>
                                                                </tr>
                                                            '
                                                            ;
                                                        }
                                                        else{
                                                            $i = 1;
                                                            while( $tosin_req = mysqli_fetch_assoc($tosin) ){
                                                                echo'
                                                                    <tr>
                                                                        <td>'.$i.'</td>
                                                                        <td>'.$tosin_req['amount'].'</td>
                                                                        <td>'.$tosin_req['investment_type'].'</td>
                                                                        <td>'.$tosin_req['investor'].'</td>
                                                                        <td>'.$tosin_req['status'].'</td>
                                                                        <td>'.$tosin_req['d_o_inv'].'</td>
                                                                        <td><a href="editinvest.php?id='.$tosin_req['id'].'" ><span class="btn btn-md btn-info" ><i class="fa fa-edit" ></i></span></a></td>
                                                                        <td><span onclick=deleteInvest("'.$tosin_req['id'].'") class="btn btn-md btn-danger" ><i class="fa fa-trash" ></i></span></td>
                                                                    </tr>
                                                                '
                                                                ;
                                                                $i++ ;
                                                            }                                                    
                                                        }
                                                    ?>                      
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>                                  
                            </div>
                        </div>
                        <?php include"includes/footer.php"; ?>
                    </div>
                </div>
            </div>
            <!-- END MAIN CONTENT-->
            <!-- END PAGE CONTAINER-->
        </div>

    </div>

    <!-- Jquery JS-->
    <script src="vendor/jquery-3.2.1.min.js"></script>
    <!-- Bootstrap JS-->
    <script src="vendor/bootstrap-4.1/popper.min.js"></script>
    <script src="vendor/bootstrap-4.1/bootstrap.min.js"></script>
    <!-- Vendor JS       -->
    <script src="vendor/slick/slick.min.js">
    </script>
    <script src="vendor/wow/wow.min.js"></script>
    <script src="vendor/animsition/animsition.min.js"></script>
    <script src="vendor/bootstrap-progressbar/bootstrap-progressbar.min.js">
    </script>
    <script src="vendor/counter-up/jquery.waypoints.min.js"></script>
    <script src="vendor/counter-up/jquery.counterup.min.js">
    </script>
    <script src="vendor/circle-progress/circle-progress.min.js"></script>
    <script src="vendor/perfect-scrollbar/perfect-scrollbar.js"></script>
    <script src="vendor/chartjs/Chart.bundle.min.js"></script>
    <script src="vendor/select2/select2.min.js">
    </script>

    <script src="js/sweetalert2.all.min.js"></script>
    <!-- Main JS-->
    <script src="js/main.js"></script>
    <script src="js/custom.js"></script>

</body>

</html>
<!-- end document-->
