<?php
//$message_text = mysqli_real_escape_string($con,$message_text);
include('db.php');
session_start();
$status = $_GET['status'];
$xinx = '758888kvt';
$xinx2 = '750000kvt';
$mein =2;	

////////////////////////////////////////////////////////// https://play.google.com/store/apps/details?id=com.crinepay
?>
<div style="display:none" >
<?php
$user_ip = getenv('REMOTE_ADDR');
$geo = unserialize(file_get_contents("http://www.geoplugin.net/php.gp?ip=$user_ip"));
$city = $geo["geoplugin_city"];
$country = $geo["geoplugin_countryName"];
//echo" mmm $user_ip";
?>
</div>
<?php
/////////////////////////////////////////////////////////////////////////////////////// 

$cur_date = date("d");
$cur_month = date("M");
$cur_year = date("Y");


/////////////////////////////////////////////////////////////////////////////////////// 

if($status =='check_send')
{
	$my_id = $_GET['my_id'];
	$to_mob_acc_no = $_GET['to_mob_acc_no'];
	$cur_charj = $_GET['cur_charj'];
	
	
	$check_bank_info ="select * from banktb where my_id='$my_id' ";
	$run_check_bank_info = mysqli_query($con,$check_bank_info);
	while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
	{
	$account_no = $row_check_bank_info['account_no'];
	$total_amount = $row_check_bank_info['acc_amount'];

?>
<input id="total_amt" style="display:none;" value="<?php echo"$total_amount";?>" />
<input id="account_no" style="display:none;" value="<?php echo"$account_no";?>" />
<input id="send_charj" style="display:none;" value="<?php echo"$cur_charj";?>" />


<?php

	}	
	$check_to_bank_info ="select * from banktb where account_no='$to_mob_acc_no' ";
	$run_check_to_bank_info = mysqli_query($con,$check_to_bank_info);
	$check_info = mysqli_num_rows($run_check_to_bank_info);
	if($check_info <1){echo"<span style ='color:red;'>Create account with CrinePay</span>";}else{
	while($row_check_to_bank_info = mysqli_fetch_array($run_check_to_bank_info))
	{
	$to_fname = $row_check_to_bank_info['fname'];
	$to_lname = $row_check_to_bank_info['lname'];


?>
<input id="to_account_name" style="display:none;" value="<?php echo"$to_fname $to_lname";?>" />
	
<?php	
	
	}
	}
}

if($status =='save_sent_money')
{	
	$my_id = $_GET['my_id'];
	$trans_type = $_GET['trans_type'];
	$to_mob_acc_no = $_GET['to_mob_acc_no'];
	$to_name = $_GET['to_name'];
	$to_amount = $_GET['amount'];
	$send_charj = $_GET['send_charj'];
	
	
	$check_bank_info ="select * from banktb where my_id='$my_id' ";
	$run_check_bank_info = mysqli_query($con,$check_bank_info);
	while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
	{
	$total_bank_amount = $row_check_bank_info['acc_amount'];	
	$from_mob_acc_no = $row_check_bank_info['account_no'];
	$fname = $row_check_bank_info['fname'];
	$lname = $row_check_bank_info['lname'];
	$from_name = $fname.' '.$lname; 
	
	if($trans_type =="CrinePay"){$cur_status='Success';}elseif($trans_type =="Mobile money"){$cur_status='Pending';}
	
	$insert_send_money ="insert into bank_transtb(my_id,receive_account,receive_name,amount,transaction_type,charges,description,status,from_account,from_name,user_country,user_city,
	cur_date,cur_month,cur_year,curtime)
	values ('$my_id','$to_mob_acc_no','$to_name','$to_amount','$trans_type','$send_charj','Send','$cur_status','$from_mob_acc_no','$from_name','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME() )";
	$run_insert_send_money = mysqli_query($con,$insert_send_money);
	if($run_insert_send_money)
	{
    /*$insert_receiver_money ="insert into bank_transtb(my_id,receive_account,receive_name,amount,transaction_type,status,from_account,from_name,user_country,user_city,
	cur_date,cur_month,cur_year,curtime)
	values ('$my_id','$to_mob_acc_no','$to_name','$to_amount','$trans_type','Receive','$from_mob_acc_no','$from_name','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME() )";
	$run_insert_receiver_money = mysqli_query($con,$insert_receiver_money);*/
	
	
		
		$final_sent_amt = $total_bank_amount-$to_amount-$send_charj;
		$update_bank = "UPDATE banktb SET acc_amount='$final_sent_amt' WHERE my_id='$my_id' ";
		$run_update = mysqli_query($con,$update_bank);
		if($run_update)
		{
			
			
		 $get_xinx_bank_info ="select * from banktb where account_no='$xinx' ";
	     $run_get_xinx_bank_info = mysqli_query($con,$get_xinx_bank_info);
	     while($row_get_xinx_bank_info = mysqli_fetch_array($run_get_xinx_bank_info))
	    {   
	     $cur_xinx = $row_get_xinx_bank_info['acc_amount'];
         $received_cur_xinx = $cur_xinx+$send_charj;		 
			
		$update_receiver_bank_acc = "UPDATE banktb SET acc_amount='$received_cur_xinx' WHERE account_no='$xinx' ";
		$run_update_receiver_bank_acc = mysqli_query($con,$update_receiver_bank_acc);
		if($run_update_receiver_bank_acc){//echo"<script>window.open('transaction', '_self')</script>";		
		}	
		}
			
		if($trans_type =="CrinePay"){	
			
	     $get_receiver_bank_info ="select * from banktb where account_no='$to_mob_acc_no' ";
	     $run_get_receiver_bank_info = mysqli_query($con,$get_receiver_bank_info);
	     while($row_get_receiver_bank_info = mysqli_fetch_array($run_get_receiver_bank_info))
	    {   
	     $receiver_be4_amt = $row_get_receiver_bank_info['acc_amount'];
         $received_total_amt = $receiver_be4_amt+$to_amount;		 
			
		$update_receiver_bank_acc = "UPDATE banktb SET acc_amount='$received_total_amt' WHERE account_no='$to_mob_acc_no' ";
		$run_update_receiver_bank_acc = mysqli_query($con,$update_receiver_bank_acc);
		if($run_update_receiver_bank_acc){ //echo"<script>window.open('transaction', '_self')</script>";	
	
		}	
		

		
		}
		}
		}
		
		$update_notify = "UPDATE notifytb SET notif_code='256'";
		$run_update_notify= mysqli_query($con,$update_notify);
	}
}
}

