$user->uid
));
$exist_id = $query_id->fetchObject();
if ($exist_id->id)
{
if ($exist_id->id < 3)
{
drupal_set_message('You need to propose a Book Proposal or if you have already proposed then your book is under reviewing process', 'status');
return '';
} //$exist_id->id < 3
else
{
$search_rows = array();
global $output;
$output = '';
$query3 = db_query("SELECT prop.id,pref.isbn,pref.book,pref.author FROM textbook_companion_proposal as prop,textbook_companion_preference as pref WHERE prop.proposal_status = 3 AND pref.approval_status =1 AND pref.proposal_id = prop.id AND prop.uid = :uid", array(
':uid' => $user->uid
));
while ($search_data3 = $query3->fetchObject())
{
if ($search_data3->id)
{
$search_rows[] = array(
$search_data3->isbn,
$search_data3->book,
$search_data3->author,
l('Download Copyright Form', 'Summer_Internship_Forms/copyright-form/generate_pdf/' . $search_data3->id),
l('Download Undertaking Form', 'Summer_Internship_Forms/undertaking-form/generate_pdf/' . $search_data3->id)
);
} //$search_data3->id
} //$search_data3 = $query3->fetchObject()
if ($search_rows)
{
$search_header = array(
'ISBN',
'Book Name',
'Author',
'Download Copyright Form',
'Download Undertaking Form'
);
$output = theme('table', array(
'header' => $search_header,
'rows' => $search_rows
));
return $output;
} //$search_rows
else
{
echo ("Error");
return '';
}
}
} //$exist_id->id
else
{
drupal_set_message('You need to propose a book Book Proposal or if you have already proposed then your book is under reviewing process', 'status');
return '';
}
}