<?php
require_once 'config.php';
$error = "";
$threshold = 200;
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : "";
if ($action == 'list') {
$dupes = dbLookupArray("select ids from dupe_check");
$query = "select id, first_name, last_name, preferred_name, email, replace(replace(phone_mobile, '-', ''), '.', '') as phone_mobile, arrest_date from arrestees";
$entities = dbLookupArray($query);
foreach ($entities as &$entity) {
$entity['pieces'] = array();
$pieces = array_merge(preg_split("/[\\s\\-]+/", trim($entity['first_name'])), preg_split("/[\\s\\-]+/", trim($entity['last_name'])));
foreach (array('last_name', 'first_name', 'preferred_name') as $field) {
foreach (preg_split("/[\\s\\-]+/", trim($entity[$field])) as $piece) {
$piece = strtolower($piece);
if ($piece == 'n/a' || $piece == 'unknown' || $piece == "") {
continue;
}
$entity['pieces'][] = array('name' => $piece, 'soundex' => soundex($piece), 'metaphone' => metaphone($piece), 'last' => $field == 'last_name');
}
}
}
$scores = array();
foreach ($entities as $one) {
foreach ($entities as $two) {
if ($two['id'] <= $one['id'] || $two['id'] == $one['id']) {
continue;
}
if (isset($dupes[$one['id'] . $two['id']])) {
continue;
require_once 'lib/autoload.php';
$key = 'AIzaSyDmo3fPBJO17GfQdKNdzuO5b8MHl2ZIuZs';
$calId = '*****@*****.**';
$keyFile = '/home/nlg/googlekey.p12';
$service_account_name = '*****@*****.**';
$client = new Google_Client();
$client->setApplicationName("Legal Support");
$key = file_get_contents($keyFile);
$cred = new Google_Auth_AssertionCredentials($service_account_name, array('https://www.googleapis.com/auth/calendar'), $key);
$client->setAssertionCredentials($cred);
if ($client->getAuth()->isAccessTokenExpired()) {
$client->getAuth()->refreshTokenWithAssertion($cred);
}
$service = new Google_Service_Calendar($client);
$datequery = "select concat(first_appearance_date_c, jurisdiction_c, afternoon) as id, first_appearance_date_c date, if(jurisdiction_c = 'A', 'AC', jurisdiction_c) jurisdiction, afternoon, sum(felony_charges) as fel, count(*) - sum(felony_charges) as mis from \n(select first_appearance_date_c, jurisdiction_c, if(next_hearing_time_c rlike '2[:00 ]*pm', 1, 0) as afternoon, felony_charges from arrestees where (disposition_c='open' or first_appearance_date_c <= CURDATE()) and first_appearance_date_c is not null and jurisdiction_c != '-blank-' ) a\ngroup by first_appearance_date_c, jurisdiction_c, afternoon";
$dates = dbLookupArray($datequery);
$existing = array();
//$client->setDeveloperKey($key);
$calendarList = $service->events->ListEvents($calId);
while (true) {
foreach ($calendarList->getItems() as $calendarListEntry) {
$id = $calendarListEntry['id'];
//$service->events->delete($calId, $id);
$title = $calendarListEntry->getSummary();
$j = substr($title, 0, 2) == 'AC' ? 'A' : substr($title, 0, 2);
$d = substr($calendarListEntry['start']['dateTime'], 0, 10);
$t = substr($calendarListEntry['start']['dateTime'], 11, 2) == '09' ? 0 : 1;
if (isset($existing[$d . $j . $t])) {
$service->events->delete($calId, $id);
} else {
$existing[$d . $j . $t] = $id;
<?php
require_once 'config.php';
require_once 'Curl.php';
use Curl\Curl;
$arrestee = array();
$initDocket = $_REQUEST['docketNumber'];
if (isset($_REQUEST['id'])) {
$id = $db->quote($_REQUEST['id']);
$arrestee = json_encode(array_values(dbLookupArray("select * from arrestees where id = '{$id}'"))[0]);
}
if ($_REQUEST['action'] == 'fetch') {
print $arrestee;
exit;
} else {
if ($_REQUEST['action'] == 'import') {
$data = $_REQUEST;
unset($data['action']);
$id = $data['id'];
unset($data['id']);
updateArrestee($data, $id);
print "ok";
exit;
}
}
if (isset($_REQUEST['frame'])) {
$curl = new Curl();
$curl->setCookieFile('cookies');
$curl->setCookieJar('cookies');
$_REQUEST['courtCode'] = $_REQUEST['courtCode'] ? $_REQUEST['courtCode'] : '01440';
if (!isset($_REQUEST['viewDetails']) && !isset($_REQUEST['returnToSearchResult'])) {
function getQueryList()
{
?>
<div id='querylist'>
<table class='sortable' id='querytable'>
<thead>
<tr><th>Name</th><th>Description</th><th>Created</th><th>Modified</th><th>Executed</th><th></th></tr>
</thead>
<tbody>
<?php
$queries = dbLookupArray("select * from queries");
foreach ($queries as $storedquery) {
$query_id = $storedquery[query_id];
echo "<tr id='row_{$query_id}'>\n\t\t\t<td id='name_{$query_id}'>\n\t\t\t\t<img class='pointer' onclick='showDetails({$query_id});' onmouseover='showTooltip(\"Edit this query\");' onmouseout='hideTooltip();' src='icons/edit.png' alt='Edit this query' />\n\t\t\t\t<div class='queryname pointer' onclick='showDetails({$query_id});'>{$storedquery['name']}</div>\n\t\t\t</td>\n\t\t\t<td id='description_{$query_id}'>{$storedquery['description']}</td>\n\t\t\t<td id='created_{$query_id}'>" . str_replace(' ', '<br/>', $storedquery[created]) . "</td>\n\t\t\t<td id='modified_{$query_id}'>" . str_replace(' ', '<br/>', $storedquery[modified]) . "</td>\n\t\t\t<td id='executed_{$query_id}'>" . str_replace(' ', '<br/>', $storedquery[executed]) . "</td>\n\t\t\t<td style='white-space: nowrap;' id='controls_{$query_id}'><a href='index.php?action=delete&query_id={$query_id}'><img class='pointer' src='icons/delete.png' alt='Delete this query'/></a><a href='index.php?action=copyquery&query_id={$query_id}'><img class='pointer' src='icons/copy.png' alt='Copy this query' /></a><a href='index.php' onclick='runQuery({$query_id}); return false;'><img class='pointer' src='icons/run.png' alt='Run this query' /></a></td>\n\t\t\t</tr>";
}
?>
</tbody>
</table>
</div>
<?php
}
function readData()
{
global $filename;
$file = file_get_contents($filename);
$rows = parse_csv($file);
// print_r($rows);
$fields = array('first_name', 'last_name', 'preferred_name', 'date_of_birth', 'phone_mobile', 'email', 'primary_address_street', 'primary_address_city', 'primary_address_state', 'primary_address_postalcode', 'arrest_date', 'arrest_time', 'arrest_city_c', 'arrest_location', 'support_needs_c', 'felony_charges', 'police_report_number_c', 'docket_c', 'first_appearance_date_c', 'next_hearing_time_c', 'cant_attend_c', 'medical_needs_c', 'description');
$data = array();
$row = $rows[0];
$fieldcount = count($row);
if (count($fields) + 2 != $fieldcount) {
if ($fieldcount == 1) {
$msg = "No online intakes to import";
} else {
$msg = "field count mismatch: is " . count($row) . " but should be " . (count($fields) + 2) . "\n";
}
print "<div class='message'>{$msg}</div>";
exit;
}
$id = array_shift($row);
$date = array_shift($row);
foreach ($fields as $field) {
$value = array_shift($row);
if (strpos($field, 'date') !== false) {
$value = fixDate($value);
} else {
if ($field == 'arrest_city_c') {
$data['jurisdiction_c'] = $value == 'San Francisco' ? 'SF' : 'A';
} else {
if ($field == 'description') {
$value .= "\nUpdated from online intake on " . substr($date, 0, 10);
}
}
}
$value = str_replace(";", "\n", $value);
$data[$field] = $value;
}
$data['release_type_c'] = 'unkown_released';
$arrestee = array_shift(dbLookupArray("select * from arrestees where id='{$id}'"));
if (isset($arrestee['release_type_c'])) {
if ($arrestee['release_type_c'] != 'in') {
$data['release_type_c'] = $arrestee['release_type_c'];
}
}
return $data;
}
<?php
require_once 'config.php';
require_once 'simpletest/browser.php';
require_once 'simple_html_dom.php';
@ini_set('zlib.output_compression', 0);
@ini_set('implicit_flush', 1);
@ob_end_clean();
set_time_limit(0);
ob_implicit_flush(1);
session_write_close();
#dbQuery("update arrestees set jurisdiction_c = 'A' where jurisdiction_c = '-blank-' and arrest_city_c in ('Oakland', 'Dublin', 'Berkeley', 'Emeryville')");
#dbQuery("update arrestees set jurisdiction_c = 'SF' where jurisdiction_c = '-blank-' and arrest_city_c in ('San Francisco')");
$names = dbLookupArray("select id, first_name, last_name, docket_c, first_appearance_date_c from arrestees where disposition_c = 'open' and jurisdiction_c = 'A' and (first_appearance_date_c is null or first_appearance_date_c <= DATE_ADD(NOW(), interval 7 DAY)) order by last_name, first_name");
?>
<!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" xml:lang="en" lang="en">
<head>
<title>Court Date Tool</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<link rel='stylesheet' href='style.css' type='text/css'/>
<link rel="stylesheet" type="text/css" media="all" href="js/tablesort/style.css" />
<script src="codepress/codepress.js" type="text/javascript"></script>
<script src="js/prototype.js" type="text/javascript"></script>
<script src="js/scriptaculous.js" type="text/javascript"></script>
<script type="text/javascript" src="js/tablesort/fastinit.js"></script>
<script type="text/javascript" src="js/tablesort/tablesort.js"></script>
<script type="text/javascript" src='lib.js'></script>
</head>
<body style=''>
function gigs_fetchMembers()
{
global $addressbook_table;
$members = dbLookupArray("select id, concat(firstname, ' ', lastname) as name, email, if(mobile= '', home, mobile) as phone, group_concat(group_name) as groups from {$addressbook_table}.addressbook join {$addressbook_table}.address_in_groups b using(id) left join {$addressbook_table}.address_in_groups c using(id) left join {$addressbook_table}.group_list d on c.group_id = d.group_id and c.group_id in (6,7,8,9, null) where b.group_id in(3,10) group by id");
return $members;
}
