$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'Készítette:')->setCellValue('B1', $admin_username);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A2', 'Dátum:')->setCellValue('B2', $date_created);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A3', 'Riport intervallum:')->setCellValue('B3', $from_date)->setCellValue('C3', $to_date);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A5', 'Felhasználónév')->setCellValue('B5', 'Foglalás dátuma')->setCellValue('C5', 'Pálya')->setCellValue('D5', 'Összeg');
$objPHPExcel->getActiveSheet()->getStyle("A1:A3")->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle("A5:D5")->getFont()->setBold(true);
$row = 6;
foreach ($reservations as $res) {
$objPHPExcel->getActiveSheet()->setCellValue('A' . $row, $res->username)->setCellValue('B' . $row, $res->add_date)->setCellValue('C' . $row, $res->timeunit->court->name)->setCellValue('D' . $row, $res->price);
$row++;
}
$objPHPExcel->getActiveSheet()->setCellValue('A' . $row, 'Összesen:')->setCellValue('C' . $row, $ret['reservationsCount'] . ' db')->setCellValue('D' . $row, $ret['reservationsIncome'] . ' Ft');
$objPHPExcel->getActiveSheet()->getStyle("A" . $row . ":D" . $row)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle("C" . $row . ":D" . $row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$rnd = STRING::Random(10);
$bfn = 'report_' . $date_created_fn . '.xlsx';
$fn = 'reports/' . $bfn;
$objWriter->save($fn);
header('Content-disposition: filename="' . $bfn . '"');
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
echo file_get_contents($fn);
} else {
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
echo json_encode($ret);
}
} else {
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
echo json_encode($ret);
public function save()
{
if ($this->valid !== true) {
throw new UserNotValid("Please call is_valid() before saving!");
}
global $DB;
if ($this->reg_date == "") {
$this->activation_key = @STRING::Random(8);
}
$sql = '
INSERT INTO users
(`username`,`password`,`full_name`,`email`,`phone`,`birthday`,`discount`,`status`,`activation_key`,`reg_date`)
VALUES(:username,MD5(:password),:full_name,:email,:phone,:birthday,0,0,:activation_key,NOW())
ON DUPLICATE KEY UPDATE full_name=:full_name, phone=:phone, birthday=:birthday, discount=:discount
';
$sth = $DB->prepare($sql);
$sth->bindParam(':username', $this->username, PDO::PARAM_STR);
$sth->bindParam(':password', $this->password, PDO::PARAM_STR);
$sth->bindParam(':full_name', $this->full_name, PDO::PARAM_STR);
$sth->bindParam(':email', $this->email, PDO::PARAM_STR);
$sth->bindParam(':phone', $this->phone, PDO::PARAM_STR);
$sth->bindParam(':birthday', $this->birthday, PDO::PARAM_STR);
$sth->bindParam(':discount', $this->discount, PDO::PARAM_STR);
$sth->bindParam(':activation_key', $this->activation_key, PDO::PARAM_STR);
$sth->execute();
}
