report.php

<?php
/*
*	 report.php
*	 Contains the main reporting page of the EG
*
*	Copyright 2011-2015 Community Legal Services
* 
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*    http://www.apache.org/licenses/LICENSE-2.0

* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
**************************************************/

	
	require_once("config.php");
	require_once("Arrest.php");
	require_once("ArrestSummary.php");
	require_once("Person.php");
	require_once("Attorney.php");
	require_once("utils.php");
	require_once("Case.php");
	
	include('head.php');
	include('header.php');
?>

<div class="main">
	<div class="content-left">&nbsp;</div>
	<div class="content-center">

<?php
// if the user isn't logged in, then don't display this page.  Tell them they need to log in.
if (!isLoggedIn())
	include("displayNotLoggedIn.php");
else
{
	$attorney = new Attorney($_SESSION["loginUserID"], $db);
	if($GLOBALS['debug'])
		$attorney->printAttorneyInfo();

	// only certain users can see this page
	if ($attorney->getUserLevel() != 1)
		print "You must have permission to view this page.";

	else
	{	
		// first, do a query of all expungements
		$query = "SELECT expungement.*, userinfo.*, arrest.*, defendant.firstName as dFirst, defendant.lastName as dLast from expungement LEFT JOIN userinfo on (expungement.userid = userinfo.userid) LEFT JOIN arrest on (expungement.arrestID = arrest.arrestID) LEFT JOIN defendant on (arrest.defendantID = defendant.defendantID)";
		
		$result = $db->query($query);
		if (!$result) 
		{
			if ($GLOBALS['debug'])
				die('Could not get the Expungement Information from the DB:' . $db->error);
			else
				die('Could not get the Expungement Information from the DB');
		}
		
		print <<<END
		<table>
		<th>Docket Number</th><th>PDF</th><th>Defendant Name</th><th>Attorney Name</th><th>Date Prepared</th><th>Charges Redacted</th><th>Type</th><th>Costs Owed</th><th>Bail Owed</th>
END;
		while ($row = $result->fetch_assoc())
		{
			$redactionType = getRedactionType($row['isExpungement'],$row['isRedaction'],$row['isSummaryExpungement']);
		
			print "<tr>";
			print "<td><a href='showCase.php?id={$row['expungementID']}'>{$row['docketNumRelated']}</a></td>";
			
			// only show the pdf link if one exists
			if (doesPDFExistForCaseId($row['expungementID']))
				print "<td><a href='displayPDF.php?id={$row['expungementID']}'><img src='images/pdf_icon.png'></a></td>";
			else
				print "<td>&nbsp;</td>";
				
			print "<td>{$row['dFirst']} {$row['dLast']} </td>";
			print "<td>{$row['firstName']}  {$row['lastName']} </td>";
			print "<td>{$row['timestamp']}</td>";
			print "<td>{$row['numRedactableCharges']}</td>";
			print "<td>$redactionType</td>";
			print "<td>$" . number_format($row['costsTotal'] - $row['bailTotal'],2) . "</td>";
			print "<td>$" . number_format($row['bailTotalToal'],2) . "</td>";
			print "</tr>";
		}
	
		$result->close();
	}
}
?>	
	</div> <!-- content-center -->
	<div class="content-right"><?php // include right column? ?></div>
	</div>
<?php
	include ('foot.php');
?>