| 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/admin/parse/ |
Upload File : |
<?
// parseProcess_Get_departmentId.phpinc
// Get departmentId.
t_Begin(); // Begin TRACKing include_filename.phpinc.
$query = "
SELECT departmentId
FROM `department`
WHERE departmentCode = '".query_safe($thisClass['departmentCode'])."'
";
d_Var('departmentInfo',$query,'q');
$departmentInfo = query_info($query);
d_Var('$departmentInfo',$departmentInfo);
if ( !$departmentInfo ) {
// INSERT department.
$query = "
INSERT INTO `department` (
departmentCode
, departmentName
, AddedOn
, AddedBy
) VALUES (
'".query_safe($thisClass['departmentCode'])."'
, '".query_safe($department[$thisClass['departmentCode']])."'
, '".currentDateTime()."'
, ".$_SESSION['user']['trueId']."
)
";
d_Var('departmentINSERT',$query,'q');
$departmentINSERT = query_do($query);
d_Var('$departmentINSERT',$departmentINSERT,'l');
$departmentInfo['departmentId'] = $GLOBALS['_QUERY']['insertId'];
d_Var("\$departmentInfo['departmentId']",$departmentInfo['departmentId']);
?>
<article>New <?=$thisClass['departmentCode']?> department found on line <?=$thisClass['!line']?>.</article>
<?
}
$departmentId[$thisClass['departmentCode']] = $departmentInfo['departmentId'];
d_Var('$departmentId['.$thisClass['departmentCode'].']',$departmentId[$thisClass['departmentCode']],'');
t_End(); // End TRACKing include_filename.phpinc.
?>