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

$data = array();

$user_id = $_SESSION['tm_id'];

//ini_set('display_errors',1);
//error_reporting(E_ALL);

require_once('functions.translators.php');

$translators_obj = new Translators();

$user_level = $translators_obj->getCurrentUserLevelByUserId( $user_id );

//this will check, if user applicable to upgrade user level, if yes it will upgrade user level
$translators_obj->upgradeUserLevel($user_id, $user_level);

require_once('functions.suggestions.php');

$suggestions_obj = new Suggestions();

require_once('functions.voting.php');

$voting_obj = new Voting();

//start calculate success ratio and upgrade Level 6, Level 11 - Step2
if( $user_level == 5 || $user_level == 10 ) {

	$level_no = $user_level;
	
	//current user level 5 or level 10
	$total_suggestions_provided_count = $suggestions_obj->getTotalSuggestionProvidedCountUptoLevelByUserId($user_id, $level_no);
	$total_closed_suggestion_count = $suggestions_obj->getSuggestionSentenceClosedCountUptoLevelByUserId($user_id, $level_no);
	$total_winning_suggestion_count = $suggestions_obj->getWinningSuggestionCountUptoLevelByUserId($user_id, $level_no);

	$total_closed_voting_count = $voting_obj->getVotingSentenceClosedCountUptoLevelByUserId($user_id, $level_no);
	$total_voting_provided_count = $voting_obj->getTotalVotingProvidedCountUptoLevelByUserId($user_id, $level_no);
	$total_winning_voting_count = $voting_obj->getWinningVotingCountUptoLevelByUserId($user_id, $level_no);		

	//Get Level 1 to Level 5, Level 1 to Level 10 all closed suggestion and voting success ratio
	$user_success_ratio = $translators_obj->getAllClosedSuggestionAndVotingSuccessRatio( $total_suggestions_provided_count, $total_closed_suggestion_count, $total_winning_suggestion_count, $total_voting_provided_count, $total_closed_voting_count, $total_winning_voting_count );	

	if( $user_level == 5 ) {
		$admin_decided_success_ratio = $suggestions_obj->getSettingsValuesByColumnName( 'step1_success_rate_percentage' );		
	} elseif( $user_level == 10 ) {
		$admin_decided_success_ratio = $suggestions_obj->getSettingsValuesByColumnName( 'step2_success_rate_percentage' );		
	}	
	
	//Upgrade Level 6, Level 11 - Step2, if success ratio more than 25%
	$translators_obj->upgradeUserLevelStep2( $user_id, $user_level, $user_success_ratio, $admin_decided_success_ratio );

}
//end calculate success ratio and upgrade Level 6, Level 11 - Step2


$userSuccessSuggestionCountForLevel =	$suggestions_obj->getUserSubmittedSuccessSuggestionCountByUserIdAndLevel( $user_id, $user_level );
$maxSuggestionCountForLevel =	$suggestions_obj->getMaxSubmitSuggestionCountByLevel( $user_level );

$userSuccessVotingCountForLevel = $voting_obj->getUserSubmittedSuccessVotingCountByUserIdAndLevel( $user_id, $user_level );
$maxVotingCount = $voting_obj->getMaxSubmitVotingCountByLevel( $user_level );

$data['user_current_level'] = $user_level;
$data['user_submitted_success_suggestions_count_for_user_level'] = $userSuccessSuggestionCountForLevel;
$data['max_submit_suggestions_count_for_user_level'] = $maxSuggestionCountForLevel;

if( $userSuccessVotingCountForLevel >= $maxVotingCount ) {
	$data['continue_label_text'] = 'tomorrow.';
} else {
	$data['continue_label_text'] = '<a href="/voting.php">Voting</a>';
}

echo json_encode($data);