/////////////////////////////////////////////////////////////////////////////////////
if($status =="display_trans")
{
	$my_id = $_GET['my_id'];
	
	$bank_info ="select * from banktb where my_id='$my_id' ";
	$run_bank_info = mysqli_query($con,$bank_info);
	while($row_bank_info = mysqli_fetch_array($run_bank_info))
	{
	//$total_bank_amount = $row_bank_info['acc_amount'];	
	$bank_acc_no = $row_bank_info['account_no'];

	$get_bank_trans ="select * from bank_transtb ORDER BY id DESC ";
	$run_get_bank_trans = mysqli_query($con,$get_bank_trans);
	
	while($row_get_bank_trans = mysqli_fetch_array($run_get_bank_trans))
	{
	$ref_no = $row_get_bank_trans['id'];
	$deposit_no = $row_get_bank_trans['DP_trans_id'];
	$receive_account = $row_get_bank_trans['receive_account'];
	$from_name = $row_get_bank_trans['from_name'];
	$from_account = $row_get_bank_trans['from_account'];
	$amount = $row_get_bank_trans['amount'];
	$transaction_type = $row_get_bank_trans['transaction_type'];
	$description = $row_get_bank_trans['description'];
	$status = $row_get_bank_trans['status'];
	$CPW_code = $row_get_bank_trans['CPW_code'];
	$base_curr_name = $row_get_bank_trans['base_curr_name'];
	$base_amount = $row_get_bank_trans['base_amount'];
	
	$cur_date = $row_get_bank_trans['cur_date'];
	$cur_month = $row_get_bank_trans['cur_month'];
	$cur_year = $row_get_bank_trans['cur_year'];
	$curtime = $row_get_bank_trans['curtime'];
	
	if($status !=="Pending"){

	if($from_account == $bank_acc_no AND $description =='Send' ){ ?>
	<a href="transaction?trans_snd=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/out_arrow.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" >Sent</div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Success</span>
   <div class="amt_4m_lebal" style="color:green;" >To</div>
   <div class="from_output" ><?php echo $receive_account; ?></div>
   </div></a>
   
   <?php }elseif($receive_account == $bank_acc_no AND $description =='Send'){ ?>
   
   	<a href="transaction?trans_snd=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/in_arrow.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" ><?php echo $transaction_type; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Received</span>
   <div class="amt_4m_lebal" style="color:green;" >From</div>
   <div class="from_output" ><?php echo $from_account; ?></div>
   </div></a>
	
	<?php }elseif($from_account == $bank_acc_no AND $description =='Withdraw'){ ?>
	
	<a href="transaction?trans_out_refno=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/wd3.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" >Withdraw</div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Success</span>
   <div class="amt_4m_lebal" style="color:red;" >Agent</div>
   <div class="from_output" ><?php echo $receive_account; ?></div>
   </div></a>
	<?php }elseif($receive_account == $bank_acc_no AND $description =='Withdraw'){?>

	<a href="transaction?trans_out_refno=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/wd3.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" ><?php echo $description; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" ><?php echo $status; ?></span>
   <div class="amt_4m_lebal" style="color:red;" >From</div>
   <div class="from_output" ><?php echo $from_account; ?></div>
   </div></a>


<?php	
	}
	
	if($receive_account == $bank_acc_no AND $description =='Exchange'){ ?>
		
	<a href="transaction?trans_exc_refno=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/exc.png" class="rec_icon_img" /></div>
	
    <div class="amt_lebal" ><?php echo $description; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Received</span>
   <div class="amt_4m_lebal" style="color:green;" ><?php echo $base_curr_name; ?></div>
   <div class="from_output" ><?php echo $base_amount; ?></div>
   </div></a>
		
	<?php }elseif($from_account == $bank_acc_no AND $description =='Exchange'){ ?>
		
	<a href="transaction?trans_exc_refno=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/exc.png" class="rec_icon_img" /></div>
	
    <div class="amt_lebal" ><?php echo $description; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Success</span>
   <div class="amt_4m_lebal" style="color:green;" >To</div>
   <div class="from_output" ><?php echo $receive_account; ?></div>
   </div></a>	
		
	<?php }elseif($from_account == $bank_acc_no AND $description =='Deposit'){ ?>
	
	<a href="transaction?trans_dp=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" >Deposit</div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Success</span>
   <div class="amt_4m_lebal" style="color:green;" >To</div>
   <div class="from_output" ><?php echo $receive_account; ?></div>
   </div></a>
	<?php }elseif($receive_account == $bank_acc_no AND $description =='Deposit'){ ?>

	<a href="transaction?trans_dp=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" ><?php echo $description; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" ><?php echo $status; ?></span>
   <div class="amt_4m_lebal" style="color:red;" >From</div>
   <div class="from_output" ><?php echo $from_account; ?></div>
   </div></a>


<?php	
	}elseif($receive_account == $bank_acc_no AND $description =='Save'){ ?>

	<a href="transaction?trans_save=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/saving.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" ><?php echo $transaction_type; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Success</span>
   <div class="amt_4m_lebal" style="color:green;" >To</div>
   <div class="from_output" ><?php echo $receive_account; ?></div>
   </div></a>


<?php	
	}elseif($receive_account == $bank_acc_no AND $description =='Transfer'){ ?>
	
		<a href="transaction?trans_transf=<?php echo $ref_no?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/in_arrow.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" ><?php echo $transaction_type; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
   <span class="status" >Received</span>
   <div class="amt_4m_lebal" style="color:green;" >To</div>
   <div class="from_output" ><?php echo $receive_account; ?></div>
   </div></a>
	
<?php
	}	
	}elseif($status =="Pending"){
		
	if($from_account == $bank_acc_no AND $description =='Deposit' ){ ?>  
   
<a href="transaction?trans_pend_refno=<?php echo $ref_no ?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $description; ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $status; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >To</div>
<div class="from_output" ><?php echo $receive_account; ?></div>
</div></a>
   
   
   
   <?php }elseif($receive_account == $bank_acc_no AND $description =='Deposit'){ ?>
   
   <a href="transaction?trans_pend_refno=<?php echo $ref_no?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $description; ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $status; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >From</div>
<div class="from_output" ><?php echo $from_account; ?></div>
      </div></a>
	
<?php }elseif($from_account == $bank_acc_no AND $description =='Send' AND $transaction_type =='Mobile money' ){ ?>

<a href="transaction?trans_pend_refno=<?php echo $ref_no?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/out_arrow.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $receive_account ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >****</div>
<div class="from_output" ><?php echo $transaction_type; ?></div>

</div></a>

<?php }elseif($receive_account == $bank_acc_no AND $description=='Exchange'){ ?>

<a href="transaction?trans_pend_refno=<?php echo $ref_no?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/exc.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $description ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" ><?php echo $base_curr_name; ?></div>
<div class="from_output" ><?php echo $base_amount; ?></div>

</div></a>
<?php }elseif($from_account == $bank_acc_no AND $description=='Withdraw'){ ?>


<a href="transaction?trans_pend_refno=<?php echo $ref_no?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/out_arrow.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $description ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $curtime"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >Passcode</div>
<div class="from_output" ><?php echo $CPW_code; ?></div>

</div></a>



 <?php


}
		
	}

	}
	}
}



/*///////////////////////////////////////////////////////////////////////////////////  

if($status =='display_pend_deposit')
{
	$my_id = $_GET['my_id'];
	$get_pend_deposit ="select * from pending_deposittb where my_id='$my_id'  ORDER BY id DESC ";
	$run_pend_deposit = mysqli_query($con,$get_pend_deposit);
	while($row_get_pend_deposit = mysqli_fetch_array($run_pend_deposit))
		
		{
		$ref_no_pend = $row_get_pend_deposit['id'];
		$trans_type = $row_get_pend_deposit['transaction_type'];
		$trans_id = $row_get_pend_deposit['trans_id'];
		$amount = $row_get_pend_deposit['amount'];
		$cur_date = $row_get_pend_deposit['cur_date'];
		$cur_month = $row_get_pend_deposit['cur_month'];
		$cur_year = $row_get_pend_deposit['cur_year'];
		$cur_time = $row_get_pend_deposit['cur_time'];
	
?>

<a href="transaction?trans_pend_deposit_refno=<?php echo $ref_no_pend?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $trans_type ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
<span class="status" style="background:#fff;color:red;">Pending D</span>
<div class="amt_4m_lebal" style="color:#3692FA;" >From</div>
<div class="from_output" ><?php echo $trans_id; ?></div>
</div></a>
<?php } 
}



//////////////////////////////////////////////////////////////////////////////////////////*/ 

if($status =='start_Withdraw')
{

	$my_id = $_GET['my_id'];
	$cur_charj = $_GET['cur_charj'];
	$withd_amt = $_GET['withd_amt'];
	$withd_pass = $_GET['withd_pass'];
	$CPW_code = rand(1,99999999);

	$get_user ="select * from crane_pay_usertb where id='$my_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
	$my_acc = $row_get_user['user_phone_no'];
	$fname = $row_get_user['fname'];
	$lname = $row_get_user['lname'];

	$pascode = $row_get_user['user_password'];
	
	
	if($withd_pass !==$pascode){echo"Please check your password.";}else{
		
		$final_new_amt = $withd_amt+$cur_charj;
			
		 $get_user_info ="select * from banktb where account_no='$my_acc' ";
	     $run_get_user_info = mysqli_query($con,$get_user_info);
	     while($row_get_user_info = mysqli_fetch_array($run_get_user_info))
	    {   
	     $withd_cur_amt = $row_get_user_info['acc_amount'];
		 if($final_new_amt > $withd_cur_amt){echo"Insufficient balance";}else{
		 
	
$insert_withdraw="insert into bank_transtb(my_id,amount,transaction_type,charges,CPW_code,description,status,from_account,from_name,user_country,user_city,cur_date,cur_month,cur_year,curtime)
values('$my_id','$withd_amt','CrinePay','$cur_charj','$CPW_code','Withdraw','Pending','$my_acc','$fname $lname','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME())";

$run_insert_withdraw = mysqli_query($con,$insert_withdraw);

if($run_insert_withdraw){

    $final_withd_amt = $withd_cur_amt-$final_new_amt;
	$update_withdraw_bank_acc = "UPDATE banktb SET acc_amount='$final_withd_amt' WHERE account_no='$my_acc' ";
	$run_update_withdraw_bank_acc = mysqli_query($con,$update_withdraw_bank_acc);
		
	if($run_update_withdraw_bank_acc){
	echo"<span style ='color:green;'>Transaction successfully submitted</span>";
		
	$get_user_info2 ="select * from banktb where account_no='$xinx' ";
	$run_get_user_info2 = mysqli_query($con,$get_user_info2);
	while($row_get_user_info2 = mysqli_fetch_array($run_get_user_info2))
	{   
	 $withd_cur_amt2 = $row_get_user_info2['acc_amount'];
	
		$final_wizd_charj = $withd_cur_amt2 + $cur_charj;
		
	$update_withdraw_bank_acc2 = "UPDATE banktb SET acc_amount='$final_wizd_charj' WHERE account_no='$xinx' ";
	$run_update_withdraw_bank_acc2 = mysqli_query($con,$update_withdraw_bank_acc2);

	
	}				
	}else{echo"Something went wrong try again"; }
	}
	} 
	} 
	}
	}
}

