//城市列表 public function get_city() { $data = Yii::$app->db->createCommand("SELECT DISTINCT (city) FROM 表名 ") ->queryAll(); // 将每个城市加上首字母 foreach ($data as $k => $v) { $data[$k]['wordName'] = $this->get_First($v['city']); } //根据首字母进行分类 foreach ($data as $k => $v) { if ($v['wordName'] == 'A') { $new_arrar['A']['w'] = 'A'; $new_arrar['A']['c'][] = $v; } if ($v['wordName'] == 'B') { $new_arrar['B']['w'] = 'B'; $new_arrar['B']['c'][] = $v; } if ($v['wordName'] == 'C') { $new_arrar['C']['w'] = 'C'; $new_arrar['C']['c'][]= $v; } if ($v['wordName'] == 'D') { $new_arrar['D']['w'] = 'D'; $new_arrar['D']['c'][] = $v; } if ($v['wordName'] == 'E') { $new_arrar['E']['w'] = 'E'; $new_arrar['E']['c'][] = $v; } if ($v['wordName'] == 'F') { $new_arrar['F']['w'] = 'F'; $new_arrar['F']['c'][] = $v; } if ($v['wordName'] == 'G') { $new_arrar['G']['w'] = 'G'; $new_arrar['G']['c'][] = $v; } if ($v['wordName'] == 'H') { $new_arrar['H']['w'] = 'H'; $new_arrar['H']['c'][] = $v; } if ($v['wordName'] == 'J') { $new_arrar['J']['w'] = 'J'; $new_arrar['J']['c'][] = $v; } if ($v['wordName'] == 'K') { $new_arrar['K']['w'] = 'K'; $new_arrar['K']['c'][] = $v; } if ($v['wordName'] == 'L') { $new_arrar['L']['w'] = 'L'; $new_arrar['L']['c'][] = $v; } if ($v['wordName'] == 'M') { $new_arrar['M']['w'] = 'M'; $new_arrar['M']['c'][] = $v; } if ($v['wordName'] == 'N') { $new_arrar['N']['w'] = 'N'; $new_arrar['N']['c'][] = $v; } if ($v['wordName'] == 'O') { $new_arrar['O']['w'] = 'O'; $new_arrar['O']['c'][] = $v; } if ($v['wordName'] == 'P') { $new_arrar['P']['w'] = 'P'; $new_arrar['P']['c'][] = $v; } if ($v['wordName'] == 'Q') { $new_arrar['Q']['w'] = 'Q'; $new_arrar['Q']['c'][] = $v; } if ($v['wordName'] == 'R') { $new_arrar['R']['w'] = 'R'; $new_arrar['R']['c'][] = $v; } if ($v['wordName'] == 'S') { $new_arrar['S']['w'] = 'S'; $new_arrar['S']['c'][] = $v; } if ($v['wordName'] == 'T') { $new_arrar['T']['w'] = 'T'; $new_arrar['T']['c'][] = $v; } if ($v['wordName'] == 'W') { $new_arrar['W']['w'] = 'W'; $new_arrar['W']['c'][] = $v; } if ($v['wordName'] == 'X') { $new_arrar['X']['w'] = 'X'; $new_arrar['X']['c'][] = $v; } if ($v['wordName'] == 'Y') { $new_arrar['Y']['w'] = 'Y'; $new_arrar['Y']['c'][] = $v; } if ($v['wordName'] == 'Z') { $new_arrar['Z']['w'] = 'Z'; $new_arrar['Z']['c'][] = $v; } } ksort($new_arrar); //对数据进行ksort排序,以key的值升序排序 //将key去除 foreach ($new_arrar as $k=>$v){ $del_key[]=$new_arrar[$k]; } $httpres = array(); $httpres['status'] = 1; $httpres['cityList']= $del_key; return $httpres; } //获取首字母 public function get_First($str) { if (empty($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; }
获取数据库中城市,并排序
最新推荐文章于 2021-12-23 14:04:04 发布