--- new.php	2001/02/28 14:16:33	1.9
+++ new.php	2002/04/29 13:11:39	1.24
@@ -6,43 +6,34 @@
 
 $smarty->assign( array ( Title=>"Pliva d.d." ) );
 
-
 if (isset($from)) {
 	$section=$from;
 } else {
 	$section="new";
 }
 
-$sql_where="where visible is true";
+$sql_where="where $visible_is_true";
+
+include("section.inc");
 
 if ($section == "investor") {
-	$title="INVESTOR'S PAGE";
-	$lpic="investor"; $lext=".jpg";
-	$mpic="investors.gif";
 	$back_url="investor.php";
-	$sql_where .= " and type='i'";
+	if (! isset($type)) {
+		$sql_where .= " and type='i'";
+	}
 	$title.=" : Investors News";
-} elseif ($section == "about") {
-	$title="ABOUT US";
-	$lpic="about"; $lext=".gif";
-	$mpic="about.gif";
 } else {
 	$title="What's New";
 	$lpic="new"; $lext=".jpg";
 	$mpic="new.gif";
 	$back_url="index.php";
+	$sql_where.=" and (type='a' or type='c' or type='e' or type='f' or type='i' or type='n' or type='p' or type='r')";		// don't show company profile
 }
 
 $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, ) );
 
-
-function find_html_file($dir,$file) {
-	$file="./$dir/$file";
-	if (is_file("$file") && file_exists("$file")) { return "$file"; }
-	if (is_file("$file.htm") && file_exists("$file.htm")) { return "$file.htm"; }
-	if (is_file("$file.html") && file_exists("$file.html")) { return "$file.html"; }
-	return 0;
-}
+include("find_html_file.inc");
+include("news_type.inc");
 
 if (file_exists(find_html_file("news",$more))) {
 
@@ -57,14 +48,10 @@
 	if (isset($type)) {
 		if ($type == "n") {
 			$sql_where .= " and (type='n' or type='i')";
-			$title.=" : News";
-		} elseif ($type == "e") {
-			$sql_where .= " and type='e'";
-			$title.=" : Events";
-		} elseif ($type == "c") {
-			$sql_where .= " and type='c'";
-			$title.=" : Community";
+		} elseif ($type == "e" || $type == "f" || $type == "c") {
+			$sql_where .= " and type='".$type."'";
 		}
+		$title.=" : ".$news_type[$type];
 	}
 
 	if (! isset($show) && !isset($start)) {
@@ -74,6 +61,16 @@
 	}
 
 
+	if (isset($days)) {
+		if ($days != 0) {
+			$sql_where.=" and date(now())-date(date) > 0 and date(now())-date(date) < $days";
+			$title.=" : News in last $days days";
+		}
+		$smarty->assign("days",$days);
+		$smarty->assign("last_days",array(14,30,160,240,365));
+		$smarty->assign("last_desc",array("two weeks","one month","four months","six months","one year"));
+	}
+
 	$num_selected=0;
 	$sql="select
 			id,upper(title) as title,town_date,body,more,pdf,
@@ -88,31 +85,39 @@
 	}
 
 	if ($num_selected == 10) {
+		$tmp="$PHP_SELF?start=".($start+10);
+		if ($days) $tmp.="&days=$days";
+		if ($from) $tmp.="&from=$from";
 		$smarty->assign(array(
 			"multi_page_show" => 1,
-			"multi_page_next" => "$PHP_SELF?start=".($start+10),
+			"multi_page_next" => $tmp
 		));
 	}
 	if ($start && $start >= 10) {
+		$tmp="$PHP_SELF?start=".($start-10);
+		if ($days) $tmp.="&days=$days";
+		if ($from) $tmp.="&from=$from";
 		$smarty->assign(array(
 			"multi_page_show" => 1,
-			"multi_page_prev" => "$PHP_SELF?start=".($start-10),
+			"multi_page_prev" => $tmp
 		));
 	}
 
 	if (isset($id) && $num_selected == 1) {
-		if ($data[0][type] == "n") {
-			$title.=" : News : ".$data[0][title_lc];
-		} elseif ($data[0][type] == "e") {
-			$title.=" : Event : ".$data[0][title_lc];
-		} elseif ($data[0][type] == "c") {
-			$title.=" : Community : ".$data[0][title_lc];
-		} elseif ($data[0][type] == "r") {
-			$title.=" : Result : ".$data[0][title_lc];
-		}
+		$title.=" : ".$news_type[ $data[0][type] ]." : ".$data[0][title_lc];
 	}
 
-	$smarty->assign("data",$data);
+
+	if (isset($days) && $num_selected == 0) {
+		$warning = "There are no news for last $days days.";
+	} elseif ($main == "" && $num_selected == 0) {
+		$warning = "This news item is no longer available";
+	}
+
+	$smarty->assign(array(
+		data=>$data,
+		warning=>$warning
+		));
 
 	$main=$smarty->fetch("new.tpl");
 
@@ -120,9 +125,6 @@
 		$main=join('',file(find_html_file("news",$data[0][more])));
 	}
 
-	if ($main == "") {
-		$main = "This news item is no longer available";
-	}
 
 }
 
@@ -130,5 +132,7 @@
 $smarty->assign( array(back_url=>$back_url, MAIN=>$main,
 	Section_title=>$title ) );
 
+include("inc/newsletter.php");
+
 $smarty->display("index.tpl");
 ?>