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"); }