From 227281197ed5f4736fbba4df7bce975bcf3ca2e5 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Thu, 14 Nov 2013 00:47:34 +0000 Subject: Files for the basic search interface. --- dockets.php | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 dockets.php (limited to 'dockets.php') diff --git a/dockets.php b/dockets.php new file mode 100644 index 0000000..f8416c2 --- /dev/null +++ b/dockets.php @@ -0,0 +1,57 @@ + + + + + Miami-Dade Clerk of Courts: Dockets + + + + +HTML; + +$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.'); + +echo << + + ID + Seq. No. + Date + Docket + Case ID + +HTML; + + +$st = $dbh->prepare("SELECT court_case_no FROM cases WHERE id = '{$_GET['case_id']}'"); +if ( $st->execute() ) { + while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + echo "

Dockets for case {$row['court_case_no']}

"; + } +} + +$st = $dbh->prepare("SELECT * FROM dockets WHERE case_id = '{$_GET['case_id']}'"); +if ( $st->execute() ) { + $alt = 'alt'; + while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + $alt = $alt ? '' : 'alt'; + echo " \n"; + echo " \n"; + foreach ( $row as $field ) { + echo " $field\n"; + } + echo " \n"; + } +} + +echo << + + + +HTML; + +?> -- cgit v1.2.3 From e4e405d6a6b48dd90d38255834d745f66acdc877 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Thu, 14 Nov 2013 21:16:26 +0000 Subject: Use x-small text only in the results tables, not on the body of any page. --- charges.php | 2 +- dockets.php | 2 +- index.php | 15 +++------------ search.php | 3 ++- style.css | 4 +++- 5 files changed, 10 insertions(+), 16 deletions(-) (limited to 'dockets.php') diff --git a/charges.php b/charges.php index ee9c9b2..55536ce 100644 --- a/charges.php +++ b/charges.php @@ -14,7 +14,7 @@ HTML; $dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.'); echo << + diff --git a/dockets.php b/dockets.php index f8416c2..6805a3a 100644 --- a/dockets.php +++ b/dockets.php @@ -15,7 +15,7 @@ HTML; $dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.'); echo << +
ID Case ID
diff --git a/index.php b/index.php index 2a3971e..dfdca68 100644 --- a/index.php +++ b/index.php @@ -1,19 +1,10 @@ - - - Miami-Dade Clerk of Courts Search - - + Miami-Dade Clerk of Courts: Search + @@ -131,7 +122,7 @@ for ( $year = date("Y"); $year >= 1990; $year-- ) { ?> (dd/mm/yyyy)
- + diff --git a/search.php b/search.php index 169e56e..30f4dd0 100644 --- a/search.php +++ b/search.php @@ -162,6 +162,7 @@ if ( $where_parts ) { } } else { echo "You must enter at least one search criteria."; + exit; } $sql = $select . $where; @@ -172,7 +173,7 @@ if ( $st->execute() ) { echo "

$row_count records found.

\n"; echo << +
ID Seq. No.
diff --git a/style.css b/style.css index f1b0ab3..89aea51 100644 --- a/style.css +++ b/style.css @@ -1,4 +1,4 @@ -body { +.results_table { font-size: x-small; } @@ -21,3 +21,5 @@ tr.tablehead { tr.alt { background-color: #eeeeee; } + +#case_num { width: 5em; } -- cgit v1.2.3 From dcbf0e118f7c4350dbaefb86026f4262ae6accfd Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Thu, 14 Nov 2013 22:03:26 +0000 Subject: Added a page for AKAs and also cleaned up how court_case_no is found on various pages. --- akas.php | 51 ++++++++++++++++++++++++++++++++++++++++++++++ charges.php | 7 +------ dockets.php | 8 +------- miami-dade_clerk_courts.py | 2 +- search.php | 17 ++++++++++++---- 5 files changed, 67 insertions(+), 18 deletions(-) create mode 100644 akas.php (limited to 'dockets.php') diff --git a/akas.php b/akas.php new file mode 100644 index 0000000..36e3542 --- /dev/null +++ b/akas.php @@ -0,0 +1,51 @@ + + + + + Miami-Dade Clerk of Courts: AKAs + + + +HTML; + +$dbh = new PDO('mysql:host=localhost;dbname=mdcc', 'mdcc', 'Mdcc.'); + +echo << + + + + + + + + + +HTML; + +echo "

AKAs for case {$_GET['case_no']}

"; + +$st = $dbh->prepare("SELECT * FROM akas WHERE case_id = '{$_GET['case_id']}'"); +if ( $st->execute() ) { + $alt = 'alt'; + while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + $alt = $alt ? '' : 'alt'; + echo " \n"; + foreach ( $row as $field ) { + echo " \n"; + } + echo " \n"; + } +} + +echo << + + + +HTML; + +?> diff --git a/charges.php b/charges.php index 55536ce..ba76d0d 100644 --- a/charges.php +++ b/charges.php @@ -25,12 +25,7 @@ echo << HTML; -$st = $dbh->prepare("SELECT court_case_no FROM cases WHERE id = '{$_GET['case_id']}'"); -if ( $st->execute() ) { - while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { - echo "

Charges for case {$row['court_case_no']}

"; - } -} +echo "

Charges for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM charges WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { diff --git a/dockets.php b/dockets.php index 6805a3a..9edb3cc 100644 --- a/dockets.php +++ b/dockets.php @@ -26,12 +26,7 @@ echo <<prepare("SELECT court_case_no FROM cases WHERE id = '{$_GET['case_id']}'"); -if ( $st->execute() ) { - while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { - echo "

Dockets for case {$row['court_case_no']}

"; - } -} +echo "

Dockets for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM dockets WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { @@ -39,7 +34,6 @@ if ( $st->execute() ) { while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { $alt = $alt ? '' : 'alt'; echo " \n"; - echo " \n"; foreach ( $row as $field ) { echo " \n"; } diff --git a/miami-dade_clerk_courts.py b/miami-dade_clerk_courts.py index 31ecea0..04132d3 100755 --- a/miami-dade_clerk_courts.py +++ b/miami-dade_clerk_courts.py @@ -477,7 +477,7 @@ def main(): # Keep track of how many NOT FOUND errors we get. case_not_found_count = 0 - for seq in range(1, 100000): + for seq in range(4299, 100000): if case_not_found_count > max_case_not_found_count: # If our not_found_count exceeds the maximum set, diff --git a/search.php b/search.php index 30f4dd0..f786db1 100644 --- a/search.php +++ b/search.php @@ -203,13 +203,22 @@ HTML; $alt = 'alt'; while ( $row = $st->fetch(PDO::FETCH_ASSOC) ) { + $akas_sql = "SELECT * FROM akas where case_id = '{$row['id']}'"; + $akas_st = $dbh->prepare($akas_sql); + if ( $akas_st->execute() ) { + $akas_rows = $akas_st->rowCount(); + } $alt = $alt ? '' : 'alt'; echo " \n"; - foreach ( $row as $field ) { - echo " \n"; + foreach ( $row as $field => $value ) { + if ( 'name' == $field && $akas_rows ) { + echo " \n"; + } else { + echo " \n"; + } } - echo " \n"; - echo " \n"; + echo " \n"; + echo " \n"; echo " \n"; } } -- cgit v1.2.3 From 5f276a29ae0041b63ec84bef909fdb11cb3f8751 Mon Sep 17 00:00:00 2001 From: Nathan Kinkade Date: Fri, 7 Feb 2014 17:59:14 +0000 Subject: Make court case number link back to main case information page. --- akas.php | 2 +- charges.php | 2 +- dockets.php | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'dockets.php') diff --git a/akas.php b/akas.php index 36e3542..f6e657b 100644 --- a/akas.php +++ b/akas.php @@ -26,7 +26,7 @@ echo << HTML; -echo "

AKAs for case {$_GET['case_no']}

"; +echo "

AKAs for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM akas WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { diff --git a/charges.php b/charges.php index ba76d0d..e0eb95d 100644 --- a/charges.php +++ b/charges.php @@ -25,7 +25,7 @@ echo << HTML; -echo "

Charges for case {$_GET['case_no']}

"; +echo "

Charges for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM charges WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { diff --git a/dockets.php b/dockets.php index 9edb3cc..6cba902 100644 --- a/dockets.php +++ b/dockets.php @@ -26,7 +26,7 @@ echo <<Dockets for case {$_GET['case_no']}"; +echo "

Dockets for case {$_GET['case_no']}

"; $st = $dbh->prepare("SELECT * FROM dockets WHERE case_id = '{$_GET['case_id']}'"); if ( $st->execute() ) { -- cgit v1.2.3
ID State Case No.
IDCase IDLast nameFirst nameMiddle nameRaceSex
$field
$field
$field$value$valueChargesDocketsChargesDockets