需求里结算首页需要按门店的首字母A-Z排序。我的数据结构原本是这样的:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
Array
(
[0] => Array
(
[sid] => 2885842
[recetcstoredpay] => 24000
[recetclprinciple] => 23465
[paytcstoredpay] => 5455
[paytclprinciple] => 34900
[sname] => 百宴餐饮---便宜坊烤鸭店
)
[1] => Array
(
[sid] => 3644191
[recetcstoredpay] => 89200
[recetclprinciple] => 406930
[paytcstoredpay] => 4090
[paytclprinciple] => 97800
[sname] => 大长秋餐饮中心
)
[2] => Array
(
[sid] => 5229673
[recetcstoredpay] => 26000
[recetclprinciple] => 45930
[paytcstoredpay] => 24795
[paytclprinciple] => 121800
[sname] => 大众点评网
)
[3] => Array
(
[sid] => 3715927
[recetcstoredpay] => 13600
[recetclprinciple] => 56930
[paytcstoredpay] => 5710
[paytclprinciple] => 37800
[sname] => 江东北路店
)
[4] => Array
(
[sid] => 3671092
[recetcstoredpay] => 1280
[recetclprinciple] => 46930
[paytcstoredpay] => 128090
[paytclprinciple] => 149800
[sname] => 金凤区新馆
)
[5] => Array
(
[sid] => 1858783
[recetcstoredpay] => 2040
[recetclprinciple] => 4465
[paytcstoredpay] => 245
[paytclprinciple] => 4900
[sname] => 浙江西子宾馆
)
[6] => Array
(
[sid] => 16832117
[recetcstoredpay] => 81600
[recetclprinciple] => 470930
[paytcstoredpay] => 506090
[paytclprinciple] => 8000
[sname] => 欢乐谷店
)
)
|
根据需求,要根据sname的第一个汉字首字母排序,那么就先需要写一个取首字母的方法:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
/**
* 取汉字的第一个字的首字母
* @param type $str
* @return string|null
*/
public function _getFirstCharter( $str ){
if (emptyempty( $str )){ return '' ;}
$fchar =ord( $str {0});
if ( $fchar >=ord( 'A' )&& $fchar <=ord( 'z' )) return strtoupper ( $str {0});
$s1 =iconv( 'UTF-8' , 'gb2312' , $str );
$s2 =iconv( 'gb2312' , 'UTF-8' , $s1 );
$s = $s2 == $str ? $s1 : $str ;
$asc =ord( $s {0})*256+ord( $s {1})-65536;
if ( $asc >=-20319&& $asc <=-20284) return 'A' ;
if ( $asc >=-20283&& $asc <=-19776) return 'B' ;
if ( $asc >=-19775&& $asc <=-19219) return 'C' ;
if ( $asc >=-19218&& $asc <=-18711) return 'D' ;
if ( $asc >=-18710&& $asc <=-18527) return 'E' ;
if ( $asc >=-18526&& $asc <=-18240) return 'F' ;
if ( $asc >=-18239&& $asc <=-17923) return 'G' ;
if ( $asc >=-17922&& $asc <=-17418) return 'H' ;
if ( $asc >=-17417&& $asc <=-16475) return 'J' ;
if ( $asc >=-16474&& $asc <=-16213) return 'K' ;
if ( $asc >=-16212&& $asc <=-15641) return 'L' ;
if ( $asc >=-15640&& $asc <=-15166) return 'M' ;
if ( $asc >=-15165&& $asc <=-14923) return 'N' ;
if ( $asc >=-14922&& $asc <=-14915) return 'O' ;
if ( $asc >=-14914&& $asc <=-14631) return 'P' ;
if ( $asc >=-14630&& $asc <=-14150) return 'Q' ;
if ( $asc >=-14149&& $asc <=-14091) return 'R' ;
if ( $asc >=-14090&& $asc <=-13319) return 'S' ;
if ( $asc >=-13318&& $asc <=-12839) return 'T' ;
if ( $asc >=-12838&& $asc <=-12557) return 'W' ;
if ( $asc >=-12556&& $asc <=-11848) return 'X' ;
if ( $asc >=-11847&& $asc <=-11056) return 'Y' ;
if ( $asc >=-11055&& $asc <=-10247) return 'Z' ;
return null;
}
|
然后下一步,要对这个二维数据排序。我思考了很久,后来想到了方案,先在循环里调用这个取首字母的方法,然后以这个字母作为key,因为php里有根据key排序的方法,所以我的代码写成这样就搞定了:
1 2 3 4 5 6 7 8 9 10 11 12 |
//门店名称
$shopData = $this ->_shopNamesArray;
//根据门店名称第一个汉字的首字母正序排序
$settles = $result [ 'data' ];
$settlesRes = array ();
foreach ( $settles as $sett ) {
$sname = $shopData [ $sett [ 'sid' ]];
$sett [ 'sname' ] = $sname ;
$snameFirstChar = $this ->_getFirstCharter( $sname ); //取出门店的第一个汉字的首字母
$settlesRes [ $snameFirstChar ] = $sett ; //以这个首字母作为key
}
ksort( $settlesRes ); //对数据进行ksort排序,以key的值升序排序
|
print出来看效果:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
Array
(
[B] => Array
(
[sid] => 2885842
[recetcstoredpay] => 24000
[recetclprinciple] => 23465
[paytcstoredpay] => 5455
[paytclprinciple] => 34900
[sname] => 百宴餐饮---便宜坊烤鸭店
)
[D] => Array
(
[sid] => 5229673
[recetcstoredpay] => 26000
[recetclprinciple] => 45930
[paytcstoredpay] => 24795
[paytclprinciple] => 121800
[sname] => 大众点评网
)
[H] => Array
(
[sid] => 16832117
[recetcstoredpay] => 81600
[recetclprinciple] => 470930
[paytcstoredpay] => 506090
[paytclprinciple] => 8000
[sname] => 欢乐谷店
)
[J] => Array
(
[sid] => 3671092
[recetcstoredpay] => 1280
[recetclprinciple] => 46930
[paytcstoredpay] => 128090
[paytclprinciple] => 149800
[sname] => 金凤区新馆
)
[Z] => Array
(
[sid] => 1858783
[recetcstoredpay] => 2040
[recetclprinciple] => 4465
[paytcstoredpay] => 245
[paytclprinciple] => 4900
[sname] => 浙江西子宾馆
)
)
|