<?php


require_once dirname(dirname(__FILE__)) . '/Config/init_project.php';

// Make sure we have all the correct elements needed
if (!(isset($_POST['action']) && isset($_POST['event_id']) && is_numeric($_POST['event_id'])
	&& isset($_POST['record']) && (isset($Proj->metadata[$_POST['field_name']])
		|| (isset($_POST['rule_id']) && (is_numeric($_POST['rule_id']) || preg_match("/pd-\d{1,2}/", $_POST['rule_id'])))))
	&& !(isset($_POST['action']) && isset($_POST['assigned_user_id']) && isset($_POST['status_id'])))
{
	exit('ERROR!');
}

// Decode record (just in case)
$_POST['record'] = html_entity_decode(urldecode($_POST['record']??""), ENT_QUOTES);

// Instantiate DataQuality object
$dq = new DataQuality();

// Get params
$field		= $_POST['field_name']??"";
$record		= label_decode($_POST['record']);
$event_id	= $_POST['event_id']??"";

// Set title of dialog (different based on if using Field Comment Log or DQ Resolution)
$title = '<i class="fas fa-comments"></i> ' .
		 RCView::span(array('style'=>'vertical-align:middle;'),
			($data_resolution_enabled == '1' ? $lang['dataqueries_141'] : $lang['dataqueries_137'])
		 );

