122 lines
3.4 KiB
PHP
122 lines
3.4 KiB
PHP
<?php
|
|
|
|
namespace Martin\Forms\Controllers;
|
|
|
|
use BackendMenu, Response;
|
|
use Backend\Classes\Controller;
|
|
use League\Csv\AbstractCsv;
|
|
use League\Csv\Writer as CsvWriter;
|
|
use SplTempFileObject;
|
|
use Martin\Forms\Models\Record;
|
|
|
|
class Exports extends Controller {
|
|
|
|
public $requiredPermissions = ['martin.forms.access_exports'];
|
|
|
|
public $implement = [
|
|
'Backend.Behaviors.FormController',
|
|
];
|
|
|
|
public $formConfig = 'config_form.yaml';
|
|
|
|
public function __construct() {
|
|
parent::__construct();
|
|
BackendMenu::setContext('Martin.Forms', 'forms', 'exports');
|
|
}
|
|
|
|
public function index() {
|
|
$this->pageTitle = e(trans('martin.forms::lang.controllers.exports.title'));
|
|
$this->create('frontend');
|
|
}
|
|
|
|
public function csv() {
|
|
|
|
$records = Record::orderBy('created_at');
|
|
|
|
// FILTER GROUPS
|
|
if (!empty($groups = post('Record.filter_groups'))) {
|
|
$records->whereIn('group', $groups);
|
|
}
|
|
|
|
// FILTER DATE
|
|
if (!empty($date_after = post('Record.filter_date_after'))) {
|
|
$records->whereDate('created_at', '>=', $date_after);
|
|
}
|
|
|
|
// FILTER DATE
|
|
if (!empty($date_before = post('Record.filter_date_before'))) {
|
|
$records->whereDate('created_at', '<=', $date_before);
|
|
}
|
|
|
|
// FILTER DELETED
|
|
if ($deleted = post('Record.options_deleted')) {
|
|
$records->withTrashed();
|
|
}
|
|
|
|
// CREATE CSV
|
|
$csv = CsvWriter::createFromFileObject(new SplTempFileObject());
|
|
|
|
// CHANGE DELIMTER
|
|
if (post('Record.options_delimiter')) {
|
|
$csv->setDelimiter(';');
|
|
}
|
|
|
|
// SET UTF-8 Output
|
|
if (post('Record.options_utf')) {
|
|
$csv->setOutputBOM(AbstractCsv::BOM_UTF8);
|
|
}
|
|
|
|
// CSV HEADERS
|
|
$headers = [];
|
|
|
|
// METADATA HEADERS
|
|
if (post('Record.options_metadata')) {
|
|
$meta_headers = [
|
|
e(trans('martin.forms::lang.controllers.records.columns.id')),
|
|
e(trans('martin.forms::lang.controllers.records.columns.group')),
|
|
e(trans('martin.forms::lang.controllers.records.columns.ip')),
|
|
e(trans('martin.forms::lang.controllers.records.columns.created_at')),
|
|
];
|
|
$headers = array_merge($meta_headers, $headers);
|
|
}
|
|
|
|
// ADD STORED FIELDS AS HEADER ROW IN CSV
|
|
$filteredRecords = $records->get();
|
|
$recordsArray = $filteredRecords->toArray();
|
|
$record = $filteredRecords->first();
|
|
$headers = array_merge($headers, array_keys($record->form_data_arr));
|
|
|
|
// ADD HEADERS
|
|
$csv->insertOne($headers);
|
|
|
|
// WRITE CSV LINES
|
|
foreach ($records->get()->toArray() as $row) {
|
|
|
|
$data = (array) json_decode($row['form_data']);
|
|
|
|
// IF DATA IS ARRAY CONVERT TO JSON STRING
|
|
foreach ($data as $field => $value) {
|
|
if (is_array($value) || is_object($value)) {
|
|
$data[$field] = json_encode($value);
|
|
}
|
|
}
|
|
|
|
// ADD METADATA IF NEEDED
|
|
if (post('Record.options_metadata')) {
|
|
array_unshift($data, $row['id'], $row['group'], $row['ip'], $row['created_at']);
|
|
}
|
|
|
|
$csv->insertOne($data);
|
|
|
|
}
|
|
|
|
// RETURN CSV
|
|
$csv->output('records.csv');
|
|
exit();
|
|
|
|
}
|
|
|
|
}
|
|
|
|
?>
|