Merge pull request #1 from prashantsinalkar/master

added certificate and other changes

1 files changed, 329 insertions, 399 deletions

diff --git a/general.inc b/general.inc
index 5c79e92..41bb7c1 100755
--- a/general.inc
+++ b/general.inc
@@ -1,408 +1,338 @@
 <?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('');
-      }
-    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;
-case 5:
-      drupal_set_message(t('You have submitted your all examples.'), 'status');
-      drupal_goto('');
-      return;
-            default:
-                drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
-                drupal_goto('');
-                return;
-                break;
-        }
-      }
-      
-      
-    /*$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;
-      }
-    /************************ 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)
-        );
-      }
-    /* check if there are any chapters */
-    if (!$chapter_rows)
-      {
-        drupal_set_message(t('No uploads found.'), 'status');
-        return $return_html;
-      }
-    $chapter_header = array(
-        'Chapter No.',
-        'Title of the Chapter',
-        'Uploaded Examples',
-        'Actions'
-    );
-    $return_html .= theme('table', array(
-        'header' => $chapter_header,
-        'rows' => $chapter_rows
-    ));
-     $submit_all_code_form = drupal_get_form('submit_all_code_form',$proposal_data->id, $preference_data->id);
-    $return_html .= drupal_render($submit_all_code_form);
-    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('');
-      }
-    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;
-case 5:
-      drupal_set_message(t('You have submitted your all codes.'), 'status');
-      drupal_goto('');
-      return;
-
-            default:
-                drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
-                drupal_goto('');
-                return;
-                break;
-        }
-      }
-    /*$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;
-      }
-    /************************ 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 />';
-      }
-    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 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 .= l($example_files_data->filename, 'textbook-companion/download/file/' . $example_files_data->id) . ' (' . $file_type . ')<br />';
-          }
-        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'
-            );
-          }
-        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_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;
+{
+	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 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', '');
-    $param['all_code_submitted']['proposal_id'] = $proposal_data_result->proposal_id;
-    $param['all_code_submitted']['user_id'] = $user->uid;
-    $param['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(), $param, $from, TRUE))
-        drupal_set_message('Error sending email message.', 'error');
+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 submit_all_code_form($form,&$form_state,$proposal_id,$preference_id){
-$form = array();
-$form['submit_all_code'] = array(
-    '#type' => 'checkbox',
-    '#title' => t('I have uploaded all the codes'),
-    '#description' => 'Once you have submited this option you are not able to upload more examples.',
-            '#required' => TRUE,
-);
-$form['prop_id'] = array(
-    '#type' => 'hidden',
-    '#value' => $proposal_id
-);
-$form['pref_id'] = array(
-    '#type' => 'hidden',
-    '#value' => $preference_id
-);
-
-$form['submit'] = array(
-    '#type' => 'submit',
-    '#value' => t('Submit')
-  );
-
-  $form['cancel'] = array(
-    '#type' => 'markup',
-    '#value' => l(t('Cancel'), 'textbook-companion/code'),
-  );
-  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 submit_all_code_form_submit($form,&$form_state){
-global $user;
-if($form_state['values']['submit_all_code']== 1){      
-db_query('UPDATE textbook_companion_proposal SET proposal_status = 5 WHERE id = :id', array(":id" =>$form_state['values']['prop_id']));
-/* sending email */
- $query = ("SELECT proposal_id FROM textbook_companion_preference WHERE id= :preference_id");
- $args = array(":preference_id" => $form_state['values']['pref_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');
+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
 }
-
-}