| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Scheduler/Schedule/Course/ |
Upload File : |
<?
// courseFormPreset.phpinc
// Get original data and preset the course form.
t_Begin(); // Begin TRACKing included file.
// Ensure primary key is set.
if ( !isset($f['courseId']) ) { formValue('courseId'); if ( !$f['courseId'] ) $f['courseId'] = 0; }
// Get original course data.
if ( $f['courseId'] ) {
// $f['courseId'] is set. Load original data from database.
$query = "
SELECT * FROM `course`
WHERE courseId = ".$f['courseId']."
";
$courseResult = query_do($query,'scheduler');
$courseCount = $GLOBALS['_QUERY']['count'];
if ( $courseCount == 1 ) {
// Load original data from record.
query_seek($courseResult, 0);
$courseInfo = mysql_fetch_assoc($courseResult);
$o['userId'] = $courseInfo['userId'];
$o['YRTR'] = $courseInfo['YRTR'];
$o['departmentId'] = $courseInfo['departmentId'];
$o['courseNumber'] = $courseInfo['courseNumber'];
$o['courseTitle'] = $courseInfo['courseTitle'];
$o['courseShortTitle'] = $courseInfo['courseShortTitle'];
$o['courseCredits'] = $courseInfo['courseCredits'];
$o['courseCreditsMax'] = $courseInfo['courseCreditsMax'];
$o['courseLecture'] = $courseInfo['courseLecture'];
$o['courseLab'] = $courseInfo['courseLab'];
$o['courseOther'] = $courseInfo['courseOther'];
$o['courseDescription'] = $courseInfo['courseDescription'];
$o['coursePrerequisite'] = $courseInfo['coursePrerequisite'];
$o['courseCorequisite'] = $courseInfo['courseCorequisite'];
$o['courseinstrtypeId'] = $courseInfo['courseinstrtypeId'];
$o['courseMax'] = $courseInfo['courseMax'];
$o['courseInactive'] = $courseInfo['courseInactive'];
} else {
// The record count was not 1. This is an error.
programmingError('Record count ('.$courseCount.') for courseId='.$f['courseId'].' was not 1.');
}
} else {
// $f['courseId'] is 0. This is an add form. Set form_course data to default values.
$f['courseId'] = 0;
if ( !isset($o['userId']) ) $o['userId'] = NULL;
if ( !isset($o['YRTR']) ) $o['YRTR'] = '';
$f['departmentId'] = 0;
if ( !isset($o['courseNumber']) ) $o['courseNumber'] = '';
if ( !isset($o['courseTitle']) ) $o['courseTitle'] = '';
if ( !isset($o['courseShortTitle']) ) $o['courseShortTitle'] = NULL;
$f['courseCredits'] = 0;
if ( !isset($o['courseCreditsMax']) ) $o['courseCreditsMax'] = NULL;
if ( !isset($o['courseLecture']) ) $o['courseLecture'] = NULL;
if ( !isset($o['courseLab']) ) $o['courseLab'] = NULL;
if ( !isset($o['courseOther']) ) $o['courseOther'] = NULL;
if ( !isset($o['courseDescription']) ) $o['courseDescription'] = NULL;
if ( !isset($o['coursePrerequisite']) ) $o['coursePrerequisite'] = NULL;
if ( !isset($o['courseCorequisite']) ) $o['courseCorequisite'] = NULL;
if ( !isset($o['courseinstrtypeId']) ) $o['courseinstrtypeId'] = NULL;
if ( !isset($o['courseMax']) ) $o['courseMax'] = NULL;
if ( !isset($o['courseInactive']) ) $o['courseInactive'] = '0';
}
// Preset course form data.
if ( $f['form'] != 'form_course' ) {
// form_course not called by itself. Preload data for form.
if ( $f['courseId'] ) {
// $f['courseId'] is set. This is an edit form. Load form_course data from database.
/** / // Remove this section if original data is obtained above.
$query = "
SELECT * FROM `course`
WHERE courseId = ".$f['courseId']."
";
$courseResult = query_do($query,'scheduler');
$courseCount = $GLOBALS['_QUERY']['count'];
/**/ // Remove this section if original data is obtained above.
if ( $courseCount == 1 ) {
// Load original data from record.
query_seek($courseResult, 0);
$courseInfo = mysql_fetch_assoc($courseResult);
$f['userId'] = $courseInfo['userId'];
$f['YRTR'] = $courseInfo['YRTR'];
$f['departmentId'] = $courseInfo['departmentId'];
$f['courseNumber'] = $courseInfo['courseNumber'];
$f['courseTitle'] = $courseInfo['courseTitle'];
$f['courseShortTitle'] = $courseInfo['courseShortTitle'];
$f['courseCredits'] = $courseInfo['courseCredits'];
$f['courseCreditsMax'] = $courseInfo['courseCreditsMax'];
$f['courseLecture'] = $courseInfo['courseLecture'];
$f['courseLab'] = $courseInfo['courseLab'];
$f['courseOther'] = $courseInfo['courseOther'];
$f['courseDescription'] = $courseInfo['courseDescription'];
$f['coursePrerequisite'] = $courseInfo['coursePrerequisite'];
$f['courseCorequisite'] = $courseInfo['courseCorequisite'];
$f['courseinstrtypeId'] = $courseInfo['courseinstrtypeId'];
$f['courseMax'] = $courseInfo['courseMax'];
$f['courseInactive'] = $courseInfo['courseInactive'];
} else {
// The record count was not 1. This is an error.
programmingError('Record count ('.$courseCount.') for courseId='.$f['courseId'].' was not 1.');
}
} else {
// $f['courseId'] is 0. This is an add form. Set form_course data to default values.
$f['courseId'] = 0;
if ( !isset($f['userId']) ) $f['userId'] = NULL;
if ( !isset($f['YRTR']) ) $f['YRTR'] = '';
$f['departmentId'] = 0;
if ( !isset($f['courseNumber']) ) $f['courseNumber'] = '';
if ( !isset($f['courseTitle']) ) $f['courseTitle'] = '';
if ( !isset($f['courseShortTitle']) ) $f['courseShortTitle'] = NULL;
$f['courseCredits'] = 0;
if ( !isset($f['courseCreditsMax']) ) $f['courseCreditsMax'] = NULL;
if ( !isset($f['courseLecture']) ) $f['courseLecture'] = NULL;
if ( !isset($f['courseLab']) ) $f['courseLab'] = NULL;
if ( !isset($f['courseOther']) ) $f['courseOther'] = NULL;
if ( !isset($f['courseDescription']) ) $f['courseDescription'] = NULL;
if ( !isset($f['coursePrerequisite']) ) $f['coursePrerequisite'] = NULL;
if ( !isset($f['courseCorequisite']) ) $f['courseCorequisite'] = NULL;
if ( !isset($f['courseinstrtypeId']) ) $f['courseinstrtypeId'] = NULL;
if ( !isset($f['courseMax']) ) $f['courseMax'] = NULL;
if ( !isset($f['courseInactive']) ) $f['courseInactive'] = '0';
}
}
t_End(); // End TRACKing included file.
?>