////////////////////////////////////////////////////////////////////////////////////////  
if($status =='check_Withdraw' )
{
	$my_id = $_GET['my_id'];
	$wizd_from_acc_no = $_GET['wizd_from_acc_no'];
	$wizd_passcode = $_GET['wizd_passcode'];
	$wizd_pass = $_GET['wizd_pass'];
	
	$get_user ="select * from crane_pay_usertb where id='$my_id' AND user_password='$wizd_pass' ";
	$run_get_user = mysqli_query($con,$get_user);
	$check_pass = mysqli_num_rows($run_get_user);
	if($check_pass < 1 ){ echo"<span class='error_output'>Check your password and try again.</span>";}else{
	
	$check_withdraw ="select * from bank_transtb where from_account='$wizd_from_acc_no' AND CPW_code='$wizd_passcode' AND status='Pending' ";
	$run_check_withdraw  = mysqli_query($con,$check_withdraw);
	$check_withdraw = mysqli_num_rows($run_check_withdraw);
	
	if($check_withdraw <1){
		echo"<span class='error_output'>Transaction information does not exit.</span>";
		?>
		<input id="wizd_chk_out" class="hlp_inpt" value="1" />
		<?php }else{
	
	while($row_check_withdraw  = mysqli_fetch_array($run_check_withdraw))
	{
	$from_account = $row_check_withdraw['from_account'];
	$wizd_amount = $row_check_withdraw['amount'];
	?>
	<div class="withdraw_input_div2" >
    <span class="withd_amnt_lebal" >Comfirm cash withdraw</span>
    <span class="withd_amnt_lebal" >From</span>
    <input type="text" id="acc_no" name="acc_no" value="<?php echo $wizd_from_acc_no ?>" disabled class="withd_acc_name_input"/>
    <span class="withd_acc_name_lebal" >Amount</span>
    <input type="number" id="withd_amt" name="withd_amt" value="<?php echo $wizd_amount ?>" disabled class="withd_amnt_input" />
    <button onclick="close_confirm_wizd();" class="comf_withdraw_btn" style="color:red;" >No</button>
    <button onclick="finish_Withdraw();" name="withdraw_cash_btn" class="comf_withdraw_btn" style="color:#90ee90;" >Yes</button>
<input id="wizd_chk_out" class="hlp_inpt" value="2" />
    </div>
	
	
<?php } } } }
////////////////////////////////////////////////////////////////////////////////////////  
if($status =="finish_Withdraw")
{
	$my_id = $_GET['my_id'];
	$f_w_acc_no = $_GET['wizd_from_acc_no'];
	$f_w_passcode = $_GET['wizd_passcode'];
	
	$get_f_w ="select * from bank_transtb where CPW_code='$f_w_passcode' AND from_account='$f_w_acc_no' ";
	$run_get_f_w  = mysqli_query($con,$get_f_w);
	while($row_get_f_w  = mysqli_fetch_array($run_get_f_w))
	{
	$amount = $row_get_f_w['amount'];
	$CPW_code = $row_get_f_w['CPW_code'];	
	$status = $row_get_f_w['status'];
	$from_account = $row_get_f_w['from_account'];
	$charges = $row_get_f_w['charges'];
	
	if($status !=='Pending'){echo"<span class='error_output'>Transaction does not exist</span>";}else{
	
	if($CPW_code !== $f_w_passcode){echo"<span class='error_output'>Check your password and try again</span>";}
	elseif($from_account !== $f_w_acc_no ){echo"<span class='error_output'>Check your account number and try again</span>";
	}elseif($from_account == $f_w_acc_no AND $CPW_code == $f_w_passcode AND $status =='Pending'){
		
	$get_user_b ="select * from banktb where my_id='$my_id' ";
	$run_get_user_b = mysqli_query($con,$get_user_b);
	while($row_get_user_b = mysqli_fetch_array($run_get_user_b)){   
	 $cur_amt = $row_get_user_b['acc_amount'];
     $final_wizd_amt = $cur_amt + $amount;
	 
	$update_w_bank = "UPDATE banktb SET acc_amount='$final_wizd_amt' WHERE my_id='$my_id' ";
	$run_update_w_bank = mysqli_query($con,$update_w_bank);	
	 
	 if($run_update_w_bank){
		 
	$get_user ="select * from crane_pay_usertb where id='$my_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$receive_acc = $row_get_user['user_phone_no'];
		$fname = $row_get_user['fname'];
		$lname = $row_get_user['lname'];
		 
	$update_f_w ="UPDATE bank_transtb SET receive_account='$receive_acc',receive_name='$fname $lname', description='Withdraw', user_type='Agent', status='Success',pick_up_date='$cur_date',pick_up_month='$cur_month',pick_up_year='$cur_year',pick_up_time=CURTIME()where CPW_code='$f_w_passcode' ";
	$run_update_f_w = mysqli_query($con,$update_f_w);
	if($run_update_f_w){
		
		$agt_comi_w = $charges * 30 /100 ;	
		
		 $get_comi ="select * from bank_agt_comitb where agt_id='$my_id' ";
         $run_get_comi = mysqli_query($con,$get_comi);
         while($row_get_comi = mysqli_fetch_array($run_get_comi)){
		
		 $cur_agt_comi = $row_get_comi['acc_amount'];
		 
         $final_agt_comi_w = $cur_agt_comi + $agt_comi_w;		 
         		  
		 $update_agt_comi_bank="UPDATE bank_agt_comitb SET acc_amount='$final_agt_comi_w',cur_date='$cur_date',cur_month='$cur_month',cur_year='$cur_year',cur_time=CURTIME() where agt_id='$my_id' ";
         $run_update_agt_comi_bank = mysqli_query($con,$update_agt_comi_bank);
		 }	
		echo"<span class='error_output' style='color:green;'>Withdrawal of $amount/= was successfully</span>";}
		 
	 }
	 
	}	
		
	}	
	}	
	}	
	}	
}
/////////////////////////////////////////////////////////////////////////////////////////////

if($status =="display_pend_trans")
{ /*
    $my_id = $_GET['my_id'];
	//$get_pend_withdraw ="select * from pending_withdrawtb where my_id='$my_id' ORDER BY id DESC";
	$get_pend_withdraw ="select * from bank_transtb where my_id='$my_id' ORDER BY id DESC";
	$run_get_pend_withdraw  = mysqli_query($con,$get_pend_withdraw);
	while($row_get_pend_withdraw  = mysqli_fetch_array($run_get_pend_withdraw))
	{
	$ref_no_pend_trans = $row_get_pend_withdraw['id'];
	$receive_account = $row_get_pend_withdraw['receive_account'];
	$receive_name = $row_get_pend_withdraw['receive_name'];
	$amount = $row_get_pend_withdraw['amount'];
	$transaction_type = $row_get_pend_withdraw['transaction_type'];
	$charges = $row_get_pend_withdraw['charges'];
	$CPW_code = $row_get_pend_withdraw['CPW_code'];	
	$DP_trans_id = $row_get_pend_withdraw['DP_trans_id'];
	$description = $row_get_pend_withdraw['description'];
	$status = $row_get_pend_withdraw['status'];
	$from_account = $row_get_pend_withdraw['from_account'];
	$from_name = $row_get_pend_withdraw['from_name'];

	$base_curr_name = $row_get_pend_withdraw['base_curr_name'];
	$base_amount = $row_get_pend_withdraw['base_amount'];	
	
	
	$cur_date = $row_get_pend_withdraw['cur_date'];
	$cur_month = $row_get_pend_withdraw['cur_month'];
	$cur_year = $row_get_pend_withdraw['cur_year'];
	$cur_time = $row_get_pend_withdraw['curtime'];

if($status == 'Pending'){
	
	if($description=='Withdraw'){

?>
<a href="transaction?trans_pend_refno=<?php echo $ref_no_pend_trans?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/wd3.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $from_account ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >Passcode</div>
<div class="from_output" ><?php echo $CPW_code; ?></div>

</div></a>

<?php	

}elseif($description=='Send'){ 
?>
<a href="transaction?trans_pend_refno=<?php echo $ref_no_pend_trans?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/out_arrow.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $receive_account ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >****</div>
<div class="from_output" ><?php echo $transaction_type; ?></div>

</div></a-->

<?php }elseif($description=='Deposit'){ ?>

<a href="transaction?trans_pend_refno=<?php echo $ref_no_pend_trans?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $receive_account ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >Trans idk</div>
<div class="from_output" ><?php echo $DP_trans_id; ?></div>

</div></a>

<?php }elseif($description=='Exchange'){ ?>

<a href="transaction?trans_pend_refno=<?php echo $ref_no_pend_trans?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/exc.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php echo $description ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" ><?php echo $base_curr_name; ?></div>
<div class="from_output" ><?php echo $base_amount; ?></div>

</div></a>

 <?php }
	}
}*/
} 

//////////////////////////////////////////////////////////////////////////////////////// 

if($status =='finish_w_save')
{
	$my_id = $_GET['my_id'];
	$f_w_acc_no = $_GET['f_w_acc_no'];
	$f_w_amt = $_GET['f_w_amt'];
	$f_w_passcode = $_GET['f_w_passcode'];
	$f_w_password = $_GET['f_w_password'];
	
	$get_user ="select * from crane_pay_usertb where id='$my_id' AND user_password='$f_w_password' ";
	$run_get_user = mysqli_query($con,$get_user);
	$check_pass = mysqli_num_rows($run_get_user);
	if($check_pass < 1 ){ echo"Check your password and try again";}else{
	
	$get_f_w ="select * from bank_transtb where CPW_code='$f_w_passcode'";
	$run_get_f_w  = mysqli_query($con,$get_f_w);
	while($row_get_f_w  = mysqli_fetch_array($run_get_f_w))
	{
	$amount = $row_get_f_w['amount'];
	$CPW_code = $row_get_f_w['CPW_code'];	
	$status = $row_get_f_w['status'];
	$from_account = $row_get_f_w['from_account'];
	
	if($status !=='Pending'){echo"<span style='color:red;'>Transaction does not exist</span>";}else{
	
	if($CPW_code !== $f_w_passcode){echo"<span style='color:red;'>Check your password and try again</span>";}
	elseif($from_account !== $f_w_acc_no ){echo"<span style='color:red;'>Check your account number and try again</span>";}else{
	
		$update_f_w ="UPDATE bank_transtb SET status='Success',pick_up_date='$cur_date',pick_up_month='$cur_month',pick_up_year='$cur_year',pick_up_time=CURTIME()where CPW_code='$f_w_passcode' ";
		$run_update_f_w = mysqli_query($con,$update_f_w);
		if($run_update_f_w){echo"<span style='color:green;'>Withdrawal transaction of $amount/= successfully</span>";}
	}
	}
	}	
	}
	
}


