From db34ba9fbc2a625d47f957144929706c2bdec653 Mon Sep 17 00:00:00 2001 From: Sashi20 Date: Mon, 16 Sep 2019 11:39:40 +0530 Subject: Add lab migration module files --- manage_solution_proposal.inc | 340 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 340 insertions(+) create mode 100755 manage_solution_proposal.inc (limited to 'manage_solution_proposal.inc') diff --git a/manage_solution_proposal.inc b/manage_solution_proposal.inc new file mode 100755 index 0000000..3e9aad5 --- /dev/null +++ b/manage_solution_proposal.inc @@ -0,0 +1,340 @@ +fields('lab_migration_proposal'); + $query->condition('solution_provider_uid', 0, '!='); + $query->condition('solution_status', 1); + $query->orderBy('id', 'DESC'); + $pending_q = $query->execute(); + while ($pending_data = $pending_q->fetchObject()) + { + $pending_rows[$pending_data->id] = array( + l($pending_data->name, 'user/' . $pending_data->uid), + $pending_data->lab_title, + l('Approve', 'lab-migration/manage-proposal/solution-proposal-approve/' . $pending_data->id) + ); + } + /* check if there are any pending proposals */ + if (!$pending_rows) + { + drupal_set_message(t('There are no pending solution proposals.'), 'status'); + return ''; + } + $pending_header = array( + 'Proposer Name', + 'Title of the Lab', + 'Action' + ); + $output = theme('table', array( + 'header' => $pending_header, + 'rows' => $pending_rows + )); + return $output; + } +/******************************************************************************/ +/***************** SOLUTION PROPOSAL APPROVAL FORM ****************************/ +/******************************************************************************/ +function lab_migration_solution_proposal_approval_form($form, $form_state) + { + global $user; + /* get current proposal */ + $proposal_id = (int) arg(3); + // $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(); + if ($proposal_q) + { + if ($proposal_data = $proposal_q->fetchObject()) + { + /* everything ok */ + } + else + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('lab-migration/manage-proposal/pending-solution-proposal'); + return; + } + } + else + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('lab-migration/manage-proposal/pending-solution-proposal'); + return; + } + $form['name'] = array( + '#type' => 'item', + '#markup' => l($proposal_data->solution_provider_name_title . ' ' . $proposal_data->solution_provider_name, 'user/' . $proposal_data->solution_provider_uid), + '#title' => t('Solution Provider Name'), + ); + $form['email_id'] = array( + '#type' => 'item', + '#markup' => user_load($proposal_data->solution_provider_uid)->mail, + '#title' => t('Solution Provider Email'), + ); + $form['contact_ph'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_contact_ph, + '#title' => t('Solution Provider Contact No.'), + ); + $form['department'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_department, + '#title' => t('Department/Branch'), + ); + $form['university'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_university, + '#title' => t('University/Institute'), + ); + +$form['country'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_country, + '#title' => t('Country') + ); + $form['all_state'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_state, + '#title' => t('State') + ); + $form['city'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_city, + '#title' => t('City') + ); + $form['pincode'] = array( + '#type' => 'item', + '#markup' => $proposal_data->solution_provider_pincode, + '#title' => t('Pincode/Postal code') + ); + + + $form['esim_version'] = array( + '#type' => 'item', + '#title' => t('eSim version used'), + '#markup'=>$proposal_data->esim_version, + ); + + + $form['lab_title'] = array( + '#type' => 'item', + '#markup' => $proposal_data->lab_title, + '#title' => t('Title of the Lab'), + ); + /* get experiment details */ + $experiment_list = ''; + $form['experiment'] = array( + '#type' => 'item', + '#markup' => $experiment_list, + '#title' => t('Experiments') + ); + $form['solution_display'] = array( + '#type' => 'item', + '#title' => t('Display the solution on the www.esim.fossee.in website'), + '#markup' => ($proposal_data->solution_display == 1) ? "Yes" : "No" + ); + /*if ($proposal_data->solution_provider_uid == 0) + { + $solution_provider = "Open"; + } + else if ($proposal_data->solution_provider_uid == $proposal_data->uid) + { + $solution_provider = "Proposer will provide the solution of the lab"; + } + else + { + $solution_provider_user_data = user_load($proposal_data->solution_provider_uid); + if ($solution_provider_user_data) + { + $solution_provider .= ''; + } + else + { + $solution_provider = "User does not exists"; + } + }*/ + + $proposer .= ''; + $form['proposer_details'] = array( + '#type' => 'item', + '#title' => t('Proposer of Lab :'), + '#markup' => $proposer, + ); + /*$form['solution_provider_uid'] = array( + '#type' => 'item', + '#title' => t('Solution Provider'), + '#markup' => $solution_provider + );*/ + $form['approval'] = array( + '#type' => 'radios', + '#title' => t('Solution Provider'), + '#options' => array( + '1' => 'Approve', + '2' => 'Disapprove' + ), + '#required' => TRUE + ); + $form['message'] = array( + '#type' => 'textarea', + '#title' => t('Reason for disapproval') + ); + $form['submit'] = array( + '#type' => 'submit', + '#value' => t('Submit') + ); + $form['cancel'] = array( + '#type' => 'markup', + '#value' => l(t('Cancel'), 'lab-migration/manage-proposal/pending-solution-proposal') + ); + return $form; + } +function lab_migration_solution_proposal_approval_form_validate($form, &$form_state) + { + $proposal_id = (int) arg(3); + // $solution_provider_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); + $solution_provider_q = $query->execute(); + $solution_provider_data = $solution_provider_q->fetchObject(); + // $solution_provider_present_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_provider_uid = %d AND approval_status IN (0, 1) AND id != %d", $solution_provider_data->uid, $proposal_id); + $query = db_select('lab_migration_proposal'); + $query->fields('lab_migration_proposal'); + $query->condition('solution_provider_uid', $solution_provider_data->uid); + $query->condition('approval_status', array( + 0, + 1 + ), 'IN'); + $query->condition('id', $proposal_id, '<>'); + $solution_provider_present_q = $query->execute(); + if ($x = $solution_provider_present_q->fetchObject()) + { + drupal_set_message($proposal_id); + form_set_error('', t('Solution provider has already one proposal active')); + } + } +function lab_migration_solution_proposal_approval_form_submit($form, &$form_state) + { + global $user; + /* get current proposal */ + $proposal_id = (int) arg(3); + //$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(); + if ($proposal_q) + { + if ($proposal_data = $proposal_q->fetchObject()) + { + /* everything ok */ + } + else + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('lab-migration/manage-proposal/pending-solution-proposal'); + return; + } + } + else + { + drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error'); + drupal_goto('lab-migration/manage-proposal/pending-solution-proposal'); + return; + } + $user_data = user_load($proposal_data->solution_provider_uid); + if ($form_state['values']['approval'] == 1) + { + $query = "UPDATE {lab_migration_proposal} SET solution_status = 2 WHERE id =:proposal_id"; + $args = array( + ":proposal_id" => $proposal_id + ); + db_query($query, $args); + /* sending email */ + $email_to = $user_data->mail; + $from = variable_get('lab_migration_from_email', ''); + $bcc = $user->mail . ', ' . variable_get('lab_migration_emails', ''); + $cc = variable_get('lab_migration_cc_emails', ''); + $param['solution_proposal_approved']['proposal_id'] = $proposal_id; + $param['solution_proposal_approved']['user_id'] = $proposal_data->solution_provider_uid; + $param['solution_proposal_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('lab_migration', 'solution_proposal_approved', $email_to, language_default(), $param, $from, TRUE)) + drupal_set_message('Error sending email message.', 'error'); + /*$email_to = $user->mail . ', ' . variable_get('lab_migration_emails', ''); + if (!drupal_mail('lab_migration', 'solution_proposal_approved', $email_to , language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE)) + drupal_set_message('Error sending email message.', 'error');*/ + drupal_set_message('Lab migration solution proposal approved. User has been notified of the approval.', 'status'); + drupal_goto('lab-migration/manage-proposal/pending-solution_proposal'); + return; + } + else if ($form_state['values']['approval'] == 2) + { + $query = "UPDATE {lab_migration_proposal} SET solution_provider_uid = :solution_provider_uid, solution_status = :solution_status, solution_provider_name_title = '', solution_provider_name = '', solution_provider_contact_ph = '', solution_provider_department = '', solution_provider_university = '' WHERE id = :proposal_id"; + $args = array( + ":solution_provider_uid" => 0, + ":solution_status" => 0, + ":proposal_id" => $proposal_id + ); + db_query($query, $args); + /* sending email */ + $email_to = $user_data->mail; + $from = variable_get('lab_migration_from_email', ''); + $bcc = $user->mail . ', ' . variable_get('lab_migration_emails', ''); + $cc = variable_get('lab_migration_cc_emails', ''); + $param['solution_proposal_disapproved']['proposal_id'] = $proposal_id; + $param['solution_proposal_disapproved']['user_id'] = $proposal_data->solution_provider_uid; + $param['solution_proposal_disapproved']['message'] = $form_state['values']['message']; + $param['solution_proposal_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('lab_migration', 'solution_proposal_disapproved', $email_to, language_default(), $param, $from, TRUE)) + drupal_set_message('Error sending email message.', 'error'); + drupal_set_message('Lab migration solution proposal dis-approved. User has been notified of the dis-approval.', 'status'); + drupal_goto('lab-migration/manage-proposal/pending-solution-proposal'); + return; + } + } -- cgit