0) { $str .= IntToChr(floor($index / 26)-1); } return $str . chr($index % 26 + $start); } /** * 测试 */ echo IntToChr(0)."
"; //# A echo IntToChr(1)."
"; //# B // ... echo IntToChr(27)."
"; //# AB //if (isDepartment($admin_Power,"01")==0) {header("Location: /login.gds");exit;} //初始化翻页链接参数 $page=empty($_REQUEST['page'])!=false ? 1 : $_REQUEST['page']; //分页尺寸 $page_size=40; //sql语句 $sql = "select OA_User_ID,OA_Name,DispatchOrdIDDt,aa=count(DispatchOrdIDDt),row_number() over (order by DispatchOrdIDDt,OA_User_ID) n from OA_User,DispatchOrd_Entourage where EntourageOAid=OA_User_ID GROUP BY OA_User_ID,OA_Name,DispatchOrdIDDt"; //计算总页数 $data = sqlsrv_query( $conn, $sql, array(), array( "Scrollable" => 'keyset' )); $total_records=sqlsrv_num_rows($data); //总行数 $total_page=ceil($total_records/$page_size); //总页数 //避免page小于0或大于总页数 $page=$page<=0?1:$page; $page=$page>$total_page?$total_page:$page; //计算开始和结束行数 $pageStart = ($page-1)*$page_size; $pageEnd = $pageStart+$page_size; //输出数据 $sqls = "select * from ($sql) sqlData where sqlData.n > $pageStart and sqlData.n <= $pageEnd" ; $data = sqlsrv_query($conn,$sqls); if($data == true){ while($row = sqlsrv_fetch_array( $data, SQLSRV_FETCH_ASSOC) ) { echo $row['OA_User_ID'].", ".$row['OA_Name'].", ".$row['DispatchOrdIDDt']."
"; } } ?>