summaryrefslogtreecommitdiff
path: root/latex.inc
diff options
context:
space:
mode:
Diffstat (limited to 'latex.inc')
-rwxr-xr-xlatex.inc261
1 files changed, 261 insertions, 0 deletions
diff --git a/latex.inc b/latex.inc
new file mode 100755
index 0000000..c6778a6
--- /dev/null
+++ b/latex.inc
@@ -0,0 +1,261 @@
+<?php
+
+function lab_migration_download_lab_pdf()
+{
+ $lab_id = arg(2);
+ _latex_copy_script_file();
+ $full_lab = arg(3);
+ if ($full_lab == "1"){
+ _latex_generate_files($lab_id, TRUE);
+ }else{
+ _latex_generate_files($lab_id, FALSE);
+}
+}
+
+
+/* full lab parameter is for gennerating the entire lab pdf including all unapproved solutions */
+function _latex_generate_files($lab_id, $full_lab = FALSE)
+{
+
+ $root_path = lab_migration_path();
+ $dir_path = $root_path . "latex/";
+
+ $lab_filedata = "";
+ $solution_provider_filedata = "";
+ $latex_filedata = "";
+ $latex_dep_filedata = "";
+
+ $depedency_list = array();
+
+ $eol = "\n";
+ $sep = "#";
+
+ //$proposal_q = db_query("SELECT * FROM {lab_migration_proposal} WHERE id = %d", $lab_id);
+ $query = db_select('lab_migration_proposal');
+ $query->fields('lab_migration_proposal');
+ $query->condition('id', $lab_id);
+ $proposal_q = $query->execute();
+ $proposal_data = $proposal_q->fetchObject();
+ if (!$proposal_data)
+ {
+ drupal_set_message('Invalid lab specified.', 'error');
+ drupal_goto('');
+ }
+ if ($proposal_data->approval_status == 0)
+ {
+ drupal_set_message('Lab proposal is still in pending review.', 'error');
+ drupal_goto('');
+ }
+
+ $category_data = '';
+ switch ($proposal_data->category)
+ {
+ case 0: $category_data = 'Not Selected'; break;
+ case 1: $category_data = 'Fluid Mechanics'; break;
+ case 2: $category_data = 'Control Theory & Control Systems'; break;
+ case 3: $category_data = 'Chemical Engineering'; break;
+ case 4: $category_data = 'Thermodynamics'; break;
+ case 5: $category_data = 'Mechanical Engineering'; break;
+ case 6: $category_data = 'Signal Processing'; break;
+ case 7: $category_data = 'Digital Communications'; break;
+ case 8: $category_data = 'Electrical Technology'; break;
+ case 9: $category_data = 'Mathematics & Pure Science'; break;
+ case 10: $category_data = 'Analog Electronics'; break;
+ case 11: $category_data = 'Digital Electronics'; break;
+ case 12: $category_data = 'Computer Programming'; break;
+ case 13: $category_data = 'Others'; break;
+ default: $category_data = 'Unknown'; break;
+ }
+
+ $lab_filedata = $proposal_data->lab_title . $sep . $proposal_data->name_title . $sep . $proposal_data->name . $sep . $proposal_data->department . $sep . $proposal_data->university . $sep . $category_data . $eol;
+
+ /* regenerate lab if full lab selected */
+ if ($full_lab){
+ lab_migration_del_lab_pdf($proposal_data->id);
+}
+ /* check if lab already generated */
+ if (file_exists($dir_path . "lab_" . $proposal_data->id . ".pdf"))
+ {
+ /* download zip file */
+ header('Content-Type: application/pdf');
+ header('Content-disposition: attachment; filename="' . $proposal_data->lab_title . '.pdf"');
+ header('Content-Length: ' . filesize($dir_path . "lab_" . $proposal_data->id . ".pdf"));
+ readfile($dir_path . "lab_" . $proposal_data->id . ".pdf");
+ return;
+ }
+
+ $solution_provider_user = user_load($proposal_data->solution_provider_uid);
+ if (!$solution_provider_user)
+ {
+ drupal_set_message('Could not fetch solution provider information for the lab specified.', 'error');
+ }
+ $solution_provider_filedata .= $proposal_data->solution_provider_name_title . $sep . $proposal_data->solution_provider_name . $sep . $proposal_data->solution_provider_department . $sep . $proposal_data->solution_provider_university . $eol;
+
+ //$experiment_q = db_query("SELECT * FROM {lab_migration_experiment} WHERE proposal_id = %d ORDER BY number DESC", $proposal_data->id);
+ $query = db_select('lab_migration_experiment');
+ $query->fields('lab_migration_experiment');
+ $query->condition('proposal_id', $proposal_data->id);
+ $query->orderBy('number', 'DESC');
+ $experiment_q = $query->execute();
+ while ($experiment_data = $experiment_q->fetchObject())
+ {
+ if ($full_lab){
+ //$solution_q = db_query("SELECT * FROM {lab_migration_solution} WHERE experiment_id = %d ORDER BY code_number DESC", $experiment_data->id);
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('experiment_id', $experiment_data->id);
+ $query->orderBy('code_number', 'DESC');
+ $solution_q = $query->execute();
+ }else{
+ //$solution_q = db_query("SELECT * FROM {lab_migration_solution} WHERE experiment_id = %d AND approval_status = 1 ORDER BY code_number DESC", $experiment_data->id);
+ $query = db_select('lab_migration_solution');
+ $query->fields('lab_migration_solution');
+ $query->condition('experiment_id', $experiment_data->id);
+ $query->condition('approval_status', 1);
+ $query->orderBy('code_number', 'DESC');
+ $solution_q = $query->execute();
+}
+ while ($solution_data = $solution_q->fetchObject())
+ {
+ //$solution_files_q = db_query("SELECT * FROM {lab_migration_solution_files} WHERE solution_id = %d", $solution_data->id);
+ $query = db_select('lab_migration_solution_files');
+ $query->fields('lab_migration_solution_files');
+ $query->condition('solution_id', $solution_data->id);
+ $solution_files_q = $query->execute();
+ while ($solution_files_data = $solution_files_q->fetchObject())
+ {
+ $latex_filedata .= $experiment_data->number . $sep;
+ $latex_filedata .= $experiment_data->title . $sep;
+ $latex_filedata .= $solution_data->code_number . $sep;
+ $latex_filedata .= $solution_data->caption . $sep;
+ $latex_filedata .= $solution_files_data->filename . $sep;
+ $latex_filedata .= $solution_files_data->filepath . $sep;
+ $latex_filedata .= $solution_files_data->filetype . $sep;
+ $latex_filedata .= $sep;
+ $latex_filedata .= $solution_files_data->id;
+ $latex_filedata .= $eol;
+ }
+ //$dependency_files_q = db_query("SELECT * FROM {lab_migration_solution_dependency} WHERE solution_id = %d", $solution_data->id);
+ $query = db_select('lab_migration_solution_dependency');
+ $query->fields('lab_migration_solution_dependency');
+ $query->condition('solution_id', $solution_data->id);
+ $dependency_files_q = $query->execute();
+ while ($dependency_files_data = $dependency_files_q->fetchObject())
+ {
+ //$dependency_q = db_query("SELECT * FROM {lab_migration_dependency_files} WHERE id = %d LIMIT 1", $dependency_files_data->dependency_id);
+ $query = db_select('lab_migration_dependency_files');
+ $query->fields('lab_migration_dependency_files');
+ $query->condition('id', $dependency_files_data->dependency_id);
+ $query->range(0, 1);
+ $dependency_q = $query->execute();
+ if ($dependency_data = $dependency_q->fetchObject())
+ {
+ if(substr($dependency_data->filename, -3) != "wav") {
+ $latex_filedata .= $experiment_data->number . $sep;
+ $latex_filedata .= $experiment_data->title . $sep;
+ $latex_filedata .= $solution_data->code_number . $sep;
+ $latex_filedata .= $solution_data->caption . $sep;
+ $latex_filedata .= $dependency_data->filename . $sep;
+ $latex_filedata .= $dependency_data->filepath . $sep;
+ $latex_filedata .= 'D' . $sep;
+ $latex_filedata .= $dependency_data->caption . $sep;
+ $latex_filedata .= $dependency_data->id;
+ $latex_filedata .= $eol;
+
+ $depedency_list[$dependency_data->id] = "D";
+ }
+
+ }
+ }
+ }
+ }
+
+ foreach ($depedency_list as $row => $data) {
+ //$dependency_q = db_query("SELECT * FROM {lab_migration_dependency_files} WHERE id = %d LIMIT 1", $row);
+ $query = db_select('lab_migration_dependency_files');
+ $query->fields('lab_migration_dependency_files');
+ $query->condition('id', $row);
+ $query->range(0, 1);
+ $dependency_q = $query->execute();
+ if ($dependency_data = $dependency_q->fetchObject())
+ {
+ $latex_dep_filedata .= $dependency_data->filename . $sep;
+ $latex_dep_filedata .= $dependency_data->filepath . $sep;
+ $latex_dep_filedata .= $dependency_data->caption . $sep;
+ $latex_dep_filedata .= $dependency_data->id;
+ $latex_dep_filedata .= $eol;
+ }
+ }
+
+ /**************************** WRITE TO FILES ********************************/
+ $download_filename = $proposal_data->lab;
+ $lab_filename = "tmp_" . $proposal_data->id . "_lab.txt";
+ $solution_provider_filename = "tmp_" . $proposal_data->id . "_solution_provider.txt";
+ $latex_filename = "tmp_" . $proposal_data->id . "_data.txt";
+ $latex_dep_filename = "tmp_" . $proposal_data->id . "_dep_data.txt";
+ $pdf_filename = "lab_" . $proposal_data->id . ".pdf";
+
+ $fb = fopen($dir_path . $lab_filename, 'w');
+ fwrite($fb, $lab_filedata);
+ fclose($fb);
+
+ $fc = fopen($dir_path . $solution_provider_filename, 'w');
+ fwrite($fc, $solution_provider_filedata);
+ fclose($fc);
+
+ $fl = fopen($dir_path . $latex_filename, 'w');
+ fwrite($fl, $latex_filedata);
+ fclose($fl);
+
+ $fd = fopen($dir_path . $latex_dep_filename, 'w');
+ fwrite($fd, $latex_dep_filedata);
+ fclose($fd);
+ if (_latex_run_script($lab_filename, $solution_provider_filename, $latex_filename, $latex_dep_filename, $pdf_filename))
+ {
+ /* download zip file */
+ header('Content-Type: application/pdf');
+ header('Content-disposition: attachment; filename="' . $proposal_data->lab_title . '_' . $proposal_data->name_title . '_' . $proposal_data->name . '.pdf"');
+ header('Content-Length: ' . filesize($dir_path . $pdf_filename));
+ readfile($dir_path . $pdf_filename);
+ } else {
+ drupal_set_message("Error occurred when generating the PDF version of the Book.", 'error');
+ }
+
+ /*********************** DELETING TEMPORARY FILES ***************************/
+ /* regenerate lab if full lab selected */
+ if ($full_lab)
+ lab_migration_del_lab_pdf($proposal_data->id);
+}
+
+function _latex_copy_script_file()
+{
+ exec("cp ./" . drupal_get_path('module', 'lab_migration') . "/latex/* " . lab_migration_path() . "latex");
+ exec("chmod u+x ./uploads/latex/*.sh");
+}
+
+function _latex_run_script($lab_filename, $solution_provider_filename, $latex_filename, $latex_dep_filename, $pdf_filename)
+{
+ $root_path = lab_migration_path();
+ $ret = 0;
+ chdir("lab_migration_uploads");
+ chdir("latex");
+
+ $sh_command = "./pdf_creator.sh " . $lab_filename . " " . $solution_provider_filename . " " . $latex_filename . " " . $latex_dep_filename;
+ exec($sh_command);
+ exec("mv TEX_final.pdf " . $pdf_filename);
+
+ if ($ret == 0)
+ return TRUE;
+ else
+ return FALSE;
+}
+
+function lab_migration_delete_lab_pdf()
+{
+ $lab_id = arg(3);
+ lab_migration_del_lab_pdf($lab_id);
+ drupal_set_message(t('Lab schedule for regeneration.'), 'status');
+ drupal_goto('lab_migration/code_approval/bulk');
+ return;
+}
+