| 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/ |
Upload File : |
<?
// Schedule/js_write_Schedule_Credintials.phpinc
// Set js variables needed for schedule management.
echo "
// BEGIN FILE ".basename(__FILE__)." ".currentDateTime().".";
t_Begin(); // Begin TRACKing js_write_Schedule.phpinc.
$jsText .= "
console.log('%c\t\t".basename(__FILE__)."','background-color:#000; color: #ccc;');";
// BEGIN Credintials.
// Define js Credintial{} object.
// Credintial[credentialId] = { Id:credentialId, departmentId:departmentId, Code:'credentialCode', Title:'credentialTitle' }
// Get the department credentials.
$query = "
SELECT credentialId
, departmentId
, credentialCode
, credentialTitle
, credentialInactive
FROM `credential`
WHERE departmentId IN ( ".$scheduleInfo['departmentId']." )
AND credentialInactive = 0
ORDER BY credentialTitle
";
#d_Var('credentialResult',$query,'dq');
$credentialResult = query_do($query);
$credentialCount = $GLOBALS['_QUERY']['count'];
#d_Var('credentialCount',$credentialCount,'d');
#d_Var('$credentialResult',$credentialResult);
$jsText .= "\n"."
var Credintial = {}; // Credintials offered by this department.";
#if ( $credentialCount != 1 ) programmingError('The credentialId ('.$credentialId.') did not return one record. '.$credentialCount.' returned.');
#if ( !$credentialCount ) programmingError('The credentialId ('.$credentialId.') did not return any records.');
if ( $credentialCount ) {
$credentialIdMaxwidth = spaceMaxFill($credentialResult,'credentialId');
query_seek($credentialResult, 0);
while ($credentialInfo = query_row($credentialResult)) {
$sp = spaceFill($credentialInfo['credentialId'], $credentialIdMaxwidth);
$group = substr($credentialInfo['credentialCode'],-3);
$jsText .= "
Credintial[".$credentialInfo['credentialId']."] = ".$sp."{ Id:".$credentialInfo['credentialId'].",".$sp." departmentId:".$credentialInfo['departmentId'].", Code:'".$credentialInfo['credentialCode']."', Group:'".$group."', Title:'".$credentialInfo['credentialTitle']."' };";
}
}
// END Credintials.
echo "
// END FILE ".basename(__FILE__)."
";
t_End(); // End TRACKing js_write_Schedule.phpinc.
?>