예제 #1
0
 public function get_list($params, $get_pic = false)
 {
     // 验证请求参数
     $fields = ['zone_id'];
     foreach ($fields as $field) {
         if (!isset($params[$field])) {
             return [-1, "缺少参数 {$field}"];
         } elseif (!ctype_digit($params[$field])) {
             return [-2, "参数 {$field} 类型错误"];
         }
     }
     $zone_id = $params['zone_id'];
     $page = $params['page'] ?? 1;
     $per_page = $params['per_page'] ?? 20;
     if ($page < 1) {
         return [-3, '请输入有效的 page 参数'];
     }
     if ($per_page > 100 || $per_page <= 0) {
         return [-4, 'per_page 参数值必须在 1~100 之间'];
     }
     if ($zone_id < 900000) {
         $prov_id = substr($zone_id, 0, 4);
         // 县的情况
         if (strlen($zone_id) == 6 && substr($zone_id, -2) != '00') {
             switch ($zone_id) {
                 case 90:
                     $where = " WHERE flag > 9 AND EN <> ''";
                     break;
                 default:
                     $where = " WHERE zone_id = '{$zone_id}' AND flag > 9 AND EN <> ''";
                     break;
             }
         } else {
             switch ($zone_id) {
                 case 90:
                     $where = " WHERE flag > 9 AND EN <> ''";
                     break;
                 case 5001:
                     //重庆的子城市有5002的情况,如500232 武隆,这里特殊处理下
                     $where = " WHERE zone_id LIKE '500%' AND flag > 9 AND EN <> ''";
                     break;
                 default:
                     $where = " WHERE zone_id LIKE '{$prov_id}%' AND flag > 9 AND EN <> ''";
                     break;
             }
         }
     } else {
         $where = " WHERE zone_id = '{$zone_id}' AND flag > 9";
     }
     if (isset($params['search_key']) && trim($params['search_key'])) {
         $title_h = trim($params['search_key']);
         $title_h = Enc::u2g($title_h);
         $where .= " AND title LIKE '%" . $title_h . "%' ";
     }
     $total_num = (int) $this->db->get_value("SELECT COUNT(*) \n            FROM " . self::$table . " {$where} ");
     $total_page = ceil($total_num / $per_page);
     $page = max(min($page, $total_page), 1);
     $start = ($page - 1) * $per_page;
     $jd_list = [];
     if ($total_num > 0) {
         $pic_field = $get_pic ? ', smallpic' : '';
         $result = $this->db->query("SELECT id, area_en, EN, CN, title, zone_id {$pic_field} \n                FROM " . self::$table . " {$where} \n                ORDER BY orderid LIMIT {$start}, {$per_page}");
         while ($arr = $this->db->fetch_array($result)) {
             if ($arr['zone_id'] > 900000 && $arr['title']) {
                 $arr['CN'] = $arr['title'];
             }
             if ($arr['CN']) {
                 if ($get_pic) {
                     $arr['smallpic'] = $this->photo_basepath() . '/' . $arr['smallpic'];
                 }
                 $jd_list[] = $arr;
             }
         }
     }
     $data = ['total_num' => $total_num, 'total_page' => $total_page, 'items' => $jd_list];
     return [0, $data];
 }
예제 #2
0
 /**
  * 获取 OAuth 的 HTTP 响应
  *
  * @param  array $result 成功响应
  * @return Response
  */
 public function authorize_output(array $result) : Response
 {
     $result = Enc::convert($result, 'GBK', 'UTF-8');
     if (isset($result['error'])) {
         $http_status = 400;
         $res = $this;
     } else {
         $http_status = 200;
         $res = $this->withHeader('Cache-Control', 'no-store')->withHeader('Pragma', 'no-cache');
     }
     return $res->withJson($result, $http_status, $this->json_options());
 }