Done minor changes and added submit all code notification for tbc reviver interface

1 files changed, 1550 insertions, 654 deletions

diff --git a/code_approval.inc b/code_approval.inc
index a669125..71c769e 100755
--- a/code_approval.inc
+++ b/code_approval.inc
@@ -1,700 +1,1596 @@
 <?php
 // $Id$
-
 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");
-  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))
-  {
-    /* 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);
-    /* 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);
-    /* 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));
-  }
-
-  /* check if there are any pending proposals */                                   
-  if (!$rows)
-  {
-    drupal_set_message(t('There are no pending proposals'), 'status');
-    return '';
-  }
-
-  $header = array('Title of the Book', 'Chapter Number', 'Title of the Chapter', 'Contributor Name', 'Actions');
-  $output = theme_table($header, $rows);
-  return $output; 
+    /* 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");*/
+    $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 = $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);*/
+        $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);*/
+        $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', 'textbook-companion/code-approval/approve/' . $row->c_id)
+        );
+    }
+    /* check if there are any pending proposals */
+    if (!$rows) {
+        drupal_set_message(t('There are no pending proposals'), 'status');
+        return '';
+    }
+    $header = array(
+        'Title of the Book',
+        'Chapter Number',
+        'Title of the Chapter',
+        'Contributor Name',
+        'Actions'
+    );
+    $output = theme('table', array(
+        'header' => $header,
+        'rows' => $rows
+    ));
+    return $output;
 }
-
-function code_approval_form($form_state)
+function code_approval_form($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))
-  {
-    /* 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);
-    /* 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);
-  } else {
-    drupal_set_message(t('Invalid chapter selected.'), 'error');
-    drupal_goto('code_approval');
-    return;
-  }
-
-  $form['#tree'] = TRUE;
-
-  $form['contributor'] = array(
-    '#type' => 'item',
-    '#value' => $proposal_data->full_name,
-    '#title' => t('Contributor Name'),
-  );
-
-  $form['book_details']['book'] = array(
-    '#type' => 'item',
-    '#value' => $preference_data->book,
-    '#title' => t('Title of the Book'),
-  );
-
-  $form['book_details']['number'] = array(
-    '#type' => 'item',
-    '#value' => $pending_chapter_data->number,
-    '#title' => t('Chapter Number'),
-  );
-
-  $form['book_details']['name'] = array(
-    '#type' => 'item',
-    '#value' => $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'),
-  );
-
-  /* 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))
-  {
-    $form['example_details'][$example_data->id] = array(
-      '#type' => 'fieldset',
-      '#collapsible' => FALSE,
-      '#collapsed' => TRUE,
-    );
-    $form['example_details'][$example_data->id]['example_number'] = array(
-      '#type' => 'item',
-      '#value' => $example_data->number,
-      '#title' => t('Example Number'),
+    /* get a list of unapproved chapters */
+    $chapter_id = arg(3);
+    /*$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);*/
+        $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);*/
+        $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('textbook-companion/code-approval');
+        return;
+    }
+    $form['#tree'] = TRUE;
+    $form['contributor'] = array(
+        '#type' => 'item',
+        '#markup' => $proposal_data->full_name,
+        '#title' => t('Contributor Name')
     );
