Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!doctype html>
- <?php
- require_once("php_includes/base.inc.php");
- if(!hasPerm("officer")){
- redirect("/index.php");
- die();
- }
- $stmt = $pdo->prepare("SELECT * FROM `arrests` WHERE `RealDate` > NOW() - INTERVAL 24 HOUR ORDER BY `id` DESC");
- $stmt->execute();
- $arrests = $stmt->fetchAll();
- $acnt = count($arrests);
- $cminfo = getInfo("cminfo");
- $cminfo = json_decode($cminfo['data'], true);
- ?>
- <html lang="en-US">
- <head>
- <!-- Meta -->
- <meta charset="UTF-8">
- <title><?php echo $cminfo['pda']; ?> - Recent Arrests</title>
- <meta name="description" content="<?php echo $cminfo['pdn']; ?> - Recent Arrests">
- <meta name="author" content="Cole, Scott Harm (Retired)">
- <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <!-- Favicons -->
- <link rel="shortcut icon" href="img/favicons/favicon.png">
- <link rel="apple-touch-icon" href="img/favicons/icon.png">
- <link rel="apple-touch-icon" sizes="72x72" href="img/favicons/72x72.png">
- <link rel="apple-touch-icon" sizes="114x114" href="img/favicons/114x114.png">
- <!-- CSS -->
- <link rel="stylesheet" href="css/reset.css">
- <link rel="stylesheet" href="css/bootstrap.min.css">
- <link rel="stylesheet" href="css/font-awesome.min.css">
- <link href="https://fonts.googleapis.com/css?family=Raleway:300|Muli:300" rel="stylesheet" type="text/css">
- <link rel="stylesheet" href="css/idangerous.swiper.css">
- <link rel="stylesheet" href="css/style.css">
- <link rel="stylesheet" href="css/ticker.css">
- <!-- Scripts -->
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
- </head>
- <body>
- <div id="overlay"></div>
- <div id="top">
- <a href="#" id="sidebar-button"></a>
- <header id="logo">
- <img src="img/logo.png" alt="Logo">
- </header>
- </div>
- <div id="main-wrapper">
- <?php require_once("boloTicker.php"); ?>
- <div id="content">
- <div class="container-fluid">
- <div id="heading" class="row">
- <div class="col-12">
- <header>
- <h1>Recent Arrest History - Last 24 Hours</h1>
- </header>
- </div>
- </div>
- <div class="row">
- <div class="col-12">
- <article class="inner">
- <div class="row">
- <div class="col-12">
- <h4>Retrieved <?php echo $acnt; ?> Arrests</h4>
- </div>
- </div>
- <center>
- <table style="text-align: center">
- <tbody>
- <tr>
- <th>Time of Arrest</th>
- <th>Name</th>
- <th>Crime</th>
- <th>Time</th>
- <th>Bail</th>
- <th>Bond</th>
- <th>Arresting Officer</th>
- <th>Processing Officer</th>
- </tr>
- <?php
- for($i = 0; $i < $acnt; $i++) {
- $aoffi = getUser($arrests[$i]['copid'], U_ID);
- $tproc = getUser($arrests[$i]['docid'], U_ID);
- ($arrests[$i]['proc'] == 0) ? $poffi = "<span style='color:#f00'>Not Processed</span>" : $poffi = $tproc[display];
- ($arrests[$i]['bondid'] == -1) ? $bond = "No" : $bond = "Yes";
- if($arrests[$i]['bail'] == 0) $bail = "No"; else $bail = "$".number_format($arrests[$i]['bail']);
- $cname = getCiv($arrests[$i]['uid'], U_ID);
- echo "<tr><td>".antiXSS($arrests[$i]['RealDate'])."</td><td>".antiXSS($cname['name'])."</td><td>".titleFormat(antiXSS($arrests[$i]['crimes']))."</td><td>".antiXSS(number_format($arrests[$i]['time']))."</td><td>$bail</td><td>$bond</td><td>$aoffi[display]</td><td>$poffi</td></tr>";
- }
- ?>
- </tbody>
- </table>
- </center>
- </article>
- </div>
- </div>
- </div>
- </div>
- <?php require_once("sidebar.php"); ?>
- <footer>
- <p class="copyright">© Copyright 2017 <a href="http://coltonbrister.com" target="_blank">Colton Brister</a></p>
- </footer>
- </div>
- </div>
- <!-- JavaScripts -->
- <script type='text/javascript' src='js/jquery.min.js'></script>
- <script type='text/javascript' src='js/bootstrap.min.js'></script>
- <script type='text/javascript' src='js/swiper/idangerous.swiper.min.js'></script>
- <script type='text/javascript' src='js/masonry/masonry.pkgd.min.js'></script>
- <script type='text/javascript' src='js/isotope/jquery.isotope.min.js'></script>
- <script type='text/javascript' src='js/custom.js'></script>
- <script type="text/javascript" src="js/ticker.js"></script>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement