Merge pull request #3 from prashantsinalkar/drupal_7.x

modifed interface as per the requirement

1 files changed, 491 insertions, 413 deletions

diff --git a/run.inc b/run.inc
index 1ff73f1..28d135c 100755
--- a/run.inc
+++ b/run.inc
@@ -1,505 +1,583 @@
-<?php 
-
-		function textbook_companion_run_form($form, &$form_state) {
-		$url_book_pref_id = (int)arg(1);
-		
-		if($url_book_pref_id){
-				$query = db_select('textbook_companion_preference');
-				$query->fields('textbook_companion_preference', array('category'));
-				$query->condition('id', $url_book_pref_id);
-				$result = $query->execute()->fetchObject();
-				$category_default_value = $result->category;
-				}else{
-				$category_default_value = 0;
-				}
-		if($url_book_pref_id){
+<?php
+function textbook_companion_run_form($form, &$form_state)
+{
+	$url_book_pref_id = (int) arg(1);
+	if ($url_book_pref_id)
+	{
+		$query = db_select('textbook_companion_preference');
+		$query->fields('textbook_companion_preference', array(
+			'category'
+		));
+		$query->condition('id', $url_book_pref_id);
+		$result = $query->execute()->fetchObject();
+		$category_default_value = $result->category;
+	} //$url_book_pref_id
+	else
+	{
+		$category_default_value = 0;
+	}
+	if ($url_book_pref_id)
+	{
 		$form['category'] = array(
 			'#type' => 'select',
 			'#title' => t('Category'),
 			'#options' => _list_of_category(),
 			'#default_value' => $category_default_value,
 			'#ajax' => array(
-				'callback' => 'ajax_book_list_callback',
+				'callback' => 'ajax_book_list_callback'
 			),
-			'#validated' => TRUE,
+			'#validated' => TRUE
 		);
 		$book_default_value = $url_book_pref_id;
 		$form['book'] = array(
 			'#type' => 'select',
 			'#title' => t('Title of the book'),
-			'#options' =>  _list_of_books($category_default_value),
-			'#default_value' =>  $book_default_value,
+			'#options' => _list_of_books($category_default_value),
+			'#default_value' => $book_default_value,
 			'#prefix' => '<div id="ajax-book-list-replace">',
 			'#suffix' => '</div>',
 			'#ajax' => array(
-				'callback' => 'ajax_chapter_list_callback',
-				),
+				'callback' => 'ajax_chapter_list_callback'
+			),
 			'#validated' => TRUE,
-			'#states' => array('invisible' => array(':input[name="category"]' => array('value' => 0),),),  
+			'#states' => array(
+				'invisible' => array(
+					':input[name="category"]' => array(
+						'value' => 0
+					)
+				)
+			)
 		);
 		/*$form['book_details'] = array(
-			'#prefix' => '<div id="ajax-book-details-replace"></div>',
-			'#suffix' => '</div>',
-			'#markup' => '',
-				
+		'#prefix' => '<div id="ajax-book-details-replace"></div>',
+		'#suffix' => '</div>',
+		'#markup' => '',
+		
 		);*/
 		$form['book_details'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-book-details-replace">'._html_book_info($book_default_value).'</div>',
-      );
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-book-details-replace">' . _html_book_info($book_default_value) . '</div>'
+		);
 		$form['download_book'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-book-replace">'.l('Download', 'download/book/' . $book_default_value) . ' ' . t('(Download the Scilab codes for all the solved examples)').'</div>',
-      );
-      $form['download_pdf'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-book-pdf-replace">'.l('Download PDF', 'textbook_companion/generate_book/' . $book_default_value) . ' ' . t('(Download the PDF file containing Scilab codes for all the solved examples)').'</div>',
-      );
-		
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-book-replace">' . l('Download', 'download/book/' . $book_default_value) . ' ' . t('(Download the Scilab codes for all the solved examples)') . '</div>'
+		);
+		$form['download_pdf'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-book-pdf-replace">' . l('Download PDF', 'textbook_companion/generate_book/' . $book_default_value) . ' ' . t('(Download the PDF file containing Scilab codes for all the solved examples)') . '</div>'
+		);
 		$form['chapter'] = array(
 			'#type' => 'select',
 			'#title' => t('Title of the chapter'),
-			'#options' =>  _list_of_chapters($book_default_value),
+			'#options' => _list_of_chapters($book_default_value),
 			//'#default_value' => isset($form_state['values']['chapter']) ? $form_state['values']['chapter'] : '',
 			'#prefix' => '<div id="ajax-chapter-list-replace">',
 			'#suffix' => '</div>',
 			'#ajax' => array(
-				'callback' => 'ajax_example_list_callback',
-				),
+				'callback' => 'ajax_example_list_callback'
+			),
 			'#validated' => TRUE,
-			'#states' => array('invisible' => array(':input[name="category"]' => array('value' => 0),),),  
+			'#states' => array(
+				'invisible' => array(
+					':input[name="category"]' => array(
+						'value' => 0
+					)
+				)
+			)
 		);
