<?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';

if (isset($_POST['sid']) && isset($_SESSION['tm_id']) && isset($_POST['suggestion'])) {
    $sentence_id = base64_decode($_POST['sid']);
    $user_id = $_SESSION['tm_id'];
    $language_id = $_SESSION['tm_language_id'];

    if (is_numeric($sentence_id)) {
        $daily_tmn_suggestion_limit = 0;
        $tmn_per_suggestion = $tmn_credits = $winning_suggestion_tmn = 0;

//        $sqlSettings = 'SELECT * FROM `settings` WHERE 1 ';
//        $resultSettings = $mysqli->query($sqlSettings);
//
//        while ($row = $resultSettings->fetch_object()) {
//            $daily_tmn_suggestion_limit = (int) $row->daily_suggestion_tmn_limit;
//            $tmn_per_suggestion = (int) $row->tmn_per_suggestion;
//            $winning_suggestion_tmn = (int) $row->winning_suggestion_tmn;
//        }
//        $sqlTodaySuggestion = 'SELECT * FROM `tbl_user_suggestion_mapping` WHERE user_id = ' . $user_id;
//        $resultTodaySuggestion = $mysqli->query($sqlTodaySuggestion);
//
//        $todaySuggestionTotal = $resultTodaySuggestion->num_rows;
//        if ($todaySuggestionTotal < $daily_tmn_suggestion_limit) {
//            $tmn_credits = $tmn_per_suggestion;
//        }

        $sqlSuggestion = 'SELECT * FROM `tbl_user_suggestion_mapping` WHERE sentence_id = ' . $sentence_id . ' and user_id = ' . $user_id;
        $resultSuggestion = $mysqli->query($sqlSuggestion);

        $sqlSuggestionCount = 'SELECT * FROM `tbl_user_suggestion_mapping` WHERE sentence_id = ' . $sentence_id;
        $resultSuggestionCount = $mysqli->query($sqlSuggestionCount);

        if ($resultSuggestion->num_rows == 0) {
            if ($resultSuggestionCount->num_rows < 5) {

                $new_tmn = $_SESSION['tm_credits'] + $tmn_credits;
                $_SESSION['tm_credits'] = $new_tmn;

                $sqlInsert = 'INSERT INTO `tbl_user_suggestion_mapping`(`sentence_id`, `user_id`, `category_id`, `suggestion`, `credits`,voted_user_id, `created_at`) VALUES '
                        . '(' . $sentence_id . ',' . $user_id . ',' . $language_id . ',"' . addslashes($_POST['suggestion']) . '",' . $tmn_credits . ',"" ,"' . date('Y-m-d H:i:s') . '")';
                $resultInsert = $mysqli->query($sqlInsert);

                $suggestion_count = (int) ($resultSuggestionCount->num_rows) + 1;
                $sqlUpdate = 'UPDATE `tbl_sentence` SET suggestion_count = ' . $suggestion_count . ' where id = ' . $sentence_id;
                $resultUpdate = $mysqli->query($sqlUpdate);
				
				// Increment users total suggestions
				$sqlUpdateUS = 'UPDATE `tbl_translators` SET total_suggestions = total_suggestions + 1 where id = ' . $user_id;
                $resultUpdateUS = $mysqli->query($sqlUpdateUS);


                echo json_encode(array("status" => "200", "msg" => "Suggestion submitted successfully"));
            } else {
                echo json_encode(array("status" => "300", "msg" => "This sentence has already reached 5 suggestions.<br>
Please skip this and contribute on a new one."));
            }
        } else {
            echo json_encode(array("status" => "300", "msg" => "You have already given suggestion for this sentence."));
        }
    } else {
        echo json_encode(array("status" => "300", "msg" => 'Something went wrong, Please try again.'));
    }
} else {
    echo json_encode(array("status" => "300", "msg" => 'User not found'));
}