-  
-    $form['example_details'][$example_data->id]['example_caption'] = array(
-      '#type' => 'item',
-      '#value' => $example_data->caption,
-      '#title' => t('Example Caption'),
+    $form['book_details']['book'] = array(
+        '#type' => 'item',
+        '#markup' => $preference_data->book,
+        '#title' => t('Title of the Book')
     );
-
-    $form['example_details'][$example_data->id]['download'] = array(
-      '#type' => 'markup',
-      '#value' => l('Download Example', 'download/example/' . $example_data->id),
+    $form['book_details']['number'] = array(
+        '#type' => 'item',
+        '#markup' => $pending_chapter_data->number,
+        '#title' => t('Chapter Number')
     );
-
-    $form['example_details'][$example_data->id]['approved'] = array(
-      '#type' => 'radios',
-      '#options' => array('Approved', 'Dis-approved'),
+    $form['book_details']['name'] = array(
+        '#type' => 'item',
+        '#markup' => $pending_chapter_data->name,
+        '#title' => t('Title of the Chapter')
     );
-
-    $form['example_details'][$example_data->id]['message'] = array(
-      '#type' => 'textfield',
-      '#title' => t('Reason for dis-approval'),
+    $form['book_details']['back_to_list'] = array(
+        '#type' => 'item',
+        '#markup' => l('Back to Code Approval List', 'textbook-companion/code-approval')
     );
-
-    $form['example_details'][$example_data->id]['example_id'] = array(
-      '#type' => 'hidden',
-      '#value' => $example_data->id,
+    /* get example data */
+    /*$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',
+            '#collapsible' => FALSE,
+            '#collapsed' => TRUE
+        );
+        $form['example_details'][$example_data->id]['example_number'] = array(
+            '#type' => 'item',
+            '#markup' => $example_data->number,
+            '#title' => t('Example Number')
+        );
+        $form['example_details'][$example_data->id]['example_caption'] = array(
+            '#type' => 'item',
+            '#markup' => $example_data->caption,
+            '#title' => t('Example Caption')
+        );
+        $form['example_details'][$example_data->id]['download'] = array(
+            '#type' => 'markup',
+            '#markup' => l('Download Example', 'textbook-companion/download/example/' . $example_data->id)
+        );
+        $form['example_details'][$example_data->id]['approved'] = array(
+            '#type' => 'radios',
+            '#options' => array(
+                'Approved',
+                'Dis-approved'
+            )
+        );
+        $form['example_details'][$example_data->id]['message'] = array(
+            '#type' => 'textfield',
+            '#title' => t('Reason for dis-approval')
+        );
+        $form['example_details'][$example_data->id]['example_id'] = array(
+            '#type' => 'hidden',
+            '#value' => $example_data->id
+        );
+    }
+    $form['submit'] = array(
+        '#type' => 'submit',
+        '#value' => t('Submit')
     );
-  }
-
-  $form['submit'] = array(
-    '#type' => 'submit',
-    '#value' => t('Submit')
-  );
-  return $form;
+    return $form;
 }
-
 function code_approval_form_submit($form, &$form_state)
 {
-  global $user;
-
-  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));
-    $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']);
-
-      /* sending email */
-      $email_to = $user_data->mail;
-      $param['example_approved']['example_id'] = $ex_data['example_id'];
-      $param['example_approved']['user_id'] = $user_data->uid;
-      if (!drupal_mail('textbook_companion', 'example_approved', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
-        drupal_set_message('Error sending email message.', 'error');
-
-    } else if ($ex_data['approved'] == "1") {
-      if (delete_example($ex_data['example_id']))
-      {
-        /* sending email */
-        $email_to = $user_data->mail;
-        $param['example_disapproved']['example_number'] = $example_data->number;
-        $param['example_disapproved']['example_caption'] = $example_data->caption;
-        $param['example_disapproved']['user_id'] = $user_data->uid;
-        $param['example_disapproved']['message'] = $ex_data['message'];
-        if (!drupal_mail('textbook_companion', 'example_disapproved', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
-          drupal_set_message('Error sending email message.', 'error');
-      } else {
-        drupal_set_message('Error disapproving and deleting example. Please contact administrator.', 'error');
-      }
+    global $user;
+    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);*/
+        $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']);*/
+            $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;
+            $from = variable_get('textbook_companion_from_email', '');
+            $bcc = variable_get('textbook_companion_emails', '');
+            $cc = variable_get('textbook_companion_cc_emails', '');
+            $param['example_approved']['example_id'] = $ex_data['example_id'];
+            $param['example_approved']['user_id'] = $user_data->uid;
+            $param['example_approved']['headers'] = array(
+                'From' => $from,
+                'MIME-Version' => '1.0',
+                'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+                'Content-Transfer-Encoding' => '8Bit',
+                'X-Mailer' => 'Drupal',
+                'Cc' => $cc,
+                'Bcc' => $bcc
+            );
+            if (!drupal_mail('textbook_companion', 'example_approved', $email_to, language_default(), $param, $from, TRUE))
+                drupal_set_message('Error sending email message.', 'error');
+        } else if ($ex_data['approved'] == "1") {
+            if (delete_example($ex_data['example_id'])) {
+                /* sending email */
+                $email_to = $user_data->mail;
+                $from = variable_get('textbook_companion_from_email', '');
+                $bcc = variable_get('textbook_companion_emails', '');
+                $cc = variable_get('textbook_companion_cc_emails', '');
+                $param['example_disapproved']['preference_id'] = $chapter_data->preference_id;
+                $param['example_disapproved']['chapter_id'] = $example_data->chapter_id;
+                $param['example_disapproved']['example_number'] = $example_data->number;
+                $param['example_disapproved']['example_caption'] = $example_data->caption;
+                $param['example_disapproved']['user_id'] = $user_data->uid;
+                $param['example_disapproved']['message'] = $ex_data['message'];
+                $param['example_disapproved']['headers'] = array(
+                    'From' => $from,
+                    'MIME-Version' => '1.0',
+                    'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+                    'Content-Transfer-Encoding' => '8Bit',
+                    'X-Mailer' => 'Drupal',
+                    'Cc' => $cc,
+                    'Bcc' => $bcc
+                );
+                if (!drupal_mail('textbook_companion', 'example_disapproved', $email_to, language_default(), $param, $from, TRUE))
+                    drupal_set_message('Error sending email message.', 'error');
+            } else {
+                drupal_set_message('Error disapproving and deleting example. Please contact administrator.', 'error');
+            }
+        }
     }
-  }
-  drupal_set_message('Updated successfully.', 'status');
-  drupal_goto('code_approval');
+    drupal_set_message('Updated successfully.', 'status');
+    drupal_goto('textbook-companion/code-approval');
 }
-
-
 /******************************************************************************/
 /********************************* 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(
-      '#type' => 'item',
-      '#value' => l('Download', 'full_download/book/' . $book_default_value) . ' ' . t('(Download all the approved and unapproved examples of the entire book)'),
-    );
-    $form['run']['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)'),
-    );
-    $form['run']['regenrate_book'] = array(
-      '#type' => 'item',
-      '#value' => l('Regenerate PDF', 'textbook_companion/delete_book/' . $book_default_value) . ' ' . t('(Manually Regenerate PDF of the entire book)'),
-    );
-    $form['run']['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'),
-    );
-    $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(
-      '#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_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',
+        '#markup' => '<div id="ajax_selected_book"></div>'
+    );
+    /*$form['download_pdf'] = array(
+    '#type' => 'item',
+    '#markup' => '<div id="ajax_selected_book_pdf"></div>',
+    );
+    $form['regenrate_book'] = array(
+    '#type' => 'item',
+    '#markup' => '<div id="ajax_selected_book_regenerate_pdf"></div>',
+    );*/
+    $form['notes_book'] = array(
+        '#type' => 'item',
+        '#markup' => '<div id="ajax_selected_book_notes"></div>'
+    );
+    $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' => _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)'),
-      );
-
-      $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(
+        '#markup' => '<div id="ajax_download_chapter"></div>'
+    );
+    $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(),
+        // '#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
+                )
+            )
         ),