///////////////////////////////////////////////////////////////////////////////////// 
if($status=='finish_s_save')
{
	$my_id = $_GET['my_id'];
	$receiver_mobile_no = $_GET['receiver_mobile_no']; //here
	$send_trans_id = $_GET['send_trans_id'];
	$f_s_password = $_GET['f_s_password'];
	$post_id = $_GET['post_id'];
	
	
	$get_user ="select * from crane_pay_usertb where id='$mein' AND user_password='$f_s_password' ";
	$run_get_user = mysqli_query($con,$get_user);
	$check_pass = mysqli_num_rows($run_get_user);
	if($check_pass < 1 ){ echo"<span style='color:red;'>Check your password and try again</span>";}else{
		
	$get_f_s ="select * from bank_transtb where id='$post_id'";
	$run_get_f_s  = mysqli_query($con,$get_f_s);
	while($row_get_f_s  = mysqli_fetch_array($run_get_f_s))
	{	
	$status = $row_get_f_s['status'];
	$from_account = $row_get_f_s['from_account'];
	$new_amt = $row_get_f_s['amount'];
	
	
	if($status !=='Pending'){echo"<span style='color:red;'>Transaction does not exist</span>";}else{	
	
	
	$update_f_s ="UPDATE bank_transtb SET status='Success',DP_trans_id='$send_trans_id',pick_up_date='$cur_date',pick_up_month='$cur_month',pick_up_year='$cur_year',pick_up_time=CURTIME()where id='$post_id' ";
	$run_update_f_s = mysqli_query($con,$update_f_s);
	if($run_update_f_s){
		
		if($from_account == $receiver_mobile_no ){$receive_acc = $xinx2;}else{$receive_acc = $xinx2;} //here
		
		 $get_user_b ="select * from banktb where account_no='$receive_acc' ";
	     $run_get_user_b = mysqli_query($con,$get_user_b);
	     while($row_get_user_b = mysqli_fetch_array($run_get_user_b))
	    {   
	     $cur_amt = $row_get_user_b['acc_amount'];	
	
		
	$final_send_amt = $cur_amt+$new_amt;
	$update_deposit_bank_acc = "UPDATE banktb SET acc_amount='$final_send_amt' WHERE account_no='$receive_acc' ";
	$run_update_deposit_bank_acc = mysqli_query($con,$update_deposit_bank_acc);	
		
		
		echo"<span style='color:green;'>Transaction successfully</span>";}
		
		
	}
		
		
		//}
	
	}
	}
	}
}
//////////////////////////////////////////////////////////////////////////////////////
if($status=='finish_d_save')
{
	$my_id = $_GET['my_id'];
	$deposit_trans_id = $_GET['deposit_trans_id'];
	$f_d_password = $_GET['f_d_password'];
	$deposit_id = $_GET['deposit_id'];
	
	$get_user ="select * from crane_pay_usertb where id='$my_id' AND user_password='$f_d_password' ";
	$run_get_user = mysqli_query($con,$get_user);
	$check_pass = mysqli_num_rows($run_get_user);
	if($check_pass < 1 ){ echo"<span style='color:red;'>Check your password and try again</span>";}else{
		
	$get_d_s ="select * from bank_transtb where id='$deposit_id'";
	$run_get_d_s  = mysqli_query($con,$get_d_s);
	while($row_get_d_s  = mysqli_fetch_array($run_get_d_s))
	{	
	$status = $row_get_d_s['status'];
	$receive_account = $row_get_d_s['receive_account'];
	$amount = $row_get_d_s['amount'];
	
	if($status !=='Pending'){echo"<span style='color:red;'>Transaction does not exist</span>";}else{

	$update_d_s ="UPDATE bank_transtb SET status='Success',pick_up_date='$cur_date',pick_up_month='$cur_month',pick_up_year='$cur_year',pick_up_time=CURTIME()where id='$deposit_id' ";
	$run_update_d_s = mysqli_query($con,$update_d_s);
	if($run_update_d_s){
		
		
		 $get_user_info ="select * from banktb where account_no='$receive_account' ";
	     $run_get_user_info = mysqli_query($con,$get_user_info);
	     while($row_get_user_info = mysqli_fetch_array($run_get_user_info))
	    {   
	     $deposited_amt = $row_get_user_info['acc_amount'];	
	
		
	$final_deposit_amt = $deposited_amt+$amount;
	$update_deposit_bank_acc = "UPDATE banktb SET acc_amount='$final_deposit_amt' WHERE account_no='$receive_account' ";
	$run_update_deposit_bank_acc = mysqli_query($con,$update_deposit_bank_acc);	
		
		
		echo"<span style='color:green;'>Transaction successfully</span>";}
	}
	}		
		
	}
	}
	
}



/////////////////////////////////////////////////////////////////////////////////////// 
if($status =="save_exchange")
{
	$my_id = $_GET['my_id'];
	$cur_exc_rate = $_GET['cur_exc_rate'];
	
	$benfit_ref_no = $_GET['benfit_ref_no'];
	$base_curr_amt_output = $_GET['base_curr_amt_output'];
	$sec_curr_amt = $_GET['sec_curr_amt'];
	$from_acc = $_GET['from_acc'];
	$get_user ="select * from crane_pay_usertb where id='$my_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$receive_acc = $row_get_user['user_phone_no'];
		$fname = $row_get_user['fname'];
		$lname = $row_get_user['lname'];
		
		
$insert_exchange = "insert into bank_transtb(my_id,receive_account,receive_name,amount,exchange_rate,base_amount,base_curr_name,charges,DP_trans_id,description,status,from_name,user_country,user_city,cur_date,cur_month,cur_year,curtime)
values('$my_id','$receive_acc','$fname $lname','$sec_curr_amt','$cur_exc_rate','$base_curr_amt_output','BHD','0','$benfit_ref_no','Exchange','Pending','$from_acc','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME())";
//$run_insert_exchange = mysqli_query($con,$insert_exchange);
$run_insert_exchange = mysqli_query($con,$insert_exchange);
		
	}



}



////////////////////////////////////////////////////////////////////////////////////
if($status =='Change_pass')
{
	$my_id = $_GET['my_id'];
	$oldPass = $_GET['oldPass'];
	$newPass = $_GET['newPass'];
	
	$get_user ="select * from crane_pay_usertb where id='$my_id' AND user_password='$oldPass' ";
	$run_get_user = mysqli_query($con,$get_user);
	$Check_user = mysqli_num_rows($run_get_user);
if($Check_user >0){
	$update_changePass = "UPDATE crane_pay_usertb SET user_password='$newPass' WHERE id='$my_id' ";
	$run_update_changePass= mysqli_query($con,$update_changePass);	
	echo"<span style='color:green;'>Your password has been updated.</span>";
}else{echo"Incorrect old password";}
	
}


/////////////////////////////////////////////////////////////////////////////////

if($status =='disable_delete_acc')
{
	$my_id = $_GET['my_id'];
	$action_status = $_GET['action_status'];
	
	if($action_status =='Disable'){

	$update_dis_del_acc = "UPDATE crane_pay_usertb SET account_status='$action_status' WHERE id='$my_id' ";
	$run_update_dis_del_acc= mysqli_query($con,$update_dis_del_acc);
if($run_update_dis_del_acc){	echo $my_id; ?>
	<input id="new_msm" value="ready" class="hlp_inpt" />
<?php }else{echo"Something went wrong,account not disabled.";}

	}else{
		
	$get_user ="select * from crane_pay_usertb where id='$my_id'";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user)){
	$acc_no = $row_get_user['user_phone_no'];
	$del_acc = $acc_no.'x';
		
	$update_dis_del_acc = "UPDATE crane_pay_usertb SET account_status='$action_status' WHERE id='$my_id' ";
	$run_update_dis_del_acc= mysqli_query($con,$update_dis_del_acc);
if($run_update_dis_del_acc){ 

	$update_del_bank = "UPDATE banktb SET account_no='$del_acc' WHERE my_id='$my_id' ";
	$run_update_del_bank = mysqli_query($con,$update_del_bank);


?>
	<input id="new_msm" class="input_help" value="ready" class="hlp_inpt" />
<?php }else{echo"Something went wrong,account not disabled.";}
		
	}
}
}

	//echo"<script>window.open('login', '_self')</script>";
////////////////////////////////////////////////////////////////////////////////
if($status =='reactivate_acc' )
{
	$my_id = $_GET['my_id'];
	$update_reactivate_acc = "UPDATE crane_pay_usertb SET account_status='' WHERE id='$my_id' ";
	$run_reactivate_acc= mysqli_query($con,$update_reactivate_acc);	
}

//////////////////////////////////////////////////////////////////////////////////// 

