For a quick export for all my tables i have added some code to implement a "EXPORT" button.
Please add these to the next official version.
edited file: /modern/admin/tmpl/droptables/default.php to add the "Export all"
button:
<a id="export_all" class="button" href="#" style="background-color: white; border: 1px solid grey; color: black; margin-left: 10px; padding: 10px">Export all</a>
Skript:
// Add export all tables function
jQuery(document).ready(function ($) {
$('#export_all').on('click', function(e) {
e.preventDefault();
// Get all table IDs from the current view
var tableIds = [];
var base_export_url = "<?php echo JUri::root() . 'administrator/';?>index.php?option=com_droptables&task=excel.export&format_excel=xlsx&front=0&onlydata=1&id=";
if (Droptables.listTable) {
for (var catID in Droptables.listTable) {
if (Droptables.listTable.hasOwnProperty(catID)) {
if (typeof Droptables.listTable[catID] !== 'undefined' && Droptables.listTable[catID].length > 0) {
Droptables.listTable[catID].forEach(function(table) {
tableIds.push(table.id);
window.open(base_export_url + table.id, '_blank');
});
}
}
}
console.log('Table IDs:', tableIds);
} else {
console.log('No tables found');
}
return false;
Please add these to the next official version.
edited file: /modern/admin/tmpl/droptables/default.php to add the "Export all"
button:
<a id="export_all" class="button" href="#" style="background-color: white; border: 1px solid grey; color: black; margin-left: 10px; padding: 10px">Export all</a>
Skript:
// Add export all tables function
jQuery(document).ready(function ($) {
$('#export_all').on('click', function(e) {
e.preventDefault();
// Get all table IDs from the current view
var tableIds = [];
var base_export_url = "<?php echo JUri::root() . 'administrator/';?>index.php?option=com_droptables&task=excel.export&format_excel=xlsx&front=0&onlydata=1&id=";
if (Droptables.listTable) {
for (var catID in Droptables.listTable) {
if (Droptables.listTable.hasOwnProperty(catID)) {
if (typeof Droptables.listTable[catID] !== 'undefined' && Droptables.listTable[catID].length > 0) {
Droptables.listTable[catID].forEach(function(table) {
tableIds.push(table.id);
window.open(base_export_url + table.id, '_blank');
});
}
}
}
console.log('Table IDs:', tableIds);
} else {
console.log('No tables found');
}
return false;
- Page :
- 1
There are no replies made for this post yet.
