<?php
// $Id$
function list_chapters()
{
	global $user;
	/************************ start approve book details ************************/
	/*$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid = %d ORDER BY id DESC LIMIT 1", $user->uid);
	$proposal_data = db_fetch_object($proposal_q);*/
	$query = db_select('textbook_companion_proposal');
	$query->fields('textbook_companion_proposal');
	$query->condition('uid', $user->uid);
	$query->orderBy('id', 'DESC');
	$query->range(0, 1);
	$result        = $query->execute();
	$proposal_data = $result->fetchObject();
	if (!$proposal_data) {
		drupal_set_message("Please submit a " . l('proposal', 'textbook-companion/proposal') . ".", 'error');
		drupal_goto('');
	} //!$proposal_data
	if ($proposal_data->proposal_status != 1 && $proposal_data->proposal_status != 4) {
		switch ($proposal_data->proposal_status) {
			case 0:
				drupal_set_message(t('We have already received your proposal. We will get back to you soon.'), 'status');
				drupal_goto('');
				return;
				break;
			case 2:
				drupal_set_message(t('Your proposal has been dis-approved. Please create another proposal ' . l('here', 'textbook-companion/proposal') . '.'), 'error');
				drupal_goto('');
				return;
				break;
			case 3:
				drupal_set_message(t('Congratulations! You have completed your last book proposal. You have to create another proposal ' . l('here', 'textbook-companion/proposal') . '.'), 'status');
				drupal_goto('');
				return;
				break;
			default:
				drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
				drupal_goto('');
				return;
				break;
		} //$proposal_data->proposal_status
	} //$proposal_data->proposal_status != 1 && $proposal_data->proposal_status != 4
	
	
	/*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
	$preference_data = db_fetch_object($preference_q);*/
	$query = db_select('textbook_companion_preference');
	$query->fields('textbook_companion_preference');
	$query->condition('proposal_id', $proposal_data->id);
	$query->condition('approval_status', 1);
	$query->range(0, 1);
	$result          = $query->execute();
	$preference_data = $result->fetchObject();
	if ($preference_data->submited_all_examples_code == 1) {
		drupal_set_message(t('You have already submited your all codes for this book to review, hence you can not upload more code, for any query please write us.'), 'status');
		drupal_goto('');
		return;
	} //$preference_data->submited_all_examples_code == 1
	if (!$preference_data) {
		drupal_set_message(t('Invalid Book Preference status. Please contact site administrator for further information.'), 'error');
		drupal_goto('');
		return;
	} //!$preference_data
	/************************ end approve book details **************************/
	$return_html = '<br />';
	$return_html .= '<strong>Title of the Book:</strong><br />' . $preference_data->book . '<br /><br />';
	$return_html .= '<strong>Contributor Name:</strong><br />' . $proposal_data->full_name . '<br /><br />';
	$return_html .= l('Upload Example Code', 'textbook-companion/code/upload') . '<br />';
	/* get chapter list */
	$chapter_rows = array();
	/*$chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d ORDER BY number ASC", $preference_data->id);*/
	$query        = db_select('textbook_companion_chapter');
	$query->fields('textbook_companion_chapter');
	$query->condition('preference_id', $preference_data->id);
	$query->orderBy('number', 'ASC');
	$chapter_q = $query->execute();
	while ($chapter_data = $chapter_q->fetchObject()) {
		/* get example list */
		/* $example_q = db_query("SELECT count(*) as example_count FROM {textbook_companion_example} WHERE chapter_id = %d", $chapter_data->id);
		$example_data = db_fetch_object($example_q);*/
		$query = db_select('textbook_companion_example');
		$query->addExpression('count(*)', 'example_count');
		$query->condition('chapter_id', $chapter_data->id);
		$result         = $query->execute();
		$example_data   = $result->fetchObject();
		$chapter_rows[] = array(
			$chapter_data->number,
			$chapter_data->name . ' (' . l('Edit', 'textbook-companion/code/chapter/edit/' . $chapter_data->id) . ')',
			$example_data->example_count,
			l('View', 'textbook-companion/code/list-examples/' . $chapter_data->id)
		);
	} //$chapter_data = $chapter_q->fetchObject()
	/* check if there are any chapters */
	if (!$chapter_rows) {
		drupal_set_message(t('No uploads found.'), 'status');
		return $return_html;
	} //!$chapter_rows
	$chapter_header = array(
		'Chapter No.',
		'Title of the Chapter',
		'Uploaded Examples',
		'Actions'
	);
	$return_html .= theme('table', array(
		'header' => $chapter_header,
		'rows' => $chapter_rows
	));
	$submited_all_example = drupal_get_form("all_example_submitted_check_form", $preference_data->id);
	$return_html .= drupal_render($submited_all_example);
	return $return_html;
}
function list_examples()
{
	global $user;
	/************************ start approve book details ************************/
	/*$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid = %d ORDER BY id DESC LIMIT 1", $user->uid);
	$proposal_data = db_fetch_object($proposal_q);*/
	$query = db_select('textbook_companion_proposal');
	$query->fields('textbook_companion_proposal');
	$query->condition('uid', $user->uid);
	$query->orderBy('id', 'DESC');
	$query->range(0, 1);
	$result        = $query->execute();
	$proposal_data = $result->fetchObject();
	if (!$proposal_data) {
		drupal_set_message("Please submit a " . l('proposal', 'textbook-companion/proposal') . ".", 'error');
		drupal_goto('');
	} //!$proposal_data
	if ($proposal_data->proposal_status != 1 && $proposal_data->proposal_status != 4) {
		switch ($proposal_data->proposal_status) {
			case 0:
				drupal_set_message(t('We have already received your proposal. We will get back to you soon.'), 'status');
				drupal_goto('');
				return;
				break;
			case 2:
				drupal_set_message(t('Your proposal has been dis-approved. Please create another proposal ' . l('here', 'textbook-companion/proposal') . '.'), 'error');
				drupal_goto('');
				return;
				break;
			case 3:
				drupal_set_message(t('Congratulations! You have completed your last book proposal. You have to create another proposal ' . l('here', 'textbook-companion/proposal') . '.'), 'status');
				drupal_goto('');
				return;
				break;
			default:
				drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
				drupal_goto('');
				return;
				break;
		} //$proposal_data->proposal_status
	} //$proposal_data->proposal_status != 1 && $proposal_data->proposal_status != 4
	/*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
	$preference_data = db_fetch_object($preference_q);*/
	$query = db_select('textbook_companion_preference');
	$query->fields('textbook_companion_preference');
	$query->condition('proposal_id', $proposal_data->id);
	$query->condition('approval_status', 1);
	$query->range(0, 1);
	$result          = $query->execute();
	$preference_data = $result->fetchObject();
	if (!$preference_data) {
		drupal_set_message(t('Invalid Book Preference status. Please contact site administrator for further information.'), 'error');
		drupal_goto('');
		return;
	} //!$preference_data
	/************************ end approve book details **************************/
	/* get chapter details */
	$chapter_id = arg(3);
	/*$chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d AND preference_id = %d LIMIT 1", $chapter_id, $preference_data->id);*/
	$query      = db_select('textbook_companion_chapter');
	$query->fields('textbook_companion_chapter');
	$query->condition('id', $chapter_id);
	$query->condition('preference_id', $preference_data->id);
	$query->range(0, 1);
	$chapter_q = $query->execute();
	if ($chapter_data = $chapter_q->fetchObject()) {
		$return_html = '<br />';
		$return_html .= '<strong>Title of the Book:</strong><br />' . $preference_data->book . '<br /><br />';
		$return_html .= '<strong>Contributor Name:</strong><br />' . $proposal_data->full_name . '<br /><br />';
		$return_html .= '<strong>Chapter Number:</strong><br />' . $chapter_data->number . '<br /><br />';
		$return_html .= '<strong>Title of the Chapter:</strong><br />' . $chapter_data->name . '<br />';
	} //$chapter_data = $chapter_q->fetchObject()
	else {
		drupal_set_message(t('Invalid chapter.'), 'error');
		drupal_goto('textbook-companion/code');
		return;
	}
	$return_html .= '<br />' . l('Back to Chapter List', 'textbook-companion/code');
	/* get example list */
	$example_rows = array();
	$query        = db_select('textbook_companion_example');
	$query->fields('textbook_companion_example');
	$query->condition('chapter_id', $chapter_id);
	$example_q = $query->execute();
	while ($example_data = $example_q->fetchObject()) {
		/* approval status */
		$approval_status = '';
		switch ($example_data->approval_status) {
			case 0:
				$approval_status = 'Pending';
				break;
			case 1:
				$approval_status = 'Approved';
				break;
			case 2:
				$approval_status = 'Rejected';
				break;
		} //$example_data->approval_status
		/* example files */
		$example_files = '';
		/*$example_files_q = db_query("SELECT * FROM {textbook_companion_example_files} WHERE example_id = %d ORDER BY filetype", $example_data->id);*/
		$query         = db_select('textbook_companion_example_files');
		$query->fields('textbook_companion_example_files');
		$query->condition('example_id', $example_data->id);
		$query->orderBy('filetype', 'ASC');
		$example_files_q = $query->execute();
		while ($example_files_data = $example_files_q->fetchObject()) {
			$file_type = '';
			switch ($example_files_data->filetype) {
				case 'S':
					$file_type = 'Main or Source';
					break;
				case 'R':
					$file_type = 'Result';
					break;
				case 'X':
					$file_type = 'xcos';
					break;
				default:
			} //$example_files_data->filetype
			$example_files .= l($example_files_data->filename, 'textbook-companion/download/file/' . $example_files_data->id) . ' (' . $file_type . ')<br />';
		} //$example_files_data = $example_files_q->fetchObject()
		if ($example_data->approval_status == 0) {
			$example_rows[] = array(
				'data' => array(
					$example_data->number,
					$example_data->caption,
					$approval_status,
					$example_files,
					l('Edit', 'textbook-companion/code/edit/' . $example_data->id) . ' | ' . l('Delete', 'textbook-companion/code/delete/' . $example_data->id, array(
						'attributes' => array(
							'onClick' => 'return confirm("Are you sure you want to delete the example?")'
						)
					))
				),
				'valign' => 'top'
			);
		} //$example_data->approval_status == 0
		else {
			$example_rows[] = array(
				'data' => array(
					$example_data->number,
					$example_data->caption,
					$approval_status,
					$example_files,
					l('Download', 'textbook-companion/download/example/' . $example_data->id)
				),
				'valign' => 'top'
			);
		}
	} //$example_data = $example_q->fetchObject()
	$example_header = array(
		'Example No.',
		'Caption',
		'Status',
		'Files',
		'Action'
	);
	$return_html .= theme('table', array(
		'header' => $example_header,
		'rows' => $example_rows
	));
	
	return $return_html;
}
function all_example_submitted_check_form($form, &$form_state, $preference_id)
{
	$form                          = array();
	$form['all_example_submitted'] = array(
		'#type' => 'checkbox',
		'#title' => t('I have submitted codes for all the examples'),
		'#description' => 'Once you have submited this option you are not able to upload more examples.',
		'#required' => TRUE
	);
	$form['hidden_preference_id']  = array(
		'#type' => 'hidden',
		'#value' => $preference_id
	);
	$form['submit']                = array(
		'#type' => 'submit',
		'#value' => t('Submit')
	);
	return $form;
}
function all_example_submitted_check_form_validate($form, &$form_state)
{
	if ($form_state['values']['all_example_submitted'] != 1) {
		form_set_error('all_example_submitted', t('Please check the field if you are intrested to submit the all uploaded examples for review!'));
	} //$form_state['values']['all_example_submitted'] != 1
	return;
}

