$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); } } else { $courts = Court::get_all(); $smarty->assign('courts', $courts); if ($_GET['did']) { $smarty->assign('default_user', $_GET['did']); } $from_date = date('Y-m-01'); $to_date = date('Y-m-d'); $smarty->assign('from_date', $from_date); $smarty->assign('to_date', $to_date); $smarty->display('admin-report.tpl'); }
public static function get_day_timeunits($date, $user = null) { global $DB; $courts = Court::get_all(); $sql = ' SELECT * FROM timeunits WHERE date=:date ORDER BY `date`, `from` '; $sth = $DB->prepare($sql); $sth->bindParam(':date', $date, PDO::PARAM_STR); $sth->execute(); $timeunits = array(); foreach ($sth->fetchAll() as $tmp) { $timeunit = new TimeUnit($tmp, false); $timeunit->user = $user; if (!is_array($timeunits[$timeunit->court_id])) { $timeunits[$timeunit->court_id] = array(); } $timeunits[$timeunit->court_id][] = $timeunit; } $ret = array(); $ret['date'] = $date; $ret['fields'] = array(); $i = 0; foreach ($courts as $court) { $j = 0; $ret['fields'][$i] = array(); $ret['fields'][$i]['id'] = $court->id; $ret['fields'][$i]['title'] = $court->name; $ret['fields'][$i]['subtitle'] = $court->subtitle; $ret['fields'][$i]['intervals'] = array(); if (is_array($timeunits[$court->id])) { foreach ($timeunits[$court->id] as $timeunit) { $ret['fields'][$i]['intervals'][$j] = $timeunit->get_array(); $j++; } } $i++; } return $ret; }