<?php
/******************************************************************************/
/****************************** DELETION FUNCTIONS ****************************/
/******************************************************************************/
function om_pssp_abstract_delete_project($proposal_id)
{
	$status = TRUE;
	$root_path = om_pssp_path();
	$query = db_select('om_pssp_proposal');
	$query->fields('om_pssp_proposal');
	$query->condition('id', $proposal_id);
	$proposal_q = $query->execute();
	$proposal_data = $proposal_q->fetchObject();
	if (!$proposal_data)
	{
		drupal_set_message('Invalid power system simulation Project.', 'error');
		return FALSE;
	} //!$proposal_data
	$query = db_select('om_pssp_submitted_abstracts_file');
	$query->fields('om_pssp_submitted_abstracts_file');
	$query->condition('proposal_id', $proposal_id);
	$abstract_q = $query->execute();
	$dir_project_files = $root_path . $proposal_data->directory_name . '/project_files';
	while ($abstract_data = $abstract_q->fetchObject())
	{
		if (is_dir($dir_project_files)){

		unlink($root_path . $proposal_data->directory_name . '/project_files/' . $abstract_data->filepath);
		}
		else
		{
			drupal_set_message('Invalid power system simulation project abstract.', 'error');
		}
		db_delete('om_pssp_submitted_abstracts_file')->condition('proposal_id', $proposal_id)->execute();
		//!om_pssp_delete_abstract_file($abstract_data->id)
	}
	$res = rmdir($root_path . $proposal_data->directory_name . '/project_files');
	$dir_path_udc = $root_path . $proposal_data->directory_name;
	if (is_dir($dir_path_udc))
	{
		unlink($root_path . $proposal_data->samplefilepath);
		$res = rmdir($dir_path_udc);
	} //is_dir($dir_path_udc)
	db_delete('om_pssp_proposal')->condition('id', $proposal_data->id)->execute();
	
	db_delete('om_pssp_submitted_abstracts')->condition('proposal_id', $proposal_id)->execute();
	return $status;
}
/*function om_pssp_delete_abstract_file($abstract_id)
{
	//var_dump($abstract_id);die;
	$status = TRUE;
	$root_path = om_pssp_path();
	$abstract_q = db_query("SELECT * from om_pssp_proposal dfp
LEFT JOIN om_pssp_submitted_abstracts dfsa ON dfp.id = dfsa.proposal_id
WHERE dfsa.id = :abstract_id", array(
		":abstract_id" => $abstract_id
	));
	$abstract_data = $abstract_q->fetchObject();
	if (!$abstract_data)
	{
		drupal_set_message('Invalid power system simualation project abstract.', 'error');
		return FALSE;
	} //!$abstract_data
	/* deleting solutions */
	/*$query = db_select('om_pssp_submitted_abstracts_file');
	$query->fields('om_pssp_submitted_abstracts_file');
	$query->condition('submitted_abstract_id', $abstract_id);
	$abstract_f_q = $query->execute();
	$delete_project_folder = FALSE;
	while ($abstract_f_data = $abstract_f_q->fetchObject())
	{
		$delete_project_folder = TRUE;
		if (!_om_pssp_delete_abstract_file($abstract_f_data->id))
			$status = FALSE;
	} //$abstract_f_data = $abstract_f_q->fetchObject()
	if (!$delete_project_folder)
	{
		return TRUE;
	} //!$delete_project_folder
	if ($status)
	{
		$dir_path_udc = $root_path . $abstract_f_data->directory_name;
		if (is_dir($dir_path_udc))
		{
			unlink($root_path . $abstract_f_data->samplefilepath);
			//$res = rmdir($dir_path_udc);
			/*if (!$res)
			{
				drupal_set_message(t('Error in deleting user defiend folder !folder', array(
					'!folder' => $abstract_f_data->directory_name
				)), 'error');
				/* sending email to admins */
			/*	$email_to = variable_get('om_pssp_emails', '');
				$from = variable_get('om_pssp_from_email', '');
				$bcc = "";
				$cc = variable_get('om_pssp_cc_emails', '');
				$params['standard']['subject'] = "[ERROR] Error deleting experiment folder";
				$params['standard']['body'] = "Error deleting folder " . $dir_path;
				$params['standard']['headers'] = array(
					'From' => $from,
					'MIME-Version' => '1.0',
					'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
					'Content-Transfer-Encoding' => '8Bit',
					'X-Mailer' => 'Drupal',
					'Cc' => $cc,
					'Bcc' => $bcc
				);
				if (!drupal_mail('om_pssp', 'standard', $email_to, language_default(), $params, $from, TRUE))
					drupal_set_message('Error sending email message.', 'error');
				return FALSE;
			} //!$res
			else
			{
				return TRUE;
			}
		}*/ //is_dir($dir_path_udc)
	/*} //$status
	return FALSE;
}
}
function _om_pssp_delete_abstract_file($abstract_id)
{
	global $user;
	$root_path = om_pssp_path();
	$query = db_select('om_pssp_proposal');
	$query->fields('om_pssp_proposal');
	$query->condition('id', $abstract_id);
	$abstract_q = $query->execute();
	$abstract_data = $abstract_q->fetchObject();
	$abstract_q = db_query("SELECT * from om_pssp_proposal dfp
LEFT JOIN om_pssp_submitted_abstracts dfsa ON dfp.id = dfsa.proposal_id
WHERE dfsa.id = :abstract_id", array(
		":abstract_id" => $abstract_id
	));
	$abstract_data = $abstract_q->fetchObject();
	if (!$abstract_data)
	{
		drupal_set_message('Invalid power system simulation project abstract.', 'error');
		return FALSE;
	} //!$abstract_data
	/* deleting abstract files 
	$query = db_select('om_pssp_submitted_abstracts_file');
	$query->fields('om_pssp_submitted_abstracts_file');
	$query->condition('submitted_abstract_id', $abstract_id);
	$abstract_f_q = $query->execute();
	while ($abstract_f_data = $abstract_f_q->fetchObject())
	{
		unlink($root_path . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath);
		$res = rmdir($root_path . $abstract_data->directory_name . '/project_files');
		/*if (!file_exists($root_path . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath))
		{
			$status = FALSE;
			drupal_set_message(t('Error deleting !file. File does not exists.', array(
				'!file' => $abstract_data->directory_name . '/project_files' . $abstract_f_data->filepath
			)), 'error');
			continue;
		} //!file_exists($root_path . $abstract_data->directory_name . '/' . $abstract_f_data->filepath)
		/* removing solution file */
		/*if (!unlink($root_path . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath))
		{
			$status = FALSE;
			drupal_set_message(t('Error deleting !file', array(
				'!file' => $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath
			)), 'error');
			/* sending email to admins */
		/*	$from = variable_get('om_pssp_from_email', '');
			$bcc = variable_get('om_pssp_emails', '');
			$cc = variable_get('om_pssp_cc_emails', '');
			$params['standard']['subject'] = "[ERROR] Error deleting example file";
			$params['standard']['body'] = "Error deleting solution files by " . $user->uid . " at " . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'] . " :
        file id : " . $abstract_data->id . "
        file path : " . $abstract_data->directory_name . '/project_files/' . $abstract_f_data->filepath;
			$params['standard']['headers'] = array(
				'From' => $from,
				'MIME-Version' => '1.0',
				'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
				'Content-Transfer-Encoding' => '8Bit',
				'X-Mailer' => 'Drupal',
				'Cc' => $cc,
				'Bcc' => $bcc
			);
			if (!drupal_mail('om_pssp', 'standard', $email_to, language_default(), $params, $from, TRUE))
				drupal_set_message('Error sending email message.', 'error');
		} *///!unlink($root_path . $abstract_data->directory_name . '/' . $abstract_f_data->filepath)
		
/*	} 
			/* deleting example files database entries */
			//db_delete('om_pssp_submitted_abstracts_file')->condition('id', $abstract_f_data->id)->execute();//$abstract_f_data = $abstract_f_q->fetchObject()
/*	if (!$status)
	{
		return FALSE;
	} //!$status
	return $status;
}*/