<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include_once('../config.php');
include_once('function.php');
//include_once GAMEBASEPATH.'agClass.php';
//$newObj = new agClass(1);
function random_strings($length_of_string)
{
// String of all alphanumeric character
$str_result = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
// Shufle the $str_result and returns substring
// of specified length
0, $length_of_string);
}
function random19() {
$number = "";
for($i=0; $i<19; $i++) {
$min = ($i == 0) ? 1:0;
}
return $number;
}
function callMeAlways($timeFrom,$nextId='')
{
global $newObj;
//$data = $newObj->getBetRecords($timeFrom,$nextId);
//print_r($data);
$playerIds = callsql("SELECT player_user_id FROM player_user order by player_user_id desc limit 50,200 ",'rows');
//$wagerids=array("GC0081930108p");
$gamenames=array("ag_26","ag_12");
$channels=array("ag_26","ag_12");
$betamounts=array("600","800","700","2000");
$payoffs=array("1950","2000","700","3000");
$dates=array("2019-04-01 02:00:00","2019-04-02 02:00:00","2019-04-03 07:00:00","2019-04-04 06:00:00","2019-04-15 02:00:00","2019-04-16 02:00:00","2019-04-17 09:00:00","2019-04-21 11:00:00","2019-04-11 02:00:00","2019-04-16 02:00:00","2019-04-20 02:00:00","2019-04-21 02:00:00","2019-04-01 22:00:00","2019-04-23 02:00:00","2019-04-25 02:00:00","2019-04-24 02:00:00"
,"2019-04-26 02:00:00","2019-04-27 02:00:00","2019-04-28 02:00:00","2019-04-29 02:00:00","2019-04-30 04:00:00");
$roundids=array("ivan001_RT","ivan002_RT");
$sequences=array("ivan001_RT","ivan002_RT");
for($i=1;$i<1000;$i++)
{
$rand=random_strings(8);;
$data['response']['data']['key'.$i]['UserName']=$playerIds[array_rand($playerIds)]['player_user_id'];
$data['response']['data']['key'.$i]['WagersID']='GC00'.$rand;
$data['response']['data']['key'.$i]['GAMENAME']=$gamenames[array_rand($gamenames)];
$data['response']['data']['key'.$i]['betIp']='';
$data['response']['data']['key'.$i]['WagersDate']=$dates[array_rand($dates)];
$data['response']['data']['key'.$i]['BetAmount']=$betamounts[array_rand($betamounts)];
$data['response']['data']['key'.$i]['Payoff']=$payoffs[array_rand($payoffs)];
$data['response']['data']['key'.$i]['Currency']='CNY';
$data['response']['data']['key'.$i]['jackpotAmount']='';
$data['response']['data']['key'.$i]['luckyDrawId']='';
$data['response']['data']['key'.$i]['roundId']=$roundids[array_rand($roundids)];
$data['response']['data']['key'.$i]['SESSIONID']=$roundids[array_rand($roundids)];
$data['response']['data']['key'.$i]['GAMETYPE']=$gamenames[array_rand($gamenames)];
$data['response']['data']['key'.$i]['BALANCE']='';
$data['response']['data']['key'.$i]['jpWin']='';
}
$datas = $data['response']['data'];
$serviceCode = 'AG';
$sg_turnover = $sg_unprocessed = $sg_winArray =array();
$iaska =0;
foreach ($datas as $key=>$value)
{
// echo "SELECT username FROM player_user WHERE player_user_id='".$value['UserName']."'";
$playername = callsql("SELECT username FROM player_user WHERE player_user_id='".$value['UserName']."'",'value');
$upd = callsql("UPDATE player_game_details SET bbin_username='".$playername."',bbin_password='".$playername."' WHERE player_id='".$value['UserName']."'");
$iaska++;
$sessionId = $value['SESSIONID'];
//$md5 = md5($sessionId.$timeTrans);
$acctId = $playername;
$ticketId = $value['WagersID']; //Tricky Way To Generate Ticket Id .. No Other Option to get Unique Transaction Id
$categoryId = $value['GAMENAME'];
$gameCode = $value['GameType'];
$betIp = $value['betIp'];
$ticketTime = $value['WagersDate'];
$betAmount = $value['BetAmount'];
$winLoss = $value['Payoff'];
$currency =$value['Currency'];
$result = $resultDetails;
$jackpotAmount = $value['jackpotAmount'];
$luckyDrawId = $value['luckyDrawId'];
$result = $value['Result'];
$r=random19();
$result = '{"BetAmount":'.$betAmount.',"Win":'.$winLoss.',"BetID":"'.$ticketId.'","BetTime":"'.$value['WagersDate'].'","BetTraceID":"'.$acctId.'_RT8::AG::STAKE::'.$r.'","GameCode":"'.$categoryId.'","UserName":"'.$acctId.'"}';
$turnover = (isset($value['BetAmount']))?
$value['BetAmount']:0;
$effective_turnover = $turnover;
if($kind == 1 && $result == 'S') //Need to ask BBIN for more accurate
$completed = 0;
else
$completed = 1;
$roundId = $value['roundId'];
$sequence = $value['SESSIONID'];
$channel = $value['GAMETYPE'];
$balance = $value['BALANCE'];
$jpWin = $value['jpWin'];
$time = strtotime($ticketTime); //Convert to GMT + 8 - Now Result GMT -4
// echo "SELECT player_id FROM player_game_details WHERE bbin_username='$acctId'";
$playerId = callsql("SELECT player_id FROM player_game_details WHERE bbin_username='$acctId'",'value');
// exit();
$checkExit = callsql("SELECT COUNT(*) FROM game_play_history WHERE service_code='$serviceCode' AND ticketId='$ticketId'",'value');
{
if(empty($checkExit) && $completed == 1)
{
$ins = mysql_query("INSERT INTO game_play_history SET player_id='$playerId',service_code='$serviceCode',ticketId='$ticketId',categoryId='$categoryId',"
. " gameCode='$gameCode',transTime='$time',betIp='$betIp',betAmount='$betAmount',winLoss='$winLoss',currency='$currency',result='$result',"
. " jackpotAmount='$jackpotAmount',luckyDrawId='$luckyDrawId',status=1,roundId='$roundId',sequence='$sequence',channel='$channel',aftr_bal='$balance',jpWin='$jpWin',turnover='$turnover',effective_turnover='$effective_turnover' ");
$sg_unprocessed[$playerId] = $sg_unprocessed[$playerId] + ($winLoss);
$sg_turnover[$playerId]= $sg_turnover[$playerId] + ($betAmount);
//echo "$iss <br>";
if($winLoss > 0)
{
$sg_winArray[$playerId] = $sg_winArray[$playerId]+ $winLoss;
}
$iss++;
}
}
}
foreach ($sg_turnover as $keyId=>$keyVal)
{
$upd = mysql_query("UPDATE player_game_details SET ag_turnover=ag_turnover+$keyVal,ag_unprocessed=ag_unprocessed+$sg_unprocessed[$keyId] WHERE player_id='$keyId'");
$vendorId = 'AG';
$checkActivePromo = callsql("SELECT * FROM promo_activity_list WHERE player_id='$keyId' AND running_promo=1 AND used_games LIKE '%$vendorId%' ",'row');
$addonPreWallet = $keyVal;
if($sg_winArray[$keyId] > 0)
{
$addonPreWallet = $addonPreWallet + $sg_winArray[$keyId];
}
if(!empty($checkActivePromo))
{
//$activeAddon = " , promo_turnover = promo_turnover + $keyVal ";
$myQry = mysql_query("SELECT * FROM promo_activity_list WHERE player_id='$keyId' AND running_promo=1 AND used_games LIKE '%$vendorId%' ORDER BY create_time ASC");
$needToUse = $keyVal;
{
if($needToUse > 0)
{
$currentMax = $myRes['turover_amount'];
$currentReached = $myRes['turnover_reached'];
$currentPromoBal = $myRes['bal_amount'];
$promo_activity_list_id = $myRes['promo_activity_list_id'];
$tempAfterAdd = $currentReached+$needToUse;
$promoAmount = $myRes['amount'];
if($currentReached >= $currentMax && $currentPromoBal == 0)
{
$amountToUse =0;
$status = 2;
$running_promo = 0;
$end_type = 1;
}
if($tempAfterAdd >= $currentMax && $currentPromoBal ==0)
{
$amountToUse = $currentMax-$currentReached;
$needToUse = $needToUse -$amountToUse;
$status = 2;
$running_promo = 0;
$end_type = 1;
addPromoToMainWallet($keyId,$myRes['promo_activity_list_id']);
}
else
{
$amountToUse = $needToUse;
$needToUse =0;
if($currentPromoBal > 0)
$status = 0;
else
$status =1;
$running_promo = 1;
$end_type = 0;
$end_time = '';
}
mysql_query("UPDATE promo_activity_list SET promo_status='$status',running_promo='$running_promo',"
. "end_type='$end_type',end_time='$end_time',turnover_reached=turnover_reached+$amountToUse WHERE promo_activity_list_id ='$promo_activity_list_id'");
$transId = $myRes['transid'];
if($status == 2)
{
{
$update = mysql_query("UPDATE player_turnover SET status=2,deposit_turnover=deposit_turnover+1 WHERE transaction_id='$transId' AND status != 2");
}
}
}
}
}
else
{
$activeAddon = " , pre_wallet_bal=pre_wallet_bal+$addonPreWallet ";
updateTurnover($keyId,$keyVal);
}
mysql_query(" UPDATE player_wallet SET deposit_turnover=deposit_turnover+$keyVal,vip_turnover=vip_turnover+$keyVal $activeAddon WHERE player_id ='$keyId'");
}
if(!empty($data['response']['pagination']))
{
$totalPages = $data['response']['pagination']['TotalPage'];
$currentPages = $data['response']['pagination']['Page'];
if($totalPages > $currentPages )
{
$newPage = $currentPages+1;
callMeAlways($timeFrom,$newPage);
}
}
}
callMeAlways($timeFrom);
?>