diff options
Diffstat (limited to 'latex.inc')
| -rwxr-xr-x | latex.inc | 501 |
1 files changed, 257 insertions, 244 deletions
@@ -1,261 +1,274 @@ <?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'); + $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); + } } - $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()) +/* full lab parameter is for gennerating the entire lab pdf including all unapproved solutions */ +function _latex_generate_files($lab_id, $full_lab = FALSE) { - 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()) + $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) { - $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; + drupal_set_message('Invalid lab specified.', 'error'); + drupal_goto(''); } - //$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()) + if ($proposal_data->approval_status == 0) { - //$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"; - } - - } + 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; } - } - - 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'); + $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', $row); + $query->condition('id', $dependency_files_data->dependency_id); $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; - } + 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); } - - /**************************** 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"); -} - + { + 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; -} - + { + $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; -} - + { + $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; + } |