"; if ($print) { echo " "; $writeup=mysqli_query($drs_db,"select * from writeups where status=".STAT_OPEN." and report_date between \"$start_date\" and \"$end_date\" order by report_date desc,period desc,report_time desc"); if (mysqli_num_rows($writeup)) { $now=date("H:i l"); echo " As of $now Newest at top
"; while ($tablerow = mysqli_fetch_assoc($writeup)) { // determine effective icon if($tablerow["period_effective"]==1) { $eff_icon=" $\"Period$ "; } else { $eff_icon=" $\"Period$ "; } // convert device number to name $dname=dblookup($drs_db,"devices","id","name",$tablerow["device"]); // convert subsystem number to name $ssname=dblookup($drs_db,"subsystems","id","name",$tablerow["subsystem"]); // determine times for period $ptimes=mysqli_fetch_row(mysqli_query($drs_db,"select times from periods where id=\"{$tablerow['period']}\""))[0]; $disc_txt="{$tablerow['discrepancy_text']}"; // determine if this is a member of a group $member_qry=mysqli_query($drs_db,"select linkgroup from links where writeupid=\"{$tablerow['id']}\""); $is_member=mysqli_num_rows($member_qry); if ($is_member) { $group_count=$is_member; $member_group=mysqli_fetch_row($member_qry)[0]; $member_group_name=dblookup($drs_db,"groups","id","name",$member_group); if ($member_group_name) { $imgtitle="Member of group: $member_group_name"; } else { $imgtitle="Member of group ID: $member_group"; } if ($group_count == 1) { $disc_txt=$disc_txt."

$\"GRP\"$

"; } else { $disc_txt=$disc_txt."

$\"GRP\"$

"; } } // print table row printf( "\n", $tablerow["id"],$tablerow["id"], $tablerow["report_date"], $ptimes, $tablerow["period"], $dname, $ssname, $tablerow["reported_by"], $disc_txt, $eff_icon ); } echo "

ID	Date	Period	Device	Subsystem	Reported by	Discrepancy	Msn Eff
%s	%s	%s	%s	%s	%s	%s	%s

\n"; } else { if ($_REQUEST['showyesterday']) { $datespec="yesterday"; } elseif ($_REQUEST['show7day']) { $datespec="the last 7 days"; } elseif ($_REQUEST['show30day']) { $datespec="the last 30 days"; } else { $datespec="today"; } echo "No open writeups for $datespec."; } } function viewtable($start_date,$end_date,$print,$drs_db,$viewtype="summary",$role) { // show date range selector $summarystat=$detailstat=""; if ($viewtype=="detail") { $detailstat="checked"; } else { $summarystat="checked"; } echo "

Writeups between      and           "; if(!$print) { echo "

Results in summary view    Results in detail view

"; } $writeup=mysqli_query($drs_db,"select * from writeups where report_date between \"$start_date\" and \"$end_date\" order by report_date desc,period desc,report_time desc"); if (mysqli_num_rows($writeup)) { $now=date("H:i l"); if ($viewtype == "summary") { if ($role) { $selcol="Sel"; } else { $selcol=""; } echo " As of $now      Newest at top
$selcol "; while ($tablerow = mysqli_fetch_assoc($writeup)) { // determine effective icon if($tablerow["period_effective"]==1) { $eff_icon=" $\"Period$ "; } else { $eff_icon=" $\"Period$ "; } // determine status indicator if ($tablerow['status']==1) $statusind="

OPEN

"; if ($tablerow['status']==2) $statusind="

CLSD

"; if ($tablerow['status']==3) $statusind="

DFRD

"; // convert device number to name $dname=dblookup($drs_db,"devices","id","name",$tablerow["device"]); // convert subsystem number to name $ssname=dblookup($drs_db,"subsystems","id","name",$tablerow["subsystem"]); // determine times for period $ptimes=mysqli_fetch_row(mysqli_query($drs_db,"select times from periods where id=\"{$tablerow['period']}\""))[0]; $disc_txt="{$tablerow['discrepancy_text']}"; // determine if this is a member of a group $member_qry=mysqli_query($drs_db,"select linkgroup from links where writeupid=\"{$tablerow['id']}\""); $is_member=mysqli_num_rows($member_qry); if ($is_member) { $group_count=$is_member; $member_group=mysqli_fetch_row($member_qry)[0]; $member_group_name=dblookup($drs_db,"groups","id","name",$member_group); if ($member_group_name) { $imgtitle="Member of group: $member_group_name"; } else { $imgtitle="Member of group ID: $member_group"; } if ($group_count == 1) { $disc_txt=$disc_txt."

