コード例 #1
0
         $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);
コード例 #2
0
/**
 * 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);
}
コード例 #3
0
 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;
 }
コード例 #4
0
/**
 * 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);
}
コード例 #5
0
 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;
 }