diff options
Diffstat (limited to 'solution_proposal.inc')
| -rwxr-xr-x | solution_proposal.inc | 427 |
1 files changed, 221 insertions, 206 deletions
diff --git a/solution_proposal.inc b/solution_proposal.inc index f2d1047..53abe30 100755 --- a/solution_proposal.inc +++ b/solution_proposal.inc @@ -1,221 +1,236 @@ <?php // $Id$ - function lab_migration_proposal_open() -{ - global $user; - - /* get open proposal list */ - $proposal_rows = array(); - //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE approval_status = 1 AND solution_provider_uid = 0"); - $query = db_select('lab_migration_proposal'); - $query->fields('lab_migration_proposal'); - $query->condition('approval_status', 1); - $query->condition('solution_provider_uid', 0); - $proposal_q = $query->execute(); - while ($proposal_data = $proposal_q->fetchObject()) { - $proposal_rows[] = array(l($proposal_data->lab_title, 'lab-migration/show-proposal/' . $proposal_data->id), l('Apply', 'lab-migration/show-proposal/' . $proposal_data->id)); + global $user; + /* get open proposal list */ + $proposal_rows = array(); + //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE approval_status = 1 AND solution_provider_uid = 0"); + $query = db_select('lab_migration_proposal'); + $query->fields('lab_migration_proposal'); + $query->condition('approval_status', 1); + $query->condition('solution_provider_uid', 0); + $proposal_q = $query->execute(); + while ($proposal_data = $proposal_q->fetchObject()) + { + $proposal_rows[] = array( + l($proposal_data->lab_title, 'lab-migration/show-proposal/' . $proposal_data->id), + l('Apply', 'lab-migration/show-proposal/' . $proposal_data->id) + ); + } + $proposal_header = array( + 'Title of the Lab', + 'Actions' + ); + $return_html = theme('table', array( + 'header' => $proposal_header, + 'rows' => $proposal_rows + )); + //$return_html = theme_table($proposal_header, $proposal_rows); + return $return_html; } - - $proposal_header = array('Title of the Lab', 'Actions'); - $return_html = theme('table', array('header' => $proposal_header, 'rows' => $proposal_rows)); - //$return_html = theme_table($proposal_header, $proposal_rows); - return $return_html; -} - function lab_migration_solution_proposal_form($form, $form_state) -{ - global $user; - - $proposal_id = (int)arg(2); - - //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id); - $query = db_select('lab_migration_proposal'); - $query->fields('lab_migration_proposal'); - $query->condition('id', $proposal_id); - $proposal_q = $query->execute(); - $proposal_data = $proposal_q->fetchObject(); - if (!$proposal_data) { - drupal_set_message("Invalid proposal.", 'error'); - drupal_goto(''); - } + global $user; + $proposal_id = (int) arg(2); + //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id); + $query = db_select('lab_migration_proposal'); + $query->fields('lab_migration_proposal'); + $query->condition('id', $proposal_id); + $proposal_q = $query->execute(); + $proposal_data = $proposal_q->fetchObject(); + if (!$proposal_data) + { + drupal_set_message("Invalid proposal.", 'error'); + drupal_goto(''); + } //var_dump($proposal_data->name); die; - $form['name'] = array( - '#type' => 'item', - '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->name, 'user/' . $proposal_data->uid), - '#title' => t('Proposer Name'), - ); - $form['lab_title'] = array( - '#type' => 'item', - '#markup' => $proposal_data->lab_title, - '#title' => t('Title of the Lab'), - ); - - $experiment_html = ''; - //$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d", $proposal_id); - $query = db_select('lab_migration_experiment'); - $query->fields('lab_migration_experiment'); - $query->condition('proposal_id', $proposal_id); - $experiment_q = $query->execute(); - while ($experiment_data = $experiment_q->fetchObject()) { - $experiment_html .= $experiment_data->title . "<br/>"; - } - $form['experiment'] = array( - '#type' => 'item', - '#markup' => $experiment_html, - '#title' => t('Experiment List'), - ); - - $form['solution_provider_name_title'] = array( - '#type' => 'select', - '#title' => t('Title'), - '#options' => array('Mr' => 'Mr', 'Ms' => 'Ms', 'Mrs' => 'Mrs', 'Dr' => 'Dr', 'Prof' => 'Prof'), - '#required' => TRUE, - ); - $form['solution_provider_name'] = array( - '#type' => 'textfield', - '#title' => t('Name of the Solution Provider'), - '#size' => 30, - '#maxlength' => 50, - '#required' => TRUE, - ); - $form['solution_provider_email_id'] = array( - '#type' => 'textfield', - '#title' => t('Email'), - '#size' => 30, - '#value' => $user->mail, - '#disabled' => TRUE, - ); - $form['solution_provider_contact_ph'] = array( - '#type' => 'textfield', - '#title' => t('Contact No.'), - '#size' => 30, - '#maxlength' => 15, - '#required' => TRUE, - ); - $form['solution_provider_department'] = array( - '#type' => 'select', - '#title' => t('Department/Branch'), - '#options' => _list_of_departments(), - '#required' => TRUE, - ); - $form['solution_provider_university'] = array( - '#type' => 'textfield', - '#title' => t('University/Institute'), - '#size' => 30, - '#maxlength' => 50, - '#required' => TRUE, - ); - $form['version'] = array( - '#type' => 'select', - '#title' => t('Version'), - '#options' => _list_of_software_version(), - '#required' => TRUE, - ); - $form['older'] = array( - '#type' => 'textfield', - '#size' => 30, - '#maxlength' => 50, - //'#required' => TRUE, - '#description' => t('Specify the Older version used'), - '#states' => array( - 'visible' => array( - ':input[name="version"]' => array('value' => 'olderversion'), - ), - ), - ); - - $form['submit'] = array( - '#type' => 'submit', - '#value' => t('Apply for Solution'), - ); - return $form; -} - + $form['name'] = array( + '#type' => 'item', + '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->name, 'user/' . $proposal_data->uid), + '#title' => t('Proposer Name') + ); + $form['lab_title'] = array( + '#type' => 'item', + '#markup' => $proposal_data->lab_title, + '#title' => t('Title of the Lab') + ); + $experiment_html = ''; + //$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d", $proposal_id); + $query = db_select('lab_migration_experiment'); + $query->fields('lab_migration_experiment'); + $query->condition('proposal_id', $proposal_id); + $experiment_q = $query->execute(); + while ($experiment_data = $experiment_q->fetchObject()) + { + $experiment_html .= $experiment_data->title . "<br/>"; + } + $form['experiment'] = array( + '#type' => 'item', + '#markup' => $experiment_html, + '#title' => t('Experiment List') + ); + $form['solution_provider_name_title'] = array( + '#type' => 'select', + '#title' => t('Title'), + '#options' => array( + 'Mr' => 'Mr', + 'Ms' => 'Ms', + 'Mrs' => 'Mrs', + 'Dr' => 'Dr', + 'Prof' => 'Prof' + ), + '#required' => TRUE + ); + $form['solution_provider_name'] = array( + '#type' => 'textfield', + '#title' => t('Name of the Solution Provider'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE + ); + $form['solution_provider_email_id'] = array( + '#type' => 'textfield', + '#title' => t('Email'), + '#size' => 30, + '#value' => $user->mail, + '#disabled' => TRUE + ); + $form['solution_provider_contact_ph'] = array( + '#type' => 'textfield', + '#title' => t('Contact No.'), + '#size' => 30, + '#maxlength' => 15, + '#required' => TRUE + ); + $form['solution_provider_department'] = array( + '#type' => 'select', + '#title' => t('Department/Branch'), + '#options' => _list_of_departments(), + '#required' => TRUE + ); + $form['solution_provider_university'] = array( + '#type' => 'textfield', + '#title' => t('University/Institute'), + '#size' => 30, + '#maxlength' => 50, + '#required' => TRUE + ); + $form['version'] = array( + '#type' => 'select', + '#title' => t('Version'), + '#options' => _list_of_software_version(), + '#required' => TRUE + ); + $form['older'] = array( + '#type' => 'textfield', + '#size' => 30, + '#maxlength' => 50, + //'#required' => TRUE, + '#description' => t('Specify the Older version used'), + '#states' => array( + 'visible' => array( + ':input[name="version"]' => array( + 'value' => 'olderversion' + ) + ) + ) + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Apply for Solution') + ); + return $form; + } function lab_migration_solution_proposal_form_validate($form, &$form_state) -{ - global $user; - if($form_state['values']['version'] == 'olderversion'){ - if($form_state['values']['older'] == ''){ - form_set_error('older', t('Please provide valid version')); - } + { + global $user; + if ($form_state['values']['version'] == 'olderversion') + { + if ($form_state['values']['older'] == '') + { + form_set_error('older', t('Please provide valid version')); + } + } + return; + //$solution_provider_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_provider_uid = ".$user->uid." AND approval_status IN (0, 1) AND solution_status IN (0, 1, 2)"); + $query = db_select('lab_migration_proposal'); + $query->fields('lab_migration_proposal'); + $query->condition('solution_provider_uid', $user->uid); + $query->condition('approval_status', array( + 0, + 1 + ), 'IN'); + $query->condition('solution_status', array( + 0, + 1, + 2 + ), 'IN'); + $solution_provider_q = $query->execute(); + if ($solution_provider_q->fetchObject()) + { + form_set_error('', t("You have already applied for a solution. Please compelete that before applying for another solution.")); + drupal_goto('lab-migration/open-proposal'); + } } - return; - //$solution_provider_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_provider_uid = ".$user->uid." AND approval_status IN (0, 1) AND solution_status IN (0, 1, 2)"); - $query = db_select('lab_migration_proposal'); - $query->fields('lab_migration_proposal'); - $query->condition('solution_provider_uid', $user->uid); - $query->condition('approval_status', array(0, 1), 'IN'); - $query->condition('solution_status', array(0, 1, 2), 'IN'); - $solution_provider_q = $query->execute(); - if ($solution_provider_q->fetchObject()) { - form_set_error('', t("You have already applied for a solution. Please compelete that before applying for another solution.")); - drupal_goto('lab-migration/open-proposal'); - } -} - function lab_migration_solution_proposal_form_submit($form, &$form_state) -{ - global $user; - - $proposal_id = (int)arg(2); - if($form_state['values']['version'] == 'olderversion'){ - $form_state['values']['version'] = $form_state['values']['older']; - } - //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id); - $query = db_select('lab_migration_proposal'); - $query->fields('lab_migration_proposal'); - $query->condition('id', $proposal_id); - $proposal_q = $query->execute(); - $proposal_data = $proposal_q->fetchObject(); - if (!$proposal_data) { - drupal_set_message("Invalid proposal.", 'error'); - drupal_goto('lab-migration/open-proposal'); - } - if ($proposal_data->solution_provider_uid != 0) { - drupal_set_message("Someone has already applied for solving this Lab.", 'error'); - drupal_goto('lab-migration/open-proposal'); - } - - $query = "UPDATE {lab_migration_proposal} set solution_provider_uid = :uid, solution_status = 1, version = :version, solution_provider_name_title = :solution_provider_name_title, solution_provider_name = :solution_provider_contact_name, solution_provider_contact_ph = :solution_provider_contact_ph, solution_provider_department = :solution_provider_department, solution_provider_university = :solution_provider_university WHERE id = :proposal_id"; + global $user; + $proposal_id = (int) arg(2); + if ($form_state['values']['version'] == 'olderversion') + { + $form_state['values']['version'] = $form_state['values']['older']; + } + //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $proposal_id); + $query = db_select('lab_migration_proposal'); + $query->fields('lab_migration_proposal'); + $query->condition('id', $proposal_id); + $proposal_q = $query->execute(); + $proposal_data = $proposal_q->fetchObject(); + if (!$proposal_data) + { + drupal_set_message("Invalid proposal.", 'error'); + drupal_goto('lab-migration/open-proposal'); + } + if ($proposal_data->solution_provider_uid != 0) + { + drupal_set_message("Someone has already applied for solving this Lab.", 'error'); + drupal_goto('lab-migration/open-proposal'); + } + $query = "UPDATE {lab_migration_proposal} set solution_provider_uid = :uid, solution_status = 1, version = :version, solution_provider_name_title = :solution_provider_name_title, solution_provider_name = :solution_provider_contact_name, solution_provider_contact_ph = :solution_provider_contact_ph, solution_provider_department = :solution_provider_department, solution_provider_university = :solution_provider_university WHERE id = :proposal_id"; $args = array( - ":uid" => $user->uid, - ":version" => $form_state['values']['version'], - ":solution_provider_name_title" => $form_state['values']['solution_provider_name_title'], - ":solution_provider_contact_name" => $form_state['values']['solution_provider_name'], - ":solution_provider_contact_ph" => $form_state['values']['solution_provider_contact_ph'], - ":solution_provider_department" => $form_state['values']['solution_provider_department'], - ":solution_provider_university" => $form_state['values']['solution_provider_university'], - ":proposal_id" => $proposal_id - ); + ":uid" => $user->uid, + ":version" => $form_state['values']['version'], + ":solution_provider_name_title" => $form_state['values']['solution_provider_name_title'], + ":solution_provider_contact_name" => $form_state['values']['solution_provider_name'], + ":solution_provider_contact_ph" => $form_state['values']['solution_provider_contact_ph'], + ":solution_provider_department" => $form_state['values']['solution_provider_department'], + ":solution_provider_university" => $form_state['values']['solution_provider_university'], + ":proposal_id" => $proposal_id + ); $result = db_query($query, $args); - drupal_set_message("We have received your application. We will get back to you soon.", 'status'); - - /* sending email */ - $email_to = $user->mail; - - $from = variable_get('lab_migration_from_email', ''); - $bcc= variable_get('lab_migration_emails', ''); - $cc=variable_get('lab_migration_cc_emails', ''); - - $param['solution_proposal_received']['proposal_id'] = $proposal_id; - $param['solution_proposal_received']['user_id'] = $user->uid; - $param['solution_proposal_received']['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('lab_migration', 'solution_proposal_received', $email_to , language_default(), $param, $from, TRUE)) - drupal_set_message('Error sending email message.', 'error'); - - /* sending email */ - /* $email_to = variable_get('lab_migration_emails', ''); - if (!drupal_mail('lab_migration', 'solution_proposal_received', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE)) + drupal_set_message("We have received your application. We will get back to you soon.", 'status'); + /* sending email */ + $email_to = $user->mail; + $from = variable_get('lab_migration_from_email', ''); + $bcc = variable_get('lab_migration_emails', ''); + $cc = variable_get('lab_migration_cc_emails', ''); + $param['solution_proposal_received']['proposal_id'] = $proposal_id; + $param['solution_proposal_received']['user_id'] = $user->uid; + $param['solution_proposal_received']['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('lab_migration', 'solution_proposal_received', $email_to, language_default(), $param, $from, TRUE)) + drupal_set_message('Error sending email message.', 'error'); + /* sending email */ + /* $email_to = variable_get('lab_migration_emails', ''); + if (!drupal_mail('lab_migration', 'solution_proposal_received', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE)) drupal_set_message('Error sending email message.', 'error');*/ - - drupal_goto('lab-migration/open-proposal'); -} - + drupal_goto('lab-migration/open-proposal'); + } |