Writeup ID
Device
";
if ($useredit) {
echo "
";
$drow=mysqli_query($drs_db,"select * from devices where active is true order by id asc");
while ($ditem=mysqli_fetch_assoc($drow)) {
if ($device==$ditem["id"]) {
printf("%s ",$ditem["id"],$ditem["name"]);
} else {
printf("%s ",$ditem["id"],$ditem["name"]);
}
}
echo "
";
} else {
$dname=dblookup($drs_db,"devices","id","name",$device);
echo "
";
}
echo "
Subsystem
";
if ($useredit) {
echo "
";
$ssrow=mysqli_query($drs_db,"select * from subsystems where active is true order by id asc");
while ($ssitem=mysqli_fetch_assoc($ssrow)) {
if ($subsystem==$ssitem["id"]) {
printf("%s ",$ssitem["id"],$ssitem["description"],$ssitem["name"]);
} else {
printf("%s ",$ssitem["id"],$ssitem["description"],$ssitem["name"]);
}
}
echo "
";
} else {
$ssname=dblookup($drs_db,"subsystems","id","name",$subsystem);
$ssdesc=dblookup($drs_db,"subsystems","id","description",$subsystem);
echo "
";
}
echo "
Period
";
if ($useredit) {
echo "
";
$prow=mysqli_query($drs_db,"select * from periods where active is true order by times asc");
while ($pitem=mysqli_fetch_assoc($prow)) {
if ($period==$pitem["id"]) {
printf("%s ",$pitem["id"],$pitem["times"],$pitem["id"]);
} else {
printf("%s ",$pitem["id"],$pitem["times"],$pitem["id"]);
}
}
echo "
";
} else {
$pertimes=dblookup($drs_db,"periods","id","times",$period);
echo "
";
}
echo "
";
$effstate=$nefstate="";
if($period_effective==1) {
$effstate="checked";
$eff_ind="Effective";
}
if($period_effective==0) {
$nefstate="checked";
$eff_ind="Non-Effective";
}
$openstate=$closedstate=$deferredstate="";
if($status==1) $openstate="selected";
if($status==2) $closedstate="selected";
if($status==3) $deferredstate="selected";
echo "
Report Date
";
if ($useredit) {
echo "
";
} else {
echo "
";
}
echo "
Report Time
";
if ($useredit) {
echo "
";
} else {
echo "
";
}
echo "
Discrepancy (required)
";
if ($useredit) {
echo " ";
} else {
echo " ";
}
echo "
Reported by (required)
";
if ($useredit) {
echo "
";
} else {
echo "
";
}
echo "
Sim period effective?
";
if ($useredit) {
echo "
Yes
No
";
} else {
echo "
";
}
echo "
";
if ($useredit) {
echo "
";
} else {
$wustat=dblookup($drs_db,"writeups","id","status",$id);
if ($wustat==2 && !$role) $allowuseredit="disabled";
echo "
";
}
// end of user section
echo "
Status
";
if ($techedit) {
echo "
OPEN
CLOSED
DEFERRED
";
} else {
echo "
";
}
echo "
Action taken by
";
if ($techedit) {
if ($role==ADMIN) {
// allow selection of tech name
echo "
";
$persrow=mysqli_query($drs_db,"select id,firstname,lastname from users where active is true order by lastname asc");
while ($persitem=mysqli_fetch_assoc($persrow)) {
if ($userid==$persitem["id"]) {
printf("%s %s ",$persitem["id"],$persitem["firstname"],$persitem["lastname"]);
} else {
printf("%s %s ",$persitem["id"],$persitem["firstname"],$persitem["lastname"]);
}
}
echo "
";
} else {
// limit the choice to the tech in question
echo "
";
$persrow=mysqli_query($drs_db,"select id,firstname,lastname from users where active is true order by lastname asc");
while ($persitem=mysqli_fetch_assoc($persrow)) {
if ($userid==$persitem["id"]) {
printf("%s %s ",$persitem["id"],$persitem["firstname"],$persitem["lastname"]);
}
}
echo "
";
}
} else {
$techfname=dblookup($drs_db,"users","id","firstname",$action_by);
$techlname=dblookup($drs_db,"users","id","lastname",$action_by);
echo "
";
}
echo "
Status change reason
";
if ($techedit) {
echo "
";
$reasrow=mysqli_query($drs_db,"select id,text from reasons where active is true order by id asc");
if (!$action_reason) echo " ";
while ($reasitem=mysqli_fetch_assoc($reasrow)) {
if ($action_reason==$reasitem["id"]) {
printf("%s ",$reasitem["id"],$reasitem["text"]);
} else {
printf("%s ",$reasitem["id"],$reasitem["text"]);
}
}
echo "
";
} else {
$reasonname=dblookup($drs_db,"reasons","id","text",$action_reason);
echo"
";
}
echo "
Action Taken (required)
";
if ($techedit) {
echo "
";
} else {
echo "
";
}
echo "
Action Taken Date
";
if ($techedit) {
echo "
";
} else {
echo "
";
}
echo "
Action Taken Time
";
if ($techedit) {
echo "
";
} else {
echo "
";
}
if ($techedit) {
echo "
";
} else {
if (!$role) $live="disabled";
echo "
";
}
echo "