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

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);

//error_reporting(E_ALL);

//Report all errors except warnings.
error_reporting(E_ALL ^ E_WARNING);

//$_POST['load_offset'] = 0;

if (isset($_SESSION['tm_id']) && isset($_POST['load_offset'])) {
    $offset = $_POST['load_offset'];
    $user_id = $_SESSION['tm_id'];

    $start_date = date('Y-m-d', strtotime('-' . $offset . ' month'));
    $end_date = date('Y-m-d', strtotime($start_date . ' -1 month'));

    $current_date = $start_date;
    while (strtotime($current_date) > strtotime($end_date)) {
        $data[$current_date] = array();
        $current_date = date('Y-m-d', strtotime($current_date . '-1 day'));
    }
    
	
	//Get reputation winning suggestion credit records for translator
	$sql_reputation_winning_suggestion = ' SELECT winning_credits, `created_at` as created_date FROM `winning_suggestion_voting_credits` WHERE user_id="' . $user_id . '" AND credit_purpose = 1 ';
    $sql_reputation_winning_suggestion = $sql_reputation_winning_suggestion . ' AND DATE_FORMAT(`created_at`,"%Y-%m-%d %H-%i-%s") >=  "' . $end_date . '" AND DATE_FORMAT(`created_at`,"%Y-%m-%d") <= "' . $start_date . '" ';
    $sql_reputation_winning_suggestion = $sql_reputation_winning_suggestion . ' ORDER BY created_date DESC ';	
	
    $result_reputation_winning_suggestion = $mysqli->query($sql_reputation_winning_suggestion);
	
	if($result_reputation_winning_suggestion->num_rows > 0) {
		while ($row_reputation_winning_suggestion = $result_reputation_winning_suggestion->fetch_object()) {
			$temp = array();
			$temp['tmn'] = $row_reputation_winning_suggestion->winning_credits;
			$temp['timestamp'] = strtotime($row_reputation_winning_suggestion->created_date);
			$temp['sentence'] = 'Your Reputation suggestion has won. <b>TMN Earned: ' . $row_reputation_winning_suggestion->winning_credits . '</b>';
			$temp['type'] = 'Suggestion';
			
			if($row_reputation_winning_suggestion->created_date != '' && $row_reputation_winning_suggestion->created_date != null) {
				if(isset($temp) && !empty($temp) && $temp != null)
					array_push($data[date('Y-m-d', strtotime($row_reputation_winning_suggestion->created_date))], $temp);
			}
		}
	}
	
	//Get reputation winning suggestion TMN votes credit records for translator
    $sql_reputation_winning_sugg_votes = 'SELECT winning_credits, `created_at` as created_date FROM `winning_suggestion_voting_credits` WHERE user_id="' . $user_id . '" AND credit_purpose=2 ';
    $sql_reputation_winning_sugg_votes = $sql_reputation_winning_sugg_votes . ' AND DATE_FORMAT(`created_at`,"%Y-%m-%d") >=  "' . $end_date . '" AND DATE_FORMAT(`created_at`,"%Y-%m-%d") <= "' . $start_date . '" ';
    $sql_reputation_winning_sugg_votes = $sql_reputation_winning_sugg_votes . ' ORDER BY created_date DESC ';	
	
    $result_reputation_winning_sugg_votes = $mysqli->query($sql_reputation_winning_sugg_votes);
	
	if($result_reputation_winning_sugg_votes->num_rows > 0) {
		while ($row_reputation_winning_sugg_votes = $result_reputation_winning_sugg_votes->fetch_object()) {
			$temp = array();
			$temp['tmn'] = $row_reputation_winning_sugg_votes->winning_credits;
			$temp['timestamp'] = strtotime($row_reputation_winning_sugg_votes->created_date);
			$temp['sentence'] = 'TMN earned for voting a winning reputation suggestion. <br><b>TMN Earned: ' . $row_reputation_winning_sugg_votes->winning_credits . '</b>';
			$temp['type'] = 'Voting';
			if($row_reputation_winning_sugg_votes->created_date != '' && $row_reputation_winning_sugg_votes->created_date != null) {
				if(isset($temp) && !empty($temp) && $temp != null)
				array_push($data[date('Y-m-d', strtotime($row_reputation_winning_sugg_votes->created_date))], $temp);
			}
		}
	}
	
	
	//Get work experience assessment winning suggestion credit records of translator
	$sql_wea_winning_suggestion = ' SELECT winning_credits, `created_at` as created_date FROM `winning_sats_suggestion_voting_credits` WHERE user_id="' . $user_id . '" AND credit_purpose = 1 ';
    $sql_wea_winning_suggestion = $sql_wea_winning_suggestion . ' AND DATE_FORMAT(`created_at`,"%Y-%m-%d %H-%i-%s") >=  "' . $end_date . '" AND DATE_FORMAT(`created_at`,"%Y-%m-%d") <= "' . $start_date . '" ';
    $sql_wea_winning_suggestion = $sql_wea_winning_suggestion . ' ORDER BY created_date DESC ';
	
    $result_wea_winning_suggestion = $mysqli->query($sql_wea_winning_suggestion);
	
	if($result_wea_winning_suggestion->num_rows > 0) {
		while ($row_wea_winning_sugggestion = $result_wea_winning_suggestion->fetch_object()) {
			$temp = array();
			$temp['tmn'] = $row_wea_winning_sugggestion->winning_credits;
			$temp['timestamp'] = strtotime($row_wea_winning_sugggestion->created_date);
			$temp['sentence'] = 'Your work experience assessment suggestion has won. <b>TMN Earned: ' . $row_wea_winning_sugggestion->winning_credits . '</b>';
			$temp['type'] = 'Suggestion';
			
			if($row_wea_winning_sugggestion->created_date != '' && $row_wea_winning_sugggestion->created_date != null) {
				if(isset($temp) && !empty($temp) && $temp != null)
					array_push($data[date('Y-m-d', strtotime($row_wea_winning_sugggestion->created_date))], $temp);
			}
		}
	}
	
	//Get work experience winning suggestion TMN votes credit records of translator
    $sql_wea_winning_sugg_votes = 'SELECT winning_credits, `created_at` as created_date FROM `winning_sats_suggestion_voting_credits` WHERE user_id="' . $user_id . '" AND credit_purpose=2 ';
    $sql_wea_winning_sugg_votes = $sql_wea_winning_sugg_votes . ' AND DATE_FORMAT(`created_at`,"%Y-%m-%d") >=  "' . $end_date . '" AND DATE_FORMAT(`created_at`,"%Y-%m-%d") <= "' . $start_date . '" ';
    $sql_wea_winning_sugg_votes = $sql_wea_winning_sugg_votes . ' ORDER BY created_date DESC ';	
	
    $result_wea_winning_sugg_votes = $mysqli->query($sql_wea_winning_sugg_votes);
	
	if($result_wea_winning_sugg_votes->num_rows > 0) {
		while ($row_wea_winning_sugg_votes = $result_wea_winning_sugg_votes->fetch_object()) {
			$temp = array();
			$temp['tmn'] = $row_wea_winning_sugg_votes->winning_credits;
			$temp['timestamp'] = strtotime($row_wea_winning_sugg_votes->created_date);
			$temp['sentence'] = 'TMN earned for voting a winning work experience assessment suggestion. <br><b>TMN Earned: ' . $row_wea_winning_sugg_votes->winning_credits . '</b>';
			$temp['type'] = 'Voting';
			if($row_wea_winning_sugg_votes->created_date != '' && $row_wea_winning_sugg_votes->created_date != null) {
				if(isset($temp) && !empty($temp) && $temp != null)
				array_push($data[date('Y-m-d', strtotime($row_wea_winning_sugg_votes->created_date))], $temp);
			}
		}
	}
	
	
	//Get TMN claimed successful records for translator
    $sql = 'SELECT claimed_credits, `created_at` as created_date FROM `translator_claimed_credits` WHERE user_id="' . $user_id . '" and status = 1 ';
    $sql = $sql . ' and DATE_FORMAT(`created_at`,"%Y-%m-%d %H-%i-%s") >=  "' . $end_date . '" and DATE_FORMAT(`created_at`,"%Y-%m-%d") <= "' . $start_date . '" ';
    $sql = $sql . ' order by created_date DESC   ';	
    $result = $mysqli->query($sql);	
	if($result->num_rows > 0) {
		while ($row = $result->fetch_object()) {
			$temp = array();
			$temp['tmn'] = '-' . $row->claimed_credits;
			$temp['timestamp'] = strtotime($row->created_date);
			$temp['sentence'] = 'TMN Claimed successfully. <b>TMN Deducted: -' . $row->claimed_credits . '</b>';
			$temp['type'] = 'Claimed Credits';
			if($row->created_date != '' && $row->created_date != null) {
				if(isset($temp) && !empty($temp) && $temp != null)
				array_push($data[date('Y-m-d', strtotime($row->created_date))], $temp);
			}
		}
	}
	

    $string = '';
    $count = 0;

    $current_date = $start_date;
    while (strtotime($current_date) > strtotime($end_date)) {

        if (sizeof($data[$current_date]) > 0) {
			$counti = 0;
            for ($i = 0; $i < sizeof($data[$current_date]); $i++) {
                $child = $data[$current_date][$i];				
					$string .= '<li class="timeline-inverted">
					  <!--Section Title -->
					  <a href="#!">
						<span class="circle warning-color z-depth-1-half"><i class="fas fa-credit-card"
							aria-hidden="true"></i></span>
					  </a>

					  <!-- Section Description -->
					  <div class="step-content z-depth-1 ml-2 mb-2 p-4">
						<p class="text-muted mt-3"><i class="far fa-clock" aria-hidden="true"></i> ' . date('d M, Y h:i a', ($child['timestamp'])) . '</p>
						<p class=" mt-4 mb-0">' . mb_convert_encoding(stripslashes($child['sentence']), "HTML-ENTITIES", "UTF-8") . '</p>
					  </div>
					</li>';
            }
            $count++;
        }
        $current_date = date('Y-m-d', strtotime($current_date . '-1 day'));
    }

    if ($count == 0 && (strtotime($end_date) <= date('Y-m-d', strtotime('-60 months')))) {
        echo '0';
    } else {
		echo $string;
    }
}