summaryrefslogtreecommitdiff
path: root/bulk_approval.inc
diff options
context:
space:
mode:
Diffstat (limited to 'bulk_approval.inc')
-rwxr-xr-xbulk_approval.inc790
1 files changed, 566 insertions, 224 deletions
diff --git a/bulk_approval.inc b/bulk_approval.inc
index 36910d8..f5a1ff0 100755
--- a/bulk_approval.inc
+++ b/bulk_approval.inc
@@ -1,13 +1,10 @@
<?php
function lab_migration_bulk_approval_form($form, &$form_state)
-{
+ {
$options_first = _bulk_list_of_labs();
$options_two = _ajax_bulk_get_experiment_list();
$selected = isset($form_state['values']['lab']) ? $form_state['values']['lab'] : key($options_first);
$select_two = isset($form_state['values']['lab_experiment_list']) ? $form_state['values']['lab_experiment_list'] : key($options_two);
- $action_first = _bulk_list_lab_actions();
- $action_two = _bulk_list_experiment_actions();
- $selected_action = isset($form_state['values']['lab_actions']) ? $form_state['values']['lab_actions'] : key($action_first);
$form = array();
$form['lab'] = array(
'#type' => 'select',
@@ -21,7 +18,7 @@ function lab_migration_bulk_approval_form($form, &$form_state)
);
$form['lab_actions'] = array(
'#type' => 'select',
- '#title' => t('Please select action for lab'),
+ '#title' => t('Please select action for Entire Lab'),
'#options' => _bulk_list_lab_actions(),
'#default_value' => 0,
'#prefix' => '<div id="ajax_selected_lab_action" style="color:red;">',
@@ -58,15 +55,26 @@ function lab_migration_bulk_approval_form($form, &$form_state)
);
$form['lab_experiment_actions'] = array(
'#type' => 'select',
- '#title' => t('Please select action for lab experiment'),
+ '#title' => t('Please select action for Entire Experiment'),
'#options' => _bulk_list_experiment_actions(),
'#default_value' => 0,
'#prefix' => '<div id="ajax_selected_lab_experiment_action" style="color:red;">',
'#suffix' => '</div>',
+ //'#states' => array('invisible' => array(':input[name="lab"]' => array('value' => 0),),),
'#states' => array(
'invisible' => array(
- ':input[name="lab"]' => array(
- 'value' => 0
+ array(
+ array(
+ ':input[name="lab"]' => array(
+ 'value' => 0
+ )
+ ),
+ 'or',
+ array(
+ ':input[name="lab_actions"]' => array(
+ 'value' => 0
+ )
+ )
)
)
)
@@ -114,7 +122,7 @@ function lab_migration_bulk_approval_form($form, &$form_state)
);
$form['solution_files'] = array(
'#type' => 'item',
- // '#title' => t('List of solution files'),
+ //'#title' => t('List of solution_files'),
'#markup' => '<div id="ajax_solution_files"></div>',
'#states' => array(
'invisible' => array(
@@ -147,14 +155,19 @@ function lab_migration_bulk_approval_form($form, &$form_state)
':input[name="lab_experiment_solution_actions"]' => array(
'value' => 3
)
+ ),
+ 'or',
+ array(
+ ':input[name="lab_actions"]' => array(
+ 'value' => 4
+ )
)
)
),
- 'or',
'required' => array(
array(
array(
- ':input[name="book_actions"]' => array(
+ ':input[name="lab_actions"]' => array(
'value' => 3
)
),
@@ -169,6 +182,12 @@ function lab_migration_bulk_approval_form($form, &$form_state)
':input[name="lab_experiment_solution_actions"]' => array(
'value' => 3
)
+ ),
+ 'or',
+ array(
+ ':input[name="lab_actions"]' => array(
+ 'value' => 4
+ )
)
)
)
@@ -187,17 +206,19 @@ function lab_migration_bulk_approval_form($form, &$form_state)
)
);
return $form;
-}
+ }
/**
* Ajax callback triggered by select.
*/
function ajax_bulk_experiment_list_callback($form, $form_state)
-{
+ {
$commands = array();
$lab_default_value = $form_state['values']['lab'];
- if ($lab_default_value != 0) {
+ if ($lab_default_value != 0)
+ {
$commands[] = ajax_command_html('#ajax_selected_lab', l('Download', 'lab-migration/full-download/lab/' . $lab_default_value) . ' ' . t('(Download all the approved and unapproved solutions of the entire lab)'));
- /*$commands[] = ajax_command_html('#ajax_selected_lab_pdf', l('Download PDF', 'lab-migration/generate-lab/' .$lab_default_value . '/1') . ' ' . t('(Download PDF of all the approved and unapproved solution of the entire lab)')); */
+ /*$commands[] = ajax_command_html('#ajax_selected_lab_pdf', l('Download PDF', 'lab_migration/generate_lab/' . $lab_default_value . '/1') .
+ ' ' . t('(Download PDF of all the approved and unapproved solution of the entire lab)')); */
$form['lab_actions']['#options'] = _bulk_list_lab_actions();
$form['lab_experiment_list']['#options'] = _ajax_bulk_get_experiment_list($lab_default_value);
$commands[] = ajax_command_data('#ajax_selected_lab', 'form_state_value_select', $form_state['values']['lab_experiment_list']);
@@ -209,7 +230,9 @@ function ajax_bulk_experiment_list_callback($form, $form_state)
$commands[] = ajax_command_html('#ajax_solution_files', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
- } else {
+ }
+ else
+ {
$commands[] = ajax_command_html('#ajax_selected_lab', '');
$commands[] = ajax_command_html('#ajax_selected_lab_pdf', '');
$commands[] = ajax_command_data('#ajax_selected_lab', 'form_state_value_select', $form_state['values']['lab']);
@@ -221,18 +244,19 @@ function ajax_bulk_experiment_list_callback($form, $form_state)
$commands[] = ajax_command_html('#ajax_solution_files', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
- }
+ }
return array(
'#type' => 'ajax',
'#commands' => $commands
);
-}
+ }
function ajax_bulk_solution_list_callback($form, $form_state)
-{
+ {
$commands = array();
$experiment_list_default_value = $form_state['values']['lab_experiment_list'];
//var_dump($lab_default_value);
- if ($experiment_list_default_value != 0) {
+ if ($experiment_list_default_value != 0)
+ {
$form['lab_experiment_actions']['#options'] = _bulk_list_experiment_actions();
$form['lab_solution_list']['#options'] = _ajax_bulk_get_solution_list($experiment_list_default_value);
$commands[] = ajax_command_html('#ajax_download_experiment', l('Download Experiment', 'lab-migration/download/experiment/' . $experiment_list_default_value));
@@ -244,7 +268,9 @@ function ajax_bulk_solution_list_callback($form, $form_state)
$commands[] = ajax_command_html('#ajax_solution_files', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
- } else {
+ }
+ else
+ {
$commands[] = ajax_command_html('#ajax_download_experiment', '');
$commands[] = ajax_command_html('#ajax_selected_lab_experiment_action', '');
$commands[] = ajax_command_html('#ajax_selected_solution', '');
@@ -253,18 +279,19 @@ function ajax_bulk_solution_list_callback($form, $form_state)
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
// $commands[] = ajax_command_replace('#ajax_selected_experiment',drupal_render($form['lab_experiment_list']));
- }
+ }
return array(
'#type' => 'ajax',
'#commands' => $commands
);
-}
+ }
function ajax_bulk_solution_files_callback($form, $form_state)
-{
+ {
$commands = array();
$solution_list_default_value = $form_state['values']['lab_solution_list'];
//var_dump($lab_default_value);
- if ($solution_list_default_value != 0) {
+ if ($solution_list_default_value != 0)
+ {
$form['lab_experiment_solution_actions']['#options'] = _bulk_list_solution_actions();
$commands[] = ajax_command_html('#ajax_selected_lab_experiment_solution_action', drupal_render($form['lab_experiment_solution_actions']));
/*************************************************************************************/
@@ -273,11 +300,14 @@ function ajax_bulk_solution_files_callback($form, $form_state)
$query->fields('lab_migration_solution_files');
$query->condition('solution_id', $solution_list_default_value);
$solution_list_q = $query->execute();
- if ($solution_list_q) {
+ if ($solution_list_q)
+ {
$solution_files_rows = array();
- while ($solution_list_data = $solution_list_q->fetchObject()) {
+ while ($solution_list_data = $solution_list_q->fetchObject())
+ {
$solution_file_type = '';
- switch ($solution_list_data->filetype) {
+ switch ($solution_list_data->filetype)
+ {
case 'S':
$solution_file_type = 'Source or Main file';
break;
@@ -295,14 +325,23 @@ function ajax_bulk_solution_files_callback($form, $form_state)
l($solution_list_data->filename, 'lab-migration/download/file/' . $solution_list_data->id),
$solution_file_type
);
- }
+ if (strlen($solution_list_data->pdfpath) >= 5)
+ {
+ $pdfname = substr($solution_list_data->pdfpath, strrpos($solution_list_data->pdfpath, '/') + 1);
+ $solution_files_rows[] = array(
+ l($pdfname, 'lab-migration/download/pdf/' . $solution_list_data->id),
+ "PDF File"
+ );
+ }
+ }
/* dependency files */
//$dependency_q = db_query("SELECT * FROM {lab_migration_solution_dependency} WHERE solution_id = %d", $form_state['values']['solution']);
$query = db_select('lab_migration_solution_dependency');
$query->fields('lab_migration_solution_dependency');
$query->condition('solution_id', $solution_list_default_value);
$dependency_q = $query->execute();
- while ($dependency_data = $dependency_q->fetchObject()) {
+ while ($dependency_data = $dependency_q->fetchObject())
+ {
//$dependency_files_q = db_query("SELECT * FROM {lab_migration_dependency_files} WHERE id = %d", $dependency_data->dependency_id);
$query = db_select('lab_migration_dependency_files');
$query->fields('lab_migration_dependency_files');
@@ -314,7 +353,7 @@ function ajax_bulk_solution_files_callback($form, $form_state)
l($dependency_files_data->filename, 'lab-migration/download/dependency/' . $dependency_files_data->dependency_id),
$solution_file_type
);
- }
+ }
/* creating list of files table */
$solution_files_header = array(
'Filename',
@@ -324,147 +363,235 @@ function ajax_bulk_solution_files_callback($form, $form_state)
'header' => $solution_files_header,
'rows' => $solution_files_rows
));
- }
+ }
$form['solution_files']['#title'] = 'List of solution files';
$form['solution_files']['#markup'] = $solution_files;
$commands[] = ajax_command_html('#ajax_download_experiment_solution', l('Download Solution', 'lab-migration/download/solution/' . $solution_list_default_value));
- $commands[] = ajax_command_html('#ajax_edit_experiment_solution', l('Edit Solution', 'code-approval/editcode/' . $solution_list_default_value));
+ $commands[] = ajax_command_html('#ajax_edit_experiment_solution', l('Edit Solution', 'lab-migration/code-approval/editcode/' . $solution_list_default_value));
// $commands[] = ajax_command_html('#ajax_solution_files', $solution_files);
$commands[] = ajax_command_html('#ajax_solution_files', drupal_render($form['solution_files']));
/*************************************************************************************/
- } else {
+ }
+ else
+ {
$commands[] = ajax_command_html('#ajax_selected_lab_experiment_solution_action', '');
$commands[] = ajax_command_html('#ajax_download_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_edit_experiment_solution', '');
$commands[] = ajax_command_html('#ajax_solution_files', '');
- }
+ }
return array(
'#type' => 'ajax',
'#commands' => $commands
);
-}
-function lab_migration_bulk_approval_form_submit($form, $form_state)
-{
- // In most cases, it is recomended that you put this logic in form generation
- // rather than the callback. Submit driven forms are an exception, because
- // you may not want to return the form at all.
+ }
+/************************************************************/
+function lab_migration_bulk_approval_form_submit($form, &$form_state)
+ {
global $user;
$root_path = lab_migration_path();
- if ($form_state['clicked_button']['#value'] == 'Submit') {
- if ($form_state['values']['lab']) {
+ if ($form_state['clicked_button']['#value'] == 'Submit')
+ {
+ if ($form_state['values']['lab'])
lab_migration_del_lab_pdf($form_state['values']['lab']);
- }
- if (user_access('lab migration bulk manage code')) {
- $query = db_select('lab_migration_proposal');
- $query->fields('lab_migration_proposal');
- $query->condition('id', $form_state['values']['lab']);
- $user_query = $query->execute();
- $user_info =$user_query->fetchObject();
-
- $user_data = user_load($user_info->uid);
-
- if (($form_state['values']['lab_actions'] == 1) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
+ if (user_access('lab migration bulk manage code'))
+ {
+ $query = db_select('lab_migration_proposal');
+ $query->fields('lab_migration_proposal');
+ $query->condition('id', $form_state['values']['lab']);
+ $user_query = $query->execute();
+ $user_info = $user_query->fetchObject();
+ $user_data = user_load($user_info->uid);
+ if (($form_state['values']['lab_actions'] == 1) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
/* approving entire lab */
// $experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d", $form_state['values']['lab']);
$query = db_select('lab_migration_experiment');
$query->fields('lab_migration_experiment');
$query->condition('proposal_id', $form_state['values']['lab']);
+ $query->orderBy('number', 'ASC');
$experiment_q = $query->execute();
- while ($experiment_data = $experiment_q->fetchObject()) {
+ $experiment_list = '';
+ while ($experiment_data = $experiment_q->fetchObject())
+ {
// db_query("UPDATE {lab_migration_solution} SET approval_status = 1, approver_uid = %d WHERE experiment_id = %d AND approval_status = 0", $user->uid, $experiment_data->id);
db_query("UPDATE {lab_migration_solution} SET approval_status = 1, approver_uid = :approver_uid WHERE experiment_id = :experiment_id AND approval_status = 0", array(
':approver_uid' => $user->uid,
':experiment_id' => $experiment_data->id
));
- }
+ $experiment_list .= '<p>' . $experiment_data->number . ') ' . $experiment_data->title . '<br> Description : ' . $experiment_data->description . '<br>';
+ $experiment_list .= ' ';
+ $experiment_list .= '</p>';
+ }
drupal_set_message(t('Approved Entire Lab.'), 'status');
/* email */
$email_subject = t('[!site_name] Your uploaded Lab Migration solutions have been approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your all the uploaded solutions for the Lab have been approved.')
+ 0 => t('
+
+Dear !user_name,
+
+Your all the uploaded solutions for the Lab with the below detail has been approved:
+
+Title of Lab :' . $user_info->lab_title . '
+
+List of experiments : ' . $experiment_list . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 2) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
+ }
+ elseif (($form_state['values']['lab_actions'] == 2) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
/* pending review entire lab */
//$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d", $form_state['values']['lab']);
$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = :proposal_id", array(
':proposal_id' => $form_state['values']['lab']
));
- while ($experiment_data = $experiment_q->fetchObject()) {
+ while ($experiment_data = $experiment_q->fetchObject())
+ {
//db_query("UPDATE {lab_migration_solution} SET approval_status = 0 WHERE experiment_id = %d", $experiment_data->id);
db_query("UPDATE {lab_migration_solution} SET approval_status = 0 WHERE experiment_id = :experiment_id", array(
":experiment_id" => $experiment_data->id
));
- }
+ }
drupal_set_message(t('Pending Review Entire Lab.'), 'status');
/* email */
$email_subject = t('[!site_name] Your uploaded Lab Migration solutions have been marked as pending', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your all the uploaded solutions for the Lab have been marked as pending to be review. You will be able to see the solutions after they have been approved by one of our reviewers.')
+ 0 => t('
+
+Dear !user_name,
+
+Your all the uploaded solutions for the Lab with Title : ' . $user_info->lab_title . ' have been marked as pending to be reviewed.
+
+You will be able to see the solutions after they have been approved by one of our reviewers.
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 3) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
- if (!$form_state['values']['message']) {
- if (strlen(trim($form_state['values']['message'])) <= 30) {
- form_set_error('message', t(''));
- drupal_set_message("Please mention the reason for disapproval.", 'error');
- return;
- }
- }
- if (!user_access('lab migration bulk delete code')) {
+ /* email */
+ /* $email_subject = t('Your uploaded Lab Migration solutions have been marked as pending');
+ $email_body = array(0 => t('Your all the uploaded solutions for the Lab have been marked as pending to be review. You will be able to see the solutions after they have been approved by one of our reviewers.'));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 3) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
+ if (strlen(trim($form_state['values']['message'])) <= 30)
+ {
+ form_set_error('message', t(''));
+ drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+ return;
+ }
+ if (!user_access('lab migration bulk delete code'))
+ {
drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Lab.'), 'error');
return;
- }
- if (lab_migration_delete_lab($form_state['values']['lab'])) {
+ }
+ if (lab_migration_delete_lab($form_state['values']['lab']))
+ {
drupal_set_message(t('Dis-Approved and Deleted Entire Lab.'), 'status');
- } else {
+ }
+ else
+ {
drupal_set_message(t('Error Dis-Approving and Deleting Entire Lab.'), 'error');
- }
+ }
/* email */
$email_subject = t('[!site_name] Your uploaded Lab Migration solutions have been marked as dis-approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your all the uploaded solutions for the whole Lab have been marked as dis-approved.
+ 0 => t('
- Reason for dis-approval:
+Dear !user_name,
- ' . $form_state['values']['message'])
+Your all the uploaded solutions for the whole Lab with Title : ' . $user_info->lab_title . ' have been marked as dis-approved.
+
+Reason for dis-approval:' . $form_state['values']['message'] . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 4) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
- if (!$form_state['values']['message']) {
- if (strlen(trim($form_state['values']['message'])) <= 30) {
- form_set_error('message', t(''));
- drupal_set_message("Please mention the reason for disapproval.", 'error');
- return;
- }
- }
- if (!user_access('lab migration bulk delete code')) {
+ /* email */
+ /* $email_subject = t('Your uploaded Lab Migration solutions have been marked as dis-approved');
+ $email_body = array(0 =>t('Your all the uploaded solutions for the whole Lab have been marked as dis-approved.
+
+ Reason for dis-approval:
+
+ ' . $form_state['values']['message']));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 4) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
+ if (strlen(trim($form_state['values']['message'])) <= 30)
+ {
+ form_set_error('message', t(''));
+ drupal_set_message("Please mention the reason for disapproval/deletion. Minimum 30 character required", 'error');
+ return;
+ }
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('proposal_id', $form_state['values']['lab']);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_list = '';
+ while ($experiment_data = $experiment_q->fetchObject())
+ {
+ $experiment_list .= '<p>' . $experiment_data->number . ') ' . $experiment_data->title . '<br> Description : ' . $experiment_data->description . '<br>';
+ $experiment_list .= ' ';
+ $experiment_list .= '</p>';
+ }
+ if (!user_access('lab migration bulk delete code'))
+ {
drupal_set_message(t('You do not have permission to Bulk Delete Entire Lab Including Proposal.'), 'error');
return;
- }
+ }
/* check if dependency files are present */
$dep_q = db_query("SELECT * FROM {lab_migration_dependency_files} WHERE proposal_id = :proposal_id", array(
":proposal_id" => $form_state['values']['lab']
));
- if ($dep_data = $dep_q->fetchObject()) {
+ if ($dep_data = $dep_q->fetchObject())
+ {
drupal_set_message(t("Cannot delete lab since it has dependency files that can be used by others. First delete the dependency files before deleting the lab."), 'error');
return;
- }
- if (lab_migration_delete_lab($form_state['values']['lab'])) {
+ }
+ if (lab_migration_delete_lab($form_state['values']['lab']))
+ {
drupal_set_message(t('Dis-Approved and Deleted Entire Lab solutions.'), 'status');
- $dir_path = $root_path . $form_state['values']['lab'];
- if (is_dir($dir_path)) {
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('proposal_id', $form_state['values']['lab']);
+ $experiment_q = $query->execute()->fetchObject();
+ $dir_path = $root_path . $experiment_q->directory_name;
+ if (is_dir($dir_path))
+ {
$res = rmdir($dir_path);
- if (!$res) {
+ if (!$res)
+ {
drupal_set_message(t("Cannot delete Lab directory : " . $dir_path . ". Please contact administrator."), 'error');
return;
- }
- } else {
+ }
+ }
+ else
+ {
drupal_set_message(t("Lab directory not present : " . $dir_path . ". Skipping deleting lab directory."), 'status');
- }
+ }
/* deleting full proposal */
//$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $form_state['values']['lab']);
$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = :id", array(
@@ -484,68 +611,208 @@ function lab_migration_bulk_approval_form_submit($form, $form_state)
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your all the uploaded solutions including the Lab proposal have been deleted permanently.')
+ 0 => t('
+
+Dear !user_name,
+
+We regret to inform you that all the uploaded Experiments of your Lab with following details have been deleted permanently.
+
+Title of Lab :' . $user_info->lab_title . '
+
+List of experiments : ' . $experiment_list . '
+
+Reason for dis-approval:' . $form_state['values']['message'] . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } else {
+ /* email */
+ /* $email_subject = t('Your uploaded Lab Migration solutions including the Lab proposal have been deleted');
+ $email_body = array(0 =>t('Your all the uploaded solutions including the Lab proposal have been deleted permanently.'));*/
+ }
+ else
+ {
drupal_set_message(t('Error Dis-Approving and Deleting Entire Lab.'), 'error');
- }
- } elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 1) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
+ }
+ }
+ elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 1) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
db_query("UPDATE {lab_migration_solution} SET approval_status = 1, approver_uid = :approver_uid WHERE experiment_id = :experiment_id AND approval_status = 0", array(
":approver_uid" => $user->uid,
":experiment_id" => $form_state['values']['lab_experiment_list']
));
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('id', $form_state['values']['lab_experiment_list']);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_value = $experiment_q->fetchObject();
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('experiment_id', $form_state['values']['lab_experiment_list']);
+ $query->orderBy('code_number', 'ASC');
+ $solution_q = $query->execute();
+ $solution_value = $solution_q->fetchObject();
drupal_set_message(t('Approved Entire Experiment.'), 'status');
/* email */
- $email_subject = t('[!site_name] Your uploaded Lab Migration solutions have been approved', array(
+ $email_subject = t('[!site_name] Your uploaded Lab Migration solution have been approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your all the uploaded solutions for the experiment have been approved.')
+ 0 => t('
+
+Dear !user_name,
+
+Your Experiment for DWSIM Lab Migration with the following details is approved.
+
+Experiment name : ' . $experiment_value->title . '
+Caption : ' . $solution_value->caption . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 2) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
+ /* email */
+ /* $email_subject = t('Your uploaded Lab Migration solutions have been approved');
+ $email_body = array(0 =>t('Your all the uploaded solutions for the experiment have been approved.'));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 2) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
db_query("UPDATE {lab_migration_solution} SET approval_status = 0 WHERE experiment_id = :experiment_id", array(
":experiment_id" => $form_state['values']['lab_experiment_list']
));
drupal_set_message(t('Entire Experiment marked as Pending Review.'), 'status');
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('id', $form_state['values']['lab_experiment_list']);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_value = $experiment_q->fetchObject();
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('experiment_id', $form_state['values']['lab_experiment_list']);
+ $query->orderBy('code_number', 'ASC');
+ $solution_q = $query->execute();
+ $solution_value = $solution_q->fetchObject();
/* email */
- $email_subject = t('[!site_name] Your uploaded Lab Migration solutions have been marked as pending', array(
+ $email_subject = t('[!site_name] Your uploaded Lab Migration solution have been marked as pending', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your all the uploaded solutions for the experiment have been marked as pending to be review.')
+ 0 => t('
+
+Dear !user_name,
+
+Your all the uploaded solutions for the experiment have been marked as pending to be reviewed.
+
+Experiment name : ' . $experiment_value->title . '
+Caption : ' . $solution_value->caption . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 3) && ($form_state['values']['lab_experiment_solution_actions'] == 0)) {
- if (!$form_state['values']['message']) {
- if (strlen(trim($form_state['values']['message'])) <= 30) {
- form_set_error('message', t(''));
- drupal_set_message("Please mention the reason for disapproval.", 'error');
- return;
- }
- }
- if (!user_access('lab migration bulk delete code')) {
+ /* email */
+ /*$email_subject = t('Your uploaded Lab Migration solutions have been marked as pending');
+ $email_body = array(0 =>t('Your all the uploaded solutions for the experiment have been marked as pending to be review.'));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 3) && ($form_state['values']['lab_experiment_solution_actions'] == 0))
+ {
+ if (strlen(trim($form_state['values']['message'])) <= 30)
+ {
+ form_set_error('message', t(''));
+ drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+ return;
+ }
+ if (!user_access('lab migration bulk delete code'))
+ {
drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Experiment.'), 'error');
return;
- }
- if (lab_migration_delete_experiment($form_state['values']['lab_experiment_list'])) {
+ }
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('id', $form_state['values']['lab_experiment_list']);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_value = $experiment_q->fetchObject();
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('experiment_id', $form_state['values']['lab_experiment_list']);
+ $query->orderBy('code_number', 'ASC');
+ $solution_q = $query->execute();
+ $solution_value = $solution_q->fetchObject();
+ if (lab_migration_delete_experiment($form_state['values']['lab_experiment_list']))
+ {
drupal_set_message(t('Dis-Approved and Deleted Entire Experiment.'), 'status');
- } else {
+ }
+ else
+ {
drupal_set_message(t('Error Dis-Approving and Deleting Entire Experiment.'), 'error');
- }
+ }
/* email */
$email_subject = t('[!site_name] Your uploaded Lab Migration solutions have been marked as dis-approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your uploaded solutions for the entire experiment have been marked as dis-approved.
+ 0 => t('
+
+Dear !user_name,
+
+We regret to inform you that your experiment with the following details under DWSIM Lab Migration is disapproved and has been deleted.
- Reason for dis-approval:
+Experiment name : ' . $experiment_value->title . '
+Caption : ' . $solution_value->caption . '
- ' . $form_state['values']['message'])
+Reason for dis-approval:' . $form_state['values']['message'] . '
+
+Please resubmit the modified solution.
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 1)) {
+ /* email */
+ /*$email_subject = t('Your uploaded Lab Migration solutions have been marked as dis-approved');
+ $email_body = array(0 => t('Your uploaded solutions for the entire experiment have been marked as dis-approved.
+
+ Reason for dis-approval:
+
+ ' . $form_state['values']['message']));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 1))
+ {
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('id', $form_state['values']['lab_solution_list']);
+ $query->orderBy('code_number', 'ASC');
+ $solution_q = $query->execute();
+ $solution_value = $solution_q->fetchObject();
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('id', $solution_value->experiment_id);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_value = $experiment_q->fetchObject();
db_query("UPDATE {lab_migration_solution} SET approval_status = 1, approver_uid = :approver_uid WHERE id = :id", array(
":approver_uid" => $user->uid,
- ":id" => $form_state['values']['solution']
+ ":id" => $form_state['values']['lab_solution_list']
));
drupal_set_message(t('Solution approved.'), 'status');
/* email */
@@ -553,9 +820,41 @@ function lab_migration_bulk_approval_form_submit($form, $form_state)
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your uploaded solution has been approved.')
+ 0 => t('
+
+Dear !user_name,
+
+Your Experiment for DWSIM Lab Migration with the following details is approved.
+
+Experiment name : ' . $experiment_value->title . '
+Caption : ' . $solution_value->caption . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 2)) {
+ /* email */
+ /* $email_subject = t('Your uploaded Lab Migration solution has been approved');
+ $email_body = array(0 =>t('Your uploaded solution has been approved.'));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 2))
+ {
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('id', $form_state['values']['lab_solution_list']);
+ $query->orderBy('code_number', 'ASC');
+ $solution_q = $query->execute();
+ $solution_value = $solution_q->fetchObject();
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('id', $solution_value->experiment_id);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_value = $experiment_q->fetchObject();
db_query("UPDATE {lab_migration_solution} SET approval_status = 0 WHERE id = :id", array(
":id" => $form_state['values']['lab_solution_list']
));
@@ -565,119 +864,160 @@ function lab_migration_bulk_approval_form_submit($form, $form_state)
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your uploaded solution has been marked as pending to be review.')
+ 0 => t('
+
+Dear !user_name,
+
+Your all the uploaded solutions for the experiment have been marked as pending to be reviewed.
+
+Experiment name : ' . $experiment_value->title . '
+Caption : ' . $solution_value->caption . '
+
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 3)) {
- if (!$form_state['values']['message']) {
- if (strlen(trim($form_state['values']['message'])) <= 30) {
- form_set_error('message', t(''));
- drupal_set_message("Please mention the reason for disapproval.", 'error');
- return;
- }
- }
- if (lab_migration_delete_solution($form_state['values']['lab_solution_list'])) {
+ /* email */
+ /*$email_subject = t('Your uploaded Lab Migration solution has been marked as pending');
+ $email_body = array(0 =>t('Your uploaded solution has been marked as pending to be review.'));*/
+ }
+ elseif (($form_state['values']['lab_actions'] == 0) && ($form_state['values']['lab_experiment_actions'] == 0) && ($form_state['values']['lab_experiment_solution_actions'] == 3))
+ {
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('id', $form_state['values']['lab_solution_list']);
+ $query->orderBy('code_number', 'ASC');
+ $solution_q = $query->execute();
+ $solution_value = $solution_q->fetchObject();
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('id', $solution_value->experiment_id);
+ $query->orderBy('number', 'ASC');
+ $experiment_q = $query->execute();
+ $experiment_value = $experiment_q->fetchObject();
+ if (strlen(trim($form_state['values']['message'])) <= 30)
+ {
+ form_set_error('message', t(''));
+ drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
+ return;
+ }
+ if (lab_migration_delete_solution($form_state['values']['lab_solution_list']))
+ {
drupal_set_message(t('Solution Dis-Approved and Deleted.'), 'status');
- } else {
+ }
+ else
+ {
drupal_set_message(t('Error Dis-Approving and Deleting Solution.'), 'error');
- }
+ }
/* email */
$email_subject = t('[!site_name] Your uploaded Lab Migration solution has been marked as dis-approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
- 0 => t('Your uploaded solution has been marked as dis-approved.
+ 0 => t('
+
+Dear !user_name,
+
+We regret to inform you that your experiment with the following details under DWSIM Lab Migration is disapproved and has been deleted.
+
+Experiment name : ' . $experiment_value->title . '
+Caption : ' . $solution_value->caption . '
+
+Reason for dis-approval:' . $form_state['values']['message'] . '
- Reason for dis-approval:
+Please resubmit the modified solution.
- ' . $form_state['values']['message'])
+Best Wishes,
+
+!site_name Team,
+FOSSEE,IIT Bombay', array(
+ '!site_name' => variable_get('site_name', ''),
+ '!user_name' => $user_data->name
+ ))
);
- } else {
- drupal_set_message("Please select any one action at a time", 'error');
+ /* email */
+ /* $email_subject = t('Your uploaded Lab Migration solution has been marked as dis-approved');
+ $email_body = array(0 =>t('Your uploaded solution has been marked as dis-approved.
+
+ Reason for dis-approval:
+
+ ' . $form_state['values']['message']));*/
+ }
+ else
+ {
+ drupal_set_message(t('Please select only one action at a time'), 'error');
return;
- }
- /****** sending email when everything done ******/
- /* if (isset($email_subject)) {
- $email_to = variable_get('lab_migration_emails', '') . ', ' . $user->mail;
- // $email_to = "contact@scilab.in" . ', ' . $user->mail;
- //$email_to = "prashantsinalkar@gmail.com";
+ }
+ /** sending email when everything done **/
+ if ($email_subject)
+ {
+ $email_to = $user_data->mail;
+ $from = variable_get('lab_migration_from_email', '');
+ $bcc = variable_get('lab_migration_emails', '');
+ $cc = variable_get('lab_migration_cc_emails', '');
$param['standard']['subject'] = $email_subject;
$param['standard']['body'] = $email_body;
- if (!drupal_mail('lab_migration', 'standard', $email_to, language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE))
+ $param['standard']['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', 'standard', $email_to, language_default(), $param, $from, TRUE))
+ {
drupal_set_message('Error sending email message.', 'error');
- }*/
-
- /**** sending email when everything done ****/
- if ($email_subject)
- {
- $email_to = $user_data->mail;
- $from = "contact-dwsim@fossee.in";
- // $email_to = "contact@scilab.in" . ', ' . $user->mail;
- //$email_to = "prashantsinalkar@gmail.com";
- // $email_bcc= variable_get('lab_migration_emails', '');
- $email_bcc = 'diptiiitb17@gmail.com' ;
- $email_cc="essarmax21@gmail.com";
- //$email_bcc=array('Bcc' => $header_bcc,'Cc' => $header_cc);
- $param['standard']['subject'] = $email_subject;
- $param['standard']['body'] = $email_body;
- $param['standard']['headers'] = $email_bcc;
-
-
- // if (!drupal_mail('lab_migration', 'standard', $email_to, language_default(), $param, variable_get('lab_migration_from_email', NULL), TRUE))
- if (!send_mail($from, $email_to,$email_cc, $email_bcc, $email_subject, $email_body))
- drupal_set_message('Error sending email message.', 'error');
- }
- } else {
+ }
+ }
+ }
+ else
+ {
drupal_set_message(t('You do not have permission to bulk manage code.'), 'error');
- }
- }
+ }
+ }
return;
-}
-
-function send_mail($from, $email_to,$email_cc, $email_bcc, $email_subject, $email_body) {
- $my_module = 'lab_migration';
- $my_mail_token = microtime();
- $message = array(
- 'id' => $my_module . '_' . $my_mail_token,
- 'to' => $email_to,
- 'subject' => $email_subject,
- 'body' => $email_body,
- 'headers' => array(
- 'From' => $from,
- 'Sender' => $from,
- 'Return-Path' => $from,
- 'Cc' => $email_cc,
- 'Bcc' => $email_bcc,
- ),
- );
- $system = drupal_mail_system($my_module, $my_mail_token);
- $message = $system->format($message);
- if ($system->mail($message)) {
- return TRUE;
- }
- else {
- return FALSE;
- }
- }
-/************************************************************/
+ }
+function lab_migration_with_morefeature($key, &$message, $params)
+ {
+ if (isset($params['subject']))
+ {
+ $message['subject'] = $params['subject'];
+ }
+ if (isset($params['body']))
+ {
+ $message['body'][] = $params['body'];
+ }
+ if (isset($params['headers']) && is_array($params['headers']))
+ {
+ $message['headers'] += $params['headers'];
+ }
+ }
+/**********************************************************/
function _bulk_list_of_labs()
-{
+ {
$lab_titles = array(
'0' => 'Please select...'
);
//$lab_titles_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE solution_display = 1 ORDER BY lab_title ASC");
$query = db_select('lab_migration_proposal');
$query->fields('lab_migration_proposal');
- $query->condition('approval_status', 2, '<>');
$query->condition('solution_display', 1);
$query->orderBy('lab_title', 'ASC');
$lab_titles_q = $query->execute();
- while ($lab_titles_data = $lab_titles_q->fetchObject()) {
+ while ($lab_titles_data = $lab_titles_q->fetchObject())
+ {
$lab_titles[$lab_titles_data->id] = $lab_titles_data->lab_title . ' (Proposed by ' . $lab_titles_data->name . ')';
- }
+ }
return $lab_titles;
-}
+ }
function _ajax_bulk_get_experiment_list($lab_default_value = '')
-{
+ {
$experiments = array(
'0' => 'Please select...'
);
@@ -687,24 +1027,25 @@ function _ajax_bulk_get_experiment_list($lab_default_value = '')
$query->condition('proposal_id', $lab_default_value);
$query->orderBy('number', 'ASC');
$experiments_q = $query->execute();
- while ($experiments_data = $experiments_q->fetchObject()) {
+ while ($experiments_data = $experiments_q->fetchObject())
+ {
$experiments[$experiments_data->id] = $experiments_data->number . '. ' . $experiments_data->title;
- }
+ }
return $experiments;
-}
+ }
function _bulk_list_lab_actions()
-{
+ {
$lab_actions = array(
- '' => 'Please Select .....'
+ 0 => 'Please select...'
);
$lab_actions[1] = 'Approve Entire Lab';
$lab_actions[2] = 'Pending Review Entire Lab';
$lab_actions[3] = 'Dis-Approve Entire Lab (This will delete all the solutions in the lab)';
$lab_actions[4] = 'Delete Entire Lab Including Proposal';
return $lab_actions;
-}
+ }
function _ajax_bulk_get_solution_list($lab_experiment_list = '')
-{
+ {
$solutions = array(
0 => 'Please select...'
);
@@ -719,28 +1060,29 @@ function _ajax_bulk_get_solution_list($lab_experiment_list = '')
// $query->orderBy("CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(code_number , '.', 2), '.', -1) AS UNSIGNED", "ASC");
// $query->orderBy("CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(code_number , '.', -1), '.', 1) AS UNSIGNED", "ASC");
$solutions_q = $query->execute();
- while ($solutions_data = $solutions_q->fetchObject()) {
+ while ($solutions_data = $solutions_q->fetchObject())
+ {
$solutions[$solutions_data->id] = $solutions_data->code_number . ' (' . $solutions_data->caption . ')';
- }
+ }
return $solutions;
-}
+ }
function _bulk_list_experiment_actions()
-{
+ {
$lab_experiment_actions = array(
- '' => 'Please Select .....'
+ 0 => 'Please select...'
);
$lab_experiment_actions[1] = 'Approve Entire Experiment';
$lab_experiment_actions[2] = 'Pending Review Entire Experiment';
$lab_experiment_actions[3] = 'Dis-Approve Entire Experiment (This will delete all the solutions in the experiment)';
return $lab_experiment_actions;
-}
+ }
function _bulk_list_solution_actions()
-{
+ {
$lab_solution_actions = array(
- '' => 'Please Select .....'
+ 0 => 'Please select...'
);
$lab_solution_actions[1] = 'Approve Entire Solution';
$lab_solution_actions[2] = 'Pending Review Entire Solution';
$lab_solution_actions[3] = 'Dis-approve Solution (This will delete the solution)';
return $lab_solution_actions;
-}
+ }
generated by cgit (git 2.34.1) at 2024-12-22 04:40:52 +0000