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