diff options
Diffstat (limited to 'additional_tabs.inc')
| -rw-r--r-- | additional_tabs.inc | 209 |
1 files changed, 209 insertions, 0 deletions
diff --git a/additional_tabs.inc b/additional_tabs.inc new file mode 100644 index 0000000..b3153c3 --- /dev/null +++ b/additional_tabs.inc @@ -0,0 +1,209 @@ +<?php + +function dwsim_flowsheet_progress_tab() +{ + $page_content = ""; + $query = db_select('dwsim_flowsheet_proposal'); + $query->fields('dwsim_flowsheet_proposal'); + $query->condition('approval_status', 1); + $query->condition('is_completed', 0); + $query->orderBy('approval_date', 'DESC'); + $result = $query->execute(); + if ($result->rowCount() == 0) + { + $page_content .= "Approved Proposals under Flowsheeting Project<hr>"; + } //$result->rowCount() == 0 + else + { + $page_content .= "Approved Proposals under Flowsheeting Project<hr>";; + $preference_rows = array(); + $i = 1; + while ($row = $result->fetchObject()) + { + $approval_date = date("Y", $row->approval_date); + $preference_rows[] = array( + $i, + $row->project_title, + $row->contributor_name, + $row->university, + $approval_date + ); + $i++; + } //$row = $result->fetchObject() + $preference_header = array( + 'No', + 'Flowsheet Project', + 'Contributor Name', + 'University / Institute', + 'Year' + ); + $page_content .= theme('table', array( + 'header' => $preference_header, + 'rows' => $preference_rows + )); + } + return $page_content; +} + + +/////////////////////////////////////////////////////////////////////// +////////////////////////////////////////////////////////////////////// +///////////////////////////////////////////////////////////////////// + + +function dwsim_flowsheet_uploaded_tab() +{ + $page_content = ""; + $result = db_query("SELECT dfp.project_title, dfp.contributor_name, dfp.university, dfp.approval_date + FROM dwsim_flowsheet_proposal dfp LEFT JOIN dwsim_flowsheet_submitted_abstracts dfsa + ON dfp.id= dfsa.proposal_id WHERE approval_status = 1 + AND user_defined_compound_filepath = 'NULL' ORDER BY dfsa.abstract_upload_date DESC"); + //var_dump($result);die; + + //$result = $query->execute(); + if ($result->rowCount() == 0) + { + $page_content .= "Uploaded Proposals under Flowsheeting Project<hr>"; + } //$result->rowCount() == 0 + else + { + $page_content .= "Uploaded Proposals under Flowsheeting Project<hr>";; + $preference_rows = array(); + $i = 1; + while ($row = $result->fetchObject()) + { + $approval_date = date("Y", $row->approval_date); + $preference_rows[] = array( + $i, + $row->project_title, + $row->contributor_name, + $row->university, + $approval_date + ); + $i++; + } //$row = $result->fetchObject() + $preference_header = array( + 'No', + 'Flowsheet Project', + 'Contributor Name', + 'University / Institute', + 'Year' + ); + $page_content .= theme('table', array( + 'header' => $preference_header, + 'rows' => $preference_rows + )); + } + return $page_content; +} + + +/////////////////////////////////////////////////////////////////////// +////////////////////////////////////////////////////////////////////// +///////////////////////////////////////////////////////////////////// + + +function dwsim_flowsheet_completed_tab_form($form, $form_state){ + /*$options_first = _list_of_flowsheet_project(); + $selected = isset($form_state['values']['howmany_select']) ? $form_state['values']['howmany_select'] : key($options_first);*/ + $form['howmany_select'] = array( + '#title' => t('Sorting projects according to year:'), + '#type' => 'select', + '#options' => array(2017 => 2017, 2018 => 2018, 2019 => 2019, 2020 => 2020, 2021 => 2021), + //'#default_value' => $selected, + '#ajax' => array( + 'callback' => 'ajax_example_autocheckboxes_callback', + //'wrapper' => 'checkboxes-div', + /*'method' => 'replace', + 'effect' => 'fade',*/ + ), + '#suffix' => '<div id="ajax_selected_flowsheet"></div>' + + ); + return $form; +} + +function ajax_example_autocheckboxes_callback($form, $form_state) +{ + $commands = array(); + $flowsheet_project_default_value = $form_state['values']['howmany_select']; + //var_dump($flowsheet_project_default_value);die; + if ($flowsheet_project_default_value != 0) + { + $commands[] = ajax_command_replace('#ajax_selected_flowsheet', _flowsheet_details($flowsheet_project_default_value)); + } //$flowsheet_project_default_value != 0 + else + { + $commands[] = ajax_command_replace('#ajax_selected_flowsheet', ''); + $commands[] = ajax_command_data('#ajax_selected_flowsheet', 'form_state_value_select', $form_state['values']['howmany_select']); + } + return array( + '#type' => 'ajax', + '#commands' => $commands + ); +} + + +function _flowsheet_details($flowsheet_proposal_id){ + //var_dump($flowsheet_proposal_id);die; + $output = ""; + $result = db_query("SELECT * from {dwsim_flowsheet_proposal} WHERE approval_status = 3 and from_unixtime(actual_completion_date, '%Y') = :year", array( + ':year' => $flowsheet_proposal_id)); + //$sql = $result->execute(); + //var_dump($result);die; + if ($result->rowCount() == 0) + { + $output .= "Work has been completed for the following flow sheets."; + + } //$result->rowCount() == 0 + else + { + $output .= "Work has been completed for the following flow sheets"; + $preference_rows = array(); + $i = 1; + while ($row = $result->fetchObject()) + { + $completion_date = date("Y", $row->actual_completion_date); + $preference_rows[] = array( + $i, + l($row->project_title, "flowsheeting-project/dwsim-flowsheet-run/" . $row->id, array('attributes' => array('title' => 'This is a zip file containing a pdf (abstract) and a dwxml/dwxmz file which is the DWSIM flow sheet which is to be viewed by right clicking on the file and opening with DWSIM.'))), + $row->contributor_name, + $row->university, + $completion_date + ); + $i++; + } //$row = $result->fetchObject() + $preference_header = array( + 'No', + 'Flowsheet Project', + 'Contributor Name', + 'University / Institute', + 'Year of Completion' + ); + $output .= theme('table', array( + 'header' => $preference_header, + 'rows' => $preference_rows + )); + } + return $output; +} + +function _list_of_flowsheet_project() +{ + $options_first = array( + '0' => 'Please select...' + ); + if(isset($form_state['values']['howmany_select'])) { + $rows = db_select('dwsim_flowsheet_proposal', 'actual_completion_date') + ->fields('actual_completion_date') + ->condition('approval_status', $form_state['values']['howmany_select']) + ->execute() + ->fetchAll(); + + $header = array(); + $form['results']['#markup'] = theme('table', array('header' => $header, 'rows' => $rows)); + } + else { + $form['results']['#markup'] = '<p>The results will appear here when you change the dropdown option.</p>'; + } +}
\ No newline at end of file |