-      );
-    //}
- //}
-
-  /************ 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);
+        '#ajax' => array(
+            'callback' => 'ajax_bulk_example_files_callback'
+        )
+    );
+    $form['download_example'] = array(
+        '#type' => 'item',
+        '#markup' => '<div id="ajax_download_selected_example"></div>'
+    );
+    $form['edit_example'] = array(
+        '#type' => 'item',
+        '#markup' => '<div id="ajax_edit_selected_example"></div>'
+    );
+    $form['example_files'] = array(
+        '#type' => 'item',
+        '#markup' => '',
+        '#prefix' => '<div id="ajax_example_files_list">',
+        '#suffix' => '</div>'
+    );
+    $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(
+            'visible' => array(
+                array(
+                    array(
+                        ':input[name="book_actions"]' => array(
+                            'value' => 3
+                        )
+                    ),
+                    'or',
+                    array(
+                        ':input[name="chapter_actions"]' => array(
+                            'value' => 3
+                        )
+                    ),
+                    'or',
+                    array(
+                        ':input[name="example_actions"]' => array(
+                            'value' => 3
+                        )
+                    ),
+                    'or',
+                    array(
+                        ':input[name="book_actions"]' => array(
+                            'value' => 4
+                        )
+                    )
+                )
+            ),
+            'required' => array(
+                array(
+                    array(
+                        ':input[name="book_actions"]' => array(
+                            'value' => 3
+                        )
+                    ),
+                    'or',
+                    array(
+                        ':input[name="chapter_actions"]' => array(
+                            'value' => 3
+                        )
+                    ),
+                    'or',
+                    array(
+                        ':input[name="example_actions"]' => array(
+                            'value' => 3
+                        )
+                    ),
+                    'or',
+                    array(
+                        ':input[name="book_actions"]' => array(
+                            'value' => 4
+                        )
+                    )
+                )
+            )
+        )
+    );
+    $form['submit'] = array(
+        '#type' => 'submit',
+        '#value' => t('Submit'),
+        '#states' => array(
+            'invisible' => array(
+                ':input[name="book"]' => array(
+                    'value' => 0
+                )
+            )
+        )
+    );
+    return $form;
+}
+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']['book'])
+            del_book_pdf($form_state['values']['book']);
+        if (user_access('bulk manage code')) {
+            $query = db_select('textbook_companion_preference');
+            $query->fields('textbook_companion_preference');
+            $query->condition('id', $form_state['values']['book']);
+            $result = $query->execute();
+            $pref_data = $result->fetchObject();
+            $prop_id = $pref_data->proposal_id;
+            $query = db_select('textbook_companion_proposal');
+            $query->fields('textbook_companion_proposal');
+            $query->condition('id', $prop_id);
+            $user_query = $query->execute();
+            $user_info = $user_query->fetchObject();
+            $user_data = user_load($user_info->uid);
+            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']['book']);*/
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $preference_data = $result->fetchObject();
+                $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);*/
+                    $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();
+                }
+                $query = db_update('textbook_companion_preference');
+                $query->fields(array(
+                    'submited_all_examples_code' => 1
+                ));
+                $query->condition('id', $form_state['values']['book']);
+                $num_updated = $query->execute();
+                drupal_set_message(t('Approved Entire Book.'), 'status');
+                /* email */
+                //$email_subject = t('Your uploaded examples have been approved');
+                //$email_body = array(0=>t('Your all the uploaded examples for the book have been approved.'));
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion examples have been approved', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your all the uploaded examples for the book have been approved.
+
+Title of the book : ' . $preference_data->book . '
+Author name : ' . $preference_data->author . '
+ISBN No. : ' . $preference_data->isbn . '
+Publisher and Place : ' . $preference_data->publisher . '
+Edition : ' . $preference_data->edition . '
+Year of publication : ' . $preference_data->year . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($form_state['values']['book_actions'] == 2) && ($form_state['values']['chapter_actions'] == 0) && ($form_state['values']['example_actions'] == 0)) {
+                /* pending entire book */
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $preference_data = $result->fetchObject();
+                /*$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 = 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 =array( 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_subject = t('[!site_name] Your uploaded Textbook Companion examples have been marked as pending', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your all the uploaded examples for the book have been marked as pending to be reviewed. 
+You will be able to see the examples after they have been approved by one of our reviewers.
+
+Title of the book : ' . $preference_data->book . '
+Author name : ' . $preference_data->author . '
+ISBN No. : ' . $preference_data->isbn . '
+Publisher and Place : ' . $preference_data->publisher . '
+Edition : ' . $preference_data->edition . '
+Year of publication : ' . $preference_data->year . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($form_state['values']['book_actions'] == 3) && ($form_state['values']['chapter_actions'] == 0) && ($form_state['values']['example_actions'] == 0)) {
+                if (strlen(trim($form_state['values']['message'])) <= 30) {
+                    form_set_error('message', t(''));
+                    drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+                    return;
+                }
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $preference_data = $result->fetchObject();
+                if (!user_access('bulk delete code')) {
+                    drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Book.'), 'error');
+                    return;
+                }
+                if (delete_book($form_state['values']['book'])) {
+                    drupal_set_message(t('Dis-Approved and Deleted Entire Book.'), 'status');
+                } else {
+                    drupal_set_message(t('Error Dis-Approving and Deleting Entire Book.'), 'error');
+                }
+                /* email */
+                /*$email_subject = t('Your uploaded examples have been marked as dis-approved');
+                $email_body =array( t('Your all the uploaded examples for the whole book have been marked as dis-approved.
+                
+                Reason for dis-approval:
+                
+                ' . $form_state['values']['message']));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion examples have been marked as
+				dis-approved', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your all the uploaded examples for the whole book have been marked as dis-approved.
+
+Title of the book : ' . $preference_data->book . '
+Author name : ' . $preference_data->author . '
+ISBN No. : ' . $preference_data->isbn . '
+Publisher and Place : ' . $preference_data->publisher . '
+Edition : ' . $preference_data->edition . '
+Year of publication : ' . $preference_data->year . '
+
+
+Reason for dis-approval:' . $form_state['values']['message'] . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($form_state['values']['book_actions'] == 4) && ($form_state['values']['chapter_actions'] == 0) && ($form_state['values']['example_actions'] == 0)) {
+                if (strlen(trim($form_state['values']['message'])) <= 30) {
+                    form_set_error('message', t(''));
+                    drupal_set_message("Please mention the reason for disapproval/deletion. Minimum 30 character required", 'error');
+                    return;
+                }
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                if (!user_access('bulk delete code')) {
+                    drupal_set_message(t('You do not have permission to Bulk Delete Entire Book Including Proposal.'), 'error');
+                    return;
+                }
+                /* check if dependency files are present */
+                /*$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']['book'])) {
+                    drupal_set_message(t('Dis-Approved and Deleted Entire Book examples.'), 'status');
+                    $dir_path = $root_path . $form_state['values']['book'];
+                    if (is_dir($dir_path)) {
+                        $res = rmdir($dir_path);
+                        if (!$res) {
+                            drupal_set_message(t("Cannot delete Book directory : " . $dir_path . ". Please contact administrator."), 'error');
+                            return;
+                        }
+                    } else {
+                        drupal_set_message(t("Book directory not present : " . $dir_path . ". Skipping deleting book directory."), 'status');
+                    }
+                    /* deleting preference and proposal */
+                    /*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $form_state['values']['book']);
+                    $preference_data = db_fetch_object($preference_q);
+                    */
+                    $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');
+                    /* email */
+                    /*$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']['message']));*/
+                    $email_subject = t('[!site_name] Your uploaded Textbook Companion examples including the book proposal 					have been deleted', array(
+                        '!site_name' => variable_get('site_name', '')
+                    ));
+                    $email_body = array(
+                        0 => t('
+
+Dear !user_name,
+
+We regret to inform you that all the uploaded examples including the book with following details have been deleted permanently.
+
+
+Title of the book : ' . $pref_data->book . '
+Author name : ' . $pref_data->author . '
+ISBN No. : ' . $pref_data->isbn . '
+Publisher and Place : ' . $pref_data->publisher . '
+Edition : ' . $pref_data->edition . '
+Year of publication : ' . $pref_data->year . '
+
+Reason for deletion:' . $form_state['values']['message'] . '
+
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                            '!site_name' => variable_get('site_name', ''),
+                            '!user_name' => $user_data->name
+                        ))
+                    );
+                } else {
+                    drupal_set_message(t('Error Dis-Approving and Deleting Entire Book.'), 'error');
+                }
+            } 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_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                $query = db_select('textbook_companion_chapter');
+                $query->fields('textbook_companion_chapter');
+                $query->condition('preference_id', $form_state['values']['book']);
+                $query->condition('id', $form_state['values']['chapter']);
+                $result = $query->execute();
+                $chap_data = $result->fetchObject();
+                $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();
+                drupal_set_message(t('Approved Entire Chapter.'), 'status');
+                /* email */
+                /*$email_subject = t('Your uploaded examples have been approved');
+                $email_body = array(0=>t('Your all the uploaded examples for the chapter have been approved.'));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion examples have been approved', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your all the uploaded examples for the chapter have been approved. 
+
+Title of the book : ' . $pref_data->book . '
+Title of the chapter : ' . $chap_data->name . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($form_state['values']['book_actions'] == 0) && ($form_state['values']['chapter_actions'] == 2) && ($form_state['values']['example_actions'] == 0)) {
+                /*db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE chapter_id = %d", $form_state['values']['chapter']);*/
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                $query = db_select('textbook_companion_chapter');
+                $query->fields('textbook_companion_chapter');
+                $query->condition('preference_id', $form_state['values']['book']);
+                $query->condition('id', $form_state['values']['chapter']);
+                $result = $query->execute();
+                $chap_data = $result->fetchObject();
+                $query = db_update('textbook_companion_example');
+                $query->fields(array(
+                    'approval_status' => 0
+                ));
+                $query->condition('chapter_id', $form_state['values']['chapter']);
+                $num_updated = $query->execute();
+                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 = array(0=>t('Your all the uploaded examples for the chapter have been marked as pending 
+                to be review.'));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion examples have been marked as pending', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your all the uploaded examples for the chapter have been marked as pending to be reviewed.
+
+Title of the book : ' . $pref_data->book . '
+Title of the chapter : ' . $chap_data->name . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($form_state['values']['book_actions'] == 0) && ($form_state['values']['chapter_actions'] == 3) && ($form_state['values']['example_actions'] == 0)) {
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                $query = db_select('textbook_companion_chapter');
+                $query->fields('textbook_companion_chapter');
+                $query->condition('preference_id', $form_state['values']['book']);
+                $query->condition('id', $form_state['values']['chapter']);
+                $result = $query->execute();
+                $chap_data = $result->fetchObject();
+                if (strlen(trim($form_state['values']['message'])) <= 30) {
+                    form_set_error('message', t(''));
+                    drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+                    return;
+                }
+                if (!user_access('bulk delete code')) {
+                    drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Chapter.'), 'error');
+                    return;
+                }
+                if (delete_chapter($form_state['values']['chapter'])) {
+                    drupal_set_message(t('Dis-Approved and Deleted Entire Chapter.'), 'status');
+                } else {
+                    drupal_set_message(t('Error Dis-Approving and Deleting Entire Chapter.'), 'error');
+                }
+                /* email */
+                /*$email_subject = t('Your uploaded example 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']['message']));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion example have been marked as 					dis-approved', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your uploaded example for the entire chapter have been marked as dis-approved.
+
+Title of the book : ' . $pref_data->book . '
+Title of the chapter : ' . $chap_data->name . '
+
+
+Reason for dis-approval:' . $form_state['values']['message'] . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($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']);*/
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                $query = db_select('textbook_companion_chapter');
+                $query->fields('textbook_companion_chapter');
+                $query->condition('preference_id', $form_state['values']['book']);
+                $query->condition('id', $form_state['values']['chapter']);
+                $result = $query->execute();
+                $chap_data = $result->fetchObject();
+                $query = db_select('textbook_companion_example');
+                $query->fields('textbook_companion_example');
+                $query->condition('id', $form_state['values']['example']);
+                $result = $query->execute();
+                $examp_data = $result->fetchObject();
+                $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();
+                drupal_set_message(t('Example approved.'), 'status');
+                /* email */
+                /*$email_subject = t('Your uploaded example has been approved');
+                $email_body = array(0=>t('Your uploaded example has been approved.'));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion example have been approved', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your example for DWSIM Textbook Companion with the following details is approved.
+
+Title of the book : ' . $pref_data->book . '
+Title of the chapter : ' . $chap_data->name . '
+Example number : ' . $examp_data->number . '
+Caption : ' . $examp_data->caption . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($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_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                $query = db_select('textbook_companion_chapter');
+                $query->fields('textbook_companion_chapter');
+                $query->condition('preference_id', $form_state['values']['book']);
+                $query->condition('id', $form_state['values']['chapter']);
+                $result = $query->execute();
+                $chap_data = $result->fetchObject();
+                $query = db_select('textbook_companion_example');
+                $query->fields('textbook_companion_example');
+                $query->condition('id', $form_state['values']['example']);
+                $result = $query->execute();
+                $examp_data = $result->fetchObject();
+                $query = db_update('textbook_companion_example');
+                $query->fields(array(
+                    'approval_status' => 0
+                ));
+                $query->condition('id', $form_state['values']['example']);
+                $num_updated = $query->execute();
+                drupal_set_message(t('Example marked as Pending Review.'), 'status');
+                /* email */
+                /*$email_subject = t('Your uploaded example has been marked as pending');
+                $email_body = array(0=>t('Your uploaded example has been marked as pending to be review.'));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion example has been marked as pending', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your uploaded example for DWSIM Textbook Companion with the following details has been marked as pending to be reviewed.
+
+Title of the book : ' . $pref_data->book . '
+Title of the chapter : ' . $chap_data->name . '
+Example number : ' . $examp_data->number . '
+Caption : ' . $examp_data->caption . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } elseif (($form_state['values']['book_actions'] == 0) && ($form_state['values']['chapter_actions'] == 0) && ($form_state['values']['example_actions'] == 3)) {
+                if (strlen(trim($form_state['values']['message'])) <= 30) {
+                    form_set_error('message', t(''));
+                    drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+                    return;
+                }
+                $query = db_select('textbook_companion_preference');
+                $query->fields('textbook_companion_preference');
+                $query->condition('id', $form_state['values']['book']);
+                $query->condition('approval_status', 1);
+                $result = $query->execute();
+                $pref_data = $result->fetchObject();
+                $query = db_select('textbook_companion_chapter');
+                $query->fields('textbook_companion_chapter');
+                $query->condition('preference_id', $form_state['values']['book']);
+                $query->condition('id', $form_state['values']['chapter']);
+                $result = $query->execute();
+                $chap_data = $result->fetchObject();
+                $query = db_select('textbook_companion_example');
+                $query->fields('textbook_companion_example');
+                $query->condition('id', $form_state['values']['example']);
+                $result = $query->execute();
+                $examp_data = $result->fetchObject();
+                if (delete_example($form_state['values']['example'])) {
+                    drupal_set_message(t('Example Dis-Approved and Deleted.'), 'status');
+                } else {
+                    drupal_set_message(t('Error Dis-Approving and Deleting Example.'), 'error');
+                }
+                /* email */
+                /*$email_subject = 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']['message']));*/
+                $email_subject = t('[!site_name] Your uploaded Textbook Companion example has been marked as 
+				dis-approved', array(
+                    '!site_name' => variable_get('site_name', '')
+                ));
+                $email_body = array(
+                    0 => t('
+
+Dear !user_name,
+
+Your example for DWSIM Textbook Companion has been marked as dis-approved and deleted.
+
+Title of the book : ' . $pref_data->book . '
+Title of the chapter : ' . $chap_data->name . '
+Example number : ' . $examp_data->number . '
+Caption : ' . $examp_data->caption . '
+
+Reason for dis-approval:' . $form_state['values']['message'] . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+                        '!site_name' => variable_get('site_name', ''),
+                        '!user_name' => $user_data->name
+                    ))
+                );
+            } else {
+                drupal_set_message(t('Please select only one action at a time'), 'error');
+                return;
+            }
+            /****** sending email when everything done ******/
+            if ($email_subject) {
+                $email_to = $user_data->mail;
+                $from = variable_get('textbook_companion_from_email', '');
+                $bcc = variable_get('textbook_companion_emails', '');
+                $cc = variable_get('textbook_companion_cc_emails', '');
+                $param['standard']['subject'] = $email_subject;
+                $param['standard']['body'] = $email_body;
+                $param['standard']['headers'] = array(
+                    'From' => $from,
+                    'MIME-Version' => '1.0',
+                    'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+                    'Content-Transfer-Encoding' => '8Bit',
+                    'X-Mailer' => 'Drupal',
+                    'Cc' => $cc,
+                    'Bcc' => $bcc
+                );
+                if (!drupal_mail('textbook_companion', 'standard', $email_to, language_default(), $param, $from, TRUE))
+                    drupal_set_message('Error sending email message.', 'error');
+            }
+        } else {
+            drupal_set_message(t('You do not have permission to bulk manage code.'), 'error');
         }
