require("lib.php"); auth(); $billid = intval($billid); $bgth = "#dddddd"; $bgtd1 = "#eeeeee"; $bgtd2 = "#dddddd"; $tbborder = 0; $tbcellspacing = 2; $tbcellpadding = 4; $qry_string = "SELECT * FROM bill WHERE billid=$billid"; $result = $db_query($qry_string, $mySQL_ID) or mysql_die(); if($db_num_rows($result) == 0) die("该订单不存在"); $row = $db_fetch_array($result); $userid = $row['userid']; $status = $row['status']; $directoryid = $row['directoryid']; $paymentid = $row['paymentid']; $shipmentid = $row['shipmentid']; $currencyid = $row['currencyid']; $dateorder = substr($row['dateorder'],0,10); $datepay = substr($row['datepay'],0,10); $datedelivery = substr($row['datedelivery'],0,10); $datefeedback = substr($row['datefeedback'],0,10); $shipmentcompanyid = intval($row['shipmentcompanyid']); $shipmentno = trim($row['shipmentno']); $total = doubleval($row['total']); $amount = doubleval($row['amount']); $freight_fee = doubleval($row['freight_fee']); $pack_fee = doubleval($row['pack_fee']); $other_fee = doubleval($row['other_fee']); $income = doubleval($row['income']); $change = doubleval($row['change']); $memo = nl2br($row['memo']); $demand = nl2br($row['demand']); $sta_str = billstatus($status); $payment = $array_payment["$paymentid"]; $currency = $array_currency["$currencyid"][1]; $shipment = $array_shipment["$shipmentid"]; if($userid != $ss_userid){ die("您无权查看该订单"); } $qry_string = "SELECT directoryid FROM user WHERE userid=$userid"; $result1 = $db_query($qry_string, $mySQL_ID) or mysql_die(); $row1 = $db_fetch_array($result1); $directoryid1 = $row1[0]; $qry_string = "SELECT realname,gender,email FROM directory WHERE directoryid=$directoryid1"; $result1 = $db_query($qry_string, $mySQL_ID) or mysql_die(); $row1 = $db_fetch_array($result1); $from_name = $row1[0]; $from_gender = ($row1[1]=="M")?"先生":"女士"; $from_email = $row1[2]; $qry_string = "SELECT * FROM billcontact WHERE billid=$billid AND directoryid=$directoryid"; $result1 = $db_query($qry_string, $mySQL_ID) or mysql_die(); $row1 = $db_fetch_array($result1); $to_name = $row1['realname']; $to_gender = $row1['gender']; $to_email = $row1['email']; $to_telephone = $row1['telephone']; //////////////////////////////////////////////////Modified by huling////////////////////////////////////////////////// $to_telephone1 = $row1['telephone1']; $to_arrivaldate = $row1['arrivaldate']; //////////////////////////////////////////////////Modified by huling////////////////////////////////////////////////// $to_country = $row1['country']; $to_province = $row1['province']; $to_city = $row1['city']; $to_address = $row1['address']; $to_zipcode = $row1['zipcode']; if($shipmentcompanyid > 0){ $qry_string = "SELECT * FROM shipmentcompany WHERE shipmentcompanyid=$shipmentcompanyid"; $result_tmp = $db_query($qry_string, $mySQL_ID) or mysql_die(); $row_tmp = $db_fetch_array($result_tmp); $shipmentcompany = $row_tmp['name']; $shipmentcompanyphone = $row_tmp['phone']; $shipmentcompanyhttp = $row_tmp['http']; } if($status == 0) $actstr = "取消订单"; else if(($status & 0xF800) == 0x0800) $actstr = "到货确认"; else $actstr = ""; ?>
| 以下是的订购单 状态: |