code

code

ini_set ('display_errors', 1);
require_once (PHPExcel.php);
require_once (PHPExcel / IOFactory.php);
include_once (../../../ wp-load.php);
$ objPHPExcel = nieuwe PHPExcel ();
globale $ wpdb;
// $ objPHPExcel-> getActiveSheet ();

$ objPHPExcel-> setActiveSheetIndex (0) -> setCellValue ('A1', 'Donatierapporten');
$ objPHPExcel-> setActiveSheetIndex (0) -> mergeCells ('A1: C1', ");
$ objPHPExcel-> setActiveSheetIndex (0) -> setCellValue ('A2', 'SI');
$ objPHPExcel-> setActiveSheetIndex (0) -> setCellValue ('B2', 'Project');
$ objPHPExcel-> setActiveSheetIndex (0) -> setCellValue ('C2', 'Subproject');
$ objPHPExcel-> setActiveSheetIndex (0) -> setCellValue ('D2', 'Locatie');
$ objPHPExcel-> setActiveSheetIndex (0) -> setCellValue ('E2', 'Total');

$ bestand = 'Donatie'. tijd (). '.xlsx'; //
// $ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'Excel2007');
// $ objWriter-> save ("upload / excelsheet /". $ bestand);
// Werkblad hernoemen
$ objPHPExcel-> getActiveSheet () -> setTitle ('Price Matrix');

// Stel actieve bladindex in op het eerste blad, dus Excel opent dit als het eerste blad
$ ObjPHPExcel-> setActiveSheetIndex (0);

$ startdate = $ _REQUEST ['exportstartdate']. ' 00: 00: 00 ';
$ enddate = $ _REQUEST ['exportenddatum']. ' 00: 00: 00 ';

$ queryexport = ("SELECT". $ wpdb-> prefix. "user_donating. *,". $ wpdb-> prefix. "selecties. *, sum (". $ wpdb-> prefix. "user_donating.total_amt) als totalamount FROM ". $ Wpdb-> prefix." User_donating LEFT JOIN ". $ Wpdb-> prefix." Selecties AAN ". $ Wpdb-> prefix." User_donating.selection_id = ". $ Wpdb-> prefix." Selections.uniqetime_id WHERE posted_date tussen '". $ startdate."' AND '". $ enddate."' GROUP per project, sub_project, locatie ");

$ result = mysql_query ($ queryexport);
$ header = ";
$ i = 3;
$ j = 1;

while ($ row = mysql_fetch_array ($ result)) {
$ objPHPExcel-> getActiveSheet () -> SetCellValue ('A'. $ i, $ j);
$ objPHPExcel-> getActiveSheet () -> SetCellValue ('B'. $ i, $ row ['project']);
$ objPHPExcel-> getActiveSheet () -> SetCellValue ('C'. $ i, $ row ['sub_project']);
$ objPHPExcel-> getActiveSheet () -> SetCellValue ('D'. $ i, $ row ['location']);
$ objPHPExcel-> getActiveSheet () -> SetCellValue ('E'. $ i, '£' .number_format ($ row ['totalamount'], 2));

$ I ++;
$ J ++;
}

$ objWriter = PHPExcel_IOFactory :: createWriter ($ objPHPExcel, 'Excel2007');
$ objWriter-> save ("upload / excelsheet /". $ bestand);
$ file_url = 'upload / excelsheet /'.$-bestand;

header ('Inhoudstype: application / vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header ("Content-Disposition: attachment; bestandsnaam =". $ file);
header ("Cache-Control: must-revalidate, post-check = 0, pre-check = 0");
ob_end_clean ();
readfile ($ FILE_URL);
Uitgang;

?>

HULP NODIG? Klik hier voor de online help