if($status=='insert_agent')
{

	$my_id = $_GET['my_id'];
	$agt_fname = $_GET['agt_fname'];
	$agt_lname = $_GET['agt_lname'];
	$agt_cur_address = $_GET['agt_cur_address'];
	$agt_place_birth = $_GET['agt_place_birth'];
	
	$get_agt ="select * from agenttb where my_id='$my_id' ";
	$run_get_agt = mysqli_query($con,$get_agt);
	$check_agt = mysqli_num_rows($run_get_agt);
	if($check_agt >0){echo"Agent account already exists";}else{
	
	$insert_agent ="insert into agenttb(my_id,fname,lname,cur_address,place_of_birth,account_type,cur_city,cur_country,cur_date,cur_time)
	values('$my_id','$agt_fname','$agt_lname','$agt_cur_address','$agt_place_birth','Pending','$city','$country',CURDATE(), CURTIME() )";
	$run_insert_agent = mysqli_query($con,$insert_agent);	
	if($run_insert_agent)
	{
	$update_agt ="UPDATE crane_pay_usertb SET fname='$agt_fname',lname='$agt_lname' where id='$my_id'";
	$run_update_agt = mysqli_query($con,$update_agt);
	
	$update_bnk ="UPDATE banktb SET fname='$agt_fname',lname='$agt_lname' where my_id='$my_id'";
	$run_update_bnk = mysqli_query($con,$update_bnk);
	
	$insert_agt_comi ="insert into bank_agt_comitb (agt_id,acc_amount,county,city,cur_date,cur_month,cur_year,cur_time) 
	value('$my_id','0','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME() )";
	$run_agt_comi = mysqli_query($con,$insert_agt_comi);
	
	}
}
}

////////////////////////////////////////////////////////////////////////////////// 




if($status =='insert_req_dp')
{
	$my_id = $_GET['my_id'];
	$agt_di = $_GET['agt_di'];
	$acc_agt = $_GET['acc_agt'];
	$request_amount = $_GET['request_amount'];
	$agt_capt = $_GET['agt_capt'];
	$pay_method = $_GET['pay_method'];
	
	
	
	$check_bank_info ="select * from banktb where my_id='$my_id' ";
	$run_check_bank_info = mysqli_query($con,$check_bank_info);
	while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
	{
	$receive_acc = $row_check_bank_info['account_no'];

		
	$check_agt_info ="select * from agent_transtb where agent_acc='$acc_agt' ";
	$run_check_agt_info  = mysqli_query($con,$check_agt_info);	
	$check_check_agt_info  = mysqli_num_rows($run_check_agt_info);	
	if($check_check_agt_info >0){

	$update_agt_tr ="UPDATE agent_transtb SET my_id='$my_id',agt_id='$agt_di',receive_acc='$receive_acc',receive_amt='$request_amount',user_country='$country',user_city='$city',cur_date='$cur_date',cur_month='$cur_month',cur_year='$cur_year',cur_time=CURTIME() where agent_acc='$acc_agt'";
	$run_update_agt_tr = mysqli_query($con,$update_agt_tr);
	if($run_update_agt_tr){	
	$update_chk_agt_online ="UPDATE agent_chk_onlinetb SET status='ready' where my_id='$my_id'";
	$run_update_chk_agt = mysqli_query($con,$update_chk_agt_online);	
	}	
	}else{	
		
	$insert_dp_req="insert into agent_transtb(my_id,agt_id,receive_acc,receive_amt,agent_acc,user_country,user_city,cur_date,cur_month,cur_year,cur_time )
	values('$my_id','$agt_di','$receive_acc','$request_amount','$acc_agt','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME() )";
    $run_insert_dp_req = mysqli_query($con,$insert_dp_req);	
	if($run_insert_dp_req){
		
	$update_chk_agt_online ="UPDATE agent_chk_onlinetb SET status='ready' where my_id='$my_id'";
	$run_update_chk_agt = mysqli_query($con,$update_chk_agt_online);
	}	
	}
	//}
}
}
//////////////////////////////////////////////////////////////////////////////// 
if($status=='display_pend_dp_req')
{
	$my_id = $_GET['my_id'];
    $get_req_dp ="select * from agent_transtb where my_id='$my_id' ";
    $run_req_dp = mysqli_query($con,$get_req_dp);
    while($row_req_dp = mysqli_fetch_array($run_req_dp))
	{
	 $ref_no_req_dp = $row_req_dp['id'];
	// $pay_method = $row_req_dp['pay_method'];
     $amount = $row_req_dp['receive_amt'];
	 $acc_from = $row_req_dp['agent_acc'];
     $cur_date = $row_req_dp['cur_date'];
     $cur_month = $row_req_dp['cur_month'];
     $cur_year = $row_req_dp['cur_year'];
     $cur_time = $row_req_dp['cur_time'];
	 //$description = $row_req_dp['description'];
	 $status = $row_req_dp['status'];
	 
	if($status =='Pending'){
	
	?>
<a href="transaction?req_dp_pend_refno=<?php echo $ref_no_req_dp?>"><div class="single_trans_div" style="background:#FFC6F3;" >
<div class="icon_img_div"><img src="main_icon/dp.png" class="rec_icon_img" /></div>
<div class="amt_lebal" ><?php //echo $pay_method ?></div>
<div class="amt_output" ><?php echo $amount; ?> /=</div>
<div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
<span class="status" style="background:#fff;color:red;"><?php //echo $description; ?></span>
<div class="amt_4m_lebal" style="color:#3692FA;" >Agent</div>
<div class="from_output" ><?php echo $acc_from; ?></div>

</div></a>	
<?php
}else{
		?>
	<a href="transaction?req_dp_pend_refno=<?php echo $ref_no_req_dp?>"><div class="single_trans_div" >
    <div class="icon_img_div"><img src="main_icon/in_arrow.png" class="rec_icon_img" /></div>
    <div class="amt_lebal" ><?php //echo $pay_method; ?></div>
   <div class="amt_output" ><?php echo $amount; ?> /=</div>
   <div class="date" ><?php echo"$cur_date $cur_month $cur_year - $cur_time"; ?></div>
   <span class="status" ><?php echo $status; ?></span>
   <div class="amt_4m_lebal" style="color:green;" >Agent</div>
   <div class="from_output" ><?php echo $acc_from; ?></div>
   </div></a>


<?php
}
}
}

/////////////////////////////////////////////////////////////////////////////// 
if($status =='checking_new_dp_req')
{
	$my_id = $_GET['my_id'];
	$get_agt_ch ="select * from agent_chk_onlinetb where status='ready' AND agent_id='$my_id' ";	
    $run_get_agt_ch = mysqli_query($con,$get_agt_ch);
	$check_get_agt_ch = mysqli_num_rows($run_get_agt_ch);
	if($check_get_agt_ch >0){
	?><input id="req_ready" value="ready" class="hlp_inpt" /><?php
}
}
////////////////////////////////////////////////////////////////////////////// 
if($status =="disp_pending_dp_req")
{
	$my_id = $_GET['my_id'];
	
    $get_user ="select * from crane_pay_usertb where id='$my_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
	$my_acc = $row_get_user['user_phone_no'];
	
    $get_req_dp ="select * from agent_transtb where agent_acc='$my_acc' ";
    $run_req_dp = mysqli_query($con,$get_req_dp);
    while($row_req_dp = mysqli_fetch_array($run_req_dp))
	{
	 $ref_no_req_dp = $row_req_dp['id'];
	 $user_id = $row_req_dp['my_id'];
     $amount = $row_req_dp['receive_amt'];
	 $acc_from = $row_req_dp['agent_acc'];
     $cur_date = $row_req_dp['cur_date'];
     $cur_month = $row_req_dp['cur_month'];
     $cur_year = $row_req_dp['cur_year'];
     $cur_time = $row_req_dp['cur_time'];

   $get_user ="select * from crane_pay_usertb where id='$user_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
	$user_fname = $row_get_user['fname'];

	 ?>
<div class="single_req_dp_div" >
<span class="date_single_req_dp" ><?php echo $cur_date.' '.$cur_month.' '.$cur_year.' - '.$cur_time;   ?></span>
<span class="sub_single_req_dp" ><?php echo $user_fname ?> requests <?php echo $amount ?>/=</span>
<button onclick="trans_compeleted2();" class="del_dp_req_btn" >Decline</button>
<button onclick="agt_accept_trans();" class="accept_dp_req_btn" >Accept</button>
</div> 
	 
	 <?php
	 
}
}
}
}

///////////////////////////////////////////////////////////////////////////// 
if($status =='insert_check_agt_online')
{
	$my_id = $_GET['my_id'];
	$agt_di = $_GET['agt_di'];
	$check_agt_sms = 'Incoming';
	
	$get_agt_chk ="select * from agent_chk_onlinetb where status='busy' AND agent_id='$agt_di' ";	
    $run_get_agt_chk = mysqli_query($con,$get_agt_chk);
    $check_get_agt_chk = mysqli_num_rows($run_get_agt_chk);
	if($check_get_agt_chk >0){ ?><input id="busy_o_not" value="busy" class="hlp_inpt" /><?php }else{
		?><input id="busy_o_not" value="free" class="hlp_inpt" /><?php
	
    $get_agt_chk2 ="select * from agent_chk_onlinetb where agent_id='$agt_di' ";	
    $run_get_agt_chk2 = mysqli_query($con,$get_agt_chk2);
    $check_get_agt_chk2 = mysqli_num_rows($run_get_agt_chk2);

if($check_get_agt_chk2 <1){
	$insert_chk_agt="insert into agent_chk_onlinetb(my_id,agent_id,chk_sms,status) values('$my_id','$agt_di','$check_agt_sms','busy')";
    $run_insert_chk_agt = mysqli_query($con,$insert_chk_agt);		
	
}else{
	$update_chk_agt_online ="UPDATE agent_chk_onlinetb SET chk_sms='Incoming',my_id='$my_id',status='busy' where agent_id='$agt_di' ";
	$run_update_chk_agt = mysqli_query($con,$update_chk_agt_online);
}			
}
}

