www.gusucode.com > 2033网博士成品网站管理系统 PHP网站源码程序 > 2033/huanzeng/module/HzMemberOrder.php

    <?php


function HzMemberOrder(){

	global $fsql,$msql;

	$tempname=$GLOBALS["PLUSVARS"]["tempname"];
	$memberid=$_COOKIE["MEMBERID"];

	//地址栏参数
	$key=$_GET["key"];
	$showyun=$_GET["showyun"];
	$showok=$_GET["showok"];
	$startday=$_GET["startday"];
	$endday=$_GET["endday"];

	if($startday=="" || $endday==""){
		$endday=date("Y-m-d");
		$enddayArr=explode("-",$endday);
		$endtime=mktime(23,59,59,$enddayArr[1],$enddayArr[2],$enddayArr[0]);
		$starttime=$endtime-691199;
		$startday=date("Y-m-d",$starttime);
	}else{
		$enddayArr=explode("-",$endday);
		$endtime=mktime(23,59,59,$enddayArr[1],$enddayArr[2],$enddayArr[0]);
		$startdayArr=explode("-",$startday);
		$starttime=mktime(0,0,0,$startdayArr[1],$startdayArr[2],$startdayArr[0]);
	}

	if($showyun==""){$showyun="all";}
	if($showok==""){$showok="0";}


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

	$var=array (
		'key' => $key,
		'showpay' => $showpay,
		'showyun' => $showyun, 
		'showok' => $showok, 
		'startday' => $startday, 
		'endday' => $endday, 
	);

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

	$scl=" memberid='$memberid' and iftui!='1' and dtime>$starttime and dtime<$endtime ";

	if($showpay=="1" || $showpay=="0"){
		$scl.=" and ifpay='$showpay' ";
	}

	if($showyun=="1" || $showyun=="0"){
		$scl.=" and ifyun='$showyun' ";
	}

	if($showok=="1" || $showok=="0"){
		$scl.=" and ifok='$showok' ";
	}

	if($key!=""){
		$scl.=" and (items regexp '$key' or name regexp '$key' or user regexp '$key' or OrderNo regexp '$key' or address regexp '$key') ";
	}
	

	include(ROOTPATH."includes/pages.inc.php");
	$pages=new pages;

	$totalnums=TblCount("_hz_order","orderid",$scl);
	
	$pages->setvar(array(
		"key" => $key,
		"startday" => $startday,
		"endday" => $endday,
		"showpay" => $showpay,
		"showyun" => $showyun,
		"showok" => $showok
		));

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

	$msql->query("select * from {P}_hz_order where $scl order by dtime desc limit $pagelimit");
	while($msql->next_record()){
		$orderid=$msql->f('orderid');
		$OrderNo=$msql->f('OrderNo');
		$memberid=$msql->f('memberid');
		$user=$msql->f('user');
		$name=$msql->f('name');
		$tel=$msql->f('tel');
		$address=$msql->f('address');
		$postcode=$msql->f('postcode');
		$totalcent=$msql->f('totalcent');
		$iflook=$msql->f('iflook');
		$ifpay=$msql->f('ifpay');
		$ifyun=$msql->f('ifyun');
		$ifok=$msql->f('ifok');
		$iftui=$msql->f('iftui');
		$ip=$msql->f('ip');
		$dtime=$msql->f('dtime');
		$yuntime=$msql->f('yuntime');
		$paytime=$msql->f('paytime');
		$bz=$msql->f('bz');
		$items=$msql->f('items');

	
		$dtime=date("y-n-j",$dtime);

		switch($ifok){
			case "0":
				$okimg="no.png";
			break;
			case "1":
				$okimg="ok.png";
			break;
		}
		
		switch($ifpay){
			case "0":
				$payimg="no.png";
			break;
			case "1":
				$payimg="ok.png";
			break;
		}

		switch($ifyun){
			case "0":
				$yunimg="no.png";
			break;
			case "1":
				$yunimg="ok.png";
			break;
		}

		$var=array (
			'orderid' => $orderid,
			'OrderNo' => $OrderNo,
			'user' => $user,
			'name' => $name,
			'address' => $address,
			'tel' => $tel,
			'postcode' => $postcode,
			'totalcent' => $totalcent,
			'ip' => $ip,
			'dtime' => $dtime,
			'yuntime' => $yuntime,
			'paytime' => $paytime,
			'bz' => $bz,
			'items' => $items,
			'okimg' => $okimg, 
			'payimg' => $payimg, 
			'yunimg' => $yunimg
		);

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

	}

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

		$pagesinfo=$pages->ShowNow();

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

		$str=ShowTplTemp($str,$var);


		return $str;


}

?>