1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / proc / self / root / home / earnlouq / oxyield.live / user /
Filename : trade-cron.php
back
<?php
include('../../config/config.php');
include('includes/functions.php');
include('includes/mail-settings.php');

error_reporting(E_ALL);
ini_set('display_errors', 1);

// Get current date
$currentDate = date("Y-m-d");

// Fetch active investments that have reached their end_date
$sql = "SELECT i.id, i.user_id, i.amount, p.profit 
        FROM investments i
        JOIN investment_plans p ON i.plan_id = p.id
        WHERE i.end_date <= '$currentDate' AND i.status = 'active'";
        $result = mysqli_query($con, $sql);

if (mysqli_num_rows($result) > 0) {

    while ($row = mysqli_fetch_assoc($result)) {
        $tradeID = $row['id'];
        $uid = $row['user_id'];
        $capital = $row['amount'];
        $profit = $row['profit'];

       // Update the 'assets' column in the `users` table with the refunded capital
    $updateUserBalanceSql = "UPDATE `users` SET `assets` = `assets` + '$capital' WHERE `id` = '$uid'";
    $updateUserBalanceResult = mysqli_query($con, $updateUserBalanceSql);
    
    if ($updateUserBalanceResult) {
          
        // Calculate daily profit based on the percentage (assuming $profit contains a decimal percentage like 2.99)
        $dailyProfitPercentage = $profit / 100;
        $dailyProfit = ($capital * $dailyProfitPercentage);

        // Calculate the total profit over 30 days
        $totalProfit = $dailyProfit * 30;

        // Update the 'profit' column in the `users` table with the total profit
        $updateUserProfitSql = "UPDATE `users` SET `profit` = `profit` + $totalProfit WHERE `id` = $uid";
        $updateUserProfitResult = mysqli_query($con, $updateUserProfitSql);

        // Update the status column of the investment table to 'canceled'
        $updateInvestmentStatusSql = "UPDATE `investments` SET `status` = 'completed', `closed_on` = NOW() WHERE `id` = '$tradeID'";
        $updateInvestmentStatusResult = mysqli_query($con, $updateInvestmentStatusSql);
       
        if ($updateInvestmentStatusResult) {
            // Send an email notification

        // Fetch the user's email from the `users` table
        $getUserEmailSql = "SELECT email, username FROM users WHERE id = '$uid'";
        $getUserEmailResult = mysqli_query($con, $getUserEmailSql);
        $userRow = mysqli_fetch_assoc($getUserEmailResult);
        $email = $userRow['email'];
        $username = $userRow['username'];

        // Send an email notification
        $toEmail = $email; // The recipient's email address
            $subject = "Trade Position Completed";
                      
            $mailHeaders = "MIME-Version: 1.0" . "\r\n";
            $mailHeaders .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
            $mailHeaders .= 'From: Zelnex Bot <' . $noreply_email . '>' . "\r\n";
            $mailHeaders .= "Date: " . date('r') . " \r\n";
            $mailHeaders .= "Return-Path: " . $site_email . "\r\n";
            $mailHeaders .= "Errors-To: " . $site_email . "\r\n";
            $mailHeaders .= "Reply-to: " . $site_email . " \r\n";
            $mailHeaders .= "Organization: " . $site_title . " \r\n";
            $mailHeaders .= "X-Sender: " . $site_email . " \r\n";
            $mailHeaders .= "X-Priority: 3 \r\n";
            $mailHeaders .= "X-MSMail-Priority: Normal \r\n";
            $mailHeaders .= "X-Mailer: PHP/" . phpversion();
  
            $content = '
                <!DOCTYPE html>
                <html>
                <head>
                <meta charset="UTF-8">
                <title>Trade Position Completed</title>
                <style>
            body {
              font-family: Arial, sans-serif;
              background-color: #f6f6f6;
              margin: 0;
              padding: 0;
            }
            .container {
              max-width: 600px;
              margin: 0 auto;
              padding: 20px;
              background-color: #ffffff;
            }
            h1 {
              font-size: 24px;
              font-weight: bold;
              color: #047ded;
              margin-top: 0;
            }
            p {
              font-size: 16px;
              line-height: 1.5;
              color: #000000;
            }
            .code {
              font-size: 32px;
              font-weight: bold;
              color: #00afe9;
              text-transform: uppercase;
            }
            .footer {
              font-size: 14px;
              color: #808080;
              margin-top: 20px;
            }
            .logo {
              display:flex;
              flex-direct:column;
              align-items:center;
              justify-content:center;
              width:100%;
            text-align: center;
            margin-bottom: 20px;
          }
          </style>
                </head>
                <body>
                <div class="container">
                <div class="logo">
                  <img src="https://zelnexbot.com/images/logo.png" alt="Logo" width="100" height="auto" />
                </div>
                <h1>Trade Position Closed</h1>
                    <p>Hello ' . $username . ',</p>
                    <p>Your trade position has been successfully closed and your trade capital has been moved to your asset balance.</p>
                    <p>Trade Amount: $' . $capital . '</p>
                    <p>Profit: $' . $profit . '</p>
                    
                    <p>Thank you for choosing our platform.</p>
                    <p>Sincerely,<br>Zelnex Bot</p>
                 </div>
                </body>
                </html>
            ';
  
            if (mail($toEmail, $subject, $content, $mailHeaders)) {
                $msg = "Trade position completed successfully. An email notification has been sent.";
                $type = "success";
            } else {
                $msg = "Trade position closed successfully, but there was an issue sending the email notification.";
                $type = "warning";
            }
        }
    } else {
        // Handle the case where there are no active investments to close
        // You can log or perform other actions as needed for this scenario
    }
  
}

}else{

    echo "No active investments to close at this time.";

}
?>