📄 gljp_01_yw_08.asp
字号:
<!--#include file="function/m_conn.asp"-->
<!--#include file="../../config.asp"-->
<%
'On Error Resume next
if len(session("login_name"))=0 then
call msginfor("您没有权限访问，请登陆!","incdex.asp")
end if
airticket_OrderID=trim(request("OrderID")) '订单号
set rs=server.CreateObject("adodb.recordset")
sql="select distinct ticket_D.订单编号,PNR号,Parentid,TakeOffTime,FromCityCode,ToCityCode,Carrier,ArriveTime,FromCity,ToCity,RebateName,ProviderCode,BunkSeat,返利,返点,limitif,签注,特殊项,航段,航班号,起飞时间,舱,机型,客票级别,客户编号,客户姓名,网上订单状态,订票时间,送票地址,联系电话,备注,客户类型,送票日期,购票紧急联系方式,购票紧急联系手机,购票电邮地址,支付方式,送票方式,配送要求,送票城市,送票标志建筑,邮政编码,送票紧急程度,ifremindflag,订座编号,电子客票号码,网上扣款标志,出票确认方式,网上客户留言,网上结算金额,网上银行反馈结果,网上实收款金额 from ticket_D inner join ticket_M on ticket_M.订单编号=ticket_D.订单编号 where [ticket_D.订单编号]='"&airticket_OrderID&"'"
rs.open sql,conn,1,3
if not rs.eof then
flightno=split(rs("航班号"),"|")
flightbunk=split(rs("舱"),"|")
flightStartTime=split(rs("TakeOffTime"),"|")
flightToTime=split(rs("ArriveTime"),"|")
flightcityfromcode=split(rs("FromCityCode"),"|")
flightcitytocode=split(rs("ToCityCode"),"|")
if isnull(rs("rebateName")) then
rebateName=""
else
rebateName=rs("rebateName")
end if
flightRebate=split(rebateName,"|")
flightType=split(rs("机型"),"|")
flightcarrier=rs("carrier") '航空公司
flightpnr=rs("PNR号")
'--------承运组信息
flightNum=rs("航班号")
bunk=rs("舱")
StartTime=rs("TakeOffTime")
ToTime=rs("ArriveTime")
CityFromCode=rs("FromCityCode")
CityToCode=rs("ToCityCode")
rebate=rs("rebateName")
planetype=rs("机型")
airwayname=rs("carrier")
'---------
if flightpnr="" or isnull(flightpnr) then
flightpnr=rs("订座编号")
end if
customername=rs("客户姓名")
customercode=rs("客户编号")
OrdStatus=rs("网上订单状态")
OrdWebMoney=rs("网上结算金额")
OrdPayMoney=rs("网上实收款金额")
OrdPayResult=rs("网上银行反馈结果")
OrdTime=rs("订票时间")
OrdTelephone=rs("联系电话")
OrdMobile=rs("购票紧急联系方式")
OrdEmail=rs("购票电邮地址")
OrdPayWay=rs("支付方式")
select case OrdPayWay
case "1" PayWay="票到付款"
case "2" PayWay="网上支付"
case "3" PayWay="电话银行"
case "4" PayWay="银行汇款"
case else
PayWay="票到付款"
end select
OrdSendWay=rs("送票方式")
select case OrdSendWay
case 1 SendWay="电子客票"
case 2 SendWay="送票上门"
case 3 SendWay="门市自取"
case 4 SendWay="特快专递"
case else
SendWay="电子客票"
end select
OrdOkWay=rs("出票确认方式")
select case OrdOkWay
case 1 OkWayValue="不需要确认"
case 2 OkWayValue="电话"
case 3 OkWayValue="短信"
case 4 OkWayValue="邮件"
case 5 OkWayValue="登门"
case else
OkWayValue="不需要确认"
end select
OrdSendIf=rs("配送要求")
OrdSendCity=rs("送票城市")
OrdSendAdd=rs("送票地址")
OrdBuilding=rs("送票标志建筑")
ifremindflag=rs("ifremindflag") '是否提醒
OrdExNum=rs("电子客票号码") '电子客票号码
OrdWebPayFlag=rs("网上扣款标志")
select case OrdWebPayFlag
case 1 WebPayFlagValue="未支付"
case 2 WebPayFlagValue="已支付"
case else
WebPayFlagValue="未支付"
end select
memo=rs("网上客户留言")
OrdSendTime = rs("送票日期")
providercode = rs("providercode")
bunkseat = rs("bunkseat")
fandian = rs("返点")
backmoney = rs("返利")
limitif = rs("limitif")
ticketgrade = rs("客票级别")
qian_zhu = rs("签注")
special = rs("特殊项")
else
errclose("参数传递错误，请返回")
response.end
end if
rs.close
function codetocity(str)'中文三支代码
set rs=conn.execute("select CityName from city where CityCode='"&str&"'")
if not rs.eof then
codetocity=trim(rs("CityName"))
else
codetocity=str
end if
rs.close
end function
%>
<!-- 送票方式 int default 1,--送票上门，电子客票，门市自取，特快专递 -->
<!-- 支付方式 varchar(12) default 1,--1票到付款,网上支付,电话银行,银行汇款 -->
<!-- 1不需要确认,2电话，3短信，4邮件，5登门, -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>订单处理</title>
<link rel="stylesheet" type="text/css" href="../../system_manage/style/comm.css" />
<link rel="stylesheet" type="text/css" href="../../system_manage/style/skin0.css" />
<SCRIPT language=javascript src="js/calendars.js" ></SCRIPT>
<style type="text/css">
<!--
body {
margin-left: 5px;
margin-top: 0px;
margin-right: 5px;
margin-bottom: 5px;
background-color: #F4FAFF;
}
-->
</style></head>
<body>
<form name="formname1" method="post" action="update_order.asp" target="_blank" style="margin:10px 0px;">
<!--整体隐藏信息-->
<input type="hidden" name="OrderFm_ID" value="<%=airticket_OrderID%>"><!--订单编号-->
<input type="hidden" name="OrdStatus" value="<%=OrdStatus%>">
<input type="hidden" name="ordertime" value="<%=OrdTime%>">
<input type="hidden" name="providercode" value="<%=providercode%>">
<input type="hidden" name="bunkseat" value="<%=bunkseat%>">
<input type="hidden" name="fandian" value="<%=fandian%>">
<input type="hidden" name="backmoney" value="<%=backmoney%>">
<input type="hidden" name="limitif" value="<%=limitif%>">
<input type="hidden" name="ticketgrade" value="<%=ticketgrade%>">
<input type="hidden" name="qian_zhu" value="<%=qian_zhu%>">
<input type="hidden" name="special" value="<%=special%>">
<!--承运信息-->
<input type="hidden" name="flightNum" value="<%=flightNum%>">
<input type="hidden" name="bunk" value="<%=bunk%>">
<input type="hidden" name="StartTime" value="<%=StartTime%>">
<input type="hidden" name="ToTime" value="<%=ToTime%>">
<input type="hidden" name="CityFromCode" value="<%=CityFromCode%>">
<input type="hidden" name="CityToCode" value="<%=CityToCode%>">
<input type="hidden" name="rebate" value="<%=rebate%>">
<input type="hidden" name="planetype" value="<%=planetype%>">
<input type="hidden" name="airwayname" value="<%=airwayname%>">
<center><div id='editor_dialog_titlebar' class='editor_dialog_titlebar fdbody' style='height:28px;width:95%;border:none;background-image:none;cursor:default' unselectable='on' onselectstart='return false;'>
<div style='cursor:default;float:right;width:40px;border:none;background-image:none;' class='fdbody' id='no_move'><div id='editor_close' class='editor_close' onMouseOver="this.className='editor_close_mover'" onMouseOut="this.className='editor_close'"><img src='http://r5.mail.qq.com/zh_CN/htmledition20071121/images/ico_closetip.gif' width='12' height='12' ondragstart='return false;' onClick="javascript:window.close()"></div></div>
<div class='editor_dialog_title' id='dialog_title' unselectable='on' style="cursor:default">订单处理</div>
</div></center>
<table width="95%" align="center" cellpadding="3" cellspacing=1 class="qq_person_sel" >
<tr bgcolor="#FFFFFF">
<td height="25">
<span class="b-14hand">详细订票清单</span>：
<strong>是否提醒：</strong>
<input name="ifRemind" value="1" type=checkBox <%if ifRemindFlag<>0 then response.write "checked"%>> </td>
</tr>
</table>
<TABLE width="95%" align="center" cellPadding=6 cellSpacing=1 bgcolor="#CCCCCC" class="editor_dialog_titlebar">
<%for i=0 to ubound(flightno)%>
<tr bgcolor="#FFFFFF">
<td height="23" colspan=4 class="attbg"><span class="txt_title"><strong> 第<%=i+1%>行程信息：</strong></span></td>
</tr>
<TR bgcolor="#FFFFFF">
<td width="18%" height=25 >起飞时间：</td>
<td width="25%" bgcolor="#FFFFFF"><%=flightstarttime(i)%></td>
<td width="14%" bgcolor="#FFFFFF">到达时间</td>
<td width="43%" bgcolor="#FFFFFF"><%=flightToTime(i)%></td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25>航 班 号：</td>
<td bgcolor="#FFFFFF"><%=flightno(i)%></td>
<td bgcolor="#FFFFFF">机票信息：</td>
<td bgcolor="#FFFFFF"> <%=codetocity(flightcityfromcode(i))%> 至 <%=codetocity(flightcitytocode(i))%></td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25 >舱位代码：</td>
<td>(<%=flightbunk(i)%>)</td>
<td bgcolor="#FFFFFF">舱位名称：</td>
<td bgcolor="#FFFFFF"><%=flightRebate(i)%> </td>
</TR>
<%next%>
<!---------------以下是订票人信息----------------------->
<tr bgcolor="#FFFFFF">
<td height="25" colspan=4 class="attbg"><span class="txt_title"><strong>联系人和乘客信息：</strong></span></td>
</tr>
<TR bgcolor="#FFFFFF">
<td height=25>订票时间：</td>
<td width="25%" bgcolor="#FFFFFF"> <%=OrdTime%></td>
<td width="14%" bgcolor="#FFFFFF">送票城市：</td>
<td bgcolor="#FFFFFF"><%=OrdSendCity&" "&OrdSendBuilding%> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25 bgcolor="#FFFFFF">联系人名：</td>
<td> <input name="customer" type="text" class="book" value="<%=CustomerName%>" size="20" maxlength="10"> </td>
<td bgcolor="#FFFFFF">Email：</td>
<td bgcolor="#FFFFFF">
<input name="CEmail" type="text" class="book" value="<%=trim(OrdEmail)%>" size="20" maxlength="14"> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25>联系电话：</td>
<td> <input name="telephone" type="text" class="book" value="<%=OrdTelephone%>" size="20" maxlength="14"> </td>
<td bgcolor="#FFFFFF">联系手机：</td>
<td bgcolor="#FFFFFF"> <input name="mobile" type="text" class="book" value="<%=trim(OrdMobile)%>" size="20" maxlength="14"> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25>送票日期：</td>
<td>
<input name="OrdSendTime" type="text" class="book" id="OrdSendTime" onClick="javascript:calendar();" value="<%=OrdSendTime%>" size="10" maxlength="15"> </td>
<td bgcolor="#FFFFFF">送票方式：</td>
<td bgcolor="#FFFFFF"><select name="SendWay" id="SendWay">
<option value="1" <%if OrdSendWay="1" then response.write "selected"%>>电子客票</option>
<option value="2" <%if OrdSendWay="2" then response.write "selected"%>>送票上门</option>
<option value="3" <%if OrdSendWay="3" then response.write "selected"%>>门市自取</option>
<option value="4" <%if OrdSendWay="4" then response.write "selected"%>>特快专递</option>
</select> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25>付款方式：</td>
<td><select name="PayWay" id="PayWay">
<option value="1" <%if OrdPayWay="1" then response.write "selected"%>>票到付款</option>
<option value="2" <%if OrdPayWay="2" then response.write "selected"%>>网上支付</option>
<option value="3" <%if OrdPayWay="3" then response.write "selected"%>>电话银行</option>
<option value="4" <%if OrdPayWay="4" then response.write "selected"%>>银行汇款</option>
</select></td>
<td bgcolor="#FFFFFF">支付状态：</td>
<td bgcolor="#FFFFFF"><%=WebPayFlagValue%></td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25 bgcolor="#FFFFFF">送票地址：</td>
<td colspan="3"> <input name="address" type="text" class="book" value="<%=OrdSendAdd%>" size="60" maxlength="50"> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td bgcolor="#FFFFFF">乘客列表：<font color="#FF0000">*</font> </td>
<td colspan="3" align="left" bgcolor="#FFFFFF">
<!---------以下是乘客信息------------>
<%
sql="select ID,类型,乘客姓名,保险,证件,证件类型,出生年月,票价,售价,附加税收,税收 from ticket_d where 订单编号='"&airticket_OrderID&"'"
rs.open sql,conn,1,3
if not rs.eof then%>
<table width="100%" cellpadding="2" cellspacing="1">
<tr>
<td width="9%" height="25" bgcolor="#FFFFFF" class="O">类型</td>
<td width="17%" bgcolor="#FFFFFF" class="O">乘客姓名</td>
<td width="33%" bgcolor="#FFFFFF" class="O">证件号码</td>
<td width="10%" bgcolor="#FFFFFF" class="O">保险数</td>
<td width="13%" bgcolor="#FFFFFF" class="O">票价</td>
<td width="18%" bgcolor="#FFFFFF" class="O">机建/燃油费</td>
</tr>
<%
i=1
do while not rs.eof%>
<input type="hidden" name="price<%=i%>" value="<%=rs("票价")%>">
<input type="hidden" name="fullprice<%=i%>" value="<%=rs("售价")%>">
<input type="hidden" name="AdultNotype<%=i%>" value="<%=rs("证件类型")%>"> <!--证件类型-->
<input type="hidden" name="PassengerId<%=i%>" value="<%=trim(rs("ID"))%>">
<input type="hidden" name="PassengerType<%=i%>" value="<%=trim(rs("类型"))%>">
<input type="hidden" name="renyou<%=i%>" value="<%=rs("附加税收")%>">
<input type="hidden" name="Taxprice<%=i%>" value="<%=rs("税收")%>">
<%if rs("类型")="婴儿" or rs("类型")="儿童" then
cidvalue=rs("出生年月")
else
cidvalue=rs("证件")
end if
%>
<tr>
<td height="25" bgcolor="#FFFFFF"><%=rs("类型")%></td>
<td bgcolor="#FFFFFF"><input name="name<%=i%>" type="text" class="book" value="<%=rs("乘客姓名")%>" size="10" maxlength="10"></td>
<td bgcolor="#FFFFFF"><input name="cid<%=i%>" type="text" class="book" value="<%=cidvalue%>" size="20" maxlength="25"></td>
<td bgcolor="#FFFFFF"><input name="baoxian<%=i%>" type="text" class="book" value="<%=rs("保险")%>" size="3" maxlength="1"></td>
<td bgcolor="#FFFFFF"><%=rs("票价")%></td>
<td bgcolor="#FFFFFF"><%=rs("税收")%>/<%=rs("附加税收")%></td>
<%
i=i+1
rs.movenext
loop%>
</tr>
</table>
<%end if %> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=25 bgcolor="#FFFFFF">订座编号：</td>
<td><input name="OpSeatNum" type="text" class="book" value="<%=flightpnr%>" size="8" maxlength="50"></td>
<td>结算金额：</td>
<td><%=OrdWebMoney%></td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=60 bgcolor="#FFFFFF">客户留言：</td>
<td height=60 colspan="3" bgcolor="#FFFFFF">
<textarea name="memo" cols="50" rows="6"><%=trim(memo)%></textarea> </td>
</TR>
<TR bgcolor="#FFFFFF">
<td height=30 colspan="4" align="center" bgcolor="#FFFFFF">
<input type="hidden" name="flag_count" value="<%=i%>">
<input type="submit" value="提交修改">
<input type="reset" value="恢复原样"></td>
</TR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -