diff options
author | Saketh1499 | 2021-10-18 14:44:17 +0530 |
---|---|---|
committer | Saketh1499 | 2021-10-18 16:01:27 +0530 |
commit | 4648e0b828e47b0b0f533be0a332fbbdd0787ce1 (patch) | |
tree | e15ebcde8638ed1437a5d3b73110fcd2bb1d6765 /download.inc | |
parent | 11cb8a66c33ca9375590feec95bf621e8cffe49b (diff) | |
download | dwsim_flowsheet-4648e0b828e47b0b0f533be0a332fbbdd0787ce1.tar.gz dwsim_flowsheet-4648e0b828e47b0b0f533be0a332fbbdd0787ce1.tar.bz2 dwsim_flowsheet-4648e0b828e47b0b0f533be0a332fbbdd0787ce1.zip |
Updating download proposals interface
Diffstat (limited to 'download.inc')
-rwxr-xr-x | download.inc | 15 |
1 files changed, 6 insertions, 9 deletions
diff --git a/download.inc b/download.inc index 62470cb..a329bf3 100755 --- a/download.inc +++ b/download.inc @@ -306,11 +306,8 @@ function dwsim_flowsheet_download_lab() function dwsim_flowsheet_download_proposals() { - $output = ""; - //$output = "<p>Click <a href='download-proposals'>here</a> to download the Proposals of the participants"; - $root_path = dwsim_flowsheet_path(); - $result = db_query("SELECT e.contributor_name as Contirbutor_Name, u.mail as Email_ID, e.project_title as Title, e.contact_no as Contact, from_unixtime(actual_completion_date,'%Y') as Year FROM dwsim_flowsheet_proposal as e JOIN users as u ON e.uid = u.uid WHERE e.approval_status=3 ORDER BY actual_completion_date DESC"); + $result = db_query("SELECT e.contributor_name as Contirbutor_Name, u.mail as Email_ID, e.project_title as Title, e.contact_no as Contact, from_unixtime(actual_completion_date,'%Y') as Year FROM dwsim_flowsheet_proposal as e JOIN users as u ON e.uid = u.uid WHERE e.approval_status=3 ORDER BY actual_completion_date DESC"); //$all_proposals_q = $result->execute(); $participants_proposal_id_file = $root_path . "participants-proposals.csv"; @@ -326,11 +323,11 @@ function dwsim_flowsheet_download_proposals() fputcsv($fp, $items); while($row = $result->fetchObject()) { $items = array( - '$row->contributor_name', - '$row->mail', - '$row->project_title', - '$row->contact_no', - '$row->actual_completion_date' + $row->contributor_name, + $row->mail, + $row->project_title, + $row->contact_no, + $row->actual_completion_date ); fputcsv($fp, $items); } |