require_once('./admin/x/bin/w_init.php');
//require_once('../x/bin/w_init.php');
//$base_dir = "http://localhost/pep/fe";
//$base_dir = "http://rada.softcall.co.ke";
$base_dir = "https://rada-portal.tikenya.org";
$id = "";
if (isset($_GET['id'])) $id = trim($_GET['id']);
$params = explode('/', trim($_SERVER['REQUEST_URI'], '/'));
$type = $params[1];
if ($type=="") $type="cases";
if (isset($_GET['type'])) $type=$_GET['type'];
$category = "";
if (isset($_GET['category'])) {
if ($type=="cases")
{
if($_GET['category']!=""){
$par = ' AND T.Type="'.stripslashes(trim($_GET['category'])).'"';
} else {
$par = ' AND T.Type IS NULL';
}
} elseif ($type=="persons") {
$par = ' AND T.Persontype="'.stripslashes(trim($_GET['category'])).'"';
} elseif ($type=="places") {
$par = ' AND T.Placetype="'.stripslashes(trim($_GET['category'])).'"';
}
}
if ($type=="cases") {
$sql = 'SELECT DISTINCT C.Case_ID, C.Case_No, C.Case_Name, C.Summary, C.Date_First_Offence, C.Start_Date, C.File
FROM `cases` C
LEFT JOIN case_options O ON C.Case_ID = O.Case_ID AND Type = "Case"
LEFT JOIN `type_case` T ON O.Option_ID= T.Type_Id
LEFT JOIN `type_charge` H ON C.Charge_ID = H.Charge_ID
LEFT JOIN `type_judgement` J ON C.Judgement_ID = J.Judgement_ID
WHERE C.Active=1'.$par;
} elseif ($type=="places") {
$sql = 'SELECT DISTINCT P.Place_ID, P.Place, P.Address, P.County, T.Placetype
FROM `places` P
LEFT JOIN `case_places` C ON C.Place_ID = P.Place_ID
LEFT JOIN `type_place` T ON C.Placetype_ID = T.Placetype_ID
WHERE P.Active=1'.$par;
} elseif ($type=="persons") {
$sql = 'SELECT DISTINCT P.Person_ID, P.Name, P.Email, T.Persontype
FROM `persons` P
LEFT JOIN `type_person` T ON P.Type = T.Persontype_ID
WHERE P.Active=1'.$par;
}
if ( isset($_POST['Searchb']) )
{
$search = trim($_POST['Search']); if ( get_magic_quotes_gpc() ) $search= stripslashes($search);
if ($type=="cases") {
$sql = 'SELECT C.Case_ID, C.Case_No, C.Case_Name, C.Summary, C.Date_First_Offence, C.Start_Date, C.File
FROM `cases` C
LEFT JOIN `type_case` T ON C.Type_ID = T.Type_Id
LEFT JOIN `type_charge` H ON C.Charge_ID = H.Charge_ID
LEFT JOIN `type_judgement` J ON C.Judgement_ID = J.Judgement_ID
WHERE C.Active=1 AND (C.Case_Name LIKE "%'.$search.'%" OR C.Case_No LIKE "%'.$search.'%" OR C.Summary LIKE "%'.$search.'%")';
} elseif ($type=="places") {
$sql = 'SELECT P.Place_ID, P.Place, P.Address, P.County, T.Placetype
FROM `places` P
LEFT JOIN `type_place` T ON P.Placetype_ID = T.Placetype_ID
WHERE P.Active=1 AND (P.Place LIKE "%'.$search.'%" OR T.Placetype LIKE "%'.$search.'%")';
} elseif ($type=="persons") {
$sql = 'SELECT P.Person_ID, P.Name, P. Email, T.Persontype
FROM `persons` P
LEFT JOIN `type_person` T ON P.Type = T.Persontype_ID
WHERE P.Active=1 AND (P.Name LIKE "%'.$search.'%" OR T.Persontype LIKE "%'.$search.'%")';
}
}
?>
Rada by Transparency InternationalLeedsSource | Salesforce, Supercharged