function doExport($table, $mode) { global $REX, $REX_USER, $XLS_TABLES, $XLS_MODES; $Basedir = dirname(__FILE__); require_once $Basedir . '/../libs/Spreadsheet_Excel_Writer-0.8/Writer.php'; if (array_key_exists($table, $XLS_TABLES) && array_key_exists($mode, $XLS_MODES)) { $createstamp = time(); $oTable = new ExportTable($table); if ($mode == 'all') { $result = $oTable->getAll(); } else { if ($mode == 'new') { $result = $oTable->getNew(); } } if (mysql_error() == '') { rs2xls(xlsLocation($table, $createstamp), xlsFilename($tables[$table], $createstamp), $result); $values = array(0, $table, mysql_num_rows($result), $REX_USER->getValue('login'), $createstamp); $set = ''; $first = true; foreach ($values as $value) { if ($first) { $first = false; } else { $set .= ', '; } if (is_string($value)) { $set .= '"' . mysql_escape_string($value) . '"'; } else { $set .= $value; } } $sql = new CompatSql(); $qry = 'INSERT INTO ' . TBL_EXCEL_EXPORT . ' VALUES (' . $set . ')'; $sql->setQuery($qry); } else { echo 'Fehler beim ausführen der Abfrage!'; } } }
<col width="*"/> <col width="50px"/> <col width="50px"/> <col width="120px"/> <col width="250px"/> </colgroup> <tr> <th>Tabelle</th> <th>Anzahl</th> <th>Neue</th> <th>Letzter Export</th> <th>Aktion</th> </tr> <?php foreach ($XLS_TABLES as $table => $label) { $oTable = new ExportTable($table); ?> <tr> <td><?php echo $label; ?> </td> <td> <?php echo $numAll = $oTable->numAll(); ?> </td> <td> <?php echo $numNew = $oTable->numNew(); ?>
<?php require_once '../include/export_class.php'; include '../include/connect.php'; $object = new ExportTable(); $object->loadContent($_POST['nr'], isset($_POST['table']) ? $_POST['table'] : '', isset($_POST['filename']) ? $_POST['filename'] : '', isset($_POST['type']) ? $_POST['type'] : '', isset($_POST['columns']) ? $_POST['columns'] : '');