<?php require '/inc/odbc.php';?>
|
<!DOCTYPE html>
|
<html>
|
<meta charset="UTF-8">
|
<title>常用MSSQL语法-PHP 字典</title>
|
<body>
|
|
|
<?php
|
/**
|
* 数字转字母 （类似于Excel列标）
|
* @param Int $index 索引值
|
* @param Int $start 字母起始值
|
* @return String 返回字母
|
*/
|
function IntToChr($index, $start = 65) {
|
$str = '';
|
if (floor($index / 26) > 0) {
|
$str .= IntToChr(floor($index / 26)-1);
|
}
|
return $str . chr($index % 26 + $start);
|
}
|
|
/**
|
* 测试
|
*/
|
|
echo IntToChr(0)."<br>"; //# A
|
echo IntToChr(1)."<br>"; //# B
|
// ...
|
echo IntToChr(27)."<br>"; //# 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']."<br />";
|
}
|
}
|
?>
|
|
|
</body>
|
</html>
|