-
-        /* 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))
-          {
+    }
+}
+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");*/
+    $query = db_select('textbook_companion_preference', 'pp');
+    $query->join('textbook_companion_proposal', 'p', 'pp.proposal_id=p.id');
+    $query->join('users', 'u', 'p.uid=u.uid');
+    $query->fields('u', array(
+        'name'
+    ));
+    $query->fields('pp', array(
+        'id',
+        'book',
+        'author'
+    ));
+    $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 . ')' . ' (Proposed by ' . $book_titles_data->name . ')';
+    }
+    return $book_titles;
+}
+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);*/
+    $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 _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
+    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->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', 'textbook-companion/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', 'textbook-companion/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, 'textbook-companion/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 . ')';
+            $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(
-        '#type' => 'item',
-        '#value' => l('Download Example', 'download/example/' . $example_default_value),
-      );
-      $form['run']['edit_example'] = array(
-        '#type'  => 'item',
-        '#value' => l('Edit Example', 'code_approval/editcode/' . $example_default_value),
-      );
-
-      $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>',
-      );
+            }
+            */
+            /* 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', 'textbook-companion/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', '');
     }
-  }
-  /************ END OF $_POST **************/
-
-  // if ($book_default_value > 0)
-  // {
-    $form['run']['message'] = array(
-      '#type' => 'textarea',
-      '#title' => t('If Dis-Approved please specify reason for Dis-Approval'),
+    return array(
+        '#type' => 'ajax',
+        '#commands' => $commands
     );
-  
-    $form['run']['submit'] = array(
-      '#type' => 'submit',
-      '#name' => 'Bulk_approval',
-      '#value' => t('Submit')
+}
+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
     );
