Hello orik3ll0,
>> 1. ...
>> Have u got some example how to integrate PHPExcel to osticket?
Yes ...
Download PHPExcel (Used: PHPExcel 1.8.0) and save it in:
\upload\phpexcel
Result:
\upload\phpexcel
\upload\phpexcel\Classes
\upload\phpexcel\Classes\PHPExcel
\upload\phpexcel\Classes\PHPExcel.php
Change the owner and the permissions:
chown -R www-data-data \upload\phpexcel\
chmod 755 -R \upload\phpexcel\
Edit only: \upload\include\ajax.reports.php
// my mod
function downloadTabularData()
{
$data = $this->getData();
/** PHPExcel */
include '../phpexcel/Classes/PHPExcel.php';
/** PHPExcel_Writer_Excel2007 */
include '../phpexcel/Classes/PHPExcel/Writer/Excel2007.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("citrixraptor");
// Optionally, set the title of the Sheet
$objPHPExcel->getActiveSheet()->setTitle('Department Statistics');
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('B1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('C1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('D1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('E1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('F1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('G1', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('H1', $data);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment:);
$objPHPExcel->getActiveSheet()->SetCellValue('A2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('B2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('C2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('D2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('E2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('F2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('G2', $data);
$objPHPExcel->getActiveSheet()->SetCellValue('H2', $data);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="Department_Statistics.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory:($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
}
// my mod
Please keep in mind this is a example! ... only the first line of:
Department, Topics and Agent will be exported! ... but it works :-)
in the default osticket installation: v1.9.14 (8b927a0)
The lines for $data); and $data are hardcoded!!! and other var's are hardcoded .... the playground is open :-)
Hope it helps ...
>>2) i have one more question. I use LDAP and we have many departments. I want to >> see count of created tickets of departments and exact person(to compare which
>> department create more tickets). Is it possible?
Hm ... please create a "dummy" Excel Example ... What do you want show?
Best Regards
citrixraptor