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']."
";
}
}
?>