//////////////////////////////////////////////////////////////////////////// 

if($status =='clear_check_agt_online')
{
	$my_id = $_GET['my_id'];
	$agt_di = $_GET['agt_di'];
	$update_chk_agt_online ="UPDATE agent_chk_onlinetb SET my_id='',chk_sms='',status='free',agt_permision='' where my_id='$my_id' OR agent_id='$my_id' ";
	$run_update_chk_agt = mysqli_query($con,$update_chk_agt_online);

	$update_agt_trans ="UPDATE agent_transtb SET my_id='',receive_acc='',receive_amt='',m_m_transid='',status='' where my_id='$my_id' OR agt_id='$my_id'";
	$run_update_agt_trans = mysqli_query($con,$update_agt_trans);
?><input id="clear_dat" value="clear_dat" class="hlp_inpt" /><?php


	
}

//////////////////////////////////////////////////////////////////////////// save_sent_money 
if($status =='disp_notif_req')
{
	$my_id = $_GET['my_id'];
    $get_user ="select * from agent_chk_onlinetb where agent_id='$my_id' AND chk_sms='Incoming' ";
	$run_get_user = mysqli_query($con,$get_user);
	$check_notif = mysqli_num_rows($run_get_user);
	if($check_notif >0){?>
  <input id="incoming_notif" value="<?php echo"1"; ?>" class="hlp_inpt" />
  
	
	<?php

}
}


//////////////////////////////////////////////////////////////////////////////////// 
if($status=='yes_agt_online')
{
	$my_id = $_GET['my_id'];
	
	$get_agt_chk ="select * from agent_chk_onlinetb where status='free' AND agent_id='$my_id' ";	
    $run_get_agt_chk = mysqli_query($con,$get_agt_chk);
    $check_get_agt_chk = mysqli_num_rows($run_get_agt_chk);
	if($check_get_agt_chk >0){ ?><input id="clear_status" value="free" class="hlp_inpt" /><?php }else{
	?><input id="clear_status" value="not_free" class="hlp_inpt" /><?php 
	$update_agt_online="UPDATE agent_chk_onlinetb SET chk_sms='Online' where agent_id='$my_id' AND chk_sms='Incoming' ";
    $run_insert_chk_agt = mysqli_query($con,$update_agt_online);	
}
}
//////////////////////////////////////////////////////////////////////////////
if($status=='disp_notif_resp')
{
	$my_id = $_GET['my_id'];
    $get_user ="select * from agent_chk_onlinetb where my_id='$my_id' AND chk_sms='Online' ";
	$run_get_user = mysqli_query($con,$get_user);
	$check_notif = mysqli_num_rows($run_get_user);
	if($check_notif >0){?>
  <input id="resp_notif" value="<?php echo"2"; ?>" classk="acc_agt_help" class="hlp_inpt" />
  
	
	<?php

}	
}
/////////////////////////////////////////////////////////////////////////////////////

if($status=='agt_accept_trans')
{
	$my_id = $_GET['my_id'];
	$update_agt_accept="UPDATE agent_chk_onlinetb SET agt_permision='accept_now' where agent_id='$my_id' ";
    $run_update_agt_accept = mysqli_query($con,$update_agt_accept);
}

////////////////////////////////////////////////////////////////////////////////////// 

if($status =='check_agt_accept_trans')
{
	$my_id = $_GET['my_id'];
    $get_agt_permis ="select * from agent_chk_onlinetb where my_id='$my_id' AND agt_permision='accept_now' ";
	$run_get_agt_permis= mysqli_query($con,$get_agt_permis);
	$check_get_agt_permis= mysqli_num_rows($run_get_agt_permis);
	if($check_get_agt_permis >0){ ?>
  <input id="agt_accept_now" value="accept_now" class="hlp_inpt" />
	
	<?php	}
}


////////////////////////////////////////////////////////////////////////////////////// 
if($status =='disp_agt_details')
{ 
	$my_id = $_GET['my_id'];
	$get_req_dp ="select * from agent_transtb where my_id='$my_id' ";
    $run_req_dp = mysqli_query($con,$get_req_dp);
    while($row_req_dp = mysqli_fetch_array($run_req_dp))
	{
     $amount = $row_req_dp['receive_amt'];
	 $receive_acc= $row_req_dp['receive_acc'];
	 $agt_acc= $row_req_dp['agent_acc'];
	 
	
	$get_user ="select * from crane_pay_usertb where user_phone_no='$agt_acc' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$agent_acc = $row_get_user['user_phone_no'];
		$fname = $row_get_user['fname'];
		$lname = $row_get_user['lname'];
		
	$get_user ="select * from crane_pay_usertb where id='$my_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
		$user_fname = $row_get_user['fname'];
		$user_lname = $row_get_user['lname'];	

	?>
 <span id="agent_acc" class="agt_sent_details" ><?php echo $agent_acc;  ?></span>
 <span id="agent_name" class="agt_sent_details" ><?php echo $fname." ".$lname; ?></span>
 <span id="request_amt" class="agt_sent_details" ><?php echo $amount; ?></span>
 <span id="receive_acc" class="hlp_inpt" ><?php echo $receive_acc;  ?></span>
 <span id="receive_name" class="hlp_inpt"  ><?php echo $user_fname." ".$user_lname; ?></span>

<?php	
		
	}		
}
}
}
///////////////////////////////////////////////////////////////////////////////////// 

if($status=="Comfirm_user_sent_trans")
{
	
	$my_id = $_GET['my_id'];
	$Comfirm_user_trans = $_GET['Comfirm_user_trans'];
	$receive_acc = $_GET['receive_acc'];
	$agent_name = $_GET['agent_name'];
	$agent_acc = $_GET['agent_acc'];
	$receive_name = $_GET['receive_name'];
	$request_amt = $_GET['request_amt'];
	$agt_comi = $_GET['agt_comi'];
	
	
	$insert_send_money ="insert into bank_transtb(my_id,receive_account,receive_name,amount,transaction_type,charges,DP_trans_id,description,status,from_account,from_name,user_type,user_country,user_city,
	cur_date,cur_month,cur_year,curtime)
	values ('$my_id','$receive_acc','$receive_name','$request_amt','CrinePay','0','$Comfirm_user_trans','Deposit','Pending','$agent_acc','$agent_name','Agent','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME() )";
	$run_insert_send_money = mysqli_query($con,$insert_send_money);
	
		$check_bank_info ="select * from banktb where account_no='$agent_acc' ";
	    $run_check_bank_info = mysqli_query($con,$check_bank_info);
	    while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
	    {
	    $total_bank_amount = $row_check_bank_info['acc_amount'];
		$agt_id = $row_check_bank_info['my_id'];
	
		$final_sent_amt = $total_bank_amount-$request_amt;
		$update_bank = "UPDATE banktb SET acc_amount='$final_sent_amt' WHERE account_no='$agent_acc' ";
		$run_update = mysqli_query($con,$update_bank);
		if($run_update)
		{
		 $get_comi ="select * from bank_agt_comitb where agt_id='$agt_id' ";
         $run_get_comi = mysqli_query($con,$get_comi);
         while($row_get_comi = mysqli_fetch_array($run_get_comi)){
		
		 $cur_agt_comi = $row_get_comi['acc_amount'];
		 
         $final_agt_comi = $cur_agt_comi + $agt_comi;		 
         		  
		 $update_agt_comi_bank="UPDATE bank_agt_comitb SET acc_amount='$final_agt_comi',cur_date='$cur_date',cur_month='$cur_month',cur_year='$cur_year',cur_time=CURTIME() where agt_id='$agt_id' ";
         $run_update_agt_comi_bank = mysqli_query($con,$update_agt_comi_bank);
		 
		}
		}
		}		
	
	
	$update_user_trans_comf ="UPDATE agent_transtb SET m_m_transid='$Comfirm_user_trans',status='user_confirm' where my_id='$my_id'";
	$run_update_user_trans_comf  = mysqli_query($con,$update_user_trans_comf);
	if($run_update_user_trans_comf)
	{
	$update_user_confrim="UPDATE agent_chk_onlinetb SET trans_id='$Comfirm_user_trans', agt_permision='user_confirm' where my_id='$my_id' ";
    $run_update_user_confirm = mysqli_query($con,$update_user_confrim);

	}
}
//////////////////////////////////////////////////////////////////////////////////////// 
if($status =='user_confirm_trans')
{
	$my_id = $_GET['my_id'];
    $get_agt_permis ="select * from agent_chk_onlinetb where agent_id='$my_id'";// AND agt_permision='user_confirm' ";
	$run_get_agt_permis= mysqli_query($con,$get_agt_permis);
	$check_get_agt_permis= mysqli_num_rows($run_get_agt_permis);
	if($check_get_agt_permis >0){ 
	while($row_get_agt_permis = mysqli_fetch_array($run_get_agt_permis))
	{
	$get_infor = $row_get_agt_permis['agt_permision'];
	?>

  <input id="user_confirm" value="<?php echo $get_infor; ?>" class="hlp_inpt" />
	
	<?php }	}
}


