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

$requestData = $_REQUEST;

$columns = array(
    0 => 'T2.original_message',
);
$user_id = $_SESSION['tm_id'];

$sql = 'select T2.id as sentence_id, T1.updated_at, T1.suggestion, T2.original_message, T2.translated_message, T2.suggestion_count from tbl_sentence_marketing as T2
LEFT JOIN tbl_user_suggestion_marketing_mapping as T1 on T1.sentence_id = T2.id 
LEFT JOIN languages T3 ON T1.category_id = T3.id
LEFT JOIN tbl_translators T4 ON T1.user_id = T4.id
where 1';

if (isset($_POST['category_id']) && $_POST['category_id'] > 0) {
    $sql.= ' and T1.category_id = ' . $_POST['category_id'];
}
$sql.= ' AND T2.paragraph_id =  "'.$_POST['id'].'"';
if (!empty($requestData['search']['value'])) {   // if there is a search parameter, $requestData['search']['value'] contains search parameter
    $sql .=" and (T2.original_message LIKE '%" . $requestData['search']['value'] . "%') ";
}
$sql .= ' AND T2.suggestion_count < 3 AND T2.id NOT IN (select sentence_id from tbl_user_suggestion_marketing_mapping where user_id = "' . $user_id . '" AND paragraph_id = "'.$_POST['id'].'")';
$sql .= ' GROUP BY T2.id';

$result = $mysqli->query($sql);

$totalData = $result->num_rows;
$totalFiltered = $totalData;
$sql.= " ORDER BY T2.sequence ". " LIMIT " . $requestData['start'] . " ," . $requestData['length'] . "   ";

$result = $mysqli->query($sql);
$data = array();
if($result->num_rows > 0) {
	while ($row = $result->fetch_object()) {
		$nestedData = array();
		$winning_credits = 0;
		$nestedData['id'] = $row->sentence_id;
		$nestedData['original_message'] =  '<span id="ossentence_id'.$row->sentence_id.'">'.mb_convert_encoding(stripslashes($row->original_message), "HTML-ENTITIES", "UTF-8").'</span>';
		$nestedData['translated_suggestion'] = mb_convert_encoding(stripslashes($row->suggestion), "HTML-ENTITIES", "UTF-8");	
		$str_suggestion = '';
		$str_suggestion .= '<div class="slider">';
		
		$str_suggestion .= '<div class="form-group">
			<label><strong>Machine Translated Message</strong></label><br>
			<span id="machine_suggestion'.$row->sentence_id.'">'.mb_convert_encoding(stripslashes($row->translated_message), "HTML-ENTITIES", "UTF-8").'</span>
			<br><br>
			<label><strong>Suggest a better translation</strong></label>
			<textarea class="form-control suggestion-text" rows="5" placeholder="Your Suggestion" name="suggestion'.$row->sentence_id.'" id="suggestion'.$row->sentence_id.'" data-id="'.$row->sentence_id.'">'.mb_convert_encoding(stripslashes($row->translated_message), "HTML-ENTITIES", "UTF-8").'</textarea>
		</div>';
		$str_suggestion .= '<div class="display-flex mobile-justify-center">
			<button type="button" disabled data-id="'.$row->sentence_id.'" class="btn btn-sm btn-save btn-save'.$row->sentence_id.' btn-success waves-effect waves-light">Save</button>
		</div>';
		$str_suggestion .= '</div>';
		$nestedData['suggestion'] = $str_suggestion;
		$data[] = $nestedData;
	}
}

$json_data = array(
    "draw" => intval($requestData['draw']), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw. 
    "recordsTotal" => intval($totalData), // total number of records
    "recordsFiltered" => intval($totalFiltered), // total number of records after searching, if there is no searching then totalFiltered = totalData
    "data" => $data, // total data array
    "data1" => $requestData['start'], // total data array
    "data2" => $requestData['length'], // total data array
//    "data3"            => $draw   // total data array
);

echo json_encode($json_data);  // send data as json format