".date('M d, Y',$start).' - '.date('M d, Y',$end).''; $date_select = '' . ProperDate( date( 'Y-m-d', $start ) ) . ' - ' . ProperDate( DBDate() ) . ''; //exit(var_dump($begin_year)); for ( $i = $start - ( 60 * 60 * 24 * 7 ); $i >= $begin_year; $i -= ( 60 * 60 * 24 * 7 ) ) // $date_select .= "=$start_time && $i-86400<=$start_time)?' selected':'').">".date('M d, Y',$i).' - '.date('M d, Y',($i+1+(($END_DAY-$START_DAY))*60*60*24)).''; { $date_select .= '= $start_time && $i - 86400 <= $start_time ) ? ' selected' : '' ) . ">" . ProperDate( date( 'Y-m-d', $i ) ) . ' - ' . ProperDate( date( 'Y-m-d', ( $i + 1 + ( ( $END_DAY - $START_DAY ) ) * 60 * 60 * 24 ) ) ) . ''; } $date_select = '' . $date_select . ''; echo '

'; DrawHeader( $date_select . ' ' . SubmitButton( _( 'Go' ) ) ); echo '

'; $RET = DBGet( "SELECT em.STUDENT_ID,em.ACTIVITY_ID,ea.TITLE,ea.START_DATE,ea.END_DATE FROM ELIGIBILITY_ACTIVITIES ea,STUDENT_ELIGIBILITY_ACTIVITIES em WHERE em.SYEAR='" . UserSyear() . "' AND em.STUDENT_ID='" . UserStudentID() . "' AND em.SYEAR=ea.SYEAR AND em.ACTIVITY_ID=ea.ID ORDER BY ea.START_DATE", array( 'START_DATE' => 'ProperDate', 'END_DATE' => 'ProperDate' ) ); $activities_RET = DBGet( "SELECT ID,TITLE FROM ELIGIBILITY_ACTIVITIES WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'" ); foreach ( (array) $activities_RET as $value ) { $activities[$value['ID']] = $value['TITLE']; } $link['remove']['link'] = 'Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=remove&start_date=' . issetVal( $_REQUEST['start_date'], '' ); $link['remove']['variables'] = array( 'activity_id' => 'ACTIVITY_ID' ); //FJ css WPadmin // $link['add']['html']['TITLE'] = '

'.SelectInput('','new_activity','',$activities).'

'; // $link['add']['html']['remove'] = button('add'); $link['add']['html'] = array( 'remove' => button( 'add' ), 'TITLE' => SelectInput( '', 'new_activity', '', $activities ) . SubmitButton( _( 'Add' ) ), 'START_DATE' => ' ', 'END_DATE' => ' ', ); echo '

'; $columns = array( 'TITLE' => _( 'Activity' ), 'START_DATE' => _( 'Starts' ), 'END_DATE' => _( 'Ends' ), ); ListOutput( $RET, $columns, 'Activity', 'Activities', $link ); echo '

'; $RET = DBGet( "SELECT e.ELIGIBILITY_CODE,c.TITLE as COURSE_TITLE FROM ELIGIBILITY e,COURSES c,COURSE_PERIODS cp WHERE e.STUDENT_ID='" . UserStudentID() . "' AND e.SYEAR='" . UserSyear() . "' AND e.COURSE_PERIOD_ID=cp.COURSE_PERIOD_ID AND cp.COURSE_ID=c.COURSE_ID AND e.SCHOOL_DATE BETWEEN '" . $start_date . "' AND '" . $end_date . "'", array( 'ELIGIBILITY_CODE' => '_makeLower' ) ); $columns = array( 'COURSE_TITLE' => _( 'Course' ), 'ELIGIBILITY_CODE' => _( 'Grade' ) ); ListOutput( $RET, $columns, 'Course', 'Courses' ); } /** * @param $word */ function _makeLower( $word ) { return ucwords( mb_strtolower( $word ) ); }