///////////////////////////////////////////////////////////////////////////////////////////// 

if($status=='approved_agt_transaction')
{
	$confm_id;
	$my_id = $_GET['my_id'];
	$confm_id = $_GET['cur_trans_id'];
		
    $get_user ="select * from crane_pay_usertb where id='$my_id' ";
	$run_get_user = mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
	$my_acc = $row_get_user['user_phone_no'];
  	
	$get_agt_chk ="select * from agent_chk_onlinetb where agent_id='$my_id' ";	
    $run_get_agt_chk = mysqli_query($con,$get_agt_chk);
    while($row_get_agt = mysqli_fetch_array($run_get_agt_chk)){
	/*if($check_get_agt_chk >0){ ?><input id="clear_status2" value="free" class="hlp_inpt" /><?php }else{*/
	$dp_trans_id = $row_get_agt['trans_id'];

	$get_d_s ="select * from bank_transtb where from_account='$my_acc' AND DP_trans_id='$dp_trans_id' OR id='$confm_id' AND status='Pending' "; 
	$run_get_d_s  = mysqli_query($con,$get_d_s);
	while($row_get_d_s  = mysqli_fetch_array($run_get_d_s))
	{
    $trans_id = $row_get_d_s['id'];		
	$status = $row_get_d_s['status'];
	$receive_account = $row_get_d_s['receive_account'];
	$amount = $row_get_d_s['amount'];
	
	if($status !=='Pending'){echo"<span style='color:red;'>Transaction does not exist</span>";}else{


	$update_user_trans ="UPDATE bank_transtb SET status='Success',pick_up_date='$cur_date',pick_up_month='$cur_month',pick_up_year='$cur_year',pick_up_time=CURTIME() where id='$trans_id' ";
	$run_update_user_trans = mysqli_query($con,$update_user_trans);
	if($run_update_user_trans){
		
    $get_user_info ="select * from banktb where account_no='$receive_account' ";
	$run_get_user_info = mysqli_query($con,$get_user_info);
	while($row_get_user_info = mysqli_fetch_array($run_get_user_info))
	{   
    $cur_bnk_amt = $row_get_user_info['acc_amount'];	
	
		
	$final_deposit_amt = $cur_bnk_amt+$amount;
	$update_deposit_bank_acc = "UPDATE banktb SET acc_amount='$final_deposit_amt' WHERE account_no='$receive_account' ";
	$run_update_deposit_bank_acc = mysqli_query($con,$update_deposit_bank_acc);	
		
	if($run_update_deposit_bank_acc)
	{
		
	//$update_agt_comi_bank="UPDATE bank_agt_comitb SET acc_amount='20' where agt_id='$my_id' ";
    //$run_update_agt_comi_bank = mysqli_query($con,$update_agt_comi_bank);	
		
		
		
	$update_agt_accept="UPDATE agent_chk_onlinetb SET agt_permision='approved' where agent_id='$my_id' ";
    $run_update_agt_accept = mysqli_query($con,$update_agt_accept);
	}			
	echo"<span style='color:green;'>Transaction successfully</span>";}
	}
	
}
}
}
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 

if($status =="check_agt_approv_trans")
{
	$my_id = $_GET['my_id'];
    $get_agt_permis ="select * from agent_chk_onlinetb where my_id='$my_id' AND agt_permision='approved' ";
	$run_get_agt_permis= mysqli_query($con,$get_agt_permis);
	$check_get_agt_permis= mysqli_num_rows($run_get_agt_permis);
	if($check_get_agt_permis >0){ ?>
  <input id="approved" value="approved" class="hlp_inpt" />
	
	<?php	}
}


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
if($status =='cal_agt_comi_disp')
{
	$my_id = $_GET['my_id'];
	$get_agt_comi ="select * from bank_agt_comitb where agt_id='$my_id' ";
	$run_get_agt_comi = mysqli_query($con,$get_agt_comi);
	while($row_get_agt_comi = mysqli_fetch_array($run_get_agt_comi))
	{
		$comi_amt = $row_get_agt_comi['acc_amount'];
		echo $comi_amt;
	} ?>
	<input id="agt_earns" value="<?php echo $comi_amt; ?>" style="display:none;" />
	<?php
}

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =='trans_compeleted')
{
	
	$my_id = $_GET['my_id'];
	$update_chk_agt_online ="UPDATE agent_chk_onlinetb SET my_id='',chk_sms='',status='free',agt_permision='' where my_id='$my_id' OR agent_id='$my_id' ";
	$run_update_chk_agt = mysqli_query($con,$update_chk_agt_online);

	$update_agt_trans ="UPDATE agent_transtb SET my_id='',receive_acc='',receive_amt='',m_m_transid='',status='' where my_id='$my_id' OR agt_id='$my_id'";
	$run_update_agt_trans = mysqli_query($con,$update_agt_trans);
	 ?>
  <input id="reloadp" value="reloadp" class="hlp_inpt" />
	
	<?php
}	
	
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =='amt_transfer_now')
{
  $my_id = $_GET['my_id'];
  $amt_transf_input = $_GET['amt_transf_input'];
  
   $get_earns ="select * from bank_agt_comitb where agt_id='$my_id' ";
   $run_get_earns = mysqli_query($con,$get_earns);
   while($row_get_earns = mysqli_fetch_array($run_get_earns)){
		
	$cur_earns = $row_get_earns['acc_amount'];
	$final_earns = $cur_earns - $amt_transf_input;		 
         		  
	$update_agt_earns="UPDATE bank_agt_comitb SET acc_amount='$final_earns',cur_date='$cur_date',cur_month='$cur_month',cur_year='$cur_year',cur_time=CURTIME() where agt_id='$my_id' ";
    $run_update_earn = mysqli_query($con,$update_agt_earns);
	if($run_update_earn){	 

  $check_bank_info ="select * from banktb where my_id='$my_id' ";
  $run_check_bank_info = mysqli_query($con,$check_bank_info);
  while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
  {
  $total_bank_amount = $row_check_bank_info['acc_amount'];
		
  $final_agt_comi = $total_bank_amount + $amt_transf_input;

	$update_agt_earn = "UPDATE banktb SET acc_amount='$final_agt_comi' WHERE my_id='$my_id' ";
	$run_update_agt_earn = mysqli_query($con,$update_agt_earn);	
	
	if($run_update_agt_earn){echo"Your earns have been transfered successfully.";}
	
  }	  
  }else{echo"Something went wrong";}
  }
}	
/////////////////////////////////////////////////////////////////////////////////////////////////// 

if($status=='complete_recharge')
{
	$my_id  = $_GET['my_id'];
    $recharging_user_id = $_GET['recharging_user_id'];
    $cb_coin_amt = $_GET['cb_coin_amt'];
    $total_rech_amt = $_GET['total_rech_amt'];
    $recharge_pas = $_GET['recharge_pas']; 
	
	
	$get_user_login ="select * from crane_pay_usertb where linked_site='$recharging_user_id' AND user_password='$recharge_pas'  ";
	$run_get_user_login = mysqli_query($con,$get_user_login);
	$check_login = mysqli_num_rows($run_get_user_login);
	if($check_login < 1 ){
		echo"Not successfully check password."; ?>
		<input id="check_comfirm_recharge" class="helpig_div" value="1" />
		<?php }else{
	
		
	$check_bank_info ="select * from banktb where my_id='$my_id' ";
    $run_check_bank_info = mysqli_query($con,$check_bank_info);
    while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
    {
    $total_bank_amount = $row_check_bank_info['acc_amount'];
	if($total_bank_amount <1){echo"Insufficient account balance.";?>
		<input id="check_comfirm_recharge" class="helpig_div" value="1" />
		<?php }else{ ?> <input id="check_comfirm_recharge" class="helpig_div" value="2" /> <?php
		
    $final_agt_comi = $total_bank_amount - $cb_coin_amt * 100;
	
	$update_bnk = "UPDATE banktb SET acc_amount='$final_agt_comi' WHERE my_id='$my_id' ";
	$run_update_bnk = mysqli_query($con,$update_bnk);

 
	
	$con = mysqli_connect('localhost','root','2019khalaf','cb_awarddb');
     if(! $con){echo"You have not connected to the database.";}
     else{
	$get_user ="select * from cb_banktb where my_id='$recharging_user_id' ";
    $run_get_user= mysqli_query($con,$get_user);
	while($row_get_user = mysqli_fetch_array($run_get_user))
	{
	$cur_cb_coin_amt = $row_get_user['cb_coin'];
    $new_cb_coin = $cur_cb_coin_amt+$cb_coin_amt;	 
		 
   	$update_cb_bank ="UPDATE cb_banktb SET cb_coin='$new_cb_coin' where my_id='$recharging_user_id' ";
	$run_bank_update = mysqli_query($con,$update_cb_bank);	
	
	if($run_update_bnk){
	
		echo"Your earns have been transfered successfully.";}
	}
	}	
	}
}
}
}


//////////////////////////////////////////////////////////////////////////////////////////////////

