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