<?php
	date_default_timezone_set('Asia/Jakarta');

	require_once "incl/config.php";
	require_once "class/Database.php";
	require_once "incl/misc_function.php";
	$db = new Database();
	$db->connect();
	
	/* Bonus Topup */
	$data = $db->fetch_all("SELECT * FROM temp_history WHERE transaction_type IN ('bonus-point-roi', 'bonus-topup', 'point-evtrade') AND transactiondate < NOW()");
	if (sizeof($data) > 0){
		foreach($data as $dt){
			$inserts = array();
			$inserts['transactionnumber'] = $dt['transactionnumber'];
			$inserts['transaction_type'] = $dt['transaction_type'];
			$inserts['notes'] = $dt['notes'];
			$inserts['transactiondate'] = $dt['transactiondate'];
			$inserts['nominal'] = $dt['nominal'];
			$inserts['userid'] = $dt['userid'];

			$db->insert("transaction_history", $inserts);
			unset($inserts);
			
			if ($dt['transaction_type'] == 'point-evtrade'){
				$db->query("UPDATE user SET bonus_point = bonus_point + ".$dt['nominal']." WHERE userid = '".$db->clean($dt['userid'])."'");
			}
			else{
				$db->query("UPDATE user SET bonus_sharing = bonus_sharing + ".$dt['nominal']." WHERE userid = '".$db->clean($dt['userid'])."'");
			}
		}
		
		$db->query("DELETE FROM temp_history WHERE transaction_type IN ('bonus-point-roi', 'bonus-topup', 'point-evtrade') AND transactiondate < NOW()");
	}
?>