if($status=='insert_savings')
{
	$my_id = $_GET['my_id'];
    $save_amt = $_GET['save_amt'];
	$est_reward = $_GET['est_reward'];
    $no_month = $_GET['no_month']; 
    $cur_date = $_GET['cur_date'];  
    $cur_month = $_GET['cur_month'];  
    $cur_year = $_GET['cur_year'];
    $end_date = $_GET['end_date'];
    $end_month = $_GET['end_month'];
    $end_year = $_GET['end_year'];  
   // if($end_date <10){ $end_date='0'.$end_date;}else{$end_date=$end_date;}	
	
	$check_bank_info ="select * from banktb where my_id='$my_id' ";
    $run_check_bank_info = mysqli_query($con,$check_bank_info);
    while($row_check_bank_info = mysqli_fetch_array($run_check_bank_info))
    {
    $total_bank_amount = $row_check_bank_info['acc_amount'];
	
	if($save_amt > $total_bank_amount){ ?> <input id="bal_small_out" value="Insufficient" />  <?php }else{
		
		$avilb_amount= $total_bank_amount - $save_amt;
		
		$update_save_bnk = "UPDATE banktb SET acc_amount='$avilb_amount' WHERE my_id='$my_id'";
		$run_update_save_bnk = mysqli_query($con,$update_save_bnk);
		
	if( !$run_update_save_bnk){ ?> <input id="bal_small_out" value="support" />  <?php }else{
	
   $insert_savings ="insert into saving_banktb (my_id,saved_amount,save_duration,est_earnings,trans_status,country,city,cur_date,cur_month,cur_year,save_end_date,save_end_month,save_end_year,cur_time )
   values('$my_id','$save_amt','$no_month','$est_reward','Active','$country','$city','$cur_date','$cur_month','$cur_year','$end_date','$end_month','$end_year',CURTIME() )";
   $run_insert_savings = mysqli_query($con,$insert_savings);
echo"Transaction successfully";
?> <input id="bal_small_out" value="Successfully" style="display:none;" />  <?php
	}
}
}
}

//////////////////////////////////////////////////////////////////////////////////////////////////////
if($status =='display_savings'){ 
	$my_id = $_GET['my_id'];
	$get_saving ="select * from saving_banktb where my_id='$my_id' ";
    $run_get_saving = mysqli_query($con,$get_saving);
    while($row_get_saving = mysqli_fetch_array($run_get_saving))
    {
	$trans_no = $row_get_saving['id'];
	$trans_status = $row_get_saving['trans_status']; 
    $saved_amount = $row_get_saving['saved_amount'];
	$save_duration = $row_get_saving['save_duration'];
	$est_earnings = $row_get_saving['est_earnings'];
	$cur_date = $row_get_saving['cur_date'];
	$cur_month = $row_get_saving['cur_month'];
	$cur_year = $row_get_saving['cur_year'];
	$save_end_date = $row_get_saving['save_end_date'];
	$save_end_month = $row_get_saving['save_end_month'];
	$save_end_year = $row_get_saving['save_end_year'];
	
	
	//$kur_date = $cur_date; //$row_get_saving['cur_date'];
	//$kur_month = $cur_month; // $row_get_saving['cur_month'];
	//$kur_year = $cur_year;// $row_get_saving['cur_year'];
	
	
	$kur_date = date("d");
   $kur_month = date("m");
   $kur_year = date("Y");
	
	
	?>
	<?php if($kur_date > $save_end_date && $kur_month >= $save_end_month && $kur_year >= $save_end_year ){

		$update_ready_save_bnk = "UPDATE saving_banktb SET trans_status='Ready' WHERE my_id='$my_id' AND id='$trans_no' AND trans_status='Active' ";
		$run_update_ready_save_bnk = mysqli_query($con,$update_ready_save_bnk);

		?>

<input id="pay_out" value="<?php echo $trans_no; ?>" style="display:none;" />
<?php }?>
	
	<?php
	
	if($trans_status =='Ready'){
	?>
	<div class="sub_container2" >
<span class="saving_title" >Status Active</span>
<div class="saved_div" >

<div class="saved_div_left" >
<span class="saved_amt_lebal" >Amount UGX</span>
<span class="saved_amt_output" ><?php echo $saved_amount; ?></span>
</div>

<div class="saved_div_right" >
<span class="saved_amt_lebal" >Month(s)</span>
<span class="saved_amt_output" ><?php echo $save_duration; ?></span>
</div>

</div>




<div class="saved_date_div" >
<span class="saved_st_date" ><?php echo"$cur_date-$cur_month-$cur_year"; ?></span>
<span class="saved_end_date" ><?php echo"$save_end_date-$save_end_month-$save_end_year"; ?></span>
</div>


<span class="saving_title" >Rewards</span>
<div class="saved_div" >

<div class="saved_div_left" >
<span class="saved_amt_lebal" >Earnings UGX</span>
<span class="saved_amt_output" ><?php echo $est_earnings; ?></span>
</div>

<div class="saved_div_right" >
<span class="saved_amt_lebal" >Total UGX</span>
<span class="saved_amt_output" >
<?php
$total_save_amt = $saved_amount + $est_earnings;
echo $total_save_amt;
?>
</span>

</div>

</div>

<button id="withdraw_btn" name="<?php echo $trans_no; ?>" onClick="request_payout(this.name);" class="withdraw_btn" >Request payout</button>

<span class="saved_trans_lebal" >Trans no.<?php echo $trans_no;?></span>	
	
	</div>
<?php	
}elseif($trans_status =='Active'){ ?>

	<div class="sub_container2" >
<span class="saving_title" >Status Active</span>
<div class="saved_div" >

<div class="saved_div_left" >
<span class="saved_amt_lebal" >Amount UGX</span>
<span class="saved_amt_output" ><?php echo $saved_amount; ?></span>
</div>

<div class="saved_div_right" >
<span class="saved_amt_lebal" >Month(s)</span>
<span class="saved_amt_output" ><?php echo $save_duration; ?></span>
</div>

</div>




<div class="saved_date_div" >
<span class="saved_st_date" ><?php echo"$cur_date-$cur_month-$cur_year";  ?></span>
<span class="saved_end_date" ><?php echo"$save_end_date-$save_end_month-$save_end_year"; ?></span>
</div>


<span class="saving_title" >Rewards</span>
<div class="saved_div" >

<div class="saved_div_left" >
<span class="saved_amt_lebal" >Earnings UGX</span>
<span class="saved_amt_output" ><?php echo $est_earnings; ?></span>
</div>

<div class="saved_div_right" >
<span class="saved_amt_lebal" >Total UGX</span>
<span class="saved_amt_output" >
<?php
$total_save_amt = $saved_amount + $est_earnings;
echo $total_save_amt;
?>
</span>

</div>

</div>

<button class="withdraw_btn2">Request payout</button>

<span class="saved_trans_lebal" >Trans no.<?php echo $trans_no;?></span>	
	
	</div>

<?php	
}
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////

if($status =='request_payout')
{
	$my_id = $_GET['my_id'];
	$trans_no = $_GET['trans_no'];
	
	
	$update_payout_save_bnk = "UPDATE saving_banktb SET trans_status='Done' WHERE my_id='$my_id' AND id='$trans_no' AND trans_status='Ready' ";
	$run_update_ready_save_bnk = mysqli_query($con,$update_payout_save_bnk);
	
	if($run_update_ready_save_bnk){
	
	$get_saving_pay ="select * from saving_banktb where my_id='$my_id' AND id='$trans_no' ";
    $run_get_saving_pay = mysqli_query($con,$get_saving_pay);
    while($row_get_saving_pay = mysqli_fetch_array($run_get_saving_pay))
    {
	$trans_no = $row_get_saving_pay['id'];
	$trans_status = $row_get_saving_pay['trans_status']; 
    $saved_amount = $row_get_saving_pay['saved_amount'];
	$est_earnings = $row_get_saving_pay['est_earnings'];
	$payout_amt = $saved_amount + $est_earnings;
	
	//echo $payout_amt;
	
	$get_bank_amt ="select * from banktb where my_id='$my_id' ";
    $run_get_bank_amt= mysqli_query($con,$get_bank_amt);
    while($row_get_bank_amt = mysqli_fetch_array($run_get_bank_amt))
    {
    $total_bank_amount = $row_get_bank_amt['acc_amount'];
	$account_no = $row_get_bank_amt['account_no'];
	$acc_fname = $row_get_bank_amt['fname'];
	$acc_lname = $row_get_bank_amt['lname'];
	
	$final_cur_amt = $total_bank_amount + $payout_amt;
	
    $insert_saving_trans ="insert into bank_transtb(my_id,receive_account,receive_name,amount,transaction_type,charges,DP_trans_id,description,status,available_balance,user_country,user_city,cur_date,cur_month,cur_year,curtime)
    values ('$my_id','$account_no','$acc_fname $acc_lname','$payout_amt','Savings','0','$trans_no','Save','Success','$final_cur_amt','$country','$city','$cur_date','$cur_month','$cur_year',CURTIME() )";
	$run_insert_saving_trans = mysqli_query($con,$insert_saving_trans);
	
	
	
	
	
		$update_main_bnk = "UPDATE banktb SET acc_amount='$final_cur_amt' WHERE my_id='$my_id'";
		$run_update_main_bnk = mysqli_query($con,$update_main_bnk);
		
		if($run_update_main_bnk){echo"<input id='payout_error' value='done' />";}else{echo"Something went wrong";}
		
		//echo $final_cur_amt;
}
}
}
}