<?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($_SESSION['tm_id'])) {
	if (isset($_POST['paragraph_id'])) {
		$locked_user_id = 0;
		$is_lock = 0;
		$sql = 'select * FROM tbl_paragraphs WHERE id = "' . $_POST['paragraph_id'].'"';	
		$result = $mysqli->query($sql);	 
		if ($result->num_rows > 0) {
			while ($row = $result->fetch_object()) {
				$is_lock = $row->is_lock;
				$locked_user_id = $row->locked_user_id;
			}
		}
		if(($locked_user_id == 0 && $is_lock == 0) || ($locked_user_id == $_SESSION['tm_id'] && $is_lock == 1)) {
			$sqlUpdateS = 'UPDATE `tbl_paragraphs` SET is_lock = 1, locked_user_id = "'.$_SESSION['tm_id'].'", locked_at = NOW() where id = "' . $_POST['paragraph_id'].'" AND locked_user_id = "'.$_SESSION['tm_id'].'"';
			$resultUpdateS = $mysqli->query($sqlUpdateS);
			echo json_encode(array("status" => "200", "msg" => 'Saved.'));
		} else {
			echo json_encode(array("status" => "500", "msg" => 'Job is opened by another user.'));
		}		
	} else {
		echo json_encode(array("status" => "300", "msg" => 'Something went wrong, Please try again.'));
	}
} else {
    echo json_encode(array("status" => "700"));
}