<?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; }