$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);
/** * Smarty lower modifier plugin * * Type: modifier<br> * Name: price<br> * Purpose: convert string to price * @param string * @return string */ function smarty_modifier_price($string) { return STRING::moneyString($string); }
public static function decodeArray($array) { $value = array(); $keys = array_keys($array); for ($i = 0; $i < count($keys); $i++) { $key = $keys[$i]; $value[$key] = STRING::decode(strval($array[$key])); } return $value; }
/** * Smarty lower modifier plugin * * Type: modifier<br> * Name: price<br> * Purpose: convert string to price * @param string * @return string */ function smarty_modifier_floatprice($string) { return STRING::floatMoneyString($string); }
public function generate_password() { global $DB; $pass = @STRING::RandomPass(8); $sth = $DB->prepare('UPDATE users SET password=MD5(:password) WHERE username=:username'); $sth->bindParam(':password', $pass, PDO::PARAM_STR); $sth->bindParam(':username', $this->username, PDO::PARAM_STR); $sth->execute(); return $pass; }