<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
date_default_timezone_set('Asia/Kolkata');

include("serive/samparka.php");

$apiUrl = "https://draw.ar-lottery01.com/WinGo/WinGo_1M/GetHistoryIssuePage.json";

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,$apiUrl);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
curl_setopt($ch, CURLOPT_TIMEOUT,10);
curl_setopt($ch, CURLOPT_USERAGENT,'Mozilla/5.0');

$response = curl_exec($ch);
curl_close($ch);

$json = json_decode($response,true);

if(isset($json['data']['list'][0])){

$real_finished_period = $json['data']['list'][0]['issueNumber'];
$real_finished_result = (int)$json['data']['list'][0]['number'];

$real_prev_period = $json['data']['list'][1]['issueNumber'];
$real_prev_result = (int)$json['data']['list'][1]['number'];

$tarika = date('Y-m-d H:i:s');


// ACTIVE PERIOD
mysqli_query($conn,"DELETE FROM gelluonduhogu WHERE atadaaidi!='$real_finished_period'");

$check_p = mysqli_query($conn,"SELECT atadaaidi FROM gelluonduhogu WHERE atadaaidi='$real_finished_period'");

if(mysqli_num_rows($check_p)==0){

mysqli_query($conn,"INSERT INTO gelluonduhogu(atadaaidi,dinankavannuracisi)
VALUES('$real_finished_period','$tarika')");

}


// RESULT UPDATE
mysqli_query($conn,"UPDATE hastacalita_phalitansa SET sthiti='0'");
mysqli_query($conn,"UPDATE hastacalita_phalitansa SET sthiti='1' WHERE sankhye='$real_finished_result'");


// HISTORY CHECK
$check_h = mysqli_query($conn,"SELECT id FROM gellaluhogiondu_phalitansa WHERE kalaparichaya='$real_prev_period'");

if(mysqli_num_rows($check_h)==0){

// COLOR LOGIC
if($real_prev_result==0){
$banna='red,violet';
}
elseif($real_prev_result==5){
$banna='green,violet';
}
elseif(in_array($real_prev_result,[1,3,7,9])){
$banna='green';
}
else{
$banna='red';
}

$random = rand(1000,9999).$real_prev_result;


// INSERT HISTORY
mysqli_query($conn,"INSERT INTO gellaluhogiondu_phalitansa
(kalaparichaya,bele,phalitansa,banna,phalitansadaprakara,dinankavannuracisi)
VALUES
('$real_prev_period','$random','$real_prev_result','$banna','sync_done','$tarika')");


// APPLY 2% TAX
mysqli_query($conn,"UPDATE bajikattuttate
SET ketebida = ketebida*0.98
WHERE kalaparichaya='$real_prev_period'");


// WIN CONDITION
$win_cond="ojana='$real_prev_result'";

if($real_prev_result>=5){
$win_cond.=" OR ojana='13'";
}else{
$win_cond.=" OR ojana='14'";
}

if(strpos($banna,'red')!==false){
$win_cond.=" OR ojana='10'";
}

if(strpos($banna,'green')!==false){
$win_cond.=" OR ojana='11'";
}

if(strpos($banna,'violet')!==false){
$win_cond.=" OR ojana='12'";
}


// MARK WINNERS
mysqli_query($conn,"UPDATE bajikattuttate
SET phalaphala='gagner',
ergebnis='$real_prev_result',
tiarikala='$tarika'
WHERE kalaparichaya='$real_prev_period' AND ($win_cond)");


// NUMBER BET 9X
mysqli_query($conn,"UPDATE bajikattuttate
SET sesabida = ketebida*9
WHERE kalaparichaya='$real_prev_period'
AND phalaphala='gagner'
AND ojana='$real_prev_result'");


// BIG SMALL 2X
mysqli_query($conn,"UPDATE bajikattuttate
SET sesabida = ketebida*2
WHERE kalaparichaya='$real_prev_period'
AND phalaphala='gagner'
AND (ojana='13' OR ojana='14')");


// RED GREEN 2X
mysqli_query($conn,"UPDATE bajikattuttate
SET sesabida = ketebida*2
WHERE kalaparichaya='$real_prev_period'
AND phalaphala='gagner'
AND (ojana='10' OR ojana='11')");


// VIOLET 4.5X
mysqli_query($conn,"UPDATE bajikattuttate
SET sesabida = ketebida*4.5
WHERE kalaparichaya='$real_prev_period'
AND phalaphala='gagner'
AND ojana='12'");


// ADD WALLET
mysqli_query($conn,"UPDATE shonu_kaichila
INNER JOIN(
SELECT byabaharkarta,SUM(sesabida) as total_win
FROM bajikattuttate
WHERE kalaparichaya='$real_prev_period'
AND phalaphala='gagner'
GROUP BY byabaharkarta
) as winners
ON shonu_kaichila.balakedara=winners.byabaharkarta
SET shonu_kaichila.motta = shonu_kaichila.motta + winners.total_win");

}

echo "SYNC DONE | PERIOD $real_finished_period | RESULT $real_finished_result";

}
?>