function ExcelOutput($query = "")
{
//connect mysql database
mysql_select_db($this->db_name, $this->db_link);
//get result
$result = mysql_query($query);
$numoffields = mysql_num_fields($result);
// now we could construct Excel output
$fieldstype = array();
for ($i = 0; $i < $numoffields; $i++) {
$fieldstype[] = mysql_field_type($result, $i);
}
// for($i=0;...) END
//create new instance of ExcelGen() class
$excel = new ExcelGen("Sql2Excel");
//initiate a counter for excel "ROW" counter
$rowscounter = 0;
//write fields to excel
for ($i = 0; $i < $numoffields; $i++) {
$fld = mysql_fetch_field($result, $i);
$fldname = $fld->name;
$excel->WriteText($rowscounter, $i, $fldname);
}
// for($i=0;...) END
$rowscounter++;
while ($row = mysql_fetch_array($result)) {
//fetch each Cell($rowscounter,$colscounter) into Excel output stream
for ($colscounter = 0; $colscounter < $numoffields; $colscounter++) {
//identify field type to descide how to write excel cell
if (eregi("(int)", $fieldstype[$colscounter])) {
$excel->WriteNumber($rowscounter, $colscounter, $row[$colscounter]);
} else {
$excel->WriteText($rowscounter, $colscounter, $row[$colscounter]);
}
}
//for($colscounter..) END
$rowscounter++;
}
// while($row=mysql..) END
$excel->SendFile();
return;
}
$list .= "\"" . $tab['ldap_base'] . "\";";
}
$list .= "\n";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"" . $filename . "\";");
header("Content-Transfer-Encoding: binary");
echo $list;
}
// Export to Excel
if ($ext == 'xls') {
$excel = new ExcelGen($filename);
$row = $col = 0;
//if($_SESSION['network']['dlist']['col'][0]) { $excel->WriteText($row, $col, $language['Status']); $col++; }
if ($_SESSION['network']['dlist']['col'][2]) {
$excel->WriteText($row, $col, $language['DataSourceName']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][3]) {
$excel->WriteText($row, $col, $language['DataSourceType']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][4]) {
$excel->WriteText($row, $col, $language['Hostname']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][5]) {
}
$list .= "\n";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
//header ("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"" . $filename . "\";");
header("Content-Transfer-Encoding: binary");
echo $list;
}
// Export to Excel
if ($ext == 'xls') {
$excel = new ExcelGen($filename);
$row = $col = 0;
if ($_SESSION['users']['list']['col'][6]) {
$excel->WriteText($row, $col, 'id');
$col++;
}
if ($_SESSION['users']['list']['col'][2]) {
$excel->WriteText($row, $col, $language['User']);
$col++;
}
if ($_SESSION['users']['list']['col'][4]) {
$excel->WriteText($row, $col, $language['UserName']);
$col++;
}
if ($_SESSION['users']['list']['col'][8]) {
$excel->WriteText($row, $col, $language['Group']);
$list .= "\"" . $updated . "\";";
}
$list .= "\n";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"" . $filename . "\";");
header("Content-Transfer-Encoding: binary");
echo $list;
}
// Export to Excel
if ($ext == 'xls') {
$excel = new ExcelGen($filename);
$row = $col = 0;
if ($_SESSION['accesspoints']['list']['col'][4]) {
$excel->WriteText($row, $col, 'id');
$col++;
}
if ($_SESSION['accesspoints']['list']['col'][4]) {
$excel->WriteText($row, $col, $language['Name']);
$col++;
}
if ($_SESSION['accesspoints']['list']['col'][2]) {
$excel->WriteText($row, $col, $language['Node']);
$col++;
}
if ($_SESSION['accesspoints']['list']['col'][3]) {
$excel->WriteText($row, $col, $language['Path']);
$list .= "\"" . sumo_get_human_date($tab['time'], true, true) . "\";";
}
$list .= "\n";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"" . $filename . "\";");
header("Content-Transfer-Encoding: binary");
echo $list;
}
// Export to Excel
if ($ext == 'xls') {
$excel = new ExcelGen($filename);
$row = $col = 0;
if ($_SESSION['security'][$submodule]['col'][3]) {
$excel->WriteText($row, $col, 'id');
$col++;
}
if ($_SESSION['security'][$submodule]['col'][3]) {
$excel->WriteText($row, $col, $language['Priority']);
$col++;
}
if ($_SESSION['security'][$submodule]['col'][3]) {
$excel->WriteText($row, $col, $language['Code']);
$col++;
}
if ($_SESSION['security'][$submodule]['col'][4]) {
$excel->WriteText($row, $col, $language['Node']);
$list .= "\"" . $tab['usergroup'] . "\";\"" . $users . "\";\n";
}
// bugfix
$list = str_replace(", \";", "\";", $list);
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"" . $filename . "\";");
header("Content-Transfer-Encoding: binary");
echo $list;
}
// Export to Excel
if ($ext == 'xls') {
$excel = new ExcelGen($filename);
$row = $col = 0;
$excel->WriteText($row, $col, $language['GroupName']);
$col++;
$excel->WriteText($row, $col, $language['UsersList']);
while ($tab = $rs->FetchRow()) {
$col = 0;
$row++;
$excel->WriteText($row, $col, $tab['usergroup']);
$query = "SELECT id,username,firstname,lastname\n\t\t\t\t FROM " . SUMO_TABLE_USERS . "\n\t\t\t\t WHERE (usergroup LIKE '" . $tab['usergroup'] . ":%' \n\t\t\t\t\t\t OR usergroup LIKE '%;" . $tab['usergroup'] . ":%'\n\t\t\t\t\t\t OR usergroup LIKE 'sumo:%'\n\t\t\t\t\t\t OR usergroup LIKE '%;sumo:%')\n\t\t\t\t AND active=1 \n\t\t\t\t AND username<>'sumo'\n\t\t\t\t ORDER BY username, lastname, firstname";
$rs2 = $SUMO['DB']->Execute($query);
while ($tab2 = $rs2->FetchRow()) {
$col = 1;
$excel->WriteText($row, $col, $tab2['user']);
$col++;
$excel->WriteText($row, $col, $tab2['lastname'] . " " . $tab2['firstname']);
$list .= "\"" . $created . "\";";
}
$list .= "\n";
}
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private", false);
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"" . $filename . "\";");
header("Content-Transfer-Encoding: binary");
echo $list;
}
// Export to Excel
if ($ext == 'xls') {
$excel = new ExcelGen($filename);
$row = $col = 0;
if ($_SESSION['groups']['list']['col'][2]) {
$excel->WriteText($row, $col, 'id');
$col++;
}
if ($_SESSION['groups']['list']['col'][2]) {
$excel->WriteText($row, $col, $language['Groups']);
$col++;
}
if ($_SESSION['groups']['list']['col'][3]) {
$excel->WriteText($row, $col, $language['Description']);
$col++;
}
if ($_SESSION['groups']['list']['col'][100]) {
$excel->WriteText($row, $col, $language['Users']);
