New popup window Get link Facebook X Pinterest Email Other Apps <br /><?php <br />include "../include/connect.php"; <br />include "../include/settings.php"; <br /> <br />/*Get id and show the details*/ <br />$select ="select * from ".VICTIM." where id='".$_REQUEST['id']."'"; <br />$result=mysql_query($select); <br />$record=mysql_fetch_array($result); <br /> <br />?> <br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <br /><html xmlns="http://www.w3.org/1999/xhtml"> <br /><head> <br /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <br /><title>View Customer's Details</title> <br /><style type="text/css"> <br />div.extraInfo, div.infoBar { <br /> background-color: #efefef; <br /> padding: 3px 10px; <br /> border-bottom: 1px solid #ccc; <br /> font-family: verdana, arial, sans-serif; <br /> font-size: 12px; <br />} <br /> <br />div.extraInfo { <br /> margin-bottom: 5px; <br />} <br /> <br />div.extraInfoTop { <br /> border-top: 1px solid #ccc; <br />} <br /></style> <br /><link href="style.css" rel="stylesheet" type="text/css" /> <br /></head> <br /><body> <br /><table width="100%" cellspacing="0" cellpadding="0" style="background-color:#333366; border-style:solid; border-bottom-color:#3300FF"> <br /> <tr> <br /> <td height="5"></td> <br /> </tr> <br /></table> <br /> <br /><div class="extraInfo"><strong>Victim Details :</strong></div> <br /><table width="100%" border="0" cellspacing="5" cellpadding="0"> <br /> <tr> <br /> <td width="39%"> </td> <br /> <td width="61%" align="right"><a href="#" onclick="javascript:window.close();" style="text-decoration:none;"><font color="#FF0000" >Close X</font></a></td> <br /> </tr> <br /> <tr> <br /> <td colspan="2" class="contentbig"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <br /> <br /> <tr> <br /> <td colspan="3" background="images/loginline2.jpg"><img src="images/loginline2.jpg" width="4" height="1" /></td> <br /> </tr> <br /> <tr> <br /> <td width="1" background="images/loginline1.jpg"></td> <br /> <td height="100%" valign="top" bgcolor="#fafafa"> <br /> <br /> <br /> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td width="3"> </td> <br /> <td class="style3" style="color:#000000"> </td> <br /> <td width="3"> </td> <br /> </tr> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td background="images/loginline.jpg"><img src="images/loginline.jpg" width="4" height="1" /></td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <tr> <br /> <td> </td> <br /> <td><table id="table1" width="100%" border="0" cellspacing="0" cellpadding="3"> <br /> <tr> <br /> <td height="30" colspan="4" align="left" class="style3" style="color:#000000">VICTIM'S DETAILS</td> <br /> </tr> <br /> <tr> <br /> <td width="181" height="30" align="left" class="style31" >Surname</td> <br /> <td width="287" align="left"> <br /> <?php echo $record['victimsurname'];?> </td> <br /> <td width="232" height="30" align="left" class="style31" >Forename</td> <br /> <td width="234" align="left"><?php echo $record['victimforename'];?></td> <br /> </tr> <br /> <br /> <tr> <br /> <td height="30" class="style31" align="left">Parent / Gaurdian </td> <br /> <td colspan="3" class="style31" align="left"> <br /> <?php echo $record['victimparent'];?> <br /> Victim DOB <br /> <?php echo $record['victimdob'];?> <br /> Victim Gender <br /> <br /> <?php echo $record['victimgender']; ?></td> <br /> </tr> <br /> <tr> <br /> <td height="30" class="style31" align="left">Victim Ethnicity </td> <br /> <td align="left"> <br /> <?php echo $record['victimethnicity'];?> </td> <br /> <td> </td> <br /> <td> </td> <br /> </tr> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Victim Address </td> <br /> <td align="left"><?php echo $record['victimaddress'];?> </td> <br /> <td height="30" align="left" class="style31" valign="top" >Victim Telephone </td> <br /> <td align="left"> <br /><?php $victimtelephone_arr=explode(",",$record['victimtelephone']); <br /> if(sizeof($victimtelephone_arr)>=2){ <br /> for($i=0;$i<sizeof($victimtelephone_arr);$i++){ <br /> ?> <br /><?php echo $victimtelephone_arr[$i];?><br /> <br /><?php } }else{ ?><?php echo $record['victimtelephone'];?> <br /><?php } ?> <br /> </td> <br /> </tr> <br /> <tbody id="tele" ></tbody> <br /> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Prison Name</td> <br /> <td align="left"> <br /><?php $prisonname_arr=explode(",",$record['prisonname']); <br /> if(sizeof($prisonname_arr)>=2){ <br /> for($i=0;$i<sizeof($prisonname_arr);$i++){ <br /> ?> <br /><?php echo $prisonname_arr[$i];?><br /> <br /><?php } }else{ ?><?php echo $record['prisonname'];?> <br /><?php } ?> <br /> <br /> <br /> <br /> </td> <br /> <td height="30" align="left" class="style31" >Prison Number </td> <br /> <td align="left"><?php echo $record['prisonnumber'];?></td> <br /> </tr> <br /> <tbody ></tbody> <br /> <br /> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td background="images/loginline.jpg"><img src="images/loginline.jpg" width="4" height="1" /></td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table id="table2" width="100%" border="0" cellspacing="0" cellpadding="3"> <br /> <tr> <br /> <td height="30" colspan="4" align="left" class="style3" style="color:#000000">OFFENDER'S DETAILS</td> <br /> </tr> <br /> <tr> <br /> <td width="181" height="30" align="left" class="style31" >Surname</td> <br /> <td width="288" align="left"> <br /> <?php echo $record['offendersurname'];?> </td> <br /> <td width="233" height="30" align="left" class="style31" >Forename</td> <br /> <td width="232" align="left"><?php echo $record['offenderforename'];?></td> <br /> </tr> <br /> <br /> <tr> <br /> <td height="30" class="style31" align="left">Offender CRN </td> <br /> <td align="left"> <br /> <?php echo $record['offendercrn'];?> </td> <br /> <td class="style31" >Offender DOB </td> <br /> <td align="left"><?php echo $record['offenderdob'];?> </td> <br /> </tr> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Offenses</td> <br /> <td align="left"> <br /><?php $offenses_arr=explode(",",$record['offenses']); <br /> if(sizeof($offenses_arr)>=2){ <br /> for($i=0;$i<sizeof($offenses_arr);$i++){ <br /> ?> <br /><?php echo $offenses_arr[$i];?><br /> <br /><?php } }else{ ?><?php echo $record['offenses'];?> <br /><?php } ?> <br /> <br /> </td> <br /> <td height="30" align="left" class="style31" >Sentense Date </td> <br /> <td align="left"><?php echo $record['sentensedate'];?> </td> <br /> </tr> <br /> <tbody ></tbody> <br /> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Court</td> <br /> <td align="left"> <?php echo $record['court'];?></td> <br /> <td height="30" colspan="2" align="left" class="style31" >Sentense <?php echo $record['sentense'];?> Remand <?php echo $record['remand'];?> </td> <br /> </tr> <br /> <br /> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td background="images/loginline.jpg"><img src="images/loginline.jpg" width="4" height="1" /></td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <br /> <br /> <tr> <br /> <td width="181" height="30" align="left" class="style31" >Prison Number</td> <br /> <td width="289" align="left"><?php echo $record['prisonnumber1'];?> </td> <br /> <td width="233" height="30" align="left" class="style31" >Date of Sentense</td> <br /> <td width="231" align="left"><?php echo $record['dateofsentense'];?> </td> <br /> </tr> <br /> <br /> <tr> <br /> <td width="181" height="30" align="left" class="style31" >Prison Location</td> <br /> <td width="289" align="left"><?php echo $record['prisonlocation'];?> </td> <br /> <td width="233" height="30" align="left" class="style31" ></td> <br /> <td width="231" align="left"></td> <br /> </tr> <br /> <tr> <br /> <td height="30" colspan="4" align="left" class="style31" >HDC/PED/ETD <br /> <?php echo $record['hdc'];?> <br /> ARD/NPD/MTD <br /> <?php echo $record['ard'];?> <br /> LED/LTD <br /> <br /> <?php echo $record['led'];?> <br /> SED <br /> <?php echo $record['sed'];?> </td> <br /> </tr> <br /> <br /> <br /> <br /> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <br /> <br /> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td background="images/loginline.jpg"><img src="images/loginline.jpg" width="4" height="1" /></td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" id="table3" border="0" cellspacing="0" cellpadding="3"> <br /> <tr> <br /> <td height="30" colspan="4" align="left" class="style3" style="color:#000000">LINKS & NOTES </td> <br /> </tr> <br /> <tr> <br /> <td width="181" height="30" align="left" class="style31" >Linked To </td> <br /> <td width="288" align="left"> <br /><?php $linkedto_arr=explode(",",$record['linkedto']); <br /> if(sizeof($linkedto_arr)>=2){ <br /> for($i=0;$i<sizeof($linkedto_arr);$i++){ <br /> ?> <br /><?php echo $linkedto_arr[$i];?><br /> <br /><?php } }else{ ?><?php echo $record['linkedto'];?> <br /><?php } ?> <br /> <br /> <br /> </td> <br /> <td width="237" height="30" align="left" class="style31" >Case No. </td> <br /> <td width="228" align="left"><?php echo $record['caseno'];?></td> <br /> </tr> <br /> <tbody ></tbody> <br /> <tr> <br /> <td height="30" class="style31" align="left">Notes</td> <br /> <td colspan="3" align="left"> <br /> <?php echo $record['notes'];?> </td> <br /> </tr> <br /> <br /> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td background="images/loginline.jpg"><img src="images/loginline.jpg" width="4" height="1" /></td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <br /> <tr> <br /> <td height="30" colspan="4" align="left" class="style3" style="color:#000000">OFFICER(OFFENDES MANAGER/MENTAL HEALTH WORKER) </td> <br /> </tr> <br /> <tr> <br /> <td width="179" height="30" align="left" class="style31" >Location</td> <br /> <td width="293" rowspan="2" align="left"> <br /> <?php echo $record['location'];?> </td> <br /> <td width="237" height="30" align="left" class="style31" >Telephone No. </td> <br /> <td width="225" align="left"><?php echo $record['telephoneno'];?></td> <br /> </tr> <br /> <tr> <br /> <td width="179" height="30" align="left" class="style31" > </td> <br /> <td height="30" align="left" class="style31" >Victim Liasion Officer </td> <br /> <td align="left"><?php echo $record['victimliasionofficer'];?></td> <br /> </tr> <br /> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <br /> <tr> <br /> <td background="images/loginline.jpg"><img src="images/loginline.jpg" width="4" height="1" /></td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> <tr> <br /> <td> </td> <br /> <td><table width="100%" border="0" cellspacing="0" cellpadding="3"> <br /> <br /> <tr> <br /> <td width="181" height="30" align="left" class="style31" >Stats Date </td> <br /> <td width="289" align="left"><?php echo $record['statsdate'];?> <br /> </td> <br /> <td width="240" height="30" align="left" class="style31" >Contact VCR/SFR </td> <br /> <td width="224" align="left"> <br /> <?php echo $record['contactvcr'];?></td> <br /> </tr> <br /> <tr> <br /> <td height="30" class="style31" align="left">Review Date </td> <br /> <td align="left"><?php echo $record['reviewdate'];?> <br /> </td> <br /> <td class="style3" > </td> <br /> <td> </td> <br /> </tr> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Status</td> <br /> <td align="left"><?php echo $record['status'];?> </td> <br /> <td height="30" align="left" class="style31" > </td> <br /> <td> </td> <br /> </tr> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Victim known to VC </td> <br /> <td align="left"><?php echo $record['victimknownvc'];?> </td> <br /> <td height="30" colspan="2" align="left" class="style31" > </td> <br /> </tr> <br /> <tr> <br /> <td height="30" align="left" class="style31" >Offender known to VC </td> <br /> <td align="left"><?php echo $record['offenderknownvc'];?> </td> <br /> <td height="30" colspan="2" align="left" class="style31" > </td> <br /> </tr> <br /> </table></td> <br /> <td> </td> <br /> </tr> <br /> <br /> </table> <br /> </td> <br /> <td width="1" background="images/loginline1.jpg" align="right"></td> <br /> </tr> <br /> <br /> <tr> <br /> <td colspan="3" background="images/loginline2.jpg"><img src="images/loginline2.jpg" width="4" height="1" /></td> <br /> </tr> <br /> <br /> </table></td> <br /> </tr> <br /> <br /> <tr> <br /> <td><div align="right"></div></td> <br /> <td> </td> <br /> </tr> <br /></table> <br /> <br /> <br /></body> <br /></html> <br /> Get link Facebook X Pinterest Email Other Apps