<?php
include 'header.php';

?>
    

    
    <div class="pt-28 md:pt-0 mt-0 md:mt-36 w-full md:w-4/5" id="general-content">
        <div class="w-full md:w-10/12 md:ml-64 2xl:ml-1/5" id="general-content-section">

            
            <div class="w-full py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-md bg-[#0e1726] p-2 md:p-4">
            <div class="flex justify-between items-center">
                <div>
                    
                    <h2 class="bg-transparent text-[#ebedf2] font-medium capitalize">
                        My Investments
                    </h2>
                </div>

                <div>
                   <a href="#" onclick="window.history.back(); return false;" class="flex justify-start items-center text-xs text-gray-400 hover:text-white">
    <svg xmlns="http://www.w3.org/2000/svg" class="h-5 w-5" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
        <path stroke-linecap="round" stroke-linejoin="round" d="M11 17l-5-5m0 0l5-5m-5 5h12" />
    </svg>
    <span>back</span>
</a>
                </div>
            </div>
        </div>
    </div>
</div>
            

            
            <div id="preloader" class="action-preloader">
    <div id="loading-bar-spinner" class="spinner">
        <div class="spinner-icon"></div>
    </div>
</div>

            
            
            
            <div class="notice">
    <div class="w-full py-5">
        <div class="w-full flex justify-center">
            <div class="w-11/12 md:w-2/3 rounded-lg bg-[#131d2c] p-2 md:p-4">
                <div class="flex justify-between items-center ">
                    
                    <!--                    <div>-->
                    <!--    <div class="w-full flex space-x-2  text-[#d3d6df] p-2 md:p-4 text-xs md:text-sm">-->
                    <!--        <div class="text-green-500">-->
                    <!--            <svg class="w-6 h-6" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">-->
                    <!--                <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M9 12l2 2 4-4m6 2a9 9 0 11-18 0 9 9 0 0118 0z"></path>-->
                    <!--            </svg>-->
                    <!--        </div>-->
                    <!--        <div>-->
                    <!--            <b class="font-medium">Success! </b> You have successfully purchased Best-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--</div>-->
                        
                    <div>
                        <a role="button" class="flex justify-start items-center text-xs text-gray-400 hover:text-white close_btn">
                            <svg class="w-6 h-6" fill="none" stroke="currentColor" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg">
                                <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M6 18L18 6M6 6l12 12"></path>
                            </svg>
                        </a>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
            

            
            <div class="py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-sm bg-[#0e1726] p-1 md:p-4">
            <div class="w-full py-5">
                <div class="w-full lg:flex lg:justify-evenly lg:space-x-2 space-y-3 lg:space-y-0 text-[#bfc9d4]">
                    <div class="flex lg:block justify-between items-center bg-[#152136] px-3 lg:px-6 py-2 lg:py-3 hover:text-white cursor-pointer rounded-md">
                        <div class="hidden lg:block relative w-full">
                            <div class="absolute flex justify-center items-center -top-7 -right-7 h-9 w-9 rounded-full bg-[#456499] text-white">
                                <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                    <path stroke-linecap="round" stroke-linejoin="round" d="M17 9V7a2 2 0 00-2-2H5a2 2 0 00-2 2v6a2 2 0 002 2h2m2 4h10a2 2 0 002-2v-6a2 2 0 00-2-2H9a2 2 0 00-2 2v6a2 2 0 002 2zm7-5a2 2 0 11-4 0 2 2 0 014 0z" />
                                </svg>
                            </div>
                        </div>
                        <div class="lg:pr-14">
                            <div>
                                <h2 class="text-sm lg:text-base font-semibold">USD<?= number_format($profit, 2) ?></h2>
                            </div>
                            <div class="mt-2">
                                <h4 class="text-xs lg:text-sm font-medium">Total earnings</h4>
                            </div>
                        </div>
                        <div class="lg:hidden opacity-50">
                            <div class="flex justify-center items-center h-9 w-9 rounded-full bg-[#456499] text-white">
                                <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                    <path stroke-linecap="round" stroke-linejoin="round" d="M17 9V7a2 2 0 00-2-2H5a2 2 0 00-2 2v6a2 2 0 002 2h2m2 4h10a2 2 0 002-2v-6a2 2 0 00-2-2H9a2 2 0 00-2 2v6a2 2 0 002 2zm7-5a2 2 0 11-4 0 2 2 0 014 0z" />
                                </svg>
                            </div>
                        </div>
                    </div>

                    <div class="flex lg:block justify-between items-center bg-[#152136] px-3 lg:px-6 py-2 lg:py-3 hover:text-white cursor-pointer rounded-md">
                        <div class="hidden lg:block relative w-full">
                            <div class="absolute flex justify-center items-center -top-7 -right-7 h-9 w-9 rounded-full bg-[#4e3aaa] text-white">
                                <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                    <path stroke-linecap="round" stroke-linejoin="round" d="M17 16v2a2 2 0 01-2 2H5a2 2 0 01-2-2v-7a2 2 0 012-2h2m3-4H9a2 2 0 00-2 2v7a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-1m-1 4l-3 3m0 0l-3-3m3 3V3" />
                                </svg>
                            </div>
                        </div>
                      <div class="lg:pr-14">
    <div>
        <?php
        // Query to calculate total invested amount for the user
        $total_query = "SELECT SUM(invest_amt) as total_invested FROM users_investment WHERE userId = $user_id";
        $total_result = mysqli_query($conn, $total_query);
        $total_data = mysqli_fetch_assoc($total_result);
        $total_invested = $total_data['total_invested'] ?? 0;
        ?>
        <h2 class="text-sm lg:text-base font-semibold">USD<?= number_format($total_invested, 2) ?></h2>
    </div>
    <div class="mt-2">
        <h4 class="text-xs lg:text-sm font-medium">Total invested</h4>
    </div>
