initial repo 13-08-2013

1 files changed, 217 insertions, 0 deletions

diff --git a/search.inc b/search.inc
new file mode 100755
index 0000000..887ec1f
--- /dev/null
+++ b/search.inc
@@ -0,0 +1,217 @@
+<?php
+// $Id$
+
+function textbook_companion_search_form()
+{
+  $form['#redirect'] = FALSE;
+  $form['search'] = array(
+      '#type' => 'textfield',
+      '#title' => t('Search'),
+      '#size' => 48,
+  );
+
+  $form['search_by_title'] = array(
+      '#type' => 'checkbox',
+      '#default_value' => TRUE,
+      '#title' => t('Search by Title of the Book'),
+  );
+
+  $form['search_by_author'] = array(
+      '#type' => 'checkbox',
+      '#default_value' => TRUE,
+      '#title' => t('Search by Author of the Book'),
+  );
+
+  $form['submit'] = array(
+    '#type' => 'submit',
+    '#value' => t('Search')
+  );
+
+  $form['cancel'] = array(
+    '#type' => 'markup',
+    '#value' => l(t('Cancel'), ''),
+  );
+
+  if ($_POST)
+  {
+    $output = '';
+    $search_rows = array();
+    $search_query = '';
+    if ($_POST['search_by_title'] && $_POST['search_by_author'])
+      $search_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 AND (book LIKE '%%%s%%' OR author LIKE '%%%s%%')", $_POST['search'], $_POST['search']);
+    else if ($_POST['search_by_title'])
+      $search_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 AND book LIKE '%%%s%%'", $_POST['search']);
+    else if ($_POST['search_by_author'])
+      $search_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 AND author LIKE '%%%s%%'", $_POST['search']);
+    else
+      drupal_set_message('Please select whether to search by Title and/or Author of the Book.', 'error');
+    while ($search_data = db_fetch_object($search_q))
+    {
+      $search_rows[] = array(l($search_data->book, 'textbook_run/' . $search_data->id), $search_data->author); 
+    }
+    if ($search_rows)
+    {
+      $search_header = array('Title of the Book', 'Author Name');
+      $output .= theme_table($search_header, $search_rows);
+      $form['search_results'] = array(
+          '#type' => 'item',
+          '#title' => t('Search results for "') . $_POST['search'] . '"',
+          '#value' => $output,
+      );
+    } else {
+      $form['search_results'] = array(
+          '#type' => 'item',
+          '#title' => t('Search results for "') . $_POST['search'] . '"',
+          '#value' => 'No results found',
+      );
+    }
+  }
+  return $form;
+}
+
+/******************************************************************************/
+/**************************** BROWSE BY FORMS *********************************/
+/******************************************************************************/
+
+function textbook_companion_browse_book()
+{
+  $return_html = _browse_list('book');
+  $return_html .= '<br /><br />';
+  $query_character = arg(2);
+  if (!$query_character) {
+    /* all books */
+    $return_html .= "Please select the starting character of the title of the book";
+    return $return_html;
+  }
+  $book_rows = array();
+  $book_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE book like '%s%%' AND approval_status = 1", $query_character);
+  while ($book_data = db_fetch_object($book_q))
+  {
+    $book_rows[] = array(l($book_data->book, 'textbook_run/' . $book_data->id), $book_data->author);
+  }
+  if (!$book_rows)
+  {
+    $return_html .= "Sorry no books are available with that title";
+  } else {
+      $book_header = array('Title of the Book', 'Author Name');
+      $return_html .= theme_table($book_header, $book_rows);
+  }
+  return $return_html;
+}
+
+function textbook_companion_browse_author()
+{
+  $return_html = _browse_list('author');
+  $return_html .= '<br /><br />';
+  $query_character = arg(2);
+  if (!$query_character) {
+    /* all books */
+    $return_html .= "Please select the starting character of the author's name";
+    return $return_html;
+  }
+  $book_rows = array();
+  $book_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE author like '%s%%' AND approval_status = 1", $query_character);
+  while ($book_data = db_fetch_object($book_q))
+  {
+    $book_rows[] = array(l($book_data->book, 'textbook_run/' . $book_data->id), $book_data->author);
+  }
+  if (!$book_rows)
+  {
+    $return_html .= "Sorry no books are available with that author's name";
+  } else {
+      $book_header = array('Title of the Book', 'Author Name');
+      $return_html .= theme_table($book_header, $book_rows);
+  }
+  return $return_html;
+}
+
+function _browse_list($type)
+{
+  $return_html = '';
+  $char_list = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
+  foreach ($char_list as $char_name)
+  {
+    $return_html .= l($char_name, 'textbook_search/' . $type . '/' . $char_name);
+    if ($char_name != 'Z')
+      $return_html .= ' | ';
+  }
+  return $return_html;
+}
+function _list_of_colleges()
+{
+  $college_names = array('0' => '--- select ---');
+  $college_names_q = db_query("SELECT DISTINCT university FROM {textbook_companion_proposal} WHERE proposal_status=1 OR proposal_status=3 ORDER BY university ASC");
+  while ($college_names_data = db_fetch_object($college_names_q))
+  {
+    $college_names[$college_names_data->university] = $college_names_data->university;
+  }
+  return $college_names;
+}
+
+function _list_books_by_college($college) {
+	$query = "SELECT pro.full_name, pro.proposal_status, pre.id as preid, pre.book, pre.isbn FROM textbook_companion_proposal pro, textbook_companion_preference pre WHERE pro.university='".$college."' AND (pro.proposal_status=1 OR pro.proposal_status=3) AND pre.proposal_id=pro.id AND pre.approval_status=1";
+	$result = db_query($query);
+	$output = '<table><tr><th>SNO</th><th>Name</th><th>Book</th><th>ISBN</th><th>Status</th></tr>';
+	$sno = 1;
+	while($row = db_fetch_object($result)) {
+		
+		if($row->proposal_status == 1) {
+			$output .= '<tr><td>'.$sno++.'</td><td>'.$row->full_name.'</td><td>'.$row->book.'</td><td>'.str_replace("-", "", $row->isbn).'</td><td style="color: orange;">Approved</td>';
+		}else {
+			$output .= '<tr><td>'.$sno++.'</td><td>'.$row->full_name.'</td><td><a target="_blank" href="'.base_path().'textbook_run/'.$row->preid.'">'.$row->book.'</a></td><td>'.str_replace("-", "", $row->isbn).'</td><td style="color: green;">Completed</td>';
+		}
+		$output .= '</tr>';
+	}
+	
+	return $output;
+}
+
+function textbook_companion_browse_college_form($form_state) {
+  $form = array();
+
+  ahah_helper_register($form, $form_state);
+
+  
+  if (!isset($form_state['storage']['college_info']['college'])) {
+    $usage_default_value = '0';
+  }
+  else {
+    $usage_default_value =  $form_state['storage']['college_info']['college'];
+  }
+
+  $form['college_info'] = array(
+    '#type'   => 'fieldset',
+    '#prefix' => '<div id="college-info-wrapper">',
+    '#suffix' => '</div>',
+    '#tree'   => TRUE,
+  );
+  $form['college_info']['college'] = array(
+    '#type' => 'select',
+    '#title' => t('College Name'),
+    '#options' => _list_of_colleges(),
+    '#default_value' => $usage_default_value,
+    '#ahah' => array(
+      'event'   => 'change',
+      'path'    => ahah_helper_path(array('college_info')),
+      'wrapper' => 'college-info-wrapper',
+    ),
+  );
+  
+  
+  if ($usage_default_value != '0') {
+    $form['college_info']['book_details'] = array(
+			'#type' => 'item',
+			'#value' => _list_books_by_college($usage_default_value)
+		);
+  }
+
+  return $form;
+}
+
+function textbook_companion_browse_college_form_validate($form, &$form_state) {
+	
+}
+
+function textbook_companion_browse_college_form_submit($form, &$form_state) {
+  
+}