<?php
|
//分页信息
|
$page=empty($_REQUEST['page'])!=false ? 1 : $_REQUEST['page'];
|
$QuantityInt = 20; //每页显示数量
|
$acc1=$page; //当前页数
|
$acc2=0; //总页数
|
$acc3=0; //总记录数
|
|
//查询条件
|
$searchSql="";
|
$searchTXT=empty($searchTXT)!=false ? "" : $searchTXT;
|
if ($searchTXT!=""){
|
$searchSql=" and (OA_Name like '%$searchTXT%') ";
|
}else{
|
$searchSql="";
|
}
|
|
$orderby=empty($orderby)!=false ? "" : $orderby;
|
If (strrpos($orderby," desc")>1){
|
$orderbydesc="";
|
$descTXT="↓";
|
}else{
|
$orderbydesc=" desc";
|
$descTXT="↑";
|
}
|
|
If ($orderby=="") {
|
$orderby="OA_DepartmentID,OA_User_ID";
|
$descTXT="↓";
|
}
|
|
if ($OrdDateType=="0" and $OrdDateStart=="" and $OrdDateEnd=="") {$OrdDateType=4;}
|
|
//查询开始
|
$SqlOrdDateType=empty($SqlOrdDateType)!=false ? "" : $SqlOrdDateType;
|
$OAOccupationSQL=empty($OAOccupation)!=false ? "" : " and EntourageID in (".$OAOccupation.") ";
|
$sql="select OA_User_ID,OA_Name,OA_IP,OA_Time=CONVERT(nvarchar(20),OA_Time, 20),Running,Running_address,Running_URL from OA_Running,OA_User where OA_User_ID=OAid and OA_Power like '%0702%' and OA_Time ".$SqlOrdDateType." and Running like '手机端%' and OAid not in (8) order by id desc";
|
//echo $sql;
|
//exit;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
$FormArray=array();
|
//表头
|
$FormArray[0]=array("序号","姓名","IP","查看时间","查看内容","用户定位");
|
$FormArrayX=count($FormArray[0]);
|
if (sqlsrv_rows_affected($data)==0) {
|
$SystemMessageType=2;
|
$SystemMessageTXT="数据库中相关无数据！";
|
$y=0;
|
} else {
|
$i=1;
|
$OA_User_ID_Old=0;
|
$OA_IP_Old="";
|
$Running_address_Old=0;
|
$OA_Time_Old=strtotime ("2000-1-1 00:00:00");
|
$OA_TimeDD=1;
|
while($rs = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) {
|
//读取数据
|
$OA_User_ID = $rs['OA_User_ID'];
|
$OA_Name = $rs['OA_Name'];
|
$OA_IP = $rs['OA_IP'];
|
$OA_Time = $rs['OA_Time'];
|
$Running = $rs['Running'];
|
$Running_address = $rs['Running_address'];
|
$Running_URL = $rs['Running_URL'];
|
$OA_Time_Old1 = strtotime ($OA_Time);
|
$guonian=ceil(($OA_Time_Old1-$OA_Time_Old)/3600);
|
|
|
|
if (ceil(($OA_Time_Old1-$OA_Time_Old)/3600)!=0) {
|
$OA_TimeDD=1;
|
$OA_Time_Old=$OA_Time_Old1;
|
}
|
if ($Running_address_Old==0 and $Running_address!='') {$Running_address_Old=2;}
|
//写入数组
|
if ($OA_User_ID!=$OA_User_ID_Old or $OA_IP!=$OA_IP_Old or $OA_TimeDD==1 or $Running_address_Old==2) {
|
$FormArray[$i][0]=$i;
|
$FormArray[$i][1]=$OA_Name;
|
$FormArray[$i][2]=$OA_IP;
|
$FormArray[$i][3]=$OA_Time;
|
$FormArray[$i][4]=$Running;
|
$FormArray[$i][5]=$Running_address;
|
$OA_TimeDD=0;
|
$Running_address_Old=1;
|
|
$i++;
|
}
|
if ($OA_User_ID!=$OA_User_ID_Old or $OA_IP!=$OA_IP_Old) {
|
$OA_User_ID_Old=$OA_User_ID;
|
$OA_IP_Old=$OA_IP;
|
}
|
if ($Running_address=='') {
|
$Running_address_Old=0;
|
}
|
|
//写入数组--End
|
|
//读取数据--End
|
}
|
|
|
|
}
|
}
|
|
if ($is_CSV==2) {
|
echo json_encode($FormArray);
|
}
|
//echo print_r($FormArray);
|
//echo json_encode($FormArray);
|
//exit;
|
?>
|