-  // }
-
-  return $form;
 }
-
-
-function bulk_approval_form_submit($form, &$form_state)
+function edit_code_submission()
 {
-	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 (user_access('bulk manage code'))
-		{
-      			if ($form_state['values']['run']['approve_book'] == "1")
-      			{
-			        /* 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))
-			        {
-				          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);
-			        }
-			        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.');
-
-		      	} else if ($form_state['values']['run']['unapprove_book'] == "1") {
-
-			        /* 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))
-		        	{
-				          db_query("UPDATE {textbook_companion_example} SET approval_status = 0 WHERE chapter_id = %d", $chapter_data->id);
-			        }
-			        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.');
-
-		      	} else if ($form_state['values']['run']['disapprove_book'] == "1") {
-
-				if (!user_access('bulk delete code'))
-        			{
-          				drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Book.'), 'error');
-			        	return;
-        			}
-
-        			if (delete_book($form_state['values']['run']['book']))
-        			{
-			          	drupal_set_message(t('Dis-Approved and Deleted Entire Book.'), 'status');
-        			} else {
-          				drupal_set_message(t('Error Dis-Approving and Deleting Entire Book.'), 'error');
-        			}
-
-		        	/* 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.
-
-Reason for dis-approval:
-
-' . $form_state['values']['run']['message']);
-
-      			} else if ($form_state['values']['run']['delete_book_including_proposal'] == "1") {
-
-        			if (!user_access('bulk delete code'))
-        			{
-          				drupal_set_message(t('You do not have permission to Bulk Delete Entire Book Including Proposal.'), 'error');
-          				return;
-        			}
-
-        			/* 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))
-        			{
-          				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']))
-        			{
-          				drupal_set_message(t('Dis-Approved and Deleted Entire Book examples.'), 'status');
-
-          				$dir_path = $root_path . $form_state['values']['run']['book'];
-          				if (is_dir($dir_path))
-          				{
-            					$res = rmdir($dir_path);
-            					if (!$res)
-            					{
-              						drupal_set_message(t("Cannot delete Book directory : " . $dir_path . ". Please contact administrator."), 'error');
-              						return;
-            					}
-          				} else {
-            					drupal_set_message(t("Book directory not present : " . $dir_path . ". Skipping deleting book directory."), 'status');
-          				}
-
-          				/* deleting preference and proposal */
-          				$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $form_state['values']['run']['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);
-
-          				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.
-
-Reason for deletion:
-
-' . $form_state['values']['run']['message']);
-
-        			} else {
-          				drupal_set_message(t('Error Dis-Approving and Deleting Entire Book.'), 'error');
-        			}
-
-      			} else if ($form_state['values']['run']['approve_chapter'] == "1") {
-
-        			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.');
-
-      			} 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']['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.');
-
-      			} else if ($form_state['values']['run']['disapprove_chapter'] == "1") {
-
-        			if (!user_access('bulk delete code'))
-        			{
-          				drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Chapter.'), 'error');
-          				return;
-        			}
-
-        			if (delete_chapter($form_state['values']['run']['chapter']))
-        			{
-          				drupal_set_message(t('Dis-Approved and Deleted Entire Chapter.'), 'status');
-       	 			} else {
-          				drupal_set_message(t('Error Dis-Approving and Deleting Entire Chapter.'), 'error');
-        			}
-
-        			/* 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.
-
-Reason for dis-approval:
-
-' . $form_state['values']['run']['message']);
-
-      			} else if ($form_state['values']['run']['approve_example'] == "1") {
-
-        			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.');
-
-      			} else if ($form_state['values']['run']['unapprove_example'] == "1") {
-
-        			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.');
-
-      			} else if ($form_state['values']['run']['disapprove_example'] == "1") {
-
-        			if (delete_example($form_state['values']['run']['example']))
-        			{
-          				drupal_set_message(t('Example Dis-Approved and Deleted.'), 'status');
-        			} else {
-          				drupal_set_message(t('Error Dis-Approving and Deleting Example.'), 'error');
-        			}
-
-        			/* 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.
-
-Reason for dis-approval:
-
-' . $form_state['values']['run']['message']);
-
-      			}
-
-      			/****** sending email when everything done ******/
-      			if ($email_subject)
-      			{
-        			$email_to = $user->mail;
-        			$param['standard']['subject'] = $email_subject;
-        			$param['standard']['body'] = $email_body;
-        			if (!drupal_mail('textbook_companion', 'standard', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
-          				drupal_set_message('Error sending email message.', 'error');
-      			}
-
+    /* get pending proposals to be approved */
+    $proposal_rows = array();
+    /*$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} ORDER BY id DESC");*/
+    $query = db_select('textbook_companion_proposal');
+    $query->fields('textbook_companion_proposal');
+    $query->condition('proposal_status', 1);
+    $query->orderBy('id', 'DESC');
+    $proposal_q = $query->execute();
+    while ($proposal_data = $proposal_q->fetchObject()) {
+        /* get preference */
+        /*$preference_q = db_query("SELECT * FROM textbook_companion_preference WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);   
+        $preference_data = db_fetch_object($preference_q);*/
+        $query = db_select('textbook_companion_preference');
+        $query->fields('textbook_companion_preference');
+        $query->condition('proposal_id', $proposal_data->id);
+        $query->condition('approval_status', 1);
+        $query->condition('submited_all_examples_code', 1);
+        $query->range(0, 1);
+        $preference_q = $query->execute();
+        $preference_data = $preference_q->fetchObject();
+        if (!$preference_data) {
+            /* $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = 1 LIMIT 1", $proposal_data->id);  
+            $preference_data = db_fetch_object($preference_q);*/
+            $query = db_select('textbook_companion_preference');
+            $query->fields('textbook_companion_preference');
+            $query->condition('proposal_id', $proposal_data->id);
+            $query->condition('pref_number', 1);
+            //$query->condition('approval_status', 0);        
+            $query->range(0, 1);
+            $preference_q = $query->execute();
+            $preference_data = $preference_q->fetchObject();
+        }
+        $proposal_status = '';
+        switch ($preference_data->submited_all_examples_code) {
+            case 0:
+                $proposal_status = 'Code Submission Pending';
+                break;
+            case 1:
+                $proposal_status = 'Submitted code for all exmample for book';
+                break;
+        }
+        $proposal_rows[] = array(
+            "{$preference_data->book} <br> 
+<em>by {$preference_data->author}</em>",
+            l($proposal_data->full_name, 'user/' . $proposal_data->uid),
+            $proposal_status,
+            l('Edit', 'textbook-companion/code-approval/edit-code-submission/edit/' . $preference_data->id)
+        );
+    }
+    /* check if there are any pending proposals */
+    if (!$proposal_rows) {
+        drupal_set_message(t('There are no proposals.'), 'status');
+        return '';
+    }
+    $proposal_header = array(
+        'Title of the Book',
+        'Contributor Name',
+        'Status',
+        'Action'
+    );
+    $output = theme('table', array(
+        'header' => $proposal_header,
+        'rows' => $proposal_rows
+    ));
+    return $output;
+}
+function get_edit_code_submission($id = NULL)
+{
+    if ($id) {
+        return drupal_get_form('edit_code_submission_form', $id);
     } else {
-      drupal_set_message(t('You do not have permission to bulk manage code.'), 'error');
+        return 'Access denied';
     }
-	}
 }
-
-function _list_of_books()
+function edit_code_submission_form($form, $form_state, $preference_id)
 {
-  $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[$book_titles_data->id] = $book_titles_data->book . ' (Written by ' . $book_titles_data->author . ')';
-  }
-  return $book_titles;
+    /* get current proposal */
+    $preference_id = arg(4);
+    /*$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $preference_id);
+    $preference_data = db_fetch_object($preference_q);*/
+    $query = db_select('textbook_companion_preference');
+    $query->fields('textbook_companion_preference');
+    $query->condition('id', $preference_id);
+    $preference_data = $query->execute()->fetchObject();
+    if (!$preference_data) {
+        drupal_set_message(t('Invalid book selected. Please try again.'), 'error');
+        drupal_goto('textbook-companion/code-approval/edit-code-submission');
+        return;
+    }
+    $form = array();
+    $form['book'] = array(
+        '#type' => 'item',
+        '#title' => t('Title of the book'),
+        '#markup' => $preference_data->book
+    );
+    $form['author'] = array(
+        '#type' => 'item',
+        '#title' => t('Author Name'),
+        '#markup' => $preference_data->author
+    );
+    $form['isbn'] = array(
+        '#type' => 'item',
+        '#title' => t('ISBN No'),
+        '#markup' => $preference_data->isbn
+    );
+    $form['publisher'] = array(
+        '#type' => 'item',
+        '#title' => t('Publisher & Place'),
+        '#markup' => $preference_data->publisher
+    );
+    $form['edition'] = array(
+        '#type' => 'item',
+        '#title' => t('Edition'),
+        '#markup' => $preference_data->edition
+    );
+    $form['year'] = array(
+        '#type' => 'item',
+        '#title' => t('Year of pulication'),
+        '#markup' => $preference_data->year
+    );
+    $form['all_example_submitted'] = array(
+        '#type' => 'checkbox',
+        '#title' => t('Enable code submission interface for user'),
+        '#description' => 'Once you have submited this option user can upload more examples.',
+        '#required' => TRUE
+    );
+    $form['hidden_preference_id'] = array(
+        '#type' => 'hidden',
+        '#value' => $preference_id
+    );
+    $form['submit'] = array(
+        '#type' => 'submit',
+        '#value' => t('Submit')
+    );
+    $form['cancle'] = array(
+        '#type' => 'item',
+        '#markup' => l('Cancle', 'textbook-companion/code-approval/edit-code-submission')
+    );
+    return $form;
 }
-
-function _list_of_chapters($preference_id = 0)
+function edit_code_submission_form_validate($form, $form_state)
 {
-  $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[$book_chapters_data->id] = $book_chapters_data->number . '. ' . $book_chapters_data->name;
-  }
-  return $book_chapters;
+    if ($form_state['values']['all_example_submitted'] != 1) {
+        form_set_error('all_example_submitted', t('Please check the field if you are intrested to submit the all uploaded examples for review!'));
+    }
+    return;
 }
