<?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 'connection.php';
error_reporting(E_ALL);
ini_set('display_errors', 1);

$data['status'] = 300;
$data['msg'] = 'Error while claiming. Try again.';

if (isset($_POST['tmn']) && isset($_POST['package_id'])) {

    $id = $_SESSION['tm_id'];
    $sqlT = 'SELECT * FROM `tbl_translators` WHERE id= ' . $id;
    $resultT = $mysqli->query($sqlT);
    while ($row = $resultT->fetch_object()) {        
        if($row->tmn_credits >= 1000) {
            $sqlClaim = 'select id from translator_claimed_topups where user_id = ' .  $id.' and status = 0';
            $resultClaim = $mysqli->query($sqlClaim);
            
            if($resultClaim->num_rows == 0) {
               $sql1 = 'INSERT INTO `translator_claimed_topups`(`user_id`, `claimed_credits`, `package_id`, `status`, `created_at`) VALUES 
               (' .$id . ','.$_POST['tmn'].','.$_POST['package_id'].',0,"'.date('Y-m-d H:i:s').'")';
               
               $result = $mysqli->query($sql1);
               
               $_SESSION['tm_is_topup_pending'] = 1;
    
               $data['status'] = 200;
               $data['msg'] = 'Your TMN has been claimed successfully.';
            } else{
               $data['msg'] = 'Please wait for your previous claim to clear out.';
            }
        } else{
            $data['msg'] = 'You do not have sufficient TMN to claim.';
        }
    }
}

echo json_encode($data);