| Server IP : 79.136.114.73 / Your IP : 18.222.153.166 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/icad.astacus.se/deviation/ |
Upload File : |
<?php
session_start();
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("vpa");
$UserID = $_SESSION['ASTACUS_SSO_INFO'][0];
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Deviation Report</title>
<style type="text/css">
.text {
font-family: Verdana, Geneva, sans-serif;
}
.text {
font-size: 12px;
}
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.subject {
font-family: Verdana, Geneva, sans-serif;
}
.subject {
font-size: 16px;
}
.subject .subject {
font-weight: bold;
}
</style>
<script>
function DeviationFunctions(selObj){
var IDs = selObj.options[selObj.selectedIndex].value;
if(IDs == 13){
document.getElementById("addedby2").disabled = false;
}else{
document.getElementById("addedby2").disabled = true;
}
}
function deviation(selObj){
var IDs = selObj.options[selObj.selectedIndex].value;
if(IDs == 4){
document.getElementById("type_Extra").disabled = false;
document.getElementById("type_ExtraSpan").innerHTML = "Client Id";
}else{
document.getElementById("type_Extra").disabled = true;
document.getElementById("type_ExtraSpan").innerHTML = "";
}
}
</script>
<script language="javascript">
function validateForm()
{
var x1=document.forms["form1"]["addedby"].value;
var x2=document.forms["form1"]["person"].value;
var x3=document.forms["form1"]["type"].value;
var x4=document.forms["form1"]["process"].value;
var x5=document.forms["form1"]["description"].value;
if(x1 == "NULL" || x2 == "NULL" || x3 == "NULL" || x4 == "NULL" || x5 == "" ){
alert("You need to fill in the top 4 fields and description!");
return false;
}
}
</script>
</head>
<body>
<span class="subject"><span class="subject">Deviation Report
</span>
</span>
<br />
<form action="save_report.php" method="post" enctype="multipart/form-data" name="form1" id="form1" onsubmit="return validateForm();">
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="258" valign="top" class="text">Added by person:</td>
<td colspan="2"><label for="addedby"></label>
<span class="style6">
<select name="addedby" id="addedby" >
<option value="NULL">Choose</option>
<?php
$sql = "SELECT * FROM SystemUser Where UserGroupID = 8 and SystemUserStatusId = 1 and Username LIKE '%@astacus.se%' order by Name asc";
$result = mysql_query($sql);
$AstacusPM = "";
while ($row = mysql_fetch_assoc($result)){
$sel = "";
if($row['SystemUserId'] == $UserID){
$sel ="selected";
}
echo("<option ".$sel." value='".$row['SystemUserId']."'>".$row['Username']."</option>");
}
?>
</select>
</span></td>
</tr>
<tr>
<td valign="top" class="text">Process:</td>
<td colspan="2" class="style6"><select name="process" id="process">
<option value="NULL">Choose</option>
<?php
$sql = "SELECT * FROM DeviationProcess order by Name asc";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
echo("<option value='".$row['ProcessId']."'>".$row['Name']."</option>");
}
?>
</select>
<br /></td>
</tr>
<tr>
<td valign="top" class="text">Deviation type:</td>
<td width="120"><select name="type" id="type" onchange="deviation(this);">
<?php
$sql = "SELECT * FROM DeviationType order by Name asc";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$sel = "";
if($row['DeviationTypeId'] == 2){
$sel = "selected='selected'";
}
echo("<option value='".$row['DeviationTypeId']."' $sel>".$row['Name']."</option>");
}
?>
</select></td>
<td width="172"><label for="type_Extra"></label>
<input name="type_Extra" type="text" disabled="disabled" id="type_Extra" size="5" />
<span id="type_ExtraSpan" class="text"></span></td>
</tr>
<tr>
<td valign="top" class="text">Cause of deviation:</td>
<td colspan="2"><span class="style6">
<select name="person" id="person" onchange="DeviationFunctions(this);">
<option value="NULL">Choose</option>
<?php
$sql = "SELECT * FROM DeviationFunctions order by Name asc";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
echo("<option value='".$row['FunctionId']."'>".$row['Name']."</option>");
}
?>
</select>
<select name="addedby2" id="addedby2" disabled="disabled">
<option value="NULL">Choose</option>
<?php
$sql = "SELECT * FROM SystemUser Where UserGroupID = 8 and SystemUserStatusId = 1 and Username LIKE '%@astacus.se%' order by Name asc";
$result = mysql_query($sql);
$AstacusPM = "";
while ($row = mysql_fetch_assoc($result)){
$sel = "";
if($row['SystemUserId'] == $UserID){
$sel ="selected";
}
echo("<option ".$sel." value='".$row['SystemUserId']."'>".$row['Username']."</option>");
}
?>
</select>
</span></td>
</tr>
<tr>
<td valign="top" class="text">Description:</td>
<td colspan="2"><label for="description"></label>
<textarea name="description" id="description" cols="50" rows="5"></textarea></td>
</tr>
<tr>
<td valign="top" class="text"> Old solutions: </td>
<td colspan="2"><span class="style6">
<select name="oldsolution" id="oldsolution">
<option value="NULL">Choose</option>
<?php
$sql = "SELECT * FROM DeviationReport WHERE Solution != '' order by TimeStamp desc";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
echo("<option value='".$row['DeviationReportId']."'>".$row['Solution']."</option>");
}
?>
</select>
</span></td>
</tr>
<tr>
<td valign="top" class="text">Action proposal:</td>
<td colspan="2"><span class="style6">
<textarea name="action" id="action" cols="50" rows="5"></textarea>
</span></td>
</tr>
<tr>
<td valign="top" class="text">Photo/Screen shot</td>
<td colspan="2"><label for="photo"></label>
<input type="file" name="photo" id="photo" />
<span class="text">(JPG)</span></td>
</tr>
<tr>
<td valign="top" class="text">How critical?</td>
<td colspan="2"><select name="critical" id="critical">
<option value="1">1</option>
<option value="2">2</option>
<option value="3" selected>3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
<span class="style6">(>3 may cause severe delays or human risks)</span></td>
</tr>
<tr>
<td valign="top" class="text">Report to Security officer</td>
<td colspan="2"><input type="checkbox" name="report" id="report" />
<label for="report"></label></td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2" align="right"><input type="submit" name="button" id="button" value="Submit deviation" /></td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2"> </td>
</tr>
</table>
</form>
</body>
</html>