printorder.php

推荐的一本书！！！！建议看 ！！！！！！！！！

<?php

/*
	[插件名称] 订单打印 - 替换模版标签{#modPrintOrder#}
	[适用范围] 全站
	[文 件 名] PrintOrder.php
	[更新时间] 2007/2/1
*/


function PrintOrder(){


	global $msql,$fsql,$charset,$tbl_yun,$tbl_yun_zone,$tbl_hb,$MenuInfo,$CONF;
	global $tbl_order,$tbl_order_items,$tbl_shop_con;
	global $lanPayY,$lanPayN,$lanYunN,$lanYunY,$lanYunB,$lanHisY,$lanHisN,$lanChkY,$lanChkN;
	


	$PSET=PlusSet("PrintOrder");

	$tempname=PlusDef($PSET["tempname"],"tpl_orderprint.htm");


	$memberid=$_COOKIE["MEMBERID"];
	$orderid=$_GET["orderid"];

	if(strstr($_SERVER["PHP_SELF"],"adm/order_print.php") && $_COOKIE["SYSUSER"]!=""){
		$addsql="";
	}else{
		$addsql=" and memberid='$memberid' ";
	}
	
	//默认货币
	$hbname=$CONF["hbname"];
	$hbdanwei=$CONF["hbdanwei"];
	$hbcode=$CONF["hbcode"];


	//取订单

	$fsql->query("select * from $tbl_order where orderid='$orderid' $addsql");

	if($fsql->next_record()){
		$OrderNo=$fsql->f('OrderNo');
		$memberid=$fsql->f('memberid');
		$name=$fsql->f('name');
		$s_email=$fsql->f('s_email');
		$s_name=$fsql->f('s_name');
		$s_tel=$fsql->f('s_tel');
		$s_addr=$fsql->f('s_addr');
		$s_postcode=$fsql->f('s_postcode');
		$s_mobi=$fsql->f('s_mobi');
		$s_time=$fsql->f('s_time');
		$goodstype=$fsql->f('goodstype');
		$goodstotal=$fsql->f('goodstotal');
		$yunzoneid=$fsql->f('yunzoneid');
		$yuntype=$fsql->f('yuntype');
		$yunifbao=$fsql->f('yunifbao');
		$yunbaofei=$fsql->f('yunbaofei');
		$yunfei=$fsql->f('yunfei');
		$totaloof=$fsql->f('totaloof');
		$totalcent=$fsql->f('totalcent');
		$totalweight=$fsql->f('totalweight');
		$paytype=$fsql->f('paytype');
		$payhb=$fsql->f('payhb');
		$payhl=$fsql->f('payhl');
		$paytotal=$fsql->f('paytotal');
		$iflook=$fsql->f('iflook');
		$ifyun=$fsql->f('ifyun');
		$ifpay=$fsql->f('ifpay');
		$ifok=$fsql->f('ifok');
		$ip=$fsql->f('ip');
		$dtime=$fsql->f('dtime');
		$paytime=$fsql->f('paytime');
		$yuntime=$fsql->f('yuntime');
		$agentok=$fsql->f('agentok');
		$bz=$fsql->f('bz');
		$items=$fsql->f('items');
		$youhui=$fsql->f('youhui');

	}
	if($youhui!=""){
		$youhui=" (".$youhui.")";
	}

	$showbz=str_replace("\n","<br>",$bz);
	$dtime=date("Y-n-j H:i",$dtime);

	if($ifpay=="1"){
		$paystat=$lanPayY;
	}else{
		$paystat=$lanPayN;
	}

	if($ifyun=="2"){
		$yunstat=$lanYunY;
	}elseif($ifyun=="1"){
		$yunstat=$lanYunB;
	}else{
		$yunstat=$lanYunN;
	}

	if($iflook=="1"){
		$chkstat=$lanChkY;
	}else{
		$chkstat=$lanChkN;
	}

	if($ifok=="1"){
		$okstat=$lanHisY;
	}else{
		$okstat=$lanHisN;
	}



	//区域名称
	$msql->query("select * from $tbl_yun_zone where id='$yunzoneid'");
	if($msql->next_record()){
		$zonename=$msql->f('zone');
	}


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


	//货币结算

	if($payhb!=$hbcode){
		$msql->query("select * from $tbl_hb where hbcode='$payhb'");
		if($msql->next_record()){
			$payhbname=$msql->f('hbname');
			$payhbdanwei=$msql->f('hbdanwei');
		}
	}else{
		$payhbname=$hbname;
		$payhbdanwei=$hbdanwei;
	}
	


	//传递变量

	$var=array (
	'OrderNo' => $OrderNo,
	'dtime' => $dtime,
	'paystat' => $paystat,
	'yunstat' => $yunstat,
	'chkstat' => $chkstat,
	'okstat' => $okstat,
	'membername' => $name,
	's_name' => $s_name,
	's_addr' => $s_addr,
	's_tel' => $s_tel,
	's_mobi' => $s_mobi,
	's_email' => $s_email,
	's_postcode' => $s_postcode,
	's_time' => $s_time
	);


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


	//商品清单


	$fsql->query("select * from $tbl_order_items where orderid='$orderid' $addsql");
	while($fsql->next_record()){
	
		$gid=$fsql->f('gid');
		$bn=$fsql->f('bn');
		$goodsname=$fsql->f('goods');
		$igoodstype=$fsql->f('goodstype');
		$mypr=$fsql->f('mypr');
		$price=$fsql->f('price');
		$kg=$fsql->f('kg');
		$nums=$fsql->f('nums');
		$danwei=$fsql->f('danwei');
		$jine=$fsql->f('jine');
		$item_ifyun=$fsql->f('ifyun');
		$item_yuntime=$fsql->f('yuntime');
		$msg=$fsql->f('msg');
		
		$zl=$kg*$nums;
		$zl=number_format($zl,2,'.','');


		$msql->query("select tcall from $tbl_shop_con where id='$gid'");
			
		if($msql->next_record()){
			$tcall=$msql->f('tcall');
			
		}
		
		if($igoodstype=="tc"){
			$tcgoods=GoodsTcAll($tcall);
		}else{
			$tcgoods="";
		}

		

		$var=array (
		
		'bn' => $bn, 
		'price' => $price,
		'acc' => $nums,
		'goodsname' => $goodsname,
		'prop' => $mypr,
		'tcgoods' => $tcgoods,
		'weight' => $zl,
		'hbcode' => $hbcode,
		'hbdanwei' => $hbdanwei,
		'hbname' => $hbname,
		'jine' => $jine,
		'danwei' => $danwei

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


	}
	$tjine=number_format($tjine,2,'.','');



	//传递变量

	$var=array (
	'OrderNo' => $OrderNo,
	'membername' => $name,
	's_name' => $s_name,
	's_addr' => $s_addr,
	's_tel' => $s_tel,
	's_mobi' => $s_mobi,
	's_email' => $s_email,
	's_postcode' => $s_postcode,
	's_time' => $s_time,
	'tjine' => $tjine,
	'hbname' => $hbname,
	'hbcode' => $hbcode,
	'hbdanwei' => $hbdanwei,
	'youhui' => $youhui,
	'yunname' => $yuntype,
	'yunfei' => $yunfei,
	'bao' => $yunbaofei,
	'zonename' => $zonename,
	'paytype' => $paytype,
	'tweight' => $totalweight,
	'goodstotal' => $goodstotal,
	'ordertotal' => $totaloof,
	'payhb' => $payhb,
	'payhbname' => $payhbname,
	'payhbdanwei' => $payhbdanwei,
	'paytotal' => $paytotal,
	'showbz' => $showbz
	);


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

}

?>