uid);
$proposal_data = db_fetch_object($proposal_q);
if (!$proposal_data)
{
drupal_set_message("Please submit a " . l('proposal', 'proposal') . ".", 'error');
drupal_goto('');
}
if ($proposal_data->proposal_status != 1)
{
switch ($proposal_data->proposal_status )
{
case 0:
drupal_set_message(t('We have already received your proposal. We will get back to you soon.'), 'status');
drupal_goto('');
return;
break;
case 2:
drupal_set_message(t('Your proposal has been dis-approved. Please create another proposal ' . l('here', 'proposal') . '.'), 'error');
drupal_goto('');
return;
break;
case 3:
drupal_set_message(t('Congratulations! You have completed your last book proposal. You have to create another proposal ' . l('here', 'proposal') . '.'), 'status');
drupal_goto('');
return;
break;
default:
drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
drupal_goto('');
return;
break;
}
}
$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
$preference_data = db_fetch_object($preference_q);
if (!$preference_data)
{
drupal_set_message(t('Invalid Book Preference status. Please contact site administrator for further information.'), 'error');
drupal_goto('');
return;
}
/************************ end approve book details **************************/
/* add javascript for automatic book title, check if example uploaded, dependency selection effects */
$chapter_name_js = " $(document).ready(function() {
$('#edit-number').change(function() {
$.get('" . base_path() . "textbook_companion/ajax/chapter_title/' + $('#edit-number').val() + '/' + " . $preference_data->id . ", function(data) {
data = data.toString().replace('\t', '');
$('#edit-name').val(data);
});
});
$('#edit-example-number').change(function() {
$.get('" . base_path() . "textbook_companion/ajax/example_exists/' + $('#edit-number').val() + '/' + " . $preference_data->id . " + '/' + $('#edit-example-number').val(), function(data) {
if (!data) {
alert(data);
}
});
});
$('#edit-existing-depfile-dep-book-title').change(function() {
var dep_selected = '';
/* showing and hiding relevant files */
$('.form-checkboxes .option').hide();
$('.form-checkboxes .option').each(function(index) {
var activeClass = $('#edit-existing-depfile-dep-book-title').val();
if ($(this).children().hasClass(activeClass)) {
$(this).show();
}
if ($(this).children().attr('checked') == true) {
dep_selected += $(this).children().next().text() + '
';
}
});
/* showing list of already existing dependencies */
$('#existing_depfile_selected').html(dep_selected);
});
$('.form-checkboxes .option').change(function() {
$('#edit-existing-depfile-dep-book-title').trigger('change');
});
$('#edit-existing-depfile-dep-book-title').trigger('change');
});";
drupal_add_js($chapter_name_js, 'inline', 'header');
$form['#attributes'] = array('enctype' => "multipart/form-data");
$form['book_details']['book'] = array(
'#type' => 'item',
'#value' => $preference_data->book,
'#title' => t('Title of the Book'),
);
$form['contributor_name'] = array(
'#type' => 'item',
'#value' => $proposal_data->full_name,
'#title' => t('Contributor Name'),
);
$form['number'] = array(
'#type' => 'select',
'#title' => t('Chapter No'),
'#options' => array('' => '(Select)', '1' => '1', '2', '3', '4', '5', '6', '7', '8', '9', '10',
'11', '12', '13', '14', '15', '16', '17', '18', '19', '20',
'21', '22', '23', '24', '25', '26', '27', '28', '29', '30',
'31', '32', '33', '34', '35', '36', '37', '38', '39', '40',
'41', '42', '43', '44', '45', '46', '47', '48', '49', '50'),
'#multiple' => FALSE,
'#size' => 1,
'#required' => TRUE,
);
$form['name'] = array(
'#type' => 'textfield',
'#title' => t('Title of the Chapter'),
'#size' => 40,
'#maxlength' => 255,
'#required' => TRUE,
);
$form['example_type'] = array(
'#type' => 'select',
'#title' => t('Solver Type'),
'#options' => _list_of_solvers(),
'#multiple' => FALSE,
'#size' => 1,
'#required' => TRUE,
);
$form['example_number'] = array(
'#type' => 'textfield',
'#title' => t('Example No'),
'#size' => 5,
'#maxlength' => 10,
'#description' => t("Example number should be separated by dots only.
Example: 1.1.a or 1.1.1"),
'#required' => TRUE,
);
$form['example_caption'] = array(
'#type' => 'textfield',
'#title' => t('Caption'),
'#size' => 40,
'#maxlength' => 255,
'#description' => t('Example caption should contain only alphabets, numbers and spaces.'),
'#required' => TRUE,
);
$form['example_warning'] = array(
'#type' => 'item',
'#title' => t('You should upload all the files as zip (main or source files, result files, executable file if any)'),
'#prefix' => '
',
'#suffix' => '
',
);
$form['sourcefile'] = array(
'#type' => 'fieldset',
'#title' => t('Main or Source Files'),
'#collapsible' => FALSE,
'#collapsed' => FALSE,
);
$form['sourcefile']['sourcefile1'] = array(
'#type' => 'file',
'#title' => t('Upload main or source file'),
'#size' => 48,
'#description' => t('Separate filenames with underscore. No spaces or any special characters allowed in filename.') . '
' .
t('Allowed file extensions : ') . variable_get('textbook_companion_source_extensions', '').'',
);
$form['submit'] = array(
'#type' => 'submit',
'#value' => t('Submit')
);
$form['cancel'] = array(
'#type' => 'markup',
'#value' => l(t('Cancel'), 'textbook_companion/code'),
);
return $form;
}
function upload_examples_form_validate($form, &$form_state)
{
if (!check_name($form_state['values']['name']))
form_set_error('name', t('Title of the Chapter can contain only alphabets, numbers and spaces.'));
if (!check_name($form_state['values']['example_caption']))
form_set_error('example_caption', t('Example Caption can contain only alphabets, numbers and spaces.'));
if (!check_chapter_number($form_state['values']['example_number']))
form_set_error('example_number', t('Invalid Example Number. Example Number can contain only alphabets and numbers sepereated by dot.'));
if (isset($_FILES['files']))
{
/* check if atleast one source or result file is uploaded */
if ( ! ($_FILES['files']['name']['sourcefile1']))
form_set_error('sourcefile1', t('Please upload source file.'));
/* check for valid filename extensions */
foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
{
if ($file_name)
{
$allowed_extensions_str = variable_get('textbook_companion_source_extensions', '');
$allowed_extensions = explode(',' , $allowed_extensions_str);
$temp_extension = end(explode('.', strtolower($_FILES['files']['name'][$file_form_name])));
//$temp_extension = substr($_FILES['files']['name'][$file_form_name], strripos($_FILES['files']['name'][$file_form_name], '.')); // get file name
//var_dump($temp_extension); die;
if (!in_array($temp_extension, $allowed_extensions))
form_set_error($file_form_name, t('Only file with ' . $allowed_extensions_str . ' extensions can be uploaded.'));
if ($_FILES['files']['size'][$file_form_name] <= 0)
form_set_error($file_form_name, t('File size cannot be zero.'));
/* check if valid file name
if (!textbook_companion_check_valid_filename($_FILES['files']['name'][$file_form_name]))
form_set_error($file_form_name, t('Invalid file name specified. Only alphabets, numbers and underscore is allowed as a valid filename.'));*/
}
}
}
/* add javascript again for automatic book title, check if example uploaded, dependency selection effects */
$chapter_name_js = " $(document).ready(function() {
$('#edit-number').change(function() {
$.get('" . base_path() . "textbook_companion/ajax/chapter_title/' + $('#edit-number').val() + '/' + " . $row->pre_id . ", function(data) {
$('#edit-name').val(data);
});
});
$('#edit-example-number').change(function() {
$.get('" . base_path() . "textbook_companion/ajax/example_exists/' + $('#edit-number').val() + '/' + $('#edit-example-number').val(), function(data) {
if (data) {
alert(data);
}
});
});
$('#edit-existing-depfile-dep-book-title').change(function() {
var dep_selected = '';
/* showing and hiding relevant files */
$('.form-checkboxes .option').hide();
$('.form-checkboxes .option').each(function(index) {
var activeClass = $('#edit-existing-depfile-dep-book-title').val();
if ($(this).children().hasClass(activeClass)) {
$(this).show();
}
if ($(this).children().attr('checked') == true) {
dep_selected += $(this).children().next().text() + '
';
}
});
/* showing list of already existing dependencies */
$('#existing_depfile_selected').html(dep_selected);
});
$('.form-checkboxes .option').change(function() {
$('#edit-existing-depfile-dep-book-title').trigger('change');
});
$('#edit-existing-depfile-dep-book-title').trigger('change');
});";
drupal_add_js($chapter_name_js, 'inline', 'header');
}
function upload_examples_form_submit($form, &$form_state) {
global $user;
$root_path = textbook_companion_path();
/************************ start approve book details ************************/
$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid = %d ORDER BY id DESC LIMIT 1", $user->uid);
$proposal_data = db_fetch_object($proposal_q);
if (!$proposal_data)
{
drupal_set_message("Please submit a " . l('proposal', 'proposal') . ".", 'error');
drupal_goto('');
}
if ($proposal_data->proposal_status != 1)
{
switch ($proposal_data->proposal_status )
{
case 0:
drupal_set_message(t('We have already received your proposal. We will get back to you soon.'), 'status');
drupal_goto('');
return;
break;
case 2:
drupal_set_message(t('Your proposal has been dis-approved. Please create another proposal ' . l('here', 'proposal') . '.'), 'error');
drupal_goto('');
return;
break;
case 3:
drupal_set_message(t('Congratulations! You have completed your last book proposal. You have to create another proposal ' . l('here', 'textbook_companion/proposal') . '.'), 'status');
drupal_goto('');
return;
break;
default:
drupal_set_message(t('Invalid proposal state. Please contact site administrator for further information.'), 'error');
drupal_goto('');
return;
break;
}
}
$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE proposal_id = %d AND approval_status = 1 LIMIT 1", $proposal_data->id);
$preference_data = db_fetch_object($preference_q);
if (!$preference_data)
{
drupal_set_message(t('Invalid Book Preference status. Please contact site administrator for further information.'), 'error');
drupal_goto('');
return;
}
/************************ end approve book details **************************/
$preference_id = $preference_data->id;
$dest_path = $preference_id . '/';
if (!is_dir($root_path . $dest_path))
mkdir($root_path . $dest_path);
/* inserting chapter details */
$chapter_id = 0;
$chapter_result = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d AND number = %d", $preference_id, $form_state['values']['number']);
if (!$chapter_row = db_fetch_object($chapter_result))
{
db_query("INSERT INTO {textbook_companion_chapter} (preference_id, number, name) VALUES (%d, '%s', '%s')",
$preference_id,
$form_state['values']['number'],
$form_state['values']['name']
);
$chapter_id = db_last_insert_id('textbook_companion_chapter', 'id');
} else {
$chapter_id = $chapter_row->id;
db_query("UPDATE {textbook_companion_chapter} SET name = '%s' WHERE id = %d", $form_state['values']['name'], $chapter_id);
}
/* get example details - dont allow if already example present */
$cur_example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d AND number = '%s'", $chapter_id, $form_state['values']['example_number']);
if ($cur_example_d = db_fetch_object($cur_example_q))
{
if ($cur_example_d->approval_status == 1)
{
drupal_set_message(t("Example already approved. Cannot overwrite it."), 'error');
drupal_goto('textbook_companion/code');
return;
} else if ($cur_example_d->approval_status == 0) {
drupal_set_message(t("Example is under pending review. Delete the example and reupload it."), 'error');
drupal_goto('textbook_companion/code');
return;
} else {
drupal_set_message(t("Error uploading example. Please contact administrator."), 'error');
drupal_goto('textbook_companion/code');
return;
}
}
/* creating directories */
$dest_path .= 'CH' . $form_state['values']['number'] . '/';
if (!is_dir($root_path . $dest_path))
mkdir($root_path . $dest_path);
$dest_path .= 'EX' . $form_state['values']['example_number'] . '/';
if (!is_dir($root_path . $dest_path))
mkdir($root_path . $dest_path);
/* creating example database entry */
db_query("INSERT INTO {textbook_companion_example} (chapter_id, number, caption, approval_status, timestamp, example_type) VALUES (%d, '%s', '%s', %d, %d, %d)",
$chapter_id,
$form_state['values']['example_number'],
$form_state['values']['example_caption'],
0,
time(),
$form_state['values']['example_type']
);
$example_id = db_last_insert_id('textbook_companion_example', 'id');
/* uploading files */
foreach ($_FILES['files']['name'] as $file_form_name => $file_name)
{
if ($file_name)
{
/* checking file type */
$file_type = 'S';
if (file_exists($root_path . $dest_path . $_FILES['files']['name'][$file_form_name]))
{
drupal_set_message(t("Error uploading file. File !filename already exists.", array('!filename' => $_FILES['files']['name'][$file_form_name])), 'error');
return;
}
/* uploading file */
if (move_uploaded_file($_FILES['files']['tmp_name'][$file_form_name], $root_path . $dest_path . $_FILES['files']['name'][$file_form_name]))
{
/* for uploaded files making an entry in the database */
db_query("INSERT INTO {textbook_companion_example_files} (example_id, filename, filepath, filemime, filesize, filetype, timestamp)
VALUES (%d, '%s', '%s', '%s', %d, '%s', %d)",
$example_id,
$_FILES['files']['name'][$file_form_name],
$dest_path . $_FILES['files']['name'][$file_form_name],
$_FILES['files']['type'][$file_form_name],
$_FILES['files']['size'][$file_form_name],
$file_type,
time()
);
drupal_set_message($file_name . ' uploaded successfully.', 'status');
} else {
drupal_set_message('Error uploading file : ' . $dest_path . '/' . $file_name, 'error');
}
}
}
drupal_set_message('Example uploaded successfully.', 'status');
/* sending email */
$email_to = $user->mail;
$param['example_uploaded']['example_id'] = $example_id;
$param['example_uploaded']['user_id'] = $user->uid;
if (!drupal_mail('textbook_companion', 'example_uploaded', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
drupal_set_message('Error sending email message.', 'error');
drupal_goto('textbook_companion/code');
}
/******************************************************************************/
/***************************** DELETE EXAMPLE *********************************/
/******************************************************************************/
function _upload_examples_delete()
{
global $user;
$root_path = textbook_companion_path();
$example_id = arg(3);
/* check example */
$example_q = db_query("SELECT * FROM {textbook_companion_example} WHERE id = %d LIMIT 1", $example_id);
$example_data = db_fetch_object($example_q);
if (!$example_data)
{
drupal_set_message('Invalid example.', 'error');
drupal_goto('textbook_companion/code');
return;
}
if ($example_data->approval_status != 0)
{
drupal_set_message('You cannnot delete an example after it has been approved. Please contact site administrator if you want to delete this example.', 'error');
drupal_goto('textbook_companion/code');
return;
}
$chapter_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE id = %d LIMIT 1", $example_data->chapter_id);
$chapter_data = db_fetch_object($chapter_q);
if (!$chapter_data)
{
drupal_set_message('You do not have permission to delete this example.', 'error');
drupal_goto('textbook_companion/code');
return;
}
$preference_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE id = %d LIMIT 1", $chapter_data->preference_id);
$preference_data = db_fetch_object($preference_q);
if (!$preference_data)
{
drupal_set_message('You do not have permission to delete this example.', 'error');
drupal_goto('textbook_companion/code');
return;
}
$proposal_q = db_query("SELECT * FROM {textbook_companion_proposal} WHERE id = %d AND uid = %d LIMIT 1", $preference_data->proposal_id, $user->uid);
$proposal_data = db_fetch_object($proposal_q);
if (!$proposal_data)
{
drupal_set_message('You do not have permission to delete this example.', 'error');
drupal_goto('textbook_companion/code');
return;
}
/* deleting example files */
if (delete_example($example_data->id))
{
drupal_set_message('Example deleted.', 'status');
/* sending email */
$email_to = $user->mail;
$param['example_deleted_user']['book_title'] = $preference_data->book;
$param['example_deleted_user']['chapter_title'] = $chapter_data->name;
$param['example_deleted_user']['example_number'] = $example_data->number;
$param['example_deleted_user']['example_caption'] = $example_data->caption;
$param['example_deleted_user']['user_id'] = $user->uid;
if (!drupal_mail('textbook_companion', 'example_deleted_user', $email_to, language_default(), $param, variable_get('textbook_companion_from_email', NULL), TRUE))
drupal_set_message('Error sending email message.', 'error');
} else {
drupal_set_message('Error deleting example.', 'status');
}
drupal_goto('textbook_companion/code');
return;
}
/******************************************************************************/
/************************** GENERAL FUNCTIONS *********************************/
/******************************************************************************/
function _list_of_book_titles()
{
$book_titles = array('0' => 'Please select...');
$book_titles_q = db_query("SELECT * FROM {textbook_companion_preference} WHERE approval_status = 1 OR approval_status = 3 ORDER BY book ASC");
while ($book_titles_data = db_fetch_object($book_titles_q))
{
$book_titles[$book_titles_data->id] = $book_titles_data->book . ' (Written by ' . $book_titles_data->author . ')';
}
return $book_titles;
}
function _list_of_book_dependency_files()
{
$book_dependency_files = array();
$book_dependency_files_class = array();
$book_dependency_files_q = db_query("SELECT * FROM {textbook_companion_dependency_files} ORDER BY filename ASC");
while ($book_dependency_files_data = db_fetch_object($book_dependency_files_q))
{
$temp_caption = '';
if ($book_dependency_files_data->caption)
$temp_caption .= ' (' . $book_dependency_files_data->caption . ')';
$book_dependency_files[$book_dependency_files_data->id] = l($book_dependency_files_data->filename . $temp_caption, 'download/dependency/' . $book_dependency_files_data->id);
$book_dependency_files_class[$book_dependency_files_data->id] = $book_dependency_files_data->preference_id;
}
return array($book_dependency_files, $book_dependency_files_class);
}
function _list_of_solvers() {
return array(
"laplacianFoam" => "laplacianFoam",
"potentialFoam" => "potentialFoam",
"scalarTransportFoam" => "scalarTransportFoam",
"adjointShapeOptimizationFoam" => "adjointShapeOptimizationFoam",
"boundaryFoam" => "boundaryFoam",
"channelFoam" => "channelFoam",
"icoFoam" => "icoFoam",
"MRFSimpleFoam" => "MRFSimpleFoam",
"nonNewtonianIcoFoam" => "nonNewtonianIcoFoam",
"pimpleDyMFoam" => "pimpleDyMFoam",
"pimpleFoam" => "pimpleFoam",
"pisoFoam" => "pisoFoam",
"porousSimpleFoam" => "porousSimpleFoam",
"shallowWaterFoam" => "shallowWaterFoam",
"simpleFoam" => "simpleFoam",
"SRFSimpleFoam" => "SRFSimpleFoam",
"windSimpleFoam" => "windSimpleFoam",
"rhoCentralFoam" => "rhoCentralFoam",
"rhoCentralDyMFoam" => "rhoCentralDyMFoam",
"rhoPimpleFoam" => "rhoPimpleFoam",
"rhoPorousMRFLTSPimpleFoam" => "rhoPorousMRFLTSPimpleFoam",
"rhoPorousMRFSimpleFoam" => "rhoPorousMRFSimpleFoam",
"rhoPorousMRFPimpleFoam" => "rhoPorousMRFPimpleFoam",
"rhoSimplecFoam" => "rhoSimplecFoam",
"rhoSimpleFoam" => "rhoSimpleFoam",
"sonicDyMFoam" => "sonicDyMFoam",
"sonicFoam" => "sonicFoam",
"sonicLiquidFoam" => "sonicLiquidFoam",
"bubbleFoam" => "bubbleFoam",
"cavitatingFoam" => "cavitatingFoam",
"compressibleInterFoam" => "compressibleInterFoam",
"interFoam" => "interFoam",
"interDyMFoam" => "interDyMFoam",
"interMixingFoam" => "interMixingFoam",
"interPhaseChangeFoam" => "interPhaseChangeFoam",
"LTSInterFoam" => "LTSInterFoam",
"MRFInterFoam" => "MRFInterFoam",
"MRFMultiphaseInterFoam" => "MRFMultiphaseInterFoam",
"multiphaseInterFoam" => "multiphaseInterFoam",
"porousInterFoam" => "porousInterFoam",
"settlingFoam" => "settlingFoam",
"twoLiquidMixingFoam" => "twoLiquidMixingFoam",
"twoPhaseEulerFoam" => "twoPhaseEulerFoam",
"dnsFoam" => "dnsFoam",
"chemFoam" => "chemFoam",
"coldEngineFoam" => "coldEngineFoam",
"dieselEngineFoam" => "dieselEngineFoam",
"dieselFoam" => "dieselFoam",
"engineFoam" => "engineFoam",
"fireFoam" => "fireFoam",
"PDRFoam" => "PDRFoam",
"reactingFoam" => "reactingFoam",
"rhoReactingFoam" => "rhoReactingFoam",
"XiFoam" => "XiFoam",
"coalChemistryFoam" => "coalChemistryFoam",
"icoUncoupledKinematicParcelDyMFoam" => "icoUncoupledKinematicParcelDyMFoam",
"icoUncoupledKinematicParcelFoam" => "icoUncoupledKinematicParcelFoam",
"LTSReactingParcelFoam" => "LTSReactingParcelFoam",
"porousExplicitSourceReactingParcelFoam" => "porousExplicitSourceReactingParcelFoam",
"reactingParcelFilmFoam" => "reactingParcelFilmFoam",
"reactingParcelFoam" => "reactingParcelFoam",
"uncoupledKinematicParcelFoam" => "uncoupledKinematicParcelFoam",
"buoyantBaffleSimpleFoam" => "buoyantBaffleSimpleFoam",
"buoyantBoussinesqPimpleFoam" => "buoyantBoussinesqPimpleFoam",
"buoyantBoussinesqSimpleFoam" => "buoyantBoussinesqSimpleFoam",
"buoyantPimpleFoam" => "buoyantPimpleFoam",
"buoyantSimpleFoam" => "buoyantSimpleFoam",
"buoyantSimpleRadiationFoam" => "buoyantSimpleRadiationFoam",
"chtMultiRegionFoam" => "chtMultiRegionFoam",
"heatConductionFoam"=> "heatConductionFoam",
"buoyantFoammdEquilibrationFoam" => "buoyantFoammdEquilibrationFoam",
"mdFoam" => "mdFoam",
"dsmcFoam" => "dsmcFoam",
"electrostaticFoam" => "electrostaticFoam",
"magneticFoam" => "magneticFoam",
"mhdFoam" => "mhdFoam",
"solidDisplacementFoam" => "solidDisplacementFoam",
"solidEquilibriumDisplacementFoam" => "solidEquilibriumDisplacementFoam",
"financialFoam" => "financialFoam",
);
}