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; }
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]) { $excel->WriteText($row, $col, $language['Port']); $col++; } if ($_SESSION['network']['dlist']['col'][6]) {
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']); $col++; } if ($_SESSION['users']['list']['col'][9]) {
} 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']); $col++; } if ($_SESSION['accesspoints']['list']['col'][5]) {
} 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']); $col++; } if ($_SESSION['security'][$submodule]['col'][5]) {
// 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']); $row++; }
} 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']); $col++; } if ($_SESSION['groups']['list']['col'][5]) {