<?php 
	include "../../conn.php";
	include "../../functions2.php";
	
	header('Content-Type: application/json; charset=utf-8');
	header('Strict-Transport-Security: max-age=31536000');
	header('Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept, Authorization');
	header('Access-Control-Allow-Credentials: true');
	$origin = isset($_SERVER['HTTP_ORIGIN']) ? $_SERVER['HTTP_ORIGIN'] : '';
	header('Access-Control-Allow-Origin: ' . $origin);
	header('vary: Origin');
	
	date_default_timezone_set("Asia/Kolkata");
	$shnunc = date("Y-m-d H:i:s");
	$res = [
		'code' => 11,
		'msg' => 'Method not allowed',
		'msgCode' => 12,
		'serviceNowTime' => $shnunc,
	];
	$shonubody = file_get_contents("php://input");
	$shonupost = json_decode($shonubody, true);
	
	if ($_SERVER['REQUEST_METHOD'] != 'GET') {
		if (isset($shonupost['issueNumber']) && isset($shonupost['language']) && isset($shonupost['random']) && isset($shonupost['signature']) && isset($shonupost['timestamp'])) {
			$issueNumber = isset($shonupost['issueNumber'][0]) ? mysqli_real_escape_string($conn, $shonupost['issueNumber'][0]) : '';
			$language = htmlspecialchars(mysqli_real_escape_string($conn, $shonupost['language']));
			$random = htmlspecialchars(mysqli_real_escape_string($conn, $shonupost['random']));
			$signature = htmlspecialchars(mysqli_real_escape_string($conn, $shonupost['signature']));
			$shonustr = '{"issueNumber":["'.$issueNumber.'"],"language":'.$language.',"random":"'.$random.'"}';
			$shonusign = strtoupper(md5($shonustr));
			if($shonusign == $signature){
				$bearer = explode(" ", $_SERVER['HTTP_AUTHORIZATION']);
				$author = $bearer[1];				
				$is_jwt_valid = is_jwt_valid($author);
				$data_auth = json_decode($is_jwt_valid, 1);
				if($data_auth['status'] === 'Success') {
					$sesquery = "SELECT akshinak
					  FROM shonu_subjects
					  WHERE akshinak = '$author'";
					$sesresult=$conn->query($sesquery);
					$sesnum = mysqli_num_rows($sesresult);
					if($sesnum == 1){
						$typeId = $issueNumber[12];
						$shonuid = $data_auth['payload']['id'];
						
						if($typeId == 1){
							$jayshriram = 'bajikattuttate';
						}
						else if($typeId == 2){
							$jayshriram = 'bajikattuttate_drei';
						}
						else if($typeId == 3){
							$jayshriram = 'bajikattuttate_funf';
						}
						else if($typeId == 5){
							$jayshriram = 'bajikattuttate_zehn';
						}
						
						$samasye = "SELECT phalaphala, sesabida, ergebnis
						  FROM ".$jayshriram." WHERE kalaparichaya = $issueNumber AND byabaharkarta = $shonuid
						  ORDER BY parichaya DESC LIMIT 1";
						$samasyephalitansa = $conn->query($samasye);
						$samasyephalitansa_sreni = mysqli_fetch_array($samasyephalitansa);
						
						$data[0]['issueNumber'] = $issueNumber;
						$data[0]['number'] = $samasyephalitansa_sreni['ergebnis'];
						if($samasyephalitansa_sreni['ergebnis'] == 0){
							$color = 'red,violet';
						}
						else if($samasyephalitansa_sreni['ergebnis'] == 5){
							$color = 'green,violet';
						}
						else if(
							$samasyephalitansa_sreni['ergebnis'] == 1 ||
							$samasyephalitansa_sreni['ergebnis'] == 3 ||
							$samasyephalitansa_sreni['ergebnis'] == 7 ||
							$samasyephalitansa_sreni['ergebnis'] == 9
							){
							$color = 'green';
						}
						else if (
                            $samasyephalitansa_sreni['ergebnis'] == 2 ||
                            $samasyephalitansa_sreni['ergebnis'] == 4 ||
                            $samasyephalitansa_sreni['ergebnis'] == 6 ||
                            $samasyephalitansa_sreni['ergebnis'] == 8
                        ) {
                            $color = 'red';
                        } else {
                            $color = 'green';
                        }
                        
                        $data[0]['colour'] = $color;
                        $data[0]['winAmount'] = $samasyephalitansa_sreni['sesabida'];
                        
                        // Assign typeName directly based on typeId
                        switch ($typeId) {
                            case 1:
                                $data[0]['typeName'] = '1Min';
                                break;
                            case 2:
                                $data[0]['typeName'] = '3Min';
                                break;
                            case 3:
                                $data[0]['typeName'] = '5Min';
                                break;
                            case 5:
                                $data[0]['typeName'] = '30S';
                                break;
                            default:
                                $data[0]['typeName'] = 'Unknown'; // Fallback case
                        }
                        
                        if ($samasyephalitansa_sreni['phalaphala'] == 'perte') {
                            $state = 0;
                        } elseif ($samasyephalitansa_sreni['phalaphala'] == 'gagner') {
                            $state = 1;
                        } else {
                            $state = -1; // Handle unexpected values
                        }
                        
                        $data[0]['state'] = $state;
											
						$res['data'] = $data;
						$res['code'] = 0;
						$res['msg'] = 'Succeed';
						$res['msgCode'] = 0;
						http_response_code(200);
						echo json_encode($res);	
					}
					else{
						$res['code'] = 4;
						$res['msg'] = 'No operation permission';
						$res['msgCode'] = 2;
						http_response_code(401);
						echo json_encode($res);
					}					
				}
				else{					
					$res['code'] = 4;
					$res['msg'] = 'No operation permission';
					$res['msgCode'] = 2;
					http_response_code(401);
					echo json_encode($res);					
				}
			}
			else{
				$res['code'] = 5;
				$res['msg'] = 'Wrong signature';
				$res['msgCode'] = 3;
				http_response_code(200);
				echo json_encode($res);				
			}
		}
		else{
			$res['code'] = 7;
			$res['msg'] = 'Param is Invalid';
			$res['msgCode'] = 6;
			http_response_code(200);
			echo json_encode($res);			
		}		
	} else {		
		http_response_code(405);
		echo json_encode($res);
	}
?>