module updated to Drupal 7

1 files changed, 647 insertions, 321 deletions

diff --git a/code_approval.inc b/code_approval.inc
index 571eb7b..f3bb2b1 100755
--- a/code_approval.inc
+++ b/code_approval.inc
@@ -4,21 +4,49 @@
 function code_approval()
 {
   /* get a list of unapproved chapters */
-  $pending_chapter_q = db_query("SELECT c.id as c_id, c.number as c_number, c.name as c_name, c.preference_id as c_preference_id FROM {textbook_companion_example} as e JOIN {textbook_companion_chapter} as c ON c.id = e.chapter_id WHERE e.approval_status = 0");
+
+  /*$pending_chapter_q = db_query("SELECT c.id as c_id, c.number as c_number, c.name as c_name, c.preference_id as c_preference_id FROM {textbook_companion_example} as e JOIN {textbook_companion_chapter} as c ON c.id = e.chapter_id WHERE e.approval_status = 0");*/
+
+	$query = db_select('textbook_companion_example', 'e');
+	$query->fields('c', array('id', 'number', 'name', 'preference_id'));
+	$query->addField('c','id','c_id');
+	$query->addField('c','number','c_number');
+	$query->addField('c','name','c_name');
+	$query->addField('c','preference_id','c_preference_id');
+	$query->innerJoin('textbook_companion_chapter', 'c', 'c.id = e.chapter_id');
+	$query->condition('e.approval_status', 0);
+	$pending_chapter_q = $query->execute();
+
   if (!$pending_chapter_q)
   {
     drupal_set_message(t('There are no pending code approvals.'), 'status');
     return '';
   }
   $rows = array();
-  while ($row = db_fetch_object($pending_chapter_q))
+  while ($row = $pending_chapter_q->fetchObject())
   {
     /* get preference data */
-    $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $row->c_preference_id);
-    $preference_data = db_fetch_object($preference_q);
+
+    /*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $row->c_preference_id);
+    $preference_data = db_fetch_object($preference_q);*/
+
+	$query = db_select('textbook_companion_preference');
+	$query->fields('textbook_companion_preference');
+	$query->condition('id', $row->c_preference_id);
+	$result = $query->execute();
+	$preference_data=$result->fetchObject();
+
     /* get proposal data */
-    $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $preference_data->proposal_id);
-    $proposal_data = db_fetch_object($proposal_q);
+
+    /*$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $preference_data->proposal_id);
+    $proposal_data = db_fetch_object($proposal_q);*/
+
+	$query = db_select('textbook_companion_proposal');
+	$query->fields('textbook_companion_proposal');
+	$query->condition('id', $preference_data->proposal_id);
+	$result = $query->execute();
+ 	$proposal_data = $result->fetchObject();
+
     /* setting table row information */
     $rows[] = array($preference_data->book, $row->c_number, $row->c_name, $proposal_data->full_name, l('Edit', 'code_approval/approve/' . $row->c_id));
   }
@@ -31,7 +59,7 @@ function code_approval()
   }
 
   $header = array('Title of the Book', 'Chapter Number', 'Title of the Chapter', 'Contributor Name', 'Actions');
-  $output = theme_table($header, $rows);
+  $output = theme('table',array('header'=>$header,'rows'=>$rows));
   return $output; 
 }
 
