<?php
require_once '../../includes/initialize.php';
$session->confirmation_protected_page();
if (User::is_employee() || User::is_secretary()) {
redirect_to('index.php');
}
require_once LIB_PATH . DS . 'src' . DS . 'Foundationphp' . DS . 'Psr4Autoloader.php';
$loader = new Foundationphp\Psr4Autoloader();
$loader->register();
$loader->addNamespace('Foundationphp', LIB_PATH . DS . 'src' . DS . 'Foundationphp');
use Foundationphp\Exporter\Csv;
//$class_name="Client";
if (isset($_POST['download'])) {
if (isset($_POST['class_name'])) {
$class_name = urldecode($_POST['class_name']);
} else {
$class_name = false;
$session->message('No class name defined');
redirect_to('index.php');
}
$table_name = $class_name::get_table_name();
$db = new mysqli(DB_SERVER, DB_USER, DB_PASS, DB_NAME);
$db->set_charset('utf-8');
if ($db->connect_error) {
$error = $db->connect_error;
} else {
$sql = 'SELECT * FROM' . ' ' . $table_name;
//$sql.= " ".get_where_string($class_name);
$result = $db->query($sql);
if ($db->error) {
<?php
require_once 'src/Foundationphp/Psr4Autoloader.php';
$loader = new Foundationphp\Psr4Autoloader();
$loader->register();
$loader->addNamespace('Foundationphp', 'src/Foundationphp');
use Foundationphp\Exporter\Xml;
use Foundationphp\Exporter\MsWord;
use Foundationphp\Exporter\OpenDoc;
require_once 'includes/flowers_pdo.php';
if (isset($_POST['download'])) {
try {
$options['stripNsplit'] = 'description';
$xml = new Xml($result, null, $options);
$dir = __DIR__ . '/';
if ($_POST['format'] == 'msword') {
$download = new MsWord($xml);
$download->setDocTemplate($dir . 'output/flowers_wordTemplate.docx');
$download->setXsltSource($dir . 'output/flowers_word.xslt');
$download->setImageSource($dir . 'images');
$download->create('flowers.docx');
} elseif ($_POST['format'] == 'opendoc') {
$download = new OpenDoc($xml);
$download->setDocTemplate($dir . 'output/flowers_odtTemplate.odt');
$download->setXsltSource($dir . 'output/flowers_odt.xslt');
$download->setImageSource($dir . 'images');
$download->create('flowers.odt');
}
} catch (Exception $e) {
$error = $e->getMessage();
}
<?php
require_once 'src/Foundationphp/Psr4Autoloader.php';
$loader = new Foundationphp\Psr4Autoloader();
$loader->register();
$loader->addNamespace('Fusonic', 'src/Fusonic');
use Fusonic\SpreadsheetExport\Spreadsheet;
use Fusonic\SpreadsheetExport\ColumnTypes\CurrencyColumn;
use Fusonic\SpreadsheetExport\ColumnTypes\NumericColumn;
use Fusonic\SpreadsheetExport\ColumnTypes\TextColumn;
use Fusonic\SpreadsheetExport\Writers\OdsWriter;
require_once 'includes/cars_mysqli.php';
if (isset($_POST['download'])) {
try {
$sheet = new Spreadsheet();
$sheet->addColumn(new NumericColumn('car_id'));
$make = new TextColumn('make');
$make->width = 1.2 * 2.54;
$sheet->addColumn($make);
$sheet->addColumn(new NumericColumn('yearmade'));
$sheet->addColumn(new NumericColumn('mileage'));
$sheet->addColumn(new TextColumn('transmission'));
$price = new CurrencyColumn('price');
$price->currency = 'USD';
$sheet->addColumn($price);
$description = new TextColumn('description');
$description->width = 3.25 * 2.54;
$sheet->addColumn($description);
while ($row = getRow($result)) {
foreach ($row as $key => $value) {
$row[$key] = str_replace(array('&', '<'), array('&', '<'), $value);
