summaryrefslogtreecommitdiff
path: root/manage_proposal.inc
diff options
context:
space:
mode:
Diffstat (limited to 'manage_proposal.inc')
-rwxr-xr-xmanage_proposal.inc1991
1 files changed, 1009 insertions, 982 deletions
diff --git a/manage_proposal.inc b/manage_proposal.inc
index 1d74562..cd4fb87 100755
--- a/manage_proposal.inc
+++ b/manage_proposal.inc
@@ -2,1002 +2,1029 @@
// $Id$
function cfd_case_study_proposal_pending()
{
- /* get pending proposals to be approved */
- $pending_rows = array();
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('approval_status', 0);
- $query->orderBy('id', 'DESC');
- $pending_q = $query->execute();
- while ($pending_data = $pending_q->fetchObject())
- {
- $pending_rows[$pending_data->id] = array(
- date('d-m-Y', $pending_data->creation_date),
- l($pending_data->name_title . ' ' . $pending_data->contributor_name, 'user/' . $pending_data->uid),
- $pending_data->project_title,
- l('Approve', 'case-study-project/manage-proposal/approve/' . $pending_data->id) . ' | ' . l('Edit', 'case-study-project/manage-proposal/edit/' . $pending_data->id)
- );
- } //$pending_data = $pending_q->fetchObject()
- /* check if there are any pending proposals */
- if (!$pending_rows)
- {
- drupal_set_message(t('There are no pending proposals.'), 'status');
- return '';
- } //!$pending_rows
- $pending_header = array(
- 'Date of Submission',
- 'Student Name',
- 'Title of the Case Study Project',
- 'Action'
- );
- //$output = theme_table($pending_header, $pending_rows);
- $output = theme('table', array(
- 'header' => $pending_header,
- 'rows' => $pending_rows
- ));
- return $output;
+ /* get pending proposals to be approved */
+ $pending_rows = array();
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('approval_status', 0);
+ $query->orderBy('id', 'DESC');
+ $pending_q = $query->execute();
+ while ($pending_data = $pending_q->fetchObject()) {
+ $pending_rows[$pending_data->id] = array(
+ date('d-m-Y', $pending_data->creation_date),
+ l($pending_data->name_title . ' ' . $pending_data->contributor_name, 'user/' . $pending_data->uid),
+ $pending_data->project_title,
+ l('Approve', 'case-study-project/manage-proposal/approve/' . $pending_data->id) . ' | ' . l('Edit', 'case-study-project/manage-proposal/edit/' . $pending_data->id),
+ );
+ } //$pending_data = $pending_q->fetchObject()
+ /* check if there are any pending proposals */
+ if (!$pending_rows) {
+ drupal_set_message(t('There are no pending proposals.'), 'status');
+ return '';
+ } //!$pending_rows
+ $pending_header = array(
+ 'Date of Submission',
+ 'Student Name',
+ 'Title of the Case Study Project',
+ 'Action',
+ );
+ //$output = theme_table($pending_header, $pending_rows);
+ $output = theme('table', array(
+ 'header' => $pending_header,
+ 'rows' => $pending_rows,
+ ));
+ return $output;
}
function cfd_case_study_proposal_all()
{
- /* get pending proposals to be approved */
- $proposal_rows = array();
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->orderBy('id', 'DESC');
- $proposal_q = $query->execute();
- while ($proposal_data = $proposal_q->fetchObject())
- {
- $approval_status = '';
- switch ($proposal_data->approval_status)
- {
- case 0:
- $approval_status = 'Pending';
- break;
- case 1:
- $approval_status = 'Approved';
- break;
- case 2:
- $approval_status = 'Dis-approved';
- break;
- case 3:
- $approval_status = 'Completed';
- break;
- default:
- $approval_status = 'Unknown';
- break;
- } //$proposal_data->approval_status
- if ($proposal_data->actual_completion_date == 0)
- {
- $actual_completion_date = "Not Completed";
- } //$proposal_data->actual_completion_date == 0
- else
- {
- $actual_completion_date = date('d-m-Y', $proposal_data->actual_completion_date);
- }
- if ($proposal_data->approval_date == 0)
- {
- $approval_date = "Not Approved";
- } //$proposal_data->actual_completion_date == 0
- else
- {
- $approval_date = date('d-m-Y', $proposal_data->approval_date);
- }
- $proposal_rows[] = array(
- date('d-m-Y', $proposal_data->creation_date),
- l($proposal_data->contributor_name, 'user/' . $proposal_data->uid),
- $proposal_data->project_title,
- $approval_date,
- $actual_completion_date,
- $approval_status,
- l('Status', 'case-study-project/manage-proposal/status/' . $proposal_data->id) . ' | ' . l('Edit', 'case-study-project/manage-proposal/edit/' . $proposal_data->id)
- );
- } //$proposal_data = $proposal_q->fetchObject()
- /* check if there are any pending proposals */
- if (!$proposal_rows)
- {
- drupal_set_message(t('There are no proposals.'), 'status');
- return '';
- } //!$proposal_rows
- $proposal_header = array(
- 'Date of Submission',
- 'Student Name',
- 'Title of the case-study project',
- 'Date of Approval',
- 'Date of Project Completion',
- 'Status',
- 'Action'
- );
- $output = theme('table', array(
- 'header' => $proposal_header,
- 'rows' => $proposal_rows
- ));
- return $output;
+ /* get pending proposals to be approved */
+ $proposal_rows = array();
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->orderBy('id', 'DESC');
+ $proposal_q = $query->execute();
+ while ($proposal_data = $proposal_q->fetchObject()) {
+ $approval_status = '';
+ switch ($proposal_data->approval_status) {
+ case 0:
+ $approval_status = 'Pending';
+ break;
+ case 1:
+ $approval_status = 'Approved';
+ break;
+ case 2:
+ $approval_status = 'Dis-approved';
+ break;
+ case 3:
+ $approval_status = 'Completed';
+ break;
+ default:
+ $approval_status = 'Unknown';
+ break;
+ } //$proposal_data->approval_status
+ if ($proposal_data->actual_completion_date == 0) {
+ $actual_completion_date = "Not Completed";
+ } //$proposal_data->actual_completion_date == 0
+ else {
+ $actual_completion_date = date('d-m-Y', $proposal_data->actual_completion_date);
+ }
+ if ($proposal_data->approval_date == 0) {
+ $approval_date = "Not Approved";
+ } //$proposal_data->actual_completion_date == 0
+ else {
+ $approval_date = date('d-m-Y', $proposal_data->approval_date);
+ }
+ $proposal_rows[] = array(
+ date('d-m-Y', $proposal_data->creation_date),
+ l($proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+ $proposal_data->project_title,
+ $approval_date,
+ $actual_completion_date,
+ $approval_status,
+ l('Status', 'case-study-project/manage-proposal/status/' . $proposal_data->id) . ' | ' . l('Edit', 'case-study-project/manage-proposal/edit/' . $proposal_data->id),
+ );
+ } //$proposal_data = $proposal_q->fetchObject()
+ /* check if there are any pending proposals */
+ if (!$proposal_rows) {
+ drupal_set_message(t('There are no proposals.'), 'status');
+ return '';
+ } //!$proposal_rows
+ $proposal_header = array(
+ 'Date of Submission',
+ 'Student Name',
+ 'Title of the case-study project',
+ 'Date of Approval',
+ 'Date of Project Completion',
+ 'Status',
+ 'Action',
+ );
+ $output = theme('table', array(
+ 'header' => $proposal_header,
+ 'rows' => $proposal_rows,
+ ));
+ return $output;
+}
+function cfd_case_study_proposal_edit_file_all()
+{
+ /* get pending proposals to be approved */
+ $proposal_rows = array();
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->orderBy('id', 'DESC');
+ $query->condition('approval_status', '0', '<>');
+ $query->condition('approval_status', '1', '<>');
+ $query->condition('approval_status', '2', '<>');
+ $query->orderBy('approval_status', 'DESC');
+ $proposal_q = $query->execute();
+ while ($proposal_data = $proposal_q->fetchObject()) {
+ $approval_status = '';
+ switch ($proposal_data->approval_status) {
+ case 0:
+ $approval_status = 'Pending';
+ break;
+ case 1:
+ $approval_status = 'Approved';
+ break;
+ case 2:
+ $approval_status = 'Dis-approved';
+ break;
+ case 3:
+ $approval_status = 'Completed';
+ break;
+ case 5:
+ $approval_status = 'On Hold';
+ break;
+ default:
+ $approval_status = 'Unknown';
+ break;
+ } //$proposal_data->approval_status
+ if ($proposal_data->actual_completion_date == 0) {
+ $actual_completion_date = "Not Completed";
+ } //$proposal_data->actual_completion_date == 0
+ else {
+ $actual_completion_date = date('d-m-Y', $proposal_data->actual_completion_date);
+ }
+ if ($proposal_data->approval_date == 0) {
+ $approval_date = "Not Approved";
+ } //$proposal_data->actual_completion_date == 0
+ else {
+ $approval_date = date('d-m-Y', $proposal_data->approval_date);
+ }
+ $proposal_rows[] = array(
+ date('d-m-Y', $proposal_data->creation_date),
+ l($proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+ $proposal_data->project_title,
+ $approval_date,
+ $actual_completion_date,
+ $approval_status,
+ l('Edit', 'case-study-project/abstract-code/edit-upload-files/' . $proposal_data->id),
+ );
+ } //$proposal_data = $proposal_q->fetchObject()
+ /* check if there are any pending proposals */
+ if (!$proposal_rows) {
+ drupal_set_message(t('There are no proposals.'), 'status');
+ return '';
+ } //!$proposal_rows
+ $proposal_header = array(
+ 'Date of Submission',
+ 'Student Name',
+ 'Title of the case-study project',
+ 'Date of Approval',
+ 'Date of Project Completion',
+ 'Status',
+ 'Action',
+ );
+ $output = theme('table', array(
+ 'header' => $proposal_header,
+ 'rows' => $proposal_rows,
+ ));
+ return $output;
}
/******************************************************************************/
/************************** PROPOSAL APPROVAL FORM ****************************/
/******************************************************************************/
function cfd_case_study_proposal_approval_form($form, &$form_state)
{
- global $user;
- /* get current proposal */
- $proposal_id = (int) arg(3);
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
- $query_abstract = db_select('case_study_submitted_abstracts_file');
- $query_abstract->fields('case_study_submitted_abstracts_file');
- $query_abstract->condition('proposal_id', $proposal_id);
- $query_abstract->condition('filetype', 'A');
- $query_abstract_pdf = $query_abstract->execute()->fetchObject();
- if ($proposal_q)
- {
- if ($proposal_data = $proposal_q->fetchObject())
- {
- /* everything ok */
- } //$proposal_data = $proposal_q->fetchObject()
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- } //$proposal_q
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- if($proposal_data->faculty_name == ''){
- $faculty_name = 'NA';
- }
- else{
- $faculty_name = $proposal_data->faculty_name;
- }
- if($proposal_data->faculty_department == ''){
- $faculty_department = 'NA';
- }
- else{
- $faculty_department = $proposal_data->faculty_department;
- }
- if($proposal_data->faculty_email == ''){
- $faculty_email = 'NA';
- }
- else{
- $faculty_email = $proposal_data->faculty_email;
- }
- $form['contributor_name'] = array(
- '#type' => 'item',
- '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->contributor_name, 'user/' . $proposal_data->uid),
- '#title' => t('Student name')
- );
- $form['student_email_id'] = array(
- '#title' => t('Student Email'),
- '#type' => 'item',
- '#markup' => user_load($proposal_data->uid)->mail,
- '#title' => t('Email')
- );
- $form['contributor_contact_no'] = array(
- '#title' => t('Contact No.'),
- '#type' => 'item',
- '#markup' => $proposal_data->contact_no,
- );
- $form['university'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->university,
- '#title' => t('University/Institute')
- );
- $form['how_did_you_know_about_project'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->how_did_you_know_about_project,
- '#title' => t('How did you know about the project')
- );
- $form['faculty_name'] = array(
- '#type' => 'item',
- '#markup' => $faculty_name,
- '#title' => t('Name of the faculty')
- );
- $form['faculty_department'] = array(
- '#type' => 'item',
- '#markup' => $faculty_department,
- '#title' => t('Department of the faculty')
- );
- $form['faculty_email'] = array(
- '#type' => 'item',
- '#markup' => $faculty_email,
- '#title' => t('Email of the faculty')
- );
- $form['country'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->country,
- '#title' => t('Country')
- );
- $form['all_state'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->state,
- '#title' => t('State')
- );
- $form['city'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->city,
- '#title' => t('City')
- );
- $form['pincode'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->pincode,
- '#title' => t('Pincode/Postal code')
- );
- $form['project_title'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->project_title,
- '#title' => t('Title of the Case Study Project')
- );
- $form['solver_used'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->solver_used,
- '#title' => t('Solver used')
- );
- $form['date_of_proposal'] = array(
- '#type' => 'textfield',
- '#title' => t('Date of Proposal'),
- '#default_value' => date('d/m/Y', $proposal_data->creation_date),
- '#disabled' => TRUE,
- );
- $form['expected_completion_date'] =array(
- '#type' => 'textfield',
- '#title' => t('Expected Date of Completion'),
- '#default_value' => date('d/m/Y', $proposal_data->expected_date_of_completion),
- '#disabled' => TRUE,
- );
- if (($query_abstract_pdf->filename != "") && ($query_abstract_pdf->filename != 'NULL'))
- {
- $str = substr($query_abstract_pdf->filename,strrpos($query_abstract_pdf->filename, '/'));
- $resource_file =ltrim($str, '/');
-
- $form['abstract_file_path'] = array(
- '#type' => 'item',
- '#title' => t('Abstract file '),
- '#markup' => l($resource_file, 'case-study-project/download/project-file/' . $proposal_id) . ""
- );
- } //$proposal_data->user_defined_compound_filepath != ""
- else
- {
- $form['abstract_file_path'] = array(
- '#type' => 'item',
- '#title' => t('Abstract file '),
- '#markup' => "Not uploaded<br><br>"
- );
- }
- $form['approval'] = array(
- '#type' => 'radios',
- '#title' => t('CFD Case Study proposal'),
- '#options' => array(
- '1' => 'Approve',
- '2' => 'Disapprove'
- ),
- '#required' => TRUE
- );
- $form['message'] = array(
- '#type' => 'textarea',
- '#title' => t('Reason for disapproval'),
- '#attributes' => array(
- 'placeholder' => t('Enter reason for disapproval in minimum 30 characters '),
- 'cols' => 50,
- 'rows' => 4
- ),
- '#states' => array(
- 'visible' => array(
- ':input[name="approval"]' => array(
- 'value' => '2'
- )
- )
- )
- );
- $form['submit'] = array(
- '#type' => 'submit',
- '#value' => t('Submit')
- );
- $form['cancel'] = array(
- '#type' => 'item',
- '#markup' => l(t('Cancel'), 'case-study-project/manage-proposal')
- );
- return $form;
+ global $user;
+ /* get current proposal */
+ $proposal_id = (int) arg(3);
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
+ $query_abstract = db_select('case_study_submitted_abstracts_file');
+ $query_abstract->fields('case_study_submitted_abstracts_file');
+ $query_abstract->condition('proposal_id', $proposal_id);
+ $query_abstract->condition('filetype', 'A');
+ $query_abstract_pdf = $query_abstract->execute()->fetchObject();
+ if ($proposal_q) {
+ if ($proposal_data = $proposal_q->fetchObject()) {
+ /* everything ok */
+ } //$proposal_data = $proposal_q->fetchObject()
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ } //$proposal_q
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ if ($proposal_data->faculty_name == '') {
+ $faculty_name = 'NA';
+ } else {
+ $faculty_name = $proposal_data->faculty_name;
+ }
+ if ($proposal_data->faculty_department == '') {
+ $faculty_department = 'NA';
+ } else {
+ $faculty_department = $proposal_data->faculty_department;
+ }
+ if ($proposal_data->faculty_email == '') {
+ $faculty_email = 'NA';
+ } else {
+ $faculty_email = $proposal_data->faculty_email;
+ }
+ $form['contributor_name'] = array(
+ '#type' => 'item',
+ '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+ '#title' => t('Student name'),
+ );
+ $form['student_email_id'] = array(
+ '#title' => t('Student Email'),
+ '#type' => 'item',
+ '#markup' => user_load($proposal_data->uid)->mail,
+ '#title' => t('Email'),
+ );
+ $form['contributor_contact_no'] = array(
+ '#title' => t('Contact No.'),
+ '#type' => 'item',
+ '#markup' => $proposal_data->contact_no,
+ );
+ $form['university'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->university,
+ '#title' => t('University/Institute'),
+ );
+ $form['how_did_you_know_about_project'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->how_did_you_know_about_project,
+ '#title' => t('How did you know about the project'),
+ );
+ $form['faculty_name'] = array(
+ '#type' => 'item',
+ '#markup' => $faculty_name,
+ '#title' => t('Name of the faculty'),
+ );
+ $form['faculty_department'] = array(
+ '#type' => 'item',
+ '#markup' => $faculty_department,
+ '#title' => t('Department of the faculty'),
+ );
+ $form['faculty_email'] = array(
+ '#type' => 'item',
+ '#markup' => $faculty_email,
+ '#title' => t('Email of the faculty'),
+ );
+ $form['country'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->country,
+ '#title' => t('Country'),
+ );
+ $form['all_state'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->state,
+ '#title' => t('State'),
+ );
+ $form['city'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->city,
+ '#title' => t('City'),
+ );
+ $form['pincode'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->pincode,
+ '#title' => t('Pincode/Postal code'),
+ );
+ $form['project_title'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->project_title,
+ '#title' => t('Title of the Case Study Project'),
+ );
+ $form['solver_used'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->solver_used,
+ '#title' => t('Solver used'),
+ );
+ $form['date_of_proposal'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Date of Proposal'),
+ '#default_value' => date('d/m/Y', $proposal_data->creation_date),
+ '#disabled' => true,
+ );
+ $form['expected_completion_date'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Expected Date of Completion'),
+ '#default_value' => date('d/m/Y', $proposal_data->expected_date_of_completion),
+ '#disabled' => true,
+ );
+ if (($query_abstract_pdf->filename != "") && ($query_abstract_pdf->filename != 'NULL')) {
+ $str = substr($query_abstract_pdf->filename, strrpos($query_abstract_pdf->filename, '/'));
+ $resource_file = ltrim($str, '/');
+
+ $form['abstract_file_path'] = array(
+ '#type' => 'item',
+ '#title' => t('Abstract file '),
+ '#markup' => l($resource_file, 'case-study-project/download/project-file/' . $proposal_id) . "",
+ );
+ } //$proposal_data->user_defined_compound_filepath != ""
+ else {
+ $form['abstract_file_path'] = array(
+ '#type' => 'item',
+ '#title' => t('Abstract file '),
+ '#markup' => "Not uploaded<br><br>",
+ );
+ }
+ $form['approval'] = array(
+ '#type' => 'radios',
+ '#title' => t('CFD Case Study proposal'),
+ '#options' => array(
+ '1' => 'Approve',
+ '2' => 'Disapprove',
+ ),
+ '#required' => true,
+ );
+ $form['message'] = array(
+ '#type' => 'textarea',
+ '#title' => t('Reason for disapproval'),
+ '#attributes' => array(
+ 'placeholder' => t('Enter reason for disapproval in minimum 30 characters '),
+ 'cols' => 50,
+ 'rows' => 4,
+ ),
+ '#states' => array(
+ 'visible' => array(
+ ':input[name="approval"]' => array(
+ 'value' => '2',
+ ),
+ ),
+ ),
+ );
+ $form['submit'] = array(
+ '#type' => 'submit',
+ '#value' => t('Submit'),
+ );
+ $form['cancel'] = array(
+ '#type' => 'item',
+ '#markup' => l(t('Cancel'), 'case-study-project/manage-proposal'),
+ );
+ return $form;
}
function cfd_case_study_proposal_approval_form_validate($form, &$form_state)
{
- if ($form_state['values']['approval'] == 2)
- {
- if ($form_state['values']['message'] == '')
- {
- form_set_error('message', t('Reason for disapproval could not be empty'));
- } //$form_state['values']['message'] == ''
- } //$form_state['values']['approval'] == 2
+ if ($form_state['values']['approval'] == 2) {
+ if ($form_state['values']['message'] == '') {
+ form_set_error('message', t('Reason for disapproval could not be empty'));
+ } //$form_state['values']['message'] == ''
+ } //$form_state['values']['approval'] == 2
}
function cfd_case_study_proposal_approval_form_submit($form, &$form_state)
{
- global $user;
- /* get current proposal */
- $proposal_id = (int) arg(3);
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
- if ($proposal_q)
- {
- if ($proposal_data = $proposal_q->fetchObject())
- {
- /* everything ok */
- } //$proposal_data = $proposal_q->fetchObject()
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- } //$proposal_q
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- if ($form_state['values']['approval'] == 1)
- {
- $query = "UPDATE {case_study_proposal} SET approver_uid = :uid, approval_date = :date, approval_status = 1 WHERE id = :proposal_id";
- $args = array(
- ":uid" => $user->uid,
- ":date" => time(),
- ":proposal_id" => $proposal_id
- );
- db_query($query, $args);
- /* sending email */
- $user_data = user_load($proposal_data->uid);
- $email_to = $user_data->mail;
- $from = variable_get('case_study_from_email', '');
- $bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
- $cc = variable_get('case_study_cc_emails', '');
- $params['case_study_proposal_approved']['proposal_id'] = $proposal_id;
- $params['case_study_proposal_approved']['user_id'] = $proposal_data->uid;
- $params['case_study_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('case_study', 'case_study_proposal_approved', $email_to, language_default(), $params, $from, TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('CFD Case Study proposal No. ' . $proposal_id . ' approved. User has been notified of the approval.', 'status');
- drupal_goto('case-study-project/manage-proposal');
- return;
- } //$form_state['values']['approval'] == 1
- else if ($form_state['values']['approval'] == 2)
- {
- $query = "UPDATE {case_study_proposal} SET approver_uid = :uid, approval_date = :date, approval_status = 2, dissapproval_reason = :dissapproval_reason WHERE id = :proposal_id";
- $args = array(
- ":uid" => $user->uid,
- ":date" => time(),
- ":dissapproval_reason" => $form_state['values']['message'],
- ":proposal_id" => $proposal_id
- );
- $result = db_query($query, $args);
- /* sending email */
- $user_data = user_load($proposal_data->uid);
- $email_to = $user_data->mail;
- $from = variable_get('case_study_from_email', '');
- $bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
- $cc = variable_get('case_study_cc_emails', '');
- $params['case_study_proposal_disapproved']['proposal_id'] = $proposal_id;
- $params['case_study_proposal_disapproved']['user_id'] = $proposal_data->uid;
- $params['case_study_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('case_study', 'case_study_proposal_disapproved', $email_to, language_default(), $params, $from, TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('CFD Case Study proposal No. ' . $proposal_id . ' dis-approved. User has been notified of the dis-approval.', 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- } //$form_state['values']['approval'] == 2
+ global $user;
+ /* get current proposal */
+ $proposal_id = (int) arg(3);
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
+ if ($proposal_q) {
+ if ($proposal_data = $proposal_q->fetchObject()) {
+ /* everything ok */
+ } //$proposal_data = $proposal_q->fetchObject()
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ } //$proposal_q
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ if ($form_state['values']['approval'] == 1) {
+ $query = "UPDATE {case_study_proposal} SET approver_uid = :uid, approval_date = :date, approval_status = 1 WHERE id = :proposal_id";
+ $args = array(
+ ":uid" => $user->uid,
+ ":date" => time(),
+ ":proposal_id" => $proposal_id,
+ );
+ db_query($query, $args);
+ /* sending email */
+ $user_data = user_load($proposal_data->uid);
+ $email_to = $user_data->mail;
+ $from = variable_get('case_study_from_email', '');
+ $bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
+ $cc = variable_get('case_study_cc_emails', '');
+ $params['case_study_proposal_approved']['proposal_id'] = $proposal_id;
+ $params['case_study_proposal_approved']['user_id'] = $proposal_data->uid;
+ $params['case_study_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('case_study', 'case_study_proposal_approved', $email_to, language_default(), $params, $from, true)) {
+ drupal_set_message('Error sending email message.', 'error');
+ }
+
+ drupal_set_message('CFD Case Study proposal No. ' . $proposal_id . ' approved. User has been notified of the approval.', 'status');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ } //$form_state['values']['approval'] == 1
+ else if ($form_state['values']['approval'] == 2) {
+ $query = "UPDATE {case_study_proposal} SET approver_uid = :uid, approval_date = :date, approval_status = 2, dissapproval_reason = :dissapproval_reason WHERE id = :proposal_id";
+ $args = array(
+ ":uid" => $user->uid,
+ ":date" => time(),
+ ":dissapproval_reason" => $form_state['values']['message'],
+ ":proposal_id" => $proposal_id,
+ );
+ $result = db_query($query, $args);
+ /* sending email */
+ $user_data = user_load($proposal_data->uid);
+ $email_to = $user_data->mail;
+ $from = variable_get('case_study_from_email', '');
+ $bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
+ $cc = variable_get('case_study_cc_emails', '');
+ $params['case_study_proposal_disapproved']['proposal_id'] = $proposal_id;
+ $params['case_study_proposal_disapproved']['user_id'] = $proposal_data->uid;
+ $params['case_study_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('case_study', 'case_study_proposal_disapproved', $email_to, language_default(), $params, $from, true)) {
+ drupal_set_message('Error sending email message.', 'error');
+ }
+
+ drupal_set_message('CFD Case Study proposal No. ' . $proposal_id . ' dis-approved. User has been notified of the dis-approval.', 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ } //$form_state['values']['approval'] == 2
}
/******************************************************************************/
/*************************** PROPOSAL STATUS FORM *****************************/
/******************************************************************************/
function cfd_case_study_proposal_status_form($form, &$form_state)
{
- global $user;
- /* get current proposal */
- $proposal_id = (int) arg(3);
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
- $query_abstract = db_select('case_study_submitted_abstracts_file');
- $query_abstract->fields('case_study_submitted_abstracts_file');
- $query_abstract->condition('proposal_id', $proposal_id);
- $query_abstract->condition('filetype', 'A');
- $query_abstract_pdf = $query_abstract->execute()->fetchObject();
- if ($proposal_q)
- {
- if ($proposal_data = $proposal_q->fetchObject())
- {
- /* everything ok */
- } //$proposal_data = $proposal_q->fetchObject()
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- } //$proposal_q
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- if($proposal_data->faculty_name == ''){
- $faculty_name = 'NA';
- }
- else{
- $faculty_name = $proposal_data->faculty_name;
- }
- if($proposal_data->faculty_department == ''){
- $faculty_department = 'NA';
- }
- else{
- $faculty_department = $proposal_data->faculty_department;
- }
- if($proposal_data->faculty_email == ''){
- $faculty_email = 'NA';
- }
- else{
- $faculty_email = $proposal_data->faculty_email;
- }
- $form['contributor_name'] = array(
- '#type' => 'item',
- '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->contributor_name, 'user/' . $proposal_data->uid),
- '#title' => t('Student name')
- );
- $form['student_email_id'] = array(
- '#title' => t('Student Email'),
- '#type' => 'item',
- '#markup' => user_load($proposal_data->uid)->mail,
- '#title' => t('Email')
- );
- $form['university'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->university,
- '#title' => t('University/Institute')
- );
- $form['how_did_you_know_about_project'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->how_did_you_know_about_project,
- '#title' => t('How did you know about the project')
- );
- $form['faculty_name'] = array(
- '#type' => 'item',
- '#markup' => $faculty_name,
- '#title' => t('Name of the faculty')
- );
- $form['faculty_department'] = array(
- '#type' => 'item',
- '#markup' => $faculty_department,
- '#title' => t('Department of the faculty')
- );
- $form['faculty_email'] = array(
- '#type' => 'item',
- '#markup' => $faculty_email,
- '#title' => t('Email of the faculty')
- );
- $form['country'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->country,
- '#title' => t('Country')
- );
- $form['all_state'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->state,
- '#title' => t('State')
- );
- $form['city'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->city,
- '#title' => t('City')
- );
- $form['pincode'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->pincode,
- '#title' => t('Pincode/Postal code')
- );
- $form['project_title'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->project_title,
- '#title' => t('Title of the Case Study Project')
- );
- $form['solver_used'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->solver_used,
- '#title' => t('Solver used')
- );
- /************************** reference link filter *******************/
- $url = '~(?:(https?)://([^\s<]+)|(www\.[^\s<]+?\.[^\s<]+))(?<![\.,:])~i';
- $reference = preg_replace($url, '<a href="$0" target="_blank" title="$0">$0</a>', $proposal_data->reference);
- /******************************/
- /*$form['reference'] = array(
- '#type' => 'item',
- '#markup' => $reference,
- '#title' => t('References')
- );*/
- if (($query_abstract_pdf->filename != "") && ($query_abstract_pdf->filename != 'NULL'))
- {
- $str = substr($query_abstract_pdf->filename,strrpos($query_abstract_pdf->filename, '/'));
- $resource_file =ltrim($str, '/');
-
- $form['abstract_file_path'] = array(
- '#type' => 'item',
- '#title' => t('Abstract file '),
- '#markup' => l($resource_file, 'case-study-project/download/project-file/' . $proposal_id) . ""
- );
- } //$proposal_data->user_defined_compound_filepath != ""
- else
- {
- $form['abstract_file_path'] = array(
- '#type' => 'item',
- '#title' => t('Abstract file '),
- '#markup' => "Not uploaded<br><br>"
- );
- }
- $proposal_status = '';
- switch ($proposal_data->approval_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;
- default:
- $proposal_status = t('Unkown');
- break;
- }
- $form['proposal_status'] = array(
- '#type' => 'item',
- '#markup' => $proposal_status,
- '#title' => t('Proposal Status')
- );
- if ($proposal_data->approval_status == 0)
- {
- $form['approve'] = array(
- '#type' => 'item',
- '#markup' => l('Click here', 'case-study-project/manage-proposal/approve/' . $proposal_id),
- '#title' => t('Approve')
- );
- } //$proposal_data->approval_status == 0
- if ($proposal_data->approval_status == 1)
- {
- $form['completed'] = array(
- '#type' => 'checkbox',
- '#title' => t('Completed'),
- '#description' => t('Check if user has provided all the required files and pdfs.')
- );
- } //$proposal_data->approval_status == 1
- if ($proposal_data->approval_status == 2)
- {
- $form['message'] = array(
- '#type' => 'item',
- '#markup' => $proposal_data->message,
- '#title' => t('Reason for disapproval')
- );
- } //$proposal_data->approval_status == 2
- $form['submit'] = array(
- '#type' => 'submit',
- '#value' => t('Submit')
- );
- $form['cancel'] = array(
- '#type' => 'markup',
- '#markup' => l(t('Cancel'), 'case-study-project/manage-proposal/all')
- );
- return $form;
+ global $user;
+ /* get current proposal */
+ $proposal_id = (int) arg(3);
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
+ $query_abstract = db_select('case_study_submitted_abstracts_file');
+ $query_abstract->fields('case_study_submitted_abstracts_file');
+ $query_abstract->condition('proposal_id', $proposal_id);
+ $query_abstract->condition('filetype', 'A');
+ $query_abstract_pdf = $query_abstract->execute()->fetchObject();
+ if ($proposal_q) {
+ if ($proposal_data = $proposal_q->fetchObject()) {
+ /* everything ok */
+ } //$proposal_data = $proposal_q->fetchObject()
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ } //$proposal_q
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ if ($proposal_data->faculty_name == '') {
+ $faculty_name = 'NA';
+ } else {
+ $faculty_name = $proposal_data->faculty_name;
+ }
+ if ($proposal_data->faculty_department == '') {
+ $faculty_department = 'NA';
+ } else {
+ $faculty_department = $proposal_data->faculty_department;
+ }
+ if ($proposal_data->faculty_email == '') {
+ $faculty_email = 'NA';
+ } else {
+ $faculty_email = $proposal_data->faculty_email;
+ }
+ $form['contributor_name'] = array(
+ '#type' => 'item',
+ '#markup' => l($proposal_data->name_title . ' ' . $proposal_data->contributor_name, 'user/' . $proposal_data->uid),
+ '#title' => t('Student name'),
+ );
+ $form['student_email_id'] = array(
+ '#title' => t('Student Email'),
+ '#type' => 'item',
+ '#markup' => user_load($proposal_data->uid)->mail,
+ '#title' => t('Email'),
+ );
+ $form['university'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->university,
+ '#title' => t('University/Institute'),
+ );
+ $form['how_did_you_know_about_project'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->how_did_you_know_about_project,
+ '#title' => t('How did you know about the project'),
+ );
+ $form['faculty_name'] = array(
+ '#type' => 'item',
+ '#markup' => $faculty_name,
+ '#title' => t('Name of the faculty'),
+ );
+ $form['faculty_department'] = array(
+ '#type' => 'item',
+ '#markup' => $faculty_department,
+ '#title' => t('Department of the faculty'),
+ );
+ $form['faculty_email'] = array(
+ '#type' => 'item',
+ '#markup' => $faculty_email,
+ '#title' => t('Email of the faculty'),
+ );
+ $form['country'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->country,
+ '#title' => t('Country'),
+ );
+ $form['all_state'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->state,
+ '#title' => t('State'),
+ );
+ $form['city'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->city,
+ '#title' => t('City'),
+ );
+ $form['pincode'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->pincode,
+ '#title' => t('Pincode/Postal code'),
+ );
+ $form['project_title'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->project_title,
+ '#title' => t('Title of the Case Study Project'),
+ );
+ $form['solver_used'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->solver_used,
+ '#title' => t('Solver used'),
+ );
+ /************************** reference link filter *******************/
+ $url = '~(?:(https?)://([^\s<]+)|(www\.[^\s<]+?\.[^\s<]+))(?<![\.,:])~i';
+ $reference = preg_replace($url, '<a href="$0" target="_blank" title="$0">$0</a>', $proposal_data->reference);
+ /******************************/
+ /*$form['reference'] = array(
+ '#type' => 'item',
+ '#markup' => $reference,
+ '#title' => t('References')
+ );*/
+ if (($query_abstract_pdf->filename != "") && ($query_abstract_pdf->filename != 'NULL')) {
+ $str = substr($query_abstract_pdf->filename, strrpos($query_abstract_pdf->filename, '/'));
+ $resource_file = ltrim($str, '/');
+
+ $form['abstract_file_path'] = array(
+ '#type' => 'item',
+ '#title' => t('Abstract file '),
+ '#markup' => l($resource_file, 'case-study-project/download/project-file/' . $proposal_id) . "",
+ );
+ } //$proposal_data->user_defined_compound_filepath != ""
+ else {
+ $form['abstract_file_path'] = array(
+ '#type' => 'item',
+ '#title' => t('Abstract file '),
+ '#markup' => "Not uploaded<br><br>",
+ );
+ }
+ $proposal_status = '';
+ switch ($proposal_data->approval_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;
+ default:
+ $proposal_status = t('Unkown');
+ break;
+ }
+ $form['proposal_status'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_status,
+ '#title' => t('Proposal Status'),
+ );
+ if ($proposal_data->approval_status == 0) {
+ $form['approve'] = array(
+ '#type' => 'item',
+ '#markup' => l('Click here', 'case-study-project/manage-proposal/approve/' . $proposal_id),
+ '#title' => t('Approve'),
+ );
+ } //$proposal_data->approval_status == 0
+ if ($proposal_data->approval_status == 1) {
+ $form['completed'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Completed'),
+ '#description' => t('Check if user has provided all the required files and pdfs.'),
+ );
+ } //$proposal_data->approval_status == 1
+ if ($proposal_data->approval_status == 2) {
+ $form['message'] = array(
+ '#type' => 'item',
+ '#markup' => $proposal_data->message,
+ '#title' => t('Reason for disapproval'),
+ );
+ } //$proposal_data->approval_status == 2
+ $form['submit'] = array(
+ '#type' => 'submit',
+ '#value' => t('Submit'),
+ );
+ $form['cancel'] = array(
+ '#type' => 'markup',
+ '#markup' => l(t('Cancel'), 'case-study-project/manage-proposal/all'),
+ );
+ return $form;
}
function cfd_case_study_proposal_status_form_submit($form, &$form_state)
{
- global $user;
- /* get current proposal */
- $proposal_id = (int) arg(3);
- //$proposal_q = db_query("SELECT * FROM {case_study_proposal} WHERE id = %d", $proposal_id);
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
- if ($proposal_q)
- {
- if ($proposal_data = $proposal_q->fetchObject())
- {
- /* everything ok */
- } //$proposal_data = $proposal_q->fetchObject()
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- } //$proposal_q
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- /* set the book status to completed */
- if ($form_state['values']['completed'] == 1)
- {
- $up_query = "UPDATE case_study_proposal SET approval_status = :approval_status , actual_completion_date = :expected_completion_date WHERE id = :proposal_id";
- $args = array(
- ":approval_status" => '3',
- ":proposal_id" => $proposal_id,
- ":expected_completion_date" => time()
- );
- $result = db_query($up_query, $args);
- CreateReadmeFileCaseStudyProject($proposal_id);
- if (!$result)
- {
- drupal_set_message('Error in update status', 'error');
- return;
- } //!$result
- /* sending email */
- $user_data = user_load($proposal_data->uid);
- $email_to = $user_data->mail;
- $from = variable_get('case_study_from_email', '');
- $bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
- $cc = variable_get('case_study_cc_emails', '');
- $params['case_study_proposal_completed']['proposal_id'] = $proposal_id;
- $params['case_study_proposal_completed']['user_id'] = $proposal_data->uid;
- $params['case_study_proposal_completed']['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('case_study', 'case_study_proposal_completed', $email_to, language_default(), $params, $from, TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message('Congratulations! CFD Case Study proposal has been marked as completed. User has been notified of the completion.', 'status');
- }
- drupal_goto('case-study-project/manage-proposal');
- return;
-
+ global $user;
+ /* get current proposal */
+ $proposal_id = (int) arg(3);
+ //$proposal_q = db_query("SELECT * FROM {case_study_proposal} WHERE id = %d", $proposal_id);
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
+ if ($proposal_q) {
+ if ($proposal_data = $proposal_q->fetchObject()) {
+ /* everything ok */
+ } //$proposal_data = $proposal_q->fetchObject()
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ } //$proposal_q
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ /* set the book status to completed */
+ if ($form_state['values']['completed'] == 1) {
+ $up_query = "UPDATE case_study_proposal SET approval_status = :approval_status , actual_completion_date = :expected_completion_date WHERE id = :proposal_id";
+ $args = array(
+ ":approval_status" => '3',
+ ":proposal_id" => $proposal_id,
+ ":expected_completion_date" => time(),
+ );
+ $result = db_query($up_query, $args);
+ CreateReadmeFileCaseStudyProject($proposal_id);
+ if (!$result) {
+ drupal_set_message('Error in update status', 'error');
+ return;
+ } //!$result
+ /* sending email */
+ $user_data = user_load($proposal_data->uid);
+ $email_to = $user_data->mail;
+ $from = variable_get('case_study_from_email', '');
+ $bcc = $user->mail . ', ' . variable_get('case_study_emails', '');
+ $cc = variable_get('case_study_cc_emails', '');
+ $params['case_study_proposal_completed']['proposal_id'] = $proposal_id;
+ $params['case_study_proposal_completed']['user_id'] = $proposal_data->uid;
+ $params['case_study_proposal_completed']['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('case_study', 'case_study_proposal_completed', $email_to, language_default(), $params, $from, true)) {
+ drupal_set_message('Error sending email message.', 'error');
+ }
+
+ drupal_set_message('Congratulations! CFD Case Study proposal has been marked as completed. User has been notified of the completion.', 'status');
+ }
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+
}
/******************************************************************************/
/**************************** PROPOSAL EDIT FORM ******************************/
/******************************************************************************/
function cfd_case_study_proposal_edit_form($form, &$form_state)
{
- global $user;
- /* get current proposal */
- $proposal_id = (int) arg(3);
- //$proposal_q = db_query("SELECT * FROM {case_study_proposal} WHERE id = %d", $proposal_id);
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
- if ($proposal_q)
- {
- if ($proposal_data = $proposal_q->fetchObject())
- {
- /* everything ok */
- } //$proposal_data = $proposal_q->fetchObject()
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- } //$proposal_q
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- $user_data = user_load($proposal_data->uid);
- $form['name_title'] = array(
- '#type' => 'select',
- '#title' => t('Title'),
- '#options' => array(
- 'Dr' => 'Dr',
- 'Prof' => 'Prof',
- 'Mr' => 'Mr',
- 'Ms' => 'Ms'
- ),
- '#required' => TRUE,
- '#default_value' => $proposal_data->name_title
- );
- $form['contributor_name'] = array(
- '#type' => 'textfield',
- '#title' => t('Name of the Proposer'),
- '#size' => 30,
- '#maxlength' => 50,
- '#required' => TRUE,
- '#default_value' => $proposal_data->contributor_name
- );
- $form['student_email_id'] = array(
- '#type' => 'item',
- '#title' => t('Email'),
- '#markup' => $user_data->mail
- );
- $form['university'] = array(
- '#type' => 'textfield',
- '#title' => t('University/Institute'),
- '#size' => 200,
- '#maxlength' => 200,
- '#required' => TRUE,
- '#default_value' => $proposal_data->university
- );
- $form['institute'] = array(
- '#type' => 'textfield',
- '#title' => t('Institute'),
- '#size' => 80,
- '#maxlength' => 200,
- '#required' => TRUE,
- '#default_value' => $proposal_data->institute
- );
- $form['how_did_you_know_about_project'] = array(
- '#type' => 'textfield',
- '#title' => t('How did you come to know about the Case Study Project?'),
- '#default_value' => $proposal_data->how_did_you_know_about_project,
- '#required' => TRUE
- );
- $form['faculty_name'] = array(
- '#type' => 'textfield',
- '#title' => t('Name of the Faculty'),
- '#size' => 50,
- '#maxlength' => 50,
- '#validated' => TRUE,
- '#default_value' => $proposal_data->faculty_name
- );
- $form['faculty_department'] = array(
- '#type' => 'textfield',
- '#title' => t('Department of the Faculty'),
- '#size' => 50,
- '#maxlength' => 50,
- '#validated' => TRUE,
- '#default_value' => $proposal_data->faculty_department
- );
- $form['faculty_email'] = array(
- '#type' => 'textfield',
- '#title' => t('Email id of the Faculty'),
- '#size' => 255,
- '#maxlength' => 255,
- '#validated' => TRUE,
- '#default_value' => $proposal_data->faculty_email
- );
- $form['country'] = array(
- '#type' => 'select',
- '#title' => t('Country'),
- '#options' => array(
- 'India' => 'India',
- 'Others' => 'Others'
- ),
- '#default_value' => $proposal_data->country,
- '#required' => TRUE,
- '#tree' => TRUE,
- '#validated' => TRUE
- );
- $form['other_country'] = array(
- '#type' => 'textfield',
- '#title' => t('Other than India'),
- '#size' => 100,
- '#default_value' => $proposal_data->country,
- '#attributes' => array(
- 'placeholder' => t('Enter your country name')
- ),
- '#states' => array(
- 'visible' => array(
- ':input[name="country"]' => array(
- 'value' => 'Others'
- )
- )
- )
- );
- $form['other_state'] = array(
- '#type' => 'textfield',
- '#title' => t('State other than India'),
- '#size' => 100,
- '#attributes' => array(
- 'placeholder' => t('Enter your state/region name')
- ),
- '#default_value' => $proposal_data->state,
- '#states' => array(
- 'visible' => array(
- ':input[name="country"]' => array(
- 'value' => 'Others'
- )
- )
- )
- );
- $form['other_city'] = array(
- '#type' => 'textfield',
- '#title' => t('City other than India'),
- '#size' => 100,
- '#attributes' => array(
- 'placeholder' => t('Enter your city name')
- ),
- '#default_value' => $proposal_data->city,
- '#states' => array(
- 'visible' => array(
- ':input[name="country"]' => array(
- 'value' => 'Others'
- )
- )
- )
- );
- $form['all_state'] = array(
- '#type' => 'select',
- '#title' => t('State'),
- '#options' => _df_list_of_states(),
- '#default_value' => $proposal_data->state,
- '#validated' => TRUE,
- '#states' => array(
- 'visible' => array(
- ':input[name="country"]' => array(
- 'value' => 'India'
- )
- )
- )
- );
- $form['city'] = array(
- '#type' => 'select',
- '#title' => t('City'),
- '#options' => _df_list_of_cities(),
- '#default_value' => $proposal_data->city,
- '#states' => array(
- 'visible' => array(
- ':input[name="country"]' => array(
- 'value' => 'India'
- )
- )
- )
- );
- $form['pincode'] = array(
- '#type' => 'textfield',
- '#title' => t('Pincode'),
- '#size' => 30,
- '#maxlength' => 6,
- '#default_value' => $proposal_data->pincode,
- '#attributes' => array(
- 'placeholder' => 'Insert pincode of your city/ village....'
- )
- );
- $form['project_title'] = array(
- '#type' => 'textfield',
- '#title' => t('Title of the Case Study Project'),
- '#size' => 300,
- '#maxlength' => 350,
- '#required' => TRUE,
- '#default_value' => $proposal_data->project_title
- );
- $form['solver_used'] = array(
- '#type' => 'textfield',
- '#title' => t('Solver to be used'),
- '#size' => 50,
- '#maxlength' => 50,
- '#required' => TRUE,
- '#default_value' => $proposal_data->solver_used
- );
- $form['date_of_proposal'] = array(
- '#type' => 'textfield',
- '#title' => t('Date of Proposal'),
- '#default_value' => date('d/m/Y', $proposal_data->creation_date),
- '#disabled' => TRUE,
- );
- $form['delete_proposal'] = array(
- '#type' => 'checkbox',
- '#title' => t('Delete Proposal')
- );
- $form['submit'] = array(
- '#type' => 'submit',
- '#value' => t('Submit')
- );
- $form['cancel'] = array(
- '#type' => 'item',
- '#markup' => l(t('Cancel'), 'case-study-project/manage-proposal')
- );
- return $form;
+ global $user;
+ /* get current proposal */
+ $proposal_id = (int) arg(3);
+ //$proposal_q = db_query("SELECT * FROM {case_study_proposal} WHERE id = %d", $proposal_id);
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
+ if ($proposal_q) {
+ if ($proposal_data = $proposal_q->fetchObject()) {
+ /* everything ok */
+ } //$proposal_data = $proposal_q->fetchObject()
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ } //$proposal_q
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ $user_data = user_load($proposal_data->uid);
+ $form['name_title'] = array(
+ '#type' => 'select',
+ '#title' => t('Title'),
+ '#options' => array(
+ 'Dr' => 'Dr',
+ 'Prof' => 'Prof',
+ 'Mr' => 'Mr',
+ 'Ms' => 'Ms',
+ ),
+ '#required' => true,
+ '#default_value' => $proposal_data->name_title,
+ );
+ $form['contributor_name'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Name of the Proposer'),
+ '#size' => 30,
+ '#maxlength' => 50,
+ '#required' => true,
+ '#default_value' => $proposal_data->contributor_name,
+ );
+ $form['student_email_id'] = array(
+ '#type' => 'item',
+ '#title' => t('Email'),
+ '#markup' => $user_data->mail,
+ );
+ $form['university'] = array(
+ '#type' => 'textfield',
+ '#title' => t('University/Institute'),
+ '#size' => 200,
+ '#maxlength' => 200,
+ '#required' => true,
+ '#default_value' => $proposal_data->university,
+ );
+ $form['institute'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Institute'),
+ '#size' => 80,
+ '#maxlength' => 200,
+ '#required' => true,
+ '#default_value' => $proposal_data->institute,
+ );
+ $form['how_did_you_know_about_project'] = array(
+ '#type' => 'textfield',
+ '#title' => t('How did you come to know about the Case Study Project?'),
+ '#default_value' => $proposal_data->how_did_you_know_about_project,
+ '#required' => true,
+ );
+ $form['faculty_name'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Name of the Faculty'),
+ '#size' => 50,
+ '#maxlength' => 50,
+ '#validated' => true,
+ '#default_value' => $proposal_data->faculty_name,
+ );
+ $form['faculty_department'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Department of the Faculty'),
+ '#size' => 50,
+ '#maxlength' => 50,
+ '#validated' => true,
+ '#default_value' => $proposal_data->faculty_department,
+ );
+ $form['faculty_email'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Email id of the Faculty'),
+ '#size' => 255,
+ '#maxlength' => 255,
+ '#validated' => true,
+ '#default_value' => $proposal_data->faculty_email,
+ );
+ $form['country'] = array(
+ '#type' => 'select',
+ '#title' => t('Country'),
+ '#options' => array(
+ 'India' => 'India',
+ 'Others' => 'Others',
+ ),
+ '#default_value' => $proposal_data->country,
+ '#required' => true,
+ '#tree' => true,
+ '#validated' => true,
+ );
+ $form['other_country'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Other than India'),
+ '#size' => 100,
+ '#default_value' => $proposal_data->country,
+ '#attributes' => array(
+ 'placeholder' => t('Enter your country name'),
+ ),
+ '#states' => array(
+ 'visible' => array(
+ ':input[name="country"]' => array(
+ 'value' => 'Others',
+ ),
+ ),
+ ),
+ );
+ $form['other_state'] = array(
+ '#type' => 'textfield',
+ '#title' => t('State other than India'),
+ '#size' => 100,
+ '#attributes' => array(
+ 'placeholder' => t('Enter your state/region name'),
+ ),
+ '#default_value' => $proposal_data->state,
+ '#states' => array(
+ 'visible' => array(
+ ':input[name="country"]' => array(
+ 'value' => 'Others',
+ ),
+ ),
+ ),
+ );
+ $form['other_city'] = array(
+ '#type' => 'textfield',
+ '#title' => t('City other than India'),
+ '#size' => 100,
+ '#attributes' => array(
+ 'placeholder' => t('Enter your city name'),
+ ),
+ '#default_value' => $proposal_data->city,
+ '#states' => array(
+ 'visible' => array(
+ ':input[name="country"]' => array(
+ 'value' => 'Others',
+ ),
+ ),
+ ),
+ );
+ $form['all_state'] = array(
+ '#type' => 'select',
+ '#title' => t('State'),
+ '#options' => _df_list_of_states(),
+ '#default_value' => $proposal_data->state,
+ '#validated' => true,
+ '#states' => array(
+ 'visible' => array(
+ ':input[name="country"]' => array(
+ 'value' => 'India',
+ ),
+ ),
+ ),
+ );
+ $form['city'] = array(
+ '#type' => 'select',
+ '#title' => t('City'),
+ '#options' => _df_list_of_cities(),
+ '#default_value' => $proposal_data->city,
+ '#states' => array(
+ 'visible' => array(
+ ':input[name="country"]' => array(
+ 'value' => 'India',
+ ),
+ ),
+ ),
+ );
+ $form['pincode'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Pincode'),
+ '#size' => 30,
+ '#maxlength' => 6,
+ '#default_value' => $proposal_data->pincode,
+ '#attributes' => array(
+ 'placeholder' => 'Insert pincode of your city/ village....',
+ ),
+ );
+ $form['project_title'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Title of the Case Study Project'),
+ '#size' => 300,
+ '#maxlength' => 350,
+ '#required' => true,
+ '#default_value' => $proposal_data->project_title,
+ );
+ $form['solver_used'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Solver to be used'),
+ '#size' => 50,
+ '#maxlength' => 50,
+ '#required' => true,
+ '#default_value' => $proposal_data->solver_used,
+ );
+ $form['date_of_proposal'] = array(
+ '#type' => 'textfield',
+ '#title' => t('Date of Proposal'),
+ '#default_value' => date('d/m/Y', $proposal_data->creation_date),
+ '#disabled' => true,
+ );
+ $form['delete_proposal'] = array(
+ '#type' => 'checkbox',
+ '#title' => t('Delete Proposal'),
+ );
+ $form['submit'] = array(
+ '#type' => 'submit',
+ '#value' => t('Submit'),
+ );
+ $form['cancel'] = array(
+ '#type' => 'item',
+ '#markup' => l(t('Cancel'), 'case-study-project/manage-proposal'),
+ );
+ return $form;
}
function cfd_case_study_proposal_edit_form_submit($form, &$form_state)
{
- global $user;
- /* get current proposal */
- $proposal_id = (int) arg(3);
- $query = db_select('case_study_proposal');
- $query->fields('case_study_proposal');
- $query->condition('id', $proposal_id);
- $proposal_q = $query->execute();
- if ($proposal_q)
- {
- if ($proposal_data = $proposal_q->fetchObject())
- {
- /* everything ok */
- } //$proposal_data = $proposal_q->fetchObject()
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- } //$proposal_q
- else
- {
- drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
- drupal_goto('case-study-project/manage-proposal');
- return;
- }
- /* delete proposal */
- if ($form_state['values']['delete_proposal'] == 1)
- {
- /* sending email */
- $user_data = user_load($proposal_data->uid);
- $email_to = $user_data->mail;
- $from = variable_get('case_study_from_email', '');
- $bcc = variable_get('case_study_emails', '');
- $cc = variable_get('case_study_cc_emails', '');
- $params['case_study_proposal_deleted']['proposal_id'] = $proposal_id;
- $params['case_study_proposal_deleted']['user_id'] = $proposal_data->uid;
- $params['case_study_proposal_deleted']['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('case_study', 'case_study_proposal_deleted', $email_to, user_preferred_language($user), $params, $from, TRUE))
- drupal_set_message('Error sending email message.', 'error');
- drupal_set_message(t('Case Study proposal has been deleted.'), 'status');
- if (rrmdir_project($proposal_id) == TRUE)
- {
- $query = db_delete('case_study_proposal');
- $query->condition('id', $proposal_id);
- $num_deleted = $query->execute();
- drupal_set_message(t('Proposal Deleted'), 'status');
- drupal_goto('case-study-project/manage-proposal');
- return;
- } //rrmdir_project($proposal_id) == TRUE
- } //$form_state['values']['delete_proposal'] == 1
- /* update proposal */
- $v = $form_state['values'];
- $project_title = $v['project_title'];
- $solver_used = $v['solver_used'];
- $proposar_name = $v['name_title'] . ' ' . $v['contributor_name'];
- $university = $v['university'];
- $directory_names = _df_dir_name($project_title, $proposar_name);
- if (DF_RenameDir($proposal_id, $directory_names))
- {
- $directory_name = $directory_names;
- } //LM_RenameDir($proposal_id, $directory_names)
- else
- {
- return;
- }
- $query = "UPDATE case_study_proposal SET
+ global $user;
+ /* get current proposal */
+ $proposal_id = (int) arg(3);
+ $query = db_select('case_study_proposal');
+ $query->fields('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $proposal_q = $query->execute();
+ if ($proposal_q) {
+ if ($proposal_data = $proposal_q->fetchObject()) {
+ /* everything ok */
+ } //$proposal_data = $proposal_q->fetchObject()
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ } //$proposal_q
+ else {
+ drupal_set_message(t('Invalid proposal selected. Please try again.'), 'error');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ }
+ /* delete proposal */
+ if ($form_state['values']['delete_proposal'] == 1) {
+ /* sending email */
+ $user_data = user_load($proposal_data->uid);
+ $email_to = $user_data->mail;
+ $from = variable_get('case_study_from_email', '');
+ $bcc = variable_get('case_study_emails', '');
+ $cc = variable_get('case_study_cc_emails', '');
+ $params['case_study_proposal_deleted']['proposal_id'] = $proposal_id;
+ $params['case_study_proposal_deleted']['user_id'] = $proposal_data->uid;
+ $params['case_study_proposal_deleted']['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('case_study', 'case_study_proposal_deleted', $email_to, user_preferred_language($user), $params, $from, true)) {
+ drupal_set_message('Error sending email message.', 'error');
+ }
+
+ drupal_set_message(t('Case Study proposal has been deleted.'), 'status');
+ if (rrmdir_project($proposal_id) == true) {
+ $query = db_delete('case_study_proposal');
+ $query->condition('id', $proposal_id);
+ $num_deleted = $query->execute();
+ drupal_set_message(t('Proposal Deleted'), 'status');
+ drupal_goto('case-study-project/manage-proposal');
+ return;
+ } //rrmdir_project($proposal_id) == TRUE
+ } //$form_state['values']['delete_proposal'] == 1
+ /* update proposal */
+ $v = $form_state['values'];
+ $project_title = $v['project_title'];
+ $solver_used = $v['solver_used'];
+ $proposar_name = $v['name_title'] . ' ' . $v['contributor_name'];
+ $university = $v['university'];
+ $directory_names = _df_dir_name($project_title, $proposar_name);
+ if (DF_RenameDir($proposal_id, $directory_names)) {
+ $directory_name = $directory_names;
+ } //LM_RenameDir($proposal_id, $directory_names)
+ else {
+ return;
+ }
+ $query = "UPDATE case_study_proposal SET
name_title=:name_title,
contributor_name=:contributor_name,
university=:university,
@@ -1013,23 +1040,23 @@ function cfd_case_study_proposal_edit_form_submit($form, &$form_state)
solver_used=:solver_used,
directory_name=:directory_name
WHERE id=:proposal_id";
- $args = array(
- ':name_title' => $v['name_title'],
- ':contributor_name' => $v['contributor_name'],
- ':university' => $v['university'],
- ":institute" => $v['institute'],
- ":how_did_you_know_about_project" => $v['how_did_you_know_about_project'],
- ":faculty_name" => $v['faculty_name'],
- ":faculty_department" => $v['faculty_department'],
- ":faculty_email" => $v['faculty_email'],
- ':city' => $v['city'],
- ':pincode' => $v['pincode'],
- ':state' => $v['all_state'],
- ':project_title' => $project_title,
- ":solver_used" => $solver_used,
- ':directory_name' => $directory_name,
- ':proposal_id' => $proposal_id
- );
- $result = db_query($query, $args);
- drupal_set_message(t('Proposal Updated'), 'status');
+ $args = array(
+ ':name_title' => $v['name_title'],
+ ':contributor_name' => $v['contributor_name'],
+ ':university' => $v['university'],
+ ":institute" => $v['institute'],
+ ":how_did_you_know_about_project" => $v['how_did_you_know_about_project'],
+ ":faculty_name" => $v['faculty_name'],
+ ":faculty_department" => $v['faculty_department'],
+ ":faculty_email" => $v['faculty_email'],
+ ':city' => $v['city'],
+ ':pincode' => $v['pincode'],
+ ':state' => $v['all_state'],
+ ':project_title' => $project_title,
+ ":solver_used" => $solver_used,
+ ':directory_name' => $directory_name,
+ ':proposal_id' => $proposal_id,
+ );
+ $result = db_query($query, $args);
+ drupal_set_message(t('Proposal Updated'), 'status');
}
generated by cgit (git 2.34.1) at 2024-12-19 15:37:15 +0000