SUMMARY
We need a way to easily create reports from Yudistira's database.
The report must be in CSV format, and can be opened in Microsoft Excel.
The project is consisted of a single web page.
It asked the parameters for the report. Then it'll query the database, and then the report will be automatically downloaded to user's browser.
The whole Yudistira application & portion of its database will be provided as sample.
=================
INPUT
Add a menu named "Report"
Clicking on that menu will show a form with following fields :
Status : dropdown
Classification : dropdown
Date Range : From - To
Source : textbox
Tags : textbox, comma separated
EXPLANATION
Empty fields are ignored / not searched.
Status : 2 choices, True or False. Stored in database as 1 when True, and 2 when False
Classification : 9 choices, defined in application/controller/Main_Data.php :
'False Connection' => 'False Connection',
'False Context' => 'False Context',
'Satire' => 'Satire',
'Manipulated Content' => 'Manipulated Content',
'Misleading Content' => 'Misleading Content',
'Impostor Content' => 'Impostor Content',
'Fabricated Content' => 'Fabricated Content',
'TRUE' => 'TRUE',
'Clarification' => 'Clarification'
Date range : searches the antihoax.created_at field
Source : searches the antihoax.source_issue field with " WHERE source_issue LIKE '%$source%' "
Tags : search all tags on antihoax.tags field with " WHERE tags LIKE '%$tag1%' AND tags LIKE '%$tag2%' " etc
=================
PROCESS
DATABASE LINKS
antihoax_content.antihoax_id links to antihoax.id
=================
OUTPUT
All found records are send to user as CSV file, with the following fields included :
tablename.fieldname
Title : antihoax_content.title
Content : antihoax_content.content
Fact : antihoax_content.fact
Status : antihoax.status (1 = "True", 2 = "False")
Classification : antihoax.classification
Source : antihoax.source_issue
Tags : antihoax.tags
Date : antihoax.tanggal
Comments