YUDISTIRA : Simple Report Generator

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