diff options
Diffstat (limited to 'search.inc')
| -rwxr-xr-x | search.inc | 274 |
1 files changed, 274 insertions, 0 deletions
diff --git a/search.inc b/search.inc new file mode 100755 index 0000000..9990b8c --- /dev/null +++ b/search.inc @@ -0,0 +1,274 @@ +<?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 pe.book as book, pe.author as author, pe.publisher as publisher, pe.year as year, pe.id as id FROM {textbook_companion_preference} pe RIGHT JOIN {textbook_companion_proposal} po on pe.proposal_id=po.id WHERE po.proposal_status=3 and pe.approval_status = 1", $query_character); + while ($book_data = db_fetch_object($book_q)) + { + /* Initial's fix algorithm */ + preg_match_all("/{$query_character}[a-z]+/", $book_data->author, $matches); + + if (count($matches) > 0) { + /* Remove the word "And"/i from the match array and make match bold */ + if (count($matches[0]) > 0) { + + foreach ($matches[0] as $key => $value) { + + if (strtolower($value) == "and") { + unset($matches[$key]); + } + else { + $matches[0][$key] = "<b>" . $value . "</b>"; + $book_data->author = str_replace($value, $matches[0][$key], $book_data->author); + } + } + } + + /* Check count of matches after removing And */ + if (count($matches[0]) > 0) { + $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 textbook_companion_browse_student() +{ + $return_html = _browse_list('student'); + $return_html .= '<br /><br />'; + $query_character = arg(2); + //print $query_character; + //die(); + if (!$query_character) { + /* all books */ + $return_html .= "Please select the starting character of the student's name"; + return $return_html; + } + $book_rows = array(); + $student_q = db_query(" + SELECT po.full_name, pe.book as book, pe.author as author, pe.publisher as publisher, pe.year as year, pe.id as pe_id, po.approval_date as approval_date + FROM textbook_companion_preference pe LEFT JOIN textbook_companion_proposal po ON pe.proposal_id = po.id + WHERE po.proposal_status = 3 AND pe.approval_status = 1 AND full_name LIKE '%s%%' + ", $query_character); + while ($student_data = db_fetch_object($student_q)) + { + $book_rows[] = array(l($student_data->book, 'textbook_run/' . $student_data->pe_id), $student_data->full_name); + } + if (!$book_rows) + { + $return_html .= "Sorry no books are available with that student's name"; + } else { + $book_header = array('Title of the Book', 'Student 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 '<div id="filter-links">' . $return_html . "</div>"; +} +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) { + +} |