header('Content-Type: application/json');
echo createJSONList($listFunc, $strList, $startRow, $rowCount, $sort, $filter, $where, intval(getRequest('draw', 1)));
break;
case 'get_invoice_total_sum':
$where = getRequest('where', '');
header('Content-Type: application/json');
echo getInvoiceListTotal($where);
break;
case 'get_selectlist':
require 'list.php';
$table = getRequest('table', '');
if (!$table) {
header('HTTP/1.1 400 Bad Request (table)');
exit;
}
if (!table_valid($table)) {
header('HTTP/1.1 400 Bad Request');
die('Invalid table name');
}
$pageLen = intval(getRequest('pagelen', 10));
$page = intval(getRequest('page', 1)) - 1;
$filter = getRequest('q', '');
$sort = getRequest('sort', '');
$id = getRequest('id', '');
header('Content-Type: application/json');
echo createJSONSelectList($table, $page * $pageLen, $pageLen, $filter, $sort, $id);
break;
case 'update_invoice_row_dates':
if (!sesWriteAccess()) {
header('HTTP/1.1 403 Forbidden');
exit;
protected function table_valid($table)
{
return table_valid($table);
}
public function launch()
{
$charset = getRequest('charset', 'UTF-8');
$table = getRequest('table', '');
$format = getRequest('format', '');
$fieldDelimiter = getRequest('field_delim', ',');
$enclosureChar = getRequest('enclosure_char', '"');
$rowDelimiter = getRequest('row_delim', "\n");
$columns = getRequest('column', '');
$childRows = getRequest('child_rows', '');
$deletedRecords = getRequest('deleted', false);
if ($table && $format && $columns) {
if (!table_valid($table)) {
die('Invalid table name');
}
$res = mysqli_query_check("show fields from {prefix}{$table}");
$field_count = mysqli_num_rows($res);
$field_defs = array();
while ($row = mysqli_fetch_assoc($res)) {
$field_defs[$row['Field']] = $row;
}
foreach ($columns as $key => $column) {
if (!$column) {
unset($columns[$key]);
} elseif (!isset($field_defs[$column])) {
die('Invalid column name');
}
}
ob_clean();
$filename = isset($GLOBALS["locTable_{$table}"]) ? $GLOBALS["locTable_{$table}"] : $table;
switch ($format) {
case 'csv':
$field_delims = $this->importer->get_field_delims();
$enclosure_chars = $this->importer->get_enclosure_chars();
$row_delims = $this->importer->get_row_delims();
if (!isset($field_delims[$fieldDelimiter])) {
die('Invalid field delimiter');
}
$fieldDelimiter = $field_delims[$fieldDelimiter]['char'];
if (!isset($enclosure_chars[$enclosureChar])) {
die('Invalid enclosure character');
}
$enclosureChar = $enclosure_chars[$enclosureChar]['char'];
if (!isset($row_delims[$rowDelimiter])) {
die('Invalid field delimiter');
}
$rowDelimiter = $row_delims[$rowDelimiter]['char'];
header('Content-type: text/csv');
header("Content-Disposition: attachment; filename=\"{$filename}.csv\"");
if ($charset == 'UTF-16') {
echo iconv($charset, 'UTF-16', '');
}
// output BOM
$this->output_str($this->str_putcsv($columns, $fieldDelimiter, $enclosureChar) . $rowDelimiter, $charset);
break;
case 'xml':
header('Content-type: text/xml');
header("Content-Disposition: attachment; filename=\"{$filename}.xml\"");
if ($charset == 'UTF-16') {
echo iconv($charset, 'UTF-16', '');
}
// output BOM
$this->output_str("<?xml version=\"1.0\"?>\n<records>\n", $charset);
break;
case 'json':
header('Content-type: application/json');
header("Content-Disposition: attachment; filename=\"{$filename}.json\"");
if ($charset == 'UTF-16') {
echo iconv($charset, 'UTF-16', '');
}
// output BOM
echo "{\"{$table}\":[\n";
break;
}
$query = "select * from {prefix}{$table}";
if (!$deletedRecords) {
$query .= ' where deleted=0';
if ($table == 'company_contact') {
$query .= ' and company_id not in (select id from {prefix}company where deleted=1)';
} elseif ($table == 'invoice_row') {
$query .= ' and invoice_id not in (select id from {prefix}invoice where deleted=1)';
}
}
$res = mysqli_query_check($query);
$first = true;
while ($row = mysqli_fetch_assoc($res)) {
$data = array();
foreach ($columns as $column) {
$value = $row[$column];
if (is_null($value)) {
$data[$column] = '';
}
if ($value && substr($field_defs[$column]['Type'], 0, 8) == 'longblob') {
$data[$column] = '0x' . bin2hex($value);
} else {
$data[$column] = $value;
}
}
switch ($format) {
case 'csv':
$this->output_str($this->str_putcsv($data, $fieldDelimiter, $enclosureChar) . $rowDelimiter, $charset);
break;
case 'xml':
$str = " <{$table}>\n";
foreach ($columns as $column) {
$str .= " <{$column}>" . xml_encode($data[$column]) . "</{$column}>\n";
}
if ($childRows && ($table == 'invoice' || $table == 'company')) {
if ($table == 'invoice') {
$cres = mysqli_param_query('select * from {prefix}invoice_row where invoice_id=?', array($row['id']));
} else {
$cres = mysqli_param_query('select * from {prefix}company_contact where company_id=?', array($row['id']));
}
while ($crow = mysqli_fetch_assoc($cres)) {
$str .= " <invoice_row>\n";
foreach ($crow as $column => $value) {
$str .= " <{$column}>" . xml_encode($value) . "</{$column}>\n";
}
$str .= " </invoice_row>\n";
}
}
$str .= " </{$table}>\n";
$this->output_str($str, $charset);
break;
case 'json':
if ($childRows && ($table == 'invoice' || $table == 'company')) {
if ($table == 'invoice') {
$childTable = 'invoice_row';
} else {
$childTable = 'company_contact';
}
$data[$childTable] = array();
if ($table == 'invoice') {
$cres = mysqli_param_query('select * from {prefix}invoice_row where invoice_id=?', array($row['id']));
} else {
$cres = mysqli_param_query('select * from {prefix}company_contact where company_id=?', array($row['id']));
}
while ($crow = mysqli_fetch_assoc($cres)) {
$data[$childTable][] = $crow;
}
}
if ($first) {
$first = false;
} else {
echo ",\n";
}
$this->output_str(json_encode($data), $charset);
break;
}
}
switch ($format) {
case 'xml':
$this->output_str("</records>\n");
break;
case 'json':
echo "\n]}\n";
break;
}
exit;
}
?>
<script type="text/javascript">
$(document).ready(function() {
$('#imessage').ajaxStart(function() {
$('#spinner').css('visibility', 'visible');
});
$('#imessage').ajaxStop(function() {
$('#spinner').css('visibility', 'hidden');
});
$('#imessage').ajaxError(function(event, request, settings) {
alert('Server request failed: ' + request.status + ' - ' + request.statusText);
$('#spinner').css('visibility', 'hidden');
});
update_field_states();
reset_columns();
});
var g_column_id = 0;
function reset_columns()
{
$("#columns > select").remove();
g_column_id = 0;
add_column();
}
function add_column()
{
var table = document.getElementById("sel_table").value;
$.getJSON("json.php?func=get_table_columns&table=" + table, function(json) {
var index = ++g_column_id;
var columns = document.getElementById("columns");
var select = document.createElement("select");
select.id = "column" + index;
select.name = "column[]";
select.onchange = update_columns;
var option = document.createElement("option");
option.value = "";
option.text = "<?php
echo $GLOBALS['locImportExportColumnNone'];
?>
";
select.options.add(option);
for (var i = 0; i < json.columns.length; i++)
{
var option = document.createElement("option");
option.value = json.columns[i].name;
option.text = json.columns[i].name;
select.options.add(option);
}
columns.appendChild(document.createTextNode(' '));
columns.appendChild(select);
});
}
function update_columns()
{
if (this.value == "" && $("#columns > select").size() > 1)
$(this).remove();
else if (this.id == "column" + g_column_id)
add_column();
}
function update_field_states()
{
var type = document.getElementById('format').value;
document.getElementById('field_delim').disabled = type != 'csv';
document.getElementById('enclosure_char').disabled = type != 'csv';
document.getElementById('row_delim').disabled = type != 'csv';
document.getElementById('child_rows').disabled = type == 'csv';
}
function add_all_columns()
{
var options = document.getElementById("column" + g_column_id).options;
$("#columns > select").remove();
g_column_id = 0;
var columns = document.getElementById("columns");
for (var i = 1; i < options.length; i++)
{
var index = ++g_column_id;
var select = document.createElement("select");
select.id = "column" + index;
select.name = "column[]";
select.onchange = update_columns;
var option = document.createElement("option");
for (var opt = 0; opt < options.length; opt++)
select.options.add(options[opt].cloneNode(true));
select.selectedIndex = i;
columns.appendChild(document.createTextNode(' '));
columns.appendChild(select);
}
}
</script>
<div class="form_container">
<h1><?php
echo $GLOBALS['locExport'];
?>
</h1>
<span id="imessage" style="display: none"></span>
<span id="spinner" style="visibility: hidden"><img src="images/spinner.gif" alt=""></span>
<form id="export_form" name="export_form" method="GET">
<input type="hidden" name="func" value="system">
<input type="hidden" name="operation" value="export">
<div class="medium_label"><?php
echo $GLOBALS['locImportExportCharacterSet'];
?>
</div>
<div class="field">
<select id="charset" name="charset">
<option value="UTF-8">UTF-8</option>
<option value="ISO-8859-1">ISO-8859-1</option>
<option value="ISO-8859-15">ISO-8859-15</option>
<option value="Windows-1251">Windows-1251</option>
<option value="UTF-16">UTF-16</option>
<option value="UTF-16LE">UTF-16 LE</option>
<option value="UTF-16BE">UTF-16 BE</option>
</select>
</div>
<div class="medium_label"><?php
echo $GLOBALS['locImportExportTable'];
?>
</div>
<div class="field">
<select id="sel_table" name="table" onchange="reset_columns()">
<option value="company"><?php
echo $GLOBALS['locImportExportTableCompanies'];
?>
</option>
<option value="company_contact"><?php
echo $GLOBALS['locImportExportTableCompanyContacts'];
?>
</option>
<option value="base"><?php
echo $GLOBALS['locImportExportTableBases'];
?>
</option>
<option value="invoice"><?php
echo $GLOBALS['locImportExportTableInvoices'];
?>
</option>
<option value="invoice_row"><?php
echo $GLOBALS['locImportExportTableInvoiceRows'];
?>
</option>
<option value="product"><?php
echo $GLOBALS['locImportExportTableProducts'];
?>
</option>
<option value="row_type"><?php
echo $GLOBALS['locImportExportTableRowTypes'];
?>
</option>
<option value="invoice_state"><?php
echo $GLOBALS['locImportExportTableInvoiceStates'];
?>
</option>
</select>
</div>
<div class="medium_label"><?php
echo $GLOBALS['locImportExportFormat'];
?>
</div>
<div class="field">
<select id="format" name="format" onchange="update_field_states()">
<option value="csv">CSV</option>
<option value="xml">XML</option>
<option value="json">JSON</option>
</select>
</div>
<div class="medium_label"><?php
echo $GLOBALS['locImportExportFieldDelimiter'];
?>
</div>
<div class="field">
<select id="field_delim" name="field_delim">
<?php
$field_delims = $this->importer->get_field_delims();
foreach ($field_delims as $key => $delim) {
echo "<option value=\"{$key}\">" . $delim['name'] . "</option>\n";
}
?>
</select>
</div>
<div class="medium_label"><?php
echo $GLOBALS['locImportExportEnclosureCharacter'];
?>
</div>
<div class="field">
<select id="enclosure_char" name="enclosure_char">
<?php
$enclosure_chars = $this->importer->get_enclosure_chars();
foreach ($enclosure_chars as $key => $delim) {
echo "<option value=\"{$key}\">" . $delim['name'] . "</option>\n";
}
?>
</select>
</div>
<div class="medium_label"><?php
echo $GLOBALS['locImportExportRowDelimiter'];
?>
</div>
<div class="field">
<select id="row_delim" name="row_delim">
<?php
$row_delims = $this->importer->get_row_delims();
foreach ($row_delims as $key => $delim) {
echo "<option value=\"{$key}\">" . $delim['name'] . "</option>\n";
}
?>
</select>
</div>
<div class="medium_label"><?php
echo $GLOBALS['locExportIncludeChildRows'];
?>
</div>
<div class="field">
<input id="child_rows" name="child_rows" type="checkbox" checked="checked">
</div>
<div class="medium_label"><?php
echo $GLOBALS['locExportIncludeDeletedRecords'];
?>
</div>
<div class="field">
<input id="deleted" name="deleted" type="checkbox">
</div>
<div class="medium_label"><?php
echo $GLOBALS['locExportColumns'];
?>
<input type="button" value="<?php
echo $GLOBALS['locExportAddAllColumns'];
?>
" onclick="add_all_columns()"></div>
<div id="columns" class="field">
</div>
<div class="form_buttons" style="clear: both">
<input type="submit" value="<?php
echo $GLOBALS['locExportDo'];
?>
">
</div>
</form>
</div>
<?php
}
