www.gusucode.com > 2030网博士成品网站管理系统 PHP网站源码程序 > 2030/dingcan/module/DingCanMemberOrder.php

    <?php


function DingCanMemberOrder(){

	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 ifdel!='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 (goodsmemo regexp '$key' or cname 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("_dingcan_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}_dingcan_order where $scl order by dtime desc limit $pagelimit");
	while($msql->next_record()){
		
		$orderid=$msql->f('orderid');
		$OrderNo=$msql->f('OrderNo');
		$ordertype=$msql->f('ordertype');
		$memberid=$msql->f('memberid');
		$cname=$msql->f('cname');
		$goodstotal=$msql->f('goodstotal');
		$yunzoneid=$msql->f('zoneid');
		$yunfei=$msql->f('pscost');
		$paytotal=$msql->f('totalcost');
		$ifcheck=$msql->f('ifcheck');
		$payid=$msql->f('payid');
		$paytype=$msql->f('paytype');
		$ifpay=$msql->f('ifpay');
		$ifyun=$msql->f('ifyun');
		$ifok=$msql->f('ifok');
		$ifdel=$msql->f('ifdel');
		$dtime=$msql->f('dtime');
		$paytime=$msql->f('paytime');
		$ordertime=$msql->f('ordertime');
		$sctime=$msql->f('sctime');
		$goodsmemo=$msql->f('goodsmemo');

	
		$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,
			'goodsmemo' => $goodsmemo, 
			'paytotal' => $paytotal, 
			'yuntype' => $yuntype, 
			'yunfei' => $yunfei, 
			'okimg' => $okimg, 
			'payimg' => $payimg, 
			'yunimg' => $yunimg, 
			'dtime' => $dtime
		);

		$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;


}

?>