function writeRow($list, $keyOr = null)
{
?>
<ul>
<?php
foreach ($list as $key => $val) {
$id = str_replace(array('/', '.'), '', $keyOr . $val);
?>
<li>
<?php
if (is_array($val)) {
echo $key;
writeRow($val, $key . '/');
} else {
?>
<input type="checkbox" name="list[]" value="<?php
echo $keyOr . $val;
?>
" id="<?php
echo $id;
?>
">
<?php
echo content_tag('label', basename($val), array('for' => $id));
?>
<?php
}
?>
</li>
<?php
}
?>
</ul>
<?php
}
writeError(" API server failed to respond (Error {$errno}). Validate the server url : {$serverUrl} ");
writeLink("drop.php", "Drop Schema, Start Again");
return;
}
echo "<hr />";
writeLine("<h1>Step 5: Setting up initial data.</h1>");
$adminPassword = createRandomPassword();
$result = loadBasicData('ringside', $adminPassword, $database);
if ($result == true) {
writeLine(" Basic setup information and some sample data was written to the database.");
// writeLine( " Admin user name is <b>admin</b> and password is <b>$adminPassword</b>" );
writeLine(" The following example users were created as well, all with password <b>ringside</b>");
echo "<table cellpadding='4' width='80%'> ";
writeRow('*****@*****.**', '*****@*****.**', '*****@*****.**', 1);
writeRow('*****@*****.**', '*****@*****.**', '*****@*****.**', 2);
writeRow('*****@*****.**', '*****@*****.**', '*****@*****.**', 3);
echo "</table>";
} else {
writeError(" While everything seems to be setup we could not add the data to the database. <br />" . "<b>Maybe do some clean up of an old install/version first?</b>");
writeLink("drop.php", "Drop Schema, Start Again");
return;
}
$href = "";
if (isset($_SERVER['PATH_INFO'])) {
$href = "../" . $href;
}
echo "<hr />";
$successMessage = "You are configured <br />";
$successMessage .= "Login as administrator: <b>username</b> : admin <b>password</b>: {$adminPassword} <br />";
$successMessage .= "OR<br />";
$successMessage .= "Login with user <b>username</b> : joe@goringside.net <b>password</b>: ringside <br />";
function HandleExportData()
{
require_once "RubricsData.php";
require_once "FileUtils.php";
require_once "StrUtils.php";
require_once "Spreadsheet/Excel/Writer.php";
print " ";
clearOldFiles();
$rubrics = new RubricsData();
$expr = getExpr($rubrics);
if (!PEAR::isError($expr)) {
$res = $rubrics->getResults($expr);
}
if (PEAR::isError($expr) || PEAR::isError($res)) {
$_GLOBAL["msg"] = "Данных нет.";
include "templates/noresultsPopup.html";
exit;
}
if ($res->numRows() > 0) {
$headers = array("№ рубрики", "Название рубрики", "№ рубрики (источник)", "Урл рубрики", "№ компании (источник)", "Урл компании", "Название", "Адрес", "Метро", "Телефон", "Факс", "Сайт", "E-mail url", "E-mail", "Статус", "Дата изменения");
$tmpfname = tempnam("../tmpworksheets", "results") . ".xls";
chdir("../tmpworksheets");
$tmpfname = basename($tmpfname);
/*
$f = fopen($tmpfname, "w");
fwrite($f, '
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1251">
<style>
table {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9pt;
}
</style>
</head>
<table border=1 cellspacing=0 cellpadding=2>');
fwrite($f, "<tr><th>" . implode("</th><th>", $headers) . "</th></tr>\n");
while ($row = &$res->fetchRow(DB_FETCHMODE_ASSOC)) {
fwrite($f, "<tr><td>" . implode("</td><td>", getOrderedColumns($row)) . "</td></tr>\n");
}
fwrite($f, '</table></body></html>');
fclose($f);
*/
// fclose(fopen($tmpfname, "w"));
// NOTE неработает если указывать относительный путь
$workbook = new Spreadsheet_Excel_Writer($tmpfname);
//$workbook = new Spreadsheet_Excel_Writer();
//$workbook->send("results.xls");
$row =& $res->fetchRow(DB_FETCHMODE_ASSOC);
$worksheet =& $workbook->addWorksheet("список компаний");
$worksheet->setInputEncoding("windows-1251");
$format =& $workbook->addFormat(array("Bold" => true));
$rowNum = 0;
writeRow($worksheet, $rowNum, $headers, $format);
$rowNum++;
writeRow($worksheet, $rowNum, getOrderedColumns($row));
$rowNum++;
while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
writeRow($worksheet, $rowNum, getOrderedColumns($row));
$rowNum++;
}
$workbook->close();
chdir("../admin");
$tmpfname = "../tmpworksheets/{$tmpfname}";
if (!file_exists(realpath($tmpfname))) {
$_GLOBAL["msg"] = "Ошибка при создании файла.";
include "templates/noresultsPopup.html";
} else {
$_GLOBAL["link"] = $tmpfname;
include "templates/resultsPopup.html";
}
} else {
$_GLOBAL["msg"] = "Данных нет.";
include "templates/noresultsPopup.html";
}
}
<?php
function escapeField($field)
{
if (preg_match('/[",\\n]/', $field)) {
$field = preg_replace('/"/', "\\\"", $field);
//$field = preg_replace("/\n/", "\\n", $field);
$field = '"' . $field . '"';
}
return $field;
}
function writeRow($row)
{
$fields = array();
foreach ($row as $field) {
$fields[] = escapeField($field);
}
echo implode(",", $fields) . "\n";
}
$keys = explode(' ', "address company created description email geocode has_image name phone updated url");
writeRow($keys);
foreach ($entries->all as $entry) {
$row = array();
foreach ($keys as $key) {
$row[] = $entry->{$key};
}
writeRow($row);
}
function HandleExportData1()
{
session_start();
if (!isset($_SESSION["request"])) {
$_SESSION["request"] = $_REQUEST;
include "templates/startPopup.html";
exit;
}
$_REQUEST = $_SESSION["request"];
unset($_SESSION["request"]);
session_destroy();
require_once "RubricsData.php";
require_once "FileUtils.php";
require_once "StrUtils.php";
require_once "Spreadsheet/Excel/Writer.php";
print " ";
clearOldFiles();
$rubrics = new RubricsData();
$expr = getExpr($rubrics);
if (!PEAR::isError($expr)) {
$res = $rubrics->getResults($expr);
}
if (PEAR::isError($expr) || PEAR::isError($res)) {
exit;
}
if ($res->numRows() == 0) {
exit;
}
$headers = array("№ рубрики", "Название рубрики", "№ рубрики (источник)", "Урл рубрики", "№ компании (источник)", "Урл компании", "Название", "Адрес", "Метро", "Телефон", "Факс", "Сайт", "E-mail url", "E-mail", "Статус", "Дата изменения", "Район", "Округ");
$tmpfname = tempnam("../tmpworksheets", "results") . ".xls";
chdir("../tmpworksheets");
$tmpfname = basename($tmpfname);
// NOTE неработает если указывать относительный путь
$workbook = new Spreadsheet_Excel_Writer($tmpfname);
$row =& $res->fetchRow(DB_FETCHMODE_ASSOC);
$worksheet =& $workbook->addWorksheet("список компаний");
$worksheet->setInputEncoding("windows-1251");
$format =& $workbook->addFormat(array("Bold" => true));
$rowNum = 0;
writeRow($worksheet, $rowNum, $headers, $format);
$rowNum++;
writeRow($worksheet, $rowNum, getOrderedColumns($row));
$rowNum++;
while ($row =& $res->fetchRow(DB_FETCHMODE_ASSOC)) {
writeRow($worksheet, $rowNum, getOrderedColumns($row));
$rowNum++;
}
$workbook->close();
chdir("../admin");
$tmpfname = "../tmpworksheets/{$tmpfname}";
if (file_exists(realpath($tmpfname))) {
print $tmpfname;
}
}
