1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / user /
Filename : non-affiliate-payment.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('includes/checklogin.php');
include('includes/functions.php');

check_login();
$title="Dashboard";
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 

$today = date("Y-m-d");

$uid= $_SESSION['id'];
$sql = "SELECT * FROM `users` WHERE `id`=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);
$uplan=$row['plan_id'];
$username=$row['username'];

$activity_balance=$row['earnings'];
$referral_balance=$row['ref_bonus'];
$indirect_referral_balance=number_format($row['indirect_ref_bonus']);
$cashout_balance=$row['cashout'];
$non_referral_earning=$row['non_referral_earning'];

  //Activate Non affiliate payment.
  if(isset($_GET['activate']))
  {
    $sql1="UPDATE `users` SET `non_referral_earning`='1' WHERE `id`='$uid' ";
    $result1=mysqli_query($con,$sql1);
        // Redirect to non-affiliate-payment.php after the update
        echo "<script>window.location.href = 'non-affiliate-payment.php';</script>";
        exit();  
  }

  $queryReferrals = "SELECT * FROM `users` WHERE `referred_by`='$username' AND `created_at` >= '2024-02-04 00:00:00'";
  $resultReferrals = mysqli_query($con, $queryReferrals);
  
  if ($resultReferrals) {
      $referralCount = mysqli_num_rows($resultReferrals);
      //$referralCount = 4;

      $totalReferrals = 4;  
      // Store the referral count in a variable for reuse
      $referralCountDisplay = $referralCount . ' out of ' . $totalReferrals;
  
  }
    

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $amount = 25000;
    $type = 'Non Affiliate';

    // Check if the user has already made a withdrawal
    $checkWithdrawnQuery = "SELECT withdrawn_flag FROM `users` WHERE `id`='$uid'";
    $checkResult = mysqli_query($con, $checkWithdrawnQuery);
    
    if ($checkResult) {
        $userRow = mysqli_fetch_assoc($checkResult);

        if ($userRow['withdrawn_flag'] == 1) {
            $msg = "You have already made a withdrawal.";
            $type = "warning";
            // You can redirect or handle this case as needed
        } else {
            // Deduct withdrawal amount from user's existing earnings
            $newbal = 0;

            $sql1 = "INSERT INTO `transactions` (`user_id`,`account_type`,`type`,`amount`,`created_at`)
                    VALUES ('$uid','$type','Withdrawal','$amount','$today')";
            $result1 = mysqli_query($con, $sql1);

            if ($result1) {
                $updateQuery = "UPDATE `users` SET `earnings`='$newbal',`cashout`='$newbal', `withdrawn_flag` = 1 WHERE `id`='$uid'";
                $result2 = mysqli_query($con, $updateQuery);

                if ($result2) {
                    $msg = "Withdrawal placed successfully.";
                    $type = "success";
                    echo '<script>
                        setTimeout(function () {
                            window.location ="history.php";
                        }, 3000);
                    </script>';
                } else {
                    $msg = "Something went wrong, please try again";
                    $type = "warning";
                }
            } else {
                $msg = "Something went wrong, please try again";
                $type = "warning";
            }
        }
    } else {
        $msg = "Error checking withdrawal status.";
        $type = "warning";
    }
}

?>

<main class="main-wrapper">
            <div class="container-fluid">
                <div class="inner-contents">
                    <div class="page-header align-items-center justify-content-between mr-bottom-30">
                    <?php if(isset($msg)){ ?>
                                <div class="alert alert-<?php echo $type?>">
                                <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                                <p class="mb-0"><?php echo $msg?></p>
                                </div>
                        <?php }?>


<?php 
                    if($non_referral_earning == 0){ ?>
                    <h4>Non-Referral Earnings Withdrawal Policy.</h4>
                    Dear <?php echo $username; ?>,

<p>We trust this message finds you well. As part of our commitment to enhancing the platform and ensuring fairness, we have made updates to the non-referral earnings withdrawal policy.</p>

<h5>NEW NON-REFERRAL WITHDRAWAL CRITERIA:</h5>

<p>To withdraw your non-referral earnings, users are now required to refer 4 persons. 
    Upon successful referral, you qualify for a total withdrawal of ₦25,000,
     comprising a minimum of ₦15,000 - ₦20,000 PMQ Activities Earnings and ₦15,000 PMQ Cashout Bonus.</p>

<h5>HOW IT WORKS:</h5>

<p>1. REFER 4 PERSONS:  Successfully refer 4 persons to qualify for withdrawal.</p>

<p>2. WITHDRAWAL AMOUNT: Eligible users can withdraw a total of ₦25,000, with a breakdown as follows:</p>
<p> ₦15,000 - ₦20,000 from PMQ Activities Earnings.</p>
<p>₦15,000 from PMQ Cashout Bonus.</p>

<p>This adjustment is designed to encourage active participation, foster community growth, and reward your efforts on
     the Promiq Technology platform.</p>

<h5>THIS PROCESS LAST ONLY FOR 14 DAYS UPON YOUR REQUEST OF ACTIVATION.</h5>

<h5>PLEASE KINDLY ACT FAST TO MEET THE REQUIREMENTS</h5>


                <a href="?id=<?php echo $row['id'];?>&activate=true" 
                        onClick="return confirm('Are you sure you want to activate no referral payment for your account?')" 
                        class="btn btn-primary deactivate-account">
                        <i class="fa fa-check"></i> Activate To Cashout</a>
<?php
                    }else{
                    ?>

            <div class="page-header d-flex align-items-center justify-content-between mr-bottom-30">
                                <div class="left-part">
                                    <h2 class="text-dark">Non-Affiliate Referral Stats</h2>
                                    <p class="text-gray mb-0">Hi there, your referrals for non affiliate payment.</p>
                                </div>  
								<div class="right-part">
									<button  class="btn btn-primary rounded-2 ff-heading fs-18 fw-bold py-4">
									<?php echo $referralCountDisplay;?>
									</button>
								</div>   
                            </div>


                            <div class="card border-0">
								<div class="dropdown-widget p-5">
                                    <div class="dropdown-wrapper">
                                          
                                    <?php if ($referralCount >= 4 && $activity_balance >= 20000 && $cashout_balance >= 15000) { ?>

                                                 <p>Congrats! You are now eligible to withdraw your non-affiliate earnings</p>                           

<div style="display:flex;align-items:center;justify-content:center;">

<form class="" method="post" action="">
    <div class="form-group">
        <button type="submit" class="btn btn-primary" onclick="return confirm('Are you sure you want to withdraw?')">Withdraw</button>
    </div>
</form>
</div>

<?php } ?>


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



<?php }?>


<div style="height:50px;"></div>
                    </div>
                      </div>
                        </div>
                          </main>
<?php include 'bottom-tabs.php' ?>
<?php include 'includes/footer.php' ?>