<?php
    include 'header.php';
    
$sql = "SELECT * FROM loan_plans ";
$result = $conn->query($sql);
$plans = [];
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $plans[] = $row;
    }
}
$conn->close();
?>
    
    

    
    <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">
                        Select New Loan Plan
                    </h2>
                </div>

                <div>
                   <a href="javascript:void(0);" onclick="window.history.back();" 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="py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-sm bg-[#0e1726] p-4 md:p-10">
                        <div class="w-full h-full flex justify-center">

                
                <form action="confirm_loans.php" method="POST" class="w-full grid  grid-cols-1 mt-12">
                    <input type="hidden" name="_token" value="ZNnXKYQyOx5JKtsRY5o4lDzBTDBUkLI4TgOrtZa4"> 
                    <?php foreach ($plans as $plan): ?>
                    <div class="w-full lg:w-60 xl:w-72 relative bg-transparent ">
                        
                        <div class="absolute w-full h-44 bg-gradient-to-r from-blue-800 via-blue-400 to-green-300 rounded-2xl z-10">
                            <div class="flex justify-between items-center pr-2">
                                <div class="bg-[#060818] text-white font-bold h-10 w-10 rounded-full flex justify-center items-center opacity-70">   <?= htmlspecialchars($plan['id']) ?></div>
                            </div>

                            <div class="w-full flex justify-center">
                                <div class="text-xl md:text-2xl font-extrabold text-gray-200">
                                      <?= htmlspecialchars($plan['name']) ?>
                                </div>
                            </div>
                        </div>
                        
                        <div class="w-full flex justify-center">
                            <div class="absolute w-10/12 h-20 bg-gray-900 rounded-md z-10 top-32">
                                <div class="w-full h-full flex justify-center items-center px-3 md:px-5 text-gray-100 text-sm md:text-base font-medium">
                                    <div class="flex justify-between space-x-1">
                                        <div>
                                            <h2>USD<?= number_format($plan['min_deposit'], 2) ?></h2>
                                        </div>
                                        <div>-</div>
                                        <div>
                                            <h2>USD<?= number_format($plan['max_amount'], 2) ?></h2>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                        <div class="absolute w-full pb-7 md:pb-10 bg-gray-800 top-32 rounded-md z-0">
                            <div class="w-full flex justify-center mt-24 text-xs md:text-sm text-[#ebedf2]">
                                <div class="w-4/5">
                                    <table class="w-full">
                                        <tr>
                                            <td class="font-medium">Min Deposit To Qualify:</td>
                                            <td>USD<?= number_format($plan['min_deposit'], 2) ?></td>
                                        </tr>
                                                                                <tr>
                                            <td class="font-medium">Interest:</td>
                                            <td>  <?= htmlspecialchars($plan['interest_rate']) ?> %</td>
                                        </tr>
                                                                            </table>

                                    <div class="w-full flex mt-10 justify-center">
                                                <label for="plan<?= $plan['id'] ?>" type="submit"
                                                    class="w-2/3 text-xs md:text-sm text-[#d1d5db] text-center px-5 py-2 bg-blue-500 hover:bg-gray-700 rounded-md">
                                                    Next
                                                </label>
                                                <input type="radio" name="loan_plan_id" id="plan<?= $plan['id'] ?>" 
                                                    value="<?= $plan['id'] ?>" class="hidden" required onclick="this.form.submit()">
                                            </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    

                    <div class="w-full mt-[25rem]">
                        <button type="button" class="hidden">
                            Next
                        </button>
                    </div>
                    <?php endforeach; ?>
                </form>



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


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