$\"GRP\"$

"; } else { $disc_txt=$disc_txt."

$\"GRP\"$

"; } } // print table row if ($role) { $selcontent=""; } else { $selcontent=""; } printf( " %s \n", $selcontent, $tablerow["id"],$tablerow["id"], $statusind, $tablerow["report_date"], $ptimes, $tablerow["period"], $dname, $ssname, $tablerow["reported_by"], $disc_txt, $eff_icon ); } echo "

ID	Status	Date	Period	Device	Subsystem	Reported by	Discrepancy	Msn Eff

%s	%s	%s	%s	%s	%s	%s	%s	%s

\n"; } elseif ($viewtype == "detail") { echo " As of $now Newest at top

"; while ($tablerow = mysqli_fetch_assoc($writeup)) { if ($role) echo " Select"; displaywriteup($tablerow['id']); echo "

"; } echo "

"; } if ($role) { echo "

"; } } else { echo "No writeups for the date range specified above."; } echo "

"; } // use default date values if not supplied $today = date("Y-m-d"); if ($start_date=="") $start_date=$today; if ($end_date=="") $end_date=$today; if ($showtoday) { $start_date=$today; $end_date=$today; } if ($showyesterday) { $start_date=mysqli_fetch_row(mysqli_query($drs_db,"select date_sub(curdate(),interval 1 day)"))[0]; $end_date=$start_date; } if ($show7day) { $start_date=mysqli_fetch_row(mysqli_query($drs_db,"select date_sub(curdate(),interval 7 day)"))[0]; $end_date=$today; } if ($show30day) { $start_date=mysqli_fetch_row(mysqli_query($drs_db,"select date_sub(curdate(),interval 30 day)"))[0]; $end_date=$today; } if ($view) { $pgtitle="Recent Writeups"; } else { $pgtitle="Open Writeups"; } framework("begin","$appname",$pgtitle,$print); //var_dump($_REQUEST); //var_dump($incoming); // ******** begin database manipulation ******** if ($addtogroup && $togroup && $selectedids && $role) { $fail=false; if ($togroup=="newgroup") { // Create a new group mysqli_query($drs_db,"insert into groups(name) value(\"\")"); $fail=mysqli_error($drs_db); $togroup=mysqli_insert_id($drs_db); } foreach ($selectedids as $selid) { // add writeup to the group if (!mysqli_num_rows(mysqli_query($drs_db,"select id from links where writeupid=\"$selid\" and linkgroup=\"$togroup\""))) { // target is not already a member of this group mysqli_query($drs_db,"insert into links (linkgroup,writeupid) values($togroup,$selid)"); $fail=mysqli_error($drs_db); } } } // ******** end database manipulation ******** pagetable("begin"); if(!$print) { pageblock("left","begin"); sidemenu(); echo "

"; pageblock("left","end"); } pageblock("right","begin"); banner($print); echo "
"; if ($addtogroup) { if (count($selectedids) > 1) { $plural="s"; } else { $plural=""; } if (!$fail) { format_message(0,"Writeup$plural successfully added to group."); } else { format_message(2,"An error was encountered when adding writeup$plural. The error was \" $fail \""); } } if (!$viewtype) $viewtype="summary"; if ($view==1) { // show writeup table viewtable($start_date,$end_date,$print,$drs_db,$viewtype,$role); } else { // show open table opentable($start_date,$end_date,$print,$drs_db,$viewtype); } echo "
"; banner($print); pageblock("right","end"); pagetable("end"); framework("end","","",$print); ?>