KumbiaPHP beta2-dev
Framework PHP en español
|
00001 <?php 00022 require_once LIBRARY_PATH.'excel/main.php'; 00032 function xls($result, $sumArray, $title, $weightArray, $headerArray){ 00033 00034 error_reporting(0); 00035 00036 $file = md5(uniqid()); 00037 $config = Config::read('config'); 00038 $active_app = Router::get_application(); 00039 00040 $workbook = new Spreadsheet_Excel_Writer("public/temp/$file.xls"); 00041 $worksheet =& $workbook->addWorksheet(); 00042 00043 $titulo_verdana =& $workbook->addFormat(array('fontfamily' => 'Verdana', 00044 'size' => 20)); 00045 $titulo_verdana2 =& $workbook->addFormat(array('fontfamily' => 'Verdana', 00046 'size' => 18)); 00047 00048 $workbook->setCustomColor(12, 0xF2, 0xF2, 0xF2); 00049 00050 $column_title =& $workbook->addFormat(array('fontfamily' => 'Verdana', 00051 'size' => 12, 00052 'fgcolor' => 12, 00053 'border' => 1, 00054 'bordercolor' => 'black', 00055 "halign" => 'center' 00056 )); 00057 00058 $column =& $workbook->addFormat(array( 'fontfamily' => 'Verdana', 00059 'size' => 11, 00060 'border' => 1, 00061 'bordercolor' => 'black', 00062 )); 00063 00064 $column_centered =& $workbook->addFormat(array( 'fontfamily' => 'Verdana', 00065 'size' => 11, 00066 'border' => 1, 00067 'bordercolor' => 'black', 00068 "halign" => 'center' 00069 )); 00070 00071 $worksheet->write(0, 0, strtoupper($config->$active_app->name), $titulo_verdana); 00072 $worksheet->write(1, 0, "REPORTE DE ".strtoupper($title), $titulo_verdana2); 00073 $worksheet->write(2, 0, "FECHA ".date("Y-m-d"), $titulo_verdana2); 00074 00075 for($i=0;$i<=count($headerArray)-1;$i++){ 00076 $worksheet->setColumn($i, $i, $weightArray[$i]); 00077 $worksheet->write(4, $i, $headerArray[$i], $column_title); 00078 } 00079 00080 $l = 5; 00081 foreach($result as $row){ 00082 for($i=0;$i<=count($row)-1;$i++){ 00083 if(!is_numeric($row[$i])){ 00084 $worksheet->writeString($l, $i, $row[$i], $column); 00085 } else { 00086 $worksheet->writeString($l, $i, $row[$i], $column_centered); 00087 } 00088 } 00089 $l++; 00090 } 00091 00092 $workbook->close(); 00093 00094 error_reporting(E_ALL ^ E_STRICT); 00095 00096 if(isset($raw_output)){ 00097 print "<script type='text/javascript'> window.open('".KUMBIA_PATH."temp/".$file.".xls', null); </script>"; 00098 } else { 00099 Generator::forms_print("<script type='text/javascript'> window.open('".KUMBIA_PATH."temp/".$file.".xls', null); </script>"); 00100 } 00101 00102 } 00103 00104 00105 ?>