<?php
DrawHeader( ProgramTitle() );
if ( $_REQUEST['modfunc'] === 'update' )
{
// Add eventual Dates to $_REQUEST['values'].
AddRequestedDates( 'values' );
foreach ( (array) $_REQUEST['values'] as $id => $columns )
{
if ( $id !== 'new' )
{
$sql = "UPDATE history_marking_periods SET ";
foreach ( (array) $columns as $column => $value )
{
$sql .= DBEscapeIdentifier( $column ) . "='" . $value . "',";
}
$sql = mb_substr( $sql, 0, -1 ) . " WHERE MARKING_PERIOD_ID='" . (int) $id . "'";
DBQuery( $sql );
}
// New: check for Title.
elseif ( $columns['NAME'] )
{
// Note: we get next ID from school_marking_periods table's MARKING_PERIOD_ID column.
// Will fail for MySQL (returns 0).
$mp_id = DBSeqNextID( 'school_marking_periods_marking_period_id_seq' );
if ( $DatabaseType === 'mysql' )
{
// @since 9.3 Add MySQL support
$mp_id = DBSeqNextID( 'school_marking_periods' );
// Manually set AUTO_INCREMENT+1 as we do not INSERT into school_marking_periods table here.
DBQuery( "ALTER TABLE school_marking_periods
AUTO_INCREMENT=" . (int) ( $mp_id + 1 ) );
}
$sql = 'INSERT INTO history_marking_periods ';
$fields = 'MARKING_PERIOD_ID,SCHOOL_ID,';
$values = $mp_id . ",'" . UserSchool() . "',";
$go = false;
foreach ( (array) $columns as $column => $value )
{
if ( ! empty( $value )
|| $value == '0' )
{
$fields .= DBEscapeIdentifier( $column ) . ',';
$values .= "'" . $value . "',";
$go = true;
}
}
$sql .= '(' . mb_substr( $fields, 0, -1 ) . ') values(' . mb_substr( $values, 0, -1 ) . ')';
if ( $go )
{
DBQuery( $sql );
}
}
}
// Unset modfunc & redirect URL.
RedirectURL( 'modfunc' );
}
if ( $_REQUEST['modfunc'] === 'remove' )
{
if ( DeletePrompt( _( 'History Marking Period' ) ) )
{
$delete_sql = "DELETE FROM history_marking_periods
WHERE MARKING_PERIOD_ID='" . (int) $_REQUEST['id'] . "';";
$delete_sql .= "DELETE FROM student_report_card_grades
WHERE MARKING_PERIOD_ID='" . (int) $_REQUEST['id'] . "';";
DBQuery( $delete_sql );
// Unset modfunc & ID & redirect URL.
RedirectURL( [ 'modfunc', 'id' ] );
}
}
if ( ! $_REQUEST['modfunc'] )
{
echo '<form action="' . URLEscape( 'Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=update' ) . '" method="POST">';
DrawHeader( '', SubmitButton() );
echo '<br />';
$functions = [
'MP_TYPE' => '_makeSelectInput',
'NAME' => '_makeTextInput',
'SHORT_NAME' => '_makeTextInput',
'POST_END_DATE' => '_makeDateInput',
'SYEAR' => '_makeSchoolYearSelectInput',
];
//FJ add translation
$LO_columns = [
'MP_TYPE' => _( 'Type' ),
'NAME' => _( 'Name' ),
'SHORT_NAME' => _( 'Short Name' ),
'POST_END_DATE' => _( 'Grade Post Date' ),
'SYEAR' => _( 'School Year' ),
];
$link['add']['html'] = [
'MP_TYPE' => _makeSelectInput( '', 'MP_TYPE' ),
'NAME' => _makeTextInput( '', 'NAME' ),
'SHORT_NAME' => _makeTextInput( '', 'SHORT_NAME' ),
'POST_END_DATE' => _makeDateInput( '', 'POST_END_DATE' ),
'SYEAR' => _makeSchoolYearSelectInput( '', 'SYEAR' ),
];
$link['remove']['link'] = 'Modules.php?modname=' . $_REQUEST['modname'] . '&modfunc=remove';
$link['remove']['variables'] = [ 'id' => 'MARKING_PERIOD_ID' ];
$LO_ret = DBGet( "SELECT MP_TYPE,NAME,SHORT_NAME,POST_END_DATE,SYEAR,MARKING_PERIOD_ID
FROM history_marking_periods
WHERE SCHOOL_ID='" . UserSchool() . "'
ORDER BY POST_END_DATE", $functions );
ListOutput(
$LO_ret,
$LO_columns,
'History Marking Period',
'History Marking Periods',
$link,
[],
[ 'count' => true, 'download' => false, 'search' => false ]
);
echo '<div class="center">' . SubmitButton() . '</div>';
echo '</form>';
}
/**
* @param $value
* @param $name
*/
function _makeTextInput( $value, $name )
{
global $THIS_RET;
if ( ! empty( $THIS_RET['MARKING_PERIOD_ID'] ) )
{
$id = $THIS_RET['MARKING_PERIOD_ID'];
}
else
{
$id = 'new';
}
if ( $name === 'NAME' )
{
$extra = 'size=20 maxlength=50';
if ( $id !== 'new' )
{
$extra .= ' required';
}
}
else
{
$extra = 'size=9 maxlength=10';
}
return TextInput(
$value,
'values[' . $id . '][' . $name . ']',
'',
$extra
);
}
/**
* @param $value
* @param $name
*/
function _makeDateInput( $value, $name )
{
global $THIS_RET;
if ( ! empty( $THIS_RET['MARKING_PERIOD_ID'] ) )
{
$id = $THIS_RET['MARKING_PERIOD_ID'];
}
else
{
$id = 'new';
}
return DateInput(
$value,
'values[' . $id . '][' . $name . ']',
'',
true,
( $id === 'new' )
);
}
/**
* @param $value
* @param $name
*/
function _makeSelectInput( $value, $name )
{
global $THIS_RET;
if ( ! empty( $THIS_RET['MARKING_PERIOD_ID'] ) )
{
$id = $THIS_RET['MARKING_PERIOD_ID'];
}
else
{
$id = 'new';
}
$options = [ 'year' => _( 'Year' ), 'semester' => _( 'Semester' ), 'quarter' => _( 'Quarter' ) ];
return SelectInput(
trim( $value ),
'values[' . $id . '][' . $name . ']',
'',
$options,
false
);
}
/**
* @param $value
* @param $name
*/
function _makeSchoolYearSelectInput( $value, $name )
{
global $THIS_RET;
if ( ! empty( $THIS_RET['MARKING_PERIOD_ID'] ) )
{
$id = $THIS_RET['MARKING_PERIOD_ID'];
}
else
{
$id = 'new';
}
$options = [];
$years = range( UserSyear() - 5, UserSyear() );
foreach ( (array) $years as $year )
//FJ school year over one/two calendar years format
{
$options[$year] = FormatSyear( $year, Config( 'SCHOOL_SYEAR_OVER_2_YEARS' ) );
}
return SelectInput(
trim( $value ),
'values[' . $id . '][' . $name . ']',
'',
$options,
false
);
}