'fieldset',
'#title' => t('Bulk Manage Code'),
'#collapsible' => FALSE,
'#collapsed' => FALSE,
'#prefix' => '',
'#suffix' => '
',
'#tree' => TRUE
);
$form['wrapper']['dependency'] = array(
'#type' => 'select',
'#title' => t('Dependency'),
'#options' => _list_of_dependencies(),
'#default_value' => $dependency_default_value,
'#tree' => TRUE,
'#attributes' => array(
'id' => 'dependancy'
)
);
$form["wrapper"]['dependencyfiles'] = array(
'#markup' => ''
);
$form['wrapper']['delete_dependency'] = array(
'#type' => 'checkbox',
"#description" => 'Please unlink the dependency from the above solutions before deleting it',
'#title' => t('Delete Dependency'),
'#prefix' => '',
'#attributes' => array(
'id' => 'delete-dependancy'
)
);
$form['wrapper']['submit'] = array(
'#type' => 'submit',
'#value' => t('Submit'),
'#suffix' => '
'
);
return $form;
}
function lab_migration_dependency_approval_ajax($item = "", $key = "")
{
$data = "";
$dependency_default_value = $key;
$solution_list = array();
//$solution_id_q = db_query("SELECT * FROM {lab_migration_solution_dependency} WHERE dependency_id = %d", $dependency_default_value);
$query = db_select('lab_migration_solution_dependency');
$query->fields('lab_migration_solution_dependency');
$query->condition('dependency_id', $dependency_default_value);
$solution_id_q = $query->execute();
while ($solution_id_data = $solution_id_q->fetchObject())
{
//$solution_q = db_query("SELECT * FROM {lab_migration_solution} WHERE id = %d", $solution_id_data->solution_id);
$query = db_select('lab_migration_solution');
$query->fields('lab_migration_solution');
$query->condition('id', $solution_id_data->solution_id);
$solution_q = $query->execute();
$solution_data = $solution_q->fetchObject();
//$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE id = %d", $solution_data->experiment_id);
$query = db_select('lab_migration_experiment');
$query->fields('lab_migration_experiment');
$query->condition('id', $solution_data->experiment_id);
$experiment_q = $query->execute();
$experiment_data = $experiment_q->fetchObject();
//$lab_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $experiment_data->proposal_id);
$query = db_select('lab_migration_proposal');
$query->fields('lab_migration_proposal');
$query->condition('id', $experiment_data->proposal_id);
$lab_q = $query->execute();
$lab_data = $lab_q->fetchObject();
$solution_list[] = array(
$solution_data->code_number,
$experiment_data->number . ' . ' . $experiment_data->title,
$lab_data->lab_title
);
}
$solution_list_header = array(
'Code',
'Experiment',
'Lab'
);
//$solution = theme_table($solution_list_header, $solution_list);
$solution = theme('table', array(
'header' => $solution_list_header,
'rows' => $solution_list
));
$data .= $solution;
echo $data;
}
function lab_migration_dependency_approval_form_submit($form, &$form_state)
{
global $user;
$root_path = lab_migration_path();
if ($form_state['clicked_button']['#value'] == 'Submit')
{
if (user_access('bulk manage code'))
{
if ($form_state['values']['delete_dependency'] == "1")
{
//$solution_q = db_query("SELECT * FROM {lab_migration_solution_dependency} WHERE dependency_id = %d", $form_state['values']['wrapper']['dependency']);
$query = db_select('lab_migration_solution_dependency');
$query->fields('lab_migration_solution_dependency');
$query->condition('dependency_id', $form_state['values']['dependency']);
$solution_q = $query->execute();
if ($solution_data = $solution_q->fetchObject())
{
drupal_set_message('Cannot delete dependency since it is linked with some solutions', 'error');
}
else
{
if (lab_migration_delete_dependency($form_state['values']['dependency']))
{
drupal_set_message('Dependency deleted', 'status');
/* email */
$email_subject = t('Dependency deleted');
$email_body = t('Dependency deleted : .') . $form_state['values']['dependency'];
$email_to = variable_get('lab_migration_emails', '') . ', ' . $user->mail;
$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))
drupal_set_message('Error sending email message.', 'error');
}
}
}
}
}
}
function _list_of_dependencies()
{
$dependencies = array(
'0' => 'Please select...'
);
//$dependency_q = db_query("SELECT * FROM {lab_migration_dependency_files} ORDER BY filename ASC");
$query = db_select('lab_migration_dependency_files');
$query->fields('lab_migration_dependency_files');
$query->orderBy('filename', 'ASC');
$dependency_q = $query->execute();
while ($dependency_data = $dependency_q->fetchObject())
{
$dependencies[$dependency_data->id] = $dependency_data->filename . ' (' . $dependency_data->filepath . ')';
}
return $dependencies;
}