<?php
	require_once "global.php";
	require_once 'class/Deposit.php';
	
	$deposit = new Deposit();
	
	// recount global evtrade
	/* $db_total = $db->fetch_one("SELECT SUM(trading_account_pam_amount) AS total FROM user");
	$total = empty($db_total['total']) ? 0 : $db_total['total'];
	$amount_added = round(0.2 * $total, 2);
	$db->query("UPDATE settings SET `value` = '".$db->clean($amount_added)."' WHERE sid = 41"); */
	
	// recount bonus member
	/* $db_user = $db->fetch_all("SELECT * FROM user");
	if (sizeof($db_user) > 0){
		foreach ($db_user as $dbu){
			// binary point tree
			if (!empty($dbu['parent_tree'])){
				$user->setUplineTotalTopup($dbu['trading_account_pam_amount'], $dbu['userid']);
			}
		}
	} */
	
	$data = $db->fetch_all("SELECT * FROM deposit WHERE status = 2");
	if (sizeof($data) > 0){
		foreach ($data as $d){
			$member_db = $db->fetch_one("SELECT parentid, deposit_status, level, email, firstname, parent_tree, trading_account_pam_amount FROM user WHERE userid = ".$db->clean($d['userid']));
			
			/* if ($d['type'] == 'topup'){
				// bonus topup referral 4 times more
				$bonus_amount = $bonussetting['bonus_topup'] / 100 * $d['amount'];
				for ($z = 1; $z <= 4; $z++){
					$inserts = array();
					$inserts['transactionnumber'] = $d['transaction_number'];
					$inserts['transaction_type'] = 'bonus-topup';
					$inserts['notes'] = 'Bonus Topup '.($z + 1).' - Member : '.$member_db['email'].' ('.$member_db['firstname'].')';
					$inserts['transactiondate'] = '\''.$d['approved_date'].'\' + interval '.$z.' month';
					$inserts['nominal'] = $bonus_amount;
					$inserts['userid'] = $member_db['parentid'];

					$db->insert("temp_history", $inserts);
					unset($inserts);
				}
			} */
			
			/* bonus point EVTrade every day */
			if ($d['type'] == 'registration'){
				$db->query("UPDATE user SET activated_date = '".$db->clean(strtotime($d['approved_date']))."' WHERE userid = '".$db->clean($d['userid'])."'");
				
				if ($d['amount'] == 300){
					$bonus_ev = 0.005 * 100;
				}
				else{
					$bonus_ev = 0.005 * 50;
				}
				for ($z = 1; $z <= 200; $z++){
					$inserts = array();
					$inserts['transactionnumber'] = $d['transaction_number'];
					$inserts['transaction_type'] = 'point-evtrade';
					$inserts['notes'] = 'Cash Back Rebate';
					$inserts['transactiondate'] = 'now() + interval '.$z.' day';
					$inserts['nominal'] = round($bonus_ev, 2);
					$inserts['userid'] = $d['userid'];

					$db->insert("temp_history", $inserts);
					unset($inserts);
				}
				
				/* bonus PAM every month */
				/* if ($member_db['trading_account_pam_amount'] > 0){
					$bonus_roi = 0.1 * $member_db['trading_account_pam_amount'];
					
					for ($z = 1; $z <= 24; $z++){
						$inserts = array();
						$inserts['transactionnumber'] = '';
						$inserts['transaction_type'] = 'bonus-point-roi';
						$inserts['notes'] = 'Bonus ROI';
						$inserts['transactiondate'] = '\''.$d['approved_date'].'\' + interval '.$z.' month';
						$inserts['nominal'] = round($bonus_roi, 2);
						$inserts['userid'] = $d['userid'];

						$db->insert("temp_history", $inserts);
						unset($inserts);
					}
				} */
			}
			else if ($d['type'] == 'topup'){
				$bonus_ev = 0.005 * $d['amount'];
				for ($z = 1; $z <= 200; $z++){
					$inserts = array();
					$inserts['transactionnumber'] = $d['transaction_number'];
					$inserts['transaction_type'] = 'point-evtrade';
					$inserts['notes'] = 'Cash Back Rebate';
					$inserts['transactiondate'] = 'now() + interval '.$z.' day';
					$inserts['nominal'] = round($bonus_ev, 2);
					$inserts['userid'] = $d['userid'];

					$db->insert("temp_history", $inserts);
					unset($inserts);
				}
			}
		}
	}
	
	/* // package type
	$db_user = $db->fetch_all("SELECT * FROM user");
	if (sizeof($db_user) > 0){
		foreach ($db_user as $dbu){
			$package = '';
			if ($dbu['userid'] == 1){
				$package = 'gold';
			}
			else{
				$depo = $db->fetch_one("SELECT amount FROM deposit WHERE userid = '".$db->clean($dbu['userid'])."' AND type = 'registration'");
				$depo['amount'] = empty($depo['amount']) ? 0 : $depo['amount'];
				if ($depo['amount'] == 300){
					$package = 'gold';
				}
				else if ($depo['amount'] == 150){
					$package = 'silver';
				}
			}
			if (!empty($package)){
				$db->query("UPDATE user SET package = '".$db->clean($package)."' WHERE userid = '".$db->clean($dbu['userid'])."'");
			}
		}
	} */
	
	/* // bonus level
	$a = $db->fetch_all("SELECT * FROM user WHERE deposit_status = 1 AND userid != 1 ORDER BY userid DESC");
	foreach ($a as $b){
		$curstatus = $db->fetch_one("SELECT * FROM deposit WHERE userid = ".$db->clean($b['userid'])." AND `type` = 'registration'");
	
		$member_db = $db->fetch_one("SELECT parentid, deposit_status, level, email, firstname FROM user WHERE userid = ".$db->clean($b['userid']));
		
		$user->setUplineTotalDownline($member_db['parentid']);
		
		$share_to = $member_db['parentid'];
		for ($lvl = 1; $lvl <= 7; $lvl++){
			if ($lvl > 1){
				$bonus_amount = $bonussetting['bonus_sponsor_'.$lvl] / 100 * $curstatus['amount'];
				$db->query("UPDATE user SET bonus_sharing = bonus_sharing + ".$bonus_amount." WHERE userid = '".$db->clean($share_to)."'");
				$deposit->saveDepositHistory($curstatus['transaction_number'], $bonus_amount, $share_to, 'bonus-sponsor-'.$lvl, 'Bonus Sponsor Level '.$lvl.' - Member : '.$member_db['email'].' ('.$member_db['firstname'].')');
			}
			
			$toup = $db->fetch_one("SELECT parentid FROM user WHERE userid = '".$db->clean($share_to)."'");
			$toup['parentid'] = empty($toup['parentid']) ? 0 : $toup['parentid'];
			if (empty($toup['parentid']) || $toup['parentid'] == -1){
				break;
			}
			$share_to = $toup['parentid'];
		}
		
		if (!empty($b['parent_tree'])){
			$user->setUplineTotalDownlineTree($b['userid']);
		}
	} */
?>