fields('dwsim_flowsheet_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 flow sheets. We welcome your contributions. For more details, please visit ".l("http://dwsim.fossee.in/flowsheeting-project","http://dwsim.fossee.in/flowsheeting-project")."
".""."If you are looking for flowsheeting project ideas, ".l("click here","http://dwsim.fossee.in/flowsheeting-ideas",array('attributes' => array('class' => array('flash_content'))))."
"."
";
} //$result->rowCount() == 0
else
{
$output .= "Work has been completed for the following flow sheets. We welcome your contributions. For more details, please visit ".l("http://dwsim.fossee.in/flowsheeting-project","http://dwsim.fossee.in/flowsheeting-project")."
".""."If you are looking for flowsheeting project ideas, ".l("click here","http://dwsim.fossee.in/flowsheeting-ideas",array('attributes' => array('class' => array('flash_content'))))."
"."
";
$preference_rows = array();
$i = 1;
while ($row = $result->fetchObject())
{
$approval_date = date("Y", $row->approval_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->university,
$approval_date
);
$i++;
} //$row = $result->fetchObject()
$preference_header = array(
'No',
'Flowsheet Project',
'Institute',
'Year'
);
$output .= theme('table', array(
'header' => $preference_header,
'rows' => $preference_rows
));
}
return $output;
}
// DWSIM Flowsheet display in progress proposals
function dwsim_flowsheet_progress_all()
{
$page_content = "";
$query = db_select('dwsim_flowsheet_proposal');
$query->fields('dwsim_flowsheet_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 flowsheets under Flowsheeting Project
";
} //$result->rowCount() == 0
else
{
$page_content .= "Work is in progress for the following flowsheets under Flowsheeting Project
";
$page_content .= "";
while ($row = $result->fetchObject())
{
$page_content .= "- ";
$page_content .= $row->project_title;
$page_content .= "
";
} //$row = $result->fetchObject()
$page_content .= "
";
}
return $page_content;
}