calendar_xls.php File Reference

Functions
	getDayOfWeekStr ($dayOfWeekNumber)

Variables
	$startYear = '2025'
	$endYear = '2026'
	$titleString = "Spieltermine_" . $startYear . "_" . $endYear
	$filename = "/var/www/ehc-troisdorf/xls/" . $titleString . ".xlsx"
	$relativePath = str_replace('/var/www/ehc-troisdorf', '..', $filename)
	$spreadsheet = new Spreadsheet()
	$sheet = $spreadsheet->getActiveSheet()
for($i=0; $i< 9; $i++)	$format_title
	$drawing1 = new Drawing()
	$drawing2 = new Drawing()
	$format_header
	$months = ['August', 'September', 'Oktober', 'November', 'Dezember', 'Januar', 'Februar', 'März', 'April']
for($i=0; $i< count($months); $i++)	$commonFont
	$weekendBackground
	$holidayBackground
	$dayBackground
	$month_array = []
for($year=(int) $startYear; $year<=(int) $endYear; $year++)	$game_stmt = $mysqli->prepare("SELECT get_xls_content(?) AS game_content")
	$holiday_stmt = $mysqli->prepare("SELECT icedome.isHoliday(?) AS holiday")
	$zeile = 4
	$lines_num = 0
for( $day=1;$day<=31;$day++) if(is_writable(dirname($filename)))	else

Function Documentation

getDayOfWeekStr()

getDayOfWeekStr

(

$dayOfWeekNumber

)

Variable Documentation

$commonFont

for ( $i=0;$i< count( $months);$i++) $commonFont

(

)

Initial value:

= [
    'font' => [
        'name' => 'Aptos Narrow',  
        'size' => 11,              
    ],
    'alignment' => [
        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT,  
        'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP,    
        'wrapText' => true,  
    ],
]

$dayBackground

$dayBackground

Initial value:

= [  
    'fill' => [
        'fillType' => Fill::FILL_NONE,
    ],
]

$drawing1

$drawing1 = new Drawing()

$drawing2

$drawing2 = new Drawing()

$endYear

$endYear = '2026'

$filename

$filename = "/var/www/ehc-troisdorf/xls/" . $titleString . ".xlsx"

$format_header

$format_header

Initial value:

= [
    'font' => [
        'bold' => true,
        'name' => 'Aptos Narrow',
        'size' => 11,
    ],
    'alignment' => [
        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
        'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
    ],
    'fill' => [
        'fillType' => Fill::FILL_SOLID,
        'startColor' => ['rgb' => 'ADD8E6'],  
    ],
]

$format_title

for ( $i=0;$i< 9;$i++) $format_title

(

)

Initial value:

=[
    'font' => [
        'bold' => false,
        'name' => 'Aptos Narrow',
        'size' => 26,
    ],
    'alignment' => [
        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
        'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
    ],
]

$game_stmt

for ( $year=(int) $startYear;$year<=(int) $endYear;$year++) $game_stmt = $mysqli->prepare("SELECT get_xls_content(?) AS game_content")

$holiday_stmt

$holiday_stmt = $mysqli->prepare("SELECT icedome.isHoliday(?) AS holiday")

$holidayBackground

$holidayBackground

Initial value:

= [
    'fill' => [
        'fillType' => Fill::FILL_SOLID,
        'startColor' => ['rgb' => '4EA72E'],  
    ],
]

$lines_num

$lines_num = 0

$month_array

$month_array = []

$months

$months = ['August', 'September', 'Oktober', 'November', 'Dezember', 'Januar', 'Februar', 'März', 'April']

$relativePath

$relativePath = str_replace('/var/www/ehc-troisdorf', '..', $filename)

$sheet

$sheet = $spreadsheet->getActiveSheet()

$spreadsheet

$spreadsheet = new Spreadsheet()

$startYear

$startYear = '2025'

$titleString

$titleString = "Spieltermine_" . $startYear . "_" . $endYear

$weekendBackground

$weekendBackground

Initial value:

= [
    'fill' => [
        'fillType' => Fill::FILL_SOLID,
        'startColor' => ['rgb' => 'FFFF00'],  
    ],
]

$zeile

$zeile = 4

else

for($day=1; $day<=31; $day++) if (is_writable(dirname( $filename))) else

Initial value:

{
    echo "<br>Error: Cannot write to directory " . dirname($filename)