diff options
Diffstat (limited to 'manage_proposal.inc')
| -rwxr-xr-x | manage_proposal.inc | 1351 |
1 files changed, 1351 insertions, 0 deletions
diff --git a/manage_proposal.inc b/manage_proposal.inc new file mode 100755 index 0000000..3840c73 --- /dev/null +++ b/manage_proposal.inc @@ -0,0 +1,1351 @@ +<?php +// $Id$ + +function _proposal_pending() +{ + /* get pending proposals to be approved */ + $pending_rows = array(); + $pending_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status = 0 ORDER BY id DESC"); + while ($pending_data = db_fetch_object($pending_q)) + { + list($y, $m, $d) = explode('-', $pending_data->creation_date); + $cre_date = $d.'-'.$m.'-'.$y; + $dates = new DateTime($cre_date); + $creation_date = $dates->format('d-m-Y'); + list($y, $m, $d) = explode('-', $pending_data->expected_completion_date); + $exe_date = $d.'-'.$m.'-'.$y; + $exe_date = new DateTime($exe_date); + $expected_completion_date = $exe_date->format('d-m-Y'); + $pending_rows[$pending_data->id] = array($creation_date, l($pending_data->full_name, 'user/' . $pending_data->uid), $expected_completion_date, l('Approve', 'manage_proposal/approve/' . $pending_data->id) . ' | ' . l('Edit', 'manage_proposal/edit/' . $pending_data->id)); + } + + /* check if there are any pending proposals */ + if (!$pending_rows) + { + drupal_set_message(t('There are no pending proposals.'), 'status'); + return ''; + } + + $pending_header = array('Date of Submission', 'Contributor Name', 'Date of Completion', 'Action'); + $output = theme_table($pending_header, $pending_rows); + return $output; +} + +function _proposal_all() +{ + function _tbc_ext($status, $preference_id) { + if($status == "Approved") { + return " | " . l("ER", "tbc_external_review/add_book/" . $preference_id); + } + else { + return ""; + } + } + /* get pending proposals to be approved */ + $proposal_rows = array(); + $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} ORDER BY id DESC"); + while ($proposal_data = db_fetch_object($proposal_q)) + { + /* 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); + 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); + } + + $proposal_status = ''; + switch ($proposal_data->proposal_status) + { + case 0: $proposal_status = 'Pending'; break; + case 1: $proposal_status = 'Approved'; break; + case 2: $proposal_status = 'Dis-approved'; break; + case 3: $proposal_status = 'Completed'; break; + case 4: $proposal_status = 'External'; break; + default: $proposal_status = 'Unknown'; break; + } + list($y, $m, $d) = explode('-', $proposal_data->creation_date); + $cre_date = $d.'-'.$m.'-'.$y; + $dates = new DateTime($cre_date); + $creation_date = $dates->format('d-m-Y'); + list($y, $m, $d) = explode('-', $proposal_data->expected_completion_date); + $exe_date = $d.'-'.$m.'-'.$y; + $exe_date = new DateTime($exe_date); + $expected_completion_date = $exe_date->format('d-m-Y'); + + $proposal_rows[] = array( + $creation_date, + "{$preference_data->book} <br> <em>by {$preference_data->author}</em>", + l($proposal_data->full_name, 'user/' . $proposal_data->uid), + $expected_completion_date, + $proposal_status, + l('Status', 'manage_proposal/status/' . $proposal_data->id) . ' | ' . l('Edit', 'manage_proposal/edit/' . $proposal_data->id) . _tbc_ext($proposal_status, $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('Date of Submission', 'Title of the Book', 'Contributor Name', 'Expected Date of Completion', 'Status', 'Action'); + $output = theme_table($proposal_header, $proposal_rows); + return $output; +} + +function _category_all() +{ + /* get pending proposals to be approved */ + $preference_rows = array(); + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 ORDER BY id DESC"); + while ($preference_data = db_fetch_object($preference_q)) + { + switch ($preference_data->category) + { + case 0: $category_data = 'Not Selected'; break; + case 1: $category_data = 'Fluid Mechanics'; break; + case 2: $category_data = 'Control Theory & Control Systems'; break; + case 3: $category_data = 'Chemical Engineering'; break; + case 4: $category_data = 'Thermodynamics'; break; + case 5: $category_data = 'Mechanical Engineering'; break; + case 6: $category_data = 'Signal Processing'; break; + case 7: $category_data = 'Digital Communications'; break; + case 8: $category_data = 'Electrical Technology'; break; + case 9: $category_data = 'Mathematics & Pure Science'; break; + case 10: $category_data = 'Analog Electronics'; break; + case 11: $category_data = 'Digital Electronics'; break; + case 12: $category_data = 'Computer Programming'; break; + case 13: $category_data = 'Others'; break; + default: $category_data = 'Unknown'; break; + } + $preference_rows[] = array($preference_data->book ."<br> <i>by " .$preference_data->author."</i>", $preference_data->isbn, $preference_data->publisher, $preference_data->edition, $preference_data->year, $category_data, l('Edit', 'manage_proposal/category/edit/' . $preference_data->id)); + } + + $preference_header = array('Book', 'ISBN', 'Publisher', 'Edition', 'Year', 'Category', 'Status'); + $output = theme_table($preference_header, $preference_rows); + return $output; +} + +/******************************************************************************/ +/************************** PROPOSAL APPROVAL FORM ****************************/ +/******************************************************************************/ + +function proposal_approval_form($form_state) +{ + global $user; + + /* get current proposal */ + $proposal_id = arg(2); + $result = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status = 0 and id = %d", $proposal_id); + if ($result) + { + if ($row = db_fetch_object($result)) + { + /* everything ok */ + } else { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + } else { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + + $form['full_name'] = array( + '#type' => 'item', + '#value' => l($row->full_name, 'user/' . $row->uid), + '#title' => t('Contributor Name'), + ); + $form['email'] = array( + '#type' => 'item', + '#value' => user_load($row->uid)->mail, + '#title' => t('Email'), + ); + $form['mobile'] = array( + '#type' => 'item', + '#value' => $row->mobile, + '#title' => t('Mobile'), + ); + $form['how_project'] = array( + '#type' => 'item', + '#value' => $row->how_project, + '#title' => t('How did you come to know about this project'), + ); + $form['course'] = array( + '#type' => 'item', + '#value' => $row->course, + '#title' => t('Course'), + ); + $form['branch'] = array( + '#type' => 'item', + '#value' => $row->branch, + '#title' => t('Department/Branch'), + ); + $form['university'] = array( + '#type' => 'item', + '#value' => $row->university, + '#title' => t('University/Institute'), + ); + $form['faculty'] = array( + '#type' => 'item', + '#value' => $row->faculty, + '#title' => t('College Teacher/Professor'), + ); + $form['reviewer'] = array( + '#type' => 'item', + '#value' => $row->reviewer, + '#title' => t('Reviewer'), + ); + + list($y, $m, $d) = explode('-', $row->expected_completion_date); + $con_date = $d.'-'.$m.'-'.$y; + $date = new DateTime($con_date); + $expected_completion_date = $date->format('d-m-Y'); + $form['completion_date'] = array( + '#type' => 'item', + '#value' => $expected_completion_date, + '#title' => t('Expected Date of Completion'), + ); + $form['operating_system'] = array( + '#type' => 'item', + '#value' => $row->operating_system, + '#title' => t('Operating System'), + ); + $form['dwsim_version'] = array( + '#type' => 'item', + '#value' => $row->dwsim_version, + '#title' => t('DWSIM Version'), + ); + $form['reference'] = array( + '#type' => 'item', + '#value' => $row->reference, + '#title' => t('References'), + ); + $form['reason'] = array( + '#type' => 'item', + '#value' => $row->reason, + '#title' => t('Reasons'), + ); + + /* get book preference */ + $preference_rows = array(); + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d ORDER BY pref_number ASC", $proposal_id); + while ($preference_data = db_fetch_object($preference_q)) + { + $preference_rows[$preference_data->id] = $preference_data->book . ' (Written by ' . $preference_data->author . ')'; + } + if($row->proposal_type == 1){ + $form['book_preference'] = array( + '#type' => 'radios', + '#options' => $preference_rows, + '#title' => t('Book Preferences'), + '#required' => TRUE, + + ); + } + else{ + $form['book_preference'] = array( + '#type' => 'radios', + '#title' => t('Book Preferences'), + '#options' => $preference_rows, + '#required' => TRUE, + );} + + $form['disapprove'] = array( + '#type' => 'checkbox', + '#title' => t('Disapprove all the above book preferences'), + + ); + + $form['message'] = array( + '#type' => 'textarea', + '#title' => t('Reason for disapproval'), + ); + + $form['proposal_id'] = array( + '#type' => 'hidden', + '#value' => $proposal_id, + ); + + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + + $form['cancel'] = array( + '#type' => 'markup', + '#value' => l(t('Cancel'), 'manage_proposal'), + ); + return $form; +} + +function proposal_approval_form_submit($form, &$form_state) +{ + global $user; + + /* get current proposal */ + $proposal_id = $form_state['values']['proposal_id']; + $result = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status = 0 and id = %d", $proposal_id); + if ($result) + { + if ($row = db_fetch_object($result)) + { + /* everything ok */ + } else { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + } else { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + + /* disapprove */ + if ($form_state['values']['disapprove']) + { $dt = new DateTime(); + $current_date = $dt->format("Y-m-d"); + db_query("UPDATE {textbook_companion_proposal} SET approver_uid = %d, approval_date = %d, proposal_status = 2, message = '%s' WHERE id = %d", $user->uid, $current_date, $form_state['values']['message'], $proposal_id); + db_query("UPDATE {textbook_companion_preference} SET approval_status = 2 WHERE proposal_id = %d", $proposal_id); + + /* unlock all the aicte books */ + $query = " + UPDATE textbook_companion_aicte + SET status = 0, uid = 0, proposal_id = 0, preference_id = 0 + WHERE proposal_id = {$proposal_id} + "; + db_query($query); + /* sending email */ + $book_user = user_load($row->uid); + $param['proposal_disapproved']['proposal_id'] = $proposal_id; + $param['proposal_disapproved']['user_id'] = $row->uid; + $email_to = $book_user->mail; + if (!drupal_mail('textbook_companion', 'proposal_disapproved', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE)) + drupal_set_message('Error sending email message.', 'error'); + + drupal_set_message('Book proposal dis-approved. User has been notified of the dis-approval.', 'error'); + drupal_goto('manage_proposal'); + return; + } + $dt = new DateTime(); + $current_date = $dt->format("Y-m-d"); + /* get book preference and set the status */ + $preference_id = $form_state['values']['book_preference']; + db_query("UPDATE {textbook_companion_proposal} SET approver_uid = %d, approval_date = %d, proposal_status = 1 WHERE id = %d", $user->uid, $current_date, $proposal_id); + db_query("UPDATE {textbook_companion_preference} SET approval_status = 1 WHERE id = %d", $preference_id); + + /* unlock aicte books except the one which was approved out of 3 nos */ + $query = " + UPDATE textbook_companion_aicte + SET status = 0, uid = 0, proposal_id = 0, preference_id = 0 + WHERE proposal_id = {$proposal_id} AND preference_id != {$preference_id} + "; + db_query($query); + + /* sending email */ + $book_user = user_load($row->uid); + $param['proposal_approved']['proposal_id'] = $proposal_id; + $param['proposal_approved']['user_id'] = $row->uid; + $email_to = $book_user->mail; + if (!drupal_mail('textbook_companion', 'proposal_approved', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE)) + drupal_set_message('Error sending email message.', 'error'); + + drupal_set_message('Book proposal approved. User has been notified of the approval', 'status'); + drupal_goto('manage_proposal'); + return; +} + + +/******************************************************************************/ +/*************************** PROPOSAL STATUS FORM *****************************/ +/******************************************************************************/ + +function proposal_status_form($form_state) +{ + global $user; + + /* get current proposal */ + $proposal_id = arg(2); + $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $proposal_id); + if (!$proposal_data = db_fetch_object($proposal_q)) + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + + $form['full_name'] = array( + '#type' => 'item', + '#value' => $proposal_data->full_name, + '#title' => t('Contributor Name'), + ); + $form['email'] = array( + '#type' => 'item', + '#value' => user_load($proposal_data->uid)->mail, + '#title' => t('Email'), + ); + $form['mobile'] = array( + '#type' => 'item', + '#value' => $proposal_data->mobile, + '#title' => t('Mobile'), + ); + $form['how_project'] = array( + '#type' => 'item', + '#value' => $proposal_data->how_project, + '#title' => t('How did you come to know about this project'), + ); + $form['course'] = array( + '#type' => 'item', + '#value' => $proposal_data->course, + '#title' => t('Course'), + ); + $form['branch'] = array( + '#type' => 'item', + '#value' => $proposal_data->branch, + '#title' => t('Department/Branch'), + ); + $form['university'] = array( + '#type' => 'item', + '#value' => $proposal_data->university, + '#title' => t('University/Institute'), + ); + $form['faculty'] = array( + '#type' => 'item', + '#value' => $proposal_data->faculty, + '#title' => t('College Teacher/Professor'), + ); + $form['reviewer'] = array( + '#type' => 'item', + '#value' => $proposal_data->reviewer, + '#title' => t('Reviewer'), + ); + list($y, $m, $d) = explode('-', $proposal_data->expected_completion_date); + $con_date = $d.'-'.$m.'-'.$y; + $date = new DateTime($con_date); + $expected_completion_date = $date->format('d-m-Y'); + $form['completion_date'] = array( + '#type' => 'item', + '#value' => $expected_completion_date, + '#title' => t('Expected Date of Completion'), + ); + $form['operating_system'] = array( + '#type' => 'item', + '#value' => $proposal_data->operating_system, + '#title' => t('Operating System'), + ); + $form['dwsim_version'] = array( + '#type' => 'item', + '#value' => $proposal_data->dwsim_version, + '#title' => t('DWSIM Version'), + ); + if($proposal_data->proposal_type == 1) + { + $form['reason'] = array( + '#type' => 'item', + '#value' => $proposal_data->reason, + '#title' => t('Reason'), + ); + $form['reference'] = array( + '#type' => 'item', + '#value' => $proposal_data->reference, + '#title' => t('References'), + ); + } + + + /* get book preference */ + $preference_html = '<ul>'; + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d ORDER BY pref_number ASC", $proposal_id); + while ($preference_data = db_fetch_object($preference_q)) + { + if ($preference_data->approval_status == 1) + $preference_html .= '<li><strong>' . $preference_data->book . ' (Written by ' . $preference_data->author . ') - Approved Book</strong></li>'; + else + $preference_html .= '<li>' . $preference_data->book . ' (Written by ' . $preference_data->author . ')</li>'; + } + $preference_html .= '</ul>'; + + $form['book_preference'] = array( + '#type' => 'item', + '#value' => $preference_html, + '#title' => t('Book Preferences'), + ); + + $proposal_status = ''; + switch ($proposal_data->proposal_status) + { + case 0: $proposal_status = t('Pending'); break; + case 1: $proposal_status = t('Approved'); break; + case 2: $proposal_status = t('Dis-approved'); break; + case 3: $proposal_status = t('Completed'); break; + case 4: $proposal_status = t('External'); break; + default: $proposal_status = t('Unkown'); break; + } + $form['proposal_status'] = array( + '#type' => 'item', + '#value' => $proposal_status, + '#title' => t('Proposal Status'), + ); + + if ($proposal_data->proposal_status == 2) { + $form['message'] = array( + '#type' => 'item', + '#value' => $proposal_data->message, + '#title' => t('Reason for disapproval'), + ); + } + + if ($proposal_data->proposal_status == 1 || $proposal_data->proposal_status == 4) + { + $form['completed'] = array( + '#type' => 'checkbox', + '#title' => t('Completed'), + '#description' => t('Check if user has completed all the book examples.'), + ); + } + + if ($proposal_data->proposal_status == 0) + { + $form['approve'] = array( + '#type' => 'item', + '#value' => l('Click here', 'manage_proposal/approve/' . $proposal_id), + '#title' => t('Approve'), + ); + } + + $form['proposal_id'] = array( + '#type' => 'hidden', + '#value' => $proposal_id, + ); + + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + + $form['cancel'] = array( + '#type' => 'markup', + '#value' => l(t('Cancel'), 'manage_proposal/all'), + ); + return $form; +} + +function proposal_status_form_submit($form, &$form_state) +{ + global $user; + + /* get current proposal */ + $proposal_id = $form_state['values']['proposal_id']; + $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $proposal_id); + if (!$proposal_data = db_fetch_object($proposal_q)) + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + + /* set the book status to completed */ + + + if ($form_state['values']['completed'] == 1) + {$dt = new DateTime(); + $current_date = $dt->format("Y-m-d"); + db_query("UPDATE {textbook_companion_proposal} SET proposal_status = 3 , actual_completion_date = '".$current_date."' WHERE id = %d", $proposal_id); + + /* sending email */ + $book_user = user_load($proposal_data->uid); + $param['proposal_completed']['proposal_id'] = $proposal_id; + $param['proposal_completed']['user_id'] = $proposal_data->uid; + $email_to = $book_user->mail; + if (!drupal_mail('textbook_companion', 'proposal_completed', $email_to , language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE)) + drupal_set_message('Error sending email message.', 'error'); + + drupal_set_message('Congratulations! Book proposal has been marked as completed. User has been notified of the completion.', 'status'); + } + drupal_goto('manage_proposal'); + return; +} + + +/******************************************************************************/ +/**************************** PROPOSAL EDIT FORM ******************************/ +/******************************************************************************/ + +function proposal_edit_form($form_state,$nonaicte_book) +{ + global $user; + + /* get current proposal */ + $proposal_id = arg(2); + $proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d", $proposal_id); + if ($proposal_q) + { + $proposal_data = db_fetch_object($proposal_q); + if (!$proposal_data) + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + } else { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('manage_proposal'); + return; + } + + $user_data = user_load($proposal_data->uid); + + $preference1_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = %d LIMIT 1", $proposal_id, 1); + $preference1_data = db_fetch_object($preference1_q); + $preference2_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = %d LIMIT 1", $proposal_id, 2); + $preference2_data = db_fetch_object($preference2_q); + $preference3_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = %d LIMIT 1", $proposal_id, 3); + $preference3_data = db_fetch_object($preference3_q); + + $form['full_name'] = array( + '#type' => 'textfield', + '#title' => t('Full Name'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE, + '#default_value' => $proposal_data->full_name, + ); + $form['email_id'] = array( + '#type' => 'textfield', + '#title' => t('Email'), + '#size' => 30, + '#value' => $user_data->mail, + '#disabled' => TRUE, + ); + $form['mobile'] = array( + '#type' => 'textfield', + '#title' => t('Mobile No.'), + '#size' => 30, + '#maxlength' => 15, + '#required' => TRUE, + '#default_value' => $proposal_data->mobile, + ); + $form['how_project'] = array( + '#type' => 'select', + '#title' => t('How did you come to know about this project'), + '#options' => array('DWSIM Website' => 'DWSIM Website', + 'Friend' => 'Friend', + 'Professor/Teacher' => 'Professor/Teacher', + 'Mailing List' => 'Mailing List', + 'Poster in my/other college' => 'Poster in my/other college', + 'Others' => 'Others'), + '#required' => TRUE, + '#default_value' => $proposal_data->how_project, + ); + $form['course'] = array( + '#type' => 'textfield', + '#title' => t('Course'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE, + '#default_value' => $proposal_data->course, + ); + $form['branch'] = array( + '#type' => 'select', + '#title' => t('Department/Branch'), + '#options' => array('Electrical Engineering' => 'Electrical Engineering', + 'Electronics Engineering' => 'Electronics Engineering', + 'Computer Engineering' => 'Computer Engineering', + 'Chemical Engineering' => 'Chemical Engineering', + 'Instrumentation Engineering' => 'Instrumentation Engineering', + 'Mechanical Engineering' => 'Mechanical Engineering', + 'Civil Engineering' => 'Civil Engineering', + 'Physics' => 'Physics', + 'Mathematics' => 'Mathematics', + 'Others' => 'Others'), + '#required' => TRUE, + '#default_value' => $proposal_data->branch, + ); + $form['university'] = array( + '#type' => 'textfield', + '#title' => t('University/Institute'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $proposal_data->university, + ); + $form['faculty'] = array( + '#type' => 'textfield', + '#title' => t('College Teacher/Professor'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $proposal_data->faculty, + ); + $form['reviewer'] = array( + '#type' => 'textfield', + '#title' => t('Reviewer'), + '#size' => 30, + '#maxlength' => 100, + '#default_value' => $proposal_data->reviewer, + ); + list($y, $m, $d) = explode('-', $proposal_data->expected_completion_date); + $con_date = $d.'-'.$m.'-'.$y; + $date = new DateTime($con_date); + $expected_completion_date = $date->format('d-m-Y'); + $form['completion_date'] = array( + '#type' => 'textfield', + '#title' => t('Expected Date of Completion'), + '#description' => t('Input date format should be DD-MM-YYYY. Eg: 23-03-2011'), + '#size' => 10, + '#maxlength' => 10, + '#default_value' => $expected_completion_date, + ); + $form['dwsim_version'] = array( + '#type' => 'textfield', + '#title' => t('DWSIM Version'), + '#size' => 10, + '#maxlength' => 20, + '#default_value' => $proposal_data->dwsim_version, + ); + $form['operating_system'] = array( + '#type' => 'textfield', + '#title' => t('Operating System'), + '#size' => 30, + '#maxlength' => 50, + '#default_value' => $proposal_data->operating_system, + ); + $form['preference1'] = array( + '#type' => 'fieldset', + '#title' => t('Book Preference'), + '#collapsible' => TRUE, + '#collapsed' => FALSE, + ); + $form['preference1']['book1'] = array( + '#type' => 'textfield', + '#title' => t('Title of the book'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference1_data->book, + ); + $form['preference1']['author1'] = array( + '#type' => 'textfield', + '#title' => t('Author Name'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference1_data->author, + ); + $form['preference1']['isbn1'] = array( + '#type' => 'textfield', + '#title' => t('ISBN No'), + '#size' => 30, + '#maxlength' => 25, + '#required' => TRUE, + '#default_value' => $preference1_data->isbn, + ); + $form['preference1']['publisher1'] = array( + '#type' => 'textfield', + '#title' => t('Publisher & Place'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE, + '#default_value' => $preference1_data->publisher, + ); + $form['preference1']['edition1'] = array( + '#type' => 'textfield', + '#title' => t('Edition'), + '#size' => 4, + '#maxlength' => 2, + '#required' => TRUE, + '#default_value' => $preference1_data->edition, + ); + $form['preference1']['year1'] = array( + '#type' => 'textfield', + '#title' => t('Year of pulication'), + '#size' => 4, + '#maxlength' => 4, + '#required' => TRUE, + '#default_value' => $preference1_data->year, + ); + /*if($preference2_data){ + $form['preference2'] = array( + '#type' => 'fieldset', + '#title' => t('Book Preference 2'), + '#collapsible' => TRUE, + '#collapsed' => FALSE, + ); + $form['preference2']['book2'] = array( + '#type' => 'textfield', + '#title' => t('Title of the book'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference2_data->book, + ); + $form['preference2']['author2'] = array( + '#type' => 'textfield', + '#title' => t('Author Name'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference2_data->author, + ); + $form['preference2']['isbn2'] = array( + '#type' => 'textfield', + '#title' => t('ISBN No'), + '#size' => 30, + '#maxlength' => 25, + '#required' => TRUE, + '#default_value' => $preference2_data->isbn, + ); + $form['preference2']['publisher2'] = array( + '#type' => 'textfield', + '#title' => t('Publisher & Place'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE, + '#default_value' => $preference2_data->publisher, + ); + $form['preference2']['edition2'] = array( + '#type' => 'textfield', + '#title' => t('Edition'), + '#size' => 4, + '#maxlength' => 2, + '#required' => TRUE, + '#default_value' => $preference2_data->edition, + ); + $form['preference2']['year2'] = array( + '#type' => 'textfield', + '#title' => t('Year of pulication'), + '#size' => 4, + '#maxlength' => 4, + '#required' => TRUE, + '#default_value' => $preference2_data->year, + ); +} +if($preference3_data){ + $form['preference3'] = array( + '#type' => 'fieldset', + '#title' => t('Book Preference 3'), + '#collapsible' => TRUE, + '#collapsed' => FALSE, + ); + $form['preference3']['book3'] = array( + '#type' => 'textfield', + '#title' => t('Title of the book'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference3_data->book, + ); + $form['preference3']['author3'] = array( + '#type' => 'textfield', + '#title' => t('Author Name'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference3_data->author, + ); + $form['preference3']['isbn3'] = array( + '#type' => 'textfield', + '#title' => t('ISBN No'), + '#size' => 30, + '#maxlength' => 25, + '#required' => TRUE, + '#default_value' => $preference3_data->isbn, + ); + $form['preference3']['publisher3'] = array( + '#type' => 'textfield', + '#title' => t('Publisher & Place'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE, + '#default_value' => $preference3_data->publisher, + ); + $form['preference3']['edition3'] = array( + '#type' => 'textfield', + '#title' => t('Edition'), + '#size' => 4, + '#maxlength' => 2, + '#required' => TRUE, + '#default_value' => $preference3_data->edition, + ); + $form['preference3']['year3'] = array( + '#type' => 'textfield', + '#title' => t('Year of pulication'), + '#size' => 4, + '#maxlength' => 4, + '#required' => TRUE, + '#default_value' => $preference3_data->year, + ); +}*/ + + /* hidden fields */ + $form['hidden_proposal_id'] = array( + '#type' => 'hidden', + '#value' => $proposal_id, + ); + + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + $form['cancel'] = array( + '#type' => 'markup', + '#value' => l(t('Cancel'), 'manage_proposal'), + ); + return $form; +} + +function proposal_edit_form_validate($form, &$form_state) + +{ + + /* mobile */ + if (!preg_match('/^[0-9\ \+]{0,15}$/', $form_state['values']['mobile'])) + form_set_error('mobile', t('Invalid mobile number')); + + /* date of completion */ + if (!preg_match('/^[0-9]{1,2}-[0-9]{1,2}-[0-9]{4}$/', $form_state['values']['completion_date'])) + form_set_error('completion_date', t('Invalid expected date of completion')); + + list($d, $m, $y) = explode('-', $form_state['values']['completion_date']); + $d = (int)$d; $m = (int)$m; $y = (int)$y; + if (!checkdate($m, $d, $y)) + form_set_error('completion_date', t('Invalid expected date of completion')); + //if (mktime(0, 0, 0, $m, $d, $y) <= time()) + //form_set_error('completion_date', t('Expected date of completion should be in future')); + + /* edition */ + if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition1'])) + form_set_error('edition1', t('Invalid edition for Book Preference 1')); + if($form_state['values']['edition2']){ + if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition2'])) + form_set_error('edition2', t('Invalid edition for Book Preference 2')); + if (!preg_match('/^[1-9][0-9]{0,1}$/', $form_state['values']['edition3'])) + form_set_error('edition3', t('Invalid edition for Book Preference 3')); +} + + + /* year of publication */ + if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year1'])) + form_set_error('year1', t('Invalid year of pulication for Book Preference 1')); + if($form_state['values']['edition2']){ + if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year2'])) + form_set_error('year2', t('Invalid year of pulication for Book Preference 2')); + if (!preg_match('/^[1-3][0-9][0-9][0-9]$/', $form_state['values']['year3'])) + form_set_error('year3', t('Invalid year of pulication for Book Preference 3')); +} + + /* year of publication */ + $cur_year = date('Y'); + if ((int)$form_state['values']['year1'] > $cur_year) + form_set_error('year1', t('Year of pulication should be not in the future for Book Preference 1')); + if ((int)$form_state['values']['year2'] > $cur_year) + form_set_error('year2', t('Year of pulication should be not in the future for Book Preference 2')); + if ((int)$form_state['values']['year3'] > $cur_year) + form_set_error('year3', t('Year of pulication should be not in the future for Book Preference 3')); + + /* isbn */ + if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn1'])) + form_set_error('isbn1', t('Invalid ISBN for Book Preference 1')); + if($form_state['values']['edition2']){ + if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn2'])) + form_set_error('isbn2', t('Invalid ISBN for Book Preference 2')); + if (!preg_match('/^[0-9\-xX]+$/', $form_state['values']['isbn3'])) + form_set_error('isbn3', t('Invalid ISBN for Book Preference 3')); +} + return; +} + +function proposal_edit_form_submit($form, &$form_state) +{ + /* completion date to timestamp */ + list($d, $m, $y) = explode('-', $form_state['values']['completion_date']); + $con_date = $y.'-'.$m.'-'.$d; + $date = new DateTime($con_date); + $expected_completion_date = $date->format('Y-m-d'); + $proposal_id = $form_state['values']['hidden_proposal_id']; + + + $query = "UPDATE {textbook_companion_proposal} SET full_name = '".$form_state['values']['full_name']."', mobile = '".$form_state['values']['mobile']."', how_project = '".$form_state['values']['how_project']."', course = '".$form_state['values']['course']."', branch = '".$form_state['values']['branch']."', university = '".$form_state['values']['university']."', faculty = '".$form_state['values']['faculty']."', reviewer = '".$form_state['values']['reviewer']."', expected_completion_date = '$expected_completion_date', operating_system= '".$form_state['values']['operating_system']."', dwsim_version= '".$form_state['values']['dwsim_version']."' WHERE id =".$proposal_id; + + + db_query($query); + + +/*db_query("UPDATE {textbook_companion_proposal} SET full_name = '%s', mobile = '%s', how_project = '%s', course = '%s', branch = '%s', university = '%s', faculty = '%s', reviewer = '%s', completion_date = %d, operating_system= '%s', scilab_version= '%s' WHERE id = %d", + $form_state['values']['full_name'], + $form_state['values']['mobile'], + $form_state['values']['how_project'], + $form_state['values']['course'], + $form_state['values']['branch'], + $form_state['values']['university'], + $form_state['values']['faculty'], + $form_state['values']['reviewer'], + $completion_date_timestamp, + $form_state['values']['operating_system'], + $form_state['values']['scilab_version'], + $proposal_id); */ + + $preference1_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = %d LIMIT 1", $proposal_id, 1); + $preference1_data = db_fetch_object($preference1_q); + if ($preference1_data) + $preference1_id = $preference1_data->id; + $preference2_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = %d LIMIT 1", $proposal_id, 2); + $preference2_data = db_fetch_object($preference2_q); + if ($preference2_data) + $preference2_id = $preference2_data->id; + $preference3_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND pref_number = %d LIMIT 1", $proposal_id, 3); + $preference3_data = db_fetch_object($preference3_q); + if ($preference3_data) + $preference3_id = $preference3_data->id; + + if ($preference1_data) + { + del_book_pdf($preference1_data->id); + db_query("UPDATE {textbook_companion_preference} SET book = '%s', author = '%s', isbn = '%s', publisher = '%s', edition = %d, year = %d WHERE id = %d", + $form_state['values']['book1'], + $form_state['values']['author1'], + $form_state['values']['isbn1'], + $form_state['values']['publisher1'], + $form_state['values']['edition1'], + $form_state['values']['year1'], + $preference1_id); + } + if ($preference2_data) + { + del_book_pdf($preference2_data->id); + db_query("UPDATE {textbook_companion_preference} SET book = '%s', author = '%s', isbn = '%s', publisher = '%s', edition = %d, year = %d WHERE id = %d", + $form_state['values']['book2'], + $form_state['values']['author2'], + $form_state['values']['isbn2'], + $form_state['values']['publisher2'], + $form_state['values']['edition2'], + $form_state['values']['year2'], + $preference2_id); + } + if ($preference3_data) + { + del_book_pdf($preference3_data->id); + db_query("UPDATE {textbook_companion_preference} SET book = '%s', author = '%s', isbn = '%s', publisher = '%s', edition = %d, year = %d WHERE id = %d", + $form_state['values']['book3'], + $form_state['values']['author3'], + $form_state['values']['isbn3'], + $form_state['values']['publisher3'], + $form_state['values']['edition3'], + $form_state['values']['year3'], + $preference3_id); + } + drupal_set_message(t('Proposal Updated'), 'status'); +} + + + +/******************************************************************************/ +/**************************** CATEGORY EDIT FORM ******************************/ +/******************************************************************************/ + +function category_edit_form($form_state) +{ + /* get current proposal */ + $preference_id = arg(3); + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $preference_id); + $preference_data = db_fetch_object($preference_q); + if (!$preference_data) + { + drupal_set_message(t('Invalid book selected. Please try again.'), 'error'); + drupal_goto('manage_proposal/category'); + return; + } + + $form['book'] = array( + '#type' => 'item', + '#title' => t('Title of the book'), + '#value' => $preference_data->book, + ); + $form['author'] = array( + '#type' => 'item', + '#title' => t('Author Name'), + '#value' => $preference_data->author, + ); + $form['isbn'] = array( + '#type' => 'item', + '#title' => t('ISBN No'), + '#value' => $preference_data->isbn, + ); + $form['publisher'] = array( + '#type' => 'item', + '#title' => t('Publisher & Place'), + '#value' => $preference_data->publisher, + ); + $form['edition'] = array( + '#type' => 'item', + '#title' => t('Edition'), + '#value' => $preference_data->edition, + ); + $form['year'] = array( + '#type' => 'item', + '#title' => t('Year of pulication'), + '#value' => $preference_data->year, + ); + $form['category'] = array( + '#type' => 'select', + '#title' => t('Category'), + '#options' => array(0 => 'Please select', + 1 => 'Fluid Mechanics', + 2 => 'Control Theory & Control Systems', + 3 => 'Chemical Engineering', + 4 => 'Thermodynamics', + 5 => 'Mechanical Engineering', + 6 => 'Signal Processing', + 7 => 'Digital Communications', + 8 => 'Electrical Technology', + 9 => 'Mathematics & Pure Science', + 10 => 'Analog Electronics', + 11 => 'Digital Electronics', + 12 => 'Computer Programming', + 13 => 'Others'), + '#required' => TRUE, + '#default_value' => $preference_data->category, + ); + + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + $form['cancel'] = array( + '#type' => 'markup', + '#value' => l(t('Cancel'), 'manage_proposal/category'), + ); + return $form; +} + +function category_edit_form_submit($form, &$form_state) +{ + /* get current proposal */ + $preference_id = (int)arg(3); + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $preference_id); + $preference_data = db_fetch_object($preference_q); + if (!$preference_data) + { + drupal_set_message(t('Invalid book selected. Please try again.'), 'error'); + drupal_goto('manage_proposal/category'); + return; + } + + db_query("UPDATE {textbook_companion_preference} SET category = %d WHERE id = %d", $form_state['values']['category'], $preference_data->id); + + drupal_set_message(t('Book Category Updated'), 'status'); + drupal_goto('manage_proposal/category'); +} + +/****************************************************************/ +/* Data entry forms */ +/****************************************************************/ + +function _data_entry_proposal_all() +{ + /* get pending proposals to be approved */ + $proposal_rows = array(); + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 ORDER BY book ASC"); + $sno = 1; + while ($preference_data = db_fetch_object($preference_q)) + { + $proposal_rows[] = array($sno++, $preference_data->book, $preference_data->author, $preference_data->isbn, l('Edit', 'dataentry_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('SNO', 'Title of the Book', 'Author', 'ISBN', ''); + $output = theme_table($proposal_header, $proposal_rows); + return $output; +} + +function dataentry_edit($id = NULL) { + if($id) { + return drupal_get_form('dataentry_edit_form', $id); + }else { + return 'Access denied'; + } +} + +function dataentry_edit_form($form_state, $id) +{ + global $user; + + $preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d", $id); + $preference_data = db_fetch_object($preference_q); + + $form['id'] = array( + '#type' => 'hidden', + '#required' => TRUE, + '#value' => $id, + ); + $form['book'] = array( + '#type' => 'textfield', + '#title' => t('Title of the book'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference_data->book, + ); + $form['author'] = array( + '#type' => 'textfield', + '#title' => t('Author Name'), + '#size' => 30, + '#maxlength' => 100, + '#required' => TRUE, + '#default_value' => $preference_data->author, + ); + $form['isbn'] = array( + '#type' => 'textfield', + '#title' => t('ISBN No'), + '#size' => 30, + '#maxlength' => 25, + '#required' => TRUE, + '#attribute' => array('readonly' => 'readonly'), + '#default_value' => $preference_data->isbn, + ); + $form['publisher'] = array( + '#type' => 'textfield', + '#title' => t('Publisher & Place'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE, + '#default_value' => $preference_data->publisher, + ); + $form['edition'] = array( + '#type' => 'textfield', + '#title' => t('Edition'), + '#size' => 4, + '#maxlength' => 2, + '#required' => TRUE, + '#default_value' => $preference_data->edition, + ); + $form['year'] = array( + '#type' => 'textfield', + '#title' => t('Year of pulication'), + '#size' => 4, + '#maxlength' => 4, + '#required' => TRUE, + '#default_value' => $preference_data->year, + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + + return $form; +} + +function dataentry_edit_form_submit($form, &$form_state) +{ + db_query("UPDATE {textbook_companion_preference} SET book = '%s', author = '%s', isbn = '%s', publisher = '%s', edition = '%s', year = %d WHERE id = %d", $_POST['book'], $_POST['author'], $_POST['isbn'], $_POST['publisher'], $_POST['edition'], $_POST['year'], $_POST['id']); + drupal_set_message('Book details updated successfully'); + drupal_goto('dataentry_book'); +} + + +function _failed_all($preference_id=0, $confirm="") { + $page_content = ""; + if($preference_id && $confirm == "yes"){ + $query = " + SELECT *, pro.id as proposal_id FROM textbook_companion_proposal pro + LEFT JOIN textbook_companion_preference pre ON pre.proposal_id = pro.id + LEFT JOIN users usr ON usr.uid = pro.uid + WHERE pre.id = {$preference_id} + "; + $result = db_query($query); + $row = db_fetch_object($result); + + /* increment failed_reminder */ + $query = " + UPDATE textbook_companion_proposal + SET failed_reminder = failed_reminder + 1 + WHERE id = {$row->proposal_id} + "; + db_query($query); + + /* sending mail */ + $to = $row->mail; + $subject = "Failed to upload the TBC codes on time"; + $body = " + <p> + Dear {$row->name},<br><br> + This is to inform you that you have failed to upload the TBC codes on time.<br> + Please note that the time you have taken is way past the deadline as well.<br> + Kindly upload the TBC codes on the interface within 5 days from now.<br> + Failure to submit the same will result in disapproval of your work and cancellation of your internship.<br><br> + Regards,<br> + DWSIM Team + </p> + "; + + $message = array( + "to" => $to, + "subject" => $subject, + "body" => $body, + "headers" => array( + "From" => "textbook@dwsim.fossee.in", + "Bcc" => "textbook@dwsim.fossee.in, prashantsinalkar@gmail.com", + "Content-Type" => "text/html; charset=UTF-8; format=flowed" + ) + ); + drupal_mail_send($message); + drupal_set_message("Reminder sent successfully."); + drupal_goto("manage_proposal/failed"); + } else if($preference_id) { + $query = " + SELECT * FROM textbook_companion_preference pre + LEFT JOIN textbook_companion_proposal pro ON pro.id = pre.proposal_id + WHERE pre.id = {$preference_id} + "; + $result = db_query($query); + $row = db_fetch_object($result); + $page_content .= "Are you sure you want to notify?<br><br>"; + $page_content .= "Book: <b>{$row->book}</b><br>"; + $page_content .= "Author: <b>{$row->author}</b><br>"; + $page_content .= "Contributor: <b>{$row->full_name}</b><br>"; + $page_content .= "Expected Completion Date: <b>" . date("d-m-Y", $row->completion_date) . "</b><br><br>"; + $page_content .= l("Yes", "manage_proposal/failed/{$preference_id}/yes") . " | "; + $page_content .= l("Cancel", "manage_proposal/failed"); + } else { + $query = " + SELECT * FROM textbook_companion_proposal pro + LEFT JOIN textbook_companion_preference pre ON pre.proposal_id = pro.id + LEFT JOIN users usr ON usr.uid = pro.uid + WHERE pro.proposal_status = 1 AND pre.approval_status = 1 AND pro.expected_completion_date < %d + ORDER BY failed_reminder + "; + $result = db_query($query, time()); + + $headers = array( + "Date of Submission", "Book", "Contributor Name", + "Expected Completion Date", "Remainders", "Action" + ); + $rows = array(); + + while ($row = db_fetch_object($result)) { + $item =array( + date("d-m-Y", $row->creation_date), + "{$row->book}<br><i>by</i> {$row->author}", + $row->name, + date("d-m-Y", $row->completion_date), + $row->failed_reminder, + l("Remind", "manage_proposal/failed/{$row->id}") + ); + array_push($rows, $item); + } + $page_content .= theme("table", $headers, $rows); + } + + return $page_content; +} |