rendered paste body<?php
require_once('config/smarty.conf');
require_once('dataaccesslayer/manager.php');
require_once("dataaccesslayer/dbmanager.php");
require_once("dataaccesslayer/contctsdbmanager.php");
require_once("dataaccesslayer/tagdbmanager.php");
require_once("main.php");
session_start();
//$right = $_SESSION["rights"];
//$smarty->assign("right", $right);
if (isset($_POST["search"])) {
if (isset($_REQUEST["name"])||isset($_REQUEST["lname"]) ||
isset($_REQUEST["place"]) ||
isset($_REQUEST["department"])||
isset($_REQUEST["position"])||
isset($_REQUEST["off_phone1"])||
isset($_REQUEST["off_phone2"])||
isset($_REQUEST["mobile"])||
isset($_REQUEST["home"])||
isset($_REQUEST["email1"])||
isset($_REQUEST["email2"])||
isset($_REQUEST["comment"])) {
if(isset($_GET["start"])) $start=$_GET["start"];
else $start = $start1;
$first_name = trim(strip_tags(stripslashes($_REQUEST["name"])));
$last_name = trim(strip_tags(stripslashes($_REQUEST["lname"])));
$university_company = trim(strip_tags(stripslashes($_REQUEST["place"])));
$department = trim(strip_tags(stripslashes($_REQUEST["department"])));
$position = trim(strip_tags(stripslashes($_REQUEST["position"])));
$off_phone1 = trim(strip_tags(stripslashes($_REQUEST["off_phone1"])));
$off_phone2 = trim(strip_tags(stripslashes($_REQUEST["off_phone2"])));
$mobile = trim(strip_tags(stripslashes($_REQUEST["mobile"])));
$home = trim(strip_tags(stripslashes($_REQUEST["home"])));
$email1 = trim(strip_tags(stripslashes($_REQUEST["email1"])));
$email2 = trim(strip_tags(stripslashes($_REQUEST["email2"])));
$comment = trim(strip_tags(stripslashes($_REQUEST["comment"])));
//print_r($_REQUEST);
$eu = ($start - 0);
$limit = 10; // No of records to be shown per page.
$this_page = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;
$page_name = "phonebooksearch.php";
$number = contcts::search($first_name,$last_name, $university_company,
$department, $position,$off_phone1, $off_phone2,
$mobile, $home,$email1, $email2, $comment ,"","","");
$nume = count($number);
$search = contcts::search($first_name,$last_name, $university_company,
$department, $position,$off_phone1, $off_phone2,
$mobile, $home,$email1, $email2, $comment ,"", $eu,$limit);
if ($search) {
?>
<script>
function deleteById(cntct_id)
{
document.getElementById("cntct").checked=true;
document.getElementById("delete_button").click();
}
</script>
<?php
if ($first_name!="")
{
$result = tags::IsDaplicated($first_name, "");
if (!$result)
tags::insertRecord($first_name,"name");
}
if ($last_name !=""){
$result = tags::IsDaplicated($last_name, "");
if (!$result)
tags::insertRecord($last_name,"lname");
}
if ($university_company != ""){
$result = tags::IsDaplicated($university_company, "");
if (!$result)
tags::insertRecord($university_company,"place");
}
if ($department){
$result = tags::IsDaplicated($department, "");
if (!$result)
tags::insertRecord($department,"department");
}
if ($position !=""){
$result = tags::IsDaplicated($position, "");
if (!$result)
tags::insertRecord($position,"position");
}
if ($comment !=""){
$result = tags::IsDaplicated($comment, "");
if (!$result)
tags::insertRecord($comment,"comment");
}
$output = "<table align='center' border=1><tr>";
if ($_SESSION["rights"] != 0) {
$output .= "<form action='' method='POST' name='dsform' id='dsform'><td></td>";
}
$output .="<td>First Name</td>
<td>Last Name</td><td>University/Company</td>
<td>Department</td><td>Position</td><td>Office phone1</td>
<td>Office phone2</td><td>Extension</td>
<td>Mobile</td><td>Home</td><td>Email1</td><td>Email2</td>
<td>Comment</td><td>Mail</td>";
if ($_SESSION["rights"] != 0) {
if (isset($_POST['contct_id'])) {
$id = $_POST["contct_id"];
foreach ($id as $ids){
contcts::deleteRecord($ids);
}
echo "Contact deleted successfully";
}
$output .="<td>Last update</td><td colspan='3'></td>";
}
$output .= "</tr>";
foreach ($search as $results){
$output .= "<tr>";
if ($_SESSION["rights"] != 0) {
$output .= "<td><input type='checkbox' name='cntct[]' id='cntct'/></td>";
}
$output .= "<td>".$results->first_name."</td>";
$output .= "<td>".$results->last_name."</td>";
$output .= "<td>".$results->university_company."</td>";
$output .= "<td>".$results->department."</td>";
$output .= "<td>".$results->position."</td>";
$output .= "<td>".$results->off_phone1."</td>";
$output .= "<td>".$results->off_phone2."</td>";
$output .= "<td>".$results->extension."</td>";
$output .= "<td>".$results->mobile."</td>";
$output .= "<td>".$results->home."</td>";
$output .= "<td>".$results->email1."</td>";
$output .= "<td>".$results->email2."</td>";
$output .= "<td>".$results->commnt."</td>";
$output .= "<td><a href='mail.php?id=$results->id' onclick='Modalbox.show(this.href, {title: this.title, transitions: false}); return false;'/>Email</a></td>";
if ($_SESSION["rights"] != 0) {
$output .= "<td>".$results->last_up."</td>";
$output .= "<td><a href='javascript:void()' onclick=\"window.open('managecontacts.php?tsk=edt&id=$results->id');\">Edit</a></td>";
$output .= "<td><a href='javascript:void()' onclick='deleteById($results->id)'>delete</a></td>";
}
$output .= "</tr>";
}
if ($_SESSION["rights"] != 0) {
$output .="<tr><td colspan='18' align='center'><input type='submit' id='delete_button' name='submit' value='Delete'/></td></tr></form>";
}
$output .= "</table>";
$output .="<table align = 'center' ><tr><td align='left'>";
if($back >=0) {
$output .= "<a href='".$page_name."&start=".$back."'>Prev</a>";
}
$output .= "</td><td align=center width='30%'>";
$n=0;
$r=1;
for($n=0;$n < $nume;$n=$n+$limit) {
if($n <> $eu)
{
$output .= "<a href='$page_name&start=$n'>$r</a> ";
}
else {
$output .= "<span class=attribute-name>$r </span>";
}
$r=$r+1;
}
$output .= "</td>";
$output .= "<td align='right' >";
if($this_page < $nume) {
$output .= "<a href='$page_name&start=$next'>Next</a>";
}
$output .= "</td></tr></table>";
}
}
}
$tags = tags::getAll("", "");
if ($tags != "") {
foreach ($tags as $tag) {
$tagresult .= "<a href='phonebooksearch.php?$tag->type=$tag->name'>$tag->name</a> " ;
}
}
$smarty->assign("result", $output);
$smarty->assign("tags", $tagresult);
$smarty->display("search.tpl");
?>