// Display data cleaner history table of this field
if ($_POST['action'] == 'view')
{
	if (isset($_POST['existing_record']) && !$_POST['existing_record']) {
		// Set button text needed (DO NOT TRANSLATE)
		$saveAndOpenBtn = ($data_resolution_enabled == '1') ? "Save and then open Field Comment Log" : "Save and then open Data Resolution Pop-up";
		// Set instructions/warning text
		$popupInstr = ($data_resolution_enabled == '1') ? $lang['dataqueries_166'] : $lang['dataqueries_165'];
		// If record has not been saved yet, then give user message to first save the record
		$content = 	RCView::div(array('style'=>'margin:5px 0 25px;'),
						RCView::img(array( 'src'=>'exclamation_orange.png')) .
						RCView::b("{$lang['global_03']}{$lang['colon']} ") . $popupInstr
					) .
					RCView::div(array('style'=>'text-align:right;'),
						RCView::button(array('class'=>"jqbutton", 'style'=>'padding: 0.4em 0.8em !important;margin-right:3px;', 'onclick'=>"
							appendHiddenInputToForm('scroll-top', $(window).scrollTop());
							appendHiddenInputToForm('dqres-fld','$field');
							dataEntrySubmit(this);return false;"), $saveAndOpenBtn
						) .
						RCView::button(array('class'=>"jqbutton", 'style'=>'padding: 0.4em 0.8em !important;', 'onclick'=>"$('#data_resolution').dialog('close');"), $lang['global_53'])
					);
		$title = ($data_resolution_enabled == '1') ? $lang['dataqueries_168'] : $lang['dataqueries_167'];
	} else {
		// Display the full history of this record's field + form for adding more comments/data queries
		$content = $dq->displayFieldDataResHistory($record, $event_id, $field, $_POST['rule_id'], $_GET['instance']);
	}
	## Output JSON
    header("Content-Type: application/json");
	print json_encode_rc(array('content'=>$content, 'title'=>$title));
}


// Save new data cleaner values for this field
elseif ($_POST['action'] == 'save')
{
	// Determine the status to set
	if (in_array($_POST['status'], array('OPEN','CLOSED','VERIFIED','DEVERIFIED'))) {
		$dr_status = $_POST['status'];
	} elseif ((isset($_POST['response_requested']) && $_POST['response_requested'])
			|| (isset($_POST['response']) && $_POST['response'])) {
		$dr_status = 'OPEN';
	} else {
		$dr_status = '';
	}

	// Set subquery for rule_id/field
	$rule_id = "";
	$non_rule = ($field == '') ? "" : "1";
	if (is_numeric($_POST['rule_id'])) {
		// Determine if custom rule contains one field in logic
		$ruleContainsOneField = $dq->ruleContainsOneField($_POST['rule_id']);
		if ($ruleContainsOneField !== false) {
			// Custom rule with one field in logic (so consider it rule-less as field-level)
			$field = $ruleContainsOneField;
			$non_rule = "1";
		} else {
			// Custom rule-level (multiple fields)
			$rule_id = $_POST['rule_id'];
			$non_rule = "";
		}
	}

	// If any files were uploaded but deleted before final submission, then make sure we delete these from the edocs table
	if (isset($_POST['delete_doc_id']) && $_POST['delete_doc_id'] != '')
	{
		$delete_docs_ids = explode(",", $_POST['delete_doc_id']);
		// Delete from table (i.e. set delete field to NOW)
		$sql = "update redcap_edocs_metadata set delete_date = '".NOW."' where project_id = " . PROJECT_ID . "
				and delete_date is null and doc_id in (" . prep_implode($delete_docs_ids) . ")";
		db_query($sql);
	}

	// If query was just closed BUT a file was uploaded in the response, then delete that file
	if ($dr_status == 'CLOSED' && isset($_POST['upload_doc_id']) && is_numeric($_POST['upload_doc_id']))
	{
		// Delete from table (i.e. set delete field to NOW)
		$sql = "update redcap_edocs_metadata set delete_date = '".NOW."' where project_id = " . PROJECT_ID . "
				and delete_date is null and doc_id = '" . db_escape($_POST['upload_doc_id']) . "'";
		db_query($sql);
	}

    // Get current form and repeat form
    $form_name = $_POST['form_name'] ?? "";
    $repeat_instrument = $Proj->isRepeatingForm($event_id, $form_name) ? $form_name : null;

	// Insert new or update existing
	$sql = "insert into redcap_data_quality_status (rule_id, non_rule, project_id, record, event_id, field_name, repeat_instrument, query_status, assigned_user_id, instance)
			values (".checkNull($rule_id).", ".checkNull($non_rule).", " . PROJECT_ID . ", '" . db_escape($record) . "',
			$event_id, " . checkNull($field) . ", " . checkNull($repeat_instrument) . ", ".checkNull($dr_status).", ".checkNull($_POST['assigned_user_id']).", '" . db_escape($_GET['instance']) . "')
			on duplicate key update query_status = ".checkNull($dr_status).", status_id = LAST_INSERT_ID(status_id)";
	if (db_query($sql))
	{
		// Get cleaner_id
		$status_id = db_insert_id();
		// Get current user's ui_id
		$userInitiator = User::getUserInfo(USERID);
		// Add new row to data_resolution_log
		$sql = "insert into redcap_data_quality_resolutions (status_id, ts, user_id, response_requested,
				response, comment, current_query_status, upload_doc_id)
				values ($status_id, '".NOW."', ".checkNull($userInitiator['ui_id']).",
				".checkNull($_POST['response_requested']).", ".checkNull($_POST['response']).",
				".checkNull(trim(label_decode($_POST['comment']))).", ".checkNull($dr_status).", ".checkNull($_POST['upload_doc_id']).")";
		if (db_query($sql)) {
			// Success, so return content via JSON to redisplay with new changes made
			$res_id = db_insert_id();
			## SET RETURN ELEMENTS
			// Set balloon icon
			if ($dr_status == 'OPEN' && $_POST['response'] == '') {
				$icon = 'balloon_exclamation.gif';
				if ($_POST['send_back']) {
					$drw_log = "Send data query back for further attention";
				} elseif ($_POST['reopen_query']) {
					$drw_log = "Reopen data query";
				} else {
					$drw_log = "Open data query";
				}
			} elseif ($dr_status == 'OPEN' && $_POST['response'] != '') {
				$icon = 'balloon_exclamation_blue.gif';
				$drw_log = "Respond to data query";
			} elseif ($dr_status == 'CLOSED') {
				$icon = 'balloon_tick.gif';
				$drw_log = "Close data query";
			} elseif ($dr_status == 'VERIFIED') {
				$icon = 'tick_circle.png';
				$drw_log = "Verified data value";
			} elseif ($dr_status == 'DEVERIFIED') {
				$icon = 'exclamation_red.png';
				$drw_log = "De-verified data value";
			} else {
				$icon = 'balloon_left.png';
				$drw_log = "Add field comment";
			}
			// Get total number of open data issues
			$queryStatuses = $dq->countDataResIssues();
			$issuesOpen = $queryStatuses['OPEN'];
			// Get number of comments that this issue current has
            $instance = ($repeat_instrument != '' || $Proj->isRepeatingEvent($event_id)) ? $_GET['instance'] : null;
			$dataIssuesThisRecordEvent = $dq->getDataIssuesByRule($_POST['rule_id'], $record, $event_id, $repeat_instrument, $instance);
			$num_comments = ($field == '') ? $dataIssuesThisRecordEvent[$record][$event_id][$repeat_instrument??""][$_GET['instance']]['num_comments']
										   : $dataIssuesThisRecordEvent[$record][$event_id][$field][$repeat_instrument??""][$_GET['instance']]['num_comments'];
			## Output JSON
			print json_encode_rc(array('res_id'=>$res_id, 'icon'=>APP_PATH_IMAGES.$icon,
				  'num_issues'=>$issuesOpen, 'num_comments'=>$num_comments, 'title'=>$title, 'tsNow'=>DateTimeRC::format_ts_from_ymd(NOW),
				  'data_resolution_enabled'=>$data_resolution_enabled));
			## Logging
			$logDataValues = json_encode_rc(array('res_id'=>$res_id,'record'=>$record,'event_id'=>$event_id,
								'field'=>$field,'rule_id'=>$_POST['rule_id'],'comment'=>trim(label_decode($_POST['comment']))));
			// Set event_id in query string for logging purposes only
			$_GET['event_id'] = $event_id;
			// Log it
			Logging::logEvent($sql,"redcap_data_quality_resolutions","MANAGE",$record,$logDataValues,$drw_log);
			// Email/Messenger notifications (if applicable)
			$notifyViaEmail = (isset($_POST['assigned_user_id_notify_email']) && $_POST['assigned_user_id_notify_email'] == '1');
			$notifyViaMessenger = ($GLOBALS['user_messaging_enabled'] == 1 && isset($_POST['assigned_user_id_notify_messenger']) && $_POST['assigned_user_id_notify_messenger'] == '1');
			if (isinteger($_POST['assigned_user_id']) && ($notifyViaEmail || $notifyViaMessenger)) {
				$assignedUserInfo = User::getUserInfoByUiid($_POST['assigned_user_id']);
				// Link to auto-open the data query
				$query_link = APP_PATH_WEBROOT_FULL . "redcap_v" . REDCAP_VERSION . "/DataQuality/resolve.php?pid=" . PROJECT_ID . "&status_type=&assigned_user_id={$_POST['assigned_user_id']}&status_id=$status_id";
				if ($notifyViaEmail) {
					// Send email
					if (isset($assignedUserInfo['user_email']) && isEmail($assignedUserInfo['user_email'])) {
						$email_body = $lang['global_21'] . "<br /><br />"
							. $lang['dataqueries_319'] . " \"" . RCView::a(array('href' => APP_PATH_WEBROOT_FULL . "redcap_v" . REDCAP_VERSION . "/index.php?pid=" . PROJECT_ID), strip_tags($app_title)) . "\"" . $lang['period']
							. "<br /><br />" . RCView::a(array('href' => $query_link), $lang['dataqueries_320']);
						REDCap::email($assignedUserInfo['user_email'], $user_email, "[REDCap] " . $lang['dataqueries_318'], $email_body);
					}
				}
				if ($notifyViaMessenger) {
					// Send message via Messenger
					Messenger::createNewConversation($lang['dataqueries_321'], $lang['dataqueries_319']." \"<b>".strip_tags($app_title)."</b>\"".$lang['period']."<br><br>".$lang['dataqueries_320'].$lang['colon']." $query_link", UI_ID, $assignedUserInfo['username'].",".USERID, PROJECT_ID);
				}
			}
		} else {
			// ERROR!
			exit('0');
		}
	}
}


