function intShowAddUserSaveCSV($add_user_save_id, $csv)
{
$csv = new CSVGenerator($csv);
$csv->sendHeader("add_user_save_{$add_user_save_id}.csv");
$info = intGetAddUserSaveInfo($add_user_save_id);
foreach ($info["details"][0] as $idx => $user_id) {
$csv->doLine($user_id, $info["details"][1][$idx], $info["details"][2][$idx]);
}
}
function intDownloadPrefixes(&$smarty, $tariff_name, $separator)
{
$req = new GetTariffInfo($tariff_name, TRUE);
$resp = $req->sendAndRecv();
if ($resp->isSuccessful()) {
$result = $resp->getResult();
$csv = new CSVGenerator($separator);
$csv->sendHeader("voip_tariff_{$tariff_name}.csv");
foreach ($result["prefixes"] as $prefix) {
$csv->doLine($prefix["prefix_name"], $prefix["prefix_code"], $prefix["cpm"], $prefix["free_seconds"], $prefix["min_duration"], $prefix["round_to"]);
}
} else {
$resp->setErrorInSmarty($smarty);
intShowTariffInfo($smarty, $tariff_name);
}
}
$I = -1;
foreach ($Data as $Item) {
$I++;
$II = -1;
foreach ($Item as $K => $V) {
$II++;
// Manipulate value if needed
if (isset($ColumnCommands[$K]) && isset($ColumnCommands[$K]["join"])) {
$V = $DB->QuerySingle("SELECT " . $ColumnCommands[$K]["join"][1] . " FROM " . $ColumnCommands[$K]["join"][0] . " WHERE id=:id", array("id" => $Item[$K]));
$V = $V[$ColumnCommands[$K]["join"][1]];
}
if (strlen($V) > 60) {
$V = substr($V, 0, 57) . "...";
}
$V = strip_tags($V);
$Rows[$I][$K] = $V;
}
}
// Generate CSV
if (count($Rows) > 0) {
$Headings = array_keys($Rows[0]);
$CSVGenerator = new CSVGenerator();
if (isset($_GET["param_1"]) && $_GET["param_1"] == "test") {
$CSVGenerator->TestMode = true;
}
$CSVGenerator->Headings = $Headings;
$CSVGenerator->Rows = $Rows;
$CSVGenerator->Generate();
} else {
die("No rows to export");
}
