<?php require '/inc/odbc.php';?>
|
<?php require '/inc/function.php';?>
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
|
<?php
|
$UnitNameID=empty($_REQUEST['UnitNameID'])!=false ? "" : addslashes($_REQUEST['UnitNameID']);
|
$CoopUnitID=empty($_REQUEST['CoopUnitID'])!=false ? "" : addslashes($_REQUEST['CoopUnitID']);
|
|
$searchTXT=empty($_REQUEST['searchTXT'])!=false ? "" : addslashes($_REQUEST['searchTXT']);
|
$orderby=empty($_REQUEST['orderby'])!=false ? "" : addslashes($_REQUEST['orderby']);
|
|
$OrdDateType=empty($_REQUEST['OrdDateType'])!=false ? "0" : addslashes($_REQUEST['OrdDateType']);
|
$OrdDateStart=empty($_REQUEST['OrdDateStart'])!=false ? "" : addslashes($_REQUEST['OrdDateStart']);
|
$OrdDateEnd=empty($_REQUEST['OrdDateEnd'])!=false ? "" : addslashes($_REQUEST['OrdDateEnd']);
|
$OrdType=empty($_REQUEST['OrdType'])!=false ? "1" : addslashes($_REQUEST['OrdType']);
|
$OrdClassType=empty($_REQUEST['OrdClassType'])!=false ? "0" : addslashes($_REQUEST['OrdClassType']);
|
$OrderLevel=empty($_REQUEST['OrderLevel'])!=false ? "0" : addslashes($_REQUEST['OrderLevel']);
|
|
if(isDepartment("070126")==0){
|
header("Location: /");
|
exit;
|
}
|
|
//默认显示字段
|
If ($OrdType=="2") {
|
$Report_Name = "客服评价明细表 ---- 服务单";
|
}else{
|
$Report_Name = "客服评价明细表 ---- 调度单";
|
}
|
if ($OrdDateType=="0" and $OrdDateStart=="" and $OrdDateEnd=="") {
|
$OrdDateType=4;
|
$OrdDateTop=" top 20 ";
|
}
|
else {
|
$OrdDateTop="";
|
}
|
$OrdDateTypeName="";
|
if ($OrdDateType=="0") {
|
if ($OrdDateStart=="" and $OrdDateEnd=="") {
|
$OrdDateStart=date("Y-m-d");
|
$OrdDateEnd=date("Y-m-d");
|
}
|
elseif ($OrdDateStart!="" and $OrdDateEnd=="") {
|
$OrdDateEnd=$OrdDateStart;
|
}
|
elseif ($OrdDateStart=="" and $OrdDateEnd!="") {
|
$OrdDateStart=$OrdDateEnd;
|
}
|
If ($OrdDateStart>$OrdDateEnd) {
|
$OrdDateStart1=$OrdDateStart;
|
$OrdDateStart=$OrdDateEnd;
|
$OrdDateEnd=$OrdDateStart1;
|
}
|
If ($OrdDateStart==$OrdDateEnd) {
|
$OrdDateTypeName=$OrdDateStart;
|
$OrdDateTypeName1=$OrdDateTypeName;
|
}
|
Else {
|
$OrdDateTypeName=$OrdDateStart." 至 ".$OrdDateEnd;
|
$OrdDateTypeName1="时间段 ".$OrdDateTypeName;
|
}
|
$SqlOrdDateType=" between '".$OrdDateStart."' and '".$OrdDateEnd." 23:59:59'";
|
}
|
Else {
|
$sql = "select top 1 vID,vtext,vOrder2 from dictionary where vType>=1 and vtitle='OrdDateType' and vID=".$OrdDateType ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$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))";
|
|
}
|
}
|
|
}
|
|
//各种返回信息
|
$SystemMessageTXT="";
|
$SystemMessageType=empty($_REQUEST['SystemMessageType'])!=false ? "" : $_REQUEST['SystemMessageType'];
|
$SMT=empty($_REQUEST['SMT'])!=false ? "" : $_REQUEST['SMT'];
|
if ($SystemMessageType!="") {
|
if ($SMT=="1") {
|
$SystemMessageTXT="请选择日期";
|
}
|
}
|
|
//时间段列表
|
$OrdDateTypes=array();
|
$sql = "select vID,vtext from dictionary where vType>=1 and vtitle='OrdDateType' order by vOrder" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$i=0;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$OrdDateTypes[$i]=array($rs['vID'],$rs['vtext']);
|
$i++;
|
}
|
}
|
|
//订单类型表列
|
$OrdTypeName="调度单";
|
if(isDepartment("02")==0){
|
$OrdTypes = array(
|
array(1,"调度单")
|
);
|
}else{
|
$OrdTypes = array(
|
array(1,"调度单"),
|
array(2,"服务单")
|
);
|
}
|
for($i=0;$i<count($OrdTypes);$i++) {
|
if ($OrdTypes[$i][0]==$OrdType){$OrdTypeName = $OrdTypes[$i][1];}
|
}
|
|
//单据类型表列
|
If (isDepartment("070109")==1 or stripos($OrdClassListSql,"SA")>0 Or $UnitNameID=="1" Or $UnitNameID=="6" Or $UnitNameID=="15") {
|
$OrdClassTypes = array(
|
array(0,"全部"),
|
array(-1,"仅正常单"),
|
array(-2,"特殊单"),
|
);
|
}Else{
|
$OrdClassTypes = array(
|
array(0,"全部"),
|
);
|
}
|
$sql = "select vID,vtext,vOrder2 from dictionary where vType=1 and vtitle='ServiceOrderType' order by vOrder" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$i=count($OrdClassTypes);
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$OrdClassTypes[$i]=array($rs['vID'],$rs['vtext']);
|
$i++;
|
}
|
}
|
for($i=0;$i<count($OrdClassTypes);$i++) {
|
if (strval($OrdClassTypes[$i][0])==$OrdClassType){$OrdClassTypeName = $OrdClassTypes[$i][1];}
|
}
|
|
//单据级别表列
|
$OrderLevelName="全部";
|
$OrderLevels=array();
|
$OrderLevels[0]=array(0,"全部");
|
$sql = "select vID,vtext,vType from dictionary where vType>=1 and vtitle='OrderLevel' order by vType desc,vOrder" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$i=1;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$OrderLevels[$i]=array($rs['vID']+1,$rs['vtext']);
|
if (strval($OrderLevels[$i][0])==$OrderLevel){$OrderLevelName = $OrderLevels[$i][1];}
|
$i++;
|
}
|
}
|
|
//公司列表
|
$UnitNameName="全部";
|
$UnitNames=array();
|
$UnitNames[0]=array(0,"全部");
|
$sql = "select vID,vtext,vType from dictionary where vType>=0 and vtitle='UnitName' order by vType desc,vOrder" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$i=1;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$UnitName=$rs['vtext'];
|
if ($rs['vType']==0) {$UnitName = $UnitName."(停用)";}
|
$UnitNames[$i]=array($rs['vID'],$UnitName);
|
if (strval($UnitNames[$i][0])==$UnitNameID){$UnitNameName = $UnitNames[$i][1];}
|
$i++;
|
}
|
}
|
|
//合作公司列表
|
$CoopUnitName="未选择";
|
$CoopUnitNames=array();
|
$CoopUnitNames[0]=array(0,"未选择");
|
if ($CoopUnitID!="" and $CoopUnitID!="0") {$CoopUnitName="多选";}
|
if (substr($CoopUnitID,0,2)=="0,") {$CoopUnitID=substr($CoopUnitID,2);}
|
$sql = "select UnitID,UnitShort from IntroducerUnitData where UnitState=1 and (ServiceBranch='' or ServiceBranch is null) order by UnitID desc" ;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$i=1;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
$CoopUnitNames[$i]=array($rs['UnitID'],$rs['UnitShort']);
|
if (strval($CoopUnitNames[$i][0])==$CoopUnitID){$CoopUnitName = $CoopUnitNames[$i][1];}
|
$i++;
|
}
|
}
|
|
$page_URL_noDate="searchTXT=".$searchTXT."&orderby=".$orderby."&OrdType=".$OrdType."&OrderLevel=".$OrderLevel."&UnitNameID=".$UnitNameID."&CoopUnitID=".$CoopUnitID."&OrdClassType=".$OrdClassType;
|
$page_URL="OrdDateType=".$OrdDateType."&OrdDateStart=".$OrdDateStart."&OrdDateEnd=".$OrdDateEnd."&".$page_URL_noDate;
|
?>
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head>
|
<title><?php echo $LindemanAdmin?></title>
|
<?php require '/inc/ccs.php';?>
|
</head>
|
<body onkeydown="xKeyEvent(event)">
|
<?php require 'menu_header.php';?>
|
<!-- content -->
|
<div id="content">
|
<?php require 'Report_menu_left.php';?>
|
<!-- content / right -->
|
<div id="right">
|
<!-- table -->
|
<div class="box">
|
<!-- box / title -->
|
<div class="title">
|
<h5><span id="right_Menu" style="display: none;">[<a onclick="JavaScript:JS_left_Menu2('1');" style="color: #ffffff;">显示菜单</a>] </span><?php if($searchTXT!=""){echo $Report_Name." ".$searchTXT;} else {echo $Report_Name;} ?></h5>
|
<ul class="links">
|
<li><a href="Report_StaffScoreUserList_Excel.php?<?php echo $page_URL?>">导出Excel</a></li>
|
<div class="search">
|
<form action="?" method="post">
|
<div class="input">
|
<input name="orderby" id="Menu_orderby" type="hidden" value="<?php echo $orderby?>">
|
<input name="OrdClassType" id="Menu_OrdClassType" type="hidden" value="<?php echo $OrdClassType?>">
|
<input name="OrdType" id="Menu_OrdType" type="hidden" value="<?php echo $OrdType?>">
|
<input name="OrderLevel" id="Menu_OrderLevel" type="hidden" value="<?php echo $OrderLevel?>">
|
<input name="UnitNameID" id="Menu_UnitNameID" type="hidden" value="<?php echo $UnitNameID?>">
|
<input name="CoopUnitID" id="Menu_CoopUnitID" type="hidden" value="<?php echo $CoopUnitID?>">
|
|
<input name="OrdDateType" id="Menu_OrdDateType" type="hidden" value="<?php echo $OrdDateType?>">
|
<input name="OrdDateStart" id="Menu_OrdDateStart" type="hidden" value="<?php echo $OrdDateStart?>">
|
<input name="OrdDateEnd" id="Menu_OrdDateEnd" type="hidden" value="<?php echo $OrdDateEnd?>">
|
<input type="text" id="searchTXT" name="searchTXT" value="<?php echo $searchTXT?>" />
|
</div>
|
<div class="button">
|
<input type="submit" name="submit" value="搜索" />
|
</div>
|
</form>
|
</div>
|
</ul>
|
</div>
|
<div class="dialogJ dialogJfix dialogJshadow" id="OrdDateTypeCreate" style="width: 440px;right: 80px; top: 150px;height:80px ;display:none;">
|
<div class="dialogJtitle">
|
<a href="javascript:JS_OrdDateTypeCreateClose();" class="dialogJclose" title="关闭本窗口"> </a>
|
<span class="dialogJtxt" id="EditPhotoTXT">请选择时间段</span>
|
</div>
|
<div class="dialogJcontent" style="margin-left: 5px;margin-right:5px;">
|
<div class="input" style="float:left;margin-top: 10px;margin-left: 5px;" id="two-inputs">
|
期间：
|
<input type="text" id="OrdDateStart" name="OrdDateStart" class="date" style="width:138px;" value="<?php echo $OrdDateStart?>">
|
至
|
<input type="text" id="OrdDateEnd" name="OrdDateEnd" class="date" style="width:138px;" value="<?php echo $OrdDateEnd?>">
|
|
</div>
|
<div class="input" style="float:left;margin-top: 5px;margin-left: 5px;"><input type="button" class="dialogJbtn first-child" onclick="JS_OrdDateJump2()" value="查询"></div>
|
</div>
|
</div>
|
<!--时间选择js liang------------->
|
<link rel="stylesheet" href="css/daterangepicker.css">
|
<script src="js/jquery-1.12.3.min.js"></script>
|
<script src="js/moment.min.js"></script>
|
<script src="js/jquery.daterangepicker.js"></script>
|
<script>
|
$(function()
|
{
|
$('#two-inputs').dateRangePicker(
|
{
|
separator : ' to ',
|
getValue: function()
|
{
|
if ($('#OrdDateStart').val() && $('#OrdDateEnd').val() )
|
return $('#OrdDateStart').val() + ' to ' + $('#OrdDateEnd').val();
|
else
|
return '';
|
},
|
setValue: function(s,s1,s2)
|
{
|
$('#OrdDateStart').val(s1);
|
$('#OrdDateEnd').val(s2);
|
}
|
|
});
|
});
|
</script>
|
<!--时间选择js liang------------->
|
<script type="text/javascript">
|
//时间表列显示下拉菜单
|
function JS_OrdDateType(){
|
if (Date_container.className!="select-container select-container-show-list"){
|
Date_container.className="select-container select-container-show-list";
|
Date_arrow.className="arrow arrow-up";
|
Date_list.style.display="block";
|
//OrdClass_container.className="select-container";
|
//OrdClass_arrow.className="arrow";
|
//OrdClass_list.style.display="none";
|
//OrdDateTypeCreate.style.display="none";
|
}
|
else {
|
Date_container.className="select-container";
|
Date_arrow.className="arrow";
|
Date_list.style.display="none";
|
}
|
}
|
//时间表列指针移动到下拉菜单
|
function JS_OrdDateTypeMouseover(id){
|
var d=document.getElementById(id);
|
<?php for($i=0;$i<count($OrdDateTypes);$i++) {?>
|
document.getElementById("OrdDateType_<?php echo $OrdDateTypes[$i][0]?>").className="list-option";
|
<?php }?>
|
document.getElementById("OrdDateType_0").className="list-option";
|
d.className="list-option option";
|
}
|
//自定义时间-打开窗口
|
function JS_OrdDateTypeCreateOpen()
|
{
|
JS_OrdDateType();
|
OrdDateTypeCreate.style.display="block";
|
}
|
//自定义时间-关闭窗口
|
function JS_OrdDateTypeCreateClose()
|
{
|
JS_OrdDateType();
|
OrdDateTypeCreate.style.display="none";
|
}
|
//自定义时间-确定时间
|
function JS_OrdDateTypeCreateSave()
|
{
|
document.getElementById('ServiceOrdTraStreet').value=document.getElementById('Duration').value;
|
document.getElementById('ServiceOrdTraEnd').value=document.getElementById('ServiceOrdTraEnd').value;
|
document.getElementById('ServiceOrdTraStreetCoo').value=results.sw.point.lng + ','+ results.sw.point.lat; //起点坐标
|
document.getElementById('ServiceOrdTraEndCoo').value=results.Lu.point.lng + ','+ results.Lu.point.lat; //起点坐标
|
}
|
//时间类表列转跳
|
function JS_OrdDateJump(id){
|
var OrdDateStart=document.getElementById("OrdDateStart").value;
|
var OrdDateEnd=document.getElementById("OrdDateEnd").value;
|
//var searchTXT=document.getElementById("searchTXT").value;
|
window.location.href='?<?php echo $page_URL_noDate?>&OrdDateType=0&OrdDateStart='+OrdDateStart+'&OrdDateEnd='+OrdDateEnd;
|
}
|
//自定义时间转跳
|
function JS_OrdDateTypeJump(id){
|
//var searchTXT=document.getElementById("searchTXT").value;
|
window.location.href='?<?php echo $page_URL_noDate?>&OrdDateType='+id;
|
}
|
|
//时间表列转跳
|
function JS_OrdClassTypeJump(id){
|
//var searchTXT=document.getElementById("searchTXT").value;
|
window.location.href='?<?php echo $page_URL_noDate?>&OrdClassList='+id;
|
}
|
|
</script>
|
<!-- end box / title -->
|
<?php //数据读取
|
$is_CSV=0; ?>
|
<?php require 'Report_StaffScoreUserList_Data.php';?>
|
|
<?php require '/inc/SystemMessages.php';?>
|
<div class="table" style="overflow:auto">
|
<table>
|
<?php if ($SystemMessageType!="2"){ ?>
|
<thead>
|
<tr style="white-space: nowrap;">
|
<?php
|
for($x=0;$x<$FormArrayX;$x++) {
|
if ($x==$FormArrayX-1){
|
$classHtml=" class=\"last\"";
|
}
|
elseif ($x==0){
|
$classHtml=" class=\"selected\"";
|
}else{
|
$classHtml="";
|
}
|
echo "<th$classHtml>".$FormArray[0][$x]."</th>";
|
}
|
?>
|
</tr>
|
</thead>
|
<tbody>
|
<?php
|
for($y=1;$y<count($FormArray);$y++) {
|
echo "<tr style=\"white-space: nowrap;\">";
|
for($x=0;$x<count($FormArray[$y]);$x++) {
|
if ($x==count($FormArray[$y])-1){
|
$classHtml=" class=\"category category2 last\"";
|
}
|
elseif ($x==0){
|
$classHtml=" class=\"selected\"";
|
}else{
|
$classHtml=" class=\"category category2\"";
|
}
|
echo "<td$classHtml>".$FormArray[$y][$x]."</td>";
|
}
|
}
|
?>
|
<?php }?>
|
<?php
|
$classHtml="";
|
for($j=$y;$j<=20;$j++) {
|
echo "<tr>";
|
for($x=0;$x<$FormArrayX;$x++) {
|
if ($x==$FormArrayX-1){
|
$classHtml=" class=\"last\"";
|
}else{
|
$classHtml="";
|
}
|
echo "<td$classHtml> </td>";
|
}
|
echo "</tr>";
|
}
|
?>
|
</tbody>
|
</table>
|
<!-- 分页 -->
|
<?php if ($total_records>=1) {?>
|
<div class="pagination pagination-left">
|
<div class="results">
|
<?php
|
$ShowingLeast = ($page-1)*$page_size+1;
|
$ShowingMax = $page_size*$page;
|
if ($ShowingMax>$total_records) {$ShowingMax=$total_records;}
|
?>
|
<span><?php echo "显示 $ShowingLeast-$ShowingMax of $total_records";?></span>
|
</div>
|
<?php if ($total_page>1) {?>
|
<ul class="pager">
|
<?php
|
if ($page==1) {
|
echo "<li class=\"disabled\">« 上页</li>";
|
}else{
|
echo "<li><a href=\"?page=".($page-1)."&".$page_URL."\">« 上页</a></li>";
|
}
|
|
$acc4=0;
|
for($i=1;$i<=$total_page;$i++) {
|
if ($i==$page) {echo "<li class=\"current\">$i</li>";}
|
elseif ($i<=3 or $i>($total_page-3) ) {echo "<li><a href=\"?page=$i&$page_URL\">$i</a></li>";}
|
elseif ($acc4==0){echo "<li class=\"separator\">...</li>";$acc4=$i<$page ? 1 : 2;}
|
elseif ($acc4==1 and $i>$page+3){echo "<li class=\"separator\">...</li>";$acc4=2;}
|
elseif ($acc4==1 and $i>=$page-3){echo "<li><a href=\"?page=$i&$page_URL\">$i</a></li>";}
|
}
|
|
if ($page>=$total_page) {
|
echo "<li class=\"disabled\">下页 »</li>";
|
}else{
|
echo "<li><a href=\"?page=".($page+1)."&".$page_URL."\">下页 »</a></li>";
|
}
|
?>
|
</ul>
|
<?php }?>
|
</div>
|
<?php }?>
|
<!-- end 分页 -->
|
</div>
|
</div>
|
<!-- end table -->
|
|
|
|
</div>
|
<!-- end content / right -->
|
</div>
|
<!-- end content -->
|
<?php require 'vicgame.php';?>
|
<IFRAME id="HiddenFrame" name="HiddenFrame" WIDTH=0 HEIGHT=0 MARGINWIDTH=0 MARGINHEIGHT=0 HSPACE=0 VSPACE=0 FRAMEBORDER=0 SCROLLING=no BORDERCOLOR=#ffffff></IFRAME>
|
</body>
|
</html>
|
