'; var_dump($events_RET); echo ''; foreach ( (array) $_REQUEST['food_service'] as $school_date => $description ) { if ( ! empty( $events_RET[$school_date] ) ) { if ( ! empty( $description['text'] ) || ! empty( $description['select'] ) ) { DBQuery( "UPDATE CALENDAR_EVENTS SET DESCRIPTION='" . $description['text'] . $description['select'] . "' WHERE ID='" . $events_RET[$school_date][1]['ID'] . "'" ); } else { DBQuery( "DELETE FROM CALENDAR_EVENTS WHERE ID='" . $events_RET[$school_date][1]['ID'] . "'" ); } } elseif ( ! empty( $description['text'] ) || ! empty( $description['select'] ) ) { DBQuery( "INSERT INTO CALENDAR_EVENTS (ID,SYEAR,SCHOOL_ID,SCHOOL_DATE,TITLE,DESCRIPTION) VALUES(" . db_seq_nextval( 'calendar_events_id_seq' ) . ",'" . UserSyear() . "','" . UserSchool() . "','" . $school_date . "','" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "','" . $description['text'] . issetVal( $description['select'], '' ) . "')" ); } } // Unset food_service & redirect URL. RedirectURL( 'food_service' ); } if ( ! empty( $_REQUEST['submit']['print'] ) ) { $events_RET = DBGet( "SELECT TITLE,DESCRIPTION,SCHOOL_DATE FROM CALENDAR_EVENTS WHERE SCHOOL_DATE BETWEEN '" . date( 'Y-m-d', $time ) . "' AND '" . date( 'Y-m-d', $time_last ) . "' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND (TITLE='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' OR TITLE='No School')", array(), array( 'SCHOOL_DATE' ) ); $skip = date( "w", $time ); echo '
'; if ( ! empty( $_REQUEST['_ROSARIO_PDF'] ) ) { // Landscape PDF. $_SESSION['orientation'] = 'landscape'; if ( is_file( 'assets/dailymenu' . UserSchool() . '.jpg' ) ) { echo ''; } else { echo ''; } } //FJ display locale with strftime() echo '


' . SchoolInfo( 'TITLE' ) . '
' . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . '	' . ProperDate( date( 'Y-m-d', mktime( 0, 0, 0, $_REQUEST['month'], 1, $_REQUEST['year'] ) ) ) . '	' . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . '

'; echo ''; echo '' . '' . '' . '' . '' . '' . ''; echo ''; if ( $skip ) { echo ''; } for ( $i = 1; $i <= $last; $i++ ) { if ( $skip % 7 == 0 ) { echo ''; } $day_time = mktime( 0, 0, 0, $_REQUEST['month'], $i, $_REQUEST['year'] ); $date = date( 'Y-m-d', $day_time ); $day_classes = ''; // Thursdays, Fridays, Saturdays. if ( ( $i + 1 ) % 7 === 0 || ( $i + 1 ) % 7 > 4 ) { $day_classes .= ' thu-fri-sat'; } $day_inner_classes = 'width-100p'; if ( ! empty( $events_RET[$date] ) ) { $day_inner_classes .= ' hover'; } $day_number_classes = 'number'; // Bold class if ( ! empty( $events_RET[$date] ) || ! empty( $assignments_RET[$date] ) ) { $day_number_classes .= ' bold'; } echo ''; $skip++; if ( $skip % 7 == 0 ) { echo ''; } } if ( $skip % 7 != 0 ) { echo ''; } echo '

' . _( 'Sunday' ) . '

' . _( 'Monday' ) . '

' . _( 'Tuesday' ) . '

' . _( 'Wednesday' ) . '

' . _( 'Thursday' ) . '

' . _( 'Friday' ) . '

' . _( 'Saturday' ) . '

'; echo '

' . $i . '

'; } else { $description_select = ''; if ( AllowEdit() ) { $description_RET = DBGet( "SELECT DISTINCT DESCRIPTION FROM CALENDAR_EVENTS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND TITLE='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' AND DESCRIPTION IS NOT NULL ORDER BY DESCRIPTION" ); if ( ! empty( $description_RET ) ) { $description_select .= ''; foreach ( (array) $description_RET as $description ) { $description_select .= ''; } $description_select .= ''; } } $calendar_RET = DBGet( "SELECT SCHOOL_DATE FROM ATTENDANCE_CALENDAR WHERE SCHOOL_DATE BETWEEN '" . date( 'Y-m-d', $time ) . "' AND '" . date( 'Y-m-d', $time_last ) . "' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND CALENDAR_ID='" . $calendar_id . "' AND MINUTES>0 ORDER BY SCHOOL_DATE", array(), array( 'SCHOOL_DATE' ) ); $events_RET = DBGet( "SELECT ID,TITLE,DESCRIPTION,SCHOOL_DATE FROM CALENDAR_EVENTS WHERE SCHOOL_DATE BETWEEN '" . date( 'Y-m-d', $time ) . "' AND '" . date( 'Y-m-d', $time_last ) . "' AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND TITLE='" . $menus_RET[$_REQUEST['menu_id']][1]['TITLE'] . "' ORDER BY SCHOOL_DATE", array( 'DESCRIPTION' => 'makeDescriptionInput', 'SCHOOL_DATE' => 'ProperDate' ) ); $events_RET[0] = array(); // make sure indexing from 1 foreach ( (array) $calendar_RET as $school_date => $value ) { $events_RET[] = array( 'ID' => '', 'SCHOOL_DATE' => ProperDate( $school_date ), 'DESCRIPTION' => TextInput( '', 'food_service[' . $school_date . '][text]', '', 'size=20' ) . ( $description_select ? '