<?php
##########################################################################
# Please refer to the README file for licensing and contact information.
#
# This file has been updated for version 0.8.20071118
#
# If you like this application, do support me in its development
# by sending any contributions at www.calendarix.com.
#
#
# Copyright © 2002-2007 Vincent Hor
##########################################################################
include ('cal_header.inc.php');
# search title
echo "<br/><table width=100% border=0><tr><td align=left valign=middle>" ;
echo "<div class=searchheaderfont>".ucfirst(translate("search"))."</div></td></tr></table><br/><div class=normalfont>\n";
if (!isset($_POST['search']))
$search = '';
else
$search = sanitize($_POST['search'],'');
if (!isset($_POST['fday']))
$fday = 0;
else
$fday = $_POST['fday'];
if (!isset($_POST['fmonth']))
$fmonth = 0;
else
$fmonth = $_POST['fmonth'];
if (!isset($_POST['fyear']))
$fyear = 0;
else
$fyear = $_POST['fyear'];
if (!isset($_POST['tday']))
$tday = 0;
else
$tday = $_POST['tday'];
if (!isset($_POST['tmonth']))
$tmonth = 0;
else
$tmonth = $_POST['tmonth'];
if (!isset($_POST['tyear']))
$tyear = 0;
else
$tyear = $_POST['tyear'];
if (!isset($_POST['suser']))
$suser = '';
else
$suser = $_POST['suser'];
if (!isset($_POST['catsearch']))
$catsearch = 0;
else
$catsearch = $_POST['catsearch'];
echo "<form action=cal_search.php method=post>\n";
echo "<input type=text name=search size=20 value='".$search."' >\n";
echo "<input type=submit value=\"".translate("search")."\">";
echo " " ;
echo "<b>".translate("From").": </b>\n";
// get days
echo "<select name=fday>\n\t<option value=0>".translate("Day")."\n";
for ($i = 1;$i<=31;$i++){
echo "\t<option value=$i" ;
if ($fday==$i) echo " selected " ;
echo ">$i\n";
}
echo "</select> \n";
// get months
echo "<select name=fmonth>\n\t<option value=0>".translate("Month")."\n";
for($i=1;$i<13;$i++){
echo "\t<option value=".$i ;
if ($fmonth==$i) echo " selected " ;
echo ">".ucfirst($mth[$i])."\n";
}
echo "</select> \n";
// get year from "calstartyear" and give "caladvanceyear" years more to select
echo "<select name=fyear>\n\t<option value=0>".translate("Year")."\n";
$year = date("Y");
for ($i=$calstartyear;$i<=($year+$caladvanceyear);$i++){
echo "\t<option value=$i" ;
if ($fyear==$i) echo " selected " ;
echo ">$i\n";
}
echo "</select> \n";
echo "<b>".translate("To").": </b>\n";
// get days
echo "<select name=tday>\n\t<option value=0>".translate("Day")."\n";
for ($i = 1;$i<=31;$i++){
echo "\t<option value=$i" ;
if ($tday==$i) echo " selected " ;
echo ">$i\n";
}
echo "</select> \n";
// get months
echo "<select name=tmonth>\n\t<option value=0>".translate("Month")."\n";
for($i=1;$i<13;$i++){
echo "\t<option value=".$i ;
if ($tmonth==$i) echo " selected " ;
echo ">".ucfirst($mth[$i])."\n";
}
echo "</select> \n";
// get year from "calstartyear" and give "caladvanceyear" years more to select
echo "<select name=tyear>\n\t<option value=0>".translate("Year")."\n";
$year = date("Y");
for ($i=$calstartyear;$i<=($year+$caladvanceyear);$i++){
echo "\t<option value=$i" ;
if ($tyear==$i) echo " selected " ;
echo ">$i\n";
}
echo "</select> \n";
// Display the users to be selected
echo "<b>".translate("User").": </b> " ;
// get users
$uquery = "select username,user_id from ".$USER_TB ;
$uresult = mysql_query($uquery) ;
echo "<select name=suser >\n";
echo "\t<option value='-'" ;
if (($suser=="-")||($suser=="")) echo " selected " ;
echo ">--\n";
while ($urow = mysql_fetch_object($uresult)){
echo "\t<option value='$urow->username'" ;
if ($suser=="$urow->username") echo " selected " ;
echo ">".$urow->username."\n";
}
echo "</select><br/><br/>\n";
echo "<b>".translate("Category").": </b>\n";
$cquery = "select cat_id,cat_name from ".$CAT_TB." order by cat_name ASC";
$cresult = mysql_query($cquery);
echo "<select name=catsearch>\n";
echo "\t<option value=0" ;
if ($catsearch==0) echo " selected " ;
echo ">".translate("All categories")."\n";
while ($crow = mysql_fetch_object($cresult)){
echo "\t<option value=$crow->cat_id" ;
if ($catsearch==$crow->cat_id) echo " selected " ;
echo ">".stripslashes($crow->cat_name)."\n";
}
echo "</select><br/><br/>\n";
echo "</form>" ;
if (!$search){
echo "<div class=searchheaderfont>".translate("No results")."</div><br/>\n";
}
elseif (strlen($search) < 3){
echo "<div class=searchheaderfont>".translate("No results")."</div><br/>\n";
}
else {
$query = "select id,user,title,description,url,cat_name,day,month,year,approved from ".$EVENTS_TB." left join ".$CAT_TB." on ".$EVENTS_TB.".cat=".$CAT_TB.".cat_id where (title like '%$search%' OR description like '%$search%') ";
// Search within category
if ($catsearch<>0) $query .= " and ".$EVENTS_TB.".cat=".$catsearch ;
// To append the date range in search if given dates are set
$fromclause = FALSE ;
$toclause = FALSE ;
if (($fday!=0)&&($fmonth!=0)&&($fyear!=0)) $fromclause = TRUE ;
if (($tday!=0)&&($tmonth!=0)&&($tyear!=0)) $toclause = TRUE ;
if ($fromclause) {
$query .= " and " ;
$query .= " (" ;
if ($toclause) $query .= "((" ;
$query .= "(year>'$fyear')" ;
if ($toclause) $query .= "&&(year<'$tyear'))" ;
$query .= "||" ;
if ($toclause) $query .= "(" ;
$query .= "(month>'$fmonth' and year='$fyear')" ;
if (($toclause)&&($fyear>=$tyear)) $query .= "&&" ;
else if ($toclause) $query .= "||" ;
if ($toclause) $query .= "(month<'$tmonth' and year='$tyear'))" ;
$query .= "||" ;
if ($toclause) $query .= "(" ;
$query .= "(day>=$fday and month='$fmonth' and year='$fyear')" ;
if (($toclause)&&($tmonth==$fmonth)&&($fyear==$tyear)) $query .= "&&" ;
else if (($toclause)&&($fyear>$tyear)) $query .= "&&" ;
else if (($toclause)&&($fmonth>=$tmonth)&&($fyear==$tyear)) $query .= "&&" ;
else if ($toclause) $query .= "||" ;
if ($toclause) $query .= "(day<=$tday and month='$tmonth' and year='$tyear'))" ;
$query .= ")" ;
if ($toclause) $query .= ")" ;
}
if (($toclause)&&(!$fromclause)) {
$query .= " and ((year<'$tyear')||(month<'$tmonth' and year='$tyear')||(day<=$tday and month='$tmonth' and year='$tyear')) " ;
}
if (($suser!="")&&($suser!="-")) {
$query = $query." and ".$EVENTS_TB.".user='".$suser."' " ;
}
$query .= " order by year ASC, month ASC, day ASC" ;
$result = mysql_query($query);
$rows = mysql_num_rows($result);
if ($rows == 0)
echo "<div class=searchheaderfont>".translate("No results")."</div><br/>\n";
else {
echo "<div class=searchheaderfont>".$rows." ".translate("results")."</div><br/>\n";
while ($row = mysql_fetch_object($result)){
echo "<div class=searchtitlefont><li>".stripslashes($row->title)." (".$row->day ." ".$mth[$row->month]." ".$row->year.")</li></div>";
echo "<div class=searchtextfont><b>".translate("Category")." : </b>".stripslashes($row->cat_name)."</div>";
$de = $row->description;
//$de = str_replace("<br />","",$row->description);
echo "<div class=searchtextfont>".substr(stripslashes($de),0,100)." ...</div>\n" ;
echo "<div class=menufont><a href='cal_event.php?op=view&id=".$row->id."'>";
echo translate("View details or edit")."</a></div>" ;
echo "<br/>";
}
}
}
back();
include ('cal_footer.inc.php');
?>