-
-function _list_of_examples($chapter_id = 0)
+function edit_code_submission_form_submit($form, $form_state)
 {
-  $book_examples = array('0' => 'Please select...');
-  $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))
-  {
-    $book_examples[$book_examples_data->id] = $book_examples_data->number . ' (' . $book_examples_data->caption . ')';
-  }
-  return $book_examples;
+    global $user;
+    if ($form_state['values']['all_example_submitted'] == 1) {
+        if (db_query('UPDATE textbook_companion_preference SET submited_all_examples_code = 0 WHERE id = :preference_id', array(
+            ':preference_id' => $form_state['values']['hidden_preference_id']
+        ))) {
+            $query = ("SELECT proposal_id FROM textbook_companion_preference WHERE id= :preference_id");
+            $args = array(
+                ":preference_id" => $form_state['values']['hidden_preference_id']
+            );
+            $proposal_data = db_query($query, $args);
+            $proposal_data_result = $proposal_data->fetchObject();
+            $proposal_query = db_select('textbook_companion_proposal');
+            $proposal_query->fields('textbook_companion_proposal');
+            $proposal_query->condition('proposal_status', 1);
+            $proposal_query->condition('id', $proposal_data_result->proposal_id);
+            $proposal_data_query = $proposal_query->execute()->fetchObject();
+            /* sending email */
+            $book_user = user_load($proposal_data_query->uid);
+            $email_to = $book_user->mail;
+            $from = variable_get('textbook_companion_from_email', '');
+            $bcc = variable_get('textbook_companion_emails', '');
+            $cc = variable_get('textbook_companion_cc_emails', '');
+            $param['all_code_submitted_status_changed']['proposal_id'] = $proposal_data_result->proposal_id;
+            $param['all_code_submitted_status_changed']['user_id'] = $user->uid;
+            $param['all_code_submitted_status_changed']['headers'] = array(
+                'From' => $from,
+                'MIME-Version' => '1.0',
+                'Content-Type' => 'text/plain; charset=UTF-8; format=flowed; delsp=yes',
+                'Content-Transfer-Encoding' => '8Bit',
+                'X-Mailer' => 'Drupal',
+                'Cc' => $cc,
+                'Bcc' => $bcc
+            );
+            if (!drupal_mail('textbook_companion', 'all_code_submitted_status_changed', $email_to, language_default(), $param, $from, TRUE))
+                drupal_set_message('Error sending email message.', 'error');
+            drupal_set_message('Enabled code submission interface for user');
+            drupal_goto('textbook-companion/code-approval/edit-code-submission');
+        }
+    }
 }
-