companysellquery.php

餐饮系统C++ 很强大的软件 多多关照

<?php

/*
	[插件名称] 餐馆主页信息检索 - 替换模版的{#modCompanySellQuery#}
	[适用范围] 餐馆主页信息检索页
	[文 件 名] CompanySellQuery.php
	[更新时间] 2006/9/20
*/


function CompanySellQuery(){

	global $fsql,$tsql,$charset,$tbl_info,$tbl_company,$PagesInfo,$ShowPages,$htmlstr,$CatchOpen;
	global $NowCatid,$NowFold,$MenuInfo,$NowCompanyId;

	$catid=$NowCatid;
	
	$PSET=PlusSet("modCompanySellQuery");
	
	$shownums=PlusDef($PSET["shownums"],"10");
	$ord=PlusDef($PSET["ord"],"uptime");
	$sc=PlusDef($PSET["sc"],"desc");
	$cutword=PlusDef($PSET["cutword"],"90");
	$target=PlusDef($PSET["target"],"_self");
	$showtime=PlusDef($PSET["showtime"],"Y/m/d H:i");
	$tempname=PlusDef($PSET["tempname"],"tpl_infoquery.htm");
	

	$tp=$_GET["tp"];
	
	$showtj=$_GET["showtj"];
	$page=$_GET["page"];
	
	
	if($tp=="search"){
		$catid=$_GET["catid"];
		$infotype=$_GET["infotype"];
		$key=$_GET["key"];
		$zoneid=$_GET["zoneid"];
		$Province=$_GET["Province"];
	}

	$htmlstr=$catid.".html";


	//模版解释
	$Temp=LoadTemp(ROOTPATH."templates/".$MenuInfo["skin"]."/".$tempname);
	$TempArr=SplitTblTemp($Temp);

	$str=$TempArr["start"];

	$now=time();
	$scl="  iffb='1' and bstype='1' and memberid='$NowCompanyId' and exptime>$now ";

	if($catid!="0" && $catid!=""){
		$fmdpath=fmpath($catid);
		$scl.=" and catpath regexp '$fmdpath' ";

	}

	if($zoneid!="0" && $zoneid!=""){
		$zfmdpath=fmpath($zoneid);
		$scl.=" and zonepath regexp '$zfmdpath' ";
	}

	if($showtj!="" && $showtj!="all"){
	$scl.=" and tj='$showtj' ";

	}

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



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

	$totalnums=TblCount($tbl_info,"id",$scl);
	
	$pages->setvar(array("tp" => $tp,"showtj" => $showtj,"infotype" => $infotype,"key" => $key,"catid" => $catid,"zoneid" => $zoneid,"Province" => $Province));

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

	$fsql->query("select * from $tbl_info where $scl order by $ord $sc limit $pagelimit");

	while($fsql->next_record()){
		
		$id=$fsql->f('id');
		$memberid=$fsql->f('memberid');
		$catid=$fsql->f('catid');
		$catpath=$fsql->f('catpath');
		$zoneid=$fsql->f('zoneid');
		$zonepath=$fsql->f('zonepath');
		$infotype=$fsql->f('infotype');
		$title=$fsql->f('title');
		$body=$fsql->f('body');
		$pictype=$fsql->f('pictype');
		$picsrc=$fsql->f('picsrc');
		$dtime=$fsql->f('dtime');
		$uptime=$fsql->f('uptime');
		$exptime=$fsql->f('exptime');


		$comdir=$memberid+100000;

		if($CatchOpen=="1" && file_exists(ROOTPATH."com/".$comdir."/sell/html/".$id.".html")){
			$link=ROOTPATH."com/".$comdir."/sell/html/".$id.".html";
		}else{
			$link=ROOTPATH."com/".$comdir."/sell/html/?".$id.".html";
		}

		if($picsrc!=""){
			$src=ROOTPATH.$picsrc;
		}else{
			$src=ROOTPATH."images/nophoto.gif";
		}

		$body=strip_tags($body);
		if($cutword!="0"){$body=csubstr($body,0,$cutword,$charset)." ...";}

		//取出公司名称
		$tsql->query("select company,zcaddr from $tbl_company where memberid='$memberid'");
		if($tsql->next_record()){
			$company=$tsql->f('company');
			$zcaddr=$tsql->f('zcaddr');
		}

		if($CatchOpen=="1" && file_exists(ROOTPATH."com/".$comdir."/index.html")){
			$companylink=ROOTPATH."com/".$comdir."/index.html";
		}else{
			$companylink=ROOTPATH."com/".$comdir."/index.php";
		}

		$feedbacklink=ROOTPATH."com/".$comdir."/feedback.php";

		$uptime=date($showtime,$uptime);

		$var=array (
		'title' => $title, 
		'company' => $company, 
		'companylink' => $companylink, 
		'feedbacklink' => $feedbacklink, 
		'uptime' => $uptime, 
		'body' => $body, 
		'src' => $src,
		'link' => $link,
		'zcaddr' => $zcaddr,
		'target' => $target

		);

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

		

	}

	$str.=$TempArr["end"];

	$PagesInfo=$pages->ShowNow();
	$ShowPages=$pages->output(1);


		return $str;


}
?>