1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / buildersmine.com / app /
Filename : interests.php
back
<?php
session_start();
error_reporting(0);
include('../../config/bconfig.php');
include('includes/checklogin.php');
check_login();
$title="Earnings";
$uid=$_SESSION['id'];
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 
include 'includes/sidebar.php';

$currentTime = date( 'd-m-Y h:i:s A', time () );
$sql = "SELECT * FROM users WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);


if(isset($_POST['submit']))
{
    $amount=$_POST['amount'];
	$eid=$_POST['eid']; //earning ID

    //Define old and new balance
    $oldbal=$row["balance"];
    $newbal=($oldbal+$amount);

if(empty($amount) || empty($eid) ){
    $msg="An Error Occured please try again";
    $type = "warning";
}elseif($amount = ""){ 
    $msg = 'An Unexpected Error Occured please try again'; 
    $type = "warning";
}else{
    $sql2="UPDATE `users` SET `balance`='$newbal' WHERE `id`='$uid' ";
    $result2=mysqli_query($con,$sql2);
    if($result2){ 
    $sql1="UPDATE `earnings` SET `status`='1' WHERE `uid`='$uid' AND `id`='$eid' ";
    $result1=mysqli_query($con,$sql1);
    if($result1){ 
        $msg="Earning claimed Successfully";
        $type = "success";
    }else{
        $msg="Couldn't claim earning,please try again";
        $type = "warning";  
    }
    

    }else{
    $msg="something went wrong,please try again";
    $type = "warning";
    }   
}

}
			?>

 
<div class="container-fluid pt-4 px-4">
<div class="bg-secondary  rounded p-4">
      <div class="d-flex align-items-center justify-content-between mb-4">
          <h4 class="card-title">P/L record</h4>
      </div>

            <div class="bg-secondary rounded h-100 p-4">           
                    
                    <?php if(isset($msg)) { ?>
                <div class="error-wrapper-<?php echo $type?>">
                <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                </div>
                <?php }?>
                  
                <div class="table-responsive">
                        <?php 
                         $query="SELECT * FROM `transactions` WHERE `type`='Profit' AND`user_id`='$uid' ORDER BY id DESC  ";
                         $result=mysqli_query($con,$query);
                         $cnt=1;
                         if(mysqli_num_rows($result)>0){
                            ?>
               <table class="table">
                <thead>
                    <tr>
                    <th>SN</th>
                    <th>Amount</th>
                    <th>Date</th>
                    </tr>
                </thead>
                <tbody>
                <?php 
            while($trx=mysqli_fetch_array($result)){
                $status=$trx['status'];
                $date=$trx['date'];
                // date_from must be from 3rd day (from order date)
                         // date_to must be the next 5th days
                         $trx_date = date(' jS F, Y ');
                         $today_date = date('l jS \of F Y');
                ?>
                    <tr>
                    <td><?php echo $cnt++; ?></td>
                    <td style="color:green">+$<?php echo $trx['amount']; ?></td>
                    <td><?php echo $trx_date; ?></td>
                   </tr>
                    <?php } 
            }else{
                echo"
                <div class='card-body'>
                <p style='text-align:left'> No Record yet!</p>
                </div>
                ";
            }
            ?>
                </tbody>
                </table>
                    </div>
                    </div>

                    </div>

                  </div>
             
<?php include 'includes/footer.php' ?>