QueryCloud/routes.php at main · rouhu/QueryCloud · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<?php
//Flight::route('GET /', array('Dashboard', 'index'));
//Flight::route('GET /home', array('Dashboard', 'index'));
//Flight::route('GET /login', array('Login', 'index'));
//Flight::route('POST /login', array('Login', 'loginuser'));
//Flight::route('GET /login/logout', array('Login', 'logout'));

Flight::route('GET /', 'Dashboard::index');
Flight::route('GET /home', 'Dashboard::index');
Flight::route('GET /login', 'Login::index');
Flight::route('POST /login', 'Login::loginuser');
Flight::route('GET /login/logout', 'Login::logout');

Flight::route('GET /dashboard', 'Dashboard::index');

// Destination Management
Flight::route('GET /destinations', 'Destinations::index');
Flight::route('POST /destinations/add', 'Destinations::add');
Flight::route('POST /destinations/delete', 'Destinations::delete');

// Data Source Management
Flight::route('GET /datasources', 'DataSources::index');
Flight::route('POST /datasources/add', 'DataSources::add');
Flight::route('POST /datasources/delete', 'DataSources::delete');

// ETL Configuration
Flight::route('GET /etl/@query_id:[0-9]+', 'ETL::index');
Flight::route('POST /etl/save', 'ETL::save');
Flight::route('POST /etl/run', 'ETL::run');

// ETL Log Page
Flight::route('GET /etllog', 'EtlLog::index');

Flight::route('GET /export/csv', 'Export::csv');
Flight::route('GET /export/excel', 'Export::excel');
Flight::route('GET /table/[a-zA-Z0-9-_?+]+', 'Table::index');
Flight::route('POST /table/run_saved_query', 'Table::run_saved_query');
Flight::route('POST /table/[a-zA-Z0-9-_?+]+', 'Table::runquery');

// Visual Query Builder
Flight::route('GET /vqb', 'VisualQueryBuilder::index');
Flight::route('POST /vqb', 'VisualQueryBuilder::run');
Flight::route('GET /vqb/@table', 'VisualQueryBuilder::index');
Flight::route('POST /vqb/@table', 'VisualQueryBuilder::run');
Flight::route('GET /vqb/edit/@query_id:[0-9]+', 'VisualQueryBuilder::edit');
Flight::route('POST /vqb/edit/@query_id:[0-9]+', 'VisualQueryBuilder::run');
//Flight::route('POST /ajax/[a-zA-Z0-9-_?+]+', array('Ajax', Flight::get('lastSegment')));
$lastSegment = Flight::get('lastSegment');
Flight::route('POST /ajax/set_data_source', 'Ajax::set_data_source');
Flight::route('POST /ajax/get_tables_for_data_source', 'Ajax::get_tables_for_data_source');
Flight::route('POST /ajax/get_destination_tables', 'Ajax::get_destination_tables');
Flight::route('POST /ajax/get_etl_mapping_data', 'Ajax::get_etl_mapping_data');
Flight::route('POST /ajax/getSqlFromVisualParams', 'Ajax::getSqlFromVisualParams');
Flight::route('POST /ajax/[a-zA-Z0-9-_?+]+', 'Ajax::'.$lastSegment);
Flight::route('GET /ajax/getSavedQueries', 'Ajax::getSavedQueries'); // Route for fetching saved queries
Flight::route('POST /ajax/saveTableFormatting', 'Ajax::saveTableFormatting'); // Route for saving table formatting
Flight::route('GET /ajax/getTableFormatting/@query_id', 'Ajax::getTableFormatting'); // Route for fetching specific table formatting
Flight::route('GET /ajax/getShareToken/@query_id', 'Ajax::getShareToken'); // Route for getting/generating a share token
Flight::route('POST /ajax/generateShareToken', 'Ajax::generateShareToken'); // Route for generating a new share token
Flight::route('POST /ajax/updateShareSettings', 'Ajax::updateShareSettings'); // Route for updating share settings (e.g. require_login)
//Flight::route('POST /ajax/@action', 'Ajax::@action');

// Public share route
Flight::route('GET /share/@token', 'Share::viewReport');