<?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('memory_limit', '-1');

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

$requestData = $_REQUEST;

$columns = array(
	0 => 'document_name',
	1 => 'original_language',
	2 => 'translated_language',
	5 => 'sentences',
	6 => 'updated_at',
);

$user_id = $_SESSION['tm_id'];
$sql = 'SELECT d.*, ol.name as original_language, tl.name as translated_language FROM `tbl_documents` d 
LEFT JOIN `tbl_user_documents` ud ON ud.document_id = d.id
LEFT JOIN languages ol ON d.original_language_id = ol.id
LEFT JOIN languages tl ON d.translated_language_id = tl.id WHERE 1 ';
$sql .= ' AND ud.user_id = "'.$user_id.'"';

$sql.= ' GROUP BY d.id';

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

$totalData = $result->num_rows;
$totalFiltered = $totalData;

$sql.= " ORDER BY " . $columns[$requestData['order'][0]['column']] . " " . $requestData['order'][0]['dir'] . " LIMIT " . $requestData['start'] . " ," . $requestData['length'] . "   ";

$result = $mysqli->query($sql);
$data = array();
$count = 1;

while ($row = $result->fetch_object()) {
    $sent_text = ' Sentences';
    $nestedData = array();
    $nestedData[] = mb_convert_encoding(stripslashes($row->document_name), "HTML-ENTITIES", "UTF-8");
	$nestedData[] = $row->original_language;
	$nestedData[] = $row->translated_language;	
	$nestedData[] = '<a data-toggle="modal" data-target="#modalDocument" class="view-document" data-dtype="0" data-id="' . $row->id . '">View</a>';
	$sql1 = 'SELECT T1.*, T2.name FROM `tbl_user_documents` as T1 LEFT JOIN tbl_translators as T2 on T1.user_id = T2.id WHERE T1.document_id = ' . $row->id . ' GROUP BY id ORDER BY T1.created_at DESC';
	$result1 = $mysqli->query($sql1);
	if($result1->num_rows > 0) {
		while ($row1 = $result1->fetch_object()) {
			$nestedData[] = '<a data-toggle="modal" data-target="#modalDocument" class="view-document" data-dtype="1" data-id="' . $row1->id . '">View</a>';			
		}
	} else {
		$nestedData[] = '-';
	}
	$nestedData[] = $row->sentences;
	$nestedData[] =  date('d M, Y h:i a', strtotime($row->updated_at));
	$count++;
    $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
);

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