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