',
'#states' => array(
'visible' => array(
array(
':input[name="circuit_simulation_actions"]' => array(
'value' => 3
)
),
'or',
array(
':input[name="circuit_simulation_actions"]' => array(
'value' => 4
)
)
)
)
);
$form['submit'] = array(
'#type' => 'submit',
'#value' => t('Submit'),
'#states' => array(
'invisible' => array(
':input[name="lab"]' => array(
'value' => 0
)
)
)
);
return $form;
}
function ajax_bulk_circuit_simulation_abstract_details_callback($form, $form_state)
{
$commands = array();
$circuit_simulation_project_default_value = $form_state['values']['circuit_simulation_project'];
if ($circuit_simulation_project_default_value != 0)
{
$commands[] = ajax_command_html('#ajax_selected_circuit_simulation', _circuit_simulation_details($circuit_simulation_project_default_value));
$form['circuit_simulation_actions']['#options'] = _bulk_list_circuit_simulation_actions();
//$form['lab_experiment_list']['#options'] = _ajax_bulk_get_experiment_list($lab_default_value);
// $commands[] = ajax_command_data('#ajax_selected_circuit_simulation', 'form_state_value_select', $form_state['values']['lab_experiment_list']);
// $commands[] = ajax_command_replace('#ajax_selected_experiment', drupal_render($form['lab_experiment_list']));
$commands[] = ajax_command_replace('#ajax_selected_circuit_simulation_action', drupal_render($form['circuit_simulation_actions']));
} //$circuit_simulation_project_default_value != 0
else
{
$commands[] = ajax_command_html('#ajax_selected_circuit_simulation', '');
$commands[] = ajax_command_data('#ajax_selected_circuit_simulation', 'form_state_value_select', $form_state['values']['circuit_simulation_project']);
}
return array(
'#type' => 'ajax',
'#commands' => $commands
);
}
/************************************************************/
function circuit_simulation_abstract_bulk_approval_form_submit($form, &$form_state)
{
global $user;
$msg = '';
$root_path = circuit_simulation_document_path();
if ($form_state['clicked_button']['#value'] == 'Submit')
{
if ($form_state['values']['circuit_simulation_project'])
// circuit_simulation_abstract_del_lab_pdf($form_state['values']['circuit_simulation_project']);
if (user_access('esim circuit_simulation bulk manage abstract'))
{
$query = db_select('circuit_simulation_proposal');
$query->fields('circuit_simulation_proposal');
$query->condition('id', $form_state['values']['circuit_simulation_project']);
$user_query = $query->execute();
$user_info = $user_query->fetchObject();
$user_data = user_load($user_info->uid);
if ($form_state['values']['circuit_simulation_actions'] == 1)
{
// approving entire project //
$query = db_select('circuit_simulation_submitted_abstracts');
$query->fields('circuit_simulation_submitted_abstracts');
$query->condition('proposal_id', $form_state['values']['circuit_simulation_project']);
$abstracts_q = $query->execute();
$experiment_list = '';
while ($abstract_data = $abstracts_q->fetchObject())
{
db_query("UPDATE {circuit_simulation_submitted_abstracts} SET abstract_approval_status = 1, approver_uid = :approver_uid WHERE id = :id", array(
':approver_uid' => $user->uid,
':id' => $abstract_data->id
));
db_query("UPDATE {circuit_simulation_submitted_abstracts_file} SET file_approval_status = 1, approvar_uid = :approver_uid WHERE submitted_abstract_id = :submitted_abstract_id", array(
':approver_uid' => $user->uid,
':submitted_abstract_id' => $abstract_data->id
));
} //$abstract_data = $abstracts_q->fetchObject()
drupal_set_message(t('Approved Circuit Simulation project.'), 'status');
// email
$email_subject = t('[!site_name][Circuit Simulation Project] Your uploaded circuit simulation project have been approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
0 => t('
Dear !user_name,
Your uploaded abstract for the circuit simulation project has been approved:
Title of circuit simulation project : ' . $user_info->project_title . '
Best Wishes,
!site_name Team,
FOSSEE,IIT Bombay', array(
'!site_name' => variable_get('site_name', ''),
'!user_name' => $user_data->name
))
);
/** sending email when everything done **/
$email_to = $user_data->mail;
$from = variable_get('circuit_simulation_from_email', '');
$bcc = variable_get('circuit_simulation_emails', '');
$cc = variable_get('circuit_simulation_cc_emails', '');
$params['standard']['subject'] = $email_subject;
$params['standard']['body'] = $email_body;
$params['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('circuit_simulation', 'standard', $email_to, language_default(), $params, $from, TRUE))
{
$msg = drupal_set_message('Error sending email message.', 'error');
} //!drupal_mail('circuit_simulation', 'standard', $email_to, language_default(), $params, $from, TRUE)
} //$form_state['values']['circuit_simulation_actions'] == 1
elseif ($form_state['values']['circuit_simulation_actions'] == 2)
{
//pending review entire project
$query = db_select('esim_circuit_simulation_submitted_abstracts');
$query->fields('esim_circuit_simulation_submitted_abstracts');
$query->condition('proposal_id', $form_state['values']['circuit_simulation_project']);
$abstracts_q = $query->execute();
$experiment_list = '';
while ($abstract_data = $abstracts_q->fetchObject())
{
db_query("UPDATE {esim_circuit_simulation_submitted_abstracts} SET abstract_approval_status = 0, approver_uid = :approver_uid WHERE id = :id", array(
':approver_uid' => $user->uid,
':id' => $abstract_data->id
));
db_query("UPDATE {esim_circuit_simulation_submitted_abstracts_file} SET file_approval_status = 0, approvar_uid = :approver_uid WHERE submitted_abstract_id = :submitted_abstract_id", array(
':approver_uid' => $user->uid,
':submitted_abstract_id' => $abstract_data->id
));
} //$abstract_data = $abstracts_q->fetchObject()
drupal_set_message(t('Approved Circuit Simulation project.'), 'status');
// email
$email_subject = t('[!site_name][Circuit Simulation Project] Your uploaded circuit simulation project have been marked as pending', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
0 => t('
Dear !user_name,
Your all the uploaded circuit simulation project with Title : ' . $user_info->project_title . ' have been marked as pending to be reviewed.
You will be able to see the circuit simulation project after 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
))
);
/** sending email when everything done **/
$email_to = $user_data->mail;
$from = variable_get('circuit_simulation_from_email', '');
$bcc = variable_get('circuit_simulation_emails', '');
$cc = variable_get('circuit_simulation_cc_emails', '');
$params['standard']['subject'] = $email_subject;
$params['standard']['body'] = $email_body;
$params['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('circuit_simulation', 'standard', $email_to, language_default(), $params, $from, TRUE))
{
drupal_set_message('Error sending email message.', 'error');
} //!drupal_mail('circuit_simulation', 'standard', $email_to, language_default(), $params, $from, TRUE)
} //$form_state['values']['circuit_simulation_actions'] == 2
elseif ($form_state['values']['circuit_simulation_actions'] == 3) //disapprove and delete entire circuit simulation project
{
if (strlen(trim($form_state['values']['message'])) <= 30)
{
form_set_error('message', t(''));
$msg = drupal_set_message("Please mention the reason for disapproval. Minimum 30 character required", 'error');
return $msg;
} //strlen(trim($form_state['values']['message'])) <= 30
if (!user_access('esim circuit_simulation bulk delete abstract'))
{
$msg = drupal_set_message(t('You do not have permission to Bulk Dis-Approved and Deleted Entire Lab.'), 'error');
return $msg;
} //!user_access('circuit_simulation bulk delete code')
if (circuit_simulation_abstract_delete_project($form_state['values']['circuit_simulation_project'])) //////
{
drupal_set_message(t('Dis-Approved and Deleted Entire Circuit Simulation project.'), 'status');
} //circuit_simulation_abstract_delete_project($form_state['values']['circuit_simulation_project'])
else
{
drupal_set_message(t('Error Dis-Approving and Deleting Entire circuit simulation project.'), 'error');
}
// email
$email_subject = t('[!site_name][Circuit Simulation Project] Your uploaded circuit simulation project have been marked as dis-approved', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
0 => t('
Dear !user_name,
Your all the uploaded circuit simulation for the whole circuit simulation project Title : ' . $user_info->project_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
))
);
} //$form_state['values']['circuit_simulation_actions'] == 3
elseif ($form_state['values']['circuit_simulation_actions'] == 4)
{
if (strlen(trim($form_state['values']['message'])) <= 30)
{
form_set_error('message', t(''));
$msg = drupal_set_message("Please mention the reason for disapproval/deletion. Minimum 30 character required", 'error');
return $msg;
} //strlen(trim($form_state['values']['message'])) <= 30
$query = db_select('esim_circuit_simulation_abstract_experiment');
$query->fields('esim_circuit_simulation_abstract_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 .= '
' . $experiment_data->number . ') ' . $experiment_data->title . '
Description : ' . $experiment_data->description . '
';
$experiment_list .= ' ';
$experiment_list .= '
';
} //$experiment_data = $experiment_q->fetchObject()
if (!user_access('lab migration bulk delete code'))
{
$msg = drupal_set_message(t('You do not have permission to Bulk Delete Entire Lab Including Proposal.'), 'error');
return $msg;
} //!user_access('lab migration bulk delete code')
// check if dependency files are present
$dep_q = db_query("SELECT * FROM {esim_circuit_simulation_abstract_dependency_files} WHERE proposal_id = :proposal_id", array(
":proposal_id" => $form_state['values']['lab']
));
if ($dep_data = $dep_q->fetchObject())
{
$msg = 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 $msg ;
} //$dep_data = $dep_q->fetchObject()
if (circuit_simulation_abstract_delete_lab($form_state['values']['lab']))
{
drupal_set_message(t('Dis-Approved and Deleted Entire Lab solutions.'), 'status');
$query = db_select('esim_circuit_simulation_abstract_experiment');
$query->fields('esim_circuit_simulation_abstract_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)
{
$msg = drupal_set_message(t("Cannot delete Lab directory : " . $dir_path . ". Please contact administrator."), 'error');
return $msg;
} //!$res
} //is_dir($dir_path)
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 {circuit_simulation_abstract_proposal} WHERE id = %d", $form_state['values']['lab']);
$proposal_q = db_query("SELECT * FROM {esim_circuit_simulation_abstract_proposal} WHERE id = :id", array(
":id" => $form_state['values']['lab']
));
$proposal_data = $proposal_q->fetchObject();
$proposal_id = $proposal_data->id;
db_query("DELETE FROM {esim_circuit_simulation_abstract_experiment} WHERE proposal_id = :proposal_id", array(
":proposal_id" => $proposal_id
));
db_query("DELETE FROM {esim_circuit_simulation_abstract_proposal} WHERE id = :id", array(
":id" => $proposal_id
));
drupal_set_message(t('Deleted Lab Proposal.'), 'status');
//email
$email_subject = t('[!site_name] Your uploaded Lab Migration solutions including the Lab proposal have been deleted', array(
'!site_name' => variable_get('site_name', '')
));
$email_body = array(
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
))
);
// 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.')
);
} //circuit_simulation_abstract_delete_lab($form_state['values']['lab'])
else
{
$msg = drupal_set_message(t('Error Dis-Approving and Deleting Entire Lab.'), 'error');
}
} //$form_state['values']['circuit_simulation_actions'] == 4
else
{
$msg = drupal_set_message(t('You do not have permission to bulk manage code.'), 'error');
}
} //user_access('circuit_simulation project bulk manage code')
return $msg;
} //$form_state['clicked_button']['#value'] == 'Submit'
}
/**********************************************************/
function _bulk_list_of_circuit_simulation_project()
{
$project_titles = array(
'0' => 'Please select...'
);
$query = db_select('esim_circuit_simulation_proposal');
$query->fields('esim_circuit_simulation_proposal');
$query->condition('approval_status', 1);
$query->orderBy('project_title', 'ASC');
$project_titles_q = $query->execute();
while ($project_titles_data = $project_titles_q->fetchObject())
{
$project_titles[$project_titles_data->id] = $project_titles_data->project_title . ' (Proposed by ' . $project_titles_data->contributor_name . ')';
} //$project_titles_data = $project_titles_q->fetchObject()
return $project_titles;
}
function _bulk_list_circuit_simulation_actions()
{
$circuit_simulation_actions = array(
0 => 'Please select...'
);
$circuit_simulation_actions[1] = 'Approve Entire Circuit Simulation Project';
//$circuit_simulation_actions[2] = 'Pending Review Entire Circuit Simulation Project';
$circuit_simulation_actions[3] = 'Dis-Approve Entire Circuit Simulation Project (This will delete Circuit Simulation Project)';
//$circuit_simulation_actions[4] = 'Delete Entire Circuit Simulation Project Including Proposal';
return $circuit_simulation_actions;
}
function _circuit_simulation_details($circuit_simulation_proposal_id)
{
$return_html = "";
$query_pro = db_select('esim_circuit_simulation_proposal');
$query_pro->fields('esim_circuit_simulation_proposal');
$query_pro->condition('id', $circuit_simulation_proposal_id);
$abstracts_pro = $query_pro->execute()->fetchObject();
$query_pdf = db_select('esim_circuit_simulation_submitted_abstracts_file');
$query_pdf->fields('esim_circuit_simulation_submitted_abstracts_file');
$query_pdf->condition('proposal_id', $circuit_simulation_proposal_id);
$query_pdf->condition('filetype', 'A');
$abstracts_pdf = $query_pdf->execute()->fetchObject();
if ($abstracts_pdf == TRUE)
{
if ($abstracts_pdf->filename != "NULL" || $abstracts_pdf->filename != "")
{
$abstract_filename = $abstracts_pdf->filename;
} //$abstracts_pdf->filename != "NULL" || $abstracts_pdf->filename != ""
else
{
$abstract_filename = "File not uploaded";
}
} //$abstracts_pdf == TRUE
else
{
$abstract_filename = "File not uploaded";
}
$query_process = db_select('esim_circuit_simulation_submitted_abstracts_file');
$query_process->fields('esim_circuit_simulation_submitted_abstracts_file');
$query_process->condition('proposal_id', $circuit_simulation_proposal_id);
$query_process->condition('filetype', 'S');
$abstracts_query_process = $query_process->execute()->fetchObject();
$query = db_select('esim_circuit_simulation_submitted_abstracts');
$query->fields('esim_circuit_simulation_submitted_abstracts');
$query->condition('proposal_id', $circuit_simulation_proposal_id);
$abstracts_q = $query->execute()->fetchObject();
if ($abstracts_q)
{
if ($abstracts_q->is_submitted == 0)
{
//drupal_set_message(t('Abstract is not submmited yet.'), 'error', $repeat = FALSE);
//return;
} //$abstracts_q->is_submitted == 0
} //$abstracts_q
//var_dump($abstracts_query_process);die;
if ($abstracts_query_process == TRUE)
{
if ($abstracts_query_process->filename != "NULL" || $abstracts_query_process->filename != "")
{
$abstracts_query_process_filename = $abstracts_query_process->filename;
} //$abstracts_query_process->filename != "NULL" || $abstracts_query_process->filename != ""
else
{
$abstracts_query_process_filename = "File not uploaded";
}
if ($abstracts_q->unit_operations_used_in_esim == '')
{
$unit_operations_used_in_esim = "Not entered";
} //$abstracts_q->unit_operations_used_in_esim == ''
else
{
$unit_operations_used_in_esim = $abstracts_q->unit_operations_used_in_esim;
}
if ($abstracts_q->thermodynamic_packages_used == '')
{
$thermodynamic_packages_used = "Not entered";
} //$abstracts_q->thermodynamic_packages_used == ''
else
{
$thermodynamic_packages_used = $abstracts_q->thermodynamic_packages_used;
}
if ($abstracts_q->logical_blocks_used == '')
{
$logical_blocks_used = "Not entered";
} //$abstracts_q->logical_blocks_used == ''
else
{
$logical_blocks_used = $abstracts_q->logical_blocks_used;
}
} //$abstracts_query_process == TRUE
else
{
$url = l('Upload abstract', 'circuit-simulation-project/abstract-code/upload');
$unit_operations_used_in_esim = "Not entered";
$thermodynamic_packages_used = "Not entered";
$logical_blocks_used = "Not entered";
$abstracts_query_process_filename = "File not uploaded";
}
$headers = array(
"Name of compound for which process development is carried out",
"CAS No."
);
$rows = array();
$item = array(
"{$abstracts_pro->process_development_compound_name}",
"{$abstracts_pro->process_development_compound_cas_number}"
);
array_push($rows, $item);
$prodata = theme('table', array(
'header' => $headers,
'rows' => $rows
));
$download_circuit_simulation = l('Download circuit simulation project','circuit-simulation-project/full-download/project/'.$circuit_simulation_proposal_id);
$return_html .= '
Proposer Name:' . $abstracts_pro->name_title . ' ' . $abstracts_pro->contributor_name . '
';
$return_html .= '
Title of the Circuit Simulation Project:' . $abstracts_pro->project_title . '
';
$return_html .= '
eSim version:' . $abstracts_pro->version . '
';
$return_html .= '
Unit Operations used in eSim:' . $unit_operations_used_in_esim . '
';
$return_html .= '
Thermodynamic Packages Used:' . $thermodynamic_packages_used . '
';
$return_html .= '
Logical Blocks used:' . $logical_blocks_used . '
';
$return_html .= '
Name of compound for which process development is carried out:' . $prodata . '
';
$return_html .= '
List of compounds from eSim Database used in process circuit simulation:' . $abstracts_pro->esim_database_compound_name . '
';
$return_html .= '
List of user defined compounds used in process circuit simulation:' . _circuit_simulation_list_of_user_defined_compound($abstracts_pro->id) . '
';
$return_html .= '
Uploaded an abstract (brief outline) of the project:' . $abstract_filename . '
';
$return_html .= '
Upload the eSim circuit simulation for the developed process:' . $abstracts_query_process_filename . '
';
$return_html .= $download_circuit_simulation;
return $return_html;
}