</div>
                        <div class="lg:hidden opacity-50">
                            <div class="flex justify-center items-center h-9 w-9 rounded-full bg-[#4e3aaa] text-white">
                                <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                    <path stroke-linecap="round" stroke-linejoin="round" d="M17 16v2a2 2 0 01-2 2H5a2 2 0 01-2-2v-7a2 2 0 012-2h2m3-4H9a2 2 0 00-2 2v7a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-1m-1 4l-3 3m0 0l-3-3m3 3V3" />
                                </svg>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
                            <div class="w-full flex justify-center items-center mt-5">
                    <div class="w-full flex justify-center items-center lg:w-2/3">
                        <canvas id="myChart" width="100" height="100"></canvas>
                    </div>
                </div>
                    </div>
    </div>
</div>


            

            

        <div class="py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-sm bg-[#0e1726] p-1 md:p-4">
            <?php
            // Assuming you already have a database connection established
            // $user_id should be defined somewhere before this code

            $query = "SELECT `id`, `userId`, `planId`, `invest_amt`, `plan_name`, `increase`, `duration`, `total_profit`, `start_date`, `end_date`, `status`, `date` FROM `users_investment` WHERE userId = $user_id";
            $result = mysqli_query($conn, $query); // Replace $conn with your DB connection variable

            if(mysqli_num_rows($result) > 0) {
                // Start the table with your original styling
                echo '<table id="datatable-skeleton-table" class="text-[#bfc9d4] text-xs md:text-sm">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Plan Name</th>
                                <th>Invested Amount</th>
                                <th>Daily Increase</th>
                                <th>Total Profit</th>
                                <th>Start Date</th>
                                <th>End Date</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody width="100%">';
                
                $counter = 1;
                
                // Using do-while loop to fetch and display the data
                do {
                    $row = mysqli_fetch_assoc($result);
                    if($row) {
                        // Format the dates
                        $start_date = date("d.m.Y", strtotime($row['start_date']));
                        $end_date = date("d.m.Y", strtotime($row['end_date']));
                        
                        // Format status (lowercase for consistency with your example)
                        $status = strtolower($row['status']);
                        
                        echo '<tr>
                                <td>'.$counter.'</td>
                                <td>'.htmlspecialchars($row['plan_name']).'</td>
                                <td>$'.number_format($row['invest_amt'], 2).'</td>
                                <td>'.$row['increase'].'%</td>
                                <td>$'.number_format($row['total_profit'], 2).'</td>
                                <td>'.$start_date.'</td>
                                <td>'.$end_date.'</td>
                                <td>'.$status.'</td>
                              </tr>';
                        
                        $counter++;
                    }
                } while($row);
                
                echo '</tbody></table>';
            } else {
                echo '<p>No investments found.</p>';
            }

            // Free the result set
            mysqli_free_result($result);
            ?>
        </div>
    </div>
</div>

        </div>
    </div>
    
</div>


<?php
    include 'footer.php';
?>
    