-		
 		$form['download_chapter'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-chapter-replace"></div>',
-      );
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-chapter-replace"></div>'
+		);
 		$example_default_value = isset($form_state['values']['chapter']) ? $form_state['values']['chapter'] : '';
 		$form['examples'] = array(
 			'#type' => 'select',
 			'#title' => t('Example No. (Caption): '),
-			'#options' =>  _list_of_examples($example_default_value),
+			'#options' => _list_of_examples($example_default_value),
 			'#default_value' => isset($form_state['values']['examples']) ? $form_state['values']['examples'] : '',
 			'#prefix' => '<div id="ajax-example-list-replace">',
 			'#suffix' => '</div>',
 			'#ajax' => array(
-				'callback' => 'ajax_example_files_callback',
-				),
-			'#states' => array('invisible' => array(':input[name="chapter"]' => array('value' => 0),),),  
+				'callback' => 'ajax_example_files_callback'
+			),
+			'#states' => array(
+				'invisible' => array(
+					':input[name="chapter"]' => array(
+						'value' => 0
+					)
+				)
+			)
 		);
 		$form['download_example_code'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-example-code-replace"></div>',
-      );
-      $form['example_files'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-example-files-replace"></div>',
-      );
-		}else{
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-example-code-replace"></div>'
+		);
+		$form['example_files'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-example-files-replace"></div>'
+		);
+	} //$url_book_pref_id
+	else
+	{
 		$form['category'] = array(
 			'#type' => 'select',
 			'#title' => t('Category'),
 			'#options' => _list_of_category(),
 			'#default_value' => $category_default_value,
 			'#ajax' => array(
-				'callback' => 'ajax_book_list_callback',
+				'callback' => 'ajax_book_list_callback'
 			),
-			'#validated' => TRUE,
+			'#validated' => TRUE
 		);
 		$form['book'] = array(
 			'#type' => 'select',
 			'#title' => t('Title of the book'),
-			'#options' =>  _list_of_books($category_default_value),
+			'#options' => _list_of_books($category_default_value),
 			//'#default_value' => isset($form_state['values']['book']) ? $form_state['values']['book'] : 0,
 			'#prefix' => '<div id="ajax-book-list-replace">',
 			'#suffix' => '</div>',
 			'#ajax' => array(
-				'callback' => 'ajax_chapter_list_callback',
-				),
+				'callback' => 'ajax_chapter_list_callback'
+			),
 			'#validated' => TRUE,
-			'#states' => array('invisible' => array(':input[name="category"]' => array('value' => 0),),),  
+			'#states' => array(
+				'invisible' => array(
+					':input[name="category"]' => array(
+						'value' => 0
+					)
+				)
+			)
 		);
-		
 		$form['book_details'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-book-details-replace"></div>',
-      );
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-book-details-replace"></div>'
+		);
 		$form['download_book'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-book-replace"></div>',
-      );
-      $form['download_pdf'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-book-pdf-replace"></div>',
-      );
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-book-replace"></div>'
+		);
+		$form['download_pdf'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-book-pdf-replace"></div>'
+		);
 		$book_default_value = isset($form_state['values']['book']) ? $form_state['values']['book'] : '';
 		$form['chapter'] = array(
 			'#type' => 'select',
 			'#title' => t('Title of the chapter'),
-			'#options' =>  _list_of_chapters($book_default_value),
+			'#options' => _list_of_chapters($book_default_value),
 			//'#default_value' => isset($form_state['values']['chapter']) ? $form_state['values']['chapter'] : '',
 			'#prefix' => '<div id="ajax-chapter-list-replace">',
 			'#suffix' => '</div>',
 			'#ajax' => array(
-				'callback' => 'ajax_example_list_callback',
-				),
+				'callback' => 'ajax_example_list_callback'
+			),
 			'#validated' => TRUE,
-			'#states' => array('invisible' => array(':input[name="category"]' => array('value' => 0),),),  
+			'#states' => array(
+				'invisible' => array(
+					':input[name="category"]' => array(
+						'value' => 0
+					)
+				)
+			)
 		);
-				
-		
 		$form['download_chapter'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-chapter-replace"></div>',
-      );
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-chapter-replace"></div>'
+		);
 		$example_default_value = isset($form_state['values']['chapter']) ? $form_state['values']['chapter'] : '';
 		$form['examples'] = array(
 			'#type' => 'select',
 			'#title' => t('Example No. (Caption): '),
-			'#options' =>  _list_of_examples($example_default_value),
+			'#options' => _list_of_examples($example_default_value),
 			'#default_value' => isset($form_state['values']['examples']) ? $form_state['values']['examples'] : '',
 			'#prefix' => '<div id="ajax-example-list-replace">',
 			'#suffix' => '</div>',
 			'#ajax' => array(
-				'callback' => 'ajax_example_files_callback',
-				),
-			'#states' => array('invisible' => array(':input[name="category"]' => array('value' => 0),),),  
+				'callback' => 'ajax_example_files_callback'
+			),
+			'#states' => array(
+				'invisible' => array(
+					':input[name="category"]' => array(
+						'value' => 0
+					)
+				)
+			)
 		);
 		$form['download_example_code'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-example-code-replace"></div>',
-      );
-      $form['example_files'] = array(
-        '#type' => 'item',
-        '#markup' => '<div id="ajax-download-example-files-replace"></div>',
-      );
-		}
-		
-        return $form;
-        
-       }
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-example-code-replace"></div>'
+		);
+		$form['example_files'] = array(
+			'#type' => 'item',
+			'#markup' => '<div id="ajax-download-example-files-replace"></div>'
+		);
+	}
+	return $form;
+}
 /********************* Ajax callback ***************************/
