www.gusucode.com > 2028网博士成品网站管理系统 PHP网站源码程序 > 2028/hospital/module/HospitalExpertQuery.php

    <?php

/*
	[插件名称] 专家检索搜索
	[适用范围] 专家检索页
*/


function HospitalExpertQuery(){

	global $msql,$fsql,$tsql,$strGuest;

	
	$shownums=$GLOBALS["PLUSVARS"]["shownums"];
	$cutword=$GLOBALS["PLUSVARS"]["cutword"];
	$cutbody=$GLOBALS["PLUSVARS"]["cutbody"];
	$target=$GLOBALS["PLUSVARS"]["target"];
	$tempname=$GLOBALS["PLUSVARS"]["tempname"];


	//地址栏参数

	if(strstr($_SERVER["QUERY_STRING"],".html")){
		$Arr=explode(".html",$_SERVER["QUERY_STRING"]);
		$hecatid=$catid=$Arr[0];
	}elseif($_GET["catid"]>0){
		$hecatid=$catid=$_GET["catid"];
	}else{
		$hecatid=$catid=0;
	}



	$page=$_GET["page"];
	$key=$_GET["key"];
	$myord=$_GET["myord"];
	$myshownums=$_GET["myshownums"];


	if($myshownums!="" && $myshownums!="0"){
		$shownums=$myshownums;
	}
	
	if($myord==""){
		$myord="uptime";
	}


	//模版解释
	$Temp=LoadTemp($tempname);
	$TempArr=SplitTblTemp($Temp);

	$str=$TempArr["start"];


	$scl=" iffb='1' and contype='hospital' ";

	if($catid!="0" && $catid!=""){
		$scl.=" and catid='$catid' ";
	}

	if($key!=""){
		
		$scl.=" and (name regexp '$key' or specialty regexp '$key' or body regexp '$key') ";
	}	
	
	include(ROOTPATH."includes/pages.inc.php");
	$pages=new pages;

	$totalnums=TblCount("_hospital_con","id",$scl);
	
	$pages->setvar(array("catid" => $catid,"myord" => $myord,"myshownums" => $myshownums,"key" => $key));

	$pages->set($shownums,$totalnums);		                          
		
	$pagelimit=$pages->limit();	  

	$fsql->query("select * from {P}_hospital_con where $scl order by $myord desc limit $pagelimit");
	while($fsql->next_record()){
		
			$id=$fsql->f('id');
			$catid=$fsql->f('catid');
			$name=$fsql->f('name');
			$specialty=$fsql->f('specialty');
			$zhicheng=$fsql->f('zhicheng');
			$body=$fsql->f('body');
			$type=$fsql->f('type');
			$src=$fsql->f('src');
			$dtime=$fsql->f('dtime');
			$uptime=$fsql->f('uptime');

			//2.16 by quyuxiang start
			$body=str_replace("<br>","...",$body);
			$body=str_replace("\n","...",$body);

			$body=strip_tags($body);
			//$body=csubstr($body,0,80);
			//2.16 by quyuxiang end


			//获取科室信息
			$msql->query("select cat from {P}_hospital_cat where catid='$catid'");
			if($msql->next_record()){
				$cat=$msql->f('cat');
			}
			
			if($src==""){
				$src="hospital/pics/nopic.gif";
			}
			$src=ROOTPATH.$src;

			$dtime=date("Y-m-d",$dtime);
			$uptime=date("Y-m-d",$uptime);
			
			if($cutword!="0"){$name=csubstr($name,0,$cutword);}
			if($cutbody!="0"){$body=csubstr($body,0,$cutbody);}

			if($GLOBALS["CONF"]["CatchOpen"]=="1" && file_exists(ROOTPATH."hospital/html/".$id.".html")){
				$link=ROOTPATH."hospital/html/".$id.".html";
			}else{
				$link=ROOTPATH."hospital/html/?".$id.".html";
			}



			$var=array (
				'id' => $id,
				'catid' => $catid,
				'cat' => $cat,
				'name' => $name,
				'specialty' => $specialty,
				'zhicheng' => $zhicheng,
				'body' => $body,
				'dtime' => $dtime, 
				'uptime' => $uptime, 
				'cl' => $cl, 
				'link' => $link,
				'src' => $src, 
				'target' => $target
			);


			$str.=ShowTplTemp($TempArr["list"],$var);
		

	}



	$pagesinfo=$pages->ShowNow();

	$var=array (
		'rid' => $rid,
		'catlist' => $catlist,
		'showform' => $showform,
		'showpages' => $pages->output(1),
		'pagestotal' => $pagesinfo["total"],
		'pagesnow' => $pagesinfo["now"],
		'pagesshownum' => $pagesinfo["shownum"],
		'pagesfrom' => $pagesinfo["from"],
		'pagesto' => $pagesinfo["to"],
		'totalnums' => $totalnums,
		'bfsite' => $bfsite,
		'bfcatid' => $bbscatid
	);

	$str.=ShowTplTemp($TempArr["end"],$var);


	return $str;


}
?>