if (!has_rights(ACX_CALL_REPORT) && !has_rights(ACX_CUSTOMER)) {
Header("HTTP/1.0 401 Unauthorized");
Header("Location: PP_error.php?c=accessdenied");
die();
}
getpost_ifset(array ( 'var_export', 'var_export_type' ));
if (strlen($var_export) == 0) {
$var_export = 'pr_sql_export';
}
# Set the parameters: SQL Query, hostname, databasename, dbuser and password
$dumpfile = new iam_csvdump;
# Call the CSV Dumping function and THAT'S IT!!!! A file named dump.csv is sent to the user for download
if (strlen($_SESSION[$var_export]) < 10) {
echo gettext("ERROR CSV EXPORT");
} else {
$log = new Logger();
if (strcmp($var_export_type, "type_csv") == 0) {
$myfileName = "Dump_" . date("Y-m-d");
$log->insertLog($_SESSION["admin_id"], 2, "FILE EXPORTED", "A File in CSV Format is exported by User, File Name= " . $myfileName . ".csv", '', $_SERVER['REMOTE_ADDR'], $_SERVER['REQUEST_URI'], '');
$dumpfile->dump($_SESSION[$var_export], $myfileName, "csv", DBNAME, USER, PASS, HOST, DB_TYPE);
}
elseif (strcmp($var_export_type, "type_xml") == 0) {
$myfileName = "Dump_" . date("Y-m-d");
$log->insertLog($_SESSION["admin_id"], 2, "FILE EXPORTED", "A File in XML Format is exported by User, File Name= " . $myfileName . ".xml", '', $_SERVER['REMOTE_ADDR'], $_SERVER['REQUEST_URI'], '');
<?php
include_once dirname(__FILE__) . "/lib/defines.php";
include_once dirname(__FILE__) . "/lib/Class.Table.php";
include_once dirname(__FILE__) . "/lib/iam_csvdump.php";
session_start();
# Set the parameters: SQL Query, hostname, databasename, dbuser and password #
#####################################################################################################################
$dumpfile = new iam_csvdump();
# Call the CSV Dumping function and THAT'S IT!!!! A file named dump.csv is sent to the user for download #
#####################################################################################################################
if (strlen($_SESSION["pr_sql_export"]) < 10) {
echo "ERROR CSV EXPORT";
} else {
//echo $_SESSION["pr_sql_export"];
$dumpfile->dump($_SESSION["pr_sql_export"], "Report_cdr_" . date("Y-m-d"), "csv", DBNAME, USER, PASS, HOST, DB_TYPE);
//$dumpfile->dump($_SESSION["pr_sql_export"], "", "csv", DBNAME, USER, PASS, HOST );
}
<?php
include "../lib/defines.php";
require_once "../lib/iam_csvdump.php";
include "../lib/module.access.php";
if (!has_rights(ACX_RATECARD)) {
Header("HTTP/1.0 401 Unauthorized");
Header("Location: PP_error.php?c=accessdenied");
die;
}
getpost_ifset(array('id_tp', 'export_style'));
# Set the parameters: SQL Query, hostname, databasename, dbuser and password #
#####################################################################################################################
$dumpfile = new iam_csvdump();
# Call the CSV Dumping function and THAT'S IT!!!! A file named dump.csv is sent to the user for download #
#####################################################################################################################
if (strlen($id_tp) < 1) {
echo gettext("ERROR CSV EXPORT");
} else {
$log = new Logger();
$DBHandle = DbConnect();
$export_fields = array('dialprefix', 'destination', 'rateinitial');
$sql_str = "ABORT;";
switch ($export_style) {
case 'peer-full-csv':
array_push($export_fields, 'buyrate', 'buyrateinitblock', 'buyrateincrement', 'rateinitial', 'initblock', 'billingblock', 'connectcharge', 'disconnectcharge', 'stepchargea', 'chargea', 'timechargea', 'billingblocka', 'stepchargeb', 'chargeb', 'timechargeb', 'billingblockb', 'stepchargec', 'chargec', 'timechargec', 'billingblockc');
$sql_str = str_dbparams($DBHandle, 'SELECT ' . implode(', ', $export_fields) . ' FROM cc_ratecard WHERE idtariffplan = %1;', array($id_tp));
$log_str = "Ratecard #%0 exported in csv format, all fields in peer format";
$myfileName = "Ratecard_" . $tp_id;
$prolog = "# Export of tp #{$id_tp}\n";
$prolog .= "#fields: " . implode(';', $export_fields) . "\n";
<?php
include_once "common/iam_csvdump.php";
require_once 'functions.php';
$amp_conf = parse_amportal_conf("/etc/amportal.conf");
$dbhost = $amp_conf['AMPDBHOST'];
$dbname = $amp_conf['AMPDBNAME'];
$dbuser = $amp_conf['AMPDBUSER'];
$dbpw = $amp_conf['AMPDBPASS'];
$dumpfile = new iam_csvdump();
$query = "(select data from sip where keyword = 'callerid') UNION (select data from iax where keyword = 'callerid') UNION (select data from zap where keyword = 'callerid') ORDER BY data ASC";
$dumpfile->dump($query, "local_extensions_" . date("d-m-Y"), "csv", $dbname, $dbuser, $dbpw, $dbhost, "mysql");
