diff options
Diffstat (limited to 'circuit_simulation_details.inc')
| -rwxr-xr-x | circuit_simulation_details.inc | 90 |
1 files changed, 90 insertions, 0 deletions
diff --git a/circuit_simulation_details.inc b/circuit_simulation_details.inc new file mode 100755 index 0000000..64fd9f5 --- /dev/null +++ b/circuit_simulation_details.inc @@ -0,0 +1,90 @@ +<?php +// eSim Circuit Simulation display completed proposals +function circuit_simulation_completed_proposals_all() +{ + $output = ""; + $query = db_select('esim_circuit_simulation_proposal'); + $query->fields('esim_circuit_simulation_proposal'); + $query->condition('approval_status', 3); + //$query->condition('is_completed', 1); + $result = $query->execute(); + if ($result->rowCount() == 0) + { + $output .= "Work has been completed for the following circuit simulation. We welcome your contributions. For more details, please visit ".l("http://esim.fossee.in/circuit-simulation-project","http://esim.fossee.in/circuit-simulation-project")."<br>"."<h4>"."If you are looking for circuit-simulation project ideas, ".l("click here","http://esim.fossee.in/circuit-simulation-ideas",array('attributes' => array('class' => array('flash_content'))))."</h4>"."<hr>"; + + } //$result->rowCount() == 0 + else + { + $output .= "Work has been completed for the following circuit simulation. We welcome your contributions. For more details, please visit ".l("http://esim.fossee.in/circuit-simulation-project","http://esim.fossee.in/circuit-simulation-project")."<br>"."<h4>"."If you are looking for circuit-simulation project ideas, ".l("click here","http://esim.fossee.in/circuit-simulation-ideas",array('attributes' => array('class' => array('flash_content'))))."</h4>"."<hr>"; + $preference_rows = array(); + $i = 1; + while ($row = $result->fetchObject()) + { + $approval_date = date("Y", $row->approval_date); + $preference_rows[] = array( + $i, + l($row->project_title, "circuit-simulation-project/esim-circuit-simulation-run/" . $row->id), + $row->contributor_name, + $row->university, + $approval_date + ); + $i++; + } //$row = $result->fetchObject() + $preference_header = array( + 'No', + 'Circuit Simulation Project', + 'Contributor Name', + 'Institute', + 'Year' + ); + $output .= theme('table', array( + 'header' => $preference_header, + 'rows' => $preference_rows + )); + } + return $output; +} +// eSim Circuit Simulation display in progress proposals +function circuit_simulation_progress_all() +{ + $page_content = ""; + $query = db_select('esim_circuit_simulation_proposal'); + $query->fields('esim_circuit_simulation_proposal'); + $query->condition('approval_status', 1); + $query->condition('is_completed', 0); + $result = $query->execute(); + if ($result->rowCount() == 0) + { + $page_content .= "Work is in progress for the following circuit simulation under Circuit Simulation Project<hr>"; + } //$result->rowCount() == 0 + else + { + $page_content .= "Work is in progress for the following circuit simulation under Circuit Simulation 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', + 'Circuit Simulation Project', + 'Contributor Name', + 'Institute', + 'Year' + ); + $page_content .= theme('table', array( + 'header' => $preference_header, + 'rows' => $preference_rows + )); + } + return $page_content; +}
\ No newline at end of file |