<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
|
<%Session.CodePage=65001%>
|
<!--#include virtual="/weixin/OAuth2.gds"-->
|
<!--#include virtual="/inc/function.gds"-->
|
<%
|
OrdDateType=SafeRequest(Request("OrdDateType"))
|
If state<>"" Then
|
stateSP=split(state,"|")
|
for i = 0 to UBOUND(stateSP)
|
If InStr(stateSP(i),"OrdDateType=")=1 Then
|
OrdDateType=Replace(stateSP(i),"OrdDateType=","")
|
End If
|
Next
|
End If
|
Set rs = Server.CreateObject("ADODB.Recordset")
|
'个人信息
|
sql="select * from OA_User where OA_User_ID="&session("adminID")
|
rs.open sql,objConn,1,1
|
If not rs.Eof then
|
OA_weixinUserID = rs("OA_weixinUserID")
|
OA_Name = rs("OA_Name")
|
OA_weixinAvatar = rs("OA_weixinAvatar")
|
OA_DepartmentID = rs("OA_DepartmentID")
|
End If
|
rs.close()
|
If OA_weixinAvatar="" Then OA_weixinAvatar="/resources/images/icon_avatar_default.png"
|
%>
|
<html xmlns="http://www.w3.org/1999/xhtml"><head>
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
|
<title>行程订单</title>
|
|
<meta name="viewport" content="width=device-width, height=device-height, initial-scale=1, maximum-scale=1, user-scalable=no">
|
<link href="/css/main.css" type="text/css" rel="stylesheet">
|
|
</head>
|
<body>
|
<%
|
If OrdDateType="" Then OrdDateType=4
|
sql="select vID,vtext,vOrder2 from dictionary where vType>=1 and vtitle='OrdDateType' and vID="&OrdDateType
|
rs.open Sql,objConn,1,1
|
If not rs.Eof Then
|
OrdDateTypeName = rs("vtext")
|
OrdDateTypeName1=OrdDateTypeName
|
SqlOrdDateType = rs("vOrder2")
|
Else
|
OrdDateType=4
|
OrdDateTypeName="本月"
|
OrdDateTypeName1=OrdDateTypeName
|
SqlOrdDateType="between DATEADD(mm,DATEDIFF(mm,0,getdate()),0) and dateadd(ms,-3,DATEADD(mm,DATEDIFF(m,0,getdate())+1,0))"
|
End If
|
rs.close()
|
|
'本月绩效
|
sql="select isnull(sum(EntourageDKP),0) from DispatchOrd_Entourage,DispatchOrd where DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 and EntourageDKP>0 and DispatchOrdReturnDate "&SqlOrdDateType&" and EntourageOAid="&session("adminID")
|
rs.open Sql,objConn,1,1
|
OA_DKP_Sum=rs(0)
|
rs.close()
|
'本月提成
|
OA_DKPMoney_Sum=0
|
sql="select DispatchOrdPerfomance,EntourageOT_is,EntourageLong_is,EntourageBetimesHH,EntourageDKP,EntourageDKPScale,EntourageState_Time,vtext from DispatchOrd_Entourage,DispatchOrd,dictionary where vtitle='DispatchOrdEntourage' and EntourageID=vID and DispatchOrdID=DispatchOrdIDDt and EntourageState<>4 and EntourageDKP>0 and DispatchOrdReturnDate "&SqlOrdDateType&" and EntourageOAid="&session("adminID")
|
rs.open Sql,objConn,1,1
|
do While not rs.Eof
|
EntourageName = rs("vtext") '职能名称
|
DispatchOrdPerfomance=rs("DispatchOrdPerfomance")
|
EntourageOT_is = rs("EntourageOT_is")
|
EntourageLong_is = rs("EntourageLong_is")
|
EntourageBetimesHH = rs("EntourageBetimesHH")
|
EntourageDKP = rs("EntourageDKP")
|
EntourageDKPScale = rs("EntourageDKPScale")
|
EntourageState_Time = rs("EntourageState_Time")
|
OA_DKPMoney=EntourageDKP_Money_A(DispatchOrdPerfomance,EntourageOT_is,EntourageLong_is,EntourageBetimesHH,EntourageDKP,EntourageDKPScale,EntourageState_Time)
|
OA_DKPMoney_Sum=OA_DKPMoney_Sum+OA_DKPMoney
|
rs.movenext
|
loop
|
rs.close()
|
|
%>
|
|
<div class="desc">
|
<div class="my-img"><img src="<%=OA_weixinAvatar%>"></div>
|
<div class="user-info">
|
<span><%=OADepartment(OA_DepartmentID,"DepartmentName")%></span>
|
<span><%=OA_Name%></span>
|
<ul>
|
<li><span class="jf"><%=OrdDateTypeName%>绩效</span><span class="jfl"><%=OA_DKP_Sum%></span></li>
|
<li><span class="zhye"><%=OrdDateTypeName%>提成</span><span class="jfl"><%=OA_DKPMoney_Sum%> 元</span></li>
|
</ul>
|
</div>
|
</div>
|
|
<div class="liebiao">
|
<ul>
|
<li><a href="m_UserOrder_List.gds?OrdState=100">未完成订单<span></span></a></li>
|
<li><a href="m_UserOrder_List.gds?OrdState=100">已完成订单<span></span></a></li>
|
</ul>
|
</div>
|
|
<!--底部-->
|
|
</body>
|
</html>
|