// Reassign data query to other user
elseif ($_POST['action'] == 'reassign' && isset($_POST['assigned_user_id']) && isinteger($_POST['assigned_user_id']) && isset($_POST['status_id']) && isinteger($_POST['status_id']))
{
	// Get values of status_id
	$sql = "select record, event_id, field_name, rule_id, assigned_user_id from redcap_data_quality_status 
			where project_id = " . PROJECT_ID . " and status_id = '{$_POST['status_id']}'";
	$q = db_query($sql);
	$record = db_result($q, 0, 'record');
	$event_id = db_result($q, 0, 'event_id');
	$field_name = db_result($q, 0, 'field_name');
	$rule_id = db_result($q, 0, 'rule_id');
	$old_assigned_user_id = db_result($q, 0, 'assigned_user_id');
	// Insert new or update existing
	$sql = "update redcap_data_quality_status
	 		set assigned_user_id = '{$_POST['assigned_user_id']}'
	 		where project_id = " . PROJECT_ID . " and status_id = '{$_POST['status_id']}'";
	if (db_query($sql))
	{
		## Logging
		$logDataValues = array('record'=>$record,'event_id'=>$event_id);
		if ($field_name != '') $logDataValues['field'] = $field_name;
		if ($rule_id != '') $logDataValues['rule_id'] = $rule_id;
		$logDataValues = json_encode_rc($logDataValues);
		// Log it
		$_GET['event_id'] = $event_id;
		Logging::logEvent($sql,"redcap_data_quality_resolutions","MANAGE",$record,$logDataValues,($old_assigned_user_id == '' ? "Assign data query to user" : "Reassign data query to other user"));
		// Email/Messenger notifications (if applicable)
		$notifyViaEmail = (isset($_POST['assigned_user_id_notify_email']) && $_POST['assigned_user_id_notify_email'] == '1');
		$notifyViaMessenger = ($GLOBALS['user_messaging_enabled'] == 1 && isset($_POST['assigned_user_id_notify_messenger']) && $_POST['assigned_user_id_notify_messenger'] == '1');
		if (isinteger($_POST['assigned_user_id']) && ($notifyViaEmail || $notifyViaMessenger)) {
			// Link to auto-open the data query
			$query_link = APP_PATH_WEBROOT_FULL . "redcap_v" . REDCAP_VERSION . "/DataQuality/resolve.php?pid=" . PROJECT_ID . "&status_type=&assigned_user_id={$_POST['assigned_user_id']}&status_id=$status_id";
			if ($notifyViaEmail) {
				// Send email
				$assignedUserInfo = User::getUserInfoByUiid($_POST['assigned_user_id']);
				if (isset($assignedUserInfo['user_email']) && isEmail($assignedUserInfo['user_email'])) {
					$email_body = $lang['global_21'] . "<br /><br />"
						. $lang['dataqueries_319'] . " \"" . RCView::a(array('href' => APP_PATH_WEBROOT_FULL . "redcap_v" . REDCAP_VERSION . "/index.php?pid=" . PROJECT_ID), strip_tags($app_title)) . "\"" . $lang['period']
						. "<br /><br />" . RCView::a(array('href' => $query_link), $lang['dataqueries_320']);
					REDCap::email($assignedUserInfo['user_email'], $user_email, "[REDCap] " . $lang['dataqueries_318'], $email_body);
				}
			}
			if ($notifyViaMessenger) {
				// Send message via Messenger
				Messenger::createNewConversation($lang['dataqueries_321'], $lang['dataqueries_319']." \"<b>".strip_tags($app_title)."</b>\"".$lang['period']."<br><br>".$lang['dataqueries_320'].$lang['colon']." $query_link", UI_ID, USERID, PROJECT_ID);
			}
		}
		exit('1');
	}
	exit('0');
}