$rowCount++;
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $times[1]);
$rowCount++;
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $times[2]);
$colCount = 1;
//populate the colums with data
foreach ($days as $day) {
$rowCount = 3;
foreach ($slots as $slot) {
$group_string = "";
$sql_group = "SELECT groups.id_group, topics.subject, topics.grade FROM topics\n\t\t\t\t\t\t\t\t\t\t\tJOIN groups ON groups.id_topic = topics.id_topic\n\t\t\t\t\t\t\t\t\t\t\tJOIN slots ON topics.id_slot = slots.id_slot\n\t\t\t\t\t\t\t\t\t\t\tWHERE slots.day = '{$day}' AND slots.slot = {$slot} AND groups.id_room = " . $room['id_room'] . ";";
$groups = get_sql_result($sql_group);
$group = mysqli_fetch_assoc($groups);
if ($group['grade']) {
//<---- find the right function
$group_string = "Klasse: " . $group['grade'] . " " . $group['subject'] . "\n\nTeilnehmer:";
echo $group_string;
$sql_students = "SELECT firstname, lastname FROM students\n\t\t\t\t\t\t\t\t\t\t\t\t\tJOIN students_groups ON students.id_student = students_groups.id_student\n\t\t\t\t\t\t\t\t\t\t\t\t\tJOIN groups ON groups.id_group = students_groups.id_group\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE groups.id_group = '" . $group['id_group'] . "';";
$students = get_sql_result($sql_students);
while ($student = mysqli_fetch_assoc($students)) {
$group_string = $group_string . "\n" . $student['firstname'] . " " . $student['lastname'];
}
$objPHPExcel->getActiveSheet()->SetCellValue($cells[$colCount] . $rowCount, $group_string);
}
$rowCount++;
}
$colCount++;
}
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('../../lists/Raumbelegungsplan.xlsx');
<?php
$objPHPExcel->getProperties()->setTitle("Statistik")->setSubject("Ferienschule")->setDescription("Zahlen und Daten");
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$grades = array(6, 7, 8, 9, 10);
$students_total = get_sql_result("SELECT COUNT(*) from students");
foreach ($grades as $grade) {
$students_per_grade = get_sql_result("SELECT COUNT(*) WHERE grade = {$grade}");
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('../../lists/Statistik.xlsx');
<?php
$objPHPExcel->getProperties()->setTitle("Emailadressen")->setSubject("Ferienschule")->setDescription("Liste mit den Mailadressen aller Angemeldeten Schüler");
$sql = "SELECT students.lastname, students.firstname, students.email\n\tFROM students\n\torder by students.lastname, students.firstname;";
$result = get_sql_result($sql);
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$rowCount = 1;
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, 'Nachname');
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, 'Vorname');
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, 'Email');
while ($row = mysqli_fetch_array($result)) {
$rowCount++;
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $row['0']);
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $rowCount, $row['1']);
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $rowCount, $row['2']);
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('../../lists/Mailadressen.xlsx');
$isalter = 1;
}
update_order_res($_POST['orid'], $prod, $isalter);
header("location:" . $_SERVER['HTTP_REFERER']);
}
if (isset($_POST['deleter'])) {
delete_order_res($_POST['orid']);
header("location:" . $_SERVER['HTTP_REFERER']);
}
if (isset($_POST['execsql'])) {
$sql = $_POST['query'];
$lnk = dbConnect('', '', '');
$res = exec_query($sql);
$add = "";
if (strtolower(substr($sql, 0, strpos($sql, ' '))) == 'select') {
$add = get_sql_result($res);
}
dbDisconnect($lnk);
$body = get_sql_form($sql) . $add;
$finish = true;
}
if (isset($_GET['mode'])) {
$finish = false;
$mode = 1;
if ($_GET['mode'] == 'orddetail') {
$isauth = is_auth();
if ($isauth) {
$body = get_order_details($_GET['id']);
} else {
$body = pageBody(1);
}
