<?php require("../../class/connect.php"); include("../../class/db_sql.php"); include("../../class/config.php"); include("../../class/functions.php"); $link=db_connect(); $empire=new mysqlquery(); $logininid=getcvar('loginuserid'); $loginin=getcvar('loginusername'); $loginrnd=getcvar('loginrnd'); $loginlevel=getcvar('loginlevel'); $editor=1; is_login($logininid,$loginin,$loginrnd); //验证权限 CheckLevel($logininid,$loginin,$classid,"shopdd"); $enews=$_GET['enews']; $url="查看订单"; $ddid=(int)$_GET['ddid']; $r=$empire->fetch1("select * from {$dbtbpre}enewsshopdd where ddid='$ddid'"); $producnoar=$empire->fetch1("select productno from {$dbtbpre}ecms_shop where title='$title' limit 1"); $producno=$producnoar[productno]; //需要发票 $fp="否"; if($r[fp]) { $fp="是"; } //金额 $total=0; if($r[payby]==1) { $pstotal=$r[pstotal]." 点"; $alltotal=$r[alltotal]." 点"; $total=$r[pstotal]+$r[alltotal]; $mytotal=$total." 点"; } else { $pstotal=$r[pstotal]." 元"; $alltotal=$r[alltotal]." 元"; $total=$r[pstotal]+$r[alltotal]+$r[fptotal]; $mytotal=$total." 元"; } //支付方式 if($r[payby]==1) { $payfsname=$r[payfsname]."(积分购买)"; } elseif($r[payby]==2) { $payfsname=$r[payfsname]."(余额购买)"; } else { $payfsname=$r[payfsname]; } //状态 if($r[checked]) { $ch="已确认"; } else { $ch="<font color=red>未确认</font>"; } if($r[outproduct]) { $ou="已发货"; } else { $ou="<font color=red>未发货</font>"; } if($r[haveprice]) { $ha="已付款"; } else { $ha="<font color=red>未付款</font>"; } //显示商品信息 function ShowBuyproduct($buycar,$payby){ global $empire; $record="!"; $field="|"; $r=explode($record,$buycar); $alltotal=0; $alltotalfen=0; echo"<table width=100% border=0 align=center cellpadding=3 cellspacing=1> <input type=hidden name=enews value=EditBuycar> <tr bgcolor=#698CC3> <td width=9% height=20> <div align=center><font color=#FFFFFF>序号</font></div></td> <td width=12%> <div align=center><font color=#FFFFFF>书号</font></div></td> <td width=30%> <div align=center><font color=#FFFFFF>商品名称</font></div></td> <td width=15%> <div align=center><font color=#FFFFFF>单价</font></div></td> <td width=10%> <div align=center><font color=#FFFFFF>数量</font></div></td> <td width=19%> <div align=center><font color=#FFFFFF>小计</font></div></td> </tr>"; $j=0; for($i=0;$i<count($r)-1;$i++) { $j++; $pr=explode($field,$r[$i]); $productid=$pr[1]; $fr=explode(",",$pr[1]); //ID $classid=$fr[0]; $id=$fr[1]; //数量 $num=$pr[2]; if(empty($num)) {$num=1;} //单价 $price=$pr[3]; $thistotal=$price*$num; $buyfen=$pr[4]; $thistotalfen=$buyfen*$num; if($payby==1) { $showprice=$buyfen." 点"; $showthistotal=$thistotalfen." 点"; } else { $showprice=$price." 元"; $showthistotal=$thistotal." 元"; } //产品名称 $title=$pr[5]; //书号 //返回链接 $titleurl="../../public/InfoUrl?classid=$classid&id=$id"; $alltotal+=$thistotal; $alltotalfen+=$thistotalfen; echo"<tr> <td align=center>".$j."</td> <td align=center>".$productno."</td> <td align=center><a href='".$titleurl."' target=_blank>".$title."</a></td> <td align=center><b>¥".$showprice."</b></td> <td align=center>".$num."</td> <td align=center>".$showthistotal."</td> </tr>"; } //支付积分付费 if($payby==1) { $a="<tr> <td colspan=5><div align=right>合计积分:<strong>".$alltotalfen."</strong></div></td> <td> </td> </tr> </table>"; } else { echo"<tr> <td colspan=5><div align=right>合计:<strong>¥".$alltotal."</strong></div></td> <td> </td> </tr> </table>"; } } //风格 $loginadminstyleid=(int)getcvar('loginadminstyleid'); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css"> <title>查看订单</title> <script> function PrintDd() { pdiv.style.display="none"; window.print(); } </script> </head>
<body> <table width="98%" border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td width="61%" height="23" bgcolor="#FFFFFF"><strong>订单ID: <?=$r[ddno]?> </strong></td> <td width="39%" bgcolor="#FFFFFF"><strong>下单时间: <?=$r[ddtime]?> </strong></td> </tr> <tr> <td height="23" colspan="2" bgcolor="#EFEFEF"><strong>商品信息</strong></td> </tr> <tr> <td colspan="2"> <? ShowBuyproduct($r[buycar],$r[payby]); ?> </td> </tr> <tr> <td height="23" colspan="2" bgcolor="#EFEFEF"><strong>订单信息</strong></td> </tr> <tr> <td height="23" colspan="2"><table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td width="15%" height="23"> <div align="right">订单号:</div></td> <td width="35%"><strong> <?=$r[ddno]?> </strong></td> <td width="15%"><div align="right">定单状态:</div></td> <td width="35%"><strong> <?=$ha?> </strong>/<strong> <?=$ou?> </strong>/<strong> <?=$ch?> </strong></td> </tr> <tr> <td height="23"> <div align="right">下单时间:</div></td> <td><strong> <?=$r[ddtime]?> </strong></td> <td><div align="right">商品总金额:</div></td> <td><strong> <?=$alltotal?> </strong></td> </tr> <tr> <td height="23"> <div align="right">配送方式:</div></td> <td><strong> <?=$r[psname]?> </strong></td> <td><div align="right">商品运费:</div></td> <td><strong> <?=$pstotal?> </strong></td> </tr> <tr> <td height="23"> <div align="right">支付方式:</div></td> <td><strong> <?=$payfsname?> </strong></td> <td><div align="right">发票金额:</div></td> <td><?=$r[fptotal]?></td> </tr> <tr> <td height="23"> <div align="right">需要发票:</div></td> <td><?=$fp?></td> <td><div align="right">订单总金额:</div></td> <td><strong> <?=$mytotal?> </strong></td> </tr> <tr> <td height="23"> <div align="right">发票抬头:</div></td> <td colspan="3"><strong> <?=$r[fptt]?> </strong></td> </tr> </table></td> </tr> <tr> <td height="23" colspan="2" bgcolor="#EFEFEF"><strong>订货人信息</strong></td> </tr> <tr> <td colspan="2"><table width="100%%" border="0" cellspacing="1" cellpadding="3"> <tr> <td width="20%">真实姓名:</td> <td width="80%"> <?=$r[truename]?> </td> </tr> <tr> <td>OICQ:</td> <td> <?=$r[oicq]?> </td> </tr> <tr> <td>MSN:</td> <td> <?=$r[msn]?> </td> </tr> <tr> <td>固定电话:</td> <td> <?=$r[call]?> </td> </tr> <tr> <td>移动电话:</td> <td> <?=$r[phone]?> </td> </tr> <tr> <td>联系邮箱:</td> <td> <?=$r[email]?> </td> </tr> <tr> <td>联系地址:</td> <td> <?=$r[address]?> </td> </tr> <tr> <td>邮编:</td> <td> <?=$r[zip]?> </td> </tr> <tr> <td>备注:</td> <td> <?=nl2br($r[bz])?> </td> </tr> </table></td> </tr> <tr> <td height="23" colspan="2" bgcolor="#EFEFEF"><strong>收货人信息</strong></td> </tr> <tr> <td colspan="2"><table width="100%%" border="0" cellspacing="1" cellpadding="3"> <tr> <td width="20%">真实姓名:</td> <td width="80%"> <?=$r[g_truename]?> </td> </tr> <tr> <td>OICQ:</td> <td> <?=$r[g_oicq]?> </td> </tr> <tr> <td>MSN:</td> <td> <?=$r[g_msn]?> </td> </tr> <tr> <td>固定电话:</td> <td> <?=$r[g_call]?> </td> </tr> <tr> <td>移动电话:</td> <td> <?=$r[g_phone]?> </td> </tr> <tr> <td>联系邮箱:</td> <td> <?=$r[g_email]?> </td> </tr> <tr> <td>联系地址:</td> <td> <?=$r[g_address]?> </td> </tr> <tr> <td>邮编:</td> <td> <?=$r[g_zip]?> </td> </tr> </table></td> </tr> <tr> <td colspan="2"><div align="center"> <table width="98%%" border="0" align="center" cellpadding="3" cellspacing="1" id="pdiv"> <tr> <td><div align="center"> <input type="button" name="Submit" value=" 打 印 " onclick="javascript:PrintDd();"> </div></td> </tr> </table> </div></td> </tr> </table> </body> </html> <? db_close(); $empire=null; ?>
|