function all_example_submitted_check_form_submit($form, &$form_state)
{
	global $user;
	if ($form_state['values']['all_example_submitted'] == 1) {
		db_query('UPDATE textbook_companion_preference SET submited_all_examples_code = 1 WHERE id = :preference_id', array(
			':preference_id' => $form_state['values']['hidden_preference_id']
		));
		/* sending email */
		$query                = ("SELECT proposal_id FROM textbook_companion_preference WHERE id= :preference_id");
		$args                 = array(
			":preference_id" => $form_state['values']['hidden_preference_id']
		);
		$proposal_data        = db_query($query, $args);
		$proposal_data_result = $proposal_data->fetchObject();
		
		$email_to                                   = $user->mail;
		$from                                       = variable_get('textbook_companion_from_email', '');
		$bcc                                        = variable_get('textbook_companion_emails', '');
		$cc                                         = variable_get('textbook_companion_cc_emails', '');
		$params['all_code_submitted']['proposal_id'] = $proposal_data_result->proposal_id;
		$params['all_code_submitted']['user_id']     = $user->uid;
		$params['all_code_submitted']['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('textbook_companion', 'all_code_submitted', $email_to, language_default(), $params, $from, TRUE))
			drupal_set_message('Error sending email message.', 'error');
	} //$form_state['values']['all_example_submitted'] == 1
}