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; } ?>