@@ -39,15 +67,38 @@ function code_approval_form($form_state)
 {
   /* get a list of unapproved chapters */
   $chapter_id = arg(2);
-  $pending_chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d", $chapter_id);
-  if ($pending_chapter_data = db_fetch_object($pending_chapter_q))
+
+  /*$pending_chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d", $chapter_id);*/
+
+	$query = db_select('textbook_companion_chapter');
+	$query->fields('textbook_companion_chapter');
+	$query->condition('id', $chapter_id);
+	$pending_chapter_q = $query->execute();
+
+  if ($pending_chapter_data = $pending_chapter_q->fetchObject())
   {
     /* get preference data */
-    $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $pending_chapter_data->preference_id);
-    $preference_data = db_fetch_object($preference_q);
+
+    /*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $pending_chapter_data->preference_id);
+    $preference_data = db_fetch_object($preference_q);*/
+
+	$query = db_select('textbook_companion_preference');
+	$query->fields('textbook_companion_preference');
+	$query->condition('id',$pending_chapter_data->preference_id);
+	$result = $query->execute();
+	$preference_data=$result->fetchObject();
+
     /* get proposal data */
-    $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $preference_data->proposal_id);
-    $proposal_data = db_fetch_object($proposal_q);
+
+    /*$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $preference_data->proposal_id);
+    $proposal_data = db_fetch_object($proposal_q);*/
+
+	$query = db_select('textbook_companion_proposal');
+	$query->fields('textbook_companion_proposal');
+	$query->condition('id', $preference_data->proposal_id);
+	$result = $query->execute();
+	$proposal_data=$result->fetchObject();
+
   } else {
     drupal_set_message(t('Invalid chapter selected.'), 'error');
     drupal_goto('code_approval');
@@ -58,36 +109,44 @@ function code_approval_form($form_state)
 
   $form['contributor'] = array(
     '#type' => 'item',
-    '#value' => $proposal_data->full_name,
+    '#markup' => $proposal_data->full_name,
     '#title' => t('Contributor Name'),
   );
 
   $form['book_details']['book'] = array(
     '#type' => 'item',
-    '#value' => $preference_data->book,
+    '#markup' => $preference_data->book,
     '#title' => t('Title of the Book'),
   );
 
   $form['book_details']['number'] = array(
     '#type' => 'item',
-    '#value' => $pending_chapter_data->number,
+    '#markup' => $pending_chapter_data->number,
     '#title' => t('Chapter Number'),
   );
 
   $form['book_details']['name'] = array(
     '#type' => 'item',
-    '#value' => $pending_chapter_data->name,
+    '#markup' => $pending_chapter_data->name,
     '#title' => t('Title of the Chapter'),
   );
 
   $form['book_details']['back_to_list'] = array(
     '#type' => 'item',
-    '#value' => l('Back to Code Approval List', 'code_approval'),
+    '#markup' => l('Back to Code Approval List', 'code_approval'),
   );
 
   /* get example data */
-  $example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d AND approval_status = 0", $chapter_id);
-  while ($example_data = db_fetch_object($example_q))
+
+  /*$example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d AND approval_status = 0", $chapter_id);*/
+
+	$query = db_select('textbook_companion_example');
+	$query->fields('textbook_companion_example');
+	$query->condition('chapter_id', $chapter_id);
+	$query->condition('approval_status', 0);
+	$example_q = $query->execute();
+
+  while ($example_data = $example_q->fetchObject())
   {
     $form['example_details'][$example_data->id] = array(
       '#type' => 'fieldset',
@@ -96,19 +155,19 @@ function code_approval_form($form_state)
     );
     $form['example_details'][$example_data->id]['example_number'] = array(
       '#type' => 'item',
-      '#value' => $example_data->number,
+      '#markup' => $example_data->number,
       '#title' => t('Example Number'),
     );
   
     $form['example_details'][$example_data->id]['example_caption'] = array(
       '#type' => 'item',
-      '#value' => $example_data->caption,
+      '#markup' => $example_data->caption,
       '#title' => t('Example Caption'),
     );
 
     $form['example_details'][$example_data->id]['download'] = array(
       '#type' => 'markup',
-      '#value' => l('Download Example', 'download/example/' . $example_data->id),
+      '#markup' => l('Download Example', 'download/example/' . $example_data->id),
     );
 
     $form['example_details'][$example_data->id]['approved'] = array(
@@ -140,18 +199,59 @@ function code_approval_form_submit($form, &$form_state)
 
   foreach ($form_state['values']['example_details'] as $ex_id => $ex_data)
   {
-    $example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE id = %d LIMIT 1", $ex_data['example_id']);
-    $example_data = db_fetch_object($example_q);
-    $chapter_data = db_fetch_object(db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d LIMIT 1", $example_data->chapter_id));
-    $preference_data = db_fetch_object(db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d LIMIT 1", $chapter_data->preference_id));
-    $proposal_data = db_fetch_object(db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d LIMIT 1", $preference_data->proposal_id));
+    /*$example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE id = %d LIMIT 1", $ex_data['example_id']);
+    $example_data = db_fetch_object($example_q);*/
+	$query = db_select('textbook_companion_example');
+	$query->fields('textbook_companion_example');
+	$query->condition('id', $ex_data['example_id']);
+	$query->range(0, 1);
+	$result = $query->execute();
+	$example_data=$result->fetchObject();
+
+    /*$chapter_data = db_fetch_object(db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d LIMIT 1", $example_data->chapter_id));*/
+	$query = db_select('textbook_companion_chapter');
+	$query->fields('textbook_companion_chapter');
+	$query->condition('id', $example_data->chapter_id);
+	$query->range(0, 1);
+	$result = $query->execute();
+	$chapter_data=$result->fetchObject();
+
+
+    /*$preference_data = db_fetch_object(db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d LIMIT 1", $chapter_data->preference_id));*/
+	$query = db_select('textbook_companion_preference');
+	$query->fields('textbook_companion_preference');
+	$query->condition('id',$chapter_data->preference_id);
+	$query->range(0, 1);
+	$result = $query->execute();
+	$preference_data=$result->fetchObject();
+
+
+    /*$proposal_data = db_fetch_object(db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d LIMIT 1", $preference_data->proposal_id));*/
+	$query = db_select('textbook_companion_proposal');
+	$query->fields('textbook_companion_proposal');
+	$query->condition('id', $preference_data->proposal_id);
+	$query->range(0, 1);
+	$result = $query->execute();
+        $proposal_data=$result->fetchObject();
+
     $user_data = user_load($proposal_data->uid);
 
     del_book_pdf($preference_data->id);
 
     if ($ex_data['approved'] == "0")
     {
-      db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d, approval_date = %d WHERE id = %d", $user->uid, time(), $ex_data['example_id']);
+      
+	/*db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d, approval_date = %d WHERE id = %d", $user->uid, time(), $ex_data['example_id']);*/
+
+	$query = db_update('textbook_companion_example');
+	$query->fields(array(
+  	'approval_status' => 1,
+  	'approver_uid' => $user->uid,
+  	'approval_date' => time(),
+	));
+	$query->condition('id', $ex_data['example_id']);
+	$num_updated = $query->execute();
+
 
       /* sending email */
       $email_to = $user_data->mail;
@@ -185,312 +285,236 @@ function code_approval_form_submit($form, &$form_state)
 /********************************* BULK APPROVAL ******************************/
 /******************************************************************************/
 
-function bulk_approval_form($form_state)
+function bulk_approval_form($form,$form_state)
 {
-  $form['#redirect'] = FALSE;
-
-  ahah_helper_register($form, $form_state);
-
-  /* default value for ahah fields */
-  if (!isset($form_state['storage']['run']['book']))
-  {
-    $book_default_value = 0;
-  } else {
-    $book_default_value =  $form_state['storage']['run']['book'];
-  }
-
-  if (!isset($form_state['storage']['run']['chapter']))
-  {
-    $chapter_default_value = 0;
-  } else {
-    if ($form_state['values']['run']['book_hidden'] !=  $form_state['values']['run']['book'])
-      $chapter_default_value = 0;
-    else
-      $chapter_default_value = $form_state['storage']['run']['chapter'];
-  }
-
-  if (!isset($form_state['storage']['run']['example']))
-  {
-    $example_default_value = 0;
-  } else {
-    if ($form_state['values']['run']['book_hidden'] !=  $form_state['values']['run']['book'])
-      $example_default_value = 0;
-    else if ($form_state['values']['run']['chapter_hidden'] !=  $form_state['values']['run']['chapter'])
-      $example_default_value = 0;
-    else
-      $example_default_value = $form_state['storage']['run']['example'];
-  }
-
-  $form['run'] = array(
-    '#type' => 'fieldset',
-    '#title' => t('Bulk Manage Code'),
-    '#collapsible' => FALSE,
-    '#collapsed' => FALSE,
-    '#prefix' => '<div id="run-wrapper">',
-    '#suffix' => '</div>',
-    '#tree' => TRUE,
-  );
-
-  $form['run']['book'] = array(
-      '#type' => 'select',
-      '#title' => t('Title of the Book'),
-      '#options' => _list_of_books(),
-      '#default_value' => $book_default_value,
-      '#tree' => TRUE,
-      '#ahah' => array(
-        'event'   => 'change',
-        'effect' => 'none',
-        'path'    => ahah_helper_path(array('run')),
-        'wrapper' => 'run-wrapper',
-        'progress' => array(
-          'type' => 'throbber',
-          'message' => t(''),
-        ),
-      ),
-  );
-
-  /* hidden form elements */
-  $form['run']['book_hidden'] = array(
-    '#type'  => 'hidden',
-    '#value' =>  $form_state['values']['run']['book'],
-  );
-
-  /* hidden form elements */
-  $form['run']['chapter_hidden'] = array(
-    '#type'  => 'hidden',
-    '#value' =>  $form_state['values']['run']['chapter'],
-  );
-
-  if ($book_default_value > 0)
-  {
-    $form['run']['download_book'] = array(
+	$options_first = _bulk_list_of_books();
+	$options_two = _ajax_bulk_get_chapter_list();
+	$selected = isset($form_state['values']['book']) ? $form_state['values']['book'] : key($options_first);
+	$select_two = isset($form_state['values']['chapter']) ? $form_state['values']['chapter'] : key($options_two);
+
+	  $form['book'] = array(
+		   '#type' => 'select',
+		   '#title' => t('Title of the Book'),
+		   '#options' => _bulk_list_of_books(),
+		   '#default_value' => $selected,
+		   //'#tree' => TRUE,
+		   '#ajax' => array(
+		     'callback' => 'ajax_bulk_chapter_list_callback',
+		   ),
+		   '#validated' => TRUE,
+	  );
+  
+    $form['download_book'] = array(
       '#type' => 'item',
-      '#value' => l('Download', 'full_download/book/' . $book_default_value) . ' ' . t('(Download all the approved and unapproved examples of the entire book)'),
+      '#markup' => '<div id="ajax_selected_book"></div>',
     );
-    $form['run']['download_pdf'] = array(
+    $form['download_pdf'] = array(
       '#type' => 'item',
-      '#value' => l('Download PDF', 'textbook_companion/generate_book/' . $book_default_value . '/1') . ' ' . t('(Download PDF of all the approved and unapproved examples of the entire book)'),
+      '#markup' => '<div id="ajax_selected_book_pdf"></div>',
     );
-    $form['run']['regenrate_book'] = array(
+    $form['regenrate_book'] = array(
       '#type' => 'item',
-      '#value' => l('Regenerate PDF', 'textbook_companion/delete_book/' . $book_default_value) . ' ' . t('(Manually Regenerate PDF of the entire book)'),
+      '#markup' => '<div id="ajax_selected_book_regenerate_pdf"></div>',
     );
-    $form['run']['notes_book'] = array(
+    $form['notes_book'] = array(
       '#type' => 'item',
-      '#value' => l('Notes for Reviewers', 'code_approval/notes/' . $book_default_value),
-    );
-
-    $form['run']['approve_book'] = array(
-      '#type'  => 'checkbox',
-      '#title' => t('Approve Entire Book'),
+      '#markup' => '<div id="ajax_selected_book_notes"></div>',      
     );
-    $form['run']['unapprove_book'] = array(
-      '#type'  => 'checkbox',
-      '#title' => t('Pending Review Entire Book'),
-    );
-    $form['run']['disapprove_book'] = array(
-      '#type'  => 'checkbox',
-      '#title' => t('Dis-Approve Entire Book (This will delete all the examples in the book)'),
-      '#prefix' => '<div style="color:red;"><strong>',
-      '#suffix' => '</strong></div>',
-    );
-    $form['run']['delete_book_including_proposal'] = array(
-      '#type'  => 'checkbox',
-      '#title' => t('Delete Entire Book Including Proposal'),
-      '#prefix' => '<div style="color:red;"><strong>',
-      '#suffix' => '</strong></div>',
-    );
-
-    $form['run']['chapter'] = array(
+    
+    $form['book_actions'] = array(
+				'#type' => 'select',
+				'#title' => t('Please select action for selected book'),
+				'#options' =>  _bulk_list_book_actions(),
+				//'#default_value' => isset($form_state['values']['lab_actions']) ? $form_state['values']['lab_actions'] : 0,
+				'#prefix' =>  '<div id="ajax_selected_book_action" style="color:red;">',
+				'#suffix' => '</div>',
+				'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),  
+				'#validated' => TRUE,
+			);
+			   
+    $form['chapter'] = array(
       '#type' => 'select',
       '#title' => t('Title of the Chapter'),
-      '#options' => _list_of_chapters($book_default_value),
-      '#default_value' => $chapter_default_value,
-      '#tree' => TRUE,
-      '#ahah' => array(
-        'event'   => 'change',
-        'effect' => 'none',
-        'path'    => ahah_helper_path(array('run')),
-        'wrapper' => 'run-wrapper',
-        'progress' => array(
-          'type' => 'throbber',
-          'message' => t(''),
-        ),
-      ),
+      '#options' => _ajax_bulk_get_chapter_list($selected),
+      //'#default_value' => $chapter_default_value,
+      '#prefix' => '<div id="ajax_select_chapter_list">',
+		'#suffix' => '</div>',
+		'#validated' => TRUE,
+     // '#tree' => TRUE,
+      '#ajax' => array(
+		     'callback' => 'ajax_bulk_example_list_callback',
+		   ),
+      '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),), 
     );
-    if ($chapter_default_value > 0)
-    {
-      $form['run']['download_chapter'] = array(
+    
+      $form['download_chapter'] = array(
         '#type' => 'item',
-        '#value' => l('Download', 'full_download/chapter/' . $chapter_default_value) . ' ' . t('(Download all the approved and unapproved examples of the entire chapter)'),
+        '#markup' => '<div id="ajax_download_chapter"></div>',  
       );
-
-      $form['run']['approve_chapter'] = array(
-        '#type'  => 'checkbox',
-        '#title' => t('Approve Entire Chapter'),
-      );
-      $form['run']['unapprove_chapter'] = array(
-        '#type'  => 'checkbox',
-        '#title' => t('Pending Review Entire Chapter'),
-      );
-      $form['run']['disapprove_chapter'] = array(
-        '#type'  => 'checkbox',
-        '#title' => t('Dis-Approve Entire Chapter (This will delete all the examples in the chapter)'),
-        '#prefix' => '<div style="color:red;"><strong>',
-        '#suffix' => '</strong></div>',
-      );
-
-      $form['run']['example'] = array(
+   
+   $form['chapter_actions'] = array(
+				'#type' => 'select',
+				'#title' => t('Please select action for selected chapter'),
+				'#options' =>   _bulk_list_chapter_actions(),
+				//'#default_value' => isset($form_state['values']['lab_actions']) ? $form_state['values']['lab_actions'] : 0,
+				'#prefix' =>  '<div id="ajax_selected_chapter_action" style="color:red;">',
+				'#suffix' => '</div>',
+				'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),  
+				'#ajax' => array(
+		     'callback' => 'ajax_bulk_chapter_actions_callback',
+		   ),
+			);
+   
+      $form['example'] = array(
         '#type' => 'select',
         '#title' => t('Example No. (Caption)'),
-        '#options' => _list_of_examples($chapter_default_value),
-        '#default_value' => $example_default_value,
-        '#tree' => TRUE,
-        '#ahah' => array(
-          'event'   => 'change',
-          'effect' => 'none',
-          'path'    => ahah_helper_path(array('run')),
-          'wrapper' => 'run-wrapper',
-          'progress' => array(
-            'type' => 'throbber',
-            'message' => t(''),
-          ),
+        '#options' => _ajax_bulk_get_examples($chapter_default_value),
+       // '#default_value' => $example_default_value,       
+        '#validated' => TRUE,
+        '#prefix' => '<div id="ajax_selected_example">',
+		  '#suffix' => '</div>',
+		  '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),  
+        '#ajax' => array(
+        		'callback' => 'ajax_bulk_example_files_callback',
         ),
-      );
-    }
-  }
-
-  /************ START OF $_POST **************/
-  if ($_POST)
-  {
-    if (($book_default_value > 0) && ($chapter_default_value > 0) && ($example_default_value > 0))
-    {
-      $example_list_q = db_query("SELECT * FROM {textbook_companion_example_files} WHERE example_id = %d", $form_state['values']['run']['example']);
-      if ($example_list_q)
-      {
-        $example_files_rows = array();
-        while ($example_list_data = db_fetch_object($example_list_q))
-        {
-          $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']);
-          while ($dependency_list_data = db_fetch_object($dependency_list_q))
-          {
-            $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($example_files_header, $example_files_rows); 
-      }
-      $form['run']['download_example'] = array(
+      );      
+      
+      $form['download_example'] = array(
         '#type' => 'item',
-        '#value' => l('Download Example', 'download/example/' . $example_default_value),
+        '#markup' => '<div id="ajax_download_selected_example"></div>',
       );
-      $form['run']['edit_example'] = array(
+      $form['edit_example'] = array(
         '#type'  => 'item',
-        '#value' => l('Edit Example', 'code_approval/editcode/' . $example_default_value),
+        '#markup' => '<div id="ajax_edit_selected_example"></div>',
       );
 
-      $form['run']['example_files'] = array(
-        '#type'  => 'item',
-        '#title' => 'List of example files',
-        '#value' => $example_files,
-      );
-
-      $form['run']['approve_example'] = array(
-        '#type'  => 'checkbox',
-        '#title' => t('Approve Example'),
-      );
-      $form['run']['unapprove_example'] = array(
-        '#type'  => 'checkbox',
-        '#title' => t('Pending Review Example'),
-      );
-      $form['run']['disapprove_example'] = array(
-        '#type'  => 'checkbox',
-        '#title' => t('Dis-approve Example (This will delete the example)'),
-        '#prefix' => '<div style="color:red;"><strong>',
-        '#suffix' => '</strong></div>',
+      $form['example_files'] = array(
+        '#type' => 'item',
+         '#markup' => '',
+        '#prefix' => '<div id="ajax_example_files_list">',
+        '#suffix' => '</div>',
+       
       );
-    }
-  }
-  /************ END OF $_POST **************/
-
-  if ($book_default_value > 0)
-  {
-    $form['run']['message'] = array(
+      
+      $form['example_actions'] = array(
+				'#type' => 'select',
+				'#title' => t('Please select action for selected example'),
+				'#options' =>  _bulk_list_example_actions(),
+				//'#default_value' => isset($form_state['values']['lab_actions']) ? $form_state['values']['lab_actions'] : 0,
+				'#prefix' =>  '<div id="ajax_selected_example_action" style="color:red;">',
+				'#suffix' => '</div>',
+				'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),  
+			);
+   
+    $form['message'] = array(
       '#type' => 'textarea',
       '#title' => t('If Dis-Approved please specify reason for Dis-Approval'),
+      '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),  
     );
   
-    $form['run']['submit'] = array(
+    $form['submit'] = array(
       '#type' => 'submit',
-      '#value' => t('Submit')
+      '#value' => t('Submit'),
+      '#validate' => array('bulk_approval_submit_validate'),
+      '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),  
     );
-  }
+  
 
   return $form;
 }
 
+function bulk_approval_submit_validate($form, &$form_state){
+var_dump('test');
+if(($form_state['values']['book_actions'] == 0) && ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 0))
+        drupal_set_message("Wrong selection of action. Please select any one action1", 'error');
+        return;
+       if(($form_state['values']['book_actions'] != 0) && ($form_state['values']['chapter_actions'] != 0) && ($form_state['values']['example_actions'] != 0))
+        drupal_set_message("Wrong selection of action. Please select any one action2");
+          return;
+       if(($form_state['values']['book_actions'] != 0) && ($form_state['values']['chapter_actions'] !=0) && ($form_state['values']['example_actions'] == 0))
+        drupal_set_message("Wrong selection of action. Please select any one action3", 'error');
+         return;
+       if(($form_state['values']['book_actions'] != 0) && ($form_state['values']['chapter_actions'] == 0) && ($form_state['values']['example_actions'] != 0))
+        drupal_set_message("Wrong selection of action. Please select any one action4", 'error');
+        return;
+
+if(($form_state['values']['book_actions'] == 0) && ($form_state['values']['chapter_actions'] != 0) && ($form_state['values']['lab_experiment_solution_actions'] != 0))
+        drupal_set_message("Wrong selection of action5. Please select any one action", 'error');         
+   return;
+
+  }
 
 function bulk_approval_form_submit($form, &$form_state)
 {
 	global $user;
 	$root_path = textbook_companion_path();
-
+	
 	if ($form_state['clicked_button']['#value'] == 'Submit')
 	{
-		if ($form_state['values']['run']['book'])
-			del_book_pdf($form_state['values']['run']['book']);
+		if ($form_state['values']['book'])
+			del_book_pdf($form_state['values']['book']);
 
 		if (user_access('bulk manage code'))
 		{
-      			if ($form_state['values']['run']['approve_book'] == "1")
+      			if (($form_state['values']['book_actions'] == 1) && ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 0))
       			{
 			        /* approving entire book */
-			        $chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d", $form_state['values']['run']['book']);
-			        while ($chapter_data = db_fetch_object($chapter_q))
+
+			       /* $chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d", 
+                               $form_state['values']['book']);*/
+
+				$query = db_select('textbook_companion_chapter');
+				$query->fields('textbook_companion_chapter');
+				$query->condition('preference_id', $form_state['values']['book']);
+				$chapter_q = $query->execute();
+
+			        while ($chapter_data = $chapter_q->fetchObject())
 			        {
-				          db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d WHERE chapter_id = %d AND approval_status = 0", $user->uid, $chapter_data->id);
+				          /*db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d WHERE chapter_id = %d AND approval_status = 0", $user->uid, $chapter_data->id);*/
+
+				$query = db_update('textbook_companion_example');
+				$query->fields(array(
+  				'approval_status' => 1,
+  				'approver_uid' => $user->uid,
+				));
+				$query->condition('chapter_id', $chapter_data->id);
+				$query->condition('approval_status', 0);
+				$num_updated = $query->execute();
+
 			        }
 			        drupal_set_message(t('Approved Entire Book.'), 'status');
 
 			        /* email */
 			        $email_subject = t('Your uploaded examples have been approved');
-			        $email_body = t('Your all the uploaded examples for the book have been approved.');
+			        $email_body = array(0=> t('Your all the uploaded examples for the book have been approved.'));
 
-		      	} else if ($form_state['values']['run']['unapprove_book'] == "1") {
+		      	} else if (($form_state['values']['book_actions'] == 2) && ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 0)) {
 
 			        /* approving entire book */
-			        $chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d", $form_state['values']['run']['book']);
-			        while ($chapter_data = db_fetch_object($chapter_q))
+
+			        /*$chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d", $form_state['values']['book']);*/
+				$query = db_select('textbook_companion_chapter');
+				$query->fields('textbook_companion_chapter');
+				$query->condition('preference_id', $form_state['values']['book']);
+				$result = $query->execute();
+
+			        while ($chapter_data = $chapter_q->fetchObject())
 		        	{
-				          db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE chapter_id = %d", $chapter_data->id);
+				          /*db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE chapter_id = %d", $chapter_data->id);*/
+					$query = db_update('textbook_companion_example');
+					$query->fields(array(
+ 						 'approval_status' => 0,
+					));
+					$query->condition('chapter_id', $chapter_data->id);
+					$num_updated = $query->execute();
 			        }
 			        drupal_set_message(t('Pending Review Entire Book.'), 'status');
 
 			        /* email */
 			        $email_subject = t('Your uploaded examples have been marked as pending');
-			        $email_body = t('Your all the uploaded examples for the book have been marked as pending to be review. You will be able to see the exmaples after they have been approved by one of our reviewers.');
+			        $email_body = array(0=> t('Your all the uploaded examples for the book have been marked as pending to be review. You will be able to see the exmaples after they have been approved by one of our reviewers.'));
 
-		      	} else if ($form_state['values']['run']['disapprove_book'] == "1") {
+		      	} else if (($form_state['values']['book_actions'] == 3) && ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 0)) {
 
 				if (!user_access('bulk delete code'))
         			{
@@ -498,7 +522,7 @@ function bulk_approval_form_submit($form, &$form_state)
 			        	return;
         			}
 
-        			if (delete_book($form_state['values']['run']['book']))
+        			if (delete_book($form_state['values']['book']))
         			{
 			          	drupal_set_message(t('Dis-Approved and Deleted Entire Book.'), 'status');
         			} else {
@@ -507,13 +531,13 @@ function bulk_approval_form_submit($form, &$form_state)
 
 		        	/* email */
         			$email_subject = t('Your uploaded examples have been marked as dis-approved');
-        			$email_body = t('Your all the uploaded examples for the whole book have been marked as dis-approved.
+        			$email_body = array(0 => t('Your all the uploaded examples for the whole book have been marked as dis-approved.
 
 Reason for dis-approval:
 
-' . $form_state['values']['run']['message']);
+' . $form_state['values']['message']));
 
-      			} else if ($form_state['values']['run']['delete_book_including_proposal'] == "1") {
+      			} elseif(($form_state['values']['book_actions'] == 4 )&& ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 0)) {
 
         			if (!user_access('bulk delete code'))
         			{
@@ -522,18 +546,24 @@ Reason for dis-approval:
         			}
 
         			/* check if dependency files are present */
-        			$dep_q = db_query("SELECT * FROM {textbook_companion_dependency_files} WHERE preference_id = %d", $form_state['values']['run']['book']);
-        			if ($dep_data = db_fetch_object($dep_q))
+        			/*$dep_q = db_query("SELECT * FROM {textbook_companion_dependency_files} WHERE preference_id = %d", $form_state['values']['book']);*/
+
+			/*	$query = db_select('textbook_companion_dependency_files');
+				$query->fields('textbook_companion_dependency_files');
+				$query->condition('preference_id', $form_state['values']['book']);
+				$dep_q = $query->execute();
+
+        			if ($dep_data =$dep_q->fetchObject())
         			{
           				drupal_set_message(t("Cannot delete book since it has dependency files that can be used by others. First delete the dependency files before deleing the Book."), 'error');
           				return;
         			}
-
-        			if (delete_book($form_state['values']['run']['book']))
+*/
+        			if (delete_book($form_state['values']['book']))
         			{
           				drupal_set_message(t('Dis-Approved and Deleted Entire Book examples.'), 'status');
 
-          				$dir_path = $root_path . $form_state['values']['run']['book'];
+          				$dir_path = $root_path . $form_state['values']['book'];
           				if (is_dir($dir_path))
           				{
             					$res = rmdir($dir_path);
@@ -547,45 +577,79 @@ Reason for dis-approval:
           				}
 
           				/* deleting preference and proposal */
-          				$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $form_state['values']['run']['book']);
+          				/*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $form_state['values']['book']);
           				$preference_data = db_fetch_object($preference_q);
-          				$proposal_id = $preference_data->proposal_id;
-          				db_query("DELETE FROM {textbook_companion_preference} WHERE proposal_id = %d", $proposal_id);
-          				db_query("DELETE FROM {textbook_companion_proposal} WHERE id = %d", $proposal_id);
+*/
+
+					$query = db_select('textbook_companion_preference');
+					$query->fields('textbook_companion_preference');
+					$query->condition('id', $form_state['values']['book']);
+					$result = $query->execute();
+					$preference_data =$result->fetchObject();
+
+          		$proposal_id = $preference_data->proposal_id;
+
+          				/*db_query("DELETE FROM {textbook_companion_preference} WHERE proposal_id = %d", $proposal_id);*/
+					$query = db_delete('textbook_companion_preference');
+					$query->condition('proposal_id', $proposal_id);
+					$num_deleted = $query->execute();
+
+          				/*db_query("DELETE FROM {textbook_companion_proposal} WHERE id = %d", $proposal_id);*/
+					$query = db_delete('textbook_companion_proposal');
+					$query->condition('id', $proposal_id);
+					$num_deleted = $query->execute();
 
-          				drupal_set_message(t('Deleted Book Proposal.'), 'status');
+          		drupal_set_message(t('Deleted Book Proposal.'), 'status');
 
           				/* email */
-          				$email_subject = t('Your uploaded examples including the book proposal have been deleted');
-					$email_body = t('Your all the uploaded examples including the book have been deleted permanently.
+          		$email_subject = t('Your uploaded examples including the book proposal have been deleted');
+					$email_body = array(0 =>t('Your all the uploaded examples including the book have been deleted permanently.
 
 Reason for deletion:
 
-' . $form_state['values']['run']['message']);
+' . $form_state['values']['message']));
 
         			} else {
           				drupal_set_message(t('Error Dis-Approving and Deleting Entire Book.'), 'error');
         			}
 
-      			} else if ($form_state['values']['run']['approve_chapter'] == "1") {
+      			} elseif (($form_state['values']['book_actions'] == 0)&& ($form_state['values']['chapter_actions']== 1) && ($form_state['values']['example_actions'] == 0)) {
+
+        			/*db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d WHERE chapter_id = %d AND approval_status = 0", $user->uid, $form_state['values']['chapter']);*/
+
+				$query = db_update('textbook_companion_example');
+				$query->fields(array(
+  					'approval_status' => 1,
+  					'approver_uid' => $user->uid,
+					));
+				$query->condition('chapter_id', $form_state['values']['chapter']);
+				$query->condition('approval_status', 0);
+				$num_updated = $query->execute();
 
-        			db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d WHERE chapter_id = %d AND approval_status = 0", $user->uid, $form_state['values']['run']['chapter']);
         			drupal_set_message(t('Approved Entire Chapter.'), 'status');
 
         			/* email */
         			$email_subject = t('Your uploaded examples have been approved');
-        			$email_body = t('Your all the uploaded examples for the chapter have been approved.');
+        			$email_body = array(0 => t('Your all the uploaded examples for the chapter have been approved.'));
+
+      			} else if (($form_state['values']['book_actions'] == 0)&& ($form_state['values']['chapter_actions']== 2) && ($form_state['values']['example_actions'] == 0)) {
 
-      			} else if ($form_state['values']['run']['unapprove_chapter'] == "1") {
+        			/*db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE chapter_id = %d", $form_state['values']['chapter']);*/
+
+				$query = db_update('textbook_companion_example');
+				$query->fields(array(
+  					'approval_status' => 0,
+				));
+				$query->condition('chapter_id', $form_state['values']['chapter']);
+				$num_updated = $query->execute();
 
-        			db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE chapter_id = %d", $form_state['values']['run']['chapter']);
         			drupal_set_message(t('Entire Chapter marked as Pending Review.'), 'status');
 
         			/* email */
         			$email_subject = t('Your uploaded examples have been marked as pending');
-        			$email_body = t('Your all the uploaded examples for the chapter have been marked as pending to be review.');
+        			$email_body = array(0 => t('Your all the uploaded examples for the chapter have been marked as pending to be review.'));
 
-      			} else if ($form_state['values']['run']['disapprove_chapter'] == "1") {
+      			} else if (($form_state['values']['book_actions'] == 0)&& ($form_state['values']['chapter_actions']== 3) && ($form_state['values']['example_actions'] == 0)) {
 
         			if (!user_access('bulk delete code'))
         			{
@@ -593,7 +657,7 @@ Reason for deletion:
           				return;
         			}
 
-        			if (delete_chapter($form_state['values']['run']['chapter']))
+        			if (delete_chapter($form_state['values']['chapter']))
         			{
           				drupal_set_message(t('Dis-Approved and Deleted Entire Chapter.'), 'status');
        	 			} else {
@@ -602,33 +666,50 @@ Reason for deletion:
 
         			/* email */
         			$email_subject = t('Your uploaded example have been marked as dis-approved');
-        			$email_body = t('Your uploaded example for the entire chapter have been marked as dis-approved.
+        			$email_body = array(0 => t('Your uploaded example for the entire chapter have been marked as dis-approved.
 
 Reason for dis-approval:
 
-' . $form_state['values']['run']['message']);
+' . $form_state['values']['message']));
+
+      			} else if (($form_state['values']['book_actions'] == 0)&& ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 1)) {
+
+        			/*db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d WHERE id = %d", $user->uid, $form_state['values']['example']);*/
 
-      			} else if ($form_state['values']['run']['approve_example'] == "1") {
+				$query = db_update('textbook_companion_example');
+				$query->fields(array(
+  					'approval_status' => 1,
+  					'approver_uid' => $user->uid,
+				));
+				$query->condition('id', $form_state['values']['example']);
+				$num_updated = $query->execute();
 
-        			db_query("UPDATE {textbook_companion_example} SET approval_status = 1, approver_uid = %d WHERE id = %d", $user->uid, $form_state['values']['run']['example']);
         			drupal_set_message(t('Example approved.'), 'status');
 
         			/* email */
         			$email_subject = t('Your uploaded example has been approved');
-        			$email_body = t('Your uploaded example has been approved.');
+        			$email_body = array(0 => t('Your uploaded example has been approved.'));
 
-      			} else if ($form_state['values']['run']['unapprove_example'] == "1") {
+      			} else if (($form_state['values']['book_actions'] == 0)&& ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 2)) {
+
+        			/*db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE id = %d", $form_state['values']['example']);*/
+
+				$query = db_update('textbook_companion_example');
+				$query->fields(array(
+  					'approval_status' => 0,
+				));
+				$query->condition('id', $form_state['values']['example']);
+				$num_updated = $query->execute();
 
-        			db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE id = %d", $form_state['values']['run']['example']);
         			drupal_set_message(t('Example marked as Pending Review.'), 'status');
 
         			/* email */
         			$email_subject = t('Your uploaded example has been marked as pending');
-        			$email_body = t('Your uploaded example has been marked as pending to be review.');
+        			$email_body = array( 0 => t('Your uploaded example has been marked as pending to be review.'));
 
-      			} else if ($form_state['values']['run']['disapprove_example'] == "1") {
+      			} else if (($form_state['values']['book_actions'] == 0)&& ($form_state['values']['chapter_actions']== 0) && ($form_state['values']['example_actions'] == 3)) {
 
-        			if (delete_example($form_state['values']['run']['example']))
+        			if (delete_example($form_state['values']['example']))
         			{
           				drupal_set_message(t('Example Dis-Approved and Deleted.'), 'status');
         			} else {
@@ -637,11 +718,11 @@ Reason for dis-approval:
 
         			/* email */
         			$email_subject = t('Your uploaded example has been marked as dis-approved');
-        			$email_body = t('Your uploaded example has been marked as dis-approved.
+        			$email_body = array(0 => t('Your uploaded example has been marked as dis-approved.
 
 Reason for dis-approval:
 
-' . $form_state['values']['run']['message']);
+' . $form_state['values']['message']));
 
       			}
 
@@ -661,39 +742,284 @@ Reason for dis-approval:
 	}
 }
 
-function _list_of_books()
+function _bulk_list_of_books()
 {
   $book_titles = array('0' => 'Please select...');
-  $book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 OR approval_status = 3 ORDER BY book ASC");
-  while ($book_titles_data = db_fetch_object($book_titles_q))
+  /*$book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 OR approval_status = 3 ORDER BY book ASC");*/
+
+	$query = db_select('textbook_companion_preference');
+	$query->fields('textbook_companion_preference');
+
+	$or = db_or();
+	$or->condition('approval_status', 1);
+	$or->condition('approval_status', 3);
+	$query->condition($or);
+	$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)
+function _ajax_bulk_get_chapter_list($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);
-  while ($book_chapters_data = db_fetch_object($book_chapters_q))
+
+  /*$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)
+function _ajax_bulk_get_examples($chapter_id = 0)
 {
   $book_examples = array('0' => 'Please select...');
-  $book_examples_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d ORDER BY
+
+  /*$book_examples_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d 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);
-  while ($book_examples_data = db_fetch_object($book_examples_q))
+    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->orderBy('CAST', 'ASC');
+		//$query->orderBy('CAST', 'ASC');
+		//$query->orderBy('CAST', 'ASC');
+		$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;
 }
+function _bulk_list_book_actions(){
+		 $book_actions = array(0 => 'Please select...');
+		 $book_actions[1] = 'Approve Entire Book';
+		 $book_actions[2] = 'Pending Review Entire Book';
+		 $book_actions[3] = 'Dis-Approve Entire Book (This will delete all the examples in the book)';
+		 $book_actions[4] = 'Delete Entire Book Including Proposal';
+	  return $book_actions;
+	}
+	   
+	function _bulk_list_chapter_actions(){
+		$chapter_actions = array(0 => 'Please select...');
+		$chapter_actions[1] = 'Approve Entire Chapter';
+		$chapter_actions[2] = 'Pending Review Entire Chapter';
+		$chapter_actions[3] = 'Dis-Approve Entire Chapter (This will delete all the examples in the chapter)';
+		
+	  return $chapter_actions;
+	}
+	function _bulk_list_example_actions(){
+		 $example_actions = array(0 => 'Please select...');
+		 $example_actions[1] = 'Approve  Approve Example';
+		 $example_actions[2] = 'Pending Review Example';
+		 $example_actions[3] = 'Dis-approve Example (This will delete the example)';
+		
+	  return $example_actions;
+	}
+	/****************************** Ajax Callback function ***************************/
+	function ajax_bulk_chapter_list_callback($form, $form_state) {
+	
+		$commands = array();
+		$book_default_value = $form_state['values']['book'];
+			if($book_default_value > 0){
+				$commands[] = ajax_command_html('#ajax_selected_book', l('Download', 'full_download/book/' . $book_default_value) . ' ' . t('(Download all the approved and unapproved examples of the entire book)') );
+			$commands[] = ajax_command_html('#ajax_selected_book_pdf', l('Download PDF', 'textbook_companion/generate_book/' . $book_default_value . '/1') . ' ' . t('(Download PDF of all the approved and unapproved examples of the entire book)'));
+			$commands[] = ajax_command_html('#ajax_selected_book_regenerate_pdf', l('Regenerate PDF', 'textbook_companion/delete_book/' . $book_default_value) . ' ' . t('(Manually Regenerate PDF of the entire book)'));
+			$commands[] = ajax_command_html('#ajax_selected_book_notes', l('Notes for Reviewers', 'code_approval/notes/' . $book_default_value));
+			$form['book_actions']['#options'] = _bulk_list_book_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_book_action',drupal_render($form['book_actions']));
+			$form['chapter']['#options'] = _ajax_bulk_get_chapter_list($book_default_value);
+			$commands[] = ajax_command_replace('#ajax_select_chapter_list',drupal_render($form['chapter']));
+			$commands[] = ajax_command_html('#ajax_download_chapter', '' );
+			$form['chapter_actions']['#options'] = _bulk_list_book_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_chapter_action',drupal_render($form['chapter_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_chapter_action', '' );
+			$commands[] = ajax_command_html('#ajax_selected_example', '' );
+			$form['example_actions']['#options'] = _bulk_list_example_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_example_action',drupal_render($form['example_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_example_action', '' );
+			$commands[] = ajax_command_html('#ajax_download_selected_example', '');
+			$commands[] = ajax_command_html('#ajax_edit_selected_example', '');
+			$form['example_files']['#title'] = '';
+			$form['example_files']['#markup'] = '' ;
+			$commands[] = ajax_command_replace('#ajax_example_files_list', drupal_render($form['example_files']));
+			}else{
+			
+			$commands[] = ajax_command_html('#ajax_selected_book', '' );
+			$commands[] = ajax_command_html('#ajax_selected_book_pdf', '');
+			$commands[] = ajax_command_html('#ajax_selected_book_regenerate_pdf', '');
+			$commands[] = ajax_command_html('#ajax_selected_book_notes', '');
+			$form['chapter']['#options'] = _ajax_bulk_get_chapter_list();
+			$commands[] = ajax_command_replace('#ajax_select_chapter_list',drupal_render($form['chapter']));
+			$commands[] = ajax_command_html('#ajax_select_chapter_list', '');
+			$form['book_actions']['#options'] = _bulk_list_book_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_book_action',drupal_render($form['book_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_book_action', '');			
+			$form['chapter_actions']['#options'] = _bulk_list_chapter_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_chapter_action',drupal_render($form['chapter_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_chapter_action', '' );
+			$commands[] = ajax_command_html('#ajax_download_chapter', '' );
+			$commands[] = ajax_command_html('#ajax_selected_example', '' );
+			$form['example_actions']['#options'] = _bulk_list_example_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_example_action',drupal_render($form['example_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_example_action', '' );
+			$commands[] = ajax_command_html('#ajax_download_selected_example', '');
+			$commands[] = ajax_command_html('#ajax_edit_selected_example', '');
+			$form['example_files']['#title'] = '';
+			$form['example_files']['#markup'] = '' ;
+			$commands[] = ajax_command_replace('#ajax_example_files_list', drupal_render($form['example_files']));
+			
+		}
+		return array('#type' => 'ajax', '#commands' => $commands);
+	}
+	
+	function ajax_bulk_example_list_callback($form, $form_state) {
+	
+		$commands = array();
+		$chapter_default_value = $form_state['values']['chapter'];
+		
+			if($chapter_default_value > 0){
+			
+			$commands[] = ajax_command_html('#ajax_download_chapter', l('Download', 'full_download/chapter/' . $chapter_default_value) . ' ' . t('(Download all the approved and unapproved examples of the entire chapter)') );
+			$form['chapter_actions']['#options'] = _bulk_list_chapter_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_chapter_action',drupal_render($form['chapter_actions']));
+			$form['example']['#options'] = _ajax_bulk_get_examples($chapter_default_value);
+			$commands[] = ajax_command_replace('#ajax_selected_example',drupal_render($form['example']));
+			$commands[] = ajax_command_html('#ajax_download_selected_example', '');
+			$commands[] = ajax_command_html('#ajax_edit_selected_example', '');
+			$form['example_actions']['#options'] = _bulk_list_example_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_example_action',drupal_render($form['example_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_example_action', '' );
+			$form['example_files']['#title'] = '';
+			$form['example_files']['#markup'] = '' ;
+			$commands[] = ajax_command_replace('#ajax_example_files_list', drupal_render($form['example_files']));
+			
+			}else{
+			
+			$commands[] = ajax_command_html('#ajax_download_chapter', '' );
+			$form['chapter_actions']['#options'] = _bulk_list_chapter_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_chapter_action',drupal_render($form['chapter_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_chapter_action', '' );
+			$form['example']['#options'] = _ajax_bulk_get_examples();
+			$commands[] = ajax_command_replace('#ajax_selected_example',drupal_render($form['example']));
+			$commands[] = ajax_command_html('#ajax_selected_example','');		
+			$commands[] = ajax_command_html('#ajax_download_selected_example', '');
+			$commands[] = ajax_command_html('#ajax_edit_selected_example', '');
+			$form['example_files']['#title'] = '';
+			$form['example_files']['#markup'] = '' ;
+			$commands[] = ajax_command_replace('#ajax_example_files_list', drupal_render($form['example_files']));
+			$form['example_actions']['#options'] = _bulk_list_example_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_example_action',drupal_render($form['example_actions']));
+			$commands[] = ajax_command_html('#ajax_selected_example_action', '' );
+			
+		}
+		return array('#type' => 'ajax', '#commands' => $commands);
+	}
+	
+	function ajax_bulk_example_files_callback($form, $form_state) {
+
+		$commands = array();
+		$example_list_default_value = $form_state['values']['example'];
+		//var_dump($example_list_default_value);
+		if($example_list_default_value > 0){ 
+			/*************************************************************************************/
+			/*$example_list_q = db_query("SELECT * FROM {textbook_companion_example_files} WHERE example_id = %d", $form_state['values']['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']['example']);*/
+
+	$query = db_select('textbook_companion_example_dependency', 'example_dependency');
+	$query->fields('dependency', array('id', 'filename', 'caption'));
+	$query->addField('dependency','id','dependency_id');
+	$query->addField('dependency','filename','dependency_filename');
+	$query->addField('dependency','caption','dependency_caption');
+	$query->leftJoin('textbook_companion_dependency_files', 'dependency', 'example_dependency.dependency_id = dependency.id');
+	$query->condition('example_dependency.example_id',  $form_state['values']['example']);
+	$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)); 
+        
+        $form['example_files']['#title'] = 'List of example files';
+		  $form['example_files']['#markup'] = $example_files ;
+		  $commands[] = ajax_command_replace('#ajax_example_files_list', drupal_render($form['example_files']));
+		  $commands[] = ajax_command_html('#ajax_download_selected_example', l('Download Example', 'download/example/' . $example_list_default_value) );
+				$commands[] = ajax_command_html('#ajax_edit_selected_example', l('Edit Example', 'code_approval/editcode/' . $example_list_default_value));
+			$form['example_actions']['#options'] = _bulk_list_example_actions();
+			$commands[] = ajax_command_replace('#ajax_selected_example_action',drupal_render($form['example_actions']));
+			//$commands[] = ajax_command_html('#ajax_selected_example_action', '' );
+      }
+      
+		}else{
+		
+				$commands[] = ajax_command_html('#ajax_download_selected_example', '');
+				$commands[] = ajax_command_html('#ajax_edit_selected_example', '');
+				$form['example_files']['#title'] = '';
+				$form['example_files']['#markup'] = '' ;
+				$commands[] = ajax_command_replace('#ajax_example_files_list', drupal_render($form['example_files']));
+				$form['example_actions']['#options'] = _bulk_list_example_actions();
+				$commands[] = ajax_command_replace('#ajax_selected_example_action',drupal_render($form['example_actions']));
+				$commands[] = ajax_command_html('#ajax_selected_example_action', '' );
+		}
+		return array('#type' => 'ajax', '#commands' => $commands);
+	}
+	function ajax_bulk_chapter_actions_callback(){
+	//if($form_state['values']['chapter_actions'] > 0){
+		//	$form['book_actions']['#options'] = _bulk_list_book_actions();
+			//$commands[] = ajax_command_replace('#ajax_selected_book_action',drupal_render($form['book_actions']));
+		//	}
+			
+			return array('#type' => 'ajax', '#commands' => $commands);
+	
+	
+	}