-		function ajax_book_list_callback($form, $form_state) {
-		
-			$category_default_value = $form_state['values']['category'];
-			if($category_default_value > 0){
-		
-				$form['book']['#options'] = _list_of_books($category_default_value);
-				$commands[] = ajax_command_replace("#ajax-book-list-replace", drupal_render($form['book']));
-				$commands[] = ajax_command_html("#ajax-chapter-list-replace", '');
-				$commands[] = ajax_command_html("#ajax-example-list-replace", '');
-				
-			}else{
-			
-				$form['book']['#options'] = _list_of_books();
-				$commands[] = ajax_command_replace("#ajax-book-list-replace", drupal_render($form['book']));
-				$commands[] = ajax_command_html("#ajax-book-list-replace", '');
-				$commands[] = ajax_command_html("#ajax-chapter-list-replace", '');
-				$commands[] = ajax_command_html("#ajax-example-list-replace", '');
-				$commands[] = ajax_command_html("#ajax-book-details-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-book-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-book-pdf-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-chapter-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
-				
-			}
-		
-		return array('#type' => 'ajax', '#commands' => $commands);
-		 
-		}
+function ajax_book_list_callback($form, $form_state)
+{
+	$category_default_value = $form_state['values']['category'];
+	if ($category_default_value > 0)
+	{
+		$form['book']['#options'] = _list_of_books($category_default_value);
+		$commands[] = ajax_command_replace("#ajax-book-list-replace", drupal_render($form['book']));
+		$commands[] = ajax_command_html("#ajax-chapter-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-example-list-replace", '');
+	} //$category_default_value > 0
+	else
+	{
+		$form['book']['#options'] = _list_of_books();
+		$commands[] = ajax_command_replace("#ajax-book-list-replace", drupal_render($form['book']));
+		$commands[] = ajax_command_html("#ajax-book-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-chapter-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-example-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-book-details-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-book-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-book-pdf-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-chapter-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
+	}
+	return array(
+		'#type' => 'ajax',
+		'#commands' => $commands
+	);
+}
 /*************************************************************************/
-		function ajax_chapter_list_callback($form, $form_state){
-			 $book_list_default_value = $form_state['values']['book'];
-			
-			if($book_list_default_value > 0){
-		   $commands[] = ajax_command_html("#ajax-book-details-replace", _html_book_info($book_list_default_value));
-			$form['chapter']['#options']=_list_of_chapters($book_list_default_value);
-			$commands[] = ajax_command_html("#ajax-download-book-replace", l('Download', 'download/book/' . $book_list_default_value) . ' ' . t('(Download the Scilab codes for all the solved examples)'));
-			$commands[] = ajax_command_html("#ajax-download-book-pdf-replace", l('Download PDF', 'textbook_companion/generate_book/' . $book_list_default_value) . ' ' . t('(Download the PDF file containing Scilab codes for all the solved examples)'));			
-				$commands[] = ajax_command_replace("#ajax-chapter-list-replace", drupal_render($form['chapter']));			   
-			   $commands[] = ajax_command_html("#ajax-example-list-replace", '');
-			   $commands[] = ajax_command_html("#ajax-download-example-code-replace", '');	
-				$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-chapter-replace",'');	
-			
-			}else{
-			
-				$commands[] = ajax_command_html("#ajax-book-details-replace", '');
-				$form['chapter']['#options']=_list_of_chapters();
-				$commands[] = ajax_command_replace("#ajax-chapter-list-replace", drupal_render($form['chapter']));
-				$commands[] = ajax_command_html("#ajax-chapter-list-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-book-replace",'');
-				$commands[] = ajax_command_html("#ajax-download-chapter-replace",'');
-				$commands[] = ajax_command_html("#ajax-download-book-pdf-replace", '');
-							
-				$commands[] = ajax_command_html("#ajax-example-list-replace", '');
-				$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');	
-				$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');	
-			}
-			
-			return array('#type' => 'ajax', '#commands' => $commands);		
-		}
-		
-		function ajax_example_list_callback($form, $form_state){
-		
-			$chapter_list_default_value = $form_state['values']['chapter'];
-			if($chapter_list_default_value > 0){
-			
-			$form['examples']['#options']= _list_of_examples($chapter_list_default_value);
-			$commands[] = ajax_command_replace("#ajax-example-list-replace", drupal_render($form['examples']));
-			$commands[] = ajax_command_html("#ajax-download-chapter-replace", l('Download', 'download/chapter/' . $chapter_list_default_value) . ' ' . t('(Download the Scilab codes for all the solved examples from the Chapter)'));	
-			
-			$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');	
-			$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
-				
-			}else{
-			$form['examples']['#options']= _list_of_examples();
-			$commands[] = ajax_command_replace("#ajax-example-list-replace", drupal_render($form['examples']));
-			$commands[] = ajax_command_html("#ajax-example-list-replace", '');
-			$commands[] = ajax_command_html("#ajax-download-chapter-replace", '');	
-			$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');	
-			$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');	
-		
-		}
-			return array('#type' => 'ajax', '#commands' => $commands);
-		}
-		/*****************************************************/
-		function ajax_example_files_callback($form, $form_state){
-		 
-		 
-		 $example_list_default_value = $form_state['values']['examples'];
-		 
-		 if($example_list_default_value!=0){
-    //  $example_list_q = db_query("SELECT * FROM {textbook_companion_example_files} WHERE example_id = %d", $form_state['values']['run']['example']);
-      $query = db_select('textbook_companion_example_files');
-						$query->fields('textbook_companion_example_files');
-						$query->condition('example_id', $example_list_default_value );
-						$example_list_q = $query->execute();
-      if ($example_list_q)
-      {
-        $example_files_rows = array();
-        while ($example_list_data = $example_list_q->fetchObject())
-        {
-          $example_file_type = '';
-          switch ($example_list_data->filetype)
-          {
-          case 'S' : $example_file_type = 'Source or Main file'; break;
-          case 'R' : $example_file_type = 'Result file'; break;
-          case 'X' : $example_file_type = 'xcos file'; break;
-          default  : $example_file_type = 'Unknown'; break;
-          }
-          $example_files_rows[] = array(l($example_list_data->filename, 'download/file/' . $example_list_data->id), $example_file_type);
-        }
-
-        /* dependency files */
-       // $dependency_list_q = db_query("SELECT dependency.id as dependency_id, dependency.filename as dependency_filename, dependency.caption as dependency_caption
-       //   FROM {textbook_companion_example_dependency} example_dependency LEFT JOIN {textbook_companion_dependency_files} dependency
-        //  ON example_dependency.dependency_id = dependency.id
-        //  WHERE example_dependency.example_id = %d", $form_state['values']['run']['example']);
-        $query = db_select('textbook_companion_example_dependency', 'example_dependency');
-						$query->fields('dependency', array('id', 'filename', 'caption'));
-						$query->leftJoin('textbook_companion_dependency_files', 'dependency', 'example_dependency.dependency_id = dependency.id');
-						$query->condition('example_dependency.example_id', $form_state['values']['example_list']);
-						$dependency_list_q = $query->execute();
-          while ($dependency_list_data = $dependency_list_q->fetchObject())
-          {
-            $example_file_type = 'Dependency file';
-            $temp_caption = '';
-            if ($dependency_list_data->dependency_caption)
-              $temp_caption = ' (' . $dependency_list_data->dependency_caption . ')';
-            $example_files_rows[] = array(l($dependency_list_data->dependency_filename, 'download/dependency/' . $dependency_list_data->dependency_id) . $temp_caption, $example_file_type);
-          }
-
-        /* creating list of files table */
-        $example_files_header = array('Filename', 'Type');
-        $example_files = theme('table', array('header' => $example_files_header, 'rows' => $example_files_rows)); 
-      }
-     
-      $commands[] = ajax_command_html("#ajax-download-example-code-replace", l('Download Scilab code for the example', 'download/example/' . $example_list_default_value));	
-      $commands[] = ajax_command_html("#ajax-download-example-files-replace",  $example_files);	
-      
-      
-			
-    }else{
-    
-		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');	
-		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');	
-    
-    }
-		
-			return array('#type' => 'ajax', '#commands' => $commands);
-		
-		}
-		/*******************************************************************/
-		function bootstrap_table_format($headers, $rows) {
-        $thead = "";
-        $tbody = "";
-        foreach($headers as $header) {
-            $thead .= "<th>{$header}</th>";
-        }
-        foreach($rows as $row) {
-            $tbody .= "<tr>";
-            foreach($row as $data) {
-                $tbody .= "<td>{$data}</td>";
-            }
-            $tbody .= "</tr>";
-        }
-        $table = "
+function ajax_chapter_list_callback($form, $form_state)
+{
+	$book_list_default_value = $form_state['values']['book'];
+	if ($book_list_default_value > 0)
+	{
+		$commands[] = ajax_command_html("#ajax-book-details-replace", _html_book_info($book_list_default_value));
+		$form['chapter']['#options'] = _list_of_chapters($book_list_default_value);
+		$commands[] = ajax_command_html("#ajax-download-book-replace", l('Download', 'download/book/' . $book_list_default_value) . ' ' . t('(Download the Scilab codes for all the solved examples)'));
+		$commands[] = ajax_command_html("#ajax-download-book-pdf-replace", l('Download PDF', 'textbook_companion/generate_book/' . $book_list_default_value) . ' ' . t('(Download the PDF file containing Scilab codes for all the solved examples)'));
+		$commands[] = ajax_command_replace("#ajax-chapter-list-replace", drupal_render($form['chapter']));
+		$commands[] = ajax_command_html("#ajax-example-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-chapter-replace", '');
+	} //$book_list_default_value > 0
+	else
+	{
+		$commands[] = ajax_command_html("#ajax-book-details-replace", '');
+		$form['chapter']['#options'] = _list_of_chapters();
+		$commands[] = ajax_command_replace("#ajax-chapter-list-replace", drupal_render($form['chapter']));
+		$commands[] = ajax_command_html("#ajax-chapter-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-book-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-chapter-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-book-pdf-replace", '');
+		$commands[] = ajax_command_html("#ajax-example-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
+	}
+	return array(
+		'#type' => 'ajax',
+		'#commands' => $commands
+	);
+}
+function ajax_example_list_callback($form, $form_state)
+{
+	$chapter_list_default_value = $form_state['values']['chapter'];
+	if ($chapter_list_default_value > 0)
+	{
+		$form['examples']['#options'] = _list_of_examples($chapter_list_default_value);
+		$commands[] = ajax_command_replace("#ajax-example-list-replace", drupal_render($form['examples']));
+		$commands[] = ajax_command_html("#ajax-download-chapter-replace", l('Download', 'download/chapter/' . $chapter_list_default_value) . ' ' . t('(Download the Scilab codes for all the solved examples from the Chapter)'));
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
+	} //$chapter_list_default_value > 0
+	else
+	{
+		$form['examples']['#options'] = _list_of_examples();
+		$commands[] = ajax_command_replace("#ajax-example-list-replace", drupal_render($form['examples']));
+		$commands[] = ajax_command_html("#ajax-example-list-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-chapter-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
+	}
+	return array(
+		'#type' => 'ajax',
+		'#commands' => $commands
+	);
+}
+/*****************************************************/
+function ajax_example_files_callback($form, $form_state)
+{
+	$example_list_default_value = $form_state['values']['examples'];
+	if ($example_list_default_value != 0)
+	{
+		//  $example_list_q = db_query("SELECT * FROM {textbook_companion_example_files} WHERE example_id = %d", $form_state['values']['run']['example']);
+		$query = db_select('textbook_companion_example_files');
+		$query->fields('textbook_companion_example_files');
+		$query->condition('example_id', $example_list_default_value);
+		$example_list_q = $query->execute();
+		if ($example_list_q)
+		{
+			$example_files_rows = array();
+			while ($example_list_data = $example_list_q->fetchObject())
+			{
+				$example_file_type = '';
+				switch ($example_list_data->filetype)
+				{
+					case 'S':
+						$example_file_type = 'Source or Main file';
+						break;
+					case 'R':
+						$example_file_type = 'Result file';
+						break;
+					case 'X':
+						$example_file_type = 'xcos file';
+						break;
+					default:
+						$example_file_type = 'Unknown';
+						break;
+				} //$example_list_data->filetype
+				$example_files_rows[] = array(
+					l($example_list_data->filename, 'download/file/' . $example_list_data->id),
+					$example_file_type
+				);
+			} //$example_list_data = $example_list_q->fetchObject()
+			/* dependency files */
+			// $dependency_list_q = db_query("SELECT dependency.id as dependency_id, dependency.filename as dependency_filename, dependency.caption as dependency_caption
+			//   FROM {textbook_companion_example_dependency} example_dependency LEFT JOIN {textbook_companion_dependency_files} dependency
+			//  ON example_dependency.dependency_id = dependency.id
+			//  WHERE example_dependency.example_id = %d", $form_state['values']['run']['example']);
+			$query = db_select('textbook_companion_example_dependency', 'example_dependency');
+			$query->fields('dependency', array(
+				'id',
+				'filename',
+				'caption'
+			));
+			$query->leftJoin('textbook_companion_dependency_files', 'dependency', 'example_dependency.dependency_id = dependency.id');
+			$query->condition('example_dependency.example_id', $form_state['values']['example_list']);
+			$dependency_list_q = $query->execute();
+			while ($dependency_list_data = $dependency_list_q->fetchObject())
+			{
+				$example_file_type = 'Dependency file';
+				$temp_caption = '';
+				if ($dependency_list_data->dependency_caption)
+					$temp_caption = ' (' . $dependency_list_data->dependency_caption . ')';
+				$example_files_rows[] = array(
+					l($dependency_list_data->dependency_filename, 'download/dependency/' . $dependency_list_data->dependency_id) . $temp_caption,
+					$example_file_type
+				);
+			} //$dependency_list_data = $dependency_list_q->fetchObject()
+			/* creating list of files table */
+			$example_files_header = array(
+				'Filename',
+				'Type'
+			);
+			$example_files = theme('table', array(
+				'header' => $example_files_header,
+				'rows' => $example_files_rows
+			));
+		} //$example_list_q
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", l('Download Scilab code for the example', 'download/example/' . $example_list_default_value));
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", $example_files);
+	} //$example_list_default_value != 0
+	else
+	{
+		$commands[] = ajax_command_html("#ajax-download-example-code-replace", '');
+		$commands[] = ajax_command_html("#ajax-download-example-files-replace", '');
+	}
+	return array(
+		'#type' => 'ajax',
+		'#commands' => $commands
+	);
+}
+/*******************************************************************/
+function bootstrap_table_format($headers, $rows)
+{
+	$thead = "";
+	$tbody = "";
+	foreach ($headers as $header)
+	{
+		$thead .= "<th>{$header}</th>";
+	} //$headers as $header
+	foreach ($rows as $row)
+	{
+		$tbody .= "<tr>";
+		foreach ($row as $data)
+		{
+			$tbody .= "<td>{$data}</td>";
+		} //$row as $data
+		$tbody .= "</tr>";
+	} //$rows as $row
+	$table = "
             <table class='table table-bordered table-hover' style='margin-left:-140px'>
                 <thead>{$thead}</thead>
                 <tbody>{$tbody}</tbody>
             </table>
         ";
-        return $table;
-    }
-            
-    /***********************************************************************************/
-
-		
- function _list_of_category()
-		{
-			$category_titles = array(0 => 'Please select category ...',
-									1 => 'Fluid Mechanics',
-									2 => 'Control Theory & Control Systems',
-									3 => 'Chemical Engineering',
-									4 => 'Thermodynamics',
-									5 => 'Mechanical Engineering',
-									6 => 'Signal Processing',
-									7 => 'Digital Communications',
-									8 => 'Electrical Technology',
-									9 => 'Mathematics & Pure Science',
-									10 => 'Analog Electronics',
-									11 => 'Digital Electronics',
-									12 => 'Computer Programming',
-									13 => 'Others'
-							);
-  
-			
-			return $category_titles;
-		}
- 
-		function _list_of_books($category_default_value)
-		{
-			$book_titles = array(0 => 'Please select ...');
-  // $book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE category=".$category_default_value." AND approval_status = 1 OR approval_status = 3 ORDER BY book ASC");
- // $book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE category=".$category_default_value." AND approval_status = 1 AND proposal_id IN (SELECT id FROM textbook_companion_proposal WHERE proposal_status=3) ORDER BY book ASC");
-// var_dump('ok= '. $category_default_value);
-			$query = db_select('textbook_companion_preference');
-				$query->fields('textbook_companion_preference');
-				$query->condition('category', $category_default_value);
-				$query->condition('approval_status', 1);
-
-				$subquery = db_select('textbook_companion_proposal');
-				$subquery->fields('textbook_companion_proposal', array('id'));
-				$subquery->condition('proposal_status', 3);
-				$query->condition('proposal_id', $subquery, 'IN');
-
-				$query->orderBy('book', 'ASC');
-				$book_titles_q = $query->execute();
-			while ($book_titles_data = $book_titles_q->fetchObject())
-			{
-				$book_titles[$book_titles_data->id] = $book_titles_data->book . ' (Written by ' . $book_titles_data->author . ')';
-			}
-			return $book_titles;
-		}
-		
-
-		function _list_of_chapters($preference_id = 0)
+	return $table;
+}
+/***********************************************************************************/
+function _list_of_category()
+{
+	$category_titles = array(
+		0 => 'Please select category ...',
+		1 => 'Fluid Mechanics',
+		2 => 'Control Theory & Control Systems',
+		3 => 'Chemical Engineering',
+		4 => 'Thermodynamics',
+		5 => 'Mechanical Engineering',
+		6 => 'Signal Processing',
+		7 => 'Digital Communications',
+		8 => 'Electrical Technology',
+		9 => 'Mathematics & Pure Science',
+		10 => 'Analog Electronics',
+		11 => 'Digital Electronics',
+		12 => 'Computer Programming',
+		13 => 'Others'
+	);
+	return $category_titles;
+}
+function _list_of_books($category_default_value)
+{
+	$book_titles = array(
+		0 => 'Please select ...'
+	);
+	// $book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE category=".$category_default_value." AND approval_status = 1 OR approval_status = 3 ORDER BY book ASC");
+	// $book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE category=".$category_default_value." AND approval_status = 1 AND proposal_id IN (SELECT id FROM textbook_companion_proposal WHERE proposal_status=3) ORDER BY book ASC");
+	// var_dump('ok= '. $category_default_value);
+	$query = db_select('textbook_companion_preference');
+	$query->fields('textbook_companion_preference');
+	$query->condition('category', $category_default_value);
+	$query->condition('approval_status', 1);
+	$subquery = db_select('textbook_companion_proposal');
+	$subquery->fields('textbook_companion_proposal', array(
+		'id'
+	));
+	$subquery->condition('proposal_status', 3);
+	$query->condition('proposal_id', $subquery, 'IN');
+	$query->orderBy('book', 'ASC');
+	$book_titles_q = $query->execute();
+	while ($book_titles_data = $book_titles_q->fetchObject())
+	{
+		$book_titles[$book_titles_data->id] = $book_titles_data->book . ' (Written by ' . $book_titles_data->author . ')';
+	} //$book_titles_data = $book_titles_q->fetchObject()
+	return $book_titles;
+}
+function _list_of_chapters($preference_id = 0)
+{
+	$book_chapters = array(
+		0 => 'Please select...'
+	);
+	//$book_chapters_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d ORDER BY number ASC", $preference_id);
+	$query = db_select('textbook_companion_chapter');
+	$query->fields('textbook_companion_chapter');
+	$query->condition('preference_id', $preference_id);
+	$query->orderBy('number', 'ASC');
+	$book_chapters_q = $query->execute();
+	while ($book_chapters_data = $book_chapters_q->fetchObject())
+	{
+		$book_chapters[$book_chapters_data->id] = $book_chapters_data->number . '. ' . $book_chapters_data->name;
+	} //$book_chapters_data = $book_chapters_q->fetchObject()
+	return $book_chapters;
+}
+function _list_of_examples($chapter_id = 0)
+{
+	$book_examples = array(
+		0 => 'Please select...'
+	);
+	//$book_examples_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d AND approval_status = 1 ORDER BY
+	// CAST(SUBSTRING_INDEX(number, '.', 1) AS BINARY) ASC,
+	// CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(number , '.', 2), '.', -1) AS UNSIGNED) ASC,
+	//  CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(number , '.', -1), '.', 1) AS UNSIGNED) ASC", $chapter_id);
+	$query = db_select('textbook_companion_example');
+	$query->fields('textbook_companion_example');
+	$query->condition('chapter_id', $chapter_id);
+	$query->condition('approval_status', 1);
+	//$query->orderBy('', '');
+	$book_examples_q = $query->execute();
+	while ($book_examples_data = $book_examples_q->fetchObject())
+	{
+		$book_examples[$book_examples_data->id] = $book_examples_data->number . ' (' . $book_examples_data->caption . ')';
+	} //$book_examples_data = $book_examples_q->fetchObject()
+	return $book_examples;
+}
+function _book_information($preference_id)
+{
+	/*$book_data = db_fetch_object(db_query("SELECT
+	preference.book as preference_book, preference.author as preference_author, preference.isbn as preference_isbn, preference.publisher as preference_publisher, preference.edition as preference_edition, preference.year as preference_year,
+	proposal.full_name as proposal_full_name, proposal.faculty as proposal_faculty, proposal.reviewer as proposal_reviewer, proposal.course as proposal_course, proposal.branch as proposal_branch, proposal.university as proposal_university
+	FROM {textbook_companion_proposal} proposal LEFT JOIN {textbook_companion_preference} preference ON proposal.id = preference.proposal_id WHERE preference.id = %d", $preference_id));*/
+	$query = db_select('textbook_companion_proposal', 'proposal');
+	$query->fields('preference', array(
+		'book',
+		'author',
+		'isbn',
+		'publisher',
+		'edition',
+		'year'
+	));
+	$query->fields('proposal', array(
+		'full_name',
+		'faculty',
+		'reviewer',
+		'course',
+		'branch',
+		'university'
+	));
+	$query->leftJoin('textbook_companion_preference', 'preference', 'proposal.id = preference.proposal_id');
+	$query->condition('preference.id', $preference_id);
+	$book_data = $query->execute()->fetchObject();
+	return $book_data;
+}
+function _html_book_info($preference_id)
+{
+	/*$book_details = db_fetch_object(db_query("SELECT
+	preference.book as preference_book, preference.author as preference_author, preference.isbn as preference_isbn, preference.publisher as preference_publisher, preference.edition as preference_edition, preference.year as preference_year,
+	proposal.full_name as proposal_full_name, proposal.faculty as proposal_faculty, proposal.reviewer as proposal_reviewer, proposal.course as proposal_course, proposal.branch as proposal_branch, proposal.university as proposal_university
+	FROM {textbook_companion_proposal} proposal LEFT JOIN {textbook_companion_preference} preference ON proposal.id = preference.proposal_id WHERE preference.id=".$preference_id));*/
+	$query = db_select('textbook_companion_proposal', 'proposal');
+	$query->addField('preference', 'book', 'preference_book');
+	$query->addField('preference', 'author', 'preference_author');
+	$query->addField('preference', 'isbn', 'preference_isbn');
+	$query->addField('preference', 'publisher', 'preference_publisher');
+	$query->addField('preference', 'edition', 'preference_edition');
+	$query->addField('preference', 'year', 'preference_year');
+	$query->addField('proposal', 'full_name', 'proposal_full_name');
+	$query->addField('proposal', 'faculty', 'proposal_faculty');
+	$query->addField('proposal', 'reviewer', 'proposal_reviewer');
+	$query->addField('proposal', 'course', 'proposal_course');
+	$query->addField('proposal', 'branch', 'proposal_branch');
+	$query->addField('proposal', 'university', 'proposal_university');
+	$query->fields('proposal', array(
+		'full_name',
+		'faculty',
+		'reviewer',
+		'course',
+		'branch',
+		'university'
+	));
+	$query->leftJoin('textbook_companion_preference', 'preference', 'proposal.id = preference.proposal_id');
+	$query->fields('preference', array(
+		'book',
+		'author',
+		'isbn',
+		'publisher',
+		'edition',
+		'year'
+	));
+	$query->condition('preference.id', $preference_id);
+	$book_details = $query->execute()->fetchObject();
+	$html_data = '';
+	if ($book_details)
+	{
+		if ($book_details->proposal_faculty == "None")
 		{
-			$book_chapters = array(0 => 'Please select...');
-  //$book_chapters_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d ORDER BY number ASC", $preference_id);
-
-			$query = db_select('textbook_companion_chapter');
-				$query->fields('textbook_companion_chapter');
-				$query->condition('preference_id', $preference_id);
-				$query->orderBy('number', 'ASC');
-				$book_chapters_q = $query->execute();
-				  
-			while ($book_chapters_data = $book_chapters_q->fetchObject())
-			{
-				$book_chapters[$book_chapters_data->id] = $book_chapters_data->number . '. ' . $book_chapters_data->name;
-			}
-			return $book_chapters;
-		}
-
-
-		function _list_of_examples($chapter_id = 0)
+			$html_data = '<table cellspacing="1" cellpadding="1" border="0" style="width: 100%;" valign="top">' . '<tr><td style="width: 35%;"><span style="color: rgb(128, 0, 0);"><strong>About the Book</strong></span></td>
+	<td style="width: 35%;"><span style="color: rgb(128, 0, 0);"><strong>About the Contributor</strong></span></td>' . '<tr><td valign="top"><ul>' . '<li><strong>Author:</strong> ' . $book_details->preference_author . '</li>' . '<li><strong>Title of the Book:</strong> ' . $book_details->preference_book . '</li>' . '<li><strong>Publisher:</strong> ' . $book_details->preference_publisher . '</li>' . '<li><strong>Year:</strong> ' . $book_details->preference_year . '</li>' . '<li><strong>Edition:</strong> ' . $book_details->preference_edition . '</li>' . '<li><strong>ISBN:</strong> ' . $book_details->preference_isbn . '</li>' . '</ul></td><td valign="top"><ul>' . '<li><strong>Contributor Name: </strong>' . $book_details->proposal_full_name . ', ' . $book_details->proposal_course . ', ' . $book_details->proposal_branch . ', ' . $book_details->proposal_university . '</li>' . '<li><strong>Reviewer: </strong>' . $book_details->proposal_reviewer . '</li>' . '</ul></td></tr>' . '</table>';
+		} //$book_details->proposal_faculty == "None"
+		else
 		{
-			$book_examples = array(0 => 'Please select...');
-  //$book_examples_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d AND approval_status = 1 ORDER BY
-   // CAST(SUBSTRING_INDEX(number, '.', 1) AS BINARY) ASC,
-   // CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(number , '.', 2), '.', -1) AS UNSIGNED) ASC,
-  //  CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(number , '.', -1), '.', 1) AS UNSIGNED) ASC", $chapter_id);
-			$query = db_select('textbook_companion_example');
-				$query->fields('textbook_companion_example');
-				$query->condition('chapter_id', $chapter_id);
-				$query->condition('approval_status', 1);
-				//$query->orderBy('', '');
-				$book_examples_q = $query->execute();
-			while ($book_examples_data = $book_examples_q->fetchObject())
-			{
-				$book_examples[$book_examples_data->id] = $book_examples_data->number . ' (' . $book_examples_data->caption . ')';
-			}
-			return $book_examples;
+			$html_data = '<table cellspacing="1" cellpadding="1" border="0" style="width: 100%;" valign="top">' . '<tr><td style="width: 35%;"><span style="color: rgb(128, 0, 0);"><strong>About the Book</strong></span></td>
+		<td style="width: 35%;"><span style="color: rgb(128, 0, 0);"><strong>About the Contributor</strong></span></td>' . '<tr><td valign="top"><ul>' . '<li><strong>Author:</strong> ' . $book_details->preference_author . '</li>' . '<li><strong>Title of the Book:</strong> ' . $book_details->preference_book . '</li>' . '<li><strong>Publisher:</strong> ' . $book_details->preference_publisher . '</li>' . '<li><strong>Year:</strong> ' . $book_details->preference_year . '</li>' . '<li><strong>Edition:</strong> ' . $book_details->preference_edition . '</li>' . '<li><strong>ISBN:</strong> ' . $book_details->preference_isbn . '</li>' . '</ul></td><td valign="top"><ul>' . '<li><strong>Contributor Name: </strong>' . $book_details->proposal_full_name . ', ' . $book_details->proposal_course . ', ' . $book_details->proposal_branch . ', ' . $book_details->proposal_university . '</li>' . '<li><strong>College Teacher: </strong>' . $book_details->proposal_faculty . '</li>' . '<li><strong>Reviewer: </strong>' . $book_details->proposal_reviewer . '</li>' . '</ul></td></tr>' . '</table>';
 		}
-		
-		function _book_information($preference_id)
-		{
-		/*$book_data = db_fetch_object(db_query("SELECT
-    preference.book as preference_book, preference.author as preference_author, preference.isbn as preference_isbn, preference.publisher as preference_publisher, preference.edition as preference_edition, preference.year as preference_year,
-    proposal.full_name as proposal_full_name, proposal.faculty as proposal_faculty, proposal.reviewer as proposal_reviewer, proposal.course as proposal_course, proposal.branch as proposal_branch, proposal.university as proposal_university
-    FROM {textbook_companion_proposal} proposal LEFT JOIN {textbook_companion_preference} preference ON proposal.id = preference.proposal_id WHERE preference.id = %d", $preference_id));*/
-			$query = db_select('textbook_companion_proposal', 'proposal');
-			$query->fields('preference', array('book', 'author', 'isbn', 'publisher', 'edition', 'year'));
-			$query->fields('proposal', array('full_name', 'faculty', 'reviewer', 'course', 'branch', 'university'));
-			$query->leftJoin('textbook_companion_preference', 'preference', 'proposal.id = preference.proposal_id');
-			$query->condition('preference.id', $preference_id);
-			$book_data = $query->execute()->fetchObject();
-
-			return $book_data;
-}
-		function _html_book_info($preference_id) {
-			 /*$book_details = db_fetch_object(db_query("SELECT
-				  preference.book as preference_book, preference.author as preference_author, preference.isbn as preference_isbn, preference.publisher as preference_publisher, preference.edition as preference_edition, preference.year as preference_year,
-				  proposal.full_name as proposal_full_name, proposal.faculty as proposal_faculty, proposal.reviewer as proposal_reviewer, proposal.course as proposal_course, proposal.branch as proposal_branch, proposal.university as proposal_university
-				  FROM {textbook_companion_proposal} proposal LEFT JOIN {textbook_companion_preference} preference ON proposal.id = preference.proposal_id WHERE preference.id=".$preference_id));*/
-				  $query = db_select('textbook_companion_proposal', 'proposal');
-								  $query->addField('preference','book','preference_book');
-								  $query->addField('preference','author','preference_author');
-								  $query->addField('preference','isbn','preference_isbn');
-								  $query->addField('preference','publisher','preference_publisher');
-								  $query->addField('preference','edition','preference_edition');
-								  $query->addField('preference','year','preference_year');
-								  $query->addField('proposal','full_name','proposal_full_name');
-								  $query->addField('proposal','faculty','proposal_faculty');
-								  $query->addField('proposal','reviewer','proposal_reviewer');
-								  $query->addField('proposal','course','proposal_course');
-								  $query->addField('proposal','branch','proposal_branch');
-								  $query->addField('proposal','university','proposal_university');
-								$query->fields('proposal', array('full_name', 'faculty', 'reviewer', 'course', 'branch', 'university'));
-								$query->leftJoin('textbook_companion_preference', 'preference', 'proposal.id = preference.proposal_id');
-								$query->fields('preference', array('book', 'author', 'isbn', 'publisher', 'edition', 'year'));
-								$query->condition('preference.id', $preference_id);
-								$book_details = $query->execute()->fetchObject();
-								
-			 $html_data = '';
-			 if($book_details) {
-				  $html_data = '<table cellspacing="1" cellpadding="1" border="0" style="width: 100%;" valign="top">' .
-				      '<tr><td style="width: 35%;"><span style="color: rgb(128, 0, 0);"><strong>About the Book</strong></span></td><td style="width: 35%;"><span style="color: rgb(128, 0, 0);"><strong>About the Contributor</strong></span></td>' .
-				      '<tr><td valign="top"><ul>' .
-				      '<li><strong>Author:</strong> ' . $book_details->preference_author . '</li>' .
-				      '<li><strong>Title of the Book:</strong> ' . $book_details->preference_book . '</li>' .
-				      '<li><strong>Publisher:</strong> ' . $book_details->preference_publisher . '</li>' .
-				      '<li><strong>Year:</strong> ' . $book_details->preference_year . '</li>' .
-				      '<li><strong>Edition:</strong> ' . $book_details->preference_edition . '</li>' .
-				      '</ul></td><td valign="top"><ul>' .
-				      '<li><strong>Contributor Name: </strong>' . $book_details->proposal_full_name . ', ' . $book_details->proposal_course . ', ' . $book_details->proposal_branch . ', ' . $book_details->proposal_university . '</li>' .
-				      '<li><strong>College Teacher: </strong>' . $book_details->proposal_faculty . '</li>' .
-				      '<li><strong>Reviewer: </strong>' . $book_details->proposal_reviewer . '</li>' .
-				      '</ul></td></tr>' . '</table>';
-			 }
-
-			 return $html_data;
+	} //$book_details
+	return $html_data;
 }
-